【Springboot+MySQL】鲜花商城销售系统、鲜花商城、在线鲜花商城、鲜花销售、花店、商城.zip

package com.daowen.controller; import java.text.MessageFormat; import java.util.ArrayList; import java.util.List; import java.util.HashMap; import java.text.SimpleDateFormat; import java.util.Date; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.daowen.util.JsonResult; import com.daowen.vo.LanmuVo; import com.daowen.vo.XinxiVo; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import com.daowen.entity.*; import com.daowen.service.*; import com.daowen.ssm.simplecrud.SimpleController; import com.daowen.webcontrol.PagerMetal; /************************** * * 资讯资讯控制 * */ @RestController public class XinxiController extends SimpleController { @Autowired private XinxiService xinxiSrv = null; @Autowired private LanmuService lanmuSrv = null; @Autowired private AgreerecordService arSrv=null; @RequestMapping(value="/admin/xinxi/agree") public JsonResult agree() { String targetid = request.getParameter("targetid"); String commentator = request.getParameter("commentator"); if (targetid == null || commentator == null) { return JsonResult.error(-1, "参数异常"); } Boolean hasExist = arSrv.isExist(MessageFormat.format( " where targetid={0} and typename=''xinxi'' and commentator=''{1}'' ", targetid, commentator)); if (hasExist) { return JsonResult.error(-2, "你已经操作过"); } Xinxi xinxi = xinxiSrv.load("where id=" + targetid); if (xinxi == null) { return JsonResult.error(-3, "数据异常"); } Agreerecord ar = new Agreerecord(); ar.setCommentator(commentator); ar.setTargetid(targetid); ar.setTypename("xinxi"); arSrv.save(ar); xinxi.setAgreecount(xinxi.getAgreecount() + 1); xinxiSrv.update(xinxi); JsonResult jsonResult =JsonResult.success(1,"你赞了他"); HashMap<String,Integer> data= new HashMap<String,Integer>(); data.put("agreecount", xinxi.getAgreecount()); jsonResult.setData(data); return jsonResult; } @ResponseBody @PostMapping("/admin/xinxi/recomment") public JsonResult recomment(){ Huiyuan temhy=(Huiyuan)request.getSession().getAttribute("huiyuan"); if(temhy==null) return JsonResult.success(1,"暂无相关信息推荐"); //获取用户浏览记录 List<XinxiVo> listRecomment=xinxiSrv.getRecomment(request,temhy); return JsonResult.success(1,"猜你喜欢",listRecomment); } @RequestMapping(value="/admin/xinxi/against") public JsonResult against() { String targetid = request.getParameter("targetid"); String commentator = request.getParameter("commentator"); if (targetid == null || commentator == null) { return JsonResult.error(-1, "参数异常"); } Boolean hasExist = arSrv.isExist(MessageFormat.format( " where targetid={0} and typename=''xinxi'' and commentator=''{1}'' ", targetid, commentator)); if (hasExist) { return JsonResult.error(-2, "你已经操作过"); } Xinxi xinxi = xinxiSrv.load("where id=" + targetid); if (xinxi == null) { return JsonResult.error(-3, "数据异常"); } Agreerecord ar = new Agreerecord(); ar.setCommentator(commentator); ar.setTargetid(targetid); ar.setTypename("xinxi"); arSrv.save(ar); xinxi.setAgainstcount(xinxi.getAgainstcount()+1); xinxiSrv.update(xinxi); JsonResult<HashMap<String,Integer>> jsonResult = JsonResult.success(1, "你赞了它"); HashMap<String,Integer> data= new HashMap<String,Integer>(); data.put("againstcount", xinxi.getAgainstcount()); jsonResult.setData(data); return jsonResult; } @PostMapping("/admin/xinxi/clickstat") public JsonResult clickcounttongji(){ String sql=" select lm.name as name,sum(clickcount) as value from xinxi x,lanmu lm where lm.id=x.lmid group by lm.id ,lm.name "; List<HashMap<String,Object>> listXinxi=xinxiSrv.queryToMap(sql); return JsonResult.success(1,"",listXinxi); } @PostMapping("/admin/xinxi/count") public JsonResult counttongji(){ String sql=" select lm.name as name,count(*) as value from xinxi x,lanmu lm where lm.id=x.lmid group by lm.id ,lm.name "; List<HashMap<String,Object>> listXinxi=xinxiSrv.queryToMap(sql); return JsonResult.success(1,"",listXinxi); } @PostMapping("/admin/xinxi/mylanmu") public JsonResult mylanmu(){ List<LanmuVo> listLanmu=xinxiSrv.getMyLanmus(); return JsonResult.success(1,"获取栏目",listLanmu); } @PostMapping("/admin/xinxi/cascadelanmu") public JsonResult CascadeList(){ List<LanmuVo> listLanmu = xinxiSrv.getMyLanmus(); JSONArray jsonArray=new JSONArray(); if(listLanmu!=null) listLanmu.forEach(c->{ JSONObject jsonObject=new JSONObject(); jsonObject.put("value",c.getId()); jsonObject.put("label",c.getName()); if(c.getSubtypes()!=null){ JSONArray array = new JSONArray(); c.getSubtypes().forEach(subtype->{ JSONObject cobj=new JSONObject(); cobj.put("label",subtype.getName()); cobj.put("value",subtype.getId()); array.add(cobj); jsonObject.put("children",array); }); } jsonArray.add(jsonObject); }); return JsonResult.success(1,"获取成功",jsonArray); } @PostMapping("/admin/xinxi/list") public JsonResult list(){ String lmid=request.getParameter("lmid"); String title = request.getParameter("title"); String pubren= request.getParameter("pubren"); String tuijian=request.getParameter("tuijian"); String ispaged=request.getParameter("ispaged"); String subtypeid= request.getParameter("subtypeid"); HashMap<String ,Object> map=new HashMap(); if (title != null) map.put("title",title); if(!"0".equals(lmid)) map.put("lmid",lmid); if(subtypeid!=null) map.put("subtypeid",subtypeid); if(pubren!=null) map.put("pubren",pubren); if(tuijian!=null) map.put("tuijian",tuijian); map.put("order"," order by id desc "); // int pageindex = 1; int pagesize = 10; // 获取当前分页 String currentpageindex = request.getParameter("currentpageindex"); // 当前页面尺寸 String currentpagesize = request.getParameter("pagesize"); // 设置当前页 if (currentpageindex != null) pageindex = new Integer(currentpageindex); // 设置当前页尺寸 if (currentpagesize != null) pagesize = new Integer(currentpagesize); if(!"-1".equals(ispaged)) { PageHelper.startPage(pageindex, pagesize); PageInfo<XinxiVo> pageInfo = new PageInfo<XinxiVo>( xinxiSrv.getEntityPlus(map)); return JsonResult.success(1, "获取成功", pageInfo); } return JsonResult.success(1,"获取成功",xinxiSrv.getEntityPlus(map)); } @PostMapping("/admin/xinxi/hot") public JsonResult hotxinxi(){ HashMap<String,Object> map=new HashMap<>(); map.put("tuijian",1); map.