| 123456789 |
- select t1.*,t2.name saler_name,t3.sumamount from sa_order t1
- left join sys_hr t2 on t2.hrid=t1.saler_hrid and t2.siteid=t1.siteid
- left join (select sa_orderid,siteid,sum(amount) sumamount from sa_orderitems group by sa_orderid,siteid) t3 on t3.sa_orderid=t1.sa_orderid and t3.siteid=t1.siteid
- where
- $where$
- and t1.type !='工具借用单' and t1.type!='配件订单'
- and t1.status in('审核','关闭')
- and t1.siteid=$siteid$
- and t1.sys_enterpriseid=$sys_enterpriseid$
|
