package com.yeshi.fanli.dao.mybatis.order;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Param;
|
|
import com.yeshi.fanli.dao.BaseMapper;
|
import com.yeshi.fanli.entity.bus.user.LostOrder;
|
|
public interface LostOrderMapper extends BaseMapper<LostOrder> {
|
|
/**
|
* 通过订单号查询丢失订单
|
*
|
* @param orderId
|
* @return
|
*/
|
List<LostOrder> selectByOrderIdAndType(@Param("orderId")String orderId,@Param("type") int type);
|
|
/**
|
* 统计用户申诉次数
|
*
|
* @param uid
|
* @return
|
*/
|
Map<String, Object> countByUid(@Param("uid") Long uid);
|
|
/**
|
* 后端列表查询
|
*
|
* @param start
|
* @param count
|
* @param key
|
* @return
|
*/
|
List<LostOrder> listQuery(@Param("start") long start, @Param("count") int count, @Param("key") String key,
|
@Param("state") Integer state, @Param("handleType") Integer handleType, @Param("type") Integer type);
|
|
long countQuery(@Param("key") String key, @Param("state") Integer state, @Param("handleType") Integer handleType,
|
@Param("type") Integer type);
|
|
/**
|
* 统计申诉订单数量
|
*
|
* @param preDay
|
* @return
|
*/
|
Integer countLostOrderNum(@Param("preDay") String preDay);
|
|
/**
|
* 统计申诉成功订单金额
|
*
|
* @param preDay
|
* @return
|
*/
|
BigDecimal countAppealMoney(@Param("preDay") String preDay);
|
|
/**
|
* 根据用户删除
|
*
|
* @param uid
|
* @return
|
*/
|
int deleteByUid(Long uid);
|
|
/**
|
*
|
* @param uid
|
* @param start
|
* @param count
|
* @return
|
*/
|
List<LostOrder> listByUidOrderByCreateTimeDesc(@Param("uid") Long uid, @Param("start") long start,
|
@Param("count") int count);
|
|
/**
|
* 获取用户订单数量
|
*
|
* @param uid
|
* @return
|
*/
|
long countAllByUid(Long uid);
|
|
/**
|
*
|
* @param orderId
|
* @param type
|
* @param stateList
|
* @return
|
*/
|
List<LostOrder> listByOrderIdAndTypeAndState(@Param("orderId") String orderId, @Param("type") int type,
|
@Param("stateList") List<Integer> stateList);
|
|
/**
|
* 处理失败
|
*
|
* @return
|
*/
|
int processFail();
|
|
/**
|
* 根据状态和结果码获取列表
|
*
|
* @param state
|
* @param resultCode
|
* @param start
|
* @param count
|
* @return
|
*/
|
List<LostOrder> listByStateAndResultCode(@Param("state") Integer state, @Param("resultCode") Integer resultCode,
|
@Param("start") long start, @Param("count") int count);
|
|
/**
|
* 统计今日申诉次数
|
*
|
* @param uid
|
* @return
|
*/
|
long countTodayAppeal(@Param("uid") Long uid);
|
|
/**
|
* 根据处理的最大时间和状态，处理结果查询
|
*
|
* @param maxTime
|
* @param state
|
* @param resultCode
|
* @return
|
*/
|
List<LostOrder> listByMaxHandleTimeAndStateAndResultCode(@Param("maxTime") long maxTime,
|
@Param("state") Integer state, @Param("resultCode") Integer resultCode);
|
|
}
|
