Category Archives: VISIBILITY

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