123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 |
- 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<String, Object> params) {
- //查询列表数据
- Query query = new Query(params);
- List<MkDailyActivitiesEntity> 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<String, Object> params) {
- List<MkDailyActivitiesEntity> 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<DailyPriceGoodsDto> dailyPriceGoodsDtoList = new ArrayList<>();//信息
- try {
- DailyPriceGoodsDto dailyPriceGoodsDto= new DailyPriceGoodsDto();
- Map<String, Object> beans = new HashMap<String, Object>();
- 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("导入成功!");
- }
- }
|