<?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.batch_flag,
            jb.create_user,
            jb.create_time,
            jb.update_user,
            jb.update_time,
            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>
