基于ssm整合的web考勤管理系统

项目描述

主要有，考勤管理、认识管理、排班管理、考勤统计等

运行环境

jdk7+tomcat7+mysql+IntelliJ IDEA（eclipse）+maven

项目技术(必填)
spring+spring mvc+mybatis+bootstrap+jquery

数据库文件

在项目文件里面

jar包文件
在项目文件里面

截图：



数据库表：

CREATE TABLE askforleave (
askForLeaveId int(11) NOT NULL AUTO_INCREMENT COMMENT ‘请假公休加班表主键ID’,
proposerId int(11) DEFAULT NULL COMMENT ‘申请人ID(staffId)’,
registrationTypeId int(11) DEFAULT NULL COMMENT ‘登记类型ID(attendanceClassChildId)’,
startDate datetime DEFAULT NULL COMMENT ‘起始时间’,
endDate datetime DEFAULT NULL COMMENT ‘终止时间’,
operationStaffId int(11) DEFAULT NULL COMMENT ‘操作人ID(staffId)’,
operatingTime datetime DEFAULT NULL COMMENT ‘操作时间’,
checkTime datetime DEFAULT NULL COMMENT ‘审核时间’,
checkManId int(11) DEFAULT NULL COMMENT ‘审核人ID(staffId)’,
remark varchar(200) DEFAULT NULL COMMENT ‘申请原因’,
checkTypeId int(1) DEFAULT NULL COMMENT ‘处理状态id（对应属性明细表主键id）’,
writeBack varchar(200) DEFAULT NULL COMMENT ‘批示’,
groupid int(11) DEFAULT NULL COMMENT ‘班组id’,
workNo tinyint(4) DEFAULT NULL COMMENT ‘出差计出勤时间否’,
PRIMARY KEY (askForLeaveId)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

/*Data for the table askforleave */

insert into askforleave(askForLeaveId,proposerId,registrationTypeId,startDate,endDate,operationStaffId,operatingTime,checkTime,checkManId,remark,checkTypeId,writeBack,groupid,workNo) values (23,26,17,‘2017-03-15 11:43:00’,‘2017-03-16 11:43:00’,26,‘2017-03-15 11:43:00’,‘2017-03-15 11:43:00’,26,‘有急事’,31,’’,27,1);

/*Table structure for table askforleavemx */

DROP TABLE IF EXISTS askforleavemx;

CREATE TABLE askforleavemx (
askForLeaveMxId int(11) NOT NULL AUTO_INCREMENT COMMENT ‘申请加班班次表主键id’,
positionClassesId int(11) DEFAULT NULL COMMENT ‘对应班次表id’,
askForLeaveId int(11) DEFAULT NULL COMMENT ‘对应请假公休加班表主键ID’,
PRIMARY KEY (askForLeaveMxId)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*Data for the table askforleavemx */

/*Table structure for table attendanceclasschild */

DROP TABLE IF EXISTS attendanceclasschild;

CREATE TABLE attendanceclasschild (
attendanceClassChildId int(11) NOT NULL AUTO_INCREMENT COMMENT ‘考勤类别明细表主键ID’,
dealWithNumber varchar(20) DEFAULT NULL COMMENT ‘处理结果编号’,
dealWithName varchar(20) DEFAULT NULL COMMENT ‘处理结果名称’,
resultId int(11) DEFAULT NULL COMMENT ‘处理结果单位ID(attributeGatherChildId)’,
ignoreValue int(11) DEFAULT NULL COMMENT ‘忽略不计值’,
wayId int(11) DEFAULT NULL COMMENT ‘舍入方式ID(attributeGatherChildId)’,
attendanceCTypeId int(11) DEFAULT NULL COMMENT ‘考勤类别id(属性明细表id)’,
deleteNo tinyint(1) DEFAULT NULL COMMENT ‘删除否’,
PRIMARY KEY (attendanceClassChildId)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

/*Data for the table attendanceclasschild */

insert into attendanceclasschild(attendanceClassChildId,dealWithNumber,dealWithName,resultId,ignoreValue,wayId,attendanceCTypeId,deleteNo) values (1,‘001’,‘白班’,17,2,20,9,0),(8,‘002’,‘夜班’,17,2,20,9,0),(9,‘0020’,‘平时加班’,17,2,20,10,0),(10,‘0021’,‘公休加班’,17,2,20,10,0),(11,‘0022’,‘节日加班’,17,2,20,10,0),(12,‘0030’,‘普通公休’,16,2,20,11,0),(13,‘0030’,‘缺勤’,17,2,20,15,0),(14,‘0031’,‘旷工’,17,2,20,15,0),(16,‘0056’,‘外地出差’,16,2,20,13,0),(17,‘0023’,‘平时请假’,16,1,20,12,0);

/*Table structure for table attributegather */

DROP TABLE IF EXISTS attributegather;

CREATE TABLE attributegather (
attributeGatherId int(11) NOT NULL AUTO_INCREMENT COMMENT ‘属性集合表主键ID’,
attributeGatherName varchar(40) DEFAULT NULL COMMENT ‘属性集合ID’,
PRIMARY KEY (attributeGatherId)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

/*Data for the table attributegather */

insert into attributegather(attributeGatherId,attributeGatherName) values (1,‘职位状态’),(2,‘职务’),(3,‘班次类型’),(4,‘考勤类别’),(5,‘处理结果’),(6,‘舍入方式’),(7,‘班组’),(8,‘签到方式’),(9,‘处理结果状态’);

/*Table structure for table attributegatherchild */

DROP TABLE IF EXISTS attributegatherchild;

CREATE TABLE attributegatherchild (
attributeGatherChildId int(11) NOT NULL AUTO_INCREMENT COMMENT ‘属性明细表主键ID’,
Name varchar(40) DEFAULT NULL COMMENT ‘属性明细表名称’,
attributeGatherId int(11) DEFAULT NULL COMMENT ‘属性集合ID’,
deleteNo tinyint(1) DEFAULT NULL,
PRIMARY KEY (attributeGatherChildId)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

/*Data for the table attributegatherchild */

insert into attributegatherchild(attributeGatherChildId,Name,attributeGatherId,deleteNo) values (1,‘在职’,1,0),(2,‘离职’,1,0),(3,‘待离职’,1,0),(4,‘董事长’,2,0),(5,‘经理’,2,0),(6,‘员工’,2,0),(7,‘正常班’,3,0),(8,‘不定时班’,3,0),(9,‘出勤类别’,4,0),(10,‘加班类别’,4,0),(11,‘公休类别’,4,0),(12,‘请假类别’,4,0),(13,‘出差类别’,4,0),(14,‘外出类别’,4,0),(15,‘缺勤类别’,4,0),(16,‘天’,5,0),(17,‘时’,5,0),(19,‘去尾’,6,0),(20,‘四舍五入’,6,0),(22,‘默认班组’,7,0),(27,‘精英班’,7,0),(29,‘指纹签到’,8,0),(30,‘人工签到’,8,0),(31,‘通过’,9,0),(32,‘不通过’,9,0),(33,‘未处理’,9,0);