生成和获取法定节假日

最新推荐文章于 2024-03-04 11:17:05 发布
最新推荐文章于 2024-03-04 11:17:05 发布
阅读量2k 收藏 4
点赞数 2
文章标签： 数据库 php 开发语言
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43988567/article/details/128387458
版权

1.获取官方节假日信息

在中国政府网获取信息：中国政府网_中央人民政府门户网站

 2.复制下面代码

以php为例

   /**
     * 生成工作日
     * @param array $holiday 法定节假日
     * @param array $exchange_day 调休日
     * @return array  $calendar
	 * 		day：日期 ，2023-01-01
	 * 		day_type：类型 ，0-工作日，1-法定节假日，2-周末加班调休，3-周末
	 * 		is_work_day：是否为工作日，1-是，0-否
     */
	public function makeWorkDay($holiday,$exchange_day) {
		$calendar = [];
		$year = 0;

		//法定节假日
		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));
			}
		}

		//调休日
		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.在第一步中获取的节假日和调休日信息传入改函数并调用即可获取

以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年节假日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法定节假日：1;\r\n周末加班调休：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 = '国家法定节假日表' 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;

零合一
关注
  • 2
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
VB6.0开发的 节日 日期查询程序.rar
07-10
VB6.0开发的 节日 日期查询程序，又名：节日一点通，程序编写组成员：杨洋 吴斌 王京龙 朱星。启动程序后，程序会显示“每日一帖”，数据存放在数据库中。这个程序主要是用来查询某个节日与日期的对应，便于使用者知道哪一天是什么节日。因此编程时，需要掌握一定的时间操作技巧，新手也可下载本源码，学习一些时间操作方面的VB知识。
php 获取全年节假日（二 ）
qq_21834227的博客
12-19 1863
<?php namespace Home\Controller; use Think\Controller; class JiejiariController extends Controller { public function index(){ $Jiejiari = file_get_contents("http://www.easybots....
php 获取一年中的节假日,PHP开发节假日时间表
weixin_34737066的博客
03-19 1376
无意中发现一个节假日的 API 接口：http://timor.tech/api/holiday/year这个接口实现起来其实很简单，而且一年只需要维护一次，想要自己实现这个接口可参考博主之前写的这篇文章PHP判断某个日期是否为工作日使用这个接口可以更简单快速的写一个 “节假日时间表”，例如博主写的代码：年节假日时间表foreach($lstHolidayas$key=>$row...
php获取农历日期节日
最新发布
wwj256的专栏
03-04 182
【代码】php获取农历日期节日。
节假日api接口之获取指定日期的节假日信息
热门推荐
xinit1的专栏
06-01 4万+
获取指定日期的节假日信息 1、接口地址：http://api.goseek.cn/Tools/holiday?date=数字日期 2、返回数据：正常工作日对应结果为 0, 法定节假日对应结果为 1, 节假日调休补班对应的结果为 2，休息日对应结果为 3  3、节假日数据说明：本接口包含2017年起的中国法定节假日数据，数据来源国务院发布的公告，每年更新1次，确保数据最新 4、示例：http://...
php实现爬虫抓取法定节假日放假和补班安排数据
sdxjwkq01的博客
10-31 1379
说到爬虫，大家首先想到的是python，其实什么语言都一样，无非是抓取网页数据，然后正则分析网页结构，把想要的信息取出来，更深层次的无非是递归爬取所有链接，数据库操作等，php做爬虫也不算稀奇，今天这个需求很简单，就是抓取一篇放假通知的文章，从里面整理出法定节假日期间哪几天放假，哪几天补班，整理成规则的数组或者json，主要用到curl和正则。string(12) "正常上班"string(12) "正常上班"string(12) "正常上班"string(12) "正常上班"
节假日判断函数
06-06
计算指定日期内哪些为工作日，节假日的函数
php获得当月的节假日函数（包含周末，年度节假日）
hanzhuhuaa的博客
09-05 178
根据下单日期，获得最早可预约时间（可预约时间可以根据需求调整）
获取今年的所有法定节假日
猪头泽兜兜的
07-11 1241
基于HuTool工具类时间工具类，获取今年的所有法定节假日。
php 公历阴历互相转换
weixin_34292402的博客
03-09 253
&lt;?php /** * Created by PhpStorm. * User: timeless * Date: 17-3-9 * Time: 上午9:32 */ class Lunar { var $MIN_YEAR = 1891; var $MAX_YEAR = 2100; var $lunarInfo = array( array...
基于PHP的节假日公告管理网页，含有数据库
06-06
（1）由于在模块中通过jQuery技术控制页面中公告信息的弹出，并因为jQuery属于第三方组件，在光盘中没有提供，所以需要读者自行下载jQuery的js组件文件，并且命名为jquery.js，将其存储于项目的js文件夹下。 （2）本模块应用MySQL数据库，其数据库文件存储于项目根目录的data文件夹下，在运行项目前需要完成数据库的附加操作，即将data文件夹下的db_jiari拷贝到您本机的MySQL的data文件夹下，同时切忌要去掉数据库文件db_jiari的只读属性，否则不能向数据库中添加数据。
php实现获取农历(阴历)、节日、节气的类与用法示例
10-18
主要介绍了php实现获取农历(阴历)、节日、节气的类与用法,结合实例形式分析了php日期工具类Lunar的具体定义与获取农历日期、节气等相关操作技巧,需要的朋友可以参考下
holiday:chinese holiday 获取中国法定节假日API 自动更新
05-18
获取法定节假日信息 使用说明 自动更新 保存到数据库中，减少对网络依赖 只有一个接口，调用简单 个人项目，不保证永久维护 开源免费 直接使用 接口地址 http://api.haoshenqi.top/holiday 参数 eg: ...
java自动生成节假日对照表
05-21
中国的节假日不是按照阳历就能够计算,在没有调接口的情况下,最好的办法就是在数据库里面维护相对应的对照表.这里就提供了一个工具类自动生成指定年份的节假日对照表
mysql2019年节假日数据信息表
12-21
msyql2019年节假日数据信息表和信息内容； 2019年msyql节假日数据信息包括：法定假日、周末和工作日； 资料为本人自己整理，无侵权纠纷。大家有需要拿去；
java计算整年工作日(包含特殊的工作日)排除法定节假日和周末能运行
01-17
java计算整年工作日(包含特殊的工作日)排除法定节假日和周末能运行
Java节假日算法(免费)
03-16
Java节假日算法(免费)
2021年所有日期数据(区分周末、节假日、工作日) mysql 语句
12-16
2021所有日期数据(区分周末、节假日、工作日) mysql 语句 insert 生成的节假日表 工作日:0 法定节假日:1 休息日加班:2 休息日:3 mysql2021日期数据全部.sql
calendar.js法定节假日日历
06-01
calendar.js是一个用于生成日历的JavaScript库，可以通过添加相关的数据源来实现法定节假日日历功能。 具体实现方法如下： 1. 首先需要准备一个包含法定节假日信息的JSON数据源，例如： ```javascript var holidays = { "2021-01-01": "元旦节", "2021-02-11": "春节", "2021-02-12": "春节", "2021-02-13": "春节", "2021-02-14": "情人节", "2021-04-04": "清明节", "2021-05-01": "劳动节", "2021-06-14": "端午节", "2021-09-21": "中秋节", "2021-10-01": "国庆节", "2021-10-02": "国庆节", "2021-10-03": "国庆节", "2021-10-04": "国庆节", "2021-10-05": "国庆节", "2021-10-06": "国庆节", "2021-10-07": "国庆节" }; ``` 2. 然后在使用calendar.js生成日历的时候，可以通过回调函数来判断某一天是否是法定节假日，例如： ```javascript var calendar = new Calendar({ holidays: holidays, isHoliday: function(date) { if (this.holidays[date]) { return true; } else { return false; } } }); ``` 这样就可以在生成的日历上标记出法定节假日了。 需要注意的是，由于每年的法定节假日日期都不同，因此需要针对不同的年份准备不同的JSON数据源。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值