ex-native-php/cetak.php at master · triantofajar/ex-native-php · GitHub

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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
<!DOCTYPE html>
<html lang="en">
<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Cetak Invoice</title>

    <!-- Bootstrap Core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom CSS -->
    <link href="css/business-casual.css" rel="stylesheet">

    <!-- Fonts -->
    <link href="http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800" rel="stylesheet" type="text/css">
    <link href="http://fonts.googleapis.com/css?family=Josefin+Slab:100,300,400,600,700,100italic,300italic,400italic,600italic,700italic" rel="stylesheet" type="text/css">

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
     <!--Start JS Datepicker-->
  <script src="js/jquery.js"></script>

</head>


<body onload="window.print()">
<br><br><br>
<div class="col-md-10" style="margin-left: 2%;" >

<h2 align="center">GTR TOUR AND TRAVEL</h2>
<hr>

<br>

<?php
	include "koneksi.php";


//getnik reserved
$getnik = $_GET['nik'];
$invoice = $_GET['invoice'];

	$query = "SELECT * FROM pesan WHERE nik='$getnik' AND invoice = $invoice";
	$sql = mysqli_query($connect,$query);


?>
<div class="box">
	<h2 align="center">INVOICE</h2>
	<h4 align="center">NO INVOICE = <?php echo $invoice; ?></h4>

</div>

	<?php


	$sqlNama = "SELECT * FROM pesan WHERE nik = '$getnik'";
	$query = mysqli_query($connect,$sqlNama);
	$tmp = mysqli_fetch_array($query);

	?>
<br>
	<table>

		<tr>
		<td align="left">NIK : <?php echo $tmp['nik']; ?></td>
		</tr>
		<tr>
		<td align="left">Nama Pemesan : <?php echo $tmp['nama_klien']; ?></td>
		</tr>

	</table>
<br>
	<table class='table table-bordered'>
	<thead>
	<tr>
		<th>No</th>
		<th>Tanggal</th>
		<th>Kategori</th>
		<th>Tarif</th>


	</tr>
	</thead>
	<?php

$no = 1;

$count = mysqli_num_rows($sql);

if($count<1){
	echo "<tr><td colspan='9'><center>Data Tidak Ditemukan!</center></td></tr>";
}else{

	while($data=mysqli_fetch_array($sql,MYSQLI_BOTH)){


?>

	<tr>
			<td><?php echo $no++; ?></td>
			<td><?php echo $data['tgl']; ?></td>
			<td><?php echo $data['kategori']; ?></td>
			<td>Rp. <?php echo number_format($data['harga']); ?></td>
		</tr>


<?php
	}
}
?>

<?php

//sum harga

$sqlSum = "SELECT * FROM pembayaran
		   WHERE nik = '$getnik'";
$query = mysqli_query($connect,$sqlSum);
$total = mysqli_fetch_array($query);

?>

<tr>
<td>Total Pembayaran (Rp. )</td><td>:</td><td colspan="3">Rp.<?php echo number_format($total['total']); ?></td>
</tr>


</table>


	</div>
</div>

	</div>

	<!-- jQuery -->
	<script src="js/jquery.js"></script>

	<!-- Bootstrap Core JavaScript -->
	<script src="js/bootstrap.min.js"></script>
</body>
</html>