API tools faq
paste
Advertisement
cod3yoda

Form_Validaiton

cod3yoda
Aug 17th, 2021
1,003
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 39.90 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. class Pendaftar extends ci_controller{
  3.     function __construct(){
  4.         parent::__construct();
  5.  
  6.         if($this->session->userdata('hakakses') != 'admin' and $this->session->userdata('hakakses') != 'operator' and $this->session->userdata('hakakses') != 'pendaftar'){
  7.             redirect('Login');
  8.         }
  9.  
  10.         date_default_timezone_set('Asia/Jakarta');
  11.     }
  12.     function index(){
  13.         redirect('Login');
  14.     }
  15.  
  16.     function NextId(){
  17.         $nextid=$this->db->query("select ifnull(max(no_pendaftar),0) as nextid from t_pendaftar")->row()->nextid;
  18.         if($nextid=='0'){
  19.             $nextid='CP0001';
  20.         }else{
  21.             $nextid=substr($nextid,2,4)+1;
  22.             $nextid="CP".substr("0000",0,4 - strlen($nextid)) . $nextid;
  23.         }
  24.        
  25.         return $nextid;
  26.     }
  27.  
  28.     function next_no_antrian($tgl){
  29.         $hasil=$this->db->query("select ifnull(max(no_antrian),0)+1 as nextno from t_pendaftar where tgl_penyerahan='$tgl'")->row()->nextno;
  30.         return $hasil;
  31.     }
  32.  
  33.     function cari_jml_penyerahan(){
  34.         $tgl=$this->input->post('cariisi');
  35.         $jml=$this->db->query("select count(*) as jml from t_pendaftar where tgl_penyerahan='".$tgl."'")->row()->jml;
  36.         $temp="";
  37.         if($jml<=150){
  38.             $temp=true;
  39.         }else{
  40.             $temp=false;
  41.         }
  42.  
  43.         echo $temp;
  44.     }
  45.  
  46.  
  47.     function cari_isi_juara(){
  48.         $id=$this->input->post('cariisi');
  49.         if($id==4){
  50.             $temp="<option value=''>- Pilih -</option>
  51.            <option value='4'>Rangking 1</option>
  52.            <option value='5'>Rangking 2</option>
  53.            <option value='6'>Rangking 3</option>";
  54.         }else{
  55.             $temp="<option value=''>- Pilih -</option>
  56.            <option value='1'>Juara 1</option>
  57.            <option value='2'>Juara 2</option>
  58.            <option value='3'>Juara 3</option>";
  59.         }
  60.         echo $temp;
  61.     }
  62.  
  63.     function cari_isi_kabupaten(){
  64.         $id=$this->input->post('cariisi');
  65.         $data=$this->db->query("select * from t_kabupaten where id_provinsi='".$id."'")->result();
  66.         $temp="<option value=''>- Pilih -</option>";
  67.         foreach($data as $d){
  68.             $temp=$temp."<option value='".$d->id_kabupaten."'>".$d->nama_kabupaten."</option>";
  69.         }
  70.         echo $temp;
  71.     }
  72.  
  73.     function cari_isi_kecamatan(){
  74.         $id=$this->input->post('cariisi');
  75.         $data=$this->db->query("select * from t_kecamatan where id_kabupaten='".$id."'")->result();
  76.         $temp="<option value=''>- Pilih -</option>";
  77.         foreach($data as $d){
  78.             $temp=$temp."<option value='".$d->id_kecamatan."'>".$d->nama_kecamatan."</option>";
  79.         }
  80.         echo $temp;
  81.     }
  82.  
  83.     function cari_isi_kelurahan(){
  84.         $id=$this->input->post('cariisi');
  85.         $data=$this->db->query("select * from t_kelurahan where id_kecamatan='".$id."'")->result();
  86.         $temp="<option value=''>- Pilih -</option>";
  87.         foreach($data as $d){
  88.             $temp=$temp."<option value='".$d->id_kelurahan."'>".$d->nama_kelurahan."</option>";
  89.         }
  90.         echo $temp;
  91.     }
  92.  
  93.     function zonasi(){
  94.         $data['title'] = 'Jalur Zonasi';
  95.         $data['pendaftar'] = $this->db->query("select p.*,avg(n.rerata) as na from t_pendaftar p left join t_nilai n on p.no_pendaftar=n.no_pendaftar where jalur='1' group by no_pendaftar order by no_pendaftar ")->result();
  96.         $data['quota']=$this->db->query("select quota from t_jalur where id_jalur='1'")->row()->quota;
  97.         $data['file']='Admin/Pendaftar/data_zonasi';
  98.         $this->load->view('Admin/Main',$data);
  99.     }
  100.  
  101.     function prestasi(){
  102.         $data['title'] = 'Jalur Prestasi';
  103.         $data['pendaftar'] = $this->db->query("select p.*,avg(n.rerata) as na from t_pendaftar p left join t_nilai n on p.no_pendaftar=n.no_pendaftar where jalur='2' group by no_pendaftar order by no_pendaftar")->result();
  104.         $data['quota']=$this->db->query("select quota from t_jalur where id_jalur='2'")->row()->quota;
  105.         $data['file']='Admin/Pendaftar/data_prestasi';
  106.         $this->load->view('Admin/Main',$data);
  107.     }
  108.  
  109.     function afirmasi(){
  110.         $data['title'] = 'Jalur Afirmasi';
  111.         $data['pendaftar'] = $this->db->query("select p.*,avg(n.rerata) as na from t_pendaftar p left join t_nilai n on p.no_pendaftar=n.no_pendaftar where jalur='3' group by no_pendaftar order by no_pendaftar")->result();
  112.         $data['quota']=$this->db->query("select quota from t_jalur where id_jalur='3'")->row()->quota;
  113.         $data['file']='Admin/Pendaftar/data_afirmasi';
  114.         $this->load->view('Admin/Main',$data);
  115.     }
  116.  
  117.     function perpindahan(){
  118.         $data['title'] = 'Jalur Perpindahan';
  119.         $data['pendaftar'] = $this->db->query("select p.*,avg(n.rerata) as na from t_pendaftar p left join t_nilai n on p.no_pendaftar=n.no_pendaftar where jalur='4' group by no_pendaftar order by no_pendaftar")->result();
  120.         $data['quota']=$this->db->query("select quota from t_jalur where id_jalur='4'")->row()->quota;
  121.         $data['file']='Admin/Pendaftar/data_perpindahan';
  122.         $this->load->view('Admin/Main',$data);
  123.     }
  124.  
  125.     function prestasi_akademik(){
  126.         $data['title'] = 'Jalur Prestasi Akademik';
  127.         $data['pendaftar'] = $this->db->query("select p.*,avg(n.rerata) as na from t_pendaftar p left join t_nilai n on p.no_pendaftar=n.no_pendaftar where jalur='5' group by no_pendaftar order by no_pendaftar")->result();
  128.         $data['quota']=$this->db->query("select quota from t_jalur where id_jalur='5'")->row()->quota;
  129.         $data['file']='Admin/Pendaftar/data_prestasi_akademik';
  130.         $this->load->view('Admin/Main',$data);
  131.     }
  132.  
  133.     function abk(){
  134.         $data['title'] = 'Jalur Anak Berkebutuhan Khusus';
  135.         $data['pendaftar'] = $this->db->query("select p.*,avg(n.rerata) as na from t_pendaftar p left join t_nilai n on p.no_pendaftar=n.no_pendaftar where jalur='6' group by no_pendaftar order by no_pendaftar")->result();
  136.         $data['quota']=$this->db->query("select quota from t_jalur where id_jalur='6'")->row()->quota;
  137.         $data['file']='Admin/Pendaftar/data_abk';
  138.         $this->load->view('Admin/Main',$data);
  139.     }
  140.    
  141.     function import_pendaftar(){
  142.         $data['title'] = 'Import Data Pendaftar';
  143.         $data['file']='Admin/Pendaftar/Pendaftar_import';
  144.         $this->load->view('Admin/Main',$data);
  145.     }
  146.    
  147.     function import_pendaftar_proses(){
  148.         $this->load->library(array('PHPExcel','PHPExcel/IOFactory'));
  149.         delete_files('./assets/files/temp/',TRUE);
  150.         $config['upload_path'] = './assets/files/temp/';
  151.         $config['allowed_types'] = '*';
  152.         $config['file_name']='pendaftar';
  153.         $this->upload->initialize($config);
  154.         if(!$this->upload->do_upload('userfile')){
  155.             $hasil=0;
  156.         }
  157.         else{
  158.             $file=$this->upload->data('userfile');
  159.             $dbName = $file['full_path'];
  160.             ini_set('memory_limit', '-1');
  161.             ini_set('max_execution_time', 1000);
  162.             ini_set('post_max_size', '128M');
  163.             ini_set('upload_max_filesize', '128M');
  164.             if (!file_exists($dbName)) {
  165.                 die("Could not find database file.");
  166.             }else{
  167.                 $hasil=1;
  168.             }
  169.                     //baca data excel
  170.             try {
  171.                 $inputFileType = IOFactory::identify($dbName);
  172.                 $objReader = IOFactory::createReader($inputFileType);
  173.                 $objPHPExcel = $objReader->load($dbName);
  174.             } catch(Exception $e) {
  175.                 die('Error loading file "'.pathinfo($dbName,PATHINFO_BASENAME).'": '.$e->getMessage());
  176.             }
  177.  
  178.                     //  Get worksheet dimensions
  179.             $sheet = $objPHPExcel->getSheet(0);
  180.             $highestRow = $sheet->getHighestRow();
  181.             $highestColumn = $sheet->getHighestColumn();
  182.  
  183.                     //  Loop through each row of the worksheet in turn
  184.                 for ($row = 2; $row <= $highestRow; $row++){                  //  Read a row of data into an array                
  185.                     $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row,
  186.                         NULL,
  187.                         TRUE,
  188.                         FALSE);
  189.  
  190.                     $nisn=$rowData[0][0] == null?' ':$rowData[0][0];
  191.                     $nama=$rowData[0][1] == null?' ':$rowData[0][1];
  192.                     $jk=$rowData[0][2] == null?' ':$rowData[0][2];
  193.                     $tahun_keluar=$rowData[0][3] == null?' ':$rowData[0][3];
  194.                     $status=$rowData[0][4] == null?' ':$rowData[0][4];
  195.                     $data = array(
  196.                         'nisn'=> strtoupper($nisn),
  197.                         'nama'=> strtoupper($nama),
  198.                         'jk'=> strtoupper($jk),
  199.                         'tahun_keluar'=> strtoupper($tahun_keluar),
  200.                         'status'=> strtoupper($status),
  201.                     );
  202.  
  203.                         //import data pendaftar
  204.                     $cek = $this->db->query("select * from t_pendaftar where nisn='".$nisn."'");
  205.                     if($cek->num_rows() == 0){
  206.                         $hasil=$this->db->insert("t_pendaftar",$data);
  207.                     }
  208.                     else{
  209.                         $this->db->where(array('nisn'=>$nisn));
  210.                         $hasil=$this->db->update('t_pendaftar',$data);
  211.                     }
  212.  
  213.  
  214.                 }
  215.             }
  216.             $this->session->set_flashdata('alert',$hasil);
  217.             redirect('Admin/Pendaftar/index');
  218.         }
  219.  
  220.         function delete_pendaftar($jalur,$id){
  221.             if($id != null){
  222.             // delete file, if exists...
  223.                 $row=$this->db->query("select * from t_pendaftar where no_pendaftar='".$id."'")->row();
  224.                 $image_path = 'assets/images/pendaftar/';
  225.                 //hapus foto
  226.                 if($row->foto){
  227.                     $filename = $image_path . $row->foto;
  228.                     if (file_exists($filename))
  229.                     {
  230.                         unlink($filename);
  231.                     }
  232.                 }
  233.                
  234.  
  235.                 //hapus scan_skhun
  236.                 if($row->scan_skhun){
  237.                     $filename = $image_path . $row->scan_skhun;
  238.                     if (file_exists($filename))
  239.                     {
  240.                         unlink($filename);
  241.                     }
  242.                 }
  243.  
  244.                 //hapus scan_dta
  245.                 if($row->scan_dta){
  246.                     $filename = $image_path . $row->scan_dta;
  247.                     if (file_exists($filename))
  248.                     {
  249.                         unlink($filename);
  250.                     }
  251.                 }
  252.                
  253.  
  254.                 //hapus scan_akta
  255.                 if($row->scan_akta){
  256.                  $filename = $image_path . $row->scan_akta;
  257.                  if (file_exists($filename))
  258.                  {
  259.                     unlink($filename);
  260.                 }
  261.             }
  262.  
  263.  
  264.                 //hapus scan_kk
  265.             if($row->scan_kk){
  266.                 $filename = $image_path . $row->scan_kk;
  267.                 if (file_exists($filename))
  268.                 {
  269.                     unlink($filename);
  270.                 }
  271.             }
  272.  
  273.  
  274.                 //hapus scan_nisn
  275.             if( $row->scan_nisn){
  276.               $filename = $image_path . $row->scan_nisn;
  277.               if (file_exists($filename))
  278.               {
  279.                 unlink($filename);
  280.             }  
  281.         }
  282.  
  283.  
  284.                 //hapus scan_ketm
  285.         if($row->scan_ketm){
  286.             $filename = $image_path . $row->scan_ketm;
  287.             if (file_exists($filename))
  288.             {
  289.                 unlink($filename);
  290.             }
  291.         }
  292.  
  293.  
  294.                 //hapus scan_prestasi
  295.         if($row->scan_prestasi){
  296.           $filename = $image_path . $row->scan_prestasi;
  297.           if (file_exists($filename))
  298.           {
  299.             unlink($filename);
  300.         }  
  301.     }
  302.  
  303.  
  304.                 //hapus scan_perpindahan
  305.     if($row->scan_perpindahan){
  306.         $filename = $image_path . $row->scan_perpindahan;
  307.         if (file_exists($filename))
  308.         {
  309.             unlink($filename);
  310.         }
  311.     }
  312.  
  313.             //end
  314.  
  315.  
  316.     $this->db->where(array('no_pendaftar'=>$id));
  317.     $hasil=$this->db->delete('t_pendaftar');
  318. }
  319. $this->session->set_flashdata('alert', $hasil);
  320.  
  321. switch($jalur){
  322.     case 1:redirect('Admin/Pendaftar/zonasi');break;
  323.     case 2:redirect('Admin/Pendaftar/prestasi');break;
  324.     case 3:redirect('Admin/Pendaftar/afirmasi');break;
  325.     case 4:redirect('Admin/Pendaftar/perpindahan');break;
  326.     default :redirect('Admin/Pendaftar');break;         }
  327.  
  328. }
  329.  
  330. function input_pendaftar($getpemanggil=null,$getnopendaftar=null){
  331.     $this->form_validation->set_rules('nik', 'NIK', 'required|is_unique[pendaftar.nik]');
  332.       if ($this->form_validation->run() == FALSE)
  333.                 {
  334.  
  335.     if($this->input->post('getpemanggil')){
  336.         $getpemanggil=$this->input->post('getpemanggil');
  337.     }
  338.  
  339.  
  340.     if($this->input->post('nama')){
  341.  
  342.         if($this->input->post('no_pendaftar')){
  343.             $no_pendaftar=$this->input->post('no_pendaftar');
  344.             $pendaftar=$this->db->query("select * from t_pendaftar where no_pendaftar='$no_pendaftar'")->row();
  345.             $image_path="assets/images/pendaftar/";
  346.             $filenamefoto = $image_path . $pendaftar->foto;
  347.             $filenameskhun = $image_path . $pendaftar->scan_skhun;
  348.             $filenamedta = $image_path . $pendaftar->scan_dta;
  349.             $filenameakta = $image_path . $pendaftar->scan_akta;
  350.             $filenamekk = $image_path . $pendaftar->scan_kk;
  351.             $filenamenisn = $image_path . $pendaftar->scan_nisn;
  352.             $filenameketm = $image_path . $pendaftar->scan_ketm;
  353.             $filenameprestasi = $image_path . $pendaftar->scan_prestasi;
  354.             $filenameperpindahan = $image_path . $pendaftar->scan_perpindahan;
  355.         }else{
  356.             $no_pendaftar=$this->NextId();
  357.             $filenamefoto = "";
  358.             $filenameskhun = "";
  359.             $filenamedta = "";
  360.             $filenameakta ="";
  361.             $filenamekk = "";
  362.             $filenamenisn ="";
  363.             $filenameketm = "";
  364.             $filenameprestasi = "";
  365.             $filenameperpindahan = "";
  366.         }
  367.             //upload foto
  368.         $foto=null;
  369.         $scan_skhun=null;
  370.         $scan_dta=null;
  371.         $scan_akta=null;
  372.         $scan_kk=null;
  373.         $scan_nisn=null;
  374.         $scan_ketm=null;
  375.         $scan_prestasi=null;
  376.         $scan_perpindahan=null;
  377.  
  378.         $config['upload_path'] = './assets/images/pendaftar/';
  379.         $config['allowed_types'] = '*';
  380.         $config['file_name']=$no_pendaftar."_foto";
  381.         $this->upload->initialize($config);
  382.         if(!$this->upload->do_upload('foto')){
  383.                     // $error = $this->upload->display_errors();
  384.                     // // menampilkan pesan error
  385.                     // print_r($error);
  386.         }
  387.         else{
  388.                     //echo "<script>alert('sukses')</script>";
  389.             if (file_exists($filenamefoto))
  390.             {
  391.                 unlink($filenamefoto);
  392.             }
  393.             $file=$this->upload->data('foto');
  394.             $foto = $this->upload->data('file_name');
  395.             ini_set('memory_limit', '-1');
  396.             ini_set('max_execution_time', 1000);
  397.             ini_set('post_max_size', '128M');
  398.             ini_set('upload_max_filesize', '128M');
  399.         }
  400.             //upload SKHUN
  401.  
  402.         $config['upload_path'] = './assets/images/pendaftar/';
  403.         $config['allowed_types'] = '*';
  404.         $config['file_name']=$no_pendaftar."_scan_skhun";
  405.         $this->upload->initialize($config);
  406.         if(!$this->upload->do_upload('scan_skhun')){
  407.         }
  408.         else{
  409.             if (file_exists($filenameskhun))
  410.             {
  411.                 unlink($filenameskhun);
  412.             }
  413.             $file=$this->upload->data('scan_skhun');
  414.             $scan_skhun =  $this->upload->data('file_name');
  415.             ini_set('memory_limit', '-1');
  416.             ini_set('max_execution_time', 1000);
  417.             ini_set('post_max_size', '128M');
  418.             ini_set('upload_max_filesize', '128M');
  419.         }
  420.                 //end
  421.  
  422.             //upload DTA
  423.  
  424.         $config['upload_path'] = './assets/images/pendaftar/';
  425.         $config['allowed_types'] = '*';
  426.         $config['file_name']=$no_pendaftar."_scan_dta";
  427.         $this->upload->initialize($config);
  428.         if(!$this->upload->do_upload('scan_dta')){
  429.         }
  430.         else{
  431.            if (file_exists($filenamedta))
  432.            {
  433.             unlink($filenamedta);
  434.         }
  435.         $file=$this->upload->data('scan_dta');
  436.         $scan_dta =  $this->upload->data('file_name');
  437.         ini_set('memory_limit', '-1');
  438.         ini_set('max_execution_time', 1000);
  439.         ini_set('post_max_size', '128M');
  440.         ini_set('upload_max_filesize', '128M');
  441.     }
  442.                 //end    
  443.  
  444.             // //upload scan_akta
  445.  
  446.     $config['upload_path'] = './assets/images/pendaftar/';
  447.     $config['allowed_types'] = '*';
  448.     $config['file_name']=$no_pendaftar."_scan_akta";
  449.     $this->upload->initialize($config);
  450.     if(!$this->upload->do_upload('scan_akta')){
  451.     }
  452.     else{
  453.         if (file_exists($filenameakta))
  454.         {
  455.             unlink($filenameakta);
  456.         }
  457.         $file=$this->upload->data('scan_akta');
  458.         $scan_akta =  $this->upload->data('file_name');
  459.         ini_set('memory_limit', '-1');
  460.         ini_set('max_execution_time', 1000);
  461.         ini_set('post_max_size', '128M');
  462.         ini_set('upload_max_filesize', '128M');
  463.     }
  464.                 //end
  465.  
  466.                 //upload scan_kk
  467.  
  468.     $config['upload_path'] = './assets/images/pendaftar/';
  469.     $config['allowed_types'] = '*';
  470.     $config['file_name']=$no_pendaftar."_scan_kk";
  471.     $this->upload->initialize($config);
  472.     if(!$this->upload->do_upload('scan_kk')){
  473.     }
  474.     else{
  475.         if (file_exists($filenamekk))
  476.         {
  477.             unlink($filenamekk);
  478.         }
  479.         $file=$this->upload->data('scan_kk');
  480.         $scan_kk =  $this->upload->data('file_name');
  481.         ini_set('memory_limit', '-1');
  482.         ini_set('max_execution_time', 1000);
  483.         ini_set('post_max_size', '128M');
  484.         ini_set('upload_max_filesize', '128M');
  485.     }
  486.                 //end
  487.  
  488.                     //upload scan_nisn
  489.  
  490.     $config['upload_path'] = './assets/images/pendaftar/';
  491.     $config['allowed_types'] = '*';
  492.     $config['file_name']=$no_pendaftar."_scan_nisn";
  493.     $this->upload->initialize($config);
  494.     if(!$this->upload->do_upload('scan_nisn')){
  495.     }
  496.     else{
  497.      if (file_exists($filenamenisn))
  498.      {
  499.         unlink($filenamenisn);
  500.     }
  501.     $file=$this->upload->data('scan_nisn');
  502.     $scan_nisn = $this->upload->data('file_name');
  503.     ini_set('memory_limit', '-1');
  504.     ini_set('max_execution_time', 1000);
  505.     ini_set('post_max_size', '128M');
  506.     ini_set('upload_max_filesize', '128M');
  507. }
  508.                 //end
  509.  
  510.                     //upload scan_ketm
  511.  
  512. $config['upload_path'] = './assets/images/pendaftar/';
  513. $config['allowed_types'] = '*';
  514. $config['file_name']=$no_pendaftar."_scan_ketm";
  515. $this->upload->initialize($config);
  516. if(!$this->upload->do_upload('scan_ketm')){
  517. }
  518. else{
  519.  if (file_exists($filenameketm))
  520.  {
  521.     unlink($filenameketm);
  522. }
  523. $file=$this->upload->data('scan_ketm');
  524. $scan_ketm =  $this->upload->data('file_name');
  525. ini_set('memory_limit', '-1');
  526. ini_set('max_execution_time', 1000);
  527. ini_set('post_max_size', '128M');
  528. ini_set('upload_max_filesize', '128M');
  529. }
  530.                 //end
  531.  
  532.                     //upload scan_prestasi
  533.  
  534. $config['upload_path'] = './assets/images/pendaftar/';
  535. $config['allowed_types'] = '*';
  536. $config['file_name']=$no_pendaftar."_scan_prestasi";
  537. $this->upload->initialize($config);
  538. if(!$this->upload->do_upload('scan_prestasi')){
  539. }
  540. else{
  541.     if (file_exists($filenameprestasi))
  542.     {
  543.         unlink($filenameprestasi);
  544.     }
  545.     $file=$this->upload->data('scan_prestasi');
  546.     $scan_prestasi =  $this->upload->data('file_name');
  547.     ini_set('memory_limit', '-1');
  548.     ini_set('max_execution_time', 1000);
  549.     ini_set('post_max_size', '128M');
  550.     ini_set('upload_max_filesize', '128M');
  551. }
  552.                 //end
  553.  
  554.                     //upload scan_perpindahan
  555.  
  556. $config['upload_path'] = './assets/images/pendaftar/';
  557. $config['allowed_types'] = '*';
  558. $config['file_name']=$no_pendaftar."_scan_perpindahan";
  559. $this->upload->initialize($config);
  560. if(!$this->upload->do_upload('scan_perpindahan')){
  561. }
  562. else{
  563.  if (file_exists($filenameperpindahan))
  564.  {
  565.     unlink($filenameperpindahan);
  566. }
  567. $file=$this->upload->data('scan_perpindahan');
  568. $scan_perpindahan =  $this->upload->data('file_name');
  569. ini_set('memory_limit', '-1');
  570. ini_set('max_execution_time', 1000);
  571. ini_set('post_max_size', '128M');
  572. ini_set('upload_max_filesize', '128M');
  573. }
  574.                 //end
  575.  
  576.                 //olah score
  577. $score_ketm=null;
  578. if($this->input->post('jenis_ketm')){
  579.     $jenis_ketm=$this->input->post('jenis_ketm');  
  580.     $score_ketm=$this->db->query("select score_ketm from t_ketm where id_ketm='$jenis_ketm'")->row()->score_ketm;
  581. }
  582. $score_prestasi=null;
  583. if($this->input->post('tingkat_prestasi') && $this->input->post('juara_prestasi') ){
  584.     $tingkat_prestasi=$this->input->post('tingkat_prestasi');
  585.     $juara_prestasi=$this->input->post('juara_prestasi');
  586.     $score_prestasi=$this->db->query("select score_prestasi from t_prestasi where tingkat_prestasi='$tingkat_prestasi' and juara_prestasi='$juara_prestasi'")->row()->score_prestasi;
  587.  
  588. }
  589.  
  590.  
  591.  
  592.                 //input sekolah baru ke table sekolah
  593. if($this->input->post('sekolah_lain')){
  594.     $new_sekolah=$this->input->post('sekolah_lain');
  595.     $data=array(
  596.         'nama_sekolah'=>$new_sekolah,
  597.     );
  598.     $hasil=$this->db->insert('t_asal_sekolah',$data);
  599.     $asal_sekolah=$this->db->query("select max(id_sekolah) as id from t_asal_sekolah")->row()->id;
  600. }else{
  601.     $asal_sekolah=$this->input->post('asal_sekolah');
  602. }
  603.  
  604.                 //input data ke array  
  605. $data=array(
  606.     'no_pendaftar' => $no_pendaftar,
  607.     'perlengkapan'=> implode(',',$this->input->post('perlengkapan')),
  608.     'nama' => $this->input->post('nama'),
  609.     'jalur' => $this->input->post('jalur'),
  610.     'nisn' => $this->input->post('nisn'),
  611.     'nik' => $this->input->post('nik'),
  612.     'jk' => $this->input->post('jk'),
  613.     'tahun_lulus' => $this->input->post('tahun_lulus'),
  614.     'asal_sekolah' => $asal_sekolah,
  615.     'tempat_lahir' => $this->input->post('tempat_lahir'),
  616.     'tgl_lahir' => $this->input->post('tgl_lahir'),
  617.     'agama' => $this->input->post('agama'),
  618.     'no_hp' => $this->input->post('no_hp'),
  619.     'provinsi' => $this->input->post('provinsi'),
  620.     'provinsi_wali' => $this->input->post('provinsi_wali'),
  621.     'kabupaten' => $this->input->post('kabupaten'),
  622.     'kabupaten_wali' => $this->input->post('kabupaten_wali'),
  623.     'kecamatan' => $this->input->post('kecamatan'),
  624.     'kecamatan_wali' => $this->input->post('kecamatan_wali'),
  625.     'kelurahan' => $this->input->post('kelurahan'),
  626.     'kelurahan_wali' => $this->input->post('kelurahan_wali'),
  627.     'rt' => $this->input->post('rt'),
  628.     'rt_wali' => $this->input->post('rt_wali'),
  629.     'rw_wali' => $this->input->post('rw_wali'),
  630.     'rw' => $this->input->post('rw'),
  631.     'alamat' => $this->input->post('alamat'),
  632.     'jarak' => $this->input->post('jarak'),
  633.     'nama_wali' => $this->input->post('nama_wali'),
  634.     'pekerjaan_wali' => $this->input->post('pekerjaan_wali'),
  635.     'agama_wali' => $this->input->post('agama_wali'),
  636.     'alamat_wali' => $this->input->post('alamat_wali'),
  637.     'no_hp_wali' => $this->input->post('no_hp_wali'),
  638.  
  639.     'jenis_ketm' => $this->input->post('jenis_ketm'),
  640.     'score_ketm' => $score_ketm,
  641.     'nama_prestasi' => $this->input->post('nama_prestasi'),
  642.     'tingkat_prestasi' => $this->input->post('tingkat_prestasi'),
  643.     'juara_prestasi' => $this->input->post('juara_prestasi'),
  644.     'score_prestasi' => $score_prestasi,
  645.  
  646.     'jurusan_1'=>$this->input->post('jurusan_1'),
  647.     'jurusan_2'=>$this->input->post('jurusan_2'),
  648.     'jurusan_3'=>$this->input->post('jurusan_3'),
  649.  
  650.     'tgl_penyerahan'=>$this->input->post('tgl_penyerahan'),
  651.     'no_antrian'=> $this->next_no_antrian($this->input->post('tgl_penyerahan')),
  652. );
  653.  
  654.                 //print_r($foto." ".$scan_skhun." ".$scan_akta." ".$scan_kk." ".$scan_nisn." ".$scan_ketm." ".$scan_prestasi." ". $scan_perpindahan);
  655.  
  656. if(!empty($foto)){
  657.     $data['foto'] = $foto;
  658. }
  659. if(!empty($scan_skhun)){
  660.     $data['scan_skhun'] = $scan_skhun;
  661. }
  662. if(!empty($scan_dta)){
  663.     $data['scan_dta'] = $scan_dta;
  664. }
  665. if(!empty($scan_akta)){
  666.     $data['scan_akta'] = $scan_akta;
  667. }
  668. if(!empty($scan_kk)){
  669.     $data['scan_kk'] = $scan_kk;
  670. }
  671. if(!empty($scan_nisn)){
  672.     $data['scan_nisn'] = $scan_nisn;
  673. }
  674. if(!empty($scan_ketm)){
  675.     $data['scan_ketm'] = $scan_ketm;
  676. }
  677. if(!empty($scan_prestasi)){
  678.     $data['scan_prestasi'] = $scan_prestasi;
  679. }
  680. if(!empty($scan_perpindahan)){
  681.     $data['scan_perpindahan'] = $scan_perpindahan;
  682. }
  683.  
  684. //input nilai
  685. //echo '<pre>';print_r($_POST);'</pre>';
  686.  
  687. /*$id_mapel=$this->input->post('id_mapel');
  688. $s1=$this->input->post('s1');
  689. $s2=$this->input->post('s2');
  690. $s3=$this->input->post('s3');
  691. $s4=$this->input->post('s4');
  692. $s5=$this->input->post('s5');
  693. $us=$this->input->post('us');
  694.  
  695. $jml_mapel=$this->db->query("select count(*) as jml_mapel from t_mapel")->row()->jml_mapel;
  696. $i=1;
  697. for($i=0;$i<$jml_mapel;$i++){
  698.     $data2['no_pendaftar'] = $no_pendaftar;
  699.     $data2['id_mapel'] = $id_mapel[$i];
  700.     $data2['s1'] = $s1[$i];
  701.     $data2['s2'] = $s2[$i];
  702.     $data2['s3'] = $s3[$i];
  703.     $data2['s4'] = $s4[$i];
  704.     $data2['s5'] = $s5[$i];
  705.     $data2['us'] = $us[$i];
  706.     $data2['rerata'] = round(($s1[$i]+$s2[$i]+$s3[$i]+$s4[$i]+$s5[$i]+$us[$i])/6,2);
  707.     $this->db->where(array('id_mapel'=>$id_mapel[$i],'no_pendaftar'=>$no_pendaftar));
  708.     $hasil=$this->db->delete('t_nilai');
  709.     $hasil=$this->db->insert('t_nilai',$data2);
  710. }*/
  711.  
  712.  
  713.  
  714. //proses simpan
  715. if($this->input->post('no_pendaftar')){
  716.     $this->db->where(array('no_pendaftar'=>$no_pendaftar));
  717.     $hasil=$this->db->update('t_pendaftar',$data);
  718. }else{
  719.     $hasil=$this->db->insert('t_pendaftar',$data);
  720. }
  721.  
  722. $this->session->set_flashdata('alert', $hasil);
  723.  
  724. switch($getpemanggil){
  725.     case 1;redirect('Admin/Pendaftar/zonasi');break;
  726.     case 2;redirect('Admin/Pendaftar/prestasi');break;
  727.     case 3;redirect('Admin/Pendaftar/afirmasi');break;
  728.     case 4;redirect('Admin/Pendaftar/perpindahan');break;
  729.     case 5;redirect('Admin/Pendaftar/prestasi_akademik');break;
  730.     case 6;redirect('Admin/Pendaftar/abk');break;
  731.     case 10;redirect('Admin/Pendaftar/input_pendaftar/10/'.$no_pendaftar);break;
  732.     default :break;
  733. }
  734.  
  735.  
  736. }
  737. else{
  738.  
  739.     $data['title'] = 'Data Pendaftar';
  740.  
  741.     if($getpemanggil != null && $getnopendaftar!=null){
  742.                 //echo "<script>alert('masuk')</script>";
  743.         $p=$this->db->get_where('t_pendaftar',array('no_pendaftar'=>$getnopendaftar))->row();
  744.         $data['pendaftar'] = $p;
  745.  
  746.         $data['data_kabupaten']=$this->db->get_where("t_kabupaten",array('id_provinsi'=>$p->provinsi))->result();
  747.         $data['data_kecamatan']=$this->db->get_where("t_kecamatan",array('id_kabupaten'=>$p->kabupaten))->result();
  748.         $data['data_kelurahan']=$this->db->get_where("t_kelurahan",array('id_kecamatan'=>$p->kecamatan))->result();
  749.  
  750.          $data['data_kabupaten_wali']=$this->db->get_where("t_kabupaten",array('id_provinsi'=>$p->provinsi_wali))->result();
  751.         $data['data_kecamatan_wali']=$this->db->get_where("t_kecamatan",array('id_kabupaten'=>$p->kabupaten_wali))->result();
  752.         $data['data_kelurahan_wali']=$this->db->get_where("t_kelurahan",array('id_kecamatan'=>$p->kecamatan_wali))->result();
  753.  
  754.     }
  755.  
  756.     $data['data_sekolah']=$this->db->get("t_asal_sekolah")->result();
  757.     $data['data_agama']=$this->db->get("t_agama")->result();
  758.     $data['data_provinsi']=$this->db->get("t_provinsi")->result();
  759.     $data['data_pekerjaan']=$this->db->get("t_pekerjaan")->result();
  760.     $data['data_agama']=$this->db->get("t_agama")->result();
  761.     $data['data_jalur']=$this->db->get("t_jalur")->result();
  762.     $data['data_ketm']=$this->db->get("t_ketm")->result();
  763.     $data['data_jurusan']=$this->db->get("t_jurusan")->result();
  764.     $data['data_mapel']=$this->db->get("t_mapel")->result();
  765.     $data['data_tgl_penyerahan']=$this->db->query("select tgl_penyerahan, count(*) as jml from t_pendaftar where not tgl_penyerahan is null group by tgl_penyerahan")->result();
  766.     $data['getpemanggil']=$getpemanggil;
  767.     $data['file']='Admin/Pendaftar/pendaftar_form';
  768.     $this->load->view('Admin/Main',$data);
  769. }
  770. }
  771.  
  772.  
  773. function cetak_kartu($getpemanggil=null,$getnopendaftar=null){
  774.    $data['title'] = 'Bukti Pendaftaran';
  775.    $sql="SELECT p.no_pendaftar,p.nama,j.nama_jalur,p.nisn,p.nik,p.jk,p.tahun_lulus,s.nama_sekolah,p.tempat_lahir,p.tgl_lahir,a.nama_agama,p.no_hp,pr.nama_provinsi,kb.nama_kabupaten,kc.nama_kecamatan,kl.nama_kelurahan,p.rt,p.rw,p.alamat,p.jarak,p.nama_wali,pk.nama_pekerjaan,p.alamat_wali,p.no_hp_wali,ketm.jenis_ketm,p.score_ketm,p.nama_prestasi,p.tingkat_prestasi,p.juara_prestasi,p.score_prestasi,avg(n.rerata)as rerata,p.status,p.foto,p.tgl_penyerahan,p.no_antrian ,p.no_antrian,p.jurusan_1,p.jurusan_2,p.jurusan_3,p.diterima_jurusan    
  776.   FROM t_pendaftar p left join t_jalur j on p.jalur=j.id_jalur left join t_asal_sekolah s on p.asal_sekolah=s.id_sekolah
  777.   left join t_agama a on p.agama=a.id_agama left join t_provinsi pr on p.provinsi=pr.id_provinsi
  778.   left join t_kabupaten kb on p.kabupaten=kb.id_kabupaten left join t_kecamatan kc on p.kecamatan=kc.id_kecamatan
  779.   left join t_kelurahan kl on p.kelurahan=kl.id_kelurahan left join t_ketm ketm on p.jenis_ketm=ketm.id_ketm
  780.   left join t_pekerjaan pk on p.pekerjaan_wali=pk.id_pekerjaan
  781.   left join t_nilai n on p.no_pendaftar=n.no_pendaftar
  782.   where p.no_pendaftar='$getnopendaftar'
  783.   group by no_pendaftar
  784.   order by no_pendaftar";
  785.    $data['pendaftar'] = $this->db->query($sql)->row();
  786.    $data['data_mapel']=$this->db->get('t_mapel')->result();
  787.    $data['getpemanggil']=$getpemanggil;
  788.    $data['file']='Admin/Pendaftar/pendaftar_kartu';
  789.    $this->load->view('Admin/Main',$data);
  790. }
  791.  
  792. function info_penerimaan($getnopendaftar=null){
  793.  
  794.   $data['title'] = 'Informasi Kelulusan';
  795.   $sql="SELECT p.no_pendaftar,p.nama,j.nama_jalur,p.nisn,p.nik,p.jk,p.tahun_lulus,s.nama_sekolah,p.tempat_lahir,p.tgl_lahir,a.nama_agama,p.no_hp,pr.nama_provinsi,kb.nama_kabupaten,kc.nama_kecamatan,kl.nama_kelurahan,p.rt,p.rw,p.alamat,p.jarak,p.nama_wali,pk.nama_pekerjaan,p.alamat_wali,p.no_hp_wali,ketm.jenis_ketm,p.score_ketm,p.nama_prestasi,p.tingkat_prestasi,p.juara_prestasi,p.score_prestasi,avg(n.rerata)as rerata,p.status,p.foto,p.tgl_penyerahan,p.no_antrian ,p.no_antrian,p.jurusan_1,p.jurusan_2,p.jurusan_3,p.diterima_jurusan    
  796.  FROM t_pendaftar p left join t_jalur j on p.jalur=j.id_jalur left join t_asal_sekolah s on p.asal_sekolah=s.id_sekolah
  797.  left join t_agama a on p.agama=a.id_agama left join t_provinsi pr on p.provinsi=pr.id_provinsi
  798.  left join t_kabupaten kb on p.kabupaten=kb.id_kabupaten left join t_kecamatan kc on p.kecamatan=kc.id_kecamatan
  799.  left join t_kelurahan kl on p.kelurahan=kl.id_kelurahan left join t_ketm ketm on p.jenis_ketm=ketm.id_ketm
  800.  left join t_pekerjaan pk on p.pekerjaan_wali=pk.id_pekerjaan
  801.  left join t_nilai n on p.no_pendaftar=n.no_pendaftar
  802.  where p.no_pendaftar='$getnopendaftar'
  803.  group by no_pendaftar
  804.  order by no_pendaftar";
  805.   $data['pendaftar'] = $this->db->query($sql)->row();
  806.   $data['data_tanggal']=$this->db->query("select * from t_daftar_ulang")->result();
  807.   $data['getpemanggil']='10';
  808.   $data['setting']=$this->db->query("select * from t_setting where id_setting='1'")->row();
  809.   $data['file']='Admin/Pendaftar/pendaftar_kelulusan';
  810.   $this->load->view('Admin/Main',$data);
  811.  
  812. }
  813.  
  814. function update_status($getpemanggil=null,$getstatus=null,$getnopendaftar=null){
  815.     if((!empty($getpemanggil))&&(!empty($getstatus))&&(!empty($getnopendaftar))){            
  816.         $this->db->where(array('no_pendaftar'=>$getnopendaftar));
  817.         $hasil=$this->db->update('t_pendaftar',array('status'=>$getstatus));
  818.     }
  819.     switch($getpemanggil){
  820.         case 1;redirect('Admin/Pendaftar/zonasi');break;
  821.         case 2;redirect('Admin/Pendaftar/prestasi');break;
  822.         case 3;redirect('Admin/Pendaftar/afirmasi');break;
  823.         case 4;redirect('Admin/Pendaftar/perpindahan');break;
  824.         case 5;redirect('Admin/Pendaftar/prestasi_akademik');break;
  825.         case 6;redirect('Admin/Pendaftar/abk');break;
  826.         default :redirect('Admin/Pendaftar/zonasi');break;
  827.     }
  828. }
  829.  
  830. function hapus_semua($getpemanggil=null){
  831.     if(!empty($getpemanggil)){
  832.  
  833.         $pendaftar = $this->db->query("select * from t_pendaftar where jalur='$getpemanggil'")->result();
  834.         foreach($pendaftar as $row){
  835.  
  836.             $image_path = 'assets/images/pendaftar/';
  837.                 //hapus foto
  838.             if($row->foto){
  839.                 $filename = $image_path . $row->foto;
  840.                 if (file_exists($filename))
  841.                 {
  842.                     unlink($filename);
  843.                 }
  844.             }
  845.  
  846.  
  847.                 //hapus scan_skhun
  848.             if($row->scan_skhun){
  849.                 $filename = $image_path . $row->scan_skhun;
  850.                 if (file_exists($filename))
  851.                 {
  852.                     unlink($filename);
  853.                 }
  854.             }
  855.  
  856.                 //hapus scan_dta
  857.             if($row->scan_dta){
  858.                 $filename = $image_path . $row->scan_dta;
  859.                 if (file_exists($filename))
  860.                 {
  861.                     unlink($filename);
  862.                 }
  863.             }
  864.  
  865.  
  866.                 //hapus scan_akta
  867.             if($row->scan_akta){
  868.              $filename = $image_path . $row->scan_akta;
  869.              if (file_exists($filename))
  870.              {
  871.                 unlink($filename);
  872.             }
  873.         }
  874.  
  875.  
  876.                 //hapus scan_kk
  877.         if($row->scan_kk){
  878.             $filename = $image_path . $row->scan_kk;
  879.             if (file_exists($filename))
  880.             {
  881.                 unlink($filename);
  882.             }
  883.         }
  884.  
  885.  
  886.                 //hapus scan_nisn
  887.         if( $row->scan_nisn){
  888.           $filename = $image_path . $row->scan_nisn;
  889.           if (file_exists($filename))
  890.           {
  891.             unlink($filename);
  892.         }  
  893.     }
  894.  
  895.  
  896.                 //hapus scan_ketm
  897.     if($row->scan_ketm){
  898.         $filename = $image_path . $row->scan_ketm;
  899.         if (file_exists($filename))
  900.         {
  901.             unlink($filename);
  902.         }
  903.     }
  904.  
  905.  
  906.                 //hapus scan_prestasi
  907.     if($row->scan_prestasi){
  908.       $filename = $image_path . $row->scan_prestasi;
  909.       if (file_exists($filename))
  910.       {
  911.         unlink($filename);
  912.     }  
  913. }
  914.  
  915.  
  916.                 //hapus scan_perpindahan
  917. if($row->scan_perpindahan){
  918.     $filename = $image_path . $row->scan_perpindahan;
  919.     if (file_exists($filename))
  920.     {
  921.         unlink($filename);
  922.     }
  923. }
  924.  
  925.             //end
  926.  
  927. $this->db->where(array('no_pendaftar'=>$row->no_pendaftar));
  928. $hasil=$this->db->delete('t_pendaftar');
  929. }
  930.  
  931.  
  932. switch($getpemanggil){
  933.     case 1;redirect('Admin/Pendaftar/zonasi');break;
  934.     case 2;redirect('Admin/Pendaftar/prestasi');break;
  935.     case 3;redirect('Admin/Pendaftar/afirmasi');break;
  936.     case 4;redirect('Admin/Pendaftar/perpindahan');break;
  937.     case 5;redirect('Admin/Pendaftar/prestasi_akademik');break;
  938.     case 6;redirect('Admin/Pendaftar/abk');break;
  939.     default :redirect('Admin/Pendaftar/zonasi');break;
  940. }
  941. }
  942. }
  943.  
  944. function cetak_verifikasi_berkas($getpemanggil=null,$getnopendaftar=null){
  945.    $data['title'] = 'Bukti Verifikasi Berkas';
  946.    $sql="SELECT p.no_pendaftar,p.nama,j.nama_jalur,p.nisn,p.nik,p.jk,p.tahun_lulus,s.nama_sekolah,p.tempat_lahir,p.tgl_lahir,a.nama_agama,p.no_hp,pr.nama_provinsi,kb.nama_kabupaten,kc.nama_kecamatan,kl.nama_kelurahan,p.rt,p.rw,p.alamat,p.jarak,p.nama_wali,pk.nama_pekerjaan,p.alamat_wali,p.no_hp_wali,ketm.jenis_ketm,p.score_ketm,p.nama_prestasi,p.tingkat_prestasi,p.juara_prestasi,p.score_prestasi,avg(n.rerata)as rerata,p.status,p.foto,p.tgl_penyerahan,p.no_antrian,p.jurusan_1,p.jurusan_2,p.jurusan_3,p.diterima_jurusan  
  947.   FROM t_pendaftar p left join t_jalur j on p.jalur=j.id_jalur left join t_asal_sekolah s on p.asal_sekolah=s.id_sekolah
  948.   left join t_agama a on p.agama=a.id_agama left join t_provinsi pr on p.provinsi=pr.id_provinsi
  949.   left join t_kabupaten kb on p.kabupaten=kb.id_kabupaten left join t_kecamatan kc on p.kecamatan=kc.id_kecamatan
  950.   left join t_kelurahan kl on p.kelurahan=kl.id_kelurahan left join t_ketm ketm on p.jenis_ketm=ketm.id_ketm
  951.   left join t_pekerjaan pk on p.pekerjaan_wali=pk.id_pekerjaan
  952.   left join t_nilai n on p.no_pendaftar=n.no_pendaftar
  953.   where p.no_pendaftar='$getnopendaftar'
  954.   group by no_pendaftar
  955.   order by no_pendaftar";
  956.    $data['pendaftar'] = $this->db->query($sql)->row();
  957.    $data['getpemanggil']=$getpemanggil;
  958.    $data['file']='Admin/Pendaftar/pendaftar_verifikasi';
  959.    $this->load->view('Admin/Main',$data);
  960. }
  961.  
  962. function dokumen_pendaftar($getpemanggil=null,$getnopendaftar=null){
  963.    $data['title'] = 'Dokumen Pendaftar';
  964.    $sql="select * from t_pendaftar where no_pendaftar='$getnopendaftar'";
  965.    $data['pendaftar'] = $this->db->query($sql)->row();
  966.    $data['getpemanggil']=$getpemanggil;
  967.    $data['file']='Admin/Pendaftar/pendaftar_dokumen';
  968.    $this->load->view('Admin/Main',$data);
  969. }
  970.  
  971.   public function pdf()
  972.  
  973.     {
  974.  
  975.     //load library DomPDF
  976.     $this->load->library('dompdf_gen');
  977.     //load database & view
  978.      $sql="SELECT p.no_pendaftar,p.nama,j.nama_jalur,p.nisn,p.nik,p.jk,p.tahun_lulus,s.nama_sekolah,p.tempat_lahir,p.tgl_lahir,a.nama_agama,p.no_hp,pr.nama_provinsi,kb.nama_kabupaten,kc.nama_kecamatan,kl.nama_kelurahan,p.rt,p.rw,p.alamat,p.jarak,p.nama_wali,pk.nama_pekerjaan,p.alamat_wali,p.no_hp_wali,ketm.jenis_ketm,p.score_ketm,p.nama_prestasi,p.tingkat_prestasi,p.juara_prestasi,p.score_prestasi,avg(n.rerata)as rerata,p.status,p.foto,p.tgl_penyerahan,p.no_antrian,p.jurusan_1,p.jurusan_2,p.jurusan_3,p.diterima_jurusan  
  979.   FROM t_pendaftar p left join t_jalur j on p.jalur=j.id_jalur left join t_asal_sekolah s on p.asal_sekolah=s.id_sekolah
  980.   left join t_agama a on p.agama=a.id_agama left join t_provinsi pr on p.provinsi=pr.id_provinsi
  981.   left join t_kabupaten kb on p.kabupaten=kb.id_kabupaten left join t_kecamatan kc on p.kecamatan=kc.id_kecamatan
  982.   left join t_kelurahan kl on p.kelurahan=kl.id_kelurahan left join t_ketm ketm on p.jenis_ketm=ketm.id_ketm
  983.   left join t_pekerjaan pk on p.pekerjaan_wali=pk.id_pekerjaan
  984.   left join t_nilai n on p.no_pendaftar=n.no_pendaftar
  985.  
  986.   group by no_pendaftar
  987.   order by no_pendaftar";
  988.    $data['pendaftar'] = $this->db->query($sql)->row();
  989.  
  990.     $this->load->view('Admin/Pendaftar/pendaftar_verifikasi', $data);
  991.     //Pengaturan kertas DomPDF
  992.     $paper_size = 'A4';
  993.     $orientation = 'portrait';
  994.     $html = $this->output->get_output();
  995.     $this->dompdf->set_paper($paper_size, $orientation);
  996.  
  997.     $this->dompdf->load_html($html);
  998.     $this->dompdf->render();
  999.     $this->dompdf->stream('laporan.pdf', array('Attachment' => 0));
  1000.  
  1001.  
  1002. }
  1003.  
  1004. function update_verifikasi($getpemanggil=null,$getstatus=null,$getnopendaftar=null){
  1005.         //if((!empty($getpemanggil))&&(!empty($getstatus))&&(!empty($getnopendaftar))){            
  1006.             $this->db->where(array('no_pendaftar'=>$getnopendaftar));
  1007.             $hasil=$this->db->update('t_pendaftar',array('verifikasi'=>$getstatus));
  1008.         //}
  1009.         switch($getpemanggil){
  1010.                     case 1;redirect('Admin/Pendaftar/zonasi');break;
  1011.                     case 2;redirect('Admin/Pendaftar/prestasi');break;
  1012.                     case 3;redirect('Admin/Pendaftar/afirmasi');break;
  1013.                     case 4;redirect('Admin/Pendaftar/perpindahan');break;
  1014.                     case 5;redirect('Admin/Pendaftar/prestasi_akademik');break;
  1015.                     case 6;redirect('Admin/Pendaftar/abk');break;
  1016.                     default :redirect('Admin/Pendaftar/zonasi');break;
  1017.                 }
  1018.       }
  1019.  
  1020. }
  1021. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!