Dong Shin 08.27.2014

  • deployed new FA/RA with contract/invoices and lab… not quite working right
    • Fix field changing bug caused by addition of Lab.
    • Lockdown baseline rows so only Admin’s can edit them.
    • Contracts Tab: Use the same fields from Funding Request Form from Contract Details button (Contract Name to Place of Performance)
    • Invoice Tab: Contract Number and ACRN pulled from COGNOS and delete Date DFAS Paid
    • When open a req for financial data entry Contracts pop-up.
    • Move View FMP Button and View Invoices Button to tabs in RA.
  • working on new contracts format…. new from Funding Request Form
    • Structure
      • Contract Name: If these funds will be placed on a contract enter the contract name of that contract.
      • Contract Number: If these funds will be placed on a contract enter the contract number of that contract.
      • Contract PoP Start: If these funds will be placed on a contract enter the contract PoP start date.
      • Contract PoP End: If these funds will be placed on a contract enter the contract PoP end date.
      • COR Name: If these funds will be placed on a contract enter the name of the COR of the contract.
      • COR Email: If these funds will be placed on a contract enter the email address of the COR of the contract.
      • COR Phone: If these funds will be placed on a contract enter the phone number of the COR of the contract.
      • Vendor: If these funds will be used to fund contractor labor, material or travel enter the name of the contractor.
      • Place of Performance: If these funds will be used to fund contractor labor, material or travel enter the place of performance of the contractor.
    • created contracts table….

Phil 8.27.14

8:00 – 6:00 SR

  • Deployed new FR, FA, RA
  • DB Backups
  • Paperwork success!
  • Discussed pulling FR data into FA for creating projects – will need to create a bunch of projects. And try multiline titles and comments to test CSS overflow problem.
  • Doing some much needed commenting
    • PanelModuleTest.html – done
    • RecordsetPanel – started
    • FundingRequestPanel
  • Sent a new version over to Bill for deployment. The commenting is finding bugs.

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!