Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <link rel="stylesheet" href="assets/css/reqformtransaksi.css" type="text/css">
- <style>
- #wrapper{
- margin: 150px 0px 50px 0px;
- }
- table{border-collapse:collapse; margin: 0 auto;}
- td, th{border-right:1px solid black;border-top:1px solid black;border-bottom:1px solid black;text-align:center;}
- .content{font-family:verdana; font-size:12px; color: #2E506E;}
- .content:hover{background-color: #9DC7ED;}
- td{padding: 5px 10px 5px 10px;}
- a{color: #2E506E;text-decoration:none;}
- #topleft{-moz-border-radius-topleft:10px;-webkit-border-radius-topleft:10px;-khtml-border-radius-topleft:10px;border-radius-topleft:10px;
- border-top: none;border-left:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}
- #topright{-moz-border-radius-topright:10px;-webkit-border-radius-topright:10px;-khtml-border-radius-topright:10px;border-radius-topright:10px;
- border-top: none;border-right:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}
- .top{border-top:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}
- .mid_left_content{border-left:none;}
- .mid_right_content{border-right:none;}
- .foot_content{border-left:none;border-right:none;font-size:12px;text-align:right;font-family:verdana;}
- .foot_img{border-left:none;border-right:none;text-align:center;}
- .foot_content a{color: #2E506E;text-decoration:none;}
- .foot_content1 a{font-family:verdana;font-size:12;color: #d5d5d5;text-decoration:none;}
- .foot_content1 a:hover{text-shadow:1px 1px 7px yellow;}
- .foot_content1{font-family:verdana;font-size:12;color: white;text-decoration:none;}
- #footer_tr{background-color: #024A68;color: white;font-weight:bold;height:30px;
- -moz-border-radius-bottomright:10px;-webkit-border-radius-bottomright:10px;-khtml-border-radius-bottomright:10px;border-radius-bottomright:10px;
- -moz-border-radius-bottomleft:10px;-webkit-border-radius-bottomleft:10px;-khtml-border-radius-bottomleft:10px;border-radius-bottomleft:10px;}
- input{text-align:center;padding: 5px 10px 5px 10px;}
- </style>
- </head>
- <body>
- <div id='wrapper'>
- <table>
- <?
- error_reporting(1);
- include("../connect.php");
- //Langkah 1: Tentukan batas,cek halaman & posisi data
- date_default_timezone_set('UTC');
- date_default_timezone_set('Asia/Jakarta');
- $date = date("Y-m-d H:i:s");
- $batas=10;
- $halaman=$_GET['halaman'];
- if(empty($halaman)){
- $posisi=0;
- $halaman=1;
- }
- else{
- $posisi = ($halaman-1) * $batas;
- }
- echo "<tr>
- <td id='topleft' width='25px'>No</td>
- <td class='top' width='100px'>Id Accecoriss</td>
- <td class='top' width='110px'>Merk</td>
- <td class='top' width='65px'>Kategori</td>
- <td class='top' width='90px'>Harga Beli</td>
- <td class='top' width='90px'>Harga Jual</td>
- <td class='top' width='20px'>Stok</td>
- <td id='topright' width='145px'>Last Update</td>
- </tr>";
- //Langkah 2: Sesuaikan perintah SQL
- $tampil="select * FROM db_accecoriss limit $posisi,$batas";
- $hasil=mysql_query($tampil);
- $no=$posisi+1;
- $nomor = 0;
- while ($data=mysql_fetch_array($hasil)){
- $id = $data[0];
- $merk = $data[1];
- $kategori = $data[2];
- $hargabeli=number_format($data[3],0,",",".");
- $hargajual=number_format($data[4],0,",",".");
- $stok = $data[5];
- $last_update = $data[6];
- $nomor++;
- echo "<tr bgcolor='#d5d5d5' class='content'>
- <td class='mid_left_content'>$nomor</td>
- <td>$id</td>
- <td>$merk</td>
- <td>$kategori</td>
- <td>Rp $hargabeli</td>
- <td>Rp $hargajual</td>
- <td>$stok</td>
- <td>$last_update</td>
- <td class='mid_right_content'><Input type='checkbox' name='select[]' value='$id'></td>
- </tr>";
- $no++;
- }
- echo"<tr bgcolor='#d5d5d5'><td colspan='8' class='foot_content'><font color='#2E506E'>Input merk atau kategori accecoriss sebagai kata kunci <b>pencarian</b>
- <input type='text' name='keyword_acc' placeholder='search'></font></td></tr>";
- echo"<tr bgcolor='#d5d5d5'>
- <td colspan='8' class='foot_img'>
- <input type='image' name='search' src='../assets/image/b_search.png' alt='cari'>
- <input type='image' name='tambah_produk' src='../assets/image/b_tambah.png' alt='tambah produk'>
- <input type='image' name='search' src='../assets/image/b_delete.png' alt='hapus'>
- <input type='image' name='search' src='../assets/image/b_beli.png' alt='beli'>
- <a href='../interface/editstok/edit_stok_acc.php?select[]=$id'>
- <input type='image' name='search' src='../assets/image/b_edit.png' alt='edit'>
- </a>
- </td>
- </tr>";
- echo"<tr bgcolor='#d5d5d5' class='list_tr'><td colspan='8' align='left' class='foot_content'>";
- //Langkah 3: Hitung total data dan halaman
- $tampil2="select * FROM db_accecoriss";
- $hasil2=mysql_query($tampil2);
- $jmldata=mysql_num_rows($hasil2);
- $jmlhalaman=ceil($jmldata/$batas);
- // Link ke halaman sebelumnya (previous)
- $file="index_cek_stok_acc.php";
- if($halaman > 1){
- $sebelumnya=$halaman-1;
- echo " <a href=$file?halaman=1>First</A> |
- <a href=$file?halaman=$sebelumnya>Prev</a> | ";
- }
- else
- {
- echo "First | Prev | ";
- }
- // Tampilkan link halaman
- $file="index_cek_stok_acc.php";
- for($i=1;$i<=$jmlhalaman;$i++)
- if ($i != $halaman){
- echo " <a href=$file?halaman=$i>$i</a> | ";
- }
- else{
- echo " <b>$i</b> | ";
- }
- // Link kehalaman berikutnya (selanjutnya)
- if($halaman < $jmlhalaman){
- $selanjutnya=$halaman+1;
- echo "<a href=$file?halaman=$selanjutnya> Next</A> |
- <a href=$file?halaman=$jmlhalaman> Last</A> ";
- }
- else{
- echo " Next | Last</td></tr>";
- }
- echo "<tr bgcolor='#d5d5d5'><td colspan='8' class='foot_content'><p><font color='#2E506E'>Total Product : $jmldata Item</font></p></td></tr>";
- echo "<tr bgcolor='#d5d5d5' id='footer_tr'><td colspan='8' class='foot_content'>$date</td></tr>";
- echo "<tr bgcolor='#d5d5d5' id='footer_tr'><td colspan='8' class='foot_content1'>Jika data accecoriss belum terdaftar pada list stok silahkan input data accecoriss terbaru terlebih dahulu <a href='http://localhost/spscounter/template/index_input_hp.php'>disini</a></td></tr>";
- ?>
- </div>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment