package com.ibeetl.admin.console.dao;

import com.ibeetl.admin.console.model.BannerModel;
import com.ibeetl.admin.console.model.ItemModel;
import com.ibeetl.admin.console.model.StorageModel;
import com.ibeetl.admin.core.entity.CoreAudit;
import com.ibeetl.admin.core.entity.CoreSetMoney;
import org.beetl.sql.core.annotatoin.SqlResource;
import org.beetl.sql.core.engine.PageQuery;
import org.beetl.sql.core.mapper.BaseMapper;

import java.util.List;
import java.util.Map;

@SqlResource("console.setting")
public interface SettingConsoleDao extends BaseMapper<CoreAudit> {

    PageQuery<CoreSetMoney> queryByCondtion(PageQuery<CoreSetMoney> query);

    int updateAgentPrice(CoreSetMoney money);
    int updateTimeInterval(CoreSetMoney money);
    int updateStratTime(CoreSetMoney money);
    int updateEndTime(CoreSetMoney money);
    int updateOverdrawPrice(CoreSetMoney money);
    int updateRechargePrice(CoreSetMoney money);
    int updateOrderTotal(CoreSetMoney money);
    int updateOrderTimeout(CoreSetMoney money);
    int updateWarehousingPrice(CoreSetMoney money);

    Map<String, Object> queryOverdrawPrice();
    Map<String, Object> queryWarehousingPrice();
    Map<String, Object> queryOrderTotal();

    /**
     * 更新account表的额度，已经修改过的额度除外
     * @param newOverdrawPrice 新额度
     * @param oldOverdrawPrice 旧额度
     * @return
     */
    int updateAccountOverdrawPrice(String newOverdrawPrice, String oldOverdrawPrice,List<String> orderIds,String oldFixPrice);
    List<String> queryRKOrderIds(String limitPrice,String type);
    int updateAccountWarehousingPrice(String newOverdrawPrice, String oldOverdrawPrice,List<String> orderIds,String oldFixPrice);
    /*
    ====物品分类===================================================================
     */

    /**
     * 查询
     * @param item
     */
    List<ItemModel> querIteml(ItemModel item);
    List<ItemModel> querIteml1(ItemModel item);
    int queryItemCount(ItemModel item);


    /**
     * 查询所有未删除的
     * @return
     */
    List<ItemModel> queryItemAll();

    /**
     * 插入
     * @param item
     */
    int insertItem(ItemModel item);

    int insertItemOperate(ItemModel item);
    int insertItemOperate1(ItemModel item);

    /**
     * 删除
     * @param item
     */
    int delItem(ItemModel item);
    int delItem1(ItemModel item);

    /**
     * 更新
     * @param item
     */
    int updateItem(ItemModel item);
    int updateItem1(ItemModel item);



    // -----仓库管理--------------------------------------------------------

    /**
     * 查询仓库列表
     * @param storageModel
     * @return
     */
    List<StorageModel> queryStorageList(StorageModel storageModel);
    int queryStorageListCount(StorageModel storageModel);

    List<Map<String,Object>> queryAllStorage();
    /**
     * 插入一条仓库
     * @param storageModel
     * @return
     */
    int addStorage(StorageModel storageModel);

    /**
     * 更新仓库
     * @param storageModel
     * @return
     */
    int updateStorage(StorageModel storageModel);

    /**
     * 删除仓库
     * @param storageModel
     * @return
     */
    int delStorage(StorageModel storageModel);


    // ---banner管理------------------------------------------

    /**
     * 查询
     * @param bannerModel
     * @return
     */
    List<BannerModel> queryBannerList(BannerModel bannerModel);
    int queryBannerListCount(BannerModel bannerModel);

    /**
     * 添加
     * @param bannerModel
     * @return
     */
    int insertBanner(BannerModel bannerModel);

    /**
     * 更新
     * @param bannerModel
     * @return
     */
    int updateBanner(BannerModel bannerModel);

    /**
     * 删除
     * @param id
     * @return
     */
    int delBanner(String id);

    int updateOverdrawPriceByUserId(String accountId,String money);

    int updateLimitByUserId(String accountId,String money);

}