package com.stylefeng.guns.modular.system.controller.general;

import com.baomidou.mybatisplus.plugins.Page;
import com.stylefeng.guns.core.base.controller.BaseController;
import com.stylefeng.guns.core.common.constant.factory.PageFactory;
import com.stylefeng.guns.core.util.ExcelUtil;
import com.stylefeng.guns.core.util.SinataUtil;
import com.stylefeng.guns.core.util.ToolUtil;
import com.stylefeng.guns.modular.system.service.IUserCouponRecordService;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.beans.factory.annotation.Autowired;
import com.stylefeng.guns.core.log.LogObjectHolder;
import org.springframework.web.bind.annotation.RequestParam;
import com.stylefeng.guns.modular.system.model.TUserRedPacketRecord;
import com.stylefeng.guns.modular.system.service.ITUserRedPacketRecordService;

import javax.servlet.http.HttpServletResponse;
import java.io.OutputStream;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * 控制器
 *
 * @author fengshuonan
 * @Date 2020-07-10 15:33:49
 */
@Controller
@RequestMapping("/tUserRedPacketRecord")
public class TUserRedPacketRecordController extends BaseController {

    private String PREFIX = "/system/tUserRedPacketRecord/";

    @Autowired
    private ITUserRedPacketRecordService tUserRedPacketRecordService;

    @Autowired
    private IUserCouponRecordService userCouponRecordService;


    /**
     * 跳转到首页
     */
    @RequestMapping("")
    public String index(Model model,Integer couponActivityId) {
        model.addAttribute("couponActivityId",couponActivityId);
        return PREFIX + "tUserRedPacketRecord.html";
    }

    /**
     * 跳转到添加
     */
    @RequestMapping("/tUserRedPacketRecord_add")
    public String tUserRedPacketRecordAdd() {
        return PREFIX + "tUserRedPacketRecord_add.html";
    }

    /**
     * 跳转到修改
     */
    @RequestMapping("/tUserRedPacketRecord_update/{tUserRedPacketRecordId}")
    public String tUserRedPacketRecordUpdate(@PathVariable Integer tUserRedPacketRecordId, Model model) {
        TUserRedPacketRecord tUserRedPacketRecord = tUserRedPacketRecordService.selectById(tUserRedPacketRecordId);
        model.addAttribute("item",tUserRedPacketRecord);
        LogObjectHolder.me().set(tUserRedPacketRecord);
        return PREFIX + "tUserRedPacketRecord_edit.html";
    }

    /**
     * 获取列表
     */
    @RequestMapping(value = "/list")
    @ResponseBody
    public Object list(String createTime,String userName,String userPhone,Integer couponActivityId,Integer state) {
        String beginTime = null;
        String endTime = null;
        if (SinataUtil.isNotEmpty(createTime)){
            String[] timeArray = createTime.split(" - ");
            beginTime = timeArray[0];
            endTime = timeArray[1];
        }
        Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
        page.setRecords(userCouponRecordService.getRedList(page,beginTime,endTime,userName,userPhone,couponActivityId,state));
        return super.packForBT(page);
    }
    /**
     * 新增
     */
    @RequestMapping(value = "/add")
    @ResponseBody
    public Object add(TUserRedPacketRecord tUserRedPacketRecord) {
        tUserRedPacketRecordService.insert(tUserRedPacketRecord);
        return SUCCESS_TIP;
    }

    /**
     * 删除
     */
    @RequestMapping(value = "/delete")
    @ResponseBody
    public Object delete(@RequestParam Integer tUserRedPacketRecordId) {
        tUserRedPacketRecordService.deleteById(tUserRedPacketRecordId);
        return SUCCESS_TIP;
    }

    /**
     * 修改
     */
    @RequestMapping(value = "/update")
    @ResponseBody
    public Object update(TUserRedPacketRecord tUserRedPacketRecord) {
        tUserRedPacketRecordService.updateById(tUserRedPacketRecord);
        return SUCCESS_TIP;
    }

    /**
     * 详情
     */
    @RequestMapping(value = "/detail/{tUserRedPacketRecordId}")
    @ResponseBody
    public Object detail(@PathVariable("tUserRedPacketRecordId") Integer tUserRedPacketRecordId) {
        return tUserRedPacketRecordService.selectById(tUserRedPacketRecordId);
    }


    /**
     * 导出
     */
    @RequestMapping(value = "/exportRecord")
    @ResponseBody
    public Object exportRecord(HttpServletResponse response, @RequestParam String createTime, @RequestParam String userName, @RequestParam String userPhone,
                               @RequestParam Integer couponActivityId, @RequestParam Integer state) {
        try {

            String beginTime = null;
            String endTime = null;
            if (SinataUtil.isNotEmpty(createTime)){
                String[] timeArray = createTime.split(" - ");
                beginTime = timeArray[0];
                endTime = timeArray[1];
            }

            Date date = new Date();
            DateFormat format = new SimpleDateFormat("yyyyMMdd");
            String time = format.format(date);
            String fileName = "红包领取记录"+time+".xls";
            String[] title = new String[] {"领取时间","领取人","领取人电话","领取金额","到期时间","状态","使用时间"};
            List<Map<String,Object>> mapList = userCouponRecordService.getRedListt(beginTime,endTime,userName,userPhone,couponActivityId,state);

            String[][] values = new String[mapList.size()][];
            for (int i = 0; i < mapList.size(); i++) {
                Map<String,Object> d=mapList.get(i);
                values[i] = new String[title.length];
                values[i][0]=d.get("insertTime").toString();
                values[i][1]=d.get("nickName").toString();
                if (ToolUtil.isNotEmpty(d.get("phone"))){
                    values[i][2]=d.get("phone").toString();
                }else {
                    values[i][2]="";
                }

                values[i][3]=d.get("money").toString();
                values[i][4]=d.get("expirationTime").toString();

                String stateStr =d.get("state").toString();
                switch (stateStr) {
                    case "0":
                        values[i][5] = "未使用";
                        break;
                    case "1":
                        values[i][5] = "已使用";
                        break;
                    case "2":
                        values[i][5] = "已过期";
                        break;
                    default:
                        values[i][5] = "";
                        break;
                }

                if (ToolUtil.isNotEmpty(d.get("useTime"))){
                    values[i][6]=d.get("useTime").toString();
                }else {
                    values[i][6]="";
                }
            }
            String fileNameTitle="红包领取记录";
            HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook(fileNameTitle+time, title, values, null);
            ExcelUtil.setResponseHeader(response, fileName);
            OutputStream os = response.getOutputStream();
            wb.write(os);
            os.flush();
            os.close();

        } catch (Exception e) {
            e.printStackTrace();
            /*return ApiUtil.putFailObj("导出失败");*/
        }
        return SUCCESS_TIP;
    }
}