<?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.bonus.sharedstation.app.mapper.BaseMapper">

    <sql id="userSql">
        id as `id`,
        user_id as `userId`,
        login_name as `loginName`,
        real_name as `realName`,
        mobile as `mobile`,
        email as `email`,
        unicode as `unicode`,
        department_id as `departmentId`,
        department_name as `departmentName`,
        owner_location as `ownerLocation`,
        org_id as `orgId`,
        org_name as `orgName`,
        title as `title`,
        user_status as `userStatus`,
        start_useful_life as `startUsefulLife`,
        end_useful_life as `endUsefulLife`,
        birthday as `birthday`,
        id_card as `idCard`,
        meal_status as `mealStatus`,
        meal_no as `mealNo`,
        compony as `compony`,
        remark as `remark`,
        creator as `creator`,
        modifier as `modifier`,
        gmt_created as `gmtCreated`,
        gmt_modified as `gmtModified`,
        is_deleted as `isDeleted`,
        office as `office`,
        baseorg_id as `baseorgId`,
        baseorg_path as `baseorgPath`,
        employee_no as `employeeNo`,
        meal_card_type as `mealCardType`,
        meal_card_operation as `mealCardOperation`,
        peration_date as `perationDate`,
        validity_period as `validityPeriod`,
        car_number as `carNumber`,
        gender as `gender`,
        landline as `landline`,
        live_addr as `liveAddr`,
        duties_id as `dutiesId`,
        tenant_id as `tenantId`
    </sql>


    <select id="getUserInfo" resultType="com.bonus.sharedstation.app.domain.GreenUserInfo">
        SELECT
        <include refid="userSql"></include>
        FROM GREEN_USER_INFO WHERE user_id = #{id}
    </select>

</mapper>