donnykurnia

sql beautifier result

Sep 17th, 2017
265
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.10 KB | None | 0 0
  1. SELECT `v_report_att`.`UserID` AS `USERID`,
  2.        `v_report_att`.`nama_pegawai` AS `nama_pegawai`,
  3.        DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m') AS `tahun_bulan`,
  4.        DATE_FORMAT(`v_report_att`.`Date`,'%Y') AS `tahun`,
  5.        DATE_FORMAT(`v_report_att`.`Date`,'%m') AS `bulann`,
  6.        DATE_FORMAT(`v_report_att`.`Date`,'%M') AS `bulan`,
  7.        TIME_FORMAT(SEC_TO_TIME(SUM(TIME_TO_SEC(`v_report_att`.`LateInHour`))),'%H:%i:%s') AS `telat`,
  8.  
  9.   (SELECT COUNT(`t_attendance`.`StatusFin`)
  10.    FROM `t_attendance`
  11.    WHERE ((`t_attendance`.`StatusFin` = 'Sakit')
  12.           AND (`t_attendance`.`UserID` = `v_report_att`.`UserID`)
  13.           AND (DATE_FORMAT(`t_attendance`.`Date`,'%Y-%m') = DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m')))) AS `sakit`,
  14.  
  15.   (SELECT COUNT(`t_attendance`.`StatusFin`)
  16.    FROM `t_attendance`
  17.    WHERE ((`t_attendance`.`StatusFin` = 'Cuti')
  18.           AND (`t_attendance`.`UserID` = `v_report_att`.`UserID`)
  19.           AND (DATE_FORMAT(`t_attendance`.`Date`,'%Y-%m') = DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m')))) AS `cuti`,
  20.  
  21.   (SELECT COUNT(`t_attendance`.`StatusFin`)
  22.    FROM `t_attendance`
  23.    WHERE ((`t_attendance`.`StatusFin` = 'Ijin')
  24.           AND (`t_attendance`.`UserID` = `v_report_att`.`UserID`)
  25.           AND (DATE_FORMAT(`t_attendance`.`Date`,'%Y-%m') = DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m')))) AS `ijin`,
  26.  
  27.   (SELECT COUNT(`t_attendance`.`StatusFin`)
  28.    FROM `t_attendance`
  29.    WHERE ((`t_attendance`.`StatusFin` = 'Terlambat')
  30.           AND (`t_attendance`.`UserID` = `v_report_att`.`UserID`)
  31.           AND (DATE_FORMAT(`t_attendance`.`Date`,'%Y-%m') = DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m')))) AS `freq_telat`,
  32.  
  33.   (SELECT COUNT(`t_attendance`.`StatusFin`)
  34.    FROM `t_attendance`
  35.    WHERE ((`t_attendance`.`StatusFin` = 'Alfa')
  36.           AND (`t_attendance`.`UserID` = `v_report_att`.`UserID`)
  37.           AND (DATE_FORMAT(`t_attendance`.`Date`,'%Y-%m') = DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m')))) AS `alfa`
  38. FROM `v_report_att`
  39. GROUP BY `v_report_att`.`UserID`,
  40.          DATE_FORMAT(`v_report_att`.`Date`,'%Y-%m')
  41. ORDER BY `v_report_att`.`UserID`,
  42.          `bulann`
Advertisement
Add Comment
Please, Sign In to add comment