Monthly Archives: July 2014

Phil 7.21.14

8:00 – 2:30 SR

  • DB backups
  • Lenny wants the truancy report run every night. Need to check with Dong about running the prerequisite query.
  • Finish JS side of application
    • Move button bar to top of screen – done
    • Make buttons a bit shorter. – done
    • Add accept/Reject to panel (combo box?) Done
    • Finished document
    • Added BLUF and other changes
    • Set rejected colors to orangered.
    • Dong poked around and was unable to break.
    • Starting to look at my previous servlet code. It looks like ChartWithRemoteData4.js is most applicable.
    • The same old link:


8:00 – 5:00 SR

  • DB Backups
  • Deployed the new view and built Lenny’s ‘Truancy Report’. Nice to see all the pieces working.
  • Need to add another panel?
  • The IE8 fix does in fact work
  • Finish building HTML financial report
  • Add ADMIN config. Done
  • Added comments so that they are editable when admin
  • Continued with linking panel objects to text. Need to add in the totals object.
  • New req’s for financial report:
    • The new module is Requisition BLUF and should be right below the Funding Description module.The module needs one field labeled Requisition BLUF (which will be roughly 6 sentences long).

      Instructions: Please provide a BLUF specifically for this requisition not for the project as a whole.  The requisition BLUF should consist of one to two sentences discussing the capability gap and why this is a problem, one to two sentences discussing what the requisition is going to do to address the capability gap and one to two sentences discussing why the ISR PMO should care about this capability gap.

    • Can you also add Agency/Service Lab as the first field in the Project Description module?  This will be a dropdown list.  I have to gather all the lab names but for now you can include: AFRL Rome, AFRL WP, APG, DOE, I2WD, NRL, RadBn Mods, SCMA, SOCOM, SPAWAR Atlantic and SPAWAR Pacific.Instructions: Please select the agency or service lab that will be managing this funding.
    • Add the ISR PMO POC (single field) to the ISR PMO Admin module below the Base/OCO field.
  • Same old link:

Dong Shin 07.17.2014

  • deployed new FA, new queries for detailed data
    • using views reduced the time to generate the detailed data to 3 seconds from 5 min!!!!
  • working on new Query Builder
    • added more fields
    • modified generate_detailed_data() procedure to use the new views and queries
    • use new table qb_queries for user queries, left the previous one – user_queries
    • adding more column configurations to queryBuilderConfig2.xml

Phil 7.17.14

8:00 – 5:30 – SR

  • Contract Details
    • Add button should be enabled because there could be multiple contracts and /or multiple vendors. Done
  • Statement of Work
    • Text entered doesn’t show in the top portion when added. Done
  • Really fixed the IE8 color problem. IE8 doesn’t handle <div> events. I moved the handler to after the <input>s are created in the form.
  • Working on creating the document – making progress –

Phil 7.16.14

8:00 – 5:00 SR

  • Add an argument that turns off the “totals” table – done
  • Fix yellow on IE8 – fixed? Nope – the events can’t seem to
  • Add instructions. Done
  • Any items in Lenny’s list that don’t have “Remove Add/Delete buttons” can have multiple rows – done
  • Add funding request name. Done
  • All fields in the File Module should be set to watch the divs of other items. When the “set Info” button is pressed, it will load get(‘value)  from the watched items. Done
  • Uploaded and ready to test:

PGF 7.15.14

8:00 – 5:00 SR

  • Got Lenny’s initial response – done (
  • DB Backups
  • Add the row limit argument and alerts that fire if the user attempts to overshoot. – done
  • Need to add an ‘admin’ checkbox on the login so that I can work through admin vs user logic. – done
  • Yellow change doesn’t work in IE8. Maybe the change event is wrong?
  • A Funding request can’t be saved until the Project Information panel is complete.
  • Save panel should have
    • Task name – done
    • project number – done
    • funding type – done
    • appropriation – done
    • amount – done
    • (search) – working

Phil 7.14.14

8:00 – 2:30

  • Happy Bastille Day! Do some knitting
  • Meeting with Chris and Lenny. So far, so good.
    • Add “comments” capability to panels so that FAs can indicate if something is wrong with an FR. – Done
    • Enable/disable inputs – done
    • Create a “Save/Open” panel that lists all the projects that one manager has. Or, if you’re an FA, all the items that you’re responsible for. Mostly done
    • Current progress:
  • What does our sysadmin need to do?
    • Log into and determine status of integration and production servers
    • Backups databases
    • back up webbapps
    • Keep webserver (Tomcat) current
    • keep database current
    • keep Java current
      Keep webpages current
    • deploy new webapps, pages, and database modifications
    • Optimize performance
    • Ensure that security patches are current
    • Interact with IT infrastructure and personnel

Phil 7.11.14

8:00 – 4:00 SR

  • DB Backups
  • Data Viz isn’t creating timelines any more. The information is going across, but the date is Jan 1 1970 and nothing shows.
  • Walked through the FRF with Lenny.
  • Financial Form
    • Added a section for instructions
    • Added in the rest of the panels
    • Added the logic for changing the color of the buttons. Didja know that CSS style ‘background-color’ is represented as ‘backgroundColor’ in the DOM? Neither did I.
    • Started to add <div>s and text for the text output.
    • Here’s the link again:

Phil 7.10.14

8:00 – 5:00SR

  • DB Backups
  • Deployed new FA
  • Tried a thing or two to speed up the DB. No joy.
  • Tested the new JS on IE8. Seems to work fine. Need to
    • Set the max number of rows that can be added (-1 = infinite?)
    • Set the minimum required rows (default = 1)
    • Get rid of the submit button. Done
    • Add ‘submit’ and ‘save’ to the form.
    • Color code buttons (Red-untouched, Yellow-touched no rows, Green-minimum required rows
    • Added logic to prevent multiple panels at the same time.
    • Added total line if there for numeric values in a table
    • Adding forms.
    • Same old link:

Phil 7.9.14

8:00 – 4:00, 6:00 – 9:00SR

  • DB Backups
  • Deploy new FA
  • JavaScript
    • Tested with IE 8, and the CSS didn’t load correctly (wrong width textarea), and update didn’t work. Started the debugger, reloaded the page, and everything worked fine. Quit IE, restarted and reloaded and it still worked fine. After looking at the page a bit, I think the new stylesheets didn’t load.
    • Delete followed by update seems to be causing problems. The e.overwritten array has no elements. Need to test more. And now it works. Not sure what’s going on. Need to test more.
  • Cell height and label color are getting messed up in FA.
  • Today’s link:
  • Meeting with John Douglass (Google) on how to move projects along.