Dong Shin 02.11.2013

  • bugs
    • Replace “next incomplete record” tooltip with “next record”
    • Add text following “x of y” at the bottom left to indicate what is being stepped through
    • Take a look at users table cascading problem
    • Create a script that deletes all contracts that are not being used
      • RemoveUnusedContracts.sql in PPM
  • Flash Builder 4.6 has been crapping out on me past months continuously giving me various run time errors, ugh! – downloading 4.7 (1GB!) – working better but waiting for a license from Adobe (free upgrade from 4.5, 4.6)
  • working on queries to retrieve committed (Funded Budget) for PA
    • SELECT bc.*, (SELECT commit
      FROM _funding_requests_budget_centers frbc, funding_requests fr, budget_centers bc
      WHERE frbc.funding_request_id = fr.uid
      AND frbc.budget_center_id = bc.uid AND bc.uid = 18)
      FROM budget_centers bc
      WHERE bc.uid = 18
  • working on queries to retrieve contracts for PA
    • SELECT GROUP_CONCAT(c.contract_number)
      FROM _funding_requests_contracts frc, funding_requests fr, contracts c, projects p
      WHERE frc.funding_request_id = fr.uid
      AND c.uid = frc.contract_id
      AND fr.project_id = p.uid
      AND p.uid = 193
      GROUP BY fr.uid