package cn.com.lzt.orders.dao;

import java.util.List;

import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.jeecgframework.minidao.annotation.Sql;
import org.springframework.stereotype.Repository;

import cn.com.lzt.orderproducts.entity.OrderProductsEntity;

@Repository
@MiniDao
public interface OrdersDao {
	
	@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<OrderProductsEntity> getLastOrderProducts(@Param("warehouseid")String warehouseid);
	
	
	/**
	 * 根据货品分类大类获取货品明细
	 * */
	public List<OrderProductsEntity> getOrderProductsOrderByCategory(@Param("orderid")String orderid);

}