生成mapper

fwq

2023-12-14 e87c1514680365416d3b9702c422472b791ac43b

生成mapper

 phi_platform_common/src/main/java/com/hx/phip/tool/AppealTypeTool.java

@@ -99,7 +99,6 @@
     * 此方法只支持一二三级都只是一个的
     * */
    public static String getStr(List<AppealTypeVo> appealTypeVoList) {

        //父级标识
        String parenId = "";
        //二级名称拼接
@@ -120,7 +119,6 @@
                parentMap.put(appealTypeVo.getParentId(),appealTypeVo);
            }
        }

        //二级
        AppealTypeVo secondVo = parentMap.get(parenId);
        if (secondVo != null){
@@ -133,9 +131,6 @@
            //三级
            AppealTypeVo thirdVo = parentMap.get(secondVo.getId());
            if (thirdVo != null){
                if (towName.length() > 0){
                    towName.append("/").append(thirdVo.getName());
                }
                if (threeName.length() > 0){
                    threeName.append("/").append(thirdVo.getName());
                }

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

@@ -8,7 +8,7 @@
    <!-- 整个实体类修改，表字段=实体类字段-->
    <sql id="Update_Column_All">
        <trim prefixOverrides=",">
            ,orderNo = #{orderNo},performId = #{performId},orderId = #{orderId},commonItemId = #{commonItemId},remarks = #{remarks},userCardId = #{userCardId},commonId = #{commonId},platformType = #{platformType},platformTypeId = #{platformTypeId},platformTypeName = #{platformTypeName},type = #{type},goodsNo = #{goodsNo},goodsName = #{goodsName},goodsImage = #{goodsImage},specs = #{specs},single = #{single},isLimitBug = #{isLimitBug},bodyPartsId = #{bodyPartsId},bodyPartsName = #{bodyPartsName},specsName = #{specsName},aptitudeNo = #{aptitudeNo},aptitudeName = #{aptitudeName},doctorQualification = #{doctorQualification},oriPrice = #{oriPrice},proPrice = #{proPrice},discount = #{discount},curPrice = #{curPrice},buyNum = #{buyNum},total = #{total},actualTotal = #{actualTotal},userPaidTotal = #{userPaidTotal},noDeductionAmount = #{noDeductionAmount},payTotal = #{payTotal},payRecharge = #{payRecharge},payIncrement = #{payIncrement},snapPayTotal = #{snapPayTotal},discountPrice = #{discountPrice},activityPrice = #{activityPrice},discountOrderPrice = #{discountOrderPrice},discountIntegral = #{discountIntegral},originalIntegral = #{originalIntegral},proIntegral = #{proIntegral},sellPoints = #{sellPoints},oriIntegralTotal = #{oriIntegralTotal},proIntegralTotal = #{proIntegralTotal},totalPoints = #{totalPoints},shouldTotalPoints = #{shouldTotalPoints},actualTotalPoints = #{actualTotalPoints},hasReNum = #{hasReNum},reTotal = #{reTotal},reIntegralTotal = #{reIntegralTotal},reCashTotal = #{reCashTotal},reCashPurenessTotal = #{reCashPurenessTotal},reRechargeTotal = #{reRechargeTotal},reIncrementTotal = #{reIncrementTotal},usedTotal = #{usedTotal},payStatus = #{payStatus},refundStatus = #{refundStatus},isSpa = #{isSpa},transferIntoShopId = #{transferIntoShopId},transferIntoShopName = #{transferIntoShopName},isTransfer = #{isTransfer},isTurn = #{isTurn},isDel = #{isDel},createTime = #{createTime},editTime = #{editTime}
            ,orderNo = #{orderNo},performId = #{performId},orderId = #{orderId},commonItemId = #{commonItemId},remarks = #{remarks},userCardId = #{userCardId},commonId = #{commonId},platformType = #{platformType},platformTypeId = #{platformTypeId},platformTypeName = #{platformTypeName},type = #{type},goodsNo = #{goodsNo},goodsName = #{goodsName},goodsImage = #{goodsImage},specs = #{specs},single = #{single},isLimitBug = #{isLimitBug},bodyPartsId = #{bodyPartsId},bodyPartsName = #{bodyPartsName},specsName = #{specsName},aptitudeNo = #{aptitudeNo},aptitudeName = #{aptitudeName},doctorQualification = #{doctorQualification},oriPrice = #{oriPrice},proPrice = #{proPrice},discount = #{discount},curPrice = #{curPrice},buyNum = #{buyNum},total = #{total},actualTotal = #{actualTotal},userPaidTotal = #{userPaidTotal},noDeductionAmount = #{noDeductionAmount},payTotal = #{payTotal},payRecharge = #{payRecharge},payIncrement = #{payIncrement},snapPayTotal = #{snapPayTotal},discountPrice = #{discountPrice},activityPrice = #{activityPrice},discountOrderPrice = #{discountOrderPrice},discountIntegral = #{discountIntegral},originalIntegral = #{originalIntegral},proIntegral = #{proIntegral},sellPoints = #{sellPoints},oriIntegralTotal = #{oriIntegralTotal},proIntegralTotal = #{proIntegralTotal},totalPoints = #{totalPoints},shouldTotalPoints = #{shouldTotalPoints},actualTotalPoints = #{actualTotalPoints},hasReNum = #{hasReNum},reTotal = #{reTotal},reIntegralTotal = #{reIntegralTotal},reCashTotal = #{reCashTotal},reCashPurenessTotal = #{reCashPurenessTotal},reRechargeTotal = #{reRechargeTotal},reIncrementTotal = #{reIncrementTotal},usedTotal = #{usedTotal},payStatus = #{payStatus},refundStatus = #{refundStatus},isSpa = #{isSpa},appealSecond = #{appealSecond},appealThird = #{appealThird},transferIntoShopId = #{transferIntoShopId},transferIntoShopName = #{transferIntoShopName},isTransfer = #{isTransfer},isTurn = #{isTurn},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 order_item (id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime)  values (#{id},#{orderNo},#{performId},#{orderId},#{commonItemId},#{remarks},#{userCardId},#{commonId},#{platformType},#{platformTypeId},#{platformTypeName},#{type},#{goodsNo},#{goodsName},#{goodsImage},#{specs},#{single},#{isLimitBug},#{bodyPartsId},#{bodyPartsName},#{specsName},#{aptitudeNo},#{aptitudeName},#{doctorQualification},#{oriPrice},#{proPrice},#{discount},#{curPrice},#{buyNum},#{total},#{actualTotal},#{userPaidTotal},#{noDeductionAmount},#{payTotal},#{payRecharge},#{payIncrement},#{snapPayTotal},#{discountPrice},#{activityPrice},#{discountOrderPrice},#{discountIntegral},#{originalIntegral},#{proIntegral},#{sellPoints},#{oriIntegralTotal},#{proIntegralTotal},#{totalPoints},#{shouldTotalPoints},#{actualTotalPoints},#{hasReNum},#{reTotal},#{reIntegralTotal},#{reCashTotal},#{reCashPurenessTotal},#{reRechargeTotal},#{reIncrementTotal},#{usedTotal},#{payStatus},#{refundStatus},#{isSpa},#{transferIntoShopId},#{transferIntoShopName},#{isTransfer},#{isTurn},#{isDel},#{createTime},#{editTime})
        insert into order_item (id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,appealSecond,appealThird,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime)  values (#{id},#{orderNo},#{performId},#{orderId},#{commonItemId},#{remarks},#{userCardId},#{commonId},#{platformType},#{platformTypeId},#{platformTypeName},#{type},#{goodsNo},#{goodsName},#{goodsImage},#{specs},#{single},#{isLimitBug},#{bodyPartsId},#{bodyPartsName},#{specsName},#{aptitudeNo},#{aptitudeName},#{doctorQualification},#{oriPrice},#{proPrice},#{discount},#{curPrice},#{buyNum},#{total},#{actualTotal},#{userPaidTotal},#{noDeductionAmount},#{payTotal},#{payRecharge},#{payIncrement},#{snapPayTotal},#{discountPrice},#{activityPrice},#{discountOrderPrice},#{discountIntegral},#{originalIntegral},#{proIntegral},#{sellPoints},#{oriIntegralTotal},#{proIntegralTotal},#{totalPoints},#{shouldTotalPoints},#{actualTotalPoints},#{hasReNum},#{reTotal},#{reIntegralTotal},#{reCashTotal},#{reCashPurenessTotal},#{reRechargeTotal},#{reIncrementTotal},#{usedTotal},#{payStatus},#{refundStatus},#{isSpa},#{appealSecond},#{appealThird},#{transferIntoShopId},#{transferIntoShopName},#{isTransfer},#{isTurn},#{isDel},#{createTime},#{editTime})
    </insert>

    <insert id="insertById" parameterType="com.hx.phiappt.model.order.OrderItem">
        insert into order_item (id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime)  values (#{id},#{orderNo},#{performId},#{orderId},#{commonItemId},#{remarks},#{userCardId},#{commonId},#{platformType},#{platformTypeId},#{platformTypeName},#{type},#{goodsNo},#{goodsName},#{goodsImage},#{specs},#{single},#{isLimitBug},#{bodyPartsId},#{bodyPartsName},#{specsName},#{aptitudeNo},#{aptitudeName},#{doctorQualification},#{oriPrice},#{proPrice},#{discount},#{curPrice},#{buyNum},#{total},#{actualTotal},#{userPaidTotal},#{noDeductionAmount},#{payTotal},#{payRecharge},#{payIncrement},#{snapPayTotal},#{discountPrice},#{activityPrice},#{discountOrderPrice},#{discountIntegral},#{originalIntegral},#{proIntegral},#{sellPoints},#{oriIntegralTotal},#{proIntegralTotal},#{totalPoints},#{shouldTotalPoints},#{actualTotalPoints},#{hasReNum},#{reTotal},#{reIntegralTotal},#{reCashTotal},#{reCashPurenessTotal},#{reRechargeTotal},#{reIncrementTotal},#{usedTotal},#{payStatus},#{refundStatus},#{isSpa},#{transferIntoShopId},#{transferIntoShopName},#{isTransfer},#{isTurn},#{isDel},#{createTime},#{editTime})
        insert into order_item (id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,appealSecond,appealThird,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime)  values (#{id},#{orderNo},#{performId},#{orderId},#{commonItemId},#{remarks},#{userCardId},#{commonId},#{platformType},#{platformTypeId},#{platformTypeName},#{type},#{goodsNo},#{goodsName},#{goodsImage},#{specs},#{single},#{isLimitBug},#{bodyPartsId},#{bodyPartsName},#{specsName},#{aptitudeNo},#{aptitudeName},#{doctorQualification},#{oriPrice},#{proPrice},#{discount},#{curPrice},#{buyNum},#{total},#{actualTotal},#{userPaidTotal},#{noDeductionAmount},#{payTotal},#{payRecharge},#{payIncrement},#{snapPayTotal},#{discountPrice},#{activityPrice},#{discountOrderPrice},#{discountIntegral},#{originalIntegral},#{proIntegral},#{sellPoints},#{oriIntegralTotal},#{proIntegralTotal},#{totalPoints},#{shouldTotalPoints},#{actualTotalPoints},#{hasReNum},#{reTotal},#{reIntegralTotal},#{reCashTotal},#{reCashPurenessTotal},#{reRechargeTotal},#{reIncrementTotal},#{usedTotal},#{payStatus},#{refundStatus},#{isSpa},#{appealSecond},#{appealThird},#{transferIntoShopId},#{transferIntoShopName},#{isTransfer},#{isTurn},#{isDel},#{createTime},#{editTime})
    </insert>

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

    <select id="selectOneByKey" resultType="com.hx.phiappt.model.order.OrderItem" parameterType="java.lang.Object" >
        select 
            id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime
            id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,appealSecond,appealThird,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime
        from order_item
        WHERE id = #{value}
    </select>

    <select id="selectOneByKeyBlob" resultType="com.hx.phiappt.model.order.OrderItem" parameterType="java.lang.Object" >
        select 
            id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime
            id,orderNo,performId,orderId,commonItemId,remarks,userCardId,commonId,platformType,platformTypeId,platformTypeName,type,goodsNo,goodsName,goodsImage,specs,single,isLimitBug,bodyPartsId,bodyPartsName,specsName,aptitudeNo,aptitudeName,doctorQualification,oriPrice,proPrice,discount,curPrice,buyNum,total,actualTotal,userPaidTotal,noDeductionAmount,payTotal,payRecharge,payIncrement,snapPayTotal,discountPrice,activityPrice,discountOrderPrice,discountIntegral,originalIntegral,proIntegral,sellPoints,oriIntegralTotal,proIntegralTotal,totalPoints,shouldTotalPoints,actualTotalPoints,hasReNum,reTotal,reIntegralTotal,reCashTotal,reCashPurenessTotal,reRechargeTotal,reIncrementTotal,usedTotal,payStatus,refundStatus,isSpa,appealSecond,appealThird,transferIntoShopId,transferIntoShopName,isTransfer,isTurn,isDel,createTime,editTime
        from order_item
        WHERE id = #{value}
    </select>