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,