| | |
| | | //注入创建时间 |
| | | if ("createTime".equals(field.getName())) { |
| | | field.setAccessible(true); |
| | | field.set(parameter, LocalDateTime.now()); |
| | | // field.set(parameter, LocalDateTime.now()); |
| | | field.setAccessible(false); |
| | | } |
| | | } catch (Exception e) { |
| | |
| | | } |
| | | if ("updateTime".equals(field.getName())) { |
| | | field.setAccessible(true); |
| | | field.set(parameter, new Date()); |
| | | // field.set(parameter, new Date()); |
| | | field.setAccessible(false); |
| | | } |
| | | } catch (Exception e) { |
| | |
| | | sol.oper_time AS operTime, sol.cost_time AS costTime,sol.companyName AS companyName,sol.roleName AS roleName,sol.phonenumber AS phonenumber, |
| | | sol.userId AS userId,sol.nickName AS nickName |
| | | from sys_oper_log sol |
| | | <where> |
| | | <if test="query.companyName != null and query.companyName != ''"> |
| | | AND sol.companyName LIKE concat('%',#{query.companyName},'%') |
| | | </if> |
| | | <if test="query.roleName != null and query.roleName != ''"> |
| | | AND sol.roleName LIKE concat('%',#{query.roleName},'%') |
| | | </if> |
| | | <if test="query.nickName != null and query.nickName != ''"> |
| | | AND sol.nickName LIKE concat('%',#{query.nickName},'%') |
| | | </if> |
| | | <if test="query.startTime != null and query.startTime != '' and query.endTime != null and query.endTime != ''"> |
| | | AND DATE_FORMAT(sol.oper_time, '%Y-%m-%d %H:%i:%s') >= #{query.startTime} |
| | | AND DATE_FORMAT(sol.oper_time, '%Y-%m-%d %H:%i:%s') <= #{query.endTime} |
| | | </if> |
| | | </where> |
| | | ORDER BY sol.oper_time DESC |
| | | </select> |
| | | |