SELECT
	to_char("T0"."C0",'yyyy-mm-dd') "日期",
	"T0"."C1" "电话中心名称",
	"T0"."C2" "IVR呼入量",
	"T0"."C3" "转人工申请量",
	"T0"."C4" "应答量",
	"T0"."C5" "C_20秒内应答量",
	"T0"."C6" "放弃量",
	"T0"."C7" "C_5秒内放弃量",
	"T0"."C8" "C_24小时重复来电",
	"T0"."C9" "呼损率_",
	"T0"."C10" "接通率_",
	"T0"."C11" "服务水平_20秒__",
	"T0"."C12" "IVR分流率",
	"T0"."C13" "转人工申请率",
	"T0"."C14" "最大放弃时间_秒_",
	"T0"."C15" "平均放弃时间_秒_",
	"T0"."C16" "最大应答时间_秒_",
	"T0"."C17" "平均应答时间_秒_",
	"T0"."C18" "c19",
	"T0"."C19" "c20",
	"T0"."C20" "C_24小时重复来电率",
	"T0"."C21" "排队放弃量",
	"T0"."C22" "振铃放弃量",
	"T0"."C23" "留言量及挂断量",
	sum("T0"."C2") OVER () "总计_IVR呼入量_",
	sum("T0"."C3") OVER () "总计_转人工申请量_",
	sum("T0"."C4") OVER () "总计_应答量_",
	sum("T0"."C5") OVER () "总计_20秒内应答量_",
	sum("T0"."C6") OVER () "总计_放弃量_",
	sum("T0"."C7") OVER () "总计_5秒内放弃量_",
	sum("T0"."C8") OVER () "总计_24小时重复来电_",
	"T0"."C24" "总计_呼损率__",
	"T0"."C25" "总计_接通率__",
	"T0"."C26" "c34",
	"T0"."C27" "总计_IVR分流率",
	"T0"."C28" "总计_转人工申请率",
	max("T0"."C14") OVER () "c37",
	"T0"."C29" "c38",
	max("T0"."C16") OVER () "c39",
	"T0"."C30" "c40",
	"T0"."C31" "c41",
	"T0"."C32" "c42",
	"T0"."C33" "c43",
	sum("T0"."C21") OVER () "总计_排队放弃量_",
	sum("T0"."C22") OVER () "总计_振铃放弃量_",
	sum("T0"."C23") OVER () "总计_留言量及挂断量_"
FROM
	(
	SELECT
		"T0"."C0" "C0",
		"T0"."C1" "C1",
		"T0"."C2" "C2",
		"T0"."C3" "C3",
		"T0"."C4" "C4",
		"T0"."C5" "C5",
		"T0"."C6" "C6",
		"T0"."C7" "C7",
		"T0"."C8" "C8",
		"T0"."C9" "C9",
		"T0"."C10" "C10",
		"T0"."C11" "C11",
		"T0"."C12" "C12",
		"T0"."C13" "C13",
		"T0"."C14" "C14",
		"T0"."C15" "C15",
		"T0"."C16" "C16",
		"T0"."C17" "C17",
		"T0"."C18" "C18",
		"T0"."C19" "C19",
		"T0"."C20" "C20",
		"T0"."C21" "C21",
		"T0"."C22" "C22",
		"T0"."C23" "C23",
		1 - sum("T0"."C4") OVER ()/ NULLIF(sum("T0"."C3") OVER (),
		0) "C24",
		sum("T0"."C4") OVER ()/ NULLIF(sum("T0"."C3") OVER (),
		0) "C25",
		sum("T0"."C5") OVER ()/ NULLIF(sum("T0"."C3") OVER (),
		0) "C26",
		CASE
			WHEN sum("T0"."C2") OVER ()= 0 THEN 0
			ELSE (sum("T0"."C2") OVER () - sum("T0"."C3") OVER ())/ NULLIF(sum("T0"."C2") OVER (),
			0)
		END "C27",
		CASE
			WHEN sum("T0"."C2") OVER ()= 0 THEN 0
			ELSE sum("T0"."C3") OVER ()/ NULLIF(sum("T0"."C2") OVER (),
			0)
		END "C28",
		sum("T0"."C24") OVER ()/ NULLIF(sum("T0"."C6") OVER (),
		0) "C29",
		sum("T0"."C25") OVER ()/ NULLIF(sum("T0"."C4") OVER (),
		0) "C30",
		sum("T0"."C26") OVER ()/ NULLIF(sum("T0"."C4") OVER (),
		0) "C31",
		sum("T0"."C27") OVER ()/ NULLIF(sum("T0"."C4") OVER (),
		0) "C32",
		sum("T0"."C8") OVER ()/ NULLIF(sum("T0"."C2") OVER (),
		0) "C33"
	FROM
		(
		SELECT
			"T_LI_RPT_CALLIN_95500"."TIME_DATE" "C0",
			"T_LI_RPT_CALLIN_95500"."CS_NAME" "C1",
			sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED") "C2",
			sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM") "C3",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED") "C4",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED_20") "C5",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_NUM") "C6",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_IN_TR") "C7",
			sum("T_LI_RPT_CALLIN_95500"."REPEAT_CALLIN_24H") "C8",
			1 - sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"),
			0) "C9",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"),
			0) "C10",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED_20")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"),
			0) "C11",
			CASE
				WHEN sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED")= 0 THEN 0
				ELSE (sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED") - sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"))/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED"),
				0)
			END "C12",
			CASE
				WHEN sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED")= 0 THEN 0
				ELSE sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED"),
				0)
			END "C13",
			(max("T_LI_RPT_CALLIN_95500"."MAX_T_ABANDONED")+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ABN_W2"), 0, 0, 30))+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ABN_W3"), 0, 0, 30) "C14",
			sum("T_LI_RPT_CALLIN_95500"."T_ABANDONED_SUM")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_NUM"),
			0) "C15",
			(max("T_LI_RPT_CALLIN_95500"."MAX_T_ANSWERED")+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ANS_W2"), 0, 0, 30))+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ANS_W3"), 0, 0, 30) "C16",
			sum("T_LI_RPT_CALLIN_95500"."T_ANSWERED_SUM")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED"),
			0) "C17",
			sum("T_LI_RPT_CALLIN_95500"."T_WAIT_START")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED"),
			0) "C18",
			sum("T_LI_RPT_CALLIN_95500"."T_WAIT_END")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED"),
			0) "C19",
			sum("T_LI_RPT_CALLIN_95500"."REPEAT_CALLIN_24H")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED"),
			0) "C20",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_QUEUE") "C21",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_RING") "C22",
			sum("T_LI_RPT_CALLIN_95500"."ENTERED_ABANDONED_NUM") "C23",
			sum("T_LI_RPT_CALLIN_95500"."T_ABANDONED_SUM") "C24",
			sum("T_LI_RPT_CALLIN_95500"."T_ANSWERED_SUM") "C25",
			sum("T_LI_RPT_CALLIN_95500"."T_WAIT_START") "C26",
			sum("T_LI_RPT_CALLIN_95500"."T_WAIT_END") "C27"
		FROM
			"REPORT"."T_LI_RPT_CALLIN_95500" "T_LI_RPT_CALLIN_95500"
		WHERE
			T_LI_RPT_CALLIN_95500."TIME_DATE">=
			to_date('${P_START}','yyyy-MM-dd')
			and 
			T_LI_RPT_CALLIN_95500."TIME_DATE"<=
			to_date('${P_END}','yyyy-MM-dd')
			${if(len(P_CS)==0,"","and T_LI_RPT_CALLIN_95500.CS_NAME in ('"+P_CS+"')")}
			${if(len(P_SUBSIDIARY)==0,"","and T_LI_RPT_CALLIN_95500.BRANCH_COMPANY_FLG in ('"+P_SUBSIDIARY+"')")}
		GROUP BY
			"T_LI_RPT_CALLIN_95500"."TIME_DATE",
			"T_LI_RPT_CALLIN_95500"."CS_NAME") "T0") "T0"
ORDER BY
	"日期" ASC NULLS LAST
