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

package thyyxxk.webserver.dao.his.medicalinsurance;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import thyyxxk.webserver.entity.medicalinsurance.manage.InstSetlLdgChkBrf;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author: DingJie
 * @create: 2021/8/99:45
 */
@Mapper
public interface SiManageDao {

    @Update("<script>" +
            "update ${table} set uploaded_flag=#{flag} where code in " +
            "<foreach collection='codes' item='code' separator=',' open='(' close=')'>" +
            "#{code}</foreach>" +
            "</script>")
    void updateUploadedFlag(@Param("table") String table,
                            @Param("flag") int flag,
                            @Param("codes") List<String> codes);

    @Update("update ${table} set uploaded_flag=0 where code=#{code}")
    void updateUploadedFlag2(@Param("table") String table,
                             @Param("code") String codes);

    @Select("select name from t_region where code=#{code}")
    String selectRegion(@Param("code") String code);

    @Select("select pat_no,times,ledger_sn,medfee_sumamt,acct_pay,fund_pay_sumamt, " +
            "hospPay=(select sum(b.fund_payamt) from t_si_setldetail b where b.pat_no=a.pat_no " +
            "and b.times=a.times and b.ledger_sn=a.ledger_sn and (b.fund_pay_type='999996' or b.setl_proc_info='999996'))" +
            "from t_si_setlinfo a where insutype=#{insutype} and setl_type=#{setlType} and revoked=0 " +
            "and clr_optins=#{clrOptins} and setl_time>=#{start} and setl_time<=#{end} and fund_pay_sumamt!=0 " +
            "and (insuplc_admdvs='439900' or insuplc_admdvs like '4301%')")
    List<InstSetlLdgChkBrf> selectSetlChkBrfsWithInsutype(@Param("setlType") String setlType,
                                              @Param("insutype") String insutype,
                                              @Param("clrOptins") String clrOptins,
                                              @Param("start") String start,
                                              @Param("end") String end);

    @Select("select pat_no,times,ledger_sn,setl_id,mdtrt_id,psn_no,medfee_sumamt,acct_pay,fund_pay_sumamt,psn_cash_pay, " +
            "hospPay=(select sum(b.fund_payamt) from t_si_setldetail b where b.pat_no=a.pat_no and b.times=a.times " +
            "and b.ledger_sn=a.ledger_sn and (b.fund_pay_type='999996' or b.setl_proc_info='999996'))" +
            "from t_si_setlinfo a where setl_type=#{setlType} and revoked=0 and clr_optins=#{clrOptins} and fund_pay_sumamt!=0 " +
            "and setl_time>=#{start} and setl_time<=#{end} and (insuplc_admdvs='439900' or insuplc_admdvs like '4301%')")
    List<InstSetlLdgChkBrf> selectSetlChkBrfs(@Param("setlType") String setlType,
                                              @Param("clrOptins") String clrOptins,
                                              @Param("start") String start,
                                              @Param("end") String end);

    @Select("select count(1) from dj_user_role where user_code=#{code} and role_id=41")
    Integer recoveryTradePermission(@Param("code") String code);
}