| | |
| | | package com.yeshi.fanli.dao.mybatis.taobao; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.entity.taobao.TaoBaoWeiQuanOrder; |
| | | |
| | | public interface TaoBaoWeiQuanOrderMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(TaoBaoWeiQuanOrder record); |
| | | |
| | | int insertSelective(TaoBaoWeiQuanOrder record); |
| | | |
| | | TaoBaoWeiQuanOrder selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(TaoBaoWeiQuanOrder record); |
| | | |
| | | int updateByPrimaryKey(TaoBaoWeiQuanOrder record); |
| | | |
| | | // 按订单号和子订单号查询 |
| | | TaoBaoWeiQuanOrder selectByOrderIdAndOrderItemId(@Param("orderId") String orderId, |
| | | @Param("orderItemId") String orderItemId); |
| | | |
| | | // 按订单号和维权状态查询 |
| | | List<TaoBaoWeiQuanOrder> selectListByOrderIdAndState(@Param("orderId") String orderId, |
| | | @Param("state") String state); |
| | | |
| | | |
| | | /** |
| | | * 统计总金额 |
| | | * @param dateType |
| | | * @param years |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> countWeiQaunOrderNumber(@Param("dateType")Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | |
| | | /** |
| | | * 统计总个数 |
| | | * @param dateType |
| | | * @param years |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> countWeiQaunOrderMoney(@Param("dateType")Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | |
| | | package com.yeshi.fanli.dao.mybatis.taobao;
|
| | |
|
| | | import java.util.List;
|
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.dto.ChartTDO;
|
| | | import com.yeshi.fanli.entity.taobao.TaoBaoWeiQuanOrder;
|
| | |
|
| | | public interface TaoBaoWeiQuanOrderMapper {
|
| | |
|
| | | int deleteByPrimaryKey(Long id);
|
| | |
|
| | | int insert(TaoBaoWeiQuanOrder record);
|
| | |
|
| | | int insertSelective(TaoBaoWeiQuanOrder record);
|
| | |
|
| | | TaoBaoWeiQuanOrder selectByPrimaryKey(Long id);
|
| | |
|
| | | int updateByPrimaryKeySelective(TaoBaoWeiQuanOrder record);
|
| | |
|
| | | int updateByPrimaryKey(TaoBaoWeiQuanOrder record);
|
| | |
|
| | | // 按订单号和子订单号查询
|
| | | TaoBaoWeiQuanOrder selectByOrderIdAndOrderItemId(@Param("orderId") String orderId,
|
| | | @Param("orderItemId") String orderItemId);
|
| | |
|
| | | TaoBaoWeiQuanOrder selectByOrderItemId(String orderItemId);
|
| | |
|
| | | // 按订单号和维权状态查询
|
| | | List<TaoBaoWeiQuanOrder> selectListByOrderIdAndState(@Param("orderId") String orderId,
|
| | | @Param("state") String state);
|
| | |
|
| | | /**
|
| | | * 统计总金额
|
| | | * |
| | | * @param dateType
|
| | | * @param years
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> countWeiQaunOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year,
|
| | | @Param("startTime") String startTime, @Param("endTime") String endTime);
|
| | |
|
| | | /**
|
| | | * 统计总个数
|
| | | * |
| | | * @param dateType
|
| | | * @param years
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> countWeiQaunOrderMoney(@Param("dateType") Integer dateType, @Param("year") String year,
|
| | | @Param("startTime") String startTime, @Param("endTime") String endTime);
|
| | |
|
| | | /**
|
| | | * 根据状态检索
|
| | | * |
| | | * @param state
|
| | | * @param start
|
| | | * @param count
|
| | | * @return
|
| | | */
|
| | | List<TaoBaoWeiQuanOrder> listByState(@Param("state") String state, @Param("start") long start,
|
| | | @Param("count") int count);
|
| | |
|
| | | /**
|
| | | * 根据状态统计数量
|
| | | * |
| | | * @param state
|
| | | * @return
|
| | | */
|
| | | long countByState(@Param("state") String state);
|
| | | |
| | | |
| | | /**
|
| | | * 根据订单号检索
|
| | | * @param orderId
|
| | | * @return
|
| | | */
|
| | | List<TaoBaoWeiQuanOrder> listByOrderId(String orderId);
|
| | | |
| | | /**
|
| | | * 根据子订单号检索
|
| | | * @param tradeId
|
| | | * @return
|
| | | */
|
| | | TaoBaoWeiQuanOrder selectByOrderItem(String tradeId);
|
| | | |
| | | |
| | | /**
|
| | | * 根据状态检索
|
| | | * |
| | | * @param state
|
| | | * @param start
|
| | | * @param count
|
| | | * @return
|
| | | */
|
| | | List<TaoBaoWeiQuanOrder> listByBeginWeiQuan(@Param("start") long start, @Param("count") int count);
|
| | | } |