Monthly Archives: November 2011

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.

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]);
     }
 }