<?php
if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Surat_mutasi extends Controller {
    function __construct(){
        parent::__construct();
		$this->ceklog();
		$this->load->library('pdf');
        $this->load->library('rhrpt');
		$this->load->library('rhlib');
        $this->load->library('cezpdf');
        
    }
	
	function ceklog() {
        $user = $this->session->userdata("user_idunlaprivate");
            if($user==""){
                redirect('auth/login');
            }
    }
    
    function TanggalIndo($date){
            $BulanIndo = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");

            $tahun = substr($date, 0, 4);
            $bulan = substr($date, 4, 2);
            $tgl   = substr($date, 6, 2);
             
            $result =$tgl . " " . $BulanIndo[(int)$bulan-1] . " ". $tahun;		
            return($result);
        }
    
    function get_bilangan($num){
		return $this->rhlib->get_bilangan($num);
	}
	
	function get_par_val($table,$fieldName,$condition){		
        return $this->rhlib->get_par_val($table,$fieldName,$condition);
    }
	function get_row_pars($table,$fields,$condition){
		return $this->rhlib->get_row_pars($table,$fields,$condition);
    }
    
    function get_data($nim){
		
		$q = "SELECT * FROM v_srtpindahmhs WHERE nim='$nim'";
		
        $query  = $this->db->query($q);
        $result = array();
        if ($query->num_rows() > 0) {
            $result = $query->result();
        }
        return $result;
    }
    
    function get_surat_mutasi($nim){
        
        $row_srtpindah = $this->get_row_pars("v_srtpindahmhs","nosrtpindahmhs,nmpimpinan,gelar,tglpermohonan,nmprodi,nmmhs,nmdatajenjangstudi,
                                            nmstakreditasi,tglpersetujuan,nmptitbpti,nmkopertis,nmpimpinan,nmstsetuju,kdthnakademik,nmjnssemester","nim='$nim'");
		
        $nomorsurat = $row_srtpindah->nosrtpindahmhs;
        $nmmhs = $row_srtpindah->nmmhs;
        $nmprodi = $row_srtpindah->nmprodi;
        $nmjenjangstudi = $row_srtpindah->nmdatajenjangstudi;
        $nmstatusakreditasi = $row_srtpindah->nmstakreditasi;
        $tglpermohonan = $row_srtpindah->tglpermohonan;
        $fakultas_tujuan = $row_srtpindah->nmptitbpti;
        $wilayah = $row_srtpindah->nmkopertis;
        $pimpinan = $row_srtpindah->nmpimpinan;
		$gelar = $row_srtpindah->gelar;
        
        $this->pdf->SetCreator(PDF_CREATOR);
        
        // set default header data  
        $this->pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,PDF_HEADER_TITLE,PDF_HEADER_STRING);
        $this->pdf->setPrintHeader(true);
        $this->pdf->setPrintFooter(false);
        // set header and footer fonts
        $this->pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', 10));
        $this->pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
        
        // set default monospaced font
        $this->pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        
        // set margins
        $this->pdf->SetMargins(PDF_MARGIN_LEFT, '45', PDF_MARGIN_RIGHT);
        $this->pdf->SetHeaderMargin('10');
        $this->pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        
        // set auto page breaks
        $this->pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        
        // set image scale factor
        $this->pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        
        // set some language-dependent strings (optional)

        // ---------------------------------------------------------
        
        // set font
        
        $this->pdf->SetCellPadding(0);
        // add a page
        $this->pdf->AddPage();
        
        $this->pdf->SetFont('times', 'B'.'U', 16);
        $this->pdf->Write(0, 'SURAT KETERANGAN MUTASI MAHASISWA', '', 0, 'C', true, 0, false, false, 0);
        $this->pdf->SetFont('times', '', 11);
        $this->pdf->Write(0, 'Nomor: '.$nomorsurat, '', 0, 'C', true, 0, false, false, 0);
        $this->pdf->Cell(40,10,'',0,1,'C');
        
        $this->pdf->SetFont('times', '', 11);
        $this->pdf->Write(0, 'Rektor Universitas Langlangbuana dengan ini menerangkan :', '', 0, 'L', true, 0, false, false, 0);
        
        $this->pdf->Cell(40,10,'Nama',0,0,'L');
        $this->pdf->Cell(5,10,': '.$nmmhs,0,1,'L');
        
        $this->pdf->Cell(40,10,'NIM',0,0,'L');
        $this->pdf->Cell(5,10,': '.$nim,0,1,'L');
        
        $this->pdf->Cell(40,10,'Perguruan Tinggi',0,0,'L');
        $this->pdf->Cell(5,10,': Universitas Langlangbuana',0,1,'L');
        
        $this->pdf->Cell(40,10,'Jenjang Program',0,0,'L');
        $this->pdf->Cell(5,10,': '.$nmjenjangstudi,0,1,'L');
        
        $this->pdf->Cell(40,10,'Status Akreditasi',0,0,'L');
        $this->pdf->Cell(5,10,': '.$nmstatusakreditasi,0,1,'L');

        $html = 
                 '<br />
                  <br />
                  <br />
        
                <span style="text-align:justify; line-height: 2;">Berdasarkan surat permohonan pindah dari mahasiswa yang bersangkutan tanggal 
                    '.$this->TanggalIndo(date("Ymd",strtotime($tglpermohonan))).' yang bersangkutan ingin pindah / melanjutkan kuliah ke '.$fakultas_tujuan.', di lingkungan Koordinator
                    Kopertis '.$wilayah.' .
                    <br />
                    <br />
                    Demikian surat keterangan ini dibuat untuk dapat dipergunakan sebagaimana mestinya.                
                </span>
                
                <br />
                <br />
                <br />
                <br />
                
                <table>
                    <tr>
                <td width="20%"></td>
                <td width="5%"></td>
                <td width="3%"></td>
                <td width="20%"></td>
                <td width="10%"></td>
                <td width="52%" align="left">Bandung,</td>
                
                
            </tr>
            
            <tr>
                <td width="20%"></td>
                <td width="5%"></td>
                <td width="3%"></td>
                <td width="20%"></td>
                <td width="10%"></td>
                <td width="52%" align="left">Rektor,</td>
            </tr>
            <tr><td></td></tr>
            <tr><td></td></tr>
            <tr><td></td></tr>
            <tr><td></td></tr>
            <tr><td></td></tr>
            
            <tr>
                <td width="20%"></td>
                <td width="5%"></td>
                <td width="3%"></td>
                <td width="20%"></td>
                <td width="10%"></td>
                <td width="52%" align="left"><b>'.$pimpinan.'</b></td>
            </tr>
			<tr>
                <td width="20%"></td>
                <td width="5%"></td>
                <td width="3%"></td>
                <td width="20%"></td>
                <td width="10%"></td>
				<td width="52%" align="left">'.$gelar.'</td>
            </tr>
                </table>';


        $this->pdf->writeHTML($html, true, 0, true, 0);
        
        $this->pdf->Output('Surat_mutasi.pdf', 'I');
        
        
    }
    
    
}