package com.cjs.cms.dao.ration;

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

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import com.cjs.cms.model.ration.TrustApplyExtInfo;
import com.cjs.cms.util.db.OracleDao;

/**
 * 托管信息附加表(在交易系统oracle库的hs_asset用户下)
 * 
 * @author tongyufu
 *
 */
@Repository
public interface TrustApplyExtDao extends OracleDao {

    /**查询指定藏品的客户同意配售数量*/
    Integer queryAggreeCount(String otcCode);

    /**查询指定藏品的客户同意配售列表*/
    List<TrustApplyExtInfo> queryAggreeList(String otcCode);

    /**查询指定单号托管信息*/
    TrustApplyExtInfo queryTrunstApply(String applyNo);

    /**
     * 修改配售状态(0:待同意；1:待交割；2:已入库)
     * @param applyNo
     * @param aggreeStatus 配售状态(0:待同意；1:待交割；2:已入库)
     * @return
     */
    int updateAggreeStatus(@Param("applyNo") String applyNo,
                           @Param("aggreeStatus") String aggreeStatus);

    /** 查询还未同意配售的用户列表*/
    List<Map<String, Object>> queryUserListNotAgree(String otcCode);

    /**可配售总量*/
    Integer queryTotalCount(String otcCode);

    /**查询用户同意与否状况*/
    List<Map<String, Object>> queryAgreeInfoByConditions(Map<String, Object> params);

    /**查询用户同意与否数量*/
    int queryAgreeInfoAmount(Map<String, Object> params);

    /**查询通过数量统计*/
    Integer querySumApprovalCount(Map<String, Object> params);

    /**再托管_查询再托管申请通过总量*/
    int queryApplyTotal(Map<String, Object> params);

    void insertTrustApplyExt(TrustApplyExtInfo extInfo);

    /**
     * 根据藏品代码删除
     */
    void deleExtByOtcCode(String otcCode);

    /**
     * 批量插入
     * @param otccode
     */
    void insertExtByCode(String otccode);

    /**
     * 在入库申请列表
     */
    List<Map<String, Object>> searchPick(Map<String, Object> params);

    int searchPickTotal(Map<String, Object> params);

    /**
     * 根据编号查询托管单
     */
    Map<String, Object> queryByNo(String applyNo);

    List<Map<String, Object>> exportPick();

    int updatePick(String applyNo);
}