Phil 12.2.11

8:30 – VISIBILITY

  • Installed Dong’s new software onto the dual-facing server and added redirects to the instances on Jeff’s server.
  • Notes from meeting with Tangie
    • PA
      • Identifier dropdown needs some kind of labeling, like id:foo, name: bar, etc. The currne tscheme with all the commas doesn’t work
      • The entry screen is getting too busy. We need to clarify the layout
        • Move help to a popup?
        • Choose the visible navigation?
      • Add Kristi’s help and splash screen link to tutorial
      • The grid of attributes sometimes stretches outside the containing panel, we should make the panel wider
      • Incomplete projects should not be listed
      • Too many plurals
      • Confusion between “current” state and “current” month. Let’s change “current” month to “reporting” month
      • Is the cumulative or monthly amount in? I didn’t see it.
    • PPM
      • Add Name to browser tab. Currently it’s “#”
      • Add a button that allows data to be filled on the Edit Project page, not just the financial reporting page

Thomas DeVito 12.01.11

start: 9:40

  • Finished fixing up the arduino side to nto depend as much on the data dictionary
  • Finished the command class which handles commands
  • In the process of fixing the PC side.  The data seems to be passing ok but still not displaying.  Its not getting lost on the arduino side anymore though

end: 6:00

Mike 12.1.2011

  • Going through Phil’s GWT book step-by-step
  • Found a workaround for the broken dialog in the GWT Eclipse plugin (when trying to create a new HTML page and nothing happens):
    • create a new file at ‘myproject/src/com/google/gwt/user/tools/AppHtml.htmlsrc’
    • put the following 1 line in it: ‘<!doctype html>’
    • The dialog should not finish correctly

Phil 12.1.11

8:30 – 4:30 VISIBILITY

  • Starting off the day from home. Which means I’m installing GWT. Might as well try it on the new (3.7) Eclipse while I’m at it.
  • Working through the GWT RPC Tutorial, which is not one of their better ones. I think its not been kept up to date. It’s good enough though.
  • Here’s the result. The server is now computing the stock price and sending the result to the client

Tom DeVito 11.30.2011

Start:  10:45

  • Reorganizing everything in the arduino sketch to work with so that if it does need anything from the data dictionary it can be passed from the main.
  • The loadBuffer parameter is now just the char* instead of the name of a dataelement.
  • The checkCommand method now accepts the command struct as a parameter instead of a dataelement.
  • Added checks in the CommandHandler class to check that a command is unique before execution.
  • This really does seem like a better idea.  It keeps it more modular and the arduino side is simple enough that the datadictionary was adding unnecessary complexity.  It is still used in the main sketch to handle remote data which passes between the pc and the aruduino which is the main reason it exists in the first place.

End: 5:45

Phil 11.30.11

7:30 – 5:00 VISIBILITY

  • Backups indicate nothing is happening. Ah well. We’ll deploy the new code next week and see if we can’t get things moving. I’ll contact Tangie tomorrow.
  • Working on RPC with GWT. Looks pretty straightforward. I want to understand the limitations on sharing a class between the client and the server.
  • Mike’s starting to get logging working in GWT.
  • Found the National Capital Area Google Technology User’s Group
  • Added name and password saving to the application. THe easy answer, storing encrypted data didn’t work. saving view state messed up the views. Using FlexGlobals.topLevelApplication.persistenceManager.setProperty() worked, but then I didn’t feel right about leaving a password out in plain text, so I wrote some crappy encryption using Perlin noise that provides a nice looking figleaf.

Dong Shin 11.30.2011

  • Financial Data navigation in Project Assistant
    • takes to the beginning of the records when option changes
    • combined checkbox navigation – done
    • working on current months navigation – done coding
    • testing would take a while….
    • revised the Budget Details query to ignore $0 budgets and years beyond current year
      • SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, r.duration,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_1), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_1), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_1_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_2), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_2_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_3), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_3), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_3_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_4), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_4), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_4_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_5), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_5), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_5_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_6), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_6), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_6_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_7), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_7), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_7_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_8), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_8), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_8_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_9), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_9), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_9_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_10), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_10), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_10_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_11), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_11), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_11_status,
        IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_12), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_12), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_12_status
        FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations r, projects p
        WHERE p.uid = 174 AND c.project_id = p.uid AND c.uid = a.budget_center_id AND a.year = o.year – p.begin_year + 1 AND c.uid = o.funding_id AND c.appropriation = r.type
        AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’ GROUP BY a.uid, o.year, o.year_count ORDER BY c.uid, o.year, o.year_count

Tom DeVito 11.29.11

Start: 10:00

  • Finished the testing sandbox for datadictionary.  Its strange, it uploads with some errors about the class object not being there, it doesn’t crash during runtime, but still doesn’t work.  It is actually using the class which is having the error to send the serial data back.
  • Still trying to figure this out.  I have decided its not necessary on the arduino side.  The DataDictionary will still work in the main sketch so the transfer from the PC side will work fine it just won’t be able to be used in the other classes which don’t really need it considering there is no graphical interface or anything else to interact with on this side.
  • Rewrote the ComUtil class to work without the DataDictionary.

End: 6:00

Mike 11.29.11

  • Finished things up in the phone app:
    • Implemented filtering in the ColumnView
    • Removed the filtering option in the TableView
    • Made the map markers DPI dependent
    • Few other small fixes
  • Looking in to GWT / Java Enterprise Architectures, specifically 3-tier application architectures
  • Fiddling around with GWT Examples

Phil 11.29.11

7:30 – 3:30 VISIBILITY

Thomas DeVito 11.28.2011

Start: 9:45

  • Upon clicking the compiler error, I found that for some reason it was using a different DataDictionary then the one seen in the project folder.  I was able to make the changes and compile.
  • For some reason Visual Micro is not able to make the objects properly when trying to deploy.
  • Something went very wrong with Visual Micro,  none of my sketches will compile now.
  • Reinstalled Visual Micro which was actually kinda annoying.  Not only did you have to delete it but you also had to go in the setting and disable the mod that did shouldn’t be installed.
  • Visual Micro is now able to compile working sketches again
  • The DataDictionary is still making a weird error message.  I commented out all the instance of it and found that there are no errors if it is only declared in the main sketch.
  • Uncommeted the datadictionary in ComUtilB,  I still get a weird error message but the sketch seems to be sent.
  • Setting up a sandbox to test datadictionary from a class.  All previous tests were done in the main sketch.  I have a feeling it will work but I will still get the weird compiling messages.

End: 5:45

Dong Shin 11.28.2011

  • revised Budget Details Query so that the navigation is bit easier….
    • SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, p.duration,
      IF(SUM(IF(ISNULL(month_1), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_1), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_1_status,
      IF(SUM(IF(ISNULL(month_2), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_2_status,
      IF(SUM(IF(ISNULL(month_3), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_3), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_3_status,
      IF(SUM(IF(ISNULL(month_4), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_4), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_4_status,
      IF(SUM(IF(ISNULL(month_5), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_5), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_5_status,
      IF(SUM(IF(ISNULL(month_6), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_6), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_6_status,
      IF(SUM(IF(ISNULL(month_7), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_7), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_7_status,
      IF(SUM(IF(ISNULL(month_8), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_8), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_8_status,
      IF(SUM(IF(ISNULL(month_9), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_9), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_9_status,
      IF(SUM(IF(ISNULL(month_10), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_10), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_10_status,
      IF(SUM(IF(ISNULL(month_11), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_11), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_11_status,
      IF(SUM(IF(ISNULL(month_12), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_12), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_12_status
      FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations p
      WHERE c.project_id = 173
      AND c.uid = o.funding_id
      AND a.budget_center_id = c.uid
      AND a.year = o.year_count
      AND c.appropriation = p.type
      AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
      GROUP BY o.year, o.year_count
      ORDER BY c.uid, o.year, o.year_count
  • looks like a separate list of current months’ status is needed to handle all/current months navigation…
    • query
      • SELECT o.year, o.year_count, o.project_id
        IF(SUM(IF(ISNULL(o.month_2), 1, 0)) = 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(o.month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as status
        FROM obligations_outlays o
        WHERE o.project_id=172
        AND (o.year + o.year_count) = 2013
        AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
        GROUP BY year, year_count