Dong Shin 08.26.2014

  • grails experiment – 2.3.1
    • changed generated class names to singular – use table in static mapping
    • relation working – make sure ID fields are named correctly
    • got XML/JSON server working – replace json with xml to get xml response
      • /project.json to get a list JSONized
      • /project/index to get an HTML standard scaffolding
      • /project/create.html scaffold for a new item
      • /project/show/1.html scaffold edit item 1
      • /project/show/1.json JSON for item id: 1

Phil 8.26.14

8:00 – 5:00 SR

  • Found out that Tabs are Bad Control Characters in JSON. It turns out that I was explicitly allowing tabs and CRs in the regex. No more. Also, the reason that the tabs were there at all (because they should have moved between fields) was because the lines that had them were pasted. Ya learn something every day.
  • FRs will for now be done in Word documents though. The system is too buggy.
  • Added indications about loading and saving to the top of the page.
  • Trap tabs in FR – done
  • Work on “Are you sure?” dialog – done
  • Ran many tests on loading/saving

Phil 8.25.14

8:00 – 2:30 SR

  • Make the list for approval a global – done
  • Add a “required” config for items. Grids that gave an empty required field remain yellow
  • Make “add’ trigger a save. If there is no project name, add a dialog that forces that – done.
  • Make the lab dropdown loads from a config file – done.

Dong Shin 08.22.2014

  • set budget centers data in Contracts and Invoices tabs in the Update Requisition Data so that correct related data are retrieved
  • added data counters to Contract and Invoices tabs
  • working on adding Labs to Requisition Data
    • added labs table, ‘TBD’ for temporary row
    • added lab column in budget_centers table
    • added lab to Update/Add Requisition Data panel
    • added insert/update code

Phil 8.22.14

8:00 – 5:00 SR

  • DB Backups
  • Task number query is messing with taskID query – removed taskID query. Junit test seems OK
  • add multiple role checks during login. – Added to java code. Passed Junit.
  • Scrollbars is not working. Test with other browsers. Tested and all seems to work. added reset-min.css to see what gives.

Phil 8.21.14

8:00 – 4:00 SR

  • DB Backups
  • Deployed FR, FA, RA
  • Need to add Project Number to comments – done
  • Need to format HTML – done. That’s a wierd one, too. If you’re using a div, then setContent() getContent() works like a charm. But since I’m using IE8 compatable textarea, I have to convert CR to <br/>. using JavaScript’s replace() function to do it all by regex.
  • Need to add scrollbar to FundingRequestPanel – done
  • Remove “Testbed” – done

Phil 8.20.14

8:00 – 4:30 SR

  • DB Backups,
  • Deploy new FR, FA, RA and db updates to production server
  • Change queries top use login and fr_name
  • Change queries to inner joins
  • Handle load of empty project
  • Work on task number insert query
  • Change it so that other roles can see all FRs
  • Junit tests
    • Bad login
    • Good login
    • Empty project
    • Create project
    • Update project delete project

Dong Shin 08.19.2014

  • deployed new FA/RA, database updates to the test server….
    • need to changed the 3, 4 year queries – done
  • working on adding invoices and contracts tabs
  • challenging SQL problem from Phil
    • update comments in fr_master_table with value from fr_text_table where the comments don’t contain value…
    • UPDATE fr_master_table f SET comments = CONCAT(
      IF(ISNULL( (SELECT value FROM (SELECT ftt.value, fmt.uid as uuid FROM fr_master_table fmt RIGHT JOIN fr_text_table AS ftt ON ftt.uid
       LIKE CONCAT(‘%’,fmt.uid, ‘_taskName’) AND fmt.comments NOT LIKE CONCAT(‘%’, ftt.value, ‘%’)) AS X WHERE f.uid = X.uuid)), ”,

      CONCAT(‘Task ID: ‘, (SELECT value FROM (SELECT ftt.value, fmt.uid as uuid FROM fr_master_table fmt RIGHT JOIN fr_text_table AS ftt ON ftt.uid LIKE CONCAT(‘%’,fmt.uid, ‘_taskName’) AND fmt.comments NOT LIKE CONCAT(‘%’, ftt.value, ‘%’)) AS X WHERE f.uid = X.uuid), ‘ – ‘)),
      comments);

Phil 8.19.14

8:00 – 5:30 SR

  • DB backups
  • Check to see what’s going on with the master table status for submit. Bad query. Fixed.
  • Put project ID in the master list? Will require a join on data that might not be there. Not sure how that will work… But done, mostly due to Dong’s mad SQL skillz.
  • Deployed new FR app late in the day because so many people are using it. Wound up being able to make a hot deploy, which is nice.
  • Zipped up new FR app and prepped for deploy tomorrow.
  • Desperately need loading animation. This looks good. Build a module for it tomorrow: http://codepen.io/fbrz/pen/yEHok

Phil 8.18.14

8:00 – 2:30 SR

  • Back from vacation
  • DB backups.
  • Forms did not explode!
  • It’s possible to save funding requests with no title. Not sure how that is, but added another check. Maybe they are all spaces? Also added a login column in FundingRequestPanel so that the admin can see who’s doing what.
  • Need to save scripts or make tools that add/delete/modify funding requests
  • Checked that status reports are good.
  • Adding a modal dialog so that there is an “are you sure?” state before deleting a funding request. Done
  • Adding a module to store variables as a hack around import. Done.

Dong Shin 08.14.2014

  • continue working on adding Baseline rows
    • query to fix Procurement (year 3 and 4) RDT&E (year 3) not showing in Obligations/Outlays, this  must be done prior to adding baseline rows.
      • INSERT INTO obligations_outlays_fix (type, project_id, funding_id, year, year_count)
        SELECT ‘Planned Obligated $:’, p.uid, c.uid, c.fiscal_year, 3 FROM projects p LEFT JOIN budget_centers c ON p.uid = c.project_id
        WHERE appropriation LIKE ‘RDT&E%’;
  • working on adding not 100% obligated to Overdue Obligations query – line item 13
  • wordpress post editor has been changed! arghhh! hating it!

Dong Shin 08.12.2014

  • working on adding Planned Baseline rows
    • added Planned Obligation Baseline: and Planned Outlay Baseline: to obligation_outlay_types table
      • INSERT INTO `project_portfolio_enh`.`obligation_outlay_types` (`uid`, `type`, `visible`, `status`) VALUES (NULL, ‘Planned Obligation Baseline:’, NULL, NULL), (NULL, ‘Planned Outlay Baseline:’, NULL, NULL);
    • add Planned Obligation/Outlay Baseline rows for existing data
      • INSERT INTO obligations_outlays
        (type, year, year_count, project_id, funding_id)
        (SELECT ‘Planned Obligation Baseline:’, year, year_count, project_id, funding_id FROM `obligations_outlays`
        GROUP BY funding_id, year_count) UNION ALL
        (SELECT ‘Planned Outlay Baseline:’, year, year_count, project_id, funding_id FROM `obligations_outlays`
        GROUP BY funding_id, year_count);
    • update visible in obligation_outlay_types so only Admins and NSA PM’s can see the planned baseline rows
      • UPDATE obligation_outlay_types SET visible = 0;
        UPDATE obligation_outlay_types SET visible = 1 WHERE type <> ‘Planned Obligation Baseline:’
        AND type <> ‘Planned Outlay Baseline:’;
    • added visible flag to getFinancialData
  • back up current database – project_portfolio_enh_081214, cleaned up databases….