Dong Shin 08.12.2014

  • working on adding Planned Baseline rows
    • added Planned Obligation Baseline: and Planned Outlay Baseline: to obligation_outlay_types table
      • INSERT INTO `project_portfolio_enh`.`obligation_outlay_types` (`uid`, `type`, `visible`, `status`) VALUES (NULL, ‘Planned Obligation Baseline:’, NULL, NULL), (NULL, ‘Planned Outlay Baseline:’, NULL, NULL);
    • add Planned Obligation/Outlay Baseline rows for existing data
      • INSERT INTO obligations_outlays
        (type, year, year_count, project_id, funding_id)
        (SELECT ‘Planned Obligation Baseline:’, year, year_count, project_id, funding_id FROM `obligations_outlays`
        GROUP BY funding_id, year_count) UNION ALL
        (SELECT ‘Planned Outlay Baseline:’, year, year_count, project_id, funding_id FROM `obligations_outlays`
        GROUP BY funding_id, year_count);
    • update visible in obligation_outlay_types so only Admins and NSA PM’s can see the planned baseline rows
      • UPDATE obligation_outlay_types SET visible = 0;
        UPDATE obligation_outlay_types SET visible = 1 WHERE type <> ‘Planned Obligation Baseline:’
        AND type <> ‘Planned Outlay Baseline:’;
    • added visible flag to getFinancialData
  • back up current database – project_portfolio_enh_081214, cleaned up databases….