Category Archives: Dong Shin

Dong Shin 07.13.2012

  • worked with Phil on site generating Monthly Financial Data status for Jessica
  • got sample data generator from Phil , generated some data, ingested it
    • changed the code to remove spaces between commas that cause Ingest Manager to prepend ‘-‘
  • started working on queries for the briefing next week

Dong Shin 07.12.2012

  • new version of PPM and PA deployed
    • need a way to tell the version of database install/configuration (new table?)
    • some issues
  • weekly status meeting
  • Tangie was having problem finding funding requests that she put in… Need some filtering
  • worked on queries for Jessica

Dong Shin 07.11.2012

  • bugs – not deleting Funding Requests when a project is deleted
    • sounds like database set up is not up-to-date, will check on-site tomorrow
  • PPM
    • corrected all database scripts to use project_portfolio
  • PA
    • configurable columns display – done
    • database update – added visible column in obligation_outlay_types table, FACTS set to invisible
      • ALTER TABLE `obligation_outlay_types` ADD `visible` BOOLEAN NULL DEFAULT NULL;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =1;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =2;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =3;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =4;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =5;
        UPDATE `obligation_outlay_types` SET `visible` = ‘0’ WHERE `obligation_outlay_types`.`uid` =6;

Dong Shin 07.10.2012

  • Meeting with Jessica on reports – lots of notes
  • PPM’s Create Project Panel has gray for non-editable, white for editable in datagrids
  • quick fix to hide FACTS data from users in PA
  • started working on configurable data display for PA

Dong Shin 07.02.2012

  • added Vis Tool Wish List to the PPM Requirememts page
  • PPM bug fixes
    • removed Close button and Cancel Button in Financial Mitigation Plan window (forces save so that it can be retrieved and added later)
    • invoices can be opened for PM Actuals Outlays onlye (double click)
    • disabled invalidHandler in FundingRequestForm
    • filter works in DBMgmtPanel
    • Project Comments returned in descending date_time order
    • set cascading for all _projects users tables

Dong Shin 06.29.2012

  • SSP meeting @ Fort
  • Bugs
    • all _projects* tables need to have cascade set – added to the bugs page
  • trouble shooting Yearly Totals DataGrid rendering problem….
    • Doh! can’t have uid in value objects!!!!! it’s reserved!!!!

Dong Shin 06.28.2012

  • Weekly status meeting at Fort
  • Deployed the latest PPM
    • last login not working – test with auto login disabled
  • Bugs
    • Financial Mitigation Plans cannot be opened for previous entries when skipped
    • Invoices cannot be opened
    • filter not working in Database Mgmt panel
    • sometimes Funding Request Save button not enabled
  • continue working on Total Budgets – done!
    • changed YearlyTotalDataGrid to AdvancedDataGrid for styleFunction
    • rearranged columns
      • budget gets stored in database
      • allocated calculated from total
      • available = budget – allocated
  • updated requirements/bugs page

Dong Shin 06.27.2012

  • continue working on Project Totals display
    • insert/update queries..
    • save / update / retrieve working
  • added filtering for Sub Project selection window
    • filter on Project ID and Project Name
    • adjusted sub project selection queries to find the start and end year that falls within the parent
      • SELECT uid, project_number as projectID, title as projectName, begin_year as startFY,
        end_year as endFY, total_budget as totalBudget, 0 as isSelected
        FROM projects
        WHERE uid NOT IN (SELECT project_id FROM _project_sub_projects)
        AND uid NOT IN (SELECT sub_project_id FROM _project_sub_projects)
        AND begin_year >= (SELECT begin_year FROM projects WHERE uid = 102)
        AND end_year <= (SELECT end_year FROM projects WHERE uid = 102)
        AND uid <> 102
  • helped Phil building PPM
    • need to change Flex Project settings…

Dong Shin 06.26.2012

  • working on Project Totals display
    • need new table – yearly_totals
      • # create new table yearly_totals
        CREATE TABLE `yearly_totals` (
        `uid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        `project_id` INT NOT NULL ,
        `fiscal_year` INT NOT NULL ,
        `allocated_amount` DOUBLE NOT NULL ,
        INDEX ( `project_id` )
        ) ENGINE = InnoDB;ALTER TABLE `yearly_totals` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio`.`projects` (
        `uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
    • created DataGrid to display the yearly totals

Dong Shin 06.22.2012

  • fixed SQL error when apostrophe(‘) is present in Funding Request fields
  • fixed disappearing Labels for the horizontal navigator (Data and Chart) in Financial Data (Monthly Data) panel
  • track last login – added server code to update users, last_login column to user table
  • working on sub/parent projects navigation…
    • removed ProjectBudgetWindow for sub projects, replaced it with Project Editor when double-clicking
    • added yearly budget details for sub projects
    • query to retrieve all funding summary
      • SELECT p1.project_number AS projectID, p1.title AS projectName, p1.begin_year AS startFY, p1.end_year AS endFY, p1.total_budget AS totalBudget, p2 . *, c.*,
        SUM(IF(a.year=1, a.amount, NULL)) as year1Amount,
        SUM(IF(a.year=2, a.amount, NULL)) as year2Amount,
        SUM(IF(a.year=3, a.amount, NULL)) as year3Amount,
        SUM(IF(a.year=4, a.amount, NULL)) as year4Amount,
        SUM(IF(a.year=5, a.amount, NULL)) as year5Amount,
        SUM(IF(a.year=6, a.amount, NULL)) as year6Amount,
        SUM(IF(a.year=7, a.amount, NULL)) as year7Amount,
        SUM(IF(a.year=8, a.amount, NULL)) as year8Amount,
        SUM(IF(a.year=9, a.amount, NULL)) as year9Amount,
        SUM(IF(a.year=10, a.amount, NULL)) as year10Amount
        FROM projects p1, _project_sub_projects p2, budget_centers c,
        budget_amounts a
        WHERE p2.project_id =99
        AND p2.sub_project_id = p1.uid
        AND c.project_id = p2.sub_project_id
        AND c.uid = budget_center_id
        GROUP BY c.project_id

Dong Shin 06.20.2012

  • fixed a bug not copying Financial Mitigation Plans properly on Duplicate Projects
    • server code changed
    • DBUpdateSQLs06202012.sql for database update
  • changed Copy Project to Copy Project Config to eliminate confusion with Duplicate Project
  • added Duplicate Project menu item to the main menu
  • changed FundingRequest selection to AdvancedDataGrid to have multiple columns sorting capability
  • working on filtering Funding Request