

-- 0表示每周工作日的规则，1表示假期，2表示调休导致的当天上班，3表示调休导致的当前放假


INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(6,2015,2,'周一',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(7,2015,3,'周二',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(8,2015,4,'周三',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(9,2015,5,'周四',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(10,2015,6,'周五',0,1);


INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(21,0,'9:00','12:00',6);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(22,1,'13:00','18:00',6);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(23,0,'9:00','12:00',7);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(24,1,'13:00','18:00',7);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(25,0,'9:00','12:00',8);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(26,1,'13:00','18:00',8);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(27,0,'9:00','12:00',9);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(28,1,'13:00','18:00',9);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(29,0,'9:00','12:00',10);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(30,1,'13:00','18:00',10);


INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(41,'元旦',      2015,'2015-01-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(42,'元旦补休',  2015,'2015-01-02 00:00:00',3,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(43,'元旦调休',  2015,'2015-01-04 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(44,'春节调休',  2015,'2015-02-15 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(45,'春节',      2015,'2015-02-18 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(46,'春节',      2015,'2015-02-19 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(47,'春节',      2015,'2015-02-20 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(48,'春节',      2015,'2015-02-21 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(49,'春节',      2015,'2015-02-22 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(50,'春节',      2015,'2015-02-23 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(51,'春节',      2015,'2015-02-24 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(52,'春节调休',  2015,'2015-02-28 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(53,'清明节',    2015,'2015-04-05 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(54,'清明节补休',2015,'2015-04-06 00:00:00',3,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(55,'劳动节',    2015,'2015-05-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(56,'端午节',    2015,'2015-06-20 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(57,'端午节补休',2015,'2015-06-22 00:00:00',3,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(58,'中秋节',    2015,'2015-09-27 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(59,'中秋节补休',2015,'2015-09-28 00:00:00',3,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(60,'国庆节',    2015,'2015-10-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(61,'国庆节',    2015,'2015-10-02 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(62,'国庆节',    2015,'2015-10-03 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(63,'国庆节',    2015,'2015-10-04 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(64,'国庆节',    2015,'2015-10-05 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(65,'国庆节',    2015,'2015-10-06 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(66,'国庆节',    2015,'2015-10-07 00:00:00',1,1);


INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(31,0,'9:00','12:00',43);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(32,1,'13:00','18:00',43);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(33,0,'9:00','12:00',44);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(34,1,'13:00','18:00',44);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(35,0,'9:00','12:00',52);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(36,1,'13:00','18:00',52);

