| 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": "7267",
"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": "7267",
"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": "7267",
"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": "7267",
"data": [
{
"workName": "智宸.龙",
"groupOfCheck": "1biiuz",
"department": "n4rxuz",
"workNum": "4nd1sv",
"idCard": "621524199010193394",
"daysOfAttendanceInHuangjiahu": 867,
"daysOfcardShortageInHuangjiahu": "x4eq0q",
"recondOfcardShortageInHuangjiahu": "9k29kf",
"sumAttendanceInHuangjiahu": 507,
"daysOfAttendanceInMoxuanhu": 507,
"daysOfcardShortageInMoxuanhu": "etqxys",
"recondOfcardShortageInMoxuanhu": "tqnnol",
"sumAttendanceInMoxuanhu": 725,
"abnormalClockNumber": 48,
"abnormalClockRecond": "51v216",
"leTwentyLateNumber": 205,
"lequalThirtyLateNumber": 12,
"geThirtyLateNumber": 594,
"lateOfRecond": "wlly9v",
"leTwentyLeaveNumber": 723,
"lequalThirtyLeaveNumber": 19,
"geThirtyLeaveNumber": 418,
"leaveOfRecond": "umekzs",
"attendanceDays": 120,
"userId": "87",
"attendanceDay": "3p5ppa",
"restDay": "j2e62d",
"workHours": "72r77m",
"numberOfLate": "25t4iz",
"numberOfLateTime": "2023-04-06 14:38:05",
"numberOfSeriousLateness": "qir9cv",
"durationOfSevereLateness": "fzcz6a",
"daysOfAbsenteeismAndLateness": "qeozoy",
"leaveEarlyNumber": "ls3xmb",
"leaveEarlyTimes": "rkn6cb",
"lackOfWorkCardTimes": "h95ft3",
"lackOfMissingWorkCardTimes": "pe28hz",
"absenteeismDay": "skx16m",
"evectionDay": "furceo",
"goOutDay": "l6k8ve",
"bereavementLeave": "8kyyk2",
"privateAffairLeaveDay": "7la8jh",
"maternityLeaveDay": "t3zvbg",
"sickLeaveDay": "biey7t",
"escortFalse": "81mand",
"marriageLeaveDay": "3kse1i",
"oneOfMonth": "g4un14",
"twoOfMonth": "kqsytu",
"threeOfMonth": "izxaxu",
"fourOfMonth": "y0dac5",
"fiveOfMonth": "0nfp7m",
"sixOfMonth": "ysvxqk",
"sevenOfMonth": "9ogzi1",
"eightOfMonth": "oq7xvc",
"nineOfMonth": "h7og4x",
"tenOfMonth": "3quzio",
"elevenOfMonth": "7g2ykf",
"twelveOfMonth": "udpyvl",
"thirteenOfMonth": "t24620",
"fourteenOfMonth": "lvxg02",
"fifteenOfMonth": "b4b0h4",
"sixteenOfMonth": "1q6gnv",
"seventeenOfMonth": "sobh3v",
"eighteenOfMonth": "xi2jj7",
"nineteenOfMonth": "62zzxm",
"twentyOfMonth": "36c3gd",
"twentyOneOfMonth": "misrdq",
"twentyTwoOfMonth": "jnmrhh",
"twentyThreeOfMonth": "xuz3z7",
"twentyFourOfMonth": "rsl4t4",
"twentyFiveOfMonth": "io8nho",
"twentySixOfMonth": "vowhym",
"twentySevenOfMonth": "tt5u70",
"twentyEightOfMonth": "3k5t7c",
"twentyNineOfMonth": "330u26",
"thirtyOfMonth": "g5blwx",
"thirtyOneOfMonth": "4pe5vm"
}
]
}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": "7267",
"data": {
"id": 159,
"userId": "87",
"workName": "智宸.龙",
"oneOfMonth": "1w4zic",
"twoOfMonth": "4t6ijl",
"threeOfMonth": "lp4ah2",
"fourOfMonth": "79rgdj",
"fiveOfMonth": "8uohp8",
"sixOfMonth": "u2x3gh",
"sevenOfMonth": "niun2a",
"eightOfMonth": "k7qoh1",
"nineOfMonth": "q61ppl",
"tenOfMonth": "erav8s",
"elevenOfMonth": "u1y29b",
"twelveOfMonth": "tstrr1",
"thirteenOfMonth": "cgcke8",
"fourteenOfMonth": "piq67o",
"fifteenOfMonth": "1jgcpf",
"sixteenOfMonth": "tnhh75",
"seventeenOfMonth": "y8sgdk",
"eighteenOfMonth": "rm488j",
"nineteenOfMonth": "g15s99",
"twentyOfMonth": "17tnaj",
"twentyOneOfMonth": "v88f7g",
"twentyTwoOfMonth": "i7oupm",
"twentyThreeOfMonth": "e05w6b",
"twentyFourOfMonth": "ytobwv",
"twentyFiveOfMonth": "nzm5xp",
"twentySixOfMonth": "9cxafj",
"twentySevenOfMonth": "mxf7q1",
"twentyEightOfMonth": "1qh0ly",
"twentyNineOfMonth": "d3cgex",
"thirtyOfMonth": "bmfdwj",
"thirtyOneOfMonth": "nsd7zb"
}
}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": "7267",
"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": "7267",
"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 | 该订单的部分项目已支付,请前往首页重新支付 |