209 lines
9.8 KiB
PHP
209 lines
9.8 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$jenis=$_POST['jenis'];
|
|
$satker_id=(int)$_POST['satker_id'];
|
|
|
|
// Filter aktif user: default ON (t)
|
|
$aktif_filter = isset($_POST['aktif']) ? $_POST['aktif'] : 't';
|
|
$aktif_filter = ($aktif_filter === 'f') ? 'f' : 't';
|
|
?>
|
|
|
|
<script type="text/javascript">
|
|
$('button[name="edit_user"]').popover();
|
|
$('button[name="nonaktif_user"]').popover();
|
|
$('button[name="aktif_user"]').popover();
|
|
$('button[name="delete_user"]').popover();
|
|
var dtUser = $("#tabel_data_user").DataTable({
|
|
"stateSave": true,
|
|
"paging": true,
|
|
"lengthChange": true,
|
|
"searching": true,
|
|
"ordering": false,
|
|
"info": true,
|
|
"autoWidth": false,
|
|
"destroy": true
|
|
});
|
|
// Inject filter aktif into DataTables controls
|
|
(function(){
|
|
var aktifFilter = <?php echo json_encode($aktif_filter); ?>;
|
|
var $wrapper = $('#tabel_data_user_wrapper');
|
|
var $target = $wrapper.find('.dataTables_filter');
|
|
if ($target.length && !$target.find('#filter_aktif_user').length) {
|
|
$target.append(
|
|
'<span style="margin-left:20px;">' +
|
|
'<label style="margin:0 6px 0 0;">Aktif:</label>' +
|
|
'<select id="filter_aktif_user" class="form-control input-sm" style="width: 140px; display:inline-block;">' +
|
|
'<option value="t">ON</option>' +
|
|
'<option value="f">OFF</option>' +
|
|
'</select>' +
|
|
'</span>'
|
|
);
|
|
}
|
|
$('#filter_aktif_user').val(aktifFilter);
|
|
})();
|
|
</script>
|
|
|
|
<table id="tabel_data_user" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:Arial;font-size:13px">
|
|
<thead>
|
|
<tr style="text-align:center;color:black;font-weight:bold">
|
|
<td>No</td>
|
|
<td width="400">Nama</td>
|
|
<td width="200">Satker</td>
|
|
<td>Username</td>
|
|
<td>Password</td>
|
|
<td width="60">Jenis</td>
|
|
<td width="50">Aktif</td>
|
|
<td align="center" width="60px;">Tools</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$no=1;
|
|
|
|
$where = array();
|
|
$where[] = "u.aktif='$aktif_filter'";
|
|
if ($jenis == 'Kordik') {
|
|
$where[] = "s2.id=$satker_id";
|
|
}
|
|
$whereSql = (count($where) ? ('WHERE '.implode(' AND ', $where)) : '');
|
|
|
|
$data = pg_query("SELECT u.id,s.nama,u.nama,u.password,j.jenis,u.aktif,p.nama,COALESCE(s2.nama,s.nama)
|
|
FROM data_user u
|
|
LEFT OUTER JOIN satuan_kerja s ON (u.satuan_kerja_id=s.id)
|
|
INNER JOIN jenis_user j ON (j.id=u.jenis_user)
|
|
LEFT OUTER JOIN data_pegawai p ON (p.id=u.data_pegawai_id)
|
|
LEFT OUTER JOIN satuan_kerja s2 ON (s2.id=p.satuan_kerja)
|
|
".$whereSql."
|
|
ORDER BY u.id DESC");
|
|
while($row=pg_fetch_array($data)) {
|
|
$jns=$row[4];
|
|
if (($jns=='Staf') || ($jns=='Kordik')) {$nama=$row[6];} else {$nama=$row[1];}
|
|
?>
|
|
<tr>
|
|
<td class="kiri" align="center"><?php echo $no; ?></td>
|
|
<td><?php echo $nama; ?></td>
|
|
<td><?php echo $row[7]; ?></td>
|
|
<td><?php echo $row[2]; ?></td>
|
|
<td><?php echo $row[3]; ?></td>
|
|
<td><?php echo $row[4]; ?></td>
|
|
<td align="center"><?php if ($row[5]=='t') {echo 'ON';} else {echo 'OFF';} ?></td>
|
|
<td class="kanan" align="center">
|
|
<button type="button" name="edit_user" style="height:22px;" class="btn btn-teal btn-xs edit_user" id="<?php echo $row['id'];?>" data-content="Edit Data" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa fa-pencil"></i>
|
|
</button>
|
|
<?php if ($row[4]=='Bidang') { ?>
|
|
<button type="button" name="delete_user" style="height:22px;"class="btn btn-danger btn-xs delete_user" id="<?php echo $row['id'];?>" data-content="Hapus" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<?php } else {} ?>
|
|
<?php if ($row[5]=='t') { ?>
|
|
<button type="button" name="nonaktif_user" style="height:22px;"class="btn btn-danger btn-xs nonaktif_user" id="<?php echo $row['id'];?>" data-content="Nonaktifkan" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<?php } else { ?>
|
|
<button type="button" name="aktif_user" style="height:22px;"class="btn btn-success btn-xs aktif_user" id="<?php echo $row['id'];?>" data-content="Aktifkan" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-refresh"></i>
|
|
</button>
|
|
<?php } ?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
$no++;
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
// Handle filter change (re-load table)
|
|
$(document).off('change', '#filter_aktif_user').on('change', '#filter_aktif_user', function(){
|
|
var sess_jenis = $('#cek_jenis').val();
|
|
var sess_satker = $('#cek_satker').val();
|
|
var sess_aktif = $('#filter_aktif_user').val();
|
|
$('#tabel_user').load("app/master/user/tabel.php",{jenis:sess_jenis,satker_id:sess_satker,aktif:sess_aktif});
|
|
});
|
|
$("#tabel_data_user").on('click','.edit_user',function(){
|
|
var id = $(this).attr('id');
|
|
var sess_jenis = $('#cek_jenis').val();
|
|
var sess_satker = $('#cek_satker').val();
|
|
$('#modal_user').modal('show');
|
|
$('#modal_body_user').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/user/modal.php",
|
|
data: 'id='+id
|
|
+'&jenis='+sess_jenis
|
|
+'&satker_id='+sess_satker,
|
|
success: function(data){
|
|
$('#modal_body_user').html(data);
|
|
$('#nama').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$("#tabel_data_user").on('click','.delete_user',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "delete_user";
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/user/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
var sess_jenis = $('#cek_jenis').val();
|
|
var sess_satker = $('#cek_satker').val();
|
|
var sess_aktif = $('#filter_aktif_user').val();
|
|
$('#tabel_user').load("app/master/user/tabel.php",{jenis:sess_jenis,satker_id:sess_satker,aktif:sess_aktif});
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
$("#tabel_data_user").on('click','.nonaktif_user',function(){
|
|
var x = confirm("Anda yakin ingin menonaktifkan ?");
|
|
if (x) {
|
|
var key = "nonaktif_user";
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/user/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
var sess_jenis = $('#cek_jenis').val();
|
|
var sess_satker = $('#cek_satker').val();
|
|
var sess_aktif = $('#filter_aktif_user').val();
|
|
$('#tabel_user').load("app/master/user/tabel.php",{jenis:sess_jenis,satker_id:sess_satker,aktif:sess_aktif});
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
$("#tabel_data_user").on('click','.aktif_user',function(){
|
|
var x = confirm("Anda yakin ingin mengaktifkan ?");
|
|
if (x) {
|
|
var key = "aktif_user";
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/user/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
var sess_jenis = $('#cek_jenis').val();
|
|
var sess_satker = $('#cek_satker').val();
|
|
var sess_aktif = $('#filter_aktif_user').val();
|
|
$('#tabel_user').load("app/master/user/tabel.php",{jenis:sess_jenis,satker_id:sess_satker,aktif:sess_aktif});
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
</script>
|
|
|