Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include"config/koneksi.php";
- $requestsales= $_REQUEST;
- $columns = array(
- 0 => 'kds',
- 1 => 'nsales',
- 2 => 'tgl_lhir',
- 3 => 'jenkel',
- 4 => 'alamat',
- 5 => 'telp'
- );
- $sql = "SELECT kds,nasales,tgl_lhir,jenkel,alamat,telp ";
- $sql.=" FROM sales";
- $query=mysqli_query($db, $sql) or die("sales-data.php: get InventoryItems".mysqli_error());
- $totalData = mysqli_num_rows($query);
- $totalFiltered = $totalData;
- if( !empty($requestData['search']['value']) ) {
- $sql = "SELECT kds,nasales,tgl_lhir,jenkel,alamat,telp";
- $sql.=" FROM sales";
- $sql.=" WHERE nsales LIKE '".$requestData['search']['value']."%' ";
- $sql.=" OR kds LIKE '".$requestData['search']['value']."%' ";
- $query=mysqli_query($db, $sql) or die("sales-data.php: get PO");
- $totalFiltered = mysqli_num_rows($query);
- $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
- $query=mysqli_query($db, $sql) or die("sales-data.php: get PO");
- } else {
- $sql = "SELECT kds,nasales,tgl_lhir,jenkel,alamat,telp ";
- $sql.=" FROM sales";
- $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
- $query=mysqli_query($db, $sql) or die("sales-data.php: get PO");
- }
- $data = array();
- while( $row=mysqli_fetch_array($query) ) {
- $nestedData=array();
- $nestedData[] = $row["kds"];
- $nestedData[] = $row["nsales"];
- $nestedData[] = $row["tgl_lhir"];
- $nestedData[] = $row["jenkel"];
- $nestedData[] = $row["alamat"];
- $nestedData[] = $row["telp"];
- $nestedData[] = '<td><center>
- <a href="edit.php?kd='.$row['kds'].'" data-toggle="tooltip" title="Edit" class="btn btn-sm btn-warning"> <i class="menu-icon icon-pencil"></i> </a>
- <a href="index.php?hal=hapus&kd='.$row['kds'].'" data-toggle="tooltip" title="Hapus" class="btn btn-sm btn-danger"> <i class="menu-icon icon-trash"></i> </a>
- </center></td>';
- $data[] = $nestedData;
- }
- $json_data = array(
- "draw" => intval( $requestData['draw'] ),
- "recordsTotal" => intval( $totalData ),
- "recordsFiltered" => intval( $totalFiltered ),
- "data" => $data
- );
- echo json_encode($json_data);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement