Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- if (!isset($_SESSION['username'])) {
- echo '<script>alert("Silahkan Hubungi Admin untuk konfirmasi!")</script>';
- echo '<meta http-equiv="refresh" content="0; url=index.php" />';
- header('location:../../index.php');
- }else {
- include "../../koneksi.php";
- include "chapps.php";
- echo "<link rel='stylesheet' href='http://localhost/keuangan/emprit/setting/background.css' type='text/css'></link>";
- echo"<h2><center>Detail Rekap Pendapatan</center></h1>";
- if($_POST['tbl_perhari'])
- {
- echo"<h2>Perhari</h2>";
- #####################################################
- # memasukan inputan yg diperlukan dlm rekap perhari #
- $tgl_perhari=$_POST['tgl_perhari'];
- $bln_perhari=$_POST['bln_perhari'];
- $thn_perhari=$_POST['thn_perhari'];
- $gb_perhari=$thn_perhari.'-'.$bln_perhari.'-'.$tgl_perhari;
- $waktu=$thn_perhari.'-'.$bln_perhari.'-'.$tgl_perhari;
- $tanggal=chappsdate($waktu);
- echo"$tanggal";
- $dapat=mysql_query("SELECT * FROM transaksi WHERE kode='input' and tanggal='$gb_perhari'") or die (mysql_error());
- $dt_total=mysql_num_rows(mysql_query($dapat));
- if($dt_total=0) {
- $dt_total=0;
- }
- echo"Total Data Pendapatan: $dt_total";
- ?>
- <table cellpadding='5px' border='1' style='border-collapse:collapse'>
- <tr bgcolor='#ba55d3'>
- <th>No</th>
- <th>Nomer Inputan </th>
- <th>Penginput </th>
- <th>Sumber Dana</th>
- <th>Biaya Pendaftaran</th>
- <th>Bukti Kwitansi</th>
- <th>Jumlah Dana</th>
- </tr>
- <?php
- $no=1;
- $dtcl=mysql_query($dapat);
- while($cl=mysql_fetch_array($dtcl))
- {
- if(($no % 2)==0){
- $bgcolor="#FFCC66";
- }else{
- $bgcolor="#FF9933";
- }
- ?>
- <tr bgcolor="<?=$bgcolor?>">
- <td><?=$no?></td>
- <td><?=$cl[nomer]?></td>
- <td><?=$cl[penginput]?></td>
- <td><?=$cl[jumlah]?></td>
- <td><?=$cl[sumber]?></td>
- <td><? echo "<img src=".$cl['file']." style='width:400px; height: 267px;' />"; ?></td>
- </tr>
- <?php
- $no++;
- $jmlh1+=$cl[jumlah];
- $uang=chappsrupiah($jmlh1);
- }
- ?>
- <tr>
- <td colspan='6' align="right">Total Biaya </td>
- <td colspan='3' align='right'><? echo ".$uang.";?></td>
- </tr>
- <tr>
- <td colspan='9' align='center'><form name='form1' target='_blank' action='print/rekap_daftar_perhari.php' method='post'>
- <input type='hidden' value='<?=$gb_perhari?>' name='tgl'>
- <input type='submit' name='Submit' value='Cetak'>
- </form></td>
- </tr>
- </table>
- <?php
- }
- elseif($_POST[tbl_pertgl])
- {
- echo "<h2>Pertanggal</h2>";
- #########################################
- # perhitungan pertangal
- ########################################
- # Persiapan charakter yang diperlukan dalam select
- $tgl_start=$_POST[tgl_pertgl_start];
- $bln_start=$_POST[bln_pertgl_start];
- $thn_start=$_POST[thn_pertgl_start];
- $tgl_stop=$_POST[tgl_pertgl_stop];
- $bln_stop=$_POST[bln_pertgl_stop];
- $thn_stop=$_POST[thn_pertgl_stop];
- $gb_start=$thn_start.'-'.$bln_start.'-'.$tgl_start;
- $gb_stop=$thn_stop.'-'.$bln_stop.'-'.$tgl_stop;
- echo"$gb_start s/d $gb_stop<br>";
- $dt_pagi=mysql_num_rows(mysql_query("SELECT * FROM $calon_pagi WHERE tgl_daftar BETWEEN '$gb_start' AND '$gb_stop'"));
- $dt_sore=mysql_num_rows(mysql_query("SELECT * FROM $calon_sore WHERE tgl_daftar BETWEEN '$gb_start' AND '$gb_stop'"));
- $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')");
- #echo"$union";
- $dt_total=mysql_num_rows(mysql_query($union));
- echo"Total Pendaftar Pagi : $dt_pagi<br>";
- echo"Total Pendaftar Sore dan Karyawan : $dt_sore<br>";
- echo"Total Pendaftar: $dt_total";
- ?>
- <table width="900" border="1">
- <tr>
- <th width="34" rowspan="2">No</th>
- <th width="93" rowspan="2">No pendaftar</th>
- <th width="291" rowspan="2">Nama Calon Pendaftar </th>
- <th colspan="2">Pilihan</th>
- <th width="89" rowspan="2">Status</th>
- <th width="94" rowspan="2">Biaya Pendaftaran</th>
- </tr>
- <tr>
- <th width="118">Pil 1 </th>
- <th width="135">Pil 2 </th>
- </tr>
- <?php
- $no=1;
- $dtcl=mysql_query($union);
- while($cl=mysql_fetch_array($dtcl))
- {
- if(($no % 2)==0){
- $bgcolor="#FFCC66";
- }else{
- $bgcolor="#FF9933";
- }
- ?>
- <tr bgcolor="<?=$bgcolor?>">
- <td><?=$no?></td>
- <td><?=$cl[no_pendaftaran]?></td>
- <td><?=$cl[nama_lengkap]?></td>
- <?php
- # KETERANGAN PROGDI
- $p1=mysql_fetch_array(mysql_query("SELECT nama_prodi FROM progdi WHERE kode_prodi='$cl[pilihan1]'"));
- $p2=mysql_fetch_array(mysql_query("SELECT nama_prodi FROM progdi WHERE kode_prodi='$cl[pilihan2]'"));
- ?>
- <td><?=$p1[nama_prodi]?></td>
- <td><?=$p2[nama_prodi]?></td>
- <td align="right"><?=$cl[kelas]?></td>
- <td align="right"><? echo rp($cl[bayar]); ?></td>
- </tr>
- <?php
- $no++;
- $jmlh1+=$cl[bayar];
- }
- ?>
- <tr>
- <td colspan="5">Total Biaya </td>
- <td align="right"> </td>
- <td align="right"><? echo rp($jmlh1);?></td>
- </tr>
- <tr>
- <td colspan="7" align="center"><form name="form1" method="post" action="print/rekap_pendaftaran_pertanggal.php" target="_blank">
- <input type='text' value='<?=$gb_start?>' name='pertanggal'>
- <input type='text' value='<?=$gb_stop?>' name='pertgl'>
- <input type="submit" name="Submit" value="Cetak"/>
- </form></td>
- </tr>
- </table>
- <?php
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment