Dong Shin 11.09.2011

  • updating UI…
  • updated __view_budget_center_appropriation view to calculate total_budget correctly (__view_budget_center_appropriation.sql)
    • CREATE OR REPLACE
      ALGORITHM = UNDEFINED
      VIEW `__view_budget_center_appropriation`
      AS select budget_centers.uid AS uid,budget_centers.project_id AS project_id,budget_centers.center_number AS center_number,
      budget_centers.center_name AS center_name,budget_centers.funding_transaction_name AS funding_transaction_name,budget_centers.
      funding_transaction_number AS funding_transaction_number,
      budget_centers.funding_transaction_type AS funding_transaction_type,
      budget_centers.capability AS capability,budget_centers.expenditure_center AS expenditure_center,
      budget_centers.investment_portfolio AS investment_portfolio,budget_centers.appropriation AS appropriation,
      SUM(budget_amounts.amount) as total_budget, budget_centers.type AS type,budget_centers.program_element AS program_element,
      budget_centers.facts_pe AS facts_pe,appropriations.duration AS duration,appropriations.status AS status
      from budget_centers, appropriations, budget_amounts WHERE budget_centers.appropriation = appropriations.type
      AND budget_centers.uid = budget_amounts.budget_center_id
      GROUP BY budget_amounts.budget_center_id