Phil 7.30.14

8:00 – 5:00 SR

  • DB backups
  • New FA. There does seem to be a problem with the calculation for cell colors
  • Continuing with writing to the DB from the JS client
  • Chased down a bunch of bugs having to do with the way that fields were being loaded, particularly on the Funding Panel, where items are represented by sourceDivs
  • Set up the table structure so that guids are produced for each row on the client then used to match between the master table and the String/data/number tables.
  • Added the code to the servlet that inserts data, but haven’t connected it to the DB yet. Tomorrow.

Phil 7.29.14

8:00 – 5:00 SR

  • DB Backups
  • Wound up having to write a class that allows for the traversal of a JSON object, which I was not expecting and added a day to the effort. It’s based on the code up at Finished with the basics, and can recursively navigate and return key/value pairs or an array of Objects that match a given key. Tomorrow we’ll need to add capability (either to the JsonNav class or to the servlet that will write rows into the db.

Dong Shin 07.29.2014

  • moved all calculated values/columns from __view_project_detailed_data to QueryConfig
  • added groupByColumns to QueryConfig to support Req’s by Project queries..
  • working on FMP

Dong Shin 07.28.2014

  • deployed new FA with Req’s by Project queries
    • found that Query Builder adds where and group by clause – fixed
    • not saving queries – fixed
    • percent values should be calculated using Total Budgets, not Committed Amounts ¬†– fixed
  • working on summarizing obligations, outlays, pm actuals for Req’s by Project queries

Phil 7.28.14

8:00 – 2:30 SR

  • DB Backups
  • Deploy new queries.
  • Remote object problems. Bounced the VM, which seemed to fix
  • Added a query to see who’d logged in today, so we can warn people before stopping the server.

Dong Shin 07.25.2014

  • working on Query Builder
    • disable obligated, outlays, pm actuals when query is using GROUP BY
    • adding queries by Req by Project
      • FY 13 Financial Status – done
      • FY14 Financial Status – done
      • FY14 Outlay Plan – done
      • FY14 Current Month Planned vs. PM Actuals – done, need to discuss what columns to show and how the calculations are done
  • working on new FMP editor
    • reworked the layout of the questions and¬†added projectedDate field – sets label based on meeting Obligation/Outlay goals
    • added validators (question 1, 2, 3, projected date)
    • separated FinancialMitigationPlanContent from FinancialMitigationPlanWindow

Phil 7.25.14

8:00 – 5:00 SR

  • DB Backups
  • Added a event handler to get the comments.
  • Add clear() method. Nope, just used location.reload(true) to force a reload of the page from the server. Better!
  • Drat. I need it anyway, to prep for loading JSON. Done.
  • Save and Load should use the name in the FR name field. If the name is not in the list when save is pressed, it’s added to the list.
  • Work on save first, then load.
  • How to do a compound insert from Dong:
    • LAST_INSERT_ID() gives you the key/index of the last record inserted…..

      1. insert the first record

      INSERT INTO data_table (uid, data) VALUES (null, ‘data’)
      2. insert into master record
      INSERT INTO master_table (uid, some_data, key_to_data_table) VALUES (null, ‘some_data’, LAST_INSERT_ID());

Dong Shin 07.24.2014

  • deployed new Query Builder – all went well.
  • fixed FY 15 Outlay Plan query
  • working on queries for project level data – GROUP BY project?
    • adding Req Select window
  • fixed obligated, outlay, pm actuals columns not sorting

Phil 7.24.14

8:00 – 5:00 SR

  • DB Backups
  • Deployed new FA and DB updates
  • Working on Client Server communication
  • Got login working
  • Need to handle logout. Add clear() method to RecordsetPanel module?
  • Eclipse is saving to the old repo need to fix that tomorrow.

Dong Shin 07.23.2014

  • reworked __view_project_detailed_data to include all the calculations (goals, totals) – still quick enough?
  • changed column config for the new Query Builder
  • added Show Goals CheckBox to hide/show obligation and outlay goals

Get every new post delivered to your Inbox.