Category Archives: Projects

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

Phil 6.24.14

8:00 – 5:00 SR

  • DB backups
  • Tried the test program and the server seems fine. I think the next step is to deploy a new MySQL on the integration server and evaluate. If that works, then we’ll put it on the production server.
  • Discussions with Lenny about the new app. Here’s (a) way to generate word documents: https://github.com/leonardoanalista/java2word
  • SimilarityDistanceWidget.
  • Got all the calculations done and working. There is a strange positional artifact that seems to whant to put the items in a plane. Javascript math?
  • Today’s progress: http://philfeldman.com/WebGLSimDistTest.html