SELECT T.* 
FROM(
SELECT
	CASE
		WHEN ltrim(substr(A."MONTH_ID", 1, 4), '0') IS NULL THEN NULL
		ELSE ltrim(substr(A."MONTH_ID", 1, 4), '0') 
	END "考勤年份",
	CASE
		WHEN ltrim(substr(A."MONTH_ID", 5, 2), '0') IS NULL THEN NULL
		ELSE ltrim(substr(A."MONTH_ID", 5, 2), '0') || '月'
	END "考勤月份",
	CASE
	WHEN ltrim(substr(A."MONTH_ID", 5, 2), '0') IS NULL THEN NULL
	ELSE ltrim(substr(A."MONTH_ID", 5, 2), '0') 
	END "查询月份",
	A."GRP_NAME" "用户组",
	A."ACCOUNT_NO" "用户名",
	A."USER_NAME" "姓名",
	max(CASE WHEN A."DAY_ID" = '01' THEN A."CHECK_SQUATE_NAME1" END ) "C_1",
	max(CASE WHEN A."DAY_ID" = '02' THEN A."CHECK_SQUATE_NAME1" END ) "C_2",
	max(CASE WHEN A."DAY_ID" = '03' THEN A."CHECK_SQUATE_NAME1" END ) "C_3",
	max(CASE WHEN A."DAY_ID" = '04' THEN A."CHECK_SQUATE_NAME1" END ) "C_4",
	max(CASE WHEN A."DAY_ID" = '05' THEN A."CHECK_SQUATE_NAME1" END ) "C_5",
	max(CASE WHEN A."DAY_ID" = '06' THEN A."CHECK_SQUATE_NAME1" END ) "C_6",
	max(CASE WHEN A."DAY_ID" = '07' THEN A."CHECK_SQUATE_NAME1" END ) "C_7",
	max(CASE WHEN A."DAY_ID" = '08' THEN A."CHECK_SQUATE_NAME1" END ) "C_8",
	max(CASE WHEN A."DAY_ID" = '09' THEN A."CHECK_SQUATE_NAME1" END ) "C_9",
	max(CASE WHEN A."DAY_ID" = '10' THEN A."CHECK_SQUATE_NAME1" END ) "C_10",
	max(CASE WHEN A."DAY_ID" = '11' THEN A."CHECK_SQUATE_NAME1" END ) "C_11",
	max(CASE WHEN A."DAY_ID" = '12' THEN A."CHECK_SQUATE_NAME1" END ) "C_12",
	max(CASE WHEN A."DAY_ID" = '13' THEN A."CHECK_SQUATE_NAME1" END ) "C_13",
	max(CASE WHEN A."DAY_ID" = '14' THEN A."CHECK_SQUATE_NAME1" END ) "C_14",
	max(CASE WHEN A."DAY_ID" = '15' THEN A."CHECK_SQUATE_NAME1" END ) "C_15",
	max(CASE WHEN A."DAY_ID" = '16' THEN A."CHECK_SQUATE_NAME1" END ) "C_16",
	max(CASE WHEN A."DAY_ID" = '17' THEN A."CHECK_SQUATE_NAME1" END ) "C_17",
	max(CASE WHEN A."DAY_ID" = '18' THEN A."CHECK_SQUATE_NAME1" END ) "C_18",
	max(CASE WHEN A."DAY_ID" = '19' THEN A."CHECK_SQUATE_NAME1" END ) "C_19",
	max(CASE WHEN A."DAY_ID" = '20' THEN A."CHECK_SQUATE_NAME1" END ) "C_20",
	max(CASE WHEN A."DAY_ID" = '21' THEN A."CHECK_SQUATE_NAME1" END ) "C_21",
	max(CASE WHEN A."DAY_ID" = '22' THEN A."CHECK_SQUATE_NAME1" END ) "C_22",
	max(CASE WHEN A."DAY_ID" = '23' THEN A."CHECK_SQUATE_NAME1" END ) "C_23",
	max(CASE WHEN A."DAY_ID" = '24' THEN A."CHECK_SQUATE_NAME1" END ) "C_24",
	max(CASE WHEN A."DAY_ID" = '25' THEN A."CHECK_SQUATE_NAME1" END ) "C_25",
	max(CASE WHEN A."DAY_ID" = '26' THEN A."CHECK_SQUATE_NAME1" END ) "C_26",
	max(CASE WHEN A."DAY_ID" = '27' THEN A."CHECK_SQUATE_NAME1" END ) "C_27",
	max(CASE WHEN A."DAY_ID" = '28' THEN A."CHECK_SQUATE_NAME1" END ) "C_28",
	max(CASE WHEN A."DAY_ID" = '29' THEN A."CHECK_SQUATE_NAME1" END ) "C_29",
	max(CASE WHEN A."DAY_ID" = '30' THEN A."CHECK_SQUATE_NAME1" END ) "C_30",
	max(CASE WHEN A."DAY_ID" = '31' THEN A."CHECK_SQUATE_NAME1" END ) "C_31"
FROM
	"REPORT"."T_LI_RPT_TIME_BOOK" A
	WHERE 1=1
	AND CS_ID=1139
	/*${if(len(P_CS)==0,"","and A.CS_ID in ("+P_CS+")")}
	${if(len(P_GROUP)==0,"","and A.GRP_ID in ("+P_GROUP+")")}*/
GROUP BY
	CASE
		WHEN ltrim(substr(A."MONTH_ID", 1, 4), '0') IS NULL THEN NULL
		ELSE ltrim(substr(A."MONTH_ID", 1, 4), '0') 
	END ,
	CASE
		WHEN ltrim(substr(A."MONTH_ID", 5, 2), '0') IS NULL THEN NULL
		ELSE ltrim(substr(A."MONTH_ID", 5, 2), '0') || '月'
	END ,
	CASE
	WHEN ltrim(substr(A."MONTH_ID", 5, 2), '0') IS NULL THEN NULL
	ELSE ltrim(substr(A."MONTH_ID", 5, 2), '0') 
	END ,
	A."GRP_NAME",
	A."ACCOUNT_NO",
	A."USER_NAME"
ORDER BY
	"用户组","考勤年份","考勤月份" ASC NULLS LAST ) T
WHERE T."考勤年份" = '${P_YEAR}'
	AND T."查询月份" >='${P_MONTH_START}'
	AND T."查询月份" <= '${P_END_START}'