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