ROUND(
((
SELECT
ROUND(
IFNULL(
SUM(
(
CASE
WHEN fop.production_shift = 3 AND fop.class = fwp.shift_schedule_1 THEN IFNULL(fwp.zero, 0)
WHEN fop.production_shift = 1 AND fop.class = fwp.shift_schedule_2 THEN IFNULL(fwp.day, 0)
WHEN fop.production_shift = 2 AND fop.class = fwp.shift_schedule_3 THEN IFNULL(fwp.middle, 0)
ELSE 0
END
)
*
CASE
WHEN fop.production_shift = 1 THEN
IFNULL( (SELECT pzxsz+0 FROM ldcp_scgl_xtwh_xtpz WHERE pzxbm = 'yljclbbkhlxs' AND is_deleted = 0 LIMIT 1), 1 )
WHEN fop.production_shift IN (2, 3) THEN
IFNULL( (SELECT pzxsz+0 FROM ldcp_scgl_xtwh_xtpz WHERE pzxbm = 'yljclzbybkhlxs' AND is_deleted = 0 LIMIT 1), 1.2 )
ELSE 1
END
),
0
),
2
)
FROM filtering_operation_record fop
LEFT JOIN filtering_workshop_production fwp
ON fop.date = fwp.date
AND fwp.is_deleted = 0
-- 匹配压滤效率表的 日期+班别
WHERE fop.date = tbl.date
AND fop.class = tbl.class
AND fop.is_deleted = 0
)
/
(
SELECT
ROUND(IFNULL(
SUM(
IFNULL(fop.filter_1,0) +
IFNULL(fop.filter_2,0) +
IFNULL(fop.filter_3,0) +
IFNULL(fop.filter_4,0) +
IFNULL(fop.filter_5,0) +
IFNULL(fop.filter_6,0) +
IFNULL(fop.filter_7,0)
)/8,0
),2)
FROM filtering_operation_record fop
-- 匹配当前效率表：同日期、同班别
WHERE fop.date = tbl.date
AND fop.class = tbl.class
AND fop.is_deleted = 0
)
)
,2)
不是显示token过期吗？
觉得是sql的问题，可以在打印台把sql拿出来到客户端调试看看