Dong Shin 08.06.2010

  • spent all morning putting together the new Fianancial Data components for Progress Bar updates…
  • eliminate multiple queries for retrieving Budget Center information
    • SELECT SUM(case WHEN year=1 then amount else 0 end) as year1, SUM(case WHEN year=2 then amount else 0 end) as year2, SUM(case WHEN year=3 then amount else 0 end) as year3, b.* FROM budget_centers b, budget_amounts ba, appropriations a WHERE b.uid = ba.budget_center_id and project_id =1 AND a.type = b.appropriation group by b.uid
    • cannot use this because the dynamic nature of FYAmounts!!!
  • working on retrieval of Financial Data