'; $query="SELECT employees.*,position.position_name,shift.shift_name,building.name,spk.keterangan,if(employees.stat='5','Aktif','Resign') statname FROM employees,position,shift,building,spk WHERE employees.spk=spk.kode and employees.position_id=position.position_id AND employees.shift_id=shift.shift_id AND employees.building_id=building.building_id order by employees.id DESC"; $result = $connection->query($query); if($result->num_rows > 0){ $no=0; while ($row= $result->fetch_assoc()) { $no++; echo' ';}} echo'

No	ID Pengguna	Nama	Email	Jabatan	Shift	Lokasi	Tugas	Status	Aksi
'.$no.'	'.$row['employees_code'].'	'.$row['employees_name'].'	'.$row['employees_email'].'	'.$row['position_name'].'	'.$row['shift_name'].'	'.$row['name'].'	'.$row['keterangan'].'	'.$row['statname'].'	'; if($level_user==1){ echo' Ubah Hapus';} else{ echo' Ubah Hapus'; } echo'

Username

Nama

Email

Password

Jabatan

- Pilih -'; $query="SELECT * from position order by position_name ASC"; $result = $connection->query($query); while($row = $result->fetch_assoc()) { echo''.$row['position_name'].''; }echo'

Shift

- Pilih -'; $query="SELECT shift_id,shift_name from shift order by shift_name ASC"; $result = $connection->query($query); while($row = $result->fetch_assoc()) { echo''.$row['shift_name'].''; }echo'

Penempatan

- Pilih -'; $query="SELECT building_id,name,address from building order by name ASC"; $result = $connection->query($query); while($row = $result->fetch_assoc()) { echo''.$row['name'].', '.$row['address'].''; }echo'

Status Penempatan

- Pilih -'; $query="SELECT kode,keterangan from spk"; $result = $connection->query($query); while($row = $result->fetch_assoc()) { echo''.$row['keterangan'].''; }echo'

Status Karyawan

- Pilih -'; $query="SELECT present_id,present_name from present_status where present_id>='5'"; $result = $connection->query($query); while($row = $result->fetch_assoc()) { echo''.$row['present_name'].''; }echo'

Foto

Simpan Batal

'; if(!empty($_GET['id'])){ $id = mysqli_real_escape_string($connection,epm_decode($_GET['id'])); $query ="SELECT * from employees WHERE id='$id'"; $result = $connection->query($query); if($result->num_rows > 0){ $row = $result->fetch_assoc(); echo'