Dong Shin 07.30.2012

  • continue working on Total datagrids for Create Project
    • query to get sub project totals
      • SELECT p.begin_year, p.end_year, t.project_id, t.fiscal_year, SUM(budget_amount)
        FROM projects p, yearly_totals t
        WHERE p.uid = 101
        AND
        project_id IN
        (SELECT sub_project_id
        FROM _project_sub_projects
        WHERE project_id = 101)
        GROUP BY fiscal_year
    • finished up – will try to deploy tomorrow
  • fixed a bug not showing parent/children projects correctly in Create Project panel