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

Phil 11.13.14

8:00 – 5:00 SR

  • DB backups
  • Discussion with Lenny about Direct Cite vs. Reimbursable. I think in the future that Spring DB access plus a rules engine (using WEKA?) might give us what we want.
  • Finally got tabs working in my system:
<!doctype html>
<html ng-app="ui.bootstrap">
<head>
    <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular.js"></script>
    <script src="//angular-ui.github.io/bootstrap/ui-bootstrap-tpls-0.11.2.js"></script>
    <link href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>

<div ><!--ng-controller="TabsDemoCtrl as tabCtrl"-->
    <tabset>
        <tab heading="Justified">Justified content</tab>
        <tab heading="SJ">Short Labeled Justified content</tab>
        <tab heading="Long Justified">Long Labeled Justified content</tab>
    </tabset>
</div>
</body>
</html>
  • Ands to get all that working also requres the bootstrap css. This isn’t surprising, it’s just not listed anywhere. So at this point, to accommodate libraries/frameworks and styles that will be reused between projects, we’re settling on a libs and styles directory. These directories will contain the local copies of the code/css files that we use in our apps.
  • Of course, the icons don’t work. It looks like we’ll need the fonts folder in the styles folder as well. Really don’t want to put in the js. And I didn’t have too.
  • So it looks like we need the following two libraries to begin with:
    • UI Bootstrap: Bootstrap components written in pure AngularJS by the AngularUI Team
    • AngularUI: The companion suite(s) to the AngularJS framework.
  • Thinking about the following for the post-JSON formatting
    session charcode char dn msec up msec

 

Phil 11.11.14

7:30 – 10:00, 5:30 – 7:00 SR

  • Taking advantage of the holiday to figure out the Angular that I forgot while I was documenting.
  • Changed queryApp to use factories and added predefined queries
  • Processing json messages. Working on adding a set of tabs to show the different processing.
  • You would think that tabs would be a thing, but they’re really horizontal menues in CSS. Using pure css to make this easier. But I can’t find a way to make the tabs behave like radio buttons. Looks like my first directive…

Dong Shin 11.10.2014