ceklog(); $this->load->library('pdf_blanko_wawancara'); $this->load->library('rhrpt'); $this->load->library('rhlib'); } function ceklog() { $user = $this->session->userdata("user_id1unla"); if($user==""){ redirect('user/login'); } } 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($thnmasuk,$jns_kelas,$kdprodi,$persen1,$kondisi1,$persen2,$kondisi2){ $KEDUA= $this->load->database('second', TRUE); $query = $KEDUA->query("CALL sp_GetDpkDet (?,?,?,?,?,?,?)",array($thnmasuk,$jns_kelas,$kdprodi,$persen1,$kondisi1,$persen2,$kondisi2)); $result = array(); if ($query->num_rows() > 0) { $result = $query->result(); } return $result; } */ /* function get_rows_blankowwncra($thnmasuk,$jns_kelas,$kdprodi,$persen1,$kondisi1,$persen2,$kondisi2){ // data table $data = $this->get_data($thnmasuk,$jns_kelas,$kdprodi,$persen1,$kondisi1,$persen2,$kondisi2); $count = 0; $count1 = 0; $no = 1; $total = 0; $t_mhs = 0; $t_blm = 0; $t_tagih = 0; $tot_tagih = 0; $t_bayar = 0; $tot_bayar = 0; $t_sisa = 0; $tot_sisa = 0; $t_diskon = 0; $tot_diskon = 0; $rows = ""; foreach($data as $item) { $stlunas = $item->stlunas; $t_tagih += $item->biaya; $tot_tagih = number_format($t_tagih , 2 , ',' , '.' ); $t_bayar += $item->jmlbayar; $tot_bayar = number_format($t_bayar , 2 , ',' , '.' ); $t_sisa += $item->sisa; $tot_sisa = number_format($t_sisa , 2 , ',' , '.' ); $t_diskon += $item->diskon; $tot_diskon = number_format($t_diskon , 2 , ',' , '.' ); if ($stlunas == 'Lunas'){ $count = 1; $t_mhs += $count; } if ($stlunas == 'Belum Lunas'){ $count1 = 1; $t_blm += $count1; } $rows .= " ".$no.". ".$item->nim." ".$item->nmmhs." ".$item->nmstawalmhs." ".$item->nmstaktivitasmhs." ".$item->nmklsmhs." ".number_format($item->biayapersmt , 2 , ',' , '.' )." ".number_format($item->jmlbayar , 2 , ',' , '.' )." ".number_format($item->persenbayarper , 0 , ',' , '.' )." % ".number_format($item->sisaper , 2 , ',' , '.' )." ".number_format($item->persensisaper , 0 , ',' , '.' )." % ".$item->stlunasper." ".number_format($item->diskon , 2 , ',' , '.' )." "; $no++; } $rows .= " TOTAL LUNAS : $t_mhs org TOTAL BLM LUNAS : $t_blm org TOTAL (Rp.) : $tot_tagih $tot_bayar $tot_sisa $tot_diskon "; return $rows; } */ function get_blanko_wawancara($idjadwalpmbnya,$kdprodinya){ /* $row_tahun = $this->get_row_pars("tahun","tahun","tahun='$thnmasuk'"); $row_jnskelas = ($jns_kelas == 4) ? 'SEMUA':$this->get_row_pars("klsmhs","concat(kdklsmhs, '-', nmklsmhs) AS nmjnskls","idklsmhs='$jns_kelas'"); $row_prodi = $this->get_row_pars("prodi","nmprodi","kdprodi='$kdprodi'"); $tahun = $row_tahun->tahun; $kelas = ($jns_kelas == 4) ? 'SEMUA':$row_jnskelas->nmjnskls; $prodi = $row_prodi->nmprodi; $angkatan_gjl = $tahun.'1'; $angkatan_gnp = $tahun.'2'; $smt1ganjil = $this->get_row_pars("vv_status_semester","*","kdstsemester='$angkatan_gjl'"); $smt1ganjilthn = $smt1ganjil->kdthnakademik; $smt1ganjiljns = $smt1ganjil->nmjnssemester; $smt1genap = $this->get_row_pars("vv_status_semester","*","kdstsemester='$angkatan_gnp'"); $smt1genapjns = $smt1genap->nmjnssemester; $angkatan_plus = intval($tahun)+1; $agktn_gjl = $angkatan_plus.'1'; $agktn_gnp = $angkatan_plus.'2'; $smt2ganjil = $this->get_row_pars("vv_status_semester","*","kdstsemester='$agktn_gjl'"); $smt2ganjilthn = $smt2ganjil->kdthnakademik; $smt2ganjiljns = $smt2ganjil->nmjnssemester; $smt2genap = $this->get_row_pars("vv_status_semester","*","kdstsemester='$agktn_gnp'"); $smt2genapjns = $smt2genap->nmjnssemester; $optfull = $kondisi1.' '.$persen1.'% '.$opt.' '.$kondisi2.' '.$persen2.'%'; $optpart = $kondisi1.' '.$persen1.'%'; $opt = (!$kondisi2) ? $optpart:$optfull; */ //$plus = intval($thnakademik)+1; //$thnsmt = $thnakademik.'/'.$plus; $thnakademik = $this->get_par_val("jadwalpmb","kdstsemester","idjadwalpmb='$idjadwalpmbnya'"); $th = substr($thnakademik, 0, -1); $row_thakasmt = $this->get_row_pars("v_tahunakademik","nmthnakademik","kdstsemester='$thnakademik'"); $akasmt = $row_thakasmt->nmthnakademik; //get data pendaftar $this->db->select("nopmb,nama,kdjk,prodi1"); $this->db->from('v_inputhasilusm'); if($idjadwalpmbnya !=''){ $where['idjadwalpmb'] =$idjadwalpmbnya; } if($kdprodinya !=''){ $where['kdprodi1'] =$kdprodinya; } $where['idstmskmhs']='2'; $this->db->where($where); $q = $this->db->get(); $result = array(); if ($q->num_rows() > 0) { $result = $q->result(); } // $this->pdf_blanko_wawancara->SetCreator(PDF_CREATOR); //$image_file = base_url().'resources/img/report.png'; // set default header data $this->pdf_blanko_wawancara->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,PDF_HEADER_TITLE,PDF_HEADER_STRING); $this->pdf_blanko_wawancara->setPrintHeader(true); $this->pdf_blanko_wawancara->setPrintFooter(false); // set header and footer fonts $this->pdf_blanko_wawancara->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', 10)); $this->pdf_blanko_wawancara->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $this->pdf_blanko_wawancara->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); // set margins $this->pdf_blanko_wawancara->SetMargins('5', '34', '20'); $this->pdf_blanko_wawancara->SetHeaderMargin('10'); $this->pdf_blanko_wawancara->SetFooterMargin(PDF_MARGIN_FOOTER); // set auto page breaks $this->pdf_blanko_wawancara->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); // set image scale factor $this->pdf_blanko_wawancara->setImageScale(PDF_IMAGE_SCALE_RATIO); // set some language-dependent strings (optional) // --------------------------------------------------------- //MUNCULKAN DAFTAR MAHASISWA foreach($result as $row) { // set font $this->pdf_blanko_wawancara->SetFont('helvetica', 'B', 8); $this->pdf_blanko_wawancara->SetCellPadding(0); // add a page $this->pdf_blanko_wawancara->AddPage('P','F4'); $this->pdf_blanko_wawancara->Write(0, 'FORMULIR WAWANCARA', '', 0, 'C', true, 0, false, false, 0); $this->pdf_blanko_wawancara->Write(0, 'PPMB TAHUN '.$th.' GELOMBANG __', '', 0, 'C', true, 0, false, false, 0); $this->pdf_blanko_wawancara->Write(0, 'PENERIMAAN MAHASISWA BARU TAHUN AKADEMIK '.$akasmt, '', 0, 'C', true, 0, false, false, 0); //$this->pdf_blanko_wawancara->Cell(0,0,'',0,1,'L'); // untuk memberi space $this->pdf_blanko_wawancara->SetFont('helvetica', 'B', 8); //$rows_get_dpk = $this->get_rows_blankowwncra(); $kotak = base_url().'resources/img/kotak_report.png'; $tbl = <<

NO.TES	: $row->nopmb	NAMA / JKL	: $row->nama / $row->kdjk
PROGRAM STUDI	: $row->prodi1

MATERI WAWANCARA

NO.	MATERI	BOBOT
1.	Pengetahuan Umum	2
2.	Pengetahuan Khusus atau Kemampuan Dasar sesuai dengan Program Studi yang Dipilih	4
3.	Logika atau Sistematika Berpikir	2
4.	Motivasi Memilih Program Studi	1
5.	Penampilan Diri Sebagai Mahasiswa	1
	JUMLAH NILAI	10

REKOMENDASI

NILAI	HASIL WAWANCARA	KETERANGAN
61-100	Diterima	PERKIRAAN HASIL KONVERSI :
50-60	Diterima, dengan catatan :	Jumlah sks diakui : ....... sks Jumlah Matakuliah diakui : ....... sks IPK Hasil Konversi : .......
< 50	Tidak Diterima	Catatan : Konversi yang lebih akurat, diperoleh pada saat perwalian sesuai dengan kurikulum yang berlaku

Beri dengan tanda (v) pada kotak yang tersedia

Bandung, ____________________________ Pewawancara _____________________________________

Potong di sini
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Lembar untuk PEWAWANCARA
PPMB TAHUN $th GELOMBANG __
PENERIMAAN MAHASISWA BARU TAHUN AKADEMIK $akasmt

NO.TES	: $row->nopmb	NAMA / JKL	: $row->nama / $row->kdjk
PROGRAM STUDI	: $row->prodi1

NILAI :
REKOMENDASI	: [ ] Diterima	[ ] Tidak Diterima
	[ ] Diterima dengan Catatan

	Bandung, ____________________________
Peserta Wawancara	Pewawancara
$row->nama	__________________________________________

EOD; $this->pdf_blanko_wawancara->writeHTML($tbl,true,false,false,false); }//END MUNCULKAN DAFTAR MAHASISWA $this->pdf_blanko_wawancara->Output('pblankowawancara.pdf', 'I'); } } ?>