Controller Quotation

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