Phil 6.4.14

8:00 – 5:00 SR

  • DB Backups
  • Working on fixing subproject privileges.
  • Got a single frame freeze/unfreeze mode working in charts. Now I need to calculate a better initial state. Done.
  • Starting to look at extruding chart components. Got some working, looking at different examples. Will try this next: http://threejs.org/examples/webgl_geometry_shapes.html
  • And on a side note, it looks like the GPU can be used for simulaiton: http://threejs.org/examples/#webgl_gpgpu_birds

Dong Shin 06.03.2014

  • working on Query Builder (6 hours)
    • cleaned up database views – _view_project_detailed_data
  • working on scripts to add parent project users to children… (2 hours)
    • INSERT INTO _projects_portfolio_mgrs
      (SELECT sub_project_id, login FROM _projects_portfolio_mgrs ppa
      LEFT JOIN _project_sub_projects psp
      ON psp.project_id = ppa.project_id WHERE (sub_project_id, login) NOT IN (SELECT * FROM (_projects_portfolio_mgrs)))
    • INSERT INTO _projects_portfolio_admins
      (SELECT sub_project_id, login FROM _projects_portfolio_admins ppa
      LEFT JOIN _project_sub_projects psp
      ON psp.project_id = ppa.project_id WHERE (sub_project_id, login) NOT IN (SELECT * FROM (_projects_portfolio_admins)))

Phil 5.30.14

8:00 – 5:00 SR

  • DB backups
  • Got outlook fixed
  • Server paperwork, with great success!
  • JavaScript
    • So JS doesn’t have static variables. I thought I’d be clever and use functions:
      • function _X(){return 0;);
    • Which works, but the performance hit was *terrible*. So don’t do this if you need speed.
    • More building of network chart.

Dong Shin 05.30.2014

  • working on other stuff (6 hours)
    • trouble shooting incorrect outlay calculation in cognos summary data
      • cannot duplicate outlay problem for Req 198874, need to clear budget_center_contracts entry and run post processing on-site.
    • created project_portfolio_enh_clean for testing
    • trouble shooting obligations stored in a month behind for 206756…. cannot duplicate.. need to look at __view_monthly_obligations_by_contract and __view_monthly_obligations_by_req_id on-site
  • added hierarchical filtering to DGSearchTextInput (2 hours)

Dong Shin 05.29.2014

  • on-site support (2 hours)
    • deployed FA/Reqonciler – fixed percentages and pre-processing
    • found some obligations are put in a month behind?
    • double counting outlays with ACR field
    • show previous month PM Actuals in Query Builder
  • working on other (5 hours)
    • added PM Actuals % to Query Builder
    • PM Actuals show previous month (month label added)

Phil 5.29.14

8:00 – 6:00 SR

  • DB Backups
  • Deploy
  • JavaScript
    • Add dClock clamp so physics doesn’t go crazy (0.5?).
    • Change emmisive properties and add point light source for selected items. Done
    • Worked on tootips a bunch
    • Added brushing
    • Need to add global lights back in as an option

Dong Shin 05.28.2014

  • working on *other* stuff
    • added ignore previously reviewed… filtering out previously viewed data
    • fixed incorrect percent values for obligated/oulays in Query Builder
    • added queries to remove duplicate obligations and outlays in pre-processing according to the rules.
    • adding PM Actuals Percentages….

Dong Shin 05.27.2014

  • deployed FA/RA with new filterable combo boxes (2 hours)
    • works well, but needs tweaking on Hierarchical data in Project Mgmt
  • working on Reqonciler Pre-Processing (6 hours)
    • removing duplicate rows query sample
      • DELETE n1 FROM test n1, test n2 WHERE n1.uid > n2.uid AND n1.name = n2.name
        AND n1.name2 = n2.name2