• browsing Budget Centers data with a project selected complete – need to go down further from the budget centers table
• working on Relational Table browser

• created Table and data classes for Budget Centers
• added routine to select project to retrieve budget centers

• added AboutDebugGroup – needs to wait until swf loaded up completely, it will fail to display compile date/time
• created TableDataForm to display individual Table data
• passing table Class objects between UI’s parse the data
• working on QueryResultAdbDataGrid to add filters/searches

• creaed RowDataBase class to support database table row
• Project VO now can use RowDataBase to display columns using dynamic class loading
• created TableDataLoader class to retrieve table data using dynamic class loading
• created ColumsSelectTitleWindow to display columns defined in the VO classes
• created TableDataSelectTitleWindow to display data from TableDataLoader

• convert to Flex Lib
• using ResizableDraggableTitleWindowSkin for PPM Widgets

• server logs’ endpoint must be set after reading config file!

• added Database, Table, Column classes to the MySQL package
• displaying tables and columns in TreeView
• added tooltips for tables and columns
• selected tables show related tables

• A Diagram of the MySQL information schema
  • http://www.xcdsql.org/MySQL/information_schema/5.1/MySQL_5_1_INFORMATION_SCHEMA.html
• find primary key of table

SELECT c.*, ke.REFERENCED_TABLE_NAME FROM
information_schema.COLUMNS c LEFT JOIN
information_schema.KEY_COLUMN_USAGE ke
USING (TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME)
WHERE
c.table_schema='test'
ORDER BY
ke.referenced_table_name;

got Tables, Primary Keys and Foreign Keys to display…

• install MacPorts xcode to get JavaHL? required by Subclipse, not working properly.
  • http://subclipse.tigris.org/wiki/JavaHL

• PM Actual Outlay tooltip added to FinancialStatusDataForm
• query – long and +gly, grabs whole year’s data
• SELECT * FROM (SELECT r.funding_amount as statusAmount, r.*, c.uid as contractUid, c.contract_number as contractNumber, c.name as contractorName, c.location as contractorLocation, c.amount as contractAmount, d.uid as directCiteUid, d.obligation_amount as dObligationAmount, d.outlay_amount as dOutlayAmount, NULL as rObligationAmount, NULL as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId, o.month_1, o.month_2, o.month_3, o.month_4, o.month_5, o.month_6, o.month_7, o.month_8, o.month_9, o.month_10, o.month_11, o.month_12 FROM funding_requests r LEFT JOIN direct_cites d ON r.uid = d.funding_request_id LEFT JOIN contracts c ON d.contract_id = c.uid LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id, obligations_outlays o WHERE b.project_id = 100 AND a.uid = 1395 AND NOT ISNULL(d.funding_request_id)  AND r.fiscal_year = 2011 AND o.year = 2011 AND o.project_id = 100 AND o.funding_id = 213 AND o.type LIKE ‘PM Actuals Outlay%’ AND o.year_count = 1 UNION SELECT r.funding_amount as statusAmount, r.*, NULL as contractUid, NULL as contractNumber, NULL as contractorName, NULL as contractorLocation, NULL as contractAmount, NULL as directCiteUid, NULL as dObligationAmount, NULL as dOutlayAmount, r.reimbursable_amount as rObligationAmount, r.outlay_amount as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId, o.month_1, o.month_2, o.month_3, o.month_4, o.month_5, o.month_6, o.month_7, o.month_8, o.month_9, o.month_10, o.month_11, o.month_12 FROM funding_requests r LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id, obligations_outlays o WHERE b.project_id = 100 AND a.uid = 1395 AND r.fiscal_year = 2011 AND r.uid NOT IN (SELECT funding_request_id FROM direct_cites) AND o.year = 2011 AND o.project_id = 100 AND o.funding_id = 213 AND o.type LIKE ‘PM Actuals Outlay%’ AND o.year_count = 1) AS T1 ORDER BY uid, contractUid, statusAmount DESC

• fixed FY Totals not showing in Financial Status
• FMP and Invoices window doesn’t come up when the monthly field changes from some value to empty
• FY Totals show on Create/Edit Project
• fixed % calculation in Financial Status

• FY Totals not showing up on Create Project Panel
• Do not show FMP when monthly data changes to null
• Funding Amount from Funding Request not showing in Financial Status
• incorrect % calculation in Financial Status
• PM Actual Outlays should come from monthly data, use it as default. If it is changed from Financial Status, keep it separate from the monthly data
• add search to appropriate panels
• embed/upload files

• Total FY Budget editable and modified budget_amounts table to support it
  • ALTER TABLE `budget_amounts` ADD `status_amount` FLOAT NOT NULL DEFAULT ‘-1’ AFTER `amount`
• fixed total calculation not working..
• saved scripts
  • projects_overdue.py, projects_under_budget.py, managers_under_budget.py

• Added check for Outlay <= Obligation
• when Outlay = 0 and Obligation = 0, don’t show it in Financial Status Form
• added Contract Value to Financial Status Form
• disable save and warn for Outlay  <= Obligation

• found that I have 0.12 M2Eclipse, couldn’t update… ended up uninstalling old and install the latest thru Eclipse Marketplace

• added BlazeDS 4.0 to FGMDEV’s Nexus repo – com.adobe.blazeds:4.0.0.14931
  • flex-messaging-common
  • flex-messaging-core
  • flex-messaging-opt
  • flex-messaging-proxy
  • flex-messaging-remoting
  • flex-rds-server
• add following lines to your settings.xml in <repositories/> section for Blaze DS 4.0

• change length of Description in Funding Request and remove maxLength validation
• ALTER TABLE `funding_requests` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
• fixed Obligation/Outlay showing where it shouldn’t – no data in funding request, but in Direct Cites
• database change – DBUpdateSQLs08022011.sql

• ALTER TABLE <table_name> COMMENT = “editable”;