package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.core.domain.BaseEntity;
import com.ltkj.hosp.domain.TjXdPicture;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * 体检心电图管理Mapper接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-04-11
 */
@Mapper
public interface TjXdPictureMapper extends BaseMapper<TjXdPicture> {
    /**
     * 查询体检心电图管理
     *
     * @param id 体检心电图管理主键
     * @return 体检心电图管理
     */
    public TjXdPicture selectTjXdPictureById(String id);

    /**
     * 查询体检心电图管理列表
     *
     * @param tjXdPicture 体检心电图管理
     * @return 体检心电图管理集合
     */
    public List<TjXdPicture> selectTjXdPictureList(TjXdPicture tjXdPicture);

    /**
     * 新增体检心电图管理
     *
     * @param tjXdPicture 体检心电图管理
     * @return 结果
     */
    public int insertTjXdPicture(TjXdPicture tjXdPicture);

    /**
     * 修改体检心电图管理
     *
     * @param tjXdPicture 体检心电图管理
     * @return 结果
     */
    public int updateTjXdPicture(TjXdPicture tjXdPicture);

    /**
     * 删除体检心电图管理
     *
     * @param id 体检心电图管理主键
     * @return 结果
     */
    public int deleteTjXdPictureById(String id);

    /**
     * 批量删除体检心电图管理
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjXdPictureByIds(String[] ids);

    @Select("SELECT\n" +
            "  b.tj_number tj_num,\n" +
            "  b.user_id cus_id,\n" +
            "  c.cus_name,\n" +
            "  a.pro_id ,\n" +
            "  d.pro_name,\n" +
            "  a.pro_result\n" +
            "FROM\n" +
            "  tj_order_detail a\n" +
            "  JOIN tj_order b ON b.order_id = a.order_id\n" +
            "  JOIN tj_customer c ON c.cus_id = b.user_id\n" +
            "  JOIN tj_project d ON d.pro_id = a.pro_id\n" +
            "  JOIN sys_dept e ON e.dept_id = d.dept_id \n" +
            "WHERE\n" +
            "  e.dept_id = '601' AND d.pro_parent_id !=0 AND b.tj_number=#{tjNum}")
    List<TjXdPicture> saveTjXdPicture(String tjNum);


    @Delete("delete from tj_xd_picture where tj_num= #{tjNum}")
    void deleteTjXdPictureBytjNum(String tjNum);
}