package com.ibeetl.admin.console.dao;
|
|
import com.ibeetl.admin.console.model.*;
|
import org.apache.commons.lang3.StringUtils;
|
import org.beetl.sql.core.annotatoin.SqlResource;
|
|
import java.util.List;
|
import java.util.Map;
|
|
@SqlResource("console.cuser")
|
public interface CuserConsoleDao {
|
|
int queryCuserListCount(String userType, String name, String phone);
|
List<UserModel> queryCuserList(String userType, String name, String phone, int page, int limit);
|
int queryCuserForTimeListCount(String phone ,String startTime, String endTime,String userType,List<String> partnerIds,List<String> townIds);
|
List<UserModel> queryCuserForTimeList(String phone,String startTime, String endTime, int page, int limit,String userType,String isProhibit,List<String> partnerIds,List<String> townIds);
|
List<UserModel> queryPromoterApiList(String phone,String startTime, String endTime, int page, int limit,String isProhibit,List<String> partnerIds);
|
int queryPromoterApiCount(String phone,String startTime, String endTime,String isProhibit,List<String> partnerIds);
|
Map<String, Object> queryUserDayCount(List<String> townIds);
|
Map<String, Object> queryUserDayCount1();
|
List<Map<String, Object>> queryCuserDetail(String phone, String userType, String tableName);
|
List<Map<String, Object>> queryCuserAddress(String phone, String userId);
|
List<Map<String, Object>> queryCuserOrderCount(String userId, Integer [] status);
|
List<Map<String, Object>> queryCuserOrderFinishList(String userId, Integer [] status,int page,int limit);
|
int queryCuserOrderFinishCount(String userId, Integer [] status);
|
UserModel queryUserById(String userId);
|
UserModel queryUserOtherById(String userId);
|
UserModel queryUserOtherByIdC(String userId);
|
List<UserModel> queryUserOtherByPhone(String phone);
|
List<Map<String,Object>> queryUserOrderList(String userId);
|
List<OrderModel> queryOrderByPhone(String phone);
|
|
int UpdateUserApiByUserId(boolean flag,String userId);
|
int UpdateUserApiByOtherUserId(boolean flag,String userId,String userType);
|
int UpdateUserApiByTargetUserId(boolean flag,String userId);
|
int updateSysStorageName(String sysStorageId,String name);
|
int updateStorageUserNameById(String userId,String name);
|
|
|
List<UserModel> queryCuserByPhoneList(String phone, String tableName, int page, int limit);
|
int queryCuserByPhoneCount(String phone, String tableName);
|
List<UserModel> queryCuserByPhone(String phone, String tableName);
|
void delCuserById(String id, String tableName);
|
void delCuserAccountById(String id);
|
void delUserAddress(String id, String phone);
|
UserModel queryUserByUsertype(String phone, String userType, String delFlag, String tableName,String normal,String nickName);
|
UserModel queryUserByUsertype1(String phone, String userType, String delFlag, String tableName,String normal,String nickName);
|
List<UserModel> queryUserByUsertypeList(String phone, String userType, String delFlag, String tableName,String normal,String nickName);
|
UserModel queryUserOldUserType(String phone, String userType, String tableName);
|
|
UserAddressModel queryUserAddressInfo(String userId,String mobilePhone);
|
|
int addCuserRole(String id, String mobilephone,String password ,String userType, String tableName,String area,String partnerId,String name,String salt,String roleId,String cityId,String storageId);
|
//#mobilephone#,#password#,#salt#,#name#,#userType#,SYSDATE(),#area#
|
//int addCuserAccountRole(String id, String phone, String userId);
|
String queryPartnerId(String area);
|
/**
|
* 根据手机号和用户类型更新 删除标记为0， 就是不删除
|
* @param phone
|
* @param userType
|
* @return
|
*/
|
int updateDelflag(String phone, String userType,String roleId,String name, String tableName,String password,String salt,String area,String partnerId,String cityId,String storageId);
|
|
List<Map<String, Object>> queryAllRole();
|
|
List<Map<String, Object>> queryAllAPPRole();
|
|
List<Map<String, Object>> querySysStrangeList(List<String> townIds);
|
|
List<Map<String, Object>> queryCuserByTypeList(String userType, String nikeName, String phone, int page, int limit);
|
int queryCuserByTypeListCount(String userType, String nikeName, String phone);
|
|
List<Map<String, Object>> queryCuserByPhoneRedisDelList(String phone);
|
|
List<Map<String, Object>> queryCuserListByName(String userId,List<String> partnerIds);
|
|
/**
|
* 根据用户ID 更新name
|
* @param userId
|
* @param name
|
*/
|
int updateUserName(String userId, String name, String mobile);
|
void updateOtherUserById1(String partnerId);
|
int updateOtherUserName(String userId, String name, String mobile);
|
/**
|
* 根据用户ID 更新推广人name
|
* @param userId
|
* @param name
|
*/
|
int updatePromoterName(String userId, String name, String mobile);
|
/**
|
* 推广员查询
|
* @param promoterModel
|
*/
|
List<PromoterModel> queryQromoterList(PromoterModel promoterModel);
|
int queryQromoterListCount(PromoterModel promoterModel);
|
|
List<String> queryCollectorNum(List<String> partnerIds);
|
Map<String,Object> totalWeightAndMoney(String userId,List<String> partnerIds);
|
|
List<UserModel> queryCollectorPageList(PromoterModel promoterModel);
|
List<String> queryCollectorPageCount(PromoterModel promoterModel);
|
List<String> queryUserOrderNum(String userId,List<String> partnerIds,String startTime,String endTime);
|
List<String> queryUserOrderNumExt(List<String> orderIds,String startTime,String endTime);
|
|
List<StorageModel> queryStorageByUserId(StorageModel storageModel);
|
int queryStorageByUserIdCount(StorageModel storageModel);
|
/**
|
* 入库员总数
|
*/
|
int queryStorageNum(List<String> partnerIds);
|
int queryPackageStorageNum(List<String> townIds);
|
List<Map<String,Object>> queryStorageList(UserModel userModel);
|
List<Map<String,Object>> queryStorageList1(UserModel userModel);
|
List<String> queryStorageCount(UserModel userModel);
|
List<String> queryStorageCount1(UserModel userModel);
|
/**
|
* 根据推广员的ID查询推广员的未注册总数，已注册总数，已下单总数
|
* @param userId
|
* @return
|
*/
|
List<PromoterModel> queryQromoterLeven(PromoterModel promoterModel);
|
|
/**
|
* 查询推广员的推广的已完成订单的总重量和总金额
|
* @param userId
|
* @return
|
*/
|
PromoterModel queryPromoterOrderWeightMoney(String userId,String startTime,String endTime);
|
|
int queryAllOrderByUserId(String userId,String startTime,String endTime);
|
/**
|
* 根据时间查询推广员已注册的用户总数
|
* @param userId
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
int queryPromoterRegiterTimeCount(String userId, String startTime, String endTime, String tableName);
|
|
/**
|
* 根据时间查询推广员推广的并已完成的订单的总重量和总金额
|
* @param userId
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
Map<String, Object> queryPromoterOrderCount(String userId, String startTime, String endTime);
|
|
/**
|
* 根据用户ID和手机号码查询账号信息
|
* @param userId
|
* @param phone
|
*/
|
UserAccountModel queryAccountInfo(String userId, String phone);
|
|
List<Map<String,Object>> queryStorageObjectList(StorageModel storageModel);
|
List<String> queryStorageObjectCount(StorageModel storageModel);
|
|
List<Map<String,Object>> querySysStorageList(StorageModel storageModel);
|
int querySysStorageCount(StorageModel storageModel);
|
|
Map<String,Object> querySysStorageAll(StorageModel storageModel);
|
List<String> sysStorageOrderNum(StorageModel storageModel);
|
|
UserModel queryRecoveryById(String userId,String userType);
|
|
int queryDayDiff(StorageModel storageModel);
|
|
List<Map<String,Object>> getSysStorageTypeName(List<String> orderIds,String startTime,String endTime,String typeName);
|
|
List<Map<String,Object>> queryApiArea();
|
List<String> sysStorageIdList();
|
|
List<Map<String,Object>> queryPageSysStorageTypeName(List<String> orderIds,String startTime,String endTime,String typeName,int page,int limit);
|
int queryCountSysStorageTypeName(List<String> orderIds,String startTime,String endTime,String typeName);
|
|
List<String> queryOrderIdsByPartners(List<String> partnerIds);
|
|
List<Map<String,Object>> queryStorageDetailAll(String startTime,String endTime,String typeName);
|
|
List<CollectorModel> queryCollectorApiList(CollectorModel collectorModel);
|
|
int queryCollectorApiCount(CollectorModel collectorModel);
|
|
List<String> orderListByStorageUserId(String storageUserId);
|
|
String querySysStorageNameById(String sysStorageId);
|
|
String queryCollectorWM(String userId);
|
|
List<CollectorModel> queryUnregisteredApiList(CollectorModel collectorModel);
|
int queryUnregisteredApiCount(CollectorModel collectorModel);
|
|
List<UserEditroleModel> queryEditroleApi(UserEditroleModel model);
|
int queryEditroleApiCount(UserEditroleModel model);
|
|
UserModel queryUserOtherInfoById(String userId);
|
UserModel queryUserOtherApiById(String userId,String userType);
|
|
int addCuserAccountRole(String id, String phone, String userId,String money);
|
int addPartnerAccount(PartnerAccountModel model);
|
int updateCuserAccount(String phone, String userId);
|
String queryUserTypeById(String id);
|
String queryEleIdByGid(String gid);
|
int insertUserInfo(UserModel model);
|
int insertUserOtherInfo(UserModel model);
|
int updateUserInfo(UserModel model);
|
|
int insertUserAddress(UserAddressModel model);
|
int updateUserAddress(UserAddressModel model);
|
|
List<UserAddressModel> queryUserAddressList(UserAddressModel model);
|
|
|
String queryProvinceByName(String name);
|
String queryCityByCityName(String name);
|
String queryTownShipByTownName(String name);
|
String queryTownCodeByTownName(String name);
|
List<String> queryElectricTownIds(String partnerId);
|
List<String> queryTownIdsByCode(List<String> townIds);
|
String queryProvinceById(String id);
|
String queryCityByCityId(String id);
|
String queryTownShipByTownId(String id);
|
|
List<Map<String,Object>> queryStoreList();
|
|
List<OrderModel> queryUserOrderApiList(String userId,int page,int limit);
|
int queryUserOrderApiCount(String userId);
|
int updateOtherUserById(String tid,String id,String userType);
|
List<UserModel> checkOtherUserByType(String userType,String mobilePhone);
|
String queryTgNameByRealUserId(String mobilePhone);
|
}
|
