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.shiro.ShiroKit;
|
import com.stylefeng.guns.core.util.ExcelUtil;
|
import com.stylefeng.guns.core.util.SinataUtil;
|
import com.stylefeng.guns.core.util.ToolUtil;
|
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.UserCouponRecord;
|
import com.stylefeng.guns.modular.system.service.IUserCouponRecordService;
|
|
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-06-17 09:15:18
|
*/
|
@Controller
|
@RequestMapping("/userCouponRecord")
|
public class UserCouponRecordController extends BaseController {
|
|
private String PREFIX = "/system/userCouponRecord/";
|
|
@Autowired
|
private IUserCouponRecordService userCouponRecordService;
|
|
/**
|
* 跳转到首页
|
*/
|
@RequestMapping("")
|
public String index( Model model,Integer couponActivityId,Integer activityType) {
|
model.addAttribute("activityType",activityType);
|
model.addAttribute("couponActivityId",couponActivityId);
|
return PREFIX + "userCouponRecord.html";
|
}
|
|
/**
|
* 跳转到添加
|
*/
|
@RequestMapping("/userCouponRecord_add")
|
public String userCouponRecordAdd() {
|
return PREFIX + "userCouponRecord_add.html";
|
}
|
|
/**
|
* 跳转到修改
|
*/
|
@RequestMapping("/userCouponRecord_update/{userCouponRecordId}")
|
public String userCouponRecordUpdate(@PathVariable Integer userCouponRecordId, Model model) {
|
UserCouponRecord userCouponRecord = userCouponRecordService.selectById(userCouponRecordId);
|
model.addAttribute("item",userCouponRecord);
|
LogObjectHolder.me().set(userCouponRecord);
|
return PREFIX + "userCouponRecord_edit.html";
|
}
|
|
/**
|
* 获取列表
|
*/
|
@RequestMapping(value = "/list")
|
@ResponseBody
|
public Object list(String createTime,String userName,String userPhone,Integer couponActivityId,Integer activityType,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.getList(page,beginTime,endTime,userName,userPhone,couponActivityId,activityType,state));
|
return super.packForBT(page);
|
}
|
|
/**
|
* 新增
|
*/
|
@RequestMapping(value = "/add")
|
@ResponseBody
|
public Object add(UserCouponRecord userCouponRecord) {
|
userCouponRecordService.insert(userCouponRecord);
|
return SUCCESS_TIP;
|
}
|
|
/**
|
* 删除
|
*/
|
@RequestMapping(value = "/delete")
|
@ResponseBody
|
public Object delete(@RequestParam Integer userCouponRecordId) {
|
userCouponRecordService.deleteById(userCouponRecordId);
|
return SUCCESS_TIP;
|
}
|
|
/**
|
* 修改
|
*/
|
@RequestMapping(value = "/update")
|
@ResponseBody
|
public Object update(UserCouponRecord userCouponRecord) {
|
userCouponRecordService.updateById(userCouponRecord);
|
return SUCCESS_TIP;
|
}
|
|
/**
|
* 详情
|
*/
|
@RequestMapping(value = "/detail/{userCouponRecordId}")
|
@ResponseBody
|
public Object detail(@PathVariable("userCouponRecordId") Integer userCouponRecordId) {
|
return userCouponRecordService.selectById(userCouponRecordId);
|
}
|
|
|
/**
|
* 导出
|
*/
|
@RequestMapping(value = "/exportRecord")
|
@ResponseBody
|
public Object exportRecord(HttpServletResponse response,@RequestParam String createTime,@RequestParam String userName,@RequestParam String userPhone,
|
@RequestParam Integer couponActivityId,@RequestParam Integer activityType,@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.getListt(beginTime,endTime,userName,userPhone,couponActivityId,activityType,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 couponUseType = d.get("couponUseType").toString();
|
switch (couponUseType) {
|
case "0":
|
values[i][5] = "通用券";
|
break;
|
case "1":
|
values[i][5] = "快车券";
|
break;
|
case "2":
|
values[i][5] = "出租券";
|
break;
|
case "3":
|
values[i][5] = "跨城出行券";
|
break;
|
default:
|
values[i][5] = "";
|
break;
|
}
|
|
String stateStr =d.get("state").toString();
|
switch (stateStr) {
|
case "0":
|
values[i][6] = "未使用";
|
break;
|
case "1":
|
values[i][6] = "已使用";
|
break;
|
case "2":
|
values[i][6] = "已过期";
|
break;
|
default:
|
values[i][6] = "";
|
break;
|
}
|
|
if (ToolUtil.isNotEmpty(d.get("useTime"))){
|
values[i][7]=d.get("useTime").toString();
|
}else {
|
values[i][7]="";
|
}
|
}
|
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;
|
}
|
}
|
