Dong Shin 02.01.2011

  • PPM Changes
    • fixed User Management TextInputs and set User object not updating Save button
    • adding Financial Status information to budget_centers table
      • back up – budget_amounts_org
      • ALTER TABLE `budget_amounts` ADD `MIPR_requested_date` DATE NULL DEFAULT NULL ,
        ADD `MIPR_request_received_date` DATE NULL DEFAULT NULL ,
        ADD `submitted_to_BABF` DATE NULL DEFAULT NULL ,
        ADD `document_number` VARCHAR( 255 ) NULL DEFAULT NULL ,
        ADD `certified_date` DATE NULL DEFAULT NULL ,
        ADD `received_contract_date` DATE NULL DEFAULT NULL ,
        ADD `initiate_commit` DOUBLE NULL DEFAULT NULL ,
        ADD `obligation` DOUBLE NULL DEFAULT NULL ,
        ADD `outlay` DOUBLE NULL DEFAULT NULL ,
        ADD `pm_actual_outlay` DOUBLE NULL DEFAULT NULL ,
        ADD `monthly_tech_report_date` DATE NULL DEFAULT NULL ,
        ADD `comments` TEXT NULL DEFAULT NULL
      • grabbing data from all related tables…
      • SELECT r.funding_type, r.description, r.funding_amount, r.document_number, c.contract_number, c.name as contractor_name, c.location as contractor_location, b.center_number, a.amount
        FROM funding_requests r
        LEFT JOIN direct_cites d ON r.uid = d.funding_request_id
        LEFT JOIN contracts c ON d.contract_id = c.uid
        LEFT JOIN budget_centers b on r.project_id = b.project_id
        LEFT JOIN budget_amounts a on b.uid = a.budget_center_id
        WHERE b.project_id = 96
    • working on saving Financial Status Data from the Form Entry