(2013-05-14 19:16:51) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, B.AREA_NM, A.BRD_TP_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, B.AREA_NO, A.BRD_TP ORDER BY A.DATA_DT, B.AREA_NO, C.OLAP_BRD_ORDR") UNIT_NO: EMP_NO: (2013-05-14 19:16:51) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, B.AREA_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, B.AREA_NO ") UNIT_NO: EMP_NO: (2013-05-14 19:16:51) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, '服輔部' AS AREA_NM, A.BRD_TP_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, A.BRD_TP ORDER BY A.DATA_DT, C.OLAP_BRD_ORDR") UNIT_NO: EMP_NO: (2013-05-14 19:16:51) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, '服輔部' AS AREA_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT ") UNIT_NO: EMP_NO: (2013-05-14 19:17:47) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, B.AREA_NM, A.BRD_TP_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, B.AREA_NO, A.BRD_TP ORDER BY A.DATA_DT, B.AREA_NO, C.OLAP_BRD_ORDR") UNIT_NO: EMP_NO: (2013-05-14 19:17:47) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, B.AREA_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, B.AREA_NO ") UNIT_NO: EMP_NO: (2013-05-14 19:17:47) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, '服輔部' AS AREA_NM, A.BRD_TP_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, A.BRD_TP ORDER BY A.DATA_DT, C.OLAP_BRD_ORDR") UNIT_NO: EMP_NO: (2013-05-14 19:17:47) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, '服輔部' AS AREA_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT ") UNIT_NO: EMP_NO: (2013-05-14 19:19:21) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, B.AREA_NM, A.BRD_TP_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, B.AREA_NO, A.BRD_TP ORDER BY A.DATA_DT, B.AREA_NO, C.OLAP_BRD_ORDR") UNIT_NO: EMP_NO: (2013-05-14 19:19:21) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, B.AREA_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, B.AREA_NO ") UNIT_NO: EMP_NO: (2013-05-14 19:19:21) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, '服輔部' AS AREA_NM, A.BRD_TP_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT, A.BRD_TP ORDER BY A.DATA_DT, C.OLAP_BRD_ORDR") UNIT_NO: EMP_NO: (2013-05-14 19:19:21) [olp004_2.php] mysqlt error: [1054: Unknown column 'OLAP_BRD_ORDR' in 'field list'] in EXECUTE("SELECT A.DATA_DT, '服輔部' AS AREA_NM , SUM(A.RV_M) TD_01_01 , CASE WHEN SUM(A.RV_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.RV_M) / SUM(A.RV_M_PP))*100),2) END TD_01_02 , SUM(A.ENG_PAY_GOAL) TD_01_03 , CASE WHEN SUM(A.ENG_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL) / SUM(A.ENG_PAY_GOAL_PP))*100),2) END TD_01_04 , CASE WHEN SUM(A.ENG_GOAL) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_PAY_GOAL)/SUM(A.ENG_GOAL))*100), 2) END TD_01_05 , SUM(A.ENG_GOAL) TD_01_06 , CASE WHEN SUM(A.ENG_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.ENG_GOAL)/ SUM(A.ENG_GOAL_PP))*100), 2) END TD_01_07 , SUM(A.BP_PAY_GOAL) TD_01_08 , CASE WHEN SUM(A.BP_PAY_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL)/ SUM(A.BP_PAY_GOAL_PP))*100), 2) END TD_01_09 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_PAY_GOAL) / SUM(A.RV_M)) * 100 ), 2) END TD_01_10 , SUM(A.BP_GOAL) TD_01_11 , CASE WHEN SUM(A.BP_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.BP_GOAL)/ SUM(A.BP_GOAL_PP))*100), 2) END TD_01_12 , SUM(A.HFK_GOAL) TD_01_13 , CASE WHEN SUM(A.HFK_GOAL_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.HFK_GOAL)/ SUM(A.HFK_GOAL_PP))*100), 2) END TD_01_14 , SUM(A.PART_COST) TD_02_01, SUM(A.PART_PROFIT) TD_02_02 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND((((SUM(A.PART_AMT_NTAX) - SUM(A.PART_COST)) / SUM(A.PART_AMT_NTAX))*100),2) END TD_02_03 , CASE WHEN SUM(A.RV_M) = 0 THEN 0 ELSE ROUND(((SUM(A.PAY_GOAL) / SUM(A.RV_M))*100),2) END TD_02_04 , SUM(A.SUM_PROFIT) TD_02_05 , CASE WHEN SUM(A.INV_AMT_NTAX) = 0 THEN 0 ELSE ROUND(((SUM(A.INV_AMT_NTAX)-( SUM(A.PART_COST)+SUM(A.PAY_COST)))/SUM(A.INV_AMT_NTAX))*100,2) END AS TD_02_06 , SUM(A.CAR_AC_M) TD_03_01 , SUM(A.CAR_IN_M) TD_03_02 , CASE WHEN SUM(A.CAR_IN_M_PP) = 0 THEN 0 ELSE ROUND(((SUM(A.CAR_IN_M)/ SUM(A.CAR_IN_M_PP))*100), 2) END TD_03_03 , SUM(A.CAR_SAL_M) TD_03_04 , SUM(A.CAR_INQ_M) TD_03_05 , SUM(A.CAR_RM_M) TD_03_06 , SUM(A.CAR_ENG_M) TD_03_07 , SUM(A.CAR_BP_M) TD_03_08 , CASE WHEN SUM(A.CAR_IN_M) = 0 THEN 0 ELSE ROUND((SUM(A.RV_M) / SUM(A.CAR_IN_M)), 2) END TD_04_01 , CASE WHEN SUM(A.CAR_ENG_M) = 0 THEN 0 ELSE ROUND((SUM(A.ENG_GOAL) / SUM(A.CAR_ENG_M)), 2) END TD_04_02 , CASE WHEN SUM(A.CAR_BP_M) = 0 THEN 0 ELSE ROUND((SUM(A.BP_GOAL) / SUM(A.CAR_BP_M)), 2) END TD_04_03 FROM ol001 B LEFT JOIN ol003 A ON A.UNIT_NO = B.UNIT_NO AND A.DATA_DT = '2013-05-13' LEFT JOIN (SELECT MAX(OLAP_BRD_ORDR) AS OLAP_BRD_ORDR, OLAP_BRD FROM fd008 GROUP BY OLAP_BRD )C ON A.BRD_TP = C.OLAP_BRD WHERE B.YM = '2013-05' AND B.UNIT_TYPE = '10' AND B.AREA_NO IS NOT NULL GROUP BY A.DATA_DT ") UNIT_NO: EMP_NO: