Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 06.18.2013

  • VizTool demo – went well
  • continue working on FA
    • bit tricky to get the ItemRenderer to work with XML data – QueryBuilderCheckBoxItemRenderer.mxml
    • working on ColumnFilterWindow for Funding Status

Dong Shin 06.17.2013

  • deployed new FA
  • continue working on RA/FA
    • found that RA uses ProjectAssistant for VersionTracker – fixed
    • created XML definition for Query Builder
      • each entry has name, table, columnName, type
    • changed ConfigLoader.as to put element.toString() instead of element.text().toString() so XML can be loaded properly

Dong Shin 06.14.13

  • no demo today
  • continue working on FA
    • fixed Funding Status not showing Obligated/Committed values
    • added Column Prefs to the Funding Status
    • COGNOS pull must be grouped by Budget Center, Req ID, and Contract – done
    • fixed Select Button not working for Saved Query
    • working on Query Builder for Funding Status

Dong Shin 06.12.2013

  • deployed new FA, few bugs
    • missing RA
    • Save Button in Review Contract (COGNOS) scrolls away
    • Claimed DG not refreshing properly, adding duplicates
    • Filter Unclaimed not working
    • VDividedBox not expanding Req datagrids
    • move Total to top of the list in Funding Status
    • SQL Save error on VSS
  • created a script to generate Accepted and Obligated status

Dong Shin 06.10.2013

  • continue working on FA
    • added clear COGNOS data
    • added auto pre-select COGNOS data when Requisitions are added/edited
    • working on Funding Status…
      • added simple filter area, using SQL syntax
      • added total at the end

Dong Shin 06.07.2013

  • deployed new FA – few bugs
    • upload/update COGNOS SQL bug – change center_name to center_number
    • Sub Budget Center Number cannot be added
    • add DividedBox for Requistions and Claimed/Unclaimed contracts
    • still couldn’t save the project – fixed by changing sub_center_number to sub_budget_center_number in budget_centers table
    • contracts filtering/mapping not working properly, especially for EA’s
  • continue working on FA
    • working through the list from today
    • fixed Server hanging on SQL error that causes server to be unresponsive…
    • moved Upload Data to Project Mgmt
    • changed all MIPR Description to Funding Description
    • reworking COGNOS data ingest to add more fields – done!
      • additional fields – Budget Center Name, Sub-Budget Center, Sub-Budget Center Name, Executing Budget Center, EBC Name

Dong Shin 06.06.2013

  • continue working on FA/RA
    • working off the list from today’s meeting
    • changing table names and column names to match application fields
      • budget_centers
        • funding_transaction_name -> req_description (fundingTransName, fundingTransactionName)
        • funding_transaction_number -> req_id (fundingTransNumber
        • funding_transaction_type -> req_type (fundingTransType
      • funding_transaction_names -> req_descriptions (FundingTransactionName
      • funding_transaction_numbers – > req_ids (FundingTrasactionNumber
      • funding_trasaction_types -> req_types (FundingTransactionType
  • Viz Tool meeting – copy from Phil’s blog
    • Not quite ready for the demo
    • Req Amt -> “Amount”
    • MIPR Desc -> Funding Description
    • Fix “#” tab title
    • Remove Sub-budget Center name and number from project and move to Req Line
    • Test search/auto claim (add sub-budget ctr) add debug statements so we can see what’s going on in production environment
    • Add columns for sub budget center and executing budget ctr
    • Project management screen in doubling Total Budget need to clean up tables…
    • Search functions (still!) need to be query driven
    • When searching for sub-budget centers, the default should be to cull based on the budget center prefix. There should be an additional search box which overrides the default search (* lists everything)
    • Use alert SQL to produce charts (There needs to be date information, so this may mean that we have to edit the source for text panels)
    • Fix Lenny’s email problem (may be the DB misbehaving. Bounced MySQL)
      • Date field tries to save empty string.
      • Look MySqlIf for clean up after a sql error.
    • Funding status should default to current month
    • Column names
      • Budget Center
      • Budget Center Name
      • Sub-Budget Center
      • Sub-Budget Center Name
      • Executing Budget Center
      • EBC Name
      • Appropriation Year
      • Requisition ID
      • PO Reference
      • ACR
      • Vendor Name
      • Address Line 1
      • City
      • Postal Code
      • Comitted Date
      • Comitted Amount
      • Obligation Date Obligated Amount
      • Expensed Date
      • Expensed Amount
      • Vendor ID
      • Vendor Abbr.
      • PO Start Date PO End Date
      • Contract Type
      • PO Type Code
      • Contract No.
  • Took FA offline until null date error is resolved
  • Demo is now scheduled for June 14

Dong Shin 06.05.2013

  • continue working on FA/RA
    • added check for Comments retrieval in Project Editor
    • fixed Sub Projects’ budgets not adding up correctly
    • put unclaimed and claimed datagrids in VDividedBox
    • fixed SQL error getting comments status
    • fixed Infinity number showing up in Financial Data
    • working on filtering funding status…

Dong Shin 06.04.2013

  • deployed new FA/RA – few bugs
    • COGNOS contracts not grouping correctly
    • SQL errors retrieving comments (project id = null?)
  • discussion about COGNOS ingest
  • continue working on FA/RA
    • fixed COGNOS contracts data not grouping correclty
    • added Search/Filter to Unclaimed Contracts
    • moved all the icons in source file to stylesheet (AccordionDefaults.css)
    • working on query to update requisition data on data ingest – done
      • UPDATE budget_center_contracts bcc1
        LEFT JOIN
        (SELECT bcc.uid AS tuid, c.uid as cuid
        FROM projects p, budget_centers c, budget_center_contracts bcc
        WHERE p.uid = c.project_id
        AND p.center_name = bcc.budget_center
        AND c.funding_transaction_number = bcc.requisition_id) t
        ON bcc1.uid = t.tuid
        SET bcc1.budget_center_id = cuid

Dong Shin 06.03.2013

  • continue working on RA/FA
    • Went through req’s, bugs and stuffs page.. Crossed out the ones that are taken care of
    • View Data in Project Editor disabled for the projects that has no Requistions
    • fixed Service PM not saving correctly in Requisitions
    • cleaned up too many UPDATE budget_center_contracts….
    • added icons to Project Mgmt panel

Dong Shin 05.31.2013

  • continue working on RA/FA
    • disabled View on projects with $0 funded amount
    • fixed scrollbar appearing on Total Project Budget datagrid, appears when there is no Requisition data
    • set the DateFields to editable so that it can be cleared ( set to null) in Requisition Data
      • added validators
    • added reset the login ID and password when logging out – RA/FA

Dong Shin 05.30.13

  • Viz Tool meeting
  • continue working on FA
    • changed labels on Sub Projects Panel – Add to Link, Remove to Unlink
    • added View Data, Create to Sub Projects Panel
    • Create Sub projects clears all data on current Project Editor
    • double click on a sub project sets the sub project data for the editor
    • working on View Data for sub projects – done
      • disabled on projects with the $0 funded amount – no requisitions

Dong Shin 05.29.2013

  • continue working on FA/RA
    • few bugs from today
      • inconsistent display of parent/children projects list in Project Management fixed
      • parent/child connection is broken, child/parent looks fine fixed
      • Total Project Budget datagrid shrinks (scrollbar) after saving project
      • SQL error when saving projects with sub projects
      • Totals for parent/sub projects not adding up correctly
    • getting Projects View to work with the new database structure….
    • working on Status View – done!
    • working on Line Item View
    • query to get status for projects requisition data
      • SELECT p.center_name, p.center_number, p.capability, p.appropriation, p.type, c.*, 0 as a_uid, c.total_budget as amount, o.year, o.year_count, r.duration, o.uid as o_uid,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_1), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_1), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_1_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_2), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_2_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_3), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_3), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_3_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_4), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_4), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_4_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_5), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_5), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_5_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_6), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_6), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_6_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_7), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_7), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_7_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_8), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_8), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_8_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_9), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_9), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_9_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_10), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_10), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_10_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_11), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_11), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_11_status,
        IF (c.total_budget = 0 OR o.year + o.year_count – 1 > 2013, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_12), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_12), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_12_status,
        0 as funded_budget,
        0 as funded_budget_flag,
        ‘contract number’ as contracts
        FROM budget_centers c, obligations_outlays o, appropriations r, projects p
        WHERE p.uid = 3 AND c.project_id = p.uid AND c.uid = o.funding_id AND p.appropriation = r.type
        AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
        GROUP BY c.uid, o.year, o.year_count
        ORDER BY c.uid, o.year, o.year_count