@@ -102,10 +102,10 @@ |
||
102 | 102 | <select name="jenis_transaksi" class="form-control"> |
103 | 103 | <?php |
104 | 104 | $query = mysql_query('SELECT * FROM jenis_transaksi ORDER BY id_jenis_transaksi'); |
105 | - if ($query && mysql_num_rows($query) > 0) { |
|
105 | + if ($query && mysql_num_rows($query)>0) { |
|
106 | 106 | while ($row = mysql_fetch_object($query)) { |
107 | 107 | echo '<option value="'.$row->id_jenis_transaksi.'"'; |
108 | - if ($row->id_jenis_transaksi == '1') { |
|
108 | + if ($row->id_jenis_transaksi=='1') { |
|
109 | 109 | echo ' selected'; |
110 | 110 | } |
111 | 111 | echo '>'.$row->jenis_transaksi.'</option>'; |
@@ -227,7 +227,7 @@ discard block |
||
227 | 227 | <tr> |
228 | 228 | |
229 | 229 | <?php |
230 | - for ($j = 1; $j <= $hjml; $j++) { |
|
230 | + for ($j = 1; $j<=$hjml; $j++) { |
|
231 | 231 | echo '<th>JML</th>'; |
232 | 232 | echo '<th>RUPIAH</th>'; |
233 | 233 | } |
@@ -252,12 +252,12 @@ discard block |
||
252 | 252 | |
253 | 253 | <tbody> |
254 | 254 | |
255 | - <?php for ($i = 1; $i <= 31; $i++) { |
|
255 | + <?php for ($i = 1; $i<=31; $i++) { |
|
256 | 256 | echo'<tr>'; |
257 | 257 | |
258 | 258 | echo"<td style='text-align:center;'>$i</td>"; |
259 | 259 | |
260 | - if (strlen($i) == '1') { |
|
260 | + if (strlen($i)=='1') { |
|
261 | 261 | $tgl = $prd.'-0'.$i; |
262 | 262 | } else { |
263 | 263 | $tgl = $prd.'-'.$i; |
@@ -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%' |
@@ -323,7 +323,7 @@ discard block |
||
323 | 323 | <tr> |
324 | 324 | |
325 | 325 | <?php |
326 | - for ($j = 1; $j <= $hjml; $j++) { |
|
326 | + for ($j = 1; $j<=$hjml; $j++) { |
|
327 | 327 | echo '<th>JML</th>'; |
328 | 328 | echo '<th>RUPIAH</th>'; |
329 | 329 | } |
@@ -348,12 +348,12 @@ discard block |
||
348 | 348 | |
349 | 349 | <tbody> |
350 | 350 | |
351 | - <?php for ($i = 1; $i <= 31; $i++) { |
|
351 | + <?php for ($i = 1; $i<=31; $i++) { |
|
352 | 352 | echo'<tr>'; |
353 | 353 | |
354 | 354 | echo"<td style='text-align:center;'>$i</td>"; |
355 | 355 | |
356 | - if (strlen($i) == '1') { |
|
356 | + if (strlen($i)=='1') { |
|
357 | 357 | $tgl = $prd.'-0'.$i; |
358 | 358 | } else { |
359 | 359 | $tgl = $prd.'-'.$i; |
@@ -88,45 +88,45 @@ discard block |
||
88 | 88 | |
89 | 89 | switch ($_GET[act]) { |
90 | 90 | |
91 | -default: |
|
91 | + default: |
|
92 | 92 | |
93 | -if ($_SESSION['outlet']=='0') { |
|
94 | - $d_outlet = '%'; |
|
93 | + if ($_SESSION['outlet']=='0') { |
|
94 | + $d_outlet = '%'; |
|
95 | 95 | } else { |
96 | - $d_outlet = $_SESSION['outlet']; |
|
96 | + $d_outlet = $_SESSION['outlet']; |
|
97 | 97 | } |
98 | 98 | |
99 | -if ($_GET['ioutlet']) { |
|
100 | - $outlet = $_GET['ioutlet']; |
|
99 | + if ($_GET['ioutlet']) { |
|
100 | + $outlet = $_GET['ioutlet']; |
|
101 | 101 | } else { |
102 | - if ($_SESSION['outlet']=='0') { |
|
103 | - $outlet = '1'; |
|
104 | - } else { |
|
105 | - $outlet = $_SESSION['outlet']; |
|
106 | - } |
|
102 | + if ($_SESSION['outlet']=='0') { |
|
103 | + $outlet = '1'; |
|
104 | + } else { |
|
105 | + $outlet = $_SESSION['outlet']; |
|
106 | + } |
|
107 | 107 | } |
108 | 108 | |
109 | -$query = mysql_query('SELECT * FROM periode '); |
|
109 | + $query = mysql_query('SELECT * FROM periode '); |
|
110 | 110 | |
111 | -if ($query && mysql_num_rows($query)==1) { |
|
112 | - $data = mysql_fetch_object($query); |
|
111 | + if ($query && mysql_num_rows($query)==1) { |
|
112 | + $data = mysql_fetch_object($query); |
|
113 | 113 | } |
114 | 114 | |
115 | -$iprd = $data->periode; |
|
115 | + $iprd = $data->periode; |
|
116 | 116 | |
117 | -if ($_GET['prd']) { |
|
118 | - $prd = $_GET['prd']; |
|
117 | + if ($_GET['prd']) { |
|
118 | + $prd = $_GET['prd']; |
|
119 | 119 | } else { |
120 | - $prd = $prd; |
|
120 | + $prd = $prd; |
|
121 | 121 | } |
122 | 122 | |
123 | -if ($_GET['istatus']) { |
|
124 | - $status = $_GET['istatus']; |
|
123 | + if ($_GET['istatus']) { |
|
124 | + $status = $_GET['istatus']; |
|
125 | 125 | } else { |
126 | - $status = '0'; |
|
126 | + $status = '0'; |
|
127 | 127 | } |
128 | 128 | |
129 | - ?> |
|
129 | + ?> |
|
130 | 130 | |
131 | 131 | |
132 | 132 | |
@@ -180,21 +180,21 @@ discard block |
||
180 | 180 | |
181 | 181 | <?php |
182 | 182 | |
183 | - $query = mysql_query("SELECT * FROM outlet where id_outlet like '$d_outlet' ORDER BY id_outlet"); |
|
183 | + $query = mysql_query("SELECT * FROM outlet where id_outlet like '$d_outlet' ORDER BY id_outlet"); |
|
184 | + |
|
185 | + if ($query && mysql_num_rows($query) > 0) { |
|
186 | + while ($row = mysql_fetch_object($query)) { |
|
187 | + echo '<option value="'.$row->id_outlet.'"'; |
|
184 | 188 | |
185 | - if ($query && mysql_num_rows($query) > 0) { |
|
186 | - while ($row = mysql_fetch_object($query)) { |
|
187 | - echo '<option value="'.$row->id_outlet.'"'; |
|
189 | + if ($row->id_outlet == $outlet) { |
|
190 | + echo ' selected'; |
|
191 | + } |
|
188 | 192 | |
189 | - if ($row->id_outlet == $outlet) { |
|
190 | - echo ' selected'; |
|
193 | + echo '>'.$row->outlet.'</option>'; |
|
191 | 194 | } |
192 | - |
|
193 | - echo '>'.$row->outlet.'</option>'; |
|
194 | 195 | } |
195 | - } |
|
196 | 196 | |
197 | - ?> |
|
197 | + ?> |
|
198 | 198 | |
199 | 199 | </select> |
200 | 200 | |
@@ -208,21 +208,21 @@ discard block |
||
208 | 208 | |
209 | 209 | <?php |
210 | 210 | |
211 | - $query = mysql_query('SELECT * FROM status ORDER BY id_status'); |
|
211 | + $query = mysql_query('SELECT * FROM status ORDER BY id_status'); |
|
212 | 212 | |
213 | - if ($query && mysql_num_rows($query) > 0) { |
|
214 | - while ($row = mysql_fetch_object($query)) { |
|
215 | - echo '<option value="'.$row->id_status.'"'; |
|
213 | + if ($query && mysql_num_rows($query) > 0) { |
|
214 | + while ($row = mysql_fetch_object($query)) { |
|
215 | + echo '<option value="'.$row->id_status.'"'; |
|
216 | 216 | |
217 | - if ($row->id_status == $status) { |
|
218 | - echo ' selected'; |
|
219 | - } |
|
217 | + if ($row->id_status == $status) { |
|
218 | + echo ' selected'; |
|
219 | + } |
|
220 | 220 | |
221 | - echo '>'.$row->status.'</option>'; |
|
221 | + echo '>'.$row->status.'</option>'; |
|
222 | + } |
|
222 | 223 | } |
223 | - } |
|
224 | 224 | |
225 | - ?> |
|
225 | + ?> |
|
226 | 226 | |
227 | 227 | </select> |
228 | 228 | |
@@ -277,7 +277,7 @@ discard block |
||
277 | 277 | <?php |
278 | 278 | |
279 | 279 | |
280 | - $pjSQL = mysql_query("SELECT * FROM penjualan_barang_detail |
|
280 | + $pjSQL = mysql_query("SELECT * FROM penjualan_barang_detail |
|
281 | 281 | |
282 | 282 | WHERE status_diskon = '$status' and prd = '$prd' and disc1 > 0 |
283 | 283 | |
@@ -285,21 +285,21 @@ discard block |
||
285 | 285 | |
286 | 286 | "); |
287 | 287 | |
288 | - $pj = mysql_num_rows($pjSQL); |
|
288 | + $pj = mysql_num_rows($pjSQL); |
|
289 | 289 | |
290 | - if ($iprd == $prd) { |
|
291 | - $disabled = ''; |
|
292 | - } else { |
|
293 | - $disabled = 'disabled'; |
|
294 | - } |
|
290 | + if ($iprd == $prd) { |
|
291 | + $disabled = ''; |
|
292 | + } else { |
|
293 | + $disabled = 'disabled'; |
|
294 | + } |
|
295 | 295 | |
296 | - if ($pj == 0) { |
|
297 | - $disabled1 = 'disabled'; |
|
298 | - } else { |
|
299 | - $disabled1 = ''; |
|
300 | - } |
|
296 | + if ($pj == 0) { |
|
297 | + $disabled1 = 'disabled'; |
|
298 | + } else { |
|
299 | + $disabled1 = ''; |
|
300 | + } |
|
301 | 301 | |
302 | - ?> |
|
302 | + ?> |
|
303 | 303 | |
304 | 304 | |
305 | 305 | |
@@ -346,7 +346,7 @@ discard block |
||
346 | 346 | <button type="submit" class="btn btn-success btn-sm " |
347 | 347 | |
348 | 348 | <?php echo $disabled?> |
349 | - |
|
349 | + |
|
350 | 350 | <?php echo $disabled1?> |
351 | 351 | |
352 | 352 | > |
@@ -374,7 +374,7 @@ discard block |
||
374 | 374 | <?php |
375 | 375 | |
376 | 376 | |
377 | - $tampil = mysql_query("SELECT b.*,c.customer,a.tanggal |
|
377 | + $tampil = mysql_query("SELECT b.*,c.customer,a.tanggal |
|
378 | 378 | |
379 | 379 | , case when b.id_barang = '0' then e.paket else d.barang end as barang |
380 | 380 | |
@@ -416,44 +416,44 @@ discard block |
||
416 | 416 | |
417 | 417 | "); |
418 | 418 | |
419 | - $no = 1; |
|
419 | + $no = 1; |
|
420 | 420 | |
421 | - while ($r = mysql_fetch_array($tampil)) { |
|
422 | - $tgl = date('d/m/y', strtotime($r['tanggal'])); |
|
421 | + while ($r = mysql_fetch_array($tampil)) { |
|
422 | + $tgl = date('d/m/y', strtotime($r['tanggal'])); |
|
423 | 423 | |
424 | - echo'<tr>'; |
|
424 | + echo'<tr>'; |
|
425 | 425 | |
426 | - echo"<td>$tgl </td>"; |
|
426 | + echo"<td>$tgl </td>"; |
|
427 | 427 | |
428 | - echo"<td>$r[notrans]</td>"; |
|
428 | + echo"<td>$r[notrans]</td>"; |
|
429 | 429 | |
430 | - echo"<td>$r[customer]</td>"; |
|
430 | + echo"<td>$r[customer]</td>"; |
|
431 | 431 | |
432 | - echo"<td>$r[barang]</td>"; |
|
432 | + echo"<td>$r[barang]</td>"; |
|
433 | 433 | |
434 | - echo"<td style='text-align:right;'>".number_format($r[total], '0', '.', ',').'</td>'; |
|
434 | + echo"<td style='text-align:right;'>".number_format($r[total], '0', '.', ',').'</td>'; |
|
435 | 435 | |
436 | - echo"<td style='text-align:right;'>".number_format($r[disc1], '2', '.', ',').' % | Rp. '.number_format($r[disc_value1], '0', '.', ',').'</td>'; |
|
436 | + echo"<td style='text-align:right;'>".number_format($r[disc1], '2', '.', ',').' % | Rp. '.number_format($r[disc_value1], '0', '.', ',').'</td>'; |
|
437 | 437 | |
438 | - echo'<td>'; ?> |
|
438 | + echo'<td>'; ?> |
|
439 | 439 | |
440 | 440 | <select name="status<?php echo $no; ?>" class="form-control" onchange="Getstatus<?php echo $no; ?>(this.value)"> |
441 | 441 | |
442 | 442 | <?php |
443 | 443 | |
444 | - $query = mysql_query('SELECT * FROM status ORDER BY id_status'); |
|
444 | + $query = mysql_query('SELECT * FROM status ORDER BY id_status'); |
|
445 | 445 | |
446 | - if ($query && mysql_num_rows($query) > 0) { |
|
447 | - while ($row = mysql_fetch_object($query)) { |
|
448 | - echo '<option value="'.$row->id_status.'"'; |
|
446 | + if ($query && mysql_num_rows($query) > 0) { |
|
447 | + while ($row = mysql_fetch_object($query)) { |
|
448 | + echo '<option value="'.$row->id_status.'"'; |
|
449 | 449 | |
450 | - if ($row->id_status == $r[status_diskon]) { |
|
451 | - echo ' selected'; |
|
452 | - } |
|
450 | + if ($row->id_status == $r[status_diskon]) { |
|
451 | + echo ' selected'; |
|
452 | + } |
|
453 | 453 | |
454 | - echo '>'.$row->status.'</option>'; |
|
455 | - } |
|
456 | - } ?> |
|
454 | + echo '>'.$row->status.'</option>'; |
|
455 | + } |
|
456 | + } ?> |
|
457 | 457 | |
458 | 458 | </select> |
459 | 459 | |
@@ -463,30 +463,30 @@ discard block |
||
463 | 463 | |
464 | 464 | <?php |
465 | 465 | |
466 | - echo'</td>'; |
|
466 | + echo'</td>'; |
|
467 | 467 | |
468 | - echo"<td style='text-align:center;'>"; |
|
468 | + echo"<td style='text-align:center;'>"; |
|
469 | 469 | |
470 | - echo"<input type='hidden' name='id".$no."' value = '$r[id_penjualan_barang_detail]'>"; |
|
470 | + echo"<input type='hidden' name='id".$no."' value = '$r[id_penjualan_barang_detail]'>"; |
|
471 | 471 | |
472 | - echo"<input type='hidden' name='prd".$no."' value = '$r[prd]'>"; |
|
472 | + echo"<input type='hidden' name='prd".$no."' value = '$r[prd]'>"; |
|
473 | 473 | |
474 | - echo"<input type='hidden' name='notrans".$no."' value = '$r[notrans]'>"; |
|
474 | + echo"<input type='hidden' name='notrans".$no."' value = '$r[notrans]'>"; |
|
475 | 475 | |
476 | - echo"<input type='hidden' name='outlet".$no."' value = '$r[id_outlet]'>"; |
|
476 | + echo"<input type='hidden' name='outlet".$no."' value = '$r[id_outlet]'>"; |
|
477 | 477 | |
478 | - echo"<input type='hidden' name='p_status".$no."' id='p_status".$no."' value = '$status'>"; |
|
478 | + echo"<input type='hidden' name='p_status".$no."' id='p_status".$no."' value = '$status'>"; |
|
479 | 479 | |
480 | - // echo"<a class='btn btn-default btn-sm' href='?module=$module&id_module=$id_module&id_pemesanan_barang=$r[id_pemesanan_barang]&prd=$prd&outlet=$outlet&act=detail' title='Detail Penarikan Simpanan'><span class='icon'><i class='fa fa-pencil-square-o'></i></span></a>"; |
|
480 | + // echo"<a class='btn btn-default btn-sm' href='?module=$module&id_module=$id_module&id_pemesanan_barang=$r[id_pemesanan_barang]&prd=$prd&outlet=$outlet&act=detail' title='Detail Penarikan Simpanan'><span class='icon'><i class='fa fa-pencil-square-o'></i></span></a>"; |
|
481 | 481 | |
482 | - echo'</td>'; |
|
482 | + echo'</td>'; |
|
483 | 483 | |
484 | - echo'</tr>'; |
|
484 | + echo'</tr>'; |
|
485 | 485 | |
486 | - $no++; |
|
487 | - } |
|
486 | + $no++; |
|
487 | + } |
|
488 | 488 | |
489 | - ?> |
|
489 | + ?> |
|
490 | 490 | |
491 | 491 | |
492 | 492 | |
@@ -584,7 +584,7 @@ discard block |
||
584 | 584 | |
585 | 585 | <?php |
586 | 586 | |
587 | - break; |
|
587 | + break; |
|
588 | 588 | |
589 | 589 | } |
590 | 590 |
@@ -182,11 +182,11 @@ discard block |
||
182 | 182 | |
183 | 183 | $query = mysql_query("SELECT * FROM outlet where id_outlet like '$d_outlet' ORDER BY id_outlet"); |
184 | 184 | |
185 | - if ($query && mysql_num_rows($query) > 0) { |
|
185 | + if ($query && mysql_num_rows($query)>0) { |
|
186 | 186 | while ($row = mysql_fetch_object($query)) { |
187 | 187 | echo '<option value="'.$row->id_outlet.'"'; |
188 | 188 | |
189 | - if ($row->id_outlet == $outlet) { |
|
189 | + if ($row->id_outlet==$outlet) { |
|
190 | 190 | echo ' selected'; |
191 | 191 | } |
192 | 192 | |
@@ -210,11 +210,11 @@ discard block |
||
210 | 210 | |
211 | 211 | $query = mysql_query('SELECT * FROM status ORDER BY id_status'); |
212 | 212 | |
213 | - if ($query && mysql_num_rows($query) > 0) { |
|
213 | + if ($query && mysql_num_rows($query)>0) { |
|
214 | 214 | while ($row = mysql_fetch_object($query)) { |
215 | 215 | echo '<option value="'.$row->id_status.'"'; |
216 | 216 | |
217 | - if ($row->id_status == $status) { |
|
217 | + if ($row->id_status==$status) { |
|
218 | 218 | echo ' selected'; |
219 | 219 | } |
220 | 220 | |
@@ -287,13 +287,13 @@ discard block |
||
287 | 287 | |
288 | 288 | $pj = mysql_num_rows($pjSQL); |
289 | 289 | |
290 | - if ($iprd == $prd) { |
|
290 | + if ($iprd==$prd) { |
|
291 | 291 | $disabled = ''; |
292 | 292 | } else { |
293 | 293 | $disabled = 'disabled'; |
294 | 294 | } |
295 | 295 | |
296 | - if ($pj == 0) { |
|
296 | + if ($pj==0) { |
|
297 | 297 | $disabled1 = 'disabled'; |
298 | 298 | } else { |
299 | 299 | $disabled1 = ''; |
@@ -443,11 +443,11 @@ discard block |
||
443 | 443 | |
444 | 444 | $query = mysql_query('SELECT * FROM status ORDER BY id_status'); |
445 | 445 | |
446 | - if ($query && mysql_num_rows($query) > 0) { |
|
446 | + if ($query && mysql_num_rows($query)>0) { |
|
447 | 447 | while ($row = mysql_fetch_object($query)) { |
448 | 448 | echo '<option value="'.$row->id_status.'"'; |
449 | 449 | |
450 | - if ($row->id_status == $r[status_diskon]) { |
|
450 | + if ($row->id_status==$r[status_diskon]) { |
|
451 | 451 | echo ' selected'; |
452 | 452 | } |
453 | 453 |