Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 05.06.2013

  • continue working on FA
    • got Project Viewer panel to display the financial data correctly – only the years the Req Data falls in
    • fixed new project saving error
  • tested freshly built VSS server and client
    • null exception for _selectedSQLObject – fixed

Dong Shin 05.03.2013

  • deployed new FA – few problems..
    • creating new Project results in SQL error fixed
      • INSERT INTO projects …. – Column count doesn’t match!
    • Sub Budget Center Name & Number not working correctly fixed
    • Un-Funded Amount = Req Amount – Funded (calculated, non-editable) – done
      • removed unfunded_amount from budget_centers table
    • Req Type should be non-addable in the combobox done
      • MIPR, REQ, EA, RTA, and EAO
    • Upload Data should delete row 1 and last two lines from the excel spreadsheet
  • built VSS and associated libs for more testing as we got weird errors on-site this morning

Dong Shin 05.02.2013

  • continue working on FA
    • obligations/outlays data updates with fiscal_year from budget_centers
    • getting View Financial Data to work with new database
      • updated Project Editor to keep appropriation in budget_centers table
      • updated Budget Information datagrid with new Req Data structure
  • burned a CD for deployment tomorrow

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