die('Could not connect: ' . mysql_error());
}
$scek2 = "select distinct `persetujuan" . $param['urut'] . "`,`stpersetujuan" . $param['urut'] . "`,tgldibutuhkan from " . $dbname . ".sdm_permintaansdm \r\n where notransaksi='" . $param['notransaksi'] . "'";
//exit("error:".$scek2);
$qcek2 = mysql_query($scek2, $conn) or die(mysql_error($conn));
$rcek2 = mysql_fetch_assoc($qcek2);
$sdt = "select tglakhirdisplay from " . $dbdt . ".sdm_lowongan where nopermintaan='" . $param['notransaksi'] . "'";
//exit("error: ".$sdt);
$qdt = mysql_query($sdt, $conn2) or die(mysql_error());
$rdt = mysql_fetch_assoc($qdt);
$qdata = mysql_query($sdata, $conn) or die(mysql_error($conn));
$rowdata = mysql_num_rows($qdata);
if ($rdt['tglakhirdisplay'] == '') {
$rdt['tglakhirdisplay'] = $rcek2['tgldibutuhkan'];
}
$slisihhari = selisihHari($tglHrini, $rdt['tglakhirdisplay']);
// exit("error:".$slisihhari);
if ($slisihhari > 0) {
if ($rcek2['stpersetujuan' . $param['urut']] != 0) {
exit("error: Data Sudah Ada Perrsetujuan");
}
}
$sins = "update " . $dbname . ".sdm_permintaansdm set `stpersetujuan" . $param['urut'] . "`='1' \r\n where notransaksi='" . $param['notransaksi'] . "' and `persetujuan" . $param['urut'] . "`='" . $rcek2['persetujuan' . $param['urut']] . "'";
if (!mysql_query($sins, $conn)) {
exit("error:" . mysql_error($conn) . "__" . $sins);
}
break;
case 'updateDt':
$scek2 = "select distinct * from " . $dbname . ".sdm_permintaansdm \r\n where notransaksi='" . $param['notransaksi'] . "'";
//exit("error:".$scek2);
$qcek2 = mysql_query($scek2) or die(mysql_error($conn));
$libur = mysql_query("select * from hari_libur where BULAN='{$bulanini}' and YEAR(TANGGAL)='{$tahun}'");
while ($viewdata = mysql_fetch_object($libur)) {
$harilibur = array();
$harilibur = explode(",", $viewdata->TANGGAL);
foreach ($harilibur as $datalibur) {
}
}
$jumlahlibur = count($harilibur);
/* -------------------------------------- */
$getcuti = mysql_query("select * from cuti where NIP_PEGAWAI='{$kp}' and MONTH(TANGGAL_AWAL)='{$bulanini}' and YEAR(TANGGAL_AWAL)='{$tahun}'");
$tanggalcuti = mysql_fetch_object($getcuti);
$tanggalawalcuti = $tanggalcuti->TANGGAL_AWAL;
$tanggalakhircuti = $tanggalcuti->TANGGAL_AKHIR;
$tgl1 = $tanggalawalcuti;
$tgl2 = $tanggalakhircuti;
$jumlahcuti = selisihHari($tgl1, $tgl2);
if ($jumlahcuti < 0) {
$hasiljumlahcuti = 0;
}
if ($jumlahcuti > 0) {
$hasiljumlahcuti = $jumlahcuti;
}
/* -------------------------------------- */
$uang_makan_transport = $objectdata->NOMINAL_UMT * $jumlahmasuk;
$takehomepay = getthp($NIP) - ($hutang->hutangnya + $nominalpinjaman + $objectdata->TABUNGAN);
$hitungjumlahharikerja = $hari - $jumlahminggu - $jumlahlibur;
$mangkir = $hitungjumlahharikerja - $jumlahmasuk - $hasiljumlahcuti;
if ($mangkir < 0) {
$hasil = 0;
}
if ($mangkir > 0) {
// tanggal, bulan, tahun
$pecah2 = explode("-", $tglAkhir);
$date2 = $pecah2[2];
$month2 = $pecah2[1];
$year2 = $pecah2[0];
//exit("error:".$tglAwal."___".$tglAkhir);
// mencari selisih hari dari tanggal awal dan akhir
$jd1 = GregorianToJD($month1, $date1, $year1);
$jd2 = GregorianToJD($month2, $date2, $year2);
$selisih = $jd2 - $jd1;
// menghitung selisih hari yang bukan tanggal merah dan hari minggu
return $selisih;
}
$awl = $periode . "-01";
$akhr = $periodesmp . "-01";
$seltgl = selisihHari($awl, $akhr);
//exit("error:\n Periode Salah".$seltgl);
if ($seltgl < 0) {
exit("error:\n Periode Salah");
}
if ($seltgl > 365) {
exit("error:\n Lebih dari satu tahun");
}
//get data kod budget barang
$data = array();
$unitId = $_SESSION['lang']['all'];
$nmPrshn = "Holding";
$purchaser = $_SESSION['lang']['all'];
if ($periode != '' || $periodesmp != '') {
$where = " left(b.tanggal,7) between '" . $periode . "' and '" . $periodesmp . "'";
$whereb = " and left(b.tanggal,7) between '" . $periode . "' and '" . $periodesmp . "'";
