Category Archives: Projects

Phil 11.22.11

8:00 – 3:30 VISIBILITY

  • Backed up the current database – slight change
  • Making font sizes look at the screen resolution, rather than just being in pixels, since the retina display makes 20 pixels look like bacteria.
  • I think I’m actually done with GesturePieChart!
  • Nice color editor: http://mudcu.be/sphere/
  • Looking at the GWT book.
    • In addition to event handling, GWT has a Message Bus which allows for more decoupled data transfer.
    • UIBinder XML = MXML?
    • Java object serialization. How is typing handled?
    • Updating my Eclipse Google plugin

Dong Shin 11.22.2011

  • pulling my hair over SQL queries……….
  • get status of selected project by year and appropriation year
    • SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count,
      IF (
      (((SUM(IF(ISNULL(month_1), 1, 0)) = 6 OR SUM(IF(ISNULL(month_2), 1, 0)) = 6)
      AND o.year+year_count=2013) OR
      ((SUM(IF(ISNULL(month_1), 1, 0)) = 6 OR SUM(IF(ISNULL(month_2), 1, 0)) = 6 OR
      SUM(IF(ISNULL(month_3), 1, 0)) = 6 OR SUM(IF(ISNULL(month_4), 1, 0)) = 6 OR
      SUM(IF(ISNULL(month_5), 1, 0)) = 6 OR SUM(IF(ISNULL(month_6), 1, 0)) = 6 OR
      SUM(IF(ISNULL(month_7), 1, 0)) = 6 OR SUM(IF(ISNULL(month_8), 1, 0)) = 6 OR
      SUM(IF(ISNULL(month_9), 1, 0)) = 6 OR SUM(IF(ISNULL(month_10), 1, 0)) = 6 OR
      SUM(IF(ISNULL(month_11), 1, 0)) = 6 OR SUM(IF(ISNULL(month_12), 1, 0)) = 6)
      AND o.year+year_count<2013))
      ,’OVERDUE’,
      IF (
      (((SUM(IF(ISNULL(month_2), 1, 0)) > 0 OR
      SUM(IF(ISNULL(month_2), 1, 0)) > 0) AND o.year+year_count=2013) OR
      ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 OR SUM(IF(ISNULL(month_2), 1, 0)) > 0 OR
      SUM(IF(ISNULL(month_3), 1, 0)) > 0 OR SUM(IF(ISNULL(month_4), 1, 0)) > 0 OR
      SUM(IF(ISNULL(month_5), 1, 0)) > 0 OR SUM(IF(ISNULL(month_6), 1, 0)) > 0 OR
      SUM(IF(ISNULL(month_7), 1, 0)) > 0 OR SUM(IF(ISNULL(month_8), 1, 0)) > 0 OR
      SUM(IF(ISNULL(month_9), 1, 0)) > 0 OR SUM(IF(ISNULL(month_10), 1, 0)) > 0 OR
      SUM(IF(ISNULL(month_11), 1, 0)) > 0 OR SUM(IF(ISNULL(month_12), 1, 0)) > 0)
      AND o.year+year_count<2013))
      , ‘INCOMPLETE’, ‘CURRENT’))
      as status
      FROM budget_centers c, obligations_outlays o, budget_amounts a
      WHERE o.project_id = 171
      AND c.uid = o.funding_id
      AND a.budget_center_id = c.uid AND a.year = year_count
      GROUP BY o.year, year_count
  • get status of project  for year 2012 and month 2
    • SELECT p.*,
      IF(p.uid IN
      (SELECT project_id FROM
      (SELECT project_id, year, year_count,
      count(funding_id) as data_count
      FROM obligations_outlays WHERE
      ((ISNULL(month_1) OR ISNULL(month_2))
      AND (year+year_count) = 2013)
      OR
      ((ISNULL(month_1) OR ISNULL(month_2) OR
      ISNULL(month_3) OR ISNULL(month_4) OR
      ISNULL(month_5) OR ISNULL(month_6) OR
      ISNULL(month_7) OR ISNULL(month_8) OR
      ISNULL(month_9) OR ISNULL(month_10) OR
      ISNULL(month_11) OR ISNULL(month_12))

      AND (year+year_count) < 2013)
      GROUP BY funding_id, year, year_count
      ) AS FOO
      WHERE data_count = 6), ‘OVERDUE’,
      IF(p.uid IN
      (SELECT project_id FROM
      (SELECT project_id, year, year_count,
      count(funding_id) as data_count
      FROM obligations_outlays WHERE
      ((ISNULL(month_1) OR ISNULL(month_2))
      AND (year+year_count) = 2013)
      OR
      ((ISNULL(month_1) OR ISNULL(month_2) OR
      ISNULL(month_3) OR ISNULL(month_4) OR
      ISNULL(month_5) OR ISNULL(month_6) OR
      ISNULL(month_7) OR ISNULL(month_8) OR
      ISNULL(month_9) OR ISNULL(month_10) OR
      ISNULL(month_11) OR ISNULL(month_12))

      AND (year+year_count) < 2013)
      GROUP BY funding_id, year, year_count
      ) AS FOO
      WHERE data_count < 6), ‘INCOMPLETE’, ‘CURRENT’)
      ) as status
      FROM projects p

Tom DeVito 11.21.2011

Start: 9:45

  • Added more commands to the command handler.  Now all fingers should be able to change notes on command.
  • The interface now will display the first value but won’t update.  The com led is not lighting up on the arduino, so it might be crashing.
  • Trying to track down a bug that is causing the Arduino sketch to crash.
  • Found a way to use Visual Studio with the arduino:  http://www.arduino.cc/playground/Code/VisualStudio

End 5:45

Dong Shin 11.21.2011

  • performance review
  • working down the list of PPM enhancement
    • added auto entry to fill the financial data up to specified month
    • added capability to automatically add data to the end of the appropriation when value reaches 100%
    • added button to start Financial Data Entry from Project Editor
    • Project Assistant (PA) show FACTS and Reported Outlay to only Admins
    • added title to PA and PPM
    • PM Actuals gets copied to Reported Outlay on data entry (when value is null)
    • added Cumulative/Monthly DropDownList to PA (Only for Monthly). When Monthly is specified, add from Previous Month data. If previous month is null, the DropDownList is disabled and defaults to Cumulative
    • Editing disabled on Year View in PA for non-admins
    • changed ItemRenderer for Identifier in PA to show unique fields
    • started on Financial Data navigation on PA

Phil 11.21.11

7:30 – 4:00 VISIBILITY

  • Review
  • Interview
  • Worked on a glitch in the GesturePieChart that allows the chart to jump if the system gets confused between a zoom and move state. I think it’s fixed, but I ran up against the difference between the number of pixels in a 3GS and a 4S. Had to make the allowable delta a fraction of the width and height.
  • Kibitzed with Dong on the PPM and PA code.
  • Chris is leaving! Darn.

Tom DeVito 11.18.2011

Start: 9:45

  • Found the problem with the command data structure nto passing right.  I forgot that if you use a char before an int you have to pad the data with another char.
  • Communication is now work in the new set up.
  • Having trouble getting the console to write the values.
  • Found the pointers that hold the values.  Added data dictionary entries for them.
  • Values are still not setting right.

End: 5:45

Phil 11.18.11

7:30 – VISIBILITY

  • Still unable to contact Rich G. about testing
  • Meeting with Chris B. about PPM and PA. All notes are about PA unless PPM is explicitly noted
    • Add auto-fill capability
      • Value (selectable) fill up to a certain month. The default is zero. This might makes sense to do as a popup dialog. There are a lot of options, but it will be used infrequently.
      • When a value us equal to 100%, auto fill that value to the end of the period of performance for that line item. Again, we may want to have a popup that says “This value is equal to 100% of the appropriation. Would you like this to be auto filled to the end of this appropriation?”
    • Add button to PPM “Project Editor” page that will open the appropriate monthly financial data entry page
    • FACTS data should only show for Admin.
    • Change “PM Actuals” to “PM Actuals (invoiced) Outlay
      • Copy values from PM Actual cell to Reported outlay cell (in PPM and PA)
      • hide “Reported Outlay” line in PA only
    • Entry should be selectable for monthly or cumulative. If entered as monthly, then it will be added to the previous month and shown in the cell as cumulative.
      • Dropdown should say “Enter Monthly Value” or “Enter Cumulative Value”
    • Year View in PA should be editable only by users with Admin (actually, probably NSAHQ users as well?)
    • Only show unige fields on identifier dropdown. There may have to be an identifier as well – e.g. Appr: O&M (2010), Name: MyProject…
    • Make a given month current until the 17th of the next month. So a project manager would have until November 17 to enter values for October
    • Continue to integrate navigation through line items by Overdue, Incomplete, Current, or All
  • Added comments to the PPM req’s page.

Tom DeVito 11.17.2011

Start: 9:45

  • Finished the arduino executive
  • Finished editing the arduino version of comutil class
  • Everything is in the right place now but it still needs some debugging.   With luck I’ll have it working by tomorrow, if not Monday.

End: 5:45

Phil 11.17.11

7:30 – 4:00 VISIBILITY

  • Deployed Dongs new stuff
  • tried to contact our designated server test guy
  • No meeting with Chris. He’s sick. We’ll try again tomorrow.
  • Need to make FACTS data optional
  • Got a new 4S. Much faster with the app.
  • Fixed up a few things with the style browser
  • Meeting with Kristi and Dong about Project Assistant
    • Splash page with a “tip of the day”, “Tutorial” button, and a “Use Project Assistant” button
    • Kristi will build the tutorial first, then we’ll break it into the help
    • Dong will add the ability to navigate through the monthly entries with the following filters:
      • overdue
      • incomplete
      • current
      • all

Phil 11.16.11

7:30 – 4:30 VISIBILITY

  • Tried to contact our test guy by phone and email, no luck yet.
  • Cleaning up GesturePieChart and GesturePieChartEvent
  • Spent quite a bit of time digging through styles to find how to make things look best together. Made a new view called StyleBrowser to seve work for the next time.
  • Dong gave me a new disk. We’ll all meet on site to deploy and talk to Chris.

How to get all the currently defined styles (from http://blog.flexexamples.com/2007/09/12/building-a-simple-style-browser-in-flex-3/)

 var arr:Array = styleManager.selectors;
 var selector:String;
 var cssStyle:CSSStyleDeclaration;
 var obj:Object;

 var key:String;
 for each (selector in arr){
     cssStyle = styleManager.getStyleDeclaration(selector);
     obj = new cssStyle.defaultFactory();
     for (key in obj) {
         trace(selector+": "+key+" = "+obj[key]);
     }
 }

Tom 11.15.2011

Start: 9:45

  • Finished the executive class
  • Fixed a problem with the Data Dictionary singleton method
  • Everything should be working on the pc side.  I am going to check what is wrong with the midi controllers tomorrow and work on the arduino side

End: 5:45