| | |
| | | package com.yeshi.fanli.dao.mybatis.order; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.entity.bus.user.LostOrder; |
| | | |
| | | public interface LostOrderMapper { |
| | | |
| | | int updateByPrimaryKeySelective(LostOrder record); |
| | | |
| | | /** |
| | | * 通过订单号查询丢失订单 |
| | | * |
| | | * @param orderId |
| | | * @return |
| | | */ |
| | | List<LostOrder> selectByOrderId(String orderId); |
| | | |
| | | /** |
| | | * 统计用户申诉次数 |
| | | * @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); |
| | | |
| | | long countQuery(@Param("key") String key, @Param("state") Integer state, @Param("handleType") Integer handleType); |
| | | 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);
|
| | |
|
| | | } |