<?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.sckw.manage.dao.KwmLineCostTankerMapper">

    <resultMap id="BaseResultMap" type="com.sckw.manage.model.entity.KwmLineCostTanker">
            <id property="id" column="id" jdbcType="BIGINT"/>
            <result property="loadAddress" column="load_address" jdbcType="VARCHAR"/>
            <result property="loadLat" column="load_lat" jdbcType="VARCHAR"/>
            <result property="loadLng" column="load_lng" jdbcType="VARCHAR"/>
            <result property="unloadAddress" column="unload_address" jdbcType="VARCHAR"/>
            <result property="unloadLat" column="unload_lat" jdbcType="VARCHAR"/>
            <result property="unloadLng" column="unload_lng" jdbcType="VARCHAR"/>
            <result property="transportTime" column="transport_time" jdbcType="INTEGER"/>
            <result property="transportMileage" column="transport_mileage" jdbcType="DECIMAL"/>
            <result property="transportCost" column="transport_cost" jdbcType="DECIMAL"/>
            <result property="consume" column="consume" jdbcType="DECIMAL"/>
            <result property="price" column="price" jdbcType="DECIMAL"/>
            <result property="consumeTotal" column="consume_total" jdbcType="DECIMAL"/>
            <result property="roadBridgeFees" column="road_bridge_fees" jdbcType="DECIMAL"/>
            <result property="driverWages" column="driver_wages" jdbcType="DECIMAL"/>
            <result property="parkingFee" column="parking_fee" jdbcType="DECIMAL"/>
            <result property="other" column="other" jdbcType="DECIMAL"/>
            <result property="changeCost" column="change_cost" jdbcType="DECIMAL"/>
            <result property="depreciationShare" column="depreciation_share" jdbcType="DECIMAL"/>
            <result property="insureShare" column="insure_share" jdbcType="DECIMAL"/>
            <result property="maintenanceShare" column="maintenance_share" jdbcType="DECIMAL"/>
            <result property="tireShare" column="tire_share" jdbcType="DECIMAL"/>
            <result property="weighingFee" column="weighing_fee" jdbcType="DECIMAL"/>
            <result property="managementFees" column="management_fees" jdbcType="DECIMAL"/>
            <result property="wagesShare" column="wages_share" jdbcType="DECIMAL"/>
            <result property="regularCost" column="regular_cost" jdbcType="DECIMAL"/>
            <result property="remark" column="remark" jdbcType="VARCHAR"/>
            <result property="status" column="status" jdbcType="INTEGER"/>
            <result property="createBy" column="create_by" jdbcType="BIGINT"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="updateBy" column="update_by" jdbcType="BIGINT"/>
            <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
            <result property="delFlag" column="del_flag" jdbcType="INTEGER"/>
    </resultMap>

    <sql id="Base_Column_List">
        id,load_address,load_lat,
        load_lng,unload_address,unload_lat,
        unload_lng,transport_time,transport_mileage,
        transport_cost,consume,price,
        consume_total,road_bridge_fees,driver_wages,
        parking_fee,other,change_cost,
        depreciation_share,insure_share,maintenance_share,
        tire_share,weighing_fee,management_fees,
        wages_share,regular_cost,remark,
        status,create_by,create_time,
        update_by,update_time,del_flag
    </sql>
</mapper>
