Category Archives: Projects

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);

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.