package com.kmall.admin.controller.alarm;

import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
import com.kmall.admin.entity.alarm.Mall2ShippingReminderAlarmEntity;
import com.kmall.common.utils.JacksonUtils;
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.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import com.kmall.admin.entity.alarm.Mall2OrderingEarlyWarningRemindsEntity;
import com.kmall.admin.service.alarm.Mall2OrderingEarlyWarningRemindsService;

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

/**
 * 订货提醒预警表Controller
 *
 * @author emato
 * @email admin@qhdswl.com
 * @date 2020-06-15 10:44:07
 */
@Controller
@RequestMapping("mall2orderingearlywarningreminds")
public class Mall2OrderingEarlyWarningRemindsController {
    @Autowired
    private Mall2OrderingEarlyWarningRemindsService mall2OrderingEarlyWarningRemindsService;

    private final Logger LOGGER = LoggerFactory.getLogger(Mall2OrderingEarlyWarningRemindsController.class);


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

        List<Mall2OrderingEarlyWarningRemindsEntity> mall2OrderingEarlyWarningRemindsList = mall2OrderingEarlyWarningRemindsService.queryList(query);
        int total = mall2OrderingEarlyWarningRemindsService.queryTotal(query);

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

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

    /**
     * 查看信息
     */
    @RequestMapping("/info/{moewrId}")
//    @RequiresPermissions("mall2orderingearlywarningreminds:info")
    @ResponseBody
    public R info(@PathVariable("moewrId") Integer moewrId) {
        Mall2OrderingEarlyWarningRemindsEntity mall2OrderingEarlyWarningReminds = mall2OrderingEarlyWarningRemindsService.queryObject(moewrId);

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

    /**
     * 保存
     */
    @RequestMapping("/save")
//    @RequiresPermissions("mall2orderingearlywarningreminds:save")
    @ResponseBody
    public R save(@RequestBody Mall2OrderingEarlyWarningRemindsEntity mall2OrderingEarlyWarningReminds) {
        mall2OrderingEarlyWarningRemindsService.save(mall2OrderingEarlyWarningReminds);

        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
//    @RequiresPermissions("mall2orderingearlywarningreminds:update")
    @ResponseBody
    public R update(@RequestBody Mall2OrderingEarlyWarningRemindsEntity mall2OrderingEarlyWarningReminds) {
        mall2OrderingEarlyWarningRemindsService.update(mall2OrderingEarlyWarningReminds);

        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
//    @RequiresPermissions("mall2orderingearlywarningreminds:delete")
    @ResponseBody
    public R delete(@RequestBody Integer[]moewrIds) {
        mall2OrderingEarlyWarningRemindsService.deleteBatch(moewrIds);

        return R.ok();
    }

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

        List<Mall2OrderingEarlyWarningRemindsEntity> list = mall2OrderingEarlyWarningRemindsService.queryList(params);

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


    // exportInfo
    /**
     * 导出订单数据
     */
    @RequestMapping("/exportInfo")
    public R exportInfo(HttpServletResponse response, HttpServletRequest request) {
        Map<String, Object> params = new HashMap<>();

        List<Mall2OrderingEarlyWarningRemindsEntity> list = mall2OrderingEarlyWarningRemindsService.queryList(params);

        LOGGER.info(JacksonUtils.toJson(list));
        List<Map<Integer, String>> lists = Lists.newArrayList();

        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        for (int i = 0; i < list.size(); i++) {
            HashMap<Integer, String> map = Maps.newHashMap();

            map.put(map.size(), (i+1)+"");
            map.put(map.size(), list.get(i).getGoodsId()+"");
            map.put(map.size(), list.get(i).getGoodsName());
            map.put(map.size(), list.get(i).getSku());
            map.put(map.size(), list.get(i).getAverageSales()+"");
            map.put(map.size(), list.get(i).getTotalNum()+"");
            map.put(map.size(), format.format(list.get(i).getAlarmTime()));

            lists.add(map);
        }
        String fileName = "订货提醒";
        String titles[] = {"序号", "商品id","商品名称","商品sku","平均销量","总库存数","预警时间"};
        try {
            ExcelUtil.exportExcel(fileName, titles, lists, response, request);
        } catch (IOException e) {
            e.printStackTrace();
            return R.error("导出失败!");
        }
        return R.error("导出成功!");
    }

}