From 5325dfb2fda7bd21bcbcf3c8c10be1ac95793d86 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期一, 05 八月 2024 20:40:48 +0800 Subject: [PATCH] 检验下单的委托人如果制单人的委托单位与选择的委托单位不一致,则委托人必须要进行填写,如果一致那么委托人就默认是制单人+.检验设备第一次进来直接所有样品的这个项目全部使用该设备,第二次修改就只针对当前样品 --- framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java b/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java index c6db317..045f040 100644 --- a/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java +++ b/framework/src/main/java/com/yuanchu/mom/mapper/SystemLogMapper.java @@ -22,5 +22,14 @@ @Select("select coalesce(count(id), 0) from ${tableName} where create_time like concat('%', #{date}, '%')") int countRowsByNow(String tableName, String date); + + @Select("select coalesce(count(id), 0) from ${tableName} where examine_time like concat('%', #{date}, '%')") + int countRowsByNow2(String tableName, String date); + + @Select("select coalesce(count(id), 0) from ${tableName} where examine_time like concat('%', #{date}, '%') and laboratory=#{laboratory} and company_id=#{companyId}") + int countRowsByNow3(String tableName, Long companyId, String laboratory, String date); + + @Select("select coalesce(count(id), 0) from ${tableName} where create_time like concat('%', #{date}, '%') and laboratory=#{laboratory} and company_id=#{companyId}") + int countRowsByNow4(String tableName, Long companyId, String laboratory, String date); } -- Gitblit v1.9.3