Dong Shin 01.09.2014

  • Phil found that RA takes too long to retrieve the list of Req’s
    • looked at various MySQL configurations – will try my-large.ini or my-huge.ini tomorrow (xampp/mysql)
  • working on queries for reports
    • now I have the goals, committed, obligation/outlay, PM actuals!
    • get goals matching project’s appropriation
      • SELECT p.*, bc.*,
        (bc.funded_budget * obligation_month_1 / 100) as month_1,
        (bc.funded_budget * obligation_month_2 / 100) as month_2,
        (bc.funded_budget * obligation_month_3 / 100) as month_3,
        (bc.funded_budget * obligation_month_4 / 100) as month_4,
        (bc.funded_budget * obligation_month_5 / 100) as month_5,
        (bc.funded_budget * obligation_month_6 / 100) as month_6,
        (bc.funded_budget * obligation_month_7 / 100) as month_7,
        (bc.funded_budget * obligation_month_8 / 100) as month_8,
        (bc.funded_budget * obligation_month_9 / 100) as month_9,
        (bc.funded_budget * obligation_month_10 / 100) as month_10,
        (bc.funded_budget * obligation_month_11 / 100) as month_11,
        (bc.funded_budget * obligation_month_12 / 100) as month_12,
        (bc.funded_budget * outlay_month_1 / 100) as outlay_month_1,
        (bc.funded_budget * outlay_month_2 / 100) as outlay_month_2,
        (bc.funded_budget * outlay_month_3 / 100) as outlay_month_3,
        (bc.funded_budget * outlay_month_4 / 100) as outlay_month_4,
        (bc.funded_budget * outlay_month_5 / 100) as outlay_month_5,
        (bc.funded_budget * outlay_month_6 / 100) as outlay_month_6,
        (bc.funded_budget * outlay_month_7 / 100) as outlay_month_7,
        (bc.funded_budget * outlay_month_8 / 100) as outlay_month_8,
        (bc.funded_budget * outlay_month_9 / 100) as outlay_month_9,
        (bc.funded_budget * outlay_month_10 / 100) as outlay_month_10,
        (bc.funded_budget * outlay_month_11 / 100) as outlay_month_11,
        (bc.funded_budget * outlay_month_12 / 100) as outlay_month_12
        FROM projects p
        LEFT JOIN budget_centers AS bc ON p.uid = bc.project_id
        LEFT JOIN obligations_outlays_goals AS oo ON p.appropriation = oo.appropriation
        WHERE oo.year = 1 AND bc.fiscal_year = IF(MONTH(CURDATE()) < 10, YEAR(CURDATE()), YEAR(CURDATE()) + 1)