拼多多订单修改

admin

2019-08-23 662f1ac651d438931127768b1629c90a0a385cd4

拼多多订单修改

 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/pdd/PDDOrderMapper.java

@@ -17,9 +17,10 @@
     * @return
     */
    PDDOrder selectByOrderSN(String orderSn);
	

    /**
     * 数量统计
     * 
     * @param dateType
     * @param year
     * @param startTime
@@ -28,4 +29,22 @@
     */
    List<Map<String, Object>> countOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year,
            @Param("startTime") String startTime, @Param("endTime") String endTime);

    /**
     * 根据状态查询数据
     * 
     * @param status
     * @param page
     * @param pageSize
     * @return
     */
    List<PDDOrder> listByStatus(@Param("status") Integer status, @Param("start") long start, @Param("count") int count);

    /**
     * 根据状态查询数量
     * 
     * @param status
     * @return
     */
    Long countByStatus(@Param("status") Integer status);
}

 fanli/src/main/java/com/yeshi/fanli/mapping/pdd/PDDOrderMapper.xml

@@ -154,7 +154,8 @@
        #{orderId,jdbcType=VARCHAR},po_create_time =
        #{createTime,jdbcType=TIMESTAMP},po_update_time =
        #{updateTime,jdbcType=TIMESTAMP},po_order_receive_time =
        #{orderReceiveTime,jdbcType=BIGINT} where po_id = #{id,jdbcType=BIGINT}
        #{orderReceiveTime,jdbcType=BIGINT} where po_id =
        #{id,jdbcType=BIGINT}
    </update>
    <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.pdd.PDDOrder">
        update yeshi_ec_pdd_order
@@ -190,7 +191,8 @@
            <if test="orderId != null">po_order_id=#{orderId,jdbcType=VARCHAR},</if>
            <if test="createTime != null">po_create_time=#{createTime,jdbcType=TIMESTAMP},</if>
            <if test="updateTime != null">po_update_time=#{updateTime,jdbcType=TIMESTAMP},</if>
            <if test="orderReceiveTime != null">po_order_receive_time=#{orderReceiveTime,jdbcType=BIGINT},</if>
            <if test="orderReceiveTime != null">po_order_receive_time=#{orderReceiveTime,jdbcType=BIGINT},
            </if>
        </set>
        where po_id = #{id,jdbcType=BIGINT}
    </update>
@@ -233,4 +235,30 @@
    </select>



    <select id="listByStatus" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />

        from yeshi_ec_pdd_order

        <if test="status!=null">
            where po_order_status=#{status}
        </if>
        limit #{start},#{count}
    </select>



    <select id="countByStatus" resultType="java.lang.Long">
        select
        count(po_id)

        from yeshi_ec_pdd_order

        <if test="status!=null">
            where po_order_status=#{status}
        </if>
    </select>

</mapper>

 fanli/src/main/java/com/yeshi/fanli/service/impl/pdd/PDDOrderServiceImpl.java

@@ -65,4 +65,9 @@
        return pddList;

    }



    @Override

    public List<PDDOrder> listByStatus(Integer status, int page, int pageSize) {

        return pddOrderMapper.listByStatus(status, (page - 1) * pageSize, pageSize);

    }



}


 fanli/src/main/java/com/yeshi/fanli/service/inter/pdd/PDDOrderService.java

@@ -24,4 +24,13 @@
     */

    public List<PDDOrder> selectByOrderSn(String orderSn);



    /**

     * 根据状态查询

     * @param status

     * @param page

     * @param pageSize

     * @return

     */

    public List<PDDOrder> listByStatus(Integer status, int page, int pageSize);



}


 fanli/src/main/java/com/yeshi/fanli/util/pinduoduo/PinDuoDuoApiUtil.java

@@ -336,7 +336,6 @@
        map.put("page", page + "");

        map.put("page_size", pageSize + "");

        String result = baseRequest(map);

        System.out.println(result);

        JSONObject json = JSONObject.fromObject(result);

        JSONObject root = json.optJSONObject("order_list_get_response");

        if (root != null) {

@@ -350,6 +349,20 @@
        return null;

    }



    public static PDDOrder getOrderDetail(String orderSn) {

        Map<String, String> map = new HashMap<>();

        map.put("type", "pdd.ddk.order.detail.get");

        map.put("order_sn", orderSn);

        String result = baseRequest(map);

        System.out.println(result);

        JSONObject json = JSONObject.fromObject(result);

        JSONObject root = json.optJSONObject("order_detail_response");

        if (root != null) {

            return new Gson().fromJson(root.toString(), PDDOrder.class);

        }

        return null;

    }



    /**

     * 获取商品详情

     *