Dong Shin 07.16.2012

  • continue working on scripts
  • VisibilityScripting still hangs on my Mac! using VisibilityScripting4
    • added sorting of scripts
    • added deleting of scripts
  • changed the VisbilityScriptingServer to refresh script list
  • created monthly progress report scripts for 2010, 2011, 2012
  • query to get current year info for the projects
    • SELECT p.uid, p.project_number, p.proj_mgr_login, services, p.begin_year,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.amount,
      o.uid, o.type, o.month_1,
      g.obligation_month_1
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o,
      obligations_outlays_goals g
      WHERE p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year – 1 = 2012
      AND p.uid = o.project_id
      AND o.year = 2012
      AND o.year_count = 1
      AND o.funding_id = c.uid
      AND g.appropriation = c.appropriation
      AND g.year = 1