Monthly Archives: June 2014

Phil 6.17.14

8:00 – 1:00

  • DB Backups
  • Pie charts
    • Creating a WebGLPieWedgeComponent so that it can hang on to the current and desired angles and calculate transitions as needed.
    • Refactored wedge calculation to reside in WebGLPieWedgeComponent.
    • Hanging onto start and end angles as well as vertices.

Dong Shin 06.17.2014

  • installed MariaDB, works with the current MySQL data! little performance improvements… . 3.04 vs 2.72
    • mysqld –datadir=<directory to data>
  • experimenting with Triggers/Store Procedures to generate summary data
    • drop and create tables not allowed
    • delete and insert takes 5 sec on RA/RA data entry

Dong Shin 06.13.2014

  • checked out projects from new SVN repo
    • builds, but cannot check in…. permission issues
    • org.apache.subversion.javahl.ClientException: Permission denied
      svn: Commit failed (details follow):
      svn: Can’t move ‘/home/vectr/svn/307519/db/txn-protorevs/3263-2iv.rev’ to ‘/home/vectr/svn/307519/db/revs/3/3264’: Permission denied

Phil 6.13.14

8:00 – 5:00 SR

  • DB backups
  • Lenny is now security guy for our servers! And is getting the paperwork done that I was forbidden to do. And our authorization is now through September 9
  • Pie Charts!
    • Chart description (XML or JSON?). XML. And after a lot of flailing, I’m producing an xml description and reading it in. JS is very clunky WRT traversing XML. Basically every time I think it’s going to be something easy, JS makes it into an all day affair.
    • Tooltips
    • Calculations
    • resizing
    • Legend (in 2D overlay. Match the color to the Math.max(ambientColor, emissiveColor) of the wedge.
    • Labels (plus percent/value) with indicator lines leading to the outer top of the wedge. This means that labels will need to have a 3D offset option.
    • Upload?

Dong Shin 06.12.2014

  • working on Query Builder
    • converted old queries to new format
    • reworked __view_total_committed_amount_by_budget_center
      • CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_total_committed_amount_by_budget_center` AS select `committed_amounts`.`budget_center_id` AS `budget_center_id`,sum(`committed_amounts`.`committed_amount`) AS `total_committed_amount`,MAX(`committed_amounts`.`committed_date`) AS `max_committed_date`, group_concat(`committed_amounts`.`committed_date` separator ‘,’) AS `committed_dates` from `committed_amounts` group by `committed_amounts`.`budget_center_id`;
    • reworked __view_project_detailed_data to include obligation date and committed date
    • going through the user queries….
  • svn migration complete – trying to check out…

Phil 6.12.14

8:00 – 12:00, 2:00 – 5:00 SR

  • DB backups
  • The svn backups failed yesterday when my computer decided to reset the connection to the server. Trying again.
  • Add compute vertex normals to the pie chart – see if we can get rid of the flat shading artifacts.
  • Make a pieChartCanvas – done. Now moving the wedge creation parts into the canvas.
  • Read in XML configuration files for pie chart and network chart.

Progress for today:

pieChartTest

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.