01.
02. $qty="select count(*) as item, po_num,po_line, location FROM joborder_stock.dbo.st_sn where project in('".implode("','",$project_name)."')and location = '".$order_no."' group by po_num,po_line,location";
03.
04. $params2 = array();
05. $options2 = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
06. $qtyup = sqlsrv_query( $conn_stock, $qty , $params2, $options2 );
07. $row_qtyup = sqlsrv_num_rows( $qtyup );
08. while($rowsrv_qty = sqlsrv_fetch_array( $qtyup, SQLSRV_FETCH_ASSOC) ) {
09. $qtyck="SELECT qty_use FROM joborder_stock.dbo.st_erp where po_num = '".$rowsrv_qty['po_num']."' and po_line ='".str_replace(' ','',$rowsrv_qty['po_line'])."' ";
10.
11. $stqty = sqlsrv_query( $conn_stock, $qtyck );
12. if($rowqty = sqlsrv_fetch_array( $stqty, SQLSRV_FETCH_ASSOC) ) {
13.
14. $num = $rowsrv_qty[item]+$rowqty[qty_use];
15.
16.
17.
18.
19.
20. $qty = "update joborder_stock.dbo.st_erp set qty_use='".$num."' where po_num = '".$rowsrv_qty['po_num']."' and po_line='".$rowsrv_qty['po_line']."'";
21.
22. $result_qty =sqlsrv_query( $conn_stock, $qty);
23. }
24. }
