package com.stylefeng.guns.modular.system.controller.general;
|
|
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.mapper.Wrapper;
|
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.shiro.ShiroUser;
|
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.model.TBalanceModifyRecord;
|
import com.stylefeng.guns.modular.system.model.TCompany;
|
import com.stylefeng.guns.modular.system.service.*;
|
import com.stylefeng.guns.modular.system.util.ResultUtil;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.ui.Model;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestMethod;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.OutputStream;
|
import java.math.BigDecimal;
|
import java.net.URLEncoder;
|
import java.text.DateFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 报表控制器
|
*/
|
@Controller
|
@RequestMapping("/report")
|
public class ReportController extends BaseController {
|
|
private String PREFIX = "/system/report/";
|
|
@Autowired
|
private ITCompanyService companyService;
|
|
@Autowired
|
private IUserCouponRecordService userCouponRecordService;
|
|
@Autowired
|
private IUserRedPacketRecordService redPacketRecordService;
|
|
@Autowired
|
private IUserActivityDiscount1Service userActivityDiscount1Service;
|
|
|
@Autowired
|
private ITBalanceModifyRecordService balanceModifyRecordService;
|
|
|
@Autowired
|
private ITPubWithdrawalService tPubWithdrawalService;
|
|
@Autowired
|
private IComplaintDeductmoneyService complaintDeductmoneyService;
|
|
@Autowired
|
private ITTaxiCardPaymentService taxiCardPaymentService;
|
|
@Autowired
|
private ITOrderTaxiService orderTaxiService;
|
|
/**
|
* 跳转到用户管理首页
|
*/
|
@RequestMapping("user")
|
public String user() {
|
return PREFIX + "tUser.html";
|
}
|
|
/**
|
* 跳转到订单收益
|
* @return
|
*/
|
@RequestMapping("order")
|
public String order() {
|
return PREFIX + "order.html";
|
}
|
|
/**
|
* 跳转公司
|
* @return
|
*/
|
@RequestMapping("company")
|
public String company() {
|
return PREFIX + "tCompany.html";
|
}
|
|
/**
|
* 分公司收益
|
* @return
|
*/
|
@RequestMapping("companyIncome")
|
public String companyIncome() {
|
return PREFIX + "companyIncome.html";
|
}
|
|
|
@RequestMapping(value = "/orderList")
|
@ResponseBody
|
public Object orderList(String insertTime,
|
String ids,Integer type,String payType) {
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
/*if (ShiroKit.getUser().getRoleType() != 1){
|
page.setRecords(null);
|
}else{*/
|
ShiroUser user = ShiroKit.getUser();
|
List<Map<String,Object>> list = orderTaxiService.getOrderList(page,beginTime,endTime,ids,type,payType,user.getObjectId());
|
page.setRecords(list);
|
/* }*/
|
return super.packForBT(page);
|
}
|
|
|
@RequestMapping("/exportOrder")
|
@ResponseBody
|
public Object exportOrder(HttpServletResponse response, String insertTime,
|
String ids,Integer type,String payType){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
String fileName = "订单收益报表"+time+".xls";
|
String[] title = new String[] {"订单时间","订单号","订单类型"
|
,"支付方式","订单状态","司机名称","司机手机号","用户名称"
|
,"用户id","用户手机号","订单原始金额","乘客支付金额"
|
,"出行费","附加费","加价费","节假日服务费","取消费","改派费"
|
,"超时罚款","优惠金额","感谢费","小件物流差价费"
|
};
|
|
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
List<Map<String,Object>> mapList = orderTaxiService.getOrderListEx(beginTime,endTime,ids,type,payType,ShiroKit.getUser().getObjectId());
|
|
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]=null == d.get("insertTime") ? "" : d.get("insertTime").toString();
|
values[i][1]=null == d.get("orderNum") ? "" : d.get("orderNum").toString();
|
values[i][2]=d.get("type").toString().equals("1")?"快车":
|
d.get("type").toString().equals("2")?"出租车":
|
d.get("type").toString().equals("3")?"城际":
|
d.get("type").toString().equals("4")?"同城物流":"跨城物流";
|
if(null != d.get("payType")){
|
switch (d.get("payType").toString()){
|
case "1":
|
values[i][3]="微信";
|
break;
|
case "2":
|
values[i][3]="支付宝";
|
break;
|
case "3":
|
values[i][3]="其他";
|
break;
|
}
|
}else {
|
values[i][3]="";
|
}
|
if(null != d.get("state")){
|
switch (d.get("state").toString()){
|
case "1":
|
values[i][4]="待接单";
|
break;
|
case "2":
|
values[i][4]="待出发";
|
break;
|
case "3":
|
values[i][4]="待到达预约地点";
|
break;
|
case "4":
|
values[i][4]= (d.get("type").toString().equals("4") || d.get("type").toString().equals("5")) ? "待取货" : "待乘客上车";
|
break;
|
case "5":
|
values[i][4]= (d.get("type").toString().equals("4") || d.get("type").toString().equals("5")) ? "送货中" : "服务中";
|
break;
|
case "6":
|
values[i][4]= (d.get("type").toString().equals("4") || d.get("type").toString().equals("5")) ? "已送达" : "完成服务";
|
break;
|
case "7":
|
values[i][4]="待支付";
|
break;
|
case "8":
|
values[i][4]= (d.get("type").toString().equals("4") || d.get("type").toString().equals("5")) ? "需补差价" : "待评价";
|
break;
|
case "9":
|
values[i][4]= (d.get("type").toString().equals("4") || d.get("type").toString().equals("5")) ? "已取货" : "已完成";
|
break;
|
case "10":
|
values[i][4]="已取消";
|
break;
|
case "11":
|
values[i][4]="改派中";
|
break;
|
case "12":
|
values[i][4]= (d.get("type").toString().equals("4") || d.get("type").toString().equals("5")) ? "已支付差价" : "取消待支付";
|
break;
|
}
|
}else{
|
values[i][4]="";
|
}
|
values[i][5]=null == d.get("driverName") ? "" : d.get("driverName").toString();
|
values[i][6]=null == d.get("driverPhone") ? "" : d.get("driverPhone").toString();
|
values[i][7]=null == d.get("userName") ? "" : d.get("userName").toString();
|
values[i][8]=null == d.get("userId") ? "" : d.get("userId").toString();
|
values[i][9]=null == d.get("userPhone") ? "" : d.get("userPhone").toString();
|
values[i][10]=null == d.get("orderMoney") ? "0" : "10".equals(d.get("state").toString()) ? "0" : new BigDecimal(d.get("orderMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][11]=null == d.get("payMoney") ? "0" : "10".equals(d.get("state").toString()) ? "0" : new BigDecimal(d.get("payMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][12]=null == d.get("travelMoney") ? "0" : new BigDecimal(d.get("travelMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][13]=null == d.get("additionalMoney") ? "0" : new BigDecimal(d.get("additionalMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][14]=null == d.get("tipMoney") ? "0" : new BigDecimal(d.get("tipMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][15]=null == d.get("holidayFee") ? "0" : new BigDecimal(d.get("holidayFee").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][16]=null == d.get("cancleMoney") ? "0" : new BigDecimal(d.get("cancleMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][17]=null == d.get("reassignMoney") ? "0" : new BigDecimal(d.get("reassignMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][18]=null == d.get("timeOutMoney") ? "0" : new BigDecimal(d.get("timeOutMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][19]=null == d.get("discountAmount") ? "0" : new BigDecimal(d.get("discountAmount").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][20]=null == d.get("thankYouFee") ? "0" : new BigDecimal(d.get("thankYouFee").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
values[i][21]=null == d.get("spreadMoney") ? "0" : new BigDecimal(d.get("spreadMoney").toString()).setScale(2, BigDecimal.ROUND_HALF_EVEN).toString();
|
}
|
String fileNameTitle="订单收益报表";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime);
|
this.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;
|
}
|
|
@RequestMapping(value = "/companyIncomeList")
|
@ResponseBody
|
public Object companyIncomeList(String insertTime,
|
String ids) {
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
if (ShiroKit.getUser().getRoleType() != 1){
|
page.setRecords(null);
|
}else{
|
|
List<Map<String,Object>> list = companyService.getCompanyIncomeList(page,beginTime,endTime,ids);
|
Map<String,Object> map = new HashMap<>();
|
map.put("id","合计");
|
map.put("money",companyService.getSumCompanyIncomeMoney(beginTime,endTime,ids));
|
list.add(map);
|
page.setRecords(list);
|
}
|
return super.packForBT(page);
|
}
|
|
|
@RequestMapping("/exportCompanyIncome")
|
@ResponseBody
|
public Object exportCompanyIncome(HttpServletResponse response, String insertTime, @RequestParam String ids){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
String fileName = "分公司收益"+time+".xls";
|
String[] title = new String[] {"id","公司名称","收益金额"};
|
|
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
List<Map<String,Object>> mapList = companyService.getCompanyIncomeListEx(beginTime,endTime,ids);
|
|
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("id").toString();
|
values[i][1]=d.get("name").toString();
|
values[i][2]=d.get("money").toString();
|
}
|
String fileNameTitle="分公司收益";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime);
|
this.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;
|
}
|
|
/**
|
* 跳转司机管理页面
|
* @return
|
*/
|
@RequestMapping("driver")
|
public String driver() {
|
return PREFIX + "tDriver.html";
|
}
|
|
/**
|
* 打车卡
|
* @return
|
*/
|
@RequestMapping("/taxiCardPayment")
|
public String taxiCardPayment() {
|
return PREFIX + "taxiCardPayment.html";
|
}
|
@RequestMapping(value = "/taxiCardPaymentList")
|
@ResponseBody
|
public Object taxiCardPaymentList(String insertTime,
|
String ids,String type) {
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
|
List<Map<String,Object>> list = taxiCardPaymentService.getList(page,beginTime,endTime,ids,type,null,null,null,null,ShiroKit.getUser().getObjectId());
|
Map<String,Object> map = new HashMap<>();
|
map.put("id","合计");
|
map.put("payMoney",taxiCardPaymentService.getSumMoney(beginTime,endTime,ids,type,null,null,null,null,ShiroKit.getUser().getObjectId()));
|
list.add(map);
|
page.setRecords(list);
|
return super.packForBT(page);
|
}
|
|
|
@RequestMapping("/exportTaxiCardPayment")
|
@ResponseBody
|
public Object exportTaxiCardPaymentList(HttpServletResponse response, String insertTime, @RequestParam String ids,String type){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
String fileName = "打车卡"+time+".xls";
|
String[] title = new String[] {"支付时间","乘客名称","乘客电话","订单ID","打车卡类型","用户支付金额"};
|
|
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
List<Map<String,Object>> mapList = taxiCardPaymentService.getListEx(beginTime,endTime,ids,type,null,null,null,null,ShiroKit.getUser().getObjectId());
|
|
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("createTime").toString();
|
values[i][1]=d.get("nickName").toString();
|
values[i][2]=d.get("phone").toString();
|
values[i][3]=d.get("id").toString();
|
values[i][4]=d.get("typeName").toString();
|
values[i][5]=d.get("payMoney").toString();
|
}
|
String fileNameTitle="打车卡";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime);
|
this.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;
|
}
|
/**
|
* 跳转投诉扣款
|
* @return
|
*/
|
@RequestMapping("/complaintDeductmoney")
|
public String complaintDeductmoney() {
|
return PREFIX + "complaintDeductmoney.html";
|
}
|
|
@RequestMapping(value = "/complaintDeductmoneyList")
|
@ResponseBody
|
public Object complaintDeductmoneyList(String insertTime,
|
String ids) {
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
if (ShiroKit.getUser().getRoleType() != 1){
|
page.setRecords(null);
|
}else{
|
|
List<Map<String,Object>> list = complaintDeductmoneyService.getList(page,beginTime,endTime,ids,null,null,null,ShiroKit.getUser().getObjectId());
|
Map<String,Object> map = new HashMap<>();
|
map.put("id","合计");
|
map.put("money",complaintDeductmoneyService.getSumMoney(beginTime,endTime,ids,null,null,null,ShiroKit.getUser().getObjectId()));
|
list.add(map);
|
page.setRecords(list);
|
}
|
return super.packForBT(page);
|
}
|
|
|
@RequestMapping("/exportComplaintDeductmoney")
|
@ResponseBody
|
public Object exportComplaintDeductmoney(HttpServletResponse response, String insertTime, @RequestParam String ids){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
String fileName = "投诉扣款"+time+".xls";
|
String[] title = new String[] {"司机名称","处罚时间","司机电话","投诉扣款"};
|
|
Wrapper wrapper = new EntityWrapper<TBalanceModifyRecord>();
|
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
List<Map<String,Object>> mapList = complaintDeductmoneyService.getListEx(beginTime,endTime,ids,null,null,null,ShiroKit.getUser().getObjectId());
|
|
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("name").toString();
|
values[i][1]=d.get("createTime").toString();
|
values[i][2]=d.get("phone").toString();
|
values[i][3]=d.get("money").toString();
|
}
|
String fileNameTitle="投诉扣款";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime);
|
this.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;
|
}
|
|
/**
|
* 投诉扣款
|
* @return
|
*/
|
@RequestMapping("/balanceModify")
|
public String balanceModifyIndex() {
|
return PREFIX + "balanceModify.html";
|
}
|
|
/**
|
* 跳转到提现列表首页
|
*/
|
@RequestMapping("withdrawal")
|
public String withdrawal() {
|
return PREFIX + "tPubWithdrawal.html";
|
}
|
/**
|
* 获取提现列表列表
|
*/
|
@RequestMapping(value = "/withdrawalList")
|
@ResponseBody
|
public Object withdrawalList(String insertTime,
|
String ids) {
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
if (ShiroKit.getUser().getRoleType() != 1){
|
page.setRecords(null);
|
}else{
|
|
List<Map<String,Object>> list = tPubWithdrawalService.getReportWithdrawalList(page,beginTime,endTime,ids);
|
Map<String,Object> map = tPubWithdrawalService.getSumMoney(beginTime,endTime,ids);
|
if(map!=null){
|
map.put("id","合计");
|
list.add(map);
|
}
|
page.setRecords(list);
|
}
|
return super.packForBT(page);
|
}
|
|
|
@RequestMapping("/exportWithdrawal")
|
@ResponseBody
|
public Object exportWithdrawal(HttpServletResponse response, String insertTime, @RequestParam String ids){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
String fileName = "司机提现"+time+".xls";
|
String[] title = new String[] {"司机名称","提现时间","提现金额","提现扣除手续费"};
|
|
Wrapper wrapper = new EntityWrapper<TBalanceModifyRecord>();
|
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(insertTime)){
|
String[] timeArray = insertTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
List<Map<String,Object>> mapList = tPubWithdrawalService.getReportWithdrawalListEx(beginTime,endTime,ids);
|
|
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("userName").toString();
|
values[i][1]=d.get("insertTime").toString();
|
values[i][2]=d.get("money").toString();
|
values[i][3]=(Double.parseDouble(d.get("money").toString())-Double.parseDouble(d.get("realGetMoney").toString()))+"";
|
}
|
String fileNameTitle="司机提现";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,insertTime);
|
this.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;
|
}
|
|
/**
|
* 余额修改记录列表
|
* @return
|
*/
|
@RequestMapping("/balanceModifylist")
|
@ResponseBody
|
public Object balanceModifylist(String userId, String startTime, String endTime) {
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
Wrapper wrapper = new EntityWrapper<TBalanceModifyRecord>();
|
wrapper.eq("1",1);
|
if (ToolUtil.isNotEmpty(userId)){
|
wrapper.last(" and find_in_set(userId,\""+ userId+"\")");
|
}
|
if (ToolUtil.isNotEmpty(startTime) && ToolUtil.isNotEmpty(endTime)){
|
wrapper.between("createTime",startTime + " 00:00:00",endTime + " 23:59:59");
|
}
|
List<Map<String,Object>> list = balanceModifyRecordService.selectMapsPage(page,wrapper).getRecords();
|
Map<String,Object> map = new HashMap<>();
|
map.put("id","合计");
|
map.put("money",balanceModifyRecordService.getSumMoney(userId,ToolUtil.isEmpty(startTime)?null:startTime + " 00:00:00",ToolUtil.isEmpty(startTime)?null:endTime + " 23:59:59"));
|
list.add(map);
|
page.setRecords(list);
|
return super.packForBT(page);
|
}
|
|
/**
|
* 导出用户余额修改记录
|
* @param response
|
* @param userId
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
@RequestMapping("/exportRecordBalanceModify")
|
@ResponseBody
|
public Object exportRecordBalanceModify(HttpServletResponse response, @RequestParam String userId,
|
@RequestParam String startTime, @RequestParam String endTime){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
String fileName = "余额修改记录"+time+".xls";
|
String[] title = new String[] {"修改时间","流水ID","用户ID","用户名称","用户手机号","金额","类型"};
|
|
Wrapper wrapper = new EntityWrapper<TBalanceModifyRecord>();
|
|
wrapper.eq("1",1);
|
if (ToolUtil.isNotEmpty(userId)){
|
wrapper.last(" and find_in_set(userId,\""+ userId+"\")");
|
}
|
String searchTime="";
|
if (ToolUtil.isNotEmpty(startTime) && ToolUtil.isNotEmpty(endTime)){
|
searchTime=startTime+" - "+endTime;
|
wrapper.between("createTime",startTime + " 00:00:00",endTime + " 23:59:59");
|
}
|
List<Map<String,Object>> mapList = balanceModifyRecordService.selectMaps(wrapper);
|
for (Map<String, Object> map : mapList) {
|
if (map.get("type").toString().equals("1")){
|
map.put("typeStr","增加");
|
}else if (map.get("type").toString().equals("2")){
|
map.put("typeStr","减少");
|
}
|
}
|
|
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("createTime").toString();
|
values[i][1]=d.get("recordID").toString();
|
values[i][2]=d.get("userId").toString();
|
if (ToolUtil.isNotEmpty(d.get("userName"))){
|
values[i][3]=d.get("userName").toString();
|
}else {
|
values[i][3]="";
|
}
|
if (ToolUtil.isNotEmpty(d.get("phone"))){
|
values[i][4]=d.get("phone").toString();
|
}else {
|
values[i][4]="";
|
}
|
values[i][5]=d.get("money").toString();
|
values[i][6]=d.get("typeStr").toString();
|
}
|
String fileNameTitle="余额修改记录";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null,searchTime);
|
this.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;
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
/**
|
* 跳转到日常运营数据汇总页
|
* @return
|
*/
|
@RequestMapping("/showOperationalData")
|
public String showOperationalData(Model model){
|
List<TCompany> tCompanies = companyService.selectList(new EntityWrapper<TCompany>().eq("state", 0).ne("flag", 3));
|
model.addAttribute("company", tCompanies);
|
return PREFIX + "operationalData.html";
|
}
|
|
/**
|
* 跳转到优惠券统计页
|
* @param model
|
* @return
|
*/
|
@RequestMapping("/showCouponStatistics")
|
public String showCouponStatistics(Model model){
|
List<TCompany> tCompanies = companyService.selectList(new EntityWrapper<TCompany>().eq("state", 0).ne("flag", 3));
|
model.addAttribute("company", tCompanies);
|
return PREFIX + "couponStatistics.html";
|
}
|
|
/**
|
* 跳转到优惠券统计详情页
|
* @param type
|
* @param model
|
* @return
|
*/
|
@RequestMapping("/showCouponStatisticsInfo")
|
public String showCouponStatisticsInfo(Integer type, Model model){
|
List<TCompany> tCompanies = companyService.selectList(new EntityWrapper<TCompany>().eq("state", 0).ne("flag", 3));
|
model.addAttribute("company", tCompanies);
|
model.addAttribute("type", type);
|
return PREFIX + "couponStatisticsInfo.html";
|
}
|
|
|
|
|
|
|
/**
|
* 获取日常运营数据
|
* @param type
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryOperationalData", method = RequestMethod.POST)
|
public Object queryOperationalData(Integer type, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
String start = null;
|
String end = null;
|
if(ToolUtil.isNotEmpty(time)){
|
start = time.split(" - ")[0];
|
end = time.split(" - ")[1];
|
}
|
return companyService.queryOperationalData(type, start, end, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
/**
|
* 下载日常运营数据汇总表
|
* @param type
|
* @param time
|
* @param companyId
|
* @param response
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/downloadOperationalData", method = RequestMethod.GET)
|
public void downloadOperationalData(Integer type, String time, Integer companyId, HttpServletResponse response){
|
try {
|
String start = null;
|
String end = null;
|
if(ToolUtil.isNotEmpty(time)){
|
start = time.split(" - ")[0];
|
end = time.split(" - ")[1];
|
}
|
HSSFWorkbook hssfWorkbook = companyService.downloadOperationalData(type, start, end, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("日常运营数据汇总表.xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
}
|
|
|
/**
|
* 获取优惠券统计
|
* @param type
|
* @param name
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryCouponRegister", method = RequestMethod.POST)
|
public Object queryCouponRegister(Integer type, String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
return userCouponRecordService.queryCouponRegister(type, name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
/**
|
* 下载优惠券领取数据
|
* @param type
|
* @param name
|
* @param time
|
* @param companyId
|
* @param response
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/downloadCouponRegister", method = RequestMethod.GET)
|
public void downloadCouponRegister(Integer type, String name, String time, Integer companyId, HttpServletResponse response){
|
try {
|
String na = "";
|
if(type == 2){
|
na = "注册优惠券奖励";
|
}
|
if(type == 3){
|
na = "邀请优惠券奖励";
|
}
|
if(type == 4){
|
na = "充值优惠券奖励";
|
}
|
HSSFWorkbook hssfWorkbook = userCouponRecordService.downloadCouponRegister(type, name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(na + ".xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
}
|
|
|
/**
|
* 获取红包统计数据
|
* @param name
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryRedEnvelopes", method = RequestMethod.POST)
|
public Object queryRedEnvelopes(String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
return redPacketRecordService.queryRedEnvelopes(name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
|
/**
|
* 下载红包奖励
|
* @param name
|
* @param time
|
* @param companyId
|
* @param response
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/downloadRedEnvelopes", method = RequestMethod.GET)
|
public void downloadRedEnvelopes(String name, String time, Integer companyId, HttpServletResponse response){
|
try {
|
HSSFWorkbook hssfWorkbook = redPacketRecordService.downloadRedEnvelopes(name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("红包奖励.xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
}
|
|
|
|
/**
|
* 获取折扣统计
|
* @param name
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryDiscount1", method = RequestMethod.POST)
|
public Object queryDiscount1(String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
return userActivityDiscount1Service.queryDiscount1(name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
/**
|
* 下载折扣优惠活动
|
* @param name
|
* @param time
|
* @param companyId
|
* @param response
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/downloadDiscount1", method = RequestMethod.GET)
|
public void downloadDiscount1(String name, String time, Integer companyId, HttpServletResponse response){
|
try {
|
HSSFWorkbook hssfWorkbook = userActivityDiscount1Service.downloadDiscount1(name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("折扣优惠活动.xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
}
|
|
/**
|
* 获取优惠券统计明细
|
* @param type
|
* @param name
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryCouponRegisterInfo", method = RequestMethod.POST)
|
public Object queryCouponRegisterInfo(Integer type, String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
type += 1;
|
return userCouponRecordService.queryCouponRegisterInfo(type, name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
|
|
|
/**
|
* 获取充值赠送优惠券明细
|
* @param name
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryCouponRegisterInfo1", method = RequestMethod.POST)
|
public Object queryCouponRegisterInfo1(String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
return userCouponRecordService.queryCouponRegisterInfo1( name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
|
/**
|
* 获取折扣优惠详情
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryDiscountInfo", method = RequestMethod.POST)
|
public Object queryDiscountInfo(String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
return userActivityDiscount1Service.queryDiscountInfo(name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
|
|
|
/**
|
* 获取红包领取详情
|
* @param name
|
* @param time
|
* @param companyId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryRedEnvelopesInfo", method = RequestMethod.POST)
|
public Object queryRedEnvelopesInfo(String name, String time, Integer companyId, Integer offset, Integer limit){
|
try {
|
return redPacketRecordService.queryRedEnvelopesInfo(name, time, companyId, offset, limit);
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
|
/**
|
* 优惠明细下载
|
* @param type
|
* @param name
|
* @param time
|
* @param companyId
|
* @param response
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/downloadCouponStatisticsInfo", method = RequestMethod.GET)
|
public void downloadCouponStatisticsInfo(Integer type, String name, String time, Integer companyId, HttpServletResponse response){
|
try {
|
if(type == 1 || type == 2){
|
type += 1;
|
HSSFWorkbook hssfWorkbook = userCouponRecordService.downloadCouponRegisterInfo(type, name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode((type == 2 ? "注册奖励明细" : "邀请奖励明细") + ".xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}
|
if(type == 3){
|
HSSFWorkbook hssfWorkbook = userCouponRecordService.downloadCouponRegisterInfo1(name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("充值奖励明细.xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}
|
if(type == 4){
|
HSSFWorkbook hssfWorkbook = userActivityDiscount1Service.downloadDiscountInfo(name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("折扣优惠明细.xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}
|
if(type == 5){
|
HSSFWorkbook hssfWorkbook = redPacketRecordService.downloadRedEnvelopesInfo(name, time, companyId);
|
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("红包优惠明细.xls", "utf-8"));
|
response.setContentType("application/vnd.ms-excel");
|
ServletOutputStream out = response.getOutputStream();
|
hssfWorkbook.write(out);
|
out.flush();
|
out.close();
|
}
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
}
|
|
|
/**
|
* 设置文件响应头
|
* @param response
|
* @param fileName
|
*/
|
private void setResponseHeader(HttpServletResponse response, String fileName) {
|
try {
|
response.setContentType("application/octet-stream;charset=UTF-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
|
response.addHeader("Pargam", "no-cache");
|
response.addHeader("Cache-Control", "no-cache");
|
} catch (Exception ex) {
|
ex.printStackTrace();
|
}
|
}
|
}
|
