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