Category Archives: VISIBILITY

Phil 12.12.11

10:00 –  5:00 VISIBILITY

  • It’s my first day back(ish) at work! I really miss my dual monitors!
    • Trying to get my laptop set up as a second monitor
    • Windows is all messed up. Trying Ubuntu 10.1. Nope, need a newer kernel
    • Trying Linux Mint. Better so far… Nope. Installer hangs repeatedly.
    • Open SUSE 12.1? (because these guys say so). And it’s awesome, but the laptop keeps freezing whenever I bring up Firefox. Looks like it has a one year warranty, so I guess I’ll try to return it.
  • Setting up my IDE (Eclipse 3.7)
    • Maven is in and up, adding environment variables
    • Adding GWT support. It turns out that There is a version of GWT designer that does not run in eclipse that has more features. You can find it here.
  • Added a blog page for things GWT

Dong Shin 12.06.2011

  • added auto-fill to Create/Edit projects. This fills specified data up to the current month and year
  • Updating PM Actuals to PM Actuals (Invoiced) broke Funding Request/Financial Status Data. Updated all references to PM Actuals
  • uploaded the latest PPM and PA to fgmdev
  • looking into incorporate HTML’s to Flex easy way….

Dong Shin 12.02.2011

  • changes to PPM and PA
    • removed Incomplete projects from the list
    • changed Spark Label to MX Text to wordwrap the Budget Details
    • changed the Current month to Reporting month
    • rearranging visual components in Financial Data Navigator to clarify the layout

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

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

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

Phil 11.29.11

7:30 – 3:30 VISIBILITY

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