| 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": "15475",
"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": "15475",
"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": "15475",
"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": "15475",
"data": [
{
"workName": "鹏飞.郑",
"groupOfCheck": "jcsv99",
"department": "llvoa5",
"workNum": "pno8cb",
"idCard": "230410199403266024",
"daysOfAttendanceInHuangjiahu": 247,
"daysOfcardShortageInHuangjiahu": "wwjsrc",
"recondOfcardShortageInHuangjiahu": "l7kivt",
"sumAttendanceInHuangjiahu": 597,
"daysOfAttendanceInMoxuanhu": 854,
"daysOfcardShortageInMoxuanhu": "8ynf6g",
"recondOfcardShortageInMoxuanhu": "oe0kv7",
"sumAttendanceInMoxuanhu": 838,
"abnormalClockNumber": 464,
"abnormalClockRecond": "ve6dij",
"leTwentyLateNumber": 291,
"lequalThirtyLateNumber": 869,
"geThirtyLateNumber": 626,
"lateOfRecond": "fkpk6m",
"leTwentyLeaveNumber": 7,
"lequalThirtyLeaveNumber": 386,
"geThirtyLeaveNumber": 119,
"leaveOfRecond": "310z6g",
"attendanceDays": 510,
"userId": "89",
"attendanceDay": "q74n7q",
"restDay": "srar1y",
"workHours": "plosc5",
"numberOfLate": "sgskfl",
"numberOfLateTime": "2023-02-27 10:16:37",
"numberOfSeriousLateness": "xaze56",
"durationOfSevereLateness": "j9ejug",
"daysOfAbsenteeismAndLateness": "7d8yzw",
"leaveEarlyNumber": "xi0fvb",
"leaveEarlyTimes": "058sn9",
"lackOfWorkCardTimes": "dzkz5g",
"lackOfMissingWorkCardTimes": "hu73y3",
"absenteeismDay": "4bpglb",
"evectionDay": "ejo82m",
"goOutDay": "51qn8v",
"bereavementLeave": "ucqtfc",
"privateAffairLeaveDay": "eavmvy",
"maternityLeaveDay": "f488f5",
"sickLeaveDay": "rn23n4",
"escortFalse": "wncn3n",
"marriageLeaveDay": "xuaqiq",
"oneOfMonth": "qdodem",
"twoOfMonth": "3vdx25",
"threeOfMonth": "32isch",
"fourOfMonth": "pzva67",
"fiveOfMonth": "ypv0c3",
"sixOfMonth": "54jkkh",
"sevenOfMonth": "0t706i",
"eightOfMonth": "kte4uv",
"nineOfMonth": "f0v4lv",
"tenOfMonth": "ly06tp",
"elevenOfMonth": "irslxj",
"twelveOfMonth": "1trcbq",
"thirteenOfMonth": "4rsa8a",
"fourteenOfMonth": "8czw58",
"fifteenOfMonth": "exr4jl",
"sixteenOfMonth": "oz1i97",
"seventeenOfMonth": "x99qhn",
"eighteenOfMonth": "8drtro",
"nineteenOfMonth": "t2j79d",
"twentyOfMonth": "qjkpv2",
"twentyOneOfMonth": "mazfhr",
"twentyTwoOfMonth": "6h9jtn",
"twentyThreeOfMonth": "8qsu67",
"twentyFourOfMonth": "oo1iqw",
"twentyFiveOfMonth": "0zwce8",
"twentySixOfMonth": "u2eq7g",
"twentySevenOfMonth": "6vym10",
"twentyEightOfMonth": "c11wpb",
"twentyNineOfMonth": "plgmwv",
"thirtyOfMonth": "fc93g3",
"thirtyOneOfMonth": "8jilh0"
}
]
}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": "15475",
"data": {
"id": 943,
"userId": "89",
"workName": "鹏飞.郑",
"oneOfMonth": "w3uaj1",
"twoOfMonth": "4320wj",
"threeOfMonth": "kugi8e",
"fourOfMonth": "7q7hth",
"fiveOfMonth": "nlycav",
"sixOfMonth": "v17fdk",
"sevenOfMonth": "vuudhs",
"eightOfMonth": "2qa81u",
"nineOfMonth": "7d2bdj",
"tenOfMonth": "shzyit",
"elevenOfMonth": "4jidwu",
"twelveOfMonth": "fxh0b3",
"thirteenOfMonth": "zj440j",
"fourteenOfMonth": "v4y07k",
"fifteenOfMonth": "3mgfk9",
"sixteenOfMonth": "smbjwu",
"seventeenOfMonth": "67g8t7",
"eighteenOfMonth": "03neau",
"nineteenOfMonth": "y05s5c",
"twentyOfMonth": "5qm1ig",
"twentyOneOfMonth": "lcg1w6",
"twentyTwoOfMonth": "w2bucq",
"twentyThreeOfMonth": "7283yv",
"twentyFourOfMonth": "o7en0i",
"twentyFiveOfMonth": "0zwhh6",
"twentySixOfMonth": "uxrh5m",
"twentySevenOfMonth": "9hqudr",
"twentyEightOfMonth": "aq8a88",
"twentyNineOfMonth": "5sr4in",
"thirtyOfMonth": "b12b4f",
"thirtyOneOfMonth": "o6fgrf"
}
}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": "15475",
"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": "15475",
"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 | 文件导入失败 |
10100 | 批量操作数据库失败 |
10021 | 付款金额错误 |
10022 | 缴费项目已存在 |
10025 | 缴费项目不存在 |
10023 | id为空 |
10024 | 该缴费项目不支持导出TXT |
10025 | 该缴费宿舍已缴费 |
10026 | 内容超长 |
10027 | AES加密失败 |
10028 | 宿舍已缴费 |
10029 | 该订单的部分项目已支付,请前往首页重新支付 |