| | |
| | | // 类型匹配 todo |
| | | if (goodQuery.getType() != null && goodQuery.getType().size() > 0) { |
| | | for (int i = 0; i < goodQuery.getType().size(); i++) { |
| | | if (i == 0){ |
| | | wrapper.apply("FIND_IN_SET('" + goodQuery.getType().get(i) + "', typeIds)"); // 将每个类型 ID 应用于 FIND_IN_SET 函数 |
| | | }else{ |
| | | // if (i == 0){ |
| | | // wrapper.apply("FIND_IN_SET('" + goodQuery.getType().get(i) + "', typeIds)"); // 将每个类型 ID 应用于 FIND_IN_SET 函数 |
| | | // }else{ |
| | | wrapper.or().apply("FIND_IN_SET('" + goodQuery.getType().get(i) + "', typeIds)"); // 将每个类型 ID 应用于 FIND_IN_SET 函数 |
| | | } |
| | | // } |
| | | } |
| | | } |
| | | wrapper.eq("isDelete", 0); |
| | |
| | | basicCount = #{req.basicCount}, |
| | | userCount = #{req.userCount}, |
| | | </set> |
| | | and id = #{req.id} |
| | | where id = #{req.id} |
| | | </update> |
| | | |
| | | <select id="goodRecommend" resultType="com.ruoyi.goods.vo.TGoodsVO"> |
| | |
| | | return AjaxResult.error("新密码不能与旧密码相同"); |
| | | } |
| | | one.setPassword(SecurityUtils.encryptPassword(password)); |
| | | sysUserService.updateById(one); |
| | | return AjaxResult.success(); |
| | | } |
| | | @GetMapping("/sendPhoneCode") |
| | |
| | | TVipOrder tVipOrder = list.get(0); |
| | | // 将会员到期时间回退到上一次 |
| | | byId1.setVipEndTime(tVipOrder.getTime()); |
| | | byId1.setVipPayTime(tVipOrder.getPayTime()); |
| | | userService.updateById(byId1); |
| | | } |
| | | return R.ok(); |
| | |
| | | update t_user |
| | | <set> |
| | | vipEndTime = #{vipEndTime}, |
| | | vipPayTime = #{vipPayTime}, |
| | | vipPayTime = #{vipPayTime} |
| | | </set> |
| | | and id = #{id} |
| | | where id = #{id} |
| | | </update> |
| | | <select id="listAll" resultType="com.ruoyi.study.vo.AppUserVO"> |
| | | select * |
| | |
| | | <if test="null != req.phone and '' != req.phone"> |
| | | and t2.phone like CONCAT('%', #{req.phone}, '%') |
| | | </if> |
| | | and t1.payState !=1 |
| | | order by t1.payTime desc |
| | | </select> |
| | | </mapper> |