724027069 / timingreward Goto Github PK
View Code? Open in Web Editor NEW计算打卡信息,以及计算各位奖励
计算打卡信息,以及计算各位奖励
打卡签到签退规则: 1. 打卡时间:每天早7:30-晚22:30 2. 打卡设置三个有效时间段:8:30-12:00;13:30-17:00:18:00-21:30, 打卡时长每覆盖一个有效时间段中的3小时视为半天。 3. 如打卡后离开无结束打卡记录者,当日打卡记录不计入奖励。 4. 如有效时间段内有课,则该时间段无效。 奖励规则: 1. 打卡奖励15元/半天。 说明: 1. 员工A 9:30签到,16:30签退,三个有效时间段都不满足,没有奖励。 实现规则: 1. 数据处理 1)读取打卡记录txt,处理教师有效的打卡时间段。 a) 统计每天最早和最晚的打卡时间。 b) 当日内只打卡一次,即仅有开始时间,无结束时间,当日打卡记录无效。 c) 依据最早、最晚时间,统计当日有效时间段。 2)读取课表。获取教师一周内的工作时间。 2. 计算奖励 1)判断有效时间段内,教师是否上课。如上课,则该有效时间段 无效。 a) 输入打卡开始时间,学校开始上课时间 2)有效时间段数量 * 15 3. 输出结果 输出一个Excel表格,表格包括2个SHEET页,分别为汇总和详情。 汇总页面: 教师编号 教师姓名 有效时间段数量 奖励 详情页面: 教师编号 教师姓名 日期 打卡起止时间 8:30-12:00是否有效 13:30-17:00是否有效 18:00-21:30是否有效 如果有效,显示为Y,如果无效,显示原因,原因包括:打卡时间不满足、有课(具体课程名称)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.