<?php
session_start();
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'config/connection.php';
if ($_POST['proses'] == 'createTable') {
# Get Data
$query = selectQuery($dbname, 'pabrik_rawatmesindt', "*", "`notransaksi`='" . $_POST['noTrans'] . "'");
$data = fetchData($query);
# Create Detail Table
createTabDetail($_POST['noTrans'], $data);
} else {
$data = $_POST;
unset($data['proses']);
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 . "')";
$sql = "insert into " . $dbname . ".log_podt (`nopo`,`kodebarang`,`nopp`)\r\n values ('" . $nopo . "','" . $isi . "','" . $_POST['nopp'][$row] . "')";
// echo "warning:".$sql;exit();
if (!mysql_query($sql)) {
echo $sql . "-----";
echo "Gagal," . mysql_error($conn);
exit;
} else {
$sUpdate = "update " . $dbname . ".log_prapodt set create_po=1 where nopp='" . $_POST['nopp'][$row] . "' and kodebarang='" . $isi . "'";
if (!mysql_query($sUpdate)) {
echo "Gagal," . mysql_error($conn);
exit;
}
}
}
echo $nopo . "###";
createTabDetail($Rslt, $data);
} else {
echo "DB Error : " . mysql_error($conn);
}
}
if ($_POST['proses'] == 'edit_po') {
$query = "select * from " . $dbname . ".log_podt where nopo='" . $_POST['nopo'] . "'";
//echo $query;exit();
$data = fetchData($query);
createTabEditDetail($_POST['nopo'], $data);
}
if ($_POST['proses'] == 'listPp') {
$kode_pt = $_POST['kodept'];
$user_id = $_POST['id_user'];
if ($user_id != $_SESSION['standard']['userid']) {
}
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
if ($_POST['proses'] == 'createTable') {
# Get Data
if ($_POST['saveStat'] == 1) {
$table = "log_prapodt";
$where = "nopp='" . $_POST['id'] . "' and status=0";
} else {
$where = "`nomor`='" . $_POST['id'] . "'";
$table = "log_permintaanhargadt";
$_POST['idPer'] = $_POST['id'];
}
$query = selectQuery($dbname, $table, "*", $where);
$data = fetchData($query);
# Create Detail Table
createTabDetail($_POST['id'], $data);
} else {
$data = $_POST;
unset($data['proses']);
switch ($_POST['proses']) {
case 'detail_add':
# Check Valid Data
if ($data['kdbrg'] == '' or $data['jmlh'] == '') {
echo "Error : Kode Barang, Spesifikasi dan Jumlah Barang Tidak Boleh Kosong";
exit;
}
if ($data['tglDari'] == '') {
$data['tglDari'] = '00-00-0000';
}
if ($data['tglSamp'] == '') {
$data['tglSamp'] = '00-00-0000';
<?php
session_start();
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'config/connection.php';
if ($_POST['proses'] == 'createTable') {
# Get Data
$query = selectQuery($dbname, 'vhc_penggantiandt', "*", "`notransaksi`='" . $_POST['notransaksi'] . "'");
$data = fetchData($query);
# Create Detail Table
createTabDetail($_POST['notransaksi'], $data);
} else {
$data = $_POST;
$tglsdt = tanggalsystem($data['tgl_sdt']);
$rtglpp = tanggalsystem($data['rtgl_pp']);
unset($data['proses']);
switch ($_POST['proses']) {
case 'detail_add':
$lokasi = $_SESSION['empl']['lokasitugas'];
$entry_by = $_SESSION['standard']['userid'];
#Check Header
if ($_POST['tgl'] == '') {
echo "warning: Please complete the form";
exit;
}
if ($data['kd_brg'] == '' or $data['jmlh'] == '') {
echo "Error :Please Complete The Detail Form";
exit;
}
$sql = "select * from " . $dbname . ".vhc_penggantianht where notransaksi='" . $_POST['notransaksi'] . "'";
include_once 'master_validation.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
$kode_cus = checkPostGet('kode_cus', '');
$nama = checkPostGet('nama', '');
$telepon = checkPostGet('telepon', '');
$email = checkPostGet('email', '');
$idkontak = checkPostGet('idkontak', '');
$method = checkPostGet('method', '');
$proses = checkPostGet('proses', '');
switch ($proses) {
case 'loadKontakPerson':
$query = selectQuery($dbname, 'pmn_4customercontact', "*", "`kodecustomer`='" . $kode_cus . "'");
$data = fetchData($query);
createTabDetail($kode_cus, $data);
break;
case 'addKontakPerson':
if ($kode_cus == '') {
echo 'Gagal : Kode Pelanggan harus diisi.';
} else {
$sKp = "select * from " . $dbname . ".pmn_4customer where kodecustomer='" . $kode_cus . "'";
if (mysql_num_rows(mysql_query($sKp)) >= 1 && $method == 'insert') {
echo 'Gagal : Kode Pelanggan sudah terdaftar didatabase.';
} else {
if ($nama == '' || $telepon == '' || $email == '') {
echo 'Gagal : Semua field kontak person harus diisi.';
} else {
$sInsertKp = "insert into " . $dbname . ".pmn_4customercontact (kodecustomer,nama,telepon,email) values ('" . $kode_cus . "','" . $nama . "','" . $telepon . "','" . $email . "')";
if (mysql_query($sInsertKp)) {
// createTabDetail(1,2);
}
$idAbn = explode("###", $_POST['absnId']);
// echo"warning:".$idAbn[1]."###".$idAbn[0];exit();
$_SESSION['temp']['OrgKd'] = $idAbn[0];
//exit();
//print_r($_SESSION['temp']['OrgKd']);
//echo "warning:".$_SESSION['temp']['OrgKd'];exit();
$query = selectQuery($dbname, 'sdm_absensidt', "*", "`tanggal`='" . tanggalsystem($idAbn[1]) . "' and `kodeorg`='" . $idAbn[0] . "'");
$data = fetchData($query);
# Create Detail Table
/*echo"warning:";
echo"<pre>";
print_r($data);
echo"</pre>";
exit();*/
createTabDetail($_POST['absnId'], $data);
} else {
$data = $_POST;
unset($data['proses']);
switch ($_POST['proses']) {
case 'detail_add':
if (isset($_SESSION['temp']['OrgKd'])) {
unset($_SESSION['temp']['OrgKd']);
}
#Check Header
$tmp = explode("###", $_POST['absnId']);
$kdOrg = $tmp[0];
$_SESSION['temp']['OrgKd'] = $kdOrg;
//echo "warning:".$_SESSION['temp']['OrgKd'];exit();
$tgl = tanggalsystem($tmp[1]);
$sql = "select kodeorg,tanggal from " . $dbname . ".sdm_absensiht where tanggal='" . $tgl . "' and kodeorg='" . $kdOrg . "'";
