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.StoreTopicGoodsDto; 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.MkDailyActivitiesEntity; import com.kmall.admin.service.MkDailyActivitiesService; 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:26 */ @Controller @RequestMapping("mkdailyactivities") public class MkDailyActivitiesController { @Autowired private MkDailyActivitiesService mkDailyActivitiesService; @Autowired private ExcelUtil excelUtil; /** * 查看列表 */ @RequestMapping("/list") // @RequiresPermissions("mkdailyactivities:list") @ResponseBody public R list(@RequestParam Map params) { //查询列表数据 Query query = new Query(params); List mkDailyActivitiesList = mkDailyActivitiesService.queryList(query); int total = mkDailyActivitiesService.queryTotal(query); PageUtils pageUtil = new PageUtils(mkDailyActivitiesList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 查看信息 */ @RequestMapping("/info/{mdaId}") // @RequiresPermissions("mkdailyactivities:info") @ResponseBody public R info(@PathVariable("mdaId") Long mdaId) { MkDailyActivitiesEntity mkDailyActivities = mkDailyActivitiesService.queryObject(mdaId); return R.ok().put("mkDailyActivities", mkDailyActivities); } /** * 保存 */ @RequestMapping("/save") // @RequiresPermissions("mkdailyactivities:save") @ResponseBody public R save(@RequestBody MkDailyActivitiesEntity mkDailyActivities) { mkDailyActivitiesService.save(mkDailyActivities); return R.ok(); } /** * 修改 */ @RequestMapping("/update") // @RequiresPermissions("mkdailyactivities:update") @ResponseBody public R update(@RequestBody MkDailyActivitiesEntity mkDailyActivities) { mkDailyActivitiesService.update(mkDailyActivities); return R.ok(); } /** * 删除 */ @RequestMapping("/delete") // @RequiresPermissions("mkdailyactivities:delete") @ResponseBody public R delete(@RequestBody Long[]mdaIds) { mkDailyActivitiesService.deleteBatch(mdaIds); return R.ok(); } /** * 查看所有列表 */ @RequestMapping("/queryAll") @ResponseBody public R queryAll(@RequestParam Map params) { List list = mkDailyActivitiesService.queryList(params); return R.ok().put("list", list); } /** * 导入excel */ @PostMapping("/upload") @ResponseBody public R storeUpload(@RequestParam("file") MultipartFile file, String storeId,String mkaId) { List dailyPriceGoodsDtoList = new ArrayList<>();//信息 try { DailyPriceGoodsDto dailyPriceGoodsDto= new DailyPriceGoodsDto(); Map beans = new HashMap(); beans.put("DailyPriceGoodsDto", dailyPriceGoodsDto); beans.put("DailyPriceGoodsDtoList", dailyPriceGoodsDtoList); if (file.isEmpty()) { return R.error("文件不能为空!"); } excelUtil.readExcel(JxlsXmlTemplateName.DAILY_PRICE_GOODS_DTO_LIST, beans, file.getInputStream()); } catch (Exception e) { e.printStackTrace(); return R.error("导入失败!"); } try { mkDailyActivitiesService.uploadExcel(dailyPriceGoodsDtoList,storeId,mkaId); } catch (ParseException e) { e.printStackTrace(); return R.error("导入失败!"); } catch (RuntimeException e){ e.printStackTrace(); return R.error(e.getMessage()); } //上传文件 return R.ok("导入成功!"); } }