Category Archives: Dong Shin

Dong Shin 06.15.2011

  • rebuilt workspace for Flash Builder 4.5 – kept giving warnings about previous version
  • built and deployed MavenAssist – 1.9.2.12
    • http://mavenassist.sourceforge.net/updates
    • installed in Flash Builder 4.5! – couldn’t install before
    • contains flexmojos:flexbuilder bug fix – set Bypass flexmojos:flexbuilder flag in Configuration
    • add these to enable M2_REPO variable within <configuration/> in flexmojos’ <plugin/> tag
      • <enableM2e>true</enableM2e>
      • <useM2Repo>true</useM2Repo>
    • seems MavenAssist don’t work with the M2REPO settings…

Dong Shin 06.13.2011

  • installed Flash Builder 4.5 – needed SN from 4.0 to upgrade
  • SENSIAC Briefing (?) at 1:30 tomorrow!
  • PPM Changes
    • Grouped Funding Request data in Financial Status by encapsulating the UNION query into a SELECT statement and group it by uid and contract id – (SELECT * FROM (the UNION query) AS t1 ORDER BY uid, contractUid
    • Financial Status shows the one amount data from a funding request
    • disabled editing of amount data where amount is not set
    • double click to edit Contracts in Contracts Panel
    • double click to edit/view Appropriations in Appropriations Panel

Dong Shin 06.10.2011

  • PPM Changes – Trish’s review changes
    • Removed Location from Contracts in Funding Request
    • Corrected typo on OISR-PMO and OISR-TF to ISR-PMO and ISR-TF in Funding Request
    • Performance Location column in Funding Request is now editable and stored in Contracts table
    • changed FY Budget in Financial Status to total of the FY selected – not FY and the appropriation
    • added comments to roles table to describe columns
    • retrieve comments SQL – SHOW FULL COLUMNS FROM roles
    • tooltip added to the User Roles Management to show comments of the column to describe the actions

Dong Shin 06.09.2011

  • PPM Changes
    • fixed data request not deleting properly for more than one data
    • fixed  refresh of the data request not clearing data provider when no data returned
    • fixed select all and delete not working properly….
    • disable Select All checkbox when no data present in Financial Data Request
    • change DoubleClick on the Financial Data DataGrid to ItemDoubleClick
  • tried to find some Flex/ActionScript code metrics tools; Flex PMD looks good, but could not install? following command works (just the number of lines in the file).
    • find . -name ‘*.as’ -or -name ‘*.mxml’ | xargs wc -l
    • 37403 lines for PPM client
  • RichCodeAnalyserRichCodeAnalyser Screenshot

Dong Shin 06.08.2011

  • re-ran the update query and found some missing updates….
    • order of updates are important because foreign key constraint may fail!
  • reworked User Management to retrieve roles data from the database, instead of using static data
    • uploaded the latest PPM to FGMDEV for deploy – /exchange/PPM060811

    Dong Shin 06.07.2011

    • deployed the latest PPM to fgmdev.com
      • missing some table fields in update SQLs! Ugh. – fixed
      • bug in Funding Request Form editor allowing edit of only Program Element – fixed
      • fixed loggin info label not clearing up after logout

    Dong Shin 06.06.2011

    • PPM Changes
      • Roles Management  working – save works
      • disabled editing of Admin’s roles
      • changed User object to retrieve permissions on login
      • changed menu items to bind to User’s permissions
      • Project Management panel changed to take permissions

    Dong Shin 06.03.2011

    • PPM Role Permissions
      • Project – Create, Copy, Modify, Enter Monthly Status, Financial Status
      • Funding Request – Create, Modify
      • Manage Contracts
      • Manage Appropriations
      • Monthly Status Report
      • User Management – Create New User, User Management, Activate New Users
      • Utils – Local Logs, Server Logs, Query Logs, Database Management
    • Create roles table
      • DROP TABLE `user_roles`
      • DROP TABLE `roles`
      • CREATE TABLE `project_portfolio`.`roles` (
        `type` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
        `create_project` TINYINT NULL DEFAULT NULL ,
        `copy_project` TINYINT NULL DEFAULT NULL ,
        `modify_project` TINYINT NULL DEFAULT NULL ,
        `enter_monthly_status_data` TINYINT NULL DEFAULT NULL ,
        `financial_status_data` TINYINT NULL DEFAULT NULL ,
        `create_funding_request` TINYINT NULL DEFAULT NULL ,
        `modify_funding_request` TINYINT NULL DEFAULT NULL ,
        `manage_contracts` TINYINT NULL DEFAULT NULL ,
        `manage_appropriations` TINYINT NULL DEFAULT NULL ,
        `monthly_status_report` TINYINT NULL DEFAULT NULL ,
        `create_new_user` TINYINT NULL DEFAULT NULL ,
        `user_management` TINYINT NULL DEFAULT NULL ,
        `activate_new_users` TINYINT NULL DEFAULT NULL ,
        `local_logs` TINYINT NULL DEFAULT NULL ,
        `server_logs` TINYINT NULL DEFAULT NULL ,
        `query_logs` TINYINT NULL DEFAULT NULL ,
        `database_management` TINYINT NULL DEFAULT NULL ,
        PRIMARY KEY ( `type` )) ENGINE = InnoDB ;

    • working on Roles Management
      • flipped the data around to view data more friendly(?)

    Dong Shin 06.02.2011

    • PPM Changes
      • added Contract select button to Financial Status Data form so that the contracts are editable only from Contract Select Window
        • Contracts cannot be added/changed to Reimbursable (Non-Direct Cites)
        • added Update query for contracts
      • reworking Financial Status data query – not returning correct data…. – fixed
      • save Obligations and Outlays based on Direct Cite status – No Direct Cite saves the data directly to the funding_request table, direct_cites table otherwise
      • changed the way the financial status data gets saved – save at the Financial Status Data form and fire an event to refresh the data
      • looking into Role Management

    Dong Shin 06.01.2011

    • PPM Changes
      • Year selection based on Appropriation length – defaults to current month if possible
      • Year and Month changes trigger retrieval of goals data and update datagrid
      • reworked the color highlighting – compared with the goals now
      • separate Initiate/Commit
        • ALTER TABLE `funding_requests` CHANGE `initiate_commit` `initiate` DOUBLE NULL DEFAULT NULL
        • ALTER TABLE `funding_requests` ADD `commit` DOUBLE NULL DEFAULT NULL AFTER `initiate`
        • Funding Request Form changed to support initiate and commit
        • Financial Status Panel and Form changed

    Dong Shin 05.31.2011

    • PPM Changes
      • add performance_location to contracts table – ALTER TABLE `contracts` ADD `performance_location` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `location`
      • add additional_info, title_task_name to funding_request table –
        • ALTER TABLE `funding_requests` ADD `additional_info` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `statement_of_work`
        • ALTER TABLE `funding_requests` ADD `title_task_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `uid`
      • contract add/remove now working
      • modify Contract Form Window to save contracts data with new field – performace_location
    • talked to Christina/Phil about the Recruiting App, ingested the latest spreadsheet.

      Dong Shin 05.27.2011

      • additional fields needed to Funding Request – also in Bug List
        • Title/Task Name
        • Program Element in Budget Center/Funding list
        • Contracts Info: Contract Numbers, Contractor Names, Contractor Place of Performance
        • Additional Info (required so MIPR will not be rejected)
      • PPM Changes
        • fixed Create Project panel showing AddBudgetCenterWindow on double click on empty DG (itemDoubleClick)
        • funding_request table modification so that Appropriation changes reflect…
          1. ALTER TABLE `funding_requests` ADD INDEX ( `appropriation` )
          2. ALTER TABLE `funding_requests` CHANGE `appropriation` `appropriation` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
          3. ALTER TABLE `funding_requests` ADD FOREIGN KEY ( `appropriation` ) REFERENCES `project_portfolio`.`appropriations` (`type`) ON DELETE NO ACTION ON UPDATE CASCADE ;
        • update Appropriations
          1. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘O&M (FY10)’ WHERE `appropriations`.`type` = ‘FY10 O&M’;
          2. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘Procurement (FY10)’ WHERE `appropriations`.`type` = ‘FY10 Procurement’;
          3. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘RDT&E (FY10)’ WHERE `appropriations`.`type` = ‘FY10 RDT&E’;
        • added new fields to Funding Request panel
          • Title/Task Name
          • Program Element
          • Contract Info datagrid
          • Additional Info
        • created _funding_requests_contracts table to support contracts info
          1. CREATE TABLE `_funding_requests_contracts` (`funding_request_id` INT NOT NULL ,`contract_id` INT NOT NULL , INDEX ( `funding_request_id` , `contract_id` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
          2. ALTER TABLE `_funding_requests_contracts` ADD INDEX ( `contract_id` );
          3. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `funding_request_id` ) REFERENCES `project_portfolio`.`funding_requests` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
          4. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;

      Dong Shin 05.26.2011

      • PPM Changes
        • Tweaked YearComboBox to support Full Year, Year #, etc. It can use calendar year (2011 , etc) or year count (0, 1, 2, etc).
        • reworking the query to retrieve all Financial Status data –
          SELECT r.*, c.contract_number, c.name as contractor_name, c.location as contractor_location, 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 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 WHERE b.project_id = 99 AND a.uid = 1335
          UNION
          SELECT r.*, NULL as contract_number, NULL as contractor_name, NULL as contractor_location, 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 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 WHERE b.project_id = 99 AND a.uid = 1335

      Dong Shin 05.25.2011

      • lost the script I was working on yesterday… Found that the scripts are not saved on the sever
      • meeting with Trisha
        • list of changes coming
      • PPM Changes
        • changed the Appropriation types – UPDATE `project_portfolio`.`appropriations` SET `type` = 'O&M (FY10)' WHERE `appropriations`.`type` = 'FY10 O&M';
        • Appropriation ComboBox removed from Financial Status panel
        • HeaderRenderer (ComboBox) for Obligation/Outlay types removed
        • added YearComboBox and FYMonthComboBox to Financial Status panel

      Dong Shin 05.24.2011

      • not getting any useful info out of all financial data script
      • few question to convert to script
        1. What projects are under #% under budget?
        2. What managers/Financial people have project > 10%?
        3. What projects are overdue?
      • query to retrieve current year data – year 2012 is for 2011 (year = 2011 + year_count (1…))
        • SELECT p.project_number, c.center_number, a.*, o.* from projects p, budget_centers c, budget_amounts a, obligations_outlays oWHERE p.uid = c.project_id AND c.uid = a.budget_center_id AND p.uid = o.project_idAND year_count = a.year AND (o.year + o.year_count) = 2012