Dong Shin 11.07.2011

  • Meeting with Tangi, found minor bugs
    • Goals should be disabled
    • format % values to 2 decimals
    • disable current button where FY is not available
  • changed ProjectFilterButtonBar skins to reflect the query
  • updated ItemRenderer to show INCOMPLETE
  • query to find OVERDUE, INCOMPLETE, CURRENT status of the projects
    • SELECT p.*,
      IF(p.uid IN (
      SELECT p.uid FROM obligations_outlays o, projects p
      WHERE o.project_id = p.uid
      AND ISNULL(o.month_2)
      AND (o.year + o.year_count – 1) = 2012),
      ‘OVERDUE’,
      (IF
      (p.uid in (SELECT p.uid FROM obligations_outlays o, projects p WHERE o.project_id = p.uid AND
      (o.year + o.year_count – 1) < 2012
      AND
      (ISNULL(o.month_1) OR
      ISNULL(o.month_2) OR
      ISNULL(o.month_3) OR
      ISNULL(o.month_4) OR
      ISNULL(o.month_5) OR
      ISNULL(o.month_6) OR
      ISNULL(o.month_7) OR
      ISNULL(o.month_8) OR
      ISNULL(o.month_9) OR
      ISNULL(o.month_10) OR
      ISNULL(o.month_11) OR
      ISNULL(o.month_12)
      )
      UNION
      SELECT p.uid FROM obligations_outlays o, projects p WHERE o.project_id = p.uid AND
      (o.year + o.year_count – 1) < 2012
      AND (ISNULL(o.month_1) OR ISNULL(o.month_2))
      ), ‘INCOMPLETE’,’CURRENT’))

      ) AS status

      FROM obligations_outlays o, projects p
      WHERE o.project_id = p.uid  AND (o.year + o.year_count – 1) = 2012
      GROUP by p.uid