| 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": "1255",
"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": "1255",
"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": "1255",
"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": "1255",
"data": [
{
"workName": "天宇.黄",
"groupOfCheck": "j4ebro",
"department": "xs6z5j",
"workNum": "v2j3xc",
"idCard": "141527200210025285",
"daysOfAttendanceInHuangjiahu": 467,
"daysOfcardShortageInHuangjiahu": "jk0vat",
"recondOfcardShortageInHuangjiahu": "0zkmji",
"sumAttendanceInHuangjiahu": 688,
"daysOfAttendanceInMoxuanhu": 151,
"daysOfcardShortageInMoxuanhu": "ujfwtn",
"recondOfcardShortageInMoxuanhu": "9zij3t",
"sumAttendanceInMoxuanhu": 573,
"abnormalClockNumber": 889,
"abnormalClockRecond": "1s8fy9",
"leTwentyLateNumber": 575,
"lequalThirtyLateNumber": 758,
"geThirtyLateNumber": 941,
"lateOfRecond": "t6owrq",
"leTwentyLeaveNumber": 45,
"lequalThirtyLeaveNumber": 201,
"geThirtyLeaveNumber": 268,
"leaveOfRecond": "9z6iof",
"attendanceDays": 68,
"userId": "36",
"attendanceDay": "wsgrzf",
"restDay": "grqcpq",
"workHours": "qn79kk",
"numberOfLate": "i2e9nk",
"numberOfLateTime": "2023-04-07 08:44:14",
"numberOfSeriousLateness": "wvk4w6",
"durationOfSevereLateness": "z7ls84",
"daysOfAbsenteeismAndLateness": "gb4qpc",
"leaveEarlyNumber": "zvg9dc",
"leaveEarlyTimes": "u89eey",
"lackOfWorkCardTimes": "ii6yod",
"lackOfMissingWorkCardTimes": "npzio4",
"absenteeismDay": "jckatp",
"evectionDay": "icx9fb",
"goOutDay": "t2zwav",
"bereavementLeave": "o4l8oz",
"privateAffairLeaveDay": "exhflq",
"maternityLeaveDay": "ku6w4c",
"sickLeaveDay": "jttz88",
"escortFalse": "pe4wed",
"marriageLeaveDay": "nv6z8r",
"oneOfMonth": "hyekms",
"twoOfMonth": "al9605",
"threeOfMonth": "vajyu2",
"fourOfMonth": "esshy1",
"fiveOfMonth": "1nm9rw",
"sixOfMonth": "jan602",
"sevenOfMonth": "o6lbm6",
"eightOfMonth": "w5lm9n",
"nineOfMonth": "9t5dkc",
"tenOfMonth": "y26d6t",
"elevenOfMonth": "1m1eop",
"twelveOfMonth": "kzu34q",
"thirteenOfMonth": "1g4yz2",
"fourteenOfMonth": "hwm4o0",
"fifteenOfMonth": "04pi78",
"sixteenOfMonth": "vv0pbm",
"seventeenOfMonth": "1t3v1y",
"eighteenOfMonth": "4z0qrv",
"nineteenOfMonth": "16ivwf",
"twentyOfMonth": "j74njn",
"twentyOneOfMonth": "q9lwg9",
"twentyTwoOfMonth": "80mf36",
"twentyThreeOfMonth": "b09wkq",
"twentyFourOfMonth": "q7tw1d",
"twentyFiveOfMonth": "9xqzxc",
"twentySixOfMonth": "v181wy",
"twentySevenOfMonth": "an1oba",
"twentyEightOfMonth": "2d8r25",
"twentyNineOfMonth": "twf09y",
"thirtyOfMonth": "dsnvhk",
"thirtyOneOfMonth": "qgmxp7"
}
]
}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": "1255",
"data": {
"id": 189,
"userId": "36",
"workName": "天宇.黄",
"oneOfMonth": "iuvlk5",
"twoOfMonth": "yw3to4",
"threeOfMonth": "86m43d",
"fourOfMonth": "nj5xfa",
"fiveOfMonth": "1eetuz",
"sixOfMonth": "fuu37s",
"sevenOfMonth": "4ttt2m",
"eightOfMonth": "f4hfey",
"nineOfMonth": "v3dkrz",
"tenOfMonth": "k9l6kb",
"elevenOfMonth": "55e5a8",
"twelveOfMonth": "5ukttc",
"thirteenOfMonth": "rtqgzi",
"fourteenOfMonth": "2v5mfn",
"fifteenOfMonth": "kj1lwz",
"sixteenOfMonth": "ciomn4",
"seventeenOfMonth": "z6zz27",
"eighteenOfMonth": "g1d9vb",
"nineteenOfMonth": "84xe9a",
"twentyOfMonth": "gfjjy3",
"twentyOneOfMonth": "by7jjw",
"twentyTwoOfMonth": "d43wcq",
"twentyThreeOfMonth": "oekn5g",
"twentyFourOfMonth": "6nifn3",
"twentyFiveOfMonth": "nmg7xe",
"twentySixOfMonth": "vpwbb2",
"twentySevenOfMonth": "pi4wl4",
"twentyEightOfMonth": "2dbaj6",
"twentyNineOfMonth": "ijg6dh",
"thirtyOfMonth": "cr8btd",
"thirtyOneOfMonth": "2x4jdd"
}
}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": "1255",
"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": "1255",
"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 | 导入文件过大! |