Monthly Archives: October 2012

Dong Shin 10.31.2012

  • wrapping up SQLEditor for VSS
    • added getSavedSQLs to retrieve save queries
    • added SQL error window to FGMFlexUtils45
    • double click on sqlResultsDG shows selected row details
  • fgmdev.com was down….

Phil 10.31.12

8:00 – 4:00

  • Backups and discussions with folks on site. Working on getting a meeting set up with the Morpheus folks.
  • fgmdev.com was down. Dong and I spent most of the morning trying to get it up. That you are reading this means success!
  • Working on adding color code. Incorporated and working nicely!
  • Checking code in
  • Burning a disk

Phil 10.30.12

10:00 – 12:00 ESSO

  • Still wet, but no wind to speak of. Cold – in the 30’s. We apparently got 80 mph gusts and I’d believe it.
  • Updated the WP engine for this blog.
  • Looking at some papers about User Interface/ Experience to see how the Alert Manager App should be built.

12:00 – 2:00 FP

  • Reading “Facilitators and Barriers to Adopting Robotic-Assisted Surgery:  Contextualizing the Unified Theory of Acceptance and Use of Technology”. I want to find a rule for User Interface adoption

Dong Shi 10.29.2012

  • working at home
  • continue working on SQLEditor for VSS
    • added method to run SQL string to server – SQLResult runSQLStrings(String databaseName, String sqlList)
    • added SQLResult.java to javaUtils – pom.xml is set to generate version 1.1, others are not using it?????
      • changed scriptingEngine and VisibilityScriptingServer to use 1.1
    • added methods to save and get list of SQLs

Phil 10.29.12

8:00 – 4:00 ESSO

  • So begins a very wet day.
  • Working on figuring out why coloring chart lines is so different from all the other charts. Going to try building a toy project with just one line chart in it and (maybe?) an item renderer.
  • Well that turned out to be easier than I thought.
	private function init():void{
		var hsb:HsbObject = new HsbObject(0x0000AA);
		var lsa:Array = new Array();
		lsa.push(createLineSeries("Profit", "Profit", hsb));
		hsb.rotateHue(40);
		lsa.push(createLineSeries("Expenses", "Expenses", hsb));
		hsb.rotateHue(40);
		lsa.push(createLineSeries("Amount", "Amount", hsb));

		_linechart.series = lsa;
	}

	private function createLineSeries(yf:String, dn:String, hsb:HsbObject):LineSeries{
		var scs:SolidColorStroke = new SolidColorStroke(hsb.getHexColor());
		scs.weight = 3;
		var ls:LineSeries = new LineSeries();
		ls.yField = yf;
		ls.displayName = dn;
		ls.setStyle("lineStroke", scs);
		return ls;
	}

The project files are here. There are two projects. The EdgeUtils project contains the HsbObject class.

Dong Shin 10.26.2012

  • added dbStoredQuery(String queryName) to ScriptFacades class
    • can run set of queries and return the last result in DbTable format
  • working on dbStoredProc – runs stored procedure in the database via VSS
  • working on QueryEditor in VSS

Phil 10.26.12

8:00 – 4:00 ESSO

  • Put in the paperwork for an URN
  • Pinged the Morpheus folks to see how we can integrate
  • Working on tracking down bugs and coloring lines
  • Discussed how to add SQL stored(?) procedures to VSS with Dong.
    • Need an editor to create and name scripts
    • Need some kind of macro substitution
    • Some of this is available in the dbObjects in JavaUtils and FGMUtils, using the classes that I wrote to create databases that map to Flex objects.
  • Fixed the bug that was crashing the column rendering in WidgetBase by adding a try/catch block and resetting the array of visibile columns. Not pretty, but it works.
  • Still trying to figure out how to change the color of a line. This seems to be the way: http://help.adobe.com/en_US/flex/using/WS2db454920e96a9e51e63e3d11c0bf69084-7c52.html

Phil 10.25.12

8:00 – 2:00 ESSO

  • Got the following error:
  • RangeError: Index ‘2’ specified is out of bounds.

    [C:autobuild3.xframeworksprojectsframeworksrcmxcollectionsListCollectionView.as:529]
    at mx.collections::ListCollectionView/addAll()[C:autobuild3.xframeworksprojectsframeworksrcmxcollectionsListCollectionView.as:512]
    at com.edgeti::WidgetBase/listColumnsHandler()[C:PhilProject WorkspacesHelios_3.6 FB4.5_32_bit_Aug_2012GenericQueryWidgetsrcmainflexcomedgetiWidgetBase.as:236]

  • Backups
  • Status meeting
    • Dave wants a contingincy plan if the server goes down. Need to talk to Vernon about this.
    • Looked at integrating with Morphious.

Dong Shin 10.25.2012

  • status meeting
  • working on running stored queries in ScriptFacades class
  • continue working on FMP alerts
  • created AlertFMPs.py and AlertFMPsSaveToTable.py scripts
  • query to find offending FMP’s in Alert format
    • SELECT
      GROUP_CONCAT(distinct(ppa.login)) as porfolio_admins,
      GROUP_CONCAT(distinct(ppm.login)) as portfolio_mgrs,
      GROUP_CONCAT(distinct(psf.login)) as service_finance_pocs,
      GROUP_CONCAT(distinct(m.login)) as service_project_managers,
      p.project_number as program,
      c.center_number as MIPR
      FROM `financial_mitigation_plans` fmp1, financial_mitigation_plans fmp2,
      projects p, obligations_outlays o, budget_centers c,
      _projects_service_project_mgrs m,
      _projects_portfolio_admins ppa,
      _projects_portfolio_mgrs ppm,
      _projects_service_finance_pocs psf
      WHERE fmp1.obligation_outlay_uid = fmp2.obligation_outlay_uid
      AND fmp1.financial_mitigation_plan = fmp2.financial_mitigation_plan
      AND fmp1.explanation1 = fmp2.explanation1
      AND fmp1.explanation2 = fmp2.explanation2
      AND fmp1.explanation3 = fmp2.explanation3
      AND fmp1.explanation4 = fmp2.explanation4
      AND fmp1.explanation5 = fmp2.explanation5
      AND fmp1.month + 1 = fmp2.month
      AND p.uid = o.project_id
      AND c.uid = o.funding_id
      AND p.uid = m.project_id
      AND p.uid = ppa.project_id
      AND p.uid = ppm.project_id
      AND p.uid = psf.project_id
      AND fmp1.obligation_outlay_uid IN
      (SELECT o.uid
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o, obligations_outlays_goals g
      WHERE
      p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND o.project_id = p.uid
      AND o.funding_id = c.uid
      AND g.appropriation = c.appropriation
      AND g.year = o.year_count
      AND o.year + o.year_count = 2014
      AND (ISNULL(o.month_1) OR (o.month_1 > TRUNCATE(a.amount *  IF(o.type LIKE ‘%Obligate%’,g.obligation_month_1, g.outlay_month_1) / 100, 2) * 1.05
      AND o.month_1 <  TRUNCATE(a.amount *  IF(o.type LIKE ‘%Obligate%’,g.obligation_month_1, g.outlay_month_1) / 100, 2) * 0.95)))
      GROUP BY o.uid

Dong Shin 10.24.2012

  • query to find offending (?) FMPs for underperforming obligations/outlays
    • SELECT *
      FROM `financial_mitigation_plans` fmp1, financial_mitigation_plans fmp2
      WHERE fmp1.obligation_outlay_uid = fmp2.obligation_outlay_uid
      AND fmp1.financial_mitigation_plan = fmp2.financial_mitigation_plan
      AND fmp1.explanation1 = fmp2.explanation1
      AND fmp1.explanation2 = fmp2.explanation2
      AND fmp1.explanation3 = fmp2.explanation3
      AND fmp1.explanation4 = fmp2.explanation4
      AND fmp1.explanation5 = fmp2.explanation5
      AND fmp1.month + 1 = fmp2.month
      AND fmp1.obligation_outlay_uid IN
      (SELECT o.uid
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o, obligations_outlays_goals g
      WHERE
      p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND o.project_id = p.uid
      AND o.funding_id = c.uid
      AND g.appropriation = c.appropriation
      AND g.year = o.year_count
      AND o.year + o.year_count = 2014
      AND (ISNULL(o.month_1) OR (o.month_1 > TRUNCATE(a.amount *  IF(o.type LIKE ‘%Obligate%’,g.obligation_month_1, g.outlay_month_1) / 100, 2) * 1.05
      AND o.month_1 <  TRUNCATE(a.amount *  IF(o.type LIKE ‘%Obligate%’,g.obligation_month_1, g.outlay_month_1) / 100, 2) * 0.95)))