$content =& $workbook->add_format();
$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);
<?
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'],
<?
require_once("business/rekap_siswa.class.php");
//print_r($_POST);
if (!is_numeric($_POST['nominal']))
$error[] = '-> Nominal harus diisi angka';
if ($_POST['nominal']<0)
$error[] = '-> Nominal tidak boleh 0 atau negatif';
if ($error) {
echo implode('<br />', $error);
}else{
$nis = $_POST['nis'];
$nominal = $_POST['nominal'];
$iuran = $_POST['iuran'];
$idTr = $_POST['idTr'];
$update = new rekap_siswa;
$update->update_transaksi($nis, $nominal, $iuran, $idTr);
echo "<b>Data Transaksi Berhasil Diupdate</b>";
}
?>
<?
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);
}
<?
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='';
}