Category Archives: Projects

Phil 2.13.13

7:30  – 3:30 ESSO

  • Still feel like crap, though I am now on antibiotics.
  • Meetings until noon. Dong is going to handle the Capability Review.
  • Changed Reported Actual Obligated to Reported FACTS Obligated in project_portfolio
  • Stated digging into YUI. While looking for an IDE, stumbled upon Cloud9 (c9.io), which is a cloud-based IDE developed initially for JavaScript, with jsHint support. Trying out some YUI code from the book. So far, so good! No server side Java support though. Need to see if the code can reach out to a dev server.

Phil 2.12.13

8:30 – 4:30 ESSO

  • Was going to go to CASPORT users group, but had to write a status report for Jim G. instead.
  • Backups
  • More Javascript OO programming today…
  • The Yahoo! User Interface (YUI) library was the first to include parasitic combination inheritance in a widely distributed JavaScript library via the Y.extend() method. YUI is a free, open source JavaScript and CSS library for building richly interactive web applications.” Nice documentation and examples…
  • Jumped ahead to tools and found jshint, which is at http://jshint.com. There is also another lint, JavaScript Lint that runs in windows explorer. it’s here: http://www.javascriptlint.com
  • Ok, I think I’m going to try some YUI tutorials. Confident enough to get the Kindle edition of the YUI 3 Cookbook. I need some standalone examples.

Dong Shin 02.11.2013

  • 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
  • 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

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.

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

8:00 – 4:00 ESSO

  • Meeting with Chris, Thom, Carla, Lenny and Dong. The notes are here.
  • Some cleanup for Diane’s visit tomorrow. Also asked Dimitri for permission to charge overhead for the real move to WCC
  • Went through the design of FA with Dong, which is all here.

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.