<?php

include '../../koneksi.php';
session_start();


$status_kp = $_POST['status_kp'];
$nik = $_POST['nik'];

if(empty($_POST['nitk'])) $_POST['nitk'] = '-';
$nitk = $_POST['nitk'];

// Cek user Exists
$sql = "SELECT * FROM pegawai WHERE pegawai_nik = '" . $nik . "' or pegawai_nitk = '" . $nitk . "'";
$query = mysqli_query($koneksi, $sql) or die(mysqli_error($koneksi));
$count = mysqli_num_rows($query);



$nama = $_POST['nama'];
$tpl = $_POST['tpl'];
$tgl = $_POST['tgl'];
$jk = $_POST['jk'];
$agama = $_POST['agama'];
$status = $_POST['status'];

$fakultas = $_POST['fakultas'];
$program_studi = $_POST['program_studi'];
$bagian = $_POST['bagian'];
$alamat = $_POST['alamat'];
$bagian = $_POST['bagian'];
$pendidikan = $_POST['pendidikan'];
$vaksin = $_POST['vaksin'];

$golongan = $_POST['golongan'];
$tmt_golongan = $_POST['tmt_golongan'];
$tmtd = $_POST['tmtd'];
$notmtd = $_POST['notmtd'];
$kontak = $_POST['kontak'];
$email = $_POST['email'];

$jabatan = $_POST['jabatan'];


$gelar = $_POST['gelar'];
$gelar2 = $_POST['gelar2'];
$ktp = $_POST['ktp'];
$kk = $_POST['kk'];
$npwp = $_POST['npwp'];
$bpjs = $_POST['bpjs'];
$alamat2 = $_POST['alamat2'];
$email2 = $_POST['email2'];
$kompetensi = $_POST['kompetensi'];
$anak = $_POST['anak'];
$ibu = $_POST['ibu'];
$pasangan = $_POST['pasangan'];
$darah = $_POST['darah'];
$rekening = $_POST['rekening'];





if(empty($_POST['nomor'])) $_POST['nomor'] = '-';
$nomor = $_POST['nomor'];

if(empty($_POST['no_golongan'])) $_POST['no_golongan'] = '-';
$no_golongan = $_POST['no_golongan'];

if(empty($_POST['anak'])) $_POST['anak'] = '-';
$anak = $_POST['anak'];

if(empty($_POST['pasangan'])) $_POST['pasangan'] = '-';
$pasangan = $_POST['pasangan'];


if(empty($_POST['gelar'])) $_POST['gelar'] = '';
$gelar = $_POST['gelar'];

if(empty($_POST['gelar2'])) $_POST['gelar2'] = '';
$gelar2 = $_POST['gelar2'];

if(empty($_POST['npwp'])) $_POST['npwp'] = '-';
$npwp = $_POST['npwp'];

if(empty($_POST['bpjs'])) $_POST['bpjs'] = '-';
$bpjs = $_POST['bpjs'];

if(empty($_POST['email2'])) $_POST['email2'] = '-';
$email2 = $_POST['email2'];

if(empty($_POST['kompetensi'])) $_POST['kompetensi'] = '-';
$kompetensi = $_POST['kompetensi'];

$tmtjabatan = $_POST['tmtjabatan'];
if(empty($_POST['tmtjabatan'])) $_POST['tmtjabatan'] = '-';

$tmtjabatan_selesai = $_POST['tmtjabatan_selesai'];
if(empty($_POST['tmtjabatan_selesai'])) $_POST['tmtjabatan_selesai'] = '-';




if(empty($_POST['nojabatan'])) $_POST['nojabatan'] = '-';
$nojabatan = $_POST['nojabatan'];
$almamater = $_POST['almamater'];
$tahun_lulus = $_POST['tahun_lulus'];
$id_user = $_POST['petugas'];


if($count > 0) {
	$msg = 'NIK/NITK Pegawai Sudah Ada Di Database';
	$_SESSION['error'] = $msg;
	header("location:pegawai.php");
}else{








$rand = rand();
$allowed =  array('gif','png','jpg','jpeg');
$filename = $_FILES['foto']['name'];










if($filename == ""){

	mysqli_query($koneksi,"INSERT INTO pegawai VALUES(NULL,'$status_kp', '$nik', '$nitk','$nama', '$tpl', '$tgl','$jk', '$agama', '$status',  '$bagian', '$fakultas','$jabatan', '$tmtjabatan','$tmtjabatan_selesai','$nojabatan','$golongan', '$tmt_golongan', '$no_golongan','$pendidikan', '$program_studi', '$tahun_lulus', '$almamater','$notmtd', '$tmtd','$kontak', '$alamat', '$email','$gelar','$gelar2','$ktp','$npwp','$bpjs','$kk','$rekening','$darah','$alamat2','$email2','$pasangan','$ibu','$anak','$kompetensi','$vaksin', '$nomor','','$id_user')")or die(mysqli_error($koneksi));

	header("location:pegawai.php?alert=berhasil");

}else{
	$ext = pathinfo($filename, PATHINFO_EXTENSION);

	if(!in_array($ext,$allowed) ) {
		header("location:pegawai.php?alert=gagal");
	}else{
		move_uploaded_file($_FILES['foto']['tmp_name'], '../file/foto/'.$rand.'_'.$filename);
	$file_gambar = $rand.'_'.$filename;
		
		mysqli_query($koneksi,"INSERT INTO pegawai VALUES(NULL,'$status_kp', '$nik', '$nitk','$nama', '$tpl', '$tgl','$jk', '$agama', '$status',  '$bagian', '$fakultas','$jabatan', '$tmtjabatan','$tmtjabatan_selesai','$nojabatan','$golongan', '$tmt_golongan', '$no_golongan','$pendidikan', '$program_studi', '$tahun_lulus', '$almamater','$notmtd', '$tmtd','$kontak', '$alamat', '$email','$gelar','$gelar2','$ktp','$npwp','$bpjs','$kk','$rekening','$darah','$alamat2','$email2','$pasangan','$ibu','$anak','$kompetensi','$vaksin', '$nomor','$file_gambar','$id_user')")or die(mysqli_error($koneksi));

		header("location:pegawai.php?alert=berhasil");

	}
}
}
?>