package jnpf.limsMapper;
|
|
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
import jnpf.base.mapper.SuperMapper;
|
import jnpf.limsEntity.LimsJianyanXiangEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Result;
|
import org.apache.ibatis.annotations.Results;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.Date;
|
import java.util.List;
|
|
@Mapper
|
public interface LimsJianyanXiangMapper extends SuperMapper<LimsJianyanXiangEntity> {
|
|
@InterceptorIgnore(others = "Ilg@true")
|
@Select({
|
"<script>",
|
"SELECT f_id AS id, f_foreign_id AS foreignId, f_tenant_id AS tenantId,",
|
"qingyandan_id AS qingyandanId, laiyuan_renwu_id AS laiyuanRenwuId,",
|
"renwu_jianyan_xiang_kuaizhao_id AS renwuJianyanXiangKuaizhaoId,",
|
"biz_type AS bizType, jianyan_liushuihao AS jianyanLiushuihao,",
|
"chanpin_id AS chanpinId, chanpin_bianma AS chanpinBianma,",
|
"chanpin_mingcheng AS chanpinMingcheng, pihao, guige,",
|
"jianyan_xiangmu_bianma AS jianyanXiangmuBianma,",
|
"jianyan_xiangmu_mingcheng AS jianyanXiangmuMingcheng,",
|
"fenxi_leixing AS fenxiLeixing, shifou_waijian AS shifouWaijian,",
|
"shifou_chuju_baogao AS shifouChujuBaogao, waijian_danwei AS waijianDanwei,",
|
"waijian_lururen AS waijianLururen, biaozhun_guiding AS biaozhunGuiding,",
|
"biaozhun_shangxian AS biaozhunShangxian, biaozhun_xiaxian AS biaozhunXiaxian,",
|
"shuju_leixing AS shujuLeixing, jiancha_banzu AS jianchaBanzu,",
|
"jiancha_ren AS jianchaRen, wancheng_riqi AS wanchengRiqi,",
|
"remind_flags AS remindFlags, jianyan_zhuangtai AS jianyanZhuangtai,",
|
"renwu_fenpeiren AS renwuFenpeiren, renwu_fenpei_shijian AS renwuFenpeiShijian,",
|
"jianyan_jieguo AS jianyanJieguo, jianyan_jielun AS jianyanJielun,",
|
"biz_files AS bizFiles, jieguo_luru_riqi AS jieguoLuruRiqi,",
|
"renwu_tuihuiren AS renwuTuihuiren, tuihui_yuanyin AS tuihuiYuanyin,",
|
"renwu_shenheren AS renwuShenheren, fenjian_zhuangtai AS fenjianZhuangtai,",
|
"fenjian_liang AS fenjianLiang, fenjian_danwei AS fenjianDanwei,",
|
"fenjian_fenzhuang_rongqi AS fenjianFenzhuangRongqi,",
|
"fenjian_baocun_tiaojian AS fenjianBaocunTiaojian, fenjian_huanjing AS fenjianHuanjing,",
|
"fenjian_ren AS fenjianRen, fenjian_riqi AS fenjianRiqi,",
|
"yichang_diaocha_leixing AS yichangDiaochaLeixing,",
|
"shifou_zuhe_fenjian AS shifouZuheFenjian, zuhe_id AS zuheId,",
|
"zuhe_fenjian_liang AS zuheFenjianLiang, zuhe_fenjian_danwei AS zuheFenjianDanwei,",
|
"f_delete_mark AS deleteMark, f_delete_time AS deleteTime,",
|
"f_delete_user_id AS deleteUserId, renwu_shenheren_shijian AS renwuShenherenShijian,",
|
"hetonghao, beizhu",
|
"FROM lims_jianyan_xiang",
|
"WHERE f_tenant_id = #{tenantId}",
|
"AND (f_delete_mark IS NULL OR f_delete_mark = 0)",
|
"AND f_id IN",
|
"<foreach collection='ids' item='id' open='(' separator=',' close=')'>",
|
"#{id}",
|
"</foreach>",
|
"</script>"
|
})
|
List<LimsJianyanXiangEntity> selectLiveTasks(
|
@Param("tenantId") String tenantId, @Param("ids") List<String> ids);
|
|
@InterceptorIgnore(others = "Ilg@true")
|
@Update({
|
"<script>",
|
"UPDATE lims_jianyan_xiang",
|
"SET jianyan_jieguo = #{result},",
|
"jianyan_jielun = #{conclusion},",
|
"biz_files = #{files},",
|
"jieguo_luru_riqi = #{recordedAt},",
|
"jianyan_zhuangtai = 'pending_audit',",
|
"yichang_diaocha_leixing = #{investigationType}",
|
"WHERE f_id = #{id}",
|
"AND f_tenant_id = #{tenantId}",
|
"AND jianyan_zhuangtai IN ('pending_test','cancelled','audit_rejected')",
|
"<choose>",
|
"<when test='external'>AND waijian_lururen = #{userId}</when>",
|
"<otherwise>AND jiancha_ren = #{userId}</otherwise>",
|
"</choose>",
|
"AND (f_delete_mark IS NULL OR f_delete_mark = 0)",
|
"</script>"
|
})
|
int submitResult(@Param("tenantId") String tenantId,
|
@Param("id") String id,
|
@Param("userId") String userId,
|
@Param("external") boolean external,
|
@Param("result") String result,
|
@Param("conclusion") String conclusion,
|
@Param("files") String files,
|
@Param("recordedAt") Date recordedAt,
|
@Param("investigationType") String investigationType);
|
|
@InterceptorIgnore(others = "Ilg@true")
|
@Update({
|
"UPDATE lims_jianyan_xiang",
|
"SET renwu_shenheren = #{auditorId},",
|
"jianyan_zhuangtai = 'audited',",
|
"renwu_shenheren_shijian = #{reviewedAt}",
|
"WHERE f_id = #{id}",
|
"AND f_tenant_id = #{tenantId}",
|
"AND jianyan_zhuangtai = 'pending_audit'",
|
"AND (f_delete_mark IS NULL OR f_delete_mark = 0)"
|
})
|
int markAudited(@Param("tenantId") String tenantId,
|
@Param("id") String id,
|
@Param("auditorId") String auditorId,
|
@Param("reviewedAt") Date reviewedAt);
|
|
@InterceptorIgnore(others = "Ilg@true")
|
@Update({
|
"UPDATE lims_jianyan_xiang",
|
"SET renwu_tuihuiren = #{auditorId},",
|
"tuihui_yuanyin = #{note},",
|
"jianyan_zhuangtai = 'audit_rejected'",
|
"WHERE f_id = #{id}",
|
"AND f_tenant_id = #{tenantId}",
|
"AND jianyan_zhuangtai = 'pending_audit'",
|
"AND (f_delete_mark IS NULL OR f_delete_mark = 0)"
|
})
|
int markAuditRejected(@Param("tenantId") String tenantId,
|
@Param("id") String id,
|
@Param("note") String note,
|
@Param("auditorId") String auditorId);
|
|
@InterceptorIgnore(others = "Ilg@true")
|
@Select({
|
"<script>",
|
"SELECT task.f_id, task.f_foreign_id, task.f_tenant_id, task.qingyandan_id AS qingyandanId, task.jianyan_zhuangtai,",
|
"task.shifou_waijian, task.waijian_lururen, task.jiancha_ren, task.biaozhun_guiding,",
|
"task.chanpin_mingcheng, task.pihao, task.guige, task.f_delete_mark,",
|
"task.jianyan_xiangmu_bianma, task.jianyan_xiangmu_mingcheng,",
|
"project.test_definition_id AS testDefinitionId,",
|
"project.match_count AS testDefinitionMatchCount,",
|
"qingyandan.shengchan_riqi AS shengchanRiqi,",
|
"qingyandan.jianyan_leixing AS jianyanLeixing,",
|
"quality_standard.gongyang_danwei AS qualityStandardSource",
|
"FROM lims_jianyan_xiang task",
|
"LEFT JOIN lims_qingyandan qingyandan ON qingyandan.f_id = task.qingyandan_id",
|
"AND qingyandan.f_tenant_id = task.f_tenant_id",
|
"AND (qingyandan.f_delete_mark IS NULL OR qingyandan.f_delete_mark = 0)",
|
"LEFT JOIN zhiliang_biaozhun_guanli_zixiang quality_standard_item",
|
"ON quality_standard_item.f_id = task.f_foreign_id",
|
"AND quality_standard_item.f_tenant_id = task.f_tenant_id",
|
"AND (quality_standard_item.f_delete_mark IS NULL OR quality_standard_item.f_delete_mark = 0)",
|
"LEFT JOIN zhiliang_biaozhun_guanli quality_standard",
|
"ON quality_standard.f_id = quality_standard_item.f_foreign_id",
|
"AND quality_standard.f_tenant_id = task.f_tenant_id",
|
"AND (quality_standard.f_delete_mark IS NULL OR quality_standard.f_delete_mark = 0)",
|
"LEFT JOIN (",
|
"SELECT f_tenant_id, bianma, MIN(f_id) AS test_definition_id, COUNT(*) AS match_count",
|
"FROM jianyan_xiangmu_guanli",
|
"GROUP BY f_tenant_id, bianma",
|
") project ON project.f_tenant_id = task.f_tenant_id",
|
"AND project.bianma = task.jianyan_xiangmu_bianma",
|
"WHERE task.f_tenant_id = #{tenantId}",
|
"AND (task.f_delete_mark IS NULL OR task.f_delete_mark = 0)",
|
"AND task.f_id IN",
|
"<foreach collection='ids' item='id' open='(' separator=',' close=')'>",
|
"#{id}",
|
"</foreach>",
|
"</script>"
|
})
|
@Results({
|
@Result(column = "f_id", property = "id", id = true),
|
@Result(column = "f_foreign_id", property = "foreignId"),
|
@Result(column = "f_tenant_id", property = "tenantId"),
|
@Result(column = "qingyandanId", property = "qingyandanId"),
|
@Result(column = "jianyan_zhuangtai", property = "jianyanZhuangtai"),
|
@Result(column = "shifou_waijian", property = "shifouWaijian"),
|
@Result(column = "waijian_lururen", property = "waijianLururen"),
|
@Result(column = "jiancha_ren", property = "jianchaRen"),
|
@Result(column = "biaozhun_guiding", property = "biaozhunGuiding"),
|
@Result(column = "chanpin_mingcheng", property = "chanpinMingcheng"),
|
@Result(column = "pihao", property = "pihao"),
|
@Result(column = "guige", property = "guige"),
|
@Result(column = "shengchanRiqi", property = "shengchanRiqi"),
|
@Result(column = "jianyanLeixing", property = "jianyanLeixing"),
|
@Result(column = "qualityStandardSource", property = "qualityStandardSource"),
|
@Result(column = "testDefinitionId", property = "testDefinitionId"),
|
@Result(column = "testDefinitionMatchCount", property = "testDefinitionMatchCount"),
|
@Result(column = "jianyan_xiangmu_bianma", property = "jianyanXiangmuBianma"),
|
@Result(column = "jianyan_xiangmu_mingcheng", property = "jianyanXiangmuMingcheng"),
|
@Result(column = "f_delete_mark", property = "deleteMark")
|
})
|
List<LimsJianyanXiangEntity> selectSnapshotTasks(
|
@Param("tenantId") String tenantId, @Param("ids") List<String> ids);
|
}
|
