<?php
if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Surat_pernyataan 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_srtpernyataan WHERE nim='$nim'";
		
        $query  = $this->db->query($q);
        $result = array();
        if ($query->num_rows() > 0) {
            $result = $query->result();
        }
        return $result;
    }
    
    function get_surat_pernyataan($nim){
        
        $row_srtpernyataan = $this->get_row_pars("v_srtpernyataan","tglpermohonan,nmprodi,nmmhs,biayakuliah,sisabiaya,tglpelunasan,tingkat,idsemester,kdsemester,nmpekerjaanortu,
                                            tglpersetujuan,nmpimpinan,kdthnakademik,nmjnssemester,nmortu,alamatortu","nim='$nim'");
		
        $nmortu = $row_srtpernyataan->nmortu;
        $alamat = $row_srtpernyataan->alamatortu;
		$pekerjaan = $row_srtpernyataan->nmpekerjaanortu;
        $nmmhs = $row_srtpernyataan->nmmhs;
        $prodi = $row_srtpernyataan->nmprodi;
        $biayakuliah = $row_srtpernyataan->biayakuliah;
		$sisabiaya = $row_srtpernyataan->sisabiaya;
        $tglpelunasan = $row_srtpernyataan->tglpelunasan;
        $tglpermohonan = $row_srtpernyataan->tglpermohonan;
        $tingkat = $row_srtpernyataan->tingkat;
        $semester = $row_srtpernyataan->kdsemester;
        
        $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('helvetica', '', 20);
        $this->pdf->Write(0, 'SURAT PERNYATAAN', '', 0, 'C', true, 0, false, false, 0);
        $this->pdf->Cell(40,10,'',0,1,'C');

        $this->pdf->SetFont('helvetica', '', 12);
        $this->pdf->Cell(40,10,'Saya yang bertanda tangan dibawah ini :',0,1,'L');
        $this->pdf->Cell(25,10,'Nama',0,0,'L');
        $this->pdf->Cell(5,10,': '.$nmortu,0,1,'L');
        
        $this->pdf->Cell(25,10,'Pekerjaan',0,0,'L');
        $this->pdf->Cell(5,10,': '.$pekerjaan,0,1,'L'); 
        
        $this->pdf->Cell(25,10,'Alamat',0,0,'L');
        $this->pdf->Cell(5,10,': '.$alamat,0,1,'L');       
        
        
        $this->pdf->Cell(40,10,'Selaku Orangtua/Wali Mahasiswa :',0,1,'L');
        $this->pdf->Cell(25,10,'Nama',0,0,'L');
        $this->pdf->Cell(5,10,': '.$nmmhs,0,1,'L');  
             
        $this->pdf->Cell(25,10,'Prog Studi',0,0,'L');
        $this->pdf->Cell(5,10,': '.$prodi,0,1,'L');
               
        $this->pdf->Cell(25,10,'Tingkat/ Smt',0,0,'L');
        $this->pdf->Cell(5,10,': '.$tingkat.' / '.$semester,0,1,'L');       
        
         $html = 
         
                 '<br />
                  <br />
                  <br />
        
                <span style="text-align:justify; line-height: 2;">Dengan ini memberitahukan bahwa belum dapat melunasi biaya perkuliahan sebesar
                Rp.'.number_format($biayakuliah , 2 , ',' , '.' ).', dengan sisa pembayaran sebesar Rp.'.number_format($sisabiaya , 2 , ',' , '.' ).'  Dan akan melunasi pada tanggal '.$this->TanggalIndo(date("Ymd",strtotime($tglpelunasan))).' dan apabila tidak dapat melunasi pada tanggal yang telah ditetapkan
                maka saya bersedia menerima sanksi dan resiko dari institusi Universitas Langlangbuana.  
                <br />  
                <br /> 
                Demikian surat pernyataan ini saya buat tanpa ada paksaan dari pihak manapun.
                </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="5%"></td>
                <td width="57%" align="left">Bandung, '.$this->TanggalIndo(date("Ymd",strtotime($tglpermohonan))).'</td>
                
                
            </tr>
            
            <tr>
                <td width="20%"></td>
                <td width="5%"></td>
                <td width="3%"></td>
                <td width="20%"></td>
                <td width="5%"></td>
                <td width="57%" align="left">Yang membuat pernyataan,</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="5%"></td>
                <td width="57%" align="left"><b>'.$nmortu.'</b></td>
            </tr>
                </table>';
                
        
        
        $this->pdf->writeHTML($html, true, 0, true, 0);
        
        $this->pdf->Output('Surat_pernyataan.pdf', 'I');
        
        
    }
    
    
}