现在直播软件开发时，一般都会实现商城功能，而与之匹配的，就是用户评价的功能，通过用户评价，其他用户可以更全面的了解商品，接下来就让我们看看，直播软件开发是怎样实现用户评价功能的。
1.效果图
2.数据库设计
3.封装商品评价VO
/**
* 用来展示商品的评价数量的VO
*/
public class CommentLevelCountsVO {
public Integer totalCounts;
public Integer goodCounts;
public Integer normalCounts;
public Integer badCounts;
省略get和set方法......
}
4.自定义Mapper
ItemsMapperCustom
public interface ItemsMapperCustom{
public List<ItemCommentVO> queryItemComments(@Param("paramsMap") Map<String,Object> map);
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.lzx.mapper.ItemsMapperCustom" >
<select id="queryItemComments" parameterType="Map" resultType="com.lzx.pojo.vo.ItemCommentVO">
SELECT
ic.`comment_level` AS commentLevel,
ic.`content` AS content,
ic.`sepc_name` AS sepcName,
ic.`created_time` AS createdTime,
u.`face` AS userFace,
u.`nickname` AS nickname
FROM
items_comments ic
LEFT JOIN
users u
ON
ic.`user_id` = u.id
WHERE
ic.`item_id`= #{paramsMap.itemId}
<if test=" paramsMap.level != null and paramsMap.level != '' ">
AND ic.`comment_level`=#{paramsMap.level}
</if>
</select>
</mapper>
5.编写Service
ItemService
/** * 根据商品id查询商品评价（分页） * @param itemId * @param level * @return */ public PagedGridResult queryItemComments(String itemId, Integer level, Integer page, Integer pageSize);
6.编写Service实现类
PagedGridResult 是对分页结果的封装
DesensitizationUtil.commonDisplay（）是对信息进行脱敏操作
@Transactional(propagation = Propagation.SUPPORTS)
@Override
public PagedGridResult queryItemComments(String itemId, Integer level, Integer page,Integer pageSize) {
Map<String,Object> map = new HashMap<>();
map.put("itemId",itemId);
map.put("level",level);
PageHelper.startPage(page,pageSize);
List<ItemCommentVO> lists = itemsMapperCustom.queryItemComments(map);
for (ItemCommentVO list:lists) {
list.setNickname(DesensitizationUtil.commonDisplay(list.getNickname()));
}
return setterPagedGrid(lists,page);
}
private PagedGridResult setterPagedGrid(List<?> list,Integer page){
PageInfo<?> pageList = new PageInfo<>(list);
PagedGridResult grid = new PagedGridResult();
grid.setPage(page);
grid.setRows(list);
grid.setTotal(pageList.getPages());
grid.setRecords(pageList.getTotal());
return grid;
}
7.编写Controller
ItemsController
@ApiOperation(value = "查询商品评价",notes = "查询商品评价",httpMethod = "GET")
@GetMapping("/comments")
public JSONResult comments(
@ApiParam(name = "itemId",value ="商品Id",required = true)
@RequestParam String itemId,
@ApiParam(name = "level",value ="评价等级",required = false)
@RequestParam Integer level,
@ApiParam(name = "page",value ="页数",required = false)
@RequestParam Integer page,
@ApiParam(name = "pageSize",value ="一页显示的数量",required = false)
@RequestParam Integer pageSize){
if (StringUtils.isBlank(itemId)) {
return JSONResult.errorMsg(null);
}
if (page == null) {
page = 1;
}
if (pageSize == null) {
pageSize = COMMENT_PAGE_SIZE ;
}
PagedGridResult result = itemService.queryItemComments(itemId, level, page, pageSize);
return JSONResult.ok(result);
}
8.部分前端代码
renderComments(itemId, level, page, pageSize) {
var serverUrl = app.serverUrl;
axios.defaults.withCredentials = true;
axios.get(
serverUrl + '/items/comments?itemId=' + itemId + "&level=" + level + "&page=" + page +
"&pageSize=" + pageSize, {})
.then(res => {
if (res.data.status == 200) {
var grid = res.data.data;
var commentList = grid.rows;
this.commentList = commentList;
// console.log(commentList);
for (var i = 0 ; i < commentList.length ; i ++) {
var date = commentList[i].createdTime;
var formatedTime = moment(date).format('YYYY年MM月DD日 h:mm:ss');
// console.log(formatedTime);
commentList[i].createdTime = formatedTime;
}
var maxPage = grid.total; // 获得总页数
var total = grid.records; // 获得总记录数
this.maxPage = maxPage;
this.total = total;
} else if (res.data.status == 500) {
alert(res.data.msg);
}
});
},
声明：本文由云豹科技转发自Java追求者博客，如有侵权请联系作者删除
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69982461/viewspace-2790145/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
直播源码搭建教程，教你实现举报功能
下一篇：
app直播源代码如何实现直播间红包功能
请登录后发表评论
登录
全部评论
