function getNextNo($iType, $frm){ $strSQL = "SELECT full_no,next_no from mr where type = '$iType'"; $lastNo = execSQLReturn($strSQL); $lastNOdb = $lastNo['full_no']; $nextNO = $lastNOdb; if ($lastNo['in_use']==1){ if ($lastNo['next_no']==1){ updateNextNo($iType,$lastNo['next_no']+1,$lastNOdb, $frm); $nextNO = $lastNo['full_no']; }else{ $baseType = substr($lastNOdb,0,4); // $baseDate = substr($lastNOdb,4,-4); $baseDate = date("dmy"); $baseFormat = substr($lastNOdb,0,-4); $baseCountZero = substr($lastNOdb,-4); $baseCount = (int)$baseCountZero; $differs = strlen(trim($baseCountZero)) - strlen($baseCount); $zeroMarch=""; for ($s=1;$s<=($differs);$s++){ $zeroMarch .="0"; } $baseCountZero = (int)$lastNo['next_no'] ; $baseFormat = $baseType.$baseDate; $nextNO = $baseFormat.$zeroMarch.$baseCountZero ; updateNextNo($iType,$baseCountZero+1,$nextNO,$frm); } } $useThis = trim($nextNO) ; execSQL("update mr set in_use=1 where type='$iType'"); return ($useThis); }
$toDBDetADisc = $_POST['txtADisc'.$i]; $toDBDetSubtotal = $_POST['txtSubtotal'.$i]; $toDBDetID = $_POST['po_detid'.$i]; $strSQLUpdDet = "UPDATE purchase_orderdetail SET satuan_po='$toDBDetSatuan', harga_po= '$toDBDetHarga', qty_po= '$toDBDetQty', discount='$toDBDetDisc' , amount_discount='$toDBDetADisc', subtotal= '$toDBDetSubtotal', updated_datetime=now(), updated_user='******' WHERE no_po= '$noPO' and fld01= $suppID and no_spb= '$noReq' and id = $toDBDetID "; mysql_query($strSQLUpdDet) or die("FAILED UPPDet.F5!! <br /> Please contact PT. Priatman ");; // print($items. "::" . $strSQLUpdDet . "<br />"); } //die (); $strTmp = "Select SUM(subtotal)as subtotal, count(id) as total_items from purchase_orderdetail WHERE no_po='$noPO' and no_spb= '$noReq' and fld01=$suppID group by no_po "; $fetchTmp = execSQLReturn($strTmp); $subtotalDetail = $fetchTmp['subtotal']; $totalItems = $fetchTmp['total_items']; //die(print "$noPO :: $noReq :: $subtotalDetail :: $items :: $dbPO :: $flags :: $suppID"); $strSQLUpd = "UPDATE purchase_order SET grand_total ='$subtotalDetail', total_items ='$totalItems', flags=3, updated_datetime=now(), updated_user='******' WHERE po_no ='$noPO' and id_supplier='$suppID' and request_no ='$noReq' and id='$poID' "; // die($strSQLUpd); mysql_query($strSQLUpd) or die("FAILED UPPHead.F5!! <br /> Please contact PT. Priatman ".mysql_error()); die("<meta http-equiv='refresh' content='0;url=home.php?hal=content/list_po'>"); break; } /********************************* IGNORE THIS PLEASE **************************************\ $noPO = $_POST['no_po']; $noReq = $_POST['po_reqno'];
<?php /** * @author Richard * @copyright 2011 * @internal purchase order retur processor. */ if(isset($_GET[stream])){ $detID=$_GET[stream]; if (empty($detID)){ echo("<script language='javascript'>window.opener.location.reload();window.close();</script>"); }else{ $poRetNo = getNextNo('RPO','action/po_receive_go'); $poNoRet = getNextNo('PO', 'action/po_receive_go'); $strSQLGet = "SELECT * FROM purchase_orderdetail WHERE id=$detID"; $fetchTmp = execSQLReturn($strSQLGet); $rtrPONO = $fetchTmp['no_po']; $rtrNoReq = $fetchTmp['no_spb']; $rtrSuppID = $fetchTmp['fld01']; $rtrQty = $fetchTmp['qty_po']; $rtrHarga = $fetchTmp['harga_po']; $rtrDisc = $fetchTmp['discount']; $rtrADisc = $fetchTmp['amount_discount']; $rtrSubTot = $fetchTmp['subtotal']; $rtrBarID = $fetchTmp['barang_id']; $strGetMs = "Select kd_barang from ms_barang where id= $rtrBarID"; $rtrBarName= getSingleData($strGetMs); $remarks = "Item Retur: $rtrBarName \n Retur No: $poRetNo"; $strSQLUpd = "UPDATE purchase_order SET remark='$remarks', fld03='$poRetNo', fld04= now(), updated_datetime=now(), updated_user='******' where po_no = '$rtrONO' and request_no= '$rtrNoReq' and id_supplier= $rtrSuppID ";
if (($idPO == 0) || ($isManual==1)){die("<meta http-equiv='refresh' content='0;url=home.php?hal=content/po_man' /> "); }else{ } //print $idPO; $strSQLHeader = "SELECT a.po_no , a.request_no as po_reqno, (date_format(a.tgl_po, '%d/%m/%Y')) as po_tgl, b.nama as supplier, (case a.flags when 1 then 'Closed' when 2 then 'Receiving' when 3 then 'Approved' when 4 then 'Open' when 5 then 'Generated' when 6 then 'Canceled' END) as status, a.created_user as creator, a.flags as flags, a.btb_no, a.penerima, a.total_price, a.percent_discount, a.discount_amount, a.ppn_amount, a.grand_total FROM purchase_order a INNER JOIN pbf b ON a.id_supplier = b.id "; if (!empty($idPO)){$strSQLHeader .= "WHERE a.id = $idPO"; } $resHeader = execSQLReturn($strSQLHeader); global $poSTBNo; global $poSTBUser; global $poTotPrice; global $poTotDisc; global $poTotADisc; global $poTotPPN; global $poTotGrand; global $poStatus; $poNO = $resHeader[po_no]; $poReqNo = $resHeader[po_reqno]; $poDate = $resHeader[po_tgl]; $poCreator = $resHeader[creator]; $poStatus = $resHeader[status]; $poSupplier = $resHeader[supplier]; $flags = $resHeader[flags];
on a.id = d.barang_id inner join purchase_orderdetail b on a.id = b.barang_id left outer join purchase_order c on b.no_po = c.po_no and b.no_spb = c.request_no and b.fld01 = c.id_supplier inner join pbf e on e.id=c.id_supplier where b.f_revisi =0 and c.id=$idPO"; $fetchPrint = execSQLReturn($strPOPrint); ?> <link rel="stylesheet" type="text/css" href="../include/style.css"/> <center><fieldset style="width:90%;"><legend style="background-color:#1bda01;"><b><font color="#fefafa" style="font-size:14px;"> PO no <?=$poNO?> </font></b></legend> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td> <table border="0" width="100%" cellpadding="0" cellspacing="0"> <tr> <td width="8px"> </td> <td width="300px" bgcolor="#9b9999"> <font style="font-size:14px; " color="#fefafa"><b>PURCHASE ORDER </b></font></td> <td></td> </tr> </table> </td>