當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

生成和获取法定节假日

發(fā)布時間：2023/12/20 编程问答 29 豆豆

生活随笔收集整理的這篇文章主要介紹了生成和获取法定节假日小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.

1.獲取官方節(jié)假日信息

在中國政府網(wǎng)獲取信息：中國政府網(wǎng)_中央人民政府門戶網(wǎng)站

?2.復制下面代碼

以php為例

/*** 生成工作日* @param array $holiday 法定節(jié)假日* @param array $exchange_day 調(diào)休日* @return array $calendar* day：日期，2023-01-01* day_type：類型，0-工作日，1-法定節(jié)假日，2-周末加班調(diào)休，3-周末* is_work_day：是否為工作日，1-是，0-否*/public function makeWorkDay($holiday,$exchange_day) {$calendar = [];$year = 0;//法定節(jié)假日foreach ($holiday as $k => $v) {$day = date('Y-m-d',strtotime($v));$calendar[$day] = ['day'=>$day,'day_type'=>1,'is_work_day'=>0];if(!$year) {$year = date('Y',strtotime($day));}}//調(diào)休日foreach ($exchange_day as $k => $v) {$day = date('Y-m-d',strtotime($v));$calendar[$day] = ['day'=>$day,'day_type'=>2,'is_work_day'=>1];}//其他日期$this_date = $year . '-01-01';$end_date = ($year + 1) . '-01-01';while (strtotime($this_date) < strtotime($end_date)) {if(!isset($calendar[$this_date])){$w = date('w',strtotime($this_date));if(in_array($w,[0,6])){$calendar[$this_date] = ['day'=>$this_date,'day_type'=>3,'is_work_day'=>0];}else{$calendar[$this_date] = ['day'=>$this_date,'day_type'=>0,'is_work_day'=>1];}}$this_date = date('Y-m-d', strtotime($this_date .' +1 day'));}ksort($calendar);return $calendar;}

3.在第一步中獲取的節(jié)假日和調(diào)休日信息傳入改函數(shù)并調(diào)用即可獲取

以2023年為例

$a1 = ['2023-01-01','2023-01-02','2023-01-21','2023-01-22','2023-01-23','2023-01-24','2023-01-25','2023-01-26','2023-01-27','2023-04-05','2023-04-29','2023-04-30','2023-05-01','2023-05-02','2023-05-03','2023-06-22','2023-06-23','2023-06-24','2023-09-29','2023-09-30','2023-10-01','2023-10-02','2023-10-03','2023-10-04','2023-10-05','2023-10-06']; $a2 = ['2023-01-28', '2023-01-29', '2023-04-23', '2023-05-06', '2023-06-25', '2023-10-07', '2023-10-08']; $a = $this->makeWorkDay($a1,$a2);

附件：2023年節(jié)假日sql腳本

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;-- ---------------------------- -- Table structure for my_workday -- ---------------------------- DROP TABLE IF EXISTS `my_workday`; CREATE TABLE `my_workday` (`id` bigint NOT NULL AUTO_INCREMENT,`day` date NOT NULL COMMENT '日期',`day_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '類型：\r\n工作日：0;\r\n法定節(jié)假日：1;\r\n周末加班調(diào)休：2;\r\n周末：3;',`is_work_day` tinyint(1) NOT NULL COMMENT '是否為工作日：1-是；0-否；',PRIMARY KEY (`id`) USING BTREE,INDEX `work_day`(`day`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 731 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '國家法定節(jié)假日表' ROW_FORMAT = DYNAMIC;-- ---------------------------- -- Records of my_workday -- ---------------------------- INSERT INTO `my_workday` VALUES (1, '2023-01-01', 1, 0); INSERT INTO `my_workday` VALUES (2, '2023-01-02', 1, 0); INSERT INTO `my_workday` VALUES (3, '2023-01-03', 0, 1); INSERT INTO `my_workday` VALUES (4, '2023-01-04', 0, 1); INSERT INTO `my_workday` VALUES (5, '2023-01-05', 0, 1); INSERT INTO `my_workday` VALUES (6, '2023-01-06', 0, 1); INSERT INTO `my_workday` VALUES (7, '2023-01-07', 3, 0); INSERT INTO `my_workday` VALUES (8, '2023-01-08', 3, 0); INSERT INTO `my_workday` VALUES (9, '2023-01-09', 0, 1); INSERT INTO `my_workday` VALUES (10, '2023-01-10', 0, 1); INSERT INTO `my_workday` VALUES (11, '2023-01-11', 0, 1); INSERT INTO `my_workday` VALUES (12, '2023-01-12', 0, 1); INSERT INTO `my_workday` VALUES (13, '2023-01-13', 0, 1); INSERT INTO `my_workday` VALUES (14, '2023-01-14', 3, 0); INSERT INTO `my_workday` VALUES (15, '2023-01-15', 3, 0); INSERT INTO `my_workday` VALUES (16, '2023-01-16', 0, 1); INSERT INTO `my_workday` VALUES (17, '2023-01-17', 0, 1); INSERT INTO `my_workday` VALUES (18, '2023-01-18', 0, 1); INSERT INTO `my_workday` VALUES (19, '2023-01-19', 0, 1); INSERT INTO `my_workday` VALUES (20, '2023-01-20', 0, 1); INSERT INTO `my_workday` VALUES (21, '2023-01-21', 1, 0); INSERT INTO `my_workday` VALUES (22, '2023-01-22', 1, 0); INSERT INTO `my_workday` VALUES (23, '2023-01-23', 1, 0); INSERT INTO `my_workday` VALUES (24, '2023-01-24', 1, 0); INSERT INTO `my_workday` VALUES (25, '2023-01-25', 1, 0); INSERT INTO `my_workday` VALUES (26, '2023-01-26', 1, 0); INSERT INTO `my_workday` VALUES (27, '2023-01-27', 1, 0); INSERT INTO `my_workday` VALUES (28, '2023-01-28', 2, 1); INSERT INTO `my_workday` VALUES (29, '2023-01-29', 2, 1); INSERT INTO `my_workday` VALUES (30, '2023-01-30', 0, 1); INSERT INTO `my_workday` VALUES (31, '2023-01-31', 0, 1); INSERT INTO `my_workday` VALUES (32, '2023-02-01', 0, 1); INSERT INTO `my_workday` VALUES (33, '2023-02-02', 0, 1); INSERT INTO `my_workday` VALUES (34, '2023-02-03', 0, 1); INSERT INTO `my_workday` VALUES (35, '2023-02-04', 3, 0); INSERT INTO `my_workday` VALUES (36, '2023-02-05', 3, 0); INSERT INTO `my_workday` VALUES (37, '2023-02-06', 0, 1); INSERT INTO `my_workday` VALUES (38, '2023-02-07', 0, 1); INSERT INTO `my_workday` VALUES (39, '2023-02-08', 0, 1); INSERT INTO `my_workday` VALUES (40, '2023-02-09', 0, 1); INSERT INTO `my_workday` VALUES (41, '2023-02-10', 0, 1); INSERT INTO `my_workday` VALUES (42, '2023-02-11', 3, 0); INSERT INTO `my_workday` VALUES (43, '2023-02-12', 3, 0); INSERT INTO `my_workday` VALUES (44, '2023-02-13', 0, 1); INSERT INTO `my_workday` VALUES (45, '2023-02-14', 0, 1); INSERT INTO `my_workday` VALUES (46, '2023-02-15', 0, 1); INSERT INTO `my_workday` VALUES (47, '2023-02-16', 0, 1); INSERT INTO `my_workday` VALUES (48, '2023-02-17', 0, 1); INSERT INTO `my_workday` VALUES (49, '2023-02-18', 3, 0); INSERT INTO `my_workday` VALUES (50, '2023-02-19', 3, 0); INSERT INTO `my_workday` VALUES (51, '2023-02-20', 0, 1); INSERT INTO `my_workday` VALUES (52, '2023-02-21', 0, 1); INSERT INTO `my_workday` VALUES (53, '2023-02-22', 0, 1); INSERT INTO `my_workday` VALUES (54, '2023-02-23', 0, 1); INSERT INTO `my_workday` VALUES (55, '2023-02-24', 0, 1); INSERT INTO `my_workday` VALUES (56, '2023-02-25', 3, 0); INSERT INTO `my_workday` VALUES (57, '2023-02-26', 3, 0); INSERT INTO `my_workday` VALUES (58, '2023-02-27', 0, 1); INSERT INTO `my_workday` VALUES (59, '2023-02-28', 0, 1); INSERT INTO `my_workday` VALUES (60, '2023-03-01', 0, 1); INSERT INTO `my_workday` VALUES (61, '2023-03-02', 0, 1); INSERT INTO `my_workday` VALUES (62, '2023-03-03', 0, 1); INSERT INTO `my_workday` VALUES (63, '2023-03-04', 3, 0); INSERT INTO `my_workday` VALUES (64, '2023-03-05', 3, 0); INSERT INTO `my_workday` VALUES (65, '2023-03-06', 0, 1); INSERT INTO `my_workday` VALUES (66, '2023-03-07', 0, 1); INSERT INTO `my_workday` VALUES (67, '2023-03-08', 0, 1); INSERT INTO `my_workday` VALUES (68, '2023-03-09', 0, 1); INSERT INTO `my_workday` VALUES (69, '2023-03-10', 0, 1); INSERT INTO `my_workday` VALUES (70, '2023-03-11', 3, 0); INSERT INTO `my_workday` VALUES (71, '2023-03-12', 3, 0); INSERT INTO `my_workday` VALUES (72, '2023-03-13', 0, 1); INSERT INTO `my_workday` VALUES (73, '2023-03-14', 0, 1); INSERT INTO `my_workday` VALUES (74, '2023-03-15', 0, 1); INSERT INTO `my_workday` VALUES (75, '2023-03-16', 0, 1); INSERT INTO `my_workday` VALUES (76, '2023-03-17', 0, 1); INSERT INTO `my_workday` VALUES (77, '2023-03-18', 3, 0); INSERT INTO `my_workday` VALUES (78, '2023-03-19', 3, 0); INSERT INTO `my_workday` VALUES (79, '2023-03-20', 0, 1); INSERT INTO `my_workday` VALUES (80, '2023-03-21', 0, 1); INSERT INTO `my_workday` VALUES (81, '2023-03-22', 0, 1); INSERT INTO `my_workday` VALUES (82, '2023-03-23', 0, 1); INSERT INTO `my_workday` VALUES (83, '2023-03-24', 0, 1); INSERT INTO `my_workday` VALUES (84, '2023-03-25', 3, 0); INSERT INTO `my_workday` VALUES (85, '2023-03-26', 3, 0); INSERT INTO `my_workday` VALUES (86, '2023-03-27', 0, 1); INSERT INTO `my_workday` VALUES (87, '2023-03-28', 0, 1); INSERT INTO `my_workday` VALUES (88, '2023-03-29', 0, 1); INSERT INTO `my_workday` VALUES (89, '2023-03-30', 0, 1); INSERT INTO `my_workday` VALUES (90, '2023-03-31', 0, 1); INSERT INTO `my_workday` VALUES (91, '2023-04-01', 3, 0); INSERT INTO `my_workday` VALUES (92, '2023-04-02', 3, 0); INSERT INTO `my_workday` VALUES (93, '2023-04-03', 0, 1); INSERT INTO `my_workday` VALUES (94, '2023-04-04', 0, 1); INSERT INTO `my_workday` VALUES (95, '2023-04-05', 1, 0); INSERT INTO `my_workday` VALUES (96, '2023-04-06', 0, 1); INSERT INTO `my_workday` VALUES (97, '2023-04-07', 0, 1); INSERT INTO `my_workday` VALUES (98, '2023-04-08', 3, 0); INSERT INTO `my_workday` VALUES (99, '2023-04-09', 3, 0); INSERT INTO `my_workday` VALUES (100, '2023-04-10', 0, 1); INSERT INTO `my_workday` VALUES (101, '2023-04-11', 0, 1); INSERT INTO `my_workday` VALUES (102, '2023-04-12', 0, 1); INSERT INTO `my_workday` VALUES (103, '2023-04-13', 0, 1); INSERT INTO `my_workday` VALUES (104, '2023-04-14', 0, 1); INSERT INTO `my_workday` VALUES (105, '2023-04-15', 3, 0); INSERT INTO `my_workday` VALUES (106, '2023-04-16', 3, 0); INSERT INTO `my_workday` VALUES (107, '2023-04-17', 0, 1); INSERT INTO `my_workday` VALUES (108, '2023-04-18', 0, 1); INSERT INTO `my_workday` VALUES (109, '2023-04-19', 0, 1); INSERT INTO `my_workday` VALUES (110, '2023-04-20', 0, 1); INSERT INTO `my_workday` VALUES (111, '2023-04-21', 0, 1); INSERT INTO `my_workday` VALUES (112, '2023-04-22', 3, 0); INSERT INTO `my_workday` VALUES (113, '2023-04-23', 2, 1); INSERT INTO `my_workday` VALUES (114, '2023-04-24', 0, 1); INSERT INTO `my_workday` VALUES (115, '2023-04-25', 0, 1); INSERT INTO `my_workday` VALUES (116, '2023-04-26', 0, 1); INSERT INTO `my_workday` VALUES (117, '2023-04-27', 0, 1); INSERT INTO `my_workday` VALUES (118, '2023-04-28', 0, 1); INSERT INTO `my_workday` VALUES (119, '2023-04-29', 1, 0); INSERT INTO `my_workday` VALUES (120, '2023-04-30', 1, 0); INSERT INTO `my_workday` VALUES (121, '2023-05-01', 1, 0); INSERT INTO `my_workday` VALUES (122, '2023-05-02', 1, 0); INSERT INTO `my_workday` VALUES (123, '2023-05-03', 1, 0); INSERT INTO `my_workday` VALUES (124, '2023-05-04', 0, 1); INSERT INTO `my_workday` VALUES (125, '2023-05-05', 0, 1); INSERT INTO `my_workday` VALUES (126, '2023-05-06', 2, 1); INSERT INTO `my_workday` VALUES (127, '2023-05-07', 3, 0); INSERT INTO `my_workday` VALUES (128, '2023-05-08', 0, 1); INSERT INTO `my_workday` VALUES (129, '2023-05-09', 0, 1); INSERT INTO `my_workday` VALUES (130, '2023-05-10', 0, 1); INSERT INTO `my_workday` VALUES (131, '2023-05-11', 0, 1); INSERT INTO `my_workday` VALUES (132, '2023-05-12', 0, 1); INSERT INTO `my_workday` VALUES (133, '2023-05-13', 3, 0); INSERT INTO `my_workday` VALUES (134, '2023-05-14', 3, 0); INSERT INTO `my_workday` VALUES (135, '2023-05-15', 0, 1); INSERT INTO `my_workday` VALUES (136, '2023-05-16', 0, 1); INSERT INTO `my_workday` VALUES (137, '2023-05-17', 0, 1); INSERT INTO `my_workday` VALUES (138, '2023-05-18', 0, 1); INSERT INTO `my_workday` VALUES (139, '2023-05-19', 0, 1); INSERT INTO `my_workday` VALUES (140, '2023-05-20', 3, 0); INSERT INTO `my_workday` VALUES (141, '2023-05-21', 3, 0); INSERT INTO `my_workday` VALUES (142, '2023-05-22', 0, 1); INSERT INTO `my_workday` VALUES (143, '2023-05-23', 0, 1); INSERT INTO `my_workday` VALUES (144, '2023-05-24', 0, 1); INSERT INTO `my_workday` VALUES (145, '2023-05-25', 0, 1); INSERT INTO `my_workday` VALUES (146, '2023-05-26', 0, 1); INSERT INTO `my_workday` VALUES (147, '2023-05-27', 3, 0); INSERT INTO `my_workday` VALUES (148, '2023-05-28', 3, 0); INSERT INTO `my_workday` VALUES (149, '2023-05-29', 0, 1); INSERT INTO `my_workday` VALUES (150, '2023-05-30', 0, 1); INSERT INTO `my_workday` VALUES (151, '2023-05-31', 0, 1); INSERT INTO `my_workday` VALUES (152, '2023-06-01', 0, 1); INSERT INTO `my_workday` VALUES (153, '2023-06-02', 0, 1); INSERT INTO `my_workday` VALUES (154, '2023-06-03', 3, 0); INSERT INTO `my_workday` VALUES (155, '2023-06-04', 3, 0); INSERT INTO `my_workday` VALUES (156, '2023-06-05', 0, 1); INSERT INTO `my_workday` VALUES (157, '2023-06-06', 0, 1); INSERT INTO `my_workday` VALUES (158, '2023-06-07', 0, 1); INSERT INTO `my_workday` VALUES (159, '2023-06-08', 0, 1); INSERT INTO `my_workday` VALUES (160, '2023-06-09', 0, 1); INSERT INTO `my_workday` VALUES (161, '2023-06-10', 3, 0); INSERT INTO `my_workday` VALUES (162, '2023-06-11', 3, 0); INSERT INTO `my_workday` VALUES (163, '2023-06-12', 0, 1); INSERT INTO `my_workday` VALUES (164, '2023-06-13', 0, 1); INSERT INTO `my_workday` VALUES (165, '2023-06-14', 0, 1); INSERT INTO `my_workday` VALUES (166, '2023-06-15', 0, 1); INSERT INTO `my_workday` VALUES (167, '2023-06-16', 0, 1); INSERT INTO `my_workday` VALUES (168, '2023-06-17', 3, 0); INSERT INTO `my_workday` VALUES (169, '2023-06-18', 3, 0); INSERT INTO `my_workday` VALUES (170, '2023-06-19', 0, 1); INSERT INTO `my_workday` VALUES (171, '2023-06-20', 0, 1); INSERT INTO `my_workday` VALUES (172, '2023-06-21', 0, 1); INSERT INTO `my_workday` VALUES (173, '2023-06-22', 1, 0); INSERT INTO `my_workday` VALUES (174, '2023-06-23', 1, 0); INSERT INTO `my_workday` VALUES (175, '2023-06-24', 1, 0); INSERT INTO `my_workday` VALUES (176, '2023-06-25', 2, 1); INSERT INTO `my_workday` VALUES (177, '2023-06-26', 0, 1); INSERT INTO `my_workday` VALUES (178, '2023-06-27', 0, 1); INSERT INTO `my_workday` VALUES (179, '2023-06-28', 0, 1); INSERT INTO `my_workday` VALUES (180, '2023-06-29', 0, 1); INSERT INTO `my_workday` VALUES (181, '2023-06-30', 0, 1); INSERT INTO `my_workday` VALUES (182, '2023-07-01', 3, 0); INSERT INTO `my_workday` VALUES (183, '2023-07-02', 3, 0); INSERT INTO `my_workday` VALUES (184, '2023-07-03', 0, 1); INSERT INTO `my_workday` VALUES (185, '2023-07-04', 0, 1); INSERT INTO `my_workday` VALUES (186, '2023-07-05', 0, 1); INSERT INTO `my_workday` VALUES (187, '2023-07-06', 0, 1); INSERT INTO `my_workday` VALUES (188, '2023-07-07', 0, 1); INSERT INTO `my_workday` VALUES (189, '2023-07-08', 3, 0); INSERT INTO `my_workday` VALUES (190, '2023-07-09', 3, 0); INSERT INTO `my_workday` VALUES (191, '2023-07-10', 0, 1); INSERT INTO `my_workday` VALUES (192, '2023-07-11', 0, 1); INSERT INTO `my_workday` VALUES (193, '2023-07-12', 0, 1); INSERT INTO `my_workday` VALUES (194, '2023-07-13', 0, 1); INSERT INTO `my_workday` VALUES (195, '2023-07-14', 0, 1); INSERT INTO `my_workday` VALUES (196, '2023-07-15', 3, 0); INSERT INTO `my_workday` VALUES (197, '2023-07-16', 3, 0); INSERT INTO `my_workday` VALUES (198, '2023-07-17', 0, 1); INSERT INTO `my_workday` VALUES (199, '2023-07-18', 0, 1); INSERT INTO `my_workday` VALUES (200, '2023-07-19', 0, 1); INSERT INTO `my_workday` VALUES (201, '2023-07-20', 0, 1); INSERT INTO `my_workday` VALUES (202, '2023-07-21', 0, 1); INSERT INTO `my_workday` VALUES (203, '2023-07-22', 3, 0); INSERT INTO `my_workday` VALUES (204, '2023-07-23', 3, 0); INSERT INTO `my_workday` VALUES (205, '2023-07-24', 0, 1); INSERT INTO `my_workday` VALUES (206, '2023-07-25', 0, 1); INSERT INTO `my_workday` VALUES (207, '2023-07-26', 0, 1); INSERT INTO `my_workday` VALUES (208, '2023-07-27', 0, 1); INSERT INTO `my_workday` VALUES (209, '2023-07-28', 0, 1); INSERT INTO `my_workday` VALUES (210, '2023-07-29', 3, 0); INSERT INTO `my_workday` VALUES (211, '2023-07-30', 3, 0); INSERT INTO `my_workday` VALUES (212, '2023-07-31', 0, 1); INSERT INTO `my_workday` VALUES (213, '2023-08-01', 0, 1); INSERT INTO `my_workday` VALUES (214, '2023-08-02', 0, 1); INSERT INTO `my_workday` VALUES (215, '2023-08-03', 0, 1); INSERT INTO `my_workday` VALUES (216, '2023-08-04', 0, 1); INSERT INTO `my_workday` VALUES (217, '2023-08-05', 3, 0); INSERT INTO `my_workday` VALUES (218, '2023-08-06', 3, 0); INSERT INTO `my_workday` VALUES (219, '2023-08-07', 0, 1); INSERT INTO `my_workday` VALUES (220, '2023-08-08', 0, 1); INSERT INTO `my_workday` VALUES (221, '2023-08-09', 0, 1); INSERT INTO `my_workday` VALUES (222, '2023-08-10', 0, 1); INSERT INTO `my_workday` VALUES (223, '2023-08-11', 0, 1); INSERT INTO `my_workday` VALUES (224, '2023-08-12', 3, 0); INSERT INTO `my_workday` VALUES (225, '2023-08-13', 3, 0); INSERT INTO `my_workday` VALUES (226, '2023-08-14', 0, 1); INSERT INTO `my_workday` VALUES (227, '2023-08-15', 0, 1); INSERT INTO `my_workday` VALUES (228, '2023-08-16', 0, 1); INSERT INTO `my_workday` VALUES (229, '2023-08-17', 0, 1); INSERT INTO `my_workday` VALUES (230, '2023-08-18', 0, 1); INSERT INTO `my_workday` VALUES (231, '2023-08-19', 3, 0); INSERT INTO `my_workday` VALUES (232, '2023-08-20', 3, 0); INSERT INTO `my_workday` VALUES (233, '2023-08-21', 0, 1); INSERT INTO `my_workday` VALUES (234, '2023-08-22', 0, 1); INSERT INTO `my_workday` VALUES (235, '2023-08-23', 0, 1); INSERT INTO `my_workday` VALUES (236, '2023-08-24', 0, 1); INSERT INTO `my_workday` VALUES (237, '2023-08-25', 0, 1); INSERT INTO `my_workday` VALUES (238, '2023-08-26', 3, 0); INSERT INTO `my_workday` VALUES (239, '2023-08-27', 3, 0); INSERT INTO `my_workday` VALUES (240, '2023-08-28', 0, 1); INSERT INTO `my_workday` VALUES (241, '2023-08-29', 0, 1); INSERT INTO `my_workday` VALUES (242, '2023-08-30', 0, 1); INSERT INTO `my_workday` VALUES (243, '2023-08-31', 0, 1); INSERT INTO `my_workday` VALUES (244, '2023-09-01', 0, 1); INSERT INTO `my_workday` VALUES (245, '2023-09-02', 3, 0); INSERT INTO `my_workday` VALUES (246, '2023-09-03', 3, 0); INSERT INTO `my_workday` VALUES (247, '2023-09-04', 0, 1); INSERT INTO `my_workday` VALUES (248, '2023-09-05', 0, 1); INSERT INTO `my_workday` VALUES (249, '2023-09-06', 0, 1); INSERT INTO `my_workday` VALUES (250, '2023-09-07', 0, 1); INSERT INTO `my_workday` VALUES (251, '2023-09-08', 0, 1); INSERT INTO `my_workday` VALUES (252, '2023-09-09', 3, 0); INSERT INTO `my_workday` VALUES (253, '2023-09-10', 3, 0); INSERT INTO `my_workday` VALUES (254, '2023-09-11', 0, 1); INSERT INTO `my_workday` VALUES (255, '2023-09-12', 0, 1); INSERT INTO `my_workday` VALUES (256, '2023-09-13', 0, 1); INSERT INTO `my_workday` VALUES (257, '2023-09-14', 0, 1); INSERT INTO `my_workday` VALUES (258, '2023-09-15', 0, 1); INSERT INTO `my_workday` VALUES (259, '2023-09-16', 3, 0); INSERT INTO `my_workday` VALUES (260, '2023-09-17', 3, 0); INSERT INTO `my_workday` VALUES (261, '2023-09-18', 0, 1); INSERT INTO `my_workday` VALUES (262, '2023-09-19', 0, 1); INSERT INTO `my_workday` VALUES (263, '2023-09-20', 0, 1); INSERT INTO `my_workday` VALUES (264, '2023-09-21', 0, 1); INSERT INTO `my_workday` VALUES (265, '2023-09-22', 0, 1); INSERT INTO `my_workday` VALUES (266, '2023-09-23', 3, 0); INSERT INTO `my_workday` VALUES (267, '2023-09-24', 3, 0); INSERT INTO `my_workday` VALUES (268, '2023-09-25', 0, 1); INSERT INTO `my_workday` VALUES (269, '2023-09-26', 0, 1); INSERT INTO `my_workday` VALUES (270, '2023-09-27', 0, 1); INSERT INTO `my_workday` VALUES (271, '2023-09-28', 0, 1); INSERT INTO `my_workday` VALUES (272, '2023-09-29', 1, 0); INSERT INTO `my_workday` VALUES (273, '2023-09-30', 1, 0); INSERT INTO `my_workday` VALUES (274, '2023-10-01', 1, 0); INSERT INTO `my_workday` VALUES (275, '2023-10-02', 1, 0); INSERT INTO `my_workday` VALUES (276, '2023-10-03', 1, 0); INSERT INTO `my_workday` VALUES (277, '2023-10-04', 1, 0); INSERT INTO `my_workday` VALUES (278, '2023-10-05', 1, 0); INSERT INTO `my_workday` VALUES (279, '2023-10-06', 1, 0); INSERT INTO `my_workday` VALUES (280, '2023-10-07', 2, 1); INSERT INTO `my_workday` VALUES (281, '2023-10-08', 2, 1); INSERT INTO `my_workday` VALUES (282, '2023-10-09', 0, 1); INSERT INTO `my_workday` VALUES (283, '2023-10-10', 0, 1); INSERT INTO `my_workday` VALUES (284, '2023-10-11', 0, 1); INSERT INTO `my_workday` VALUES (285, '2023-10-12', 0, 1); INSERT INTO `my_workday` VALUES (286, '2023-10-13', 0, 1); INSERT INTO `my_workday` VALUES (287, '2023-10-14', 3, 0); INSERT INTO `my_workday` VALUES (288, '2023-10-15', 3, 0); INSERT INTO `my_workday` VALUES (289, '2023-10-16', 0, 1); INSERT INTO `my_workday` VALUES (290, '2023-10-17', 0, 1); INSERT INTO `my_workday` VALUES (291, '2023-10-18', 0, 1); INSERT INTO `my_workday` VALUES (292, '2023-10-19', 0, 1); INSERT INTO `my_workday` VALUES (293, '2023-10-20', 0, 1); INSERT INTO `my_workday` VALUES (294, '2023-10-21', 3, 0); INSERT INTO `my_workday` VALUES (295, '2023-10-22', 3, 0); INSERT INTO `my_workday` VALUES (296, '2023-10-23', 0, 1); INSERT INTO `my_workday` VALUES (297, '2023-10-24', 0, 1); INSERT INTO `my_workday` VALUES (298, '2023-10-25', 0, 1); INSERT INTO `my_workday` VALUES (299, '2023-10-26', 0, 1); INSERT INTO `my_workday` VALUES (300, '2023-10-27', 0, 1); INSERT INTO `my_workday` VALUES (301, '2023-10-28', 3, 0); INSERT INTO `my_workday` VALUES (302, '2023-10-29', 3, 0); INSERT INTO `my_workday` VALUES (303, '2023-10-30', 0, 1); INSERT INTO `my_workday` VALUES (304, '2023-10-31', 0, 1); INSERT INTO `my_workday` VALUES (305, '2023-11-01', 0, 1); INSERT INTO `my_workday` VALUES (306, '2023-11-02', 0, 1); INSERT INTO `my_workday` VALUES (307, '2023-11-03', 0, 1); INSERT INTO `my_workday` VALUES (308, '2023-11-04', 3, 0); INSERT INTO `my_workday` VALUES (309, '2023-11-05', 3, 0); INSERT INTO `my_workday` VALUES (310, '2023-11-06', 0, 1); INSERT INTO `my_workday` VALUES (311, '2023-11-07', 0, 1); INSERT INTO `my_workday` VALUES (312, '2023-11-08', 0, 1); INSERT INTO `my_workday` VALUES (313, '2023-11-09', 0, 1); INSERT INTO `my_workday` VALUES (314, '2023-11-10', 0, 1); INSERT INTO `my_workday` VALUES (315, '2023-11-11', 3, 0); INSERT INTO `my_workday` VALUES (316, '2023-11-12', 3, 0); INSERT INTO `my_workday` VALUES (317, '2023-11-13', 0, 1); INSERT INTO `my_workday` VALUES (318, '2023-11-14', 0, 1); INSERT INTO `my_workday` VALUES (319, '2023-11-15', 0, 1); INSERT INTO `my_workday` VALUES (320, '2023-11-16', 0, 1); INSERT INTO `my_workday` VALUES (321, '2023-11-17', 0, 1); INSERT INTO `my_workday` VALUES (322, '2023-11-18', 3, 0); INSERT INTO `my_workday` VALUES (323, '2023-11-19', 3, 0); INSERT INTO `my_workday` VALUES (324, '2023-11-20', 0, 1); INSERT INTO `my_workday` VALUES (325, '2023-11-21', 0, 1); INSERT INTO `my_workday` VALUES (326, '2023-11-22', 0, 1); INSERT INTO `my_workday` VALUES (327, '2023-11-23', 0, 1); INSERT INTO `my_workday` VALUES (328, '2023-11-24', 0, 1); INSERT INTO `my_workday` VALUES (329, '2023-11-25', 3, 0); INSERT INTO `my_workday` VALUES (330, '2023-11-26', 3, 0); INSERT INTO `my_workday` VALUES (331, '2023-11-27', 0, 1); INSERT INTO `my_workday` VALUES (332, '2023-11-28', 0, 1); INSERT INTO `my_workday` VALUES (333, '2023-11-29', 0, 1); INSERT INTO `my_workday` VALUES (334, '2023-11-30', 0, 1); INSERT INTO `my_workday` VALUES (335, '2023-12-01', 0, 1); INSERT INTO `my_workday` VALUES (336, '2023-12-02', 3, 0); INSERT INTO `my_workday` VALUES (337, '2023-12-03', 3, 0); INSERT INTO `my_workday` VALUES (338, '2023-12-04', 0, 1); INSERT INTO `my_workday` VALUES (339, '2023-12-05', 0, 1); INSERT INTO `my_workday` VALUES (340, '2023-12-06', 0, 1); INSERT INTO `my_workday` VALUES (341, '2023-12-07', 0, 1); INSERT INTO `my_workday` VALUES (342, '2023-12-08', 0, 1); INSERT INTO `my_workday` VALUES (343, '2023-12-09', 3, 0); INSERT INTO `my_workday` VALUES (344, '2023-12-10', 3, 0); INSERT INTO `my_workday` VALUES (345, '2023-12-11', 0, 1); INSERT INTO `my_workday` VALUES (346, '2023-12-12', 0, 1); INSERT INTO `my_workday` VALUES (347, '2023-12-13', 0, 1); INSERT INTO `my_workday` VALUES (348, '2023-12-14', 0, 1); INSERT INTO `my_workday` VALUES (349, '2023-12-15', 0, 1); INSERT INTO `my_workday` VALUES (350, '2023-12-16', 3, 0); INSERT INTO `my_workday` VALUES (351, '2023-12-17', 3, 0); INSERT INTO `my_workday` VALUES (352, '2023-12-18', 0, 1); INSERT INTO `my_workday` VALUES (353, '2023-12-19', 0, 1); INSERT INTO `my_workday` VALUES (354, '2023-12-20', 0, 1); INSERT INTO `my_workday` VALUES (355, '2023-12-21', 0, 1); INSERT INTO `my_workday` VALUES (356, '2023-12-22', 0, 1); INSERT INTO `my_workday` VALUES (357, '2023-12-23', 3, 0); INSERT INTO `my_workday` VALUES (358, '2023-12-24', 3, 0); INSERT INTO `my_workday` VALUES (359, '2023-12-25', 0, 1); INSERT INTO `my_workday` VALUES (360, '2023-12-26', 0, 1); INSERT INTO `my_workday` VALUES (361, '2023-12-27', 0, 1); INSERT INTO `my_workday` VALUES (362, '2023-12-28', 0, 1); INSERT INTO `my_workday` VALUES (363, '2023-12-29', 0, 1); INSERT INTO `my_workday` VALUES (364, '2023-12-30', 3, 0); INSERT INTO `my_workday` VALUES (365, '2023-12-31', 3, 0);SET FOREIGN_KEY_CHECKS = 1;

總結(jié)

以上是生活随笔為你收集整理的生成和获取法定节假日的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。

法定节假日

上一篇：在打破传统保险业的“玻璃屋顶” 之前，A
下一篇： DT时代即将到来