Dong Shin 08.07.2012

  • added “No Email” for the users with no email address when generating Financial Data Request
  • removed EdgeUtils from VisibilityScripting4
  • working on query to generate user, project, description, status, and month (for the last 4 months maybe?) as rows
    • query to extract current year and fiscal month
      • SELECT DATE_FORMAT(CURRENT_DATE(), ‘%Y’) as year,
        IF(DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 < 1,
        DATE_FORMAT(CURRENT_DATE(), ‘%m’) + 3, DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 ) as month
    • query to find missing August entries
      • SELECT p.begin_year, a.*, o.uid, o.type, o.year, o.year_count,
        o.month_11 as ‘Aug’
        FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o
        WHERE p.uid = c.project_id
        AND a.budget_center_id = c.uid
        AND a.year = 2012 – p.begin_year + 1
        AND o.project_id = p.uid
        AND o.funding_id = c.uid
        AND o.year + o.year_count – 1 = 2012
        AND o.year_count = 1
        AND ISNULL(o.month_11)
        AND p.uid = 99