优化

fwq

2023-12-27 6e80249f1b01348f4a10909f3e95fbb3e30bbd01

优化

 phi_platform_common/src/main/resources/mapper/platform/DeductionSingleMapper.xml

@@ -8,7 +8,7 @@
    <!-- 整个实体类修改，表字段=实体类字段-->
    <sql id="Update_Column_All">
        <trim prefixOverrides=",">
            ,recordNo = #{recordNo},sealStatus = #{sealStatus},hisId = #{hisId},userId = #{userId},shopId = #{shopId},shopName = #{shopName},type = #{type},commonId = #{commonId},treatSingleId = #{treatSingleId},appId = #{appId},appIdCode = #{appIdCode},sourceCode = #{sourceCode},sourceName = #{sourceName},status = #{status},rescindedTime = #{rescindedTime},cancelTime = #{cancelTime},remarkInfo = #{remarkInfo},operatorId = #{operatorId},operatorName = #{operatorName},isCustomerConfirm = #{isCustomerConfirm},receptionConsultantId = #{receptionConsultantId},receptionConsultantName = #{receptionConsultantName},CIQ = #{CIQ},memberNo = #{memberNo},caseNo = #{caseNo},userShopId = #{userShopId},userShopNo = #{userShopNo},userShopName = #{userShopName},belongConsultantId = #{belongConsultantId},belongConsultantName = #{belongConsultantName},belongDoctorId = #{belongDoctorId},belongDoctorName = #{belongDoctorName},belongTMKId = #{belongTMKId},belongTMKName = #{belongTMKName},belongNurseId = #{belongNurseId},belongNurseName = #{belongNurseName},memberLevelId = #{memberLevelId},memberLevelName = #{memberLevelName},userStatus = #{userStatus},actualConsumablesCost = #{actualConsumablesCost},standardConsumablesCost = #{standardConsumablesCost},partType = #{partType},orderClassify = #{orderClassify},channelCategory = #{channelCategory},channelId = #{channelId},channelName = #{channelName},channel2Id = #{channel2Id},channel2Name = #{channel2Name},channel2Json = #{channel2Json},channelAssistId = #{channelAssistId},channelAssistName = #{channelAssistName},channelAssist2Id = #{channelAssist2Id},channelAssist2Name = #{channelAssist2Name},channelAssist2Json = #{channelAssist2Json},isDel = #{isDel},createTime = #{createTime},editTime = #{editTime}
            ,recordNo = #{recordNo},sealStatus = #{sealStatus},hisId = #{hisId},userId = #{userId},shopId = #{shopId},shopName = #{shopName},type = #{type},commonId = #{commonId},treatSingleId = #{treatSingleId},appId = #{appId},appIdCode = #{appIdCode},sourceCode = #{sourceCode},sourceName = #{sourceName},status = #{status},rescindedTime = #{rescindedTime},cancelTime = #{cancelTime},remarkInfo = #{remarkInfo},operatorId = #{operatorId},operatorName = #{operatorName},isCustomerConfirm = #{isCustomerConfirm},receptionConsultantId = #{receptionConsultantId},receptionConsultantName = #{receptionConsultantName},CIQ = #{CIQ},memberNo = #{memberNo},caseNo = #{caseNo},userShopId = #{userShopId},userShopNo = #{userShopNo},userShopName = #{userShopName},belongConsultantId = #{belongConsultantId},belongConsultantName = #{belongConsultantName},belongDoctorId = #{belongDoctorId},belongDoctorName = #{belongDoctorName},belongTMKId = #{belongTMKId},belongTMKName = #{belongTMKName},belongNurseId = #{belongNurseId},belongNurseName = #{belongNurseName},memberLevelId = #{memberLevelId},memberLevelName = #{memberLevelName},userStatus = #{userStatus},actualConsumablesCost = #{actualConsumablesCost},standardConsumablesCost = #{standardConsumablesCost},partType = #{partType},orderClassify = #{orderClassify},channelCategory = #{channelCategory},channelId = #{channelId},channelName = #{channelName},channel2Id = #{channel2Id},channel2Name = #{channel2Name},channel2Json = #{channel2Json},channelAssistId = #{channelAssistId},channelAssistName = #{channelAssistName},channelAssist2Id = #{channelAssist2Id},channelAssist2Name = #{channelAssist2Name},channelAssist2Json = #{channelAssist2Json},relationType = #{relationType},relationId = #{relationId},relationName = #{relationName},isDel = #{isDel},createTime = #{createTime},editTime = #{editTime}
        </trim>
    </sql>
     
@@ -19,11 +19,11 @@
        <selectKey keyProperty="id" resultType="String" order="BEFORE">
               select replace(uuid(),'-','') from dual
        </selectKey>
        insert into deduction_single (id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,isDel,createTime,editTime)  values (#{id},#{recordNo},#{sealStatus},#{hisId},#{userId},#{shopId},#{shopName},#{type},#{commonId},#{treatSingleId},#{appId},#{appIdCode},#{sourceCode},#{sourceName},#{status},#{rescindedTime},#{cancelTime},#{remarkInfo},#{operatorId},#{operatorName},#{isCustomerConfirm},#{receptionConsultantId},#{receptionConsultantName},#{CIQ},#{memberNo},#{caseNo},#{userShopId},#{userShopNo},#{userShopName},#{belongConsultantId},#{belongConsultantName},#{belongDoctorId},#{belongDoctorName},#{belongTMKId},#{belongTMKName},#{belongNurseId},#{belongNurseName},#{memberLevelId},#{memberLevelName},#{userStatus},#{actualConsumablesCost},#{standardConsumablesCost},#{partType},#{orderClassify},#{channelCategory},#{channelId},#{channelName},#{channel2Id},#{channel2Name},#{channel2Json},#{channelAssistId},#{channelAssistName},#{channelAssist2Id},#{channelAssist2Name},#{channelAssist2Json},#{isDel},#{createTime},#{editTime})
        insert into deduction_single (id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,relationType,relationId,relationName,isDel,createTime,editTime)  values (#{id},#{recordNo},#{sealStatus},#{hisId},#{userId},#{shopId},#{shopName},#{type},#{commonId},#{treatSingleId},#{appId},#{appIdCode},#{sourceCode},#{sourceName},#{status},#{rescindedTime},#{cancelTime},#{remarkInfo},#{operatorId},#{operatorName},#{isCustomerConfirm},#{receptionConsultantId},#{receptionConsultantName},#{CIQ},#{memberNo},#{caseNo},#{userShopId},#{userShopNo},#{userShopName},#{belongConsultantId},#{belongConsultantName},#{belongDoctorId},#{belongDoctorName},#{belongTMKId},#{belongTMKName},#{belongNurseId},#{belongNurseName},#{memberLevelId},#{memberLevelName},#{userStatus},#{actualConsumablesCost},#{standardConsumablesCost},#{partType},#{orderClassify},#{channelCategory},#{channelId},#{channelName},#{channel2Id},#{channel2Name},#{channel2Json},#{channelAssistId},#{channelAssistName},#{channelAssist2Id},#{channelAssist2Name},#{channelAssist2Json},#{relationType},#{relationId},#{relationName},#{isDel},#{createTime},#{editTime})
    </insert>

    <insert id="insertById" parameterType="com.hx.phiappt.model.deduction.DeductionSingle">
        insert into deduction_single (id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,isDel,createTime,editTime)  values (#{id},#{recordNo},#{sealStatus},#{hisId},#{userId},#{shopId},#{shopName},#{type},#{commonId},#{treatSingleId},#{appId},#{appIdCode},#{sourceCode},#{sourceName},#{status},#{rescindedTime},#{cancelTime},#{remarkInfo},#{operatorId},#{operatorName},#{isCustomerConfirm},#{receptionConsultantId},#{receptionConsultantName},#{CIQ},#{memberNo},#{caseNo},#{userShopId},#{userShopNo},#{userShopName},#{belongConsultantId},#{belongConsultantName},#{belongDoctorId},#{belongDoctorName},#{belongTMKId},#{belongTMKName},#{belongNurseId},#{belongNurseName},#{memberLevelId},#{memberLevelName},#{userStatus},#{actualConsumablesCost},#{standardConsumablesCost},#{partType},#{orderClassify},#{channelCategory},#{channelId},#{channelName},#{channel2Id},#{channel2Name},#{channel2Json},#{channelAssistId},#{channelAssistName},#{channelAssist2Id},#{channelAssist2Name},#{channelAssist2Json},#{isDel},#{createTime},#{editTime})
        insert into deduction_single (id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,relationType,relationId,relationName,isDel,createTime,editTime)  values (#{id},#{recordNo},#{sealStatus},#{hisId},#{userId},#{shopId},#{shopName},#{type},#{commonId},#{treatSingleId},#{appId},#{appIdCode},#{sourceCode},#{sourceName},#{status},#{rescindedTime},#{cancelTime},#{remarkInfo},#{operatorId},#{operatorName},#{isCustomerConfirm},#{receptionConsultantId},#{receptionConsultantName},#{CIQ},#{memberNo},#{caseNo},#{userShopId},#{userShopNo},#{userShopName},#{belongConsultantId},#{belongConsultantName},#{belongDoctorId},#{belongDoctorName},#{belongTMKId},#{belongTMKName},#{belongNurseId},#{belongNurseName},#{memberLevelId},#{memberLevelName},#{userStatus},#{actualConsumablesCost},#{standardConsumablesCost},#{partType},#{orderClassify},#{channelCategory},#{channelId},#{channelName},#{channel2Id},#{channel2Name},#{channel2Json},#{channelAssistId},#{channelAssistName},#{channelAssist2Id},#{channelAssist2Name},#{channelAssist2Json},#{relationType},#{relationId},#{relationName},#{isDel},#{createTime},#{editTime})
    </insert>

    <select id="selectList" resultType="com.hx.phiappt.model.deduction.DeductionSingle" parameterType="com.hx.mybatisTool.SqlSentence" >
@@ -55,14 +55,14 @@

    <select id="selectOneByKey" resultType="com.hx.phiappt.model.deduction.DeductionSingle" parameterType="java.lang.Object" >
        select 
            id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,isDel,createTime,editTime
            id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,relationType,relationId,relationName,isDel,createTime,editTime
        from deduction_single
        WHERE id = #{value}
    </select>

    <select id="selectOneByKeyBlob" resultType="com.hx.phiappt.model.deduction.DeductionSingle" parameterType="java.lang.Object" >
        select 
            id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,isDel,createTime,editTime
            id,recordNo,sealStatus,hisId,userId,shopId,shopName,type,commonId,treatSingleId,appId,appIdCode,sourceCode,sourceName,status,rescindedTime,cancelTime,remarkInfo,operatorId,operatorName,isCustomerConfirm,receptionConsultantId,receptionConsultantName,CIQ,memberNo,caseNo,userShopId,userShopNo,userShopName,belongConsultantId,belongConsultantName,belongDoctorId,belongDoctorName,belongTMKId,belongTMKName,belongNurseId,belongNurseName,memberLevelId,memberLevelName,userStatus,actualConsumablesCost,standardConsumablesCost,partType,orderClassify,channelCategory,channelId,channelName,channel2Id,channel2Name,channel2Json,channelAssistId,channelAssistName,channelAssist2Id,channelAssist2Name,channelAssist2Json,relationType,relationId,relationName,isDel,createTime,editTime
        from deduction_single
        WHERE id = #{value}
    </select>