<?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.DcBaseOmsPlatformSkuMapper">
  <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      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_site" jdbcType="TIMESTAMP" property="payTimeSite" />
    <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="create_time_site" jdbcType="TIMESTAMP" property="createTimeSite" />
    <result column="paid_time_site" jdbcType="TIMESTAMP" property="paidTimeSite" />
    <result column="paid_time" jdbcType="TIMESTAMP" property="paidTime" />
    <result column="seller_id" jdbcType="VARCHAR" property="sellerId" />
    <result column="bailun_account_id" jdbcType="INTEGER" property="bailunAccountId" />
    <result column="seller_account" jdbcType="VARCHAR" property="sellerAccount" />
    <result column="seller_order_id" jdbcType="VARCHAR" property="sellerOrderId" />
    <result column="seller_email" jdbcType="VARCHAR" property="sellerEmail" />
    <result column="order_update_time" jdbcType="TIMESTAMP" property="orderUpdateTime" />
    <result column="seller_order_exchange_rate" jdbcType="DECIMAL" property="sellerOrderExchangeRate" />
    <result column="finance_order_exchange_rate" jdbcType="DECIMAL" property="financeOrderExchangeRate" />
    <result column="cny_to_usd_exchange_rate" jdbcType="DECIMAL" property="cnyToUsdExchangeRate" />
    <result column="order_to_usd_exchange_rate" jdbcType="DECIMAL" property="orderToUsdExchangeRate" />
    <result column="order_currency" jdbcType="VARCHAR" property="orderCurrency" />
    <result column="seller_name" jdbcType="VARCHAR" property="sellerName" />
    <result column="bailun_order_id" jdbcType="VARCHAR" property="bailunOrderId" />
    <result column="platform_order_status" jdbcType="VARCHAR" property="platformOrderStatus" />
    <result column="bailun_order_status" jdbcType="VARCHAR" property="bailunOrderStatus" />
    <result column="bailun_payment_status" jdbcType="VARCHAR" property="bailunPaymentStatus" />
    <result column="bailun_interception_status" jdbcType="VARCHAR" property="bailunInterceptionStatus" />
    <result column="shipping_status" jdbcType="VARCHAR" property="shippingStatus" />
    <result column="platform_sku" jdbcType="VARCHAR" property="platformSku" />
    <result column="item_id" jdbcType="VARCHAR" property="itemId" />
    <result column="platform_sku_title_en" jdbcType="VARCHAR" property="platformSkuTitleEn" />
    <result column="platform_sku_title_cn" jdbcType="VARCHAR" property="platformSkuTitleCn" />
    <result column="platform_sku_quantity_ordered" jdbcType="INTEGER" property="platformSkuQuantityOrdered" />
    <result column="platform_sku_quantity_shipped" jdbcType="INTEGER" property="platformSkuQuantityShipped" />
    <result column="platform_sku_unit_price" jdbcType="DECIMAL" property="platformSkuUnitPrice" />
    <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_cancle" jdbcType="BIT" property="hasCancle" />
    <result column="area_id" jdbcType="INTEGER" property="areaId" />
    <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate" />
    <result column="gmt_modified" jdbcType="TIMESTAMP" property="gmtModified" />
    <result column="has_delete" jdbcType="BIT" property="hasDelete" />
    <result column="has_scalp" jdbcType="BIT" property="hasScalp" />
  </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_site, pay_time, pay_method, 
    pay_account, pay_status, collection_account, platform_order_type, website, create_time, 
    create_time_site, paid_time_site, paid_time, seller_id, bailun_account_id, seller_account, 
    seller_order_id, seller_email, order_update_time, seller_order_exchange_rate, finance_order_exchange_rate, 
    cny_to_usd_exchange_rate, order_to_usd_exchange_rate, order_currency, seller_name, 
    bailun_order_id, platform_order_status, bailun_order_status, bailun_payment_status, 
    bailun_interception_status, shipping_status, platform_sku, item_id, platform_sku_title_en, 
    platform_sku_title_cn, platform_sku_quantity_ordered, platform_sku_quantity_shipped, 
    platform_sku_unit_price, receipt_country, receipt_city, receipt_area, receipt_address, 
    receipt_address_2, receipt_postal_code, receiver, receiver_phone, buyer_id, buyer_name, 
    buyer_email, has_cancle, area_id, gmt_create, gmt_modified, has_delete, has_scalp
  </sql>
  <select id="selectByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPlatformSkuExample" 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_platform_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_platform_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_platform_sku
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPlatformSkuExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from dc_base_oms_platform_sku
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_oms_platform_sku (id, origin_order_id, platform_type, 
      transaction_id, pay_time_site, pay_time, 
      pay_method, pay_account, pay_status, 
      collection_account, platform_order_type, website, 
      create_time, create_time_site, paid_time_site, 
      paid_time, seller_id, bailun_account_id, 
      seller_account, seller_order_id, seller_email, 
      order_update_time, seller_order_exchange_rate, 
      finance_order_exchange_rate, cny_to_usd_exchange_rate, 
      order_to_usd_exchange_rate, order_currency, 
      seller_name, bailun_order_id, platform_order_status, 
      bailun_order_status, bailun_payment_status, 
      bailun_interception_status, shipping_status, 
      platform_sku, item_id, platform_sku_title_en, 
      platform_sku_title_cn, platform_sku_quantity_ordered, 
      platform_sku_quantity_shipped, platform_sku_unit_price, 
      receipt_country, receipt_city, receipt_area, 
      receipt_address, receipt_address_2, receipt_postal_code, 
      receiver, receiver_phone, buyer_id, 
      buyer_name, buyer_email, has_cancle, 
      area_id, gmt_create, gmt_modified, 
      has_delete, has_scalp)
    values (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{platformType,jdbcType=VARCHAR}, 
      #{transactionId,jdbcType=VARCHAR}, #{payTimeSite,jdbcType=TIMESTAMP}, #{payTime,jdbcType=TIMESTAMP}, 
      #{payMethod,jdbcType=VARCHAR}, #{payAccount,jdbcType=VARCHAR}, #{payStatus,jdbcType=VARCHAR}, 
      #{collectionAccount,jdbcType=VARCHAR}, #{platformOrderType,jdbcType=VARCHAR}, #{website,jdbcType=VARCHAR}, 
      #{createTime,jdbcType=TIMESTAMP}, #{createTimeSite,jdbcType=TIMESTAMP}, #{paidTimeSite,jdbcType=TIMESTAMP}, 
      #{paidTime,jdbcType=TIMESTAMP}, #{sellerId,jdbcType=VARCHAR}, #{bailunAccountId,jdbcType=INTEGER}, 
      #{sellerAccount,jdbcType=VARCHAR}, #{sellerOrderId,jdbcType=VARCHAR}, #{sellerEmail,jdbcType=VARCHAR}, 
      #{orderUpdateTime,jdbcType=TIMESTAMP}, #{sellerOrderExchangeRate,jdbcType=DECIMAL}, 
      #{financeOrderExchangeRate,jdbcType=DECIMAL}, #{cnyToUsdExchangeRate,jdbcType=DECIMAL}, 
      #{orderToUsdExchangeRate,jdbcType=DECIMAL}, #{orderCurrency,jdbcType=VARCHAR}, 
      #{sellerName,jdbcType=VARCHAR}, #{bailunOrderId,jdbcType=VARCHAR}, #{platformOrderStatus,jdbcType=VARCHAR}, 
      #{bailunOrderStatus,jdbcType=VARCHAR}, #{bailunPaymentStatus,jdbcType=VARCHAR}, 
      #{bailunInterceptionStatus,jdbcType=VARCHAR}, #{shippingStatus,jdbcType=VARCHAR}, 
      #{platformSku,jdbcType=VARCHAR}, #{itemId,jdbcType=VARCHAR}, #{platformSkuTitleEn,jdbcType=VARCHAR}, 
      #{platformSkuTitleCn,jdbcType=VARCHAR}, #{platformSkuQuantityOrdered,jdbcType=INTEGER}, 
      #{platformSkuQuantityShipped,jdbcType=INTEGER}, #{platformSkuUnitPrice,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}, #{hasCancle,jdbcType=BIT}, 
      #{areaId,jdbcType=INTEGER}, #{gmtCreate,jdbcType=TIMESTAMP}, #{gmtModified,jdbcType=TIMESTAMP}, 
      #{hasDelete,jdbcType=BIT}, #{hasScalp,jdbcType=BIT})
  </insert>
  <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_oms_platform_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="payTimeSite != null">
        pay_time_site,
      </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="createTimeSite != null">
        create_time_site,
      </if>
      <if test="paidTimeSite != null">
        paid_time_site,
      </if>
      <if test="paidTime != null">
        paid_time,
      </if>
      <if test="sellerId != null">
        seller_id,
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id,
      </if>
      <if test="sellerAccount != null">
        seller_account,
      </if>
      <if test="sellerOrderId != null">
        seller_order_id,
      </if>
      <if test="sellerEmail != null">
        seller_email,
      </if>
      <if test="orderUpdateTime != null">
        order_update_time,
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate,
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate,
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate,
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate,
      </if>
      <if test="orderCurrency != null">
        order_currency,
      </if>
      <if test="sellerName != null">
        seller_name,
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id,
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status,
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status,
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status,
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status,
      </if>
      <if test="shippingStatus != null">
        shipping_status,
      </if>
      <if test="platformSku != null">
        platform_sku,
      </if>
      <if test="itemId != null">
        item_id,
      </if>
      <if test="platformSkuTitleEn != null">
        platform_sku_title_en,
      </if>
      <if test="platformSkuTitleCn != null">
        platform_sku_title_cn,
      </if>
      <if test="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered,
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped,
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price,
      </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="hasCancle != null">
        has_cancle,
      </if>
      <if test="areaId != null">
        area_id,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </if>
      <if test="hasDelete != null">
        has_delete,
      </if>
      <if test="hasScalp != null">
        has_scalp,
      </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="payTimeSite != null">
        #{payTimeSite,jdbcType=TIMESTAMP},
      </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="createTimeSite != null">
        #{createTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTimeSite != null">
        #{paidTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        #{paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerId != null">
        #{sellerId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="sellerAccount != null">
        #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="platformSku != null">
        #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="itemId != null">
        #{itemId,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleEn != null">
        #{platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleCn != null">
        #{platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuQuantityOrdered != null">
        #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        #{platformSkuUnitPrice,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="hasCancle != null">
        #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        #{areaId,jdbcType=INTEGER},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="hasDelete != null">
        #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        #{hasScalp,jdbcType=BIT},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPlatformSkuExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from dc_base_oms_platform_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_platform_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.payTimeSite != null">
        pay_time_site = #{record.payTimeSite,jdbcType=TIMESTAMP},
      </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.createTimeSite != null">
        create_time_site = #{record.createTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="record.paidTimeSite != null">
        paid_time_site = #{record.paidTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="record.paidTime != null">
        paid_time = #{record.paidTime,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.sellerAccount != null">
        seller_account = #{record.sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerOrderId != null">
        seller_order_id = #{record.sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerEmail != null">
        seller_email = #{record.sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="record.orderUpdateTime != null">
        order_update_time = #{record.orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.sellerOrderExchangeRate != null">
        seller_order_exchange_rate = #{record.sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.financeOrderExchangeRate != null">
        finance_order_exchange_rate = #{record.financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate = #{record.cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate = #{record.orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.orderCurrency != null">
        order_currency = #{record.orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="record.sellerName != null">
        seller_name = #{record.sellerName,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunOrderId != null">
        bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.platformOrderStatus != null">
        platform_order_status = #{record.platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunOrderStatus != null">
        bailun_order_status = #{record.bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunPaymentStatus != null">
        bailun_payment_status = #{record.bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunInterceptionStatus != null">
        bailun_interception_status = #{record.bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.shippingStatus != null">
        shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.platformSku != null">
        platform_sku = #{record.platformSku,jdbcType=VARCHAR},
      </if>
      <if test="record.itemId != null">
        item_id = #{record.itemId,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.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.platformSkuUnitPrice != null">
        platform_sku_unit_price = #{record.platformSkuUnitPrice,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.hasCancle != null">
        has_cancle = #{record.hasCancle,jdbcType=BIT},
      </if>
      <if test="record.areaId != null">
        area_id = #{record.areaId,jdbcType=INTEGER},
      </if>
      <if test="record.gmtCreate != null">
        gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.gmtModified != null">
        gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="record.hasDelete != null">
        has_delete = #{record.hasDelete,jdbcType=BIT},
      </if>
      <if test="record.hasScalp != null">
        has_scalp = #{record.hasScalp,jdbcType=BIT},
      </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_platform_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_site = #{record.payTimeSite,jdbcType=TIMESTAMP},
      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},
      create_time_site = #{record.createTimeSite,jdbcType=TIMESTAMP},
      paid_time_site = #{record.paidTimeSite,jdbcType=TIMESTAMP},
      paid_time = #{record.paidTime,jdbcType=TIMESTAMP},
      seller_id = #{record.sellerId,jdbcType=VARCHAR},
      bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
      seller_account = #{record.sellerAccount,jdbcType=VARCHAR},
      seller_order_id = #{record.sellerOrderId,jdbcType=VARCHAR},
      seller_email = #{record.sellerEmail,jdbcType=VARCHAR},
      order_update_time = #{record.orderUpdateTime,jdbcType=TIMESTAMP},
      seller_order_exchange_rate = #{record.sellerOrderExchangeRate,jdbcType=DECIMAL},
      finance_order_exchange_rate = #{record.financeOrderExchangeRate,jdbcType=DECIMAL},
      cny_to_usd_exchange_rate = #{record.cnyToUsdExchangeRate,jdbcType=DECIMAL},
      order_to_usd_exchange_rate = #{record.orderToUsdExchangeRate,jdbcType=DECIMAL},
      order_currency = #{record.orderCurrency,jdbcType=VARCHAR},
      seller_name = #{record.sellerName,jdbcType=VARCHAR},
      bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
      platform_order_status = #{record.platformOrderStatus,jdbcType=VARCHAR},
      bailun_order_status = #{record.bailunOrderStatus,jdbcType=VARCHAR},
      bailun_payment_status = #{record.bailunPaymentStatus,jdbcType=VARCHAR},
      bailun_interception_status = #{record.bailunInterceptionStatus,jdbcType=VARCHAR},
      shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
      platform_sku = #{record.platformSku,jdbcType=VARCHAR},
      item_id = #{record.itemId,jdbcType=VARCHAR},
      platform_sku_title_en = #{record.platformSkuTitleEn,jdbcType=VARCHAR},
      platform_sku_title_cn = #{record.platformSkuTitleCn,jdbcType=VARCHAR},
      platform_sku_quantity_ordered = #{record.platformSkuQuantityOrdered,jdbcType=INTEGER},
      platform_sku_quantity_shipped = #{record.platformSkuQuantityShipped,jdbcType=INTEGER},
      platform_sku_unit_price = #{record.platformSkuUnitPrice,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_cancle = #{record.hasCancle,jdbcType=BIT},
      area_id = #{record.areaId,jdbcType=INTEGER},
      gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
      has_delete = #{record.hasDelete,jdbcType=BIT},
      has_scalp = #{record.hasScalp,jdbcType=BIT}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_platform_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="payTimeSite != null">
        pay_time_site = #{payTimeSite,jdbcType=TIMESTAMP},
      </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="createTimeSite != null">
        create_time_site = #{createTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTimeSite != null">
        paid_time_site = #{paidTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        paid_time = #{paidTime,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="sellerAccount != null">
        seller_account = #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        seller_email = #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        order_currency = #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        seller_name = #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="platformSku != null">
        platform_sku = #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="itemId != null">
        item_id = #{itemId,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="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price = #{platformSkuUnitPrice,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="hasCancle != null">
        has_cancle = #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        area_id = #{areaId,jdbcType=INTEGER},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="hasDelete != null">
        has_delete = #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        has_scalp = #{hasScalp,jdbcType=BIT},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_platform_sku
    set origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      platform_type = #{platformType,jdbcType=VARCHAR},
      transaction_id = #{transactionId,jdbcType=VARCHAR},
      pay_time_site = #{payTimeSite,jdbcType=TIMESTAMP},
      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},
      create_time_site = #{createTimeSite,jdbcType=TIMESTAMP},
      paid_time_site = #{paidTimeSite,jdbcType=TIMESTAMP},
      paid_time = #{paidTime,jdbcType=TIMESTAMP},
      seller_id = #{sellerId,jdbcType=VARCHAR},
      bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      seller_account = #{sellerAccount,jdbcType=VARCHAR},
      seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
      seller_email = #{sellerEmail,jdbcType=VARCHAR},
      order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
      seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
      cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      order_currency = #{orderCurrency,jdbcType=VARCHAR},
      seller_name = #{sellerName,jdbcType=VARCHAR},
      bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
      bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
      bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
      bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
      shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      platform_sku = #{platformSku,jdbcType=VARCHAR},
      item_id = #{itemId,jdbcType=VARCHAR},
      platform_sku_title_en = #{platformSkuTitleEn,jdbcType=VARCHAR},
      platform_sku_title_cn = #{platformSkuTitleCn,jdbcType=VARCHAR},
      platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER},
      platform_sku_unit_price = #{platformSkuUnitPrice,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_cancle = #{hasCancle,jdbcType=BIT},
      area_id = #{areaId,jdbcType=INTEGER},
      gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      has_delete = #{hasDelete,jdbcType=BIT},
      has_scalp = #{hasScalp,jdbcType=BIT}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      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_platform_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="payTimeSite != null">
        pay_time_site,
      </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="createTimeSite != null">
        create_time_site,
      </if>
      <if test="paidTimeSite != null">
        paid_time_site,
      </if>
      <if test="paidTime != null">
        paid_time,
      </if>
      <if test="sellerId != null">
        seller_id,
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id,
      </if>
      <if test="sellerAccount != null">
        seller_account,
      </if>
      <if test="sellerOrderId != null">
        seller_order_id,
      </if>
      <if test="sellerEmail != null">
        seller_email,
      </if>
      <if test="orderUpdateTime != null">
        order_update_time,
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate,
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate,
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate,
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate,
      </if>
      <if test="orderCurrency != null">
        order_currency,
      </if>
      <if test="sellerName != null">
        seller_name,
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id,
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status,
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status,
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status,
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status,
      </if>
      <if test="shippingStatus != null">
        shipping_status,
      </if>
      <if test="platformSku != null">
        platform_sku,
      </if>
      <if test="itemId != null">
        item_id,
      </if>
      <if test="platformSkuTitleEn != null">
        platform_sku_title_en,
      </if>
      <if test="platformSkuTitleCn != null">
        platform_sku_title_cn,
      </if>
      <if test="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered,
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped,
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price,
      </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="hasCancle != null">
        has_cancle,
      </if>
      <if test="areaId != null">
        area_id,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </if>
      <if test="hasDelete != null">
        has_delete,
      </if>
      <if test="hasScalp != null">
        has_scalp,
      </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="payTimeSite != null">
        #{payTimeSite,jdbcType=TIMESTAMP},
      </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="createTimeSite != null">
        #{createTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTimeSite != null">
        #{paidTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        #{paidTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerId != null">
        #{sellerId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="sellerAccount != null">
        #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="platformSku != null">
        #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="itemId != null">
        #{itemId,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleEn != null">
        #{platformSkuTitleEn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuTitleCn != null">
        #{platformSkuTitleCn,jdbcType=VARCHAR},
      </if>
      <if test="platformSkuQuantityOrdered != null">
        #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        #{platformSkuUnitPrice,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="hasCancle != null">
        #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        #{areaId,jdbcType=INTEGER},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="hasDelete != null">
        #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        #{hasScalp,jdbcType=BIT},
      </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="payTimeSite != null">
        pay_time_site = #{payTimeSite,jdbcType=TIMESTAMP},
      </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="createTimeSite != null">
        create_time_site = #{createTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTimeSite != null">
        paid_time_site = #{paidTimeSite,jdbcType=TIMESTAMP},
      </if>
      <if test="paidTime != null">
        paid_time = #{paidTime,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="sellerAccount != null">
        seller_account = #{sellerAccount,jdbcType=VARCHAR},
      </if>
      <if test="sellerOrderId != null">
        seller_order_id = #{sellerOrderId,jdbcType=VARCHAR},
      </if>
      <if test="sellerEmail != null">
        seller_email = #{sellerEmail,jdbcType=VARCHAR},
      </if>
      <if test="orderUpdateTime != null">
        order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="sellerOrderExchangeRate != null">
        seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="financeOrderExchangeRate != null">
        finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="cnyToUsdExchangeRate != null">
        cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderToUsdExchangeRate != null">
        order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="orderCurrency != null">
        order_currency = #{orderCurrency,jdbcType=VARCHAR},
      </if>
      <if test="sellerName != null">
        seller_name = #{sellerName,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="platformOrderStatus != null">
        platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunOrderStatus != null">
        bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunPaymentStatus != null">
        bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR},
      </if>
      <if test="bailunInterceptionStatus != null">
        bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="platformSku != null">
        platform_sku = #{platformSku,jdbcType=VARCHAR},
      </if>
      <if test="itemId != null">
        item_id = #{itemId,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="platformSkuQuantityOrdered != null">
        platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER},
      </if>
      <if test="platformSkuQuantityShipped != null">
        platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER},
      </if>
      <if test="platformSkuUnitPrice != null">
        platform_sku_unit_price = #{platformSkuUnitPrice,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="hasCancle != null">
        has_cancle = #{hasCancle,jdbcType=BIT},
      </if>
      <if test="areaId != null">
        area_id = #{areaId,jdbcType=INTEGER},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="hasDelete != null">
        has_delete = #{hasDelete,jdbcType=BIT},
      </if>
      <if test="hasScalp != null">
        has_scalp = #{hasScalp,jdbcType=BIT},
      </if>
    </trim>
  </insert>
  <insert id="upsert" parameterType="com.bailuntec.domain.entity.DcBaseOmsPlatformSku">
    <!--
      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_platform_sku
    (id, origin_order_id, platform_type, transaction_id, pay_time_site, pay_time, pay_method, 
      pay_account, pay_status, collection_account, platform_order_type, website, create_time, 
      create_time_site, paid_time_site, paid_time, seller_id, bailun_account_id, seller_account, 
      seller_order_id, seller_email, order_update_time, seller_order_exchange_rate, finance_order_exchange_rate, 
      cny_to_usd_exchange_rate, order_to_usd_exchange_rate, order_currency, seller_name, 
      bailun_order_id, platform_order_status, bailun_order_status, bailun_payment_status, 
      bailun_interception_status, shipping_status, platform_sku, item_id, platform_sku_title_en, 
      platform_sku_title_cn, platform_sku_quantity_ordered, platform_sku_quantity_shipped, 
      platform_sku_unit_price, receipt_country, receipt_city, receipt_area, receipt_address, 
      receipt_address_2, receipt_postal_code, receiver, receiver_phone, buyer_id, buyer_name, 
      buyer_email, has_cancle, area_id, gmt_create, gmt_modified, has_delete, has_scalp
      )
    values
    (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{platformType,jdbcType=VARCHAR}, 
      #{transactionId,jdbcType=VARCHAR}, #{payTimeSite,jdbcType=TIMESTAMP}, #{payTime,jdbcType=TIMESTAMP}, 
      #{payMethod,jdbcType=VARCHAR}, #{payAccount,jdbcType=VARCHAR}, #{payStatus,jdbcType=VARCHAR}, 
      #{collectionAccount,jdbcType=VARCHAR}, #{platformOrderType,jdbcType=VARCHAR}, #{website,jdbcType=VARCHAR}, 
      #{createTime,jdbcType=TIMESTAMP}, #{createTimeSite,jdbcType=TIMESTAMP}, #{paidTimeSite,jdbcType=TIMESTAMP}, 
      #{paidTime,jdbcType=TIMESTAMP}, #{sellerId,jdbcType=VARCHAR}, #{bailunAccountId,jdbcType=INTEGER}, 
      #{sellerAccount,jdbcType=VARCHAR}, #{sellerOrderId,jdbcType=VARCHAR}, #{sellerEmail,jdbcType=VARCHAR}, 
      #{orderUpdateTime,jdbcType=TIMESTAMP}, #{sellerOrderExchangeRate,jdbcType=DECIMAL}, 
      #{financeOrderExchangeRate,jdbcType=DECIMAL}, #{cnyToUsdExchangeRate,jdbcType=DECIMAL}, 
      #{orderToUsdExchangeRate,jdbcType=DECIMAL}, #{orderCurrency,jdbcType=VARCHAR}, 
      #{sellerName,jdbcType=VARCHAR}, #{bailunOrderId,jdbcType=VARCHAR}, #{platformOrderStatus,jdbcType=VARCHAR}, 
      #{bailunOrderStatus,jdbcType=VARCHAR}, #{bailunPaymentStatus,jdbcType=VARCHAR}, 
      #{bailunInterceptionStatus,jdbcType=VARCHAR}, #{shippingStatus,jdbcType=VARCHAR}, 
      #{platformSku,jdbcType=VARCHAR}, #{itemId,jdbcType=VARCHAR}, #{platformSkuTitleEn,jdbcType=VARCHAR}, 
      #{platformSkuTitleCn,jdbcType=VARCHAR}, #{platformSkuQuantityOrdered,jdbcType=INTEGER}, 
      #{platformSkuQuantityShipped,jdbcType=INTEGER}, #{platformSkuUnitPrice,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}, #{hasCancle,jdbcType=BIT}, 
      #{areaId,jdbcType=INTEGER}, #{gmtCreate,jdbcType=TIMESTAMP}, #{gmtModified,jdbcType=TIMESTAMP}, 
      #{hasDelete,jdbcType=BIT}, #{hasScalp,jdbcType=BIT})
    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_site = #{payTimeSite,jdbcType=TIMESTAMP}, 
    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}, 
    create_time_site = #{createTimeSite,jdbcType=TIMESTAMP}, 
    paid_time_site = #{paidTimeSite,jdbcType=TIMESTAMP}, 
    paid_time = #{paidTime,jdbcType=TIMESTAMP}, 
    seller_id = #{sellerId,jdbcType=VARCHAR}, 
    bailun_account_id = #{bailunAccountId,jdbcType=INTEGER}, 
    seller_account = #{sellerAccount,jdbcType=VARCHAR}, 
    seller_order_id = #{sellerOrderId,jdbcType=VARCHAR}, 
    seller_email = #{sellerEmail,jdbcType=VARCHAR}, 
    order_update_time = #{orderUpdateTime,jdbcType=TIMESTAMP}, 
    seller_order_exchange_rate = #{sellerOrderExchangeRate,jdbcType=DECIMAL}, 
    finance_order_exchange_rate = #{financeOrderExchangeRate,jdbcType=DECIMAL}, 
    cny_to_usd_exchange_rate = #{cnyToUsdExchangeRate,jdbcType=DECIMAL}, 
    order_to_usd_exchange_rate = #{orderToUsdExchangeRate,jdbcType=DECIMAL}, 
    order_currency = #{orderCurrency,jdbcType=VARCHAR}, 
    seller_name = #{sellerName,jdbcType=VARCHAR}, 
    bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR}, 
    platform_order_status = #{platformOrderStatus,jdbcType=VARCHAR}, 
    bailun_order_status = #{bailunOrderStatus,jdbcType=VARCHAR}, 
    bailun_payment_status = #{bailunPaymentStatus,jdbcType=VARCHAR}, 
    bailun_interception_status = #{bailunInterceptionStatus,jdbcType=VARCHAR}, 
    shipping_status = #{shippingStatus,jdbcType=VARCHAR}, 
    platform_sku = #{platformSku,jdbcType=VARCHAR}, 
    item_id = #{itemId,jdbcType=VARCHAR}, 
    platform_sku_title_en = #{platformSkuTitleEn,jdbcType=VARCHAR}, 
    platform_sku_title_cn = #{platformSkuTitleCn,jdbcType=VARCHAR}, 
    platform_sku_quantity_ordered = #{platformSkuQuantityOrdered,jdbcType=INTEGER}, 
    platform_sku_quantity_shipped = #{platformSkuQuantityShipped,jdbcType=INTEGER}, 
    platform_sku_unit_price = #{platformSkuUnitPrice,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_cancle = #{hasCancle,jdbcType=BIT}, 
    area_id = #{areaId,jdbcType=INTEGER}, 
    gmt_create = #{gmtCreate,jdbcType=TIMESTAMP}, 
    gmt_modified = #{gmtModified,jdbcType=TIMESTAMP}, 
    has_delete = #{hasDelete,jdbcType=BIT}, 
    has_scalp = #{hasScalp,jdbcType=BIT}
  </insert>
  <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPlatformSkuExample" 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_platform_sku
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
</mapper>