Category Archives: VISIBILITY

Phil 10.20.11

8:30 – 3:30 VISIBILITY

  • Deployed Dong’s new code
    • Exec Summary is still default
    • Don’t show the “null” in the Budget Center combobox
    • Remove refresh dialog, since query is now fast enough (Yay!)
  • Mobile
    • Fix ordering problem – done. Needed to sort the selectedIndicies for some reason.
    • Add search to GenericScroller. Different behaviors depending on status of enableMultipleSelect
    • Make the dataProvider parsing more flexible?
    • My install of VisMobScreens in eclipse broke, no highlighting and messed up completion. Deleted and reloaded. Fine now.

Dong Shin 10.19.2011

  • deployed PPM Widgets and some problems….
  • PPM Widgets Changes
    • change the query to retrieve the financial data, instead of using the view, get all the data directly from the tables. This cut down the query process time significantly
    • Budget Center dropdown lists all the fields
    • moved Status column to left most
    • removed Exec Summary from default column
    • burned a CD for try out tomorrow.

Phil 10.19.11

8:00 – 4:00 VISIBILITY

  • Deployed Dong’s code
    • Change Budget Center to something like “Identifier”, since that doesn’t seem to be a unique identifier. Maybe fine all the items that do change within a column and use them to select which line item to selct? Other common information can be displayed below the comboboxes.
    • The current navigation gets put in a dropdown called “month”
    • The navigation at the bottom should step through the items that need to be filled out for the selected month. There should be an indicator that shows progress through the list (maybe a progress bar and a “2 of 10” label)
    • Selected columns unselect after coming back from a Financial Data Entry dialog
    • When changing a budget center, load times take upwards of two minutes!
    • Should SingletonDataDictionary.getItemData() return a null if data has not been published? Changed this so that it is the case
    • Default columns should not include Exec Summary.
    • “Columns” button should be changed to preferences
    • Status should be the left-most column.
  • Mobile App
    • Added Generic Scrollers to the table and column choices. Need to make sure that the ordering from the column list to the way that the columns are rendered is maintained.
    • Changed SingletonDataDictionary.getItemData() so that it returns a null if no item has been set yet. Checked in and deployed.

Phil 10.18.11

8:00 – 4:00 VISIBILITY

  • Deployed Dong’s new code
    • The load takes *way* to long on project status in the Widget.
    • The default login needs to be removed
    • The new fonts appear to mess up the financial update section
    • Had to change the html fore some reason, otherwise I got a blank white page. I was able to put together one that works using the old PPM html.
    • Brought in debug versions of Flashplayer
    • Working on developing a new AppEngine that uses the MySql data store functionality
      • Applied for a datastore account
    • While waiting for this, I was thinking that it might work to import the spreadsheet into the appEngine, use an in-memory DB to do all the actions, and then write out the database as a table again. Looking at JavaDB(Oracle) and HQSLDB. There are some issues with this approach – big tables/spreadsheets would be bad. There is the mapping between column id and column headers that needs to be worked out. Also, I’m not sure if the 3rd-party jar file issue that Mike warned me about will be an issue, but this may be a solution to that.

Dong Shin 10.18.2011

  • attempt to deploy new PPM and PPM Widget
    • start up query that retrieves project status takes to long – 145,000 records in __view_financial_data_status_view
    • remove default (debug) login
    • show status of query
    • Font size increase messed up PPM
    • Data Window in DB Table Mgmt needs scroller
  • added Alert to ask user to view project status up on login
  • added user information on top
  • added debugUser information to setupModel.xml
  • modified query to retrieve the projects status
    • 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_1)
      AND (o.year + o.year_count – 1) = 2012), ‘OVERDUE’, ‘CURRENT’)
      AS status FROM obligations_outlays o, projects p

      WHERE o.project_id = p.uid
      AND (o.year + o.year_count – 1) = 2012
      AND (proj_mgr_login = ‘annaleese’ OR p.uid in (SELECT project_id FROM
      _projects_service_project_mgrs WHERE login = ‘annaleese’))
      GROUP by p.uid

Phil 10.17.11

8:00 – 4:00 VISIBILITY

  • Got admin privs on Mikes machine and gave him Tomcat
  • Installed subversion on my box so we can keep synchronized.
  • Went over Dong’s progress. He has a new widget and a new PPM burned to disk. We’ll try deploying tomorrow
  • Assembled a description of the VISIBILITY suite for Chris Bailey
  • Got a little googling done. Mikes making good progress with maps.
    • Drat, the Google Query Language does not support inserts. Looks like a new AppEngine

Dong Shin 10.14.11

  • working at home
  • PPM
    • made font size bigger (12)
    • fixed endpoint errors not getting to MySQLIf (timing)
    • find overdue budget centers
      • select *, ‘overdue’ as status from obligations_outlays
        where (year + year_count) = 2013 and isnull(month_1)
        and funding_id in
        (select uid from budget_centers where project_id = 99)
        group by funding_id
    • find overdue years for the budget center
      • select *, ‘overdue’ as status from obligations_outlays
        where (year + year_count) = 2013 and isnull(month_1)
        and funding_id = 181
        group by year

Phil 10.13.11

8:00 – 4:30 VISIBILITY

  • Attempted to deploy Dong’s PPM Widget.
    • It launches in IE, but not in Firefox. Need to bring in debug players
    • There is an endpoint problem. Took screenshots for Dong to peruse
    • Meeting with Tangi
    • Impromptu meeting with Bill
  • Renewing my ACM membership
  • Submitting reimbursement for patent application fees
  • More work with Mike’s Google interface.

Dong Shin 10.12.2011

  • PPM Widgets
    • added Project status
    • updated FinancialDataView to have the fields from Project, added FinancialDataViewStatus for project status
    • added query to retrieve the status of the project (may need fine tuning, takes about 4 seconds to retrieve the data)
    • burned the software to test on-site
    • working on Budget Centers, Years, Year Counts for overdue projects
      • select b.`uid` AS `uid`,
        b.`project_id` AS `project_id`,
        `appropriations`.`status` AS `status`,
        ‘complete’ as project_status,
        O_type, o_year, o_year_count, o_uid, o_month_1
        from `budget_centers` b
        left join `appropriations` on
        b.`appropriation` = `appropriations`.`type`
        left join __view_financial_data_view
        on project_id = p_uid and b.uid = c_uid
        where p_uid = 100 and o_year = 2012 and o_year_count = 1
        and ISNULL(o_month_1)
        and uid not in (
        select b.`uid` AS `uid`
        from `budget_centers` b
        left join `appropriations` on
        b.`appropriation` = `appropriations`.`type`
        left join __view_financial_data_view
        on project_id = p_uid and b.uid = c_uid
        where p_uid = 100 and o_year = 2012 and o_year_count = 1
        and NOT ISNULL(o_month_1)
        GROUP BY uid)
        GROUP BY uid
        UNION

        select b.`uid` AS `uid`,
        b.`project_id` AS `project_id`,
        `appropriations`.`status` AS `status`,
        ‘overdue’ as project_status,
        O_type, o_year, o_year_count, o_uid, o_month_1
        from `budget_centers` b
        left join `appropriations` on
        b.`appropriation` = `appropriations`.`type`
        left join __view_financial_data_view
        on project_id = p_uid and b.uid = c_uid
        where p_uid = 100 and o_year = 2012 and o_year_count = 1
        and NOT ISNULL(o_month_1)
        GROUP BY uid

Dong Shin 10.11.2011

  • created FinancialDataDataGridSkin and modified FinancialDataItemRenderer
    • hover highlight and selection removed for non-editable row
    • backGround color added for editable row
    • MX + Spark setting in Flex Build Path not allowing spark theme? This doesn’t allow Spark DataGrid to use alternatingRowColors property, ended up modifying FinancialDataItemRenderer instead of using the skin class
  • cleaning up UI
  • create view for budget_centers and appropriations joined
    • CREATE ALGORITHM = UNDEFINED VIEW `__view_budget_center` AS SELECT budget_centers . * , appropriations.duration, appropriations.status
      FROM `budget_centers`
      LEFT JOIN appropriations ON budget_centers.appropriation = appropriations.type

Dong Shin 10.06.11

  • Meeting with Tangie at Fort and some enhancements requested
    • make fonts bigger
    • distinguishable header info in Financial Status Data. It should be each row of the project’s budget data and selectable/changeable
    • PM Actual Outlays link to the Financial Data
    • Possible meetings on Mon/Thu mornings
  • Continue working on PPM Widgets
    • basic monthly display is done
    • working on query to get whole financial data at one year at a time…Goals and data, $ and %, – all calculated.
      1. Obligations Goals %
      2. Obligations Goals $ – calculated from budget amount
      3. Obligation % and $ from Financial Data…. multiple data
      4. Outlay Goals %
      5. Outlay Goals $ – calculated from budget amount
      6. Outlay % and $ from Financial Data… multiple data
    • Goals Data query….for project uid 100
      • SELECT * FROM (
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Obligation %:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        CONCAT (g.obligation_month_1, ‘%’) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Obligation $:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        (a.amount * g.obligation_month_1 / 100) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        o.type as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        o.month_1 as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Obligated%’
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        REPLACE (o.type, ‘$:’, ‘%:’) as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        (o.month_1 / a.amount) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Obligated%’
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Outlay %:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        CONCAT (g.outlay_month_1, ‘%’) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Outlay $:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        (a.amount * g.outlay_month_1 / 100) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        o.type as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        o.month_1 as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Outlay%’
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        REPLACE (o.type, ‘$:’, ‘%:’) as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        (o.month_1 / a.amount) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Outlay%’
        ) AS X
        WHERE p_uid = 100 AND o_year=2011 AND o_year_count=1

Phil 10.6.11

8:30 – 4:30 VISIBILITY

  • Talked to Bill D, mostly about not freaking out Stark.
  • Dong met with Tanji. Meetings will be either Monday or Thursday, with donuts. Since Monday is a holiday, first donuts meeting will be Thursday.
  • Got admin privileges. Mike thinks he’ll have some code to test tomorrow or so.
  • Going through Mike’s code to see how he’s talking to Google.