# 出勤紀錄查詢

用於查詢員工打卡及出勤紀錄，包括：打卡資料查詢、打卡比對資料查詢。

## 取得員工打卡比對結果檔

> \`\`\`\
> emp\_cardmatch = {\
> &#x20; "EMP\_CARDMATCH\_ID": number,           //ID\
> &#x20; "CO\_ID": number,                      //公司\_ID\
> &#x20; "EMP\_ID": number,                     //員工\_ID\
> &#x20; "WORK\_DATE":date,                     //應出勤日期\
> &#x20; "WORK\_DATE\_SEQ": number,              //出勤日期分段\
> &#x20; "CARD\_TYPE": number,                  //打卡別\
> &#x20; "CARD\_GROUP": number,                 //打卡組別\
> &#x20; "IS\_FLEXIBLE": number,                //此段刷卡是否有彈性\
> &#x20; "FLEXIBLE\_MIN": number,               //實際彈性分鐘數\
> &#x20; "WORK\_CARD\_DATETIME":date,            //應刷卡時間(不含彈性)\
> &#x20; "FLEXIBLE\_CARD\_DATETIME":date,        //應刷卡時間(含彈性)\
> &#x20; "EMP\_OT\_ID": number,                  //加班資料\_ID\
> &#x20; "RANGE1\_START":date,                  //應打卡區間起(合理時間)\
> &#x20; "RANGE1\_END":date,                    //應打卡區間迄(合理時間)\
> &#x20; "RANGE2\_START":date,                  //應打卡區間起(不合理時間)\
> &#x20; "RANGE2\_END":date,                    //應打卡區間迄(不合理時間)\
> &#x20; "EMP\_LEAVE\_ID": number,               //應打卡區間-請假主檔\_ID\
> &#x20; "IS\_REST\_OVERTIME": number,           //休息時間-可否加班\
> &#x20; "CARD\_DATETIME":date,                 //實際打卡時間\
> &#x20; "TEMP\_UNIT":string,                   //體溫單位\
> &#x20; "TEMP\_VALUE": number,                 //體溫值\
> &#x20; "CARD\_SOURCE": number,                //實際打卡資料來源\
> &#x20; "EMP\_CARDDATA\_ID": number,            //實際打卡明細檔\_ID\
> &#x20; "CARD\_MATCH\_STATUS": number,          //異常比對結果\
> &#x20; "UNUSUAL\_ACTION": number,             //異常處理方式\
> &#x20; "UNUSUAL\_REMARK":string,              //異常處理備註\
> &#x20; "UNUSUAL\_FILL\_DATETIME":date,         //異常處理\_填寫日期\
> &#x20; "UNUSUAL\_START":date,                 //異常起始時間\
> &#x20; "UNUSUAL\_END":date,                   //異常結束時間\
> &#x20; "LATE\_MIN": number,                   //遲到分鐘數\
> &#x20; "EARLY\_MIN": number,                  //早退分鐘數\
> &#x20; "NOT\_WORKING\_MIN": number,            //曠職分鐘數\
> &#x20; "EMP\_ASK\_LEAVE\_BIZ\_IDS":string,       //已申請的請假IDS\
> &#x20; "OVER\_ATTEND\_STATUS": number,         //超時出勤比對結果\
> &#x20; "OVER\_ATTEND\_ACTION": number,         //超時出勤異常處理方式\
> &#x20; "OVER\_ATTEND\_DESC":string,            //超時出勤回報\_說明\
> &#x20; "OVER\_ATTEND\_FILL\_TYPE":string,       //超時出勤回報\_填寫人員種類\
> &#x20; "OVER\_ATTEND\_FILL\_DATETIME":date,     //超時出勤回報\_填寫日期\
> &#x20; "OVER\_ATTEND\_START":date,             //超時出勤起始時間\
> &#x20; "OVER\_ATTEND\_END":date,               //超時出勤結束時間\
> &#x20; "OVER\_ATTEND\_MIN": number,            //超時出勤分鐘數\
> &#x20; "EMP\_OVER\_TIME\_IDS":string,           //超時出勤已申請的加班資料IDS\
> &#x20; "CAL\_STATUS": number,                 //假勤結算狀態\
> &#x20; "SALARY\_CLOSE\_ID": number,            //薪資結檔主檔\_ID\
> &#x20; "C\_DATETIME":date,                    //新增\_日期\
> &#x20; "E\_DATETIME":date,                    //修改\_日期\
> },\
> \`\`\`<br>

````json
{"openapi":"3.0.0","tags":[{"name":"出勤紀錄查詢","description":"用於查詢員工打卡及出勤紀錄，包括：打卡資料查詢、打卡比對資料查詢。"}],"servers":[{"url":"https://104demotest-api-server.hrmax.104.com.tw"}],"security":[{"bearerAuth":[]}],"components":{"securitySchemes":{"bearerAuth":{"type":"http","scheme":"bearer","bearerFormat":"JWT"}},"responses":{"401":{"description":"認證失敗 (請更新 accessToken 再試一次)"},"403":{"description":"權限不足"},"440":{"description":"參數錯誤 (請檢查 parameters 或 request body 的欄位、格式是否完整及正確)"},"500":{"description":"系統異常 `{ code: 500, msg: string }`"}}},"paths":{"/api/am/emp_cardmatch":{"post":{"tags":["出勤紀錄查詢"],"summary":"取得員工打卡比對結果檔","description":"```\nemp_cardmatch = {\n  \"EMP_CARDMATCH_ID\": number,           //ID\n  \"CO_ID\": number,                      //公司_ID\n  \"EMP_ID\": number,                     //員工_ID\n  \"WORK_DATE\":date,                     //應出勤日期\n  \"WORK_DATE_SEQ\": number,              //出勤日期分段\n  \"CARD_TYPE\": number,                  //打卡別\n  \"CARD_GROUP\": number,                 //打卡組別\n  \"IS_FLEXIBLE\": number,                //此段刷卡是否有彈性\n  \"FLEXIBLE_MIN\": number,               //實際彈性分鐘數\n  \"WORK_CARD_DATETIME\":date,            //應刷卡時間(不含彈性)\n  \"FLEXIBLE_CARD_DATETIME\":date,        //應刷卡時間(含彈性)\n  \"EMP_OT_ID\": number,                  //加班資料_ID\n  \"RANGE1_START\":date,                  //應打卡區間起(合理時間)\n  \"RANGE1_END\":date,                    //應打卡區間迄(合理時間)\n  \"RANGE2_START\":date,                  //應打卡區間起(不合理時間)\n  \"RANGE2_END\":date,                    //應打卡區間迄(不合理時間)\n  \"EMP_LEAVE_ID\": number,               //應打卡區間-請假主檔_ID\n  \"IS_REST_OVERTIME\": number,           //休息時間-可否加班\n  \"CARD_DATETIME\":date,                 //實際打卡時間\n  \"TEMP_UNIT\":string,                   //體溫單位\n  \"TEMP_VALUE\": number,                 //體溫值\n  \"CARD_SOURCE\": number,                //實際打卡資料來源\n  \"EMP_CARDDATA_ID\": number,            //實際打卡明細檔_ID\n  \"CARD_MATCH_STATUS\": number,          //異常比對結果\n  \"UNUSUAL_ACTION\": number,             //異常處理方式\n  \"UNUSUAL_REMARK\":string,              //異常處理備註\n  \"UNUSUAL_FILL_DATETIME\":date,         //異常處理_填寫日期\n  \"UNUSUAL_START\":date,                 //異常起始時間\n  \"UNUSUAL_END\":date,                   //異常結束時間\n  \"LATE_MIN\": number,                   //遲到分鐘數\n  \"EARLY_MIN\": number,                  //早退分鐘數\n  \"NOT_WORKING_MIN\": number,            //曠職分鐘數\n  \"EMP_ASK_LEAVE_BIZ_IDS\":string,       //已申請的請假IDS\n  \"OVER_ATTEND_STATUS\": number,         //超時出勤比對結果\n  \"OVER_ATTEND_ACTION\": number,         //超時出勤異常處理方式\n  \"OVER_ATTEND_DESC\":string,            //超時出勤回報_說明\n  \"OVER_ATTEND_FILL_TYPE\":string,       //超時出勤回報_填寫人員種類\n  \"OVER_ATTEND_FILL_DATETIME\":date,     //超時出勤回報_填寫日期\n  \"OVER_ATTEND_START\":date,             //超時出勤起始時間\n  \"OVER_ATTEND_END\":date,               //超時出勤結束時間\n  \"OVER_ATTEND_MIN\": number,            //超時出勤分鐘數\n  \"EMP_OVER_TIME_IDS\":string,           //超時出勤已申請的加班資料IDS\n  \"CAL_STATUS\": number,                 //假勤結算狀態\n  \"SALARY_CLOSE_ID\": number,            //薪資結檔主檔_ID\n  \"C_DATETIME\":date,                    //新增_日期\n  \"E_DATETIME\":date,                    //修改_日期\n},\n```\n","requestBody":{"required":true,"content":{"application/json":{"schema":{"type":"object","required":["CO_ID","WORK_SDATE","WORK_EDATE","MATCH_STATUS","UNUSUAL_ACTION","OVER_ATTEND_STATUS","OVER_ATTEND_ACTION","EMP_ID"],"properties":{"CO_ID":{"type":"integer","description":"公司ID"},"WORK_SDATE":{"type":["date"],"description":"出勤日期起"},"WORK_EDATE":{"type":["date"],"description":"出勤日期迄"},"MATCH_STATUS":{"type":["string"],"description":"異常條件"},"UNUSUAL_ACTION":{"type":["string"],"description":"異常處理方式"},"OVER_ATTEND_STATUS":{"type":["string"],"description":"超時出勤條件"},"OVER_ATTEND_ACTION":{"type":["string"],"description":"超時出勤異常處理方式"},"EMP_ID":{"type":"integer","description":"員工ID"}}}}}},"responses":{"200":{"description":"成功\n```\n{\n  code: 200, \n  data: [emp_cardmatch, emp_cardmatch, ...]\n}\n```\n"},"401":{"$ref":"#/components/responses/401"},"403":{"$ref":"#/components/responses/403"},"440":{"$ref":"#/components/responses/440"},"500":{"$ref":"#/components/responses/500"}}}}}}
````

## 取得員工打卡明細資料檔

> \`\`\`\
> emp\_carddata = {\
> &#x20; "CO\_ID": number,          //公司\_ID\
> &#x20; "EMP\_ID": number,         //員工\_ID\
> &#x20; "EMP\_NO":string,          //匯入員工編號\
> &#x20; "CARDNO":string,          //匯入卡號\
> &#x20; "CARD\_DATETIME":date,     //打卡時間\
> &#x20; "TEMP\_UNIT":string,       //體溫單位\
> &#x20; "TEMP\_VALUE": number,     //體溫值\
> &#x20; "CARD\_TYPE": number,      //原始打卡別\
> &#x20; "CARD\_SOURCE": number,    //資料來源\
> &#x20; "IMPORT\_TYPE":string,     //資料匯入方式\
> &#x20; "WF\_NO":string,           //WORKFLOW 表單編號\
> &#x20; "WF\_RESULT": number,      //表單狀態\
> &#x20; "WF\_SIGN\_TIME":date,      //簽核完成時間\
> &#x20; "C\_DATETIME":date,        //新增\_日期\
> &#x20; "E\_DATETIME":date,        //修改\_日期\
> },\
> \`\`\`<br>

````json
{"openapi":"3.0.0","tags":[{"name":"出勤紀錄查詢","description":"用於查詢員工打卡及出勤紀錄，包括：打卡資料查詢、打卡比對資料查詢。"}],"servers":[{"url":"https://104demotest-api-server.hrmax.104.com.tw"}],"security":[{"bearerAuth":[]}],"components":{"securitySchemes":{"bearerAuth":{"type":"http","scheme":"bearer","bearerFormat":"JWT"}},"responses":{"401":{"description":"認證失敗 (請更新 accessToken 再試一次)"},"403":{"description":"權限不足"},"440":{"description":"參數錯誤 (請檢查 parameters 或 request body 的欄位、格式是否完整及正確)"},"500":{"description":"系統異常 `{ code: 500, msg: string }`"}}},"paths":{"/api/am/emp_carddata":{"post":{"tags":["出勤紀錄查詢"],"summary":"取得員工打卡明細資料檔","description":"```\nemp_carddata = {\n  \"CO_ID\": number,          //公司_ID\n  \"EMP_ID\": number,         //員工_ID\n  \"EMP_NO\":string,          //匯入員工編號\n  \"CARDNO\":string,          //匯入卡號\n  \"CARD_DATETIME\":date,     //打卡時間\n  \"TEMP_UNIT\":string,       //體溫單位\n  \"TEMP_VALUE\": number,     //體溫值\n  \"CARD_TYPE\": number,      //原始打卡別\n  \"CARD_SOURCE\": number,    //資料來源\n  \"IMPORT_TYPE\":string,     //資料匯入方式\n  \"WF_NO\":string,           //WORKFLOW 表單編號\n  \"WF_RESULT\": number,      //表單狀態\n  \"WF_SIGN_TIME\":date,      //簽核完成時間\n  \"C_DATETIME\":date,        //新增_日期\n  \"E_DATETIME\":date,        //修改_日期\n},\n```\n","requestBody":{"required":true,"content":{"application/json":{"schema":{"type":"object","required":["CO_ID","CARD_SDATETIME","CARD_EDATETIME","EMP_ID"],"properties":{"CO_ID":{"type":"integer","description":"公司ID"},"CARD_SDATETIME":{"type":["string","date"],"description":"打卡時間起"},"CARD_EDATETIME":{"type":["string","date"],"description":"打卡時間迄"},"EMP_ID":{"type":"integer","description":"員工ID"}}}}}},"responses":{"200":{"description":"成功\n```\n{\n  code: 200, \n  data: [emp_carddata, emp_carddata, ...]\n}\n```\n"},"401":{"$ref":"#/components/responses/401"},"403":{"$ref":"#/components/responses/403"},"440":{"$ref":"#/components/responses/440"},"500":{"$ref":"#/components/responses/500"}}}}}}
````
