| | |
| | | package com.yeshi.fanli.dao.mybatis;
|
| | |
|
| | | import java.math.BigDecimal;
|
| | | import java.util.List;
|
| | | import java.util.Map;
|
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.entity.bus.user.Extract;
|
| | |
|
| | | public interface ExtractMapper {
|
| | | int deleteByPrimaryKey(Long configId);
|
| | |
|
| | | int insert(Extract record);
|
| | |
|
| | | int insertSelective(Extract record);
|
| | |
|
| | | Extract selectByPrimaryKey(Long configId);
|
| | |
|
| | | Extract selectByPrimaryKeyForUpdate(Long configId);
|
| | |
|
| | | int updateByPrimaryKeySelective(Extract record);
|
| | |
|
| | | int updateByPrimaryKey(Extract record);
|
| | |
|
| | | List<Integer> checkExtract(String uid);
|
| | |
|
| | | Map<String, Object> getTodayCount();
|
| | |
|
| | | /**
|
| | | * 统计今日提现成功金额
|
| | | */
|
| | | BigDecimal getTodayTotalSuccessMoney();
|
| | |
|
| | | /**
|
| | | * 统计成功的次数、总金额
|
| | | * |
| | | * @return
|
| | | */
|
| | | Map<String, Object> countTotalSuccess();
|
| | |
|
| | | /**
|
| | | * 查询当前客服待处理
|
| | | * |
| | | * @param start
|
| | | * @param count
|
| | | * @param title
|
| | | * @param state
|
| | | * @return
|
| | | */
|
| | | Extract getMyTaskInfo(@Param("adminId") Long adminId);
|
| | |
|
| | | /**
|
| | | * 查询当前客服新处理任务
|
| | | * |
| | | * @param start
|
| | | * @param count
|
| | | * @param title
|
| | | * @param state
|
| | | * @return
|
| | | */
|
| | | Extract getNewTaskInfo();
|
| | |
|
| | | /**
|
| | | * 查询当前客服待处理
|
| | | * |
| | | * @param start
|
| | | * @param count
|
| | | * @param title
|
| | | * @param state
|
| | | * @return
|
| | | */
|
| | | Map<String, Object> countRecordsByUid(@Param("uid") Long uid);
|
| | |
|
| | | double countSuccessMoneysByUid(@Param("uid") Long uid);
|
| | |
|
| | | long countSuccessByUid(@Param("uid") Long uid);
|
| | |
|
| | | List<Map<String, Object>> getFinishRecord(@Param("start") long start, @Param("count") int count,
|
| | | @Param("key") String key, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
| | |
|
| | | /**
|
| | | * 统计今日提现申请次数
|
| | | * |
| | | * @return
|
| | | */
|
| | | int countTodayApply();
|
| | |
|
| | | /**
|
| | | * 统计今日已处理提现数量
|
| | | * |
| | | * @return
|
| | | */
|
| | | int countTodayComplete();
|
| | |
|
| | | package com.yeshi.fanli.dao.mybatis; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.entity.bus.user.Extract; |
| | | |
| | | public interface ExtractMapper { |
| | | int deleteByPrimaryKey(Long configId); |
| | | |
| | | int insert(Extract record); |
| | | |
| | | int insertSelective(Extract record); |
| | | |
| | | Extract selectByPrimaryKey(Long configId); |
| | | |
| | | Extract selectByPrimaryKeyForUpdate(Long configId); |
| | | |
| | | int updateByPrimaryKeySelective(Extract record); |
| | | |
| | | int updateByPrimaryKey(Extract record); |
| | | |
| | | List<Integer> checkExtract(String uid); |
| | | |
| | | Map<String, Object> getTodayCount(); |
| | | |
| | | /** |
| | | * 统计今日提现成功金额 |
| | | */ |
| | | BigDecimal getTodayTotalSuccessMoney(); |
| | | |
| | | /** |
| | | * 统计成功的次数、总金额 |
| | | * |
| | | * @return |
| | | */ |
| | | Map<String, Object> countTotalSuccess(); |
| | | |
| | | /** |
| | | * 查询当前客服待处理 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @param title |
| | | * @param state |
| | | * @return |
| | | */ |
| | | Extract getMyTaskInfo(@Param("adminId") Long adminId); |
| | | |
| | | /** |
| | | * 查询当前客服新处理任务 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @param title |
| | | * @param state |
| | | * @return |
| | | */ |
| | | Extract getNewTaskInfo(); |
| | | |
| | | /** |
| | | * 查询当前客服待处理 |
| | | * |
| | | * @param start |
| | | * @param count |
| | | * @param title |
| | | * @param state |
| | | * @return |
| | | */ |
| | | Map<String, Object> countRecordsByUid(@Param("uid") Long uid); |
| | | |
| | | double countSuccessMoneysByUid(@Param("uid") Long uid); |
| | | |
| | | long countSuccessByUid(@Param("uid") Long uid); |
| | | |
| | | List<Map<String, Object>> getFinishRecord(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("startTime") String startTime, @Param("endTime") String endTime); |
| | | |
| | | /** |
| | | * 统计今日提现申请次数 |
| | | * |
| | | * @return |
| | | */ |
| | | int countTodayApply(); |
| | | |
| | | /** |
| | | * 统计今日已处理提现数量 |
| | | * |
| | | * @return |
| | | */ |
| | | int countTodayComplete(); |
| | | |
| | | double countTodayMoney(@Param("uid") Long uid); |
| | | |
| | | /** |
| | | * 获取补偿金额 |
| | | * |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | BigDecimal computeCompensateByUid(Long uid); |
| | | |
| | | /** |
| | | * 统计今日申请提现的金额(根据用户ID) |
| | | * |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | /** |
| | | * 统计当日提现 |
| | | * @param uid |
| | | * @param day |
| | | * @return |
| | | */ |
| | | BigDecimal sumToadyApplyByUid(@Param("uid") Long uid, @Param("day") String day); |
| | | |
| | | /** |
| | | * 根据用户ID与状态统计资金 |
| | | * @param uid |
| | | * @param stateList |
| | | * @return |
| | | */ |
| | | BigDecimal sumMoneyByUidAndState(@Param("uid") Long uid,@Param("stateList")List<Integer> stateList); |
| | | |
| | | |
| | | /** |
| | | * 查询提现成功记录 |
| | | * @param start |
| | | * @param count |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | List<Extract> getExtractSucceedRecord(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid); |
| | | |
| | | |
| | | Long countExtractSucceedRecord(@Param("uid") Long uid); |
| | | |
| | | } |