Category Archives: Dong Shin

Dong Shin 05.01.2013

  • continue working on FA
    • Req Info datagrid preferences saved
      • created a base class – FilterableDG that manages column preferences and saves info
    • added column filter preferences to Project Mgmt panel
      • ID column not in filter – used as tree navigation for Parent/Chile projects
    • removed the references to budget_centers table when saving projects
    • reworking Budget Info to get correct appropriation length  – done
    • noticed that sub center name and number were added to the budget_center table, not projects table – fixed
      • ALTER TABLE `projects` ADD `sub_center_name` VARCHAR( 255 ) NULL ,
        ADD `sub_center_number` VARCHAR( 255 ) NULL

Dong Shin 04.29.2013

  • debugging Tomcat webapps via Eclipse
  • continue working on FA
    • cleaning up and consolidating database
      • DELETE FROM budget_centers WHERE project_id NOT IN (SELECT uid FROM projects)
      • DELETE FROM budget_amounts WHERE budget_center_id NOT IN (SELECT uid FROM budget_centers)
      • update budget_centers table with budget_amounts data
        • UPDATE budget_centers c1
          INNER JOIN (
          SELECT a.budget_center_id as budget_center_id, begin_year + a.year – 1 AS fiscal_year_new, a.amount AS total_budget_new
          FROM projects p, budget_centers c, budget_amounts a
          WHERE a.amount <> 0
          AND p.uid = c.project_id
          AND c.uid = a.budget_center_id) T ON c1.uid = t.budget_center_id
          SET fiscal_year = t.fiscal_year_new, total_budget = total_budget_new
      • DROP TABLE budget_amounts

      • DELETE o.* FROM `obligations_outlays` o INNER JOIN budget_centers c

        ON o.funding_id = c.uid AND o.year <> c.fiscal_year;

Dong Shin 04.26.2013

  • continue working on FA
    • changed SOW to MIPR Description
    • reworked Totals Data Grid to calculate totals correctly using ArrayCollection chagen event handler
    • working on saving column preferences
      • added new column to users table
        • ALTER TABLE `users` ADD `column_preferences` TEXT NULL

Dong Shin 04.24.2013

  • deployed new FA – few bugs
    • no columns showing in Filter Columns windows – fixed
    • uploaded info is too long – set as the tooltip on the Upload Data button
    • color the Upload Data button, not the text – done

Dong Shin 04.22.2013

  • continue working on FA
    • added Funded Amount and Un-Funded Amount to Project and Sub-Project totals
    • removed totals for project and sub projects
    • working on CurrencyTextInput to be used for Req data – done
    • added more columns to budget_centers table
      • ALTER TABLE `budget_centers` ADD `fiscal_year` DECIMAL( 4 ) NULL ,
        ADD `unfunded_amount` DECIMAL( 10, 2 ) NULL
    • Totals from Req Data are calculated and updated dynamically

Dong Shin 04.19.2013

  • VizTool review
  • working down the list…
    • Change Total Budget to Requisition Amount
    • Change Funded Budget to Funded Amount
    • Remove FY columns
    • Add Fiscal Year column before Req Description
    • Add Un-Funded Amount column before Date Submitted
    • Change Update Budget Center Data to Update Requisition Data
    • Change Date Submitted to Date Submitted to Services
    • Change Date Received to Date Received from Services
    • Change Total Budget to Requisition Amount
    • Change Funded Budget to Funded Amount
    • Add Un-Funded Amount above Date Submitted
    • added Fiscal Year to AddBudgetCenterWindow

Dong Shin 04.17.2013

  • continue working on FA
    • added column filtering to Budget Center (Funding) datagrid
    • set rowCount to eliminate the empty rows
    • rearranged buttons and Totals (Allocated/Budgeted)
  • added VersionTracker to all projects
  • burned a CD for tomorrow.

Dong Shin 04.12.2013

  • deployed the new PPM, PA, and FA
    • problem with VersionTracker not creating database
    • max_allowed_packet option need to back up the visibility_scripting database
    • Lenny’s contracts data ingested successfully – ~488 rows
  • continue working on FA
    • added comments to Budget Center table
      • ALTER TABLE `budget_centers` ADD `comments` TEXT NULL
    • removed Funding Type, Org, Location from Budget Center

Dong Shin 04.10.2013

  • finished FA server coding of checking for duplicates of COGNOS contracts data….
    • a SQL PrepareStatement trick to check for null values by binding NULL
      • (? IS NULL AND budget_center IS NULL) OR (budget_center = ?)
  • tested ingesting 7500 rows at a time… no isssues running on localhost…
  • added contracts_cognos_history table to database to keep track of upload history
  • added last uploaded info label to Project Editor
  • integrated the new VersionTracker to PA!!!