<?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.bailuntec.mapper.DcBaseOmsSkuMapper">
    <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        <id column="id" jdbcType="INTEGER" property="id"/>
        <result column="origin_order_id" jdbcType="VARCHAR" property="originOrderId"/>
        <result column="platform_type" jdbcType="VARCHAR" property="platformType"/>
        <result column="transaction_id" jdbcType="VARCHAR" property="transactionId"/>
        <result column="pay_time" jdbcType="TIMESTAMP" property="payTime"/>
        <result column="pay_method" jdbcType="VARCHAR" property="payMethod"/>
        <result column="pay_account" jdbcType="VARCHAR" property="payAccount"/>
        <result column="pay_status" jdbcType="VARCHAR" property="payStatus"/>
        <result column="collection_account" jdbcType="VARCHAR" property="collectionAccount"/>
        <result column="platform_order_type" jdbcType="VARCHAR" property="platformOrderType"/>
        <result column="website" jdbcType="VARCHAR" property="website"/>
        <result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
        <result column="purchase_create_time" jdbcType="TIMESTAMP" property="purchaseCreateTime"/>
        <result column="has_paytime" jdbcType="BIT" property="hasPaytime"/>
        <result column="paid_time" jdbcType="TIMESTAMP" property="paidTime"/>
        <result column="refund_time" jdbcType="TIMESTAMP" property="refundTime"/>
        <result column="seller_id" jdbcType="VARCHAR" property="sellerId"/>
        <result column="bailun_account_id" jdbcType="INTEGER" property="bailunAccountId"/>
        <result column="hq_account" jdbcType="VARCHAR" property="hqAccount"/>
        <result column="seller_account" jdbcType="VARCHAR" property="sellerAccount"/>
        <result column="seller_order_id" jdbcType="VARCHAR" property="sellerOrderId"/>
        <result column="seller_email" jdbcType="VARCHAR" property="sellerEmail"/>
        <result column="order_update_time" jdbcType="TIMESTAMP" property="orderUpdateTime"/>
        <result column="seller_order_exchange_rate" jdbcType="DECIMAL" property="sellerOrderExchangeRate"/>
        <result column="seller_other_exchange_rate" jdbcType="DECIMAL" property="sellerOtherExchangeRate"/>
        <result column="finance_order_exchange_rate" jdbcType="DECIMAL" property="financeOrderExchangeRate"/>
        <result column="finance_other_exchange_rate" jdbcType="DECIMAL" property="financeOtherExchangeRate"/>
        <result column="cny_to_usd_exchange_rate" jdbcType="DECIMAL" property="cnyToUsdExchangeRate"/>
        <result column="order_to_usd_exchange_rate" jdbcType="DECIMAL" property="orderToUsdExchangeRate"/>
        <result column="other_to_usd_exchange_rate" jdbcType="DECIMAL" property="otherToUsdExchangeRate"/>
        <result column="order_currency" jdbcType="VARCHAR" property="orderCurrency"/>
        <result column="other_currency" jdbcType="VARCHAR" property="otherCurrency"/>
        <result column="seller_name" jdbcType="VARCHAR" property="sellerName"/>
        <result column="bailun_order_id" jdbcType="VARCHAR" property="bailunOrderId"/>
        <result column="platform_order_status" jdbcType="VARCHAR" property="platformOrderStatus"/>
        <result column="bailun_order_status" jdbcType="VARCHAR" property="bailunOrderStatus"/>
        <result column="bailun_payment_status" jdbcType="VARCHAR" property="bailunPaymentStatus"/>
        <result column="bailun_interception_status" jdbcType="VARCHAR" property="bailunInterceptionStatus"/>
        <result column="shipping_status" jdbcType="VARCHAR" property="shippingStatus"/>
        <result column="bailun_sku" jdbcType="VARCHAR" property="bailunSku"/>
        <result column="bailun_sku_title_en" jdbcType="VARCHAR" property="bailunSkuTitleEn"/>
        <result column="bailun_sku_title_cn" jdbcType="VARCHAR" property="bailunSkuTitleCn"/>
        <result column="bailun_sku_quantity_ordered" jdbcType="INTEGER" property="bailunSkuQuantityOrdered"/>
        <result column="bailun_sku_quantity_shipped" jdbcType="INTEGER" property="bailunSkuQuantityShipped"/>
        <result column="bailun_sku_quantity_refund" jdbcType="INTEGER" property="bailunSkuQuantityRefund"/>
        <result column="bailun_sku_quantity_picked" jdbcType="INTEGER" property="bailunSkuQuantityPicked"/>
        <result column="warehouse_name" jdbcType="VARCHAR" property="warehouseName"/>
        <result column="warehouse_code_fba" jdbcType="VARCHAR" property="warehouseCodeFba"/>
        <result column="warehouse_code" jdbcType="VARCHAR" property="warehouseCode"/>
        <result column="bailun_sku_unit_price" jdbcType="DECIMAL" property="bailunSkuUnitPrice"/>
        <result column="bailun_sku_weight" jdbcType="DECIMAL" property="bailunSkuWeight"/>
        <result column="bailun_sku_size" jdbcType="VARCHAR" property="bailunSkuSize"/>
        <result column="amount_sales" jdbcType="DECIMAL" property="amountSales"/>
        <result column="amount_total" jdbcType="DECIMAL" property="amountTotal"/>
        <result column="amount_shipping" jdbcType="DECIMAL" property="amountShipping"/>
        <result column="amount_product" jdbcType="DECIMAL" property="amountProduct"/>
        <result column="amount_tax" jdbcType="DECIMAL" property="amountTax"/>
        <result column="amount_adjustment" jdbcType="DECIMAL" property="amountAdjustment"/>
        <result column="amount_gift_wrap" jdbcType="DECIMAL" property="amountGiftWrap"/>
        <result column="amount_refund" jdbcType="DECIMAL" property="amountRefund"/>
        <result column="amount_prepaid" jdbcType="DECIMAL" property="amountPrepaid"/>
        <result column="cost_total" jdbcType="DECIMAL" property="costTotal"/>
        <result column="cost_promotion" jdbcType="DECIMAL" property="costPromotion"/>
        <result column="cost_platform_fee" jdbcType="DECIMAL" property="costPlatformFee"/>
        <result column="cost_product" jdbcType="DECIMAL" property="costProduct"/>
        <result column="cost_shipping" jdbcType="DECIMAL" property="costShipping"/>
        <result column="cost_package" jdbcType="DECIMAL" property="costPackage"/>
        <result column="cost_fba_fee" jdbcType="DECIMAL" property="costFbaFee"/>
        <result column="cost_paypal_fee" jdbcType="DECIMAL" property="costPaypalFee"/>
        <result column="cost_refund_commisson" jdbcType="DECIMAL" property="costRefundCommisson"/>
        <result column="cost_handle_bailun" jdbcType="DECIMAL" property="costHandleBailun"/>
        <result column="cost_handle_platform" jdbcType="DECIMAL" property="costHandlePlatform"/>
        <result column="cost_tail" jdbcType="DECIMAL" property="costTail"/>
        <result column="cost_first" jdbcType="DECIMAL" property="costFirst"/>
        <result column="cost_logistics" jdbcType="DECIMAL" property="costLogistics"/>
        <result column="profit_total" jdbcType="DECIMAL" property="profitTotal"/>
        <result column="profit_rate" jdbcType="DECIMAL" property="profitRate"/>
        <result column="receipt_country" jdbcType="VARCHAR" property="receiptCountry"/>
        <result column="receipt_city" jdbcType="VARCHAR" property="receiptCity"/>
        <result column="receipt_area" jdbcType="VARCHAR" property="receiptArea"/>
        <result column="receipt_address" jdbcType="VARCHAR" property="receiptAddress"/>
        <result column="receipt_address_2" jdbcType="VARCHAR" property="receiptAddress2"/>
        <result column="receipt_postal_code" jdbcType="VARCHAR" property="receiptPostalCode"/>
        <result column="receiver" jdbcType="VARCHAR" property="receiver"/>
        <result column="receiver_phone" jdbcType="VARCHAR" property="receiverPhone"/>
        <result column="buyer_id" jdbcType="VARCHAR" property="buyerId"/>
        <result column="buyer_name" jdbcType="VARCHAR" property="buyerName"/>
        <result column="buyer_email" jdbcType="VARCHAR" property="buyerEmail"/>
        <result column="has_fba_exception" jdbcType="BIT" property="hasFbaException"/>
        <result column="has_platform_exception" jdbcType="BIT" property="hasPlatformException"/>
        <result column="has_cancle" jdbcType="BIT" property="hasCancle"/>
        <result column="area_id" jdbcType="INTEGER" property="areaId"/>
        <result column="bailun_category_id" jdbcType="INTEGER" property="bailunCategoryId"/>
        <result column="bailun_category_name" jdbcType="VARCHAR" property="bailunCategoryName"/>
        <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate"/>
        <result column="gmt_modified" jdbcType="TIMESTAMP" property="gmtModified"/>
        <result column="ratio_weight" jdbcType="DECIMAL" property="ratioWeight"/>
        <result column="ratio_price" jdbcType="DECIMAL" property="ratioPrice"/>
        <result column="bailun_picking_status" jdbcType="VARCHAR" property="bailunPickingStatus"/>
        <result column="bailun_require_logistics" jdbcType="VARCHAR" property="bailunRequireLogistics"/>
        <result column="has_delete" jdbcType="BIT" property="hasDelete"/>
        <result column="has_scalp" jdbcType="BIT" property="hasScalp"/>
        <result column="has_buyer_remark" jdbcType="BIT" property="hasBuyerRemark"/>
        <result column="has_platsku_remark" jdbcType="BIT" property="hasPlatskuRemark"/>
        <result column="logistics_method_code" jdbcType="VARCHAR" property="logisticsMethodCode"/>
        <result column="logistics_method_name" jdbcType="VARCHAR" property="logisticsMethodName"/>
        <result column="has_innersale" jdbcType="BIT" property="hasInnersale"/>
        <result column="company_id" jdbcType="INTEGER" property="companyId"/>
        <result column="bailun_refund_status" jdbcType="VARCHAR" property="bailunRefundStatus"/>
        <result column="refund_obj" jdbcType="VARCHAR" property="refundObj"/>
        <result column="refund_type" jdbcType="VARCHAR" property="refundType"/>
        <result column="refund_reference_id" jdbcType="VARCHAR" property="refundReferenceId"/>
        <result column="has_fba_s" jdbcType="BIT" property="hasFbaS"/>
        <result column="bailun_sku_quantity_pushed" jdbcType="INTEGER" property="bailunSkuQuantityPushed"/>
        <result column="amount_general_cargo" jdbcType="DECIMAL" property="amountGeneralCargo"/>
        <result column="has_transfer_order" jdbcType="BIT" property="hasTransferOrder"/>
        <result column="warning_type" jdbcType="VARCHAR" property="warningType"/>
        <result column="warning_type_name" jdbcType="VARCHAR" property="warningTypeName"/>
        <result column="total_fee" jdbcType="DECIMAL" property="totalFee"/>
        <result column="shipping" jdbcType="DECIMAL" property="shipping"/>
        <result column="opf" jdbcType="DECIMAL" property="opf"/>
        <result column="fsc" jdbcType="DECIMAL" property="fsc"/>
        <result column="dt" jdbcType="DECIMAL" property="dt"/>
        <result column="rsf" jdbcType="DECIMAL" property="rsf"/>
        <result column="otf" jdbcType="DECIMAL" property="otf"/>
        <result column="whf" jdbcType="DECIMAL" property="whf"/>
        <result column="currency_code" jdbcType="VARCHAR" property="currencyCode"/>
        <result column="wms_to_cny_exchange_rate" jdbcType="DECIMAL" property="wmsToCnyExchangeRate"/>
        <result column="wms_to_usd_exchange_rate" jdbcType="DECIMAL" property="wmsToUsdExchangeRate"/>
        <result column="shipping_deadline_real" jdbcType="TIMESTAMP" property="shippingDeadlineReal"/>
    </resultMap>
    <sql id="Example_Where_Clause">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        <where>
            <foreach collection="oredCriteria" item="criteria" separator="or">
                <if test="criteria.valid">
                    <trim prefix="(" prefixOverrides="and" suffix=")">
                        <foreach collection="criteria.criteria" item="criterion">
                            <choose>
                                <when test="criterion.noValue">
                                    and ${criterion.condition}
                                </when>
                                <when test="criterion.singleValue">
                                    and ${criterion.condition} #{criterion.value}
                                </when>
                                <when test="criterion.betweenValue">
                                    and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                                </when>
                                <when test="criterion.listValue">
                                    and ${criterion.condition}
                                    <foreach close=")" collection="criterion.value" item="listItem" open="("
                                             separator=",">
                                        #{listItem}
                                    </foreach>
                                </when>
                            </choose>
                        </foreach>
                    </trim>
                </if>
            </foreach>
        </where>
    </sql>
    <sql id="Update_By_Example_Where_Clause">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        <where>
            <foreach collection="example.oredCriteria" item="criteria" separator="or">
                <if test="criteria.valid">
                    <trim prefix="(" prefixOverrides="and" suffix=")">
                        <foreach collection="criteria.criteria" item="criterion">
                            <choose>
                                <when test="criterion.noValue">
                                    and ${criterion.condition}
                                </when>
                                <when test="criterion.singleValue">
                                    and ${criterion.condition} #{criterion.value}
                                </when>
                                <when test="criterion.betweenValue">
                                    and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                                </when>
                                <when test="criterion.listValue">
                                    and ${criterion.condition}
                                    <foreach close=")" collection="criterion.value" item="listItem" open="("
                                             separator=",">
                                        #{listItem}
                                    </foreach>
                                </when>
                            </choose>
                        </foreach>
                    </trim>
                </if>
            </foreach>
        </where>
    </sql>
    <sql id="Base_Column_List">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        id, origin_order_id, platform_type, transaction_id, pay_time, pay_method, pay_account,
        pay_status, collection_account, platform_order_type, website, create_time, purchase_create_time,
        has_paytime, paid_time, refund_time, seller_id, bailun_account_id, hq_account, seller_account,
        seller_order_id, seller_email, order_update_time, seller_order_exchange_rate, seller_other_exchange_rate,
        finance_order_exchange_rate, finance_other_exchange_rate, cny_to_usd_exchange_rate,
        order_to_usd_exchange_rate, other_to_usd_exchange_rate, order_currency, other_currency,
        seller_name, bailun_order_id, platform_order_status, bailun_order_status, bailun_payment_status,
        bailun_interception_status, shipping_status, bailun_sku, bailun_sku_title_en, bailun_sku_title_cn,
        bailun_sku_quantity_ordered, bailun_sku_quantity_shipped, bailun_sku_quantity_refund,
        bailun_sku_quantity_picked, warehouse_name, warehouse_code_fba, warehouse_code, bailun_sku_unit_price,
        bailun_sku_weight, bailun_sku_size, amount_sales, amount_total, amount_shipping,
        amount_product, amount_tax, amount_adjustment, amount_gift_wrap, amount_refund, amount_prepaid,
        cost_total, cost_promotion, cost_platform_fee, cost_product, cost_shipping, cost_package,
        cost_fba_fee, cost_paypal_fee, cost_refund_commisson, cost_handle_bailun, cost_handle_platform,
        cost_tail, cost_first, cost_logistics, profit_total, profit_rate, receipt_country,
        receipt_city, receipt_area, receipt_address, receipt_address_2, receipt_postal_code,
        receiver, receiver_phone, buyer_id, buyer_name, buyer_email, has_fba_exception, has_platform_exception,
        has_cancle, area_id, bailun_category_id, bailun_category_name, gmt_create, gmt_modified,
        ratio_weight, ratio_price, bailun_picking_status, bailun_require_logistics, has_delete,
        has_scalp, has_buyer_remark, has_platsku_remark, logistics_method_code, logistics_method_name,
        has_innersale, company_id, bailun_refund_status, refund_obj, refund_type, refund_reference_id,
        has_fba_s, bailun_sku_quantity_pushed, amount_general_cargo, has_transfer_order,
        warning_type, warning_type_name, total_fee, shipping, opf, fsc, dt, rsf, otf, whf,
        currency_code, wms_to_cny_exchange_rate, wms_to_usd_exchange_rate, shipping_deadline_real
    </sql>
    <select id="selectByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSkuExample"
            resultMap="BaseResultMap">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        select
        <if test="distinct">
            distinct
        </if>
        <include refid="Base_Column_List"/>
        from dc_base_oms_sku
        <if test="_parameter != null">
            <include refid="Example_Where_Clause"/>
        </if>
        <if test="orderByClause != null">
            order by ${orderByClause}
        </if>
        <if test="rows != null">
            <if test="offset != null">
                limit ${offset}, ${rows}
            </if>
            <if test="offset == null">
                limit ${rows}
            </if>
        </if>
    </select>
    <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        select
        <include refid="Base_Column_List"/>
        from dc_base_oms_sku
        where id = #{id,jdbcType=INTEGER}
    </select>
    <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        delete from dc_base_oms_sku
        where id = #{id,jdbcType=INTEGER}
    </delete>
    <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSkuExample">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        delete from dc_base_oms_sku
        <if test="_parameter != null">
            <include refid="Example_Where_Clause"/>
        </if>
    </delete>
    <insert id="insert" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        insert into dc_base_oms_sku (id, origin_order_id, platform_type,
        transaction_id, pay_time, pay_method,
        pay_account, pay_status, collection_account,
        platform_order_type, website, create_time,
        purchase_create_time, has_paytime, paid_time,
        refund_time, seller_id, bailun_account_id,
        hq_account, seller_account, seller_order_id,
        seller_email, order_update_time, seller_order_exchange_rate,
        seller_other_exchange_rate, finance_order_exchange_rate,
        finance_other_exchange_rate, cny_to_usd_exchange_rate,
        order_to_usd_exchange_rate, other_to_usd_exchange_rate,
        order_currency, other_currency, seller_name,
        bailun_order_id, platform_order_status, bailun_order_status,
        bailun_payment_status, bailun_interception_status,
        shipping_status, bailun_sku, bailun_sku_title_en,
        bailun_sku_title_cn, bailun_sku_quantity_ordered,
        bailun_sku_quantity_shipped, bailun_sku_quantity_refund,
        bailun_sku_quantity_picked, warehouse_name,
        warehouse_code_fba, warehouse_code, bailun_sku_unit_price,
        bailun_sku_weight, bailun_sku_size, amount_sales,
        amount_total, amount_shipping, amount_product,
        amount_tax, amount_adjustment, amount_gift_wrap,
        amount_refund, amount_prepaid, cost_total,
        cost_promotion, cost_platform_fee, cost_product,
        cost_shipping, cost_package, cost_fba_fee,
        cost_paypal_fee, cost_refund_commisson, cost_handle_bailun,
        cost_handle_platform, cost_tail, cost_first,
        cost_logistics, profit_total, profit_rate,
        receipt_country, receipt_city, receipt_area,
        receipt_address, receipt_address_2, receipt_postal_code,
        receiver, receiver_phone, buyer_id,
        buyer_name, buyer_email, has_fba_exception,
        has_platform_exception, has_cancle, area_id,
        bailun_category_id, bailun_category_name, gmt_create,
        gmt_modified, ratio_weight, ratio_price,
        bailun_picking_status, bailun_require_logistics,
        has_delete, has_scalp, has_buyer_remark,
        has_platsku_remark, logistics_method_code, logistics_method_name,
        has_innersale, company_id, bailun_refund_status,
        refund_obj, refund_type, refund_reference_id,
        has_fba_s, bailun_sku_quantity_pushed, amount_general_cargo,
        has_transfer_order, warning_type, warning_type_name,
        total_fee, shipping, opf,
        fsc, dt, rsf, otf,
        whf, currency_code, wms_to_cny_exchange_rate,
        wms_to_usd_exchange_rate, shipping_deadline_real
        )
        values (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{platformType,jdbcType=VARCHAR},
        #{transactionId,jdbcType=VARCHAR}, #{payTime,jdbcType=TIMESTAMP}, #{payMethod,jdbcType=VARCHAR},
        #{payAccount,jdbcType=VARCHAR}, #{payStatus,jdbcType=VARCHAR}, #{collectionAccount,jdbcType=VARCHAR},
        #{platformOrderType,jdbcType=VARCHAR}, #{website,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},
        #{purchaseCreateTime,jdbcType=TIMESTAMP}, #{hasPaytime,jdbcType=BIT}, #{paidTime,jdbcType=TIMESTAMP},
        #{refundTime,jdbcType=TIMESTAMP}, #{sellerId,jdbcType=VARCHAR}, #{bailunAccountId,jdbcType=INTEGER},
        #{hqAccount,jdbcType=VARCHAR}, #{sellerAccount,jdbcType=VARCHAR}, #{sellerOrderId,jdbcType=VARCHAR},
        #{sellerEmail,jdbcType=VARCHAR}, #{orderUpdateTime,jdbcType=TIMESTAMP},
        #{sellerOrderExchangeRate,jdbcType=DECIMAL},
        #{sellerOtherExchangeRate,jdbcType=DECIMAL}, #{financeOrderExchangeRate,jdbcType=DECIMAL},
        #{financeOtherExchangeRate,jdbcType=DECIMAL}, #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
        #{orderToUsdExchangeRate,jdbcType=DECIMAL}, #{otherToUsdExchangeRate,jdbcType=DECIMAL},
        #{orderCurrency,jdbcType=VARCHAR}, #{otherCurrency,jdbcType=VARCHAR}, #{sellerName,jdbcType=VARCHAR},
        #{bailunOrderId,jdbcType=VARCHAR}, #{platformOrderStatus,jdbcType=VARCHAR},
        #{bailunOrderStatus,jdbcType=VARCHAR},
        #{bailunPaymentStatus,jdbcType=VARCHAR}, #{bailunInterceptionStatus,jdbcType=VARCHAR},
        #{shippingStatus,jdbcType=VARCHAR}, #{bailunSku,jdbcType=VARCHAR}, #{bailunSkuTitleEn,jdbcType=VARCHAR},
        #{bailunSkuTitleCn,jdbcType=VARCHAR}, #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
        #{bailunSkuQuantityShipped,jdbcType=INTEGER}, #{bailunSkuQuantityRefund,jdbcType=INTEGER},
        #{bailunSkuQuantityPicked,jdbcType=INTEGER}, #{warehouseName,jdbcType=VARCHAR},
        #{warehouseCodeFba,jdbcType=VARCHAR}, #{warehouseCode,jdbcType=VARCHAR}, #{bailunSkuUnitPrice,jdbcType=DECIMAL},
        #{bailunSkuWeight,jdbcType=DECIMAL}, #{bailunSkuSize,jdbcType=VARCHAR}, #{amountSales,jdbcType=DECIMAL},
        #{amountTotal,jdbcType=DECIMAL}, #{amountShipping,jdbcType=DECIMAL}, #{amountProduct,jdbcType=DECIMAL},
        #{amountTax,jdbcType=DECIMAL}, #{amountAdjustment,jdbcType=DECIMAL}, #{amountGiftWrap,jdbcType=DECIMAL},
        #{amountRefund,jdbcType=DECIMAL}, #{amountPrepaid,jdbcType=DECIMAL}, #{costTotal,jdbcType=DECIMAL},
        #{costPromotion,jdbcType=DECIMAL}, #{costPlatformFee,jdbcType=DECIMAL}, #{costProduct,jdbcType=DECIMAL},
        #{costShipping,jdbcType=DECIMAL}, #{costPackage,jdbcType=DECIMAL}, #{costFbaFee,jdbcType=DECIMAL},
        #{costPaypalFee,jdbcType=DECIMAL}, #{costRefundCommisson,jdbcType=DECIMAL},
        #{costHandleBailun,jdbcType=DECIMAL},
        #{costHandlePlatform,jdbcType=DECIMAL}, #{costTail,jdbcType=DECIMAL}, #{costFirst,jdbcType=DECIMAL},
        #{costLogistics,jdbcType=DECIMAL}, #{profitTotal,jdbcType=DECIMAL}, #{profitRate,jdbcType=DECIMAL},
        #{receiptCountry,jdbcType=VARCHAR}, #{receiptCity,jdbcType=VARCHAR}, #{receiptArea,jdbcType=VARCHAR},
        #{receiptAddress,jdbcType=VARCHAR}, #{receiptAddress2,jdbcType=VARCHAR}, #{receiptPostalCode,jdbcType=VARCHAR},
        #{receiver,jdbcType=VARCHAR}, #{receiverPhone,jdbcType=VARCHAR}, #{buyerId,jdbcType=VARCHAR},
        #{buyerName,jdbcType=VARCHAR}, #{buyerEmail,jdbcType=VARCHAR}, #{hasFbaException,jdbcType=BIT},
        #{hasPlatformException,jdbcType=BIT}, #{hasCancle,jdbcType=BIT}, #{areaId,jdbcType=INTEGER},
        #{bailunCategoryId,jdbcType=INTEGER}, #{bailunCategoryName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP},
        #{gmtModified,jdbcType=TIMESTAMP}, #{ratioWeight,jdbcType=DECIMAL}, #{ratioPrice,jdbcType=DECIMAL},
        #{bailunPickingStatus,jdbcType=VARCHAR}, #{bailunRequireLogistics,jdbcType=VARCHAR},
        #{hasDelete,jdbcType=BIT}, #{hasScalp,jdbcType=BIT}, #{hasBuyerRemark,jdbcType=BIT},
        #{hasPlatskuRemark,jdbcType=BIT}, #{logisticsMethodCode,jdbcType=VARCHAR},
        #{logisticsMethodName,jdbcType=VARCHAR},
        #{hasInnersale,jdbcType=BIT}, #{companyId,jdbcType=INTEGER}, #{bailunRefundStatus,jdbcType=VARCHAR},
        #{refundObj,jdbcType=VARCHAR}, #{refundType,jdbcType=VARCHAR}, #{refundReferenceId,jdbcType=VARCHAR},
        #{hasFbaS,jdbcType=BIT}, #{bailunSkuQuantityPushed,jdbcType=INTEGER}, #{amountGeneralCargo,jdbcType=DECIMAL},
        #{hasTransferOrder,jdbcType=BIT}, #{warningType,jdbcType=VARCHAR}, #{warningTypeName,jdbcType=VARCHAR},
        #{totalFee,jdbcType=DECIMAL}, #{shipping,jdbcType=DECIMAL}, #{opf,jdbcType=DECIMAL},
        #{fsc,jdbcType=DECIMAL}, #{dt,jdbcType=DECIMAL}, #{rsf,jdbcType=DECIMAL}, #{otf,jdbcType=DECIMAL},
        #{whf,jdbcType=DECIMAL}, #{currencyCode,jdbcType=VARCHAR}, #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
        #{wmsToUsdExchangeRate,jdbcType=DECIMAL}, #{shippingDeadlineReal,jdbcType=TIMESTAMP}
        )
    </insert>
    <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        insert into dc_base_oms_sku
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                id,
            </if>
            <if test="originOrderId != null">
                origin_order_id,
            </if>
            <if test="platformType != null">
                platform_type,
            </if>
            <if test="transactionId != null">
                transaction_id,
            </if>
            <if test="payTime != null">
                pay_time,
            </if>
            <if test="payMethod != null">
                pay_method,
            </if>
            <if test="payAccount != null">
                pay_account,
            </if>
            <if test="payStatus != null">
                pay_status,
            </if>
            <if test="collectionAccount != null">
                collection_account,
            </if>
            <if test="platformOrderType != null">
                platform_order_type,
            </if>
            <if test="website != null">
                website,
            </if>
            <if test="createTime != null">
                create_time,
            </if>
            <if test="purchaseCreateTime != null">
                purchase_create_time,
            </if>
            <if test="hasPaytime != null">
                has_paytime,
            </if>
            <if test="paidTime != null">
                paid_time,
            </if>
            <if test="refundTime != null">
                refund_time,
            </if>
            <if test="sellerId != null">
                seller_id,
            </if>
            <if test="bailunAccountId != null">
                bailun_account_id,
            </if>
            <if test="hqAccount != null">
                hq_account,
            </if>
            <if test="sellerAccount != null">
                seller_account,
            </if>
            <if test="sellerOrderId != null">
                seller_order_id,
            </if>
            <if test="sellerEmail != null">
                seller_email,
            </if>
            <if test="orderUpdateTime != null">
                order_update_time,
            </if>
            <if test="sellerOrderExchangeRate != null">
                seller_order_exchange_rate,
            </if>
            <if test="sellerOtherExchangeRate != null">
                seller_other_exchange_rate,
            </if>
            <if test="financeOrderExchangeRate != null">
                finance_order_exchange_rate,
            </if>
            <if test="financeOtherExchangeRate != null">
                finance_other_exchange_rate,
            </if>
            <if test="cnyToUsdExchangeRate != null">
                cny_to_usd_exchange_rate,
            </if>
            <if test="orderToUsdExchangeRate != null">
                order_to_usd_exchange_rate,
            </if>
            <if test="otherToUsdExchangeRate != null">
                other_to_usd_exchange_rate,
            </if>
            <if test="orderCurrency != null">
                order_currency,
            </if>
            <if test="otherCurrency != null">
                other_currency,
            </if>
            <if test="sellerName != null">
                seller_name,
            </if>
            <if test="bailunOrderId != null">
                bailun_order_id,
            </if>
            <if test="platformOrderStatus != null">
                platform_order_status,
            </if>
            <if test="bailunOrderStatus != null">
                bailun_order_status,
            </if>
            <if test="bailunPaymentStatus != null">
                bailun_payment_status,
            </if>
            <if test="bailunInterceptionStatus != null">
                bailun_interception_status,
            </if>
            <if test="shippingStatus != null">
                shipping_status,
            </if>
            <if test="bailunSku != null">
                bailun_sku,
            </if>
            <if test="bailunSkuTitleEn != null">
                bailun_sku_title_en,
            </if>
            <if test="bailunSkuTitleCn != null">
                bailun_sku_title_cn,
            </if>
            <if test="bailunSkuQuantityOrdered != null">
                bailun_sku_quantity_ordered,
            </if>
            <if test="bailunSkuQuantityShipped != null">
                bailun_sku_quantity_shipped,
            </if>
            <if test="bailunSkuQuantityRefund != null">
                bailun_sku_quantity_refund,
            </if>
            <if test="bailunSkuQuantityPicked != null">
                bailun_sku_quantity_picked,
            </if>
            <if test="warehouseName != null">
                warehouse_name,
            </if>
            <if test="warehouseCodeFba != null">
                warehouse_code_fba,
            </if>
            <if test="warehouseCode != null">
                warehouse_code,
            </if>
            <if test="bailunSkuUnitPrice != null">
                bailun_sku_unit_price,
            </if>
            <if test="bailunSkuWeight != null">
                bailun_sku_weight,
            </if>
            <if test="bailunSkuSize != null">
                bailun_sku_size,
            </if>
            <if test="amountSales != null">
                amount_sales,
            </if>
            <if test="amountTotal != null">
                amount_total,
            </if>
            <if test="amountShipping != null">
                amount_shipping,
            </if>
            <if test="amountProduct != null">
                amount_product,
            </if>
            <if test="amountTax != null">
                amount_tax,
            </if>
            <if test="amountAdjustment != null">
                amount_adjustment,
            </if>
            <if test="amountGiftWrap != null">
                amount_gift_wrap,
            </if>
            <if test="amountRefund != null">
                amount_refund,
            </if>
            <if test="amountPrepaid != null">
                amount_prepaid,
            </if>
            <if test="costTotal != null">
                cost_total,
            </if>
            <if test="costPromotion != null">
                cost_promotion,
            </if>
            <if test="costPlatformFee != null">
                cost_platform_fee,
            </if>
            <if test="costProduct != null">
                cost_product,
            </if>
            <if test="costShipping != null">
                cost_shipping,
            </if>
            <if test="costPackage != null">
                cost_package,
            </if>
            <if test="costFbaFee != null">
                cost_fba_fee,
            </if>
            <if test="costPaypalFee != null">
                cost_paypal_fee,
            </if>
            <if test="costRefundCommisson != null">
                cost_refund_commisson,
            </if>
            <if test="costHandleBailun != null">
                cost_handle_bailun,
            </if>
            <if test="costHandlePlatform != null">
                cost_handle_platform,
            </if>
            <if test="costTail != null">
                cost_tail,
            </if>
            <if test="costFirst != null">
                cost_first,
            </if>
            <if test="costLogistics != null">
                cost_logistics,
            </if>
            <if test="profitTotal != null">
                profit_total,
            </if>
            <if test="profitRate != null">
                profit_rate,
            </if>
            <if test="receiptCountry != null">
                receipt_country,
            </if>
            <if test="receiptCity != null">
                receipt_city,
            </if>
            <if test="receiptArea != null">
                receipt_area,
            </if>
            <if test="receiptAddress != null">
                receipt_address,
            </if>
            <if test="receiptAddress2 != null">
                receipt_address_2,
            </if>
            <if test="receiptPostalCode != null">
                receipt_postal_code,
            </if>
            <if test="receiver != null">
                receiver,
            </if>
            <if test="receiverPhone != null">
                receiver_phone,
            </if>
            <if test="buyerId != null">
                buyer_id,
            </if>
            <if test="buyerName != null">
                buyer_name,
            </if>
            <if test="buyerEmail != null">
                buyer_email,
            </if>
            <if test="hasFbaException != null">
                has_fba_exception,
            </if>
            <if test="hasPlatformException != null">
                has_platform_exception,
            </if>
            <if test="hasCancle != null">
                has_cancle,
            </if>
            <if test="areaId != null">
                area_id,
            </if>
            <if test="bailunCategoryId != null">
                bailun_category_id,
            </if>
            <if test="bailunCategoryName != null">
                bailun_category_name,
            </if>
            <if test="gmtCreate != null">
                gmt_create,
            </if>
            <if test="gmtModified != null">
                gmt_modified,
            </if>
            <if test="ratioWeight != null">
                ratio_weight,
            </if>
            <if test="ratioPrice != null">
                ratio_price,
            </if>
            <if test="bailunPickingStatus != null">
                bailun_picking_status,
            </if>
            <if test="bailunRequireLogistics != null">
                bailun_require_logistics,
            </if>
            <if test="hasDelete != null">
                has_delete,
            </if>
            <if test="hasScalp != null">
                has_scalp,
            </if>
            <if test="hasBuyerRemark != null">
                has_buyer_remark,
            </if>
            <if test="hasPlatskuRemark != null">
                has_platsku_remark,
            </if>
            <if test="logisticsMethodCode != null">
                logistics_method_code,
            </if>
            <if test="logisticsMethodName != null">
                logistics_method_name,
            </if>
            <if test="hasInnersale != null">
                has_innersale,
            </if>
            <if test="companyId != null">
                company_id,
            </if>
            <if test="bailunRefundStatus != null">
                bailun_refund_status,
            </if>
            <if test="refundObj != null">
                refund_obj,
            </if>
            <if test="refundType != null">
                refund_type,
            </if>
            <if test="refundReferenceId != null">
                refund_reference_id,
            </if>
            <if test="hasFbaS != null">
                has_fba_s,
            </if>
            <if test="bailunSkuQuantityPushed != null">
                bailun_sku_quantity_pushed,
            </if>
            <if test="amountGeneralCargo != null">
                amount_general_cargo,
            </if>
            <if test="hasTransferOrder != null">
                has_transfer_order,
            </if>
            <if test="warningType != null">
                warning_type,
            </if>
            <if test="warningTypeName != null">
                warning_type_name,
            </if>
            <if test="totalFee != null">
                total_fee,
            </if>
            <if test="shipping != null">
                shipping,
            </if>
            <if test="opf != null">
                opf,
            </if>
            <if test="fsc != null">
                fsc,
            </if>
            <if test="dt != null">
                dt,
            </if>
            <if test="rsf != null">
                rsf,
            </if>
            <if test="otf != null">
                otf,
            </if>
            <if test="whf != null">
                whf,
            </if>
            <if test="currencyCode != null">
                currency_code,
            </if>
            <if test="wmsToCnyExchangeRate != null">
                wms_to_cny_exchange_rate,
            </if>
            <if test="wmsToUsdExchangeRate != null">
                wms_to_usd_exchange_rate,
            </if>
            <if test="shippingDeadlineReal != null">
                shipping_deadline_real,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">
                #{id,jdbcType=INTEGER},
            </if>
            <if test="originOrderId != null">
                #{originOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformType != null">
                #{platformType,jdbcType=VARCHAR},
            </if>
            <if test="transactionId != null">
                #{transactionId,jdbcType=VARCHAR},
            </if>
            <if test="payTime != null">
                #{payTime,jdbcType=TIMESTAMP},
            </if>
            <if test="payMethod != null">
                #{payMethod,jdbcType=VARCHAR},
            </if>
            <if test="payAccount != null">
                #{payAccount,jdbcType=VARCHAR},
            </if>
            <if test="payStatus != null">
                #{payStatus,jdbcType=VARCHAR},
            </if>
            <if test="collectionAccount != null">
                #{collectionAccount,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderType != null">
                #{platformOrderType,jdbcType=VARCHAR},
            </if>
            <if test="website != null">
                #{website,jdbcType=VARCHAR},
            </if>
            <if test="createTime != null">
                #{createTime,jdbcType=TIMESTAMP},
            </if>
            <if test="purchaseCreateTime != null">
                #{purchaseCreateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="hasPaytime != null">
                #{hasPaytime,jdbcType=BIT},
            </if>
            <if test="paidTime != null">
                #{paidTime,jdbcType=TIMESTAMP},
            </if>
            <if test="refundTime != null">
                #{refundTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerId != null">
                #{sellerId,jdbcType=VARCHAR},
            </if>
            <if test="bailunAccountId != null">
                #{bailunAccountId,jdbcType=INTEGER},
            </if>
            <if test="hqAccount != null">
                #{hqAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerAccount != null">
                #{sellerAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerOrderId != null">
                #{sellerOrderId,jdbcType=VARCHAR},
            </if>
            <if test="sellerEmail != null">
                #{sellerEmail,jdbcType=VARCHAR},
            </if>
            <if test="orderUpdateTime != null">
                #{orderUpdateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerOrderExchangeRate != null">
                #{sellerOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="sellerOtherExchangeRate != null">
                #{sellerOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOrderExchangeRate != null">
                #{financeOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOtherExchangeRate != null">
                #{financeOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="cnyToUsdExchangeRate != null">
                #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderToUsdExchangeRate != null">
                #{orderToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="otherToUsdExchangeRate != null">
                #{otherToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderCurrency != null">
                #{orderCurrency,jdbcType=VARCHAR},
            </if>
            <if test="otherCurrency != null">
                #{otherCurrency,jdbcType=VARCHAR},
            </if>
            <if test="sellerName != null">
                #{sellerName,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderId != null">
                #{bailunOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderStatus != null">
                #{platformOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderStatus != null">
                #{bailunOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunPaymentStatus != null">
                #{bailunPaymentStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunInterceptionStatus != null">
                #{bailunInterceptionStatus,jdbcType=VARCHAR},
            </if>
            <if test="shippingStatus != null">
                #{shippingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunSku != null">
                #{bailunSku,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleEn != null">
                #{bailunSkuTitleEn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleCn != null">
                #{bailunSkuTitleCn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuQuantityOrdered != null">
                #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityShipped != null">
                #{bailunSkuQuantityShipped,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityRefund != null">
                #{bailunSkuQuantityRefund,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityPicked != null">
                #{bailunSkuQuantityPicked,jdbcType=INTEGER},
            </if>
            <if test="warehouseName != null">
                #{warehouseName,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCodeFba != null">
                #{warehouseCodeFba,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCode != null">
                #{warehouseCode,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuUnitPrice != null">
                #{bailunSkuUnitPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuWeight != null">
                #{bailunSkuWeight,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuSize != null">
                #{bailunSkuSize,jdbcType=VARCHAR},
            </if>
            <if test="amountSales != null">
                #{amountSales,jdbcType=DECIMAL},
            </if>
            <if test="amountTotal != null">
                #{amountTotal,jdbcType=DECIMAL},
            </if>
            <if test="amountShipping != null">
                #{amountShipping,jdbcType=DECIMAL},
            </if>
            <if test="amountProduct != null">
                #{amountProduct,jdbcType=DECIMAL},
            </if>
            <if test="amountTax != null">
                #{amountTax,jdbcType=DECIMAL},
            </if>
            <if test="amountAdjustment != null">
                #{amountAdjustment,jdbcType=DECIMAL},
            </if>
            <if test="amountGiftWrap != null">
                #{amountGiftWrap,jdbcType=DECIMAL},
            </if>
            <if test="amountRefund != null">
                #{amountRefund,jdbcType=DECIMAL},
            </if>
            <if test="amountPrepaid != null">
                #{amountPrepaid,jdbcType=DECIMAL},
            </if>
            <if test="costTotal != null">
                #{costTotal,jdbcType=DECIMAL},
            </if>
            <if test="costPromotion != null">
                #{costPromotion,jdbcType=DECIMAL},
            </if>
            <if test="costPlatformFee != null">
                #{costPlatformFee,jdbcType=DECIMAL},
            </if>
            <if test="costProduct != null">
                #{costProduct,jdbcType=DECIMAL},
            </if>
            <if test="costShipping != null">
                #{costShipping,jdbcType=DECIMAL},
            </if>
            <if test="costPackage != null">
                #{costPackage,jdbcType=DECIMAL},
            </if>
            <if test="costFbaFee != null">
                #{costFbaFee,jdbcType=DECIMAL},
            </if>
            <if test="costPaypalFee != null">
                #{costPaypalFee,jdbcType=DECIMAL},
            </if>
            <if test="costRefundCommisson != null">
                #{costRefundCommisson,jdbcType=DECIMAL},
            </if>
            <if test="costHandleBailun != null">
                #{costHandleBailun,jdbcType=DECIMAL},
            </if>
            <if test="costHandlePlatform != null">
                #{costHandlePlatform,jdbcType=DECIMAL},
            </if>
            <if test="costTail != null">
                #{costTail,jdbcType=DECIMAL},
            </if>
            <if test="costFirst != null">
                #{costFirst,jdbcType=DECIMAL},
            </if>
            <if test="costLogistics != null">
                #{costLogistics,jdbcType=DECIMAL},
            </if>
            <if test="profitTotal != null">
                #{profitTotal,jdbcType=DECIMAL},
            </if>
            <if test="profitRate != null">
                #{profitRate,jdbcType=DECIMAL},
            </if>
            <if test="receiptCountry != null">
                #{receiptCountry,jdbcType=VARCHAR},
            </if>
            <if test="receiptCity != null">
                #{receiptCity,jdbcType=VARCHAR},
            </if>
            <if test="receiptArea != null">
                #{receiptArea,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress != null">
                #{receiptAddress,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress2 != null">
                #{receiptAddress2,jdbcType=VARCHAR},
            </if>
            <if test="receiptPostalCode != null">
                #{receiptPostalCode,jdbcType=VARCHAR},
            </if>
            <if test="receiver != null">
                #{receiver,jdbcType=VARCHAR},
            </if>
            <if test="receiverPhone != null">
                #{receiverPhone,jdbcType=VARCHAR},
            </if>
            <if test="buyerId != null">
                #{buyerId,jdbcType=VARCHAR},
            </if>
            <if test="buyerName != null">
                #{buyerName,jdbcType=VARCHAR},
            </if>
            <if test="buyerEmail != null">
                #{buyerEmail,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaException != null">
                #{hasFbaException,jdbcType=BIT},
            </if>
            <if test="hasPlatformException != null">
                #{hasPlatformException,jdbcType=BIT},
            </if>
            <if test="hasCancle != null">
                #{hasCancle,jdbcType=BIT},
            </if>
            <if test="areaId != null">
                #{areaId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryId != null">
                #{bailunCategoryId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryName != null">
                #{bailunCategoryName,jdbcType=VARCHAR},
            </if>
            <if test="gmtCreate != null">
                #{gmtCreate,jdbcType=TIMESTAMP},
            </if>
            <if test="gmtModified != null">
                #{gmtModified,jdbcType=TIMESTAMP},
            </if>
            <if test="ratioWeight != null">
                #{ratioWeight,jdbcType=DECIMAL},
            </if>
            <if test="ratioPrice != null">
                #{ratioPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunPickingStatus != null">
                #{bailunPickingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunRequireLogistics != null">
                #{bailunRequireLogistics,jdbcType=VARCHAR},
            </if>
            <if test="hasDelete != null">
                #{hasDelete,jdbcType=BIT},
            </if>
            <if test="hasScalp != null">
                #{hasScalp,jdbcType=BIT},
            </if>
            <if test="hasBuyerRemark != null">
                #{hasBuyerRemark,jdbcType=BIT},
            </if>
            <if test="hasPlatskuRemark != null">
                #{hasPlatskuRemark,jdbcType=BIT},
            </if>
            <if test="logisticsMethodCode != null">
                #{logisticsMethodCode,jdbcType=VARCHAR},
            </if>
            <if test="logisticsMethodName != null">
                #{logisticsMethodName,jdbcType=VARCHAR},
            </if>
            <if test="hasInnersale != null">
                #{hasInnersale,jdbcType=BIT},
            </if>
            <if test="companyId != null">
                #{companyId,jdbcType=INTEGER},
            </if>
            <if test="bailunRefundStatus != null">
                #{bailunRefundStatus,jdbcType=VARCHAR},
            </if>
            <if test="refundObj != null">
                #{refundObj,jdbcType=VARCHAR},
            </if>
            <if test="refundType != null">
                #{refundType,jdbcType=VARCHAR},
            </if>
            <if test="refundReferenceId != null">
                #{refundReferenceId,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaS != null">
                #{hasFbaS,jdbcType=BIT},
            </if>
            <if test="bailunSkuQuantityPushed != null">
                #{bailunSkuQuantityPushed,jdbcType=INTEGER},
            </if>
            <if test="amountGeneralCargo != null">
                #{amountGeneralCargo,jdbcType=DECIMAL},
            </if>
            <if test="hasTransferOrder != null">
                #{hasTransferOrder,jdbcType=BIT},
            </if>
            <if test="warningType != null">
                #{warningType,jdbcType=VARCHAR},
            </if>
            <if test="warningTypeName != null">
                #{warningTypeName,jdbcType=VARCHAR},
            </if>
            <if test="totalFee != null">
                #{totalFee,jdbcType=DECIMAL},
            </if>
            <if test="shipping != null">
                #{shipping,jdbcType=DECIMAL},
            </if>
            <if test="opf != null">
                #{opf,jdbcType=DECIMAL},
            </if>
            <if test="fsc != null">
                #{fsc,jdbcType=DECIMAL},
            </if>
            <if test="dt != null">
                #{dt,jdbcType=DECIMAL},
            </if>
            <if test="rsf != null">
                #{rsf,jdbcType=DECIMAL},
            </if>
            <if test="otf != null">
                #{otf,jdbcType=DECIMAL},
            </if>
            <if test="whf != null">
                #{whf,jdbcType=DECIMAL},
            </if>
            <if test="currencyCode != null">
                #{currencyCode,jdbcType=VARCHAR},
            </if>
            <if test="wmsToCnyExchangeRate != null">
                #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="wmsToUsdExchangeRate != null">
                #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="shippingDeadlineReal != null">
                #{shippingDeadlineReal,jdbcType=TIMESTAMP},
            </if>
        </trim>
    </insert>
    <select id="countByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSkuExample"
            resultType="java.lang.Long">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        select count(*) from dc_base_oms_sku
        <if test="_parameter != null">
            <include refid="Example_Where_Clause"/>
        </if>
    </select>
    <update id="updateByExampleSelective" parameterType="map">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        update dc_base_oms_sku
        <set>
            <if test="record.id != null">
                id = #{record.id,jdbcType=INTEGER},
            </if>
            <if test="record.originOrderId != null">
                origin_order_id = #{record.originOrderId,jdbcType=VARCHAR},
            </if>
            <if test="record.platformType != null">
                platform_type = #{record.platformType,jdbcType=VARCHAR},
            </if>
            <if test="record.transactionId != null">
                transaction_id = #{record.transactionId,jdbcType=VARCHAR},
            </if>
            <if test="record.payTime != null">
                pay_time = #{record.payTime,jdbcType=TIMESTAMP},
            </if>
            <if test="record.payMethod != null">
                pay_method = #{record.payMethod,jdbcType=VARCHAR},
            </if>
            <if test="record.payAccount != null">
                pay_account = #{record.payAccount,jdbcType=VARCHAR},
            </if>
            <if test="record.payStatus != null">
                pay_status = #{record.payStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.collectionAccount != null">
                collection_account = #{record.collectionAccount,jdbcType=VARCHAR},
            </if>
            <if test="record.platformOrderType != null">
                platform_order_type = #{record.platformOrderType,jdbcType=VARCHAR},
            </if>
            <if test="record.website != null">
                website = #{record.website,jdbcType=VARCHAR},
            </if>
            <if test="record.createTime != null">
                create_time = #{record.createTime,jdbcType=TIMESTAMP},
            </if>
            <if test="record.purchaseCreateTime != null">
                purchase_create_time = #{record.purchaseCreateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="record.hasPaytime != null">
                has_paytime = #{record.hasPaytime,jdbcType=BIT},
            </if>
            <if test="record.paidTime != null">
                paid_time = #{record.paidTime,jdbcType=TIMESTAMP},
            </if>
            <if test="record.refundTime != null">
                refund_time = #{record.refundTime,jdbcType=TIMESTAMP},
            </if>
            <if test="record.sellerId != null">
                seller_id = #{record.sellerId,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunAccountId != null">
                bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
            </if>
            <if test="record.hqAccount != null">
                hq_account = #{record.hqAccount,jdbcType=VARCHAR},
            </if>
            <if test="record.sellerAccount != null">
                seller_account = #{record.sellerAccount,jdbcType=VARCHAR},
            </if>
            <if test="record.sellerOrderId != null">
                seller_order_id = #{record.sellerOrderId,jdbcType=VARCHAR},
            </if>
            <if test="record.sellerEmail != null">
                seller_email = #{record.sellerEmail,jdbcType=VARCHAR},
            </if>
            <if test="record.orderUpdateTime != null">
                order_update_time = #{record.orderUpdateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="record.sellerOrderExchangeRate != null">
                seller_order_exchange_rate = #{record.sellerOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.sellerOtherExchangeRate != null">
                seller_other_exchange_rate = #{record.sellerOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.financeOrderExchangeRate != null">
                finance_order_exchange_rate = #{record.financeOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.financeOtherExchangeRate != null">
                finance_other_exchange_rate = #{record.financeOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.cnyToUsdExchangeRate != null">
                cny_to_usd_exchange_rate = #{record.cnyToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.orderToUsdExchangeRate != null">
                order_to_usd_exchange_rate = #{record.orderToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.otherToUsdExchangeRate != null">
                other_to_usd_exchange_rate = #{record.otherToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.orderCurrency != null">
                order_currency = #{record.orderCurrency,jdbcType=VARCHAR},
            </if>
            <if test="record.otherCurrency != null">
                other_currency = #{record.otherCurrency,jdbcType=VARCHAR},
            </if>
            <if test="record.sellerName != null">
                seller_name = #{record.sellerName,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunOrderId != null">
                bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
            </if>
            <if test="record.platformOrderStatus != null">
                platform_order_status = #{record.platformOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunOrderStatus != null">
                bailun_order_status = #{record.bailunOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunPaymentStatus != null">
                bailun_payment_status = #{record.bailunPaymentStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunInterceptionStatus != null">
                bailun_interception_status = #{record.bailunInterceptionStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.shippingStatus != null">
                shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunSku != null">
                bailun_sku = #{record.bailunSku,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunSkuTitleEn != null">
                bailun_sku_title_en = #{record.bailunSkuTitleEn,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunSkuTitleCn != null">
                bailun_sku_title_cn = #{record.bailunSkuTitleCn,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunSkuQuantityOrdered != null">
                bailun_sku_quantity_ordered = #{record.bailunSkuQuantityOrdered,jdbcType=INTEGER},
            </if>
            <if test="record.bailunSkuQuantityShipped != null">
                bailun_sku_quantity_shipped = #{record.bailunSkuQuantityShipped,jdbcType=INTEGER},
            </if>
            <if test="record.bailunSkuQuantityRefund != null">
                bailun_sku_quantity_refund = #{record.bailunSkuQuantityRefund,jdbcType=INTEGER},
            </if>
            <if test="record.bailunSkuQuantityPicked != null">
                bailun_sku_quantity_picked = #{record.bailunSkuQuantityPicked,jdbcType=INTEGER},
            </if>
            <if test="record.warehouseName != null">
                warehouse_name = #{record.warehouseName,jdbcType=VARCHAR},
            </if>
            <if test="record.warehouseCodeFba != null">
                warehouse_code_fba = #{record.warehouseCodeFba,jdbcType=VARCHAR},
            </if>
            <if test="record.warehouseCode != null">
                warehouse_code = #{record.warehouseCode,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunSkuUnitPrice != null">
                bailun_sku_unit_price = #{record.bailunSkuUnitPrice,jdbcType=DECIMAL},
            </if>
            <if test="record.bailunSkuWeight != null">
                bailun_sku_weight = #{record.bailunSkuWeight,jdbcType=DECIMAL},
            </if>
            <if test="record.bailunSkuSize != null">
                bailun_sku_size = #{record.bailunSkuSize,jdbcType=VARCHAR},
            </if>
            <if test="record.amountSales != null">
                amount_sales = #{record.amountSales,jdbcType=DECIMAL},
            </if>
            <if test="record.amountTotal != null">
                amount_total = #{record.amountTotal,jdbcType=DECIMAL},
            </if>
            <if test="record.amountShipping != null">
                amount_shipping = #{record.amountShipping,jdbcType=DECIMAL},
            </if>
            <if test="record.amountProduct != null">
                amount_product = #{record.amountProduct,jdbcType=DECIMAL},
            </if>
            <if test="record.amountTax != null">
                amount_tax = #{record.amountTax,jdbcType=DECIMAL},
            </if>
            <if test="record.amountAdjustment != null">
                amount_adjustment = #{record.amountAdjustment,jdbcType=DECIMAL},
            </if>
            <if test="record.amountGiftWrap != null">
                amount_gift_wrap = #{record.amountGiftWrap,jdbcType=DECIMAL},
            </if>
            <if test="record.amountRefund != null">
                amount_refund = #{record.amountRefund,jdbcType=DECIMAL},
            </if>
            <if test="record.amountPrepaid != null">
                amount_prepaid = #{record.amountPrepaid,jdbcType=DECIMAL},
            </if>
            <if test="record.costTotal != null">
                cost_total = #{record.costTotal,jdbcType=DECIMAL},
            </if>
            <if test="record.costPromotion != null">
                cost_promotion = #{record.costPromotion,jdbcType=DECIMAL},
            </if>
            <if test="record.costPlatformFee != null">
                cost_platform_fee = #{record.costPlatformFee,jdbcType=DECIMAL},
            </if>
            <if test="record.costProduct != null">
                cost_product = #{record.costProduct,jdbcType=DECIMAL},
            </if>
            <if test="record.costShipping != null">
                cost_shipping = #{record.costShipping,jdbcType=DECIMAL},
            </if>
            <if test="record.costPackage != null">
                cost_package = #{record.costPackage,jdbcType=DECIMAL},
            </if>
            <if test="record.costFbaFee != null">
                cost_fba_fee = #{record.costFbaFee,jdbcType=DECIMAL},
            </if>
            <if test="record.costPaypalFee != null">
                cost_paypal_fee = #{record.costPaypalFee,jdbcType=DECIMAL},
            </if>
            <if test="record.costRefundCommisson != null">
                cost_refund_commisson = #{record.costRefundCommisson,jdbcType=DECIMAL},
            </if>
            <if test="record.costHandleBailun != null">
                cost_handle_bailun = #{record.costHandleBailun,jdbcType=DECIMAL},
            </if>
            <if test="record.costHandlePlatform != null">
                cost_handle_platform = #{record.costHandlePlatform,jdbcType=DECIMAL},
            </if>
            <if test="record.costTail != null">
                cost_tail = #{record.costTail,jdbcType=DECIMAL},
            </if>
            <if test="record.costFirst != null">
                cost_first = #{record.costFirst,jdbcType=DECIMAL},
            </if>
            <if test="record.costLogistics != null">
                cost_logistics = #{record.costLogistics,jdbcType=DECIMAL},
            </if>
            <if test="record.profitTotal != null">
                profit_total = #{record.profitTotal,jdbcType=DECIMAL},
            </if>
            <if test="record.profitRate != null">
                profit_rate = #{record.profitRate,jdbcType=DECIMAL},
            </if>
            <if test="record.receiptCountry != null">
                receipt_country = #{record.receiptCountry,jdbcType=VARCHAR},
            </if>
            <if test="record.receiptCity != null">
                receipt_city = #{record.receiptCity,jdbcType=VARCHAR},
            </if>
            <if test="record.receiptArea != null">
                receipt_area = #{record.receiptArea,jdbcType=VARCHAR},
            </if>
            <if test="record.receiptAddress != null">
                receipt_address = #{record.receiptAddress,jdbcType=VARCHAR},
            </if>
            <if test="record.receiptAddress2 != null">
                receipt_address_2 = #{record.receiptAddress2,jdbcType=VARCHAR},
            </if>
            <if test="record.receiptPostalCode != null">
                receipt_postal_code = #{record.receiptPostalCode,jdbcType=VARCHAR},
            </if>
            <if test="record.receiver != null">
                receiver = #{record.receiver,jdbcType=VARCHAR},
            </if>
            <if test="record.receiverPhone != null">
                receiver_phone = #{record.receiverPhone,jdbcType=VARCHAR},
            </if>
            <if test="record.buyerId != null">
                buyer_id = #{record.buyerId,jdbcType=VARCHAR},
            </if>
            <if test="record.buyerName != null">
                buyer_name = #{record.buyerName,jdbcType=VARCHAR},
            </if>
            <if test="record.buyerEmail != null">
                buyer_email = #{record.buyerEmail,jdbcType=VARCHAR},
            </if>
            <if test="record.hasFbaException != null">
                has_fba_exception = #{record.hasFbaException,jdbcType=BIT},
            </if>
            <if test="record.hasPlatformException != null">
                has_platform_exception = #{record.hasPlatformException,jdbcType=BIT},
            </if>
            <if test="record.hasCancle != null">
                has_cancle = #{record.hasCancle,jdbcType=BIT},
            </if>
            <if test="record.areaId != null">
                area_id = #{record.areaId,jdbcType=INTEGER},
            </if>
            <if test="record.bailunCategoryId != null">
                bailun_category_id = #{record.bailunCategoryId,jdbcType=INTEGER},
            </if>
            <if test="record.bailunCategoryName != null">
                bailun_category_name = #{record.bailunCategoryName,jdbcType=VARCHAR},
            </if>
            <if test="record.gmtCreate != null">
                gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
            </if>
            <if test="record.gmtModified != null">
                gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
            </if>
            <if test="record.ratioWeight != null">
                ratio_weight = #{record.ratioWeight,jdbcType=DECIMAL},
            </if>
            <if test="record.ratioPrice != null">
                ratio_price = #{record.ratioPrice,jdbcType=DECIMAL},
            </if>
            <if test="record.bailunPickingStatus != null">
                bailun_picking_status = #{record.bailunPickingStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.bailunRequireLogistics != null">
                bailun_require_logistics = #{record.bailunRequireLogistics,jdbcType=VARCHAR},
            </if>
            <if test="record.hasDelete != null">
                has_delete = #{record.hasDelete,jdbcType=BIT},
            </if>
            <if test="record.hasScalp != null">
                has_scalp = #{record.hasScalp,jdbcType=BIT},
            </if>
            <if test="record.hasBuyerRemark != null">
                has_buyer_remark = #{record.hasBuyerRemark,jdbcType=BIT},
            </if>
            <if test="record.hasPlatskuRemark != null">
                has_platsku_remark = #{record.hasPlatskuRemark,jdbcType=BIT},
            </if>
            <if test="record.logisticsMethodCode != null">
                logistics_method_code = #{record.logisticsMethodCode,jdbcType=VARCHAR},
            </if>
            <if test="record.logisticsMethodName != null">
                logistics_method_name = #{record.logisticsMethodName,jdbcType=VARCHAR},
            </if>
            <if test="record.hasInnersale != null">
                has_innersale = #{record.hasInnersale,jdbcType=BIT},
            </if>
            <if test="record.companyId != null">
                company_id = #{record.companyId,jdbcType=INTEGER},
            </if>
            <if test="record.bailunRefundStatus != null">
                bailun_refund_status = #{record.bailunRefundStatus,jdbcType=VARCHAR},
            </if>
            <if test="record.refundObj != null">
                refund_obj = #{record.refundObj,jdbcType=VARCHAR},
            </if>
            <if test="record.refundType != null">
                refund_type = #{record.refundType,jdbcType=VARCHAR},
            </if>
            <if test="record.refundReferenceId != null">
                refund_reference_id = #{record.refundReferenceId,jdbcType=VARCHAR},
            </if>
            <if test="record.hasFbaS != null">
                has_fba_s = #{record.hasFbaS,jdbcType=BIT},
            </if>
            <if test="record.bailunSkuQuantityPushed != null">
                bailun_sku_quantity_pushed = #{record.bailunSkuQuantityPushed,jdbcType=INTEGER},
            </if>
            <if test="record.amountGeneralCargo != null">
                amount_general_cargo = #{record.amountGeneralCargo,jdbcType=DECIMAL},
            </if>
            <if test="record.hasTransferOrder != null">
                has_transfer_order = #{record.hasTransferOrder,jdbcType=BIT},
            </if>
            <if test="record.warningType != null">
                warning_type = #{record.warningType,jdbcType=VARCHAR},
            </if>
            <if test="record.warningTypeName != null">
                warning_type_name = #{record.warningTypeName,jdbcType=VARCHAR},
            </if>
            <if test="record.totalFee != null">
                total_fee = #{record.totalFee,jdbcType=DECIMAL},
            </if>
            <if test="record.shipping != null">
                shipping = #{record.shipping,jdbcType=DECIMAL},
            </if>
            <if test="record.opf != null">
                opf = #{record.opf,jdbcType=DECIMAL},
            </if>
            <if test="record.fsc != null">
                fsc = #{record.fsc,jdbcType=DECIMAL},
            </if>
            <if test="record.dt != null">
                dt = #{record.dt,jdbcType=DECIMAL},
            </if>
            <if test="record.rsf != null">
                rsf = #{record.rsf,jdbcType=DECIMAL},
            </if>
            <if test="record.otf != null">
                otf = #{record.otf,jdbcType=DECIMAL},
            </if>
            <if test="record.whf != null">
                whf = #{record.whf,jdbcType=DECIMAL},
            </if>
            <if test="record.currencyCode != null">
                currency_code = #{record.currencyCode,jdbcType=VARCHAR},
            </if>
            <if test="record.wmsToCnyExchangeRate != null">
                wms_to_cny_exchange_rate = #{record.wmsToCnyExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.wmsToUsdExchangeRate != null">
                wms_to_usd_exchange_rate = #{record.wmsToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="record.shippingDeadlineReal != null">
                shipping_deadline_real = #{record.shippingDeadlineReal,jdbcType=TIMESTAMP},
            </if>
        </set>
        <if test="_parameter != null">
            <include refid="Update_By_Example_Where_Clause"/>
        </if>
    </update>
    <update id="updateByExample" parameterType="map">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        update dc_base_oms_sku
        set id = #{record.id,jdbcType=INTEGER},
        origin_order_id = #{record.originOrderId,jdbcType=VARCHAR},
        platform_type = #{record.platformType,jdbcType=VARCHAR},
        transaction_id = #{record.transactionId,jdbcType=VARCHAR},
        pay_time = #{record.payTime,jdbcType=TIMESTAMP},
        pay_method = #{record.payMethod,jdbcType=VARCHAR},
        pay_account = #{record.payAccount,jdbcType=VARCHAR},
        pay_status = #{record.payStatus,jdbcType=VARCHAR},
        collection_account = #{record.collectionAccount,jdbcType=VARCHAR},
        platform_order_type = #{record.platformOrderType,jdbcType=VARCHAR},
        website = #{record.website,jdbcType=VARCHAR},
        create_time = #{record.createTime,jdbcType=TIMESTAMP},
        purchase_create_time = #{record.purchaseCreateTime,jdbcType=TIMESTAMP},
        has_paytime = #{record.hasPaytime,jdbcType=BIT},
        paid_time = #{record.paidTime,jdbcType=TIMESTAMP},
        refund_time = #{record.refundTime,jdbcType=TIMESTAMP},
        seller_id = #{record.sellerId,jdbcType=VARCHAR},
        bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
        hq_account = #{record.hqAccount,jdbcType=VARCHAR},
        seller_account = #{record.sellerAccount,jdbcType=VARCHAR},
        seller_order_id = #{record.sellerOrderId,jdbcType=VARCHAR},
        seller_email = #{record.sellerEmail,jdbcType=VARCHAR},
        order_update_time = #{record.orderUpdateTime,jdbcType=TIMESTAMP},
        seller_order_exchange_rate = #{record.sellerOrderExchangeRate,jdbcType=DECIMAL},
        seller_other_exchange_rate = #{record.sellerOtherExchangeRate,jdbcType=DECIMAL},
        finance_order_exchange_rate = #{record.financeOrderExchangeRate,jdbcType=DECIMAL},
        finance_other_exchange_rate = #{record.financeOtherExchangeRate,jdbcType=DECIMAL},
        cny_to_usd_exchange_rate = #{record.cnyToUsdExchangeRate,jdbcType=DECIMAL},
        order_to_usd_exchange_rate = #{record.orderToUsdExchangeRate,jdbcType=DECIMAL},
        other_to_usd_exchange_rate = #{record.otherToUsdExchangeRate,jdbcType=DECIMAL},
        order_currency = #{record.orderCurrency,jdbcType=VARCHAR},
        other_currency = #{record.otherCurrency,jdbcType=VARCHAR},
        seller_name = #{record.sellerName,jdbcType=VARCHAR},
        bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
        platform_order_status = #{record.platformOrderStatus,jdbcType=VARCHAR},
        bailun_order_status = #{record.bailunOrderStatus,jdbcType=VARCHAR},
        bailun_payment_status = #{record.bailunPaymentStatus,jdbcType=VARCHAR},
        bailun_interception_status = #{record.bailunInterceptionStatus,jdbcType=VARCHAR},
        shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
        bailun_sku = #{record.bailunSku,jdbcType=VARCHAR},
        bailun_sku_title_en = #{record.bailunSkuTitleEn,jdbcType=VARCHAR},
        bailun_sku_title_cn = #{record.bailunSkuTitleCn,jdbcType=VARCHAR},
        bailun_sku_quantity_ordered = #{record.bailunSkuQuantityOrdered,jdbcType=INTEGER},
        bailun_sku_quantity_shipped = #{record.bailunSkuQuantityShipped,jdbcType=INTEGER},
        bailun_sku_quantity_refund = #{record.bailunSkuQuantityRefund,jdbcType=INTEGER},
        bailun_sku_quantity_picked = #{record.bailunSkuQuantityPicked,jdbcType=INTEGER},
        warehouse_name = #{record.warehouseName,jdbcType=VARCHAR},
        warehouse_code_fba = #{record.warehouseCodeFba,jdbcType=VARCHAR},
        warehouse_code = #{record.warehouseCode,jdbcType=VARCHAR},
        bailun_sku_unit_price = #{record.bailunSkuUnitPrice,jdbcType=DECIMAL},
        bailun_sku_weight = #{record.bailunSkuWeight,jdbcType=DECIMAL},
        bailun_sku_size = #{record.bailunSkuSize,jdbcType=VARCHAR},
        amount_sales = #{record.amountSales,jdbcType=DECIMAL},
        amount_total = #{record.amountTotal,jdbcType=DECIMAL},
        amount_shipping = #{record.amountShipping,jdbcType=DECIMAL},
        amount_product = #{record.amountProduct,jdbcType=DECIMAL},
        amount_tax = #{record.amountTax,jdbcType=DECIMAL},
        amount_adjustment = #{record.amountAdjustment,jdbcType=DECIMAL},
        amount_gift_wrap = #{record.amountGiftWrap,jdbcType=DECIMAL},
        amount_refund = #{record.amountRefund,jdbcType=DECIMAL},
        amount_prepaid = #{record.amountPrepaid,jdbcType=DECIMAL},
        cost_total = #{record.costTotal,jdbcType=DECIMAL},
        cost_promotion = #{record.costPromotion,jdbcType=DECIMAL},
        cost_platform_fee = #{record.costPlatformFee,jdbcType=DECIMAL},
        cost_product = #{record.costProduct,jdbcType=DECIMAL},
        cost_shipping = #{record.costShipping,jdbcType=DECIMAL},
        cost_package = #{record.costPackage,jdbcType=DECIMAL},
        cost_fba_fee = #{record.costFbaFee,jdbcType=DECIMAL},
        cost_paypal_fee = #{record.costPaypalFee,jdbcType=DECIMAL},
        cost_refund_commisson = #{record.costRefundCommisson,jdbcType=DECIMAL},
        cost_handle_bailun = #{record.costHandleBailun,jdbcType=DECIMAL},
        cost_handle_platform = #{record.costHandlePlatform,jdbcType=DECIMAL},
        cost_tail = #{record.costTail,jdbcType=DECIMAL},
        cost_first = #{record.costFirst,jdbcType=DECIMAL},
        cost_logistics = #{record.costLogistics,jdbcType=DECIMAL},
        profit_total = #{record.profitTotal,jdbcType=DECIMAL},
        profit_rate = #{record.profitRate,jdbcType=DECIMAL},
        receipt_country = #{record.receiptCountry,jdbcType=VARCHAR},
        receipt_city = #{record.receiptCity,jdbcType=VARCHAR},
        receipt_area = #{record.receiptArea,jdbcType=VARCHAR},
        receipt_address = #{record.receiptAddress,jdbcType=VARCHAR},
        receipt_address_2 = #{record.receiptAddress2,jdbcType=VARCHAR},
        receipt_postal_code = #{record.receiptPostalCode,jdbcType=VARCHAR},
        receiver = #{record.receiver,jdbcType=VARCHAR},
        receiver_phone = #{record.receiverPhone,jdbcType=VARCHAR},
        buyer_id = #{record.buyerId,jdbcType=VARCHAR},
        buyer_name = #{record.buyerName,jdbcType=VARCHAR},
        buyer_email = #{record.buyerEmail,jdbcType=VARCHAR},
        has_fba_exception = #{record.hasFbaException,jdbcType=BIT},
        has_platform_exception = #{record.hasPlatformException,jdbcType=BIT},
        has_cancle = #{record.hasCancle,jdbcType=BIT},
        area_id = #{record.areaId,jdbcType=INTEGER},
        bailun_category_id = #{record.bailunCategoryId,jdbcType=INTEGER},
        bailun_category_name = #{record.bailunCategoryName,jdbcType=VARCHAR},
        gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
        gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
        ratio_weight = #{record.ratioWeight,jdbcType=DECIMAL},
        ratio_price = #{record.ratioPrice,jdbcType=DECIMAL},
        bailun_picking_status = #{record.bailunPickingStatus,jdbcType=VARCHAR},
        bailun_require_logistics = #{record.bailunRequireLogistics,jdbcType=VARCHAR},
        has_delete = #{record.hasDelete,jdbcType=BIT},
        has_scalp = #{record.hasScalp,jdbcType=BIT},
        has_buyer_remark = #{record.hasBuyerRemark,jdbcType=BIT},
        has_platsku_remark = #{record.hasPlatskuRemark,jdbcType=BIT},
        logistics_method_code = #{record.logisticsMethodCode,jdbcType=VARCHAR},
        logistics_method_name = #{record.logisticsMethodName,jdbcType=VARCHAR},
        has_innersale = #{record.hasInnersale,jdbcType=BIT},
        company_id = #{record.companyId,jdbcType=INTEGER},
        bailun_refund_status = #{record.bailunRefundStatus,jdbcType=VARCHAR},
        refund_obj = #{record.refundObj,jdbcType=VARCHAR},
        refund_type = #{record.refundType,jdbcType=VARCHAR},
        refund_reference_id = #{record.refundReferenceId,jdbcType=VARCHAR},
        has_fba_s = #{record.hasFbaS,jdbcType=BIT},
        bailun_sku_quantity_pushed = #{record.bailunSkuQuantityPushed,jdbcType=INTEGER},
        amount_general_cargo = #{record.amountGeneralCargo,jdbcType=DECIMAL},
        has_transfer_order = #{record.hasTransferOrder,jdbcType=BIT},
        warning_type = #{record.warningType,jdbcType=VARCHAR},
        warning_type_name = #{record.warningTypeName,jdbcType=VARCHAR},
        total_fee = #{record.totalFee,jdbcType=DECIMAL},
        shipping = #{record.shipping,jdbcType=DECIMAL},
        opf = #{record.opf,jdbcType=DECIMAL},
        fsc = #{record.fsc,jdbcType=DECIMAL},
        dt = #{record.dt,jdbcType=DECIMAL},
        rsf = #{record.rsf,jdbcType=DECIMAL},
        otf = #{record.otf,jdbcType=DECIMAL},
        whf = #{record.whf,jdbcType=DECIMAL},
        currency_code = #{record.currencyCode,jdbcType=VARCHAR},
        wms_to_cny_exchange_rate = #{record.wmsToCnyExchangeRate,jdbcType=DECIMAL},
        wms_to_usd_exchange_rate = #{record.wmsToUsdExchangeRate,jdbcType=DECIMAL},
        shipping_deadline_real = #{record.shippingDeadlineReal,jdbcType=TIMESTAMP}
        <if test="_parameter != null">
            <include refid="Update_By_Example_Where_Clause"/>
        </if>
    </update>
    <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        update dc_base_oms_sku
        <set>
            <if test="originOrderId != null">
                origin_order_id = #{originOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformType != null">
                platform_type = #{platformType,jdbcType=VARCHAR},
            </if>
            <if test="transactionId != null">
                transaction_id = #{transactionId,jdbcType=VARCHAR},
            </if>
            <if test="payTime != null">
                pay_time = #{payTime,jdbcType=TIMESTAMP},
            </if>
            <if test="payMethod != null">
                pay_method = #{payMethod,jdbcType=VARCHAR},
            </if>
            <if test="payAccount != null">
                pay_account = #{payAccount,jdbcType=VARCHAR},
            </if>
            <if test="payStatus != null">
                pay_status = #{payStatus,jdbcType=VARCHAR},
            </if>
            <if test="collectionAccount != null">
                collection_account = #{collectionAccount,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderType != null">
                platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
            </if>
            <if test="website != null">
                website = #{website,jdbcType=VARCHAR},
            </if>
            <if test="createTime != null">
                create_time = #{createTime,jdbcType=TIMESTAMP},
            </if>
            <if test="purchaseCreateTime != null">
                purchase_create_time = #{purchaseCreateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="hasPaytime != null">
                has_paytime = #{hasPaytime,jdbcType=BIT},
            </if>
            <if test="paidTime != null">
                paid_time = #{paidTime,jdbcType=TIMESTAMP},
            </if>
            <if test="refundTime != null">
                refund_time = #{refundTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerId != null">
                seller_id = #{sellerId,jdbcType=VARCHAR},
            </if>
            <if test="bailunAccountId != null">
                bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
            </if>
            <if test="hqAccount != null">
                hq_account = #{hqAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerAccount != null">
                seller_account = #{sellerAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerOrderId != null">
                seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
            </if>
            <if test="sellerEmail != null">
                seller_email = #{sellerEmail,jdbcType=VARCHAR},
            </if>
            <if test="orderUpdateTime != null">
                order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerOrderExchangeRate != null">
                seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="sellerOtherExchangeRate != null">
                seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOrderExchangeRate != null">
                finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOtherExchangeRate != null">
                finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="cnyToUsdExchangeRate != null">
                cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderToUsdExchangeRate != null">
                order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="otherToUsdExchangeRate != null">
                other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderCurrency != null">
                order_currency = #{orderCurrency,jdbcType=VARCHAR},
            </if>
            <if test="otherCurrency != null">
                other_currency = #{otherCurrency,jdbcType=VARCHAR},
            </if>
            <if test="sellerName != null">
                seller_name = #{sellerName,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderId != null">
                bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderStatus != null">
                platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderStatus != null">
                bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunPaymentStatus != null">
                bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunInterceptionStatus != null">
                bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
            </if>
            <if test="shippingStatus != null">
                shipping_status = #{shippingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunSku != null">
                bailun_sku = #{bailunSku,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleEn != null">
                bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleCn != null">
                bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuQuantityOrdered != null">
                bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityShipped != null">
                bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityRefund != null">
                bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityPicked != null">
                bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
            </if>
            <if test="warehouseName != null">
                warehouse_name = #{warehouseName,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCodeFba != null">
                warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCode != null">
                warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuUnitPrice != null">
                bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuWeight != null">
                bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuSize != null">
                bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
            </if>
            <if test="amountSales != null">
                amount_sales = #{amountSales,jdbcType=DECIMAL},
            </if>
            <if test="amountTotal != null">
                amount_total = #{amountTotal,jdbcType=DECIMAL},
            </if>
            <if test="amountShipping != null">
                amount_shipping = #{amountShipping,jdbcType=DECIMAL},
            </if>
            <if test="amountProduct != null">
                amount_product = #{amountProduct,jdbcType=DECIMAL},
            </if>
            <if test="amountTax != null">
                amount_tax = #{amountTax,jdbcType=DECIMAL},
            </if>
            <if test="amountAdjustment != null">
                amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
            </if>
            <if test="amountGiftWrap != null">
                amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
            </if>
            <if test="amountRefund != null">
                amount_refund = #{amountRefund,jdbcType=DECIMAL},
            </if>
            <if test="amountPrepaid != null">
                amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
            </if>
            <if test="costTotal != null">
                cost_total = #{costTotal,jdbcType=DECIMAL},
            </if>
            <if test="costPromotion != null">
                cost_promotion = #{costPromotion,jdbcType=DECIMAL},
            </if>
            <if test="costPlatformFee != null">
                cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
            </if>
            <if test="costProduct != null">
                cost_product = #{costProduct,jdbcType=DECIMAL},
            </if>
            <if test="costShipping != null">
                cost_shipping = #{costShipping,jdbcType=DECIMAL},
            </if>
            <if test="costPackage != null">
                cost_package = #{costPackage,jdbcType=DECIMAL},
            </if>
            <if test="costFbaFee != null">
                cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
            </if>
            <if test="costPaypalFee != null">
                cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
            </if>
            <if test="costRefundCommisson != null">
                cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
            </if>
            <if test="costHandleBailun != null">
                cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
            </if>
            <if test="costHandlePlatform != null">
                cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
            </if>
            <if test="costTail != null">
                cost_tail = #{costTail,jdbcType=DECIMAL},
            </if>
            <if test="costFirst != null">
                cost_first = #{costFirst,jdbcType=DECIMAL},
            </if>
            <if test="costLogistics != null">
                cost_logistics = #{costLogistics,jdbcType=DECIMAL},
            </if>
            <if test="profitTotal != null">
                profit_total = #{profitTotal,jdbcType=DECIMAL},
            </if>
            <if test="profitRate != null">
                profit_rate = #{profitRate,jdbcType=DECIMAL},
            </if>
            <if test="receiptCountry != null">
                receipt_country = #{receiptCountry,jdbcType=VARCHAR},
            </if>
            <if test="receiptCity != null">
                receipt_city = #{receiptCity,jdbcType=VARCHAR},
            </if>
            <if test="receiptArea != null">
                receipt_area = #{receiptArea,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress != null">
                receipt_address = #{receiptAddress,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress2 != null">
                receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
            </if>
            <if test="receiptPostalCode != null">
                receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
            </if>
            <if test="receiver != null">
                receiver = #{receiver,jdbcType=VARCHAR},
            </if>
            <if test="receiverPhone != null">
                receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
            </if>
            <if test="buyerId != null">
                buyer_id = #{buyerId,jdbcType=VARCHAR},
            </if>
            <if test="buyerName != null">
                buyer_name = #{buyerName,jdbcType=VARCHAR},
            </if>
            <if test="buyerEmail != null">
                buyer_email = #{buyerEmail,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaException != null">
                has_fba_exception = #{hasFbaException,jdbcType=BIT},
            </if>
            <if test="hasPlatformException != null">
                has_platform_exception = #{hasPlatformException,jdbcType=BIT},
            </if>
            <if test="hasCancle != null">
                has_cancle = #{hasCancle,jdbcType=BIT},
            </if>
            <if test="areaId != null">
                area_id = #{areaId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryId != null">
                bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryName != null">
                bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
            </if>
            <if test="gmtCreate != null">
                gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
            </if>
            <if test="gmtModified != null">
                gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
            </if>
            <if test="ratioWeight != null">
                ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
            </if>
            <if test="ratioPrice != null">
                ratio_price = #{ratioPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunPickingStatus != null">
                bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunRequireLogistics != null">
                bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
            </if>
            <if test="hasDelete != null">
                has_delete = #{hasDelete,jdbcType=BIT},
            </if>
            <if test="hasScalp != null">
                has_scalp = #{hasScalp,jdbcType=BIT},
            </if>
            <if test="hasBuyerRemark != null">
                has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
            </if>
            <if test="hasPlatskuRemark != null">
                has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
            </if>
            <if test="logisticsMethodCode != null">
                logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
            </if>
            <if test="logisticsMethodName != null">
                logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
            </if>
            <if test="hasInnersale != null">
                has_innersale = #{hasInnersale,jdbcType=BIT},
            </if>
            <if test="companyId != null">
                company_id = #{companyId,jdbcType=INTEGER},
            </if>
            <if test="bailunRefundStatus != null">
                bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
            </if>
            <if test="refundObj != null">
                refund_obj = #{refundObj,jdbcType=VARCHAR},
            </if>
            <if test="refundType != null">
                refund_type = #{refundType,jdbcType=VARCHAR},
            </if>
            <if test="refundReferenceId != null">
                refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaS != null">
                has_fba_s = #{hasFbaS,jdbcType=BIT},
            </if>
            <if test="bailunSkuQuantityPushed != null">
                bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
            </if>
            <if test="amountGeneralCargo != null">
                amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
            </if>
            <if test="hasTransferOrder != null">
                has_transfer_order = #{hasTransferOrder,jdbcType=BIT},
            </if>
            <if test="warningType != null">
                warning_type = #{warningType,jdbcType=VARCHAR},
            </if>
            <if test="warningTypeName != null">
                warning_type_name = #{warningTypeName,jdbcType=VARCHAR},
            </if>
            <if test="totalFee != null">
                total_fee = #{totalFee,jdbcType=DECIMAL},
            </if>
            <if test="shipping != null">
                shipping = #{shipping,jdbcType=DECIMAL},
            </if>
            <if test="opf != null">
                opf = #{opf,jdbcType=DECIMAL},
            </if>
            <if test="fsc != null">
                fsc = #{fsc,jdbcType=DECIMAL},
            </if>
            <if test="dt != null">
                dt = #{dt,jdbcType=DECIMAL},
            </if>
            <if test="rsf != null">
                rsf = #{rsf,jdbcType=DECIMAL},
            </if>
            <if test="otf != null">
                otf = #{otf,jdbcType=DECIMAL},
            </if>
            <if test="whf != null">
                whf = #{whf,jdbcType=DECIMAL},
            </if>
            <if test="currencyCode != null">
                currency_code = #{currencyCode,jdbcType=VARCHAR},
            </if>
            <if test="wmsToCnyExchangeRate != null">
                wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="wmsToUsdExchangeRate != null">
                wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="shippingDeadlineReal != null">
                shipping_deadline_real = #{shippingDeadlineReal,jdbcType=TIMESTAMP},
            </if>
        </set>
        where id = #{id,jdbcType=INTEGER}
    </update>
    <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
        update dc_base_oms_sku
        set origin_order_id = #{originOrderId,jdbcType=VARCHAR},
        platform_type = #{platformType,jdbcType=VARCHAR},
        transaction_id = #{transactionId,jdbcType=VARCHAR},
        pay_time = #{payTime,jdbcType=TIMESTAMP},
        pay_method = #{payMethod,jdbcType=VARCHAR},
        pay_account = #{payAccount,jdbcType=VARCHAR},
        pay_status = #{payStatus,jdbcType=VARCHAR},
        collection_account = #{collectionAccount,jdbcType=VARCHAR},
        platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
        website = #{website,jdbcType=VARCHAR},
        create_time = #{createTime,jdbcType=TIMESTAMP},
        purchase_create_time = #{purchaseCreateTime,jdbcType=TIMESTAMP},
        has_paytime = #{hasPaytime,jdbcType=BIT},
        paid_time = #{paidTime,jdbcType=TIMESTAMP},
        refund_time = #{refundTime,jdbcType=TIMESTAMP},
        seller_id = #{sellerId,jdbcType=VARCHAR},
        bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
        hq_account = #{hqAccount,jdbcType=VARCHAR},
        seller_account = #{sellerAccount,jdbcType=VARCHAR},
        seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
        seller_email = #{sellerEmail,jdbcType=VARCHAR},
        order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
        seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
        seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
        finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
        finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
        cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
        order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
        other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
        order_currency = #{orderCurrency,jdbcType=VARCHAR},
        other_currency = #{otherCurrency,jdbcType=VARCHAR},
        seller_name = #{sellerName,jdbcType=VARCHAR},
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
        platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
        bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
        bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
        bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
        bailun_sku = #{bailunSku,jdbcType=VARCHAR},
        bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
        bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
        bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
        bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
        bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
        bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
        warehouse_name = #{warehouseName,jdbcType=VARCHAR},
        warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
        warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
        bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
        bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
        bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
        amount_sales = #{amountSales,jdbcType=DECIMAL},
        amount_total = #{amountTotal,jdbcType=DECIMAL},
        amount_shipping = #{amountShipping,jdbcType=DECIMAL},
        amount_product = #{amountProduct,jdbcType=DECIMAL},
        amount_tax = #{amountTax,jdbcType=DECIMAL},
        amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
        amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
        amount_refund = #{amountRefund,jdbcType=DECIMAL},
        amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
        cost_total = #{costTotal,jdbcType=DECIMAL},
        cost_promotion = #{costPromotion,jdbcType=DECIMAL},
        cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
        cost_product = #{costProduct,jdbcType=DECIMAL},
        cost_shipping = #{costShipping,jdbcType=DECIMAL},
        cost_package = #{costPackage,jdbcType=DECIMAL},
        cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
        cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
        cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
        cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
        cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
        cost_tail = #{costTail,jdbcType=DECIMAL},
        cost_first = #{costFirst,jdbcType=DECIMAL},
        cost_logistics = #{costLogistics,jdbcType=DECIMAL},
        profit_total = #{profitTotal,jdbcType=DECIMAL},
        profit_rate = #{profitRate,jdbcType=DECIMAL},
        receipt_country = #{receiptCountry,jdbcType=VARCHAR},
        receipt_city = #{receiptCity,jdbcType=VARCHAR},
        receipt_area = #{receiptArea,jdbcType=VARCHAR},
        receipt_address = #{receiptAddress,jdbcType=VARCHAR},
        receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
        receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
        receiver = #{receiver,jdbcType=VARCHAR},
        receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
        buyer_id = #{buyerId,jdbcType=VARCHAR},
        buyer_name = #{buyerName,jdbcType=VARCHAR},
        buyer_email = #{buyerEmail,jdbcType=VARCHAR},
        has_fba_exception = #{hasFbaException,jdbcType=BIT},
        has_platform_exception = #{hasPlatformException,jdbcType=BIT},
        has_cancle = #{hasCancle,jdbcType=BIT},
        area_id = #{areaId,jdbcType=INTEGER},
        bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
        bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
        ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
        ratio_price = #{ratioPrice,jdbcType=DECIMAL},
        bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
        bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
        has_delete = #{hasDelete,jdbcType=BIT},
        has_scalp = #{hasScalp,jdbcType=BIT},
        has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
        has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
        logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
        logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
        has_innersale = #{hasInnersale,jdbcType=BIT},
        company_id = #{companyId,jdbcType=INTEGER},
        bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
        refund_obj = #{refundObj,jdbcType=VARCHAR},
        refund_type = #{refundType,jdbcType=VARCHAR},
        refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
        has_fba_s = #{hasFbaS,jdbcType=BIT},
        bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
        amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
        has_transfer_order = #{hasTransferOrder,jdbcType=BIT},
        warning_type = #{warningType,jdbcType=VARCHAR},
        warning_type_name = #{warningTypeName,jdbcType=VARCHAR},
        total_fee = #{totalFee,jdbcType=DECIMAL},
        shipping = #{shipping,jdbcType=DECIMAL},
        opf = #{opf,jdbcType=DECIMAL},
        fsc = #{fsc,jdbcType=DECIMAL},
        dt = #{dt,jdbcType=DECIMAL},
        rsf = #{rsf,jdbcType=DECIMAL},
        otf = #{otf,jdbcType=DECIMAL},
        whf = #{whf,jdbcType=DECIMAL},
        currency_code = #{currencyCode,jdbcType=VARCHAR},
        wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
        wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
        shipping_deadline_real = #{shippingDeadlineReal,jdbcType=TIMESTAMP}
        where id = #{id,jdbcType=INTEGER}
    </update>
    <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
        insert into dc_base_oms_sku
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                id,
            </if>
            <if test="originOrderId != null">
                origin_order_id,
            </if>
            <if test="platformType != null">
                platform_type,
            </if>
            <if test="transactionId != null">
                transaction_id,
            </if>
            <if test="payTime != null">
                pay_time,
            </if>
            <if test="payMethod != null">
                pay_method,
            </if>
            <if test="payAccount != null">
                pay_account,
            </if>
            <if test="payStatus != null">
                pay_status,
            </if>
            <if test="collectionAccount != null">
                collection_account,
            </if>
            <if test="platformOrderType != null">
                platform_order_type,
            </if>
            <if test="website != null">
                website,
            </if>
            <if test="createTime != null">
                create_time,
            </if>
            <if test="purchaseCreateTime != null">
                purchase_create_time,
            </if>
            <if test="hasPaytime != null">
                has_paytime,
            </if>
            <if test="paidTime != null">
                paid_time,
            </if>
            <if test="refundTime != null">
                refund_time,
            </if>
            <if test="sellerId != null">
                seller_id,
            </if>
            <if test="bailunAccountId != null">
                bailun_account_id,
            </if>
            <if test="hqAccount != null">
                hq_account,
            </if>
            <if test="sellerAccount != null">
                seller_account,
            </if>
            <if test="sellerOrderId != null">
                seller_order_id,
            </if>
            <if test="sellerEmail != null">
                seller_email,
            </if>
            <if test="orderUpdateTime != null">
                order_update_time,
            </if>
            <if test="sellerOrderExchangeRate != null">
                seller_order_exchange_rate,
            </if>
            <if test="sellerOtherExchangeRate != null">
                seller_other_exchange_rate,
            </if>
            <if test="financeOrderExchangeRate != null">
                finance_order_exchange_rate,
            </if>
            <if test="financeOtherExchangeRate != null">
                finance_other_exchange_rate,
            </if>
            <if test="cnyToUsdExchangeRate != null">
                cny_to_usd_exchange_rate,
            </if>
            <if test="orderToUsdExchangeRate != null">
                order_to_usd_exchange_rate,
            </if>
            <if test="otherToUsdExchangeRate != null">
                other_to_usd_exchange_rate,
            </if>
            <if test="orderCurrency != null">
                order_currency,
            </if>
            <if test="otherCurrency != null">
                other_currency,
            </if>
            <if test="sellerName != null">
                seller_name,
            </if>
            <if test="bailunOrderId != null">
                bailun_order_id,
            </if>
            <if test="platformOrderStatus != null">
                platform_order_status,
            </if>
            <if test="bailunOrderStatus != null">
                bailun_order_status,
            </if>
            <if test="bailunPaymentStatus != null">
                bailun_payment_status,
            </if>
            <if test="bailunInterceptionStatus != null">
                bailun_interception_status,
            </if>
            <if test="shippingStatus != null">
                shipping_status,
            </if>
            <if test="bailunSku != null">
                bailun_sku,
            </if>
            <if test="bailunSkuTitleEn != null">
                bailun_sku_title_en,
            </if>
            <if test="bailunSkuTitleCn != null">
                bailun_sku_title_cn,
            </if>
            <if test="bailunSkuQuantityOrdered != null">
                bailun_sku_quantity_ordered,
            </if>
            <if test="bailunSkuQuantityShipped != null">
                bailun_sku_quantity_shipped,
            </if>
            <if test="bailunSkuQuantityRefund != null">
                bailun_sku_quantity_refund,
            </if>
            <if test="bailunSkuQuantityPicked != null">
                bailun_sku_quantity_picked,
            </if>
            <if test="warehouseName != null">
                warehouse_name,
            </if>
            <if test="warehouseCodeFba != null">
                warehouse_code_fba,
            </if>
            <if test="warehouseCode != null">
                warehouse_code,
            </if>
            <if test="bailunSkuUnitPrice != null">
                bailun_sku_unit_price,
            </if>
            <if test="bailunSkuWeight != null">
                bailun_sku_weight,
            </if>
            <if test="bailunSkuSize != null">
                bailun_sku_size,
            </if>
            <if test="amountSales != null">
                amount_sales,
            </if>
            <if test="amountTotal != null">
                amount_total,
            </if>
            <if test="amountShipping != null">
                amount_shipping,
            </if>
            <if test="amountProduct != null">
                amount_product,
            </if>
            <if test="amountTax != null">
                amount_tax,
            </if>
            <if test="amountAdjustment != null">
                amount_adjustment,
            </if>
            <if test="amountGiftWrap != null">
                amount_gift_wrap,
            </if>
            <if test="amountRefund != null">
                amount_refund,
            </if>
            <if test="amountPrepaid != null">
                amount_prepaid,
            </if>
            <if test="costTotal != null">
                cost_total,
            </if>
            <if test="costPromotion != null">
                cost_promotion,
            </if>
            <if test="costPlatformFee != null">
                cost_platform_fee,
            </if>
            <if test="costProduct != null">
                cost_product,
            </if>
            <if test="costShipping != null">
                cost_shipping,
            </if>
            <if test="costPackage != null">
                cost_package,
            </if>
            <if test="costFbaFee != null">
                cost_fba_fee,
            </if>
            <if test="costPaypalFee != null">
                cost_paypal_fee,
            </if>
            <if test="costRefundCommisson != null">
                cost_refund_commisson,
            </if>
            <if test="costHandleBailun != null">
                cost_handle_bailun,
            </if>
            <if test="costHandlePlatform != null">
                cost_handle_platform,
            </if>
            <if test="costTail != null">
                cost_tail,
            </if>
            <if test="costFirst != null">
                cost_first,
            </if>
            <if test="costLogistics != null">
                cost_logistics,
            </if>
            <if test="profitTotal != null">
                profit_total,
            </if>
            <if test="profitRate != null">
                profit_rate,
            </if>
            <if test="receiptCountry != null">
                receipt_country,
            </if>
            <if test="receiptCity != null">
                receipt_city,
            </if>
            <if test="receiptArea != null">
                receipt_area,
            </if>
            <if test="receiptAddress != null">
                receipt_address,
            </if>
            <if test="receiptAddress2 != null">
                receipt_address_2,
            </if>
            <if test="receiptPostalCode != null">
                receipt_postal_code,
            </if>
            <if test="receiver != null">
                receiver,
            </if>
            <if test="receiverPhone != null">
                receiver_phone,
            </if>
            <if test="buyerId != null">
                buyer_id,
            </if>
            <if test="buyerName != null">
                buyer_name,
            </if>
            <if test="buyerEmail != null">
                buyer_email,
            </if>
            <if test="hasFbaException != null">
                has_fba_exception,
            </if>
            <if test="hasPlatformException != null">
                has_platform_exception,
            </if>
            <if test="hasCancle != null">
                has_cancle,
            </if>
            <if test="areaId != null">
                area_id,
            </if>
            <if test="bailunCategoryId != null">
                bailun_category_id,
            </if>
            <if test="bailunCategoryName != null">
                bailun_category_name,
            </if>
            <if test="gmtCreate != null">
                gmt_create,
            </if>
            <if test="gmtModified != null">
                gmt_modified,
            </if>
            <if test="ratioWeight != null">
                ratio_weight,
            </if>
            <if test="ratioPrice != null">
                ratio_price,
            </if>
            <if test="bailunPickingStatus != null">
                bailun_picking_status,
            </if>
            <if test="bailunRequireLogistics != null">
                bailun_require_logistics,
            </if>
            <if test="hasDelete != null">
                has_delete,
            </if>
            <if test="hasScalp != null">
                has_scalp,
            </if>
            <if test="hasBuyerRemark != null">
                has_buyer_remark,
            </if>
            <if test="hasPlatskuRemark != null">
                has_platsku_remark,
            </if>
            <if test="logisticsMethodCode != null">
                logistics_method_code,
            </if>
            <if test="logisticsMethodName != null">
                logistics_method_name,
            </if>
            <if test="hasInnersale != null">
                has_innersale,
            </if>
            <if test="companyId != null">
                company_id,
            </if>
            <if test="bailunRefundStatus != null">
                bailun_refund_status,
            </if>
            <if test="refundObj != null">
                refund_obj,
            </if>
            <if test="refundType != null">
                refund_type,
            </if>
            <if test="refundReferenceId != null">
                refund_reference_id,
            </if>
            <if test="hasFbaS != null">
                has_fba_s,
            </if>
            <if test="bailunSkuQuantityPushed != null">
                bailun_sku_quantity_pushed,
            </if>
            <if test="amountGeneralCargo != null">
                amount_general_cargo,
            </if>
            <if test="hasTransferOrder != null">
                has_transfer_order,
            </if>
            <if test="warningType != null">
                warning_type,
            </if>
            <if test="warningTypeName != null">
                warning_type_name,
            </if>
            <if test="totalFee != null">
                total_fee,
            </if>
            <if test="shipping != null">
                shipping,
            </if>
            <if test="opf != null">
                opf,
            </if>
            <if test="fsc != null">
                fsc,
            </if>
            <if test="dt != null">
                dt,
            </if>
            <if test="rsf != null">
                rsf,
            </if>
            <if test="otf != null">
                otf,
            </if>
            <if test="whf != null">
                whf,
            </if>
            <if test="currencyCode != null">
                currency_code,
            </if>
            <if test="wmsToCnyExchangeRate != null">
                wms_to_cny_exchange_rate,
            </if>
            <if test="wmsToUsdExchangeRate != null">
                wms_to_usd_exchange_rate,
            </if>
            <if test="shippingDeadlineReal != null">
                shipping_deadline_real,
            </if>
        </trim>
        values
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                #{id,jdbcType=INTEGER},
            </if>
            <if test="originOrderId != null">
                #{originOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformType != null">
                #{platformType,jdbcType=VARCHAR},
            </if>
            <if test="transactionId != null">
                #{transactionId,jdbcType=VARCHAR},
            </if>
            <if test="payTime != null">
                #{payTime,jdbcType=TIMESTAMP},
            </if>
            <if test="payMethod != null">
                #{payMethod,jdbcType=VARCHAR},
            </if>
            <if test="payAccount != null">
                #{payAccount,jdbcType=VARCHAR},
            </if>
            <if test="payStatus != null">
                #{payStatus,jdbcType=VARCHAR},
            </if>
            <if test="collectionAccount != null">
                #{collectionAccount,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderType != null">
                #{platformOrderType,jdbcType=VARCHAR},
            </if>
            <if test="website != null">
                #{website,jdbcType=VARCHAR},
            </if>
            <if test="createTime != null">
                #{createTime,jdbcType=TIMESTAMP},
            </if>
            <if test="purchaseCreateTime != null">
                #{purchaseCreateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="hasPaytime != null">
                #{hasPaytime,jdbcType=BIT},
            </if>
            <if test="paidTime != null">
                #{paidTime,jdbcType=TIMESTAMP},
            </if>
            <if test="refundTime != null">
                #{refundTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerId != null">
                #{sellerId,jdbcType=VARCHAR},
            </if>
            <if test="bailunAccountId != null">
                #{bailunAccountId,jdbcType=INTEGER},
            </if>
            <if test="hqAccount != null">
                #{hqAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerAccount != null">
                #{sellerAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerOrderId != null">
                #{sellerOrderId,jdbcType=VARCHAR},
            </if>
            <if test="sellerEmail != null">
                #{sellerEmail,jdbcType=VARCHAR},
            </if>
            <if test="orderUpdateTime != null">
                #{orderUpdateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerOrderExchangeRate != null">
                #{sellerOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="sellerOtherExchangeRate != null">
                #{sellerOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOrderExchangeRate != null">
                #{financeOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOtherExchangeRate != null">
                #{financeOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="cnyToUsdExchangeRate != null">
                #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderToUsdExchangeRate != null">
                #{orderToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="otherToUsdExchangeRate != null">
                #{otherToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderCurrency != null">
                #{orderCurrency,jdbcType=VARCHAR},
            </if>
            <if test="otherCurrency != null">
                #{otherCurrency,jdbcType=VARCHAR},
            </if>
            <if test="sellerName != null">
                #{sellerName,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderId != null">
                #{bailunOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderStatus != null">
                #{platformOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderStatus != null">
                #{bailunOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunPaymentStatus != null">
                #{bailunPaymentStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunInterceptionStatus != null">
                #{bailunInterceptionStatus,jdbcType=VARCHAR},
            </if>
            <if test="shippingStatus != null">
                #{shippingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunSku != null">
                #{bailunSku,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleEn != null">
                #{bailunSkuTitleEn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleCn != null">
                #{bailunSkuTitleCn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuQuantityOrdered != null">
                #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityShipped != null">
                #{bailunSkuQuantityShipped,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityRefund != null">
                #{bailunSkuQuantityRefund,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityPicked != null">
                #{bailunSkuQuantityPicked,jdbcType=INTEGER},
            </if>
            <if test="warehouseName != null">
                #{warehouseName,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCodeFba != null">
                #{warehouseCodeFba,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCode != null">
                #{warehouseCode,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuUnitPrice != null">
                #{bailunSkuUnitPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuWeight != null">
                #{bailunSkuWeight,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuSize != null">
                #{bailunSkuSize,jdbcType=VARCHAR},
            </if>
            <if test="amountSales != null">
                #{amountSales,jdbcType=DECIMAL},
            </if>
            <if test="amountTotal != null">
                #{amountTotal,jdbcType=DECIMAL},
            </if>
            <if test="amountShipping != null">
                #{amountShipping,jdbcType=DECIMAL},
            </if>
            <if test="amountProduct != null">
                #{amountProduct,jdbcType=DECIMAL},
            </if>
            <if test="amountTax != null">
                #{amountTax,jdbcType=DECIMAL},
            </if>
            <if test="amountAdjustment != null">
                #{amountAdjustment,jdbcType=DECIMAL},
            </if>
            <if test="amountGiftWrap != null">
                #{amountGiftWrap,jdbcType=DECIMAL},
            </if>
            <if test="amountRefund != null">
                #{amountRefund,jdbcType=DECIMAL},
            </if>
            <if test="amountPrepaid != null">
                #{amountPrepaid,jdbcType=DECIMAL},
            </if>
            <if test="costTotal != null">
                #{costTotal,jdbcType=DECIMAL},
            </if>
            <if test="costPromotion != null">
                #{costPromotion,jdbcType=DECIMAL},
            </if>
            <if test="costPlatformFee != null">
                #{costPlatformFee,jdbcType=DECIMAL},
            </if>
            <if test="costProduct != null">
                #{costProduct,jdbcType=DECIMAL},
            </if>
            <if test="costShipping != null">
                #{costShipping,jdbcType=DECIMAL},
            </if>
            <if test="costPackage != null">
                #{costPackage,jdbcType=DECIMAL},
            </if>
            <if test="costFbaFee != null">
                #{costFbaFee,jdbcType=DECIMAL},
            </if>
            <if test="costPaypalFee != null">
                #{costPaypalFee,jdbcType=DECIMAL},
            </if>
            <if test="costRefundCommisson != null">
                #{costRefundCommisson,jdbcType=DECIMAL},
            </if>
            <if test="costHandleBailun != null">
                #{costHandleBailun,jdbcType=DECIMAL},
            </if>
            <if test="costHandlePlatform != null">
                #{costHandlePlatform,jdbcType=DECIMAL},
            </if>
            <if test="costTail != null">
                #{costTail,jdbcType=DECIMAL},
            </if>
            <if test="costFirst != null">
                #{costFirst,jdbcType=DECIMAL},
            </if>
            <if test="costLogistics != null">
                #{costLogistics,jdbcType=DECIMAL},
            </if>
            <if test="profitTotal != null">
                #{profitTotal,jdbcType=DECIMAL},
            </if>
            <if test="profitRate != null">
                #{profitRate,jdbcType=DECIMAL},
            </if>
            <if test="receiptCountry != null">
                #{receiptCountry,jdbcType=VARCHAR},
            </if>
            <if test="receiptCity != null">
                #{receiptCity,jdbcType=VARCHAR},
            </if>
            <if test="receiptArea != null">
                #{receiptArea,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress != null">
                #{receiptAddress,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress2 != null">
                #{receiptAddress2,jdbcType=VARCHAR},
            </if>
            <if test="receiptPostalCode != null">
                #{receiptPostalCode,jdbcType=VARCHAR},
            </if>
            <if test="receiver != null">
                #{receiver,jdbcType=VARCHAR},
            </if>
            <if test="receiverPhone != null">
                #{receiverPhone,jdbcType=VARCHAR},
            </if>
            <if test="buyerId != null">
                #{buyerId,jdbcType=VARCHAR},
            </if>
            <if test="buyerName != null">
                #{buyerName,jdbcType=VARCHAR},
            </if>
            <if test="buyerEmail != null">
                #{buyerEmail,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaException != null">
                #{hasFbaException,jdbcType=BIT},
            </if>
            <if test="hasPlatformException != null">
                #{hasPlatformException,jdbcType=BIT},
            </if>
            <if test="hasCancle != null">
                #{hasCancle,jdbcType=BIT},
            </if>
            <if test="areaId != null">
                #{areaId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryId != null">
                #{bailunCategoryId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryName != null">
                #{bailunCategoryName,jdbcType=VARCHAR},
            </if>
            <if test="gmtCreate != null">
                #{gmtCreate,jdbcType=TIMESTAMP},
            </if>
            <if test="gmtModified != null">
                #{gmtModified,jdbcType=TIMESTAMP},
            </if>
            <if test="ratioWeight != null">
                #{ratioWeight,jdbcType=DECIMAL},
            </if>
            <if test="ratioPrice != null">
                #{ratioPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunPickingStatus != null">
                #{bailunPickingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunRequireLogistics != null">
                #{bailunRequireLogistics,jdbcType=VARCHAR},
            </if>
            <if test="hasDelete != null">
                #{hasDelete,jdbcType=BIT},
            </if>
            <if test="hasScalp != null">
                #{hasScalp,jdbcType=BIT},
            </if>
            <if test="hasBuyerRemark != null">
                #{hasBuyerRemark,jdbcType=BIT},
            </if>
            <if test="hasPlatskuRemark != null">
                #{hasPlatskuRemark,jdbcType=BIT},
            </if>
            <if test="logisticsMethodCode != null">
                #{logisticsMethodCode,jdbcType=VARCHAR},
            </if>
            <if test="logisticsMethodName != null">
                #{logisticsMethodName,jdbcType=VARCHAR},
            </if>
            <if test="hasInnersale != null">
                #{hasInnersale,jdbcType=BIT},
            </if>
            <if test="companyId != null">
                #{companyId,jdbcType=INTEGER},
            </if>
            <if test="bailunRefundStatus != null">
                #{bailunRefundStatus,jdbcType=VARCHAR},
            </if>
            <if test="refundObj != null">
                #{refundObj,jdbcType=VARCHAR},
            </if>
            <if test="refundType != null">
                #{refundType,jdbcType=VARCHAR},
            </if>
            <if test="refundReferenceId != null">
                #{refundReferenceId,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaS != null">
                #{hasFbaS,jdbcType=BIT},
            </if>
            <if test="bailunSkuQuantityPushed != null">
                #{bailunSkuQuantityPushed,jdbcType=INTEGER},
            </if>
            <if test="amountGeneralCargo != null">
                #{amountGeneralCargo,jdbcType=DECIMAL},
            </if>
            <if test="hasTransferOrder != null">
                #{hasTransferOrder,jdbcType=BIT},
            </if>
            <if test="warningType != null">
                #{warningType,jdbcType=VARCHAR},
            </if>
            <if test="warningTypeName != null">
                #{warningTypeName,jdbcType=VARCHAR},
            </if>
            <if test="totalFee != null">
                #{totalFee,jdbcType=DECIMAL},
            </if>
            <if test="shipping != null">
                #{shipping,jdbcType=DECIMAL},
            </if>
            <if test="opf != null">
                #{opf,jdbcType=DECIMAL},
            </if>
            <if test="fsc != null">
                #{fsc,jdbcType=DECIMAL},
            </if>
            <if test="dt != null">
                #{dt,jdbcType=DECIMAL},
            </if>
            <if test="rsf != null">
                #{rsf,jdbcType=DECIMAL},
            </if>
            <if test="otf != null">
                #{otf,jdbcType=DECIMAL},
            </if>
            <if test="whf != null">
                #{whf,jdbcType=DECIMAL},
            </if>
            <if test="currencyCode != null">
                #{currencyCode,jdbcType=VARCHAR},
            </if>
            <if test="wmsToCnyExchangeRate != null">
                #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="wmsToUsdExchangeRate != null">
                #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="shippingDeadlineReal != null">
                #{shippingDeadlineReal,jdbcType=TIMESTAMP},
            </if>
        </trim>
        on duplicate key update
        <trim suffixOverrides=",">
            <if test="id != null">
                id = #{id,jdbcType=INTEGER},
            </if>
            <if test="originOrderId != null">
                origin_order_id = #{originOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformType != null">
                platform_type = #{platformType,jdbcType=VARCHAR},
            </if>
            <if test="transactionId != null">
                transaction_id = #{transactionId,jdbcType=VARCHAR},
            </if>
            <if test="payTime != null">
                pay_time = #{payTime,jdbcType=TIMESTAMP},
            </if>
            <if test="payMethod != null">
                pay_method = #{payMethod,jdbcType=VARCHAR},
            </if>
            <if test="payAccount != null">
                pay_account = #{payAccount,jdbcType=VARCHAR},
            </if>
            <if test="payStatus != null">
                pay_status = #{payStatus,jdbcType=VARCHAR},
            </if>
            <if test="collectionAccount != null">
                collection_account = #{collectionAccount,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderType != null">
                platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
            </if>
            <if test="website != null">
                website = #{website,jdbcType=VARCHAR},
            </if>
            <if test="createTime != null">
                create_time = #{createTime,jdbcType=TIMESTAMP},
            </if>
            <if test="purchaseCreateTime != null">
                purchase_create_time = #{purchaseCreateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="hasPaytime != null">
                has_paytime = #{hasPaytime,jdbcType=BIT},
            </if>
            <if test="paidTime != null">
                paid_time = #{paidTime,jdbcType=TIMESTAMP},
            </if>
            <if test="refundTime != null">
                refund_time = #{refundTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerId != null">
                seller_id = #{sellerId,jdbcType=VARCHAR},
            </if>
            <if test="bailunAccountId != null">
                bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
            </if>
            <if test="hqAccount != null">
                hq_account = #{hqAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerAccount != null">
                seller_account = #{sellerAccount,jdbcType=VARCHAR},
            </if>
            <if test="sellerOrderId != null">
                seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
            </if>
            <if test="sellerEmail != null">
                seller_email = #{sellerEmail,jdbcType=VARCHAR},
            </if>
            <if test="orderUpdateTime != null">
                order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
            </if>
            <if test="sellerOrderExchangeRate != null">
                seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="sellerOtherExchangeRate != null">
                seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOrderExchangeRate != null">
                finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="financeOtherExchangeRate != null">
                finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="cnyToUsdExchangeRate != null">
                cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderToUsdExchangeRate != null">
                order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="otherToUsdExchangeRate != null">
                other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="orderCurrency != null">
                order_currency = #{orderCurrency,jdbcType=VARCHAR},
            </if>
            <if test="otherCurrency != null">
                other_currency = #{otherCurrency,jdbcType=VARCHAR},
            </if>
            <if test="sellerName != null">
                seller_name = #{sellerName,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderId != null">
                bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
            </if>
            <if test="platformOrderStatus != null">
                platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunOrderStatus != null">
                bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunPaymentStatus != null">
                bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunInterceptionStatus != null">
                bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
            </if>
            <if test="shippingStatus != null">
                shipping_status = #{shippingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunSku != null">
                bailun_sku = #{bailunSku,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleEn != null">
                bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuTitleCn != null">
                bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuQuantityOrdered != null">
                bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityShipped != null">
                bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityRefund != null">
                bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
            </if>
            <if test="bailunSkuQuantityPicked != null">
                bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
            </if>
            <if test="warehouseName != null">
                warehouse_name = #{warehouseName,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCodeFba != null">
                warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
            </if>
            <if test="warehouseCode != null">
                warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
            </if>
            <if test="bailunSkuUnitPrice != null">
                bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuWeight != null">
                bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
            </if>
            <if test="bailunSkuSize != null">
                bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
            </if>
            <if test="amountSales != null">
                amount_sales = #{amountSales,jdbcType=DECIMAL},
            </if>
            <if test="amountTotal != null">
                amount_total = #{amountTotal,jdbcType=DECIMAL},
            </if>
            <if test="amountShipping != null">
                amount_shipping = #{amountShipping,jdbcType=DECIMAL},
            </if>
            <if test="amountProduct != null">
                amount_product = #{amountProduct,jdbcType=DECIMAL},
            </if>
            <if test="amountTax != null">
                amount_tax = #{amountTax,jdbcType=DECIMAL},
            </if>
            <if test="amountAdjustment != null">
                amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
            </if>
            <if test="amountGiftWrap != null">
                amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
            </if>
            <if test="amountRefund != null">
                amount_refund = #{amountRefund,jdbcType=DECIMAL},
            </if>
            <if test="amountPrepaid != null">
                amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
            </if>
            <if test="costTotal != null">
                cost_total = #{costTotal,jdbcType=DECIMAL},
            </if>
            <if test="costPromotion != null">
                cost_promotion = #{costPromotion,jdbcType=DECIMAL},
            </if>
            <if test="costPlatformFee != null">
                cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
            </if>
            <if test="costProduct != null">
                cost_product = #{costProduct,jdbcType=DECIMAL},
            </if>
            <if test="costShipping != null">
                cost_shipping = #{costShipping,jdbcType=DECIMAL},
            </if>
            <if test="costPackage != null">
                cost_package = #{costPackage,jdbcType=DECIMAL},
            </if>
            <if test="costFbaFee != null">
                cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
            </if>
            <if test="costPaypalFee != null">
                cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
            </if>
            <if test="costRefundCommisson != null">
                cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
            </if>
            <if test="costHandleBailun != null">
                cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
            </if>
            <if test="costHandlePlatform != null">
                cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
            </if>
            <if test="costTail != null">
                cost_tail = #{costTail,jdbcType=DECIMAL},
            </if>
            <if test="costFirst != null">
                cost_first = #{costFirst,jdbcType=DECIMAL},
            </if>
            <if test="costLogistics != null">
                cost_logistics = #{costLogistics,jdbcType=DECIMAL},
            </if>
            <if test="profitTotal != null">
                profit_total = #{profitTotal,jdbcType=DECIMAL},
            </if>
            <if test="profitRate != null">
                profit_rate = #{profitRate,jdbcType=DECIMAL},
            </if>
            <if test="receiptCountry != null">
                receipt_country = #{receiptCountry,jdbcType=VARCHAR},
            </if>
            <if test="receiptCity != null">
                receipt_city = #{receiptCity,jdbcType=VARCHAR},
            </if>
            <if test="receiptArea != null">
                receipt_area = #{receiptArea,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress != null">
                receipt_address = #{receiptAddress,jdbcType=VARCHAR},
            </if>
            <if test="receiptAddress2 != null">
                receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
            </if>
            <if test="receiptPostalCode != null">
                receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
            </if>
            <if test="receiver != null">
                receiver = #{receiver,jdbcType=VARCHAR},
            </if>
            <if test="receiverPhone != null">
                receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
            </if>
            <if test="buyerId != null">
                buyer_id = #{buyerId,jdbcType=VARCHAR},
            </if>
            <if test="buyerName != null">
                buyer_name = #{buyerName,jdbcType=VARCHAR},
            </if>
            <if test="buyerEmail != null">
                buyer_email = #{buyerEmail,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaException != null">
                has_fba_exception = #{hasFbaException,jdbcType=BIT},
            </if>
            <if test="hasPlatformException != null">
                has_platform_exception = #{hasPlatformException,jdbcType=BIT},
            </if>
            <if test="hasCancle != null">
                has_cancle = #{hasCancle,jdbcType=BIT},
            </if>
            <if test="areaId != null">
                area_id = #{areaId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryId != null">
                bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
            </if>
            <if test="bailunCategoryName != null">
                bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
            </if>
            <if test="gmtCreate != null">
                gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
            </if>
            <if test="gmtModified != null">
                gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
            </if>
            <if test="ratioWeight != null">
                ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
            </if>
            <if test="ratioPrice != null">
                ratio_price = #{ratioPrice,jdbcType=DECIMAL},
            </if>
            <if test="bailunPickingStatus != null">
                bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
            </if>
            <if test="bailunRequireLogistics != null">
                bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
            </if>
            <if test="hasDelete != null">
                has_delete = #{hasDelete,jdbcType=BIT},
            </if>
            <if test="hasScalp != null">
                has_scalp = #{hasScalp,jdbcType=BIT},
            </if>
            <if test="hasBuyerRemark != null">
                has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
            </if>
            <if test="hasPlatskuRemark != null">
                has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
            </if>
            <if test="logisticsMethodCode != null">
                logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
            </if>
            <if test="logisticsMethodName != null">
                logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
            </if>
            <if test="hasInnersale != null">
                has_innersale = #{hasInnersale,jdbcType=BIT},
            </if>
            <if test="companyId != null">
                company_id = #{companyId,jdbcType=INTEGER},
            </if>
            <if test="bailunRefundStatus != null">
                bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
            </if>
            <if test="refundObj != null">
                refund_obj = #{refundObj,jdbcType=VARCHAR},
            </if>
            <if test="refundType != null">
                refund_type = #{refundType,jdbcType=VARCHAR},
            </if>
            <if test="refundReferenceId != null">
                refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
            </if>
            <if test="hasFbaS != null">
                has_fba_s = #{hasFbaS,jdbcType=BIT},
            </if>
            <if test="bailunSkuQuantityPushed != null">
                bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
            </if>
            <if test="amountGeneralCargo != null">
                amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
            </if>
            <if test="hasTransferOrder != null">
                has_transfer_order = #{hasTransferOrder,jdbcType=BIT},
            </if>
            <if test="warningType != null">
                warning_type = #{warningType,jdbcType=VARCHAR},
            </if>
            <if test="warningTypeName != null">
                warning_type_name = #{warningTypeName,jdbcType=VARCHAR},
            </if>
            <if test="totalFee != null">
                total_fee = #{totalFee,jdbcType=DECIMAL},
            </if>
            <if test="shipping != null">
                shipping = #{shipping,jdbcType=DECIMAL},
            </if>
            <if test="opf != null">
                opf = #{opf,jdbcType=DECIMAL},
            </if>
            <if test="fsc != null">
                fsc = #{fsc,jdbcType=DECIMAL},
            </if>
            <if test="dt != null">
                dt = #{dt,jdbcType=DECIMAL},
            </if>
            <if test="rsf != null">
                rsf = #{rsf,jdbcType=DECIMAL},
            </if>
            <if test="otf != null">
                otf = #{otf,jdbcType=DECIMAL},
            </if>
            <if test="whf != null">
                whf = #{whf,jdbcType=DECIMAL},
            </if>
            <if test="currencyCode != null">
                currency_code = #{currencyCode,jdbcType=VARCHAR},
            </if>
            <if test="wmsToCnyExchangeRate != null">
                wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="wmsToUsdExchangeRate != null">
                wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
            </if>
            <if test="shippingDeadlineReal != null">
                shipping_deadline_real = #{shippingDeadlineReal,jdbcType=TIMESTAMP},
            </if>
        </trim>
    </insert>
    <insert id="upsert" parameterType="com.bailuntec.domain.entity.DcBaseOmsSku">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
        insert into dc_base_oms_sku
        (id, origin_order_id, platform_type, transaction_id, pay_time, pay_method, pay_account,
        pay_status, collection_account, platform_order_type, website, create_time, purchase_create_time,
        has_paytime, paid_time, refund_time, seller_id, bailun_account_id, hq_account,
        seller_account, seller_order_id, seller_email, order_update_time, seller_order_exchange_rate,
        seller_other_exchange_rate, finance_order_exchange_rate, finance_other_exchange_rate,
        cny_to_usd_exchange_rate, order_to_usd_exchange_rate, other_to_usd_exchange_rate,
        order_currency, other_currency, seller_name, bailun_order_id, platform_order_status,
        bailun_order_status, bailun_payment_status, bailun_interception_status, shipping_status,
        bailun_sku, bailun_sku_title_en, bailun_sku_title_cn, bailun_sku_quantity_ordered,
        bailun_sku_quantity_shipped, bailun_sku_quantity_refund, bailun_sku_quantity_picked,
        warehouse_name, warehouse_code_fba, warehouse_code, bailun_sku_unit_price, bailun_sku_weight,
        bailun_sku_size, amount_sales, amount_total, amount_shipping, amount_product, amount_tax,
        amount_adjustment, amount_gift_wrap, amount_refund, amount_prepaid, cost_total,
        cost_promotion, cost_platform_fee, cost_product, cost_shipping, cost_package, cost_fba_fee,
        cost_paypal_fee, cost_refund_commisson, cost_handle_bailun, cost_handle_platform,
        cost_tail, cost_first, cost_logistics, profit_total, profit_rate, receipt_country,
        receipt_city, receipt_area, receipt_address, receipt_address_2, receipt_postal_code,
        receiver, receiver_phone, buyer_id, buyer_name, buyer_email, has_fba_exception,
        has_platform_exception, has_cancle, area_id, bailun_category_id, bailun_category_name,
        gmt_create, gmt_modified, ratio_weight, ratio_price, bailun_picking_status, bailun_require_logistics,
        has_delete, has_scalp, has_buyer_remark, has_platsku_remark, logistics_method_code,
        logistics_method_name, has_innersale, company_id, bailun_refund_status, refund_obj,
        refund_type, refund_reference_id, has_fba_s, bailun_sku_quantity_pushed, amount_general_cargo,
        has_transfer_order, warning_type, warning_type_name, total_fee, shipping, opf,
        fsc, dt, rsf, otf, whf, currency_code, wms_to_cny_exchange_rate, wms_to_usd_exchange_rate,
        shipping_deadline_real)
        values
        (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{platformType,jdbcType=VARCHAR},
        #{transactionId,jdbcType=VARCHAR}, #{payTime,jdbcType=TIMESTAMP}, #{payMethod,jdbcType=VARCHAR},
        #{payAccount,jdbcType=VARCHAR}, #{payStatus,jdbcType=VARCHAR}, #{collectionAccount,jdbcType=VARCHAR},
        #{platformOrderType,jdbcType=VARCHAR}, #{website,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},
        #{purchaseCreateTime,jdbcType=TIMESTAMP}, #{hasPaytime,jdbcType=BIT}, #{paidTime,jdbcType=TIMESTAMP},
        #{refundTime,jdbcType=TIMESTAMP}, #{sellerId,jdbcType=VARCHAR}, #{bailunAccountId,jdbcType=INTEGER},
        #{hqAccount,jdbcType=VARCHAR}, #{sellerAccount,jdbcType=VARCHAR}, #{sellerOrderId,jdbcType=VARCHAR},
        #{sellerEmail,jdbcType=VARCHAR}, #{orderUpdateTime,jdbcType=TIMESTAMP},
        #{sellerOrderExchangeRate,jdbcType=DECIMAL},
        #{sellerOtherExchangeRate,jdbcType=DECIMAL}, #{financeOrderExchangeRate,jdbcType=DECIMAL},
        #{financeOtherExchangeRate,jdbcType=DECIMAL}, #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
        #{orderToUsdExchangeRate,jdbcType=DECIMAL}, #{otherToUsdExchangeRate,jdbcType=DECIMAL},
        #{orderCurrency,jdbcType=VARCHAR}, #{otherCurrency,jdbcType=VARCHAR}, #{sellerName,jdbcType=VARCHAR},
        #{bailunOrderId,jdbcType=VARCHAR}, #{platformOrderStatus,jdbcType=VARCHAR},
        #{bailunOrderStatus,jdbcType=VARCHAR},
        #{bailunPaymentStatus,jdbcType=VARCHAR}, #{bailunInterceptionStatus,jdbcType=VARCHAR},
        #{shippingStatus,jdbcType=VARCHAR}, #{bailunSku,jdbcType=VARCHAR}, #{bailunSkuTitleEn,jdbcType=VARCHAR},
        #{bailunSkuTitleCn,jdbcType=VARCHAR}, #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
        #{bailunSkuQuantityShipped,jdbcType=INTEGER}, #{bailunSkuQuantityRefund,jdbcType=INTEGER},
        #{bailunSkuQuantityPicked,jdbcType=INTEGER}, #{warehouseName,jdbcType=VARCHAR},
        #{warehouseCodeFba,jdbcType=VARCHAR}, #{warehouseCode,jdbcType=VARCHAR}, #{bailunSkuUnitPrice,jdbcType=DECIMAL},
        #{bailunSkuWeight,jdbcType=DECIMAL}, #{bailunSkuSize,jdbcType=VARCHAR}, #{amountSales,jdbcType=DECIMAL},
        #{amountTotal,jdbcType=DECIMAL}, #{amountShipping,jdbcType=DECIMAL}, #{amountProduct,jdbcType=DECIMAL},
        #{amountTax,jdbcType=DECIMAL}, #{amountAdjustment,jdbcType=DECIMAL}, #{amountGiftWrap,jdbcType=DECIMAL},
        #{amountRefund,jdbcType=DECIMAL}, #{amountPrepaid,jdbcType=DECIMAL}, #{costTotal,jdbcType=DECIMAL},
        #{costPromotion,jdbcType=DECIMAL}, #{costPlatformFee,jdbcType=DECIMAL}, #{costProduct,jdbcType=DECIMAL},
        #{costShipping,jdbcType=DECIMAL}, #{costPackage,jdbcType=DECIMAL}, #{costFbaFee,jdbcType=DECIMAL},
        #{costPaypalFee,jdbcType=DECIMAL}, #{costRefundCommisson,jdbcType=DECIMAL},
        #{costHandleBailun,jdbcType=DECIMAL},
        #{costHandlePlatform,jdbcType=DECIMAL}, #{costTail,jdbcType=DECIMAL}, #{costFirst,jdbcType=DECIMAL},
        #{costLogistics,jdbcType=DECIMAL}, #{profitTotal,jdbcType=DECIMAL}, #{profitRate,jdbcType=DECIMAL},
        #{receiptCountry,jdbcType=VARCHAR}, #{receiptCity,jdbcType=VARCHAR}, #{receiptArea,jdbcType=VARCHAR},
        #{receiptAddress,jdbcType=VARCHAR}, #{receiptAddress2,jdbcType=VARCHAR}, #{receiptPostalCode,jdbcType=VARCHAR},
        #{receiver,jdbcType=VARCHAR}, #{receiverPhone,jdbcType=VARCHAR}, #{buyerId,jdbcType=VARCHAR},
        #{buyerName,jdbcType=VARCHAR}, #{buyerEmail,jdbcType=VARCHAR}, #{hasFbaException,jdbcType=BIT},
        #{hasPlatformException,jdbcType=BIT}, #{hasCancle,jdbcType=BIT}, #{areaId,jdbcType=INTEGER},
        #{bailunCategoryId,jdbcType=INTEGER}, #{bailunCategoryName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP},
        #{gmtModified,jdbcType=TIMESTAMP}, #{ratioWeight,jdbcType=DECIMAL}, #{ratioPrice,jdbcType=DECIMAL},
        #{bailunPickingStatus,jdbcType=VARCHAR}, #{bailunRequireLogistics,jdbcType=VARCHAR},
        #{hasDelete,jdbcType=BIT}, #{hasScalp,jdbcType=BIT}, #{hasBuyerRemark,jdbcType=BIT},
        #{hasPlatskuRemark,jdbcType=BIT}, #{logisticsMethodCode,jdbcType=VARCHAR},
        #{logisticsMethodName,jdbcType=VARCHAR},
        #{hasInnersale,jdbcType=BIT}, #{companyId,jdbcType=INTEGER}, #{bailunRefundStatus,jdbcType=VARCHAR},
        #{refundObj,jdbcType=VARCHAR}, #{refundType,jdbcType=VARCHAR}, #{refundReferenceId,jdbcType=VARCHAR},
        #{hasFbaS,jdbcType=BIT}, #{bailunSkuQuantityPushed,jdbcType=INTEGER}, #{amountGeneralCargo,jdbcType=DECIMAL},
        #{hasTransferOrder,jdbcType=BIT}, #{warningType,jdbcType=VARCHAR}, #{warningTypeName,jdbcType=VARCHAR},
        #{totalFee,jdbcType=DECIMAL}, #{shipping,jdbcType=DECIMAL}, #{opf,jdbcType=DECIMAL},
        #{fsc,jdbcType=DECIMAL}, #{dt,jdbcType=DECIMAL}, #{rsf,jdbcType=DECIMAL}, #{otf,jdbcType=DECIMAL},
        #{whf,jdbcType=DECIMAL}, #{currencyCode,jdbcType=VARCHAR}, #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
        #{wmsToUsdExchangeRate,jdbcType=DECIMAL}, #{shippingDeadlineReal,jdbcType=TIMESTAMP}
        )
        on duplicate key update
        id = #{id,jdbcType=INTEGER},
        origin_order_id = #{originOrderId,jdbcType=VARCHAR},
        platform_type = #{platformType,jdbcType=VARCHAR},
        transaction_id = #{transactionId,jdbcType=VARCHAR},
        pay_time = #{payTime,jdbcType=TIMESTAMP},
        pay_method = #{payMethod,jdbcType=VARCHAR},
        pay_account = #{payAccount,jdbcType=VARCHAR},
        pay_status = #{payStatus,jdbcType=VARCHAR},
        collection_account = #{collectionAccount,jdbcType=VARCHAR},
        platform_order_type = #{platformOrderType,jdbcType=VARCHAR},
        website = #{website,jdbcType=VARCHAR},
        create_time = #{createTime,jdbcType=TIMESTAMP},
        purchase_create_time = #{purchaseCreateTime,jdbcType=TIMESTAMP},
        has_paytime = #{hasPaytime,jdbcType=BIT},
        paid_time = #{paidTime,jdbcType=TIMESTAMP},
        refund_time = #{refundTime,jdbcType=TIMESTAMP},
        seller_id = #{sellerId,jdbcType=VARCHAR},
        bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
        hq_account = #{hqAccount,jdbcType=VARCHAR},
        seller_account = #{sellerAccount,jdbcType=VARCHAR},
        seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
        seller_email = #{sellerEmail,jdbcType=VARCHAR},
        order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
        seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
        seller_other_exchange_rate = #{sellerOtherExchangeRate,jdbcType=DECIMAL},
        finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
        finance_other_exchange_rate = #{financeOtherExchangeRate,jdbcType=DECIMAL},
        cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
        order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
        other_to_usd_exchange_rate = #{otherToUsdExchangeRate,jdbcType=DECIMAL},
        order_currency = #{orderCurrency,jdbcType=VARCHAR},
        other_currency = #{otherCurrency,jdbcType=VARCHAR},
        seller_name = #{sellerName,jdbcType=VARCHAR},
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
        platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
        bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
        bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
        bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
        bailun_sku = #{bailunSku,jdbcType=VARCHAR},
        bailun_sku_title_en = #{bailunSkuTitleEn,jdbcType=VARCHAR},
        bailun_sku_title_cn = #{bailunSkuTitleCn,jdbcType=VARCHAR},
        bailun_sku_quantity_ordered = #{bailunSkuQuantityOrdered,jdbcType=INTEGER},
        bailun_sku_quantity_shipped = #{bailunSkuQuantityShipped,jdbcType=INTEGER},
        bailun_sku_quantity_refund = #{bailunSkuQuantityRefund,jdbcType=INTEGER},
        bailun_sku_quantity_picked = #{bailunSkuQuantityPicked,jdbcType=INTEGER},
        warehouse_name = #{warehouseName,jdbcType=VARCHAR},
        warehouse_code_fba = #{warehouseCodeFba,jdbcType=VARCHAR},
        warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
        bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
        bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
        bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
        amount_sales = #{amountSales,jdbcType=DECIMAL},
        amount_total = #{amountTotal,jdbcType=DECIMAL},
        amount_shipping = #{amountShipping,jdbcType=DECIMAL},
        amount_product = #{amountProduct,jdbcType=DECIMAL},
        amount_tax = #{amountTax,jdbcType=DECIMAL},
        amount_adjustment = #{amountAdjustment,jdbcType=DECIMAL},
        amount_gift_wrap = #{amountGiftWrap,jdbcType=DECIMAL},
        amount_refund = #{amountRefund,jdbcType=DECIMAL},
        amount_prepaid = #{amountPrepaid,jdbcType=DECIMAL},
        cost_total = #{costTotal,jdbcType=DECIMAL},
        cost_promotion = #{costPromotion,jdbcType=DECIMAL},
        cost_platform_fee = #{costPlatformFee,jdbcType=DECIMAL},
        cost_product = #{costProduct,jdbcType=DECIMAL},
        cost_shipping = #{costShipping,jdbcType=DECIMAL},
        cost_package = #{costPackage,jdbcType=DECIMAL},
        cost_fba_fee = #{costFbaFee,jdbcType=DECIMAL},
        cost_paypal_fee = #{costPaypalFee,jdbcType=DECIMAL},
        cost_refund_commisson = #{costRefundCommisson,jdbcType=DECIMAL},
        cost_handle_bailun = #{costHandleBailun,jdbcType=DECIMAL},
        cost_handle_platform = #{costHandlePlatform,jdbcType=DECIMAL},
        cost_tail = #{costTail,jdbcType=DECIMAL},
        cost_first = #{costFirst,jdbcType=DECIMAL},
        cost_logistics = #{costLogistics,jdbcType=DECIMAL},
        profit_total = #{profitTotal,jdbcType=DECIMAL},
        profit_rate = #{profitRate,jdbcType=DECIMAL},
        receipt_country = #{receiptCountry,jdbcType=VARCHAR},
        receipt_city = #{receiptCity,jdbcType=VARCHAR},
        receipt_area = #{receiptArea,jdbcType=VARCHAR},
        receipt_address = #{receiptAddress,jdbcType=VARCHAR},
        receipt_address_2 = #{receiptAddress2,jdbcType=VARCHAR},
        receipt_postal_code = #{receiptPostalCode,jdbcType=VARCHAR},
        receiver = #{receiver,jdbcType=VARCHAR},
        receiver_phone = #{receiverPhone,jdbcType=VARCHAR},
        buyer_id = #{buyerId,jdbcType=VARCHAR},
        buyer_name = #{buyerName,jdbcType=VARCHAR},
        buyer_email = #{buyerEmail,jdbcType=VARCHAR},
        has_fba_exception = #{hasFbaException,jdbcType=BIT},
        has_platform_exception = #{hasPlatformException,jdbcType=BIT},
        has_cancle = #{hasCancle,jdbcType=BIT},
        area_id = #{areaId,jdbcType=INTEGER},
        bailun_category_id = #{bailunCategoryId,jdbcType=INTEGER},
        bailun_category_name = #{bailunCategoryName,jdbcType=VARCHAR},
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
        ratio_weight = #{ratioWeight,jdbcType=DECIMAL},
        ratio_price = #{ratioPrice,jdbcType=DECIMAL},
        bailun_picking_status = #{bailunPickingStatus,jdbcType=VARCHAR},
        bailun_require_logistics = #{bailunRequireLogistics,jdbcType=VARCHAR},
        has_delete = #{hasDelete,jdbcType=BIT},
        has_scalp = #{hasScalp,jdbcType=BIT},
        has_buyer_remark = #{hasBuyerRemark,jdbcType=BIT},
        has_platsku_remark = #{hasPlatskuRemark,jdbcType=BIT},
        logistics_method_code = #{logisticsMethodCode,jdbcType=VARCHAR},
        logistics_method_name = #{logisticsMethodName,jdbcType=VARCHAR},
        has_innersale = #{hasInnersale,jdbcType=BIT},
        company_id = #{companyId,jdbcType=INTEGER},
        bailun_refund_status = #{bailunRefundStatus,jdbcType=VARCHAR},
        refund_obj = #{refundObj,jdbcType=VARCHAR},
        refund_type = #{refundType,jdbcType=VARCHAR},
        refund_reference_id = #{refundReferenceId,jdbcType=VARCHAR},
        has_fba_s = #{hasFbaS,jdbcType=BIT},
        bailun_sku_quantity_pushed = #{bailunSkuQuantityPushed,jdbcType=INTEGER},
        amount_general_cargo = #{amountGeneralCargo,jdbcType=DECIMAL},
        has_transfer_order = #{hasTransferOrder,jdbcType=BIT},
        warning_type = #{warningType,jdbcType=VARCHAR},
        warning_type_name = #{warningTypeName,jdbcType=VARCHAR},
        total_fee = #{totalFee,jdbcType=DECIMAL},
        shipping = #{shipping,jdbcType=DECIMAL},
        opf = #{opf,jdbcType=DECIMAL},
        fsc = #{fsc,jdbcType=DECIMAL},
        dt = #{dt,jdbcType=DECIMAL},
        rsf = #{rsf,jdbcType=DECIMAL},
        otf = #{otf,jdbcType=DECIMAL},
        whf = #{whf,jdbcType=DECIMAL},
        currency_code = #{currencyCode,jdbcType=VARCHAR},
        wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
        wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
        shipping_deadline_real = #{shippingDeadlineReal,jdbcType=TIMESTAMP}
    </insert>
    <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsSkuExample"
            resultMap="BaseResultMap">
        <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
        select
        <include refid="Base_Column_List"/>
        from dc_base_oms_sku
        <if test="_parameter != null">
            <include refid="Example_Where_Clause"/>
        </if>
        <if test="orderByClause != null">
            order by ${orderByClause}
        </if>
        limit 1
    </select>

    <select id="listFbaFee" resultType="double">
        SELECT cost_fba_fee
        FROM dc_base_oms_sku
        WHERE platform_type = 'FBA'
          and paid_time &gt;= DATE_SUB(CURDATE(), INTERVAL #{timeInterval} day)
          AND bailun_sku = #{bailunSku}
          and website = #{website}
    </select>
    <select id="listFbaSku" resultType="com.bailuntec.domain.pojo.FbaFeeSku">
        SELECT bailun_sku, website
        FROM dc_base_oms_sku
        WHERE platform_type = 'FBA'
          and paid_time &gt;= DATE_SUB(CURDATE(), INTERVAL #{timeInterval} day)
        GROUP BY bailun_sku, website
    </select>

    <select id="selectFBAFee" resultType="java.math.BigDecimal">
        SELECT cost_fba_fee
        FROM dc_base_oms_sku
        WHERE platform_type = 'FBA'
          AND bailun_sku = #{bailunSku}
          AND website = #{webSite}
          AND cost_fba_fee &gt; 0
        limit 1
    </select>

    <select id="selectCostPlatformFee" resultType="java.math.BigDecimal">
        SELECT cost_platform_fee
        FROM dc_base_oms_sku
        where platform_type = #{platformType}
          AND bailun_sku = #{bailunSku}
          AND website = #{webSite}
          AND cost_platform_fee &gt; 0
          and origin_order_id != #{originOrderId}
        order by order_update_time desc
        limit 1
    </select>

    <select id="selectOneByCreateTime" resultType="com.bailuntec.domain.entity.DcBaseOmsSku">
        SELECT bailun_sku, create_time
        FROM dc_base_oms_sku
        WHERE bailun_sku = #{bailunSku}
        order by create_time asc
        limit 1
    </select>

    <select id="omsSkuSellerCount" resultType="java.math.BigDecimal">
        SELECT (SELECT coalesce(sum(ifnull(tt2.sales, tt1.bailun_sku_quantity_ordered)), 0)
                from (
                      dc_aims_transfer_warehouse_sales tt2
                         LEFT JOIN (
                    select coalesce(sum(t1.bailun_sku_quantity_ordered), 0) as bailun_sku_quantity_ordered,
                           DATE_FORMAT(paid_time, '%Y-%m-%d')                 as paid_date
                    from dc_base_oms_sku t1
                    where t1.paid_time &gt;= #{lowerTime}
                      and t1.paid_time &lt;= #{upperTime}
                      and t1.bailun_sku = #{bailunSku}
                      and t1.warehouse_code = #{warehouseCode}
                      and t1.has_fba_s = 0
                      and t1.has_delete = 0
                      and t1.has_scalp = 0
                      and t1.has_buyer_remark = 0
                      and t1.has_platsku_remark = 0
                      and t1.has_innersale = 0
                      and t1.bailun_order_status != 'Canceled'
                      <if test="platform!=null and platform !=''">
                          and t1.platform_type = #{platform}
                      </if>
                      and t1.platform_order_type != '手工单'
                    GROUP BY DATE_FORMAT(paid_time, '%y%m%d')) tt1 on tt1.paid_date = tt2.date_str)
                where tt2.bailun_sku =#{bailunSku}
                  and tt2.warehouse_code = #{warehouseCode}
                  and tt2.date &gt;= #{lowerTime}
                  and tt2.date &lt;= #{upperTime})
                   / #{days}
                +
               (SELECT coalesce(sum(ifnull(tt2.sales, tt1.bailun_sku_quantity_ordered)), 0)
                from (
                      dc_aims_transfer_warehouse_sales tt2
                         right JOIN (
                    select coalesce(sum(t1.bailun_sku_quantity_ordered), 0) as bailun_sku_quantity_ordered,
                           DATE_FORMAT(paid_time, '%Y-%m-%d')                 as paid_date
                    from dc_base_oms_sku t1
                    where t1.paid_time &gt;= #{lowerTime}
                      and t1.paid_time &lt;= #{upperTime}
                      and t1.bailun_sku = #{bailunSku}
                      and t1.warehouse_code = #{warehouseCode}
                      and t1.has_fba_s = 0
                      and t1.has_delete = 0
                      and t1.has_scalp = 0
                      and t1.has_buyer_remark = 0
                      and t1.has_platsku_remark = 0
                      and t1.has_innersale = 0
                      and t1.bailun_order_status != 'Canceled'
                      and t1.platform_order_type != '手工单'
                        <if test="platform!=null and platform !=''">
                            and t1.platform_type = #{platform}
                        </if>
                    GROUP BY DATE_FORMAT(paid_time, '%y%m%d')) tt1 on tt1.paid_date = tt2.date_str))
                   / #{days}
                   -
            (SELECT coalesce(sum(ifnull(tt2.sales, tt1.bailun_sku_quantity_ordered)), 0)
                            from (
                                  dc_aims_transfer_warehouse_sales tt2
                                     inner JOIN (
                                select coalesce(sum(t1.bailun_sku_quantity_ordered), 0) as bailun_sku_quantity_ordered,
                                       DATE_FORMAT(paid_time, '%Y-%m-%d')                 as paid_date
                                from dc_base_oms_sku t1
                                where t1.paid_time &gt;= #{lowerTime}
                                  and t1.paid_time &lt;= #{upperTime}
                                  and t1.bailun_sku = #{bailunSku}
                                  and t1.warehouse_code = #{warehouseCode}
                                  and t1.has_fba_s = 0
                                  and t1.has_delete = 0
                                  and t1.has_scalp = 0
                                  and t1.has_buyer_remark = 0
                                  and t1.has_platsku_remark = 0
                                  and t1.has_innersale = 0
                                  and t1.bailun_order_status != 'Canceled'
                                  and t1.platform_order_type != '手工单'
                                    <if test="platform!=null and platform !=''">
                                        and t1.platform_type = #{platform}
                                    </if>
                                GROUP BY DATE_FORMAT(paid_time, '%y%m%d')) tt1 on tt1.paid_date = tt2.date_str)
                            where tt2.bailun_sku =#{bailunSku}
                              and tt2.warehouse_code = #{warehouseCode}
                              and tt2.date &gt;= #{lowerTime}
                              and tt2.date &lt;= #{upperTime})
                               / #{days}
    </select>


</mapper>
