efdb11db3f
Add the main admin, dosen, mahasiswa, API, and service code needed to run the core legacy application with configurable upload storage.
108 lines
3.0 KiB
PHP
108 lines
3.0 KiB
PHP
<?php
|
|
|
|
include 'steven/conf/koneksiPDO.php';
|
|
|
|
$conn = new createCon();
|
|
$dbh = $conn->connect();
|
|
|
|
$sql = "SELECT * FROM tbdosen LEFT JOIN tb_kelompok_keahlian ON tbdosen.kelompokKeahlian = tb_kelompok_keahlian.idKK WHERE status = 'A' AND idDosen != '44' ORDER BY nmLengkap ASC";
|
|
$stmt = $dbh->prepare($sql);
|
|
$stmt->execute();
|
|
|
|
$listData = [];
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
|
|
array_push($listData, $row);
|
|
}
|
|
|
|
?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>Data Dosen Jurusan Informatika Universitas Tanjungpura</title>
|
|
|
|
<link
|
|
rel="stylesheet"
|
|
href="libs/Semantic/Fomantic-UI/semantic.css"
|
|
type="text/css"
|
|
charset="utf-8"
|
|
/>
|
|
|
|
<link
|
|
rel="stylesheet"
|
|
href="libs/DataTable/datatables.min.css"
|
|
type="text/css"
|
|
charset="utf-8"
|
|
/>
|
|
|
|
<script src="libs/jquery-3.3.1.js"></script>
|
|
|
|
<script src="libs/Semantic/Fomantic-UI/semantic.min.js"></script>
|
|
|
|
<script src="libs/DataTable/datatables.min.js"></script>
|
|
</head>
|
|
<body>
|
|
<table id="tabelData" class="ui blue celled unstackable selectable table">
|
|
<thead>
|
|
<tr>
|
|
<th>No</th>
|
|
<th>Foto</th>
|
|
<th>Nama Lengkap</th>
|
|
<th>Nomor Induk</th>
|
|
<th class="two wide">Email</th>
|
|
<th>Kelompok Keahlian</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$no = 1;
|
|
foreach ($listData as $key => $val) {
|
|
$namaDosen = $val['nmLengkap'];
|
|
$nipDosen = $val['nip'];
|
|
if ($nipDosen == '082216717275') {
|
|
$nipDosen = '8885370018';
|
|
}
|
|
|
|
$foto = $val['foto'];
|
|
if(empty($foto)){
|
|
$foto = 'noimageprofile.png';
|
|
}else{
|
|
if(!file_exists('img/'.$foto)){
|
|
$foto = 'noimageprofile.png';
|
|
}
|
|
}
|
|
|
|
$urlFoto = "//spota.untan.ac.id/img/".$foto;
|
|
$namaKK = $val['namaKK'];
|
|
$emailDosen = $val['email'];
|
|
|
|
echo "
|
|
<tr>
|
|
<td>$no</td>
|
|
<td><img class='ui rounded mini image' src='$urlFoto' style='margin:auto auto;'></td>
|
|
<td>$namaDosen</td>
|
|
<td>$nipDosen</td>
|
|
<td>$emailDosen</td>
|
|
<td>$namaKK</td>
|
|
</tr>
|
|
";
|
|
++$no;
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
</body>
|
|
</html>
|
|
|
|
<script>
|
|
/**
|
|
$("#tabelData").dataTable({
|
|
paging: false,
|
|
|
|
lengthChange: false,
|
|
});
|
|
*/
|
|
</script>
|