Dong Shin 08.16.2013

  • continue working on FA4/RA
    • all components in Dynamic Panel must be wrapped in <s:Scroller /> to resize properly!
    • going through the list from yesterday’s meeting
      • removed Projects View
      • created FilterableDGSpark for Spark DataGrid
      • reworking to get status from three row types instead of all row types (Obligation Outlay Types)
    • database update!
      • ALTER TABLE `obligation_outlay_types` CHANGE `type` `type` VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
      • ALTER TABLE `obligation_outlay_types` ADD `status` TINYINT NULL DEFAULT NULL ;
    • query to get OVERDUE requisitions
      • SELECT ‘DUE’ AS status, funding_id, c.* FROM (
        SELECT funding_id FROM (
        SELECT * FROM (
        SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_1)
        AND (o.type in (SELECT `type` FROM obligation_outlay_types WHERE status = 1 ))
        GROUP BY year, year_count, funding_id
        UNION
        SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_2)
        AND (o.type in (SELECT `type` FROM obligation_outlay_types WHERE status = 1 ))
        GROUP BY year, year_count, funding_id
        AND (o.type in (SELECT `type` FROM obligation_outlay_types WHERE status = 1 ))
        GROUP BY year, year_count, funding_id
        ) AS q WHERE null_count = (SELECT COUNT(*) FROM obligation_outlay_types WHERE status = 1) ) AS t ) AS t2
        LEFT JOIN budget_centers c ON t2.funding_id = c.uid