<?xml version="1.0" encoding="UTF-8"?>

<!--
  ~
  ~      Copyright (c) 2018-2025, lengleng All rights reserved.
  ~
  ~  Redistribution and use in source and binary forms, with or without
  ~  modification, are permitted provided that the following conditions are met:
  ~
  ~ Redistributions of source code must retain the above copyright notice,
  ~  this list of conditions and the following disclaimer.
  ~  Redistributions in binary form must reproduce the above copyright
  ~  notice, this list of conditions and the following disclaimer in the
  ~  documentation and/or other materials provided with the distribution.
  ~  Neither the name of the yifu4cloud.com developer nor the names of its
  ~  contributors may be used to endorse or promote products derived from
  ~  this software without specific prior written permission.
  ~  Author: lengleng (wangiegie@gmail.com)
  ~
  -->

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.yifu.cloud.plus.v1.yifu.social.mapper.TPreDispatchInfoMapper">

  <resultMap id="tPreDispatchInfoMap" type="com.yifu.cloud.plus.v1.yifu.social.entity.TPreDispatchInfo">
    <id property="id" column="ID"/>
    <result property="type" column="TYPE"/>
    <result property="date" column="DATE"/>
    <result property="company" column="COMPANY"/>
    <result property="payAddress" column="PAY_ADDRESS"/>
    <result property="customerName" column="CUSTOMER_NAME"/>
    <result property="empIdcard" column="EMP_IDCARD"/>
    <result property="empName" column="EMP_NAME"/>
    <result property="telOne" column="TEL_ONE"/>
    <result property="telTwo" column="TEL_TWO"/>
    <result property="entryDate" column="ENTRY_DATE"/>
    <result property="formalSalary" column="FORMAL_SALARY"/>
    <result property="dispatchStart" column="DISPATCH_START"/>
    <result property="dispatchEnd" column="DISPATCH_END"/>
    <result property="contractStart" column="CONTRACT_START"/>
    <result property="contractEnd" column="CONTRACT_END"/>
    <result property="trialStart" column="TRIAL_START"/>
    <result property="trialEnd" column="TRIAL_END"/>
    <result property="trialSalary" column="TRIAL_SALARY"/>
    <result property="workingSystem" column="WORKING_SYSTEM"/>
    <result property="contractVersion" column="CONTRACT_VERSION"/>
    <result property="telNotice" column="TEL_NOTICE"/>
    <result property="workingAddress" column="WORKING_ADDRESS"/>
    <result property="remarkOne" column="REMARK_ONE"/>
    <result property="remarkTwo" column="REMARK_TWO"/>
    <result property="pensionAddress" column="PENSION_ADDRESS"/>
    <result property="pensionBase" column="PENSION_BASE"/>
    <result property="pensionStart" column="PENSION_START"/>
    <result property="medicalAddress" column="MEDICAL_ADDRESS"/>
    <result property="medicalBase" column="MEDICAL_BASE"/>
    <result property="medicalStart" column="MEDICAL_START"/>
    <result property="injuryAddress" column="INJURY_ADDRESS"/>
    <result property="injuryBase" column="INJURY_BASE"/>
    <result property="injuryStart" column="INJURY_START"/>
    <result property="birthAddress" column="BIRTH_ADDRESS"/>
    <result property="birthBase" column="BIRTH_BASE"/>
    <result property="birthStart" column="BIRTH_START"/>
    <result property="unemploymentAddress" column="UNEMPLOYMENT_ADDRESS"/>
    <result property="unemploymentBase" column="UNEMPLOYMENT_BASE"/>
    <result property="unemploymentStart" column="UNEMPLOYMENT_START"/>
    <result property="fundAddress" column="FUND_ADDRESS"/>
    <result property="fundBase" column="FUND_BASE"/>
    <result property="fundStart" column="FUND_START"/>
    <result property="fundPersonalPer" column="FUND_PERSONAL_PER"/>
    <result property="fundCompanyPer" column="FUND_COMPANY_PER"/>
    <result property="dispatchCompany" column="DISPATCH_COMPANY"/>
    <result property="customerService" column="CUSTOMER_SERVICE"/>
    <result property="contractMinorName" column="CONTRACT_MINOR_NAME"/>
    <result property="uniqueNumber" column="UNIQUE_NUMBER"/>
    <result property="customerNumber" column="CUSTOMER_NUMBER"/>
    <result property="serviceType" column="SERVICE_TYPE"/>
    <result property="pensionAddressReduce" column="PENSION_ADDRESS_REDUCE"/>
    <result property="pensionEndReduce" column="PENSION_END_REDUCE"/>
    <result property="medicalAddressReduce" column="MEDICAL_ADDRESS_REDUCE"/>
    <result property="medicalEndReduce" column="MEDICAL_END_REDUCE"/>
    <result property="injuryAddressReduce" column="INJURY_ADDRESS_REDUCE"/>
    <result property="injuryEndReduce" column="INJURY_END_REDUCE"/>
    <result property="birthAddressReduce" column="BIRTH_ADDRESS_REDUCE"/>
    <result property="birthEndReduce" column="BIRTH_END_REDUCE"/>
    <result property="unemploymentAddressReduce" column="UNEMPLOYMENT_ADDRESS_REDUCE"/>
    <result property="unemploymentEndReduce" column="UNEMPLOYMENT_END_REDUCE"/>
    <result property="fundAddressReduce" column="FUND_ADDRESS_REDUCE"/>
    <result property="fundEndReduce" column="FUND_END_REDUCE"/>
    <result property="leaveDate" column="LEAVE_DATE"/>
    <result property="leaveReason" column="LEAVE_REASON"/>
    <result property="contractType" column="CONTRACT_TYPE"/>
    <result property="empTypeAdd" column="EMP_TYPE_ADD"/>
    <result property="unitIdAdd" column="UNIT_ID_ADD"/>
    <result property="departIdAdd" column="DEPART_ID_ADD"/>
    <result property="unitNameAdd" column="UNIT_NAME_ADD"/>
    <result property="departNameAdd" column="DEPART_NAME_ADD"/>
    <result property="socialHouseAdd" column="SOCIAL_HOUSE_ADD"/>
    <result property="fundHouseAdd" column="FUND_HOUSE_ADD"/>
    <result property="filingBaseAdd" column="FILING_BASE_ADD"/>
    <result property="preStatus" column="PRE_STATUS"/>
    <result property="status" column="STATUS"/>
    <result property="exceptionContent" column="EXCEPTION_CONTENT"/>
    <result property="socialProvince" column="SOCIAL_PROVINCE"/>
    <result property="socialCity" column="SOCIAL_CITY"/>
    <result property="socialTown" column="SOCIAL_TOWN"/>
    <result property="fundProvince" column="FUND_PROVINCE"/>
    <result property="fundCity" column="FUND_CITY"/>
    <result property="fundTown" column="FUND_TOWN"/>
    <result property="dayLimit" column="DAY_LIMIT"/>
    <result property="dataSubStatus" column="DATA_SUB_STATUS"/>
    <result property="positionAdd" column="POSITION_ADD"/>
    <result property="contractNameAdd" column="CONTRACT_NAME_ADD"/>
    <result property="contractTypeAdd" column="CONTRACT_TYPE_ADD"/>
    <result property="contractStartAdd" column="CONTRACT_START_ADD"/>
    <result property="contractEndAdd" column="CONTRACT_END_ADD"/>
    <result property="contractTermAdd" column="CONTRACT_TERM_ADD"/>
    <result property="workingHoursAdd" column="WORKING_HOURS_ADD"/>
    <result property="leaveReasonAdd" column="LEAVE_REASON_ADD"/>
    <result property="remark" column="REMARK"/>
    <result property="dispatchFlag" column="DISPATCH_FLAG"/>
    <result property="cancelRemark" column="CANCEL_REMARK"/>
    <result property="userDeptName" column="USER_DEPT_NAME"/>
    <result property="createBy" column="CREATE_BY"/>
    <result property="updateBy" column="UPDATE_BY"/>
    <result property="createName" column="CREATE_NAME"/>
    <result property="createTime" column="CREATE_TIME"/>
    <result property="updateTime" column="UPDATE_TIME"/>
  </resultMap>
    <sql id="Base_Column_List">
                a.ID,
                a.TYPE,
                a.DATE,
                a.COMPANY,
                a.PAY_ADDRESS,
                a.CUSTOMER_NAME,
                a.EMP_IDCARD,
                a.EMP_NAME,
                a.TEL_ONE,
                a.TEL_TWO,
                a.ENTRY_DATE,
                a.FORMAL_SALARY,
                a.DISPATCH_START,
                a.DISPATCH_END,
                a.CONTRACT_START,
                a.CONTRACT_END,
                a.TRIAL_START,
                a.TRIAL_END,
                a.TRIAL_SALARY,
                a.WORKING_SYSTEM,
                a.CONTRACT_VERSION,
                a.TEL_NOTICE,
                a.WORKING_ADDRESS,
                a.REMARK_ONE,
                a.REMARK_TWO,
                a.PENSION_ADDRESS,
                a.PENSION_BASE,
                a.PENSION_START,
                a.MEDICAL_ADDRESS,
                a.MEDICAL_BASE,
                a.MEDICAL_START,
                a.INJURY_ADDRESS,
                a.INJURY_BASE,
                a.INJURY_START,
                a.BIRTH_ADDRESS,
                a.BIRTH_BASE,
                a.BIRTH_START,
                a.UNEMPLOYMENT_ADDRESS,
                a.UNEMPLOYMENT_BASE,
                a.UNEMPLOYMENT_START,
                a.FUND_ADDRESS,
                a.FUND_BASE,
                a.FUND_START,
                a.FUND_PERSONAL_PER,
                a.FUND_COMPANY_PER,
                a.DISPATCH_COMPANY,
                a.CUSTOMER_SERVICE,
                a.CONTRACT_MINOR_NAME,
                a.UNIQUE_NUMBER,
                a.CUSTOMER_NUMBER,
                a.SERVICE_TYPE,
                a.PENSION_ADDRESS_REDUCE,
                a.PENSION_END_REDUCE,
                a.MEDICAL_ADDRESS_REDUCE,
                a.MEDICAL_END_REDUCE,
                a.INJURY_ADDRESS_REDUCE,
                a.INJURY_END_REDUCE,
                a.BIRTH_ADDRESS_REDUCE,
                a.BIRTH_END_REDUCE,
                a.UNEMPLOYMENT_ADDRESS_REDUCE,
                a.UNEMPLOYMENT_END_REDUCE,
                a.FUND_ADDRESS_REDUCE,
                a.FUND_END_REDUCE,
                a.LEAVE_DATE,
                a.LEAVE_REASON,
                a.CONTRACT_TYPE,
                a.EMP_TYPE_ADD,
                a.UNIT_ID_ADD,
                a.DEPART_ID_ADD,
                a.UNIT_NAME_ADD,
                a.DEPART_NAME_ADD,
                a.SOCIAL_HOUSE_ADD,
                a.FUND_HOUSE_ADD,
                a.FILING_BASE_ADD,
                a.PRE_STATUS,
                a.STATUS,
                a.EXCEPTION_CONTENT,
                a.SOCIAL_PROVINCE,
                a.SOCIAL_CITY,
                a.SOCIAL_TOWN,
                a.FUND_PROVINCE,
                a.FUND_CITY,
                a.FUND_TOWN,
                a.DAY_LIMIT,
                a.DATA_SUB_STATUS,
                a.POSITION_ADD,
                a.CONTRACT_NAME_ADD,
                a.CONTRACT_TYPE_ADD,
                a.CONTRACT_START_ADD,
                a.CONTRACT_END_ADD,
                a.CONTRACT_TERM_ADD,
                a.WORKING_HOURS_ADD,
                a.LEAVE_REASON_ADD,
                a.REMARK,
                a.DISPATCH_FLAG,
                a.CANCEL_REMARK,
                a.USER_DEPT_NAME,
                a.CREATE_BY,
                a.UPDATE_BY,
                a.CREATE_NAME,
                a.CREATE_TIME,
                a.UPDATE_TIME
    </sql>
    <sql id="tPreDispatchInfo_where">
        <if test="tPreDispatchInfo != null">
				<if test="tPreDispatchInfo.idList != null">
				AND a.id in
				<foreach item="idStr" index="index" collection="tPreDispatchInfo.idList" open="(" separator="," close=")">
					#{idStr}
				</foreach>
				</if>
		<if test="tPreDispatchInfo.idList == null">
                    <if test="tPreDispatchInfo.id != null and tPreDispatchInfo.id.trim() != ''">
                        AND a.ID = #{tPreDispatchInfo.id}
                    </if>
                    <if test="tPreDispatchInfo.type != null and tPreDispatchInfo.type.trim() != ''">
                        AND a.TYPE = #{tPreDispatchInfo.type}
                    </if>
                    <if test="tPreDispatchInfo.date != null and tPreDispatchInfo.date.trim() != ''">
                        AND a.DATE = #{tPreDispatchInfo.date}
                    </if>
                    <if test="tPreDispatchInfo.company != null and tPreDispatchInfo.company.trim() != ''">
						AND a.COMPANY like  CONCAT('%',#{tPreDispatchInfo.company,jdbcType=VARCHAR},'%')
					</if>
                    <if test="tPreDispatchInfo.payAddress != null and tPreDispatchInfo.payAddress.trim() != ''">
						AND a.PAY_ADDRESS like  CONCAT('%',#{tPreDispatchInfo.payAddress,jdbcType=VARCHAR},'%')
                    </if>
                    <if test="tPreDispatchInfo.customerName != null and tPreDispatchInfo.customerName.trim() != ''">
						AND a.CUSTOMER_NAME like  CONCAT('%',#{tPreDispatchInfo.customerName,jdbcType=VARCHAR},'%')
					</if>
                    <if test="tPreDispatchInfo.empIdcard != null and tPreDispatchInfo.empIdcard.trim() != ''">
                        AND a.EMP_IDCARD = #{tPreDispatchInfo.empIdcard}
                    </if>
                    <if test="tPreDispatchInfo.empName != null and tPreDispatchInfo.empName.trim() != ''">
						AND a.EMP_NAME like  CONCAT('%',#{tPreDispatchInfo.empName,jdbcType=VARCHAR},'%')
					</if>
                    <if test="tPreDispatchInfo.telOne != null and tPreDispatchInfo.telOne.trim() != ''">
                        AND a.TEL_ONE = #{tPreDispatchInfo.telOne}
                    </if>
                    <if test="tPreDispatchInfo.telTwo != null and tPreDispatchInfo.telTwo.trim() != ''">
                        AND a.TEL_TWO = #{tPreDispatchInfo.telTwo}
                    </if>
                    <if test="tPreDispatchInfo.entryDate != null and tPreDispatchInfo.entryDate.trim() != ''">
                        AND a.ENTRY_DATE = #{tPreDispatchInfo.entryDate}
                    </if>
                    <if test="tPreDispatchInfo.formalSalary != null and tPreDispatchInfo.formalSalary.trim() != ''">
                        AND a.FORMAL_SALARY = #{tPreDispatchInfo.formalSalary}
                    </if>
                    <if test="tPreDispatchInfo.dispatchStart != null and tPreDispatchInfo.dispatchStart.trim() != ''">
                        AND a.DISPATCH_START = #{tPreDispatchInfo.dispatchStart}
                    </if>
                    <if test="tPreDispatchInfo.dispatchEnd != null and tPreDispatchInfo.dispatchEnd.trim() != ''">
                        AND a.DISPATCH_END = #{tPreDispatchInfo.dispatchEnd}
                    </if>
                    <if test="tPreDispatchInfo.contractStart != null and tPreDispatchInfo.contractStart.trim() != ''">
                        AND a.CONTRACT_START = #{tPreDispatchInfo.contractStart}
                    </if>
                    <if test="tPreDispatchInfo.contractEnd != null and tPreDispatchInfo.contractEnd.trim() != ''">
                        AND a.CONTRACT_END = #{tPreDispatchInfo.contractEnd}
                    </if>
                    <if test="tPreDispatchInfo.trialStart != null and tPreDispatchInfo.trialStart.trim() != ''">
                        AND a.TRIAL_START = #{tPreDispatchInfo.trialStart}
                    </if>
                    <if test="tPreDispatchInfo.trialEnd != null and tPreDispatchInfo.trialEnd.trim() != ''">
                        AND a.TRIAL_END = #{tPreDispatchInfo.trialEnd}
                    </if>
                    <if test="tPreDispatchInfo.trialSalary != null and tPreDispatchInfo.trialSalary.trim() != ''">
                        AND a.TRIAL_SALARY = #{tPreDispatchInfo.trialSalary}
                    </if>
                    <if test="tPreDispatchInfo.workingSystem != null and tPreDispatchInfo.workingSystem.trim() != ''">
                        AND a.WORKING_SYSTEM = #{tPreDispatchInfo.workingSystem}
                    </if>
                    <if test="tPreDispatchInfo.contractVersion != null and tPreDispatchInfo.contractVersion.trim() != ''">
                        AND a.CONTRACT_VERSION = #{tPreDispatchInfo.contractVersion}
                    </if>
                    <if test="tPreDispatchInfo.telNotice != null and tPreDispatchInfo.telNotice.trim() != ''">
                        AND a.TEL_NOTICE = #{tPreDispatchInfo.telNotice}
                    </if>
                    <if test="tPreDispatchInfo.workingAddress != null and tPreDispatchInfo.workingAddress.trim() != ''">
                        AND a.WORKING_ADDRESS = #{tPreDispatchInfo.workingAddress}
                    </if>
                    <if test="tPreDispatchInfo.remarkOne != null and tPreDispatchInfo.remarkOne.trim() != ''">
                        AND a.REMARK_ONE = #{tPreDispatchInfo.remarkOne}
                    </if>
                    <if test="tPreDispatchInfo.remarkTwo != null and tPreDispatchInfo.remarkTwo.trim() != ''">
                        AND a.REMARK_TWO = #{tPreDispatchInfo.remarkTwo}
                    </if>
                    <if test="tPreDispatchInfo.pensionAddress != null and tPreDispatchInfo.pensionAddress.trim() != ''">
                        AND a.PENSION_ADDRESS = #{tPreDispatchInfo.pensionAddress}
                    </if>
                    <if test="tPreDispatchInfo.pensionBase != null">
                        AND a.PENSION_BASE = #{tPreDispatchInfo.pensionBase}
                    </if>
                    <if test="tPreDispatchInfo.pensionStart != null and tPreDispatchInfo.pensionStart.trim() != ''">
                        AND a.PENSION_START = #{tPreDispatchInfo.pensionStart}
                    </if>
                    <if test="tPreDispatchInfo.medicalAddress != null and tPreDispatchInfo.medicalAddress.trim() != ''">
                        AND a.MEDICAL_ADDRESS = #{tPreDispatchInfo.medicalAddress}
                    </if>
                    <if test="tPreDispatchInfo.medicalBase != null">
                        AND a.MEDICAL_BASE = #{tPreDispatchInfo.medicalBase}
                    </if>
                    <if test="tPreDispatchInfo.medicalStart != null and tPreDispatchInfo.medicalStart.trim() != ''">
                        AND a.MEDICAL_START = #{tPreDispatchInfo.medicalStart}
                    </if>
                    <if test="tPreDispatchInfo.injuryAddress != null and tPreDispatchInfo.injuryAddress.trim() != ''">
                        AND a.INJURY_ADDRESS = #{tPreDispatchInfo.injuryAddress}
                    </if>
                    <if test="tPreDispatchInfo.injuryBase != null">
                        AND a.INJURY_BASE = #{tPreDispatchInfo.injuryBase}
                    </if>
                    <if test="tPreDispatchInfo.injuryStart != null and tPreDispatchInfo.injuryStart.trim() != ''">
                        AND a.INJURY_START = #{tPreDispatchInfo.injuryStart}
                    </if>
                    <if test="tPreDispatchInfo.birthAddress != null and tPreDispatchInfo.birthAddress.trim() != ''">
                        AND a.BIRTH_ADDRESS = #{tPreDispatchInfo.birthAddress}
                    </if>
                    <if test="tPreDispatchInfo.birthBase != null">
                        AND a.BIRTH_BASE = #{tPreDispatchInfo.birthBase}
                    </if>
                    <if test="tPreDispatchInfo.birthStart != null and tPreDispatchInfo.birthStart.trim() != ''">
                        AND a.BIRTH_START = #{tPreDispatchInfo.birthStart}
                    </if>
                    <if test="tPreDispatchInfo.unemploymentAddress != null and tPreDispatchInfo.unemploymentAddress.trim() != ''">
                        AND a.UNEMPLOYMENT_ADDRESS = #{tPreDispatchInfo.unemploymentAddress}
                    </if>
                    <if test="tPreDispatchInfo.unemploymentBase != null">
                        AND a.UNEMPLOYMENT_BASE = #{tPreDispatchInfo.unemploymentBase}
                    </if>
                    <if test="tPreDispatchInfo.unemploymentStart != null and tPreDispatchInfo.unemploymentStart.trim() != ''">
                        AND a.UNEMPLOYMENT_START = #{tPreDispatchInfo.unemploymentStart}
                    </if>
                    <if test="tPreDispatchInfo.fundAddress != null and tPreDispatchInfo.fundAddress.trim() != ''">
                        AND a.FUND_ADDRESS = #{tPreDispatchInfo.fundAddress}
                    </if>
                    <if test="tPreDispatchInfo.fundBase != null">
                        AND a.FUND_BASE = #{tPreDispatchInfo.fundBase}
                    </if>
                    <if test="tPreDispatchInfo.fundStart != null and tPreDispatchInfo.fundStart.trim() != ''">
                        AND a.FUND_START = #{tPreDispatchInfo.fundStart}
                    </if>
                    <if test="tPreDispatchInfo.fundPersonalPer != null">
                        AND a.FUND_PERSONAL_PER = #{tPreDispatchInfo.fundPersonalPer}
                    </if>
                    <if test="tPreDispatchInfo.fundCompanyPer != null">
                        AND a.FUND_COMPANY_PER = #{tPreDispatchInfo.fundCompanyPer}
                    </if>
                    <if test="tPreDispatchInfo.dispatchCompany != null and tPreDispatchInfo.dispatchCompany.trim() != ''">
                        AND a.DISPATCH_COMPANY = #{tPreDispatchInfo.dispatchCompany}
                    </if>
                    <if test="tPreDispatchInfo.customerService != null and tPreDispatchInfo.customerService.trim() != ''">
                        AND a.CUSTOMER_SERVICE = #{tPreDispatchInfo.customerService}
                    </if>
                    <if test="tPreDispatchInfo.contractMinorName != null and tPreDispatchInfo.contractMinorName.trim() != ''">
                        AND a.CONTRACT_MINOR_NAME = #{tPreDispatchInfo.contractMinorName}
                    </if>
                    <if test="tPreDispatchInfo.uniqueNumber != null and tPreDispatchInfo.uniqueNumber.trim() != ''">
                        AND a.UNIQUE_NUMBER = #{tPreDispatchInfo.uniqueNumber}
                    </if>
                    <if test="tPreDispatchInfo.customerNumber != null and tPreDispatchInfo.customerNumber.trim() != ''">
                        AND a.CUSTOMER_NUMBER = #{tPreDispatchInfo.customerNumber}
                    </if>
                    <if test="tPreDispatchInfo.serviceType != null and tPreDispatchInfo.serviceType.trim() != ''">
                        AND a.SERVICE_TYPE = #{tPreDispatchInfo.serviceType}
                    </if>
                    <if test="tPreDispatchInfo.pensionAddressReduce != null and tPreDispatchInfo.pensionAddressReduce.trim() != ''">
                        AND a.PENSION_ADDRESS_REDUCE = #{tPreDispatchInfo.pensionAddressReduce}
                    </if>
                    <if test="tPreDispatchInfo.pensionEndReduce != null and tPreDispatchInfo.pensionEndReduce.trim() != ''">
                        AND a.PENSION_END_REDUCE = #{tPreDispatchInfo.pensionEndReduce}
                    </if>
                    <if test="tPreDispatchInfo.medicalAddressReduce != null and tPreDispatchInfo.medicalAddressReduce.trim() != ''">
                        AND a.MEDICAL_ADDRESS_REDUCE = #{tPreDispatchInfo.medicalAddressReduce}
                    </if>
                    <if test="tPreDispatchInfo.medicalEndReduce != null and tPreDispatchInfo.medicalEndReduce.trim() != ''">
                        AND a.MEDICAL_END_REDUCE = #{tPreDispatchInfo.medicalEndReduce}
                    </if>
                    <if test="tPreDispatchInfo.injuryAddressReduce != null and tPreDispatchInfo.injuryAddressReduce.trim() != ''">
                        AND a.INJURY_ADDRESS_REDUCE = #{tPreDispatchInfo.injuryAddressReduce}
                    </if>
                    <if test="tPreDispatchInfo.injuryEndReduce != null and tPreDispatchInfo.injuryEndReduce.trim() != ''">
                        AND a.INJURY_END_REDUCE = #{tPreDispatchInfo.injuryEndReduce}
                    </if>
                    <if test="tPreDispatchInfo.birthAddressReduce != null and tPreDispatchInfo.birthAddressReduce.trim() != ''">
                        AND a.BIRTH_ADDRESS_REDUCE = #{tPreDispatchInfo.birthAddressReduce}
                    </if>
                    <if test="tPreDispatchInfo.birthEndReduce != null and tPreDispatchInfo.birthEndReduce.trim() != ''">
                        AND a.BIRTH_END_REDUCE = #{tPreDispatchInfo.birthEndReduce}
                    </if>
                    <if test="tPreDispatchInfo.unemploymentAddressReduce != null and tPreDispatchInfo.unemploymentAddressReduce.trim() != ''">
                        AND a.UNEMPLOYMENT_ADDRESS_REDUCE = #{tPreDispatchInfo.unemploymentAddressReduce}
                    </if>
                    <if test="tPreDispatchInfo.unemploymentEndReduce != null and tPreDispatchInfo.unemploymentEndReduce.trim() != ''">
                        AND a.UNEMPLOYMENT_END_REDUCE = #{tPreDispatchInfo.unemploymentEndReduce}
                    </if>
                    <if test="tPreDispatchInfo.fundAddressReduce != null and tPreDispatchInfo.fundAddressReduce.trim() != ''">
                        AND a.FUND_ADDRESS_REDUCE = #{tPreDispatchInfo.fundAddressReduce}
                    </if>
                    <if test="tPreDispatchInfo.fundEndReduce != null and tPreDispatchInfo.fundEndReduce.trim() != ''">
                        AND a.FUND_END_REDUCE = #{tPreDispatchInfo.fundEndReduce}
                    </if>
                    <if test="tPreDispatchInfo.leaveDate != null">
                        AND a.LEAVE_DATE = #{tPreDispatchInfo.leaveDate}
                    </if>
                    <if test="tPreDispatchInfo.leaveReason != null and tPreDispatchInfo.leaveReason.trim() != ''">
                        AND a.LEAVE_REASON = #{tPreDispatchInfo.leaveReason}
                    </if>
                    <if test="tPreDispatchInfo.contractType != null and tPreDispatchInfo.contractType.trim() != ''">
                        AND a.CONTRACT_TYPE = #{tPreDispatchInfo.contractType}
                    </if>
                    <if test="tPreDispatchInfo.empTypeAdd != null and tPreDispatchInfo.empTypeAdd.trim() != ''">
                        AND a.EMP_TYPE_ADD = #{tPreDispatchInfo.empTypeAdd}
                    </if>
                    <if test="tPreDispatchInfo.unitIdAdd != null and tPreDispatchInfo.unitIdAdd.trim() != ''">
                        AND a.UNIT_ID_ADD = #{tPreDispatchInfo.unitIdAdd}
                    </if>
                    <if test="tPreDispatchInfo.departIdAdd != null and tPreDispatchInfo.departIdAdd.trim() != ''">
                        AND a.DEPART_ID_ADD = #{tPreDispatchInfo.departIdAdd}
                    </if>
                    <if test="tPreDispatchInfo.unitNameAdd != null and tPreDispatchInfo.unitNameAdd.trim() != ''">
                        AND a.UNIT_NAME_ADD like CONCAT('%',#{tPreDispatchInfo.unitNameAdd,jdbcType=VARCHAR},'%')
                    </if>
                    <if test="tPreDispatchInfo.departNameAdd != null and tPreDispatchInfo.departNameAdd.trim() != ''">
						AND a.DEPART_NAME_ADD like  CONCAT('%',#{tPreDispatchInfo.departNameAdd,jdbcType=VARCHAR},'%')
					</if>
                    <if test="tPreDispatchInfo.socialHouseAdd != null and tPreDispatchInfo.socialHouseAdd.trim() != ''">
                        AND a.SOCIAL_HOUSE_ADD = #{tPreDispatchInfo.socialHouseAdd}
                    </if>
                    <if test="tPreDispatchInfo.fundHouseAdd != null and tPreDispatchInfo.fundHouseAdd.trim() != ''">
                        AND a.FUND_HOUSE_ADD = #{tPreDispatchInfo.fundHouseAdd}
                    </if>
                    <if test="tPreDispatchInfo.filingBaseAdd != null">
                        AND a.FILING_BASE_ADD = #{tPreDispatchInfo.filingBaseAdd}
                    </if>
                    <if test="tPreDispatchInfo.preStatus != null and tPreDispatchInfo.preStatus.trim() != ''">
                        AND a.PRE_STATUS = #{tPreDispatchInfo.preStatus}
                    </if>
                    <if test="tPreDispatchInfo.status != null and tPreDispatchInfo.status.trim() != ''">
                        AND a.STATUS = #{tPreDispatchInfo.status}
                    </if>
                    <if test="tPreDispatchInfo.exceptionContent != null and tPreDispatchInfo.exceptionContent.trim() != ''">
                        AND a.EXCEPTION_CONTENT = #{tPreDispatchInfo.exceptionContent}
                    </if>
                    <if test="tPreDispatchInfo.socialProvince != null and tPreDispatchInfo.socialProvince.trim() != ''">
                        AND a.SOCIAL_PROVINCE = #{tPreDispatchInfo.socialProvince}
                    </if>
                    <if test="tPreDispatchInfo.socialCity != null and tPreDispatchInfo.socialCity.trim() != ''">
                        AND a.SOCIAL_CITY = #{tPreDispatchInfo.socialCity}
                    </if>
                    <if test="tPreDispatchInfo.socialTown != null and tPreDispatchInfo.socialTown.trim() != ''">
                        AND a.SOCIAL_TOWN = #{tPreDispatchInfo.socialTown}
                    </if>
                    <if test="tPreDispatchInfo.fundProvince != null and tPreDispatchInfo.fundProvince.trim() != ''">
                        AND a.FUND_PROVINCE = #{tPreDispatchInfo.fundProvince}
                    </if>
                    <if test="tPreDispatchInfo.fundCity != null and tPreDispatchInfo.fundCity.trim() != ''">
                        AND a.FUND_CITY = #{tPreDispatchInfo.fundCity}
                    </if>
                    <if test="tPreDispatchInfo.fundTown != null and tPreDispatchInfo.fundTown.trim() != ''">
                        AND a.FUND_TOWN = #{tPreDispatchInfo.fundTown}
                    </if>
                    <if test="tPreDispatchInfo.dayLimit != null">
                        AND a.DAY_LIMIT = #{tPreDispatchInfo.dayLimit}
                    </if>
                    <if test="tPreDispatchInfo.dataSubStatus != null and tPreDispatchInfo.dataSubStatus.trim() != ''">
                        AND a.DATA_SUB_STATUS = #{tPreDispatchInfo.dataSubStatus}
                    </if>
                    <if test="tPreDispatchInfo.positionAdd != null and tPreDispatchInfo.positionAdd.trim() != ''">
                        AND a.POSITION_ADD = #{tPreDispatchInfo.positionAdd}
                    </if>
                    <if test="tPreDispatchInfo.contractNameAdd != null and tPreDispatchInfo.contractNameAdd.trim() != ''">
                        AND a.CONTRACT_NAME_ADD = #{tPreDispatchInfo.contractNameAdd}
                    </if>
                    <if test="tPreDispatchInfo.contractTypeAdd != null and tPreDispatchInfo.contractTypeAdd.trim() != ''">
                        AND a.CONTRACT_TYPE_ADD = #{tPreDispatchInfo.contractTypeAdd}
                    </if>
                    <if test="tPreDispatchInfo.contractStartAdd != null and tPreDispatchInfo.contractStartAdd.trim() != ''">
                        AND a.CONTRACT_START_ADD = #{tPreDispatchInfo.contractStartAdd}
                    </if>
                    <if test="tPreDispatchInfo.contractEndAdd != null and tPreDispatchInfo.contractEndAdd.trim() != ''">
                        AND a.CONTRACT_END_ADD = #{tPreDispatchInfo.contractEndAdd}
                    </if>
                    <if test="tPreDispatchInfo.contractTermAdd != null and tPreDispatchInfo.contractTermAdd.trim() != ''">
                        AND a.CONTRACT_TERM_ADD = #{tPreDispatchInfo.contractTermAdd}
                    </if>
                    <if test="tPreDispatchInfo.workingHoursAdd != null and tPreDispatchInfo.workingHoursAdd.trim() != ''">
                        AND a.WORKING_HOURS_ADD = #{tPreDispatchInfo.workingHoursAdd}
                    </if>
                    <if test="tPreDispatchInfo.leaveReasonAdd != null and tPreDispatchInfo.leaveReasonAdd.trim() != ''">
                        AND a.LEAVE_REASON_ADD = #{tPreDispatchInfo.leaveReasonAdd}
                    </if>
                    <if test="tPreDispatchInfo.remark != null and tPreDispatchInfo.remark.trim() != ''">
                        AND a.REMARK = #{tPreDispatchInfo.remark}
                    </if>
                    <if test="tPreDispatchInfo.dispatchFlag != null and tPreDispatchInfo.dispatchFlag.trim() != ''">
                        AND a.DISPATCH_FLAG = #{tPreDispatchInfo.dispatchFlag}
                    </if>
                    <if test="tPreDispatchInfo.cancelRemark != null and tPreDispatchInfo.cancelRemark.trim() != ''">
                        AND a.CANCEL_REMARK = #{tPreDispatchInfo.cancelRemark}
                    </if>
                    <if test="tPreDispatchInfo.userDeptName != null and tPreDispatchInfo.userDeptName.trim() != ''">
                        AND a.USER_DEPT_NAME = #{tPreDispatchInfo.userDeptName}
                    </if>
                    <if test="tPreDispatchInfo.createBy != null and tPreDispatchInfo.createBy.trim() != ''">
                        AND a.CREATE_BY = #{tPreDispatchInfo.createBy}
                    </if>
                    <if test="tPreDispatchInfo.updateBy != null and tPreDispatchInfo.updateBy.trim() != ''">
                        AND a.UPDATE_BY = #{tPreDispatchInfo.updateBy}
                    </if>
                    <if test="tPreDispatchInfo.createName != null and tPreDispatchInfo.createName.trim() != ''">
                        AND a.CREATE_NAME = #{tPreDispatchInfo.createName}
                    </if>
					<if test="tPreDispatchInfo.createTimeEnd != null" >
						AND a.CREATE_TIME <![CDATA[<=]]> #{tPreDispatchInfo.createTimeEnd}
					</if>
					<if test="tPreDispatchInfo.createTimeStart != null">
						AND a.CREATE_TIME <![CDATA[>=]]> #{tPreDispatchInfo.createTimeStart}
					</if>
                    <if test="tPreDispatchInfo.updateTime != null">
                        AND a.UPDATE_TIME = #{tPreDispatchInfo.updateTime}
                    </if>
					<if test="tPreDispatchInfo.authSql != null and tPreDispatchInfo.authSql.trim() != ''">
						${tPreDispatchInfo.authSql}
					</if>
		</if>
        </if>
    </sql>
    <!--tPreDispatchInfo简单分页查询-->
    <select id="getTPreDispatchInfoPage" resultMap="tPreDispatchInfoMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM t_pre_dispatch_info a
        <where>
            1=1
            <include refid="tPreDispatchInfo_where"/>
        </where>
		ORDER BY a.CREATE_TIME desc
    </select>
	<!--tPreDispatchInfo无分页查询-->
	<select id="getListForExport" resultMap="tPreDispatchExportMap">
		SELECT
		<include refid="Base_Column_List"/>
		FROM t_pre_dispatch_info a
		<where>
			1=1
			<include refid="tPreDispatchInfo_where"/>
		</where>
	</select>
	<update id="updatePreDispatchInfoById" parameterType="com.yifu.cloud.plus.v1.yifu.social.entity.TPreDispatchInfo">
		update t_pre_dispatch_info
		<trim prefix="SET" suffixOverrides=",">
			<if test="date != null ">date = #{date},</if>
			<if test="company != null">company = #{company},</if>
			<if test="payAddress != null">pay_address = #{payAddress},</if>
			<if test="customerName != null">customer_name = #{customerName},</if>
			<if test="empName != null">emp_name = #{empName},</if>
			<if test="empIdcard != null">emp_idcard = #{empIdcard},</if>
			<if test="telOne != null">tel_one = #{telOne},</if>
			<if test="telTwo != null">tel_two = #{telTwo},</if>
			<if test="entryDate != null ">entry_date = #{entryDate},</if>
			<if test="formalSalary != null">formal_salary = #{formalSalary},</if>
			<if test="dispatchStart != null">dispatch_start = #{dispatchStart},</if>
			<if test="dispatchEnd != null">dispatch_end = #{dispatchEnd},</if>
			<if test="contractType != null">contract_type = #{contractType},</if>
			<if test="contractStart != null">contract_start = #{contractStart},</if>
			<if test="contractEnd != null">contract_end = #{contractEnd},</if>
			<if test="contractNameAdd != null">
				contract_name_add = #{contractNameAdd},
			</if>
			<if test="contractTypeAdd != null">
				contract_type_add = #{contractTypeAdd},
			</if>
			<if test="contractTypeAdd != null">
				contract_type_add = #{contractTypeAdd},
			</if>
			<if test="changeContractAndEmployee != null">
				CHANGE_CONTRACT_AND_EMPLOYEE = #{changeContractAndEmployee},
			</if>
			<if test="contractStartAdd != null">
				CONTRACT_START_ADD = #{contractStartAdd},
			</if>
			<if test="contractEndAdd != null">
				contract_end_add = #{contractEndAdd},
			</if>
			<if test="contractTermAdd != null">
				contract_term_add = #{contractTermAdd},
			</if>
			<if test="contractNameAdd == null  or contractNameAdd == ''">
				contract_name_add = null,
			</if>
			<if test="contractTypeAdd == null  or contractTypeAdd == ''">
				contract_type_add = null,
			</if>
			<if test="contractStartAdd == null  or contractStartAdd == ''">
				contract_start_add = null,
			</if>
			<if test="contractEndAdd == null  or contractEndAdd == ''">
				contract_end_add = null,
			</if>
			<if test="contractTermAdd == null  or contractTermAdd == ''">
				contract_term_add = null,
			</if>
			<if test="trialStart != null">trial_start = #{trialStart},</if>
			<if test="trialEnd != null">trial_end = #{trialEnd},</if>
			<if test="trialSalary != null">trial_salary = #{trialSalary},</if>
			<if test="workingSystem != null">working_system = #{workingSystem},</if>
			<if test="contractVersion != null">contract_version = #{contractVersion},</if>
			<if test="telNotice != null">tel_notice = #{telNotice},</if>
			<if test="workingAddress != null">working_address = #{workingAddress},</if>
			<if test="remarkOne != null">remark_one = #{remarkOne},</if>
			<if test="remarkTwo != null">remark_two = #{remarkTwo},</if>
			<if test='type == "0"'>
				<if test="pensionAddress != null">
					pension_address = #{pensionAddress},
					<if test="socialProvince != null">social_province = #{socialProvince},</if>
					<if test="socialCity != null">social_city = #{socialCity},</if>
					<if test="socialTown != null">social_town = #{socialTown},</if>
				</if>
				<if test='pensionAddress == null || pensionAddress == ""'>
					pension_address = null,
					social_province = null,
					social_city = null,
					social_town = null,
				</if>
				<if test="fundAddress != null">
					fund_address = #{fundAddress},
					<if test="fundProvince != null">
						fund_province = #{fundProvince},
						<if test="fundCity == null">fund_city = null,</if>
						<if test="fundTown == null">fund_town = null,</if>
					</if>
					<if test="fundCity != null">fund_city = #{fundCity},</if>
					<if test="fundTown != null">fund_town = #{fundTown},</if>
				</if>
				<if test='fundAddress == null || fundAddress == ""'>
					fund_address = null,
					fund_province = null,
					fund_city = null,
					fund_town = null,
				</if>
			</if>
			<if test='type == "1"'>
				<if test="pensionAddressReduce != null">
					pension_address_reduce = #{pensionAddressReduce},
					pension_address = #{pensionAddressReduce},
					<if test="socialProvince != null">social_province = #{socialProvince},</if>
					<if test="socialCity != null">social_city = #{socialCity},</if>
					<if test="socialTown != null">social_town = #{socialTown},</if>
				</if>
				<if test='pensionAddressReduce == null || pensionAddressReduce ==""'>
					pension_address_reduce = null,
					pension_end_reduce = null,
					pension_address = null,
					social_province = null,
					social_city = null,
					social_town = null,
				</if>
				<if test="fundAddressReduce != null">
					fund_address_reduce = #{fundAddressReduce},
					fund_address = #{fundAddressReduce},
					<if test="fundProvince != null">
						fund_province = #{fundProvince},
						<if test="fundCity == null">fund_city = null,</if>
						<if test="fundTown == null">fund_town = null,</if>
					</if>
					<if test="fundCity != null">fund_city = #{fundCity},</if>
					<if test="fundTown != null">fund_town = #{fundTown},</if>
				</if>
				<if test='fundAddressReduce == null || fundAddressReduce == ""'>
					fund_address_reduce = null,
					fund_address = null,
					fund_end_reduce = null,
					fund_province = null,
					fund_city = null,
					fund_town = null,
				</if>
			</if>
			<if test="pensionBase != null ">pension_base = #{pensionBase},</if>
			<if test="pensionStart != null">pension_start = #{pensionStart},</if>
			<if test="medicalAddress != null">medical_address = #{medicalAddress},</if>
			<if test="medicalBase != null ">medical_base = #{medicalBase},</if>
			<if test="medicalStart != null">medical_start = #{medicalStart},</if>
			<if test="injuryAddress != null ">injury_address = #{injuryAddress},</if>
			<if test="injuryBase != null ">injury_base = #{injuryBase},</if>
			<if test="injuryStart != null">injury_start = #{injuryStart},</if>
			<if test="birthAddress != null">birth_address = #{birthAddress},</if>
			<if test="birthBase != null ">birth_base = #{birthBase},</if>
			<if test="birthStart != null">birth_start = #{birthStart},</if>
			<if test="unemploymentAddress != null">unemployment_address = #{unemploymentAddress},</if>
			<if test="unemploymentBase != null ">unemployment_base = #{unemploymentBase},</if>
			<if test="unemploymentStart != null">unemployment_start = #{unemploymentStart},</if>
			<if test="pensionBase == null ">pension_base = null,</if>
			<if test="pensionStart == null">pension_start = null,</if>
			<if test="medicalAddress == null  or medicalAddress == ''">medical_address = null,</if>
			<if test="medicalBase == null ">medical_base = null,</if>
			<if test="medicalStart == null">medical_start = null,</if>
			<if test="injuryAddress == null or injuryAddress == ''">injury_address = null,</if>
			<if test="injuryBase == null ">injury_base = null,</if>
			<if test="injuryStart == null">injury_start = null,</if>
			<if test="birthAddress == null or birthAddress == ''">birth_address = null,</if>
			<if test="birthBase == null ">birth_base = null,</if>
			<if test="birthStart == null">birth_start = null,</if>
			<if test="unemploymentAddress == null or unemploymentAddress == ''">unemployment_address = null,</if>
			<if test="unemploymentBase == null ">unemployment_base = null,</if>
			<if test="unemploymentStart == null">unemployment_start = null,</if>
			<if test="fundBase != null ">fund_base = #{fundBase},</if>
			<if test="fundStart != null">fund_start = #{fundStart},</if>
			<if test="fundPersonalPer != null ">fund_personal_per = #{fundPersonalPer},</if>
			<if test="fundCompanyPer != null ">fund_company_per = #{fundCompanyPer},</if>
			<if test="fundBase == null ">fund_base = null,</if>
			<if test="fundStart == null">fund_start = null,</if>
			<if test="fundPersonalPer == null ">fund_personal_per = null,</if>
			<if test="fundCompanyPer == null ">fund_company_per = null,</if>
			<if test="dispatchCompany != null">dispatch_company = #{dispatchCompany},</if>
			<if test="customerService != null">customer_service = #{customerService},</if>
			<if test="contractMinorName != null">contract_minor_name = #{contractMinorName},</if>
			<if test="uniqueNumber != null">unique_number = #{uniqueNumber},</if>
			<if test="customerNumber != null">customer_number = #{customerNumber},</if>
			<if test="serviceType != null">service_type = #{serviceType},</if>
			<if test="pensionEndReduce != null">pension_end_reduce = #{pensionEndReduce},</if>
			<if test="medicalAddressReduce != null">medical_address_reduce = #{medicalAddressReduce},</if>
			<if test="medicalEndReduce != null">medical_end_reduce = #{medicalEndReduce},</if>
			<if test="injuryAddressReduce != null">injury_address_reduce = #{injuryAddressReduce},</if>
			<if test="injuryEndReduce != null">injury_end_reduce = #{injuryEndReduce},</if>
			<if test="birthAddressReduce != null">birth_address_reduce = #{birthAddressReduce},</if>
			<if test="birthEndReduce != null">birth_end_reduce = #{birthEndReduce},</if>
			<if test="unemploymentAddressReduce != null">unemployment_address_reduce = #{unemploymentAddressReduce},</if>
			<if test="unemploymentEndReduce != null">unemployment_end_reduce = #{unemploymentEndReduce},</if>
			<if test="fundEndReduce != null">fund_end_reduce = #{fundEndReduce},</if>
			<if test="leaveDate != null ">leave_date = #{leaveDate},</if>
			<if test="leaveReason != null">leave_reason = #{leaveReason},</if>
			<if test="leaveReasonAdd != null">leave_reason_add = #{leaveReasonAdd},</if>
			<if test="empTypeAdd != null">emp_type_add = #{empTypeAdd},</if>
			<if test="unitIdAdd != null">unit_id_add = #{unitIdAdd},</if>
			<if test="departIdAdd != null">depart_id_add = #{departIdAdd},</if>
			<if test="unitNameAdd != null">unit_name_add = #{unitNameAdd},</if>
			<if test="departNameAdd != null">depart_name_add = #{departNameAdd},</if>
			<if test="socialHouseAdd != null">social_house_add = #{socialHouseAdd},</if>
			<if test="fundHouseAdd != null">fund_house_add = #{fundHouseAdd},</if>
			<if test="filingBaseAdd != null ">filing_base_add = #{filingBaseAdd},</if>
			<if test="preStatus != null">pre_status = #{preStatus},</if>
			<if test="status != null">status = #{status},</if>
			<if test="exceptionContent != null">exception_content = #{exceptionContent},</if>
			<if test="dayLimit != null ">day_limit = #{dayLimit},</if>
			<if test="dataSubStatus != null">data_sub_status = #{dataSubStatus},</if>
			<if test="remark != null">remark = #{remark},</if>
			<if test="dispatchFlag != null">dispatch_flag = #{dispatchFlag},</if>
			<if test="cancelRemark != null">cancel_remark = #{cancelRemark},</if>
		</trim>
		where id = #{id}
	</update>

	<!-- 批量更新资料提交状态-->
	<update id="modifyDataSubmitStatus">
		update t_pre_dispatch_info
		SET data_sub_status = #{status}
		WHERE
		<!--指定ID数据-->
		<if test="idList != null and idList.size() > 0">
			id in
			<foreach collection="idList" item="item" open="(" separator="," close=")">
				#{item}
			</foreach>
		</if>
	</update>

	<!-- 批量清空资料提交状态-->
	<update id="clearContractInfo">
		<!--指定ID数据-->
		<if test="idList != null and idList.size() > 0">
			update t_pre_dispatch_info
			SET
			contract_name_add = null,
			contract_type_add = null,
			contract_start_add = null,
			contract_end_add = null,
			contract_term_add = null
			WHERE
			id in
			<foreach collection="idList" item="item" open="(" separator="," close=")">
				#{item}
			</foreach>
		</if>
	</update>
	<update id="updatePreStatusById" parameterType="com.yifu.cloud.plus.v1.yifu.social.entity.TPreDispatchInfo">
		update t_pre_dispatch_info
		<trim prefix="SET" suffixOverrides=",">
			<if test="preStatus != null  and preStatus != ''">pre_status = #{preStatus},</if>
			<if test="status != null  and status != ''">status = #{status},</if>
			<if test="exceptionContent != null">exception_content = #{exceptionContent},</if>
		</trim>
		where id = #{id}
	</update>
	<resultMap id="tPreDispatchExportMap" type="com.yifu.cloud.plus.v1.yifu.social.vo.TPreDispatchExportVo">
		<result property="type" column="type"/>
		<result property="date" column="date"/>
		<result property="company" column="company"/>
		<result property="payAddress" column="pay_address"/>
		<result property="customerName" column="customer_name"/>
		<result property="empIdcard" column="emp_idcard"/>
		<result property="empName" column="emp_name"/>
		<result property="entryDate" column="entry_date"/>
		<result property="formalSalary" column="formal_salary"/>
		<result property="dispatchStart" column="dispatch_start"/>
		<result property="dispatchEnd" column="dispatch_end"/>
		<result property="contractStart" column="contract_start"/>
		<result property="contractEnd" column="contract_end"/>
		<result property="trialStart" column="trial_start"/>
		<result property="trialEnd" column="trial_end"/>
		<result property="trialSalary" column="trial_salary"/>
		<result property="workingSystem" column="working_system"/>
		<result property="contractVersion" column="contract_version"/>
		<result property="telNotice" column="tel_notice"/>
		<result property="workingAddress" column="working_address"/>
		<result property="pensionAddress" column="pension_address"/>
		<result property="pensionBase" column="pension_base"/>
		<result property="pensionStart" column="pension_start"/>
		<result property="medicalAddress" column="medical_address"/>
		<result property="medicalBase" column="medical_base"/>
		<result property="medicalStart" column="medical_start"/>
		<result property="injuryAddress" column="injury_address"/>
		<result property="injuryBase" column="injury_base"/>
		<result property="injuryStart" column="injury_start"/>
		<result property="birthAddress" column="birth_address"/>
		<result property="birthBase" column="birth_base"/>
		<result property="birthStart" column="birth_start"/>
		<result property="unemploymentAddress" column="unemployment_address"/>
		<result property="unemploymentBase" column="unemployment_base"/>
		<result property="unemploymentStart" column="unemployment_start"/>
		<result property="fundAddress" column="fund_address"/>
		<result property="fundBase" column="fund_base"/>
		<result property="fundStart" column="fund_start"/>
		<result property="fundPersonalPer" column="fund_personal_per"/>
		<result property="fundCompanyPer" column="fund_company_per"/>
		<result property="dispatchCompany" column="dispatch_company"/>
		<result property="customerService" column="customer_service"/>
		<result property="contractMinorName" column="contract_minor_name"/>
		<result property="uniqueNumber" column="unique_number"/>
		<result property="customerNumber" column="customer_number"/>
		<result property="serviceType" column="service_type"/>
		<result property="pensionAddressReduce" column="pension_address_reduce"/>
		<result property="pensionEndReduce" column="pension_end_reduce"/>
		<result property="medicalAddressReduce" column="medical_address_reduce"/>
		<result property="medicalEndReduce" column="medical_end_reduce"/>
		<result property="injuryAddressReduce" column="injury_address_reduce"/>
		<result property="injuryEndReduce" column="injury_end_reduce"/>
		<result property="birthAddressReduce" column="birth_address_reduce"/>
		<result property="birthEndReduce" column="birth_end_reduce"/>
		<result property="unemploymentAddressReduce" column="unemployment_address_reduce"/>
		<result property="unemploymentEndReduce" column="unemployment_end_reduce"/>
		<result property="fundAddressReduce" column="fund_address_reduce"/>
		<result property="fundEndReduce" column="fund_end_reduce"/>
		<result property="leaveDate" column="leave_date"/>
		<result property="leaveReason" column="leave_reason"/>
		<result property="contractType" column="contract_type"/>
		<result property="unitNameAdd" column="unit_name_add"/>
		<result property="departNameAdd" column="depart_name_add"/>
		<result property="filingBaseAdd" column="filing_base_add"/>
		<result property="preStatus" column="pre_status"/>
		<result property="status" column="status"/>
		<result property="exceptionContent" column="exception_content"/>
		<result property="dayLimit" column="day_limit"/>
		<result property="dataSubStatus" column="data_sub_status"/>
		<result property="telOne" column="tel_one"/>
		<result property="telTwo" column="tel_two"/>
		<result property="contractNameAdd" column="contract_name_add"/>
		<result property="remarkOne" column="remark_one"/>
		<result property="remarkTwo" column="remark_two"/>
		<result property="dispatchFlag" column="dispatch_flag"/>
		<result property="cancelRemark" column="cancel_remark"/>
	</resultMap>
</mapper>
