Monthly Archives: August 2014

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

Phil 8.7.14

8:00 – 5:00 SR

  • DB Backups – done
  • Deploy new FR app – done
  • Update index page with link and description – done
  • Removed “Update” button for a while
  • Need to add top and bottom marking <div>
  • Add delete FR and delete row functionality to client
  • Update should “add” if there are no rows
  • Make sure that the year is greater  or equal to today – done
  • Add validators to update
  • Add logger – done
  • Send error message back to client for alert.
  • Make sure that date parser is correct – may need to add one to month – done
  • leave ‘@’ in string validator – done
  • Add default zeros in number fields – done
  • Realized that using delete/add would cause artifacts in the DB, changed it so that the table has the old funding request deleted before the new one is added.

Phil 8.6.14

8:00 – 6:00 SR

  • Woke up at 3:30 thinking about the loading problem. Thoughts are in the previous entry.
  • Deployed the new version, which went nicely.
  • Discovered a problem with IE8. Comments (//) in the <style> section don’t work, and the following needs to be added to the .panelButton style:
    • display: inline-block;
    • float: left;
  • Onward…
  • Made all the changes to FundingRequestPanel and things are working. Still need to add the adjustment of the fr_master_table for Submit. If the testing works out, then things are kind of beta?
  • Add deleteRow() and deleteFR() to java. Done
  • Integrated new save

Phil 8.5.14

8:00 – 6:00 SR

  • Submit button
  • Clear button – done
  • Why are the buttons turning yellow on load? State issues. Fixed
  • Check to see that users are not being changed on save.
  • Disable access to dropdown and remove NA from list – done
  • The Submit and changed users are the result of the data about a funding request (name, approval) are being saved in the FundingRequestPanel as part of each submission. There needs to be a fr_master_table:
    • uid: hash of frName and login
    • frName
    • status
  • This table will be used by FundingRequestPanel (FRP) only, and the FRP will not be stored in the fr_panel_table. Rows will not be kept in the table. Instead, the rows will be reconstituted. This means that a lot of the base class functionality (_fromArray(), _toJson()) will have to be rewritten to access the new table. Login will read from this table and if there is data to load, then the FRP will show. Maybe show it anyway, with a “New” button that fires a “FundingRequestPanel:clear” event.

Phil 8.4.14

8:00 – 2:30 SR

  • Add non-admin viewing logic to server code – done
  • Add ability to select requests by status (incomplete, submitted, rejected accepted) to req panel, then clear and re-run the query
  • Add submit functionality.
  • Set status to green when NA is selected.
  • Get the latest YUI-base for deployment and test – done
  • Make sure that the DB creation files are correct. – done
  • Make sure that the original user’s information is being saved when updated by Admin – done
  • Check https functionality.
  • Zip up and try deploying!
  • Fixed some bugs in the assembling of the queries. Also had to add a regex

Phil 8.1.14

8:00 – 5:30 SR

  • DB and webapps backup
  • Deployed new FA, but had to roll back because the FMPs were broken
  • Working on getting all the login permutations handled.
    • Added status return if no entries found.
    • Added fr_name parameter to the getPanel call.
  • Built the load query
  • Added a method that iterates through the array of results and builds the panel from that
  • Hooked op the FundingRequestPanel to the fromArray() method and connected it to the login. I still need to adjust the behavior based on whether the role is admin, but it works.
  • Added a load event to FundingRequestPanel
  • Added a method to grab the array of results and feed it to all the panels except FundingRequestPanel.
  • Tested and wporking for one funding request and the Administrator role.

Saved out and loaded in from the DB:

woohoo