API tools faq
paste
emprit

bukti_bayar.spp

emprit
May 22nd, 2014
250
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.80 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include "../../conn.php";
  4. define('FPDF_FONTPATH', 'fpdf/font/');
  5. include "fpdf/fpdf.php";
  6. function chappsdate($waktu){
  7.     if (isset($waktu)){
  8.     $waktu_bulan= substr($waktu,5,2)-1;
  9.     $bulan_aray= array('Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
  10.     return substr($waktu,8,2)." ".$bulan_aray[$waktu_bulan]." ".substr($waktu,0,4);
  11.     }
  12. }
  13.  
  14. $semes = mysql_query("SELECT kode, ket_smstr FROM semester where aktif='aktif'");
  15. $sm = mysql_fetch_array($semes);
  16. $status = $sm['ket_smstr'];
  17.  
  18. /* query */
  19.     $kode = $_POST['kode'];
  20.     $nis  = $_POST['nis'];
  21.     $input=$_POST['input'];
  22.     $jml_bulan = count($input);
  23.     //echo $jml_bulan;die();
  24.  
  25.  
  26.  
  27.     $statusbulan=$_POST['statusbulan'];
  28.     $bulangasal = array("juli","agustus","september","oktober","nopember","desember");
  29.     $bulangenap = array("januari","februari","maret","april","mei","juni");
  30.     $bulan = $statusbulan=='Gasal'?$bulangasal:$bulangenap;
  31.  
  32.     $val=date('m')%6;
  33.     $val=$val==0?6:$val;
  34.  
  35.     //mencari tahu apakah dalam tabel keu sudah ada data siswa yg bersangkutan
  36.     $query = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());
  37.     if (mysql_num_rows($query)=='1') {
  38.             $data=mysql_fetch_array($query);
  39.            
  40.             foreach($bulan as $bln){
  41.                    
  42.                 if($data[$bln] == NULL or $data[$bln] == $val or $data[$bln] == '0'.$val){
  43.          
  44.                 $qry=mysql_query("UPDATE keu_".$kode."
  45.                                        SET $bln=".(isset($input[$bln])?$input[$bln]:'NULL')."
  46.                                        WHERE nis=".$nis) or die(mysql_error());
  47.                 $aktifitas="User operator {$_SESSION['login_name']} "
  48.                           ."menginput spp siswa dengan nis={$nis} bulan={$bln} membayar pada bulan=".(isset($input[$bln])?$input[$bln]:'NULL');
  49.                 include "../keylog.php";
  50.                 }
  51.             }
  52.  
  53.  
  54.             class PDF extends FPDF
  55.             {
  56.                 function Header()
  57.                 {
  58.                     global $status;
  59.                     $this->Image('/home/wiyr1282/public_html/images/logo.jpg',3.3,0.8,2);
  60.                     $this->SetFont('Times','B','10');
  61.                     $this->Cell(19,0.5,'BUKTI BAYAR SPP',0,0,'C');
  62.                     $this->Ln();
  63.                     $this->SetFont('Times','B','11');
  64.                     $this->Cell(19,0.5,'SMK PALEBON SEMARANG',0,0,'C');
  65.                     $this->Ln();
  66.                     $this->Cell(19,0.5,'Jalan Palebon Raya No. 30 Pedurungan Semarang (50199)',0,0,'C');
  67.                     $this->SetFont('Times','B','10');
  68.                     $this->Ln();
  69.                     $this->Cell(19,0.5,'Semester '.$status,0,0,'C');
  70.                     $this->Line(2,3.3,19,3.3);
  71.                     $this->Line(2,3.4,19,3.4);
  72.                     $this->Ln();
  73.                 }
  74.              
  75.                 public function Footer()
  76.                 {  
  77.                     $this->SetY(-2,5);
  78.                     $this->SetFont('Times','','6');
  79.                     $this->Cell(5,0.5,'di cetak oleh '.$_SESSION['login_name'].'  jam:'.date ("H:i:s"),0,false,'C',0,'',0,false,'T','M');
  80.                 }
  81.             }
  82.  
  83.  
  84.  
  85.             $pdf = new PDF('P','cm','a4');
  86.             $pdf->Open();
  87.             $pdf->AliasNbPages();
  88.  
  89.             $kat = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());
  90.             $u = mysql_fetch_array($kat);
  91.             foreach($bulan as $bln){
  92.              
  93.             //kalo di echo $bln." ".$u[$bln]." ".$val hasilnya ada yg september 4 4 tapi kenapa gmw nyetak pdf?;  
  94.                    
  95.                 if($u[$bln] != $val or $u[$bln] != '0'.$val){
  96.  
  97.                 }else{
  98.  
  99.                 $pdf->AddPage();
  100.                 $pdf->SetMargins('2','1','1');
  101.                 $pdf->Ln();
  102.                 $pdf->Ln();
  103.  
  104.                
  105.  
  106.                 //mencaritahu dari identitas siswa
  107.                 $s = mysql_fetch_array(mysql_query("SELECT * FROM student where nis='".$nis."'"));
  108.                 //mendapatkan kelas
  109.                 $k = mysql_fetch_array(mysql_query("SELECT kelas, jurusan, sub_kelas FROM kelas WHERE id_kelas='".$s['id_kelas']."'"));
  110.                 //mendapatkan tarif
  111.                 $tarif = mysql_fetch_object(mysql_query("SELECT tarif FROM tarif WHERE id_kelas='".$s['id_kelas']."'"));
  112.                 $nominal = $tarif->tarif;
  113.  
  114.                 $pdf->Cell(3.5,0.5,'Nama ',0,0,'L');
  115.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  116.                 $pdf->Cell(5,0.5,$s['nama'],0,1,'L');
  117.  
  118.                 $pdf->Cell(3.5,0.5,'NIS',0,0,'L');
  119.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  120.                 $pdf->Cell(5,0.5,$s['nis'],0,1,'L');
  121.  
  122.                 $pdf->Cell(3.5,0.5,'Kelas',0,0,'L');
  123.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  124.                 $pdf->Cell(5,0.5,$k['kelas']." ".$k['jurusan']." ".$k['sub_kelas'],0,1,'L');
  125.  
  126.                 $pdf->Cell(3.5,0.5,'Jumlah Nominal',0,0,'L');
  127.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  128.                 $pdf->Cell(5,0.5,$nominal,0,1,'L');
  129.  
  130.                 $pdf->Cell(19,0.5,'Untuk pembayaran pada bulan '.ucfirst($bln),0,1,'L');
  131.                 $pdf->Ln();
  132.                 $pdf->Cell(13,0.5,'',0,0,'L');
  133.                 $pdf->Cell(4,0.5,'Semarang, '.chappsdate(date("Y-m-d")),0,1,'C');
  134.                 $pdf->Cell(13,1,'',0,0,'L');
  135.                 $pdf->Cell(4,0.5,'( '.$_SESSION['nama_lengkap'].' )',0,1,'C');
  136.             }
  137.         }
  138.             $pdf->Output("Bukti Bayar ".$_POST['nis'].".pdf","I");
  139.  
  140.  
  141.     }else {
  142.  
  143.         $sql="INSERT keu_".$kode." (id_keu, nis, ".implode(',', $bulan).") VALUES ('','$nis'";
  144.         foreach($bulan as $bln){
  145.                 $sql.=",".(isset($input[$bln])?$input[$bln]:'NULL');
  146.         }
  147.         $sql.=")";
  148.  
  149.         $aktifitas="User operator {$_SESSION['login_name']} "
  150.                   ."menginput spp siswa dengan nis={$nis} bulan=".implode(',', $bulan);
  151.         include "../keylog.php";
  152.        
  153.         $qry=mysql_query($sql) or die(mysql_error());
  154.        
  155.  
  156.         $kode = $_POST['kode'];
  157.         $nis  = $_POST['nis'];
  158.         $input=$_POST['input'];
  159.  
  160.         class PDF extends FPDF
  161.             {
  162.                 function Header()
  163.                 {
  164.                     global $status;
  165.                     $this->Image('/home/wiyr1282/public_html/images/logo.jpg',3.3,0.8,2);
  166.                     $this->SetFont('Times','B','10');
  167.                     $this->Cell(19,0.5,'BUKTI BAYAR SPP',0,0,'C');
  168.                     $this->Ln();
  169.                     $this->SetFont('Times','B','11');
  170.                     $this->Cell(19,0.5,'SMK PALEBON SEMARANG',0,0,'C');
  171.                     $this->Ln();
  172.                     $this->Cell(19,0.5,'Jalan Palebon Raya No. 30 Pedurungan Semarang (50199)',0,0,'C');
  173.                     $this->SetFont('Times','B','10');
  174.                     $this->Ln();
  175.                     $this->Cell(19,0.5,'Semester '.$status,0,0,'C');
  176.                     $this->Line(2,3.3,19,3.3);
  177.                     $this->Line(2,3.4,19,3.4);
  178.                     $this->Ln();
  179.                 }
  180.              
  181.                 public function Footer()
  182.                 {  
  183.                     $this->SetY(-2,5);
  184.                     $this->SetFont('Times','','6');
  185.                     $this->Cell(5,0.5,'di cetak oleh '.$_SESSION['login_name'].'  jam:'.date ("H:i:s"),0,false,'C',0,'',0,false,'T','M');
  186.                 }
  187.             }
  188.  
  189.             $pdf = new PDF('P','cm','a4');
  190.             $pdf->Open();
  191.             $pdf->AliasNbPages();
  192.  
  193.             $kat = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());
  194.             $u = mysql_fetch_array($kat);
  195.             foreach($bulan as $bln){
  196.              
  197.             //kalo di echo $bln." ".$u[$bln]." ".$val hasilnya ada yg september 4 4 tapi kenapa gmw nyetak pdf?;  
  198.                    
  199.                 if($u[$bln] != $val or $u[$bln] != '0'.$val){
  200.  
  201.                 }else{
  202.  
  203.                 $pdf->AddPage();
  204.                 $pdf->SetMargins('2','1','1');
  205.                 $pdf->Ln();
  206.                 $pdf->Ln();
  207.  
  208.                
  209.  
  210.                 //mencaritahu dari identitas siswa
  211.                 $s = mysql_fetch_array(mysql_query("SELECT * FROM student where nis='".$nis."'"));
  212.                 //mendapatkan kelas
  213.                 $k = mysql_fetch_array(mysql_query("SELECT kelas, jurusan FROM kelas WHERE id_kelas='".$s['id_kelas']."'"));
  214.                 //mendapatkan tarif
  215.                 $tarif = mysql_fetch_object(mysql_query("SELECT tarif FROM tarif WHERE id_kelas='".$s['id_kelas']."'"));
  216.                 $nominal = $tarif->tarif;
  217.  
  218.                 $pdf->Cell(3.5,0.5,'Nama ',0,0,'L');
  219.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  220.                 $pdf->Cell(5,0.5,$s['nama'],0,1,'L');
  221.  
  222.                 $pdf->Cell(3.5,0.5,'NIS',0,0,'L');
  223.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  224.                 $pdf->Cell(5,0.5,$s['nis'],0,1,'L');
  225.  
  226.                 $pdf->Cell(3.5,0.5,'Kelas',0,0,'L');
  227.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  228.                 $pdf->Cell(5,0.5,$k['kelas']." ".$k['jurusan'],0,1,'L');
  229.  
  230.                 $pdf->Cell(3.5,0.5,'Jumlah Nominal',0,0,'L');
  231.                 $pdf->Cell(0.5,0.5,':',0,0,'C');
  232.                 $pdf->Cell(5,0.5,$nominal,0,1,'L');
  233.  
  234.                 $pdf->Cell(19,0.5,'Untuk pembayaran pada bulan '.ucfirst($bln),0,1,'L');
  235.                 $pdf->Ln();
  236.                 $pdf->Cell(13,0.5,'',0,0,'L');
  237.                 $pdf->Cell(4,0.5,'Semarang, '.chappsdate(date("Y-m-d")),0,1,'C');
  238.                 $pdf->Cell(13,1,'',0,0,'L');
  239.                 $pdf->Cell(4,0.5,'( '.$_SESSION['nama_lengkap'].' )',0,1,'C');
  240.             }
  241.         }
  242.             $pdf->Output("Bukti Bayar ".$_POST['nis'].".pdf","I");
  243.     }
  244. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!