Beispiel #1
0
<?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;
	$count = $temp;
}

$digit1 = (int) ($count % 10);
$digit2 = (int) (($count % 100) / 10);
Beispiel #2
0
    $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";
*/

?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">