src/main/java/org/springblade/modules/article/controller/ArticleController.java
@@ -41,8 +41,8 @@ private final IMgcxService mgcxService; /** * * 查询资讯分页信息 * * @param response * @param article 资讯对象 * @param query 查询参数 @@ -57,8 +57,8 @@ } /** * * 敏感词预警 * * @param response * @param article 资讯对象 * @param query 查询参数 @@ -73,8 +73,8 @@ } /** * * 查询资讯分页信息(角色权限) * * @param response * @param article 资讯对象 * @param query 查询参数 @@ -97,8 +97,8 @@ } /** * * 查询资讯分页信息(角色权限)附带点赞评论数 * * @param response * @param article 资讯对象 * @param query 查询参数 @@ -126,6 +126,7 @@ /** * 资讯详情 * * @param article 资讯查询对象 * @param response */ @@ -142,6 +143,7 @@ /** * 新增资讯信息 * * @param article 资讯对象 */ @PostMapping("/save") @@ -153,6 +155,7 @@ /** * 修改资讯信息 * * @param article 资讯对象 */ @PostMapping("/update") @@ -164,6 +167,7 @@ /** * 新增或修改资讯信息 * * @param article 资讯对象信息 */ @PostMapping("/submit") @@ -198,11 +202,10 @@ mgcx.setUid(userid); mgcx.setPhone(detail.getPhone()); mgcx.setCardid(detail.getCardid()); mgcx.setCountx(10); mgcx.setCountx(mgcxService.sel()); mgcx.setCounts(1); mgcxService.save(mgcx); } else { } else { Integer counts = one.getCounts(); int i = counts + 1; one.setCounts(i); @@ -219,6 +222,7 @@ /** * 删除资讯信息 * * @param ids 资讯主键id,id集合 */ @PostMapping("/remove") src/main/java/org/springblade/modules/integral/controller/IntegralController.java
@@ -21,6 +21,7 @@ import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; import io.swagger.models.auth.In; import lombok.AllArgsConstructor; import org.springblade.core.boot.ctrl.BladeController; import org.springblade.core.mp.support.Condition; @@ -33,6 +34,9 @@ import org.springframework.web.bind.annotation.*; import javax.validation.Valid; import java.util.HashMap; import java.util.List; import java.util.Map; /** * 控制器 @@ -131,8 +135,17 @@ */ @PostMapping("/selectCount") public R selectCount(String uid) { return R.data(integralService.selectCount(uid)); List<Map<Object, Object>> list = integralService.selectCount(uid); Map map = new HashMap(); Integer a = Integer.parseInt(list.get(0).get("integral").toString()); Integer b = Integer.parseInt(list.get(1).get("integral").toString()); //总积分 map.put("zjf", list.get(0)); //总的用掉的积分 map.put("yjf", list.get(1)); //剩余积分 map.put("sjf", a - b); return R.data(map); } } src/main/java/org/springblade/modules/integral/entity/Integral.java
@@ -63,6 +63,10 @@ */ @ApiModelProperty(value = "积分") private Integer integral; /** * 类型 */ private String type; } src/main/java/org/springblade/modules/integral/mapper/IntegralMapper.java
@@ -22,6 +22,7 @@ import org.springblade.modules.integral.vo.IntegralVO; import java.util.List; import java.util.Map; /** * Mapper 接口 @@ -39,5 +40,5 @@ * @return */ List<IntegralVO> selectIntegralPage(IPage page, IntegralVO integral); String selectCount(String uid); List<Map<Object, Object>> selectCount(String uid); } src/main/java/org/springblade/modules/integral/mapper/IntegralMapper.xml
@@ -18,9 +18,14 @@ where is_deleted = 0 </select> <select id="selectCount" resultType="java.lang.String"> <select id="selectCount" resultType="java.util.HashMap"> SELECT COALESCE(sum(integral), 0) as integral FROM sys_integral where uid=#{uid} FROM sys_integral WHERE type = 1 AND uid=#{uid} UNION ALL SELECT COALESCE(sum(integral), 0) AS integral FROM sys_integral WHERE type = 2 AND uid=#{uid} </select> </mapper> src/main/java/org/springblade/modules/integral/service/IIntegralService.java
@@ -21,6 +21,9 @@ import org.springblade.modules.integral.entity.Integral; import org.springblade.modules.integral.vo.IntegralVO; import java.util.List; import java.util.Map; /** * 服务类 * @@ -37,5 +40,5 @@ * @return */ IPage<IntegralVO> selectIntegralPage(IPage<IntegralVO> page, IntegralVO integral); String selectCount(String uid); List<Map<Object, Object>> selectCount(String uid); } src/main/java/org/springblade/modules/integral/service/impl/IntegralServiceImpl.java
@@ -24,6 +24,9 @@ import org.springblade.modules.integral.vo.IntegralVO; import org.springframework.stereotype.Service; import java.util.List; import java.util.Map; /** * 服务实现类 * @@ -39,7 +42,7 @@ } @Override public String selectCount(String uid) { public List<Map<Object, Object>> selectCount(String uid) { return baseMapper.selectCount(uid); }
@@ -123,4 +123,15 @@ return R.status(mgcxService.removeByIds(Func.toLongList(ids))); } @PostMapping("/updateval") public R updateval(@ApiParam int val) { mgcxService.update(val); return R.success("修改成功"); } @PostMapping("/sel") public R sel() { return R.data(mgcxService.sel()); } } src/main/java/org/springblade/modules/mgcx/mapper/MgcxMapper.java
@@ -40,4 +40,7 @@ */ List<MgcxVO> selectMgcxPage(IPage page, MgcxVO mgcx); void update(int val); int sel(); } src/main/java/org/springblade/modules/mgcx/mapper/MgcxMapper.xml
@@ -17,4 +17,12 @@ select * from sys_mgcx where is_deleted = 0 </select> <update id="update"> update sys_valmgcx set value=#{val} where id=1 </update> <select id="sel" resultType="java.lang.Integer"> select value from sys_valmgcx where id=1 </select> </mapper> src/main/java/org/springblade/modules/mgcx/service/IMgcxService.java
@@ -37,5 +37,6 @@ * @return */ IPage<MgcxVO> selectMgcxPage(IPage<MgcxVO> page, MgcxVO mgcx); void update(int val); int sel(); } src/main/java/org/springblade/modules/mgcx/service/impl/MgcxServiceImpl.java
@@ -38,4 +38,14 @@ return page.setRecords(baseMapper.selectMgcxPage(page, mgcx)); } @Override public void update(int val) { baseMapper.update(val); } @Override public int sel() { return baseMapper.sel(); } }
