New file |
| | |
| | | package com.yeshi.fanli.dao.mybatis.user.cloud; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.bus.user.cloud.UserCloudOrder; |
| | | |
| | | public interface UserCloudOrderMapper extends BaseMapper<UserCloudOrder> { |
| | | |
| | | /** |
| | | * 查询用于更新余额-锁定 |
| | | * @param id |
| | | * @return |
| | | */ |
| | | UserCloudOrder selectForUpdate(long id); |
| | | |
| | | /** |
| | | * 查询后一条支付完成的 |
| | | * @param uid |
| | | * @param type |
| | | * @return |
| | | */ |
| | | UserCloudOrder getLastOrderByPayEnd(@Param("uid") Long uid, @Param("type")String type); |
| | | |
| | | /** |
| | | * 查询后一条支付完成的 |
| | | * @param uid |
| | | * @param type |
| | | * @return |
| | | */ |
| | | UserCloudOrder getLastOrderByUnpaid(@Param("uid") Long uid, @Param("type")String type); |
| | | |
| | | |
| | | /** |
| | | * 查询订单记录 |
| | | * @param start |
| | | * @param count |
| | | * @param uid |
| | | * @param state |
| | | * @return |
| | | */ |
| | | List<UserCloudOrder> getOrderRecord(@Param("start") long start, @Param("count") int count, @Param("uid")Long uid, @Param("state")Integer state); |
| | | |
| | | /** |
| | | * 查询订单记录 |
| | | * @param uid |
| | | * @param state |
| | | * @return |
| | | */ |
| | | Long countOrderRecord(@Param("uid")Long uid, @Param("state")Integer state); |
| | | |
| | | /** |
| | | * 查询近一个小时未支付 |
| | | * @return |
| | | */ |
| | | List<UserCloudOrder> getLasthourByUnpaid(); |
| | | |
| | | |
| | | /** |
| | | * 查询订单记录 |
| | | * @param start |
| | | * @param count |
| | | * @param uid |
| | | * @param state |
| | | * @return |
| | | */ |
| | | List<UserCloudOrder> query(@Param("start") long start, @Param("count") int count, @Param("key")String key, @Param("state")Integer state); |
| | | |
| | | Long count(@Param("key")String key, @Param("state")Integer state); |
| | | |
| | | } |