| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 |
- package com.sqx.modules.errand.dao;
- import com.baomidou.mybatisplus.core.mapper.BaseMapper;
- import com.baomidou.mybatisplus.core.metadata.IPage;
- import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
- import com.sqx.modules.app.entity.UserEntity;
- import com.sqx.modules.datacentre.query.DataCenterQuery;
- import com.sqx.modules.errand.dto.WaitForAcceptOrderQueryDTO;
- import com.sqx.modules.errand.entity.ErrandAddress;
- import com.sqx.modules.errand.entity.ErrandRedPacket;
- import com.sqx.modules.errand.entity.TbIndent;
- import com.sqx.modules.errand.vo.ShopWaitAcceptOrderVO;
- import org.apache.ibatis.annotations.Mapper;
- import org.apache.ibatis.annotations.Param;
- import java.math.BigDecimal;
- import java.util.Date;
- import java.util.List;
- @Mapper
- public interface TbIndentDao extends BaseMapper<TbIndent> {
- IPage<TbIndent> findNewIndent(Page<TbIndent> pages, double riderLng, double riderLat, double distances, String indentType);
- IPage<TbIndent> findNewIndentcity(Page<TbIndent> pages, double riderLng, double riderLat, String address, String indentType);
- IPage<TbIndent> findNewIndentByCity(@Param("pages") Page<TbIndent> pages, @Param("queryDTO") WaitForAcceptOrderQueryDTO queryDTO);
- IPage<TbIndent> findNewIndentByDistances(@Param("pages") Page<TbIndent> pages, @Param("queryDTO") WaitForAcceptOrderQueryDTO queryDTO);
- IPage<ShopWaitAcceptOrderVO> findNewIndentByDistancesGroupByShop(@Param("pages") Page<ShopWaitAcceptOrderVO> pages, @Param("queryDTO") WaitForAcceptOrderQueryDTO queryDTO);
- TbIndent findIndentByNumber(String indentNumber);
- TbIndent findIndentByOrderId(String orderId);
- int selectIndentByRiderUserCount(Long riderUserId);
- void indentReceiving(Long userId, String indentNumber, String format);
- void indentReceiv(Long userId, String indentNumber, String format,String state);
- void orderIndentReceiving(Long userId, String orderId, String format);
- void orderIndentReceiv(Long userId, String orderId, String format,String state);
- IPage<TbIndent> findRiderIndent(Page<TbIndent> pages, Long userId, String indentState);
- TbIndent indentRiderMessage(String indentNumber, double riderLng, double riderLat);
- void riderCancleIndent(@Param("riderUserId") Long userId, @Param("indentNumber") String indentNumber);
- void updateRiderCashDeposit(BigDecimal cashDeposit, Long userId);
- void riderDelivery(Long indentId, String date);
- TbIndent selectIndentByIndentNumber(String indentNumber);
- void updateRiderBalance(BigDecimal balance, Long userId);
- void userDelivery(Long userId, String indentNumber, String date);
- IPage<TbIndent> findallIndent(Page<TbIndent> pages, Long userId, Long riderUserId, Long shopId,Integer indentType,String ordersNo,Integer status,String riderPhone);
- void updateDefault(Long userId);
- void addUserAddress(ErrandAddress errandAddress);
- void updateAddress(@Param("userId")Long userId, @Param("userName") String userName, @Param("userPhone")String userPhone, @Param("address") String address,
- @Param("addressDetail")String addressDetail, @Param("lng")double lng, @Param("lat")double lat,
- @Param("updatetime")String datetime, @Param("addressDefault") String addressDefault, @Param("addressId") Long addressId);
- List<ErrandAddress> findUserAddress(Long userId);
- ErrandAddress findAddressById(Long userId, Integer addressId);
- void addDefaultAddress(Long userId, Integer addressId);
- void delUserAddress(Long userId, Integer addressId);
- ErrandRedPacket findRed(Long redPacketId);
- void delRedPacket(Long redPacketId);
- IPage<TbIndent> findAllIndent(Page<TbIndent> pages, String indentType, String phone, String indentState, String date, String dateType,String riderPhone);
- IPage<TbIndent> findAllIndents(Page<TbIndent> pages, String indentType, String phone, String indentState, String date, String dateType,String riderPhone);
- IPage<TbIndent> IndentCenter(Page<TbIndent> pages, String indentType, String indentNumber, String indentState, String phone, String date, String dateType);
- void updateIndentState(String indentNumber, String indentState);
- void adminSoldOutIndent(String indentNumber);
- BigDecimal billMoney(@Param("query") DataCenterQuery query);
- BigDecimal receivingMoney(@Param("query") DataCenterQuery query) ;
- int billCount(@Param("query") DataCenterQuery query);
- int reveivingCount(@Param("query") DataCenterQuery query);
- IPage<TbIndent> taskAnalysisMoney(Page<TbIndent> pages,@Param("query") DataCenterQuery query,@Param("indentState") String status);
- int findAllCount();
- int findDayAddUser(String format);
- int findMonthAddUser(String format);
- int findYearAddUser(String format);
- BigDecimal findDayIncome(String format);
- BigDecimal findMonthIncome(String format);
- BigDecimal findYearIncome(String format);
- int findIndentCount(String format);
- int selectOrderByStatus(@Param("query") DataCenterQuery query, Integer status);
- BigDecimal findAdminIncomeday(Long userId, String date, String dateType);
- BigDecimal findPrepayMoney(Long userId, String date, String dateType);
- int findAdminIndentCount(Long userId, String date, String dateType);
- IPage<TbIndent> selectIndentById(Page<TbIndent> pages, Long userId, String date, String dateType);
- IPage<TbIndent> findUserIndent(Page<TbIndent> pages, Long userId, String indentState);
- TbIndent indentMessage(String indentNumber);
- List<UserEntity> find5KmRider(@Param("lng") double lng, @Param("lat") double lat);
- void updateCoordinate(Long userId, double lng, double lat);
- UserEntity findUserInfoById(Long userId);
- List<ErrandRedPacket> findAllRedPacket(Long userId, String expirationTime);
- List<ErrandRedPacket> findRedPacket(Long userId, String indentType, BigDecimal indentBasicsMoney, Date expirationTime);
- int userCancleIndent(@Param("userId") Long userId, @Param("indentNumber") String indentNumber, @Param("cancelIndentTime") String cancelIndentTime);
- int updateRedPaclet(@Param("redPacketId") Long redPacketId);
- List<TbIndent> selectIndentList(Long userId);
- List<TbIndent> selectSendOrder(String date);
- Long selectRiderByDictance(Double userLng, Double userLat, Double distance, Double cashDeposit,Integer maxNum);
- TbIndent indentMessageByOrderId(Long orderId, double riderLng, double riderLat);
- IPage<ShopWaitAcceptOrderVO> findNewIndentByCityGroupByShop(@Param("pages") Page<ShopWaitAcceptOrderVO> pages, @Param("queryDTO") WaitForAcceptOrderQueryDTO queryDTO);
- }
|