Merge remote-tracking branch 'origin/master'
| | |
| | | (select count(id) from t_order_logistics where driverId = a.id and state in (6, 9)) |
| | | ) as orderNum, |
| | | ((select sum(fraction) from t_order_evaluate where driverId = a.id) / (select count(fraction) from t_order_evaluate where driverId = a.id)) as score, |
| | | if((select id from t_merchant where auditStatus = 2 and userType = 2 and userId = a.id and state = 1) is null, 0, 1) as merchant |
| | | if((select id from t_merchant where auditStatus = 2 and userType = 2 and userId = a.id and state = 1) is null, 0, 1) as merchant, |
| | | a.companyId as companyId, |
| | | e.name as companyName |
| | | from t_driver a |
| | | left join t_car b on (a.carId = b.id) |
| | | left join t_car_model c on (b.carModelId = c.id) |
| | | left join t_car_brand d on (c.brandId = d.id) |
| | | left join t_company e on (a.companyId = e.id) |
| | | where a.id = #{uid} |
| | | </select> |
| | | |
| | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import java.math.BigDecimal; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDateTime; |
| | | import java.time.LocalDate; |
| | | import java.util.*; |
| | | import java.util.concurrent.TimeUnit; |
| | | |
| | |
| | | driver.setProvince(registeredWarpper.getProvince()); |
| | | driver.setProvinceCode(registeredWarpper.getProvinceCode()); |
| | | driver.setCompanyId(registeredWarpper.getCompanyId()); |
| | | if(registeredWarpper.getCompanyId()==null){ |
| | | return ResultUtil.error("请选择服务商"); |
| | | } |
| | | |
| | | String code = registeredWarpper.getAreaCode(); |
| | | Company query = companyCityService.query(code); |
| | |
| | | public DriverIndexVo queryHomeDataFromDriver(Integer uid) { |
| | | DriverIndexVo driverIndexVo = new DriverIndexVo(); |
| | | // 获取快车订单 |
| | | List<OrderPrivateCar> orderPrivateCars = orderPrivateCarMapper.selectList(new EntityWrapper<OrderPrivateCar>().ne("state", 10).eq("driverId", uid).like("insertTime", LocalDateTime.now().toString())); |
| | | List<OrderPrivateCar> orderPrivateCars = orderPrivateCarMapper.selectList(new EntityWrapper<OrderPrivateCar>().ne("state", 10).eq("driverId", uid).like("insertTime", LocalDate.now().toString())); |
| | | // 跨城订单 |
| | | List<OrderCrossCity> orderCrossCities = orderCrossCityMapper.selectList(new EntityWrapper<OrderCrossCity>().ne("state", 10).eq("driverId", uid).like("insertTime", LocalDateTime.now().toString())); |
| | | List<OrderCrossCity> orderCrossCities = orderCrossCityMapper.selectList(new EntityWrapper<OrderCrossCity>().ne("state", 10).eq("driverId", uid).like("insertTime", LocalDate.now().toString())); |
| | | // 出租车订单 |
| | | List<OrderTaxi> orderTaxis = orderTaxiMapper.selectList(new EntityWrapper<OrderTaxi>().ne("state", 10).eq("driverId", uid).like("insertTime", LocalDateTime.now().toString())); |
| | | List<OrderTaxi> orderTaxis = orderTaxiMapper.selectList(new EntityWrapper<OrderTaxi>().ne("state", 10).eq("driverId", uid).like("insertTime", LocalDate.now().toString())); |
| | | driverIndexVo.setTodayOrderNum(orderPrivateCars.size() + orderCrossCities.size() + orderTaxis.size()); |
| | | |
| | | |
| | |
| | | driverIndexVo.setTodayOrderMoney(new BigDecimal(sum +sum1+sum2)); |
| | | |
| | | |
| | | BigDecimal reduce = orderPrivateCarMapper.selectList(new EntityWrapper<OrderPrivateCar>().eq("promotionDriverId", uid).like("insertTime", LocalDateTime.now().toString())).stream().map(OrderPrivateCar::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal reduce1 = orderCrossCityMapper.selectList(new EntityWrapper<OrderCrossCity>().eq("promotionDriverId", uid).like("insertTime", LocalDateTime.now().toString())).stream().map(OrderCrossCity::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal reduce2 = orderTaxiMapper.selectList(new EntityWrapper<OrderTaxi>().eq("promotionDriverId", uid).like("insertTime", LocalDateTime.now().toString())).stream().map(OrderTaxi::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal reduce = orderPrivateCarMapper.selectList(new EntityWrapper<OrderPrivateCar>().eq("promotionDriverId", uid).like("insertTime", LocalDate.now().toString())).stream().map(OrderPrivateCar::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal reduce1 = orderCrossCityMapper.selectList(new EntityWrapper<OrderCrossCity>().eq("promotionDriverId", uid).like("insertTime", LocalDate.now().toString())).stream().map(OrderCrossCity::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal reduce2 = orderTaxiMapper.selectList(new EntityWrapper<OrderTaxi>().eq("promotionDriverId", uid).like("insertTime", LocalDate.now().toString())).stream().map(OrderTaxi::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | driverIndexVo.setTodayPromotionMoney(reduce.add(reduce1).add(reduce2)); |
| | | return driverIndexVo; |
| | | }; |
| | |
| | | List<OrderTaxi> orderTaxis = orderTaxiMapper.selectList(new EntityWrapper<OrderTaxi>().ne("state", 10).eq("driverId", uid)); |
| | | DriverOrderDataVo driverOrderDataVo = new DriverOrderDataVo(); |
| | | driverOrderDataVo.setAllOrderNum(orderPrivateCars.size() + orderCrossCities.size() + orderTaxis.size()); |
| | | long count = orderPrivateCars.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).count(); |
| | | long count1 = orderCrossCities.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).count(); |
| | | long count2 = orderTaxis.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).count(); |
| | | long count = orderPrivateCars.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).count(); |
| | | long count1 = orderCrossCities.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).count(); |
| | | long count2 = orderTaxis.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).count(); |
| | | driverOrderDataVo.setTodayOrderNum((int) (count+count1+count2)); |
| | | |
| | | Date date = new Date(); |
| | |
| | | |
| | | |
| | | |
| | | double count = orderPrivateCars.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).mapToDouble(OrderPrivateCar::getOrderMoney).sum(); |
| | | double count1 = orderCrossCities.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).mapToDouble(OrderCrossCity::getOrderMoney).sum(); |
| | | double count2 = orderTaxis.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).mapToDouble(OrderTaxi::getOrderMoney).sum(); |
| | | double count = orderPrivateCars.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).mapToDouble(OrderPrivateCar::getOrderMoney).sum(); |
| | | double count1 = orderCrossCities.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).mapToDouble(OrderCrossCity::getOrderMoney).sum(); |
| | | double count2 = orderTaxis.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).mapToDouble(OrderTaxi::getOrderMoney).sum(); |
| | | driverOrderDataVo.setTodayOrderMoney(new BigDecimal(count+count1+count2)); |
| | | |
| | | |
| | |
| | | |
| | | |
| | | |
| | | BigDecimal count = orderPrivateCars.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).map(OrderPrivateCar::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal count1 = orderCrossCities.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).map(OrderCrossCity::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal count2 = orderTaxis.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDateTime.now().toString())).map(OrderTaxi::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal count = orderPrivateCars.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).map(OrderPrivateCar::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal count1 = orderCrossCities.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).map(OrderCrossCity::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | BigDecimal count2 = orderTaxis.stream().filter(e -> simpleDateFormat.format(e.getInsertTime()).equals(LocalDate.now().toString())).map(OrderTaxi::getPromotionMoney).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | driverOrderDataVo.setTodayOrderMoney(count.add(count1).add(count2)); |
| | | |
| | | |
| | |
| | | model.addAttribute("driverId",id); |
| | | return PREFIX + "tDriverPromotionActivityUser.html"; |
| | | } |
| | | @RequestMapping("/tDriverPromotionActivity_viewMoney/{id}") |
| | | public String tDriverPromotionActivityViewMoney(@PathVariable Integer id, Model model) { |
| | | @RequestMapping("/tDriverPromotionActivity_viewMoney/{id}/{activityId}") |
| | | public String tDriverPromotionActivityViewMoney(@PathVariable Integer id,@PathVariable Integer activityId, Model model) { |
| | | List<Map<String, Object>> list=new ArrayList<>(); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, null, null, null, null, null, null, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),id); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, null, null, null, null, null, null, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),id,activityId); |
| | | BigDecimal reduce = list.stream().map(e -> new BigDecimal(e.get("promotionMoney").toString())).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | model.addAttribute("money",reduce); |
| | | model.addAttribute("size",list.size()); |
| | | |
| | | model.addAttribute("driverId",id); |
| | | model.addAttribute("activityId",activityId); |
| | | return PREFIX + "tPromotionOrder.html"; |
| | | } |
| | | /** |
| | |
| | | @RequestMapping("") |
| | | public String index(Model model) { |
| | | List<Map<String, Object>> list=new ArrayList<>(); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, null, null, null, null, null, null, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),null); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, null, null, null, null, null, null, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),null,null); |
| | | BigDecimal reduce = list.stream().map(e -> new BigDecimal(e.get("promotionMoney").toString())).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | model.addAttribute("money",reduce); |
| | | model.addAttribute("size",list.size()); |
| | |
| | | String orderNum, |
| | | String userName, |
| | | String name, |
| | | String driverName,Integer driverId){ |
| | | String driverName,Integer driverId,Integer activityId){ |
| | | String beginTime = null; |
| | | String endTime = null; |
| | | if (SinataUtil.isNotEmpty(insertTime)) { |
| | |
| | | endTime = timeArray[1]; |
| | | } |
| | | Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage(); |
| | | page.setRecords(tOrderPrivateCarService.promotionInfo(page, beginTime, endTime, orderNum, userName, name, driverName, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),driverId)); |
| | | page.setRecords(tOrderPrivateCarService.promotionInfo(page, beginTime, endTime, orderNum, userName, name, driverName, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),driverId,activityId)); |
| | | return super.packForBT(page); |
| | | } |
| | | |
| | |
| | | endTime = timeArray[1]; |
| | | } |
| | | List<Map<String, Object>> list=new ArrayList<>(); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, beginTime, endTime, orderNum, userName, name, driverName, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),driverId); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, beginTime, endTime, orderNum, userName, name, driverName, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),driverId,null); |
| | | |
| | | |
| | | // 表格数据【封装】 |
| | |
| | | String orderNum, |
| | | String userName, |
| | | String name, |
| | | String driverName) { |
| | | String driverName,Integer driverId,Integer activityId) { |
| | | String beginTime = null; |
| | | String endTime = null; |
| | | if (SinataUtil.isNotEmpty(insertTime)) { |
| | |
| | | endTime = timeArray[1]; |
| | | } |
| | | List<Map<String, Object>> list=new ArrayList<>(); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, beginTime, endTime, orderNum, userName, name, driverName, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),null); |
| | | list = tOrderPrivateCarService.promotionInfoExport(null, beginTime, endTime, orderNum, userName, name, driverName, shiroExtUtil.getUser().getRoleType(), shiroExtUtil.getUser().getObjectId(),driverId,activityId); |
| | | HashMap<String, Object> map = new HashMap<>(); |
| | | BigDecimal reduce = list.stream().map(e -> new BigDecimal(e.get("promotionMoney").toString())).reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | map.put("money", reduce); |
| | |
| | | |
| | | List<Map<String,Object>> getSurcharge(@Param("id") Object id,@Param("orderType") Integer orderType); |
| | | |
| | | List<Map<String, Object>> promotionInfo(@Param("page") Page<Map<String, Object>> page, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("orderNum") String orderNum, @Param("userName") String userName, @Param("name") String name, @Param("driverName") String driverName, @Param("roleType") Integer roleType, @Param("objectId") Integer objectId, @Param("driverId") Integer driverId); |
| | | List<Map<String, Object>> promotionInfo(@Param("page") Page<Map<String, Object>> page, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("orderNum") String orderNum, @Param("userName") String userName, @Param("name") String name, @Param("driverName") String driverName, @Param("roleType") Integer roleType, @Param("objectId") Integer objectId, @Param("driverId") Integer driverId,@Param("activityId") Integer activityId); |
| | | |
| | | List<Map<String, Object>> promotionInfoExport(@Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("orderNum") String orderNum, @Param("userName") String userName, @Param("name") String name, @Param("driverName") String driverName, @Param("roleType") Integer roleType, @Param("objectId") Integer objectId, @Param("driverId") Integer driverId); |
| | | List<Map<String, Object>> promotionInfoExport(@Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("orderNum") String orderNum, @Param("userName") String userName, @Param("name") String name, @Param("driverName") String driverName, @Param("roleType") Integer roleType, @Param("objectId") Integer objectId, @Param("driverId") Integer driverId, @Param("activityId") Integer activityId); |
| | | } |
| | |
| | | <if test="orderNum != null and orderNum != ''"> |
| | | and t1.orderNum =#{orderNum} |
| | | </if> |
| | | <if test="activityId != null"> |
| | | and t1.promotionActivityId =#{activityId} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and t1.successTime between #{beginTime} and #{endTime} |
| | | </if> |
| | |
| | | where t1.promotionActivityId is not null |
| | | <if test="orderNum != null and orderNum != ''"> |
| | | and t1.orderNum =#{orderNum} |
| | | </if> |
| | | <if test="activityId != null"> |
| | | and t1.promotionActivityId =#{activityId} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and t1.successTime between #{beginTime} and #{endTime} |
| | |
| | | where t1.promotionActivityId is not null |
| | | <if test="orderNum != null and orderNum != ''"> |
| | | and t1.orderNum =#{orderNum} |
| | | </if> |
| | | <if test="activityId != null"> |
| | | and t1.promotionActivityId =#{activityId} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and t1.successTime between #{beginTime} and #{endTime} |
| | |
| | | <if test="orderNum != null and orderNum != ''"> |
| | | and t1.orderNum =#{orderNum} |
| | | </if> |
| | | <if test="activityId != null"> |
| | | and t1.promotionActivityId =#{activityId} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and t1.successTime between #{beginTime} and #{endTime} |
| | | </if> |
| | |
| | | where t1.promotionActivityId is not null |
| | | <if test="orderNum != null and orderNum != ''"> |
| | | and t1.orderNum =#{orderNum} |
| | | </if> |
| | | <if test="activityId != null"> |
| | | and t1.promotionActivityId =#{activityId} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and t1.successTime between #{beginTime} and #{endTime} |
| | |
| | | <if test="orderNum != null and orderNum != ''"> |
| | | and t1.orderNum =#{orderNum} |
| | | </if> |
| | | <if test="activityId != null"> |
| | | and t1.promotionActivityId =#{activityId} |
| | | </if> |
| | | <if test="beginTime != null and endTime != null"> |
| | | and t1.successTime between #{beginTime} and #{endTime} |
| | | </if> |
| | |
| | | private Integer userNum; |
| | | |
| | | private BigDecimal money; |
| | | |
| | | private Long activityId; |
| | | } |
| | |
| | | private Integer promotionDriverId; |
| | | |
| | | private BigDecimal promotionMoney; |
| | | private String voice; |
| | | |
| | | private Date voiceTime; |
| | | |
| | | public String getVoice() { |
| | | return voice; |
| | | } |
| | | |
| | | public void setVoice(String voice) { |
| | | this.voice = voice; |
| | | } |
| | | |
| | | public Date getVoiceTime() { |
| | | return voiceTime; |
| | | } |
| | | |
| | | public void setVoiceTime(Date voiceTime) { |
| | | this.voiceTime = voiceTime; |
| | | } |
| | | public BigDecimal getPromotionMoney() { |
| | | return promotionMoney; |
| | | } |
| | |
| | | |
| | | private BigDecimal promotionMoney; |
| | | |
| | | private String voice; |
| | | |
| | | private Date voiceTime; |
| | | |
| | | public String getVoice() { |
| | | return voice; |
| | | } |
| | | |
| | | public void setVoice(String voice) { |
| | | this.voice = voice; |
| | | } |
| | | |
| | | public Date getVoiceTime() { |
| | | return voiceTime; |
| | | } |
| | | |
| | | public void setVoiceTime(Date voiceTime) { |
| | | this.voiceTime = voiceTime; |
| | | } |
| | | |
| | | public BigDecimal getPromotionMoney() { |
| | | return promotionMoney; |
| | | } |
| | |
| | | private Integer promotionDriverId; |
| | | |
| | | private BigDecimal promotionMoney; |
| | | private String voice; |
| | | |
| | | private Date voiceTime; |
| | | |
| | | public String getVoice() { |
| | | return voice; |
| | | } |
| | | |
| | | public void setVoice(String voice) { |
| | | this.voice = voice; |
| | | } |
| | | |
| | | public Date getVoiceTime() { |
| | | return voiceTime; |
| | | } |
| | | |
| | | public void setVoiceTime(Date voiceTime) { |
| | | this.voiceTime = voiceTime; |
| | | } |
| | | public BigDecimal getPromotionMoney() { |
| | | return promotionMoney; |
| | | } |
| | |
| | | |
| | | List<Map<String,Object>> getSurcharge(Object id,Integer orderType); |
| | | |
| | | List<Map<String, Object>> promotionInfo(Page<Map<String, Object>> page, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId); |
| | | List<Map<String, Object>> promotionInfo(Page<Map<String, Object>> page, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId,Integer activityId); |
| | | |
| | | |
| | | List<Map<String, Object>> promotionInfoExport(Object o, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId); |
| | | List<Map<String, Object>> promotionInfoExport(Object o, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId,Integer activityId); |
| | | } |
| | |
| | | |
| | | for (TDriver tDriver : tDrivers) { |
| | | DriverRankVo driverRankVo = new DriverRankVo(); |
| | | driverRankVo.setActivityId(id); |
| | | driverRankVo.setDriverId(tDriver.getId()); |
| | | driverRankVo.setDriverName(tDriver.getName()); |
| | | long count = tUsers.stream().filter(e -> tDriver.getId().equals(e.getBindDriverId())).count(); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<Map<String, Object>> promotionInfo(Page<Map<String, Object>> page, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId) { |
| | | return this.baseMapper.promotionInfo(page, beginTime, endTime, orderNum, userName, name, driverName, roleType, objectId,driverId); |
| | | public List<Map<String, Object>> promotionInfo(Page<Map<String, Object>> page, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId,Integer activityId) { |
| | | return this.baseMapper.promotionInfo(page, beginTime, endTime, orderNum, userName, name, driverName, roleType, objectId,driverId,activityId); |
| | | } |
| | | |
| | | @Override |
| | | public List<Map<String, Object>> promotionInfoExport(Object o, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId) { |
| | | return this.baseMapper.promotionInfoExport(beginTime, endTime, orderNum, userName, name, driverName, roleType, objectId,driverId); |
| | | public List<Map<String, Object>> promotionInfoExport(Object o, String beginTime, String endTime, String orderNum, String userName, String name, String driverName, Integer roleType, Integer objectId,Integer driverId,Integer activityId) { |
| | | return this.baseMapper.promotionInfoExport(beginTime, endTime, orderNum, userName, name, driverName, roleType, objectId,driverId,activityId); |
| | | } |
| | | } |
| | |
| | | package com.stylefeng.guns.modular.system.util; |
| | | |
| | | |
| | | import com.aliyun.oss.OSS; |
| | | import com.aliyun.oss.OSSClient; |
| | | import com.baomidou.mybatisplus.mapper.EntityWrapper; |
| | | import com.stylefeng.guns.modular.system.model.TDriver; |
| | | import com.stylefeng.guns.modular.system.model.TOrderCrossCity; |
| | | import com.stylefeng.guns.modular.system.model.TOrderPrivateCar; |
| | | import com.stylefeng.guns.modular.system.model.TOrderTaxi; |
| | | import com.stylefeng.guns.modular.system.service.ITDriverService; |
| | | import com.stylefeng.guns.modular.system.service.ITOrderCrossCityService; |
| | | import com.stylefeng.guns.modular.system.service.ITOrderPrivateCarService; |
| | | import com.stylefeng.guns.modular.system.service.ITOrderTaxiService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.scheduling.annotation.Scheduled; |
| | | import org.springframework.stereotype.Component; |
| | | |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | |
| | |
| | | |
| | | @Autowired |
| | | private ITDriverService driverService; |
| | | |
| | | @Autowired |
| | | private ITOrderPrivateCarService orderPrivateCarService; |
| | | |
| | | @Autowired |
| | | private ITOrderTaxiService orderTaxiService; |
| | | |
| | | @Autowired |
| | | private ITOrderCrossCityService orderCrossCityService; |
| | | |
| | | |
| | | /** |
| | |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 每分钟执行 |
| | | */ |
| | | @Scheduled(cron = "0 0/1 * * * ?") |
| | | public void taskMinute(){ |
| | | // 15天后的时间 |
| | | long time = System.currentTimeMillis() + 15 * 24 * 60 * 60 * 1000; |
| | | Date date = new Date(time); |
| | | // 查出录音 |
| | | List<TOrderPrivateCar> list = orderPrivateCarService.selectList(new EntityWrapper<TOrderPrivateCar>().isNotNull("voiceTime").gt("voiceTime", date)); |
| | | List<TOrderTaxi> tOrderTaxis = orderTaxiService.selectList(new EntityWrapper<TOrderTaxi>().isNotNull("voiceTime").gt("voiceTime", date)); |
| | | List<TOrderCrossCity> tOrderCrossCities = orderCrossCityService.selectList(new EntityWrapper<TOrderCrossCity>().isNotNull("voiceTime").gt("voiceTime", date)); |
| | | ArrayList<String> strings = new ArrayList<>(); |
| | | for (TOrderPrivateCar tOrderPrivateCar : list) { |
| | | strings.add(tOrderPrivateCar.getVoice()); |
| | | } |
| | | for (TOrderTaxi tOrderTaxi : tOrderTaxis) { |
| | | strings.add(tOrderTaxi.getVoice()); |
| | | } |
| | | for (TOrderCrossCity tOrderCrossCity : tOrderCrossCities) { |
| | | strings.add(tOrderCrossCity.getVoice()); |
| | | } |
| | | if(strings.size()>0){ |
| | | deleteFile(strings); |
| | | } |
| | | |
| | | } |
| | | |
| | | public static String oss_domain = "https://cdxy-jiaotong-20250725.oss-cn-chengdu.aliyuncs.com/"; |
| | | public static String accessKeyId = "LTAI5t8obxz88oV8MgFMr4Bd"; |
| | | public static String accessKeySecret = "Y17SxRCVYGePCkr82FSCk9jqCBljRP"; |
| | | public static String bucketName="cdxy-jiaotong-20250725"; |
| | | public static String endpoint = "oss-cn-chengdu.aliyuncs.com"; |
| | | public static OSSClient ossClient = new OSSClient(endpoint, accessKeyId,accessKeySecret); |
| | | private static boolean deleteFile(List<String> fileNames) { |
| | | try { |
| | | for (String fileName : fileNames) { |
| | | // 删除文件 |
| | | ossClient.deleteObject(bucketName, "img/"+fileName); |
| | | } |
| | | // 关闭OSSClient |
| | | ossClient.shutdown(); |
| | | return true; |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | } |
| | |
| | | </div> |
| | | <div class="ibox-content"> |
| | | <input type="hidden" id="driverId" value="${driverId}"> |
| | | <input type="hidden" id="activityId" value="${activityId}"> |
| | | <div class="row row-lg"> |
| | | <div class="col-sm-12"> |
| | | <div class="row"> |
| | |
| | | let driverName = $('#driverName').val(); |
| | | let userName = $('#userName').val(); |
| | | let orderNum = $('#orderNum').val(); |
| | | let activityId = $('#activityId').val(); |
| | | |
| | | |
| | | //提交信息 |
| | |
| | | ajax.set("driverName",driverName); |
| | | ajax.set("userName",userName); |
| | | ajax.set("orderNum",orderNum); |
| | | ajax.set("activityId",activityId); |
| | | ajax.start(); |
| | | TAbnormalOrder.search() |
| | | } |
| | | |
| | | |
| | | function resetSearch() { |
| | | |
| | | let activityId = $('#activityId').val(); |
| | | let driverId = $('#driverId').val(); |
| | | //提交信息 |
| | | var ajax = new $ax(Feng.ctxPath + "/promotionInfo/list1", function(data){ |
| | | console.log(data) |
| | |
| | | $("#size").text(data.size) |
| | | },function(data){ |
| | | }); |
| | | ajax.set("activityId",activityId); |
| | | ajax.set("driverId",driverId); |
| | | ajax.start(); |
| | | |
| | | TAbnormalOrder.resetSearch() |
| | | } |
| | | </script> |
| | |
| | | formatter: function (value, row) { |
| | | var btn = []; |
| | | btn += '<a href="javascript:void(0);" onclick="TDriverPromotionActivity.viewUser(' + row.driverId + ')" style="color: #0e9aef">查看下级用户</a> '; |
| | | btn += '<a href="javascript:void(0);" onclick="TDriverPromotionActivity.viewMoney(' + row.driverId + ')" style="color: #0e9aef">查看收益明细</a> '; |
| | | btn += '<a href="javascript:void(0);" onclick="TDriverPromotionActivity.viewMoney(' + row.driverId+","+row.activityId + ')" style="color: #0e9aef">查看收益明细</a> '; |
| | | return btn; |
| | | } |
| | | |
| | |
| | | /** |
| | | * 打开查看详情 |
| | | */ |
| | | TDriverPromotionActivity.viewMoney = function (e) { |
| | | TDriverPromotionActivity.viewMoney = function (e,e1) { |
| | | var index = layer.open({ |
| | | type: 2, |
| | | title: '推广收益明细', |
| | | area: ['100%', '100%'], //宽高 |
| | | fix: false, //不固定 |
| | | maxmin: true, |
| | | content: Feng.ctxPath + '/tDriverPromotionActivity/tDriverPromotionActivity_viewMoney/' + e |
| | | content: Feng.ctxPath + '/tDriverPromotionActivity/tDriverPromotionActivity_viewMoney/' + e+"/"+e1 |
| | | }); |
| | | this.layerIndex = index; |
| | | }; |
| | |
| | | queryData['userName'] = $("#userName").val(); |
| | | queryData['orderNum'] = $("#orderNum").val(); |
| | | queryData['driverId'] = $("#driverId").val(); |
| | | queryData['activityId'] = $("#activityId").val(); |
| | | TAbnormalOrder.table.refresh({query: queryData}); |
| | | }; |
| | | |
| | |
| | | let userName = $('#userName').val(); |
| | | let orderNum = $('#orderNum').val(); |
| | | let driverId = $('#driverId').val(); |
| | | let activityId = $('#activityId').val(); |
| | | if(null != insertTime && '' != insertTime){ |
| | | p += "insertTime=" + insertTime + "&"; |
| | | } |
| | |
| | | } |
| | | if(null != driverId && '' != driverId){ |
| | | p += "driverId=" + driverId + "&" ; |
| | | } |
| | | if(null != activityId && '' != activityId){ |
| | | p += "activityId=" + activityId + "&" ; |
| | | } |
| | | if('' != p){ |
| | | p = "?" + p.substring(0, p.length - 1); |
| | |
| | | |
| | | $(function () { |
| | | var defaultColunms = TAbnormalOrder.initColumn(); |
| | | var table = new BSTable(TAbnormalOrder.id, "/promotionInfo/list?driverId="+$('#driverId').val(), defaultColunms); |
| | | var table = new BSTable(TAbnormalOrder.id, "/promotionInfo/list?driverId="+$('#driverId').val()+"&activityId="+$('#activityId').val(), defaultColunms); |
| | | table.setPaginationType("server"); |
| | | TAbnormalOrder.table = table.init(); |
| | | }); |
| | |
| | | @Override |
| | | public List<Phone> queryPhones(String code) throws Exception { |
| | | OpenCity openCity = openCityService.openCity1(code); |
| | | return phoneMapper.selectList(new EntityWrapper<Phone>().eq("openCityId", openCity)); |
| | | return phoneMapper.selectList(new EntityWrapper<Phone>().eq("openCityId", openCity.getId())); |
| | | } |
| | | |
| | | |