<?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.cool.store.mapper.PointDetailInfoMapper">
  <resultMap id="BaseResultMap" type="com.cool.store.entity.PointDetailInfoDO">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="point_id" jdbcType="BIGINT" property="pointId" />
    <result column="business_status" jdbcType="TINYINT" property="businessStatus" />
    <result column="nine_flow_rate" jdbcType="INTEGER" property="nineFlowRate" />
    <result column="ten_flow_rate" jdbcType="INTEGER" property="tenFlowRate" />
    <result column="eighteen_flow_rate" jdbcType="INTEGER" property="eighteenFlowRate" />
    <result column="nineteen_flow_rate" jdbcType="INTEGER" property="nineteenFlowRate" />
    <result column="point_direction" jdbcType="TINYINT" property="pointDirection" />
    <result column="site_conditions" jdbcType="TINYINT" property="siteConditions" />
    <result column="store_width" jdbcType="VARCHAR" property="storeWidth" />
    <result column="landlord_username" jdbcType="VARCHAR" property="landlordUsername" />
    <result column="landlord_mobile" jdbcType="VARCHAR" property="landlordMobile" />
    <result column="payment_method" jdbcType="TINYINT" property="paymentMethod" />
    <result column="property_status" jdbcType="TINYINT" property="propertyStatus" />
    <result column="transfer_fee" jdbcType="VARCHAR" property="transferFee" />
    <result column="cover_community" jdbcType="TINYINT" property="coverCommunity" />
    <result column="consumer_ability" jdbcType="TINYINT" property="consumerAbility" />
    <result column="flow_rate_calculate" jdbcType="TINYINT" property="flowRateCalculate" />
    <result column="gather_guest_farmer_market" jdbcType="TINYINT" property="gatherGuestFarmerMarket" />
    <result column="gather_guest_hospital" jdbcType="TINYINT" property="gatherGuestHospital" />
    <result column="gather_guest_school" jdbcType="TINYINT" property="gatherGuestSchool" />
    <result column="store_flow_trend" jdbcType="TINYINT" property="storeFlowTrend" />
    <result column="near_repast" jdbcType="TINYINT" property="nearRepast" />
    <result column="near_neighbor" jdbcType="TINYINT" property="nearNeighbor" />
    <result column="near_compete" jdbcType="TINYINT" property="nearCompete" />
    <result column="near_business_condition" jdbcType="TINYINT" property="nearBusinessCondition" />
    <result column="intend_position" jdbcType="TINYINT" property="intendPosition" />
    <result column="green_belt" jdbcType="TINYINT" property="greenBelt" />
    <result column="store_outlook" jdbcType="TINYINT" property="storeOutlook" />
    <result column="guest_convenience" jdbcType="TINYINT" property="guestConvenience" />
    <result column="want_shop_size" jdbcType="TINYINT" property="wantShopSize" />
    <result column="compete_type" jdbcType="TINYINT" property="competeType" />
    <result column="compete_business_capacity" jdbcType="TINYINT" property="competeBusinessCapacity" />
    <result column="invest_amount" jdbcType="VARCHAR" property="investAmount" />
    <result column="day_trader" jdbcType="VARCHAR" property="dayTrader" />
    <result column="profit_rate" jdbcType="VARCHAR" property="profitRate" />
    <result column="month_profit_rate" jdbcType="VARCHAR" property="monthProfitRate" />
    <result column="brand_use_rate" jdbcType="VARCHAR" property="brandUseRate" />
    <result column="brand_use_fee" jdbcType="VARCHAR" property="brandUseFee" />
    <result column="staff_fee" jdbcType="VARCHAR" property="staffFee" />
    <result column="shop_manager_num" jdbcType="INTEGER" property="shopManagerNum" />
    <result column="shop_manager_fee" jdbcType="INTEGER" property="shopManagerFee" />
    <result column="clerk_num" jdbcType="INTEGER" property="clerkNum" />
    <result column="clerk_fee" jdbcType="INTEGER" property="clerkFee" />
    <result column="bonus" jdbcType="VARCHAR" property="bonus" />
    <result column="month_rent" jdbcType="VARCHAR" property="monthRent" />
    <result column="other_fee" jdbcType="VARCHAR" property="otherFee" />
    <result column="net_profit" jdbcType="VARCHAR" property="netProfit" />
    <result column="month_rate_return" jdbcType="VARCHAR" property="monthRateReturn" />
    <result column="development_manager_sign" jdbcType="VARCHAR" property="developmentManagerSign" />
    <result column="development_manager_sign_time" jdbcType="TIMESTAMP" property="developmentManagerSignTime" />
    <result column="operation_user_sign" jdbcType="VARCHAR" property="operationUserSign" />
    <result column="operation_user_sign_time" jdbcType="TIMESTAMP" property="operationUserSignTime" />
    <result column="line_sign" jdbcType="VARCHAR" property="lineSign" />
    <result column="line_sign_time" jdbcType="TIMESTAMP" property="lineSignTime" />
    <result column="market_size_score" jdbcType="INTEGER" property="marketSizeScore" />
    <result column="shop_area_score" jdbcType="INTEGER" property="shopAreaScore" />
    <result column="convenient_score" jdbcType="INTEGER" property="convenientScore" />
    <result column="environment_score" jdbcType="INTEGER" property="environmentScore" />
    <result column="rent_contract" jdbcType="VARCHAR" property="rentContract" />
    <result column="map_evaluation_report" jdbcType="VARCHAR" property="mapEvaluationReport" />
    <result column="deleted" jdbcType="BIT" property="deleted" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
    <result column="picture_obj" jdbcType="LONGVARCHAR" property="pictureObj" />
  </resultMap>
  <select id="getPointDetailIdByPointId" resultType="java.lang.Long">
    select id from xfsg_point_detail_info where point_id = #{pointId}
  </select>

  <select id="getShopPointDetailInfoByPointId" resultMap="BaseResultMap">
    select * from xfsg_point_detail_info where point_id = #{pointId} and deleted = 0
  </select>

  <update id="updatePartFieldPointDetail">
    update xfsg_point_detail_info
    set
      business_status = #{update.businessStatus},
      nine_flow_rate = #{update.nineFlowRate},
      ten_flow_rate = #{update.tenFlowRate},
      eighteen_flow_rate = #{update.eighteenFlowRate},
      nineteen_flow_rate = #{update.nineteenFlowRate},
      point_direction = #{update.pointDirection},
      site_conditions = #{update.siteConditions},
      store_width = #{update.storeWidth},
      landlord_username = #{update.landlordUsername},
      landlord_mobile = #{update.landlordMobile},
      payment_method = #{update.paymentMethod},
      property_status = #{update.propertyStatus},
      transfer_fee = #{update.transferFee},
      cover_community = #{update.coverCommunity},
      consumer_ability = #{update.consumerAbility},
      flow_rate_calculate = #{update.flowRateCalculate},
      gather_guest_farmer_market = #{update.gatherGuestFarmerMarket},
      gather_guest_hospital = #{update.gatherGuestHospital},
      gather_guest_school = #{update.gatherGuestSchool},
      store_flow_trend = #{update.storeFlowTrend},
      near_repast = #{update.nearRepast},
      near_neighbor = #{update.nearNeighbor},
      near_compete = #{update.nearCompete},
      near_business_condition = #{update.nearBusinessCondition},
      intend_position = #{update.intendPosition},
      green_belt = #{update.greenBelt},
      store_outlook = #{update.storeOutlook},
      guest_convenience = #{update.guestConvenience},
      want_shop_size = #{update.wantShopSize},
      compete_type = #{update.competeType},
      compete_business_capacity = #{update.competeBusinessCapacity},
      invest_amount = #{update.investAmount},
      day_trader = #{update.dayTrader},
      profit_rate = #{update.profitRate},
      month_profit_rate = #{update.monthProfitRate},
      brand_use_rate = #{update.brandUseRate},
      brand_use_fee = #{update.brandUseFee},
      staff_fee = #{update.staffFee},
      bonus = #{update.bonus},
      month_rent = #{update.monthRent},
      other_fee = #{update.otherFee},
      net_profit = #{update.netProfit},
      month_rate_return = #{update.monthRateReturn},
      market_size_score = #{update.marketSizeScore},
      shop_area_score = #{update.shopAreaScore},
      convenient_score = #{update.convenientScore},
      environment_score = #{update.environmentScore},
      rent_contract = #{update.rentContract},
      picture_obj = #{update.pictureObj}
    where id = #{update.id}
  </update>

</mapper>