Author Archives: pgfeldman

Dong Shin 11.25.2011

  • created ItemRenderer and skin for Month Status ComboBox
  • realized that Reported Outlay and Outlay $ (Reported in FACTS) are not shown to Project Managers. These should not be counted in Project Status
  • new Query
    • SELECT
      IF ( (((SUM(IF(ISNULL(month_1), 1, 0)) = 4 OR SUM(IF(ISNULL(month_2), 1, 0)) = 4) AND o.year+year_count=2013) OR ((SUM(IF(ISNULL(month_1), 1, 0)) = 4 OR SUM(IF(ISNULL(month_2), 1, 0)) = 4 OR SUM(IF(ISNULL(month_3), 1, 0)) = 4 OR SUM(IF(ISNULL(month_4), 1, 0)) = 4 OR SUM(IF(ISNULL(month_5), 1, 0)) = 4 OR SUM(IF(ISNULL(month_6), 1, 0)) = 4 OR SUM(IF(ISNULL(month_7), 1, 0)) = 4 OR SUM(IF(ISNULL(month_8), 1, 0)) = 4 OR SUM(IF(ISNULL(month_9), 1, 0)) = 4 OR SUM(IF(ISNULL(month_10), 1, 0)) = 4 OR SUM(IF(ISNULL(month_11), 1, 0)) = 4 OR SUM(IF(ISNULL(month_12), 1, 0)) = 4) AND o.year+year_count<2013)) ,’OVERDUE’,  ‘CURRENT’) as status,
      (
      IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 4 AND o.year+year_count=2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 4 AND o.year+year_count=2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_3), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_4), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_5), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_6), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_7), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_8), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_9), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_10), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_11), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_12), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0)
      )
      as overdue_count,
      (
      IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 4 AND o.year+year_count=2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 4  AND o.year+year_count=2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_3), 1, 0)) > 0 AND SUM(IF(ISNULL(month_3), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_4), 1, 0)) > 0 AND SUM(IF(ISNULL(month_4), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_5), 1, 0)) > 0 AND SUM(IF(ISNULL(month_5), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_6), 1, 0)) > 0 AND SUM(IF(ISNULL(month_6), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_7), 1, 0)) > 0 AND SUM(IF(ISNULL(month_7), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_8), 1, 0)) > 0 AND SUM(IF(ISNULL(month_8), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_9), 1, 0)) > 0 AND SUM(IF(ISNULL(month_9), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_10), 1, 0)) > 0 AND SUM(IF(ISNULL(month_10), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_11), 1, 0)) > 0 AND SUM(IF(ISNULL(month_11), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
      IF ((SUM(IF(ISNULL(month_12), 1, 0)) > 0 AND SUM(IF(ISNULL(month_12), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0)
      )
      as incomplete_count,
      c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count,  p.duration
      FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations p
      WHERE o.project_id = 173 AND c.uid = o.funding_id AND a.budget_center_id = c.uid AND a.year = year_count AND c.appropriation = p.type
      AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
      GROUP BY o.year, year_count

Tom DeVito 11.23.2011

Start: 9:45

  • For some reason, the ComUtil class would not include properly.  Renamed it ComUtilB and it works again.  No idea why I had to do this but it will help keep the arduino and pc versions from getting confused.
  • The Singleton method of the DataDictionary is not working on the arduino side.
  • Fixed a few things which were causing compiler errors, still can’t figure out why the singleton method isn’t working
  • Checked to see if I was having the same problem on the PC side.  It seems to be working fine.
  • Googled “singleton arduino,” apparently it can’t be done in the standard way because the arduino is single threaded.  There is a solution which I have yet to try in the second to last post: http://www.arduino.cc/cgi-bin/yabb2/YaBB.pl?num=1295472760

End: 5:45

Phil 11.23.11

7:30 – 3:30 VISIBILITY

Dong Shin 11.23.2011

  • more PA changes
    • queries done, tested
    • changed BudgetCenter and created BudgetCenterDetail classes to map the new queries to AS objects
    • overhauling Financial Data Navigator to use new data types
    • realized that there could be more than one overdue/incomplete columns in a year, tweaked the query (longer!).
      • SELECT
        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’,  ‘CURRENT’) as status,
        (
        IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 6 AND o.year+year_count=2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 6 AND o.year+year_count=2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_3), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_4), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_5), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_6), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_7), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_8), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_9), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_10), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_11), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_12), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0)
        )
        as overdueCount,
        (
        IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 6 AND o.year+year_count=2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 6  AND o.year+year_count=2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_3), 1, 0)) > 0 AND SUM(IF(ISNULL(month_3), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_4), 1, 0)) > 0 AND SUM(IF(ISNULL(month_4), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_5), 1, 0)) > 0 AND SUM(IF(ISNULL(month_5), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_6), 1, 0)) > 0 AND SUM(IF(ISNULL(month_6), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_7), 1, 0)) > 0 AND SUM(IF(ISNULL(month_7), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_8), 1, 0)) > 0 AND SUM(IF(ISNULL(month_8), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_9), 1, 0)) > 0 AND SUM(IF(ISNULL(month_9), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_10), 1, 0)) > 0 AND SUM(IF(ISNULL(month_10), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_11), 1, 0)) > 0 AND SUM(IF(ISNULL(month_11), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
        IF ((SUM(IF(ISNULL(month_12), 1, 0)) > 0 AND SUM(IF(ISNULL(month_12), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0)
        )
        as incompleteCount,
        c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count,  p.duration FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations p WHERE o.project_id = 100 AND c.uid = o.funding_id AND a.budget_center_id = c.uid AND a.year = year_count AND c.appropriation = p.type GROUP BY o.year, year_count

Tom DeVito 11.22.2011

Start: 11:00

  • The link I posted yesterday for using visual studio with the arduino only works with VS2008.  There is a new link which was added to the bottom for a addin called Visual Micro:  http://www.visualmicro.com/
  • I was having a problem creating a arduino project.  I had to reset the addins: http://www.visualmicro.com/post/2011/10/01/How-to-reset-the-arduino-visual-studio-interface.aspx
  • Imported all the arduino classes into the project.  I used the testing sketch to check and make sure it uploaded to the arduino, everything seems to be working.  There are some red underlines here and there for no apparent reason but it compiles and transmits correctly.
  • Everything is in one place now.  Its much easier to see and edit all the classes from one place.  Before I could only really see the main sketch and had multiple windows open for the classes.
  • There are a couple bugs in the error checking.  The IDE will red line some things which are actually not errors and compile fine.  Still a vast improvement.
  • The ComUtil class on the arduino side was not being included properly.  Not exactly sure what I did but it is working now.
  • Everything seems to be working properly in individual testing now.  Putting it all together, hopefully will have something to show by end of the day tomorrow.

End: 6:00

Mike 11.22.11

  • More waiting around at site for permissions
  • Created a set of icons for the ColumnView page of the mobile app, added multiple versions for different screen DPI
  • Updated the pie chart colors
  • Added another logo screen for larger screen sizes
  • Yearly review with Brian
  • Various other bug fixes and polishing on the mobile app

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.