Category Archives: VISIBILITY

Phil 11.14.11

7:30 – 4:00 VISIBILITY

  • Network problems on site again. Our servers are running just fin though.
  • Working on nicer zooming. Got it. I just use a 200ms timer that’s reset every time the zoom method is called. If more then 200ms has passed since the last zoom, moving is allowed. Time to do some cleaning up of the code and dataProvider.
  • Dong found a cool thing that uses GWT instead of Flex: http://www.smartclient.com/smartgwt/showcase/#grid_offline_pref_featured_category

Dong Shin 11.14.2011

  • PPM
    • created HeaderRenderer for the yearly view in FinancialDataNavigator
      • selected month – blue, current month – red
    • changed NavBar button to ButtonBar in FinancialDataNavigator and created skin for it.
  • Experimenting with Google Web Toolkit (GWT)

Phil 11.10.11

7:30 – 4:00 VISIBILITY

  • Deployed new Project Assistant to Jeff’s server. Required dropping a view and then re-sourcing it in the DB.
  • Set up (I believe) a repeating task to back up the database daily. We’ll see if it works on Monday
  • Got pan and zoom working on the phone. Zoom is clunky – I think I need to change it so that the center of the zoom is always the center of the screen.

Phil 11.9.11

7:30 – 4:30 VISIBILITY

  • Set up scripts to backup financial databases. Need to automate those next.
  • Working through getting gestures to behave exactly right. I need to be able to move the chart without selecting parts. Maybe use a time delay?
  • Interview.

Dong Shin 11.09.2011

  • updating UI…
  • updated __view_budget_center_appropriation view to calculate total_budget correctly (__view_budget_center_appropriation.sql)
    • CREATE OR REPLACE
      ALGORITHM = UNDEFINED
      VIEW `__view_budget_center_appropriation`
      AS select budget_centers.uid AS uid,budget_centers.project_id AS project_id,budget_centers.center_number AS center_number,
      budget_centers.center_name AS center_name,budget_centers.funding_transaction_name AS funding_transaction_name,budget_centers.
      funding_transaction_number AS funding_transaction_number,
      budget_centers.funding_transaction_type AS funding_transaction_type,
      budget_centers.capability AS capability,budget_centers.expenditure_center AS expenditure_center,
      budget_centers.investment_portfolio AS investment_portfolio,budget_centers.appropriation AS appropriation,
      SUM(budget_amounts.amount) as total_budget, budget_centers.type AS type,budget_centers.program_element AS program_element,
      budget_centers.facts_pe AS facts_pe,appropriations.duration AS duration,appropriations.status AS status
      from budget_centers, appropriations, budget_amounts WHERE budget_centers.appropriation = appropriations.type
      AND budget_centers.uid = budget_amounts.budget_center_id
      GROUP BY budget_amounts.budget_center_id

Dong Shin 11.08.2011

  • reworked to disable goals in Financial Data
  • added NumberFormatter to format % values to 2 decimal points
  • Current button disabled on data when FY is not available
  • added DataGrid for Full FY Data, switch between monthly and yearly
  • reworking UI

Phil 11.8.11

7:30 – 4:30 VISIBILITY

  • My machine is working again!
  • Gave Mike my receipts for all my various permissions
  • Doing the Phishing training
  • Back to recognizing gestures. It may be that region select won’t be a problem?

Phil 11.7.11

7:30 – 4:30 VISIBILITY

  • Hopefully my customer machine is being fixed as I write this.
  • Mike got his access today?
  • Putting all the test pieces together to produce a fully functional pie chart component
  • More machine fixing
  • Meeting with Tangie
  • Uploaded new Project Assistant

Dong Shin 11.07.2011

  • Meeting with Tangi, found minor bugs
    • Goals should be disabled
    • format % values to 2 decimals
    • disable current button where FY is not available
  • changed ProjectFilterButtonBar skins to reflect the query
  • updated ItemRenderer to show INCOMPLETE
  • query to find OVERDUE, INCOMPLETE, CURRENT status of the projects
    • SELECT p.*,
      IF(p.uid IN (
      SELECT p.uid FROM obligations_outlays o, projects p
      WHERE o.project_id = p.uid
      AND ISNULL(o.month_2)
      AND (o.year + o.year_count – 1) = 2012),
      ‘OVERDUE’,
      (IF
      (p.uid in (SELECT p.uid FROM obligations_outlays o, projects p WHERE o.project_id = p.uid AND
      (o.year + o.year_count – 1) < 2012
      AND
      (ISNULL(o.month_1) OR
      ISNULL(o.month_2) OR
      ISNULL(o.month_3) OR
      ISNULL(o.month_4) OR
      ISNULL(o.month_5) OR
      ISNULL(o.month_6) OR
      ISNULL(o.month_7) OR
      ISNULL(o.month_8) OR
      ISNULL(o.month_9) OR
      ISNULL(o.month_10) OR
      ISNULL(o.month_11) OR
      ISNULL(o.month_12)
      )
      UNION
      SELECT p.uid FROM obligations_outlays o, projects p WHERE o.project_id = p.uid AND
      (o.year + o.year_count – 1) < 2012
      AND (ISNULL(o.month_1) OR ISNULL(o.month_2))
      ), ‘INCOMPLETE’,’CURRENT’))

      ) AS status

      FROM obligations_outlays o, projects p
      WHERE o.project_id = p.uid  AND (o.year + o.year_count – 1) = 2012
      GROUP by p.uid

Phil 11.4.11

8:00 – 4:30 VISIBILITY

  • A bit late because of lab tests
  • Uploaded new Project Assistant
  • Updated db on Jeff’s server so that Project Assistant would work on it and copied it over.
  • Meeting with Tangie. Dong has notes.
  • Some running around for Bill D.
  • More security stuff
  • Meeting with Mary G. to go over VISIBILITY for marketing purposes. Wide ranging discussion that wound up on how to use social media to market FGM.
  • Note: For Monday, do something like:

Dong Shin 11.04.2011

  • meeting with Tangi, few enhancementsand fixes
    • add INCOMPLETE for projects that are missing previous months’ data
    • add ‘Goals’ string to Obligation/Outlay (11/04)
    • Incomplete, Overdue, Current to filter projects list (11/04)
    • fix month when navigating thru Overdue projects (11/04)

Dong Shin 11.03.2011

  • PPM
    • changed PPM Widgets to Project Assistant
    • bold fonts on DropDowList
    • lighter gray for disabled Budget Centers and Years
    • added Budget Center information on Financial Data Navigator
    • fixed triple click/double tab to edit bug
  • Updated SF86 and sent to Carrie
  • Updating Performance Plan

Phil 11.3.11

7:30 – 4:00 VISIBILITY

  • Added more info to the credentials test webpage servlet and sent out the link
  • Walked though the PPM Widget with Dong
  • Reviewed Mike M’s spreadsheet for proposal
  • Working on Performance Plan – done
  • Security videos

Phil 11.2.11

7:30 – 5:30 VISIBILITY

  • Deployed Dong’s code, thought he network was slooooooooooooooooow. Didn’t realize that cut and paste worked with remote desktop. Handy.
  • Talked to Dong about making the contract information clearer
  • Worked on Performance Plan
  • Meeting with customer here at the Rams Head. Demo went well except for when everything bogged down because the laptop was trying to install 27 windows updates during the demo