Example #1
0
</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;
Example #2
0
     /* 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, 
Example #3
0
function reserveNo($type,$frm){
    //getNO($type);
    $ret = getNextNo($type,$frm);
    return($ret);
}
Example #4
0
    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";
*/
Example #5
0
<?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 ";