Category Archives: Dong Shin

Dong Shin 05.22.2013

  • continue working on FA/RA
    • working down the bug list
      • fixed Budget not showing properly when saved as new
      • fixed Project Budget Info not selecting previously selected data
      • fixed FACTS PE not setting correctly
      • fixed Total Budget / Total Allocated not showing correctly in Project Mgmt Panel
      • fixed Sub Projects Budget calculation
      • added additional information to the sub projects panel (total, funded, unfunded, available)

Dong Shin 05.21.2013

  • deployed new FA and RA, found few problems
    • When Update is clicked and not all fields are filled in, we might what to pop up a dialog box saying that they are not all filled in but allowing for a save
    • Add tooltips to buttons. In particular, we need to be clear about what saves and what cancels without saving.
    • Add a “Select All” to the SQL error dialog, now that we have QUERIES FROM HELL.
    • RA error string: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExceptio: Unknown column ‘c.appropriation’ in ‘where clause’.
  • Continue working on FA/RA
    • setting up relations between projects, budget_centers, obligations_outlays tables
      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio_enh`.`projects` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
        ALTER TABLE `obligations_outlays` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio_enh`.`projects` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
        ALTER TABLE `obligations_outlays` ADD FOREIGN KEY ( `funding_id` ) REFERENCES `project_portfolio_enh`.`budget_centers` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
    • found that saving “new” project doesn’t create obligations/outlays data correctly – fixed

Dong Shin 05.20.2013

  • continue working on FA/RA
    • removed unecessary columns from budget_centers table
      • ALTER TABLE `budget_centers`
        DROP `center_number`,
        DROP `center_name`,
        DROP `capability`,
        DROP `expenditure_center`,
        DROP `investment_portfolio`,
        DROP `appropriation`,
        DROP `program_element`,
        DROP `facts_pe`;
    • working down the bug list from Lenny
      • save Requisition allows empty date fields
      • reworking Copy Project
        • removed Project menu items – more confusing
        • created stored procedure – copy_budget_centers, to copy all requisition and obligations/outlays data

Dong Shin 05.17.2013

  • continue working on RA/FA
    • working on Financial Data Editor
      • got filtering to work
      • editor works!
    • need to update the projects to have correct appropriations – done
    • cleaning up previous project budget/requistion information….

Dong Shin 05.15.2013

  • continue working on FA/RA
    • added POC filter for adding service POC’s to Req’s
    • filter Requisitions List in RA per assigned Service POC’s to the Req’s
    • working on getting status for Req’s – done!
      • query to find Overdue, Due, Current Req’s
        • SELECT * FROM (
          SELECT ‘CURRENT’ AS status, c.* FROM budget_centers c WHERE uid NOT IN (
          SELECT funding_id 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) 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) 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_3) 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_4) 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_5) 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_6) GROUP BY year, year_count, funding_id
          ) AS t)
          UNIONSELECT ‘DUE’ AS status, c.* FROM budget_centers c WHERE uid IN (
          SELECT funding_id 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) GROUP BY year, year_count, funding_id
          ) AS t)
          AND uid NOT IN (
          SELECT funding_id 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) 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) 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_3) 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_4) 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_5) 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_6) GROUP BY year, year_count, funding_id
          ) AS t)

          UNION

          SELECT ‘OVERDUE’ AS status, c.* FROM budget_centers c WHERE uid IN (
          SELECT funding_id 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) 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) 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_3) 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_4) 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_5) 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_6) GROUP BY year, year_count, funding_id
          ) AS t
          )
          ) AS t2 ORDER BY uid

Dong Shin 05.14.2013

  • continue working on RA/FA
    • converting FilterableDG and associated components in FGMFlexUtils45 to spark components…. – done
    • got Requisition data list to display in RA
    • working on getting status for the Req Data

Dong Shin 05.13.2013

  • continue working on FA/RA
    • Degrafa 3 (Maven) is not compatible with Flex 4
      • download news one at https://degrafa.googlecode.com/files/DegrafaFlex4.swc
    • got User Management Panel to work
    • working on Budget Center / Requisition View in RA
    • moved FilterableDG components to EdgeUtils and FGMFlexUtils45 from FA

Dong Shin 05.10.2013

  • discussed with Phil about new database layout for FA/PA/RA….
  • continue working on FA/RA(Req Assistant)
    • converting Financial Assistant to Flex 4.6
      • mix of 3.5 and 4.6 results  in weird compile errors
      • converted EdgeUtils to Flex 4.6

Dong Shin 05.09.2013

  • VizTool meeting at Fort
    • lots of notes – at Phil’s blog
  • continue working on FA
    • working on Users (Service POCs) for Req’s – done!
      • created table, _budget_centers_users to map Req’s and users
        • CREATE TABLE IF NOT EXISTS `_budget_centers_service_pocs` (
          `budget_center_id` int(11) NOT NULL,
          `login` varchar(255) NOT NULL,
          PRIMARY KEY (`budget_center_id`,`login`)
          ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
      • added AddServicePOCWindow
  • created new project – ReqAssistant – copy from Project Assistant for FA

Dong Shin 05.06.2013

  • continue working on FA
    • got Project Viewer panel to display the financial data correctly – only the years the Req Data falls in
    • fixed new project saving error
  • tested freshly built VSS server and client
    • null exception for _selectedSQLObject – fixed

Dong Shin 05.03.2013

  • deployed new FA – few problems..
    • creating new Project results in SQL error fixed
      • INSERT INTO projects …. – Column count doesn’t match!
    • Sub Budget Center Name & Number not working correctly fixed
    • Un-Funded Amount = Req Amount – Funded (calculated, non-editable) – done
      • removed unfunded_amount from budget_centers table
    • Req Type should be non-addable in the combobox done
      • MIPR, REQ, EA, RTA, and EAO
    • Upload Data should delete row 1 and last two lines from the excel spreadsheet
  • built VSS and associated libs for more testing as we got weird errors on-site this morning

Dong Shin 05.02.2013

  • continue working on FA
    • obligations/outlays data updates with fiscal_year from budget_centers
    • getting View Financial Data to work with new database
      • updated Project Editor to keep appropriation in budget_centers table
      • updated Budget Information datagrid with new Req Data structure
  • burned a CD for deployment tomorrow