drimlen

cek_stok_acc.php

Aug 10th, 2012
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.07 KB | None | 0 0
  1. <html>
  2. <head>
  3. <link rel="stylesheet" href="assets/css/reqformtransaksi.css" type="text/css">
  4. <style>
  5.     #wrapper{
  6.         margin: 150px 0px 50px 0px;
  7.     }
  8.     table{border-collapse:collapse; margin: 0 auto;}
  9.     td, th{border-right:1px solid black;border-top:1px solid black;border-bottom:1px solid black;text-align:center;}
  10.    
  11.     .content{font-family:verdana; font-size:12px; color: #2E506E;}
  12.     .content:hover{background-color: #9DC7ED;}
  13.    
  14.     td{padding: 5px 10px 5px 10px;}
  15.     a{color: #2E506E;text-decoration:none;}
  16.  
  17.     #topleft{-moz-border-radius-topleft:10px;-webkit-border-radius-topleft:10px;-khtml-border-radius-topleft:10px;border-radius-topleft:10px;
  18.  
  19.         border-top: none;border-left:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}
  20.    
  21.     #topright{-moz-border-radius-topright:10px;-webkit-border-radius-topright:10px;-khtml-border-radius-topright:10px;border-radius-topright:10px;
  22.  
  23.         border-top: none;border-right:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}
  24.  
  25.     .top{border-top:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}
  26.  
  27.     .mid_left_content{border-left:none;}
  28.  
  29.     .mid_right_content{border-right:none;}
  30.  
  31.     .foot_content{border-left:none;border-right:none;font-size:12px;text-align:right;font-family:verdana;}
  32.    
  33.     .foot_img{border-left:none;border-right:none;text-align:center;}
  34.  
  35.     .foot_content a{color: #2E506E;text-decoration:none;}  
  36.  
  37.     .foot_content1 a{font-family:verdana;font-size:12;color: #d5d5d5;text-decoration:none;}
  38.  
  39.     .foot_content1 a:hover{text-shadow:1px 1px 7px yellow;}
  40.  
  41.     .foot_content1{font-family:verdana;font-size:12;color: white;text-decoration:none;}
  42.  
  43.     #footer_tr{background-color: #024A68;color: white;font-weight:bold;height:30px;
  44.  
  45.         -moz-border-radius-bottomright:10px;-webkit-border-radius-bottomright:10px;-khtml-border-radius-bottomright:10px;border-radius-bottomright:10px;
  46.         -moz-border-radius-bottomleft:10px;-webkit-border-radius-bottomleft:10px;-khtml-border-radius-bottomleft:10px;border-radius-bottomleft:10px;}
  47.    
  48.     input{text-align:center;padding: 5px 10px 5px 10px;}
  49. </style>
  50. </head>
  51. <body>
  52. <div id='wrapper'>
  53. <table>
  54. <?
  55. error_reporting(1);
  56. include("../connect.php");
  57. //Langkah 1: Tentukan batas,cek halaman & posisi data
  58.         date_default_timezone_set('UTC');
  59.         date_default_timezone_set('Asia/Jakarta');
  60.  
  61.         $date = date("Y-m-d H:i:s");
  62.  
  63. $batas=10;
  64. $halaman=$_GET['halaman'];
  65. if(empty($halaman)){
  66.     $posisi=0;
  67.     $halaman=1;
  68. }
  69. else{
  70.     $posisi = ($halaman-1) * $batas;
  71. }
  72.  
  73. echo "<tr>
  74.         <td id='topleft' width='25px'>No</td>
  75.         <td class='top' width='100px'>Id Accecoriss</td>
  76.         <td class='top' width='110px'>Merk</td>
  77.         <td class='top' width='65px'>Kategori</td>
  78.         <td class='top' width='90px'>Harga Beli</td>
  79.         <td class='top' width='90px'>Harga Jual</td>
  80.         <td class='top' width='20px'>Stok</td>
  81.         <td id='topright' width='145px'>Last Update</td>
  82.       </tr>";
  83.  
  84. //Langkah 2: Sesuaikan perintah SQL
  85. $tampil="select * FROM db_accecoriss limit $posisi,$batas";
  86. $hasil=mysql_query($tampil);
  87.  
  88. $no=$posisi+1;
  89. $nomor = 0;
  90. while ($data=mysql_fetch_array($hasil)){
  91.  
  92.     $id = $data[0];
  93.     $merk = $data[1];
  94.     $kategori = $data[2];
  95.     $hargabeli=number_format($data[3],0,",",".");
  96.     $hargajual=number_format($data[4],0,",",".");
  97.     $stok = $data[5];
  98.     $last_update = $data[6];
  99.     $nomor++;
  100.  
  101.   echo "<tr bgcolor='#d5d5d5' class='content'>
  102.             <td class='mid_left_content'>$nomor</td>
  103.             <td>$id</td>
  104.             <td>$merk</td>
  105.             <td>$kategori</td>
  106.             <td>Rp $hargabeli</td>
  107.             <td>Rp $hargajual</td>
  108.             <td>$stok</td>
  109.             <td>$last_update</td>
  110.             <td class='mid_right_content'><Input type='checkbox' name='select[]' value='$id'></td>
  111.         </tr>";
  112.   $no++;
  113. }
  114. echo"<tr bgcolor='#d5d5d5'><td colspan='8' class='foot_content'><font color='#2E506E'>Input merk atau kategori accecoriss sebagai kata kunci <b>pencarian</b>
  115.         <input type='text' name='keyword_acc' placeholder='search'></font></td></tr>";
  116. echo"<tr bgcolor='#d5d5d5'>
  117.         <td colspan='8' class='foot_img'>
  118.                 <input type='image' name='search' src='../assets/image/b_search.png' alt='cari'>
  119.                 <input type='image' name='tambah_produk' src='../assets/image/b_tambah.png' alt='tambah produk'>
  120.                 <input type='image' name='search' src='../assets/image/b_delete.png' alt='hapus'>
  121.                 <input type='image' name='search' src='../assets/image/b_beli.png' alt='beli'>
  122.             <a href='../interface/editstok/edit_stok_acc.php?select[]=$id'>
  123.                 <input type='image' name='search' src='../assets/image/b_edit.png' alt='edit'>
  124.             </a>
  125.         </td>
  126.     </tr>";
  127. echo"<tr bgcolor='#d5d5d5' class='list_tr'><td colspan='8' align='left' class='foot_content'>";
  128.  
  129. //Langkah 3: Hitung total data dan halaman
  130. $tampil2="select * FROM db_accecoriss";
  131. $hasil2=mysql_query($tampil2);
  132. $jmldata=mysql_num_rows($hasil2);
  133.  
  134. $jmlhalaman=ceil($jmldata/$batas);
  135.  
  136. // Link ke halaman sebelumnya (previous)
  137. $file="index_cek_stok_acc.php";
  138. if($halaman > 1){
  139.     $sebelumnya=$halaman-1;
  140.     echo "  <a href=$file?halaman=1>First</A> |
  141.             <a href=$file?halaman=$sebelumnya>Prev</a> | ";
  142. }
  143. else
  144. {
  145.     echo "First | Prev | ";
  146. }
  147.  
  148. // Tampilkan link halaman
  149. $file="index_cek_stok_acc.php";
  150. for($i=1;$i<=$jmlhalaman;$i++)
  151. if ($i != $halaman){
  152.     echo " <a href=$file?halaman=$i>$i</a> | ";
  153. }
  154. else{
  155.     echo " <b>$i</b> | ";
  156. }
  157.  
  158. // Link kehalaman berikutnya (selanjutnya)
  159. if($halaman < $jmlhalaman){
  160.     $selanjutnya=$halaman+1;
  161.     echo "<a href=$file?halaman=$selanjutnya> Next</A> |
  162.           <a href=$file?halaman=$jmlhalaman> Last</A> ";
  163. }
  164. else{
  165.     echo " Next | Last</td></tr>";
  166. }
  167. echo "<tr bgcolor='#d5d5d5'><td colspan='8' class='foot_content'><p><font color='#2E506E'>Total Product : $jmldata Item</font></p></td></tr>";
  168. echo "<tr bgcolor='#d5d5d5' id='footer_tr'><td colspan='8' class='foot_content'>$date</td></tr>";
  169. 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>";
  170. ?>
  171. </div>
  172. </table>
  173. </body>
  174. </html>
Advertisement
Add Comment
Please, Sign In to add comment