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.CombinationPriceGoodsDto; import com.kmall.admin.dto.DailyPriceGoodsDto; import com.kmall.admin.entity.MkActivitiesCombinationPriceEntity; import com.kmall.admin.service.MkActivitiesCombinationPriceService; import com.kmall.common.constant.JxlsXmlTemplateName; import com.kmall.common.utils.PageUtils; import com.kmall.common.utils.Query; import com.kmall.common.utils.R; 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 org.springframework.web.multipart.MultipartFile; /** * 营销活动-组合价Controller * * @author emato * @email admin@qhdswl.com * @date 2020-09-23 10:43:25 */ @Controller @RequestMapping("mkactivitiescombinationprice") public class MkActivitiesCombinationPriceController { @Autowired private MkActivitiesCombinationPriceService mkActivitiesCombinationPriceService; @Autowired private ExcelUtil excelUtil; /** * 查看列表 */ @RequestMapping("/list") // @RequiresPermissions("mkactivitiescombinationprice:list") @ResponseBody public R list(@RequestParam Map params) { //查询列表数据 Query query = new Query(params); List mkActivitiesCombinationPriceList = mkActivitiesCombinationPriceService.queryList(query); int total = mkActivitiesCombinationPriceService.queryTotal(query); PageUtils pageUtil = new PageUtils(mkActivitiesCombinationPriceList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 查看信息 */ @RequestMapping("/info/{macpId}") // @RequiresPermissions("mkactivitiescombinationprice:info") @ResponseBody public R info(@PathVariable("macpId") Long macpId) { MkActivitiesCombinationPriceEntity mkActivitiesCombinationPrice = mkActivitiesCombinationPriceService.queryObject(macpId); return R.ok().put("mkActivitiesCombinationPrice", mkActivitiesCombinationPrice); } /** * 保存 */ @RequestMapping("/save") // @RequiresPermissions("mkactivitiescombinationprice:save") @ResponseBody public R save(@RequestBody MkActivitiesCombinationPriceEntity mkActivitiesCombinationPrice) { mkActivitiesCombinationPriceService.save(mkActivitiesCombinationPrice); return R.ok(); } /** * 修改 */ @RequestMapping("/update") // @RequiresPermissions("mkactivitiescombinationprice:update") @ResponseBody public R update(@RequestBody MkActivitiesCombinationPriceEntity mkActivitiesCombinationPrice) { mkActivitiesCombinationPriceService.update(mkActivitiesCombinationPrice); return R.ok(); } /** * 删除 */ @RequestMapping("/delete") // @RequiresPermissions("mkactivitiescombinationprice:delete") @ResponseBody public R delete(@RequestBody Long[]macpIds) { mkActivitiesCombinationPriceService.deleteBatch(macpIds); return R.ok(); } /** * 查看所有列表 */ @RequestMapping("/queryAll") @ResponseBody public R queryAll(@RequestParam Map params) { List list = mkActivitiesCombinationPriceService.queryList(params); return R.ok().put("list", list); } /** * 导入excel */ @PostMapping("/upload") @ResponseBody public R storeUpload(@RequestParam("file") MultipartFile file, String storeId, String mkaId) { List combinationPriceGoodsDtoList = new ArrayList<>();//信息 try { CombinationPriceGoodsDto combinationPriceGoodsDto= new CombinationPriceGoodsDto(); Map beans = new HashMap(); beans.put("CombinationPriceGoodsDto", combinationPriceGoodsDto); beans.put("CombinationPriceGoodsDtoList", combinationPriceGoodsDtoList); if (file.isEmpty()) { return R.error("文件不能为空!"); } excelUtil.readExcel(JxlsXmlTemplateName.COMBINATION_PRICE_GOODS_DTO_LIST, beans, file.getInputStream()); } catch (Exception e) { e.printStackTrace(); return R.error("导入失败!"); } try { mkActivitiesCombinationPriceService.uploadExcel(combinationPriceGoodsDtoList,storeId,mkaId); } catch (RuntimeException e){ e.printStackTrace(); return R.error(e.getMessage()); } //上传文件 return R.ok("导入成功!"); } }