Category Archives: VISIBILITY

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

Phil 7.1.14

8:00 – 5:00

Phil 6.30.2014

8:00 – 3:00

  • Attempted to deploy new FA, but got a blank white screen. The player is 11.5.502.110. Weird.
  • Formbuilder.
  • Took a quick look at Polymer, which looks cool and is along the lines of what I’m wanting to build, but it appears alpha and broken-y.
  • While looking through my code example I’m prototyping, I noticed that the code was using a Y.Lang.sub() call where it appeared that an object containing values:
    • {ANSI: “55000”, STATE: “WISCONSIN”, TOTAL_POP: 5654774, LAND_AREA: 54310.1, POP_PER_SQ_MILE: 98.8}
    • was being inserted using the following format as a way of building table rows.
    • TEMPLATE_TR = ‘<tr id=”row_{ANSI}”><td>{STATE}</td><td>{TOTAL_POP}</td><td>{LAND_AREA}</td></tr>’;
    • So yay. Lots of other good stuf, including type checking. So pay more attention to this one! (http://yuilibrary.com/yui/docs/api/classes/Lang.html)
    • Also, this means that dynamic forms and tables can be built, with strings and types fed in in the configuration argument
  • Here’s how the panel will animate: https://yuilibrary.com/yui/docs/panel/panel-animate.html
  • Starting to combine the panel and the table/recordset. It’s going pretty smoothly. I’m still using the data array, but I’ll move to more form-based data tomorrow or wednesday. Nicely, the height of the panel resizes based on what’s in it.  And I should be able to use the same module for the login form.

Phil 6.27.14

8:00 – 4:300 SR

  • DB Backups
  • Status Reports!
  • Starting Funding Request Form. I’m currently thinking that a YUI recordset might be a good way to do this. Got the recordset demo working fine, but the implementation is basic HTML table manipulation. Now, that’s not necessarily a bad thing – it just means that there needs to be a module written to handle that. I’m not sure that it’s a big win over DataTable, which is part of the forms example.

Dong Shin 06.26.2014

  • tried to deploy the new Query Builder, the queries are too slow… 6 minutes! will try this tomorrow
    • ‘Copying to tmp table’, ‘2.432915’
      ‘Sorting result’, ‘0.899327’
      ‘Sending data’, ‘0.783034’
    • SHOW VARIABLES LIKE ‘max_heap_table_size’;
      • ‘max_heap_table_size’, ‘16777216’
    • SHOW VARIABLES LIKE ‘tmp_table_size’;
      • ‘tmp_table_size’, ‘16777216’
  • added last COGNOS upload status to FA
  • added status (Red, Yellow, Green) to Obligated, Outlay, PM Actuals % value columns in Query Builder (old)

Phil 6.26.14

8:00 – 5:00 SR

  • Backups
  • Poked at the slow server problem. Profiles indicate that the reading/writing of temp files is slow…
  • Cool thing for the day: http://esprima.org/index.html
  • First draft of the cluster analysis tool is done. Need to add user-supplied similarity function, some graphics options (more shiny – less shiny slider?), and change the output to have a csv compatible output

Phil 6.25.14

8:00 – 5:00 SR

  • DB Backups
  • Discussion with Lenny about new form. Details are not worked out yet.
  • Adding more user interaction to the SimDist test, since I’ll need that for the form.
  • Working on reading in a text file pasted into the browser. Done!
  • Current version: http://philfeldman.com/WebGLSimDistTest.html