Dong Shin 09.24.2013

  • working on Query Builder
    • added ProgressBar to the Query Builder Panel
    • added req totals view
      • CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_req_totals` AS select `budget_centers`.`req_id` AS `req_id`,sum(`budget_centers`.`funded_budget`) AS `req_id_total` from `budget_centers` group by `budget_centers`.`req_id`;
    • added % values to the queries…
      • capability, bcc.budget_center_name AS ‘Budget Center Name’, bcc.budget_center AS ‘Budget Center’, req_id AS ‘Req ID’, vrt.req_id_total AS ‘Total’,
        CONCAT(obligation_month_12,’%’) AS ‘Obligation Goal Percent’,
        CONCAT(IF(o.type = ‘Reported FACTS Obligated $:’,month_12/vrt.req_id_total*100,0),’%’) AS ‘Obligated Value Percent’
        WHERE capability = ‘ACC’
        GROUP BY bcc.budget_center, req_id
  • Sub Projects are back!
    • reworked Project Editor panel to show Sub Project