PGF 7.15.14

8:00 – 5:00 SR

  • Got Lenny’s initial response – done (http://philfeldman.com/PanelModuleTest.html)
  • 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: http://philfeldman.com/PanelModuleTest.html
  • 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: http://philfeldman.com/PanelModuleTest.html

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: http://philfeldman.com/PanelModuleTest.html

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: http://philfeldman.com/PanelModuleTest.html
  • Meeting with John Douglass (Google) on how to move projects along.

Dong Shin 07.08.2014

  • deployed new FA
    • Status ItemRenderer changes when scrolling in Query Builder – fixed
  • working on new Query Builder
    • refining master data table to include all appropriation years in a row instead of separated by a year
    • SELECT
      SUM(IF(year_count=1,SUM(IF(type = ‘Planned Obligated $:’, month_1, 0)),0)) AS planned_obligated_year_1_month_1,
      SUM(IF(year_count=1,SUM(IF(type = ‘Reported FACTS Obligated $:’, month_1, 0)),0)) AS reported_facts_obligated_year_1_month_1,
      SUM(IF(year_count=1,SUM(IF(type = ‘Planned Outlay $:’, month_1, 0)),0)) AS planned_outlay_year_1_month_1,
      SUM(IF(year_count=1,SUM(IF(type = ‘Reported Outlay $:’, month_1, 0)),0)) AS reported_outlay_year_1_month_1,
      SUM(IF(year_count=1,SUM(IF(type = ‘PM Actuals (Invoiced) Outlay $:’, month_1, 0)),0)) AS pm_actuals_year_1_month_1,
      SUM(IF(year_count=1,SUM(IF(type = ‘Outlay $ (Reported in FACTS)’, month_1, 0)),0)) AS reported_facts_outlay_year_1_month_1
      FROM obligations_outlays
      GROUP BY funding_id

Phil 7.8.14

8:00 – 5:00 SR

  • DB Backups
  • Deployed new FA
  • Tested new JS code, seems to be working.
  • Added delete, which worked right the first time.
  • Added comboboxes, which worked the first time. The Apocalypse must be here.
  • Starting to add in all the sections. The Y.one() is returning the first table created, so the __id field is going to need more info.

Phil 7.7.14

8:00 – 12:00 SR

  • DB Backups
  • Leaving early for parent/doctor stuff
  • JavaScript
    • IE8 does not support Object.keys(). Here’s the fix: http://stackoverflow.com/questions/18912932/object-keys-not-working-in-internet-explorer
    • Added the monkeypatch in and chased down the other bugs in the select/update code. I do want to redo this based only on <div>s and <input>s
    • Starting on the main form.
    • Here’s how you do a dropdown in a form. Need to add that to the config:
    • <form action=””>
      <select name=”cars”>
      <option value=”volvo”>Volvo</option>
      <option value=”saab”>Saab</option>
      <option value=”fiat”>Fiat</option>
      <option value=”audi”>Audi</option>
      </select>
      <br/>
      First name: <input type=”text” name=”firstname”><br>
      Last name: <input type=”text” name=”lastname”>
      </form>
    • Today’s work.

Phil 7.3.14

8:00 – 4:00 SR

  • The JS fix seems to work, though there seems to be a funky modal event that is keeping the module from working correctly.
  • Continue to modularize
  • I think I’d like to get the config items in the configArray to be easily converted to input tags.
  • Added an ‘edit’ button, but I think I’m going to change it to a ‘selected’ radiobox and then have an updated/delete selected button. Done. Working on adding in the needed actions.
    • Close. Updating seems to destroy something… http://philfeldman.com/PanelModuleTest.html
  • Database backups
  • Switch reports to June
  • Visualization components from dashboard
    • Direct annotation, with some drawing (braces, callouts, etc)
    • Horizontal and vertical bar charts
      • by value
      • by percentage
      • adjacent and stacked
    • Dials (Red/Yellow/Green and Red/Green)
    • Line charts
    • combination (adjacent bar plus line)
    • Scatter against colored BG (Green/Yellow/Red)
    • Automatically updated text.
    • Titles

Phil 7.2.14

8:00 – 5:30 SR

  • The test page doesn’t seem to be working with IE8. The yui-sam stylesheet isn’t loading, and the popup won’t show. The error says “Expected identifier, string or number” – configArray.push({name: ‘name’, type:’text’, default:’unset’}); It could be that ‘default’ is causing the problem since it’s a reserved word.
  • Yay! https://www.modern.ie/en-us/virtualization-tools#downloads
    • And that worked just fine. Tested the fix (replacing ‘default’ with ‘initialVal’) and all is well again!
  • Creating the PanelModule – wierd bugs, but here’s the initial version: http://philfeldman.com/PanelModuleTest.html