Category Archives: Projects

Dong Shin 06.11.2014

  • working on Query Builder
    • adding Lenny’s queries to database
      • Overdue Acceptances
      • Overdue Obligations
      • Under performing obligations
      • FY14 Financial Status
      • FY14 Outlay Plan
      • FY13 Financial Status
      • FY14 current month Planned vs. PM Actuals
      • FY13 TST Financial Status
      • FY14 TST Financial STatus
      • FY14 ISR-PMO Financial Status
      • FY14 Financial Status (duplicate?)

Phil 6.11.14

8:00 – 5:00 SR

  • Backups
  • Found some issues in the slides where PM Actuals are greater than Obligations. Lenny’s looking into what might be the issue. Possibly dates.
  • Meeting with Tim?
  • Charts!
    • Fixed the non-square bug. I was stepping values by the wrong side.
    • Now, that’s a nifty looking pie chart if I say so myself:

pieChartTest

Phil 6.10.14

8:00 – 4:00

  • Backups
  • Submitted Lenny as our sever security guy.
  • Charts!
    • Worked on calculating the pie chart geometry. Close, but the math only works for squares. Somewhere is a bug that has the radius and angle sides confused. Tomorrow…
  • ToDo:
    • Create a pie chart canvas
    • Better reflection map.
    • Look into tessellation as a way to create a curved surface, otherwise a grid who’s y-axis conforms to a hemisphere should be fine.
    • Better background
    • Add lighting for selected wedge
    • Start on XML description of chart data
    • Animated transitions for value changes. Remember that the arc perimeter will have to travel on polar coordinates

Phil 6.9.14

8:00 – 3:00 SR

  • DB backups
  • Updated the queries used for briefing slides
  • Charts!
    • Working on UV mapping for the extruded shapes. Actually, it turns out that for reflection maps, I just need surface normals. Which is great, since that makes complex or irregular shapes much more straightforward.
    • A simple pie chart.

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.