Category Archives: Dong Shin

Dong Shin 02.25.2011

  • PPM
    • created DBUpdateSQLs02252011.sql for adding data request tables
    • working on Project export
      • Get all budget centers and amounts query
        SELECT
        c.center_name as `Budget Center`,
        c.center_number as Number,
        GROUP_CONCAT(if(a.year=1,a.amount,NULL)) as FY1Amount,
        GROUP_CONCAT(if(a.year=2,a.amount,NULL)) as FY2Amount,
        GROUP_CONCAT(if(a.year=3,a.amount,NULL)) as FY3Amount,
        c.appropriation as Remarks
        FROM projects p, budget_centers c, budget_amounts a
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND p.uid = 96
        GROUP BY a.budget_center_id

        SELECT c.center_name as `Budget Center`,c.center_number as Number,
        GROUP_CONCAT(if(a.year=1,a.amount,NULL)) as FY1Amount,GROUP_CONCAT(if(a.year=2,a.amount,NULL)) as FY2Amount,GROUP_CONCAT(if(a.year=3,a.amount,NULL)) as FY3Amount,
        c.appropriation as Remarks
        FROM projects p, budget_centers c, budget_amounts aWHERE p.uid = c.project_idAND c.uid = a.budget_center_idAND p.uid = 96GROUP BY a.budget_center_id

    • Array Collection not returning data in ordered manner? May have to write own parser…

Dong Shin 02.24.2011

  • PPM
    • added reset filters on Requests Data
    • joining projects, budget_centers, appropriations doesn’t return projects with 0 budget because those might not have budget centers data – fixed by adding OR p.total_budget = 0 in the query
    • removed colors for projects and added status – incomplete gets red
    • rearranged project filter buttons
    • reworked Active Year filters
    • added tooltips to projects datagrid

Dong Shin 02.23.2011

  • Verified that FGMDEV backup works
  • My Eclipse is not behaving!
    • hangs at Loading Web Service DOM….
    • found a offending bug on WTP – related to Tomcat?
    • adding -clean to eclipse.ini resolved it temporarily
    • moved projects to different workspace…
  • PPM
    • Request filtering using Year, Month, Description and Status
    • Project filtering (Active Project) based on Start and End Year range using appropriation length

Dong Shin 02.22.2011

  • FGMDEV backups working….
  • PPM
    • rearranging components to support Active Project search…
    • Project filtering query…..
      SELECT p.begin_year, (p.end_year+MAX(a.duration)) as end_year, p.uid
      FROM budget_centers c, projects p, appropriations a
      WHERE c.project_id = p.uid AND c.appropriation = a.type
      GROUP BY p.uid

Dong Shin 02.21.2011

  • FGMDEV Backup – noticed deletion not working properly, modified the script. check tomorrow…
  • PPM
    • Added DataRequestsEmailsWindow, RequestEmailTextHBox to support multiple request email generation from DataRequestPanel
    • continue working on Excel export….

Dong Shin 02.18.2011

  • FGMDEV backup is working… yeah!
  • PPM Changes
    • set dataProviders manually so that filtering doesn’t flicker between all list and filtered list in DataRequestFormWindow
    • filtering added to Users in DataRequestFormWindow
    • Status filtering ComboBox and Description filtering textbox added to DataRequestPanel. This work together as a filtering set.

Dong Shin 02.17.2011

  • FGMDEV backup working….. check again tomorrow.
  • PPM
    • creating queries for project export…. would like to put all the calculation on queries.
    • got feedback on Data Request
      • moved Users and Project to DataRequestFrom
      • added color-coded status for the Requests
      • added CheckBox filters to show selected/saved users and projects

Dong Shin 02.16.2011

  • FGMDEV backup still not working
    • tweaked the script to use /exchange/backups directory…
  • PPM
    • server code is out of sync, saved all the changes, rechecked in and out.
    • working on Project export
    • Security error when trying to save Excel file…
      • Error: Error #2176: Certain actions, such as those that display a pop-up window, may only be invoked upon user interaction, for example by a mouse click or button press.
      • for security reason, FileReference.save() must be initiated from a user interaction… Arrrgh!
      • Added Alert to confirm save
    • Changed EdgeUtils.ExportUtils to have an option of saving files with and without header
  • Eclipse and Tomcat server configuration using Maven for Dynamic Web Project
    1. set up your Tomcat server instance within Eclipse IDE
    2. generate Eclipse project settings from the pom.xml you created, the packaging type must be war to use this feature.
      • mvn eclipse:eclipse -Dwtpversion=1.5
    3. web.xml may need some changes as Eclipse complains about the order of elements within <webapp/>. Follow this order….
      1. icon
      2. display-name
      3. description
      4. distributable
      5. context-param
      6. filter
      7. filter-mapping
      8. listener
      9. servlet
      10. servlet-mapping
      11. session-config
      12. mime-mapping
      13. welcome-file-list
      14. error-page
      15. taglib
      16. resource-env-ref
      17. resource-ref
      18. security-constraint
      19. login-config
      20. security-role
      21. env-entry
      22. ejb-ref
      23. ejb-local-ref
    4. add the project to the server by right clicking the Tomcat server in Servers view and selecting Add and Remove in the context menu.
      • got weird errors, “Validation Message” that points to nowhere… no effect on building projects, though.
    5. set a break point, stop and start the server in Debug… now you can debug your Java/Server code!

Dong Shin 02.15.2011

  • FGMDEV backup still not working
    • put absolute paths in the script
  • PPM
    • continue working on Data Requests – primary functions added
      • create and save requests by selecting users and projects
      • update requests – change status, description, month, and year
      • added textArea for email
      • printed screenshots for review

Dong Shin 02.14.2011

  • FGMDEV backup still not behaving
    • created a separate script that dumps database an hour before the ftp transfer….
  • PPM Changes
    • added Export testing button for Project Mgmt Panel for Beta only….
    • added email, phone/fax to MIPR Request Form
    • uploaded the latest PPM for release/testing to /exhange/PPM_021411
    • working on email request generator
      • created data_requests table
      • created _data_requests_projects table
      • created _data_requests_users table
      • set up relations between tables

Dong Shin 02.11.2011

  • PPM Changes
    • Working on data email generator
    • Working on a sandbox app to save datagrid data to excel file – donefla
    • added a test button to Project Mgmt to test exporting – works!
    • added ExportUtils to EdgeUitls
    • deployed com.as3xls.as3xls:1.0:swc to FGMDEV Nexus
      • <dependency>
        <groupId>com.as3xls</groupId>
        <artifactId>as3xls</artifactId>
        <version>1.0</version>
        <type>swc</type>
        </dependency>
  • Flash running at the site is v10.0

Dong Shin 02.10.2011

  • while searching for ways to save PPM data into excel format, found
  • PPM Changes
    • saving database changes to DBUpdateSQLs02102011.sql
    • Funding Request Changes
      • larger mailing address POC
      • added email and phone/fax for mailing address POC
      • two more fields to funding_requests table – mailing_address_email and mailing_address_phone
        • ALTER TABLE `funding_requests` ADD `mailing_address_email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `mailing_address` ,
          ADD `mailing_address_phone` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `mailing_address_email`
      • removed Contracts from Reimbursable
      • Add Contract added to Direct Cite window
      • added a new field to contracts table
        • ALTER TABLE `contracts` ADD `ACRN` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `contract_number`
      • remove all, but FY and Budget Center in BudgetCentersWindow for Financial Status
    • working on a pivot query to return financial data for selected project, month, year
      • find all first month data for year 2011 from projects and obligations_outlays tables
        SELECT year, project_id, year_count,
        GROUP_CONCAT(IF(type=’Planned Obligated $:’, month_1, NULL)) AS ‘Planned Obligated $:’,
        GROUP_CONCAT(IF(type=’Reported Actual Obligated $:’, month_1, NULL)) AS ‘Reported Actual Obligated $:’,
        GROUP_CONCAT(IF(type=’Planned Outlay $:’, month_1, NULL)) AS ‘Planned Outlay $:’,
        GROUP_CONCAT(IF(type=’Reported Outlay $:’, month_1, NULL)) AS ‘Reported Outlay $:’,
        GROUP_CONCAT(IF(type=’PM Actuals Outlay $:’, month_1, NULL)) AS ‘PM Actuals Outlay $:’,
        GROUP_CONCAT(IF(type=’Outlay $ (Reported in FACTS)’, month_1, NULL)) AS ‘Outlay $ (Reported in FACTS)’,
        p.*
        FROM obligations_outlays o, projects p
        WHERE year = 2011 AND year_count = 1 AND o.project_id = p.uid
        GROUP BY year_count, year, project_id
        ORDER BY project_id, year

Dong Shin 02.08.2011

  • PPM Changes
    • created SelectContractWindow that has filtering/searching capabilities, mapped to Funding Request
    • consolidated many buttons in ProjectMgmtPanel into PopUpButton
      • disabled click, works like ComboBox
    • added support to view Project Status from Main menu
    • fixed Start / End date validation
  • FGMDEV backup
    • dump files still not getting to the server
    • created and configured second script to transfer that runs one hour after the first one – check tomorrow.

Dong Shin 02.08.2011

  • FGMDEV backup
    • still missing database dump files….
    • modified the script to tar up the dump files and transfer, check tomorrow
  • PPM Changes
    • FinancialStatusDataGrid acting weird… Could not select anything other than last one. Turned out the uid field in the class causing it. Had same uid’s populated on the data. Changed it to dataUid, works now….
    • Errors reported on the latest deployed version
      • changed Create Project to set program_element and FACTS_PE fields to NULL for existing data
      • updated server code to remove INSERTs
    • Fixing bugs
      • Funding request warning dialog has “financial” misspelled as “fianancial”.
      • Removed limit of data in Names list  – had 100 entries
      • Increased width of Contract Number in Direct Cite Window
      • added RTAs to Funding Type
      • check for Start Date and End Date, also disables dates based on selection
      • working on SelectContractWindow