Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include"../config/koneksi.php";
- $requestData= $_REQUEST;
- $columns = array(
- 0 => 'nik',
- 1 => 'nama',
- 2 => 'jenkel',
- 3 => 'alamat',
- 4 => 'telp',
- 5 => 'status',
- 6 => 'cabang'
- );
- $sqlUser = "select cabang from login where userid='".$_SESSION['userid']."'";
- var_dump($sqlUser);// untuk debug bisa dihapus;
- $user = mysql_fetch_array(mysql_query($sqlUser));
- $sql = "SELECT nik,nama,jenkel,alamat,telp,status,cabang ";
- $sql.=" FROM staff where cabang= '".$user['cabang']."' and cabang='Pusat'";
- $query=mysqli_query($db, $sql) or die("karyawan-data.php: get InventoryItems".mysqli_error());
- $totalData = mysqli_num_rows($query);
- $totalFiltered = $totalData;
- if( !empty($requestData['search']['value']) ) {
- $sql = "SELECT nik,nama,jenkel,alamat,telp,status,cabang";
- $sql.=" FROM staff";
- $sql.=" WHERE nama LIKE '".$requestData['search']['value']."%' ";
- $sql.=" OR nik LIKE '".$requestData['search']['value']."%' ";
- $query=mysqli_query($db, $sql) or die("karyawan-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("karyawan-data.php: get PO");
- } else {
- $sql = "SELECT nik,nama,jenkel,alamat,telp,status,cabang ";
- $sql.=" FROM staff staff where cabang= '".$user['cabang']."' and cabang='Pusat'";
- $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
- $query=mysqli_query($db, $sql) or die("karyawan-data.php: get PO".mysqli_error());
- }
- $data = array();
- while( $row=mysqli_fetch_array($query) ) {
- $nestedData=array();
- $nestedData[] = $row["nik"];
- $nestedData[] = $row["nama"];
- $nestedData[] = $row["jenkel"];
- $nestedData[] = $row["alamat"];
- $nestedData[] = $row["telp"];
- $nestedData[] = $row["status"];
- $nestedData[] = $row["cabang"];
- $nestedData[] = '<td><center>
- <a href="karyawan-e.php?nik='.$row['nik'].'" data-toggle="tooltip" title="Edit" class="btn btn-sm btn-warning"> <i class="menu-icon icon-pencil"></i> </a>
- <a href="karyawan.php?hal=hapus&kd='.$row['nik'].'" 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