距离时间

最新推荐文章于 2022-10-27 22:22:07 发布

yangzhao6628

最新推荐文章于 2022-10-27 22:22:07 发布

阅读量300

点赞数

本文链接：https://blog.csdn.net/yangzhao6628/article/details/50250853

版权

param_createTime VARCHAR(20),param_type VARCHAR(10),param_status VARCHAR(10)

BEGIN

DECLARE param_second BIGINT;
DECLARE param_minute BIGINT;
DECLARE param_hour BIGINT;
DECLARE param_day BIGINT;
DECLARE param_month BIGINT;
DECLARE param_year BIGINT;
DECLARE param_return VARCHAR(25) DEFAULT '订单已超时';
DECLARE param_distanceminute INT;

IF param_type='017001' THEN SET param_distanceminute=30;
ELSEIF param_type='017002' THEN SET param_distanceminute=4320;
ELSEIF param_type='016001' THEN SET param_distanceminute=30;
ELSEIF param_type='016003' THEN SET param_distanceminute=21600;
ELSEIF param_type='016007' AND param_status='020001' THEN SET param_distanceminute=4320;
ELSEIF param_type='016007' AND param_status='020006' THEN SET param_distanceminute=21600;
ELSEIF param_type='016007' AND param_status='020003' THEN SET param_distanceminute=21600;
END IF;

SET param_second = UNIX_TIMESTAMP(DATE_ADD(param_createTime,INTERVAL param_distanceminute minute))-UNIX_TIMESTAMP(NOW());
SET param_minute = floor(param_second/60);
SET param_hour = floor(param_minute/60);
SET param_day = floor(param_hour/24);
SET param_month = floor(param_day/30);

IF param_day>0 THEN RETURN CONCAT('还剩',param_day,'天',(param_hour-param_day*24),'小时',(param_minute-param_hour*60),'分钟');
ELSEIF param_hour>0 THEN RETURN CONCAT('还剩',param_hour,'小时',(param_minute-param_hour*60),'分钟');
ELSEIF param_minute>0 THEN RETURN CONCAT('还剩',param_minute,'分钟',(param_second-param_minute*60),'秒');
ELSE RETURN param_return;
END IF;

END