Monthly Archives: April 2014

Dong Shin 04.03.2014

  • deployed new FA/RA/Reqonciler along with jar files. Still no FMP shown in FA, puzzled…..
  • fixed Logger to filter the items correctly
  • updating query to speed up RA… This would do it!
    • SELECT * FROM
      (SELECT ‘OVERDUE’ AS status, bc.*
      FROM budget_centers bc
      WHERE uid IN (
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) < 2014
      AND (ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6)
      OR ISNULL(month_7) OR ISNULL(month_8) OR ISNULL(month_9) OR ISNULL(month_10) OR ISNULL(month_11) OR ISNULL(month_12))
      UNION
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) = 2014
      AND (ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6)))
      UNION
      SELECT ‘CURRENT’ AS status, bc.*
      FROM budget_centers bc WHERE uid NOT IN (
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) < 2014
      AND (ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6)
      OR ISNULL(month_7) OR ISNULL(month_8) OR ISNULL(month_9) OR ISNULL(month_10) OR ISNULL(month_11) OR ISNULL(month_12))
      UNION
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) = 2014
      AND (ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6)))
      UNION
      SELECT ‘DUE’ AS status, bc.*
      FROM budget_centers bc WHERE uid NOT IN (
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) < 2014
      AND (ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6)
      OR ISNULL(month_7) OR ISNULL(month_8) OR ISNULL(month_9) OR ISNULL(month_10) OR ISNULL(month_11) OR ISNULL(month_12))
      UNION
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) = 2014
      AND (ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6)))
      AND uid IN (
      SELECT
      oo.funding_id
      FROM obligations_outlays oo
      WHERE (oo.type LIKE ‘%PM%’ OR oo.type LIKE ‘Planned%’)
      AND (year + year_count + 1) = 2014
      AND (ISNULL(month_7)))) AS t
      LEFT JOIN committed_amounts AS ca ON t.uid = ca.budget_center_id
      LEFT JOIN projects AS p ON t.project_id = p.uid

Phil 4.3.14

8:00 – 4:00 SR

  • DB backups
  • Deployed new jars and swfs for FA. The FMP window and the debug statements is not working. And Dong still needs to add class and method info to logger for non-debug.
  • Webapps backup.
  • WebGL
  • Got a response back from JetBrains. They basically said ‘don’t load large files’. Idiots.
  • Got three.js from Git. Works fine. Yay!
  • Need to drill down into the way that translations and rotations are handled.

Phil 4.2.14

8:00 – 4:00

  • FinancialAssistant and VisibilityScriptingServer both disappeared from the server. No idea why. Maybe tied to the war file?
  • FMP popup is working in RA but not FA
  • Regex fix worked
  • Working on WebGL up and Running, but the example code crashed WebStorm. It really is that kind of day. Finally found the problem: a 14MB javascript model file. WTF?
  • Three.js is looking very nice…
  • And there is a typescript descriptor file: https://github.com/borisyankov/DefinitelyTyped/blob/master/threejs/three.d.ts

Dong Shin 04.01.2014

  • Oracle doubles the speed of MySQL query handling – found this while reading about MariaDB, upgrade soon?
  • need to run 6 queries to update Obligations/Outlays data when claim/un-claim happens…
    • update obligations (4), update outlays (5), update outlays for second year (6), update months in year 1 to 100% (101), update month 1 year 2 to 100% from month 12 year 1 (200), update months in year 2 to 100% (201)
  • worked off most of the Action Items from 3/25/2014
    • All fields with $ should accept negative values – CurrencyTextInput
    • get a list of budget values for FY13 and FY14 charts
    • create a query for Planned Obligated vs. FACTS
    • Outlay $ Reported row should not be editable
    • invoice dialog box should not show if the line item is not a MIPR or EAO
    • total budget in slides should be project total, not requistiion total
    • Req Data Analysis should show Req Allocated, Req Funded (Committed)

Phil 4.1.14

8:00 – SR

  • Nice, symmetric data today.
  • Took my comprehensive exam again. Felt much better about it. We’ll know in a month, I guess.
  • Backups.
  • Need to retire some certs. And push Lenny on his training.
  • Found the problem with the big vis query – the cell values are being single quoted, but one of thi strings contains a single quote : ‘Carla’ Demo’. So it looks like we need to strengthen the way that data is written out. Added a regex pattern that’s defined on DbTable instantiation : ^[a-zA-Z0-9 ]+
  • JavaScript/WebGL
  • Worked through my issues with my alpha “fogged” cube. A debugger would be very helpful. It looks like there is one here: http://www.gremedy.com/download.php Need to check that out. But in the meantime, here’s the better result that still doesn’t work in IE (WebGL error INVALID_ENUM in drawElements(Triangles, 36, UNSIGNED_BYTE, 0)).
  • WebGL typescript definition file, automatically generated: https://github.com/RicoP/webgl.d.ts/blob/master/README.md.
  • OBJViewer has code to read a Blender file and draw it. Nicely, this doesn’t freak out IE. The buffers must be better put together.
  • Finished the book. It looks like three.js is a wrapper that has some legs. And it will run on IE if you’re careful. Ordered the book.