API tools faq
paste
cod3yoda

COntroller_SIgnature

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