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

Phil 5.27.14

8:00 – 5:00

  • DB Backups
  • Deploying new RQ and FA
  • Working on the hours spreadsheet
  • JavaScript
    • Adding connecting lines that track target objects.
    • Added in forces. Everything appears to be working and the math is fast. Need to add anchor math. Nicely, if all the objects are in the same (z, in this case) plane, they form a saddle point that keeps everything in the plane.
    • Need to add anchor math tomorrow.