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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.