<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.fjhx.victoriatourist.mapper.jd.JdBackMapper">
    <select id="getPage" resultType="com.fjhx.victoriatourist.entity.jd.vo.JdBackVo">
        SELECT
            jb.id,
            jb.type,
            jb.`status`,
            jb.waybill,
            jb.warehouse_id,
            jb.business_status,
            jb.batch_flag,
            jb.create_user,
            jb.create_time,
            jb.update_user,
            jb.update_time,
            jb.return_id,
            jb.provider_code,
            jb.provider_name,
            jb.create_date,
            jb.from_deliver_center_name,
            jb.to_deliver_center_name,
            jb.return_state_name,
            jb.total_num,
            jb.total_price,
            jb.stock_name,
            jb.ware_house_address,
            jb.ware_house_cell,
            jb.ware_house_contact,
            jb.out_store_room_date,
            jb.ware_variety,
            jb.balance_state_name,
            jb.balance_date

        <!--,li.logistics_company_code,
        li.`code` logistics_code-->
        FROM
            jd_back jb
                <!--JOIN jd_back_details jbd ON jbd.jd_back_id = jb.id
                JOIN logistics_infos li ON li.business_id = jb.id-->
            ${ew.customSqlSegment}
    </select>

</mapper>
