| | |
| | | package com.stylefeng.guns.modular.system.service.impl; |
| | | |
| | | 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.ToolUtil; |
| | | import com.stylefeng.guns.modular.system.model.DriverActivityHistory; |
| | | import com.stylefeng.guns.modular.system.dao.DriverActivityHistoryMapper; |
| | | import com.stylefeng.guns.modular.system.service.IDriverActivityHistoryService; |
| | | import com.baomidou.mybatisplus.service.impl.ServiceImpl; |
| | | import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | |
| | | @Override |
| | | public List<Map<String, Object>> getList(Page<Map<String, Object>> page, Integer activityId, Integer type) { |
| | | return this.baseMapper.getList(page,activityId,type); |
| | | } |
| | | |
| | | @Override |
| | | public List<Map<String, Object>> getListt(Integer activityId, Integer type) { |
| | | return this.baseMapper.getListt(activityId, type); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public Map<String, Object> rewardDetailsList(String driverName, String driverPhone, String createTime, Integer offset, Integer limit) throws Exception { |
| | | String startTime = ""; |
| | | String endTime = ""; |
| | | if(ToolUtil.isNotEmpty(createTime)){ |
| | | String[] split = createTime.split(" - "); |
| | | startTime = split[0]; |
| | | endTime = split[1]; |
| | | } |
| | | List<Map<String, Object>> list = this.baseMapper.rewardDetailsList(ShiroKit.getUser().getObjectId(), driverName, driverPhone, startTime, endTime, offset, limit); |
| | | int count = this.baseMapper.rewardDetailsListCount(ShiroKit.getUser().getObjectId(), driverName, driverPhone, startTime, endTime); |
| | | Double aDouble = this.baseMapper.rewardDetailsListSum(ShiroKit.getUser().getObjectId(), driverName, driverPhone, startTime, endTime); |
| | | Map<String, Object> map1 = new HashMap<>(); |
| | | map1.put("insertTime", "合计"); |
| | | map1.put("money", aDouble); |
| | | list.add(map1); |
| | | |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("rows", list); |
| | | map.put("total", count); |
| | | return map; |
| | | } |
| | | |
| | | @Override |
| | | public HSSFWorkbook exportRewardDetails(String driverName, String driverPhone, String createTime) throws Exception { |
| | | String startTime = ""; |
| | | String endTime = ""; |
| | | if(ToolUtil.isNotEmpty(createTime)){ |
| | | String[] split = createTime.split(" - "); |
| | | startTime = split[0]; |
| | | endTime = split[1]; |
| | | } |
| | | List<Map<String, Object>> list = this.baseMapper.rewardDetailsList(ShiroKit.getUser().getObjectId(), driverName, driverPhone, startTime, endTime, null, null); |
| | | String[] title = new String[]{"时间", "司机名称", "活动名称", "活动总收益"}; |
| | | String[][] values = new String[list.size()][5]; |
| | | for (int i = 0; i < list.size(); i++) { |
| | | Map<String, Object> map = list.get(i); |
| | | values[i][0] = null != map.get("insertTime") ? map.get("insertTime").toString() : ""; |
| | | values[i][1] = null != map.get("name") ? map.get("name").toString() : ""; |
| | | values[i][2] = null != map.get("activityName") ? map.get("activityName").toString() : ""; |
| | | values[i][3] = null != map.get("money") ? map.get("money").toString() : ""; |
| | | } |
| | | |
| | | return ExcelUtil.getHSSFWorkbook("奖励明细", title, values, null); |
| | | } |
| | | } |