Dong Shin 02.06.2014

  • fixed FA to display Req Editor window for non-admins
  • working on query for reports
    • sample query to get two consecutive months of data
    • SELECT uid,MONTH(CURDATE()) AS MONTH_NUM,
      CASE
      WHEN (MONTH(CURDATE())=10) THEN month_1
      WHEN (MONTH(CURDATE())=11) THEN month_2
      WHEN (MONTH(CURDATE())=12) THEN month_3
      WHEN (MONTH(CURDATE())=1) THEN month_4
      WHEN (MONTH(CURDATE())=2) THEN month_5
      WHEN (MONTH(CURDATE())=3) THEN month_6
      WHEN (MONTH(CURDATE())=4) THEN month_7
      WHEN (MONTH(CURDATE())=5) THEN month_8
      WHEN (MONTH(CURDATE())=6) THEN month_9
      WHEN (MONTH(CURDATE())=7) THEN month_10
      WHEN (MONTH(CURDATE())=8) THEN month_11
      WHEN (MONTH(CURDATE())=9) THEN month_12
      ELSE ‘no month’
      END
      AS month_1,

      CASE
      WHEN (MONTH(CURDATE())=10) THEN month_2
      WHEN (MONTH(CURDATE())=11) THEN month_3
      WHEN (MONTH(CURDATE())=12) THEN month_4
      WHEN (MONTH(CURDATE())=1) THEN month_5
      WHEN (MONTH(CURDATE())=2) THEN month_6
      WHEN (MONTH(CURDATE())=3) THEN month_7
      WHEN (MONTH(CURDATE())=4) THEN month_8
      WHEN (MONTH(CURDATE())=5) THEN month_9
      WHEN (MONTH(CURDATE())=6) THEN month_10
      WHEN (MONTH(CURDATE())=7) THEN month_11
      WHEN (MONTH(CURDATE())=8) THEN month_12
      ELSE ‘no month’
      END
      AS month_2
      FROM `obligations_outlays` WHERE 1