require_once("business/rekap_siswa.class.php");
$tmpl->setBasedir("module/rekap_siswa/templates");
$tmpl->readTemplatesFromFile("edit_siswa_view.html");
$tmpl->addVar("article", "URL_PROSES", "module/rekap_siswa/process_request.php");
//print_r($code);
$idTr=$code['idTr'];
$edit = new rekap_siswa;
$edit->connect();
$edit->get_detail_transaksi($idTr);
$row=0;
while($result=$edit->get_array()){
$disp[$row]=array(
'ID_TR'=>$idTr,
'NIS'=>$result['NIS'],
'NAMA'=>$result['NAMA'],
'TANGGAL'=>$result['TANGGAL'],
'ID_TRANS'=>$result['ID_TRANS'],
'NOMINAL'=>$result['NOMINAL']);
$row++;
}
//print_r($disp);
foreach($disp as $data){
$tmpl->addVars("data", $data);
}
$edit->display_iuran();
$content->set_size(8);
$content->set_color('black');
$content->set_border(1);
$worksheet =& $workbook->add_worksheet();
$worksheet->set_landscape();
$worksheet->set_paper(5);
$worksheet->hide_gridlines();
$worksheet->set_margin_left(2.5);
$worksheet->set_margin_top(0.5);
$worksheet->set_margin_right(0);
$worksheet->set_margin_bottom(0);
$view = new rekap_siswa;
$view->get_kelas_detil($idKelas);
$namaKelas = $view->get_array();
$worksheet->merge_cells(1, 0, 2, 8);
$worksheet->write_string(1, 0, 'SMK N 2 TEMANGGUNG', $h3);
$worksheet->merge_cells(3, 0, 3, 8);
$worksheet->write_string(3, 0, 'Rekapitulasi Dana Iuran Siswa', $h3);
$worksheet->set_column(0, 0, 3);
$worksheet->set_column(1, 1, 10);
$worksheet->set_column(2, 2, 20);
$worksheet->set_column(3, 3, 15);
$worksheet->set_column(4, 4, 15);
$worksheet->set_column(5, 5, 15);
$worksheet->set_column(6, 6, 15);
$worksheet->set_column(7, 7, 15);
require_once("business/rekap_siswa.class.php");
require_once("function/format_tanggal.php");
$tmpl->setBasedir("module/rekap_siswa/templates");
$tmpl->readTemplatesFromFile("detil_siswa_view.html");
$tmpl->addVar("article", "HEADLINE", "Detail Rekap Siswa");
//print_r($code);
$nis=$code['nis']; //didecrypt di index.php
$view = new rekap_siswa;
$view->connect();
$view->get_siswa($nis);
$siswa = $view->get_array();
$tmpl->addVar("article", "NIS", $siswa['NIS']);
$tmpl->addVar("article", "NAMA", $siswa['NAMA']);
$tmpl->addVar("article", "KELAS", $siswa['JENJANG']." - ".$siswa['KELAS']);
$view->get_list_transaksi($nis);
while($result=$view->get_array()){
$number=$row+1;
if ($number % 2 ==0){
$class_name='table-common-even';
}else{
$class_name='';
}
$disp[$row]=array('NO_TRANS'=>$number,
