| | |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.bus.user.LostOrder; |
| | | |
| | | public interface LostOrderMapper { |
| | | |
| | | LostOrder selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(LostOrder record); |
| | | public interface LostOrderMapper extends BaseMapper<LostOrder> { |
| | | |
| | | /** |
| | | * 通过订单号查询丢失订单 |
| | |
| | | * @return |
| | | */ |
| | | List<LostOrder> selectByOrderId(String orderId); |
| | | |
| | | |
| | | /** |
| | | * 统计用户申诉次数 |
| | | * |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | Map<String, Object> countByUid(@Param("uid") Long uid); |
| | | |
| | | |
| | | /** |
| | | * 后端列表查询 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | |
| | | */ |
| | | 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); |
| | | |
| | | /** |
| | | * 统计申诉订单数量 |
| | | * @param type |
| | | * |
| | | * @param type |
| | | * @param state |
| | | * @param years |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> countLostNum(@Param("dateType")Integer dateType,@Param("resultCode")Integer resultCode, |
| | | @Param("year") String year, @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | |
| | | |
| | | List<Map<String, Object>> countLostNum(@Param("dateType") Integer dateType, @Param("resultCode") Integer resultCode, |
| | | @Param("year") String year, @Param("startTime") String startTime, @Param("endTime") String endTime); |
| | | |
| | | /** |
| | | * 统计申诉成功订单金额 |
| | | * @param type |
| | | * |
| | | * @param type |
| | | * @param state |
| | | * @param years |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> countAppealMoney(@Param("dateType")Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | List<Map<String, Object>> countAppealMoney(@Param("dateType") Integer dateType, @Param("year") String year, |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime); |
| | | |
| | | /** |
| | | * 根据用户删除 |
| | | * |
| | | * @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); |
| | | |
| | | } |