随笔

<select id="getSignInRecordList" resultType="HashMap" parameterType="com.lf.platform.core.Example">
    select IFNULL(sir.down_time,'未签退') as down_time,IFNULL(sir.sign_date,'未签到') as sign_date,IFNULL(tci.class_name,'未签到')as class_name,tt.technician_name,  IFNULL(sir.up_time,'未签到')as up_time
    from t_technician_info tt
    left join  (select * from t_sign_in_record sign where sign.sign_date=#{record.signDate}) sir  on sir.technician_id=tt.technician_id
    left join t_class_info tci on sir.class_id=tci.class_id where tt.store=#{record.storeId}

    <include refid="base_order"></include>
</select>