基于JavaScript的旅游网站Web定制DIY设计源码

package com.cn.travel.web.manager; import cn.hutool.poi.excel.ExcelUtil; import cn.hutool.poi.excel.ExcelWriter; import com.cn.travel.cms.product.dao.ProductDao; import com.cn.travel.cms.product.entity.Product; import com.cn.travel.cms.scenicSpot.entity.ScenicSpot; import com.cn.travel.cms.scenicSpot.service.imp.ScenicSpotService; import com.cn.travel.cms.travelRoute.entity.TravelRoute; import com.cn.travel.role.admin.entity.Admin; import com.cn.travel.utils.Tools; import com.cn.travel.web.base.BaseController; import com.cn.travel.web.base.PageParam; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.servlet.ModelAndView; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.File; import java.io.IOException; import java.net.URLEncoder; import java.util.List; @Controller @RequestMapping("/manager") public class ScenicSpotController extends BaseController { @Autowired ScenicSpotService scenicSpotService; @Autowired ProductDao productDao; @RequestMapping("/scenicSpotView/product") public String scenicSpotProducts(String id, Model model) throws Exception { // 商品信息 List<Product> listBySpotId = productDao.getListBySpotId(id); model.addAttribute("spotProducts", listBySpotId); // 景点信息 ScenicSpot scenicSpot = scenicSpotService.findById(id); model.addAttribute("spot", scenicSpot); return "scenicSpot/productList"; } @GetMapping("/scenicSpot/export") public void export(HttpServletResponse response) throws Exception { // 从数据库查询出所有的数据 List<ScenicSpot> list = scenicSpotService.findList(); // 左内存操作，写出到浏览器 ExcelWriter writer = ExcelUtil.getWriter(true); // 自定义标题别名 writer.addHeaderAlias("id", "ID"); writer.addHeaderAlias("spotStar", "主题"); writer.addHeaderAlias("spotAddress", "出发地"); writer.addHeaderAlias("openTime", "结束地"); writer.addHeaderAlias("ticketsMessage", "开始时间"); writer.addHeaderAlias("state", "结束时间"); writer.addHeaderAlias("imgUrl", "图片地址"); writer.addHeaderAlias("addUserId", "创建人"); writer.addHeaderAlias("addTime", "创建时间"); writer.addHeaderAlias("deleteStatus", "1删除 2未删"); writer.addHeaderAlias("modifyUserId", "修改人"); writer.addHeaderAlias("modifyTime", "修改时间"); // 一次性写出list内的对象到Excel，使用默认样式，强制输出标题 writer.write(list, true); // 设置浏览器响应的格式 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8"); String fileName = URLEncoder.encode("景点信息", "UTF-8"); response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx"); ServletOutputStream out = response.getOutputStream(); writer.flush(out, true); out.close(); writer.close(); } @RequestMapping("/scenicSpotList") public ModelAndView scenicSpotList(PageParam pageParam, @RequestParam(value = "query", required = false) String query){ ModelAndView mv = this.getModeAndView(); if(pageParam.getPageNumber()<1){ pageParam =new PageParam(); long count = 0; try { count = scenicSpotService.count(); } catch (Exception e) { e.printStackTrace(); } pageParam.setCount(count); if(count<=10){ pageParam.setSize(1); }else{ pageParam.setSize(count%10==0?count/10:count/10+1); } pageParam.setPageNumber(1); pageParam.setPageSize(10); } List<ScenicSpot> list = scenicSpotService.findByPage(pageParam.getPageNumber(),pageParam.getPageSize(), query); mv.addObject("pageData", list); if (Tools.notEmpty(query)) { mv.addObject("query", query); pageParam.setCount(list.size()); if (list.size() > pageParam.getPageSize()) { pageParam.setSize(list.size() / pageParam.getPageSize()); } else { pageParam.setSize(1); } } mv.addObject("pageParam",pageParam); mv.setViewName("scenicSpot/scenicSpotList"); return mv; } @RequestMapping("/scenicSpotAdd") public ModelAndView scenicSpotAdd(){ ModelAndView mv = this.getModeAndView(); mv.addObject("entity",new ScenicSpot()); mv.setViewName("scenicSpot/scenicSpotEdit"); return mv; } @RequestMapping("/scenicSpotView") public ModelAndView scenicSpotView(String id){ ModelAndView mv = this.getModeAndView(); try { mv.addObject("entity",scenicSpotService.findById(id)); }catch (Exception e){ e.printStackTrace(); } mv.setViewName("scenicSpot/scenicSpotView"); return mv; } @RequestMapping("/scenicSpotEdit") public ModelAndView scenicSpotEdit(String id){ ModelAndView mv = this.getModeAndView(); try { mv.addObject("entity",scenicSpotService.findById(id)); }catch (Exception e){ e.printStackTrace(); } mv.setViewName("scenicSpot/scenicSpotEdit"); return mv; } @RequestMapping("/scenicSpotSave") public String scenicSpotSave(HttpServletRequest request, String id, @RequestParam("fileName") MultipartFile file){ ScenicSpot entity = null; try { if(Tools.notEmpty(id)){ entity = scenicSpotService.findById(id); }else{ entity = new ScenicSpot(); } this.bindValidateRequestEntity(request,entity); if(file != null && !file.isEmpty()){ String fileName = file.getOriginalFilename(); int size = (int) file.getSize(); System.out.println(fileName + "-->" + size); String path = "G:/gitee/diy-travel/target/classes/static/scenicSpot" ; File dest = new File(path + "/" + fileName); if(!dest.getParentFile().exists()){ //判断文件父目录是否存在 dest.getParentFile().mkdir(); } try { file.transferTo(dest); //保存文件 entity.setImgUrl("/scenicSpot/" + fileName); } catch (IllegalStateException e) { e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if (Tools.isEmpty(entity.getId())){ entity.setId(Tools.getUUID()); Admin admin = (Admin) request.getSession().getAttribute("admin"); entity.setAddUserId(admin.getId()); scenicSpotService.save(entity); }else{ Admin admin = (Admin) request.getSession().getAttribute("admin"); entity.setModifyUserId(admin.getId()); scenicSpotService.update(entity); } } catch (Exception e) { e.printStackTrace(); } return REDIRECT+"/manager/scenicSpotList";