| 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": "52413",
"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": "52413",
"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": "52413",
"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": "52413",
"data": [
{
"workName": "皓轩.武",
"groupOfCheck": "99rdun",
"department": "6rcsy2",
"workNum": "3cw4ho",
"idCard": "620706200003289448",
"daysOfAttendanceInHuangjiahu": 842,
"daysOfcardShortageInHuangjiahu": "cmbery",
"recondOfcardShortageInHuangjiahu": "i2poyf",
"sumAttendanceInHuangjiahu": 231,
"daysOfAttendanceInMoxuanhu": 343,
"daysOfcardShortageInMoxuanhu": "u6t01x",
"recondOfcardShortageInMoxuanhu": "ulja4g",
"sumAttendanceInMoxuanhu": 92,
"abnormalClockNumber": 104,
"abnormalClockRecond": "kt1tub",
"leTwentyLateNumber": 837,
"lequalThirtyLateNumber": 113,
"geThirtyLateNumber": 203,
"lateOfRecond": "ylq5ix",
"leTwentyLeaveNumber": 872,
"lequalThirtyLeaveNumber": 526,
"geThirtyLeaveNumber": 491,
"leaveOfRecond": "056l9p",
"attendanceDays": 158,
"userId": "33",
"attendanceDay": "8kvdwd",
"restDay": "7f4smz",
"workHours": "wifjpo",
"numberOfLate": "f32s5k",
"numberOfLateTime": "2023-04-04 17:37:35",
"numberOfSeriousLateness": "m22t8o",
"durationOfSevereLateness": "m8ga7s",
"daysOfAbsenteeismAndLateness": "pxdcga",
"leaveEarlyNumber": "0pfwv2",
"leaveEarlyTimes": "kivwcw",
"lackOfWorkCardTimes": "81kl2y",
"lackOfMissingWorkCardTimes": "39w52d",
"absenteeismDay": "2ldg2d",
"evectionDay": "gu312d",
"goOutDay": "to5jsv",
"bereavementLeave": "7rz7eb",
"privateAffairLeaveDay": "480z01",
"maternityLeaveDay": "tpmp5s",
"sickLeaveDay": "dh1xie",
"escortFalse": "m4fy3k",
"marriageLeaveDay": "6hltvx",
"oneOfMonth": "giyj0t",
"twoOfMonth": "4rt3o4",
"threeOfMonth": "5aa8t5",
"fourOfMonth": "2dsuvc",
"fiveOfMonth": "rzfdl4",
"sixOfMonth": "ahzahc",
"sevenOfMonth": "f0mrza",
"eightOfMonth": "flpqdq",
"nineOfMonth": "387puz",
"tenOfMonth": "nz0qw1",
"elevenOfMonth": "yu6yy9",
"twelveOfMonth": "4n10hl",
"thirteenOfMonth": "vqpl9k",
"fourteenOfMonth": "b3wtw4",
"fifteenOfMonth": "5ru9f5",
"sixteenOfMonth": "sp9oy0",
"seventeenOfMonth": "h5xzep",
"eighteenOfMonth": "pkjr7v",
"nineteenOfMonth": "5fyrjx",
"twentyOfMonth": "ued1cz",
"twentyOneOfMonth": "iqxe36",
"twentyTwoOfMonth": "m399ht",
"twentyThreeOfMonth": "uyem5e",
"twentyFourOfMonth": "hfdska",
"twentyFiveOfMonth": "d2s0tn",
"twentySixOfMonth": "ies3of",
"twentySevenOfMonth": "6f63yl",
"twentyEightOfMonth": "r4pgxi",
"twentyNineOfMonth": "luuv47",
"thirtyOfMonth": "08xyc5",
"thirtyOneOfMonth": "fjq864"
}
]
}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": "52413",
"data": {
"id": 524,
"userId": "33",
"workName": "皓轩.武",
"oneOfMonth": "le0keg",
"twoOfMonth": "30h0ai",
"threeOfMonth": "4ctlo5",
"fourOfMonth": "uboab3",
"fiveOfMonth": "1a3kqy",
"sixOfMonth": "ek1ova",
"sevenOfMonth": "lyn6vm",
"eightOfMonth": "s8k8it",
"nineOfMonth": "142e2z",
"tenOfMonth": "pldsf6",
"elevenOfMonth": "qq9yk5",
"twelveOfMonth": "q0n6l2",
"thirteenOfMonth": "ltszhi",
"fourteenOfMonth": "onjk5b",
"fifteenOfMonth": "9bjbew",
"sixteenOfMonth": "zu8z36",
"seventeenOfMonth": "q0dlw0",
"eighteenOfMonth": "vfsbwi",
"nineteenOfMonth": "lf8wdt",
"twentyOfMonth": "tx6fat",
"twentyOneOfMonth": "m21wd5",
"twentyTwoOfMonth": "tuyf0t",
"twentyThreeOfMonth": "dfd71a",
"twentyFourOfMonth": "ahrrd0",
"twentyFiveOfMonth": "trw03q",
"twentySixOfMonth": "wfvnvh",
"twentySevenOfMonth": "4rvn6y",
"twentyEightOfMonth": "791jcg",
"twentyNineOfMonth": "nlc8g1",
"thirtyOfMonth": "43p2ot",
"thirtyOneOfMonth": "3t9h2x"
}
}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": "52413",
"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": "52413",
"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 | 该订单的部分项目已支付,请前往首页重新支付 |