Monthly Archives: July 2014

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 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:
    • 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>
      First name: <input type=”text” name=”firstname”><br>
      Last name: <input type=”text” name=”lastname”>
    • 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…
  • 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!
    • 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:

Phil 7.1.14

8:00 – 5:00