Dong Shin 08.27.2012

  • updated database on site for 2013 data
  • fixed Project deletion errors by removing foreign keys on _projects_portfolio_admins table
  • Jessica reported
    • Funding Request Save errors – suspecting some invalid characters, but could not resolve it over the phone. more information needed
    • Total Allocated Budget is needed in addition to the Total Budget – added to Project Management Panel
      • SELECT p.*, p.uid as ID, p.project_number as ‘Project ID’, p.title as ‘Project Name’, begin_year as ‘Start FY’, end_year as ‘End FY’, begin_year as startYear, IF(ISNULL(lock_id), if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’),
        IF (lock_id=’projportfolio’, if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), ‘LOCKED’)) as Status,
        (end_year – begin_year) as duration, services, p.total_budget as ‘Total Allocated’, sub.project_id as parent_project_id, sub.sub_project_id,
        SUM(IF(ISNULL(t.budget_amount), 0, t.budget_amount)) as ‘Total Budget’
        FROM projects p
        LEFT JOIN _project_sub_projects as sub ON p.uid = sub_project_id
        LEFT OUTER JOIN yearly_totals AS t ON p.uid = t.project_id
        GROUP BY p.uid