Dong Shin 04.01.2010

  • Found Collapsable TitleWindow
  • AddAlertWindow working!
  • need to expand this SQL to retrieve the Alerts data
    • select sum(if (month=1,1,0)) as month1,
      sum(if (month=2, 1, 0)) as month2,
      sum(if (month=3, 1, 0)) as month3,
      sum(if (month=4, 1, 0)) as month4,
      sum(if (month=5, 1, 0)) as month5,
      sum(if (month=6, 1, 0)) as month6,
      sum(if (month=6, 1, 0)) as month7,
      sum(if (month=6, 1, 0)) as month8,
      sum(if (month=6, 1, 0)) as month9,
      sum(if (month=6, 1, 0)) as month10,
      sum(if (month=6, 1, 0)) as month11,
      sum(if (month=6, 1, 0)) as month12,
      sum(if (month=6, 1, 0)) as month13,
      year from project_alerts  group by funding_id