<?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>
    <select id="thematicAnalysisPage" resultType="com.fjhx.jushuitan.entity.jst.ThematicAnalysisBo">
        SELECT joi.oid,
               joi.labels,
               joi.type,
               joi.so_id,
               joi.`status`,
               joi.drp_from,
               joi.shop_name,
               joi.shop_buyer_id,
               joi.buyer_message,
               joi.remark,
               joi.order_date,
               joi.send_date,
               joi.end_time,
               joi.creator_name,
               joi.receiver_name,
               joi.receiver_state,
               joi.receiver_city,
               joi.receiver_town,
               joi.logistics_company,
               joi.lid,
               joi.shop_id,
               jod.sku_id,
               jod.iid,
               jod.raw_so_id,
               jod.`name`,
               jod.shop_sku_id,
               jod.base_price,
               jod.price,
               jod.qty,
               jod.amount
        FROM jst_order_info joi
                 JOIN jst_order_detail jod ON jod.order_id = joi.id
            ${ew.customSqlSegment}
    </select>

</mapper>
