Dong Shin 10.18.2011

  • attempt to deploy new PPM and PPM Widget
    • start up query that retrieves project status takes to long – 145,000 records in __view_financial_data_status_view
    • remove default (debug) login
    • show status of query
    • Font size increase messed up PPM
    • Data Window in DB Table Mgmt needs scroller
  • added Alert to ask user to view project status up on login
  • added user information on top
  • added debugUser information to setupModel.xml
  • modified query to retrieve the projects status
    • 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_1)
      AND (o.year + o.year_count – 1) = 2012), ‘OVERDUE’, ‘CURRENT’)
      AS status FROM obligations_outlays o, projects p

      WHERE o.project_id = p.uid
      AND (o.year + o.year_count – 1) = 2012
      AND (proj_mgr_login = ‘annaleese’ OR p.uid in (SELECT project_id FROM
      _projects_service_project_mgrs WHERE login = ‘annaleese’))
      GROUP by p.uid