php加mysql完整的绩效考核管理系统源码

/* Navicat MySQL Data Transfer Source Server : jixiao Source Server Version : 50547 Source Host : localhost:3306 Source Database : myjixiao Target Server Type : MYSQL Target Server Version : 50547 File Encoding : 65001 Date: 2017-06-19 00:24:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `depart` -- ---------------------------- DROP TABLE IF EXISTS `depart`; CREATE TABLE `depart` ( `depart_id` int(11) NOT NULL AUTO_INCREMENT, `depart_name` varchar(30) NOT NULL DEFAULT '', `depart_code` varchar(10) NOT NULL DEFAULT '' COMMENT '部门编号', `depart_type` varchar(20) DEFAULT '' COMMENT '部门类型', `depart_header` int(11) DEFAULT '0' COMMENT '部门领导人', `depart_addr` varchar(50) DEFAULT '' COMMENT '办公地址', `depart_num` int(11) DEFAULT '0' COMMENT '部门人数', `depart_update` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '部门更新信息', PRIMARY KEY (`depart_id`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of depart -- ---------------------------- INSERT INTO `depart` VALUES ('1', '总公办', '000001', '公司股东', '0', '长沙分公司', '4', '2017-05-18 20:19:12'); INSERT INTO `depart` VALUES ('2', '研发一部', '000002', '研发', '0', '长沙分公司', '16', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('3', '研发二部', '000003', '研发', '0', '长沙分公司', '15', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('4', '研发三部', '000004', '研发', '0', '杭州总公司', '22', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('5', '测试一部', '000005', '测试', '0', '杭州总公司', '8', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('6', '测试二部', '000006', '测试', '0', '长沙分公司', '12', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('7', '测试三部', '000007', '测试', '0', '长沙分公司', '6', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('8', '人事一部', '000008', '人事', '0', '杭州总公司', '4', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('9', '人事二部', '000009', '人事', '0', '长沙分公司', '2', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('10', '人事三部', '000010', '人事', '0', '长沙分公司', '6', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('11', '研究院', '000011', '研究院', '0', '杭州总公司', '7', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('12', '华东销售一部', '000012', '华东销售', '0', '华东', '25', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('13', '华东销售二部', '000013', '华东销售', '0', '华东', '19', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('14', '华东销售三部test', '000014', '华东销售', '0', '华东', '17', '2017-05-18 21:06:49'); INSERT INTO `depart` VALUES ('15', '华中销售一部', '000015', '华中销售', '0', '华中', '26', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('16', '华中销售二部', '000016', '华中销售', '0', '华中', '15', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('17', '华中销售三部', '000017', '华中销售', '0', '华中', '16', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('18', '华南销售一部', '000018', '华南销售', '0', '华南', '8', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('19', '华南销售二部', '000019', '华南销售', '0', '华南', '6', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('20', '财务部', '000020', '财物', '0', '杭州总公司', '5', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('21', '法律部', '000021', '法律', '0', '杭州总公司', '2', '0000-00-00 00:00:00'); INSERT INTO `depart` VALUES ('22', '保密办', '000022', '保密', '0', '杭州总公司', '4', '0000-00-00 00:00:00'); -- ---------------------------- -- Table structure for `dl_eval` -- ---------------------------- DROP TABLE IF EXISTS `dl_eval`; CREATE TABLE `dl_eval` ( `dl_id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) DEFAULT NULL, PRIMARY KEY (`dl_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dl_eval -- ---------------------------- -- ---------------------------- -- Table structure for `dx_eval` -- ---------------------------- DROP TABLE IF EXISTS `dx_eval`; CREATE TABLE `dx_eval` ( `dx_id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) DEFAULT '0' COMMENT '被评人的id', `eval_name` varchar(55) DEFAULT '' COMMENT '评分人姓名', `eval_id` int(11) DEFAULT NULL, `eval_grade` int(11) DEFAULT '0' COMMENT '评价分数', `eval_desc` text COMMENT '评价评语', `eval_creattime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `eval_updatetime` timestamp NULL DEFAULT NULL, `eval_year` varchar(10) DEFAULT NULL, `eval_month` varchar(10) DEFAULT NULL, `eval_quarter` int(3) DEFAULT NULL COMMENT '季度', `eval_type` int(4) DEFAULT '1' COMMENT '1:自我评价；2：组长评价；3：组员评价；', PRIMARY KEY (`dx_id`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dx_eval -- ---------------------------- INSERT INTO `dx_eval` VALUES ('13', '4', '刘琳文', '4', '49', '自我评价测试', '2017-05-24 10:12:28', '2017-05-06 16:00:53', '2017', '05', '2', '1'); INSERT INTO `dx_eval` VALUES ('11', '3', '刘琳文', '4', '46', '员工互评测试', '2017-05-24 10:45:22', '2017-05-06 15:59:54', '2017', '05', '2', '3'); INSERT INTO `dx_eval` VALUES ('12', '2', '刘琳文', '4', '45', '员工互评测试2', '2017-05-24 10:45:16', '2017-05-06 16:00:25', '2017', '05', '2', '3'); INSERT INTO `dx_eval` VALUES ('14', '3', '黄蓉', '3', '49', '组长自我评价测试', '2017-05-24 10:12:51', '2017-05-06 16:10:42', '2017', '05', '2', '1'); INSERT INTO `dx_eval` VALUES ('15', '2', '黄蓉', '3', '48', '组长对普通员工的评价', '2017-05-24 10:45:24', '2017-05-06 16:11:14', '2017', '05', '2', '2'); INSERT INTO `dx_eval` VALUES ('16', '4', '黄蓉', '3', '49', '组长对普通员工的测试', '2017-05-24 10:45:29', '2017-05-06 16:11:52', '2017', '05', '2', '2'); INSERT INTO `dx_eval` VALUES ('17', '3', '刘琳文', '4', '47', '员工互评测试月份不同', '2017-05-24 10:45:36', '2017-05-07 16:25:27', '2017', '06', '2', '3'); INSERT INTO `dx_eval` VALUES ('21', '6', '测试', '5', '49', '', '2017-05-24 10:45:40', '2017-05-17 23:09:42', '2017', '05', '2', '3'); INSERT INTO `dx_eval` VALUES ('20', '5', '测试', '5', '47', '', '2017-05-24 10:13:23', '2017-05-17 23:09:17', '2017', '05', '2', '1'); INSERT INTO `dx_eval` VALUES ('22', '5', '黄蓉', '3', '49', '', '2017-05-24 10:45:42', '2017-05-17 23:10:29', '2017', '05', '2', '2'); INSERT INTO `dx_eval` VALUES ('23', '6', '黄蓉', '3', '48', '', '2017-05-24 10:45:46', '2017-05-17 23:10:55', '2017', '05', '2', '2'); INSERT INTO `dx_eval` VALUES ('24', '5', '', '0', '46', '', '2017-05-24 14:36:26', '2017-05-24 14:36:26', '2017', '05', '2', '3'); INSERT INTO `dx_eval` VALUES ('25', '5', '', '0', '46', '', '2017-05-24 14:36:31', '2017-05-24 14:36:31', '2017', '05', '2', '3'); INSERT INTO `dx_eval` VALUES ('26', '5', '刘琳文', '4', '45', '', '2017-05-24 14:38:50', '2017-05-24 14:38:50', '2017', '05', '2', '3'); -- ---------------------------- -- Table structure for `evallist` -- ---------------------------- DROP TABLE IF EXISTS `evallist`; CREATE TABLE `evallist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` text, `creattime` timestamp NULL DEFAULT NULL, `updatetime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `isuse` int(2) DEFAULT '0' COMMENT '是否启用', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of evallist --