@@ -82,7 +82,7 @@ |
||
82 | 82 | <?php |
83 | 83 | } elseif ($module == 'modul' and $act == 'hapusmod') { |
84 | 84 | // membaca ID dari data yang akan dihapus |
85 | - $id = $_GET['id']; |
|
85 | + $id = $_GET['id']; |
|
86 | 86 | $id_module = $_GET['id_module']; |
87 | 87 | |
88 | 88 | mysql_query("DELETE a |
@@ -162,7 +162,7 @@ discard block |
||
162 | 162 | |
163 | 163 | <?php |
164 | 164 | $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
165 | - $g = mysql_fetch_array($gtampil); |
|
165 | + $g = mysql_fetch_array($gtampil); |
|
166 | 166 | |
167 | 167 | if ($g['pict']) { |
168 | 168 | $pict = $g['pict']; |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | |
173 | 173 | $company = ucwords($g['company']); |
174 | 174 | |
175 | - ?> |
|
175 | + ?> |
|
176 | 176 | |
177 | 177 | <table width='100%' style="padding-top:10px;"> |
178 | 178 | <tr> |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | <select required name="pasien" class="form-control" disabled> |
101 | 101 | <option>--Pilih Pasien--</option> |
102 | 102 | <?php |
103 | - $query = mysql_query('SELECT * FROM pasien ORDER BY nama'); |
|
103 | + $query = mysql_query('SELECT * FROM pasien ORDER BY nama'); |
|
104 | 104 | if ($query && mysql_num_rows($query) > 0) { |
105 | 105 | while ($row = mysql_fetch_object($query)) { |
106 | 106 | $pasien = $row->ktp.'-'.$row->nama; |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | <select name="poli" class="form-control" disabled> |
128 | 128 | <option>--Pilih Poliklinik --</option> |
129 | 129 | <?php |
130 | - $query = mysql_query('SELECT * FROM poli ORDER BY poli'); |
|
130 | + $query = mysql_query('SELECT * FROM poli ORDER BY poli'); |
|
131 | 131 | if ($query && mysql_num_rows($query) > 0) { |
132 | 132 | while ($row = mysql_fetch_object($query)) { |
133 | 133 | echo '<option value="'.$row->id_poli.'"'; |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | <select name="obat" id="obat" class="form-control" required> |
191 | 191 | <option value='0'></option> |
192 | 192 | <?php |
193 | - $query = mysql_query('SELECT * FROM obat ORDER BY obat'); |
|
193 | + $query = mysql_query('SELECT * FROM obat ORDER BY obat'); |
|
194 | 194 | if ($query && mysql_num_rows($query) > 0) { |
195 | 195 | while ($row = mysql_fetch_object($query)) { |
196 | 196 | echo '<option value="'.$row->id_obat.'"'; |
@@ -231,11 +231,11 @@ discard block |
||
231 | 231 | <input type="hidden" name="imodule" value="<?php echo $imodule?>" /> |
232 | 232 | |
233 | 233 | <?php |
234 | - echo'</form>'; ?> |
|
234 | + echo'</form>'; ?> |
|
235 | 235 | |
236 | 236 | <?php |
237 | 237 | |
238 | - $SQL = "SELECT a.*,b.obat |
|
238 | + $SQL = "SELECT a.*,b.obat |
|
239 | 239 | FROM kunjungan_berobat_detail a LEFT JOIN obat b |
240 | 240 | ON a.id_obat = b.id_obat |
241 | 241 | WHERE a.id_kunjungan_berobat = '$id' |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | <select name="obat" id="obat<?php echo $no; ?>" class="form-control" required> |
263 | 263 | <option value='0'></option> |
264 | 264 | <?php |
265 | - $query = mysql_query('SELECT * FROM obat ORDER BY obat'); |
|
265 | + $query = mysql_query('SELECT * FROM obat ORDER BY obat'); |
|
266 | 266 | if ($query && mysql_num_rows($query) > 0) { |
267 | 267 | while ($row = mysql_fetch_object($query)) { |
268 | 268 | echo '<option value="'.$row->id_obat.'"'; |
@@ -315,7 +315,7 @@ discard block |
||
315 | 315 | <input type="hidden" name="imodule" value="<?php echo $imodule?>" /> |
316 | 316 | |
317 | 317 | <?php |
318 | - echo'</form>'; |
|
318 | + echo'</form>'; |
|
319 | 319 | } ?> |
320 | 320 | |
321 | 321 |
@@ -91,7 +91,7 @@ discard block |
||
91 | 91 | <select required name="pasien" class="form-control" disabled> |
92 | 92 | <option>--Pilih Pasien--</option> |
93 | 93 | <?php |
94 | - $query = mysql_query('SELECT * FROM pasien ORDER BY nama'); |
|
94 | + $query = mysql_query('SELECT * FROM pasien ORDER BY nama'); |
|
95 | 95 | if ($query && mysql_num_rows($query) > 0) { |
96 | 96 | while ($row = mysql_fetch_object($query)) { |
97 | 97 | $pasien = $row->ktp.'-'.$row->nama; |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | <select name="poli" class="form-control" disabled> |
113 | 113 | <option>--Pilih Poliklinik --</option> |
114 | 114 | <?php |
115 | - $query = mysql_query('SELECT * FROM poli ORDER BY poli'); |
|
115 | + $query = mysql_query('SELECT * FROM poli ORDER BY poli'); |
|
116 | 116 | if ($query && mysql_num_rows($query) > 0) { |
117 | 117 | while ($row = mysql_fetch_object($query)) { |
118 | 118 | echo '<option value="'.$row->id_poli.'"'; |
@@ -166,7 +166,7 @@ discard block |
||
166 | 166 | |
167 | 167 | <?php |
168 | 168 | $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
169 | - $g = mysql_fetch_array($gtampil); |
|
169 | + $g = mysql_fetch_array($gtampil); |
|
170 | 170 | |
171 | 171 | if ($g['pict']) { |
172 | 172 | $pict = $g['pict']; |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | |
213 | 213 | <?php |
214 | 214 | |
215 | - $tampil = mysql_query("SELECT a.obat,b.satuan,a.jumlah,ifnull(sum(d.qty),0) as keluar |
|
215 | + $tampil = mysql_query("SELECT a.obat,b.satuan,a.jumlah,ifnull(sum(d.qty),0) as keluar |
|
216 | 216 | FROM obat a left join satuan b |
217 | 217 | ON a.id_satuan = b.id_satuan |
218 | 218 | left join kunjungan_berobat c |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | |
168 | 168 | <?php |
169 | 169 | $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
170 | - $g = mysql_fetch_array($gtampil); |
|
170 | + $g = mysql_fetch_array($gtampil); |
|
171 | 171 | |
172 | 172 | if ($g['pict']) { |
173 | 173 | $pict = $g['pict']; |
@@ -196,7 +196,7 @@ discard block |
||
196 | 196 | <hr> |
197 | 197 | |
198 | 198 | <?php |
199 | - $tampil = mysql_query("SELECT a.*,b.agama,c.kategori |
|
199 | + $tampil = mysql_query("SELECT a.*,b.agama,c.kategori |
|
200 | 200 | FROM pasien a left join agama b |
201 | 201 | ON a.id_agama = b.id_agama |
202 | 202 | left join kategori c |
@@ -84,7 +84,7 @@ |
||
84 | 84 | <div class="col-md-6 col-sm-6 col-xs-12" > |
85 | 85 | <select name="satuan" class="form-control"> |
86 | 86 | <?php |
87 | - $query = mysql_query('SELECT * FROM satuan ORDER BY satuan'); |
|
87 | + $query = mysql_query('SELECT * FROM satuan ORDER BY satuan'); |
|
88 | 88 | if ($query && mysql_num_rows($query) > 0) { |
89 | 89 | while ($row = mysql_fetch_object($query)) { |
90 | 90 | echo '<option value="'.$row->id_satuan.'"'; |
@@ -139,46 +139,46 @@ discard block |
||
139 | 139 | |
140 | 140 | <?php |
141 | 141 | |
142 | - $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
142 | + $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
143 | 143 | |
144 | - $g = mysql_fetch_array($gtampil); |
|
144 | + $g = mysql_fetch_array($gtampil); |
|
145 | 145 | |
146 | - if ($g['pict']) { |
|
147 | - $pict = $g['pict']; |
|
148 | - } else { |
|
149 | - $pict = ''; |
|
150 | - } |
|
146 | + if ($g['pict']) { |
|
147 | + $pict = $g['pict']; |
|
148 | + } else { |
|
149 | + $pict = ''; |
|
150 | + } |
|
151 | 151 | |
152 | - $company = ucwords($g['company']); |
|
152 | + $company = ucwords($g['company']); |
|
153 | 153 | |
154 | - $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
154 | + $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
155 | 155 | WHERE id_jenis_transaksi = '$jenis_transaksi' |
156 | 156 | |
157 | 157 | "); |
158 | 158 | |
159 | - $j = mysql_fetch_array($jsql); |
|
159 | + $j = mysql_fetch_array($jsql); |
|
160 | 160 | |
161 | - $jenis_transaksi = $j['jenis_transaksi']; |
|
161 | + $jenis_transaksi = $j['jenis_transaksi']; |
|
162 | 162 | |
163 | - $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
163 | + $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
164 | 164 | ON a.id_shift = b.id_shift |
165 | 165 | WHERE a.id_kasir = '$k_ID' |
166 | 166 | |
167 | 167 | "); |
168 | 168 | |
169 | - $r = mysql_fetch_array($sql); |
|
169 | + $r = mysql_fetch_array($sql); |
|
170 | 170 | |
171 | - $penjualan_barang = $r['id_kasir']; |
|
171 | + $penjualan_barang = $r['id_kasir']; |
|
172 | 172 | |
173 | - $shift = $r['shift']; |
|
173 | + $shift = $r['shift']; |
|
174 | 174 | |
175 | - $petugas = $r['petugas']; |
|
175 | + $petugas = $r['petugas']; |
|
176 | 176 | |
177 | - $status = $r['status']; |
|
177 | + $status = $r['status']; |
|
178 | 178 | |
179 | - $tanggal = date('d/m/Y', strtotime($r['tanggal'])); |
|
179 | + $tanggal = date('d/m/Y', strtotime($r['tanggal'])); |
|
180 | 180 | |
181 | - ?> |
|
181 | + ?> |
|
182 | 182 | |
183 | 183 | <table width="100%"> |
184 | 184 | <tr> |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | echo "<th colspan='2'>".$h['penjamin'].'</th>'; |
213 | 213 | } |
214 | 214 | |
215 | - ?> |
|
215 | + ?> |
|
216 | 216 | |
217 | 217 | <th colspan ="4" >UMUM</th> |
218 | 218 | <th rowspan="2" >PIC</th> |
@@ -227,11 +227,11 @@ discard block |
||
227 | 227 | <tr> |
228 | 228 | |
229 | 229 | <?php |
230 | - for ($j = 1; $j <= $hjml; $j++) { |
|
231 | - echo '<th>JML</th>'; |
|
232 | - echo '<th>RUPIAH</th>'; |
|
233 | - } |
|
234 | - ?> |
|
230 | + for ($j = 1; $j <= $hjml; $j++) { |
|
231 | + echo '<th>JML</th>'; |
|
232 | + echo '<th>RUPIAH</th>'; |
|
233 | + } |
|
234 | + ?> |
|
235 | 235 | |
236 | 236 | |
237 | 237 | <th>JML</th> |
@@ -253,18 +253,18 @@ discard block |
||
253 | 253 | <tbody> |
254 | 254 | |
255 | 255 | <?php for ($i = 1; $i <= 31; $i++) { |
256 | - echo'<tr>'; |
|
256 | + echo'<tr>'; |
|
257 | 257 | |
258 | - echo"<td style='text-align:center;'>$i</td>"; |
|
258 | + echo"<td style='text-align:center;'>$i</td>"; |
|
259 | 259 | |
260 | - if (strlen($i) == '1') { |
|
261 | - $tgl = $prd.'-0'.$i; |
|
262 | - } else { |
|
263 | - $tgl = $prd.'-'.$i; |
|
264 | - } |
|
260 | + if (strlen($i) == '1') { |
|
261 | + $tgl = $prd.'-0'.$i; |
|
262 | + } else { |
|
263 | + $tgl = $prd.'-'.$i; |
|
264 | + } |
|
265 | 265 | |
266 | - //transaksi asuransi |
|
267 | - $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
266 | + //transaksi asuransi |
|
267 | + $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
268 | 268 | , COUNT(c.jumlah) as jml |
269 | 269 | , IFNULL(SUM(c.jumlah),0) as rp |
270 | 270 | FROM penjamin a LEFT JOIN kasir b |
@@ -280,13 +280,13 @@ discard block |
||
280 | 280 | GROUP BY a.id_penjamin |
281 | 281 | ORDER BY a.id_penjamin"); |
282 | 282 | |
283 | - while ($d1 = mysql_fetch_array($dtampil1)) { |
|
284 | - echo '<th>'.$d1['jml'].'</th>'; |
|
285 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
286 | - } |
|
283 | + while ($d1 = mysql_fetch_array($dtampil1)) { |
|
284 | + echo '<th>'.$d1['jml'].'</th>'; |
|
285 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
286 | + } |
|
287 | 287 | |
288 | - //transaksi umum tunai |
|
289 | - $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
288 | + //transaksi umum tunai |
|
289 | + $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
290 | 290 | , IFNULL(SUM(c.jumlah),0) as rp |
291 | 291 | FROM kasir b LEFT JOIN kasir_detail c |
292 | 292 | ON b.id_kasir = c.id_kasir |
@@ -296,13 +296,13 @@ discard block |
||
296 | 296 | WHERE b.tanggal = '$tgl' |
297 | 297 | AND b.status != '4'"); |
298 | 298 | |
299 | - $d2 = mysql_fetch_array($dtampil2); |
|
299 | + $d2 = mysql_fetch_array($dtampil2); |
|
300 | 300 | |
301 | - echo '<th>'.$d2['jml'].'</th>'; |
|
302 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
301 | + echo '<th>'.$d2['jml'].'</th>'; |
|
302 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
303 | 303 | |
304 | - //transaksi umum tunai |
|
305 | - $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
304 | + //transaksi umum tunai |
|
305 | + $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
306 | 306 | , IFNULL(SUM(c.jumlah),0) as rp |
307 | 307 | FROM kasir b LEFT JOIN kasir_detail c |
308 | 308 | ON b.id_kasir = c.id_kasir |
@@ -312,21 +312,21 @@ discard block |
||
312 | 312 | WHERE b.tanggal = '$tgl' |
313 | 313 | AND b.status != '4'"); |
314 | 314 | |
315 | - $d3 = mysql_fetch_array($dtampil3); |
|
315 | + $d3 = mysql_fetch_array($dtampil3); |
|
316 | 316 | |
317 | - echo '<th>'.$d3['jml'].'</th>'; |
|
318 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
317 | + echo '<th>'.$d3['jml'].'</th>'; |
|
318 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
319 | 319 | |
320 | - echo '<th></th>'; |
|
321 | - echo '<th></th>'; |
|
322 | - echo '<th></th>'; |
|
320 | + echo '<th></th>'; |
|
321 | + echo '<th></th>'; |
|
322 | + echo '<th></th>'; |
|
323 | 323 | |
324 | - echo '<th></th>'; |
|
325 | - echo '<th></th>'; |
|
326 | - echo '<th></th>'; |
|
324 | + echo '<th></th>'; |
|
325 | + echo '<th></th>'; |
|
326 | + echo '<th></th>'; |
|
327 | 327 | |
328 | - //total jml |
|
329 | - $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
328 | + //total jml |
|
329 | + $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
330 | 330 | FROM kasir b LEFT JOIN kasir_detail c |
331 | 331 | ON b.id_kasir = c.id_kasir |
332 | 332 | AND c.status != '4' |
@@ -334,12 +334,12 @@ discard block |
||
334 | 334 | WHERE b.tanggal = '$tgl' |
335 | 335 | AND b.status != '4'"); |
336 | 336 | |
337 | - $d4 = mysql_fetch_array($dtampil4); |
|
337 | + $d4 = mysql_fetch_array($dtampil4); |
|
338 | 338 | |
339 | - echo '<th>'.$d4['jml'].'</th>'; |
|
339 | + echo '<th>'.$d4['jml'].'</th>'; |
|
340 | 340 | |
341 | - //total pembayaran |
|
342 | - $dtampil5 = mysql_query("SELECT a.groups |
|
341 | + //total pembayaran |
|
342 | + $dtampil5 = mysql_query("SELECT a.groups |
|
343 | 343 | , IFNULL(SUM(c.jumlah),0) as rp |
344 | 344 | FROM jenis_pembayaran a LEFT JOIN kasir b |
345 | 345 | ON b.tanggal = '$tgl' |
@@ -352,23 +352,23 @@ discard block |
||
352 | 352 | GROUP BY a.groups |
353 | 353 | ORDER BY a.groups"); |
354 | 354 | |
355 | - while ($d5 = mysql_fetch_array($dtampil5)) { |
|
356 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
357 | - } |
|
355 | + while ($d5 = mysql_fetch_array($dtampil5)) { |
|
356 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
357 | + } |
|
358 | 358 | |
359 | - echo'</tr>'; |
|
360 | - } ?> |
|
359 | + echo'</tr>'; |
|
360 | + } ?> |
|
361 | 361 | |
362 | 362 | </tbody> |
363 | 363 | |
364 | 364 | <?php |
365 | 365 | |
366 | - echo'<tr>'; |
|
366 | + echo'<tr>'; |
|
367 | 367 | |
368 | - echo"<th style='text-align:center;'>TOTAL</th>"; |
|
368 | + echo"<th style='text-align:center;'>TOTAL</th>"; |
|
369 | 369 | |
370 | - //transaksi asuransi |
|
371 | - $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
370 | + //transaksi asuransi |
|
371 | + $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
372 | 372 | , COUNT(c.jumlah) as jml |
373 | 373 | , IFNULL(SUM(c.jumlah),0) as rp |
374 | 374 | FROM penjamin a LEFT JOIN kasir b |
@@ -384,13 +384,13 @@ discard block |
||
384 | 384 | GROUP BY a.id_penjamin |
385 | 385 | ORDER BY a.id_penjamin"); |
386 | 386 | |
387 | - while ($d1 = mysql_fetch_array($dtampil1)) { |
|
388 | - echo '<th>'.$d1['jml'].'</th>'; |
|
389 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
390 | - } |
|
387 | + while ($d1 = mysql_fetch_array($dtampil1)) { |
|
388 | + echo '<th>'.$d1['jml'].'</th>'; |
|
389 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
390 | + } |
|
391 | 391 | |
392 | - //transaksi umum tunai |
|
393 | - $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
392 | + //transaksi umum tunai |
|
393 | + $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
394 | 394 | , IFNULL(SUM(c.jumlah),0) as rp |
395 | 395 | FROM kasir b LEFT JOIN kasir_detail c |
396 | 396 | ON b.id_kasir = c.id_kasir |
@@ -400,13 +400,13 @@ discard block |
||
400 | 400 | AND b.tanggal LIKE '$prd%' |
401 | 401 | AND b.status != '4'"); |
402 | 402 | |
403 | - $d2 = mysql_fetch_array($dtampil2); |
|
403 | + $d2 = mysql_fetch_array($dtampil2); |
|
404 | 404 | |
405 | - echo '<th>'.$d2['jml'].'</th>'; |
|
406 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
405 | + echo '<th>'.$d2['jml'].'</th>'; |
|
406 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
407 | 407 | |
408 | - //transaksi umum tunai |
|
409 | - $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
408 | + //transaksi umum tunai |
|
409 | + $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
410 | 410 | , IFNULL(SUM(c.jumlah),0) as rp |
411 | 411 | FROM kasir b LEFT JOIN kasir_detail c |
412 | 412 | ON b.id_kasir = c.id_kasir |
@@ -416,33 +416,33 @@ discard block |
||
416 | 416 | WHERE b.tanggal LIKE '$prd%' |
417 | 417 | AND b.status != '4'"); |
418 | 418 | |
419 | - $d3 = mysql_fetch_array($dtampil3); |
|
419 | + $d3 = mysql_fetch_array($dtampil3); |
|
420 | 420 | |
421 | - echo '<th>'.$d3['jml'].'</th>'; |
|
422 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
421 | + echo '<th>'.$d3['jml'].'</th>'; |
|
422 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
423 | 423 | |
424 | - echo '<th></th>'; |
|
425 | - echo '<th></th>'; |
|
426 | - echo '<th></th>'; |
|
424 | + echo '<th></th>'; |
|
425 | + echo '<th></th>'; |
|
426 | + echo '<th></th>'; |
|
427 | 427 | |
428 | - echo '<th></th>'; |
|
429 | - echo '<th></th>'; |
|
430 | - echo '<th></th>'; |
|
428 | + echo '<th></th>'; |
|
429 | + echo '<th></th>'; |
|
430 | + echo '<th></th>'; |
|
431 | 431 | |
432 | - //total jml |
|
433 | - $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
432 | + //total jml |
|
433 | + $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
434 | 434 | FROM kasir b LEFT JOIN kasir_detail c |
435 | 435 | ON b.id_kasir = c.id_kasir |
436 | 436 | AND c.status != '4' |
437 | 437 | WHERE b.tanggal LIKE '$prd%' |
438 | 438 | AND b.status != '4'"); |
439 | 439 | |
440 | - $d4 = mysql_fetch_array($dtampil4); |
|
440 | + $d4 = mysql_fetch_array($dtampil4); |
|
441 | 441 | |
442 | - echo '<th>'.$d4['jml'].'</th>'; |
|
442 | + echo '<th>'.$d4['jml'].'</th>'; |
|
443 | 443 | |
444 | - //total pembayaran |
|
445 | - $dtampil5 = mysql_query("SELECT a.groups |
|
444 | + //total pembayaran |
|
445 | + $dtampil5 = mysql_query("SELECT a.groups |
|
446 | 446 | , IFNULL(SUM(c.jumlah),0) as rp |
447 | 447 | FROM jenis_pembayaran a LEFT JOIN kasir b |
448 | 448 | ON b.tanggal LIKE '$prd%' |
@@ -455,18 +455,18 @@ discard block |
||
455 | 455 | GROUP BY a.groups |
456 | 456 | ORDER BY a.groups"); |
457 | 457 | |
458 | - while ($d5 = mysql_fetch_array($dtampil5)) { |
|
459 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
460 | - } |
|
458 | + while ($d5 = mysql_fetch_array($dtampil5)) { |
|
459 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
460 | + } |
|
461 | 461 | |
462 | - echo'</tr>'; |
|
462 | + echo'</tr>'; |
|
463 | 463 | |
464 | - echo'<tr>'; |
|
464 | + echo'<tr>'; |
|
465 | 465 | |
466 | - echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
466 | + echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
467 | 467 | |
468 | - //total jml |
|
469 | - $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
468 | + //total jml |
|
469 | + $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
470 | 470 | FROM kasir b LEFT JOIN kasir_detail c |
471 | 471 | ON b.id_kasir = c.id_kasir |
472 | 472 | AND c.status != '4' |
@@ -474,12 +474,12 @@ discard block |
||
474 | 474 | WHERE b.tanggal LIKE '$prd%' |
475 | 475 | AND b.status != '4'"); |
476 | 476 | |
477 | - $d4 = mysql_fetch_array($dtampil4); |
|
477 | + $d4 = mysql_fetch_array($dtampil4); |
|
478 | 478 | |
479 | - echo '<th>'.$d4['jml'].'</th>'; |
|
479 | + echo '<th>'.$d4['jml'].'</th>'; |
|
480 | 480 | |
481 | - //total pembayaran |
|
482 | - $dtampil5 = mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
481 | + //total pembayaran |
|
482 | + $dtampil5 = mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
483 | 483 | FROM kasir b LEFT JOIN kasir_detail c |
484 | 484 | ON b.id_kasir = c.id_kasir |
485 | 485 | AND c.status != '4' |
@@ -487,9 +487,9 @@ discard block |
||
487 | 487 | WHERE b.tanggal LIKE '$prd%' |
488 | 488 | AND b.status != '4'"); |
489 | 489 | |
490 | - $d5 = mysql_fetch_array($dtampil5); |
|
490 | + $d5 = mysql_fetch_array($dtampil5); |
|
491 | 491 | |
492 | - echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
492 | + echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
493 | 493 | |
494 | 494 | ?> |
495 | 495 |
@@ -238,46 +238,46 @@ discard block |
||
238 | 238 | |
239 | 239 | <?php |
240 | 240 | |
241 | - $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
241 | + $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
242 | 242 | |
243 | - $g = mysql_fetch_array($gtampil); |
|
243 | + $g = mysql_fetch_array($gtampil); |
|
244 | 244 | |
245 | - if ($g['pict']) { |
|
246 | - $pict = $g['pict']; |
|
247 | - } else { |
|
248 | - $pict = ''; |
|
249 | - } |
|
245 | + if ($g['pict']) { |
|
246 | + $pict = $g['pict']; |
|
247 | + } else { |
|
248 | + $pict = ''; |
|
249 | + } |
|
250 | 250 | |
251 | - $company = ucwords($g['company']); |
|
251 | + $company = ucwords($g['company']); |
|
252 | 252 | |
253 | - $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
253 | + $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
254 | 254 | WHERE id_jenis_transaksi = '$jenis_transaksi' |
255 | 255 | |
256 | 256 | "); |
257 | 257 | |
258 | - $j = mysql_fetch_array($jsql); |
|
258 | + $j = mysql_fetch_array($jsql); |
|
259 | 259 | |
260 | - $jenis_transaksi = $j['jenis_transaksi']; |
|
260 | + $jenis_transaksi = $j['jenis_transaksi']; |
|
261 | 261 | |
262 | - $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
262 | + $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
263 | 263 | ON a.id_shift = b.id_shift |
264 | 264 | WHERE a.id_kasir = '$k_ID' |
265 | 265 | |
266 | 266 | "); |
267 | 267 | |
268 | - $r = mysql_fetch_array($sql); |
|
268 | + $r = mysql_fetch_array($sql); |
|
269 | 269 | |
270 | - $penjualan_barang = $r['id_kasir']; |
|
270 | + $penjualan_barang = $r['id_kasir']; |
|
271 | 271 | |
272 | - $shift = $r['shift']; |
|
272 | + $shift = $r['shift']; |
|
273 | 273 | |
274 | - $petugas = $r['petugas']; |
|
274 | + $petugas = $r['petugas']; |
|
275 | 275 | |
276 | - $status = $r['status']; |
|
276 | + $status = $r['status']; |
|
277 | 277 | |
278 | - $tanggal = date('d/m/Y', strtotime($r['tanggal'])); |
|
278 | + $tanggal = date('d/m/Y', strtotime($r['tanggal'])); |
|
279 | 279 | |
280 | - ?> |
|
280 | + ?> |
|
281 | 281 | |
282 | 282 | <table width="100%"> |
283 | 283 | <tr> |
@@ -308,7 +308,7 @@ discard block |
||
308 | 308 | echo "<th colspan='2'>".$h['penjamin'].'</th>'; |
309 | 309 | } |
310 | 310 | |
311 | - ?> |
|
311 | + ?> |
|
312 | 312 | |
313 | 313 | <th colspan ="4" >UMUM</th> |
314 | 314 | <th rowspan="2" >PIC</th> |
@@ -323,11 +323,11 @@ discard block |
||
323 | 323 | <tr> |
324 | 324 | |
325 | 325 | <?php |
326 | - for ($j = 1; $j <= $hjml; $j++) { |
|
327 | - echo '<th>JML</th>'; |
|
328 | - echo '<th>RUPIAH</th>'; |
|
329 | - } |
|
330 | - ?> |
|
326 | + for ($j = 1; $j <= $hjml; $j++) { |
|
327 | + echo '<th>JML</th>'; |
|
328 | + echo '<th>RUPIAH</th>'; |
|
329 | + } |
|
330 | + ?> |
|
331 | 331 | |
332 | 332 | |
333 | 333 | <th>JML</th> |
@@ -349,18 +349,18 @@ discard block |
||
349 | 349 | <tbody> |
350 | 350 | |
351 | 351 | <?php for ($i = 1; $i <= 31; $i++) { |
352 | - echo'<tr>'; |
|
352 | + echo'<tr>'; |
|
353 | 353 | |
354 | - echo"<td style='text-align:center;'>$i</td>"; |
|
354 | + echo"<td style='text-align:center;'>$i</td>"; |
|
355 | 355 | |
356 | - if (strlen($i) == '1') { |
|
357 | - $tgl = $prd.'-0'.$i; |
|
358 | - } else { |
|
359 | - $tgl = $prd.'-'.$i; |
|
360 | - } |
|
356 | + if (strlen($i) == '1') { |
|
357 | + $tgl = $prd.'-0'.$i; |
|
358 | + } else { |
|
359 | + $tgl = $prd.'-'.$i; |
|
360 | + } |
|
361 | 361 | |
362 | - //transaksi asuransi |
|
363 | - $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
362 | + //transaksi asuransi |
|
363 | + $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
364 | 364 | , COUNT(c.jumlah) as jml |
365 | 365 | , IFNULL(SUM(c.jumlah),0) as rp |
366 | 366 | FROM penjamin a LEFT JOIN kasir b |
@@ -376,13 +376,13 @@ discard block |
||
376 | 376 | GROUP BY a.id_penjamin |
377 | 377 | ORDER BY a.id_penjamin"); |
378 | 378 | |
379 | - while ($d1 = mysql_fetch_array($dtampil1)) { |
|
380 | - echo '<th>'.$d1['jml'].'</th>'; |
|
381 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
382 | - } |
|
379 | + while ($d1 = mysql_fetch_array($dtampil1)) { |
|
380 | + echo '<th>'.$d1['jml'].'</th>'; |
|
381 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
382 | + } |
|
383 | 383 | |
384 | - //transaksi umum tunai |
|
385 | - $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
384 | + //transaksi umum tunai |
|
385 | + $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
386 | 386 | , IFNULL(SUM(c.jumlah),0) as rp |
387 | 387 | FROM kasir b LEFT JOIN kasir_detail c |
388 | 388 | ON b.id_kasir = c.id_kasir |
@@ -392,13 +392,13 @@ discard block |
||
392 | 392 | WHERE b.tanggal = '$tgl' |
393 | 393 | AND b.status != '4'"); |
394 | 394 | |
395 | - $d2 = mysql_fetch_array($dtampil2); |
|
395 | + $d2 = mysql_fetch_array($dtampil2); |
|
396 | 396 | |
397 | - echo '<th>'.$d2['jml'].'</th>'; |
|
398 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
397 | + echo '<th>'.$d2['jml'].'</th>'; |
|
398 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
399 | 399 | |
400 | - //transaksi umum tunai |
|
401 | - $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
400 | + //transaksi umum tunai |
|
401 | + $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
402 | 402 | , IFNULL(SUM(c.jumlah),0) as rp |
403 | 403 | FROM kasir b LEFT JOIN kasir_detail c |
404 | 404 | ON b.id_kasir = c.id_kasir |
@@ -408,21 +408,21 @@ discard block |
||
408 | 408 | WHERE b.tanggal = '$tgl' |
409 | 409 | AND b.status != '4'"); |
410 | 410 | |
411 | - $d3 = mysql_fetch_array($dtampil3); |
|
411 | + $d3 = mysql_fetch_array($dtampil3); |
|
412 | 412 | |
413 | - echo '<th>'.$d3['jml'].'</th>'; |
|
414 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
413 | + echo '<th>'.$d3['jml'].'</th>'; |
|
414 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
415 | 415 | |
416 | - echo '<th></th>'; |
|
417 | - echo '<th></th>'; |
|
418 | - echo '<th></th>'; |
|
416 | + echo '<th></th>'; |
|
417 | + echo '<th></th>'; |
|
418 | + echo '<th></th>'; |
|
419 | 419 | |
420 | - echo '<th></th>'; |
|
421 | - echo '<th></th>'; |
|
422 | - echo '<th></th>'; |
|
420 | + echo '<th></th>'; |
|
421 | + echo '<th></th>'; |
|
422 | + echo '<th></th>'; |
|
423 | 423 | |
424 | - //total jml |
|
425 | - $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
424 | + //total jml |
|
425 | + $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
426 | 426 | FROM kasir b LEFT JOIN kasir_detail c |
427 | 427 | ON b.id_kasir = c.id_kasir |
428 | 428 | AND c.status != '4' |
@@ -430,12 +430,12 @@ discard block |
||
430 | 430 | WHERE b.tanggal = '$tgl' |
431 | 431 | AND b.status != '4'"); |
432 | 432 | |
433 | - $d4 = mysql_fetch_array($dtampil4); |
|
433 | + $d4 = mysql_fetch_array($dtampil4); |
|
434 | 434 | |
435 | - echo '<th>'.$d4['jml'].'</th>'; |
|
435 | + echo '<th>'.$d4['jml'].'</th>'; |
|
436 | 436 | |
437 | - //total pembayaran |
|
438 | - $dtampil5 = mysql_query("SELECT a.groups |
|
437 | + //total pembayaran |
|
438 | + $dtampil5 = mysql_query("SELECT a.groups |
|
439 | 439 | , IFNULL(SUM(c.jumlah),0) as rp |
440 | 440 | FROM jenis_pembayaran a LEFT JOIN kasir b |
441 | 441 | ON b.tanggal = '$tgl' |
@@ -448,23 +448,23 @@ discard block |
||
448 | 448 | GROUP BY a.groups |
449 | 449 | ORDER BY a.groups"); |
450 | 450 | |
451 | - while ($d5 = mysql_fetch_array($dtampil5)) { |
|
452 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
453 | - } |
|
451 | + while ($d5 = mysql_fetch_array($dtampil5)) { |
|
452 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
453 | + } |
|
454 | 454 | |
455 | - echo'</tr>'; |
|
456 | - } ?> |
|
455 | + echo'</tr>'; |
|
456 | + } ?> |
|
457 | 457 | |
458 | 458 | </tbody> |
459 | 459 | |
460 | 460 | <?php |
461 | 461 | |
462 | - echo'<tr>'; |
|
462 | + echo'<tr>'; |
|
463 | 463 | |
464 | - echo"<th style='text-align:center;'>TOTAL</th>"; |
|
464 | + echo"<th style='text-align:center;'>TOTAL</th>"; |
|
465 | 465 | |
466 | - //transaksi asuransi |
|
467 | - $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
466 | + //transaksi asuransi |
|
467 | + $dtampil1 = mysql_query("SELECT a.id_penjamin |
|
468 | 468 | , COUNT(c.jumlah) as jml |
469 | 469 | , IFNULL(SUM(c.jumlah),0) as rp |
470 | 470 | FROM penjamin a LEFT JOIN kasir b |
@@ -480,13 +480,13 @@ discard block |
||
480 | 480 | GROUP BY a.id_penjamin |
481 | 481 | ORDER BY a.id_penjamin"); |
482 | 482 | |
483 | - while ($d1 = mysql_fetch_array($dtampil1)) { |
|
484 | - echo '<th>'.$d1['jml'].'</th>'; |
|
485 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
486 | - } |
|
483 | + while ($d1 = mysql_fetch_array($dtampil1)) { |
|
484 | + echo '<th>'.$d1['jml'].'</th>'; |
|
485 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
486 | + } |
|
487 | 487 | |
488 | - //transaksi umum tunai |
|
489 | - $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
488 | + //transaksi umum tunai |
|
489 | + $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
490 | 490 | , IFNULL(SUM(c.jumlah),0) as rp |
491 | 491 | FROM kasir b LEFT JOIN kasir_detail c |
492 | 492 | ON b.id_kasir = c.id_kasir |
@@ -496,13 +496,13 @@ discard block |
||
496 | 496 | AND b.tanggal LIKE '$prd%' |
497 | 497 | AND b.status != '4'"); |
498 | 498 | |
499 | - $d2 = mysql_fetch_array($dtampil2); |
|
499 | + $d2 = mysql_fetch_array($dtampil2); |
|
500 | 500 | |
501 | - echo '<th>'.$d2['jml'].'</th>'; |
|
502 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
501 | + echo '<th>'.$d2['jml'].'</th>'; |
|
502 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
503 | 503 | |
504 | - //transaksi umum tunai |
|
505 | - $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
504 | + //transaksi umum tunai |
|
505 | + $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
506 | 506 | , IFNULL(SUM(c.jumlah),0) as rp |
507 | 507 | FROM kasir b LEFT JOIN kasir_detail c |
508 | 508 | ON b.id_kasir = c.id_kasir |
@@ -512,21 +512,21 @@ discard block |
||
512 | 512 | WHERE b.tanggal LIKE '$prd%' |
513 | 513 | AND b.status != '4'"); |
514 | 514 | |
515 | - $d3 = mysql_fetch_array($dtampil3); |
|
515 | + $d3 = mysql_fetch_array($dtampil3); |
|
516 | 516 | |
517 | - echo '<th>'.$d3['jml'].'</th>'; |
|
518 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
517 | + echo '<th>'.$d3['jml'].'</th>'; |
|
518 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
519 | 519 | |
520 | - echo '<th></th>'; |
|
521 | - echo '<th></th>'; |
|
522 | - echo '<th></th>'; |
|
520 | + echo '<th></th>'; |
|
521 | + echo '<th></th>'; |
|
522 | + echo '<th></th>'; |
|
523 | 523 | |
524 | - echo '<th></th>'; |
|
525 | - echo '<th></th>'; |
|
526 | - echo '<th></th>'; |
|
524 | + echo '<th></th>'; |
|
525 | + echo '<th></th>'; |
|
526 | + echo '<th></th>'; |
|
527 | 527 | |
528 | - //total jml |
|
529 | - $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
528 | + //total jml |
|
529 | + $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
530 | 530 | FROM kasir b LEFT JOIN kasir_detail c |
531 | 531 | ON b.id_kasir = c.id_kasir |
532 | 532 | AND c.status != '4' |
@@ -534,12 +534,12 @@ discard block |
||
534 | 534 | WHERE b.tanggal LIKE '$prd%' |
535 | 535 | AND b.status != '4'"); |
536 | 536 | |
537 | - $d4 = mysql_fetch_array($dtampil4); |
|
537 | + $d4 = mysql_fetch_array($dtampil4); |
|
538 | 538 | |
539 | - echo '<th>'.$d4['jml'].'</th>'; |
|
539 | + echo '<th>'.$d4['jml'].'</th>'; |
|
540 | 540 | |
541 | - //total pembayaran |
|
542 | - $dtampil5 = mysql_query("SELECT a.groups |
|
541 | + //total pembayaran |
|
542 | + $dtampil5 = mysql_query("SELECT a.groups |
|
543 | 543 | , IFNULL(SUM(c.jumlah),0) as rp |
544 | 544 | FROM jenis_pembayaran a LEFT JOIN kasir b |
545 | 545 | ON b.tanggal LIKE '$prd%' |
@@ -552,18 +552,18 @@ discard block |
||
552 | 552 | GROUP BY a.groups |
553 | 553 | ORDER BY a.groups"); |
554 | 554 | |
555 | - while ($d5 = mysql_fetch_array($dtampil5)) { |
|
556 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
557 | - } |
|
555 | + while ($d5 = mysql_fetch_array($dtampil5)) { |
|
556 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
557 | + } |
|
558 | 558 | |
559 | - echo'</tr>'; |
|
559 | + echo'</tr>'; |
|
560 | 560 | |
561 | - echo'<tr>'; |
|
561 | + echo'<tr>'; |
|
562 | 562 | |
563 | - echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
563 | + echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
564 | 564 | |
565 | - //total jml |
|
566 | - $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
565 | + //total jml |
|
566 | + $dtampil4 = mysql_query("SELECT COUNT(c.jumlah) as jml |
|
567 | 567 | FROM kasir b LEFT JOIN kasir_detail c |
568 | 568 | ON b.id_kasir = c.id_kasir |
569 | 569 | AND c.status != '4' |
@@ -571,12 +571,12 @@ discard block |
||
571 | 571 | WHERE b.tanggal LIKE '$prd%' |
572 | 572 | AND b.status != '4'"); |
573 | 573 | |
574 | - $d4 = mysql_fetch_array($dtampil4); |
|
574 | + $d4 = mysql_fetch_array($dtampil4); |
|
575 | 575 | |
576 | - echo '<th>'.$d4['jml'].'</th>'; |
|
576 | + echo '<th>'.$d4['jml'].'</th>'; |
|
577 | 577 | |
578 | - //total pembayaran |
|
579 | - $dtampil5 = mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
578 | + //total pembayaran |
|
579 | + $dtampil5 = mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
580 | 580 | FROM kasir b LEFT JOIN kasir_detail c |
581 | 581 | ON b.id_kasir = c.id_kasir |
582 | 582 | AND c.status != '4' |
@@ -584,9 +584,9 @@ discard block |
||
584 | 584 | WHERE b.tanggal LIKE '$prd%' |
585 | 585 | AND b.status != '4'"); |
586 | 586 | |
587 | - $d5 = mysql_fetch_array($dtampil5); |
|
587 | + $d5 = mysql_fetch_array($dtampil5); |
|
588 | 588 | |
589 | - echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
589 | + echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, '.', ',').'</th>'; |
|
590 | 590 | |
591 | 591 | ?> |
592 | 592 |