Тоже нет статистики.
в qsystem.sql есть такое, как их выполнить по отдельности в
MySQL Workbench 6.3.8 CE (winx64)
CREATE TRIGGER insert_to_statistic
AFTER INSERT ON clients
FOR EACH ROW
BEGIN
SET @finish_start= TIMEDIFF(NEW.finish_time, NEW.start_time);
SET @start_starnd = TIMEDIFF(NEW.start_time, NEW.stand_time);
INSERT
INTO statistic(state_in, results_id, user_id, client_id, service_id, user_start_time, user_finish_time, client_stand_time, user_work_period, client_wait_period)
VALUES
(NEW.state_in, NEW.result_id, NEW.user_id, NEW.id, NEW.service_id, NEW.start_time, NEW.finish_time, NEW.stand_time,
round(
(HOUR(@finish_start) * 60 * 60 +
MINUTE(@finish_start) * 60 +
SECOND(@finish_start) + 59)/60),
round(
(HOUR(@start_starnd) * 60 * 60 +
MINUTE(@start_starnd) * 60 +
SECOND(@start_starnd) + 59)/60)
);
END;$$
USE `qsystem`$$
DROP TRIGGER IF EXISTS `qsystem`.`update_to_statistic` $$
USE `qsystem`$$
CREATE TRIGGER update_to_statistic
AFTER UPDATE ON clients
FOR EACH ROW
BEGIN
SET @finish_start= TIMEDIFF(NEW.finish_time, NEW.start_time);
SET @start_starnd = TIMEDIFF(NEW.start_time, NEW.stand_time);
INSERT
INTO statistic(state_in, results_id, user_id, client_id, service_id, user_start_time, user_finish_time, client_stand_time, user_work_period, client_wait_period)
VALUES
(NEW.state_in, NEW.result_id, NEW.user_id, NEW.id, NEW.service_id, NEW.start_time, NEW.finish_time, NEW.stand_time,
round(
(HOUR(@finish_start) * 60 * 60 +
MINUTE(@finish_start) * 60 +
SECOND(@finish_start) + 59)/60),
round(
(HOUR(@start_starnd) * 60 * 60 +
MINUTE(@start_starnd) * 60 +
SECOND(@start_starnd) + 59)/60)
);
END;$$
