SiMzFeeOprnSystem/src/main/java/thyyxxk/simzfeeoprnsystm/dao/MobilePayDao.java

package thyyxxk.simzfeeoprnsystm.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.*;
import thyyxxk.simzfeeoprnsystm.pojo.SiPatInfo;
import thyyxxk.simzfeeoprnsystm.pojo.mobilepay.*;

import java.util.List;

@Mapper
public interface MobilePayDao extends BaseMapper<MobilePay> {
    @Select("select psn_no from t_si_pat_info where pat_no=#{patNo} and times=#{times}")
    String selectPsnNofoForMz(@Param("patNo") String patNo,
                              @Param("times") int times);

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

    @Select("select count(1) from t_si_pat_info where pat_no=#{patNo} and times=#{times} ")
    int selectSiMzInfoCount(@Param("patNo") String patNo,
                            @Param("times") int times);

    @Insert("insert into t_si_pat_info (pat_no, times, ledger_sn, psn_no, psn_cert_type, insutype, insuplc_admdvs, " +
            "certno, psn_name, gend, naty, brdy, age, med_type, psn_idet_type,psn_type,emp_name, create_datetime, balc) " +
            "values (#{patNo},#{times},#{ledgerSn},#{psnNo},#{psnCertType},#{insutype},#{insuplc},#{certno}," +
            "#{psnName},#{gend},#{naty},#{brdy},#{age},#{medType},#{psnIdetType},#{psnType},#{empName},getdate(),#{balc})")
    void insertSiMzInfoPsnNo(PsnBaseInfo psnBaseinfo);

    @Update("update t_si_pat_info set insutype=#{insutype},balc=#{balc},insuplc_admdvs=#{admdvs} " +
            "where pat_no=#{patNo} and times=#{times}")
    void updateSiZyInfoPsnNo(@Param("patNo") String patNo,
                             @Param("times") int times,
                             @Param("insutype") String insutype,
                             @Param("balc") String balc,
                             @Param("admdvs") String admdvs);

    @Select("select psn_no,insutype, " +
            "medOrgOrd=pat_no+'_'+cast(a.times as varchar)+'_1', " +
            "begntime=b.visit_date, " +
            "idNo=a.certno, " +
            "userName=a.psn_name, " +
            "idType='01', " +
            "ecToken='', " +
            "insuCode=a.insuplc_admdvs, " +
            "iptOtpNo=a.pat_no, " +
            "deptCode=rtrim(b.visit_dept_code)," +
            "deptName=(select rtrim(d.name) from zd_unit_code d where d.code=b.visit_dept_code), " +
            "caty=(select rtrim(d.si_caty) from zd_unit_code d where d.code=b.visit_dept_code), " +
            "a.mdtrt_id,a.med_type, " +
            "feeType='01', " +
            "medfeeSumamt=(select sum(d.charge_fee) from t_mt_receipt d where d.patient_id=a.pat_no and d.times=a.times), " +
            "acctUsedFlag='1', " +
            "psnSetlway='01', " +
            "diseCodg=a.dise_code," +
            "diseName=a.dise_name," +
            "chrgBchno=pat_no+'_'+a.mdtrt_id " +
            "from t_si_pat_info a,mz_visit_table b " +
            "where a.pat_no=#{patNo} and a.times=#{times} " +
            "and b.patient_id=a.pat_no and b.times=a.times")
    Upload6201 selectUpload6201(@Param("patNo") String patNo, @Param("times") int times);

    @Select("select diag_type,diag_srt_no,diag_code,diag_name," +
            "diag_dept,dise_dor_no,dise_dor_name," +
            "diag_time,vali_flag from t_si_mz_diag " +
            "where pat_no=#{patNo} and times=#{times}")
    List<Diseinfo> selectMpDiseinfos(@Param("patNo") String patNo, @Param("times") int times);

    @Select("select " +
            "feedetlSn=(a.patient_id + '_' + cast(a.times as varchar) + '_' + cast(a.receipt_no as varchar) + '_' + " +
            "cast(a.order_no as varchar) + '_' + cast(a.item_no as varchar)), " +
            "b.mdtrt_id,b.psn_no,chrgBchno=b.pat_no+'_'+b.mdtrt_id, " +
            "rxCircFlag='0',input_date as feeOcurTime, " +
            "medListCodg=isnull((select max(national_code) from yp_zd_dict where code=his_item_code), " +
            "(select max(national_code) from zd_charge_item where code=his_item_code)), " +
            "his_item_code as medinsListCodg, " +
            "charge_fee as detItemFeeSumamt, " +
            "quantity as cnt, price as pric, " +
            "b.med_type,hospApprFlag='1', " +
            "bilgDrCodg=(select rtrim(yb_code) from a_employee_mi where code=input_staff), " +
            "input_man as bilgDrName, " +
            "bilgDeptCodg=rtrim(c.visit_dept_code), " +
            "bilgDeptName=(select rtrim(d.name) from zd_unit_code d where d.code=c.visit_dept_code) " +
            "from t_mt_receipt a, t_si_pat_info b, mz_visit_table c " +
            "where a.patient_id=#{patNo} and a.times=#{times} " +
            "and b.pat_no=a.patient_id and b.times=a.times " +
            "and c.patient_id=a.patient_id and c.times=a.times")
    List<Feedetail> selectMpFees(@Param("patNo") String patNo, @Param("times") int times);

    @Select("select icd_code_new as icdCode,icd_text_new as icdName," +
            "visit_date,drCode=rtrim(doctor_code)," +
            "drName=(select rtrim(d.name) from a_employee_mi d where d.code=doctor_code) " +
            "from mz_visit_table where patient_id=#{patNo} and times=#{times}")
    VisitTableIcd selectMzVisitIcd(@Param("patNo") String patNo, @Param("times") int times);

    @Select("select * from t_si_pat_info where pat_no=#{patNo} and times=#{times}")
    SiPatInfo selectSiPatInfoForMz(@Param("patNo") String patNo,
                                   @Param("times") int times);

    @Select("select pay_ord_id,orgCodg='H43010500370',pay_token,id_no," +
            "user_name,id_type from t_mobile_pay where mdtrt_id=#{mdtrtId} ")
    MobileOrderQuery selectOrderQueryData(@Param("mdtrtId") String mdtrtId);
}