<?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.TOrderProductMapper">
  <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="Id" jdbcType="BIGINT" property="id" />
    <id column="PayTime" jdbcType="TIMESTAMP" property="paytime" />
    <result column="OrderNo" jdbcType="VARCHAR" property="orderno" />
    <result column="PlatformOrderNo" jdbcType="VARCHAR" property="platformorderno" />
    <result column="Platform" jdbcType="VARCHAR" property="platform" />
    <result column="PlatformSite" jdbcType="VARCHAR" property="platformsite" />
    <result column="PlatformSku" jdbcType="VARCHAR" property="platformsku" />
    <result column="ProductCode" jdbcType="VARCHAR" property="productcode" />
    <result column="Title" jdbcType="VARCHAR" property="title" />
    <result column="ProductShipCount" jdbcType="INTEGER" property="productshipcount" />
    <result column="ProductWeight" jdbcType="DECIMAL" property="productweight" />
    <result column="ProductSaleAmount" jdbcType="DECIMAL" property="productsaleamount" />
    <result column="Developer" jdbcType="VARCHAR" property="developer" />
    <result column="Buyer" jdbcType="VARCHAR" property="buyer" />
    <result column="Seller" jdbcType="VARCHAR" property="seller" />
    <result column="PackageFee" jdbcType="DECIMAL" property="packagefee" />
    <result column="CategoryId" jdbcType="INTEGER" property="categoryid" />
    <result column="CategoryName" jdbcType="VARCHAR" property="categoryname" />
    <result column="ParentCategoryName" jdbcType="VARCHAR" property="parentcategoryname" />
    <result column="MainImageUrl" jdbcType="VARCHAR" property="mainimageurl" />
    <result column="SupplierId" jdbcType="INTEGER" property="supplierid" />
    <result column="SupplierName" jdbcType="VARCHAR" property="suppliername" />
    <result column="HeadFreight" jdbcType="DECIMAL" property="headfreight" />
    <result column="Customsfee" jdbcType="DECIMAL" property="customsfee" />
    <result column="ReturnFee" jdbcType="DECIMAL" property="returnfee" />
    <result column="PublishedFee" jdbcType="DECIMAL" property="publishedfee" />
    <result column="AdFee" jdbcType="DECIMAL" property="adfee" />
    <result column="FbaFee" jdbcType="DECIMAL" property="fbafee" />
    <result column="PlatformFee" jdbcType="DECIMAL" property="platformfee" />
    <result column="WarehouseFee" jdbcType="DECIMAL" property="warehousefee" />
    <result column="PaypalFee" jdbcType="DECIMAL" property="paypalfee" />
    <result column="Freight" jdbcType="DECIMAL" property="freight" />
    <result column="BuyPrice" jdbcType="DECIMAL" property="buyprice" />
    <result column="DevelopTime" jdbcType="TIMESTAMP" property="developtime" />
    <result column="ShipTime" jdbcType="TIMESTAMP" property="shiptime" />
    <result column="CreateTime" jdbcType="TIMESTAMP" property="createtime" />
    <result column="UpdateTime" jdbcType="TIMESTAMP" property="updatetime" />
    <result column="OrderTime" jdbcType="TIMESTAMP" property="ordertime" />
    <result column="OrderSaleAmount" jdbcType="DECIMAL" property="ordersaleamount" />
    <result column="OrderSellerCount" jdbcType="INTEGER" property="ordersellercount" />
    <result column="SellerOrderAmount" jdbcType="DECIMAL" property="sellerorderamount" />
    <result column="SellerSkuCount" jdbcType="INTEGER" property="sellerskucount" />
    <result column="ProductCost" jdbcType="DECIMAL" property="productcost" />
    <result column="OrderFreight" jdbcType="DECIMAL" property="orderfreight" />
    <result column="IsSystemShip" jdbcType="INTEGER" property="issystemship" />
    <result column="ItemId" jdbcType="VARCHAR" property="itemid" />
    <result column="SellAccount" jdbcType="VARCHAR" property="sellaccount" />
    <result column="ShipWarehouseCode" jdbcType="VARCHAR" property="shipwarehousecode" />
    <result column="Currency" jdbcType="VARCHAR" property="currency" />
    <result column="OrderStatus" jdbcType="INTEGER" property="orderstatus" />
    <result column="Hid" jdbcType="BIGINT" property="hid" />
    <result column="OriginalCurrency" jdbcType="VARCHAR" property="originalcurrency" />
    <result column="OriginalTotal" jdbcType="DECIMAL" property="originaltotal" />
    <result column="IsRefund" jdbcType="INTEGER" property="isrefund" />
    <result column="BjPayTime" jdbcType="TIMESTAMP" property="bjpaytime" />
    <result column="IsDelete" jdbcType="INTEGER" property="isdelete" />
    <result column="_ts" jdbcType="TIMESTAMP" property="ts" />
    <result column="order_system" jdbcType="VARCHAR" property="orderSystem" />
  </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, PayTime, OrderNo, PlatformOrderNo, Platform, PlatformSite, PlatformSku, ProductCode, 
    Title, ProductShipCount, ProductWeight, ProductSaleAmount, Developer, Buyer, Seller, 
    PackageFee, CategoryId, CategoryName, ParentCategoryName, MainImageUrl, SupplierId, 
    SupplierName, HeadFreight, Customsfee, ReturnFee, PublishedFee, AdFee, FbaFee, PlatformFee, 
    WarehouseFee, PaypalFee, Freight, BuyPrice, DevelopTime, ShipTime, CreateTime, UpdateTime, 
    OrderTime, OrderSaleAmount, OrderSellerCount, SellerOrderAmount, SellerSkuCount, 
    ProductCost, OrderFreight, IsSystemShip, ItemId, SellAccount, ShipWarehouseCode, 
    Currency, OrderStatus, Hid, OriginalCurrency, OriginalTotal, IsRefund, BjPayTime, 
    IsDelete, _ts, order_system
  </sql>
  <select id="selectByExample" parameterType="com.bailuntec.domain.example.TOrderProductExample" 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 t_order_product
    <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="com.bailuntec.domain.entity.TOrderProductKey" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from t_order_product
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="com.bailuntec.domain.entity.TOrderProductKey">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from t_order_product
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </delete>
  <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.TOrderProductExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from t_order_product
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into t_order_product (Id, PayTime, OrderNo, 
      PlatformOrderNo, Platform, PlatformSite, 
      PlatformSku, ProductCode, Title, 
      ProductShipCount, ProductWeight, ProductSaleAmount, 
      Developer, Buyer, Seller, 
      PackageFee, CategoryId, CategoryName, 
      ParentCategoryName, MainImageUrl, SupplierId, 
      SupplierName, HeadFreight, Customsfee, 
      ReturnFee, PublishedFee, AdFee, 
      FbaFee, PlatformFee, WarehouseFee, 
      PaypalFee, Freight, BuyPrice, 
      DevelopTime, ShipTime, CreateTime, 
      UpdateTime, OrderTime, OrderSaleAmount, 
      OrderSellerCount, SellerOrderAmount, SellerSkuCount, 
      ProductCost, OrderFreight, IsSystemShip, 
      ItemId, SellAccount, ShipWarehouseCode, 
      Currency, OrderStatus, Hid, 
      OriginalCurrency, OriginalTotal, IsRefund, 
      BjPayTime, IsDelete, _ts, 
      order_system)
    values (#{id,jdbcType=BIGINT}, #{paytime,jdbcType=TIMESTAMP}, #{orderno,jdbcType=VARCHAR},
      #{platformorderno,jdbcType=VARCHAR}, #{platform,jdbcType=VARCHAR}, #{platformsite,jdbcType=VARCHAR}, 
      #{platformsku,jdbcType=VARCHAR}, #{productcode,jdbcType=VARCHAR}, #{title,jdbcType=VARCHAR}, 
      #{productshipcount,jdbcType=INTEGER}, #{productweight,jdbcType=DECIMAL}, #{productsaleamount,jdbcType=DECIMAL}, 
      #{developer,jdbcType=VARCHAR}, #{buyer,jdbcType=VARCHAR}, #{seller,jdbcType=VARCHAR}, 
      #{packagefee,jdbcType=DECIMAL}, #{categoryid,jdbcType=INTEGER}, #{categoryname,jdbcType=VARCHAR}, 
      #{parentcategoryname,jdbcType=VARCHAR}, #{mainimageurl,jdbcType=VARCHAR}, #{supplierid,jdbcType=INTEGER}, 
      #{suppliername,jdbcType=VARCHAR}, #{headfreight,jdbcType=DECIMAL}, #{customsfee,jdbcType=DECIMAL}, 
      #{returnfee,jdbcType=DECIMAL}, #{publishedfee,jdbcType=DECIMAL}, #{adfee,jdbcType=DECIMAL}, 
      #{fbafee,jdbcType=DECIMAL}, #{platformfee,jdbcType=DECIMAL}, #{warehousefee,jdbcType=DECIMAL}, 
      #{paypalfee,jdbcType=DECIMAL}, #{freight,jdbcType=DECIMAL}, #{buyprice,jdbcType=DECIMAL}, 
      #{developtime,jdbcType=TIMESTAMP}, #{shiptime,jdbcType=TIMESTAMP}, #{createtime,jdbcType=TIMESTAMP},
      #{updatetime,jdbcType=TIMESTAMP}, #{ordertime,jdbcType=TIMESTAMP}, #{ordersaleamount,jdbcType=DECIMAL},
      #{ordersellercount,jdbcType=INTEGER}, #{sellerorderamount,jdbcType=DECIMAL}, #{sellerskucount,jdbcType=INTEGER}, 
      #{productcost,jdbcType=DECIMAL}, #{orderfreight,jdbcType=DECIMAL}, #{issystemship,jdbcType=INTEGER}, 
      #{itemid,jdbcType=VARCHAR}, #{sellaccount,jdbcType=VARCHAR}, #{shipwarehousecode,jdbcType=VARCHAR}, 
      #{currency,jdbcType=VARCHAR}, #{orderstatus,jdbcType=INTEGER}, #{hid,jdbcType=BIGINT}, 
      #{originalcurrency,jdbcType=VARCHAR}, #{originaltotal,jdbcType=DECIMAL}, #{isrefund,jdbcType=INTEGER}, 
      #{bjpaytime,jdbcType=TIMESTAMP}, #{isdelete,jdbcType=INTEGER}, #{ts,jdbcType=TIMESTAMP},
      #{orderSystem,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into t_order_product
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        Id,
      </if>
      <if test="paytime != null">
        PayTime,
      </if>
      <if test="orderno != null">
        OrderNo,
      </if>
      <if test="platformorderno != null">
        PlatformOrderNo,
      </if>
      <if test="platform != null">
        Platform,
      </if>
      <if test="platformsite != null">
        PlatformSite,
      </if>
      <if test="platformsku != null">
        PlatformSku,
      </if>
      <if test="productcode != null">
        ProductCode,
      </if>
      <if test="title != null">
        Title,
      </if>
      <if test="productshipcount != null">
        ProductShipCount,
      </if>
      <if test="productweight != null">
        ProductWeight,
      </if>
      <if test="productsaleamount != null">
        ProductSaleAmount,
      </if>
      <if test="developer != null">
        Developer,
      </if>
      <if test="buyer != null">
        Buyer,
      </if>
      <if test="seller != null">
        Seller,
      </if>
      <if test="packagefee != null">
        PackageFee,
      </if>
      <if test="categoryid != null">
        CategoryId,
      </if>
      <if test="categoryname != null">
        CategoryName,
      </if>
      <if test="parentcategoryname != null">
        ParentCategoryName,
      </if>
      <if test="mainimageurl != null">
        MainImageUrl,
      </if>
      <if test="supplierid != null">
        SupplierId,
      </if>
      <if test="suppliername != null">
        SupplierName,
      </if>
      <if test="headfreight != null">
        HeadFreight,
      </if>
      <if test="customsfee != null">
        Customsfee,
      </if>
      <if test="returnfee != null">
        ReturnFee,
      </if>
      <if test="publishedfee != null">
        PublishedFee,
      </if>
      <if test="adfee != null">
        AdFee,
      </if>
      <if test="fbafee != null">
        FbaFee,
      </if>
      <if test="platformfee != null">
        PlatformFee,
      </if>
      <if test="warehousefee != null">
        WarehouseFee,
      </if>
      <if test="paypalfee != null">
        PaypalFee,
      </if>
      <if test="freight != null">
        Freight,
      </if>
      <if test="buyprice != null">
        BuyPrice,
      </if>
      <if test="developtime != null">
        DevelopTime,
      </if>
      <if test="shiptime != null">
        ShipTime,
      </if>
      <if test="createtime != null">
        CreateTime,
      </if>
      <if test="updatetime != null">
        UpdateTime,
      </if>
      <if test="ordertime != null">
        OrderTime,
      </if>
      <if test="ordersaleamount != null">
        OrderSaleAmount,
      </if>
      <if test="ordersellercount != null">
        OrderSellerCount,
      </if>
      <if test="sellerorderamount != null">
        SellerOrderAmount,
      </if>
      <if test="sellerskucount != null">
        SellerSkuCount,
      </if>
      <if test="productcost != null">
        ProductCost,
      </if>
      <if test="orderfreight != null">
        OrderFreight,
      </if>
      <if test="issystemship != null">
        IsSystemShip,
      </if>
      <if test="itemid != null">
        ItemId,
      </if>
      <if test="sellaccount != null">
        SellAccount,
      </if>
      <if test="shipwarehousecode != null">
        ShipWarehouseCode,
      </if>
      <if test="currency != null">
        Currency,
      </if>
      <if test="orderstatus != null">
        OrderStatus,
      </if>
      <if test="hid != null">
        Hid,
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency,
      </if>
      <if test="originaltotal != null">
        OriginalTotal,
      </if>
      <if test="isrefund != null">
        IsRefund,
      </if>
      <if test="bjpaytime != null">
        BjPayTime,
      </if>
      <if test="isdelete != null">
        IsDelete,
      </if>
      <if test="ts != null">
        _ts,
      </if>
      <if test="orderSystem != null">
        order_system,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="paytime != null">
        #{paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="orderno != null">
        #{orderno,jdbcType=VARCHAR},
      </if>
      <if test="platformorderno != null">
        #{platformorderno,jdbcType=VARCHAR},
      </if>
      <if test="platform != null">
        #{platform,jdbcType=VARCHAR},
      </if>
      <if test="platformsite != null">
        #{platformsite,jdbcType=VARCHAR},
      </if>
      <if test="platformsku != null">
        #{platformsku,jdbcType=VARCHAR},
      </if>
      <if test="productcode != null">
        #{productcode,jdbcType=VARCHAR},
      </if>
      <if test="title != null">
        #{title,jdbcType=VARCHAR},
      </if>
      <if test="productshipcount != null">
        #{productshipcount,jdbcType=INTEGER},
      </if>
      <if test="productweight != null">
        #{productweight,jdbcType=DECIMAL},
      </if>
      <if test="productsaleamount != null">
        #{productsaleamount,jdbcType=DECIMAL},
      </if>
      <if test="developer != null">
        #{developer,jdbcType=VARCHAR},
      </if>
      <if test="buyer != null">
        #{buyer,jdbcType=VARCHAR},
      </if>
      <if test="seller != null">
        #{seller,jdbcType=VARCHAR},
      </if>
      <if test="packagefee != null">
        #{packagefee,jdbcType=DECIMAL},
      </if>
      <if test="categoryid != null">
        #{categoryid,jdbcType=INTEGER},
      </if>
      <if test="categoryname != null">
        #{categoryname,jdbcType=VARCHAR},
      </if>
      <if test="parentcategoryname != null">
        #{parentcategoryname,jdbcType=VARCHAR},
      </if>
      <if test="mainimageurl != null">
        #{mainimageurl,jdbcType=VARCHAR},
      </if>
      <if test="supplierid != null">
        #{supplierid,jdbcType=INTEGER},
      </if>
      <if test="suppliername != null">
        #{suppliername,jdbcType=VARCHAR},
      </if>
      <if test="headfreight != null">
        #{headfreight,jdbcType=DECIMAL},
      </if>
      <if test="customsfee != null">
        #{customsfee,jdbcType=DECIMAL},
      </if>
      <if test="returnfee != null">
        #{returnfee,jdbcType=DECIMAL},
      </if>
      <if test="publishedfee != null">
        #{publishedfee,jdbcType=DECIMAL},
      </if>
      <if test="adfee != null">
        #{adfee,jdbcType=DECIMAL},
      </if>
      <if test="fbafee != null">
        #{fbafee,jdbcType=DECIMAL},
      </if>
      <if test="platformfee != null">
        #{platformfee,jdbcType=DECIMAL},
      </if>
      <if test="warehousefee != null">
        #{warehousefee,jdbcType=DECIMAL},
      </if>
      <if test="paypalfee != null">
        #{paypalfee,jdbcType=DECIMAL},
      </if>
      <if test="freight != null">
        #{freight,jdbcType=DECIMAL},
      </if>
      <if test="buyprice != null">
        #{buyprice,jdbcType=DECIMAL},
      </if>
      <if test="developtime != null">
        #{developtime,jdbcType=TIMESTAMP},
      </if>
      <if test="shiptime != null">
        #{shiptime,jdbcType=TIMESTAMP},
      </if>
      <if test="createtime != null">
        #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordertime != null">
        #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordersaleamount != null">
        #{ordersaleamount,jdbcType=DECIMAL},
      </if>
      <if test="ordersellercount != null">
        #{ordersellercount,jdbcType=INTEGER},
      </if>
      <if test="sellerorderamount != null">
        #{sellerorderamount,jdbcType=DECIMAL},
      </if>
      <if test="sellerskucount != null">
        #{sellerskucount,jdbcType=INTEGER},
      </if>
      <if test="productcost != null">
        #{productcost,jdbcType=DECIMAL},
      </if>
      <if test="orderfreight != null">
        #{orderfreight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="itemid != null">
        #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="shipwarehousecode != null">
        #{shipwarehousecode,jdbcType=VARCHAR},
      </if>
      <if test="currency != null">
        #{currency,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        #{orderstatus,jdbcType=INTEGER},
      </if>
      <if test="hid != null">
        #{hid,jdbcType=BIGINT},
      </if>
      <if test="originalcurrency != null">
        #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="isdelete != null">
        #{isdelete,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="orderSystem != null">
        #{orderSystem,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.bailuntec.domain.example.TOrderProductExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from t_order_product
    <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 t_order_product
    <set>
      <if test="record.id != null">
        Id = #{record.id,jdbcType=BIGINT},
      </if>
      <if test="record.paytime != null">
        PayTime = #{record.paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.orderno != null">
        OrderNo = #{record.orderno,jdbcType=VARCHAR},
      </if>
      <if test="record.platformorderno != null">
        PlatformOrderNo = #{record.platformorderno,jdbcType=VARCHAR},
      </if>
      <if test="record.platform != null">
        Platform = #{record.platform,jdbcType=VARCHAR},
      </if>
      <if test="record.platformsite != null">
        PlatformSite = #{record.platformsite,jdbcType=VARCHAR},
      </if>
      <if test="record.platformsku != null">
        PlatformSku = #{record.platformsku,jdbcType=VARCHAR},
      </if>
      <if test="record.productcode != null">
        ProductCode = #{record.productcode,jdbcType=VARCHAR},
      </if>
      <if test="record.title != null">
        Title = #{record.title,jdbcType=VARCHAR},
      </if>
      <if test="record.productshipcount != null">
        ProductShipCount = #{record.productshipcount,jdbcType=INTEGER},
      </if>
      <if test="record.productweight != null">
        ProductWeight = #{record.productweight,jdbcType=DECIMAL},
      </if>
      <if test="record.productsaleamount != null">
        ProductSaleAmount = #{record.productsaleamount,jdbcType=DECIMAL},
      </if>
      <if test="record.developer != null">
        Developer = #{record.developer,jdbcType=VARCHAR},
      </if>
      <if test="record.buyer != null">
        Buyer = #{record.buyer,jdbcType=VARCHAR},
      </if>
      <if test="record.seller != null">
        Seller = #{record.seller,jdbcType=VARCHAR},
      </if>
      <if test="record.packagefee != null">
        PackageFee = #{record.packagefee,jdbcType=DECIMAL},
      </if>
      <if test="record.categoryid != null">
        CategoryId = #{record.categoryid,jdbcType=INTEGER},
      </if>
      <if test="record.categoryname != null">
        CategoryName = #{record.categoryname,jdbcType=VARCHAR},
      </if>
      <if test="record.parentcategoryname != null">
        ParentCategoryName = #{record.parentcategoryname,jdbcType=VARCHAR},
      </if>
      <if test="record.mainimageurl != null">
        MainImageUrl = #{record.mainimageurl,jdbcType=VARCHAR},
      </if>
      <if test="record.supplierid != null">
        SupplierId = #{record.supplierid,jdbcType=INTEGER},
      </if>
      <if test="record.suppliername != null">
        SupplierName = #{record.suppliername,jdbcType=VARCHAR},
      </if>
      <if test="record.headfreight != null">
        HeadFreight = #{record.headfreight,jdbcType=DECIMAL},
      </if>
      <if test="record.customsfee != null">
        Customsfee = #{record.customsfee,jdbcType=DECIMAL},
      </if>
      <if test="record.returnfee != null">
        ReturnFee = #{record.returnfee,jdbcType=DECIMAL},
      </if>
      <if test="record.publishedfee != null">
        PublishedFee = #{record.publishedfee,jdbcType=DECIMAL},
      </if>
      <if test="record.adfee != null">
        AdFee = #{record.adfee,jdbcType=DECIMAL},
      </if>
      <if test="record.fbafee != null">
        FbaFee = #{record.fbafee,jdbcType=DECIMAL},
      </if>
      <if test="record.platformfee != null">
        PlatformFee = #{record.platformfee,jdbcType=DECIMAL},
      </if>
      <if test="record.warehousefee != null">
        WarehouseFee = #{record.warehousefee,jdbcType=DECIMAL},
      </if>
      <if test="record.paypalfee != null">
        PaypalFee = #{record.paypalfee,jdbcType=DECIMAL},
      </if>
      <if test="record.freight != null">
        Freight = #{record.freight,jdbcType=DECIMAL},
      </if>
      <if test="record.buyprice != null">
        BuyPrice = #{record.buyprice,jdbcType=DECIMAL},
      </if>
      <if test="record.developtime != null">
        DevelopTime = #{record.developtime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.shiptime != null">
        ShipTime = #{record.shiptime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.createtime != null">
        CreateTime = #{record.createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.updatetime != null">
        UpdateTime = #{record.updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.ordertime != null">
        OrderTime = #{record.ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.ordersaleamount != null">
        OrderSaleAmount = #{record.ordersaleamount,jdbcType=DECIMAL},
      </if>
      <if test="record.ordersellercount != null">
        OrderSellerCount = #{record.ordersellercount,jdbcType=INTEGER},
      </if>
      <if test="record.sellerorderamount != null">
        SellerOrderAmount = #{record.sellerorderamount,jdbcType=DECIMAL},
      </if>
      <if test="record.sellerskucount != null">
        SellerSkuCount = #{record.sellerskucount,jdbcType=INTEGER},
      </if>
      <if test="record.productcost != null">
        ProductCost = #{record.productcost,jdbcType=DECIMAL},
      </if>
      <if test="record.orderfreight != null">
        OrderFreight = #{record.orderfreight,jdbcType=DECIMAL},
      </if>
      <if test="record.issystemship != null">
        IsSystemShip = #{record.issystemship,jdbcType=INTEGER},
      </if>
      <if test="record.itemid != null">
        ItemId = #{record.itemid,jdbcType=VARCHAR},
      </if>
      <if test="record.sellaccount != null">
        SellAccount = #{record.sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="record.shipwarehousecode != null">
        ShipWarehouseCode = #{record.shipwarehousecode,jdbcType=VARCHAR},
      </if>
      <if test="record.currency != null">
        Currency = #{record.currency,jdbcType=VARCHAR},
      </if>
      <if test="record.orderstatus != null">
        OrderStatus = #{record.orderstatus,jdbcType=INTEGER},
      </if>
      <if test="record.hid != null">
        Hid = #{record.hid,jdbcType=BIGINT},
      </if>
      <if test="record.originalcurrency != null">
        OriginalCurrency = #{record.originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="record.originaltotal != null">
        OriginalTotal = #{record.originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="record.isrefund != null">
        IsRefund = #{record.isrefund,jdbcType=INTEGER},
      </if>
      <if test="record.bjpaytime != null">
        BjPayTime = #{record.bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.isdelete != null">
        IsDelete = #{record.isdelete,jdbcType=INTEGER},
      </if>
      <if test="record.ts != null">
        _ts = #{record.ts,jdbcType=TIMESTAMP},
      </if>
      <if test="record.orderSystem != null">
        order_system = #{record.orderSystem,jdbcType=VARCHAR},
      </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 t_order_product
    set Id = #{record.id,jdbcType=BIGINT},
      PayTime = #{record.paytime,jdbcType=TIMESTAMP},
      OrderNo = #{record.orderno,jdbcType=VARCHAR},
      PlatformOrderNo = #{record.platformorderno,jdbcType=VARCHAR},
      Platform = #{record.platform,jdbcType=VARCHAR},
      PlatformSite = #{record.platformsite,jdbcType=VARCHAR},
      PlatformSku = #{record.platformsku,jdbcType=VARCHAR},
      ProductCode = #{record.productcode,jdbcType=VARCHAR},
      Title = #{record.title,jdbcType=VARCHAR},
      ProductShipCount = #{record.productshipcount,jdbcType=INTEGER},
      ProductWeight = #{record.productweight,jdbcType=DECIMAL},
      ProductSaleAmount = #{record.productsaleamount,jdbcType=DECIMAL},
      Developer = #{record.developer,jdbcType=VARCHAR},
      Buyer = #{record.buyer,jdbcType=VARCHAR},
      Seller = #{record.seller,jdbcType=VARCHAR},
      PackageFee = #{record.packagefee,jdbcType=DECIMAL},
      CategoryId = #{record.categoryid,jdbcType=INTEGER},
      CategoryName = #{record.categoryname,jdbcType=VARCHAR},
      ParentCategoryName = #{record.parentcategoryname,jdbcType=VARCHAR},
      MainImageUrl = #{record.mainimageurl,jdbcType=VARCHAR},
      SupplierId = #{record.supplierid,jdbcType=INTEGER},
      SupplierName = #{record.suppliername,jdbcType=VARCHAR},
      HeadFreight = #{record.headfreight,jdbcType=DECIMAL},
      Customsfee = #{record.customsfee,jdbcType=DECIMAL},
      ReturnFee = #{record.returnfee,jdbcType=DECIMAL},
      PublishedFee = #{record.publishedfee,jdbcType=DECIMAL},
      AdFee = #{record.adfee,jdbcType=DECIMAL},
      FbaFee = #{record.fbafee,jdbcType=DECIMAL},
      PlatformFee = #{record.platformfee,jdbcType=DECIMAL},
      WarehouseFee = #{record.warehousefee,jdbcType=DECIMAL},
      PaypalFee = #{record.paypalfee,jdbcType=DECIMAL},
      Freight = #{record.freight,jdbcType=DECIMAL},
      BuyPrice = #{record.buyprice,jdbcType=DECIMAL},
      DevelopTime = #{record.developtime,jdbcType=TIMESTAMP},
      ShipTime = #{record.shiptime,jdbcType=TIMESTAMP},
      CreateTime = #{record.createtime,jdbcType=TIMESTAMP},
      UpdateTime = #{record.updatetime,jdbcType=TIMESTAMP},
      OrderTime = #{record.ordertime,jdbcType=TIMESTAMP},
      OrderSaleAmount = #{record.ordersaleamount,jdbcType=DECIMAL},
      OrderSellerCount = #{record.ordersellercount,jdbcType=INTEGER},
      SellerOrderAmount = #{record.sellerorderamount,jdbcType=DECIMAL},
      SellerSkuCount = #{record.sellerskucount,jdbcType=INTEGER},
      ProductCost = #{record.productcost,jdbcType=DECIMAL},
      OrderFreight = #{record.orderfreight,jdbcType=DECIMAL},
      IsSystemShip = #{record.issystemship,jdbcType=INTEGER},
      ItemId = #{record.itemid,jdbcType=VARCHAR},
      SellAccount = #{record.sellaccount,jdbcType=VARCHAR},
      ShipWarehouseCode = #{record.shipwarehousecode,jdbcType=VARCHAR},
      Currency = #{record.currency,jdbcType=VARCHAR},
      OrderStatus = #{record.orderstatus,jdbcType=INTEGER},
      Hid = #{record.hid,jdbcType=BIGINT},
      OriginalCurrency = #{record.originalcurrency,jdbcType=VARCHAR},
      OriginalTotal = #{record.originaltotal,jdbcType=DECIMAL},
      IsRefund = #{record.isrefund,jdbcType=INTEGER},
      BjPayTime = #{record.bjpaytime,jdbcType=TIMESTAMP},
      IsDelete = #{record.isdelete,jdbcType=INTEGER},
      _ts = #{record.ts,jdbcType=TIMESTAMP},
      order_system = #{record.orderSystem,jdbcType=VARCHAR}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update t_order_product
    <set>
      <if test="orderno != null">
        OrderNo = #{orderno,jdbcType=VARCHAR},
      </if>
      <if test="platformorderno != null">
        PlatformOrderNo = #{platformorderno,jdbcType=VARCHAR},
      </if>
      <if test="platform != null">
        Platform = #{platform,jdbcType=VARCHAR},
      </if>
      <if test="platformsite != null">
        PlatformSite = #{platformsite,jdbcType=VARCHAR},
      </if>
      <if test="platformsku != null">
        PlatformSku = #{platformsku,jdbcType=VARCHAR},
      </if>
      <if test="productcode != null">
        ProductCode = #{productcode,jdbcType=VARCHAR},
      </if>
      <if test="title != null">
        Title = #{title,jdbcType=VARCHAR},
      </if>
      <if test="productshipcount != null">
        ProductShipCount = #{productshipcount,jdbcType=INTEGER},
      </if>
      <if test="productweight != null">
        ProductWeight = #{productweight,jdbcType=DECIMAL},
      </if>
      <if test="productsaleamount != null">
        ProductSaleAmount = #{productsaleamount,jdbcType=DECIMAL},
      </if>
      <if test="developer != null">
        Developer = #{developer,jdbcType=VARCHAR},
      </if>
      <if test="buyer != null">
        Buyer = #{buyer,jdbcType=VARCHAR},
      </if>
      <if test="seller != null">
        Seller = #{seller,jdbcType=VARCHAR},
      </if>
      <if test="packagefee != null">
        PackageFee = #{packagefee,jdbcType=DECIMAL},
      </if>
      <if test="categoryid != null">
        CategoryId = #{categoryid,jdbcType=INTEGER},
      </if>
      <if test="categoryname != null">
        CategoryName = #{categoryname,jdbcType=VARCHAR},
      </if>
      <if test="parentcategoryname != null">
        ParentCategoryName = #{parentcategoryname,jdbcType=VARCHAR},
      </if>
      <if test="mainimageurl != null">
        MainImageUrl = #{mainimageurl,jdbcType=VARCHAR},
      </if>
      <if test="supplierid != null">
        SupplierId = #{supplierid,jdbcType=INTEGER},
      </if>
      <if test="suppliername != null">
        SupplierName = #{suppliername,jdbcType=VARCHAR},
      </if>
      <if test="headfreight != null">
        HeadFreight = #{headfreight,jdbcType=DECIMAL},
      </if>
      <if test="customsfee != null">
        Customsfee = #{customsfee,jdbcType=DECIMAL},
      </if>
      <if test="returnfee != null">
        ReturnFee = #{returnfee,jdbcType=DECIMAL},
      </if>
      <if test="publishedfee != null">
        PublishedFee = #{publishedfee,jdbcType=DECIMAL},
      </if>
      <if test="adfee != null">
        AdFee = #{adfee,jdbcType=DECIMAL},
      </if>
      <if test="fbafee != null">
        FbaFee = #{fbafee,jdbcType=DECIMAL},
      </if>
      <if test="platformfee != null">
        PlatformFee = #{platformfee,jdbcType=DECIMAL},
      </if>
      <if test="warehousefee != null">
        WarehouseFee = #{warehousefee,jdbcType=DECIMAL},
      </if>
      <if test="paypalfee != null">
        PaypalFee = #{paypalfee,jdbcType=DECIMAL},
      </if>
      <if test="freight != null">
        Freight = #{freight,jdbcType=DECIMAL},
      </if>
      <if test="buyprice != null">
        BuyPrice = #{buyprice,jdbcType=DECIMAL},
      </if>
      <if test="developtime != null">
        DevelopTime = #{developtime,jdbcType=TIMESTAMP},
      </if>
      <if test="shiptime != null">
        ShipTime = #{shiptime,jdbcType=TIMESTAMP},
      </if>
      <if test="createtime != null">
        CreateTime = #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordertime != null">
        OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordersaleamount != null">
        OrderSaleAmount = #{ordersaleamount,jdbcType=DECIMAL},
      </if>
      <if test="ordersellercount != null">
        OrderSellerCount = #{ordersellercount,jdbcType=INTEGER},
      </if>
      <if test="sellerorderamount != null">
        SellerOrderAmount = #{sellerorderamount,jdbcType=DECIMAL},
      </if>
      <if test="sellerskucount != null">
        SellerSkuCount = #{sellerskucount,jdbcType=INTEGER},
      </if>
      <if test="productcost != null">
        ProductCost = #{productcost,jdbcType=DECIMAL},
      </if>
      <if test="orderfreight != null">
        OrderFreight = #{orderfreight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        IsSystemShip = #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="itemid != null">
        ItemId = #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        SellAccount = #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="shipwarehousecode != null">
        ShipWarehouseCode = #{shipwarehousecode,jdbcType=VARCHAR},
      </if>
      <if test="currency != null">
        Currency = #{currency,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        OrderStatus = #{orderstatus,jdbcType=INTEGER},
      </if>
      <if test="hid != null">
        Hid = #{hid,jdbcType=BIGINT},
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        IsRefund = #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="isdelete != null">
        IsDelete = #{isdelete,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        _ts = #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="orderSystem != null">
        order_system = #{orderSystem,jdbcType=VARCHAR},
      </if>
    </set>
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update t_order_product
    set OrderNo = #{orderno,jdbcType=VARCHAR},
      PlatformOrderNo = #{platformorderno,jdbcType=VARCHAR},
      Platform = #{platform,jdbcType=VARCHAR},
      PlatformSite = #{platformsite,jdbcType=VARCHAR},
      PlatformSku = #{platformsku,jdbcType=VARCHAR},
      ProductCode = #{productcode,jdbcType=VARCHAR},
      Title = #{title,jdbcType=VARCHAR},
      ProductShipCount = #{productshipcount,jdbcType=INTEGER},
      ProductWeight = #{productweight,jdbcType=DECIMAL},
      ProductSaleAmount = #{productsaleamount,jdbcType=DECIMAL},
      Developer = #{developer,jdbcType=VARCHAR},
      Buyer = #{buyer,jdbcType=VARCHAR},
      Seller = #{seller,jdbcType=VARCHAR},
      PackageFee = #{packagefee,jdbcType=DECIMAL},
      CategoryId = #{categoryid,jdbcType=INTEGER},
      CategoryName = #{categoryname,jdbcType=VARCHAR},
      ParentCategoryName = #{parentcategoryname,jdbcType=VARCHAR},
      MainImageUrl = #{mainimageurl,jdbcType=VARCHAR},
      SupplierId = #{supplierid,jdbcType=INTEGER},
      SupplierName = #{suppliername,jdbcType=VARCHAR},
      HeadFreight = #{headfreight,jdbcType=DECIMAL},
      Customsfee = #{customsfee,jdbcType=DECIMAL},
      ReturnFee = #{returnfee,jdbcType=DECIMAL},
      PublishedFee = #{publishedfee,jdbcType=DECIMAL},
      AdFee = #{adfee,jdbcType=DECIMAL},
      FbaFee = #{fbafee,jdbcType=DECIMAL},
      PlatformFee = #{platformfee,jdbcType=DECIMAL},
      WarehouseFee = #{warehousefee,jdbcType=DECIMAL},
      PaypalFee = #{paypalfee,jdbcType=DECIMAL},
      Freight = #{freight,jdbcType=DECIMAL},
      BuyPrice = #{buyprice,jdbcType=DECIMAL},
      DevelopTime = #{developtime,jdbcType=TIMESTAMP},
      ShipTime = #{shiptime,jdbcType=TIMESTAMP},
      CreateTime = #{createtime,jdbcType=TIMESTAMP},
      UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      OrderSaleAmount = #{ordersaleamount,jdbcType=DECIMAL},
      OrderSellerCount = #{ordersellercount,jdbcType=INTEGER},
      SellerOrderAmount = #{sellerorderamount,jdbcType=DECIMAL},
      SellerSkuCount = #{sellerskucount,jdbcType=INTEGER},
      ProductCost = #{productcost,jdbcType=DECIMAL},
      OrderFreight = #{orderfreight,jdbcType=DECIMAL},
      IsSystemShip = #{issystemship,jdbcType=INTEGER},
      ItemId = #{itemid,jdbcType=VARCHAR},
      SellAccount = #{sellaccount,jdbcType=VARCHAR},
      ShipWarehouseCode = #{shipwarehousecode,jdbcType=VARCHAR},
      Currency = #{currency,jdbcType=VARCHAR},
      OrderStatus = #{orderstatus,jdbcType=INTEGER},
      Hid = #{hid,jdbcType=BIGINT},
      OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      IsRefund = #{isrefund,jdbcType=INTEGER},
      BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      IsDelete = #{isdelete,jdbcType=INTEGER},
      _ts = #{ts,jdbcType=TIMESTAMP},
      order_system = #{orderSystem,jdbcType=VARCHAR}
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </update>
  <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into t_order_product
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        Id,
      </if>
      <if test="paytime != null">
        PayTime,
      </if>
      <if test="orderno != null">
        OrderNo,
      </if>
      <if test="platformorderno != null">
        PlatformOrderNo,
      </if>
      <if test="platform != null">
        Platform,
      </if>
      <if test="platformsite != null">
        PlatformSite,
      </if>
      <if test="platformsku != null">
        PlatformSku,
      </if>
      <if test="productcode != null">
        ProductCode,
      </if>
      <if test="title != null">
        Title,
      </if>
      <if test="productshipcount != null">
        ProductShipCount,
      </if>
      <if test="productweight != null">
        ProductWeight,
      </if>
      <if test="productsaleamount != null">
        ProductSaleAmount,
      </if>
      <if test="developer != null">
        Developer,
      </if>
      <if test="buyer != null">
        Buyer,
      </if>
      <if test="seller != null">
        Seller,
      </if>
      <if test="packagefee != null">
        PackageFee,
      </if>
      <if test="categoryid != null">
        CategoryId,
      </if>
      <if test="categoryname != null">
        CategoryName,
      </if>
      <if test="parentcategoryname != null">
        ParentCategoryName,
      </if>
      <if test="mainimageurl != null">
        MainImageUrl,
      </if>
      <if test="supplierid != null">
        SupplierId,
      </if>
      <if test="suppliername != null">
        SupplierName,
      </if>
      <if test="headfreight != null">
        HeadFreight,
      </if>
      <if test="customsfee != null">
        Customsfee,
      </if>
      <if test="returnfee != null">
        ReturnFee,
      </if>
      <if test="publishedfee != null">
        PublishedFee,
      </if>
      <if test="adfee != null">
        AdFee,
      </if>
      <if test="fbafee != null">
        FbaFee,
      </if>
      <if test="platformfee != null">
        PlatformFee,
      </if>
      <if test="warehousefee != null">
        WarehouseFee,
      </if>
      <if test="paypalfee != null">
        PaypalFee,
      </if>
      <if test="freight != null">
        Freight,
      </if>
      <if test="buyprice != null">
        BuyPrice,
      </if>
      <if test="developtime != null">
        DevelopTime,
      </if>
      <if test="shiptime != null">
        ShipTime,
      </if>
      <if test="createtime != null">
        CreateTime,
      </if>
      <if test="updatetime != null">
        UpdateTime,
      </if>
      <if test="ordertime != null">
        OrderTime,
      </if>
      <if test="ordersaleamount != null">
        OrderSaleAmount,
      </if>
      <if test="ordersellercount != null">
        OrderSellerCount,
      </if>
      <if test="sellerorderamount != null">
        SellerOrderAmount,
      </if>
      <if test="sellerskucount != null">
        SellerSkuCount,
      </if>
      <if test="productcost != null">
        ProductCost,
      </if>
      <if test="orderfreight != null">
        OrderFreight,
      </if>
      <if test="issystemship != null">
        IsSystemShip,
      </if>
      <if test="itemid != null">
        ItemId,
      </if>
      <if test="sellaccount != null">
        SellAccount,
      </if>
      <if test="shipwarehousecode != null">
        ShipWarehouseCode,
      </if>
      <if test="currency != null">
        Currency,
      </if>
      <if test="orderstatus != null">
        OrderStatus,
      </if>
      <if test="hid != null">
        Hid,
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency,
      </if>
      <if test="originaltotal != null">
        OriginalTotal,
      </if>
      <if test="isrefund != null">
        IsRefund,
      </if>
      <if test="bjpaytime != null">
        BjPayTime,
      </if>
      <if test="isdelete != null">
        IsDelete,
      </if>
      <if test="ts != null">
        _ts,
      </if>
      <if test="orderSystem != null">
        order_system,
      </if>
    </trim>
    values
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="paytime != null">
        #{paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="orderno != null">
        #{orderno,jdbcType=VARCHAR},
      </if>
      <if test="platformorderno != null">
        #{platformorderno,jdbcType=VARCHAR},
      </if>
      <if test="platform != null">
        #{platform,jdbcType=VARCHAR},
      </if>
      <if test="platformsite != null">
        #{platformsite,jdbcType=VARCHAR},
      </if>
      <if test="platformsku != null">
        #{platformsku,jdbcType=VARCHAR},
      </if>
      <if test="productcode != null">
        #{productcode,jdbcType=VARCHAR},
      </if>
      <if test="title != null">
        #{title,jdbcType=VARCHAR},
      </if>
      <if test="productshipcount != null">
        #{productshipcount,jdbcType=INTEGER},
      </if>
      <if test="productweight != null">
        #{productweight,jdbcType=DECIMAL},
      </if>
      <if test="productsaleamount != null">
        #{productsaleamount,jdbcType=DECIMAL},
      </if>
      <if test="developer != null">
        #{developer,jdbcType=VARCHAR},
      </if>
      <if test="buyer != null">
        #{buyer,jdbcType=VARCHAR},
      </if>
      <if test="seller != null">
        #{seller,jdbcType=VARCHAR},
      </if>
      <if test="packagefee != null">
        #{packagefee,jdbcType=DECIMAL},
      </if>
      <if test="categoryid != null">
        #{categoryid,jdbcType=INTEGER},
      </if>
      <if test="categoryname != null">
        #{categoryname,jdbcType=VARCHAR},
      </if>
      <if test="parentcategoryname != null">
        #{parentcategoryname,jdbcType=VARCHAR},
      </if>
      <if test="mainimageurl != null">
        #{mainimageurl,jdbcType=VARCHAR},
      </if>
      <if test="supplierid != null">
        #{supplierid,jdbcType=INTEGER},
      </if>
      <if test="suppliername != null">
        #{suppliername,jdbcType=VARCHAR},
      </if>
      <if test="headfreight != null">
        #{headfreight,jdbcType=DECIMAL},
      </if>
      <if test="customsfee != null">
        #{customsfee,jdbcType=DECIMAL},
      </if>
      <if test="returnfee != null">
        #{returnfee,jdbcType=DECIMAL},
      </if>
      <if test="publishedfee != null">
        #{publishedfee,jdbcType=DECIMAL},
      </if>
      <if test="adfee != null">
        #{adfee,jdbcType=DECIMAL},
      </if>
      <if test="fbafee != null">
        #{fbafee,jdbcType=DECIMAL},
      </if>
      <if test="platformfee != null">
        #{platformfee,jdbcType=DECIMAL},
      </if>
      <if test="warehousefee != null">
        #{warehousefee,jdbcType=DECIMAL},
      </if>
      <if test="paypalfee != null">
        #{paypalfee,jdbcType=DECIMAL},
      </if>
      <if test="freight != null">
        #{freight,jdbcType=DECIMAL},
      </if>
      <if test="buyprice != null">
        #{buyprice,jdbcType=DECIMAL},
      </if>
      <if test="developtime != null">
        #{developtime,jdbcType=TIMESTAMP},
      </if>
      <if test="shiptime != null">
        #{shiptime,jdbcType=TIMESTAMP},
      </if>
      <if test="createtime != null">
        #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordertime != null">
        #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordersaleamount != null">
        #{ordersaleamount,jdbcType=DECIMAL},
      </if>
      <if test="ordersellercount != null">
        #{ordersellercount,jdbcType=INTEGER},
      </if>
      <if test="sellerorderamount != null">
        #{sellerorderamount,jdbcType=DECIMAL},
      </if>
      <if test="sellerskucount != null">
        #{sellerskucount,jdbcType=INTEGER},
      </if>
      <if test="productcost != null">
        #{productcost,jdbcType=DECIMAL},
      </if>
      <if test="orderfreight != null">
        #{orderfreight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="itemid != null">
        #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="shipwarehousecode != null">
        #{shipwarehousecode,jdbcType=VARCHAR},
      </if>
      <if test="currency != null">
        #{currency,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        #{orderstatus,jdbcType=INTEGER},
      </if>
      <if test="hid != null">
        #{hid,jdbcType=BIGINT},
      </if>
      <if test="originalcurrency != null">
        #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="isdelete != null">
        #{isdelete,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="orderSystem != null">
        #{orderSystem,jdbcType=VARCHAR},
      </if>
    </trim>
    on duplicate key update 
    <trim suffixOverrides=",">
      <if test="id != null">
        Id = #{id,jdbcType=BIGINT},
      </if>
      <if test="paytime != null">
        PayTime = #{paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="orderno != null">
        OrderNo = #{orderno,jdbcType=VARCHAR},
      </if>
      <if test="platformorderno != null">
        PlatformOrderNo = #{platformorderno,jdbcType=VARCHAR},
      </if>
      <if test="platform != null">
        Platform = #{platform,jdbcType=VARCHAR},
      </if>
      <if test="platformsite != null">
        PlatformSite = #{platformsite,jdbcType=VARCHAR},
      </if>
      <if test="platformsku != null">
        PlatformSku = #{platformsku,jdbcType=VARCHAR},
      </if>
      <if test="productcode != null">
        ProductCode = #{productcode,jdbcType=VARCHAR},
      </if>
      <if test="title != null">
        Title = #{title,jdbcType=VARCHAR},
      </if>
      <if test="productshipcount != null">
        ProductShipCount = #{productshipcount,jdbcType=INTEGER},
      </if>
      <if test="productweight != null">
        ProductWeight = #{productweight,jdbcType=DECIMAL},
      </if>
      <if test="productsaleamount != null">
        ProductSaleAmount = #{productsaleamount,jdbcType=DECIMAL},
      </if>
      <if test="developer != null">
        Developer = #{developer,jdbcType=VARCHAR},
      </if>
      <if test="buyer != null">
        Buyer = #{buyer,jdbcType=VARCHAR},
      </if>
      <if test="seller != null">
        Seller = #{seller,jdbcType=VARCHAR},
      </if>
      <if test="packagefee != null">
        PackageFee = #{packagefee,jdbcType=DECIMAL},
      </if>
      <if test="categoryid != null">
        CategoryId = #{categoryid,jdbcType=INTEGER},
      </if>
      <if test="categoryname != null">
        CategoryName = #{categoryname,jdbcType=VARCHAR},
      </if>
      <if test="parentcategoryname != null">
        ParentCategoryName = #{parentcategoryname,jdbcType=VARCHAR},
      </if>
      <if test="mainimageurl != null">
        MainImageUrl = #{mainimageurl,jdbcType=VARCHAR},
      </if>
      <if test="supplierid != null">
        SupplierId = #{supplierid,jdbcType=INTEGER},
      </if>
      <if test="suppliername != null">
        SupplierName = #{suppliername,jdbcType=VARCHAR},
      </if>
      <if test="headfreight != null">
        HeadFreight = #{headfreight,jdbcType=DECIMAL},
      </if>
      <if test="customsfee != null">
        Customsfee = #{customsfee,jdbcType=DECIMAL},
      </if>
      <if test="returnfee != null">
        ReturnFee = #{returnfee,jdbcType=DECIMAL},
      </if>
      <if test="publishedfee != null">
        PublishedFee = #{publishedfee,jdbcType=DECIMAL},
      </if>
      <if test="adfee != null">
        AdFee = #{adfee,jdbcType=DECIMAL},
      </if>
      <if test="fbafee != null">
        FbaFee = #{fbafee,jdbcType=DECIMAL},
      </if>
      <if test="platformfee != null">
        PlatformFee = #{platformfee,jdbcType=DECIMAL},
      </if>
      <if test="warehousefee != null">
        WarehouseFee = #{warehousefee,jdbcType=DECIMAL},
      </if>
      <if test="paypalfee != null">
        PaypalFee = #{paypalfee,jdbcType=DECIMAL},
      </if>
      <if test="freight != null">
        Freight = #{freight,jdbcType=DECIMAL},
      </if>
      <if test="buyprice != null">
        BuyPrice = #{buyprice,jdbcType=DECIMAL},
      </if>
      <if test="developtime != null">
        DevelopTime = #{developtime,jdbcType=TIMESTAMP},
      </if>
      <if test="shiptime != null">
        ShipTime = #{shiptime,jdbcType=TIMESTAMP},
      </if>
      <if test="createtime != null">
        CreateTime = #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordertime != null">
        OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordersaleamount != null">
        OrderSaleAmount = #{ordersaleamount,jdbcType=DECIMAL},
      </if>
      <if test="ordersellercount != null">
        OrderSellerCount = #{ordersellercount,jdbcType=INTEGER},
      </if>
      <if test="sellerorderamount != null">
        SellerOrderAmount = #{sellerorderamount,jdbcType=DECIMAL},
      </if>
      <if test="sellerskucount != null">
        SellerSkuCount = #{sellerskucount,jdbcType=INTEGER},
      </if>
      <if test="productcost != null">
        ProductCost = #{productcost,jdbcType=DECIMAL},
      </if>
      <if test="orderfreight != null">
        OrderFreight = #{orderfreight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        IsSystemShip = #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="itemid != null">
        ItemId = #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        SellAccount = #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="shipwarehousecode != null">
        ShipWarehouseCode = #{shipwarehousecode,jdbcType=VARCHAR},
      </if>
      <if test="currency != null">
        Currency = #{currency,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        OrderStatus = #{orderstatus,jdbcType=INTEGER},
      </if>
      <if test="hid != null">
        Hid = #{hid,jdbcType=BIGINT},
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        IsRefund = #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="isdelete != null">
        IsDelete = #{isdelete,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        _ts = #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="orderSystem != null">
        order_system = #{orderSystem,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <insert id="upsert" parameterType="com.bailuntec.domain.entity.TOrderProduct">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into t_order_product
    (Id, PayTime, OrderNo, PlatformOrderNo, Platform, PlatformSite, PlatformSku, ProductCode, 
      Title, ProductShipCount, ProductWeight, ProductSaleAmount, Developer, Buyer, Seller, 
      PackageFee, CategoryId, CategoryName, ParentCategoryName, MainImageUrl, SupplierId, 
      SupplierName, HeadFreight, Customsfee, ReturnFee, PublishedFee, AdFee, FbaFee, 
      PlatformFee, WarehouseFee, PaypalFee, Freight, BuyPrice, DevelopTime, ShipTime, 
      CreateTime, UpdateTime, OrderTime, OrderSaleAmount, OrderSellerCount, SellerOrderAmount, 
      SellerSkuCount, ProductCost, OrderFreight, IsSystemShip, ItemId, SellAccount, ShipWarehouseCode, 
      Currency, OrderStatus, Hid, OriginalCurrency, OriginalTotal, IsRefund, BjPayTime, 
      IsDelete, _ts, order_system)
    values
    (#{id,jdbcType=BIGINT}, #{paytime,jdbcType=TIMESTAMP}, #{orderno,jdbcType=VARCHAR},
      #{platformorderno,jdbcType=VARCHAR}, #{platform,jdbcType=VARCHAR}, #{platformsite,jdbcType=VARCHAR}, 
      #{platformsku,jdbcType=VARCHAR}, #{productcode,jdbcType=VARCHAR}, #{title,jdbcType=VARCHAR}, 
      #{productshipcount,jdbcType=INTEGER}, #{productweight,jdbcType=DECIMAL}, #{productsaleamount,jdbcType=DECIMAL}, 
      #{developer,jdbcType=VARCHAR}, #{buyer,jdbcType=VARCHAR}, #{seller,jdbcType=VARCHAR}, 
      #{packagefee,jdbcType=DECIMAL}, #{categoryid,jdbcType=INTEGER}, #{categoryname,jdbcType=VARCHAR}, 
      #{parentcategoryname,jdbcType=VARCHAR}, #{mainimageurl,jdbcType=VARCHAR}, #{supplierid,jdbcType=INTEGER}, 
      #{suppliername,jdbcType=VARCHAR}, #{headfreight,jdbcType=DECIMAL}, #{customsfee,jdbcType=DECIMAL}, 
      #{returnfee,jdbcType=DECIMAL}, #{publishedfee,jdbcType=DECIMAL}, #{adfee,jdbcType=DECIMAL}, 
      #{fbafee,jdbcType=DECIMAL}, #{platformfee,jdbcType=DECIMAL}, #{warehousefee,jdbcType=DECIMAL}, 
      #{paypalfee,jdbcType=DECIMAL}, #{freight,jdbcType=DECIMAL}, #{buyprice,jdbcType=DECIMAL}, 
      #{developtime,jdbcType=TIMESTAMP}, #{shiptime,jdbcType=TIMESTAMP}, #{createtime,jdbcType=TIMESTAMP},
      #{updatetime,jdbcType=TIMESTAMP}, #{ordertime,jdbcType=TIMESTAMP}, #{ordersaleamount,jdbcType=DECIMAL},
      #{ordersellercount,jdbcType=INTEGER}, #{sellerorderamount,jdbcType=DECIMAL}, #{sellerskucount,jdbcType=INTEGER}, 
      #{productcost,jdbcType=DECIMAL}, #{orderfreight,jdbcType=DECIMAL}, #{issystemship,jdbcType=INTEGER}, 
      #{itemid,jdbcType=VARCHAR}, #{sellaccount,jdbcType=VARCHAR}, #{shipwarehousecode,jdbcType=VARCHAR}, 
      #{currency,jdbcType=VARCHAR}, #{orderstatus,jdbcType=INTEGER}, #{hid,jdbcType=BIGINT}, 
      #{originalcurrency,jdbcType=VARCHAR}, #{originaltotal,jdbcType=DECIMAL}, #{isrefund,jdbcType=INTEGER}, 
      #{bjpaytime,jdbcType=TIMESTAMP}, #{isdelete,jdbcType=INTEGER}, #{ts,jdbcType=TIMESTAMP},
      #{orderSystem,jdbcType=VARCHAR})
    on duplicate key update 
    Id = #{id,jdbcType=BIGINT}, 
    PayTime = #{paytime,jdbcType=TIMESTAMP},
    OrderNo = #{orderno,jdbcType=VARCHAR}, 
    PlatformOrderNo = #{platformorderno,jdbcType=VARCHAR}, 
    Platform = #{platform,jdbcType=VARCHAR}, 
    PlatformSite = #{platformsite,jdbcType=VARCHAR}, 
    PlatformSku = #{platformsku,jdbcType=VARCHAR}, 
    ProductCode = #{productcode,jdbcType=VARCHAR}, 
    Title = #{title,jdbcType=VARCHAR}, 
    ProductShipCount = #{productshipcount,jdbcType=INTEGER}, 
    ProductWeight = #{productweight,jdbcType=DECIMAL}, 
    ProductSaleAmount = #{productsaleamount,jdbcType=DECIMAL}, 
    Developer = #{developer,jdbcType=VARCHAR}, 
    Buyer = #{buyer,jdbcType=VARCHAR}, 
    Seller = #{seller,jdbcType=VARCHAR}, 
    PackageFee = #{packagefee,jdbcType=DECIMAL}, 
    CategoryId = #{categoryid,jdbcType=INTEGER}, 
    CategoryName = #{categoryname,jdbcType=VARCHAR}, 
    ParentCategoryName = #{parentcategoryname,jdbcType=VARCHAR}, 
    MainImageUrl = #{mainimageurl,jdbcType=VARCHAR}, 
    SupplierId = #{supplierid,jdbcType=INTEGER}, 
    SupplierName = #{suppliername,jdbcType=VARCHAR}, 
    HeadFreight = #{headfreight,jdbcType=DECIMAL}, 
    Customsfee = #{customsfee,jdbcType=DECIMAL}, 
    ReturnFee = #{returnfee,jdbcType=DECIMAL}, 
    PublishedFee = #{publishedfee,jdbcType=DECIMAL}, 
    AdFee = #{adfee,jdbcType=DECIMAL}, 
    FbaFee = #{fbafee,jdbcType=DECIMAL}, 
    PlatformFee = #{platformfee,jdbcType=DECIMAL}, 
    WarehouseFee = #{warehousefee,jdbcType=DECIMAL}, 
    PaypalFee = #{paypalfee,jdbcType=DECIMAL}, 
    Freight = #{freight,jdbcType=DECIMAL}, 
    BuyPrice = #{buyprice,jdbcType=DECIMAL}, 
    DevelopTime = #{developtime,jdbcType=TIMESTAMP},
    ShipTime = #{shiptime,jdbcType=TIMESTAMP},
    CreateTime = #{createtime,jdbcType=TIMESTAMP},
    UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
    OrderTime = #{ordertime,jdbcType=TIMESTAMP},
    OrderSaleAmount = #{ordersaleamount,jdbcType=DECIMAL}, 
    OrderSellerCount = #{ordersellercount,jdbcType=INTEGER}, 
    SellerOrderAmount = #{sellerorderamount,jdbcType=DECIMAL}, 
    SellerSkuCount = #{sellerskucount,jdbcType=INTEGER}, 
    ProductCost = #{productcost,jdbcType=DECIMAL}, 
    OrderFreight = #{orderfreight,jdbcType=DECIMAL}, 
    IsSystemShip = #{issystemship,jdbcType=INTEGER}, 
    ItemId = #{itemid,jdbcType=VARCHAR}, 
    SellAccount = #{sellaccount,jdbcType=VARCHAR}, 
    ShipWarehouseCode = #{shipwarehousecode,jdbcType=VARCHAR}, 
    Currency = #{currency,jdbcType=VARCHAR}, 
    OrderStatus = #{orderstatus,jdbcType=INTEGER}, 
    Hid = #{hid,jdbcType=BIGINT}, 
    OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR}, 
    OriginalTotal = #{originaltotal,jdbcType=DECIMAL}, 
    IsRefund = #{isrefund,jdbcType=INTEGER}, 
    BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
    IsDelete = #{isdelete,jdbcType=INTEGER}, 
    _ts = #{ts,jdbcType=TIMESTAMP},
    order_system = #{orderSystem,jdbcType=VARCHAR}
  </insert>
  <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.TOrderProductExample" 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 t_order_product
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
</mapper>