package cn.com.lzt.budget.data.dao;

import cn.com.lzt.arrangeduty.dto.ProjectDepartDto;
import cn.com.lzt.budget.data.dto.BudgetContractEntity;
import cn.com.lzt.budget.inst.dto.BudgetInstDto;
import cn.com.lzt.budget.inst.entity.BudgetInstEntity;
import cn.com.lzt.goodsinfo.entity.TBGoodsInfoEntity;
import cn.com.lzt.orderproducts.entity.OrderProductsEntity;
import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.jeecgframework.minidao.annotation.ResultType;
import org.jeecgframework.minidao.annotation.Sql;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.springframework.stereotype.Repository;

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

@Repository
@MiniDao
public interface BudgetDataDao {

	@ResultType(TBGoodsInfoEntity.class)
	public List<TBGoodsInfoEntity> getUsedGoodsInfoByTime(@Param("startTime") Date startTime,@Param("endTime") Date endTime,@Param("categoryCodeList")List<String> categoryCodeList,@Param("warehouseIdList")List<String> warehouseIdList);

	/**
	 * 获得商品年度使用情况
	 */
	public List<Map<String,Object>> getOneGoodsRefYearUsed(@Param("id") String id, @Param("startTime") Date startTime, @Param("endTime")Date endTime,@Param("warehouseIdList")List<String> warehouseIdList);

	@ResultType(BudgetContractEntity.class)
	public List<BudgetContractEntity> getContractInfoByYear(@Param("year") String year,@Param("exclude")List<String> excludeEntityIdList);

}