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

package com.kmall.admin.controller;

import java.math.BigDecimal;
import java.text.ParseException;
import java.util.*;

import com.kmall.admin.dto.SystemFormatDto;
import com.kmall.admin.dto.WxPaymentOrderDto;
import com.kmall.admin.entity.BrandEntity;
import com.kmall.admin.entity.MallPaymentOrderDataEntity;
import com.kmall.admin.service.MallPaymentOrderDataService;
import com.kmall.admin.utils.ParamUtils;
import com.kmall.common.constant.Dict;
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.RRException;
import com.kmall.common.utils.excel.ExcelExport;
import com.kmall.common.utils.excel.ExcelUtil;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
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;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


/**
 * 支付订单表Controller
 *
 * @author emato
 * @email admin@qhdswl.com
 * @date 2021-04-22 14:54:43
 */
@Controller
@RequestMapping("mallpaymentorderdata")
public class MallPaymentOrderDataController {
    @Autowired
    private MallPaymentOrderDataService mall2PaymentOrderDataService;
    @Autowired
    private ExcelUtil excelUtil;

    /**
     * 查看列表
     */
    @RequestMapping("/list")
    @RequiresPermissions("mallpaymentorderdata:list")
    @ResponseBody
    public R list(@RequestParam Map<String, Object> params) {

        //处理时间格式问题
        params = ParamUtils.setTimeMap(params);
        //查询列表数据
        Query query = new Query(params);

        List<MallPaymentOrderDataEntity> mall2PaymentOrderDataList = mall2PaymentOrderDataService.queryList(query);
        int total = mall2PaymentOrderDataService.queryTotal(query);

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

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

    /**
     * 查看信息
     */
    @RequestMapping("/info/{payOrderId}")
    @RequiresPermissions("mallpaymentorderdata:info")
    @ResponseBody
    public R info(@PathVariable("payOrderId") Integer payOrderId) {
        MallPaymentOrderDataEntity mall2PaymentOrderData = mall2PaymentOrderDataService.queryObject(payOrderId);

        return R.ok().put("mallPaymentOrderData", mall2PaymentOrderData);
    }

    /**
     * 保存
     */
    @RequestMapping("/save")
    @RequiresPermissions("mallpaymentorderdata:save")
    @ResponseBody
    public R save(@RequestBody MallPaymentOrderDataEntity mall2PaymentOrderData) {
        mall2PaymentOrderDataService.save(mall2PaymentOrderData);

        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    @RequiresPermissions("mallpaymentorderdata:update")
    @ResponseBody
    public R update(@RequestBody MallPaymentOrderDataEntity mall2PaymentOrderData) {
        mall2PaymentOrderDataService.update(mall2PaymentOrderData);

        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
    @RequiresPermissions("mallpaymentorderdata:delete")
    @ResponseBody
    public R delete(@RequestBody Integer[]payOrderIds) {
        mall2PaymentOrderDataService.deleteBatch(payOrderIds);

        return R.ok();
    }

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

        List<MallPaymentOrderDataEntity> list = mall2PaymentOrderDataService.queryList(params);

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

    @RequestMapping("/upload")
    @RequiresPermissions("mallpaymentorderdata:upload")
    @ResponseBody
    public R upload(@RequestParam("file") MultipartFile file,@RequestParam Map<String, Object> params) throws Exception {

        List<MallPaymentOrderDataEntity> list = new ArrayList<>();
        String payFlag = params.get("payFlag").toString();
        try {
            if (file.isEmpty()) {
                throw new RRException("上传文件不能为空");
            }
            MallPaymentOrderDataEntity mallPaymentOrderDataEntity = new MallPaymentOrderDataEntity();
            Map<String, Object> beans = new HashMap<String, Object>();
            beans.put("MallPaymentOrderDataEntity", mallPaymentOrderDataEntity);
            beans.put("MallPaymentOrderDataEntityList", list);
            if (Dict.payFlag.item_weixin.getItem().equals(payFlag)) {
                excelUtil.readExcel(JxlsXmlTemplateName.WX_PAYMENT_ORDER_DTO_List, beans, file.getInputStream());
            }else if (Dict.payFlag.item_alipay.getItem().equals(payFlag)){
                excelUtil.readExcel(JxlsXmlTemplateName.ALI_PAYMENT_ORDER_DTO_List, beans, file.getInputStream());
            }
        }catch (Exception e){
            e.printStackTrace();
            return R.error("导入失败！");
        }
        try {
            mall2PaymentOrderDataService.uploadExcel(list,payFlag);
        } catch (Exception e) {
            e.printStackTrace();
            return R.error(e.getMessage());
        }
        return R.ok();
    }

    /**
     * System Format 导出请求
     */
    @RequestMapping(value = "exportDataFormat")
    @RequiresPermissions("mallpaymentorderdata:exportDataFormat")
    @ResponseBody
    public R exportSystemFormat(@RequestParam Map<String, Object> params, HttpServletResponse response, HttpServletRequest request) throws ParseException {

        params = ParamUtils.setTimeMap(params);
        mall2PaymentOrderDataService.exportDataFormatList(params,response);
        return R.ok();
    }

}