- continue working on FA/RA
- added check for Comments retrieval in Project Editor
- fixed Sub Projects’ budgets not adding up correctly
- put unclaimed and claimed datagrids in VDividedBox
- fixed SQL error getting comments status
- fixed Infinity number showing up in Financial Data
- working on filtering funding status…
Category Archives: VISIBILITY
Dong Shin 06.04.2013
- deployed new FA/RA – few bugs
- COGNOS contracts not grouping correctly
- SQL errors retrieving comments (project id = null?)
- discussion about COGNOS ingest
- continue working on FA/RA
- fixed COGNOS contracts data not grouping correclty
- added Search/Filter to Unclaimed Contracts
- moved all the icons in source file to stylesheet (AccordionDefaults.css)
- working on query to update requisition data on data ingest – done
- UPDATE budget_center_contracts bcc1
LEFT JOIN
(SELECT bcc.uid AS tuid, c.uid as cuid
FROM projects p, budget_centers c, budget_center_contracts bcc
WHERE p.uid = c.project_id
AND p.center_name = bcc.budget_center
AND c.funding_transaction_number = bcc.requisition_id) t
ON bcc1.uid = t.tuid
SET bcc1.budget_center_id = cuid
- UPDATE budget_center_contracts bcc1
Phil 6.4.13
8:00 – 11:30 SR
- Backups and disk cleaning
- Conversation with Lenny about how to handle COGNOS uploads
- non MIPR/EAO are all manually claimed
- (MIPRs and EAOs) get automatically mapped, and don’t have to go through the claiming process (budget center and Req ID match the budget line item)
- All unclaimed should always be shown.
- If a MIPR line item is incorrectly claimed, it can be unclaimed, at which point it will have to be manually claimed
11:30 – 4:30 FP
- Making nice clean classes for audio
- Emitter goes into the SampledSound base class – done. Almost easy, though I had to go and relearn how C++ constructors work. Gawd, it’s been a while…
- Everything else goes into BasicAudio – done. Had some problems with frequency until I realized that I hadn’t zeroed out the listener velocity.
- And actually, I need to be able to set velocity for doppler effects. Need to add methods like the position methods tomorrow.
Phil 6.3.13
8:00 – 11:00 SR
- Backups
- Got the paperwork to start on getting client sites hooked up to the main system
- Bugs
- Lenny did the following and got some kind of NULL sql error. It may have happened to Carla as well
- Created a project
- Added service PM on the project tab
- saved
- Deleted the PM from the project (first tab)
- Added a Req on the second tab
- Added the same (now deleted) service PM to the Req.
- Clicked ‘update’, which threw the SQL error
- clicked close
- Checked the record, and everything appeared to be saved properly
- Other req updates using the same sequence did not cause the error
- The goal is thenter one EA line item and then link multiple req’s out of unclaimed to it. Is this possible?
- Unclaimed needs to roll up and subtotal all lines (just with matching req’s? Not sure what to do about blanks, unless there is a way to find other matching sequences)
- There are a heck of a lot of “UPDATE budget_center_contracts SET budget_center_id= NULL where uid = xx”. It’s probably a good 70% of the logs.
- Lenny did the following and got some kind of NULL sql error. It may have happened to Carla as well
11:00 – 4:30 FP
- Well, after two days of not being able to work on this due to Comps prep and trouble with a significant fraction of my vehicles, maybe I can get some 3D audio working today.
- Added everything from How to: Integrate X3DAudio with XAudio2, and definitely got a result – when the emitter position moved off of center, the sound cut out. Now you might think that’s a bad thing, but my guess is that I have some variable that either being set with zero or junk, which is messing up the sound matrix calculations.
- Using the XAudio2Sound3D project as a source of code to mine, I pulled over the (much more extensive) emitter setup and now have things working, although not as clearly as I’d like. Next is to clean up and package the code into the SampleSound-derived classes.
- And by the way, this might be a good hard hat to try the rig on: http://www.amazon.com/ERB-19224-Americana-Full-Ratchet/dp/B001LYB7JW
- Cleared a lot of nonessential (i.e. listening cone)code out of the emitter
- Realized that I could probably use voice->SetOutputMatrix() to set the channels directly. I added a method that cleans out the dspSettings.matrixCoefficients and then sets a single value in the matrix. Whadaya know – it worked

- Need to do some packaging of the code, but I now have enough to do tests for the situational awareness system and to get rid of the MIDI boards for the vibrotactile controller.
Dong Shin 06.03.2013
- continue working on RA/FA
- Went through req’s, bugs and stuffs page.. Crossed out the ones that are taken care of
- View Data in Project Editor disabled for the projects that has no Requistions
- fixed Service PM not saving correctly in Requisitions
- cleaned up too many UPDATE budget_center_contracts….
- added icons to Project Mgmt panel
Dong Shin 05.31.2013
- continue working on RA/FA
- disabled View on projects with $0 funded amount
- fixed scrollbar appearing on Total Project Budget datagrid, appears when there is no Requisition data
- set the DateFields to editable so that it can be cleared ( set to null) in Requisition Data
- added validators
- added reset the login ID and password when logging out – RA/FA
Phil 5.31.13
7:30 – 10:30 SR
- Backups – I wonder if I can have the output go through a script that counts the number of “copied” and “moved” to report if the entire script executed correctly? Have to look into that.
- Took the projportfolio debug login out of setup.xml
- Took care of various paperwork, including resume stuff
10:30 – 3:30 TIMEOFF
- Arranged to get the Porsche towed. Well no, that was an adventure in itself, and basically killed the rest of the day.
- Scheduled service for motorcycle
- Handed in tuition paperwork
Dong Shin 05.30.13
- Viz Tool meeting
- continue working on FA
- changed labels on Sub Projects Panel – Add to Link, Remove to Unlink
- added View Data, Create to Sub Projects Panel
- Create Sub projects clears all data on current Project Editor
- double click on a sub project sets the sub project data for the editor
- working on View Data for sub projects – done
- disabled on projects with the $0 funded amount – no requisitions
Phil 5.30.13
7:30 – 10:30 SR
- Direct Cite/Reimbursable – separate lines
- Comitted date changes to latest
- Set date(s) nullable
- Reports on Committed and Obligated dates (future)
- Total in Proj Mgmt incorrect
- Add “Create Project” to sub project line
- Add “View Financial Data” to sub project line
- Double clicking should bring up subproject
- FACTS PE resetting to null?
- Reset login on logout
- Verify that “Add” subproject moves a root-level project and that Remove does the same
- Add -> “link”
- Remove -> “unlink”
- Double-clicking on a subproject shouold switch the project view to the subproject
- Add a check for no budget data so that “view data” does not hang
- “view data” contract info should come from COGNOS pull.
- In “Funding Status” have a TOTALS line above the main grid that totals up the columns with numbers
- Be able to add/remove columns created by the query
- Be able to have public/private queries
10:30 – 5:30 TIMEOFF
- Prepping for comps meeting this evening. If I get done early, I’ll go back to XAudio
Phil 5.29.13
8:00 – 1:00 SR
- Backups
- There was a demo today! Was invited in towards the end to talk about data security and roles.
- Had a good idea about how to run the PA/RA code on one of our (Dreamhost? Steadfast?) servers and let the labs input their data directly. We could then ingest the data nightly. Need to research this a bit.
1:00 – 4:00 FP
- Finished rolling up the SampleSounds(s) into BasicAudio.
- Starting on 3D audio, using How to: Integrate X3DAudio with XAudio2
- Adding the 3D calls to the main() in ConsoleSound2, just after the BasicAudio class has been initialized.
- Had to add x3daudio.lib to the project and <x3daudio.h> to the #includes.
- This looks to be the meat of the calculation. It looks like X3DCalculate() works on the relative position of an Emitter and the Listener and uses that to populate a DSP. Once that’s done, then the Audio2 source is manipulated appropriately.
-
X3DAudioCalculate( g_audioState.x3DInstance, &g_audioState.listener, &g_audioState.emitter, dwCalcFlags, &g_audioState.dspSettings ); IXAudio2SourceVoice* voice = g_audioState.pSourceVoice; if( voice ) { // Apply X3DAudio generated DSP settings to XAudio2 voice->SetFrequencyRatio( g_audioState.dspSettings.DopplerFactor ); voice->SetOutputMatrix( g_audioState.pMasteringVoice, INPUTCHANNELS, g_audioState.nChannels, g_audioState.matrixCoefficients ); voice->SetOutputMatrix(g_audioState.pSubmixVoice, 1, 1, &g_audioState.dspSettings.ReverbLevel); XAUDIO2_FILTER_PARAMETERS FilterParametersDirect = { LowPassFilter, 2.0f * sinf(X3DAUDIO_PI/6.0f * g_audioState.dspSettings.LPFDirectCoefficient), 1.0f }; // see XAudio2CutoffFrequencyToRadians() in XAudio2.h for more information on the formula used here voice->SetOutputFilterParameters(g_audioState.pMasteringVoice, &FilterParametersDirect); XAUDIO2_FILTER_PARAMETERS FilterParametersReverb = { LowPassFilter, 2.0f * sinf(X3DAUDIO_PI/6.0f * g_audioState.dspSettings.LPFReverbCoefficient), 1.0f }; // see XAudio2CutoffFrequencyToRadians() in XAudio2.h for more information on the formula used here voice->SetOutputFilterParameters(g_audioState.pSubmixVoice, &FilterParametersReverb); }
Dong Shin 05.29.2013
- continue working on FA/RA
- few bugs from today
inconsistent display of parent/children projects list in Project Managementfixedparent/child connection is broken, child/parent looks finefixed- Total Project Budget datagrid shrinks (scrollbar) after saving project
- SQL error when saving projects with sub projects
- Totals for parent/sub projects not adding up correctly
- getting Projects View to work with the new database structure….
- working on Status View – done!
- working on Line Item View
- query to get status for projects requisition data
- SELECT p.center_name, p.center_number, p.capability, p.appropriation, p.type, c.*, 0 as a_uid, c.total_budget as amount, o.year, o.year_count, r.duration, o.uid as o_uid,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_1), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_1), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_1_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_2), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_2_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_3), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_3), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_3_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_4), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_4), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_4_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_5), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_5), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_5_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_6), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_6), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_6_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_7), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_7), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_7_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_8), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_8), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_8_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_9), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_9), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_9_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_10), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_10), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_10_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_11), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_11), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_11_status,
IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_12), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_12), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_12_status,
0 as funded_budget,
0 as funded_budget_flag,
‘contract number’ as contracts
FROM budget_centers c, obligations_outlays o, appropriations r, projects p
WHERE p.uid = 3 AND c.project_id = p.uid AND c.uid = o.funding_id AND p.appropriation = r.type
AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
GROUP BY c.uid, o.year, o.year_count
ORDER BY c.uid, o.year, o.year_count
- SELECT p.center_name, p.center_number, p.capability, p.appropriation, p.type, c.*, 0 as a_uid, c.total_budget as amount, o.year, o.year_count, r.duration, o.uid as o_uid,
- few bugs from today
Phil 5.28.13
8:00 – 10:30 SR
- Backups
10:30 – 4:00 FP
- Comments on Ravi’s proposal
- Working on getting multi buffer support. Done! Also got repeating sound working.
- Going to put a basic Audio class together to manage SampleSounds.
Dong Shin 05.28.2013
- continue working on RA/FA
- contracts are now selectable/searchable in invoices
- FMP’s working
- working on Project View
Dong Shin 05.24.2013
- deployed new FA/RA – everything seems well
- continue working on FA/RA
- working on Invoices to use new COGNOS contracts data
Phil 5.24.13
7:30 – 11:00 SR
- Backups. And to make sure that it’s possible to see the results of the db backup script, I added in a “pause.exe” at the end of the batch file.
- Deployed the new FA and RA
- RA was taking a *long* time to start up. It turns out that the reason was that there were 17,000 alerts that were going into a DataGrid. The temporary fix was to delete the old alerts, but there needs to be a mechanism for determining/limiting what to show.
11:00 – 4:30FP
- Building a copy of XAudio2BasicSound, cleverly calling ConsoleSound2.
- Since it depends on SDKwavefile, I had to pull SAFE_DELETE, SAFE_DELETE_ARRAY, and SAFE_RELEASE from dxut.h. It also requires dxerr.h. but that’s in the regular directx include directory.
- Extremely empty code right now, but it compiles and links. On a side note, the compiler should accept the environment variable $(DXSDK_DIR), but it doesn’t. And adding macros is an enormous pain, as near as I can tell.
- The code is ported over and works. It’s all stuck in a main() right now. I need to clean up and build an Audio class. Actually, looking at the way the code is set up, a WavSampleSound class might be better. It probably could extend from a SampleSound class, but I’ll break that out later…
- Class is mostly done and running!
-


You must be logged in to post a comment.