Dong Shin 02.26.2014

  • snow! again! working at home
  • added where config to queryBuilderConfig.xml and modified to QueryBuilder code to read the config….
  • added currency fields in queryBuilderConfig.xml
  • set query name when saving existing query in QueryBuilder
  • changed Spark DataGrid to Advanced DataGrid in pre-processing to support multi-columns sorting
  • changed Col Pref window to ResizableWindow
  • added multiple selection support in Claimed/Unclaimed contracts

Phil 2.25.14

8:00 – 5:00 SR

  • Backups
  • Deployed some new SQL. Lenny found a couple of bugs, but not too bad. Dong has notes, but he went home because it’s his birthday. Some people. Jeez.
  • More inevitable server paperwork.
  • JavaScript
    • You would think that drawing and clearing lines would be easy. Nope. For some reason, YUI Path.clear() does not clear in all conditions. If I draw the line on each frame, everything’s fine. If I draw a line occasionally, it stays. I wound up just calling moveTo() if there was no line, which works.
    • Added the ability to anchor a shape. Physics don’t work on it. Also got drag and drop to work with that.
    • Test this

Dong Shin 02.25.2014

  • deployed to new query, query config… missing some details in where clause
  • some notes
    • add saved name when updating a query
    • 2nd year Obligation/Outlays not updating properly
    • bigger col prefs
    • multiple contracts selection in unclaimed/claimed
    • separate pre-processing for FY13/FY14
    • enable multi-column sort in Reqonciler
    • add Expensed Date in Duplicate Expensed Amount > 0 pre-processing query

Phil 2.24.14

8:00 – 4:00 SR

  • Backups
  • Copied all the webapps and data from the production machine to the test machine.
  • More server paperwork.
  • Javascript
    • Make the controls a pop-up panel. Got stuck on getting a button to work in the graphics container. It looks like all mouse events are being trapped. Was able to add the button to a new wrapper around the control container. Using that I’m able to fade the controls in and out.
    • Build a multi-part network for more testing will all connections.
    • Progress for today

Dong Shin 02.21.2014

  • working on the query for Lenny/Chris
    • capability AS Capability, bcc.budget_center_name AS ‘Budget Center’, req_id AS ‘Req ID’, req_description AS ‘Req Title’, vrt.req_id_total AS ‘Req Funded Amount’,
      SUM(IF(o.type=’Planned Outlay $:’,month_1,0)) AS ‘Oct 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_2,0)) AS ‘Nov 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_3,0)) AS ‘Dec 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_4,0)) AS ‘Jan 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_5,0)) AS ‘Feb 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_6,0)) AS ‘Mar 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_7,0)) AS ‘Apr 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_8,0)) AS ‘May 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_9,0)) AS ‘Jun 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_10,0)) AS ‘Jul 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_11,0)) AS ‘Aug 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_12,0)) AS ‘Sep 14’
      WHERE fiscal_year = 2014
      GROUP BY capability, req_id
    • getting the second year will be tricky….

Dong Shin 02.20.2014

  • deployed all swf’s with Mod/Revision text
  • missed queryBuilderConfig.xml
    • LEFT JOIN __view_committed_totals AS vct ON vct.budget_center_id = bc.uid
  • checked in all Flex projects
  • working on query for reports
  • Query Request from Lenny/Chris
    • query that shows Capability, Budget Center, Req ID, Req Title, Req Funded Amount,Outlay Plan by month
    • The column headings would be: Capability, Budget Center, Req ID, Req Title, Req Funded Amount, Oct 13, Nov 13, Dec 13, Jan 14, etc. through the first two years.

Dong Shin 02.19.2014

  • building vis2 with new settings… wouldn’t let me build with Flex SDK 3.
    • would not compile in Flex 4 workspace , weird. created a new workspace just for Flex 3 projects
    • built IngestManager – had to check out as a new project, AccountManager
    • packed up everything to VizTool.zip

Phil 2.19.14

8:00 – 10:00 SR

  • Backups
  • More server firedrills.
  • Talked to Lenny more about report queries. He’s producing a list. We also discussed what could be done simply with cognos data that predates vistool info.

Phil 2.18.14

10:00 – 4:00 SR

  • Backups
  • More paperwork. There’s a new list of items that the web pages have to have, so we’ll need to modify all our flash files.
  • Worked on adding banners to Data Visualizer and Scripting. Had all kinds of problems with the properties pointing to the wrong folder for the .swf, and then the java export functionality was broken. Finally had to delete all the servers from Eclipse , reinstall, and then change the settings  on the server so that it explicitly used the current Tomcat 7.0 Install. After that, the server came up. Next will be to get the VSS server side code to export.
  • Javascript?

2:00 – ?? Mandatory All Hands. Nope, wrong contract

Phil 2.14.14

9:30 – 3:30 SR

  • Tried to get into the office to do backups, but it was locked and empty. Went over to the Columbia offices, which was not locked, but still pretty empty.
  • Javascript
    • Adding in physics. Starting with 2 shapes…
    • Physics are working
    • Turning off physics for the dragged shape
    • Adjusting click behavior so that selection happens on mousedown and is released on mouseup
    • Hooking up dials – done
    • Adding movement threshold instead of damping – Done
    • Good progress today!

Dong Shin 02.12.2014

  • deployed new queries to update COGNOS data mapping – working!
  • changed Reqonciler to retrieve the list of queries in ‘order’ order…
  • working on reconfiguring Commited Amounts/Date in Query Builder
    • created view for Committed Amount/Date – __view_committed_totals
      • CREATE ALGORITHM = UNDEFINED VIEW `__view_committed_totals` AS SELECT budget_center_id, MAX( committed_date ) AS committed_date, SUM( committed_amount ) AS committed_amount, GROUP_CONCAT( committed_amount )
        FROM `committed_amounts`
        GROUP BY budget_center_id
    • added __view_committed_totals join queryBuilderConfig.xml – vct
    • change queries – committed_date to vct.committed_date in queries!

Phil 2.12.14

8:00 – 4:00 SR

  • Backups
  • Updated budget center cognos data queries. Still need to add an “order by `order`” in the reqonciler post-processing query.  Actually, all queries.
  • Remove committed amounts and dates from query builder, calculate from new req data.
  • Mousemove not working in IE8. Possibly need to add the explicit div name (http://stackoverflow.com/questions/6922672/yui3-events-not-working-in-firefox-or-opera-works-fine-in-chrome-though). That fix is in. Need to test.
  • Spent the rest of the day working out the physics for the shapes. Mostly done and ready to start testing?