emprit

rekap.php

Jun 11th, 2012
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 5.31 KB | None | 0 0
  1. <?php
  2. session_start();
  3. if (!isset($_SESSION['username'])) {
  4.  
  5.         echo '<script>alert("Silahkan Hubungi Admin untuk konfirmasi!")</script>';
  6.  
  7.         echo '<meta http-equiv="refresh" content="0; url=index.php" />';
  8.  
  9.         header('location:../../index.php');
  10.  
  11.     }else {
  12. include "../../koneksi.php";
  13. include "chapps.php";
  14. echo "<link rel='stylesheet' href='http://localhost/keuangan/emprit/setting/background.css' type='text/css'></link>";
  15. echo"<h2><center>Detail Rekap Pendapatan</center></h1>";   
  16.  
  17. if($_POST['tbl_perhari'])
  18. {
  19.     echo"<h2>Perhari</h2>";
  20.     #####################################################
  21.     # memasukan inputan yg diperlukan dlm rekap perhari #
  22.     $tgl_perhari=$_POST['tgl_perhari'];
  23.     $bln_perhari=$_POST['bln_perhari'];
  24.     $thn_perhari=$_POST['thn_perhari'];
  25.     $gb_perhari=$thn_perhari.'-'.$bln_perhari.'-'.$tgl_perhari;
  26.     $waktu=$thn_perhari.'-'.$bln_perhari.'-'.$tgl_perhari;
  27.     $tanggal=chappsdate($waktu);
  28.     echo"$tanggal";
  29.     $dapat=mysql_query("SELECT * FROM transaksi WHERE kode='input' and tanggal='$gb_perhari'") or die (mysql_error());
  30.    
  31.     $dt_total=mysql_num_rows(mysql_query($dapat));
  32.     if($dt_total=0) {
  33.         $dt_total=0;
  34.         }
  35.     echo"Total Data Pendapatan: $dt_total";
  36.     ?>
  37.     <table cellpadding='5px' border='1' style='border-collapse:collapse'>
  38.       <tr bgcolor='#ba55d3'>
  39.         <th>No</th>
  40.         <th>Nomer Inputan </th>
  41.         <th>Penginput </th>
  42.         <th>Sumber Dana</th>
  43.        <th>Biaya Pendaftaran</th>
  44.        <th>Bukti Kwitansi</th>
  45.         <th>Jumlah Dana</th>
  46.       </tr>
  47.      
  48.       <?php
  49.         $no=1;
  50.         $dtcl=mysql_query($dapat);
  51.         while($cl=mysql_fetch_array($dtcl))
  52.         {
  53.         if(($no % 2)==0){
  54.         $bgcolor="#FFCC66";
  55.         }else{
  56.         $bgcolor="#FF9933";
  57.         }
  58.       ?>
  59.       <tr bgcolor="<?=$bgcolor?>">
  60.         <td><?=$no?></td>
  61.         <td><?=$cl[nomer]?></td>
  62.         <td><?=$cl[penginput]?></td>
  63.         <td><?=$cl[jumlah]?></td>
  64.         <td><?=$cl[sumber]?></td>
  65.        <td><? echo "<img src=".$cl['file']." style='width:400px; height: 267px;' />";  ?></td>
  66.       </tr>
  67.       <?php
  68.       $no++;
  69.       $jmlh1+=$cl[jumlah];
  70.       $uang=chappsrupiah($jmlh1);
  71.       }
  72.       ?>
  73.       <tr>
  74.         <td colspan='6' align="right">Total Biaya </td>
  75.         <td colspan='3' align='right'><? echo ".$uang.";?></td>
  76.       </tr>
  77.       <tr>
  78.       <td colspan='9' align='center'><form name='form1' target='_blank' action='print/rekap_daftar_perhari.php' method='post'>
  79.        <input type='hidden'  value='<?=$gb_perhari?>' name='tgl'>
  80.        <input type='submit' name='Submit' value='Cetak'>
  81.         </form></td>
  82.       </tr>
  83.     </table>
  84.  
  85. <?php
  86. }
  87. elseif($_POST[tbl_pertgl])
  88. {
  89.  
  90.     echo "<h2>Pertanggal</h2>";
  91.     #########################################
  92.     # perhitungan  pertangal
  93.     ########################################
  94.     # Persiapan charakter yang diperlukan dalam select
  95.     $tgl_start=$_POST[tgl_pertgl_start];
  96.     $bln_start=$_POST[bln_pertgl_start];
  97.     $thn_start=$_POST[thn_pertgl_start];
  98.     $tgl_stop=$_POST[tgl_pertgl_stop];
  99.     $bln_stop=$_POST[bln_pertgl_stop];
  100.     $thn_stop=$_POST[thn_pertgl_stop];
  101.     $gb_start=$thn_start.'-'.$bln_start.'-'.$tgl_start;
  102.     $gb_stop=$thn_stop.'-'.$bln_stop.'-'.$tgl_stop;
  103.     echo"$gb_start s/d $gb_stop<br>";
  104.     $dt_pagi=mysql_num_rows(mysql_query("SELECT * FROM $calon_pagi WHERE tgl_daftar BETWEEN '$gb_start' AND '$gb_stop'"));
  105.     $dt_sore=mysql_num_rows(mysql_query("SELECT * FROM $calon_sore WHERE tgl_daftar BETWEEN '$gb_start' AND '$gb_stop'"));
  106.     $union=("(SELECT * FROM $calon_pagi WHERE tgl_daftar BETWEEN '$gb_start' AND '$gb_stop')union(SELECT * FROM $calon_sore WHERE tgl_daftar BETWEEN '$gb_start' AND '$gb_stop')");
  107.     #echo"$union";
  108.     $dt_total=mysql_num_rows(mysql_query($union));
  109.     echo"Total Pendaftar Pagi : $dt_pagi<br>";
  110.     echo"Total Pendaftar Sore dan Karyawan : $dt_sore<br>";
  111.     echo"Total Pendaftar: $dt_total";
  112.     ?>
  113.     <table width="900" border="1">
  114.       <tr>
  115.         <th width="34" rowspan="2">No</th>
  116.         <th width="93" rowspan="2">No pendaftar</th>
  117.         <th width="291" rowspan="2">Nama Calon Pendaftar </th>
  118.         <th colspan="2">Pilihan</th>
  119.         <th width="89" rowspan="2">Status</th>
  120.         <th width="94" rowspan="2">Biaya Pendaftaran</th>
  121.       </tr>
  122.       <tr>
  123.         <th width="118">Pil 1 </th>
  124.         <th width="135">Pil 2 </th>
  125.       </tr>
  126.       <?php
  127.         $no=1;
  128.         $dtcl=mysql_query($union);
  129.         while($cl=mysql_fetch_array($dtcl))
  130.         {
  131.         if(($no % 2)==0){
  132.         $bgcolor="#FFCC66";
  133.         }else{
  134.         $bgcolor="#FF9933";
  135.         }
  136.       ?>
  137.       <tr bgcolor="<?=$bgcolor?>">
  138.         <td><?=$no?></td>
  139.         <td><?=$cl[no_pendaftaran]?></td>
  140.         <td><?=$cl[nama_lengkap]?></td>
  141.         <?php
  142.         # KETERANGAN PROGDI
  143.         $p1=mysql_fetch_array(mysql_query("SELECT nama_prodi FROM progdi WHERE kode_prodi='$cl[pilihan1]'"));
  144.         $p2=mysql_fetch_array(mysql_query("SELECT nama_prodi FROM progdi WHERE kode_prodi='$cl[pilihan2]'"));
  145.         ?>
  146.         <td><?=$p1[nama_prodi]?></td>
  147.         <td><?=$p2[nama_prodi]?></td>
  148.         <td align="right"><?=$cl[kelas]?></td>
  149.         <td align="right"><? echo rp($cl[bayar]); ?></td>
  150.       </tr>
  151.       <?php
  152.       $no++;
  153.       $jmlh1+=$cl[bayar];
  154.       }
  155.       ?>
  156.       <tr>
  157.         <td colspan="5">Total Biaya </td>
  158.         <td align="right">&nbsp;</td>
  159.         <td align="right"><? echo rp($jmlh1);?></td>
  160.       </tr>
  161.       <tr>
  162.       <td colspan="7" align="center"><form name="form1" method="post" action="print/rekap_pendaftaran_pertanggal.php" target="_blank">
  163.         <input type='text' value='<?=$gb_start?>' name='pertanggal'>
  164.         <input type='text' value='<?=$gb_stop?>' name='pertgl'>
  165.         <input type="submit" name="Submit" value="Cetak"/>
  166.         </form></td>
  167.       </tr>
  168.     </table>
  169. <?php
  170. }  
  171. }
  172. ?>
Advertisement
Add Comment
Please, Sign In to add comment