aksi_lulus.php

<?php
session_start();
include "../../conn.php";
define('FPDF_FONTPATH', 'fpdf/font/');
include "fpdf/fpdf.php";
function chappsdate($waktu){
    if (isset($waktu)){
    $waktu_bulan= substr($waktu,5,2)-1;
    $bulan_aray= array('Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
    return substr($waktu,8,2)." ".$bulan_aray[$waktu_bulan]." ".substr($waktu,0,4);
    }
}

$semes = $_POST['semester'];
$kelas = $_POST['id_kelas'];
$k = mysql_fetch_array(mysql_query("SELECT kelas, jurusan, sub_kelas FROM kelas WHERE id_kelas='".$kelas."'"));

    class PDF extends FPDF
            {
                function Header()
                {
                    global $semes;
                    $this->Image('../../../images/logo.JPG',3.3,0.8,2);
                    $this->SetFont('Times','B','10');
                    $this->Cell(26,0.5,'KELULUSAN SISWA',0,0,'C');
                    $this->Ln();
                    $this->SetFont('Times','B','11');
                    $this->Cell(26,0.5,'YAYASAN PENDIDIKAN WIYATA TAMA',0,0,'C');
                    $this->Ln();
                    $this->Cell(26,0.5,'Jalan Palebon Raya No. 30 Pedurungan Semarang (50199)',0,0,'C');
                    $this->SetFont('Times','B','10');
                    $this->Ln();
                    $this->Cell(26,0.5,'Semester '.$semes,0,0,'C');
                    $this->Line(2,3.3,26,3.3);
                    $this->Line(2,3.4,26,3.4);
                    $this->Ln();
                }

                public function Footer()
                {
                    $this->SetY(-2,5);
                    $this->SetFont('Times','','6');
                    $this->Cell(5,0.5,'di cetak oleh '.$_SESSION['login_name'].'  jam:'.date ("H:i:s"),0,false,'C',0,'',0,false,'T','M');
                }
            }

            $pdf = new PDF('L','cm','a4');
            $pdf->Open();
            $pdf->AliasNbPages();
            $pdf->Ln();


            $pdf->Cell(3.5,0.5,'Kelas',0,0,'L');
            $pdf->Cell(0.5,0.5,':',0,0,'C');
            $pdf->Cell(8,0.5,$k['kelas']." ".$k['jurusan']." ".$k['sub_kelas'],0,1,'L');

            $pdf->Ln();
            //header
            $pdf->Cell(1,0.5,'No.',1,0,'C');
            $pdf->Cell(2,0.5,'NIS',1,0,'C');
            $pdf->Cell(4,0.5,'Nama',1,0,'C');
            $pdf->Cell(5,0.5,'Alamat',1,0,'C');
            $pdf->Cell(3,0.5,'Nama Ayah',1,0,'C');
            $pdf->Cell(3,0.5,'Nama Ibu',1,0,'C');
            $pdf->Cell(6,0.5,'No. HP',1,0,'C');
            $pdf->Cell(8,0.5,'Tempat, Tanggal Lahir',1,0,'C');
            $pdf->Cell(4,0.5,'Tanggal Masuk',1,1,'C');

            $no=1;
            foreach ($_POST['val'] as $nis => $value) {
                if($value == '1'){
                    $aktifitas="User Operator ".$_SESSION['login_name']." meluluskan siswa dengan nis=".$nis;
                    include"../keylog.php";

                    $sql = mysql_fetch_array(mysql_query("SELECT * FROM student WHERE nis='".$nis."'"));
                    $pdf->Cell(1,0.5,$no,1,0,'C');
                    $pdf->Cell(2,0.5,$sql['nis'],1,0,'C');
                    $pdf->Cell(4,0.5,$sql['nama'],1,0,'C');
                    $pdf->Cell(5,0.5,$sql['alamat'],1,0,'C');
                    $pdf->Cell(3,0.5,$sql['nama_bpk'],1,0,'C');
                    $pdf->Cell(3,0.5,$sql['nama_ibu'],1,0,'C');
                    $pdf->Cell(6,0.5,$sql['no_hp'],1,0,'C');
                    $pdf->Cell(8,0.5,$sql['tempat'].", ".chappsdate($sql['tgl_lahir']),1,0,'C');
                    $pdf->Cell(4,0.5,chappsdate($sql['tgl_masuk']),1,0,'C');
                    $pdf->Cell(6,0.5,'DELETE student WHERE nis=$nis',1,1,'C');
                    //$del = mysql_query("DELETE student WHERE nis='$nis'")or die(mysql_error());
                }
                $no++;
            }
            $pdf->Output("REKAP SISWA LULUS.pdf","D");

?>