| | |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.entity.admin.ReslutOrder; |
| | | import com.yeshi.fanli.entity.taobao.TaoBaoOrder; |
| | | import com.yeshi.fanli.vo.order.TaoBaoOrderVO; |
| | | |
| | | public interface TaoBaoOrderMapper { |
| | | |
| | |
| | | // 通过订单号获取订单列表 |
| | | List<TaoBaoOrder> selectTaoBaoOrderByOrderId(String orderId); |
| | | |
| | | // 通过交易ID获取订单 |
| | | TaoBaoOrder selectTaoBaoOrderByTradeId(String tradeId); |
| | | |
| | | List<TaoBaoOrder> listByTradeId(String tradeId); |
| | | |
| | | int updateByPrimaryKeySelective(TaoBaoOrder record); |
| | | |
| | | int updateByPrimaryKey(TaoBaoOrder record); |
| | | |
| | | // 根据订单号删除数据 |
| | | int deleteByOrderId(String orderId); |
| | | |
| | | |
| | | List<ReslutOrder> queryJoinHongBao(@Param("start") int start, @Param("count") int count, @Param("key") String key, |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime, |
| | | @Param("type")Integer type,@Param("days") Integer days); |
| | | |
| | | int countQueryJoinHongBao( @Param("key") String key,@Param("startTime") String startTime, |
| | | @Param("endTime") String endTime, @Param("type")Integer type,@Param("days") Integer days); |
| | | |
| | | |
| | | /** |
| | | * 统计--订单类型区分 |
| | | * |
| | | * @return |
| | | */ |
| | | Map<String, Object> countByOdrerType(); |
| | | |
| | | |
| | | |
| | | /** |
| | | * 统计今日订单 |
| | | * |
| | | * @return |
| | | */ |
| | | int countToday(); |
| | | |
| | | |
| | | /** |
| | | * 统计昨日订单 |
| | | * |
| | | * @return |
| | | */ |
| | | int countYesterday(); |
| | | |
| | | |
| | | |
| | | /** |
| | | * 统计当日预估收益 |
| | | * @param date 2018-09-01 |
| | | * |
| | | * @param date |
| | | * 2018-09-01 |
| | | * @return |
| | | */ |
| | | double countEstimate(@Param("date")String date); |
| | | |
| | | |
| | | |
| | | List<TaoBaoOrder> getStateByOrderIdAndPayment(@Param("orderId")String orderId, @Param("payment")String payment); |
| | | |
| | | |
| | | double countEstimate(@Param("date") String date); |
| | | |
| | | List<TaoBaoOrder> getStateByOrderIdAndPayment(@Param("orderId") String orderId, @Param("payment") String payment); |
| | | |
| | | TaoBaoOrder selectLatestByAuctionId(long auctionId); |
| | | |
| | | |
| | | |
| | | /** |
| | | * 统计所有订单 |
| | | * 统计所有订单 |
| | | * |
| | | * @param channel |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> countOrderNumber( @Param("dateType") Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | |
| | | List<Map<String, Object>> countOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year, |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime); |
| | | |
| | | List<TaoBaoOrderVO> listQuery(@Param("start")long start, @Param("count") int count, |
| | | @Param("keyType")Integer keyType, @Param("key") String key, |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime, |
| | | @Param("state")Integer state); |
| | | |
| | | long countQuery(@Param("keyType")Integer keyType, @Param("key") String key, |
| | | @Param("startTime") String startTime,@Param("endTime") String endTime, |
| | | @Param("state")Integer state); |
| | | |
| | | /** |
| | | * 获取长期未更新的订单 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @return |
| | | */ |
| | | List<TaoBaoOrder> listLongTimeNoUpdateOrders(@Param("start") long start, @Param("count") int count); |
| | | |
| | | /** |
| | | * 获取所有订单列表 |
| | | * |
| | | * @param orderNo |
| | | * @param start |
| | | * @param count |
| | | * @return |
| | | */ |
| | | List<TaoBaoOrder> listAllOrder(@Param("orderNo") String orderNo, @Param("start") long start, |
| | | @Param("count") int count); |
| | | |
| | | /** |
| | | * 所有订单数量 |
| | | * |
| | | * @param orderNo |
| | | * @return |
| | | */ |
| | | long countAllOrder(@Param("orderNo") String orderNo); |
| | | |
| | | /** |
| | | * 根据结算时间拼排序 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @return |
| | | */ |
| | | List<TaoBaoOrder> listBySettlementTime(@Param("minTime") Long minTime, @Param("maxTime") Long maxTime, |
| | | @Param("start") long start, @Param("count") int count); |
| | | |
| | | /** |
| | | * 根据结算时间计数 |
| | | * |
| | | * @param minTime |
| | | * @param maxTime |
| | | * @return |
| | | */ |
| | | Long countBySettlementTime(@Param("minTime") Long minTime, @Param("maxTime") Long maxTime); |
| | | } |