• looking into Triggers for updating alerts data
• fixed some bugs on AlertsPanel
• changed colors on AlertMgmtPanel
• exported current working version to Laurel Demo
  • http://laureldemo.edge-technologies.com/FormBuilder/ProjectPortfolioMgr.html
  • Databases: userinfo and project_portfolio
  • Flex Clients
  • removed userinfo.xml for security
• meeting with Jim Murphy and others
• Action Items:
  • Invoice number for  each obligation. May be multiple invoices for each column.  Run in a popup?
  • Calculate the difference between the actual and the goal (calculated FROM % OF TOTAL).
  • Alerts have an action associated with them – fill out a report, change your spend plan, etc
  • Supervisonrs do not have to perform an action on their underling’s alert
  • Print the project creation screen for eval
  • Portfolio manager approval by supervisor based on data entered
  • MIPR EA FAD forms we newedan example of each kind of form
  • A project may have multiple forms
  • Portfolio managers need a “substitute” field

• decided parse the Alerts data on client instead of getting in the format using single SQL query (so complicated…)
• cell shows red when there is any Alert data
• modified query in AlertsMgmtPanel to return all projects data grouped by funding
• modified TableDataGrid to support Where SQL clause
• added TableDataGrid to AddAlertWindow – supports deletion of existing alerts
• AlertsManagementPanel and AddAlertWindow updates upon add/deletion of alerts

• Found Collapsable TitleWindow
  • http://myflex.wordpress.com/2008/03/05/resizable-collapsable-titlewindow/
  • modified to use ProjPortfolioMgr – developed for Flex 2!!!!
• AddAlertWindow working!
• need to expand this SQL to retrieve the Alerts data
  • select sum(if (month=1,1,0)) as month1,
    sum(if (month=2, 1, 0)) as month2,
    sum(if (month=3, 1, 0)) as month3,
    sum(if (month=4, 1, 0)) as month4,
    sum(if (month=5, 1, 0)) as month5,
    sum(if (month=6, 1, 0)) as month6,
    sum(if (month=6, 1, 0)) as month7,
    sum(if (month=6, 1, 0)) as month8,
    sum(if (month=6, 1, 0)) as month9,
    sum(if (month=6, 1, 0)) as month10,
    sum(if (month=6, 1, 0)) as month11,
    sum(if (month=6, 1, 0)) as month12,
    sum(if (month=6, 1, 0)) as month13,
    year from project_alerts  group by funding_id

• copied Query Panels and Tables Management Panels from FormBuilder and modified to work with ProjectPortfolio database – more testing needed
• added LoginScreen to main panel to enable login and logout – user info not yet set!
• created AlertsViewer for logged in user
• User Alerts checked and shown up on login
• Alerts Clear and Clear All working

• created RelationTableDataGrid and RelationTableWindow to manage relationships between tables
  • requires key, keyName, foreignKeyName, relationKeyName, tableName, relationTableName
• fixed bugs in ProjectWizard not matching table names
• need to figure out how to make TitleWindow resizable.
• made key field enabled=false in EditTableDataWindow so that the key cannot be modified
• wrap the key field with ‘ in EditTableDataWindow so it works with strings…..
• created ProjectTitlesWizard to manage (add/remove) project names

• created EditTableDataWindow for data editing
• double click on TableDataGrid brings up EditTableDataWindow
• TableDataGrid modifications
  • added remove selected functionality to TableDataGrid – multi-select not supported
  • moved the Add/Edit data windows to TableDataGrid – makes more sense since it has all the structures defined
  • pre-initialize of the columns data required to use the TableDataGrid properly,otherwise it will use default tables names and structures

• turned out that ObjectUitl.copy works for ArrayCollection….. just need to cast the object right.
  • new ArrayCollection (OjbectUtil.copy (something.source) as Array)
• Contractors and  Contract Numbers added to ObligationOverlayDataCanvas to show contract info on each of the ObligationsOverlay data.

• Questions:

1. Are Summary sections calculated or just the forms that users  enter the data?
2. Do Summary titles mean anything to data? For example, FY10 NAVY-10-004 Summary spans two years project funding, but is it FY10 data? Is the next summary data, FY11 should span 2011 to 2013?
3. How should the Obligations and Outlays be grouped?
4. The summary sections have Amount Distributed to Date. Are these static?

• added more fields to contracts.
  • contract_amount
  • contract_type
  • contract_period
  • contract_existing (boolean to indicate new or existing contract)
• created TableDataGrid to manage table data for Contracts data – useful for other tables, too.
• created AddTableDataWindow for table data entry

• played with the query for a while…. finally got it!
  • basic algorithm –
  • SELECT *, (N-1) * FROM table ( LEFT JOIN table on (conditions) ) * N-1 WHERE (condition) (AND  (N-1 conditions))
• ObjectUtils.copy() doesn’t work for Array???????
• itemEditPreEnd and itemEditPostEnd added to control user inputs and display format
  • check for invalid inputs (other than numbers and .)
  • auto formats to two decimal places
• 0 is treated as NULL in the Obligation/Outlay DataGrid
• Save Obligation/Outlay data works!
• somehow NULL fields show up as a single space character on the Obligations/Outlays DataGrid, need to look into this.
• Phil got me more data to look at.

• Obligations and Outlays data retrieval working
• formatted display data to two decimal points
• obligation outlays canvas almost working….
• the query kinds of works, but need some tuning…. cannot get rid of the null rows…

• set up users for Project Portfoli management
  • added additional fields to database table
  • modified AddUserForm and UserManagement
• created ProjectViewer to display financial/funding data
• met with Jim to clarify UI and work flow
• created Add Project Form

• started data definitions
• discussed with Phil about design approach
• added more information to user_info.user table to reflect the changes
• created database and tables
  • contract
  • invoice
  • obligations_outlays
  • project
  • project_funding
  • project_cofunding
  • project_financials
  • relationship
  • relationship_type
• defining relationships as it needs

• fixed a bug not updating default values properly in TableMgmtDG
• prepared for the demo
  • 4 different sets of data
  • created charting capability of each

• added Nullable and Default TextInput controls to TablesManagement
  • null – can be empty when inserting
  • default – default value to use when not specified
  • create and modify both working

• found a bug in FormViewer not displaying labels
  • transition from com.edgeti.* to com.fgm.* made a whole lot of messes than I thought….
• build and deployed MvnAssist 1.9

• Using Cryogenic Roadmap to test FormBuilder…..
• added login, timestamp information to tables creation
• CreateTableConfirmWindow allows alphanumeric and “_” for table names
• removed login, timestamp from ManageTableCanvas to hide from user when adding new data
• login and timestamp appended when FormViewer saves data
• added add row/record functionality to TableDataEditor
• added number of records label to TableDataEditor
• configuration of the buttons (enable/disable) based on input and data returned
• added more info to MvnAssist (1.7.9 now)