Dong Shin 08.08.2012

  • changed VisibilityScripting4 to embed AS3Dictionary.xml and SmartEditor.css
  • fixed FlexUtils not showing Compilation Date correctly
  • working on users’ project status script…
    • query to return all project mgrs with overdue data
      • created CurrentMonthOverdueUsers.py – in VS4 resources/scripts directory
      • SELECT m.login as user_login, p.project_number, p.description, a.amount, 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, _projects_service_project_mgrs m
        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 = m.project_id
        UNION
        SELECT p.proj_mgr_login as user_login, p.project_number, p.description, a.amount, 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 NOT ISNULL(p.proj_mgr_login)