cetak

<?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 = mysql_query("SELECT kode, ket_smstr FROM semester where aktif='aktif'");
$sm = mysql_fetch_array($semes);
$status = $sm['ket_smstr'];

/* query */
    $kode = $_POST['kode'];
    $nis  = $_POST['nis'];
    $input=$_POST['input'];

    $statusbulan=$_POST['statusbulan'];
    $bulangasal = array("juli","agustus","september","oktober","nopember","desember");
    $bulangenap = array("januari","februari","maret","april","mei","juni");
    $bulan = $statusbulan=='Gasal'?$bulangasal:$bulangenap;

    $val=date('m')%6;
    $val=$val==0?6:$val;

    //mencari tahu apakah dalam tabel keu sudah ada data siswa yg bersangkutan
    $query = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());


                class PDF extends FPDF
                {
                    function Header()
                    {
                        global $status;
                        $this->Image('../../../images/logo.JPG',3.3,0.8,2);
                        $this->SetFont('Times','B','10');
                        $this->Cell(19,0.5,'BUKTI BAYAR SPP',0,0,'C');
                        $this->Ln();
                        $this->SetFont('Times','B','11');
                        $this->Cell(19,0.5,'SMK PALEBON SEMARANG',0,0,'C');
                        $this->Ln();
                        $this->Cell(19,0.5,'Jalan Palebon Raya No. 30 Pedurungan Semarang (50199)',0,0,'C');
                        $this->SetFont('Times','B','10');
                        $this->Ln();
                        $this->Cell(19,0.5,'Semester '.$status,0,0,'C');
                        $this->Line(2,3.3,19,3.3);
                        $this->Line(2,3.4,19,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');
                    }
                }

                if (mysql_num_rows($query)=='1') {
                $data=mysql_fetch_array($query);

                foreach($bulan as $bln){

                    if($data[$bln] == NULL or $data[$bln] == $val or $data[$bln] == '0'.$val){

                    $qry=mysql_query("UPDATE keu_".$kode."
                                            SET $bln=".(isset($input[$bln])?$input[$bln]:'NULL')."
                                            WHERE nis=".$nis) or die(mysql_error());
                    $aktifitas="User operator {$_SESSION['login_name']} "
                              ."menginput spp siswa dengan nis={$nis} bulan={$bln} membayar pada bulan=".(isset($input[$bln])?$input[$bln]:'NULL');
                    include "../keylog.php";

                $pdf = new PDF('P','cm','a4');
                $pdf->Open();
                $pdf->AliasNbPages();
                $pdf->AddPage();
                $pdf->SetMargins('2','1','1');
                $pdf->Ln();
                $pdf->Ln();



                //mencaritahu dari identitas siswa
                $s = mysql_fetch_array(mysql_query("SELECT * FROM student where nis='".$nis."'"));
                //mendapatkan kelas
                $k = mysql_fetch_array(mysql_query("SELECT kelas, jurusan FROM kelas WHERE id_kelas='".$s['id_kelas']."'"));
                //mendapatkan tarif
                $tarif = mysql_fetch_object(mysql_query("SELECT tarif FROM tarif WHERE id_kelas='".$s['id_kelas']."'"));
                $nominal = $tarif->tarif;

                $pdf->Cell(3.5,0.5,'Nama ',0,0,'L');
                $pdf->Cell(0.5,0.5,':',0,0,'C');
                $pdf->Cell(5,0.5,$s['nama'],0,1,'L');

                $pdf->Cell(3.5,0.5,'NIS',0,0,'L');
                $pdf->Cell(0.5,0.5,':',0,0,'C');
                $pdf->Cell(5,0.5,$s['nis'],0,1,'L');

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

                $pdf->Cell(3.5,0.5,'Jumlah Nominal',0,0,'L');
                $pdf->Cell(0.5,0.5,':',0,0,'C');
                $pdf->Cell(5,0.5,$nominal,0,1,'L');

                $pdf->Cell(19,0.5,'Untuk pembayaran pada bulan '.ucfirst($bln),0,1,'L');
                $pdf->Ln();
                $pdf->Cell(13,0.5,'',0,0,'L');
                $pdf->Cell(4,0.5,'Semarang, '.chappsdate(date("Y-m-d")),0,1,'C');
                $pdf->Cell(13,0.5,'',0,0,'L');
                $pdf->Cell(4,0.5,'( '.$_SESSION['nama_lengkap'].' )',0,1,'C');


                $pdf->Output("Bukti Bayar ".$_POST['nis'].".pdf","D");
                }
            }

    }else {

        $sql="INSERT keu_".$kode." (id_keu, nis, ".implode(',', $bulan).") VALUES ('','$nis'";
        foreach($bulan as $bln){
                $sql.=",".(isset($input[$bln])?$input[$bln]:'NULL');
        }
        $sql.=")";

        $aktifitas="User operator {$_SESSION['login_name']} "
                  ."menginput spp siswa dengan nis={$nis} bulan=".implode(',', $bulan);
        include "keylog.php";

        $qry=mysql_query($sql) or die(mysql_error());
        header('location: aW5wdXRfcGVyc2lzd2E-'.$setting->safe_b64encode($qry?'2':'1').'.htm');

    }
?>