package com.kmall.admin.controller.mk; 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.StoreGoodsDto; import com.kmall.admin.dto.StoreTopicGoodsDto; import com.kmall.admin.entity.mk.Mk2GoodsTopicPriceEntity; 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 com.kmall.admin.entity.mk.Mk2GoodsTopicPriceEntity; import com.kmall.admin.service.mk.Mk2GoodsTopicPriceService; import org.springframework.web.multipart.MultipartFile; /** * 商品活动价格表Controller * * @author emato * @email admin@qhdswl.com * @date 2020-06-15 10:44:07 */ @Controller @RequestMapping("mk2goodstopicprice") public class Mk2GoodsTopicPriceController { @Autowired private Mk2GoodsTopicPriceService mk2GoodsTopicPriceService; @Autowired private ExcelUtil excelUtil; /** * 查看列表 */ @RequestMapping("/list") // @RequiresPermissions("mk2goodstopicprice:list") @ResponseBody public R list(@RequestParam Map params) { //查询列表数据 Query query = new Query(params); List mk2GoodsTopicPriceList = mk2GoodsTopicPriceService.queryList(query); int total = mk2GoodsTopicPriceService.queryTotal(query); PageUtils pageUtil = new PageUtils(mk2GoodsTopicPriceList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 查看信息 */ @RequestMapping("/info/{mgthpId}") // @RequiresPermissions("mk2goodstopicprice:info") @ResponseBody public R info(@PathVariable("mgthpId") Integer mgthpId) { Mk2GoodsTopicPriceEntity mk2GoodsTopicPrice = mk2GoodsTopicPriceService.queryObject(mgthpId); return R.ok().put("mk2GoodsTopicPrice", mk2GoodsTopicPrice); } /** * 保存 */ @RequestMapping("/save") // @RequiresPermissions("mk2goodstopicprice:save") @ResponseBody public R save(@RequestBody Mk2GoodsTopicPriceEntity mk2GoodsTopicPrice) { mk2GoodsTopicPriceService.save(mk2GoodsTopicPrice); return R.ok(); } /** * 修改 */ @RequestMapping("/update") // @RequiresPermissions("mk2goodstopicprice:update") @ResponseBody public R update(@RequestBody Mk2GoodsTopicPriceEntity mk2GoodsTopicPrice) { mk2GoodsTopicPriceService.update(mk2GoodsTopicPrice); return R.ok(); } /** * 删除 */ @RequestMapping("/delete") // @RequiresPermissions("mk2goodstopicprice:delete") @ResponseBody public R delete(@RequestBody Integer[]mgthpIds) { mk2GoodsTopicPriceService.deleteBatch(mgthpIds); return R.ok(); } /** * 查看所有列表 */ @RequestMapping("/queryAll") @ResponseBody public R queryAll(@RequestParam Map params) { List list = mk2GoodsTopicPriceService.queryList(params); return R.ok().put("list", list); } @PostMapping("/goodsTopicPriceUpload") @ResponseBody public R storeUpload(@RequestParam("file") MultipartFile file) { List storeTopicGoodsDtoList = new ArrayList<>();//信息 try { StoreTopicGoodsDto storeTopicGoodsDto = new StoreTopicGoodsDto(); Map beans = new HashMap(); beans.put("storeTopicGoodsDto", storeTopicGoodsDto); beans.put("storeTopicGoodsDtoList", storeTopicGoodsDtoList); if (file.isEmpty()) { return R.error("文件不能为空!"); } excelUtil.readExcel(JxlsXmlTemplateName.STORE_TOPIC_DTO_LIST, beans, file.getInputStream()); } catch (Exception e) { e.printStackTrace(); return R.error("导入失败!"); } try { mk2GoodsTopicPriceService.uploadExcel(storeTopicGoodsDtoList); } catch (ParseException e) { e.printStackTrace(); return R.error("导入失败!"); } //上传文件 return R.ok("导入成功!"); } }