@@ -1,13 +1,13 @@ |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | - session_start(); |
|
| 3 | + session_start(); |
|
| 4 | 4 | |
| 5 | - session_destroy(); |
|
| 5 | + session_destroy(); |
|
| 6 | 6 | |
| 7 | - $userid = $_GET['userid']; |
|
| 8 | - $module = $_GET['module']; |
|
| 7 | + $userid = $_GET['userid']; |
|
| 8 | + $module = $_GET['module']; |
|
| 9 | 9 | |
| 10 | - header('location:index.php?userid='.$userid.'&module='.$module.''); |
|
| 10 | + header('location:index.php?userid='.$userid.'&module='.$module.''); |
|
| 11 | 11 | |
| 12 | 12 | // Apabila setelah logout langsung menuju halaman utama website, aktifkan baris di bawah ini: |
| 13 | 13 | |
@@ -1,5 +1,5 @@ |
||
| 1 | 1 | <?php |
| 2 | - /* MySQL connection */ |
|
| 2 | + /* MySQL connection */ |
|
| 3 | 3 | include $_SERVER['DOCUMENT_ROOT'].'/datatables/mysql.php'; /* ;-) */ |
| 4 | 4 | |
| 5 | 5 | $gaSql['link'] = mysql_pconnect($gaSql['server'], $gaSql['user'], $gaSql['password']) or |
@@ -2,22 +2,22 @@ |
||
| 2 | 2 | |
| 3 | 3 | include 'config/koneksi.php'; |
| 4 | 4 | |
| 5 | - $tampil = mysql_query("SELECT * FROM modul where link !='' ORDER BY urutan"); |
|
| 5 | + $tampil = mysql_query("SELECT * FROM modul where link !='' ORDER BY urutan"); |
|
| 6 | 6 | |
| 7 | - while ($r = mysql_fetch_array($tampil)) { |
|
| 8 | - $p = strlen($r['link']); |
|
| 9 | - $mod = substr($r['link'], 8, $p); |
|
| 7 | + while ($r = mysql_fetch_array($tampil)) { |
|
| 8 | + $p = strlen($r['link']); |
|
| 9 | + $mod = substr($r['link'], 8, $p); |
|
| 10 | 10 | |
| 11 | - // echo"$mod<br>"; |
|
| 12 | - // echo"$_GET[module]<br>"; |
|
| 13 | - // echo"modul/mod_$mod.php<br>"; |
|
| 11 | + // echo"$mod<br>"; |
|
| 12 | + // echo"$_GET[module]<br>"; |
|
| 13 | + // echo"modul/mod_$mod.php<br>"; |
|
| 14 | 14 | // |
| 15 | 15 | |
| 16 | - if ($_GET['module'] == $mod) { |
|
| 17 | - //include "modul/mod_$mod.php"; |
|
| 18 | - include "modul/mod_$mod/$mod.php"; |
|
| 19 | - } |
|
| 20 | - } |
|
| 16 | + if ($_GET['module'] == $mod) { |
|
| 17 | + //include "modul/mod_$mod.php"; |
|
| 18 | + include "modul/mod_$mod/$mod.php"; |
|
| 19 | + } |
|
| 20 | + } |
|
| 21 | 21 | |
| 22 | 22 | // Apabila modul tidak ditemukan |
| 23 | 23 | //else{ |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | |
| 33 | 33 | $user = $_SESSION['userid']; |
| 34 | 34 | |
| 35 | - $sql = mysql_query("select * from modul where aktif='Y' order by urutan"); |
|
| 35 | + $sql = mysql_query("select * from modul where aktif='Y' order by urutan"); |
|
| 36 | 36 | |
| 37 | 37 | while ($r = mysql_fetch_array($sql)) { |
| 38 | 38 | if ($r[status_menu] == 'M' and !empty($r[link])) { |
@@ -56,7 +56,7 @@ discard block |
||
| 56 | 56 | echo'</ul>'; |
| 57 | 57 | } |
| 58 | 58 | |
| 59 | - ?> |
|
| 59 | + ?> |
|
| 60 | 60 | |
| 61 | 61 | |
| 62 | 62 | |
@@ -464,7 +464,7 @@ |
||
| 464 | 464 | -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, // |
| 465 | 465 | -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, // |
| 466 | 466 | 36, -1, -1, -1, 37, 38, -1, -1, -1, -1, 39, 40, -1, 41, 42, 43, // |
| 467 | - 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 44, -1, -1, -1, -1, -1, // |
|
| 467 | + 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 44, -1, -1, -1, -1, -1, // |
|
| 468 | 468 | -1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, // |
| 469 | 469 | 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, -1, -1, -1, -1, -1, // |
| 470 | 470 | -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, // |
@@ -419,7 +419,7 @@ |
||
| 419 | 419 | -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, |
| 420 | 420 | -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, |
| 421 | 421 | 36, -1, -1, -1, 37, 38, -1, -1, -1, -1, 39, 40, -1, 41, 42, 43, |
| 422 | - 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 44, -1, -1, -1, -1, -1, |
|
| 422 | + 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 44, -1, -1, -1, -1, -1, |
|
| 423 | 423 | -1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, |
| 424 | 424 | 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, -1, -1, -1, -1, -1, |
| 425 | 425 | -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, |
@@ -33,5 +33,5 @@ |
||
| 33 | 33 | // |
| 34 | 34 | //?> |
| 35 | 35 | <?php |
| 36 | - echo" <link href='css/i_style.css' type='text/css' rel='stylesheet'>"; |
|
| 37 | - ?> |
|
| 38 | 36 | \ No newline at end of file |
| 37 | + echo" <link href='css/i_style.css' type='text/css' rel='stylesheet'>"; |
|
| 38 | + ?> |
|
| 39 | 39 | \ No newline at end of file |
@@ -109,16 +109,16 @@ discard block |
||
| 109 | 109 | <p class="pull-right"> |
| 110 | 110 | <select name="itipe_barang" class="form-control" onChange="document.myform.submit();"> |
| 111 | 111 | <?php |
| 112 | - $query = mysql_query('SELECT * FROM tipe_barang ORDER BY id_tipe_barang'); |
|
| 113 | - if ($query && mysql_num_rows($query) > 0) { |
|
| 114 | - while ($row = mysql_fetch_object($query)) { |
|
| 115 | - echo '<option value="'.$row->id_tipe_barang.'"'; |
|
| 116 | - if ($row->id_tipe_barang == $tipe_barang) { |
|
| 117 | - echo ' selected'; |
|
| 118 | - } |
|
| 119 | - echo '>'.$row->tipe_barang.'</option>'; |
|
| 120 | - } |
|
| 121 | - } |
|
| 112 | + $query = mysql_query('SELECT * FROM tipe_barang ORDER BY id_tipe_barang'); |
|
| 113 | + if ($query && mysql_num_rows($query) > 0) { |
|
| 114 | + while ($row = mysql_fetch_object($query)) { |
|
| 115 | + echo '<option value="'.$row->id_tipe_barang.'"'; |
|
| 116 | + if ($row->id_tipe_barang == $tipe_barang) { |
|
| 117 | + echo ' selected'; |
|
| 118 | + } |
|
| 119 | + echo '>'.$row->tipe_barang.'</option>'; |
|
| 120 | + } |
|
| 121 | + } |
|
| 122 | 122 | ?> |
| 123 | 123 | </select> |
| 124 | 124 | </p> |
@@ -126,16 +126,16 @@ discard block |
||
| 126 | 126 | <p class="pull-right"> |
| 127 | 127 | <select name="ioutlet" class="form-control" onChange="document.myform.submit();"> |
| 128 | 128 | <?php |
| 129 | - $query = mysql_query('SELECT * FROM outlet ORDER BY id_outlet'); |
|
| 130 | - if ($query && mysql_num_rows($query) > 0) { |
|
| 131 | - while ($row = mysql_fetch_object($query)) { |
|
| 132 | - echo '<option value="'.$row->id_outlet.'"'; |
|
| 133 | - if ($row->id_outlet == $outlet) { |
|
| 134 | - echo ' selected'; |
|
| 135 | - } |
|
| 136 | - echo '>'.$row->outlet.'</option>'; |
|
| 137 | - } |
|
| 138 | - } |
|
| 129 | + $query = mysql_query('SELECT * FROM outlet ORDER BY id_outlet'); |
|
| 130 | + if ($query && mysql_num_rows($query) > 0) { |
|
| 131 | + while ($row = mysql_fetch_object($query)) { |
|
| 132 | + echo '<option value="'.$row->id_outlet.'"'; |
|
| 133 | + if ($row->id_outlet == $outlet) { |
|
| 134 | + echo ' selected'; |
|
| 135 | + } |
|
| 136 | + echo '>'.$row->outlet.'</option>'; |
|
| 137 | + } |
|
| 138 | + } |
|
| 139 | 139 | ?> |
| 140 | 140 | </select> |
| 141 | 141 | </p> |
@@ -175,7 +175,7 @@ discard block |
||
| 175 | 175 | |
| 176 | 176 | <?php |
| 177 | 177 | |
| 178 | - $SQL = "SELECT b.jenis_barang |
|
| 178 | + $SQL = "SELECT b.jenis_barang |
|
| 179 | 179 | ,c.unit_barang |
| 180 | 180 | ,a.kode as kode_barang |
| 181 | 181 | ,a.id_barang |
@@ -208,15 +208,15 @@ discard block |
||
| 208 | 208 | ,d.harga_jual |
| 209 | 209 | ORDER BY a.id_jenis_barang,a.kode"; |
| 210 | 210 | |
| 211 | - $tampil = mysql_query($SQL); |
|
| 211 | + $tampil = mysql_query($SQL); |
|
| 212 | 212 | |
| 213 | - $no = 1; |
|
| 213 | + $no = 1; |
|
| 214 | 214 | |
| 215 | - while ($r = mysql_fetch_array($tampil)) { |
|
| 216 | - $id_barang = $r['id_barang']; |
|
| 217 | - $kode_barang = $r['kode_barang']; |
|
| 215 | + while ($r = mysql_fetch_array($tampil)) { |
|
| 216 | + $id_barang = $r['id_barang']; |
|
| 217 | + $kode_barang = $r['kode_barang']; |
|
| 218 | 218 | |
| 219 | - $dsql = mysql_query("SELECT sum(qty) as reserve
|
|
| 219 | + $dsql = mysql_query("SELECT sum(qty) as reserve
|
|
| 220 | 220 | FROM stok_reserved |
| 221 | 221 | WHERE id_barang_promosi = '$id_barang' |
| 222 | 222 | AND id_outlet = '$outlet' |
@@ -224,35 +224,35 @@ discard block |
||
| 224 | 224 | and prd = '$prd' |
| 225 | 225 | "); |
| 226 | 226 | |
| 227 | - $d = mysql_fetch_array($dsql); |
|
| 227 | + $d = mysql_fetch_array($dsql); |
|
| 228 | 228 | |
| 229 | - if ($d['reserve']) { |
|
| 230 | - $reserve = $d['reserve']; |
|
| 231 | - } else { |
|
| 232 | - $reserve = 0; |
|
| 233 | - } |
|
| 229 | + if ($d['reserve']) { |
|
| 230 | + $reserve = $d['reserve']; |
|
| 231 | + } else { |
|
| 232 | + $reserve = 0; |
|
| 233 | + } |
|
| 234 | 234 | |
| 235 | - $sisa_stok = $r['stok'] - $reserve; |
|
| 235 | + $sisa_stok = $r['stok'] - $reserve; |
|
| 236 | 236 | |
| 237 | - if ($sisa_stok == '0') { |
|
| 238 | - echo ''; |
|
| 239 | - } else { |
|
| 240 | - echo'<tr>'; |
|
| 241 | - echo" <td style='text-align:center;'>"; |
|
| 242 | - echo"<a href='../../modul/mod_$module/aksi_$module.php?module=$module&act=add&barcode=$kode_barang&prd=$prd¬rans=$notrans&kode=$kode&tanggal=$tanggal&customer=$customer&outlet=$outlet&id_outlet=$id_outlet&id_module=$id_module&look=1' title=''><span class='icon'><i class='fa fa-check'></i></span></a>"; |
|
| 237 | + if ($sisa_stok == '0') { |
|
| 238 | + echo ''; |
|
| 239 | + } else { |
|
| 240 | + echo'<tr>'; |
|
| 241 | + echo" <td style='text-align:center;'>"; |
|
| 242 | + echo"<a href='../../modul/mod_$module/aksi_$module.php?module=$module&act=add&barcode=$kode_barang&prd=$prd¬rans=$notrans&kode=$kode&tanggal=$tanggal&customer=$customer&outlet=$outlet&id_outlet=$id_outlet&id_module=$id_module&look=1' title=''><span class='icon'><i class='fa fa-check'></i></span></a>"; |
|
| 243 | 243 | |
| 244 | - echo'</td>'; |
|
| 245 | - echo'<td>'.$r['jenis_barang'].'</td>'; |
|
| 246 | - echo'<td>'.$r['kode_barang'].'</td>'; |
|
| 247 | - echo'<td>'.$r['barang'].'</td>'; |
|
| 248 | - echo'<td>'.$r['unit_barang'].'</td>'; |
|
| 249 | - echo"<td style='text-align:right;'>".number_format($r['harga_jual'], 0, '.', ',').'</td>'; |
|
| 244 | + echo'</td>'; |
|
| 245 | + echo'<td>'.$r['jenis_barang'].'</td>'; |
|
| 246 | + echo'<td>'.$r['kode_barang'].'</td>'; |
|
| 247 | + echo'<td>'.$r['barang'].'</td>'; |
|
| 248 | + echo'<td>'.$r['unit_barang'].'</td>'; |
|
| 249 | + echo"<td style='text-align:right;'>".number_format($r['harga_jual'], 0, '.', ',').'</td>'; |
|
| 250 | 250 | |
| 251 | - echo'</tr>'; |
|
| 252 | - } |
|
| 251 | + echo'</tr>'; |
|
| 252 | + } |
|
| 253 | 253 | |
| 254 | - $no++; |
|
| 255 | - } |
|
| 254 | + $no++; |
|
| 255 | + } |
|
| 256 | 256 | ?> |
| 257 | 257 | </tbody> |
| 258 | 258 | </table> |
@@ -146,49 +146,49 @@ discard block |
||
| 146 | 146 | |
| 147 | 147 | <?php |
| 148 | 148 | |
| 149 | - $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
| 149 | + $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
| 150 | 150 | |
| 151 | - $g = mysql_fetch_array($gtampil); |
|
| 151 | + $g = mysql_fetch_array($gtampil); |
|
| 152 | 152 | |
| 153 | - if ($g['pict']) { |
|
| 154 | - $pict = $g['pict']; |
|
| 155 | - } else { |
|
| 156 | - $pict = ''; |
|
| 157 | - } |
|
| 153 | + if ($g['pict']) { |
|
| 154 | + $pict = $g['pict']; |
|
| 155 | + } else { |
|
| 156 | + $pict = ''; |
|
| 157 | + } |
|
| 158 | 158 | |
| 159 | - $company = ucwords($g['company']); |
|
| 159 | + $company = ucwords($g['company']); |
|
| 160 | 160 | |
| 161 | - $jsql = mysql_query("SELECT * FROM jenis_transaksi
|
|
| 161 | + $jsql = mysql_query("SELECT * FROM jenis_transaksi
|
|
| 162 | 162 | WHERE id_jenis_transaksi = '$jenis_transaksi' |
| 163 | 163 | |
| 164 | 164 | "); |
| 165 | 165 | |
| 166 | - $j = mysql_fetch_array($jsql); |
|
| 166 | + $j = mysql_fetch_array($jsql); |
|
| 167 | 167 | |
| 168 | - $jenis_transaksi = $j['jenis_transaksi']; |
|
| 168 | + $jenis_transaksi = $j['jenis_transaksi']; |
|
| 169 | 169 | |
| 170 | - $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b
|
|
| 170 | + $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b
|
|
| 171 | 171 | ON a.id_shift = b.id_shift |
| 172 | 172 | WHERE a.id_kasir = '$k_ID' |
| 173 | 173 | |
| 174 | 174 | "); |
| 175 | 175 | |
| 176 | - $r = mysql_fetch_array($sql); |
|
| 176 | + $r = mysql_fetch_array($sql); |
|
| 177 | 177 | |
| 178 | - $penjualan_barang = $r['id_kasir']; |
|
| 178 | + $penjualan_barang = $r['id_kasir']; |
|
| 179 | 179 | |
| 180 | - $shift = $r['shift']; |
|
| 180 | + $shift = $r['shift']; |
|
| 181 | 181 | |
| 182 | - $petugas = $r['petugas']; |
|
| 182 | + $petugas = $r['petugas']; |
|
| 183 | 183 | |
| 184 | - $status = $r['status']; |
|
| 184 | + $status = $r['status']; |
|
| 185 | 185 | |
| 186 | - $tanggal = date('d/m/Y', strtotime($r['tanggal'])); |
|
| 186 | + $tanggal = date('d/m/Y', strtotime($r['tanggal'])); |
|
| 187 | 187 | |
| 188 | - ?> |
|
| 188 | + ?> |
|
| 189 | 189 | |
| 190 | 190 | <?php if ($tipe == 'R') { |
| 191 | - ?> |
|
| 191 | + ?> |
|
| 192 | 192 | |
| 193 | 193 | |
| 194 | 194 | <table width="100%"> |
@@ -214,14 +214,14 @@ discard block |
||
| 214 | 214 | <?php |
| 215 | 215 | $htampil = mysql_query("SELECT * FROM jenis_transaksi where aktif = 'Y' ORDER BY id_jenis_transaksi"); |
| 216 | 216 | |
| 217 | - $hjml = mysql_num_rows($htampil); |
|
| 217 | + $hjml = mysql_num_rows($htampil); |
|
| 218 | 218 | |
| 219 | - while ($h = mysql_fetch_array($htampil)) { |
|
| 220 | - echo '<tr>'; |
|
| 221 | - echo '<td>'.$h['jenis_transaksi'].'</td>'; |
|
| 219 | + while ($h = mysql_fetch_array($htampil)) { |
|
| 220 | + echo '<tr>'; |
|
| 221 | + echo '<td>'.$h['jenis_transaksi'].'</td>'; |
|
| 222 | 222 | |
| 223 | - //transaksi umum tunai |
|
| 224 | - $dtampil = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 223 | + //transaksi umum tunai |
|
| 224 | + $dtampil = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 225 | 225 | , IFNULL(SUM(c.jumlah),0) as rp |
| 226 | 226 | FROM kasir b LEFT JOIN kasir_detail c |
| 227 | 227 | ON b.id_kasir = c.id_kasir |
@@ -230,13 +230,13 @@ discard block |
||
| 230 | 230 | AND c.id_jenis_transaksi = '".$h['id_jenis_transaksi']."' |
| 231 | 231 | AND b.status != '4'"); |
| 232 | 232 | |
| 233 | - $d = mysql_fetch_array($dtampil); |
|
| 233 | + $d = mysql_fetch_array($dtampil); |
|
| 234 | 234 | |
| 235 | - echo '<th>'.$d['jml'].'</th>'; |
|
| 236 | - echo "<th style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</th>'; |
|
| 235 | + echo '<th>'.$d['jml'].'</th>'; |
|
| 236 | + echo "<th style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</th>'; |
|
| 237 | 237 | |
| 238 | - echo '</tr>'; |
|
| 239 | - } ?> |
|
| 238 | + echo '</tr>'; |
|
| 239 | + } ?> |
|
| 240 | 240 | |
| 241 | 241 | |
| 242 | 242 | <tr> |
@@ -250,10 +250,10 @@ discard block |
||
| 250 | 250 | WHERE b.tanggal like '$prd%' |
| 251 | 251 | AND b.status != '4'"); |
| 252 | 252 | |
| 253 | - $d = mysql_fetch_array($dtampil); |
|
| 253 | + $d = mysql_fetch_array($dtampil); |
|
| 254 | 254 | |
| 255 | - echo '<th>'.$d['jml'].'</th>'; |
|
| 256 | - echo "<th style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</th>'; ?> |
|
| 255 | + echo '<th>'.$d['jml'].'</th>'; |
|
| 256 | + echo "<th style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</th>'; ?> |
|
| 257 | 257 | |
| 258 | 258 | </tr> |
| 259 | 259 | |
@@ -291,8 +291,8 @@ discard block |
||
| 291 | 291 | |
| 292 | 292 | |
| 293 | 293 | <?php |
| 294 | - } else { |
|
| 295 | - ?> |
|
| 294 | + } else { |
|
| 295 | + ?> |
|
| 296 | 296 | |
| 297 | 297 | <table width="100%"> |
| 298 | 298 | <tr> |
@@ -323,11 +323,11 @@ discard block |
||
| 323 | 323 | |
| 324 | 324 | $htampil = mysql_query("SELECT * FROM penjamin where aktif = 'Y' ORDER BY id_penjamin"); |
| 325 | 325 | |
| 326 | - $hjml = mysql_num_rows($htampil); |
|
| 326 | + $hjml = mysql_num_rows($htampil); |
|
| 327 | 327 | |
| 328 | - while ($h = mysql_fetch_array($htampil)) { |
|
| 329 | - echo "<th colspan='2' rowspan='2'>".$h['penjamin'].'</th>'; |
|
| 330 | - } ?> |
|
| 328 | + while ($h = mysql_fetch_array($htampil)) { |
|
| 329 | + echo "<th colspan='2' rowspan='2'>".$h['penjamin'].'</th>'; |
|
| 330 | + } ?> |
|
| 331 | 331 | |
| 332 | 332 | <th colspan ="4" >UMUM</th> |
| 333 | 333 | <th colspan ="2" rowspan='2'>TOTAL</th> |
@@ -367,15 +367,15 @@ discard block |
||
| 367 | 367 | |
| 368 | 368 | $htampil = mysql_query("SELECT * FROM jenis_transaksi where aktif = 'Y' ORDER BY id_jenis_transaksi"); |
| 369 | 369 | |
| 370 | - $hjml = mysql_num_rows($htampil); |
|
| 370 | + $hjml = mysql_num_rows($htampil); |
|
| 371 | 371 | |
| 372 | - while ($h = mysql_fetch_array($htampil)) { |
|
| 373 | - echo'<tr>'; |
|
| 372 | + while ($h = mysql_fetch_array($htampil)) { |
|
| 373 | + echo'<tr>'; |
|
| 374 | 374 | |
| 375 | - echo'<td>'.$h['jenis_transaksi'].'</td>'; |
|
| 375 | + echo'<td>'.$h['jenis_transaksi'].'</td>'; |
|
| 376 | 376 | |
| 377 | - //transaksi asuransi |
|
| 378 | - $dtampil1 = mysql_query("SELECT a.id_penjamin
|
|
| 377 | + //transaksi asuransi |
|
| 378 | + $dtampil1 = mysql_query("SELECT a.id_penjamin
|
|
| 379 | 379 | , COUNT(c.jumlah) as jml |
| 380 | 380 | , IFNULL(SUM(c.jumlah),0) as rp |
| 381 | 381 | FROM penjamin a LEFT JOIN kasir b |
@@ -391,12 +391,12 @@ discard block |
||
| 391 | 391 | GROUP BY a.id_penjamin |
| 392 | 392 | ORDER BY a.id_penjamin"); |
| 393 | 393 | |
| 394 | - while ($d1 = mysql_fetch_array($dtampil1)) { |
|
| 395 | - echo "<td style='text-align:center;'>".$d1['jml'].'</td>'; |
|
| 396 | - echo "<td style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</td>'; |
|
| 397 | - } |
|
| 394 | + while ($d1 = mysql_fetch_array($dtampil1)) { |
|
| 395 | + echo "<td style='text-align:center;'>".$d1['jml'].'</td>'; |
|
| 396 | + echo "<td style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</td>'; |
|
| 397 | + } |
|
| 398 | 398 | |
| 399 | - $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 399 | + $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 400 | 400 | , IFNULL(SUM(c.jumlah),0) as rp |
| 401 | 401 | FROM kasir b LEFT JOIN kasir_detail c |
| 402 | 402 | ON b.id_kasir = c.id_kasir |
@@ -406,12 +406,12 @@ discard block |
||
| 406 | 406 | AND c.id_jenis_transaksi = '".$h['id_jenis_transaksi']."' |
| 407 | 407 | AND b.status != '4'"); |
| 408 | 408 | |
| 409 | - $d2 = mysql_fetch_array($dtampil2); |
|
| 409 | + $d2 = mysql_fetch_array($dtampil2); |
|
| 410 | 410 | |
| 411 | - echo "<td style='text-align:center;'>".$d2['jml'].'</td>'; |
|
| 412 | - echo "<td style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</td>'; |
|
| 411 | + echo "<td style='text-align:center;'>".$d2['jml'].'</td>'; |
|
| 412 | + echo "<td style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</td>'; |
|
| 413 | 413 | |
| 414 | - $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 414 | + $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 415 | 415 | , IFNULL(SUM(c.jumlah),0) as rp |
| 416 | 416 | FROM kasir b LEFT JOIN kasir_detail c |
| 417 | 417 | ON b.id_kasir = c.id_kasir |
@@ -421,12 +421,12 @@ discard block |
||
| 421 | 421 | AND c.id_jenis_transaksi = '".$h['id_jenis_transaksi']."' |
| 422 | 422 | AND b.status != '4'"); |
| 423 | 423 | |
| 424 | - $d3 = mysql_fetch_array($dtampil3); |
|
| 424 | + $d3 = mysql_fetch_array($dtampil3); |
|
| 425 | 425 | |
| 426 | - echo "<td style='text-align:center;'>".$d3['jml'].'</td>'; |
|
| 427 | - echo "<td style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</td>'; |
|
| 426 | + echo "<td style='text-align:center;'>".$d3['jml'].'</td>'; |
|
| 427 | + echo "<td style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</td>'; |
|
| 428 | 428 | |
| 429 | - $dtampil = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 429 | + $dtampil = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 430 | 430 | , IFNULL(SUM(c.jumlah),0) as rp |
| 431 | 431 | FROM kasir b LEFT JOIN kasir_detail c |
| 432 | 432 | ON b.id_kasir = c.id_kasir |
@@ -435,13 +435,13 @@ discard block |
||
| 435 | 435 | AND c.id_jenis_transaksi = '".$h['id_jenis_transaksi']."' |
| 436 | 436 | AND b.status != '4'"); |
| 437 | 437 | |
| 438 | - $d = mysql_fetch_array($dtampil); |
|
| 438 | + $d = mysql_fetch_array($dtampil); |
|
| 439 | 439 | |
| 440 | - echo "<td style='text-align:center;'>".$d['jml'].'</td>'; |
|
| 441 | - echo "<td style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</td>'; |
|
| 440 | + echo "<td style='text-align:center;'>".$d['jml'].'</td>'; |
|
| 441 | + echo "<td style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</td>'; |
|
| 442 | 442 | |
| 443 | - echo'</tr>'; |
|
| 444 | - } ?> |
|
| 443 | + echo'</tr>'; |
|
| 444 | + } ?> |
|
| 445 | 445 | |
| 446 | 446 | </tbody> |
| 447 | 447 | |
@@ -449,12 +449,12 @@ discard block |
||
| 449 | 449 | |
| 450 | 450 | <?php |
| 451 | 451 | |
| 452 | - echo'<tr>'; |
|
| 452 | + echo'<tr>'; |
|
| 453 | 453 | |
| 454 | - echo'<th>TOTAL</th>'; |
|
| 454 | + echo'<th>TOTAL</th>'; |
|
| 455 | 455 | |
| 456 | - //transaksi asuransi |
|
| 457 | - $dtampil1 = mysql_query("SELECT a.id_penjamin
|
|
| 456 | + //transaksi asuransi |
|
| 457 | + $dtampil1 = mysql_query("SELECT a.id_penjamin
|
|
| 458 | 458 | , COUNT(c.jumlah) as jml |
| 459 | 459 | , IFNULL(SUM(c.jumlah),0) as rp |
| 460 | 460 | FROM penjamin a LEFT JOIN kasir b |
@@ -469,12 +469,12 @@ discard block |
||
| 469 | 469 | GROUP BY a.id_penjamin |
| 470 | 470 | ORDER BY a.id_penjamin"); |
| 471 | 471 | |
| 472 | - while ($d1 = mysql_fetch_array($dtampil1)) { |
|
| 473 | - echo '<th>'.$d1['jml'].'</th>'; |
|
| 474 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
| 475 | - } |
|
| 472 | + while ($d1 = mysql_fetch_array($dtampil1)) { |
|
| 473 | + echo '<th>'.$d1['jml'].'</th>'; |
|
| 474 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, '.', ',').'</th>'; |
|
| 475 | + } |
|
| 476 | 476 | |
| 477 | - $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 477 | + $dtampil2 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 478 | 478 | , IFNULL(SUM(c.jumlah),0) as rp |
| 479 | 479 | FROM kasir b LEFT JOIN kasir_detail c |
| 480 | 480 | ON b.id_kasir = c.id_kasir |
@@ -483,12 +483,12 @@ discard block |
||
| 483 | 483 | WHERE b.tanggal LIKE '$prd%' |
| 484 | 484 | AND b.status != '4'"); |
| 485 | 485 | |
| 486 | - $d2 = mysql_fetch_array($dtampil2); |
|
| 486 | + $d2 = mysql_fetch_array($dtampil2); |
|
| 487 | 487 | |
| 488 | - echo '<th>'.$d2['jml'].'</th>'; |
|
| 489 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
| 488 | + echo '<th>'.$d2['jml'].'</th>'; |
|
| 489 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, '.', ',').'</th>'; |
|
| 490 | 490 | |
| 491 | - $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 491 | + $dtampil3 = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 492 | 492 | , IFNULL(SUM(c.jumlah),0) as rp |
| 493 | 493 | FROM kasir b LEFT JOIN kasir_detail c |
| 494 | 494 | ON b.id_kasir = c.id_kasir |
@@ -497,12 +497,12 @@ discard block |
||
| 497 | 497 | WHERE b.tanggal LIKE '$prd%' |
| 498 | 498 | AND b.status != '4'"); |
| 499 | 499 | |
| 500 | - $d3 = mysql_fetch_array($dtampil3); |
|
| 500 | + $d3 = mysql_fetch_array($dtampil3); |
|
| 501 | 501 | |
| 502 | - echo '<th>'.$d3['jml'].'</th>'; |
|
| 503 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
| 502 | + echo '<th>'.$d3['jml'].'</th>'; |
|
| 503 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, '.', ',').'</th>'; |
|
| 504 | 504 | |
| 505 | - $dtampil = mysql_query("SELECT COUNT(c.jumlah) as jml
|
|
| 505 | + $dtampil = 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 |
@@ -510,12 +510,12 @@ discard block |
||
| 510 | 510 | WHERE b.tanggal like '$prd%' |
| 511 | 511 | AND b.status != '4'"); |
| 512 | 512 | |
| 513 | - $d = mysql_fetch_array($dtampil); |
|
| 513 | + $d = mysql_fetch_array($dtampil); |
|
| 514 | 514 | |
| 515 | - echo '<th>'.$d['jml'].'</th>'; |
|
| 516 | - echo "<th style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</th>'; |
|
| 515 | + echo '<th>'.$d['jml'].'</th>'; |
|
| 516 | + echo "<th style='text-align:right;'>".number_format($d['rp'], 0, '.', ',').'</th>'; |
|
| 517 | 517 | |
| 518 | - echo'</tr>'; ?> |
|
| 518 | + echo'</tr>'; ?> |
|
| 519 | 519 | |
| 520 | 520 | |
| 521 | 521 | |
@@ -529,17 +529,17 @@ discard block |
||
| 529 | 529 | |
| 530 | 530 | $lastday = date('t', strtotime($iprd)); |
| 531 | 531 | |
| 532 | - $year = date('Y', strtotime($iprd)); |
|
| 532 | + $year = date('Y', strtotime($iprd)); |
|
| 533 | 533 | |
| 534 | - $month = date('m', strtotime($iprd)) * 1; |
|
| 534 | + $month = date('m', strtotime($iprd)) * 1; |
|
| 535 | 535 | |
| 536 | - if ($month == '1') { |
|
| 537 | - $imonth = 12; |
|
| 538 | - } else { |
|
| 539 | - $imonth = $month - 1; |
|
| 540 | - } |
|
| 536 | + if ($month == '1') { |
|
| 537 | + $imonth = 12; |
|
| 538 | + } else { |
|
| 539 | + $imonth = $month - 1; |
|
| 540 | + } |
|
| 541 | 541 | |
| 542 | - $nprd = $lastday.' '.getBulan1($imonth).' '.$year; ?> |
|
| 542 | + $nprd = $lastday.' '.getBulan1($imonth).' '.$year; ?> |
|
| 543 | 543 | |
| 544 | 544 | <table width="100%"> |
| 545 | 545 | <tr> |
@@ -570,7 +570,7 @@ discard block |
||
| 570 | 570 | |
| 571 | 571 | |
| 572 | 572 | <?php |
| 573 | - } ?> |
|
| 573 | + } ?> |
|
| 574 | 574 | |
| 575 | 575 | |
| 576 | 576 | |