t_login_2021 SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(u.id) as count from t_user u where 1=1 and u.id = #{id} and u.name like concat('%', #{name}, '%') and u.roleCode = #{roleCode} and u.statusCode = #{statusCode} select u.*, m.* from ( select u.*, l.loginChannel, l.loginDate, l.loginTime, l.loginCount from t_user u left join ( select l.*, a.loginCount from l, ( select max(seq) as seq, count(seq) as loginCount from group by id ) a where l.seq = a.seq ) l on u.id = l.id where 1=1 and u.id = #{id} and u.name like concat('%', #{name}, '%') and u.roleCode = #{roleCode} and u.statusCode = #{statusCode} ) u left join ( select m.userId, m.plantSeq , group_concat(m.plantSeq) as plantSeqArray, group_concat(p.name) as plantNameArray from t_user_plant_mapping m, t_plant p where m.plantSeq = p.seq and p.plantStatus = '01' group by m.userId ) m on u.id = m.userId order by u.createDatetime desc select * from t_user where id = #{id} and statusCode = '01' select u.*, l.loginDate, l.loginTime, l.loginCount from t_user u left join ( select l.*, a.loginCount from l, ( select max(seq) as seq, count(seq) as loginCount from group by id ) a where l.seq = a.seq ) l on u.id = l.id where 1=1 and u.id like concat('%', #{id}, '%') and u.name like concat('%', #{name}, '%') and u.roleCode = #{roleCode} and u.statusCode = #{statusCode} order by u.createDatetime desc update t_user set name = #{name}, password = #{password}, statusCode = #{statusCode}, roleCode = #{roleCode}, clientSeq = #{clientSeq}, updateDatetime = now() where id = #{id} insert into t_user ( id, name, password, statusCode, roleCode, clientSeq, createDateTime, updateDatetime ) values ( #{id}, #{name}, #{password}, #{statusCode}, #{roleCode}, #{clientSeq}, now(), now() ) insert into ( id, roleCode, sessionId, loginChannel, loginDate, loginTime, updateTime ) values ( #{id}, #{roleCode}, #{sessionId}, #{loginChannel}, curdate(), curtime(), curtime() ) update set updateTime = curtime() where id = #{id} and sessionId= #{sessionId} SELECT R1.* FROM ( select * from where id = #{id} order by seq desc ) R1 LIMIT 0, 10 select * from t_user where id = #{id} and statusCode = '01' select m.*, p.name as plantName, p.plantStatus from t_user_plant_mapping m, t_plant p where m.plantSeq = p.seq and m.userId=#{id} select m.*, p.name as plantName from t_user_plant_mapping m, t_plant p where m.plantSeq = p.seq and p.plantStatus = '01' and m.userId=#{id} select p.seq as plantSeq, p.name as plantName from t_plant p where p.plantStatus = '01' and p.clientOrderSeq = #{clientOrderSeq}; select p.seq as plantSeq, p.name as plantName from t_plant p left join t_pms m on p.seq = m.plantSeq and p.plantStatus = '01' and m.pmsStatus = '01' order by p.seq desc insert into t_user_plant_mapping ( userId, plantSeq, createUserId, createDatetime ) values ( #{userId}, #{plantSeq}, #{createUserId}, now() ) delete from t_user_plant_mapping where plantSeq = #{plantSeq} and userId=#{userId} and seq > 0