package com.ltkj.hosp.mapper;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
import java.util.Map;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.hosp.domain.TjGroupingPro;
|
import com.ltkj.hosp.vodomain.AddNewReservationConfirm;
|
import org.apache.ibatis.annotations.*;
|
|
/**
|
* 体检项目分组Mapper接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-08-07
|
*/
|
@Mapper
|
public interface TjGroupingProMapper extends BaseMapper<TjGroupingPro> {
|
/**
|
* 查询体检项目分组
|
*
|
* @param id 体检项目分组主键
|
* @return 体检项目分组
|
*/
|
public TjGroupingPro selectTjGroupingProById(String id);
|
|
/**
|
* 查询体检项目分组列表
|
*
|
* @param tjGroupingPro 体检项目分组
|
* @return 体检项目分组集合
|
*/
|
public List<TjGroupingPro> selectTjGroupingProList(TjGroupingPro tjGroupingPro);
|
|
/**
|
* 新增体检项目分组
|
*
|
* @param tjGroupingPro 体检项目分组
|
* @return 结果
|
*/
|
public int insertTjGroupingPro(TjGroupingPro tjGroupingPro);
|
|
/**
|
* 修改体检项目分组
|
*
|
* @param tjGroupingPro 体检项目分组
|
* @return 结果
|
*/
|
public int updateTjGroupingPro(TjGroupingPro tjGroupingPro);
|
|
/**
|
* 删除体检项目分组
|
*
|
* @param id 体检项目分组主键
|
* @return 结果
|
*/
|
public int deleteTjGroupingProById(String id);
|
|
/**
|
* 批量删除体检项目分组
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjGroupingProByIds(String[] ids);
|
|
@Select("SELECT\n" +
|
"\ta.grouping_id,\n" +
|
"\ta.pro_id,\n" +
|
"\ta.pro_name,\n" +
|
"\tb.pro_id pid,\n" +
|
"\tb.pro_name pnam,\n" +
|
"\tb.pro_price, a.limits \n" +
|
"FROM\n" +
|
"\ttj_grouping_pro a\n" +
|
"\tLEFT JOIN tj_project b ON a.pro_id = b.pro_parent_id \n" +
|
"WHERE\n" +
|
"\ta.deleted = 0 \n" +
|
"\tAND a.grouping_id = #{groupingId} ")
|
List<AddNewReservationConfirm> getAddNewReservationConfirm(String groupingId);
|
|
|
@Delete("DELETE FROM tj_grouping_pro WHERE grouping_id =#{groupingId}")
|
void deletedTjGroupingProByGroupingId(String groupingId);
|
|
|
@Update(" update tj_grouping_pro " +
|
" SET " +
|
" limits=#{limits}," +
|
" ys_price=pro_price*(#{limits}/10)" +
|
" where grouping_id=#{groupId} ")
|
boolean updateGroupProLimitsByGroupId(@Param("groupId") String groupId,@Param("limits") String limits);
|
//
|
// @Insert("")
|
// boolean saveTjOrderDetailsByGroupId(@Param("groupingId") String groupingId,@Param("userName") String userName,@Param("userId") String userId,@Param("orderId")String orderId);
|
|
@Select("SELECT aa.parent_pro_id xmid,(g.ys_price-aa.ys)cj FROM tj_grouping_pro g JOIN (\n" +
|
"\n" +
|
"SELECT a.parent_pro_id,SUM(a.now_price)ys FROM tb_transition a WHERE a.cus_id=#{cusIdCard} AND pac_id=#{groupingId} AND ISNULL(a.tj_num) GROUP BY a.parent_pro_id)aa\n" +
|
"ON\n" +
|
"trim(g.pro_id)=trim(aa.parent_pro_id ) where g.grouping_id=#{groupingId} AND (g.ys_price-aa.ys)>0")
|
List<Map<String,Object>> huoquxiangmuchajia(@Param("groupingId") String groupingId, @Param("cusIdCard") String cusIdCard);
|
|
}
|
