Dong Shin 09.11.2012

  • new bugs
    • totals for sub projects still not working
    • Total Budget in Project Management panel doubles for sub projects
    • incomplete (missing Budget Center/MIPR) sub projects don’t show in the parent project
    • Funding Request selection needs to be expandable/resizable
    • Funding Request needs save confirmation on window close
    • need search capability in Database Mgmt panel
  • fixed Total Budget not showing correctly
    • use following query to find and remove duplicates
    • SELECT GROUP_CONCAT(uid) as duplicates FROM `yearly_totals` WHERE 1
      GROUP BY project_id, fiscal_year
      HAVING count(*) > 1
  • updated ChangeLogPanel in EdgeUtils and FGMFlexUtils45 to have variableRowHeight for description column
  • Funding Request select window is now expanable/resizable
  • incomplete sub projects are red in Create Project panel
  • updated query to get sub projects to include incomplete projects
    • SELECT p1.project_number AS projectID, p1.title AS projectName, p2.sub_project_id as subProjectID, p1.begin_year AS startFY, p1.end_year AS endFY, p1.total_budget AS totalBudget, p2.*,
      SUM(IF(a.year=1, a.amount, NULL)) as year1Amount,
      SUM(IF(a.year=2, a.amount, NULL)) as year2Amount,
      SUM(IF(a.year=3, a.amount, NULL)) as year3Amount,
      SUM(IF(a.year=4, a.amount, NULL)) as year4Amount,
      SUM(IF(a.year=5, a.amount, NULL)) as year5Amount,
      SUM(IF(a.year=6, a.amount, NULL)) as year6Amount,
      SUM(IF(a.year=7, a.amount, NULL)) as year7Amount,
      SUM(IF(a.year=8, a.amount, NULL)) as year8Amount,
      SUM(IF(a.year=9, a.amount, NULL)) as year9Amount,
      SUM(IF(a.year=10, a.amount, NULL)) as year10Amount
      FROM projects p1, _project_sub_projects p2, budget_centers c, budget_amounts a
      WHERE p2.project_id = 177 AND p2.sub_project_id = p1.uid  AND c.project_id = p2.sub_project_id  AND c.uid = budget_center_id  GROUP BY c.project_id
      UNION
      SELECT p1.project_number AS projectID, p1.title AS projectName, p2.sub_project_id as subProjectID, p1.begin_year AS startFY, p1.end_year AS endFY, p1.total_budget AS totalBudget, p2.*,
      0 as year1Amount,
      0 as year2Amount,
      0 as year3Amount,
      0 as year4Amount,
      0 as year5Amount,
      0 as year6Amount,
      0 as year7Amount,
      0 as year8Amount,
      0 as year9Amount,
      0 as year10Amount
      FROM projects p1, _project_sub_projects p2
      WHERE p2.project_id = 177 AND p2.sub_project_id = p1.uid  AND p2.sub_project_id NOT IN
      (SELECT c.project_id FROM budget_centers c)

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.