Files
2025-10-09 12:30:11 +07:00

54 lines
3.3 KiB
PHP

<?php
include ('../../koneksi.php');
$id=$_POST['id'];
$data=pg_query("SELECT u.id,u.satuan_kerja_id,u.jabatan_pegawai_id
FROM data_bos u
INNER JOIN satuan_kerja s ON (s.id=u.satuan_kerja_id)
INNER JOIN jabatan_pegawai j ON (j.id=u.jabatan_pegawai_id)
WHERE u.id='$id'");
while($row=pg_fetch_array($data)) {
$id=$row[0];
$satuan_kerja_id=$row[1];
$jabatan_pegawai_id=$row[2];
}
?>
<input type="hidden" id="bos_id" value="<?php echo $id; ?>">
<div class="form-group">
<label for="exampleInputEmail1">Satuan Kerja</label>
<select class="form-control" name="bos_satker" id="bos_satker">
<option></option>
<?php
$ukerja=pg_query("SELECT DISTINCT id,nama FROM satuan_kerja ORDER BY nama ASC");
while($row=pg_fetch_assoc($ukerja)) {
?>
<option <?php if ($satuan_kerja_id==$row['id']) {echo "selected";} ?> value="<?php echo $row['id']; ?>"><?php echo $row['nama']?></option>
<?php
}
?>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1">Kepala Satker</label>
<select class="form-control" name="bos_jabatan" id="bos_jabatan">
<option></option>
<?php
$ukerja=pg_query("SELECT DISTINCT id,nama FROM jabatan_pegawai ORDER BY nama ASC");
while($row=pg_fetch_assoc($ukerja)) {
?>
<option <?php if ($jabatan_pegawai_id==$row['id']) {echo "selected";} ?> value="<?php echo $row['id']; ?>"><?php echo $row['nama']?></option>
<?php
}
?>
</select>
</div>
<script>
//$("#bos_satker").select2();
//$("#bos_jabatan").select2();
</script>