$content->set_align('top'); $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);
<? require_once("business/rekap_siswa.class.php"); $tmpl->setBasedir("module/rekap_siswa/templates"); $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'],