fix viewJhyOrder.json

Helius

2021-06-28 135e1a36d71ff23a6a4832da6e28e33ce115943c

fix viewJhyOrder.json

 gc-shop/src/main/java/com/xzx/gc/shop/mapper/JhyOrderMapper.java

@@ -13,5 +13,5 @@

    List<QueryJhyOrderListVo> queryOrderList(@Param("record") QueryJhyOrderListDto model);

    ViewJhyOrderVo viewJhyOrder(@Param("id")Long id);
    ViewJhyOrderVo viewJhyOrder(@Param("id") Long id);
}

 gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml

@@ -65,25 +65,7 @@
        xzx_jhy_order a
        left join xzx_user_info b on b.user_id = a.user_id
        left join xzx_jhy_info d on d.id = a.jhy_id
        WHERE 1 = 1
        <if test="record.orderNo != null and record.orderNo != ''">
            and a.order_no like concat('%',#{record.orderNo},'%')
        </if>
        <if test="record.status != null and record.status != ''">
            and a.status = #{record.status}
        </if>
        <if test="record.account != null and record.account != ''">
            and ( b.nick_name like concat('%',#{record.account},'%')
            or b.mobile_phone like concat('%',#{record.account},'%') )
        </if>
        <if test="record.reserveTimeStart != null">
            and a.reserve_time >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and a.reserve_time &lt;= #{record.reserveTimeEnd}
        </if>
        order by a.CREATED_TIME desc
        WHERE a.id=#{id}
    </select>