kmall-haikong/kmall-admin/src/main/java/com/kmall/admin/controller/SysCusNationCodeController.java

package com.kmall.admin.controller;

import java.util.*;

import com.kmall.admin.entity.SysCusNationCodeEntity;
import com.kmall.admin.service.SysCusNationCodeService;
import com.kmall.admin.fromcomm.entity.SysUserEntity;
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.admin.utils.ShiroUtils;
import com.kmall.common.utils.RRException;
import com.kmall.common.utils.excel.ExcelUtil;
import com.kmall.manager.manager.express.sf.ServiceException;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.jxls.reader.XLSDataReadException;
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 huangyq,zhuhh
 * @email admin@qhdswl.com
 * @date 2018-11-10 15:26:44
 */
@RestController
@RequestMapping("syscusnationcode")
public class SysCusNationCodeController {
    private Log logger = LogFactory.getLog(SysCusNationCodeController.class);

    @Autowired
    private SysCusNationCodeService sysCusNationCodeService;

    @Autowired
    private ExcelUtil excelUtil;

    /**
     * 查看列表
     */
    @RequestMapping("/list")
    @RequiresPermissions("syscusnationcode:list")
    @ResponseBody
    public R list(@RequestParam Map<String, Object> params) {
        //查询列表数据
        Query query = new Query(params);

        List<SysCusNationCodeEntity> sysCusNationCodeList = sysCusNationCodeService.queryList(query);
        int total = sysCusNationCodeService.queryTotal(query);

        PageUtils pageUtil = new PageUtils(sysCusNationCodeList, total, query.getLimit(), query.getPage());

        return R.ok().put("page", pageUtil);
    }

    /**
     * 查看信息
     */
    @RequestMapping("/info/{sn}")
    @RequiresPermissions("syscusnationcode:info")
    @ResponseBody
    public R info(@PathVariable("sn") String sn) {
        SysCusNationCodeEntity sysCusNationCode = sysCusNationCodeService.queryObject(sn);
        return R.ok().put("sysCusNationCode", sysCusNationCode);
    }

    /**
     * 保存
     */
    @RequestMapping("/save")
    @RequiresPermissions("syscusnationcode:save")
    @ResponseBody
    public R save(@RequestBody SysCusNationCodeEntity sysCusNationCode) {

        SysUserEntity user = ShiroUtils.getUserEntity();
        sysCusNationCode.setCreaterSn(user.getUserId().toString());
        sysCusNationCode.setCreateTime(new Date());
        sysCusNationCode.setModerSn(user.getUserId().toString());
        sysCusNationCode.setModTime(new Date());

        sysCusNationCodeService.save(sysCusNationCode);

        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    @RequiresPermissions("syscusnationcode:update")
    @ResponseBody
    public R update(@RequestBody SysCusNationCodeEntity sysCusNationCode) {
        SysUserEntity user = ShiroUtils.getUserEntity();
        sysCusNationCode.setModerSn(user.getUserId().toString());
        sysCusNationCode.setModTime(new Date());
        sysCusNationCodeService.update(sysCusNationCode);

        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
    @RequiresPermissions("syscusnationcode:delete")
    @ResponseBody
    public R delete(@RequestBody String[]sns) {
        sysCusNationCodeService.deleteBatch(sns);

        return R.ok();
    }

    /**
     * 查看所有列表
     */
    @RequestMapping("/queryAll")
    @ResponseBody
    public R queryAll(@RequestParam Map<String, Object> params) {

        List<SysCusNationCodeEntity> list = sysCusNationCodeService.queryList(params);

        return R.ok().put("list", list);
    }

    /**
     * 导入 excel 数据
     * @author zhuhh
     * @param file
     * @return
     */
    @RequestMapping("/upload")
    public R upload(@RequestParam("file") MultipartFile file) {
        List<SysCusNationCodeEntity> sysCusNationCodeEntityList = new ArrayList<>();
        // 读取 excel 数据
        try {
            SysCusNationCodeEntity sysCusNationCodeEntity = new SysCusNationCodeEntity();
            Map<String, Object> beans = new HashMap<>();
            beans.put("sysCusNationCodeEntity", sysCusNationCodeEntity);
            beans.put("sysCusNationCodeEntityList", sysCusNationCodeEntityList);
            if (file.isEmpty()) {
                return R.error("文件不能为空！");
            }
            excelUtil.readExcel(JxlsXmlTemplateName.SYS_CUS_NATION_CODE_DTO_List, beans, file.getInputStream());
        } catch (XLSDataReadException e) {
            e.printStackTrace();
            logger.error("商品供货商读取excel失败：" + e.getMessage());
            return R.error("导入失败！请在单元格输入正确的数据格式");
        } catch (Exception e) {
            e.printStackTrace();
            logger.error("商品供货商读取excel失败：" + e.getMessage());
            return R.error("读取excel数据失败！");
        }
        // 新增数据
        try {
            if (sysCusNationCodeEntityList == null || sysCusNationCodeEntityList.size() == 0) {
                return R.error("读取excel失败！单元格内容不能为空！");
            }

            sysCusNationCodeService.uploadExcel(sysCusNationCodeEntityList);
        } catch (ServiceException e) {
            e.printStackTrace();
            logger.error("商品供货商数据格式校验失败：" + e.getMessage());
            return R.error(e.getMessage());
        } catch (RRException e) {
            e.printStackTrace();
            logger.error("商品供货商添加数据失败：" + e.getMsg());
            return R.error(e.getMsg());
        } catch (Exception e) {
            e.printStackTrace();
            logger.error("商品供货商添加数据失败：" + e.getMessage());
            return R.error("数据保存数据库失败！");
        }
        return R.ok("导入成功！");
    }

}