package com.kmall.admin.controller; import java.text.ParseException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import com.kmall.admin.dto.DailyPriceGoodsDto; import com.kmall.admin.dto.DiscountedProductsDto; import com.kmall.common.constant.JxlsXmlTemplateName; import com.kmall.common.utils.excel.ExcelUtil; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import com.kmall.admin.entity.MkActivitiesDiscountEntity; import com.kmall.admin.service.MkActivitiesDiscountService; import com.kmall.common.utils.PageUtils; import com.kmall.common.utils.Query; import com.kmall.common.utils.R; import org.springframework.web.multipart.MultipartFile; /** * 营销活动-全场打折Controller * * @author emato * @email admin@qhdswl.com * @date 2020-09-23 10:43:25 */ @Controller @RequestMapping("mkactivitiesdiscount") public class MkActivitiesDiscountController { @Autowired private MkActivitiesDiscountService mkActivitiesDiscountService; @Autowired private ExcelUtil excelUtil; /** * 查看列表 */ @RequestMapping("/list") // @RequiresPermissions("mkactivitiesdiscount:list") @ResponseBody public R list(@RequestParam Map params) { //查询列表数据 Query query = new Query(params); List mkActivitiesDiscountList = mkActivitiesDiscountService.queryList(query); int total = mkActivitiesDiscountService.queryTotal(query); PageUtils pageUtil = new PageUtils(mkActivitiesDiscountList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 查看信息 */ @RequestMapping("/info/{madId}") // @RequiresPermissions("mkactivitiesdiscount:info") @ResponseBody public R info(@PathVariable("madId") Long madId) { MkActivitiesDiscountEntity mkActivitiesDiscount = mkActivitiesDiscountService.queryObject(madId); return R.ok().put("mkActivitiesDiscount", mkActivitiesDiscount); } /** * 保存 */ @RequestMapping("/save") // @RequiresPermissions("mkactivitiesdiscount:save") @ResponseBody public R save(@RequestBody MkActivitiesDiscountEntity mkActivitiesDiscount) { mkActivitiesDiscountService.save(mkActivitiesDiscount); return R.ok(); } /** * 修改 */ @RequestMapping("/update") // @RequiresPermissions("mkactivitiesdiscount:update") @ResponseBody public R update(@RequestBody MkActivitiesDiscountEntity mkActivitiesDiscount) { mkActivitiesDiscountService.update(mkActivitiesDiscount); return R.ok(); } /** * 删除 */ @RequestMapping("/delete") // @RequiresPermissions("mkactivitiesdiscount:delete") @ResponseBody public R delete(@RequestBody Long[]madIds) { mkActivitiesDiscountService.deleteBatch(madIds); return R.ok(); } /** * 查看所有列表 */ @RequestMapping("/queryAll") @ResponseBody public R queryAll(@RequestParam Map params) { List list = mkActivitiesDiscountService.queryList(params); return R.ok().put("list", list); } /** * 导入excel */ @PostMapping("/upload") @ResponseBody public R storeUpload(@RequestParam("file") MultipartFile file, String storeId, String mkaId) { List discountedProductsDtoList = new ArrayList<>();//信息 try { DiscountedProductsDto discountedProductsDto= new DiscountedProductsDto(); Map beans = new HashMap(); beans.put("DiscountedProductsDto", discountedProductsDto); beans.put("DiscountedProductsDtoList", discountedProductsDtoList); if (file.isEmpty()) { return R.error("文件不能为空!"); } excelUtil.readExcel(JxlsXmlTemplateName.DISCOUNTED_PRODUCTS_DTO_LIST, beans, file.getInputStream()); } catch (Exception e) { e.printStackTrace(); return R.error("导入失败!"); } try { mkActivitiesDiscountService.uploadExcel(discountedProductsDtoList,storeId,mkaId); } catch (RuntimeException e){ e.printStackTrace(); return R.error(e.getMessage()); } //上传文件 return R.ok("导入成功!"); } }