<?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="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="platform_sku" jdbcType="VARCHAR" property="platformSku" />
    <result column="platform_sku_title_en" jdbcType="VARCHAR" property="platformSkuTitleEn" />
    <result column="platform_sku_title_cn" jdbcType="VARCHAR" property="platformSkuTitleCn" />
    <result column="platform_sku_item_id" jdbcType="VARCHAR" property="platformSkuItemId" />
    <result column="platform_sku_quantity_ordered" jdbcType="INTEGER" property="platformSkuQuantityOrdered" />
    <result column="platform_sku_quantity_shipped" jdbcType="INTEGER" property="platformSkuQuantityShipped" />
    <result column="platform_sku_quantity_refund" jdbcType="INTEGER" property="platformSkuQuantityRefund" />
    <result column="platform_sku_unit_price" jdbcType="DECIMAL" property="platformSkuUnitPrice" />
    <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="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="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" 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_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="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_estimate_logistics" jdbcType="DECIMAL" property="costEstimateLogistics" />
    <result column="cost_first" jdbcType="DECIMAL" property="costFirst" />
    <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="category_id" jdbcType="INTEGER" property="categoryId" />
    <result column="category_name" jdbcType="VARCHAR" property="categoryName" />
    <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate" />
    <result column="gmt_modified" jdbcType="TIMESTAMP" property="gmtModified" />
  </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, paid_time, 
    refund_time, seller_id, bailun_account_id, hq_account, seller_account, seller_order_id, 
    seller_email, order_update_time, platform_sku, platform_sku_title_en, platform_sku_title_cn, 
    platform_sku_item_id, platform_sku_quantity_ordered, platform_sku_quantity_shipped, 
    platform_sku_quantity_refund, platform_sku_unit_price, seller_order_exchange_rate, 
    seller_other_exchange_rate, finance_order_exchange_rate, finance_other_exchange_rate, 
    order_currency, other_currency, seller_name, bailun_order_id, platform_order_status, 
    bailun_order_status, bailun_payment_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, bailun_sku_unit_price, 
    bailun_sku_weight, bailun_sku_size, amount_total, amount_shipping, amount_product, 
    amount_tax, amount_adjustment, amount_gift_wrap, amount_refund, cost_total, cost_promotion, 
    cost_platform_fee, cost_product, cost_shipping, cost_package, cost_fba_fee, cost_paypal_fee, 
    cost_refund_commisson, cost_estimate_logistics, cost_first, 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, category_id, category_name, 
    gmt_create, gmt_modified
  </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, 
      paid_time, refund_time, seller_id, 
      bailun_account_id, hq_account, seller_account, 
      seller_order_id, seller_email, order_update_time, 
      platform_sku, platform_sku_title_en, platform_sku_title_cn, 
      platform_sku_item_id, platform_sku_quantity_ordered, 
      platform_sku_quantity_shipped, platform_sku_quantity_refund, 
      platform_sku_unit_price, seller_order_exchange_rate, 
      seller_other_exchange_rate, finance_order_exchange_rate, 
      finance_other_exchange_rate, order_currency, 
      other_currency, seller_name, bailun_order_id, 
      platform_order_status, bailun_order_status, 
      bailun_payment_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, bailun_sku_unit_price, bailun_sku_weight, 
      bailun_sku_size, amount_total, amount_shipping, 
      amount_product, amount_tax, amount_adjustment, 
      amount_gift_wrap, amount_refund, cost_total, 
      cost_promotion, cost_platform_fee, cost_product, 
      cost_shipping, cost_package, cost_fba_fee, 
      cost_paypal_fee, cost_refund_commisson, cost_estimate_logistics, 
      cost_first, 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, 
      category_id, category_name, gmt_create, 
      gmt_modified)
    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},
      #{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},
      #{platformSku,jdbcType=VARCHAR}, #{platformSkuTitleEn,jdbcType=VARCHAR}, #{platformSkuTitleCn,jdbcType=VARCHAR}, 
      #{platformSkuItemId,jdbcType=VARCHAR}, #{platformSkuQuantityOrdered,jdbcType=INTEGER}, 
      #{platformSkuQuantityShipped,jdbcType=INTEGER}, #{platformSkuQuantityRefund,jdbcType=INTEGER}, 
      #{platformSkuUnitPrice,jdbcType=DECIMAL}, #{sellerOrderExchangeRate,jdbcType=DECIMAL}, 
      #{sellerOtherExchangeRate,jdbcType=DECIMAL}, #{financeOrderExchangeRate,jdbcType=DECIMAL}, 
      #{financeOtherExchangeRate,jdbcType=DECIMAL}, #{orderCurrency,jdbcType=VARCHAR}, 
      #{otherCurrency,jdbcType=VARCHAR}, #{sellerName,jdbcType=VARCHAR}, #{bailunOrderId,jdbcType=VARCHAR}, 
      #{platformOrderStatus,jdbcType=VARCHAR}, #{bailunOrderStatus,jdbcType=VARCHAR}, 
      #{bailunPaymentStatus,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}, 
      #{warehouseCode,jdbcType=VARCHAR}, #{bailunSkuUnitPrice,jdbcType=DECIMAL}, #{bailunSkuWeight,jdbcType=DECIMAL}, 
      #{bailunSkuSize,jdbcType=VARCHAR}, #{amountTotal,jdbcType=DECIMAL}, #{amountShipping,jdbcType=DECIMAL}, 
      #{amountProduct,jdbcType=DECIMAL}, #{amountTax,jdbcType=DECIMAL}, #{amountAdjustment,jdbcType=DECIMAL}, 
      #{amountGiftWrap,jdbcType=DECIMAL}, #{amountRefund,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}, #{costEstimateLogistics,jdbcType=DECIMAL}, 
      #{costFirst,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}, 
      #{categoryId,jdbcType=INTEGER}, #{categoryName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP},
      #{gmtModified,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="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="platformSku != null">
        platform_sku,
      </if>
      <if test="platformSkuTitleEn != null">
        platform_sku_title_en,
      </if>
      <if test="platformSkuTitleCn != null">
        platform_sku_title_cn,
      </if>
      <if test="platformSkuItemId != null">
        platform_sku_item_id,
      </if>
      <if test="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered,
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped,
      </if>
      <if test="platformSkuQuantityRefund != null">
        platform_sku_quantity_refund,
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price,
      </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="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="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="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="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="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="costEstimateLogistics != null">
        cost_estimate_logistics,
      </if>
      <if test="costFirst != null">
        cost_first,
      </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="categoryId != null">
        category_id,
      </if>
      <if test="categoryName != null">
        category_name,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </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="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="platformSku != null">
        #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleEn != null">
        #{platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleCn != null">
        #{platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuItemId != null">
        #{platformSkuItemId,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuQuantityOrdered != null">
        #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityRefund != null">
        #{platformSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        #{platformSkuUnitPrice,jdbcType=DECIMAL},
      </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="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="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="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="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="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="costEstimateLogistics != null">
        #{costEstimateLogistics,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        #{costFirst,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="categoryId != null">
        #{categoryId,jdbcType=INTEGER},
      </if>
      <if test="categoryName != null">
        #{categoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,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.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.platformSku != null">
        platform_sku = #{record.platformSku,jdbcType=VARCHAR},
      </if>
      <if test="record.platformSkuTitleEn != null">
        platform_sku_title_en = #{record.platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="record.platformSkuTitleCn != null">
        platform_sku_title_cn = #{record.platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="record.platformSkuItemId != null">
        platform_sku_item_id = #{record.platformSkuItemId,jdbcType=VARCHAR},
      </if>
      <if test="record.platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered = #{record.platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="record.platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped = #{record.platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="record.platformSkuQuantityRefund != null">
        platform_sku_quantity_refund = #{record.platformSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="record.platformSkuUnitPrice != null">
        platform_sku_unit_price = #{record.platformSkuUnitPrice,jdbcType=DECIMAL},
      </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.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.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.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.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.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.costEstimateLogistics != null">
        cost_estimate_logistics = #{record.costEstimateLogistics,jdbcType=DECIMAL},
      </if>
      <if test="record.costFirst != null">
        cost_first = #{record.costFirst,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.categoryId != null">
        category_id = #{record.categoryId,jdbcType=INTEGER},
      </if>
      <if test="record.categoryName != null">
        category_name = #{record.categoryName,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>
    </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},
      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},
      platform_sku = #{record.platformSku,jdbcType=VARCHAR},
      platform_sku_title_en = #{record.platformSkuTitleEn,jdbcType=VARCHAR},
      platform_sku_title_cn = #{record.platformSkuTitleCn,jdbcType=VARCHAR},
      platform_sku_item_id = #{record.platformSkuItemId,jdbcType=VARCHAR},
      platform_sku_quantity_ordered = #{record.platformSkuQuantityOrdered,jdbcType=INTEGER},
      platform_sku_quantity_shipped = #{record.platformSkuQuantityShipped,jdbcType=INTEGER},
      platform_sku_quantity_refund = #{record.platformSkuQuantityRefund,jdbcType=INTEGER},
      platform_sku_unit_price = #{record.platformSkuUnitPrice,jdbcType=DECIMAL},
      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},
      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},
      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 = #{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_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},
      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_estimate_logistics = #{record.costEstimateLogistics,jdbcType=DECIMAL},
      cost_first = #{record.costFirst,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},
      category_id = #{record.categoryId,jdbcType=INTEGER},
      category_name = #{record.categoryName,jdbcType=VARCHAR},
      gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{record.gmtModified,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="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="platformSku != null">
        platform_sku = #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleEn != null">
        platform_sku_title_en = #{platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleCn != null">
        platform_sku_title_cn = #{platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuItemId != null">
        platform_sku_item_id = #{platformSkuItemId,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityRefund != null">
        platform_sku_quantity_refund = #{platformSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price = #{platformSkuUnitPrice,jdbcType=DECIMAL},
      </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="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="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="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="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="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="costEstimateLogistics != null">
        cost_estimate_logistics = #{costEstimateLogistics,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        cost_first = #{costFirst,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="categoryId != null">
        category_id = #{categoryId,jdbcType=INTEGER},
      </if>
      <if test="categoryName != null">
        category_name = #{categoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,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},
      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},
      platform_sku = #{platformSku,jdbcType=VARCHAR},
      platform_sku_title_en = #{platformSkuTitleEn,jdbcType=VARCHAR},
      platform_sku_title_cn = #{platformSkuTitleCn,jdbcType=VARCHAR},
      platform_sku_item_id = #{platformSkuItemId,jdbcType=VARCHAR},
      platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER},
      platform_sku_quantity_refund = #{platformSkuQuantityRefund,jdbcType=INTEGER},
      platform_sku_unit_price = #{platformSkuUnitPrice,jdbcType=DECIMAL},
      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},
      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},
      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 = #{warehouseCode,jdbcType=VARCHAR},
      bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL},
      bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL},
      bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR},
      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},
      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_estimate_logistics = #{costEstimateLogistics,jdbcType=DECIMAL},
      cost_first = #{costFirst,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},
      category_id = #{categoryId,jdbcType=INTEGER},
      category_name = #{categoryName,jdbcType=VARCHAR},
      gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{gmtModified,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="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="platformSku != null">
        platform_sku,
      </if>
      <if test="platformSkuTitleEn != null">
        platform_sku_title_en,
      </if>
      <if test="platformSkuTitleCn != null">
        platform_sku_title_cn,
      </if>
      <if test="platformSkuItemId != null">
        platform_sku_item_id,
      </if>
      <if test="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered,
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped,
      </if>
      <if test="platformSkuQuantityRefund != null">
        platform_sku_quantity_refund,
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price,
      </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="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="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="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="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="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="costEstimateLogistics != null">
        cost_estimate_logistics,
      </if>
      <if test="costFirst != null">
        cost_first,
      </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="categoryId != null">
        category_id,
      </if>
      <if test="categoryName != null">
        category_name,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </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="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="platformSku != null">
        #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleEn != null">
        #{platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleCn != null">
        #{platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuItemId != null">
        #{platformSkuItemId,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuQuantityOrdered != null">
        #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityRefund != null">
        #{platformSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        #{platformSkuUnitPrice,jdbcType=DECIMAL},
      </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="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="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="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="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="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="costEstimateLogistics != null">
        #{costEstimateLogistics,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        #{costFirst,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="categoryId != null">
        #{categoryId,jdbcType=INTEGER},
      </if>
      <if test="categoryName != null">
        #{categoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,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="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="platformSku != null">
        platform_sku = #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleEn != null">
        platform_sku_title_en = #{platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleCn != null">
        platform_sku_title_cn = #{platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuItemId != null">
        platform_sku_item_id = #{platformSkuItemId,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityRefund != null">
        platform_sku_quantity_refund = #{platformSkuQuantityRefund,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price = #{platformSkuUnitPrice,jdbcType=DECIMAL},
      </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="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="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="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="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="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="costEstimateLogistics != null">
        cost_estimate_logistics = #{costEstimateLogistics,jdbcType=DECIMAL},
      </if>
      <if test="costFirst != null">
        cost_first = #{costFirst,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="categoryId != null">
        category_id = #{categoryId,jdbcType=INTEGER},
      </if>
      <if test="categoryName != null">
        category_name = #{categoryName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,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, paid_time, 
      refund_time, seller_id, bailun_account_id, hq_account, seller_account, seller_order_id, 
      seller_email, order_update_time, platform_sku, platform_sku_title_en, platform_sku_title_cn, 
      platform_sku_item_id, platform_sku_quantity_ordered, platform_sku_quantity_shipped, 
      platform_sku_quantity_refund, platform_sku_unit_price, seller_order_exchange_rate, 
      seller_other_exchange_rate, finance_order_exchange_rate, finance_other_exchange_rate, 
      order_currency, other_currency, seller_name, bailun_order_id, platform_order_status, 
      bailun_order_status, bailun_payment_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, 
      bailun_sku_unit_price, bailun_sku_weight, bailun_sku_size, amount_total, amount_shipping, 
      amount_product, amount_tax, amount_adjustment, amount_gift_wrap, amount_refund, 
      cost_total, cost_promotion, cost_platform_fee, cost_product, cost_shipping, cost_package, 
      cost_fba_fee, cost_paypal_fee, cost_refund_commisson, cost_estimate_logistics, 
      cost_first, 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, category_id, category_name, gmt_create, gmt_modified)
    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},
      #{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},
      #{platformSku,jdbcType=VARCHAR}, #{platformSkuTitleEn,jdbcType=VARCHAR}, #{platformSkuTitleCn,jdbcType=VARCHAR}, 
      #{platformSkuItemId,jdbcType=VARCHAR}, #{platformSkuQuantityOrdered,jdbcType=INTEGER}, 
      #{platformSkuQuantityShipped,jdbcType=INTEGER}, #{platformSkuQuantityRefund,jdbcType=INTEGER}, 
      #{platformSkuUnitPrice,jdbcType=DECIMAL}, #{sellerOrderExchangeRate,jdbcType=DECIMAL}, 
      #{sellerOtherExchangeRate,jdbcType=DECIMAL}, #{financeOrderExchangeRate,jdbcType=DECIMAL}, 
      #{financeOtherExchangeRate,jdbcType=DECIMAL}, #{orderCurrency,jdbcType=VARCHAR}, 
      #{otherCurrency,jdbcType=VARCHAR}, #{sellerName,jdbcType=VARCHAR}, #{bailunOrderId,jdbcType=VARCHAR}, 
      #{platformOrderStatus,jdbcType=VARCHAR}, #{bailunOrderStatus,jdbcType=VARCHAR}, 
      #{bailunPaymentStatus,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}, 
      #{warehouseCode,jdbcType=VARCHAR}, #{bailunSkuUnitPrice,jdbcType=DECIMAL}, #{bailunSkuWeight,jdbcType=DECIMAL}, 
      #{bailunSkuSize,jdbcType=VARCHAR}, #{amountTotal,jdbcType=DECIMAL}, #{amountShipping,jdbcType=DECIMAL}, 
      #{amountProduct,jdbcType=DECIMAL}, #{amountTax,jdbcType=DECIMAL}, #{amountAdjustment,jdbcType=DECIMAL}, 
      #{amountGiftWrap,jdbcType=DECIMAL}, #{amountRefund,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}, #{costEstimateLogistics,jdbcType=DECIMAL}, 
      #{costFirst,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}, 
      #{categoryId,jdbcType=INTEGER}, #{categoryName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP},
      #{gmtModified,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},
    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},
    platform_sku = #{platformSku,jdbcType=VARCHAR}, 
    platform_sku_title_en = #{platformSkuTitleEn,jdbcType=VARCHAR}, 
    platform_sku_title_cn = #{platformSkuTitleCn,jdbcType=VARCHAR}, 
    platform_sku_item_id = #{platformSkuItemId,jdbcType=VARCHAR}, 
    platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER}, 
    platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER}, 
    platform_sku_quantity_refund = #{platformSkuQuantityRefund,jdbcType=INTEGER}, 
    platform_sku_unit_price = #{platformSkuUnitPrice,jdbcType=DECIMAL}, 
    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}, 
    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}, 
    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 = #{warehouseCode,jdbcType=VARCHAR}, 
    bailun_sku_unit_price = #{bailunSkuUnitPrice,jdbcType=DECIMAL}, 
    bailun_sku_weight = #{bailunSkuWeight,jdbcType=DECIMAL}, 
    bailun_sku_size = #{bailunSkuSize,jdbcType=VARCHAR}, 
    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}, 
    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_estimate_logistics = #{costEstimateLogistics,jdbcType=DECIMAL}, 
    cost_first = #{costFirst,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}, 
    category_id = #{categoryId,jdbcType=INTEGER}, 
    category_name = #{categoryName,jdbcType=VARCHAR}, 
    gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
    gmt_modified = #{gmtModified,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 >= 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 >= DATE_SUB(CURDATE(),INTERVAL #{timeInterval} day) GROUP BY bailun_sku,website
  </select>
</mapper>