Phil 11.21.14

Phil 8:00 – 4:00

  • I can see the servers again!
  • DB backups
  • No deploy, Bill V is out for the day.
  • More Angular. Spent most of the day working on sending and receiving data. YUI had all kinds of nice functions to convert JSON objects to all kinds of things. JavaScript and Angular lack these, so after poing around for a while I found this post that seems to work nicely and lets you use POJsOs for data upload. Using a function in the in the module definition is something I have not seen before. Need to understand that better.

Dong Shin 11.21.2014

  • no deploy today, but fixed __view_project_detailed_data
  • Lenny needs to send me an email about Reqonciler issues/proposed changes

Phil 11.20.14

8:00 – 5:30 SR

  • DB backups – nope server access denied. And other weird server problems today.
  • Lots of good angular work today. Got several simple directives working, refactored the structure a bit, learned how to trap paste events and I think I know how to deal with key presses.

Dong Shin 11.20.2014

  • verified that 100% PM Actuals data update works correctly, need to test it on-site
  • fixed missing Appropriation column in Financial Assistant server
  • new queries to try for Direct Cite/Reimbursable tomorrow

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/
    • 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

Phil 11.19.14

7:30 – 5:00 SR

  • Static type checking for JS from Facebook -
  • DB Updates
  • Fixed truancy report by adjusting querybuilder query there appears to be a problem in the java code that is returning the header twice.
  • Built a couple of toy directives. On to bigger, more complex things.

Phil 11.18.14

8:00 – 5:00 SR

  • Asked Ronda to check/update vulnerabilities. First with the test server, then with production.
  • DB backups
  • Briefing today from 1:00 – 2:30

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.17.2014

  • working on Query Builder to support the new requirements…
    • removed all unused parts in QueryBuilderWindow….

Phil 11.17.14

8:00 – 10:00, 12:00-5:00

  • DB Backups
  • Angular.

Get every new post delivered to your Inbox.