| Version | Update Time | Status | Author | Description |
|---|---|---|---|---|
0.0.1 | 2022-09-20 09:50:00 | 创建文档 | binguo | 初始化接口文档 |
3. 月度汇总
3.1. 读取钉钉考勤excel原始数据,添加至数据库
Type: POST
Content-Type: multipart/form-data
Description: 读取钉钉考勤excel原始数据,添加至数据库
Query-parameters:
| Parameter | Type | Description | Required | Since |
|---|---|---|---|---|
file | file | No comments found. | true | - |
Request-example:
curl -X POST -H 'Content-Type: multipart/form-data' -i http://192.168.161.34:8087/attendance/month/importExcelResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | object | 接口调用返回数据 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": {
"waring": "You may have used non-display generics."
}
}3.2. 分析钉钉原始数据
Type: GET
Content-Type: application/x-www-form-urlencoded;charset=utf-8
Description: 分析钉钉原始数据
Request-example:
curl -X GET -i http://192.168.161.34:8087/attendance/month/analyseResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | object | 接口调用返回数据 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": {
"waring": "You may have used non-display generics."
}
}3.3. 查询解析是否完成
Type: GET
Content-Type: application/x-www-form-urlencoded;charset=utf-8
Description: 查询解析是否完成
Request-example:
curl -X GET -i http://192.168.161.34:8087/attendance/month/queryAnalyseStatuResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | object | 接口调用返回数据 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": {
"waring": "You may have used non-display generics."
}
}3.4. 下载excel数据
Type: GET
Content-Type: application/x-www-form-urlencoded;charset=utf-8
Description: 下载excel数据
Request-example:
curl -X GET -i http://192.168.161.34:8087/attendance/month/downLoadResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | array | 接口调用返回数据 | - |
└─workName | string | 姓名 | - |
└─groupOfCheck | string | 考勤组 | - |
└─department | string | 部门 | - |
└─workNum | string | 工号 | - |
└─idCard | string | 身份证 | - |
└─daysOfAttendanceInHuangjiahu | int32 | 黄家湖出勤天数 | - |
└─daysOfcardShortageInHuangjiahu | string | 黄家湖缺卡天数 | - |
└─recondOfcardShortageInHuangjiahu | string | 黄家湖缺卡记录 | - |
└─sumAttendanceInHuangjiahu | int32 | 黄家湖总出勤天数 = 黄家湖出勤天数 + 黄家湖缺卡天数 | - |
└─daysOfAttendanceInMoxuanhu | int32 | 墨轩湖出勤天数 | - |
└─daysOfcardShortageInMoxuanhu | string | 墨轩湖缺卡天数 | - |
└─recondOfcardShortageInMoxuanhu | string | 墨轩湖缺卡记录 | - |
└─sumAttendanceInMoxuanhu | int32 | 墨轩湖总出勤天数 = 墨轩湖出勤天数 + 墨轩湖缺卡天数 | - |
└─abnormalClockNumber | int32 | 异常地点打卡天数 | - |
└─abnormalClockRecond | string | 异常地点打卡记录 | - |
└─leTwentyLateNumber | int32 | 0-20分钟迟到次数 | - |
└─lequalThirtyLateNumber | int32 | 20-30分钟迟到次数 | - |
└─geThirtyLateNumber | int32 | >30分钟迟到次数 | - |
└─lateOfRecond | string | 迟到次数记录 | - |
└─leTwentyLeaveNumber | int32 | 0-20分钟早退次数 | - |
└─lequalThirtyLeaveNumber | int32 | 20-30分钟早退次数 | - |
└─geThirtyLeaveNumber | int32 | >30分钟早退次数 | - |
└─leaveOfRecond | string | 早退次数记录 | - |
└─attendanceDays | int32 | 出勤天数=校区出勤天数+校区缺卡+校区异地 | - |
└─userId | string | userId | - |
└─attendanceDay | string | 出勤天数 | - |
└─restDay | string | 休息天数 | - |
└─workHours | string | 工作时长 | - |
└─numberOfLate | string | 迟到次数 | - |
└─numberOfLateTime | string | 迟到时长 | - |
└─numberOfSeriousLateness | string | 严重迟到次数 | - |
└─durationOfSevereLateness | string | 严重迟到时长 | - |
└─daysOfAbsenteeismAndLateness | string | 旷工迟到天数 | - |
└─leaveEarlyNumber | string | 早退次数 | - |
└─leaveEarlyTimes | string | 早退时长 | - |
└─lackOfWorkCardTimes | string | 上班缺卡次数 | - |
└─lackOfMissingWorkCardTimes | string | 下班缺卡次数 | - |
└─absenteeismDay | string | 旷工天数 | - |
└─evectionDay | string | 出差(天) | - |
└─goOutDay | string | 外出(天) | - |
└─bereavementLeave | string | 丧假(天) | - |
└─privateAffairLeaveDay | string | 事假(天) | - |
└─maternityLeaveDay | string | 产假(天) | - |
└─sickLeaveDay | string | 病假(天) | - |
└─escortFalse | string | 陪护假(天) | - |
└─marriageLeaveDay | string | 婚假 | - |
└─oneOfMonth | string | 月度第1天 | - |
└─twoOfMonth | string | 月度第2天 | - |
└─threeOfMonth | string | 月度第3天 | - |
└─fourOfMonth | string | 月度第4天 | - |
└─fiveOfMonth | string | 月度第5天 | - |
└─sixOfMonth | string | 月度第6天 | - |
└─sevenOfMonth | string | 月度第7天 | - |
└─eightOfMonth | string | 月度第8天 | - |
└─nineOfMonth | string | 月度第9天 | - |
└─tenOfMonth | string | 月度第10天 | - |
└─elevenOfMonth | string | 月度第11天 | - |
└─twelveOfMonth | string | 月度第12天 | - |
└─thirteenOfMonth | string | 月度第13天 | - |
└─fourteenOfMonth | string | 月度第14天 | - |
└─fifteenOfMonth | string | 月度第15天 | - |
└─sixteenOfMonth | string | 月度第16天 | - |
└─seventeenOfMonth | string | 月度第17天 | - |
└─eighteenOfMonth | string | 月度第18天 | - |
└─nineteenOfMonth | string | 月度第19天 | - |
└─twentyOfMonth | string | 月度第20天 | - |
└─twentyOneOfMonth | string | 月度第21天 | - |
└─twentyTwoOfMonth | string | 月度第22天 | - |
└─twentyThreeOfMonth | string | 月度第23天 | - |
└─twentyFourOfMonth | string | 月度第24天 | - |
└─twentyFiveOfMonth | string | 月度第25天 | - |
└─twentySixOfMonth | string | 月度第26天 | - |
└─twentySevenOfMonth | string | 月度第27天 | - |
└─twentyEightOfMonth | string | 月度第28天 | - |
└─twentyNineOfMonth | string | 月度第29天 | - |
└─thirtyOfMonth | string | 月度第30天 | - |
└─thirtyOneOfMonth | string | 月度第31天 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": [
{
"workName": "弘文.蒋",
"groupOfCheck": "9mtsre",
"department": "b7npi9",
"workNum": "xp9093",
"idCard": "320706199109171297",
"daysOfAttendanceInHuangjiahu": 154,
"daysOfcardShortageInHuangjiahu": "bw16f6",
"recondOfcardShortageInHuangjiahu": "b9nf0e",
"sumAttendanceInHuangjiahu": 505,
"daysOfAttendanceInMoxuanhu": 322,
"daysOfcardShortageInMoxuanhu": "x6a9kj",
"recondOfcardShortageInMoxuanhu": "rlr8em",
"sumAttendanceInMoxuanhu": 857,
"abnormalClockNumber": 276,
"abnormalClockRecond": "leokl3",
"leTwentyLateNumber": 245,
"lequalThirtyLateNumber": 32,
"geThirtyLateNumber": 786,
"lateOfRecond": "87wckf",
"leTwentyLeaveNumber": 187,
"lequalThirtyLeaveNumber": 627,
"geThirtyLeaveNumber": 202,
"leaveOfRecond": "ppu9fg",
"attendanceDays": 911,
"userId": "49",
"attendanceDay": "squa34",
"restDay": "41uz3n",
"workHours": "2d1k97",
"numberOfLate": "1mbeop",
"numberOfLateTime": "2023-04-07 08:32:59",
"numberOfSeriousLateness": "x4qm8b",
"durationOfSevereLateness": "itpiwj",
"daysOfAbsenteeismAndLateness": "x198c9",
"leaveEarlyNumber": "ogutft",
"leaveEarlyTimes": "mlsln8",
"lackOfWorkCardTimes": "k5pgfp",
"lackOfMissingWorkCardTimes": "zg2gfg",
"absenteeismDay": "xk6xzn",
"evectionDay": "0wd9sr",
"goOutDay": "daefhw",
"bereavementLeave": "eijaa5",
"privateAffairLeaveDay": "ilwauc",
"maternityLeaveDay": "23q7fv",
"sickLeaveDay": "og7ujp",
"escortFalse": "a5le18",
"marriageLeaveDay": "rgqgyo",
"oneOfMonth": "wl7uso",
"twoOfMonth": "0qn3as",
"threeOfMonth": "vuv08z",
"fourOfMonth": "u9lt13",
"fiveOfMonth": "gdqwxd",
"sixOfMonth": "m06a4d",
"sevenOfMonth": "3k3itx",
"eightOfMonth": "igcn10",
"nineOfMonth": "0hdwww",
"tenOfMonth": "4wzlgd",
"elevenOfMonth": "d7escj",
"twelveOfMonth": "b2ocbw",
"thirteenOfMonth": "146z1m",
"fourteenOfMonth": "4iuexb",
"fifteenOfMonth": "9ymg9k",
"sixteenOfMonth": "fe3g61",
"seventeenOfMonth": "fp00hk",
"eighteenOfMonth": "0xp8p0",
"nineteenOfMonth": "tuunup",
"twentyOfMonth": "ddzr7p",
"twentyOneOfMonth": "ayoovt",
"twentyTwoOfMonth": "e0ufdr",
"twentyThreeOfMonth": "5uuz49",
"twentyFourOfMonth": "9reh98",
"twentyFiveOfMonth": "h6mjmq",
"twentySixOfMonth": "nieru6",
"twentySevenOfMonth": "dmurqx",
"twentyEightOfMonth": "gkz8m3",
"twentyNineOfMonth": "8cv2et",
"thirtyOfMonth": "bvie80",
"thirtyOneOfMonth": "dlbjas"
}
]
}3.5.
Type: GET
Content-Type: application/x-www-form-urlencoded;charset=utf-8
Description: null
Request-example:
curl -X GET -i http://192.168.161.34:8087/attendance/month/teResponse-example:
Doesn't return a value.3.6. 获取月度 日标题
Type: GET
Content-Type: application/x-www-form-urlencoded;charset=utf-8
Description: 获取月度 日标题
Request-example:
curl -X GET -i http://192.168.161.34:8087/attendance/month/titleResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | object | 接口调用返回数据 | - |
└─id | int64 | 编号 | - |
└─userId | string | userId | - |
└─workName | string | workName | - |
└─oneOfMonth | string | 月度第1天 | - |
└─twoOfMonth | string | 月度第2天 | - |
└─threeOfMonth | string | 月度第3天 | - |
└─fourOfMonth | string | 月度第4天 | - |
└─fiveOfMonth | string | 月度第5天 | - |
└─sixOfMonth | string | 月度第6天 | - |
└─sevenOfMonth | string | 月度第7天 | - |
└─eightOfMonth | string | 月度第8天 | - |
└─nineOfMonth | string | 月度第9天 | - |
└─tenOfMonth | string | 月度第10天 | - |
└─elevenOfMonth | string | 月度第11天 | - |
└─twelveOfMonth | string | 月度第12天 | - |
└─thirteenOfMonth | string | 月度第13天 | - |
└─fourteenOfMonth | string | 月度第14天 | - |
└─fifteenOfMonth | string | 月度第15天 | - |
└─sixteenOfMonth | string | 月度第16天 | - |
└─seventeenOfMonth | string | 月度第17天 | - |
└─eighteenOfMonth | string | 月度第18天 | - |
└─nineteenOfMonth | string | 月度第19天 | - |
└─twentyOfMonth | string | 月度第20天 | - |
└─twentyOneOfMonth | string | 月度第21天 | - |
└─twentyTwoOfMonth | string | 月度第22天 | - |
└─twentyThreeOfMonth | string | 月度第23天 | - |
└─twentyFourOfMonth | string | 月度第24天 | - |
└─twentyFiveOfMonth | string | 月度第25天 | - |
└─twentySixOfMonth | string | 月度第26天 | - |
└─twentySevenOfMonth | string | 月度第27天 | - |
└─twentyEightOfMonth | string | 月度第28天 | - |
└─twentyNineOfMonth | string | 月度第29天 | - |
└─thirtyOfMonth | string | 月度第30天 | - |
└─thirtyOneOfMonth | string | 月度第31天 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": {
"id": 640,
"userId": "49",
"workName": "弘文.蒋",
"oneOfMonth": "07oons",
"twoOfMonth": "948wip",
"threeOfMonth": "9gmd2o",
"fourOfMonth": "4hck3f",
"fiveOfMonth": "h84y1f",
"sixOfMonth": "kh3ox8",
"sevenOfMonth": "iyvwqj",
"eightOfMonth": "s7zwd8",
"nineOfMonth": "nn1x1e",
"tenOfMonth": "deyoah",
"elevenOfMonth": "timxc0",
"twelveOfMonth": "asxh97",
"thirteenOfMonth": "bd78hf",
"fourteenOfMonth": "xyxggy",
"fifteenOfMonth": "bvp91e",
"sixteenOfMonth": "zqrhxm",
"seventeenOfMonth": "0r3fbe",
"eighteenOfMonth": "sbcsr6",
"nineteenOfMonth": "zoqr0i",
"twentyOfMonth": "50iksg",
"twentyOneOfMonth": "eq7u7i",
"twentyTwoOfMonth": "bgqxt2",
"twentyThreeOfMonth": "ct0plj",
"twentyFourOfMonth": "kty0uv",
"twentyFiveOfMonth": "o5k8ih",
"twentySixOfMonth": "dvc5io",
"twentySevenOfMonth": "lfszwi",
"twentyEightOfMonth": "uw51oy",
"twentyNineOfMonth": "u6689z",
"thirtyOfMonth": "eaol9d",
"thirtyOneOfMonth": "ci91st"
}
}4. 原始数据
4.1. 读取钉钉考勤excel原始数据,添加至数据库
Type: POST
Content-Type: multipart/form-data
Description: 读取钉钉考勤excel原始数据,添加至数据库
Query-parameters:
| Parameter | Type | Description | Required | Since |
|---|---|---|---|---|
file | file | No comments found. | true | - |
Request-example:
curl -X POST -H 'Content-Type: multipart/form-data' -i http://192.168.161.34:8087/attendance/original/importOriginalResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | object | 接口调用返回数据 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": {
"waring": "You may have used non-display generics."
}
}5. 员工身份
5.1. 读取钉钉考勤excel原始数据,添加至数据库
Type: POST
Content-Type: multipart/form-data
Description: 读取钉钉考勤excel原始数据,添加至数据库
Query-parameters:
| Parameter | Type | Description | Required | Since |
|---|---|---|---|---|
file | file | No comments found. | true | - |
Request-example:
curl -X POST -H 'Content-Type: multipart/form-data' -i http://192.168.161.34:8087/attendance/work/importWorkResponse-fields:
| Field | Type | Description | Since |
|---|---|---|---|
success | boolean | 接口调用结果标识 | - |
message | string | 接口调用结果信息 | - |
code | string | 接口调用业务码 | - |
data | object | 接口调用返回数据 | - |
Response-example:
{
"success": true,
"message": "success",
"code": "65216",
"data": {
"waring": "You may have used non-display generics."
}
}6. 错误码列表
| Error code | Description |
|---|---|
10000 | 系统未知异常 |
10001 | 参数格式校验失败 |
10002 | body为空 |
10003 | 请求方法不支持 |
10004 | 数据已存在 |
10005 | 数据不存在 |
10006 | 无效的token |
10007 | 参数异常 |
10008 | 没有操作权限 |
10009 | 管理员登录失败 |
10012 | 缺少必要的请求头 |
10013 | 缴费信息不存在 |
10014 | 订单不存在 |
10015 | 获取微信jsapi支付参数失败 |
10016 | 建行订单状态查询失败 |
10017 | 非建行支付订单 |
10018 | 农商行订单状态查询失败 |
10019 | 缴费年级不存在 |
10020 | 文件导入失败 |
10030 | 文件格式错误 |
10100 | 批量操作数据库失败 |
10021 | 付款金额错误 |
10022 | 缴费项目已存在 |
10025 | 缴费项目不存在 |
10023 | id为空 |
10024 | 该缴费项目不支持导出TXT |
10025 | 该缴费宿舍已缴费 |
10026 | 内容超长 |
10027 | AES加密失败 |
10028 | 宿舍已缴费 |
10029 | 该订单的部分项目已支付,请前往首页重新支付 |
10030 | 导入文件过大! |