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);
Ejemplo n.º 4
0
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'] : '';