| 123456789101112131415161718 |
- select
- itde.goods_id as goodsId,
- goods.goods_code as pnumber,
- goods.goods_name as pname ,
- goods.specification as specType ,
- itde.measure_unit as measureUnit
- from t_b_materialsusing_detail itde
- left join t_b_materialsusing it on itde.fk_id = it.id
- left join t_b_goods_info goods on itde.goods_id = goods.id
- where 1= 1
- and it.order_onumber in (select max(order_onumber) from t_b_materialsusing
- where 1 = 1
- <#if ( warehouseid )?? && warehouseid ?length gt 0>
- /* 仓库 */
- and warehouse_id = :warehouseid
- </#if>
- )
|
