<?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.jushuitan.mapper.jst.JstOrderInfoMapper">
    <select id="getList" resultType="com.fjhx.jushuitan.entity.jst.vo.JstOrderInfoVo">
        select
            joi.id,
            joi.plan_delivery_date,
            joi.referrer_id,
            joi.open_id,
            joi.fweight,
            joi.drp_co_id_from,
            joi.buyer_id,
            joi.type,
            joi.discount_rate,
            joi.send_date,
            joi.buyer_tax_no,
            joi.modified,
            joi.receiver_country,
            joi.tag,
            joi.buyer_paid_amount,
            joi.drp_from,
            joi.shipment,
            joi.shop_status,
            joi.buyer_message,
            joi.outer_so_id,
            joi.created,
            joi.drp_to,
            joi.is_split,
            joi.weight,
            joi.shop_name,
            joi.labels,
            joi.shop_id,
            joi.node,
            joi.ffreight,
            joi.shop_buyer_id,
            joi.wms_co_id,
            joi.drp_co_id_to,
            joi.paid_amount,
            joi.referrer_name,
            joi.link_o_id,
            joi.status,
            joi.ext_datas,
            joi.lc_id,
            joi.skus,
            joi.question_desc,
            joi.as_id,
            joi.receiver_city,
            joi.invoice_title,
            joi.outer_as_id,
            joi.freight,
            joi.remark,
            joi.is_cod,
            joi.receiver_state,
            joi.glasses,
            joi.receiver_zip,
            joi.so_id,
            joi.oid,
            joi.receiver_name,
            joi.currency,
            joi.invoice_type,
            joi.seller_income_amount,
            joi.free_amount,
            joi.outer_pay_id,
            joi.amount,
            joi.question_type,
            joi.receiver_district,
            joi.receiver_town,
            joi.pay_amount,
            joi.co_id,
            joi.end_time,
            joi.shop_site,
            joi.receiver_mobile,
            joi.sign_time,
            joi.seller_flag,
            joi.order_date,
            joi.merge_so_id,
            joi.raw_so_id,
            joi.order_from,
            joi.is_merge,
            joi.receiver_address,
            joi.logistics_company,
            joi.creator_name,
            joi.lid,
            joi.receiver_phone,
            joi.ts,
            joi.dept_id
        from jst_order_info joi
            ${ew.customSqlSegment}
    </select>

    <select id="getPage" resultType="com.fjhx.jushuitan.entity.jst.vo.JstOrderInfoVo">
        select
            joi.id,
            joi.plan_delivery_date,
            joi.referrer_id,
            joi.open_id,
            joi.fweight,
            joi.drp_co_id_from,
            joi.buyer_id,
            joi.type,
            joi.discount_rate,
            joi.send_date,
            joi.buyer_tax_no,
            joi.modified,
            joi.receiver_country,
            joi.tag,
            joi.buyer_paid_amount,
            joi.drp_from,
            joi.shipment,
            joi.shop_status,
            joi.buyer_message,
            joi.outer_so_id,
            joi.created,
            joi.drp_to,
            joi.is_split,
            joi.weight,
            joi.shop_name,
            joi.labels,
            joi.shop_id,
            joi.node,
            joi.ffreight,
            joi.shop_buyer_id,
            joi.wms_co_id,
            joi.drp_co_id_to,
            joi.paid_amount,
            joi.referrer_name,
            joi.link_o_id,
            joi.status,
            joi.ext_datas,
            joi.lc_id,
            joi.skus,
            joi.question_desc,
            joi.as_id,
            joi.receiver_city,
            joi.invoice_title,
            joi.outer_as_id,
            joi.freight,
            joi.remark,
            joi.is_cod,
            joi.receiver_state,
            joi.glasses,
            joi.receiver_zip,
            joi.so_id,
            joi.oid,
            joi.receiver_name,
            joi.currency,
            joi.invoice_type,
            joi.seller_income_amount,
            joi.free_amount,
            joi.outer_pay_id,
            joi.amount,
            joi.question_type,
            joi.receiver_district,
            joi.receiver_town,
            joi.pay_amount,
            joi.co_id,
            joi.end_time,
            joi.shop_site,
            joi.receiver_mobile,
            joi.sign_time,
            joi.seller_flag,
            joi.order_date,
            joi.merge_so_id,
            joi.raw_so_id,
            joi.order_from,
            joi.is_merge,
            joi.receiver_address,
            joi.logistics_company,
            joi.creator_name,
            joi.lid,
            joi.receiver_phone,
            joi.ts,
            joi.dept_id
        from jst_order_info joi
            ${ew.customSqlSegment}
    </select>

</mapper>
