zjh20250103

zjh

2025-01-03 303a933ae58e2057f34693d5813e4128550d1081

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjXdPictureMapper.java

@@ -3,7 +3,10 @@
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;

@@ -63,4 +66,25 @@
     * @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);
}