package cn.com.lzt.ordersfixasset.dao;

import cn.com.lzt.ordersfixasset.entity.OrderFixAssetProductsEntity;
import cn.com.lzt.ordersfixasset.entity.OrdersFixAssetEntity;
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.springframework.stereotype.Repository;

import java.util.List;

@Repository
@MiniDao
public interface OrdersFixAssetDao {
	
	@Sql(" select pnumber,pname,spec_type as specType,measure_unit as measureUnit,purchase_price as purchasePrice,goods_id as goodsId from t_b_order_products where fk_id in ( select id  from (SELECT id FROM t_b_orders where order_months in  ( SELECT max(order_months) FROM t_b_orders \n" + 
			"	WHERE  warehouse_id = :warehouseid ) and warehouse_id = :warehouseid ORDER BY create_date ASC LIMIT 1 ) temp )")
	public List<OrderFixAssetProductsEntity> getLastOrderProducts(@Param("warehouseid") String warehouseid);
	
	
	/**
	 * 根据货品分类大类获取货品明细
	 * */
	public List<OrderFixAssetProductsEntity> getOrderProductsOrderByCategory(@Param("orderid") String orderid);

	/**
	 *选择物料签报明细，报销用 ，对外付款
	 */
	@ResultType(OrderFixAssetProductsEntity.class)
	public List<OrderFixAssetProductsEntity> getOrderProducts4CostPay(@Param("entity") OrderFixAssetProductsEntity entity,@Param("userId") String userId
			,@Param("projectUser") boolean projectUser,@Param("warehouseIdList") List<String> warehouseIdList);
	/**
	 *选择物料签报，报销用，员工报销
	 */
	@ResultType(OrdersFixAssetEntity.class)
    List<OrdersFixAssetEntity> getOrders4CostPay(@Param("entity")OrdersFixAssetEntity entity, @Param("userId")String userId
			,@Param("projectUser") boolean projectUser, @Param("warehouseIdList")List<String> warehouseIdList);
}