Dong Shin 06.22.2012

  • fixed SQL error when apostrophe(‘) is present in Funding Request fields
  • fixed disappearing Labels for the horizontal navigator (Data and Chart) in Financial Data (Monthly Data) panel
  • track last login – added server code to update users, last_login column to user table
  • working on sub/parent projects navigation…
    • removed ProjectBudgetWindow for sub projects, replaced it with Project Editor when double-clicking
    • added yearly budget details for sub projects
    • query to retrieve all funding summary
      • SELECT p1.project_number AS projectID, p1.title AS projectName, p1.begin_year AS startFY, p1.end_year AS endFY, p1.total_budget AS totalBudget, p2 . *, c.*,
        SUM(IF(a.year=1, a.amount, NULL)) as year1Amount,
        SUM(IF(a.year=2, a.amount, NULL)) as year2Amount,
        SUM(IF(a.year=3, a.amount, NULL)) as year3Amount,
        SUM(IF(a.year=4, a.amount, NULL)) as year4Amount,
        SUM(IF(a.year=5, a.amount, NULL)) as year5Amount,
        SUM(IF(a.year=6, a.amount, NULL)) as year6Amount,
        SUM(IF(a.year=7, a.amount, NULL)) as year7Amount,
        SUM(IF(a.year=8, a.amount, NULL)) as year8Amount,
        SUM(IF(a.year=9, a.amount, NULL)) as year9Amount,
        SUM(IF(a.year=10, a.amount, NULL)) as year10Amount
        FROM projects p1, _project_sub_projects p2, budget_centers c,
        budget_amounts a
        WHERE p2.project_id =99
        AND p2.sub_project_id = p1.uid
        AND c.project_id = p2.sub_project_id
        AND c.uid = budget_center_id
        GROUP BY c.project_id