公司讓我做一個統計值班人員 根據當前天數統計之前的時間的值班次數的功能 返一個串列給前端 本以為應該不難
但看了資料庫表 sql不知道該如何實作了。。求大佬解答1下。。具體表我附圖如下
CREATE TABLE `gongshu_schedule` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fk_ai_id` int(11) DEFAULT NULL COMMENT '智能模板外鍵',
`boss_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '領導id',
`boss_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '領導名字',
`morn_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '白班人員id',
`morn_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '白班人員名字',
`even_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '夜班人員id',
`even_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '夜班人員名字',
`onduty_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '值班人員id',
`onduty_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '值班人員名字',
`driver_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '備勤司機id',
`driver_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '備勤司機名字',
`p_id` int(11) DEFAULT NULL COMMENT '更改id',
`duty_time` timestamp NULL DEFAULT NULL COMMENT '值班日期',
`state` tinyint(4) DEFAULT NULL COMMENT '狀態，0：啟用，1：禁用',
`is_delete` tinyint(4) DEFAULT NULL,
`create_time` timestamp NULL DEFAULT NULL,
`update_time` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `duty_time` (`duty_time`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='日程表';
資料我提供了部分
INSERT INTO `gongshu_schedule` VALUES (1, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-01 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (2, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-02 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (3, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-03 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (4, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-04 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (5, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-05 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (6, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-06 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (7, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-07 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (8, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-08 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (9, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-09 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (10, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-10 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (11, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-11 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (12, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-12 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (13, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-13 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (14, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-14 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (15, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-15 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (16, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-16 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (17, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-17 00:00:00', 0, 0, '2020-06-02 18:36:41', '2020-06-02 18:36:41');
INSERT INTO `gongshu_schedule` VALUES (18, 2, '1142132201843671', '曹杰', '0450451606856055', '李超', '0344452237833568', '陳棟躍', 'manager8843', '楊喜', '196412415421799906', '盧黎明', NULL, '2020-06-18 00:00:00', 0, 0, '2020-06-02 18:36:42', '2020-06-02 18:36:42');
INSERT INTO `gongshu_schedule` VALUES (19, 1, '196412415421799906', '盧黎明', '1142132201843671', '曹杰', '0106310349841958', '楊華', '0230223035315017', '謝文虎', '083223276624134528', '張天恩', NULL, '2020-06-19 00:00:00', 0, 0, '2020-06-02 18:36:42', '2020-06-02 18:36:42');
比如這張表出現9個人的名字，那就統計當前時間以往的9個人的值班次數 （領導、白晚班、值班、司機人員都算值班人員），時間欄位是duty_time
uj5u.com熱心網友回復：
頁面的效果想是這樣的
uj5u.com熱心網友回復：
頁面上的測驗單位可以先屏蔽 聯表取即可轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/16698.html
標籤：MySQL