-----------------------------Table Login----------------------
CREATE TABLE `login` (
  `userid` varchar(20) NOT NULL,
  `pass` varchar(50) NOT NULL,
  `cabang` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`userid`, `pass`, `cabang`) VALUES
('adminbima', 'd41289e0be0da64cdcefe342554114c1', 'Bima'),
('admindompu', 'd41289e0be0da64cdcefe342554114c1', 'Dompu'),
('adminfinance', '955e233a0dbfeb2df77dd57abd6693ed', 'Pusat'),
('adminmataram', 'd41289e0be0da64cdcefe342554114c1', 'Mataram'),
('adminpraya', 'd41289e0be0da64cdcefe342554114c1', 'Praya'),
('adminselong', 'd41289e0be0da64cdcefe342554114c1', 'Selong'),
('adminsumbawa', 'd41289e0be0da64cdcefe342554114c1', 'Sumbawa'),
('admintaliwang', 'd41289e0be0da64cdcefe342554114c1', 'Taliwang'),
('admintanjung', 'd41289e0be0da64cdcefe342554114c1', 'Tanjung'),
('bu5et', 'd8ac8d4727bf4e782919fb022d275450', 'Pusat');

-- --------------------------------------------------------


---------------------- table staff -----------------------------

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `nik` varchar(20) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `jenkel` varchar(12) NOT NULL,
  `alamat` varchar(70) NOT NULL,
  `telp` varchar(13) NOT NULL,
  `status` varchar(20) NOT NULL,
  `cabang` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--------------------- login -------------------
<?php
session_start();
include"koneksi.php";
$userid = $_POST['userid'];
$psw = md5($_POST['pass']);
$op = $_GET['op'];
if($op=="in"){
$cek = mysqli_query($db,"SELECT * FROM login WHERE userid='$userid' AND pass='$psw'");
if(mysqli_num_rows($cek)==1){
$c = mysqli_fetch_array($cek);

//mendaftarkan session keserver
session_register('userid');
session_register('cabang');

//isi variabel session
$_SESSION['userid'] = $c['userid'];
$_SESSION['cabang'] = $c['cabang'];
if($c['cabang']=="Pusat"){
header("location:../admin/index.php");
}else if($c['cabang']=="Selong" or $c['cabang']=="Praya" or $c['cabang']=="Mataram" or $c['cabang']=="Tanjung" or $c['cabang']=="Sumbawa" or $c['cabang']=="Taliwang" or $c['cabang']=="Dombpu" or $c['cabang']=="Bima"){
header("location:../cabang/index.php");
}
}else{
echo "<script type='text/javascript'> alert('Maaf Username dan Password Anda Tidak Cocok!'); window.location=('index.php'); </script>";
}
}else if($op=="out"){
unset($_SESSION['userid']);
unset($_SESSION['cabang']);
header("location:../index.php");
}
?>
----------------------- tampil data karyawan ------------------------------------------
<?php
session_start();
include"../config/koneksi.php";
$requestData= $_REQUEST;

$nip=$_SESSION['userid'];
$query = mysqli_query($db,"SELECT cabang FROM login where userid='$_SESSION[userid]'");
while ($data = mysqli_fetch_assoc($query)) {}

$columns = array(
	0 => 'nik',
    1 => 'nama',
	2 => 'jenkel',
	3 => 'alamat',
    4 => 'telp',
    5 => 'status',
	6 => 'cabang'
);


$sql = "SELECT nik,nama,jenkel,alamat,telp,status,cabang ";
$sql.=" FROM staff where cabang='Pusat' and cabang='".$_SESSION['cabang']."' ";
$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 where cabang='Pusat' and cabang='".$_SESSION['cabang']."' ";
	$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);

?>