ryan/simpro-rssa
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
simpro-rssa/app/cekpeserta/peserta/crud.php
T
root 2b7abf23e8 first commit
2024-08-13 05:44:19 +00:00

244 lines
12 KiB
PHP
Raw Permalink Blame History

<?php
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='nama_satker') {
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$s=pg_query("SELECT nama FROM satuan_kerja
WHERE id='$satuan_kerja_id'");
while($rs=pg_fetch_array($s)) {$n=$rs[0];}
echo $n;
} else
if ($key=='simpan_nd1') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$no_und=$_POST['no_und'];
$tgl_und=$_POST['tgl_und'];
//$tgl_und=str_replace('/','-',$tgl_und);
$tm=date('Y',strtotime($tgl_und));
$bm=date('m',strtotime($tgl_und));
$hm=date('d',strtotime($tgl_und));
$upd=pg_query("UPDATE riwayat_kegiatan SET no_und='$no_und',tgl_und='$tm-$bm-$hm' WHERE id='$riwayat_kegiatan_id'");
} else
if ($key=='approve') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$tenaga_id=$_POST['tenaga_id'];
$tenaga2_id=$_POST['tenaga2_id'];
$a=$_POST['pegawai_id'];
$pecah=explode(',',$a);
foreach($pecah as $selected) {
$cek_peserta2=pg_query("SELECT data_pegawai_id FROM riwayat_peserta WHERE data_pegawai_id='$selected' AND riwayat_kegiatan_id='$riwayat_kegiatan_id'");
$row_peserta2 = pg_fetch_row($cek_peserta2);
if ($row_peserta2[0] > 0) {} else {
$r=pg_query("SELECT tenaga_id,tenaga2_id FROM data_pegawai WHERE id='$selected'");
while($rr=pg_fetch_array($r)) {$tenaga_id=$rr[0];$tenaga2_id=$rr[1];}
$ins_peserta = pg_query("INSERT into riwayat_peserta (
riwayat_kegiatan_id,
data_pegawai_id,
sebagai_id,
status,
tanggal_reg,
satuan_kerja_id,
tenaga_id,
tenaga2_id
) values(
'$riwayat_kegiatan_id',
'$selected',
'1',
'Pending',
NOW(),
'$satuan_kerja_id',
'$tenaga_id',
'$tenaga2_id'
)
");
}
}
} else
if ($key=='delete_peserta') {
$id=$_POST['id'];
$del=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");
} else
if ($key=='cek_quota') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$str=$_POST['str'];
$e=pg_query("SELECT DATE_PART('day', NOW()::timestamp - jatuh_tempo_reg::timestamp) FROM riwayat_kegiatan WHERE id='$riwayat_kegiatan_id'");
while($re=pg_fetch_array($e)) {$jhari=$re[0];}
$c=pg_query("SELECT DISTINCT tenaga_id,(SELECT nama FROM tenaga WHERE id=tenaga_id) FROM bidang WHERE satuan_kerja_id='$satuan_kerja_id'");
while(($rc=pg_fetch_array($c)) !== FALSE) {$n=$rc[1];
if ($rc[0]=='1') {
$j=pg_query("SELECT COALESCE(quota1,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_medis=$rj[0];}
if ($q_medis==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=1 AND status IS NOT NULL");
while($rk=pg_fetch_array($k)) {$tot_quo1=$rk[0];}
echo '<button type="button" class="btn btn-teal btn-rounded vtambah m-r-5" id="tambah_peserta_q_medis"><i class="fa fa-plus m-r-5"></i>'.$n.'<span id="tambah1"> - '.$q_medis.'/'.$tot_quo1.'</span></button>';
}
} else
if ($rc[0]==2) {
$j=pg_query("SELECT COALESCE(quota2,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_nmedis=$rj[0];}
if ($q_nmedis==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=2 AND status IS NOT NULL");
while($rk=pg_fetch_array($k)) {$tot_quo2=$rk[0];}
echo '<button type="button" class="btn btn-teal btn-rounded vtambah m-r-5" id="tambah_peserta_q_nmedis"><i class="fa fa-plus m-r-5"></i>'.$n.'<span id="tambah2"> - '.$q_nmedis.'/'.$tot_quo2.'</span></button>';
}
} else
if ($rc[0]==3) {
$j=pg_query("SELECT COALESCE(quota3,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_perawatan=$rj[0];}
if ($q_perawatan==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=3 AND status IS NOT NULL");
while($rk=pg_fetch_array($k)) {$tot_quo3=$rk[0];}
echo '
<input type="hidden" value='.$jhari.' id="jhari">
<input type="hidden" value='.$str.' id="str">
<input type="hidden" id="q_perawatan" value='.$q_perawatan.'>
<input type="hidden" id="tot_quo3" value='.$tot_quo3.'>
<input type="hidden" value='.$riwayat_kegiatan_id.' id="riwayat_kegiatan_id">
<input type="hidden" value='.$satuan_kerja_id.' id="satuan_kerja_id">
<button type="button" class="btn btn-teal btn-rounded vtambah m-r-5" id="tambah_peserta_q_perawatan"><i class="fa fa-plus m-r-5"></i>'.$n.'<span id="tambah3"> - '.$q_perawatan.'/'.$tot_quo3.'</span></button>';
}
} else
if ($rc[0]==4) {
$j=pg_query("SELECT COALESCE(quota4,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_nperawatan=$rj[0];}
if ($q_nperawatan==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=4 AND status IS NOT NULL");
while($rk=pg_fetch_array($k)) {$tot_quo4=$rk[0];}
echo '<button type="button" class="btn btn-teal btn-rounded vtambah m-r-5" id="tambah_peserta_q_nperawatan"><i class="fa fa-plus m-r-5"></i>'.$n.'<span id="tambah4"> - '.$q_nperawatan.'/'.$tot_quo4.'</span></button>';
}
} else
if ($rc[0]==5) {
$j=pg_query("SELECT COALESCE(quota5,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_pekarya=$rj[0];}
if ($q_pekarya==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=5 AND status IS NOT NULL");
while($rk=pg_fetch_array($k)) {$tot_quo5=$rk[0];}
echo '
<input type="hidden" value='.$jhari.' id="jhari">
<input type="hidden" value='.$str.' id="str">
<input type="hidden" id="q_pekarya" value='.$q_pekarya.'>
<input type="hidden" id="tot_quo5" value='.$tot_quo5.'>
<input type="hidden" value='.$riwayat_kegiatan_id.' id="riwayat_kegiatan_id">
<input type="hidden" value='.$satuan_kerja_id.' id="satuan_kerja_id">
<button type="button" class="btn btn-teal btn-rounded vtambah m-r-5" id="tambah_peserta_q_pekarya"><i class="fa fa-plus m-r-5"></i>'.$n.'<span id="tambah5"> - '.$q_pekarya.'/'.$tot_quo5.'</span></button>';
}
} else {}
}
} else
if ($key=='vready') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$str=$_POST['str'];
if (($satuan_kerja_id==null) || ($satuan_kerja_id=="")) {
$c=pg_query("SELECT DISTINCT tenaga_id FROM bidang");
while(($rc=pg_fetch_array($c)) !== FALSE) {$n=$rc[0];
$upd=pg_query("UPDATE riwayat_peserta SET status='Ready' WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id='$n' AND status IS NOT NULL");
}
} else {
$c=pg_query("SELECT DISTINCT tenaga_id FROM bidang WHERE satuan_kerja_id='$satuan_kerja_id'");
while(($rc=pg_fetch_array($c)) !== FALSE) {$n=$rc[0];
$upd=pg_query("UPDATE riwayat_peserta SET status='Ready' WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id='$n' AND status IS NOT NULL");
}
}
} else
if ($key=='vbatal') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$str=$_POST['str'];
if (($satuan_kerja_id==null) || ($satuan_kerja_id=="")) {
$c=pg_query("SELECT DISTINCT tenaga_id FROM bidang");
while(($rc=pg_fetch_array($c)) !== FALSE) {$n=$rc[0];
$upd=pg_query("UPDATE riwayat_peserta SET status='Pending' WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id='$n' AND status IS NOT NULL");
}
} else {
$c=pg_query("SELECT DISTINCT tenaga_id FROM bidang WHERE satuan_kerja_id='$satuan_kerja_id'");
while(($rc=pg_fetch_array($c)) !== FALSE) {$n=$rc[0];
$upd=pg_query("UPDATE riwayat_peserta SET status='Pending' WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id='$n' AND status IS NOT NULL");
}
}
} else
if ($key=='delete_cv') {
$riwayat_kegiatan_id=$_POST['id'];
$del_cv=pg_query("UPDATE riwayat_kegiatan SET pdf_spt=NULL WHERE id='$riwayat_kegiatan_id'");
}
?>
<script>
$('#tambah_peserta_q_medis').click(function(){
var jhari = $('#jhari').val();
if (jhari>0) {alert('Tanggal pendaftaran sudah lewat..');} else {
var satuan_kerja_id = $('#str').val();
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
var q_medis = $('#q_medis').val();
var tot_quo1 = $('#tot_quo1').val();
var tenaga_id = '1';
var ket = 'Medis';
var jenis_user = 'Bidang';
var ket_id = $('#satuan_kerja_id').val();
$.post('app/info/pendaftaran/tabel_peg.php',{ket_id:ket_id,jenis_user:jenis_user, riwayat_kegiatan_id : riwayat_kegiatan_id, satuan_kerja_id : satuan_kerja_id, tot:q_medis, req:tot_quo1, tenaga_id:tenaga_id, ket:ket},function(html){$("#main_tag").html(html);});
}
});
$('#tambah_peserta_q_nmedis').click(function(){
var jhari = $('#jhari').val();
if (jhari>0) {alert('Tanggal pendaftaran sudah lewat..');} else {
var satuan_kerja_id = $('#str').val();
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
var q_nmedis = $('#q_nmedis').val();
var tot_quo2 = $('#tot_quo2').val();
var tenaga_id = '2';
var ket = 'Non Medis';
var jenis_user = 'Bidang';
var ket_id = $('#satuan_kerja_id').val();
$.post('app/info/pendaftaran/tabel_peg.php',{ket_id:ket_id,jenis_user:jenis_user, riwayat_kegiatan_id : riwayat_kegiatan_id, satuan_kerja_id : satuan_kerja_id, tot:q_nmedis, req:tot_quo2, tenaga_id:tenaga_id, ket:ket},function(html){$("#main_tag").html(html);});
}
});
$('#tambah_peserta_q_perawatan').click(function(){
var jhari = $('#jhari').val();
if (jhari>0) {alert('Tanggal pendaftaran sudah lewat..');} else {
var satuan_kerja_id = $('#str').val();
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
var q_perawatan = $('#q_perawatan').val();
var tot_quo3 = $('#tot_quo3').val();
var tenaga_id = '3';
var ket = 'Perawatan';
var jenis_user = 'Bidang';
var ket_id = $('#satuan_kerja_id').val();
$.post('app/info/pendaftaran/tabel_peg.php',{ket_id:ket_id,jenis_user:jenis_user, riwayat_kegiatan_id : riwayat_kegiatan_id, satuan_kerja_id : satuan_kerja_id, tot:q_perawatan, req:tot_quo3, tenaga_id:tenaga_id, ket:ket},function(html){$("#main_tag").html(html);});
}
});
$('#tambah_peserta_q_nperawatan').click(function(){
var jhari = $('#jhari').val();
if (jhari>0) {alert('Tanggal pendaftaran sudah lewat..');} else {
var satuan_kerja_id = $('#str').val();
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
var q_nperawatan = $('#q_nperawatan').val();
var tot_quo4 = $('#tot_quo4').val();
var tenaga_id = '4';
var ket = 'Non Perawatan';
var jenis_user = 'Bidang';
var ket_id = $('#satuan_kerja_id').val();
$.post('app/info/pendaftaran/tabel_peg.php',{ket_id:ket_id,jenis_user:jenis_user, riwayat_kegiatan_id : riwayat_kegiatan_id, satuan_kerja_id : satuan_kerja_id, tot:q_nperawatan, req:tot_quo4, tenaga_id:tenaga_id, ket:ket},function(html){$("#main_tag").html(html);});
}
});
$('#tambah_peserta_q_pekarya').click(function(){
var jhari = $('#jhari').val();
if (jhari>0) {alert('Tanggal pendaftaran sudah lewat..');} else {
var satuan_kerja_id = $('#str').val();
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
var q_pekarya = $('#q_pekarya').val();
var tot_quo5 = $('#tot_quo5').val();
var tenaga_id = '5';
var ket = 'Pekarya';
var jenis_user = 'Bidang';
var ket_id = $('#satuan_kerja_id').val();
$.post('app/info/pendaftaran/tabel_peg.php',{ket_id:ket_id,jenis_user:jenis_user, riwayat_kegiatan_id : riwayat_kegiatan_id, satuan_kerja_id : satuan_kerja_id, tot:q_pekarya, req:tot_quo5, tenaga_id:tenaga_id, ket:ket},function(html){$("#main_tag").html(html);});
}
});
</script>
Reference in New Issue View Git Blame Copy Permalink