Dong Shin 03.26.2014

  • deployed new views and presentation looks better!
  • few bugs
    • fix __view_financial_data – add sum and group by for year 2
    • Planned Obligations/Outlay Update SQL errors when it reaches 100% – uid, project_id, year_count are null
    • Recalculate Obligations/Outlays when Claimed/Unclaimed Contracts are updated
    • rework Query Builder!
  • bc.total_budget for Req Allocation and vct.committed_amount for Req Funded
  • downloaded and played with JSPMyAdmin – JSP based MySQL Admin tool that can run on Tomcat…. a bit slow and looks like missing lots of features compared to phpMyAdmin, not sure if I want to use it.
  • working on getting entire data for big table
    • this may be good enough?
      • SELECT *
        FROM projects p
        LEFT JOIN budget_centers bc ON bc.project_id = p.uid
        LEFT JOIN obligations_outlays oo ON oo.funding_id = bc.uid
        LEFT JOIN (SELECT project_id, GROUP_CONCAT(fiscal_year) AS fiscal_years,
        SUM(budget_amount) AS budget_amount FROM yearly_totals GROUP BY project_id) AS yt ON yt.project_id = p.uid
        LEFT JOIN (SELECT project_id, GROUP_CONCAT(login) AS financial_analysts FROM _projects_portfolio_mgrs GROUP BY project_id) AS fa ON fa.project_id = p.uid
        LEFT JOIN (SELECT project_id, GROUP_CONCAT(login) AS portfolio_managers FROM _projects_portfolio_admins GROUP BY project_id) AS pm ON pm.project_id = p.uid
        LEFT JOIN (SELECT budget_center_id, SUM(committed_amount) AS total_committed_amount, GROUP_CONCAT(committed_date) AS committed_dates
        FROM committed_amounts GROUP BY budget_center_id) AS ca ON ca.budget_center_id = bc.uid