switch ($_POST['proses']) { case 'detail_add': $lokasi = $_SESSION['empl']['lokasitugas']; $entry_by = $_SESSION['standard']['userid']; #Check Header if ($data['jmlh'] == '' || $data['kd_brg'] == '') { echo "Error :Please Complete The Detail Form"; exit; } //echo "warning:".$res;exit(); $sCek = "select notransaksi from " . $dbname . ".pabrik_rawatmesinht where notransaksi='" . $data['noTrans'] . "'"; //echo "warning:".$sCek; $qCek = mysql_query($sCek) or die(mysql_error()); $rCek = mysql_fetch_row($qCek); if ($rCek < 1) { $sIns = "insert into " . $dbname . ".pabrik_rawatmesinht (notransaksi, pabrik, tanggal, shift, statasiun, mesin,kegiatan, jammulai, jamselesai, updateby) \r\n\t\t\tvalues ('" . $data['noTrans'] . "','" . $data['pbrkId'] . "','" . $data['tgl'] . "','" . $data['shft'] . "','" . $data['statid'] . "','" . $data['mesinId'] . "','" . $data['kegiatan'] . "',''" . tanggalsystemd($data['jmAwal']) . "','" . tanggalsystemd($data['jmAkhir']) . "','" . $userOnline . "')"; echo "warning:" . $sIns; if (mysql_query($sIns)) { $sInd = "insert into " . $dbname . ".pabrik_rawatmesindt (notransaksi, kodebarang, satuan, jumlah, keterangan) values ('" . $data['noTrans'] . "','" . $data['kd_brg'] . "','" . $data['satuan'] . "','" . $data['jmlh'] . "','" . $data['ket'] . "')"; if (mysql_query($sInd)) { echo ""; } else { echo "DB Error : " . mysql_error($conn); } } else { echo "DB Error : " . mysql_error($conn); } } else { $sInd = "insert into " . $dbname . ".pabrik_rawatmesindt (notransaksi, kodebarang, satuan, jumlah, keterangan) values ('" . $data['noTrans'] . "','" . $data['kd_brg'] . "','" . $data['satuan'] . "','" . $data['jmlh'] . "','" . $data['ket'] . "')"; //echo "warning:test".$sInd; if (mysql_query($sInd)) {
<?php require_once 'master_validation.php'; require_once 'config/connection.php'; include 'lib/nangkoelib.php'; $koderorg = $_POST['koderorg']; $kapasitasolah = $_POST['kapasitasolah']; $berlakusampai = tanggalsystemd($_POST['berlakusampai']); $jammulai = tanggalsystemd($_POST['jam_mulai']); $jamselesai = tanggalsystemd($_POST['jam_selesai']); $kapasitaslori = $_POST['kapasitaslori']; $method = $_POST['method']; switch ($method) { case 'delete': $strx = "delete from " . $dbname . ".pabrik_5jampengolahan where koderorg='" . $koderorg . "' "; //echo $strx; exit(); break; case 'update': //print_r($_POST); $strx = "update " . $dbname . ".pabrik_5jampengolahan set kapasitasolah='" . $kapasitasolah . "',jammulai='" . $jammulai . "',jamselesai='" . $jamselesai . "',berlakusampai='" . $berlakusampai . "',kapasitaslori=" . $kapasitaslori . " where koderorg='" . $koderorg . "'"; //echo "warning:".$strx; exit(); if (mysql_query($strx)) { echo ""; } else { echo " Gagal," . mysql_error($conn); } break; case 'insert': $sql = "select from " . $dbname . ".pabrik_5jampengolahan where kodeorg='" . $koderorg . "'"; $query = mysql_query($sql) or die(mysql_error()); $res = mysql_fetch_row($query);
session_start(); require_once 'master_validation.php'; require_once 'config/connection.php'; include_once 'lib/nangkoelib.php'; include_once 'lib/zLib.php'; $proses = checkPostGet('proses', ''); $kdPabrik = checkPostGet('kdOrg', ''); $kdStatsiun = checkPostGet('statId', ''); $noTrans = checkPostGet('noTrans', ''); $pbrkId = checkPostGet('pbrkId', ''); $shft = checkPostGet('shft', ''); $statid = checkPostGet('statid', ''); $mesinId = checkPostGet('mesinId', ''); $tgl = tanggalsystem(checkPostGet('tgl', '')); $jmAwal = substr(tanggalsystemd(checkPostGet('jmAwal', '')), 0, 10); $jmAkhir = substr(tanggalsystemd(checkPostGet('jmAkhir', '')), 0, 10); $kdbrg = checkPostGet('kdbrg', ''); $satuan = checkPostGet('satuan', ''); $jmlhMinta = checkPostGet('jmlhMinta', ''); $ketrngn = checkPostGet('ketrngn', ''); $userOnline = $_SESSION['standard']['userid']; $kegiatan = checkPostGet('kgtn', ''); $pbrikId = checkPostGet('kdrg', ''); //$sttId=checkPostGet('',''); $jamMulai = checkPostGet('jamMulai', ''); $mntMulai = checkPostGet('mntMulai', ''); $jamSlsi = checkPostGet('jamSlsi', ''); $mntSlsi = checkPostGet('mntSlsi', ''); $jmAwal = $jmAwal . " " . $jamMulai . ":" . $mntMulai; $jmAkhir = $jmAkhir . " " . $jamSlsi . ":" . $mntSlsi; //exit("Error".$jmAwal);
require_once 'master_validation.php'; require_once 'config/connection.php'; include 'lib/nangkoelib.php'; include_once 'lib/zLib.php'; $supplier_id = isset($_POST['supplier_id']) ? $_POST['supplier_id'] : ''; $proses = isset($_POST['proses']) ? $_POST['proses'] : ''; $nopo = isset($_POST['nopo']) ? $_POST['nopo'] : ''; $tgl_po = isset($_POST['tglpo']) ? tanggalsystem($_POST['tglpo']) : ''; $sub_total = isset($_POST['subtot']) ? $_POST['subtot'] : ''; $disc = isset($_POST['diskon']) ? $_POST['diskon'] : ''; $nilai_dis = isset($_POST['nildiskon']) ? $_POST['nildiskon'] : ''; $pbbkb = isset($_POST['pbbkb']) ? $_POST['pbbkb'] : ''; $npph = isset($_POST['pph']) ? $_POST['pph'] : ''; $nppn = isset($_POST['ppn']) ? $_POST['ppn'] : ''; $chkppn = isset($_POST['chkppn']) ? $_POST['chkppn'] : ''; $tanggl_kirim = isset($_POST['tgl_krm']) ? tanggalsystemd($_POST['tgl_krm']) : ''; $lokasi_krm = isset($_POST['lok_kirim']) ? $_POST['lok_kirim'] : ''; $cr_pembayaran = isset($_POST['cara_pembayarn']) ? $_POST['cara_pembayarn'] : ''; $nilai_po = isset($_POST['grand_total']) ? $_POST['grand_total'] : ''; $purchaser = isset($_POST['purchser_id']) ? $_POST['purchser_id'] : ''; $lokasi_kirim = isset($_POST['lokasi_krm']) ? $_POST['lokasi_krm'] : ''; $persetujuan = isset($_POST['id_user']) ? $_POST['id_user'] : ''; $comment = isset($_POST['cm_hasil']) ? $_POST['cm_hasil'] : ''; $jmlh_realisasi = isset($_POST['jmlh_realisasi']) ? $_POST['jmlh_realisasi'] : ''; $jmlh_diminta = isset($_POST['jmlh_diminta']) ? $_POST['jmlh_diminta'] : ''; $jnopp = isset($_POST['jnopp']) ? $_POST['jnopp'] : ''; $jkdbrg = isset($_POST['jkdbrg']) ? $_POST['jkdbrg'] : ''; $ketUraian = isset($_POST['ketUraian']) ? $_POST['ketUraian'] : ''; $mtUang = isset($_POST['mtUang']) ? $_POST['mtUang'] : ''; $Kurs = isset($_POST['Kurs']) ? $_POST['Kurs'] : ''; $nmSupplier = isset($_POST['nmSupplier']) ? $_POST['nmSupplier'] : '';