Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 11.19.2014

  • modifying __view_project_detailed_data to use the REGEXP for po_reference column – done
  • working on Direct Cite/Reimbursable queries..
  • created scripts to start project_portfolio_enh database (bare minimum to start up)
    • src/resources/database/project_portfolio_enh_inserts.sql
    • src/resources/database/new_project.sql
    • src/resources/database/project_enh.111914.philsdata.zip
    • src/resources/database/project_portfolio_enh_clean.sql
  • missing Appropriations in server side Reqonciler Processing, this may have caused incorrect mapping of the COGNOS summary data for Outlays?
    • put back in ContractParser.java

Dong Shin 11.18.2014

  • working on master table to include required fields for Direct Cite/Reimbursable processing
    • query to summarize Direct Cite/Reimbursable
    • SELECT GROUP_CONCAT(requisition_id),
      MAX(obligation_date) AS obligation_date,
      MAX(expensed_date) AS expensed_date,
      SUM(obligated_amount) AS total_obligated_amount,
      SUM(expensed_amount) AS total_expensed_amount,
      SUM(IF(po_reference LIKE ‘HH98230%’,obligated_amount,0)) AS reimbursable_obligated_amount,
      SUM(IF(NOT po_reference LIKE ‘HH98230%’,obligated_amount,0)) AS direct_cite_obligated_amount,
      SUM(IF(po_reference LIKE ‘HH98230%’,expensed_amount,0)) AS reimbursable_expensed_amount,
      SUM(IF(NOT po_reference LIKE ‘HH98230%’,expensed_amount,0)) AS direct_cite_expensed_amount
      FROM budget_center_contracts
      WHERE NOT ISNULL(budget_center_id)
      GROUP BY budget_center_id;
    • REGEXP
    • SELECT po_reference, IF( po_reference REGEXP ‘^H98230-[0-9][0-9][0-9][0-9][0-9][0-9]’, ‘REIMBURSABLE’, ‘DIRECT CITE’) FROM `budget_center_contracts`
  • fixed RA not enabling PM Actuals in current month
  • deployed new FA/RA with updated __view_project_detailed_data
    • need to tweak how to determine Direct Cite/Reimbursable
  • discussed how to show Direct Cites/Reimbursables
    • should show in Scripting and/or Visibility
    • group by Budget Centers (Capabilities – ACC, GCC) and individual contracts/req along with totals

Dong Shin 11.10.2014

Dong Shin 11.07.2014

  • deployed new FA – fixed rolling month for PM Actuals
  • discussed how to implement Direct Cite and Reimbursable Obligations
  • AngularJS – working on login using ngRoute…..
  • add http response status to server response in FinancialAssistantService so that AngularJS can process the response in promises better……
    • public List<User>>getAllUsers(HttpSession session) to
    • public ResponseEntity<List<User>> getAllUsers(HttpSession session) 

Dong Shin 11.06.2014

  • deployed new FA – sorting fixed, still broken month rollover (shows previous month for current month)
  • fixed PM Actuals month rollover (again!)  – need to look at fiscal year not calendar year
  • fixed datagrid footers not showing properly in Query Builder
  • AngularJS…

Dong Shin 10.30.2014

  • fixed PM Actuals not sorting properly in Query Builder
  • got SQLController/Service working
    • send up
      • {
        “sqlStr”:”select begin_year, end_year from projects limit 1″,
        “user”:{
        “login”: “projportfolio”,
        “password”: “projportfolio”
        }
        }
    • received
      • {
        “status”: true,
        “statusString”: “”,
        “errorString”: “”,
        “data”: [
        {
        “end_year”: 2017,
        “begin_year”: 2014
        }
        ],
        “exception”: “”,
        “sqlStr”: “select begin_year, end_year from projects limit 1”
        }

Dong Shin 10.28.2014

  • fixed ExportToVizWindow not defaulting to the roles found
  • fixing ExportToViz not saving data correctly…
    • new scriptEngine.jar needed
    • modified javaUtils.jar
  • working on FinancialAssitantServer for JSON response

Dong Shin 10.24.2014

  • deployed new FA/RA – fixed Sep not showing
  • configurable access to FA –
    • added allowedUserTyps to setUpModel.xml
  • trouble shooting Export to Viz
    • looks like the row size is too big
    • com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs