- bugs
Replace “next incomplete record” tooltip with “next record”Add text following “x of y” at the bottom left to indicate what is being stepped through- Take a look at users table cascading problem
Create a script that deletes all contracts that are not being used- RemoveUnusedContracts.sql in PPM
- Flash Builder 4.6 has been crapping out on me past months continuously giving me various run time errors, ugh! – downloading 4.7 (1GB!) – working better but waiting for a license from Adobe (free upgrade from 4.5, 4.6)
- working on queries to retrieve committed (Funded Budget) for PA
- SELECT bc.*, (SELECT commit
FROM _funding_requests_budget_centers frbc, funding_requests fr, budget_centers bc
WHERE frbc.funding_request_id = fr.uid
AND frbc.budget_center_id = bc.uid AND bc.uid = 18)
FROM budget_centers bc
WHERE bc.uid = 18
- SELECT bc.*, (SELECT commit
- working on queries to retrieve contracts for PA
- SELECT GROUP_CONCAT(c.contract_number)
FROM _funding_requests_contracts frc, funding_requests fr, contracts c, projects p
WHERE frc.funding_request_id = fr.uid
AND c.uid = frc.contract_id
AND fr.project_id = p.uid
AND p.uid = 193
GROUP BY fr.uid
- SELECT GROUP_CONCAT(c.contract_number)
Category Archives: VISIBILITY
Phil 2.11.13
8:30 – 4:30 ESSO
- Bronchitis. Urk.
- Backups, and some fixing of databases, as well as acknowledging all the alerts. We really need to turn some scripts off tomorrow.
- Showed Carla how the issue was really bad labeling of what the “1 of 4” items actually were.
- Javascript
- So this is how you define an inheritable class:
- Wow – this overwrites the value in the base parent Object, so that every instance of the superclass or subclass now say “foo”:
SubType.prototype.saySuperName = function(){ return "foo"; }; - This appears to be a good way to do inheritance:
//--------- SuperType definition ------------ function SuperType(name){ this.name = name; this.nickName = "None"; this.colors = ["red", "blue", "green"]; } SuperType.prototype.setNickname = function(nickName){ this.nickName = nickName; } SuperType.prototype.sayName = function(){ alert("Name = "+this.name+", Nickname = "+this.nickName); }; //--------- SubType definition ------------ function SubType(name, age){ SuperType.call(this, name); this.age = age; } SubType.prototype = new SuperType(); SubType.prototype.sayAge = function(){ if(this.nickName == "None"){ alert(this.name+" is "+this.age+" years old"); }else{ alert(this.nickName+" is "+this.age+" years old"); } }; //----------- sequential code -------------------- var instance1 = new SubType("Nicholas", 29); instance1.setNickname("Nick"); instance1.colors.push("black"); alert(instance1.name+"'s colors are: "+instance1.colors); //"red,blue,green,black" instance1.sayName(); //"Nicholas"; instance1.sayAge(); //29 var instance2 = new SubType("Greg", 27); alert(instance2.name+"'s colors are: "+instance2.colors); //"red,blue,green" instance2.sayName(); //"Greg"; instance2.sayAge(); //27
Dong Shin 02.08.2013
- PPM
- select contract from funding request data instead of projects data in PPM for the Invoice
- removed from Financial Data Navigator in both status and line item view
- Expenditure Center
- Investment Portfolio
- Program Element
- FACTS PE
- changed Identifier to use MIPR (center_name) in Yearly View
- Reported FACTS Obligated is disabled
- added BETA image to PA
Phil 2.8.13
8:00 – 4:00 ESSO
- Backups.
- There is an issue where an item that is showing up in the Line Item View in PA and the Financial Data Entry view in PPM is not showing up in the Status View in PA. I’ve taken screenshots on what I think all the relavent pages are.
- Turns out that’s a feature. That particular project is complete, and does not remain to fill out. Dong will verify on Mondy, but we’re betting that’s the case.
- Javascript.
Dong Shin 02.07.2013
- updated PPM/PA req’s and bugs and stuff with comments from Chris and Carla
- created a script to update Reported Actual Obliated $: to Reported FACTS Obligated $: in database
- DBUpdateSQLs02072013.sql
Phil 2.7.12
8:00 – 4:00 ESSO
- Backups
- Got comments from Chris and Carla. Handed off to Dong
- Lunch with Diane
- More JavaScript
- Looking at how to implement the Data Dictionary
- Leave promptly at 4:00! Class!
Phil 2.6.13
Phil 2.5.13
8:00 – 4:00 ESSO
- Deployed new Vis2, PPM and PA. Mostly went well, except for one hiccup with the financial_remediation_plans table, that took about an hour of beating on before it submitted to our will
- Walked through the potential architecture for FA with Dong. Now we need to write it up here.
Dong Shin 02.04.2013
- phpMyAdmin has been really slow since I upgraded XAMPP to 1.8.0 which contains a Tomcat instance. Upgrading pmyMyAdmin to the latest (3.5.6) didn’t resolve it.
- Adding $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; to config.inc.php (careful with the single quotest!) as suggested at http://ellislab.com/forums/viewthread/224775/ did the trick!
- Changed PPM to require FMP’s on only Obligations and Outlays
Dong Shin 02.01.2013
- cleaned up sql scripts – fixes errors when running stored procedures with temporary/in-memory tables
- figured out how to back up stored procedures, is turned off by default
- mysqldump –routines outputfile
- need to add this to the backup script on site
- working on PPM to have only Obligations and Outlays require FMP’s
Phil 2.1.12
Spent the morning doing PhD stuff
1:30 – 5:30 ESSO
- Working on making larger fonts in tooltips. Done. Just wound up setting the gloab ToolTip and DataTips styles in the vis2.onSliderChanged() method.
- Need to set the default _labelFieldColumnName to the zeroth, column. So that code was there in WidgetBase.listColumnsHandler() for a reason. It was just being too aggressive…
Dong Shin 01.31.2013
- presentation for Col. Duke – went pretty well!
- finished up adding FMP View button – a new window and lots of back communications
- FMPs are now required for only Reported Actual Obligated and Outlay $ Reported in FACTS, others are ignored.
Phil 1.31.13
7:30 – 3:30 ESSO
- Brought in a new version of vis2, but the colors still don’t work quite right for a three-element chart
- Making larger text looks as straightforward as setting up the magnification and sizing appropriate to the conference room screen.
- Tooltips will still be a problem. Need to get the magnification value passed to them.
- Need to include the name of the Label Column when loading from XML. Fixed. For some reason I was forcing the _labelColumnField to the name of the 0th column in WidgetBase.setColumns. Dunno why.
Dong Shin 01.30.2013
- prep for Col Duke’s presentation
- latest data generation (script) and ingest – set to run every morning
- alerts ingested – need to fix the script that contains the Stored Procedure
- temporary and memory
- went over the charts with Chris
- FMP’s should only be Obligations and Outlays – tabled for discussion later
- continue working on FMPs for PA
Phil 1.29.13
8:00 – 4:00 ESSO
- Worked on getting all the data in the data visualizer for Col Dukes’ presentation on Thursday.
- Cleaned out a lot of old code, files and cruft in general.
- Had problems getting the ingestor to swallow alerts. Diagnosing this lead to a problem with Projects Under Budget. We’re about halfway through the fix for all that.
- Loaded up the latest COGNOS data
- Integrated Comitted with the rest of the FY13 data
- Javascript
- Chapter 6, or how to do OO when there is no such thing as a class in JavaScript.
- JavaScript prototypes are most peculiar.

You must be logged in to post a comment.