示例#1
0
	$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);
示例#2
0
<?
	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'],
示例#3
0
<?

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>";
}

?>
示例#4
0
<?

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);
}
示例#5
0
<?
	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='';
		}