Category Archives: Dong Shin

Dong Shin 04.29.2011

  • PPM Changes
    • Fixed Excel export error cause by wrong project ID in Generate Emails for selected projects
    • changed Description in Funding Request to TextArea from TextInput – vertical scroll bar still appears for lines more than 4
    • Fixed errors creating Funding Request – Project ID not set
    • Fixed a bug showing Export Multiple button on a single project

Dong Shin 04.28.2011

  • working at home
  • PPM Changes
    • additional fields for Funding Request to support Financial Status
      • comments, initiate_commit, PM_actual_outlay, MIPR_requested_date, MIPR_request_received_date, acceptance_received, received_contract, monthly_tech_report – ALTER TABLE `funding_requests` ADD `comments` LONGTEXT NULL DEFAULT NULL,ADD `initiate_commit` DOUBLE NULL DEFAULT NULL,ADD `PM_actual_outlay` DOUBLE NULL DEFAULT NULL,ADD `MIPR_requested_date` DATE NULL DEFAULT NULL,ADD `MIPR_request_received_date` DATE NULL DEFAULT NULL,ADD `acceptance_received` DATE NULL DEFAULT NULL,ADD `received_contract` DATE NULL DEFAULT NULL,ADD `monthly_tech_report` DATE NULL DEFAULT NULL
    • modified FianancialStatusData to work with the new table structure

Dong Shin 04.25.2011

  • PPM Changes
    • trouble-shooting search on Contracts Window
      • throws exception at very same place every time
      • Error: Error #2006: The supplied index is out of bounds.
      • description about N66001-03-D-7002
      • added try catch, still throws exceptions, but behaves better……
    • removed Amount in Contracts sections in Excel export – keep Contract Amount
    • added SOW Window to view and edit long SOW’s for Funding Request

Dong Shin 04.22.2011

  • Went over the bugs list in the blog, updated status of fixed ones
  • More memory on FGMDEV!
  • PPM Changes
    • Period of Performance Dates and Obligation Date Deadline not required
    • DateFields can be cleared by Control-Click on the same date
    • added columns to search on Contracts window
    • added toolTips to Contracts Window
    • set the ContractsDataGrid’s max rowCount to 20
    • added AmountTextInput for Contract Amount

Dong Shin 04.21.2011

  • PPM Changes
    • added FY, Description, Appropriation, Funding Type to Funding Request Select window
    • removed contract checking on Direct Cites so that contracts are not required and can be added/changed later
    • fixed a bug Outlay Amount not showing up correctly in Direct Cites
    • Project Information (Project Number, Title, Budget) added to Funding Request

Dong Shin 04.13.2011

  • working on SQL queries to retrieve the financial data via scripting interface… This query will retrieve all financial data with calculated goals value and checks if data is less than the goals
    • SELECT p.uid as 'Project ID', p.project_number, b.uid as 'Budget Center ID', b.center_number,
b.appropriation, a.uid, a.year, a.amount, o.uid, o.year_count, o.month_1, o.year, o.type,
IF (o.type like '%Outlay%', (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100) as goal_month_1,
IF (o.month_1 < IF (o.type like '%Outlay%', (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100), 'FLAG', 'OK') as flag_month_1,

IF (o.type like '%Outlay%', (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100) as goal_month_2,
IF (o.month_2 < IF (o.type like '%Outlay%', (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100), 'FLAG', 'OK') as flag_month_21,

IF (o.type like '%Outlay%', (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100) as goal_month_3,
IF (o.month_3 < IF (o.type like '%Outlay%', (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100), 'FLAG', 'OK') as flag_month_3,

IF (o.type like '%Outlay%', (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100) as goal_month_4,
IF (o.month_4 < IF (o.type like '%Outlay%', (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100), 'FLAG', 'OK') as flag_month_4,

IF (o.type like '%Outlay%', (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100) as goal_month_5,
IF (o.month_5 < IF (o.type like '%Outlay%', (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100), 'FLAG', 'OK') as flag_month_5,

IF (o.type like '%Outlay%', (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100) as goal_month_6,
IF (o.month_6 < IF (o.type like '%Outlay%', (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100), 'FLAG', 'OK') as flag_month_6,

IF (o.type like '%Outlay%', (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100) as goal_month_7,
IF (o.month_7 < IF (o.type like '%Outlay%', (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100), 'FLAG', 'OK') as flag_month_7,

IF (o.type like '%Outlay%', (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100) as goal_month_8,
IF (o.month_8 < IF (o.type like '%Outlay%', (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100), 'FLAG', 'OK') as flag_month_8,

IF (o.type like '%Outlay%', (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100) as goal_month_9,
IF (o.month_9 < IF (o.type like '%Outlay%', (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100), 'FLAG', 'OK') as flag_month_9,

IF (o.type like '%Outlay%', (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100) as goal_month_10,
IF (o.month_10 < IF (o.type like '%Outlay%', (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100), 'FLAG', 'OK') as flag_month_10,

IF (o.type like '%Outlay%', (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100) as goal_month_11,
IF (o.month_11 < IF (o.type like '%Outlay%', (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100), 'FLAG', 'OK') as flag_month_11,

IF (o.type like '%Outlay%', (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100) as goal_month_12,
IF (o.month_12 < IF (o.type like '%Outlay%', (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100), 'FLAG', 'OK') as flag_month_12

FROM projects p, budget_centers b, budget_amounts a, obligations_outlays o, obligations_outlays_goals g
WHERE p.uid = b.project_id AND b.uid = a.budget_center_id AND b.uid = o.funding_id
AND b.appropriation = g.appropriation AND g.year = year_count AND a.year = g.year
ORDER BY b.uid, a.year, o.year

Dong Shin 04.11.2011

  • Demo’ed and went over high-level architectures of Visibility and PPM with Sophia
  • PPM
    • bugs found when I was going over PPM with Sophia
      • exceptions thrown at Create Financial Data Request – fixed
      • Project Delete stuck in endless loop – fixed
    • Exporting contract to XLS files – working! more testing needed

Dong Shin 04.05.2011

  • PPM
    • found that Portfolio Manage (NSA) is misspelled, Porfolio Manager. DB update is necessary
      • UPDATE `project_portfolio`.`users` SET `type` = 'Portfolio Manager (NSA)' WHERE type = 'Porfolio Manager (NSA)'
    • continue working on Roles Management
      • User.isNSAmanager(), User.isAdmin(), User.isSiteUser() added
      • Admin > NSA Manager > Site User
      • Top menu modified accordingly
        • Admins have all privileges
        • NSA Managers have no User Management, DB Management, Appropriation Mgmt
        • Site Users have no user assignment, create projects, copy projects in addition to the NSA Managers’ incapabilites
      • Project selection modified to fit the Roles Mgmt (Financial Data, Funding Request, etc)

Dong Shin 04.01.2011

  • fixed IngestManager crashing on empty list of files
  • Ingest fails on some SQL error, but reporting Success – need to look into this
  • created project data and ingested using VisibilityScriptingServer (projects.py) and IngestManager
  • created project budget information (project_budgets.py)
  • created project goals information (project_goals.py)
  • FMGDEV crashing (twice today!)….
    • Nexus crashed on low memory and would not start
    • stop lampp first to release the memory(?), start Nexus and restart lampp…..