package com.ltkj.hosp.mapper;
|
|
import java.util.List;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.hosp.domain.TjDwGrouping;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* 体检单位分组Mapper接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-08-07
|
*/
|
@Mapper
|
public interface TjDwGroupingMapper extends BaseMapper<TjDwGrouping> {
|
/**
|
* 查询体检单位分组
|
*
|
* @param id 体检单位分组主键
|
* @return 体检单位分组
|
*/
|
public TjDwGrouping selectTjDwGroupingById(String id);
|
|
/**
|
* 查询体检单位分组列表
|
*
|
* @param tjDwGrouping 体检单位分组
|
* @return 体检单位分组集合
|
*/
|
public List<TjDwGrouping> selectTjDwGroupingList(TjDwGrouping tjDwGrouping);
|
|
/**
|
* 新增体检单位分组
|
*
|
* @param tjDwGrouping 体检单位分组
|
* @return 结果
|
*/
|
public int insertTjDwGrouping(TjDwGrouping tjDwGrouping);
|
|
/**
|
* 修改体检单位分组
|
*
|
* @param tjDwGrouping 体检单位分组
|
* @return 结果
|
*/
|
public int updateTjDwGrouping(TjDwGrouping tjDwGrouping);
|
|
/**
|
* 删除体检单位分组
|
*
|
* @param id 体检单位分组主键
|
* @return 结果
|
*/
|
public int deleteTjDwGroupingById(String id);
|
|
/**
|
* 批量删除体检单位分组
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjDwGroupingByIds(String[] ids);
|
|
|
@Select("SELECT COUNT(*) FROM tj_dw_grouping a WHERE a.dw_dept_id=#{dwDeptId} AND a.sex=#{sex} ")
|
public int selectTjDwGroupingBySex(@Param("dwDeptId")String dwDeptId,@Param("sex") String sex);
|
|
|
@Select("SELECT SUM(b.aa) cc FROM ( SELECT" +
|
"CASE WHEN ISNULL( b.sex )" +
|
"AND ISNULL( c.pro_name ) THEN 0" +
|
"WHEN ! ISNULL( b.sex )" +
|
"AND ISNULL( c.pro_name ) THEN 0 ELSE 1" +
|
"END" +
|
"aa" +
|
"FROM" +
|
"tj_dw_dept a" +
|
"LEFT JOIN tj_dw_grouping b ON a.id = b.dw_dept_id" +
|
"LEFT JOIN tj_grouping_pro c ON b.id = c.grouping_id " +
|
"WHERE" +
|
"a.id =#{dwDeptId}" +
|
"GROUP BY" +
|
"b.sex)b")
|
public int selectTjDwGroupingByDwDeptId(String dwDeptId);
|
}
|
