Advertisement
Guest User

model untuk mendapatkan no pendaftaran

a guest
Jul 18th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.77 KB | None | 0 0
  1. function no_pendaftaran()  
  2.     {
  3.         $this->db->select('RIGHT(formulir.id_formulir,4) as kode', FALSE);
  4.         $this->db->order_by('id_formulir','DESC');    
  5.         $this->db->limit(1);    
  6.           $data = $this->db->get('formulir');      //cek dulu apakah ada sudah ada kode di tabel.    
  7.           if($data->num_rows() <> 0){      
  8.            //jika kode ternyata sudah ada.      
  9.             $data = $data->row();      
  10.             $kode = intval($data->kode) + 1;    
  11.           }
  12.           else {      
  13.            //jika kode belum ada      
  14.             $kode = 1;    
  15.           }
  16.           $kodemax = str_pad($kode, 4, "0", STR_PAD_LEFT); // angka 4 menunjukkan jumlah digit angka 0
  17.           $tanggal=date('/Ymd');
  18.           $dinas="/4JO/KDI";
  19.           $kodejadi =  $kodemax.$tanggal.$dinas;    // hasilnya ODJ-9921-0001 dst.
  20.           return $kodejadi;  
  21.         }
  22.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement