web_server/src/main/java/thyyxxk/webserver/dao/his/medicalinsurance/AutoUploadBillDao.java

package thyyxxk.webserver.dao.his.medicalinsurance;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import thyyxxk.webserver.entity.querydata.AutoUploadBill;

import java.util.Date;
import java.util.List;

/**
 * @Description:上传日志
 * @Author:lihong
 * @Date: 2023/1/4
 */
@Mapper
public interface AutoUploadBillDao extends BaseMapper<AutoUploadBill> {
    @Insert("<script>" +
            " insert into t_auto_upload_bill (pat_no, times, ledger_sn, log_text, created_date, upload_date, type_flag, flag, setl_time,upload_code,upload_name)" +
            " values " +
            " <foreach collection='list' item='item'  separator=','>" +
            " (#{item.patNo},#{item.times},#{item.ledgerSn},#{item.logText},#{item.createdDate},#{item.uploadDate},#{item.typeFlag},#{item.flag},#{item.setlTime},#{item.uploadCode},#{item.uploadName}) "+
            " </foreach>" +
            " </script>")
    void batchSaveData(List<AutoUploadBill> list);

    @Delete("<script>" +
            " delete from t_auto_upload_bill where pat_no + cast(times as varchar) + cast(ledger_sn as varchar) " +
            " in (" +
            " <foreach collection='visitIds' item='item'  separator=','>" +
            " #{item}"+
            " </foreach>" +
            " )" +
            "</script>")
    void deleteVisitId(List<String> visitIds);
    @Select("select max(created_date) created_date from t_auto_upload_bill " +
            " where  pat_no =#{patNo} and times =#{times} and ledger_sn =#{ledgerSn}"
            )
    Date getLastUpdateTime(@Param("patNo") String patNo, @Param("times")Integer times, @Param("ledgerSn")Integer ledgerSn);
}