| | |
| | | and del_flag = '0' limit 1 |
| | | </select> |
| | | <select id="selectUserBySiteId" resultType="com.ruoyi.system.api.domain.SysUser"> |
| | | select * from sys_user where del_flag = '0' and status = '0' and site_id = #{siteId} |
| | | select u.user_id as userId, u.dept_id as deptId, u.user_name as userName, u.nick_name as nickName, u.email, u.avatar, u.phonenumber, u.password, |
| | | u.sex, u.status, u.del_flag as delFlag, u.login_ip as loginIp, u.login_date as loginDate, u.role_type as roleType, |
| | | u.create_by as createBy, u.create_time as createTime, u.remark from sys_user u where u.del_flag = '0' and u.status = '0' and u.site_id = #{siteId} |
| | | </select> |
| | | |
| | | <insert id="insertUser" parameterType="com.ruoyi.system.api.domain.SysUser" useGeneratedKeys="true" keyProperty="userId"> |
| | |
| | | AND end_time between #{dto.beginTime2 } and #{dto.endTime2 } |
| | | </if> |
| | | <if test="dto.siteId != null"> |
| | | AND site_id = #{dto.siteId} |
| | | AND power_station_id = #{dto.siteId} |
| | | </if> |
| | | order by begin_time DESC |
| | | </select> |