</script> </head> <body> <?php $tahun = date("y"); $qp = mysql_query("SELECT * FROM mr WHERE type='SPB'"); $rp = mysql_fetch_array($qp); $lastNO = $rp['full_no']; $tgl = substr($lastNO,8,2); if ($tgl == $tahun) { $count = $rp['next_no']; $no_req = getNextNo('SPB', 'content/mr_auto'); } else { $count = 1; $no_req = resetNo('SPB','content/mr_auto'); } /* if ($tgl == $tahun) { $temp = $rp['param_no']; $count = $temp + 1; } else { $temp = 1;
/* NOTHING TODO THIS TRANSACTION ALREADY TERMINATED */ die("<meta http-equiv='refresh' content='0;url=home.php?hal=content/list_po'>"); break; case 2: //die(print "$noPO :: $noReq :: $lastNO :: $items :: $dbPO :: $flags :: $suppID :: 2 :: $toDBDetID"); /* CHANGED PO STATUS TO (CLOSED) */ /* IF IT's ALREADY ON (CLOSED) STATUS THEN NOTHING TODO */ $items = $_POST['param']; if(empty($noPO)) {$noPO = $_POST['pono'];} if(empty($noReq)) {$noReq = $_POST['no_req'];} if(empty($suppID)) {$suppID = $_POST['posupplier'];} if(empty($noBTB)) {$noBTB = $_POST['nobtb'];} if(empty($poID)) {$poID = $_POST['idPO'];} if(empty($poSTBNo)){ $poSTBNo= $_POST['poSTBNo']; if(empty($poSTBNo)){getNextNo('STB','action/generate_po');} } if(empty($poSTBUser)){ $poSTBUser = $_POST['poSTBUser']; if(empty($poSTBUser)){$poSTBUser=$userLoged;} } for($i=1;$i<=$items;$i++){ $toDBDetID = $_POST['po_detid'.$i]; $exDate = $_POST['txtExpDate'.$i]; $strSQLUpdDet = "UPDATE purchase_orderdetail SET fld02='$poSTBNo', fld03='$poSTBUser', updated_datetime=now(), updated_user='******', fld05='$exDate' WHERE no_po= '$noPO' and fld01= $suppID and no_spb= '$noReq' and id = $toDBDetID"; //(print "$noPO :: $noReq :: $lastNO :: $items :: $dbPO :: $flags :: $suppID :: 2 :: $toDBDetID"); mysql_query($strSQLUpdDet) or die("FAILED UPPDet.F2!! <br /> Please contact PT. Priatman "); $strSQLUpdHarga = "INSERT INTO set_harga (barang_id, exp_date, po_no, po_date, price_ms_date,
function reserveNo($type,$frm){ //getNO($type); $ret = getNextNo($type,$frm); return($ret); }
echo "<meta http-equiv='refresh' content='0;url=home.php?hal=content/list_spb_man' /> "; // header("Location: home.php?hal=content/list_spb_man"); }else{ $spb_no = getSingleData("select spb_no from head_spb where id = $idSPB") ; $tahun = date("y"); //$qp= mysql_query("SELECT * FROM mr WHERE LAST_INSERT_ID(param_no) ORDER BY id DESC LIMIT 1"); $qp = mysql_query("SELECT * FROM mr WHERE type='PO'"); $rp = mysql_fetch_array($qp); $lastNO = $rp['full_no']; $isUse = $rp['in_use']; $tgl = substr($lastNO,8,2); if ($tgl == $tahun) { $count = $rp['next_no']; if ((empty($isUse))||($isUse==1)){ $no_req = getNextNo('PO', 'content/list_spb'); }else{ $count = 1; $no_req = resetNo('PO','content/list_spb'); } } } $param_no = $count; /* $digit1 = (int) ($count % 10); $digit2 = (int) (($count % 100) / 10); $digit3 = (int) (($count % 1000) / 100); $digit4 = (int) (($count % 10000) / 1000); $no_req = "PON/" . date("dmy"). "$digit4" . "$digit3" . "$digit2" . "$digit1"; */
<?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 ";