Category Archives: Dong Shin

Dong Shin 08.09.2012

• weekly status meeting at Fort
• added Courier New font to the PrettyTextEditor in VSS4, using it in .css file would not work for Windows. It took me a while to figure that out?

Dong Shin 08.08.2012

• changed VisibilityScripting4 to embed AS3Dictionary.xml and SmartEditor.css
• fixed FlexUtils not showing Compilation Date correctly
• working on users’ project status script…
  • query to return all project mgrs with overdue data
    • created CurrentMonthOverdueUsers.py – in VS4 resources/scripts directory
    • SELECT m.login as user_login, p.project_number, p.description, a.amount, o.uid, o.type, o.year, o.year_count,
      o.month_11 as ‘Aug’
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o, _projects_service_project_mgrs m
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND a.year = 2012 – p.begin_year + 1
      AND o.project_id = p.uid
      AND o.funding_id = c.uid
      AND o.year + o.year_count – 1 = 2012
      AND o.year_count = 1
      AND ISNULL(o.month_11)
      AND p.uid = m.project_id
      UNION
      SELECT p.proj_mgr_login as user_login, p.project_number, p.description, a.amount, o.uid, o.type, o.year, o.year_count,
      o.month_11 as ‘Aug’
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND a.year = 2012 – p.begin_year + 1
      AND o.project_id = p.uid
      AND o.funding_id = c.uid
      AND o.year + o.year_count – 1 = 2012
      AND o.year_count = 1
      AND ISNULL(o.month_11)
      AND NOT ISNULL(p.proj_mgr_login)

Dong Shin 08.07.2012

• added “No Email” for the users with no email address when generating Financial Data Request
• removed EdgeUtils from VisibilityScripting4
• working on query to generate user, project, description, status, and month (for the last 4 months maybe?) as rows
  • query to extract current year and fiscal month
    • SELECT DATE_FORMAT(CURRENT_DATE(), ‘%Y’) as year,
      IF(DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 < 1,
      DATE_FORMAT(CURRENT_DATE(), ‘%m’) + 3, DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 ) as month
  • query to find missing August entries
    • SELECT p.begin_year, a.*, o.uid, o.type, o.year, o.year_count,
      o.month_11 as ‘Aug’
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND a.year = 2012 – p.begin_year + 1
      AND o.project_id = p.uid
      AND o.funding_id = c.uid
      AND o.year + o.year_count – 1 = 2012
      AND o.year_count = 1
      AND ISNULL(o.month_11)
      AND p.uid = 99

Dong Shin 08.06.2012

• added ChangeLogs panel to keep track of change/fixes to PPM – Moved to EdgeUtils
• fixed typo for Auguest in PPM
• working on configurable line items for Monthly Financial Data

Dong Shin 08.03.2012

• added the revised questions for the Financial Mitigations Plan
• fixed typos in the FMP
• fixed Contract Window not showing contracts
• clean database set up for PPM src/main/resources/database/project_portfolio_clean.sql
• went over the database structure to clean up relations – src/main/resources/database/DBUpdateSQLs08032012.sql
• fixed Project Mgmt permissions not behaving correctly
• fixed logging out messing up panels states
• fixed services filter not working

Dong Shin 07.31.2012

• deployed new PPM and went over with JR
• fixed IngestManger bugs
  • changed the Merge flag to Replace
  • reset all the fields in Auto Ingest panel on save
• The title of PPM shows correctly here, but not on-site. weird
• sent Phil new VisiblityScriptingMain4 (Flex 4 version of VisibilityScriptingMain) and the new IngestManager

Dong Shin 07.30.2012

• continue working on Total datagrids for Create Project
  • query to get sub project totals
    • SELECT p.begin_year, p.end_year, t.project_id, t.fiscal_year, SUM(budget_amount)
      FROM projects p, yearly_totals t
      WHERE p.uid = 101
      AND
      project_id IN
      (SELECT sub_project_id
      FROM _project_sub_projects
      WHERE project_id = 101)
      GROUP BY fiscal_year
  • finished up – will try to deploy tomorrow
• fixed a bug not showing parent/children projects correctly in Create Project panel

Dong Shin 07.27.2012

• reworking Total datagrids in Create Project panel
  • added datagrid for the parents should have budgets dynamically calculated from the children (parent budget – children)
• building vis2 and AccountManager per Phil’s request – update all the codes
  • working from workspace.codesonly
  • copying Mike’s local Maven Repo – C:mavenrepo to C:mavenrepo.mike
  • updated and deployed EdgeUtils, GenericQueryWidget, ManagemetUtils to local repo
  • updated AccountManager and vis2 swf’s to try
• got Out-of-Memory / heap space error deploying from M2Eclipse, to resolve
  • http://eureka.ykyuen.info/2010/02/28/maven-set-java-heap-memory-on-m2eclipse/

Dong Shin 07.25.2012

• added total budgets for project and sub projects in separate datagrids
  • budget is entered in only one datagrid
  • total, allocated, available calculated separate
  • working on retrieving individual budgets from sub projects

Dong Shin 07.24.2012

• finished installing XP no Phil’s box – after several failed attempts
  • IE 7 7.0.5730.13
  • Flash Player 11.2.202.228
• tried various versions (3.5, 3.6 compiles, SWFs that we tried at Fort) – Everythings loads fine!
• reworking query for sub-projects to return yearly totals for parent projects

Dong Shin 07.23.2012

• working on parent/child budget information on Create Project Panel – done!
  • fixed number of sub projects not showing correctly on delete
• installing XP on Phil’s box

Dong Shin 07.19.2012

• got bug list from Jessica
• fixed sub projects not showing up for the PMs
• building several different version of Visibility to trouble-shoot IE7 problem per Phil’s recommendation
  • had to fix some hard-coded paths and project settings

Dong Shin 07.18.2012

• spent most of the day on site with Phil prepping demo for Col. Duke
• few bugs noticed – should be the Jessica’s list of bugs/enhancements
  • sub projects are not shown to the PMs in Project Management panel
  • add a budget summary panel to parent projects
• burned Mike’s Visiblity SWF’s from his laptop to a CD

Dong Shin 07.17.2012

• space between month and year causing Ingest Manager to fail, but works fine here… changed all the scripts to have month_year
• scripts created
  • to retrieve FY Goals – FY12Goals.py
  • to retrieve PPM tool usages for the users – PPMUsersUsages.py
  •  to retrieve FMPs for 2012 – FY12FMPs.py, need clarification on how to do rates/goals
  • to calculate monthly status (actual / (goal * budget amount)) -FY12MonthlyStatus.py
• query to retrieve tool usages
  • SELECT
    user, date, MAX(timestamp) as start_time, MIN(timestamp) as end_time, (UNIX_TIMESTAMP(MAX(timestamp)) – UNIX_TIMESTAMP(MIN(timestamp))) as duration_seconds
    FROM query_logs
    GROUP BY date
• query to retrieve all obligation/outlay goals
  • SELECT
    appropriation, ‘obligation’ as type,
    SUM(IF(year=1, obligation_month_1, NULL)) as ‘Oct 2011’,
    SUM(IF(year=1, obligation_month_2, NULL)) as ‘Nov 2011’,
    SUM(IF(year=1, obligation_month_3, NULL)) as ‘Dec 2011’,
    SUM(IF(year=1, obligation_month_4, NULL)) as ‘Jan 2012’,
    SUM(IF(year=1, obligation_month_5, NULL)) as ‘Feb 2012’,
    SUM(IF(year=1, obligation_month_6, NULL)) as ‘Mar 2012’,
    SUM(IF(year=1, obligation_month_7, NULL)) as ‘Apr 2012’,
    SUM(IF(year=1, obligation_month_8, NULL)) as ‘May 2012’,
    SUM(IF(year=1, obligation_month_9, NULL)) as ‘Jun 2012’,
    SUM(IF(year=1, obligation_month_10, NULL)) as ‘Jul 2012’,
    SUM(IF(year=1, obligation_month_11, NULL)) as ‘Aug 2012’,
    SUM(IF(year=1, obligation_month_12, NULL)) as ‘Sep 2012’,
    SUM(IF(year=2, obligation_month_1, NULL)) as ‘Oct 2012’,
    SUM(IF(year=2, obligation_month_2, NULL)) as ‘Nov 2012’,
    SUM(IF(year=2, obligation_month_3, NULL)) as ‘Dec 2012’,
    SUM(IF(year=2, obligation_month_4, NULL)) as ‘Jan 2013’,
    SUM(IF(year=2, obligation_month_5, NULL)) as ‘Feb 2013’,
    SUM(IF(year=2, obligation_month_6, NULL)) as ‘Mar 2013’,
    SUM(IF(year=2, obligation_month_7, NULL)) as ‘Apr 2013’,
    SUM(IF(year=2, obligation_month_8, NULL)) as ‘May 2013’,
    SUM(IF(year=2, obligation_month_9, NULL)) as ‘Jun 2013’,
    SUM(IF(year=2, obligation_month_10, NULL)) as ‘Jul 2013’,
    SUM(IF(year=2, obligation_month_11, NULL)) as ‘Aug 2013’,
    SUM(IF(year=2, obligation_month_12, NULL)) as ‘Sep 2013’,
    SUM(IF(year=3, obligation_month_1, NULL)) as ‘Oct 2013’,
    SUM(IF(year=3, obligation_month_2, NULL)) as ‘Nov 2013’,
    SUM(IF(year=3, obligation_month_3, NULL)) as ‘Dec 2013’,
    SUM(IF(year=3, obligation_month_4, NULL)) as ‘Jan 2014’,
    SUM(IF(year=3, obligation_month_5, NULL)) as ‘Feb 2014’,
    SUM(IF(year=3, obligation_month_6, NULL)) as ‘Mar 2014’,
    SUM(IF(year=3, obligation_month_7, NULL)) as ‘Apr 2014’,
    SUM(IF(year=3, obligation_month_8, NULL)) as ‘May 2014’,
    SUM(IF(year=3, obligation_month_9, NULL)) as ‘Jun 2014’,
    SUM(IF(year=3, obligation_month_10, NULL)) as ‘Jul 2014’,
    SUM(IF(year=3, obligation_month_11, NULL)) as ‘Aug 2014’,
    SUM(IF(year=3, obligation_month_12, NULL)) as ‘Sep 2014’,
    SUM(IF(year=4, obligation_month_1, NULL)) as ‘Oct 2014’,
    SUM(IF(year=4, obligation_month_2, NULL)) as ‘Nov 2014’,
    SUM(IF(year=4, obligation_month_3, NULL)) as ‘Dec 2014’,
    SUM(IF(year=4, obligation_month_4, NULL)) as ‘Jan 2015’,
    SUM(IF(year=4, obligation_month_5, NULL)) as ‘Feb 2015’,
    SUM(IF(year=4, obligation_month_6, NULL)) as ‘Mar 2015’,
    SUM(IF(year=4, obligation_month_7, NULL)) as ‘Apr 2015’,
    SUM(IF(year=4, obligation_month_8, NULL)) as ‘May 2015’,
    SUM(IF(year=4, obligation_month_9, NULL)) as ‘Jun 2015’,
    SUM(IF(year=4, obligation_month_10, NULL)) as ‘Jul 2015’,
    SUM(IF(year=4, obligation_month_11, NULL)) as ‘Aug 2015’,
    SUM(IF(year=4, obligation_month_12, NULL)) as ‘Sep 2015’
    FROM obligations_outlays_goals
    GROUP BY appropriation
    UNION
    SELECT
    appropriation, ‘outlay’ as type,
    SUM(IF(year=1, outlay_month_1, NULL)) as ‘Oct 2011’,
    SUM(IF(year=1, outlay_month_2, NULL)) as ‘Nov 2011’,
    SUM(IF(year=1, outlay_month_3, NULL)) as ‘Dec 2011’,
    SUM(IF(year=1, outlay_month_4, NULL)) as ‘Jan 2012’,
    SUM(IF(year=1, outlay_month_5, NULL)) as ‘Feb 2012’,
    SUM(IF(year=1, outlay_month_6, NULL)) as ‘Mar 2012’,
    SUM(IF(year=1, outlay_month_7, NULL)) as ‘Apr 2012’,
    SUM(IF(year=1, outlay_month_8, NULL)) as ‘May 2012’,
    SUM(IF(year=1, outlay_month_9, NULL)) as ‘Jun 2012’,
    SUM(IF(year=1, outlay_month_10, NULL)) as ‘Jul 2012’,
    SUM(IF(year=1, outlay_month_11, NULL)) as ‘Aug 2012’,
    SUM(IF(year=1, outlay_month_12, NULL)) as ‘Sep 2012’,
    SUM(IF(year=2, outlay_month_1, NULL)) as ‘Oct 2012’,
    SUM(IF(year=2, outlay_month_2, NULL)) as ‘Nov 2012’,
    SUM(IF(year=2, outlay_month_3, NULL)) as ‘Dec 2012’,
    SUM(IF(year=2, outlay_month_4, NULL)) as ‘Jan 2013’,
    SUM(IF(year=2, outlay_month_5, NULL)) as ‘Feb 2013’,
    SUM(IF(year=2, outlay_month_6, NULL)) as ‘Mar 2013’,
    SUM(IF(year=2, outlay_month_7, NULL)) as ‘Apr 2013’,
    SUM(IF(year=2, outlay_month_8, NULL)) as ‘May 2013’,
    SUM(IF(year=2, outlay_month_9, NULL)) as ‘Jun 2013’,
    SUM(IF(year=2, outlay_month_10, NULL)) as ‘Jul 2013’,
    SUM(IF(year=2, outlay_month_11, NULL)) as ‘Aug 2013’,
    SUM(IF(year=2, outlay_month_12, NULL)) as ‘Sep 2013’,
    SUM(IF(year=3, outlay_month_1, NULL)) as ‘Oct 2013’,
    SUM(IF(year=3, outlay_month_2, NULL)) as ‘Nov 2013’,
    SUM(IF(year=3, outlay_month_3, NULL)) as ‘Dec 2013’,
    SUM(IF(year=3, outlay_month_4, NULL)) as ‘Jan 2014’,
    SUM(IF(year=3, outlay_month_5, NULL)) as ‘Feb 2014’,
    SUM(IF(year=3, outlay_month_6, NULL)) as ‘Mar 2014’,
    SUM(IF(year=3, outlay_month_7, NULL)) as ‘Apr 2014’,
    SUM(IF(year=3, outlay_month_8, NULL)) as ‘May 2014’,
    SUM(IF(year=3, outlay_month_9, NULL)) as ‘Jun 2014’,
    SUM(IF(year=3, outlay_month_10, NULL)) as ‘Jul 2014’,
    SUM(IF(year=3, outlay_month_11, NULL)) as ‘Aug 2014’,
    SUM(IF(year=3, outlay_month_12, NULL)) as ‘Sep 2014’,
    SUM(IF(year=4, outlay_month_1, NULL)) as ‘Oct 2014’,
    SUM(IF(year=4, outlay_month_2, NULL)) as ‘Nov 2014’,
    SUM(IF(year=4, outlay_month_3, NULL)) as ‘Dec 2014’,
    SUM(IF(year=4, outlay_month_4, NULL)) as ‘Jan 2015’,
    SUM(IF(year=4, outlay_month_5, NULL)) as ‘Feb 2015’,
    SUM(IF(year=4, outlay_month_6, NULL)) as ‘Mar 2015’,
    SUM(IF(year=4, outlay_month_7, NULL)) as ‘Apr 2015’,
    SUM(IF(year=4, outlay_month_8, NULL)) as ‘May 2015’,
    SUM(IF(year=4, outlay_month_9, NULL)) as ‘Jun 2015’,
    SUM(IF(year=4, outlay_month_10, NULL)) as ‘Jul 2015’,
    SUM(IF(year=4, outlay_month_11, NULL)) as ‘Aug 2015’,
    SUM(IF(year=4, outlay_month_12, NULL)) as ‘Sep 2015’
    FROM obligations_outlays_goals
    GROUP BY appropriation
• query to retrieve Financial Mitigation Plans for 2012
  • SELECT p.uid as project_uid, p.project_number, c.appropriation, c.center_number, c.center_name,
    CASE fmp.month WHEN 1 THEN ‘Oct 2011’ WHEN 2 THEN ‘Nov 2011’ WHEN 3 THEN ‘Dec 2011’ WHEN 4 THEN ‘Jan 2012’ WHEN 5 THEN ‘Feb 2012’ WHEN 6 THEN ‘Mar 2012’ WHEN 7 THEN ‘Apr 2012’ WHEN 8 THEN ‘May 2012’ WHEN 9 THEN ‘Jun 2012’ WHEN 10 THEN ‘Jul 2012’ WHEN 11 THEN ‘Aug 2012’ WHEN 12 THEN ‘Sep 2012’ END as month_year,
    o.type, a.amount,
    CASE fmp.month WHEN 1 THEN o.month_1 WHEN 2 THEN o.month_2 WHEN 3 THEN o.month_3 WHEN 4 THEN o.month_4 WHEN 5 THEN o.month_5 WHEN 6 THEN o.month_6 WHEN 7 THEN o.month_7 WHEN 8 THEN o.month_8 WHEN 9 THEN o.month_9 WHEN 10 THEN o.month_10 WHEN 11 THEN o.month_11 WHEN 12 THEN o.month_12 END as month_value,
    IF(o.type LIKE ‘%Obligat%’,
    CASE fmp.month WHEN 1 THEN g.obligation_month_1 * a.amount / 100 WHEN 2 THEN g.obligation_month_2 * a.amount / 100 WHEN 3 THEN g.obligation_month_3 * a.amount / 100 WHEN 4 THEN g.obligation_month_4 * a.amount / 100 WHEN 5 THEN g.obligation_month_5 * a.amount / 100 WHEN 6 THEN g.obligation_month_6 * a.amount / 100 WHEN 7 THEN g.obligation_month_7 * a.amount / 100 WHEN 8 THEN g.obligation_month_8 * a.amount / 100 WHEN 9 THEN g.obligation_month_9 * a.amount / 100 WHEN 10 THEN g.obligation_month_10 * a.amount / 100 WHEN 11 THEN g.obligation_month_11 * a.amount / 100 WHEN 12 THEN g.obligation_month_12 * a.amount / 100 END,
    CASE fmp.month WHEN 1 THEN g.outlay_month_1 * a.amount / 100 WHEN 2 THEN g.outlay_month_2 * a.amount / 100 WHEN 3 THEN g.outlay_month_3 * a.amount / 100 WHEN 4 THEN g.outlay_month_4 * a.amount / 100 WHEN 5 THEN g.outlay_month_5 * a.amount / 100 WHEN 6 THEN g.outlay_month_6 * a.amount / 100 WHEN 7 THEN g.outlay_month_7 * a.amount / 100 WHEN 8 THEN g.outlay_month_8 * a.amount / 100 WHEN 9 THEN g.outlay_month_9 * a.amount / 100 WHEN 10 THEN g.outlay_month_10 * a.amount / 100 WHEN 11 THEN g.outlay_month_11 * a.amount / 100 WHEN 12 THEN g.outlay_month_12 * a.amount / 100 END) as month_goal
    FROM project_portfolio.financial_mitigation_plans fmp,
    project_portfolio.obligations_outlays o,
    project_portfolio.projects p,
    project_portfolio.budget_centers c,
    project_portfolio.budget_amounts a,
    project_portfolio.obligations_outlays_goals g
    WHERE fmp.obligation_outlay_uid = o.uid
    AND o.project_id = p.uid
    AND p.uid = c.project_id
    AND o.funding_id = c.uid
    AND o.year = 2012
    AND o.year_count = 1
    AND a.budget_center_id = c.uid
    AND a.year = 2012 – p.begin_year + 1
    AND g.appropriation = c.appropriation
    AND g.year = 1
• query to calculate goals reached for 2012
  • SELECT p.uid, p.project_number, p.proj_mgr_login, services, p.begin_year,
    c.uid, c.center_number, c.center_name, c.appropriation,
    a.amount,
    o.uid, o.type,
    FORMAT((o.month_1 / (g.obligation_month_1 * a.amount / 100)) * 100, 2) as ‘Oct 2011’,
    FORMAT((o.month_2 / (g.obligation_month_2 * a.amount / 100)) * 100, 2) as ‘Nov 2011’,
    FORMAT((o.month_3 / (g.obligation_month_3 * a.amount / 100)) * 100, 2) as ‘Dec 2011’,
    FORMAT((o.month_4 / (g.obligation_month_4 * a.amount / 100)) * 100, 2) as ‘Jan 2012’,
    FORMAT((o.month_5 / (g.obligation_month_5 * a.amount / 100)) * 100, 2) as ‘Feb 2012’,
    FORMAT((o.month_6 / (g.obligation_month_6 * a.amount / 100)) * 100, 2) as ‘Mar 2012’,
    FORMAT((o.month_7 / (g.obligation_month_7 * a.amount / 100)) * 100, 2) as ‘Apr 2012’,
    FORMAT((o.month_8 / (g.obligation_month_8 * a.amount / 100)) * 100, 2) as ‘May 2012’,
    FORMAT((o.month_9 / (g.obligation_month_9 * a.amount / 100)) * 100, 2) as ‘Jun 2012’,
    FORMAT((o.month_10 / (g.obligation_month_10 * a.amount / 100)) * 100, 2) as ‘Jul 2012’,
    FORMAT((o.month_11 / (g.obligation_month_11 * a.amount / 100)) * 100, 2) as ‘Aug 2012’,
    FORMAT((o.month_12 / (g.obligation_month_12 * a.amount / 100)) * 100, 2) as ‘Sep 2012’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 p.begin_year + a.year – 1 = 2012
    AND p.uid = o.project_id
    AND o.year = 2012
    AND o.year_count = 1
    AND o.funding_id = c.uid
    AND g.appropriation = c.appropriation
    AND g.year = 1

Dong Shin 07.16.2012

• continue working on scripts
• VisibilityScripting still hangs on my Mac! using VisibilityScripting4
  • added sorting of scripts
  • added deleting of scripts
• changed the VisbilityScriptingServer to refresh script list
• created monthly progress report scripts for 2010, 2011, 2012
• query to get current year info for the projects
  • SELECT p.uid, p.project_number, p.proj_mgr_login, services, p.begin_year,
    c.uid, c.center_number, c.center_name, c.appropriation,
    a.amount,
    o.uid, o.type, o.month_1,
    g.obligation_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 p.begin_year + a.year – 1 = 2012
    AND p.uid = o.project_id
    AND o.year = 2012
    AND o.year_count = 1
    AND o.funding_id = c.uid
    AND g.appropriation = c.appropriation
    AND g.year = 1