<?php
if (isset($_POST["tampilkan"])) {
$tglawal = $_POST['tanggal1'];
$tglakhir = $_POST['tanggal2'];
$qu="select a.kode_id,nama_pegawai,a.status_pegawai,a.kode_rekrutmen,b.jenis_kontrak,b.nomor_kontrak,b.jenis_kontrak,a.kode_npp,date_format(b.tglcetak,\"%d-%m-%Y\") as tglcetak "
. "from tbmaspegawai a inner join tbform_pkwt b on a.kode_id=b.kode_id where a.kode_group=10 and approve='Y' and a.status_pegawai in ('PTT','MAGANG','PROFESIONAL') "
. "and b.validasi='F' and b.tglcetak between '$tglawal' and '$tglakhir' order by b.tglcetak desc";
$getdata = dataarray($qu);
}
else
{
$qu="select a.kode_id,nama_pegawai,a.status_pegawai,a.kode_rekrutmen,b.jenis_kontrak,b.nomor_kontrak,b.jenis_kontrak,a.kode_npp,date_format(b.tglcetak,\"%d-%m-%Y\") as tglcetak "
. "from tbmaspegawai a inner join tbform_pkwt b on a.kode_id=b.kode_id where a.kode_group=10 and approve='Y' and a.status_pegawai in ('PTT','MAGANG','PROFESIONAL') and b.validasi='F' "
. "and month(b.tglcetak)=month(curdate()) and year(b.tglcetak)=year(curdate()) order by b.tglcetak desc";
$getdata = dataarray($qu);
}
?>
<div class="content-wrapper">
<div class="row">
<div class="col-md-12">
<div class="callout callout-info">
<form action="" method="post">
<div class="row">
<table>
<tr>
<td>
<label for="exampleInputEmail1" class="col-md-12 col-form-label">Tanggal buat kontrak </label>
</td>
<td>
<input style="width: 100%" type="date" class="form-control" onkeydown="return false" id="tglawal" name="tanggal1" value="
<?php echo date('y-m-d'); ?>" required/>
</td>
<td>
<label class="col-md-12 col-form-label"> s/d </label>
</td>
<td>
<input style="width: 100%" type="date" class="form-control" onkeydown="return false" id="tglawal" name="tanggal2" value="
<?php echo date('y-m-d'); ?>" required/>
</td>
<td style="width: 100%">
<button type='submit' name='tampilkan' class='btn btn-primary'><i class="fa fa-play-circle"> Tampilkan</i></button>
</td>
</tr>
</table>
</div>
</form>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<section class="content">
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Riwayat SK Kontrak</h3>
</div>
<div class="card-body" id="list_mytr" >
<table id="example1" class="table table-bordered table-hover">
<thead>
<tr>
<th>Kode ID</th>
<th>Tgl buat kontrak</th>
<th>Nomor Kontrak</th>
<th>Nama Pegawai</th>
<th>Status</th>
<th>Jenis Kontrak</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if($kodegroup == 10) // Holding
{
foreach ($getdata as $has):
echo "
<tr>
<td>$has[7]</td>
<td>$has[tglcetak]</td>
<td>$has[5]</td>
<td>$has[1]</td>
<td>$has[2]</td>
";
if($has[6] == 'new')
{
echo "<td>Kontrak Baru</td>";
}
else if($has[6] == 'perpanjang')
{
echo "<td>Perpanjangan Kontrak</td>";
}
else if($has[6] == 'adendum')
{
echo "<td>Adendum Kontrak</td>";
}
if($has[4] == 'new')
{
if($has[2] == 'PTT')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='a' class='btn btn-primary btn-xs pull-left download'><i class='fa fa-print sm'></i></a></span>
<input type='text' hidden id='noregpttnew' value=".base64_encode($has[3]).">
|
<span><a target='blank' href='./kontrak/reportsk/offering_letter.php?koderegis=".base64_encode($has[3])."' title='Cetak Offering Letter' class='btn btn-info btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/spk.php?koderegis=".base64_encode($has[3])."' title='Cetak Surat Panggilan Kerja' class='btn btn-warning btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/skk.php?koderegis=".base64_encode($has[3])."' title='Cetak Surat Keterangan Kerja' class='btn btn-default btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
//<span><a type='submit' href='#konfirmasi_kontrak' data-toggle='modal' data-target='#konfirmasi_kontrak' data-id=".$has[3].$has[5]." class='btn btn-primary btn-xs pull-left'><i class='fa fa-check-circle sm'></i></a></span>
}
else if($has[2] == 'MAGANG')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_mg_ho.php?koderegis=".base64_encode($has[3])."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/offering_letter.php?koderegis=".base64_encode($has[3])."' title='Cetak Offering Letter' class='btn btn-info btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/spk.php?koderegis=".base64_encode($has[3])."' title='Cetak Surat Panggilan Kerja' class='btn btn-warning btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/skk.php?koderegis=".base64_encode($has[3])."' title='Cetak Surat Keterangan Kerja' class='btn btn-default btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
else if($has[2] == 'PROFESIONAL')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_pro_ho.php?koderegis=".base64_encode($has[3])."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/offering_letter.php?koderegis=".base64_encode($has[3])."' title='Cetak Offering Letter' class='btn btn-info btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/spk.php?koderegis=".base64_encode($has[3])."' title='Cetak Surat Panggilan Kerja' class='btn btn-warning btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
|
<span><a target='blank' href='./kontrak/reportsk/skk.php?koderegis=".base64_encode($has[3])."' title='Cetak Surat Keterangan Kerja' class='btn btn-default btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
}
else if($has[4] == 'adendum')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_adendum_kontrak_ho.php?koderegis=".base64_encode($has[0])."&nokontrak=".$has[5]."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
else
{
if($has[2] == 'PTT')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_perpanjang_pkwt_ho.php?kodeid=".base64_encode($has[0])."&nokontrak=".$has[5]."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
else if($has[2] == 'MAGANG')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_perpanjang_mg_ho.php?koderegis=".base64_encode($has[0])."&nokontrak=".$has[5]."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
else if($has[2] == 'PROFESIONAL')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_perpanjang_pro_ho.php?koderegis=".base64_encode($has[0])."&nokontrak=".$has[5]."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
else
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_perpanjang.php?kodeid=".base64_encode($has[0])."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
}
endforeach;
?>
<div class="modal fade" id="konfirmasi_kontrak" role="dialog" >
<div class="modal-dialog" role="document">
<button type="button" class="close" data-dismiss="modal">×</button>
<div class="modal-content">
<div class="modal-body">
<font color="black"><div class="fetched-data"></div></font>
</div>
</div>
</div>
</div>
<?php
}
else if($kodegroup == 20) // Holding
{
$levelentitas = $_SESSION["level"];
if($levelentitas == "K")
{
$qu=mysqli_query($con,"select kode_id,nama_pegawai,status_pegawai from tbmaspegawai a inner join tbform_pkwt b on "
. "a.kode_rekrutmen=b.kode_rekrutmen inner join tbmasoutlet c on a.kode_outlet=c.kode_outlet "
. "where c.kode_ub in (select kodemember_klinik from klinikarea where kodebm_klinik='".$kodebm."') and c.entitas='K' and approve='Y'"
. "and status_pegawai in ('PTT','MAGANG BERSERTIFIKAT')");
}
else
{
$qu=mysqli_query($con,"select a.kode_id,nama_pegawai,a.status_pegawai,a.kode_rekrutmen,b.jenis_kontrak,b.nomor_kontrak from tbmaspegawai a inner join tbform_pkwt b on "
. "a.kode_npp=b.kode_npp inner join tbmasoutlet c on a.kode_outlet=c.kode_outlet "
. "where c.kode_bm='".$kodebm."' and approve='Y' and a.status_pegawai in ('PTT')");
}
{
echo "
<tr>
<td>$has[0]</td>
<td>$has[5]</td>
<td>$has[1]</td>
<td>$has[2]</td>
";
if($has[4] == 'new')
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_pkwt.php?koderegis=".base64_encode($has[3])."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
else
{
echo "
<td style='text-align:center'>
<span><a target='blank' href='./kontrak/cetak_kontrak_perpanjang.php?kodeid=".base64_encode($has[0])."' class='btn btn-primary btn-xs pull-left'><i class='fa fa-print sm'></i></a></span>
</td>
</tr>
";
}
}
}
?>
</tbody>
</table>
</div>
</div>
</section>
</div>
</div>
</div>