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);
|
}
|
