From 2e9962fe2881c92a0953dff2ad475cb40365c10f Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期二, 17 十二月 2024 17:31:22 +0800
Subject: [PATCH] 统计工时调整
---
inspect-server/src/main/resources/mapper/InsOrderMapper.xml | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/inspect-server/src/main/resources/mapper/InsOrderMapper.xml b/inspect-server/src/main/resources/mapper/InsOrderMapper.xml
index 4b55e8b..633ef7e 100644
--- a/inspect-server/src/main/resources/mapper/InsOrderMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsOrderMapper.xml
@@ -192,6 +192,7 @@
A.model,
A.inspection_item,
A.company,
+ A.cost ,
A.`name`,
COUNT(1) num,
ROUND(SUM(A.price),2) price
@@ -201,7 +202,7 @@
isa.sample,
isa.model,
ins_sample_id,
- times cost,
+ times cost,
sum(c.price * times) price,
GROUP_CONCAT(distinct c.inspection_item SEPARATOR ',') inspection_item,
i.company,
--
Gitblit v1.9.3