package com.ltkj.hosp.mapper;
|
|
import java.util.List;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.hosp.domain.TjOrderRemark;
|
import com.ltkj.hosp.vodomain.CsProVo;
|
import org.apache.ibatis.annotations.*;
|
|
/**
|
* 医生备注Mapper接口
|
*
|
* @author 赵佳豪
|
* @date 2022-12-02
|
*/
|
@Mapper
|
public interface TjOrderRemarkMapper extends BaseMapper<TjOrderRemark> {
|
|
|
@Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type IN(0,3) AND deleted='0'")
|
List<TjOrderRemark> getTjOrderRemarkListByYjNum(String tjNumber);
|
|
@Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND deleted='0'")
|
List<TjOrderRemark> getTjOrderRemarkListByTjNum(String tjNumber);
|
|
@Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND pro_id=#{proParentId} AND deleted='0'")
|
TjOrderRemark getTjOrderRemarkByTjNumAndProParentId(@Param("tjNumber") String tjNumber,@Param("proParentId") String proParentId);
|
|
@Select("SELECT COUNT(*) a FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type IN (0,3) AND deleted=0")
|
int getTjYqOrderRemarkByTjNum(String tjNumber);
|
|
@Delete("DELETE FROM tj_order_remark WHERE tj_number=#{tjNumber}")
|
void deletedOrderRemarkByTjNum(String tjNumber);
|
|
// @Select({"<script>", "select", "*", "from tj_order_remark", "where type =#{type} AND pro_id in", "<foreach collection='ksproList' item='id' open='(' separator=',' close=')'>",
|
// "#{id}",
|
// "</foreach>","ORDER BY tj_number",
|
// "</script>" })
|
// List<TjOrderRemark> getTjOrderRemarkListByksproList(@Param("ksproList")List<Long> ksproList,@Param("type")Integer type);
|
//
|
// @Select({"<script>", "select", "*", "from tj_order_remark", "where type in(0,3) AND pro_id in", "<foreach collection='ksproList' item='id' open='(' separator=',' close=')'>",
|
// "#{id}",
|
// "</foreach>","ORDER BY tj_number",
|
// "</script>" })
|
// List<TjOrderRemark> getTjOrderRemarkListByksproLists(@Param("ksproList")List<Long> ksproList);
|
|
@Select("SELECT GROUP_CONCAT(pro_id ORDER BY pro_id) AS names FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type=3 AND deleted='0' ")
|
String getTjOrderRemarkProIdList(String tjNumber);
|
|
|
|
@Insert("INSERT INTO tj_order_remark(\n" +
|
"pro_id,\n" +
|
"dept_id,\n" +
|
"create_time,\n" +
|
"create_by,\n" +
|
"create_id,\n" +
|
"tj_number,\n" +
|
"update_by,\n" +
|
"update_time,\n" +
|
"update_id\n" +
|
")\n" +
|
"\n" +
|
"SELECT b.pro_id,b.dept_id,SYSDATE(),#{userName},#{userId},#{tjNumber},#{userName},SYSDATE(),#{userId} FROM tj_order_detail a " +
|
"LEFT JOIN tj_project b ON a.pro_id=b.pro_id WHERE a.order_id=#{orderId} AND\n" +
|
"b.pro_parent_id=0")
|
boolean saveTjOrderRemarkByOrderId(@Param("tjNumber")String tjNumber,@Param("userName") String userName,@Param("userId") String userId,@Param("orderId")String orderId);
|
|
|
@Select("SELECT * FROM tj_order_remark a LEFT JOIN tj_project b ON a.pro_id=b.pro_id WHERE a.tj_number=#{tjNumber}" +
|
" AND a.type =1 AND a.deleted=0 AND b.need_report='Y' AND b.deleted=0 and a.dept_id in (269,270,253,254,255,257,251,271) ")//and a.dept_id in (269,270,253,254,255,257)
|
List<TjOrderRemark> getRemarkListByTjNumAndType(String tjNumber);
|
|
|
@Select("SELECT a.pro_id FROM tj_order_remark a WHERE a.deleted=0 AND a.tj_number=#{tjNumber} AND a.type !=2;")
|
List<Long> getTjProIdsByTjNum(String tjNumber);
|
|
|
@Select("SELECT b.pro_id FROM tj_package_project a " +
|
"LEFT JOIN tj_order_remark b ON a.pro_id=b.pro_id " +
|
"WHERE b.type !=2 AND b.pro_id = a.pro_id AND a.pac_id=#{pacId} AND b.tj_number=#{tjNumber}")
|
List<Long> getTjProIdsByTjNumAndPacIc(@Param("tjNumber") String tjNumber,@Param("pacId") String pacId);
|
|
|
@Select("SELECT b.pro_id FROM tj_package_project a " +
|
"LEFT JOIN tj_order_remark b ON a.pro_id=b.pro_id " +
|
"WHERE b.type !=2 AND b.pro_id != a.pro_id AND a.pac_id=#{pacId} AND b.tj_number=#{tjNumber}")
|
List<Long> getTjProIdsByTjNumAndPacIc1(@Param("tjNumber") String tjNumber,@Param("pacId") String pacId);
|
|
|
@Select("SELECT\n" +
|
"\tdep.dept_name,\n" +
|
"\tpro.pro_name,\n" +
|
"\tre.type,\n" +
|
"\tus.nick_name doctor_name,\n" +
|
"\tus.nick_name bcdoctor_name,\n" +
|
"\t'统收' sffs,\n" +
|
"\t'已收费' is_pay,\n" +
|
"\tre.create_time qdcreate_time,\n" +
|
"\tre.update_time bcupdate_time,\n" +
|
"\tre.update_time zhupdate_time \n" +
|
"FROM\n" +
|
"\ttj_order_remark re\n" +
|
"\tLEFT JOIN sys_dept dep ON re.dept_id = dep.dept_id\n" +
|
"\tLEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" +
|
"\tLEFT JOIN sys_user us ON us.user_id = re.doctor_name \n" +
|
"WHERE\n" +
|
"\tre.type != 2 \n" +//and pro.need_report='Y'
|
"\tAND re.tj_number =#{tjNumber}")
|
List<CsProVo> cSWebGetProByTjNumAndOrderId(String tjNumber);
|
|
|
@Select("call pro_lis_sqdbgd(0,#{tjnumber,mode=IN})")
|
// @Select("select * from test_remark")
|
List<TjOrderRemark> addHuaYanTable(@Param("tjnumber") String tjnumber);
|
|
|
@Update("UPDATE tj_order_remark a SET a.type=2 WHERE a.tj_number=#{tjnumber} AND a.pro_id=#{proId}")
|
void updateTjOrderRemark(@Param("tjnumber")String tjnumber,@Param("proId")String proId);
|
}
|
