| | |
| | | </if> |
| | | </trim> |
| | | </where> |
| | | |
| | | order by spu.create_time desc |
| | | </select> |
| | | |
| | | <select id="queryForPullDownDorm" resultType="com.thhy.staff.modules.biz.platuser.entity.PlatUserPullDown"> |
| | |
| | | public BasicResult examine(HiddenDangerEntity hiddenDangerEntity) { |
| | | SysUserInfo sysUserInfo = UserInfoUtils.getInstance().getUserInfo(); |
| | | String platUserId = regionInspectionRecordMapper.selectPlatUserId(hiddenDangerEntity.getCreateUser()); |
| | | |
| | | Map platUser = regionInspectionRecordMapper.getPlatUser(platUserId); |
| | | int user_type = (int) platUser.get("user_type"); |
| | | Map account = new HashMap(); |
| | |
| | | private Double changeIntegral;//变量在积分超市 修改前的变量 |
| | | |
| | | |
| | | @Excel(sort = 1,title = "时间") |
| | | private Date createTime; |
| | | @Excel(sort = 1,title = "时间") |
| | | private String createDate; |
| | | @Excel(sort = 2,title = "人员类别") |
| | | private String userTypeName; |
| | | @Excel(sort = 3,title = "人员姓名") |
| | |
| | | SELECT |
| | | t.*, |
| | | spu.real_name realName, |
| | | spu.user_type userTypeName |
| | | FROM t_integral_detail t |
| | | spu.user_type userTypeName, |
| | | DATE_FORMAT(t.createTime, '%Y-%m-%d %H:%m:%s') createDate |
| | | FROM t_integral_detail t |
| | | LEFT JOIN sys_plat_user spu on spu.user_id = t.userId |
| | | WHERE t.isUse = 1 and t.type = 2 and t.companyId = #{companyId} |
| | | <if test="userId != null and userId !=''"> |
| | |
| | | <select id="selectSafeIntegralInfo" resultType="com.thhy.secure.modules.biz.integralAccount.entity.IntegralDetailDto"> |
| | | SELECT |
| | | t.*, |
| | | DATE_FORMAT(t.createTime, '%Y-%m-%d') createDate |
| | | DATE_FORMAT(t.createTime, '%Y-%m-%d %H:%m:%s') createDate |
| | | FROM t_integral_detail t |
| | | WHERE t.isUse = 1 |
| | | <if test="companyId != null and companyId !=''"> |