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 . "'";