$worksheet->merge_cells(8, 4, 8, 4);
$worksheet->write_string(8, 4, 'Tabungan Akhir', $h4);
$worksheet->merge_cells(8, 5, 8, 5);
$worksheet->write_string(8, 5, 'Prakerin', $h4);
$worksheet->merge_cells(8, 6, 8, 6);
$worksheet->write_string(8, 6, 'Kesiswaan', $h4);
$worksheet->merge_cells(8, 7, 8, 7);
$worksheet->write_string(8, 7, 'Sumbangan', $h4);
$worksheet->merge_cells(7, 8, 8, 8);
$worksheet->write_string(7, 8, 'Nominal Sumbangan', $h4);
$view->get_list_siswa($jenjangKelas, $idKelas);
$row=9;
$number=1;
while($result=$view->get_array()){
$worksheet->write_string($row, 0, $number, $content);
$worksheet->write_string($row, 1, $result['NIS'], $content);
$worksheet->write_string($row, 2, $result['NAMA'], $content);
$worksheet->write_string($row, 3, number_format($result['TOTAL_KOMITE'],2,',','.'), $content);
$worksheet->write_string($row, 4, number_format($result['TOTAL_TA'],2,',','.'), $content);
$worksheet->write_string($row, 5, number_format($result['TOTAL_PRAKERIN'],2,',','.'), $content);
$worksheet->write_string($row, 6, number_format($result['TOTAL_OSIS'],2,',','.'), $content);
$worksheet->write_string($row, 7, number_format($result['TOTAL_DPS'],2,',','.'), $content);
$worksheet->write_string($row, 8, number_format($result['NoMINAL_DPS'],2,',','.'), $content);
$row++;$number++;
}
$tmpl->readTemplatesFromFile("detil_kelas_view.html");
//print_r($_POST);
$klsJenjang = $_POST['jenjang'];
$klsId = $_POST['kelas'];
$view = new rekap_siswa;
$view->connect();
$view->get_kelas_detil($klsId);
$namaKelas = $view->get_array();
$tmpl->addVar("article", "HEADLINE", "Rekap Iuran Siswa Kelas ".$klsJenjang." - ".$namaKelas['NAMA']);
$tmpl->addVar("article", "URL_XLS", "module/rekap_siswa/cetak_excel_siswa.php?j=".$klsJenjang."&i=".$klsId."");
$view->get_list_siswa($klsJenjang, $klsId);
$row=0;
while($result=$view->get_array()){
$number=$row+1;
if ($number % 2 ==0){
$class_name='table-common-even';
}else{
$class_name='';
}
$disp[$row]=array('NO'=>$number,
'NIS'=>$result['NIS'],
'NAMA'=>$result['NAMA'],
'KOMITE'=>number_format($result['TOTAL_KOMITE'],2,',','.'),
'TA'=>number_format($result['TOTAL_TA'],2,',','.'),
'PRAKERIN'=>number_format($result['TOTAL_PRAKERIN'],2,',','.'),
'KESISWAAN'=>number_format($result['TOTAL_OSIS'],2,',','.'),