-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathkonfirmasi_filter.php
105 lines (93 loc) · 3.52 KB
/
konfirmasi_filter.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?php
session_start();
if(!isset($_SESSION['username'])) {
header('location:index.php'); }
else { $username = $_SESSION['username'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="EN" lang="EN" dir="ltr">
<head profile="http://gmpg.org/xfn/11">
<title>Elja Ticket</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="imagetoolbar" content="no" />
<link rel="stylesheet" href="styles/layout_admin.css" type="text/css" />
<link rel="stylesheet" href="styles/contoh-gambar-zoom.css">
<script type="text/javascript" src="scripts/jquery-1.4.1.min.js"></script>
<script type="text/javascript" src="scripts/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="scripts/jquery.timers.1.2.js"></script>
<script type="text/javascript" src="scripts/jquery.galleryview.2.1.1.min.js"></script>
<script type="text/javascript" src="scripts/jquery.galleryview.setup.js"></script>
</head>
<script>
function warning() {
return confirm("Apakah Anda Yakin?");
}
</script>
<body id="top">
<?php
include "header.php";
?>
<?php
include "menu.php";
?>
<!-- ####################################################################################################### -->
<div class="container">
<?php
$tanggal1=$_POST['tanggal1'];
$tanggal2=$_POST['tanggal2'];
include "koneksi.php" ;
$sql = "select * from konfirmasi
inner join bayar on konfirmasi.kode_bayar = bayar.kode_bayar
inner join pesan on pesan.kode_pesan = bayar.kode_pesan
where tgl_konfirmasi BETWEEN '$tanggal1' AND '$tanggal2'
order by kode_konfirmasi desc";
$hasil = mysql_query($sql);
$num=mysql_num_rows($hasil);
if (!$hasil)
die("Gagal query..".mysql_error());
?>
<table align="center" border="1">
<tr><td colspan="9" align="center"><h2><b>DATA KONFIRMASI<br>Tanggal <?php echo"$tanggal1 s/d $tanggal2"?></b></h2><?php echo"Jumlah : $num "?></td></tr>
<tr bgcolor="yellow" width=100% height=50>
<th>No</th>
<th>Kode Pesan</th>
<th>Jumlah Transfer</th>
<th>Tanggal Konfirmasi</th>
<th>Bukti Transfer</th>
<th>Jadwal</th>
<th>Status</th>
<!--<th colspan="2">Proses</th>-->
</tr>
<?php
$nomor=1;
echo "<br>".$format_indonesia; //1.234,56
while ($row = mysql_fetch_array($hasil)) {
if ($nomor % 2 == 0){
echo "<tr style='background-color:#9AAEDB'>";
}else {
echo "<tr style='background-color:#000000'>";
}
$jml_transfer=number_format($row['jml_transfer'],0,",",".");
$stat = $row['status'];
echo " <tr>";
echo " <td><center>" .$nomor."</center></td>" ;
echo " <td><center> ".$row['pemesanan']." </td> " ;
echo " <td><center> Rp. $jml_transfer </td> " ;
echo " <td><center> ".$row['tgl_konfirmasi']." </td> " ;
echo " <td><center><div class=”img-zoom”><img class='contoh-gambar-zoom' src='gambar/bukti/$row[gambar]'>"." </td></div> " ;
echo " <td><center> ".$row['jadwal']." </td> " ;
echo " <td ".($stat=='Bayar'?'bgcolor=white':'bgcolor=red')."><center> ".$row['status']." </td> " ;
//echo " <td><center>"."<a href = konfirmasi_verifikasi.php?kode_pesan={$row['kode_pesan']}><img src='button/verifikasi.jpg'></a>"." </td>";
//echo " <td><center>"."<a href = konfirmasi_hapus.php?kode_konfirmasi={$row['kode_konfirmasi']}><img src='button/delete.png'></a>"." </td> " ;
echo " </tr> ";
$nomor++;
}
?>
</table>
</div>
<?php
include "footer.php";
?>
</body>
</html>