}
break;
case 'update':
$iUpdate = "update " . $dbname . ".vhc_penggantianht set noreferensi='" . $nodok . "',tanggal='" . $tgl_ganti . "',\r\n tanggalkeluar='" . $tgl_keluar . "',downtime='" . $dwnTime . "',kmmasuk='" . $kmmasuk . "',kmkeluar='" . $kmkeluar . "',\r\n kerusakan='" . $descDmg . "',terlambat='" . $terlambat . "' \r\n where notransaksi='" . $trans_no . "' and kodeorg='" . $codeOrg . "' and kodevhc='" . $vhc_code . "' ";
if (mysql_query($iUpdate)) {
updateKmHm($vhc_code);
} else {
echo "DB Error : " . mysql_error($conn);
}
break;
case 'delete':
$qTrans = selectQuery($dbname, 'vhc_penggantianht', "kodevhc", "notransaksi='" . $trans_no . "'");
$resTrans = fetchData($qTrans);
$iDelete = "delete from " . $dbname . ".vhc_penggantianht where notransaksi='" . $trans_no . "'";
if (mysql_query($iDelete)) {
updateKmHm($resTrans[0]['kodevhc']);
} else {
echo "DB Error : " . mysql_error($conn);
}
break;
case 'getListBarang':
echo "<fieldset style='float:left;' >\r\n <legend>" . $_SESSION['lang']['find'] . " " . $_SESSION['lang']['namabarang'] . "</legend>\r\n <table cellspacing=1 border=0 class=data>\r\n <tr>\r\n <td colspan=2>" . $_SESSION['lang']['namabarang'] . "</td>\r\n\r\n <td colspan=5>: \r\n <input type=text id=namaBarangCari class=myinputtext maxlength=100 onkeypress=\"return tanpa_kutip(event);\" style='width:100px;'>\r\n <button class=mybutton onclick=cariListBarang()>cari</button>\r\n <td>\r\n <tr>\r\n </table>\r\n \r\n <table id=listCariBarang >\r\n <thead>\r\n <tr class=rowheader>\r\n <td>No</td>\r\n <td>" . $_SESSION['lang']['kodebarang'] . "</td>\r\n <td>" . $_SESSION['lang']['namabarang'] . "</td>\r\n <td>" . $_SESSION['lang']['satuan'] . "</td>\r\n </tr></thead>";
if ($namaBarangCari == '') {
} else {
$i = "select kodebarang,namabarang from " . $dbname . ".log_5masterbarang where namabarang like '%" . $namaBarangCari . "%'";
$n = mysql_query($i) or die(mysql_error($conn));
while ($d = mysql_fetch_assoc($n)) {
$whBrg = "kodebarang='" . $d['kodebarang'] . "'";
$no += 1;
echo "\r\n <tr class=rowcontent style='cursor:pointer;' title='Click It' onclick=\"moveDataBarang('" . $d['kodebarang'] . "','" . $nmBrg[$d['kodebarang']] . "','" . $satBrg[$d['kodebarang']] . "','" . $dHarga['hargarata'] . "');\">\r\n <td>" . $no . "</td>\r\n <td>" . $d['kodebarang'] . "</td>\r\n <td>" . $nmBrg[$d['kodebarang']] . "</td>\r\n <td>" . $satBrg[$d['kodebarang']] . "</td>\r\n \r\n </tr>";
}
//exit("Error:".$sup);
if (mysql_query($sup)) {
$sKm = "select distinct kmhmakhir from " . $dbname . ".vhc_kmhmakhir_vw where kodevhc='" . $optKdVhc[$notransaksi_head] . "'";
//exit("Error:".$sKm);
$qKm = mysql_query($sKm) or die(mysql_error($conn));
$rKm = mysql_fetch_assoc($qKm);
updateKmHm($optKdVhc[$notransaksi_head]);
echo intval($rKm['kmhmakhir']);
} else {
echo "DB Error : " . mysql_error($conn);
}
break;
case 'deleteKrj':
$delKrj = "delete from " . $dbname . ".vhc_rundt\n\t\t\twhere notransaksi='" . $notransaksi_head . "' and\n\t\t\tjenispekerjaan='" . $jnsPekerjaan . "' and\n\t\t\talokasibiaya='" . $Blok . "' and\n\t\t\tkodesegment='" . $segment . "'";
if (mysql_query($delKrj)) {
updateKmHm($optKdVhc[$notransaksi_head]);
} else {
echo "DB Error : " . mysql_error($conn);
}
break;
case 'insert_operator':
$sCekHt = "select notransaksi from " . $dbname . ".vhc_runht where notransaksi='" . $notransaksi_head . "'";
// echo"warning:".$sCekHt;
$qCekHt = mysql_query($sCekHt) or die(mysql_error());
$rCekHt = mysql_num_rows($qCekHt);
if ($rCekHt < 1) {
echo "warning: Header required";
exit;
}
$sPeriode = "select periode from " . $dbname . ".sdm_5periodegaji where kodeorg='" . substr($rKode['kodeorg'], 0, 4) . "' and periode='" . substr($tglTrans, 0, 4) . "-" . substr($tglTrans, 4, 2) . "'";
# tanggalmulai<".$tglTrans." and tanggalsampai>=".$tglTrans;
