package com.ibeetl.admin.console.dao;
|
|
import com.ibeetl.admin.console.model.OrderItemModel;
|
import com.ibeetl.admin.console.model.OrderModel;
|
import com.ibeetl.admin.console.model.SysAddressLevelModel;
|
import org.beetl.sql.core.annotatoin.SqlResource;
|
|
import java.util.List;
|
import java.util.Map;
|
|
@SqlResource("console.orderManage")
|
public interface OrderManageDao {
|
/**
|
* 统计所有的总数
|
* @return
|
*/
|
List<Map<String, Object>> queryStaticData(int flag);
|
|
/**
|
* 统计今天的所有总数
|
* @return
|
*/
|
List<Map<String, Object>> queryStaticDataToday(String startTime, String endTime, String receiverphone, int flag);
|
|
/**
|
* 统计详情
|
* @param startTime
|
* @param endTime
|
* @param time
|
*/
|
List<Map<String, Object>> queryDetailList(String startTime, String endTime,
|
String storageUserName, String receiverName,
|
String flag, int page, int limit);
|
|
/**
|
* 统计详情总数
|
* @param startTime
|
* @param endTime
|
* @param flag
|
* @return
|
*/
|
int queryDetailListCount(String startTime, String endTime, String storageUserName, String receiverName, String flag);
|
|
/**
|
* 统计详情里面的总数
|
* @param startTime
|
* @param endTime
|
* @param flag
|
* @return
|
*/
|
List<Map<String, Object>> queryDetailTotal(String startTime, String endTime, int flag);
|
|
/**
|
* 查询回收员的订单号
|
* @param startTime
|
* @param endTime
|
* @param phone
|
* @param page
|
* @param limit
|
* @return
|
*/
|
List<Map<String, Object>> queryUserOrderNo(String startTime, String endTime, String phone, int page, int limit, int flag);
|
int queryUserOrderNoCount(String startTime, String endTime, String phone, int flag);
|
|
/**
|
* 根据订单号统计当前订单的数据总量
|
* @param orderNo
|
* @return
|
*/
|
List<Map<String, Object>> queryTotalForOrderNo(String orderNo, String flag);
|
|
List<Map<String, Object>> queryTotalOrderItemByIds(String[] orderArr, String storageId);
|
|
String queryOrderIdsByStorageId(String storageId);
|
|
|
/**
|
* 根据用户id查询用户的订单
|
*/
|
List<Map<String, Object>> queryCuserOrderByUserId(String userId, List<String> orderStatus, int page, int limit);
|
List<Map<String, Object>> queryCuserOrderByUserIdx(String receiveUserId, List<String> orderStatus, int page, int limit);
|
int queryCuserOrderByUserIdCount(String userId, List<String> orderStatus);
|
Map<String,Object> queryCuserOrderByUserIdCount1(String userId);
|
int queryCuserOrderByUserIdCountx(String receiveUserId, List<String> orderStatus);
|
|
|
/**
|
* 根据订单号查询订单详情
|
* @param orderNo
|
* @return
|
*/
|
List<Map<String, Object>> queryOrderByOrderno(String orderNo);
|
|
String queryOrderByOrderId(String orderId);
|
String queryUserIdByOrderId(String orderId);
|
|
List<Map<String, Object>> queryOrderPageByOrderno(String orderNo,int page,int limit);
|
|
int queryOrderCountByOrderno(String orderNo);
|
|
/**
|
* 查询订单列表
|
* @param orderStatus
|
* @param startTime
|
* @param endTime
|
*/
|
List<Map<String, Object>> queryOrderList(String orderStatus, String startTime, String name, String mobilePhone,
|
String endTime, String orderType,
|
int page, int limit);
|
List<OrderModel> queryOrderApiList(OrderModel orderModel);
|
List<OrderModel> queryOrderByTownIdApiList(OrderModel orderModel);
|
List<String> queryTownIdsByPartnerIds(List<String> partnerIds);
|
int queryOrderListCount(String orderStatus, String startTime, String name, String mobilePhone,
|
String endTime, String orderType);
|
|
int queryOrderApiListCount(OrderModel orderModel);
|
int queryOrderByTownIdsApiListCount(OrderModel orderModel);
|
|
/**
|
* 根据用户Id查询用的订单分类总数
|
* @param userId
|
* @return
|
*/
|
List<Map<String, Object>> queryStatusByCuserId(String userId);
|
String queryOrderByPartnerId(String orderId);
|
String queryTownIdByPartnerId(String townId);
|
|
/**
|
* 根据订单号更新订单状态
|
* @param orderId
|
*/
|
int updateOrderStatus(String orderId, String receiveId, String orderStatus);
|
int updateApirecByOrderId(String orderId,String receiveId,String trid);
|
int updateApirecDetailByOrderId(String orderId,String mobilePhone,String name);
|
int updateOrderStatus1(String orderId, String orderStatus);
|
int updateOrderDetailReData(String orderId,String cancelReasonName);
|
String queryOrderReNum(String userId);
|
List<Map<String,Object>> queryStorageApiList(OrderModel orderModel);
|
int queryStorageApiNum(OrderModel orderModel);
|
|
|
List<Map<String,Object>> queryStorageDetailApiList(List<String> orderIds,int page,int limit);
|
|
List<Map<String,Object>> queryStroageDetailPageByOrderno(List<String> orderIds,String storageId,int page,int limit);
|
|
int queryStroageDetailCountByOrderno(List<String> orderIds,String storageId);
|
|
int addOrderInfoApi(OrderModel orderModel);
|
|
int addOrderDetailApi(OrderModel orderModel);
|
|
int addOrderItem(List<OrderItemModel> list);
|
|
List<SysAddressLevelModel> queryProvince();
|
List<SysAddressLevelModel> queryCityByProvinceId(String provinceId);
|
List<SysAddressLevelModel> queryTownShipByCityId(String cityId);
|
}
|
