Controller My

function getIKKID() {
     global $cfg;
     $objDB = new Database();
     try {
         $query="SELECT max(substr(no_invoice_keluar,8,5)) as no_invoice_keluar FROM invoice_keluar_kontrak where substr(no_invoice_keluar,2,6)='".date('ymd')."'";
         //call select methods to retreive max id Order 00001
         $data=$objDB->select($query);
         foreach($data as $item):
             $xid=$item['no_invoice_keluar'];
             if(!isset($item['no_invoice_keluar'])) {
                 $maxid="V".date('ymd')."00001";
             }
             else if(substr($xid,0,4)=="0000") {
                    if(substr($xid,0,5)=="0009")
                     $maxid = "V".date('ymd')."000".(intval(substr($xid,4,1))+1);
                    else
                     $maxid = "V".date('ymd')."0000".(intval(substr($xid,4,1))+1);
             } else if(substr($xid,0,3)=="000" && substr($xid,0,4)!="0000") {
                 if(substr($xid,0,5)=="0099")
                     $maxid = "V".date('ymd')."00".(intval(substr($xid,3,2))+1);
                 else
                     $maxid = "V".date('ymd')."000".(intval(substr($xid,3,2))+1);
                 } else if(substr($xid,0,2)=="00" && substr($xid,0,3)!="000") {
                 if(substr($xid,0,5)=="0999")
                     $maxid = "V".date('ymd')."0".(intval(substr($xid,2,3))+1);
                 else
                     $maxid = "V".date('ymd')."00".(intval(substr($xid,2,3))+1);
                 } else if(substr($xid,0,1)=="0" && substr($xid,0,2)!="00") {
                    $maxid = "V".date('ymd')."0".(intval(substr($xid,1,4))+1);
                 } else
                 $maxid = "V".date('ymd').substr($xid,0,5)+1;
         endforeach;
     } catch (Exception $e) {
         echo "Query failure" . NL;
         echo $e->getMessage();
     }
     return $maxid;
    }