package com.stylefeng.guns.modular.system.service.impl;
|
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.plugins.Page;
|
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.modular.system.dao.OrderCancelMapper;
|
import com.stylefeng.guns.modular.system.model.*;
|
import com.stylefeng.guns.modular.system.dao.TOrderTaxiMapper;
|
import com.stylefeng.guns.modular.system.service.*;
|
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
|
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.Service;
|
|
import javax.annotation.Resource;
|
import java.math.BigDecimal;
|
import java.text.DateFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 订单-出租车 服务实现类
|
* </p>
|
*
|
* @author 吕雪
|
* @since 2020-06-08
|
*/
|
@Service
|
public class TOrderTaxiServiceImpl extends ServiceImpl<TOrderTaxiMapper, TOrderTaxi> implements ITOrderTaxiService {
|
|
@Resource
|
private OrderCancelMapper orderCancelMapper;
|
|
@Autowired
|
private ITReassignService reassignService;
|
|
@Autowired
|
private ITCompanyService companyService;
|
|
@Autowired
|
private ITLineService lineService;
|
|
@Autowired
|
private IIncomeService incomeService;
|
|
|
|
@Override
|
public List<Map<String, Object>> getTaxiOrderList(Page<Map<String, Object>> page, String beginTime, String endTime, Integer roleType, Integer nowUserId, String orderNum, Integer orderSource, String userName, String userPhone, String passengers, String passengersPhone, String driver, Integer state) {
|
return this.baseMapper.getTaxiOrderList(page, beginTime, endTime, roleType, nowUserId, orderNum, orderSource, userName, userPhone, passengers, passengersPhone, driver, state);
|
}
|
|
@Override
|
public Map<String, Object> getTaxiOrderDetailById(Integer orderId) {
|
return this.baseMapper.getTaxiOrderDetailById(orderId);
|
}
|
|
@Override
|
public List<Map<String, Object>> getCanSelectTaxiDriverList(Page<Map<String, Object>> page,Integer companyId, String name, String phone) {
|
return this.baseMapper.getCanSelectTaxiDriverList(page,companyId, name, phone);
|
}
|
|
@Override
|
public Integer getAllOrderNum(Integer companyId, String beginTime, String endTime) {
|
return this.baseMapper.getAllOrderNum(companyId, beginTime, endTime);
|
}
|
|
@Override
|
public Double getAllTradeMoney(Integer companyId, String beginTime, String endTime) {
|
return this.baseMapper.getAllTradeMoney(companyId, beginTime, endTime);
|
}
|
|
@Override
|
public Double getAllIncomeMoney(Integer companyId, String beginTime, String endTime) {
|
return this.baseMapper.getAllIncomeMoney(companyId, beginTime, endTime);
|
}
|
|
@Override
|
public List<Map<String, Object>> getOrderList(Page<Map<String, Object>> page, String beginTime, String endTime, String userId, Integer type, String payType,Integer companyId) {
|
return this.baseMapper.getOrderList(page,beginTime,endTime,userId,type,payType,companyId);
|
}
|
|
@Override
|
public List<Map<String, Object>> getOrderListEx(String beginTime, String endTime, String userId, Integer type, String payType,Integer companyId) {
|
return this.baseMapper.getOrderListEx(beginTime,endTime,userId,type,payType,companyId);
|
}
|
|
|
@Override
|
public List<Map<String, Object>> getIncomeOrderList(Page<Map<String, Object>> page, String beginTime, String endTime, String phone, String name, Integer state, Integer type,Integer companyId, Integer income, Integer payType) {
|
List<Map<String, Object>> incomeOrderList = this.baseMapper.getIncomeOrderList(page, beginTime, endTime, phone, name, state, type, companyId, income, payType);
|
for (Map<String, Object> map : incomeOrderList) {
|
if(null != map.get("payType")){
|
switch (Integer.valueOf(map.get("payType").toString())){
|
case 1:
|
map.put("payTypeName", "微信");
|
break;
|
case 2:
|
map.put("payTypeName", "支付宝");
|
break;
|
case 3:
|
map.put("payTypeName", "余额支付");
|
break;
|
case 4:
|
map.put("payTypeName","云闪付");
|
break;
|
case 5:
|
map.put("payTypeName","扫码下单");
|
break;
|
}
|
}
|
|
|
Integer incomeType = Integer.valueOf(map.get("incomeType").toString());
|
Integer id = null != map.get("id") ? Integer.valueOf(map.get("id").toString()) : null;
|
if(null == id){
|
continue;
|
}
|
Integer orderType = Integer.valueOf(map.get("orderType").toString());
|
Double orderMoney = Double.valueOf(null == map.get("orderMoney") ? "0" : map.get("orderMoney").toString());
|
Integer companyId1 = Integer.valueOf(map.get("companyId").toString());
|
Income income1 = incomeService.selectOne(new EntityWrapper<Income>().eq("userType", 2).eq("type", 2)
|
.eq("incomeId", id).eq("orderType", orderType));
|
if(null != income1){
|
map.put("money", income1.getMoney());
|
}
|
|
|
// if(orderType == 3){//跨城计算
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// Integer lineId = Integer.valueOf(map.get("lineId").toString());
|
// TLine line = lineService.selectById(lineId);
|
// Double speMoney = Double.valueOf(line.getRakeRate());
|
// BigDecimal c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);//企业收入
|
// BigDecimal d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);//司机收入
|
// map.put("money", c);
|
// }
|
//
|
// if(orderType == 2){
|
// TCompany company = companyService.selectById(companyId1);
|
// Double speMoney = company.getTaxiMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsTaxiFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsTaxiFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
//
|
// if(orderType == 1){
|
// TCompany company = companyService.selectById(companyId1);
|
// Double speMoney = company.getSpeMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsSpeFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsSpeFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
//
|
// if(orderType == 4){
|
// TCompany company = companyService.selectById(companyId1);
|
// Double speMoney = company.getSameLogisticsMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsSameLogisticsFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsSameLogisticsFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
// if(orderType == 5){
|
// TCompany company = companyService.selectById(companyId1);
|
//
|
// Double speMoney = company.getCrossLogisticsMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsCrossLogisticsFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsCrossLogisticsFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
if(incomeType == 3){
|
OrderCancel query = orderCancelMapper.query(id, orderType, null, null, 2);
|
if(null != query){
|
switch (query.getPayType()){
|
case 1:
|
map.put("payTypeName", "微信");
|
break;
|
case 2:
|
map.put("payTypeName", "支付宝");
|
break;
|
case 3:
|
map.put("payTypeName", "余额支付");
|
break;
|
case 4:
|
map.put("payTypeName", "云闪付");
|
break;
|
}
|
map.put("other", query.getMoney());
|
}
|
}
|
if(incomeType == 4){
|
Integer driverId = Integer.valueOf(map.get("driverId").toString());
|
TReassign tReassign = reassignService.selectOne(new EntityWrapper<TReassign>().eq("orderType", orderType).eq("orderId", id)
|
.in("state", Arrays.asList(2, 3, 4, 5)).last(" and (originalDriverId = " + driverId + " or nowDriverId = " + driverId + ")"));
|
if(null != tReassign){
|
switch (Integer.valueOf(map.get("payTypes").toString())){
|
case 1:
|
map.put("payTypeName", "微信");
|
break;
|
case 2:
|
map.put("payTypeName", "支付宝");
|
break;
|
case 3:
|
map.put("payTypeName", "余额支付");
|
break;
|
case 4:
|
map.put("payTypeName", "云闪付");
|
break;
|
|
}
|
map.put("other", tReassign.getMoney());
|
}
|
}
|
}
|
return incomeOrderList;
|
}
|
|
@Override
|
public List<Map<String, Object>> getIncomeOrderListEx(String beginTime, String endTime, String phone, String name, Integer state, Integer type,Integer companyId, Integer income, Integer payType) {
|
List<Map<String, Object>> incomeOrderListEx = this.baseMapper.getIncomeOrderListEx(beginTime, endTime, phone, name, state, type, companyId, income, payType);
|
for (Map<String, Object> map : incomeOrderListEx) {
|
if(null != map.get("payType")){
|
switch (Integer.valueOf(map.get("payType").toString())){
|
case 1:
|
map.put("payTypeName", "微信");
|
break;
|
case 2:
|
map.put("payTypeName", "支付宝");
|
break;
|
case 3:
|
map.put("payTypeName", "余额支付");
|
break;
|
case 4:
|
map.put("payTypeName", "云闪付");
|
break;
|
case 5:
|
map.put("payTypeName", "扫码下单");
|
break;
|
}
|
}
|
|
Integer incomeType = Integer.valueOf(map.get("incomeType").toString());
|
Integer id = null != map.get("id") ? Integer.valueOf(map.get("id").toString()) : null;
|
if(null == id){
|
continue;
|
}
|
Integer orderType = Integer.valueOf(map.get("orderType").toString());
|
Double orderMoney = Double.valueOf(null == map.get("orderMoney") ? "0" : map.get("orderMoney").toString());
|
Integer companyId1 = Integer.valueOf(map.get("companyId").toString());
|
Income income1 = incomeService.selectOne(new EntityWrapper<Income>().eq("userType", 2).eq("type", 2)
|
.eq("incomeId", id).eq("orderType", orderType));
|
if(null != income1){
|
map.put("money", income1.getMoney());
|
}
|
// if(orderType == 3){//跨城计算
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// Integer lineId = Integer.valueOf(map.get("lineId").toString());
|
// TLine line = lineService.selectById(lineId);
|
// Double speMoney = Double.valueOf(line.getRakeRate());
|
// BigDecimal c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);//企业收入
|
// BigDecimal d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);//司机收入
|
// map.put("money", c);
|
// }
|
//
|
// if(orderType == 2){
|
// TCompany company = companyService.selectById(companyId1);
|
// Double speMoney = company.getTaxiMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsTaxiFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsTaxiFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
//
|
// if(orderType == 1){
|
// TCompany company = companyService.selectById(companyId1);
|
// Double speMoney = company.getSpeMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsSpeFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsSpeFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
//
|
// if(orderType == 4){
|
// TCompany company = companyService.selectById(companyId1);
|
// Double speMoney = company.getSameLogisticsMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsSameLogisticsFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsSameLogisticsFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
// if(orderType == 5){
|
// TCompany company = companyService.selectById(companyId1);
|
//
|
// Double speMoney = company.getCrossLogisticsMoney().doubleValue();
|
// BigDecimal d = null;//企业收入
|
// BigDecimal c = null;//司机收入
|
// // TODO: 2022/3/19 抽成按照订单金额计算，优先保证司机的收入，用户支付金额不够，则在平台收入中补贴司机收入
|
// //例如：订单金额10元，优惠3元，司机收入比例80%，平台收入比例20%。
|
// //司机收入：10 * 0.8 = 8
|
// //平台收入：7 - 8 = -1
|
// if(company.getIsCrossLogisticsFixedOrProportional() == 2){//固定
|
// d = new BigDecimal(speMoney.compareTo(orderMoney) > 0 ? orderMoney : speMoney);
|
// c = speMoney.compareTo(orderMoney) > 0 ? new BigDecimal(0) : new BigDecimal(orderMoney).subtract(d);//只有出行金额参与抽成，其余归属司机
|
// }
|
// if(company.getIsCrossLogisticsFixedOrProportional() == 1){//比例
|
// c = new BigDecimal(orderMoney).multiply(new BigDecimal(1 - (speMoney / 100))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// d = new BigDecimal(orderMoney).subtract(c).setScale(2, BigDecimal.ROUND_HALF_EVEN);
|
// }
|
// map.put("money", c);
|
// }
|
if(incomeType == 3){
|
OrderCancel query = orderCancelMapper.query(id, orderType, null, null, 2);
|
if(null != query){
|
switch (query.getPayType()){
|
case 1:
|
map.put("payTypeName", "微信");
|
break;
|
case 2:
|
map.put("payTypeName", "支付奥");
|
break;
|
case 3:
|
map.put("payTypeName", "余额支付");
|
break;
|
}
|
map.put("other", query.getMoney());
|
}
|
}
|
if(incomeType == 4){
|
Integer driverId = Integer.valueOf(map.get("driverId").toString());
|
TReassign tReassign = reassignService.selectOne(new EntityWrapper<TReassign>().eq("orderType", orderType).eq("orderId", id)
|
.in("state", Arrays.asList(2, 3, 4, 5)).last(" and (originalDriverId = " + driverId + " or nowDriverId = " + driverId + ")"));
|
if(null != tReassign){
|
switch (tReassign.getPayType()){
|
case 1:
|
map.put("payTypeName", "微信");
|
break;
|
case 2:
|
map.put("payTypeName", "支付宝");
|
break;
|
case 3:
|
map.put("payTypeName", "余额支付");
|
break;
|
}
|
map.put("other", tReassign.getMoney());
|
}
|
}
|
}
|
return incomeOrderListEx;
|
}
|
|
@Override
|
public Map<String, Object> getIncomeOrderSumMoney(String beginTime, String endTime, String phone, String name, Integer state, Integer type,Integer companyId, Integer income, Integer payType) {
|
return this.baseMapper.getIncomeOrderSumMoney(beginTime,endTime,phone,name,state,type,companyId, income, payType);
|
}
|
|
@Override
|
public List<Map<String, Object>> queryOtherIncomeDetail(Page<Map<String, Object>> page, String beginTime, String endTime, String orderNo, String name, String phone) {
|
Integer objectId = ShiroKit.getUser().getObjectId();
|
return this.baseMapper.queryOtherIncomeDetail(page, beginTime, endTime, orderNo, name, phone,objectId);
|
}
|
|
@Override
|
public HSSFWorkbook exportOtherIncomeDetail(String beginTime, String endTime, String orderNo, String name, String phone) {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time = format.format(date);
|
Integer objectId = ShiroKit.getUser().getObjectId();
|
List<Map<String, Object>> mapList = this.baseMapper.exportOtherIncomeDetail(beginTime, endTime, orderNo, name, phone,objectId);
|
String[] title = new String[] {"交易时间","订单号","下单用户昵称","下单用户手机号","感谢费"/*,"附加费"*/};
|
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]=null == d.get("nickName") ? "" : d.get("nickName").toString();
|
values[i][3]=null == d.get("phone") ? "" : d.get("phone").toString();
|
values[i][4]=null == d.get("thankYouFee") ? "0" : d.get("thankYouFee").toString();
|
// values[i][5]=null == d.get("additionalFee") ? "0" : d.get("additionalFee").toString();
|
}
|
String fileNameTitle="平台其他收入明细";
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbookTime(fileNameTitle+time, title, values, null, "");
|
return wb;
|
}
|
}
|
