- continue working on FA
- working on Query Builder
- added Obligations/Outlays/PM Actuals to the query
- added Obligations/Outlays/PM Actuals Check Boxes
- created GLOBALS.as class for global constants and static methods
- working on Query Builder
Phil 8.27.13
8:00 – 10:00 SR
- Backups
- Training
10:00 – 4:30 FP
- Goal Box – done. I had to add collision detection for determining if a TargetSphere was touching (for setup) or inside (achieving the goal). I basically wrote an axis-aligned bounding box where the radius of the TargetSphere was either added (inside) to or subtracted from (touching) the size of the GoalBox. I’m not calculating penetration, just looking for sign change on the line segment.
- Added <map> of UI_cmd to handle commands coming from the control system and results coming from the sim. Worked right the first time. Yay, C++ templates!
- Enable/disable haptics/tactors – done. It’s interesting to see how the behavior and feel of the system changes with the different capabilities enabled/disabled.
- Started working on the experiment session management
Picture for the day:
Phil 8.26.13
8:00 – 10:00 SR
- Backups
- Training
- Chris and Lenny are out – quiet!
10:00 – 4200 FP
- Working on adding test sequences and a goal box
- Added goal box. Working on rendering. I’ll need to break out the method that calculates a target’s initial placement so that it is aware of the box and is placed outside. It might actually be easier(?) to use spherical coordinates.
Dong Shin 08.26.2013
- continue working on FA
- working on Query Builder
- working on queries for Chris
- saving queries to QueryBuilderQueries.sql in resources/database/
- adding Obligations/Outlays to the Query Builder
- query to find obligaed, outlay, pm actuals
- SELECT projects.*, bc.*, bcc.*,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_1, 0)) AS obligated_month_1,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_2, 0)) AS obligated_month_2,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_3, 0)) AS obligated_month_3,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_4, 0)) AS obligated_month_4,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_5, 0)) AS obligated_month_5,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_6, 0)) AS obligated_month_6,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_7, 0)) AS obligated_month_7,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_8, 0)) AS obligated_month_8,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_9, 0)) AS obligated_month_9,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_10, 0)) AS obligated_month_10,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_11, 0)) AS obligated_month_11,
SUM(IF(o.type = ‘Reported FACTS Obligated $:’, month_12, 0)) AS obligated_month_12,SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_1, 0)) AS outlay_month_1,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_2, 0)) AS outlay_month_2,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_3, 0)) AS outlay_month_3,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_4, 0)) AS outlay_month_4,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_5, 0)) AS outlay_month_5,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_6, 0)) AS outlay_month_6,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_7, 0)) AS outlay_month_7,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_8, 0)) AS outlay_month_8,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_9, 0)) AS outlay_month_9,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_10, 0)) AS outlay_month_10,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_11, 0)) AS outlay_month_11,
SUM(IF(o.type = ‘Outlay $ (Reported in FACTS)’, month_12, 0)) AS outlay_month_12,SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_1, 0)) AS pm_actuals_month_1,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_2, 0)) AS pm_actuals_month_2,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_3, 0)) AS pm_actuals_month_3,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_4, 0)) AS pm_actuals_month_4,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_5, 0)) AS pm_actuals_month_5,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_6, 0)) AS pm_actuals_month_6,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_7, 0)) AS pm_actuals_month_7,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_8, 0)) AS pm_actuals_month_8,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_9, 0)) AS pm_actuals_month_9,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_10, 0)) AS pm_actuals_month_10,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_11, 0)) AS pm_actuals_month_11,
SUM(IF(o.type = ‘PM Actuals (Invoiced) Outlay $:’, month_12, 0)) AS pm_actuals_month_12FROM projects
RIGHT JOIN budget_centers AS bc ON projects.uid = bc.project_id
RIGHT JOIN budget_center_contracts AS bcc ON bcc.budget_center_id = bc.uid
RIGHT JOIN obligations_outlays AS o ON o.project_id = projects.uid
WHERE o.year = 2013 AND o.year_count = 1
AND (o.type = ‘Reported FACTS Obligated $:’ OR o.type = ‘Outlay $ (Reported in FACTS)’ OR o.type = ‘PM Actuals (Invoiced) Outlay $:’)
GROUP BY funding_id
Phil 8.23.13
8:00 – 10:00 SR
- Backups
- Paperwork
- Added Dimitri as a VISIBILITY user with his on role so that he can play around.
- Timesheets!
10:00 – 4:00 FP
Phil 8.22.13
8:00 – 10:00 SR
- Backups
- The Shortest Meeting Ever. Chris liked the “Planned $$” idea but wasn’t OMG. Sigh.
- Dong’s taking the rest of the day and tomorrow off.
10:00 – 5:00
- Adding a calibration feature to the Vibrotactile headset code – done
- Adding speaker wire extensions to the 5 spare actuators I’ve got – done
- Integrating sound into TargetSphere – didn’t quite make it…
Phil 8.21.13
8:00 – 10:30 SR (And 8:00 – 11:00 yesterday)
- Backups
- Walked through some issues with Pat.
10:30 – 4:30 FP
- Integrating test code and event management.
- Adding sound pointers to TargetSphere.
Dong Shin 08.20.2013
- continue working on RA/FA
- working on Auto-Fill to 100% – done. Auto-fills all the way to the end of the appropriation years
- added a ProgressBar to RequistionsView in RA
- working on QueryBuilder
Dong Shin 08.20.2013
- deployed new RA, few bugs @ requirements page
- updated financial data – $0 up to July for FY13 projects
- working on FA/RA
- clear data on logout of RA
- working on RDT&E and Procurement not creating financial data correctly…..
- fixed in FA – wasn’t getting correct Appropriation Lenth
- need to fix the database manually – FixFinancialData.sql in resources directory under FA
- FA’s user managements menus are all functional
- FA’s COGNOS Data Mgmt is functional
- working on Auto-Filling of 100%
Phil 8.19.13
8:00 – 11:00 SR
- Backups.
- Got the list of queries that Lenny and Chris think would be a good starting point.
- Working out hours remaining on FP. Sent off to brad
11:00 – 4:00 FP
- it looks like there are bugs in the audio code. It seems that you cannot do zero speed sessions. And the writing out of results with multiple sound files looks pretty confused. I’m not sure if extra CRs are being put in there or if some of the data isn’t being written out. Need to run some more examples. And I just can’t make it break. Odd.
- Fixing the state problem. Done.
- Fixing the saving issue. Also changing the naming of the speakers to reflect Dolby or not. Done.
- New version release built and deployed.
Dong Shin 08.19.2013
- continue working on FA4/RA
- working on the project status query for RA – done!
- added project budget information to RA (filterable, configurable)
- refreshing RA data keeps the filter…
- FMP/Invoice not required for Req’s with $0 funded budget
- fixed status filter not working
- working on Dynamic Panel not working – ManagedCanvas.minimizeAll()
Phil 8.16.13
8:00 – 10:00 SR
- Backups
- A little unpacking. Now that I have a desk, I can have some tea!
10:00 – 4:00 FP
Dong Shin 08.16.2013
- continue working on FA4/RA
- all components in Dynamic Panel must be wrapped in <s:Scroller /> to resize properly!
- going through the list from yesterday’s meeting
- removed Projects View
- created FilterableDGSpark for Spark DataGrid
- reworking to get status from three row types instead of all row types (Obligation Outlay Types)
- database update!
- ALTER TABLE `obligation_outlay_types` CHANGE `type` `type` VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
- ALTER TABLE `obligation_outlay_types` ADD `status` TINYINT NULL DEFAULT NULL ;
- query to get OVERDUE requisitions
- SELECT ‘DUE’ AS status, funding_id, c.* FROM (
SELECT funding_id FROM (
SELECT * FROM (
SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_1)
AND (o.type in (SELECT `type` FROM obligation_outlay_types WHERE status = 1 ))
GROUP BY year, year_count, funding_id
UNION
SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_2)
AND (o.type in (SELECT `type` FROM obligation_outlay_types WHERE status = 1 ))
GROUP BY year, year_count, funding_id
AND (o.type in (SELECT `type` FROM obligation_outlay_types WHERE status = 1 ))
GROUP BY year, year_count, funding_id
) AS q WHERE null_count = (SELECT COUNT(*) FROM obligation_outlay_types WHERE status = 1) ) AS t ) AS t2
LEFT JOIN budget_centers c ON t2.funding_id = c.uid
- SELECT ‘DUE’ AS status, funding_id, c.* FROM (
Phil 8.15.13
Phil 8:00 – 11:00 SR
- Meeting. Dong has input the list of issues
- Backed up
- Switched out PPM and PA for FA and RA on the VISIBILITY website. Could not get roles restrictions to work on the PPM directory. Need to look into that.
11:00 – 4:30 FP
- Switched out the old, glued together stack of sensors for a set of c-section parts that allow pressure on the sensor to be independent of the speaker. They keep falling off though. Trying now with more glue and cure time. I also need to get some double-stick tape.
- More glue worked!

- Modified the code so that multiple targets can exist and experimented with turning forces off.
Dong Shin 08.15.2013
- VizTool meeting – notes @ requirements page…
- working on Dynamic Panel – done!
- checked in as DynamicPanel Flex Component project
- continue working on FA4
- incorporating the new Dynamic Panel




You must be logged in to post a comment.