Category Archives: Dong Shin

Dong Shin 10.27.2011

  • went to Fort, the VR hasn’t been approved yet.
  • PPM Widgets
    • changed the labels for the month navigation buttons
    • changed the way Financial Data Navigator starts up.
      • when there are overdue financial data, show first overdue on start
      • when there are no overdue financial data, show current FY and month
    • current Identifier added to the title of the Financial Data Navigator
    • changed the label per request (show # of total overdue when navigating overdue data, otherwise show total # of overdue data)
    • changed the colors of the Navigator

Dong Shin 10.26.2011

  • PPM Widgets
    • overdue project navigation – done
      • load list of overdue financial data and compare it on financial data retrieval
      • enable/disable buttons based on the current financial data loaded
    • ditched Spark ButtonBar in favor of Buttons because it’s easier to manage
  • burned a CD for PPM and Widgets for tomorrow, hoping my VR is ready.

Dong Shin 10.24.2011

  • PPM
    • looks like default font size is 10, anything bigger than 11 causes HAccordion components not showing header info
  • PPM Widgets
    • added FMP (Financial Mitigation Plan) to Financial Data Navigator – required when value < goal
    • adding Invoice for PM Actuals

Dong Shin 10.20.2011

  • deployed new PPM Widgets – queries are lot faster!
  • working thru PPM Widgets bugs
    • Exec Summary removed from the columns, not included in the deployed one.
    • removed null fields from Budget Center information DropDownList
    • removed the refresh Alert on login as the queries are not very fast.
    • changed the Budget Center label to “Identifier”
    • moved the Financial Data Navigate buttons to PopUpButtons and labeled it “Contract Month”, reworked navigation routines
    • keep columns selected for display on Projects refresh and changed the “Columns” label on the button to “Preferences”

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.

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

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

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

Dong Shin 10.05.11

  • I know I shouldn’t have, but went ahead and updated to the Flash Player 11.0. It kept crashing in Firefox. Not just the our software, but Adobe’s as well. Chrome uses the version 11.0 and it looks ok. Well, going back to the version 10.
  • The problem I have had with ADL (Adobe Air Debug Launcher) for the mobile apps turned out to be related to the FlashFireBug plugin. mm.cfg file in my home directory is set to pre-load the plugin swf on start up. Somehow it messes up the ADL…. Set the PreloadSWF field to empty, and now it runs. I had to remove the plugin completely because it tries to fill the field again and when it did, it messed up the ADL again.
  • working on retrieving obligations/outlays data
    • created view for financial data – this allows to retrieve the data in one-shot.
    • CREATE
      ALGORITHM = UNDEFINED
      VIEW `project_obligations_outlays`
      AS       SELECT
      p.uid as p_uid,
      p.project_number as p_project_number,
      p.title as p_title,
      p.exec_summary as p_exec_summary,
      p.description as p_description,
      p.location as p_location,
      p.begin_year as p_begin_year,
      p.end_year as p_end_year,
      p.total_budget as p_total_budget,
      p.proj_mgr_login as p_proj_mgr_login,
      p.proj_admin_login as p_proj_admin_login,
      p.portfolio_mgr_login as p_portfolio_mgr_login,
      p.portfolio_admin_login as p_portfolio_admin_login,
      p.priority as p_priority,
      p.services as p_services,
      p.TRL_start as p_TRL_start,
      p.TRL_current as p_TRL_current,
      p.TRL_end as p_TRL_end,
      p.TCL_start as p_TCL_start,
      p.TCL_current as p_TCL_current,
      p.TCL_end as p_TCL_end,
      p.TP_start as p_TP_start,
      p.TP_current as p_TP_current,
      p.TP_end as p_TP_end,
      p.lock_id as p_lock_id,
      p.lock_time as p_lock_time,
      c.uid as c_uid,
      c.project_id as c_project_id,
      c.center_number as c_center_number,
      c.center_name as c_center_name,
      c.funding_transaction_name as c_funding_transaction_name,
      c.funding_transaction_number as c_funding_transaction_number,
      c.funding_transaction_type as c_funding_transaction_type,
      c.capability as c_capability,
      c.expenditure_center as c_expenditure_center,
      c.investment_portfolio as c_investment_portfolio,
      c.appropriation as c_appropriation,
      c.total_budget as c_total_budget,
      c.type as c_type,
      c.program_element as c_program_element,
      c.facts_pe as c_facts_pe,
      a.uid as a_uid,
      a.year as a_year,
      a.amount as a_amount,
      a.status_amount as a_status_amount,
      a.budget_center_id as a_budget_center_id,
      a.last_updated as a_last_updated,
      o.uid as o_uid,
      o.type as o_type,
      o.description as o_description,
      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,
      o.month_1 as o_month_2,
      o.month_1 as o_month_3,
      o.month_1 as o_month_4,
      o.month_1 as o_month_5,
      o.month_1 as o_month_6,
      o.month_1 as o_month_7,
      o.month_1 as o_month_8,
      o.month_1 as o_month_9,
      o.month_1 as o_month_10,
      o.month_1 as o_month_11,
      o.month_1 as o_month_12

      FROM `projects` p,
      budget_centers c,
      budget_amounts a,
      obligations_outlays o
      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
      ORDER BY o.uid

Dong Shin 10.04.11

  • Working on PPM Wizard
    • created ProjectSelectGroup to display list of projects
    • added ColumnsSelectTitleWindow to ProjectSelectGroup. This allows selection of columns to view in the list of projects
    • added  FinancialDataNavigator
    • added FinancialDataDataGrid
      • FinancialDataItemRenderer to display the data in CurrencyFormat
      • FinancialDataItemEditor to restrict numbers input using NumberTextInput
    • added getDefaultVariables method to return list of pre-selected fields/columns to display from RowDataBase class
    • added parseData to parse database results to RowDataBase object dynamically
  • Flash Player 11 is here!

Dong Shin 10.03.11

  • Cleaning up and mapping database tables to ActionScript classes
    • Tables not needed? Contacts, Cofundings, Financials, Forms_Query, Project_Alerts
      • TRUNCATE TABLE `contacts`
    • done – left out relation tables…
  • working on Project Managers Wizard