web_server/src/main/java/thyyxxk/webserver/dao/his/yibao/DismissDao.java

package thyyxxk.webserver.dao.his.yibao;

import org.apache.ibatis.annotations.*;
import thyyxxk.webserver.entity.yibao.dismiss.ActOrderDetail;
import thyyxxk.webserver.entity.yibao.dismiss.NegativeFee;
import thyyxxk.webserver.entity.yibao.dismiss.ReceiptFee;

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

@Mapper
public interface DismissDao {
    @Select("select top 1 ltrim(rtrim(name)) from a_employee_mi where code=#{code}")
    String getOperateName(@Param("code") String code);

    @Select("select isnull(max ( ledger_sn ), isnull(min ( ledger_sn ), 1)) from zy_ledger_file where " +
            "inpatient_no=#{patNo} and admiss_times=#{times}")
    Integer getLedgerSn(@Param("patNo") String patNo, @Param("times") Integer times);

    @Update("exec zy_receive_drug @in_no=#{patNo},@times=#{times},@v_no=#{patNo}, @is_infant=0")
    void acceptFeeStepOne(@Param("patNo") String patNo, @Param("times") Integer times);

    @Update("exec zy_receive_one @in_no=#{patNo},@times=#{times},@v_no=#{patNo}, @is_infant=0")
    int acceptFeeStepTwo(@Param("patNo") String patNo, @Param("times") Integer times);

    @Update("exec dbo.zy_cngl_fyjs_list_yz_1 @in_no=#{patNo}, @in_times=#{times}")
    int getOrderList(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("select ltrim(rtrim(str(act_order_no))) as actOrderNo,rtrim(order_name) as orderName," +
            "charge_date as chargeDate, rtrim(charge_code) as chargeCode,charge_fee=rtrim(charge_fee), " +
            "chargeName=rtrim(charge_name), frequCode=rtrim(frequ_code)," +
            "cxFlag=cx_flag,drugSpecification=rtrim(drug_specification)," +
            "start_time,end_time,chargeAmount=charge_amount,page_no,charge_status," +
            "supplyCode=(select rtrim(name) from view_zd_supply_type where code=supply_code)," +
            "physician=(select rtrim(name) from a_employee_mi where code=physician)," +
            "enterOper=(select rtrim(name) from a_employee_mi where code=enter_oper)," +
            "execUnit=(select rtrim(name) from zd_unit_code where code=exec_unit)," +
            "wardName=(select rtrim(name) from zd_unit_code where code=ward_code)," +
            "order_code, group_no from zy_list where charge_status in ('5','6','8')")
    List<ActOrderDetail> getActOrderDetail();

    @Update("exec zy_calc_detail_again_new @in_no=#{patNo}," +
            "@times=#{times},@sn=#{ledgerSn},@orig_type='1',@new_type='1'")
    int hasUnsettledStepOne(@Param("patNo") String patNo,
                            @Param("times") Integer times,
                            @Param("ledgerSn") int ledgerSn);

    @Select("select isnull(sum ( depo_amount ),0) from zy_deposit_file where depo_type='Y' " +
            "and inpatient_no=#{patNo} and admiss_times=#{times}")
    int hasUnsettledStepTwo(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("SELECT count(1) FROM zy_detail_charge WHERE inpatient_no=#{patNo} AND " +
            "admiss_times=#{times} and ledger_sn>=1 AND charge_fee <> 0 and charge_status ='1'")
    int hasNotAccounted(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("SELECT count(1) FROM yp_zy_patient WHERE inpatient_no=#{patNo} AND " +
            "admiss_times=#{times} AND amount <> 0 and acct_sign <> '2' ")
    int hasUnreceivedDrugList(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("SELECT count(1) FROM yz_zy_patient_fee WHERE inpatient_no=#{patNo} " +
            "AND admiss_times=#{times} and charge_date<=#{actOrderDisDate} AND charge_fee <> 0 " +
            "and charge_status <> '0' and charge_status <> '2' ")
    int hasUnreceivedFees(@Param("patNo") String patNo,
                          @Param("times") Integer times,
                          @Param("actOrderDisDate") Date actOrderDisDate);

    @Select("SELECT count(1) FROM yz_yp_zy_order ( nolock ) WHERE inpatient_no=#{patNo} " +
            "AND admiss_times=#{times} AND ( amount > 0 or ( amount < 0 and " +
            "drug_class <> 'd' ) ) and status_flag='1' and page_no=0")
    int hasUnSubmitDrugList(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("SELECT count(1) FROM yz_yp_zy_order ( nolock ) WHERE inpatient_no=#{patNo} " +
            "AND admiss_times=#{times} AND ( amount > 0 or ( amount < 0 and " +
            "drug_class <> 'd' ) ) and status_flag='1' and ( case when amount > 0 then " +
            "page_no else page_no_ty end > 0 ) ")
    int hasUntreatedDrugWithdrawalOrder(@Param("patNo") String patNo,
                                        @Param("times") Integer times);

    @Select("SELECT count(1) FROM yz_zy_patient_fee WHERE inpatient_no=#{patNo} " +
            "AND admiss_times=#{times} and charge_date<=#{actOrderDisDate} AND " +
            "charge_fee <> 0 and charge_status='3'")
    int hasUnconfirmedMedicalTech(@Param("patNo") String patNo,
                                  @Param("times") Integer times,
                                  @Param("actOrderDisDate") Date actOrderDisDate);

    @Select("select * from (select sum(a.charge_fee) as code,a.charge_code_mx as chargeCode,b.name from zy_detail_charge a, " +
            "zd_charge_item b where a.inpatient_no=#{patNo} and a.admiss_times=#{times} and " +
            "a.charge_code_mx=b.code group by a.charge_code_mx,b.name union select " +
            "sum(a.charge_fee) as code,a.charge_code_mx as chargeCode,b.name from zy_detail_charge a,yp_zd_dict b " +
            "where a.inpatient_no=#{patNo} and a.admiss_times=#{times} and a.charge_code_mx=b.code " +
            "group by a.charge_code_mx,b.name ) as x where x.code<0")
    List<NegativeFee> feeOrderNegative(@Param("patNo") String patNo, @Param("times") Integer times);

    @Delete("delete zy_tmp_settle_select_detail where inpatient_no=#{patNo} and admiss_times=#{times}")
    void deleteTemporaryTable(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("select top 1 date_2 from zy_receipt where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn>0 order by ledger_sn desc")
    Date selectAccountDate(@Param("patNo") String patNo, @Param("times") int times);

    @Select("select admiss_date from ${table} where inpatient_no=#{patNo} and admiss_times=#{times}")
    Date selectAdmissDate(@Param("patNo") String patNo, @Param("times") Integer times, @Param("table") String table);

    @Select("SELECT settle_type FROM zy_ledger_file WHERE inpatient_no=#{patNo} " +
            "AND admiss_times=#{times} AND ledger_sn=#{ledgerSn}")
    int hasSettled(@Param("patNo") String patNo,
                   @Param("times") Integer times, @Param("ledgerSn") int ledgerSn);

    @Select("select count(1) from zy_tmp_settle_select_detail where inpatient_no=#{patNo} " +
            "and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    int hasUncheckedFee(@Param("patNo") String patNo,
                        @Param("times") Integer times, @Param("ledgerSn") int ledgerSn);

    @Select("select count(1) from yz_act_order where inpatient_no=#{patNo} and admiss_times=#{times} " +
            "and status_flag > '2' and isnull(group_no,'00' )='00' and order_code in ('06026','06053','05973')")
    Integer countDisActOrders(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("select count(1) from yz_inact_order where inpatient_no=#{patNo} and admiss_times=#{times} " +
            "and status_flag > '2' and isnull(group_no,'00' )='00' and order_code in ('06026','06053','05973')")
    Integer countDisActOrders2(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("select (select isnull(sum(charge_fee),0) from zy_detail_charge where inpatient_no=#{patNo} " +
            "AND admiss_times=#{times} AND ledger_sn=#{ledgerSn} and isnull(charge_status, '1') <> '1' " +
            "and charge_date>=#{begntime} and charge_date<=#{endtime})-(select isnull(total_charge,0) from zy_ledger_file " +
            "where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn})")
    int getFeeOffset(@Param("patNo") String patNo,
                     @Param("times") Integer times,
                     @Param("ledgerSn") int ledgerSn,
                     @Param("begntime") Date begntime,
                     @Param("endtime") Date endtime);

    @Update("update zy_ledger_file set deposit=(select sum(depo_amount) from zy_deposit_file f with(nolock) " +
            "where f.inpatient_no=#{zyh} and f.admiss_times=#{times} and f.ledger_sn=#{ledger} and f.status = '1') " +
            "where inpatient_no=#{zyh} and admiss_times=#{times} and ledger_sn=#{ledger}")
    void recountDeposit(@Param("zyh") String zyh,
                        @Param("times") int times,
                        @Param("ledger") int ledger);

    @Delete("delete zy_ledger_file_yb where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    void deleteZyLedgerFileYb(@Param("patNo") String patNo,
                              @Param("times") Integer times, @Param("ledgerSn") int ledgerSn);

    @Insert("insert into zy_ledger_file_yb (inpatient_no,admiss_times,ledger_sn,total_cost,tczf,grzhzf,dbzf,xjzf," +
            "full_self_pay,part_self_pay,hospital_pay) " +
            "values (#{patNo},#{times},#{ledgerSn},#{fee0},#{fee1},#{fee2},#{fee3},#{fee4}," +
            "#{fullSelfPay},#{partSelfPay},#{hospitalPay})")
    int writeYbSettleTable(@Param("patNo") String patNo,
                           @Param("times") Integer times, @Param("ledgerSn") int ledgerSn,
                           @Param("fee0") String fee0, @Param("fee1") String fee1, @Param("fee2") String fee2,
                           @Param("fee3") String fee3, @Param("fee4") String fee4,
                           @Param("fullSelfPay") String fullSelfPay, @Param("partSelfPay") String partSelfPay,
                           @Param("hospitalPay") String hospitalPay);

    @Update("update zy_ledger_file set charge_yb=1 where inpatient_no=#{patNo} and " +
            "admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    int beforeWriteReceiptTable(@Param("patNo") String patNo,
                                @Param("times") Integer times, @Param("ledgerSn") int ledgerSn);

    @Insert("insert into zy_receipt (inpatient_no,admiss_times,ledger_sn,receipt_sn,receipt_no," +
            "account_date,date_1,date_2,ward,dept,print_date,responce_unit,op_id_code,total_charge," +
            "charge1,charge2,charge3,charge4,charge5,charge6,charge7,charge8,charge9,charge10,charge11," +
            "charge12,charge13,charge14,charge15,charge16,charge17,charge18,charge19,charge20,charge21," +
            "charge22,charge23,charge24,charge25,charge26,charge27,charge28,charge29,charge30) " +
            "values (#{patNo},#{times},#{ledgerSn},#{receiptSn},'0000000',#{dismissDate}," +
            "#{admissDate},#{dismissDate},#{wardCode},#{deptCode},#{printDate},#{responceUnit},#{codeRs}," +
            "#{map.total},#{map.001},#{map.002},#{map.003},#{map.004},#{map.005},#{map.006},#{map.007},#{map.008},#{map.009},#{map.010}," +
            "#{map.011},#{map.012},#{map.013},#{map.014},#{map.015},#{map.016},#{map.017},#{map.018},#{map.019},#{map.020},#{map.021},#{map.022}," +
            "#{map.023},#{map.024},#{map.025},#{map.026},#{map.027},#{map.028},'0.00','0.00')")
    int writeReceiptTable(@Param("patNo") String patNo, @Param("times") Integer times,
                          @Param("ledgerSn") int ledgerSn, @Param("receiptSn") int receiptSn,
                          @Param("admissDate") Date admissDate, @Param("dismissDate") Date dismissDate,
                          @Param("wardCode") String wardCode, @Param("deptCode") String deptCode,
                          @Param("printDate") Date printDate, @Param("responceUnit") String responceUnit,
                          @Param("codeRs") String codeRs, @Param("map") Map<String, String> map);

    @Select("select max(infant_flag) FROM zy_detail_charge WHERE inpatient_no=#{patNo} and admiss_times=#{times}")
    int hasInfant(@Param("patNo") String patNo, @Param("times") Integer times);

    @Update("update zy_ledger_file set account_date=#{dismissDate},settle_type='1',balance=0," +
            "last_balance=total_charge,settle=deposit-total_charge,ward_code=#{wardCode}," +
            "dept_code=#{deptCode},op_id_code=#{codeRs},responce_type='01',charge_yb=0 from zy_ledger_file " +
            "where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    int updateZifeiCostStatus(@Param("patNo") String patNo, @Param("times") Integer times,
                              @Param("ledgerSn") int ledgerSn, @Param("wardCode") String wardCode,
                              @Param("deptCode") String deptCode, @Param("codeRs") String codeRs,
                              @Param("dismissDate") Date dismissDate);

    @Select("select case when isnull(xjzf,0)!=0 then xjzf else total_cost-tczf end from zy_ledger_file_yb " +
            "where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    String selectMedinsCashPay(@Param("patNo") String patNo,
                               @Param("times") Integer times,
                               @Param("ledgerSn") int ledgerSn);

    @Update("update zy_ledger_file set account_date=#{dismissDate},settle_type='1',balance=0,last_balance=#{cash}, " +
            "settle=(deposit-#{cash}),ward_code=#{wardCode},dept_code=#{deptCode},op_id_code=#{codeRs},charge_yb=0 " +
            "where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    int updateCostStatusWithoutInfant(@Param("patNo") String patNo, @Param("times") Integer times,
                                      @Param("ledgerSn") int ledgerSn, @Param("wardCode") String wardCode,
                                      @Param("deptCode") String deptCode, @Param("codeRs") String codeRs,
                                      @Param("dismissDate") Date dismissDate, @Param("cash") String cash);

    @Select("select tczf from zy_ledger_file_yb where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    String selectMedinsFundPay(@Param("patNo") String patNo,
                               @Param("times") Integer times,
                               @Param("ledgerSn") int ledgerSn);

    @Update("update zy_ledger_file set account_date=#{dismissDate},settle_type='1',balance=0, " +
            "last_balance=(total_charge-#{fund}),settle=(deposit-total_charge+#{fund}), " +
            "ward_code=#{wardCode},dept_code=#{deptCode},op_id_code=#{codeRs}, " +
            "charge_yb=0 where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    int updateCostStatusWithInfant(@Param("patNo") String patNo, @Param("times") Integer times,
                                   @Param("ledgerSn") int ledgerSn, @Param("wardCode") String wardCode,
                                   @Param("deptCode") String deptCode, @Param("codeRs") String codeRs,
                                   @Param("dismissDate") Date dismissDate, @Param("fund") String fund);

    @Update("update zy_detail_charge set charge_status=3 where charge_status=2 and " +
            "inpatient_no=#{patNo} AND admiss_times=#{times} AND ledger_sn=#{ledgerSn}")
    int updateZyDetailCharge(@Param("patNo") String patNo,
                             @Param("times") Integer times, @Param("ledgerSn") int ledgerSn);

    @Select("select start_time from yz_act_order where inpatient_no=#{patNo} and admiss_times=#{times} " +
            "and status_flag > '1' and isnull(group_no, '00')='00' and order_code in ('06026','06053','05973')")
    Date selectActOrderDisDate(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("select start_time from yz_inact_order where inpatient_no=#{patNo} and admiss_times=#{times} " +
            "and status_flag > '1' and isnull(group_no, '00')='00' and order_code in ('06026','06053','05973')")
    Date selectActOrderDisDate2(@Param("patNo") String patNo, @Param("times") Integer times);

    @Update("update ${table} SET dis_date=#{disDate},dis_ward=ward,dis_dept=dept,job_nurse=#{codeRs}," +
            "bed_status='5' WHERE inpatient_no=#{patNo} AND admiss_times=#{times}")
    int updateZyActpatient(@Param("patNo") String patNo, @Param("times") Integer times,
                           @Param("disDate") Date disDate, @Param("codeRs") String codeRs, @Param("table") String table);

    @Delete("DELETE FROM zy_inactpatient WHERE inpatient_no=#{patNo} AND admiss_times=#{times}")
    void deleteZyInactpatient(@Param("patNo") String patNo, @Param("times") Integer times);

    @Insert("INSERT INTO zy_inactpatient SELECT * FROM zy_actpatient WHERE inpatient_no=#{patNo} AND admiss_times=#{times}")
    int insertZyInactpatient(@Param("patNo") String patNo, @Param("times") Integer times);

    @Update("update ${table} SET dis_date=#{disDate},dis_ward=ward,dis_dept=dept WHERE inpatient_no >=#{patNo1} " +
            "and inpatient_no <= #{patNo6} and admiss_times=#{times}")
    void updateZyActpatientAgain(@Param("patNo1") String patNo1,
                                 @Param("patNo6") String patNo6,
                                 @Param("times") Integer times,
                                 @Param("disDate") Date disDate, @Param("table") String table);

    @Insert("INSERT INTO zy_inactpatient SELECT * FROM zy_actpatient WHERE inpatient_no >=#{patNo1} " +
            "and inpatient_no <= #{patNo6} and admiss_times=#{times}")
    void insertZyInactpatientAgain(@Param("patNo1") String patNo1,
                                   @Param("patNo6") String patNo6,
                                   @Param("times") Integer times);

    @Update("update zy_adt SET dis_date=#{disDate},orig_ward=#{wardCode},orig_dept=#{deptCode},orig_bed=#{bedNo} " +
            "WHERE inpatient_no=#{patNo} AND admiss_times=#{times} AND trans_times=0")
    int updateZyAdt(@Param("patNo") String patNo, @Param("times") Integer times,
                    @Param("wardCode") String wardCode, @Param("deptCode") String deptCode,
                    @Param("bedNo") String bedNo, @Param("disDate") Date disDate);

    @Update("update zy_bed_mi SET bed_status='1',admiss_times=NULL,inpatient_no=NULL WHERE " +
            "inpatient_no=#{patNo} AND admiss_times=#{times}")
    void updateZyBedMi(@Param("patNo") String patNo, @Param("times") Integer times);

    @Delete("DELETE FROM zy_actpatient WHERE inpatient_no=#{patNo}")
    void deleteZyActpatient(@Param("patNo") String patNo);

    @Delete("DELETE FROM zy_actpatient WHERE inpatient_no >= #{patNo1} and inpatient_no <= #{patNo6} " +
            " and admiss_times=#{times}")
    void deleteZyActpatientAgain(@Param("patNo1") String patNo1, @Param("patNo6") String patNo6,
                                 @Param("times") Integer times);

    @Insert("insert into zy_work_log (inpatient_no,admiss_times,ledger_sn,op_id,op_date,log_type," +
            "dept_code,ward_code,name) values (#{patNo},#{times},#{ledgerSn},#{codeRs}," +
            "getDate(),#{logType},#{deptCode},#{wardCode},#{userName})")
    int insertNewZyWorkLog(@Param("patNo") String patNo, @Param("times") Integer times,
                           @Param("ledgerSn") int ledgerSn, @Param("wardCode") String wardCode,
                           @Param("logType") String logType, @Param("deptCode") String deptCode,
                           @Param("codeRs") String codeRs, @Param("userName") String userName);

    @Update("update ${table} set times_billed=(times_billed+1) where " +
            "inpatient_no=#{patNo} and admiss_times=#{times}")
    void updateTimesBilledByIncreaseOne(@Param("patNo") String patNo, @Param("times") Integer times, @Param("table") String table);

    @Insert("INSERT INTO zy_ledger_file (inpatient_no, admiss_times, ledger_sn, op_id_code, deposit, balance, " +
            "total_charge, charge1, charge2, charge3, charge4, charge5, charge6, charge7, charge8, charge9, " +
            "charge10, charge11, charge12, charge13, charge14, charge15, charge16, charge17, charge18, " +
            "charge19, charge20, last_balance, settle, settle_type) VALUES " +
            "(#{patNo}, #{times}, #{ledgerSn}, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, " +
            "0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0')")
    void insertNewLedgerFile(@Param("patNo") String patNo,
                             @Param("times") Integer times,
                             @Param("ledgerSn") int ledgerSn);

    @Update("update zy_ledger_file set total_charge=" +
            "(select isnull(sum(charge_fee),0) from zy_detail_charge where inpatient_no=#{patNo} and " +
            "admiss_times=#{times} and ledger_sn=#{ledgerSn}) where inpatient_no=#{patNo} " +
            "and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    void updateZyLedgerFileTotalCharge(@Param("patNo") String patNo,
                                       @Param("times") Integer times,
                                       @Param("ledgerSn") int ledgerSn);

    @Update("update zy_detail_charge set ledger_sn=#{ledgerSn} where inpatient_no=#{patNo} " +
            "and admiss_times=#{times} and ledger_sn=#{lastSn} and charge_date>#{zjdzDate}")
    void updateFeesLedgerSn(@Param("patNo") String patNo,
                            @Param("times") Integer times,
                            @Param("ledgerSn") int ledgerSn,
                            @Param("lastSn") int lastSn,
                            @Param("zjdzDate") Date zjdzDate);

    @Update("update zy_actpatient set responce_type='01', visit_type='01', yb_type='', treat_type=''," +
            "yb_register_date=#{date} where inpatient_no=#{patNo} and admiss_times=#{times}")
    void retractYbsf1(@Param("patNo") String patNo, @Param("times") Integer times, @Param("date") Date date);

    @Update("delete from yb_zy_review_record where inpatient_no=#{patNo} and admiss_times=#{times}")
    void retractYbsf2(@Param("patNo") String patNo, @Param("times") Integer times);

    @Select("select rtrim(hic_no_new) from a_patient_mi where inpatient_no=#{zyh}")
    String getHicNoNew(@Param("zyh") String zyh);

    @Update("update a_patient_mi set cpy=#{hicNew} where inpatient_no=#{zyh}")
    void updateCpy(@Param("zyh") String zyh, @Param("hicNew") String hicNew);

    @Update("update a_patient_mi set hic_no=#{hicNew} where inpatient_no=#{zyh}")
    void updateHic(@Param("zyh") String zyh, @Param("hicNew") String hicNew);

    @Select("select mdtrt_id from t_si_pat_info where pat_no=#{patNo} and times=#{times} and ledger_sn=#{ledgerSn}")
    String selectMdtrtId(@Param("patNo") String patNo,
                         @Param("times") Integer times,
                         @Param("ledgerSn") int ledgerSn);

    @Select("select serial_no from t_injury_si_pat_info where pat_no=#{patNo} and times=#{times} and ledger_sn=#{ledgerSn}")
    String selectInjurySerialNo(@Param("patNo") String patNo,
                                @Param("times") Integer times,
                                @Param("ledgerSn") int ledgerSn);

    @Update("update zy_actpatient set total_charge=#{map.total},charge1=#{map.001},charge2=#{map.002}, " +
            "charge3=#{map.003},charge4=#{map.004},charge5=#{map.005},charge6=#{map.006},charge7=#{map.007}, " +
            "charge8=#{map.008},charge9=#{map.009},charge10=#{map.010},charge11=#{map.011},charge12=#{map.012}, " +
            "charge13=#{map.013},charge14=#{map.014},charge15=#{map.015},charge16=#{map.016},charge17=#{map.017}, " +
            "charge18=#{map.018},charge19=#{map.019},charge20=#{map.020},charge21=#{map.021},charge22=#{map.022}," +
            "charge23=#{map.023},charge24=#{map.024},charge25=#{map.025},charge26=#{map.026},charge27=#{map.027}, " +
            "charge28=#{map.028},charge29=0,charge30=0 where inpatient_no>=#{patNo1} and inpatient_no<=#{patNo6} and admiss_times=#{times} ")
    void updateInfantfee(@Param("patNo1") String patNo1,
                         @Param("patNo6") String patNo6,
                         @Param("times") int times,
                         @Param("map") Map<String, String> map);

    @Select("select b.bill_item_zy as bill_code, ledger_fee=sum(a.charge_fee), " +
            "infant_fee=sum(case when isnull(infant_flag,0)=1 then charge_fee else 0 end), " +
            "adult_fee=sum(case when isnull(infant_flag,0)!=1 then charge_fee else 0 end) " +
            "from zy_detail_charge a, zd_charge_item b " +
            "where a.inpatient_no=#{patNo} and a.admiss_times=#{times} and " +
            "a.ledger_sn=#{ledgerSn} and a.charge_status!='1' and " +
            "a.charge_date>=#{begntime} and a.charge_date<=#{endtime} and " +
            "a.charge_code=b.code group by b.bill_item_zy, a.ledger_sn")
    List<ReceiptFee> selectLedgerFees(@Param("patNo") String patNo,
                                      @Param("times") int times,
                                      @Param("ledgerSn") int ledgerSn,
                                      @Param("begntime") Date begntime,
                                      @Param("endtime") Date endtime);

    @Select("select code from zy_bill_item")
    List<String> selectBillCodes();

    @Select("select code from zy_zd_responce_type where med_type=(select med_type from t_si_pat_info " +
            "where pat_no=#{patNo} and times=#{times} and ledger_sn=#{ledgerSn} and isnull(mdtrt_id,'')!='')")
    String selectResponceType(@Param("patNo") String patNo,
                              @Param("times") int times,
                              @Param("ledgerSn") int ledgerSn);

    @Select("select cast(sum(depo_amount) as varchar(16)) from zy_deposit_file where " +
            "inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn} and status = '1' ")
    String selectDepositSumamt(@Param("patNo") String patNo,
                               @Param("times") int times,
                               @Param("ledgerSn") int ledgerSn);

    @Update("update zy_ledger_file set deposit=#{deposit}, balance=#{balance}, responce_type=#{restype}, " +
            "total_charge=#{map.total},charge1=#{map.001},charge2=#{map.002}, charge3=#{map.003},charge4=#{map.004}, " +
            "charge5=#{map.005},charge6=#{map.006},charge7=#{map.007}, charge8=#{map.008},charge9=#{map.009}, " +
            "charge10=#{map.010},charge11=#{map.011},charge12=#{map.012}, charge13=#{map.013},charge14=#{map.014}, " +
            "charge15=#{map.015},charge16=#{map.016},charge17=#{map.017}, charge18=#{map.018},charge19=#{map.019}, " +
            "charge20=#{map.020},charge21=#{map.021},charge22=#{map.022}, charge23=#{map.023},charge24=#{map.024}, " +
            "charge25=#{map.025},charge26=#{map.026},charge27=#{map.027}, charge28=#{map.028},charge29=0,charge30=0 " +
            "where inpatient_no=#{patNo} and admiss_times=#{times} and ledger_sn=#{ledgerSn}")
    void updateZyLedgerFileCharges(@Param("patNo") String patNo,
                                   @Param("times") int times,
                                   @Param("ledgerSn") int ledgerSn,
                                   @Param("deposit") String deposit,
                                   @Param("balance") String balance,
                                   @Param("restype") String restype,
                                   @Param("map") Map<String, String> map);

    @Update("update zy_actpatient set balance=#{balance},responce_type=#{restype}, total_charge=#{totalCost}, " +
            "charge1=#{map.001},charge2=#{map.002}, charge3=#{map.003},charge4=#{map.004},charge5=#{map.005}, " +
            "charge6=#{map.006},charge7=#{map.007}, charge8=#{map.008},charge9=#{map.009},charge10=#{map.010}, " +
            "charge11=#{map.011},charge12=#{map.012}, charge13=#{map.013},charge14=#{map.014},charge15=#{map.015}, " +
            "charge16=#{map.016},charge17=#{map.017}, charge18=#{map.018},charge19=#{map.019},charge20=#{map.020}, " +
            "charge21=#{map.021},charge22=#{map.022}, charge23=#{map.023},charge24=#{map.024},charge25=#{map.025}, " +
            "charge26=#{map.026},charge27=#{map.027}, charge28=#{map.028},charge29=0,charge30=0 where inpatient_no=#{patNo} ")
    void updateZyActpatientCharges(@Param("patNo") String patNo,
                                   @Param("totalCost") String totalCost,
                                   @Param("balance") String balance,
                                   @Param("restype") String restype,
                                   @Param("map") Map<String, String> map);

    @Select("select isnull(sum(charge_fee),0) from zy_detail_charge where inpatient_no=#{patNo} " +
            "and admiss_times=#{times} and ledger_sn>0 and isnull(charge_status,'1')!='1' ")
    String selectTotalCharge(@Param("patNo") String patNo,
                             @Param("times") int times);
}