<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
require_once 'lib/zLib.php';
require_once 'lib/fpdf.php';
//$proses=$_GET['proses'];
$proses = checkPostGet('proses', '');
$unit = checkPostGet('unit', '');
$tgl1 = tanggalsystemn(checkPostGet('tgl1', ''));
$tgl2 = tanggalsystemn(checkPostGet('tgl2', ''));
$nmOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
$nmBrg = makeOption($dbname, 'log_5masterbarang', 'kodebarang,namabarang');
$stBrg = makeOption($dbname, 'log_5masterbarang', 'kodebarang,satuan');
$arrPost = array("0" => "Not Posted", "1" => "Posting");
if ($tgl1 == '--') {
$tgl1 = '';
}
if ($tgl2 == '--') {
$tgl2 = '';
}
$golkar = makeOption($dbname, 'datakaryawan', 'karyawanid', 'kodegolongan');
$namagol = makeOption($dbname, 'sdm_5golongan', 'kodegolongan', 'namagolongan');
$namatipe = makeOption($dbname, 'sdm_5tipekaryawan', 'id,tipe');
$sGetKary = "select sum(c.jumlah) as jumlah,a.kodegolongan,a.karyawanid,a.nik,b.namajabatan,a.namakaryawan,a.tipekaryawan,\r\n subbagian from " . $dbname . ".datakaryawan a \r\n left join " . $dbname . ".sdm_5jabatan b on a.kodejabatan=b.kodejabatan \r\n left join " . $dbname . ".sdm_5gajipokok c on a.karyawanid=c.karyawanid\r\n where (tanggalkeluar>'" . $tgl1 . "' or tanggalkeluar='0000-00-00') and lokasitugas='{$unit}' and \r\n a.tipekaryawan in ('1','2','3','4') group by a.karyawanid order by namakaryawan asc";
//echo $sGetKary;
//$sGetKar="";
//echo $sGetKary; exit;
$rGetkary = fetchData($sGetKary);
foreach ($rGetkary as $row => $kar) {
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
$pt = $_POST['pt'];
$gudang = $_POST['gudang'];
$tanggalpivot = $_POST['tanggalpivot'];
$statuspo = $_POST['statuspo'];
$tanggalv = tanggalsystemn($_POST['tanggalpivot']);
$supkontran = $_POST['supkontran'];
if ($gudang != '') {
$whereGudang = " and a.kodeorg = '" . $gudang . "'";
} else {
$whereGudang = "";
}
if ($pt != '') {
$wherePt = " and a.kodeorg = '" . $pt . "'";
} else {
$wherePt = "";
}
if ($statuspo != '') {
if ($statuspo == 1) {
$wherePo = " and b.lokalpusat = '1'";
} else {
$wherePo = " and (b.lokalpusat = '0' or b.lokalpusat is null)";
}
} else {
$wherePo = "";
}
if ($supkontran != '') {
//indraaaa
case 'data_refresh':
//exit("Error:MASUK");
$limit = 20;
$page = 0;
if (isset($_POST['page'])) {
$page = $_POST['page'];
if ($page < 0) {
$page = 0;
}
}
$offset = $page * $limit;
if ($_POST['txtSearch'] != '') {
$where .= "and nopp LIKE '%" . $_POST['txtSearch'] . "%' ";
} elseif ($_POST['tglCari'] != '') {
$where .= "and tanggal LIKE '%" . (!empty($_POST['tglCari']) ? tanggalsystemn($_POST['tglCari']) : '') . "%' ";
}
if ($_POST['pembuat'] != '') {
$where .= " and dibuat='" . $_POST['pembuat'] . "'";
}
if ($_POST['pembuat'] != '') {
$where .= " and dibuat='" . $_POST['pembuat'] . "'";
}
if ($_POST['nmbrg'] != '') {
$where .= "and nopp in (select nopp from " . $dbname . ".log_prapodt where kodebarang in (select distinct kodebarang from " . $dbname . ".log_5masterbarang where namabarang like '%" . $_POST['nmbrg'] . "%'))";
}
/*if($_SESSION['org']['tipeinduk']=='HOLDING')
{
//close = '1'
$str="SELECT * FROM ".$dbname.".log_prapoht where close!=2 ".$where." and (persetujuan1='".$_SESSION['standard']['userid']."' or persetujuan2='".$_SESSION['standard']['userid']."' or persetujuan3='".$_SESSION['standard']['userid']."' or persetujuan4='".$_SESSION['standard']['userid']."' or persetujuan5='".$_SESSION['standard']['userid']."')
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
require_once 'lib/zLib.php';
require_once 'lib/fpdf.php';
$proses = $_GET['proses'];
$kdpabrik = $_POST['kdpabrik'];
$tgl1 = tanggalsystemn($_POST['tgl1']);
$tgl2 = tanggalsystemn($_POST['tgl2']);
if ($proses == 'excel' or $proses == 'pdf') {
$tgl1 = tanggalsystemn($_GET['tgl1']);
$tgl2 = tanggalsystemn($_GET['tgl2']);
$kdpabrik = $_GET['kdpabrik'];
}
$optnmor = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
$optjnvhc = makeOption($dbname, 'vhc_5jenisvhc', 'jenisvhc,namajenisvhc');
$optnmbar = makeOption($dbname, 'log_5masterbarang', 'kodebarang,namabarang');
$optnamacostumer = makeOption($dbname, 'log_5supplier', 'kodetimbangan,namasupplier');
if ($proses == 'preview' or $proses == 'excel' or $proses == 'pdf') {
if ($tgl1 == '' or $tgl2 == '') {
echo "Error: Tanggal tidak boleh kosong";
exit;
} else {
if ($tgl1 > $tgl2) {
echo "Error: Tanggal pertama tidak boleh lebih besar dari tanggal kedua";
exit;
}
}
}
function simpanData($x, $jenisdata)
{
global $dbname;
global $conn;
global $pemisah;
$jlhbaris = count($x) - 1;
#baris pertama adalah header;
foreach ($x[0] as $val) {
$header[] = trim($val);
}
switch ($jenisdata) {
case 'ACCBAL':
#ambil noakun
$str = "select noakun from " . $dbname . ".keu_5akun where length(noakun)=7";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$noakun[] = $bar->noakun;
}
#periksa kelengkapan data
if (count($x[0]) != 4) {
exit("Error: Form not valid");
}
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
if ($header[$ids] == 'periode' and strlen($rinc) != 6) {
exit("Error: some data on period not valid (line " . $key . ")");
} else {
if ($header[$ids] == 'noakun' and strlen($rinc) != 7) {
exit("Error: some data on noakun not valid (line " . $key . ")");
} else {
if ($header[$ids] == 'kodeorg' and strlen($rinc) != 4) {
exit("Error: some data on kodeorg not valid (line " . $key . $rinc . ")");
} else {
if ($header[$ids] == 'noakun') {
#periksa noakun yang disubmit
$akunbermasalah[$rinc] = $rinc;
foreach ($noakun as $bb => $cc) {
if ($cc == $rinc) {
unset($akunbermasalah[$rinc]);
}
}
}
}
}
}
}
}
}
if (count($akunbermasalah) > 0) {
echo "The following account number were not defined:<br>";
print_r($akunbermasalah);
exit;
}
#ambil kolom periode
foreach ($header as $ki => $val) {
if ($val == 'periode') {
$index = $ki;
}
if ($val == 'kodeorg') {
$idkOrg = $ki;
}
}
$column = 'awal' . substr($x[1][$index], 4, 2);
foreach ($header as $ki => $val) {
if ($val == 'saldo') {
$header[$ki] = $column;
$indexNumeric = $ki;
}
}
#delete first
$str = "delete from " . $dbname . ".keu_saldobulanan where kodeorg='" . $x[1][$idkOrg] . "' and periode='" . $x[1][$index] . "'";
mysql_query($str);
#generate SQL:
$stringSQL = "insert into " . $dbname . ".keu_saldobulanan(";
foreach ($header as $ki => $val) {
if ($ki == 0) {
$stringSQL .= $val;
} else {
$stringSQL .= "," . $val;
}
}
$stringSQL .= ") values";
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ki => $val) {
if ($ki == 0) {
if ($key == 1) {
$stringSQL .= "('" . trim($val) . "'";
} else {
$stringSQL .= ",('" . trim($val) . "'";
}
} else {
$stringSQL .= ",'" . trim($val) . "'";
}
}
$stringSQL .= ")";
}
}
$stringSQL .= ";";
if (mysql_query($stringSQL)) {
echo "Uploaded";
} else {
echo mysql_error($conn) . $stringSQL;
}
break;
#===========================================================end prevbal ======================================================
#===========================================================end prevbal ======================================================
case 'JOURNAL':
#ambil noakun
$str = "select noakun from " . $dbname . ".keu_5akun where length(noakun)=7";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$noakun[] = $bar->noakun;
}
#ambil nik
$str = "select karyawanid from " . $dbname . ".datakaryawan";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$nik[] = $bar->karyawanid;
}
#ambil kegiatan
$str = "select kodekegiatan from " . $dbname . ".setup_kegiatan";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$kegiatan[] = $bar->kodekegiatan;
}
#ambil supplier
$str = "select supplierid from " . $dbname . ".log_5supplier";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$supplier[] = $bar->supplierid;
}
#ambil custommer
$str = "select kodecustomer from " . $dbname . ".pmn_4customer";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$custommer[] = $bar->kodecustomer;
}
#ambil blok
$str = "select kodeorg from " . $dbname . ".setup_blok";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$blok[] = $bar->kodeorg;
}
#periksa kelengkapan data
$zz = 0;
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
$x[$key][$ids] = trim($rinc);
if ($header[$ids] == 'tanggal') {
$rinc = str_replace('-', '', $rinc);
$rinc = str_replace('/', '', $rinc);
if (strlen($rinc) != 8) {
exit("Error: some data on date not valid (line " . $key . ")");
} else {
if (substr($rinc, 0, 4) < '2000') {
exit("Error: date not valid (line " . $key . ")");
} else {
$x[$key][$ids] = $rinc;
}
}
}
if ($header[$ids] == 'noakun' and strlen($rinc) != 7 and $rinc != '0') {
exit("Error: some data on noakun not valid (line " . $key . ")");
}
if ($header[$ids] == 'kodeorg' and strlen($rinc) != 4) {
exit("Error: some data on kodeorg not valid (line " . $key . ")");
}
if ($header[$ids] == 'matauang') {
if (trim($rinc) == '') {
exit("Error: some data on currency not valid (line " . $key . ")");
}
}
if ($header[$ids] == 'kurs') {
if (trim($rinc) == '') {
$x[$key][$ids] = 1;
}
}
if ($header[$ids] == 'nourut') {
if (trim($rinc) == '') {
$x[$key][$ids] = $zz++;
}
}
if ($header[$ids] == 'noakun') {
#periksa noakun yang disubmit
$akunbermasalah[$rinc] = $rinc;
foreach ($noakun as $bb => $cc) {
if ($cc == $rinc or trim($rinc) == '0') {
unset($akunbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'nik' and trim($rinc) != '') {
#periksa nik yang disubmit
$nikbermasalah[$rinc] = $rinc;
foreach ($nik as $bb => $cc) {
if ($cc == $rinc) {
unset($nikbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kodekegiatan' and trim($rinc) != '') {
$kegiatanbermasalah[$rinc] = $rinc;
foreach ($kegiatan as $bb => $cc) {
if ($cc == $rinc) {
unset($kegiatanbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kodesupplier' and trim($rinc) != '') {
$supplierbermasalah[$rinc] = $rinc;
foreach ($supplier as $bb => $cc) {
if ($cc == $rinc) {
unset($supplierbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kodecustomer' and trim($rinc) != '') {
$custommerbermasalah[$rinc] = $rinc;
foreach ($custommer as $bb => $cc) {
if ($cc == $rinc) {
unset($custommerbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kodeblok' and trim($rinc) != '') {
$blokbermasalah[$rinc] = $rinc;
foreach ($blok as $bb => $cc) {
if ($cc == $rinc) {
unset($blokbermasalah[$rinc]);
}
}
}
}
}
}
$bermasalah = false;
if (count($akunbermasalah) > 0) {
echo "The folowing account number were not defined:<br>";
print_r($akunbermasalah);
$bermasalah = true;
}
if (count($nikbermasalah) > 0) {
echo "The folowing NIK were not defined:<br>";
print_r($nikbermasalah);
$bermasalah = true;
}
if (count($kegiatanbermasalah) > 0) {
echo "The folowing activity code were not defined:<br>";
print_r($kegiatanbermasalah);
$bermasalah = true;
}
if (count($supplierbermasalah) > 0) {
echo "The folowing supplier/contractor code were not defined:<br>";
print_r($supplierbermasalah);
$bermasalah = true;
}
if (count($custommerbermasalah) > 0) {
echo "The folowing custommer code were not defined:<br>";
print_r($custommerbermasalah);
$bermasalah = true;
}
if (count($blokbermasalah) > 0) {
echo "The folowing block code were not defined:<br>";
print_r($blokbermasalah);
$bermasalah = true;
}
if ($bermasalah) {
exit;
}
#periksa jumlah debet dan kredit
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
if ($header[$ids] == 'jumlah') {
$total += $rinc;
$tt += abs($rinc);
}
}
}
}
$tdecre = $tt / 2;
if (abs($total) > 100) {
exit("Error:Total amount not balance:" . $total);
}
#create header journal
#ambil kolom periode
foreach ($header as $ki => $val) {
if ($val == 'tanggal') {
$itanggal = $ki;
}
if ($val == 'nojurnal') {
$inojurnal = $ki;
}
if ($val == 'kurs') {
$ikurs = $ki;
}
if ($val == 'matauang') {
$imatauang = $ki;
}
if ($val == 'noreferensi') {
$inoreferensi = $ki;
}
}
// #delete first
$str = "delete from " . $dbname . ".keu_jurnalht where nojurnal='" . $x[2][$inojurnal] . "'";
mysql_query($str);
#generate header journal
$str = "insert into " . $dbname . ".keu_jurnalht (`nojurnal`, `kodejurnal`, `tanggal`, `tanggalentry`, `posting`, `totaldebet`, `totalkredit`, `amountkoreksi`, `noreferensi`, `autojurnal`, `matauang`, `kurs`, `revisi`) VALUES\n ('" . $x[2][$inojurnal] . "', 'Hist', '" . $x[2][$itanggal] . "', '" . date('Ymd') . "', 1," . $tdecre . ", -" . $tdecre . ", '0', '" . $x[2][$inoreferensi] . "', 1, '" . $x[2][$imatauang] . "', " . $x[2][$ikurs] . ", 0);";
// #generate detail SQL:
$stringSQL = "insert into " . $dbname . ".keu_jurnaldt(";
foreach ($header as $ki => $val) {
if ($ki == 0) {
$stringSQL .= $val;
} else {
$stringSQL .= "," . $val;
}
}
$stringSQL .= ") values";
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ki => $val) {
if ($ki == 0) {
if ($key == 1) {
$stringSQL .= "('" . trim($val) . "'";
} else {
$stringSQL .= ",('" . trim($val) . "'";
}
} else {
$stringSQL .= ",'" . trim($val) . "'";
}
}
$stringSQL .= ")";
}
}
$stringSQL .= ";";
if (mysql_query($str)) {
#insert header
if (mysql_query($stringSQL)) {
#insert detail
echo "Uploaded";
} else {
echo "Error insert detail " . mysql_error($conn) . $stringSQL;
}
} else {
echo "Error insert header " . mysql_error($conn) . $str;
}
break;
#===========================================================end prevbal ======================================================
#==============================BEGIN MATERIAL
#===========================================================end prevbal ======================================================
#==============================BEGIN MATERIAL
case 'INV':
#ambil blok
$str = "select kodebarang from " . $dbname . ".log_5masterbarang";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$barang[] = $bar->kodebarang;
}
#ambil kodeorganisasi
$str = "select kodeorganisasi from " . $dbname . ".organisasi";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$org[] = $bar->kodeorganisasi;
}
#periksa kelengkapan data
$zz = 0;
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
$x[$key][$ids] = trim($rinc);
}
}
}
foreach ($header as $ki => $val) {
if ($val == 'periode') {
$iperiode = $ki;
}
if ($val == 'kodeorg') {
$ikodeorg = $ki;
}
if ($val == 'kodebarang') {
$ikodebarang = $ki;
}
if ($val == 'saldoakhirqty') {
$isaldoakhirqty = $ki;
}
if ($val == 'hargarata') {
$ihargarata = $ki;
}
if ($val == 'kodegudang') {
$ikodegudang = $ki;
}
}
#periksa periode gudang
$str = "select periode from " . $dbname . ".setup_periodeakuntansi where periode='" . $x[1][$iperiode] . "' and\n kodeorg='" . $x[1][$ikodegudang] . "' and tutupbuku=0";
$res = mysql_query($str);
if (mysql_num_rows($res) < 1) {
exit("Error: Accounting period for " . $x[1][$ikodegudang] . " not defined");
}
#periksa pt apakah terdaftar atau tidak
$kodept = false;
foreach ($org as $bb => $vb) {
if ($x[1][$ikodeorg] == $vb) {
$kodept = true;
}
}
if (!$kodept) {
exit("Error : Company code not found");
}
#periksa kode barang
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
$arrkodemasalah[$arr[$ikodebarang]] = $arr[$ikodebarang];
foreach ($barang as $tt => $gh) {
if ($arr[$ikodebarang] == $gh) {
unset($arrkodemasalah[$arr[$ikodebarang]]);
}
}
if ($arr[$ihargarata] == '0') {
$hargamasalah[$arr[$ikodebarang]] = $arr[$ikodebarang];
}
if ($arr[$isaldoakhirqty] <= '0') {
$qtymasalah[$arr[$isaldoakhirqty]] = $arr[$isaldoakhirqty];
}
}
}
if (count($arrkodemasalah) > 0) {
echo " The folowing material code not defined on material master:";
print_r($arrkodemasalah);
exit;
} else {
if (count($hargamasalah) > 0) {
echo " The folowing material with blank price";
print_r($hargamasalah);
exit;
} else {
if (count($qtymasalah) > 0) {
echo " The folowing material with blank qty";
print_r($qtymasalah);
exit;
}
}
}
// #delete first
$str = "delete from " . $dbname . ".log_5saldobulanan where periode='" . $x[1][$iperiode] . "' and kodegudang='" . $x[1][$ikodegudang] . "'";
mysql_query($str);
$str = "delete from " . $dbname . ".log_5masterbarangdt where kodegudang='" . $x[1][$ikodegudang] . "'";
mysql_query($str);
#generate sql
$stringSQL = "insert into " . $dbname . ".log_5saldobulanan(kodeorg,kodebarang,saldoakhirqty,hargarata,lastuser,periode,\n nilaisaldoakhir,kodegudang,saldoawalqty,hargaratasaldoawal,nilaisaldoawal) values";
$stringSQL1 = "insert into " . $dbname . ".log_5masterbarangdt(kodeorg,kodebarang,saldoqty,hargalastin,\n hargalastout,lastuser,kodegudang) values";
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
if ($key == '1') {
$stringSQL .= "('" . $arr[$ikodeorg] . "','" . $arr[$ikodebarang] . "','" . $arr[$isaldoakhirqty] . "','" . $arr[$ihargarata] . "',0,'" . $arr[$iperiode] . "',\n '" . $arr[$isaldoakhirqty] * $arr[$ihargarata] . "','" . $arr[$ikodegudang] . "','" . $arr[$isaldoakhirqty] . "',\n '" . $arr[$ihargarata] . "','" . $arr[$isaldoakhirqty] * $arr[$ihargarata] . "')";
$stringSQL1 .= "('" . $arr[$ikodeorg] . "','" . $arr[$ikodebarang] . "','" . $arr[$isaldoakhirqty] . "','" . $arr[$ihargarata] . "','" . $arr[$ihargarata] . "',0,\n '" . $arr[$ikodegudang] . "')";
} else {
$stringSQL .= ",('" . $arr[$ikodeorg] . "','" . $arr[$ikodebarang] . "','" . $arr[$isaldoakhirqty] . "','" . $arr[$ihargarata] . "',0,'" . $arr[$iperiode] . "',\n '" . $arr[$isaldoakhirqty] * $arr[$ihargarata] . "','" . $arr[$ikodegudang] . "','" . $arr[$isaldoakhirqty] . "',\n '" . $arr[$ihargarata] . "','" . $arr[$isaldoakhirqty] * $arr[$ihargarata] . "')";
$stringSQL1 .= ",('" . $arr[$ikodeorg] . "','" . $arr[$ikodebarang] . "','" . $arr[$isaldoakhirqty] . "','" . $arr[$ihargarata] . "','" . $arr[$ihargarata] . "',0,\n '" . $arr[$ikodegudang] . "')";
}
}
}
$stringSQL .= ";";
$stringSQL1 .= ";";
//exit($stringSQL."<br>".$stringSQL1);
if (mysql_query($stringSQL)) {
#insert header
if (mysql_query($stringSQL1)) {
#insert detail
echo "Uploaded";
} else {
echo "Error insert masterbarangdt " . mysql_error($conn) . $stringSQL1;
}
} else {
echo "Error insert saldobulanan " . mysql_error($conn) . $stringSQL;
}
break;
#====================================================END INV ================================================
#====================================================END INV ================================================
case 'PO':
#ambil supplier
$str = "select supplierid from " . $dbname . ".log_5supplier";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$supplier[] = $bar->supplierid;
}
#ambil kodeorganisasi
$str = "select kodeorganisasi from " . $dbname . ".organisasi where tipe='PT'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$kodept[] = $bar->kodeorganisasi;
}
#ambil kodeorganisasi
$str = "select kodebarang from " . $dbname . ".log_5masterbarang";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$kdbarang[] = $bar->kodebarang;
}
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
if ($header[$ids] == 'kodeorg' and strlen($rinc) != 3) {
exit("Error: some data on kodeorg not " . $x[$key][$ids] . "___" . $ids . "__" . $key . " valid (line " . $key . ")");
}
if ($header[$ids] == 'matauang') {
if (trim($rinc) == '') {
exit("Error: some data on currency not valid (line " . $key . ")");
}
}
if ($header[$ids] == 'kodesupplier') {
$supplierbermasalah[$rinc] = $rinc;
foreach ($supplier as $bb => $cc) {
if ($cc == $rinc) {
unset($supplierbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kodeorg') {
#periksa kodeblok yang disubmit
$kdptbermasalah[$rinc] = $rinc;
foreach ($kodept as $bb => $cc) {
if ($cc == $rinc) {
unset($kdptbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kodebarang' and trim($rinc) != '') {
$kdbarangbermasalah[$rinc] = $rinc;
foreach ($kdbarang as $bb => $cc) {
if ($cc == $rinc) {
unset($kdbarangbermasalah[$rinc]);
}
}
}
if ($header[$ids] == 'kurs') {
if (trim($rinc) == '') {
$x[$key][$ids] = 1;
}
}
if ($header[$ids] == 'tanggal') {
$rinc = str_replace('-', '', $rinc);
if (strlen($rinc) != 8) {
exit("Error: some data on date not valid (line " . $key . ":" . $rinc . ")");
} else {
if (substr($rinc, 0, 4) < '2000') {
exit("Error: date not valid (line " . $key . ")");
}
}
}
}
}
}
if (count($supplierbermasalah) > 0) {
echo "The following supplier/contractor code on were not defined:<br>";
echo "<pre>";
print_r($supplierbermasalah);
echo "</pre>";
exit;
}
if (count($kdptbermasalah) > 0) {
echo "The following company code were not defined:<br>";
echo "<pre>";
print_r($kdptbermasalah);
echo "</pre>";
exit;
}
if (count($kdbarangbermasalah) > 0) {
echo "The following material code were not defined:<br>";
echo "<pre>";
print_r($kdbarangbermasalah);
echo "</pre>";
exit;
}
$jmhrBrs = count($x[0]);
$jmlhRow = count($x);
$aer = 0;
foreach ($x[0] as $lstDt => $lstNama) {
if ($aer == 0) {
$sinsHed .= "insert into " . $dbname . ".log_poht (`" . trim($lstNama) . "`";
$aet = 0;
$nopo = $lstNama;
} else {
if ($aer < 11) {
$sinsHed .= ",`" . trim($lstNama) . "`";
} else {
if ($aet == 0) {
$sinsHed .= ",`statuspo`,`stat_release`,`lokalpusat`) values ";
$sInsDet .= "insert into " . $dbname . ".log_podt (`" . trim($nopo) . "`,`" . trim($lstNama) . "`";
} else {
if ($aet < 4) {
$sInsDet .= ",`" . trim($lstNama) . "`";
}
}
$aet++;
}
}
if ($aer < 11) {
$aer++;
}
if ($aet == 4) {
$sInsDet .= ",`harganormal`,`hargasbldiskon`) ";
}
}
for ($aerto = 1; $aerto < $jmlhRow; $aerto++) {
if ($nopohead != $x[$aerto][0]) {
$nopohead = "";
$headUtm = "";
$headUtm .= $sinsHed;
$nopohead = $x[$aerto][0];
$scek = "select * from " . $dbname . ".log_poht where nopo='" . $nopohead . "'";
$qcek = mysql_query($scek) or die(mysql_error($conn));
if (mysql_num_rows($qcek) < 1) {
$headUtm .= "('" . trim($x[$aerto][0]) . "','" . trim($x[$aerto][1]) . "','" . trim($x[$aerto][2]) . "','" . trim($x[$aerto][3]) . "','" . trim($x[$aerto][4]) . "','" . trim($x[$aerto][5]) . "','" . trim($x[$aerto][6]) . "','" . trim($x[$aerto][7]) . "','" . trim($x[$aerto][8]) . "','" . trim($x[$aerto][9]) . "','" . trim($x[$aerto][10]) . "','2','1','" . trim($x[$aerto][15]) . "')";
//exit("error:".$headUtm."__masuk sini");
if (!mysql_query($headUtm)) {
exit("error:\n" . $headUtm . "__l" . mysql_error());
} else {
$detData = "";
$detData .= $sInsDet . " values ";
$hrgdis[$aerto] = trim($x[$aerto][14]);
if (intval($x[$aerto][6]) != 0) {
$hrgdis[$aerto] = floatval($x[$aerto][14]) - floatval($x[$aerto][14]) * (floatval($x[$aerto][6]) / 100);
}
$sDelDt = "delete from " . $dbname . ".log_podt where nopo='" . trim($x[$aerto][0]) . "' and kodebarang='" . trim($x[$aerto][11]) . "'";
if (mysql_query($sDelDt)) {
$detData .= "('" . trim($x[$aerto][0]) . "','" . trim($x[$aerto][11]) . "','" . trim($x[$aerto][12]) . "','" . trim($x[$aerto][13]) . "','" . $hrgdis[$aerto] . "','" . $hrgdis[$aerto] . "','" . trim($x[$aerto][14]) . "')";
if (!mysql_query($detData)) {
exit("error:\n" . $detData . "__uatas" . mysql_error());
}
}
}
} else {
$sdel = "delete from " . $dbname . ".log_poht where nopo='" . $x[$aerto][0] . "'";
if (mysql_query($sdel)) {
$headUtm .= "('" . trim($x[$aerto][0]) . "','" . trim($x[$aerto][1]) . "','" . trim($x[$aerto][2]) . "','" . trim($x[$aerto][3]) . "','" . trim($x[$aerto][4]) . "','" . trim($x[$aerto][5]) . "','" . trim($x[$aerto][6]) . "','" . trim($x[$aerto][7]) . "','" . trim($x[$aerto][8]) . "','" . trim($x[$aerto][9]) . "','" . trim($x[$aerto][10]) . "','2','1','" . trim($x[$aerto][15]) . "')";
if (!mysql_query($headUtm)) {
exit("error:\n" . $headUtm . "__s" . mysql_error($conn));
} else {
$detData = "";
$detData .= $sInsDet . " values ";
$hrgdis[$aerto] = trim($x[$aerto][14]);
if (intval($x[$aerto][6]) != 0) {
$hrgdis[$aerto] = floatval($x[$aerto][14]) - floatval($x[$aerto][14]) * (floatval($x[$aerto][6]) / 100);
}
$sDelDt = "delete from " . $dbname . ".log_podt where nopo='" . trim($x[$aerto][0]) . "' and kodebarang='" . trim($x[$aerto][11]) . "'";
if (mysql_query($sDelDt)) {
$detData .= "('" . trim($x[$aerto][0]) . "','" . trim($x[$aerto][11]) . "','" . trim($x[$aerto][12]) . "','" . trim($x[$aerto][13]) . "','" . $hrgdis[$aerto] . "','" . $hrgdis[$aerto] . "','" . trim($x[$aerto][14]) . "')";
if (!mysql_query($detData)) {
exit("error:\n" . $detData . "__t" . mysql_error($conn));
}
}
}
}
}
} else {
$detData = "";
$detData .= $sInsDet . " values ";
$hrgdis[$aerto] = trim($x[$aerto][14]);
if (intval($x[$aerto][6]) != 0) {
$hrgdis[$aerto] = floatval($x[$aerto][14]) - floatval($x[$aerto][14]) * (floatval($x[$aerto][6]) / 100);
}
$sDelDt = "delete from " . $dbname . ".log_podt where nopo='" . trim($x[$aerto][0]) . "' and kodebarang='" . trim($x[$aerto][11]) . "'";
if (mysql_query($sDelDt)) {
$detData .= "('" . trim($x[$aerto][0]) . "','" . trim($x[$aerto][11]) . "','" . trim($x[$aerto][12]) . "','" . trim($x[$aerto][13]) . "','" . $hrgdis[$aerto] . "','" . $hrgdis[$aerto] . "','" . trim($x[$aerto][14]) . "')";
if (!mysql_query($detData)) {
exit("error:\n" . $detData . "__u1" . mysql_error());
}
}
}
}
//exit("error:masuk".$headUtm."____".$detData."__".$aet."___".$jmlhRow);
break;
# ====================================================END PO=====================================
#====================================================START ABSENSI================================================
# ====================================================END PO=====================================
#====================================================START ABSENSI================================================
case 'ABSENSI':
$data = $x;
// Validasi Kosong
if (empty($data)) {
exit("Isi File Kosong");
}
// Cek apakah ada periode yang berbeda dan pengecekan format tanggal
$periode = substr($data[1][0], 0, 7);
$listNik = array();
foreach ($data as $key => $row) {
if ($key > 0) {
$tmpDate = explode('-', $row[0]);
// Validasi Format Tanggal
if (count($tmpDate) != 3 or strlen($tmpDate[0]) != 4 or strlen($tmpDate[1]) != 2 or strlen($tmpDate[2]) != 2) {
exit("Format Tanggal tidak valid.<br>Format tanggal = YYYY-MM-DD");
}
// Validasi Periode
if ($periode != substr($row[0], 0, 7)) {
exit("Warning: Ada periode yang tidak sama " . substr($row[0], 0, 7));
}
$listNik[trim($row[1])] = trim($row[1]);
}
}
// Kode Absen
$str2 = "select kodeabsen from " . $dbname . ".sdm_5absensi order by kelompok asc";
$res2 = mysql_query($str2);
while ($bar = mysql_fetch_object($res2)) {
$kdaben[] = $bar->kodeabsen;
}
// Get Data Karyawan
$str = "select karyawanid,nik,lokasitugas,subbagian from " . $dbname . ".datakaryawan where nik in ('" . implode("','", $listNik) . "') \n\t\t\tand tanggalkeluar='0000-00-00' and tipekaryawan!=0 order by nik asc";
//echo $str;
$res = mysql_query($str);
$dataNik = $dataKaryId = $dataLokasi = $dataSubbagian = array();
$listSubbagian = $listLokasi = $listAllLokasi = array();
while ($bar = mysql_fetch_object($res)) {
$dataNik[$bar->nik] = $bar->nik;
$dataKaryId[$bar->nik] = $bar->karyawanid;
$dataLokasi[$bar->nik] = $bar->lokasitugas;
if (!empty($bar->subbagian)) {
$dataSubbagian[$bar->nik] = $bar->subbagian;
$listSubbagian[$bar->subbagian] = $bar->subbagian;
$listAllLokasi[$bar->subbagian] = $bar->subbagian;
}
$listLokasi[$bar->lokasitugas] = $bar->lokasitugas;
$listAllLokasi[$bar->lokasitugas] = $bar->lokasitugas;
}
// Get Tipe Karyawan
$optTipe = makeOption($dbname, 'datakaryawan', 'karyawanid,tipekaryawan', "karyawanid in ('" . implode("','", $dataKaryId) . "')");
// Cek Periode Aktif
$scek = "select distinct kodeorg,periode from " . $dbname . ".setup_periodeakuntansi where\n\t\t\tkodeorg in ('" . implode("','", $listLokasi) . "') and\n\t\t\ttutupbuku=0 order by periode asc";
$resCek = fetchData($scek);
// Cek Periode tidak sama
$optPeriod = array();
foreach ($resCek as $row) {
$optPeriod[$row['kodeorg']] = $row['periode'];
}
foreach ($optPeriod as $org => $p) {
if ($periode != $p) {
exit("error: Period is not the same with active period :" . $p);
}
}
// Cek Periode tidak ada
foreach ($listLokasi as $row) {
if (!isset($optPeriod[$row])) {
exit("Warning: " . $row . " tidak ada periode aktif");
}
}
// Cek Data Bermasalah
$nopoisi = 0;
$nikbermasalah = $absenbermasalah = array();
$tanggalNow = '';
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
if ($ids == 0) {
$x[$key][0] = tanggalsystemn($rinc);
}
if ($nopoisi != 1) {
$nopoisi = 1;
if ($header[0] == 'tanggal') {
$rinc = str_replace('-', '', $x[$key][0]);
if (strlen($rinc) != 8) {
exit("Error: some data on date not valid (line " . $key . "__" . $rinc . ")");
} else {
if (substr($rinc, 0, 4) < '2000') {
exit("Error: date not valid (line " . $key . ")");
}
}
}
}
if (isset($header[1]) and $header[1] == 'nik') {
$rinc = $x[$key][1];
$nikbermasalah[$rinc] = $rinc;
foreach ($dataKaryId as $bb => $cc) {
if ($bb == $rinc) {
unset($nikbermasalah[$rinc]);
}
}
}
if (isset($header[3]) and $header[3] == 'absensi') {
$rinc = $x[$key][3];
$absenbermasalah[$rinc] = $rinc;
foreach ($kdaben as $bb => $cc) {
if ($cc == $rinc) {
unset($absenbermasalah[$rinc]);
}
}
}
}
}
//else
}
//foreach
$bermasalah = false;
if (count($nikbermasalah) > 0) {
echo "Warning - The following nik on were not defined:<br>";
echo "<pre>";
print_r($nikbermasalah);
echo "</pre>";
$bermasalah = true;
}
if (count($absenbermasalah) > 0) {
echo "Warning - The following absence on were not defined:<br>";
echo "<pre>";
print_r($absenbermasalah);
echo "</pre>";
$bermasalah = true;
}
if ($bermasalah == true) {
exit;
}
// Get List Lokasi & Tanggal
$lokTgl = array();
foreach ($data as $key => $row) {
if ($key > 0) {
$tmpLok = isset($dataSubbagian[$row[1]]) ? $dataSubbagian[$row[1]] : $dataLokasi[$row[1]];
$lokTgl[$tmpLok . $row[0]] = $tmpLok . $row[0];
}
}
// Pool Data & Insert Header
$dataD = array();
foreach ($data as $key => $row) {
if ($key > 0) {
foreach ($listAllLokasi as $lok) {
if (isset($lokTgl[$lok . $row[0]])) {
// Insert Header
$dataH = array('tanggal' => trim($row[0]), 'kodeorg' => $lok, 'periode' => $periode);
$qIns = insertQuery($dbname, 'sdm_absensiht', $dataH, array('tanggal', 'kodeorg', 'periode'));
// Execute, jika gagal skip
if (!mysql_query($qIns)) {
if (mysql_errno() != 1062) {
exit("Insert Header Error: " . mysql_error());
}
}
}
}
$cekAbs = false;
if ($optTipe[$dataKaryId[trim($row[1])]] == 4) {
// Jika PHL, cek BKM
// Cek BKM Rawat
$qRawat = selectQuery($dbname, 'kebun_kehadiran_vw', '*', "karyawanid = '" . $dataKaryId[trim($row[1])] . "' and\n\t\t\t\t\t\t\t\t\t\t tanggal = '" . trim($row[0]) . "'");
$resRawat = fetchData($qRawat);
if (!empty($resRawat)) {
$cekAbs = true;
break;
}
// Cek BKM Panen
$qPnn = selectQuery($dbname, 'kebun_prestasi_vw', '*', "karyawanid = '" . $dataKaryId[trim($row[1])] . "' and\n\t\t\t\t\t\t\t\t\t\t tanggal = '" . trim($row[0]) . "'");
$resPnn = fetchData($qPnn);
if (!empty($resPnn)) {
$cekAbs = true;
break;
}
}
// Pool Detail
if (!$cekAbs) {
// Jika Belum ada di BKM
$org = isset($dataSubbagian[$row[1]]) ? $dataSubbagian[$row[1]] : $dataLokasi[$row[1]];
if ($dataLokasi[trim($row[1])] == substr($org, 0, 4)) {
$dataD[] = array('kodeorg' => $org, 'tanggal' => trim($row[0]), 'karyawanid' => $dataKaryId[trim($row[1])], 'shift' => trim($row[2]), 'absensi' => trim($row[3]), 'jam' => trim($row[4]), 'jamPlg' => trim($row[5]), 'penjelasan' => trim($row[6]), 'catu' => 0, 'penaltykehadiran' => 0, 'premi' => 0, 'insentif' => 0, 'fingerprint' => 1);
}
}
}
}
// Insert Detail
foreach ($dataD as $row) {
$qIns = insertQuery($dbname, 'sdm_absensidt', $row);
if (!mysql_query($qIns)) {
if (mysql_errno() != 1062) {
exit("Insert Detail Error: " . mysql_error());
}
}
}
echo "Notice: Data berhasil diupload";
break;
#====================================================START HARGA HARIAN PASAR================================================
#====================================================START HARGA HARIAN PASAR================================================
case 'HARGAHARIANPASAR':
$nopoisi = 0;
foreach ($x as $key => $arr) {
if ($key == 0) {
continue;
} else {
foreach ($arr as $ids => $rinc) {
if ($nopoisi != 1) {
$nopoisi = 1;
if ($header[2] == 'tanggal') {
if (strlen($x[$key][2]) == 1) {
$x[$key][2] = '0' . $x[$key][2];
} else {
if (strlen($x[$key][2]) == 2) {
$x[$key][2] = $x[$key][2];
}
}
}
}
}
}
//else
}
//foreach
$jmlhRow = count($x);
$key = 1;
for ($ind = 1; $ind < $jmlhRow; $ind++) {
$w = "insert into " . $dbname . ".pmn_hargapasar (tanggal,kodeproduk,pasar,satuan,harga,matauang,statusharga,ffa,mni) values";
$w .= " ('" . $x[$ind][0] . '-' . $x[$ind][1] . '-' . $x[$ind][2] . "','" . $x[$ind][3] . "','" . $x[$ind][4] . "','" . $x[$ind][5] . "',";
$w .= "'" . trim($x[$ind][6]) . "','" . trim($x[$ind][7]) . "','" . trim($x[$ind][8]) . "','" . trim($x[$ind][9]) . "','" . trim($x[$ind][10]) . "')";
if (!mysql_query($w)) {
exit("error: gagal" . $w);
}
}
echo "Notice: Data berhasil diupload";
break;
default:
break;
}
}
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/fpdf.php';
require_once 'lib/nangkoelib.php';
//$pt="PMO";
$pt = $_GET['pt'];
$gudang = $_GET['gudang'];
$tanggalpivot = $_GET['tanggalpivot'];
$tanggalv = tanggalsystemn($_GET['tanggalpivot']);
$statuspo = $_GET['statuspo'];
$supkontran = $_GET['supkontran'];
$str = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $pt . "'";
$namapt = 'Seluruhnya';
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$namapt = strtoupper($bar->namaorganisasi);
}
/*if($gudang!='')
{
$str="select * from ".$dbname.".aging_sch_vw
where posting=1 and tanggal <= '".$tanggalv."' and kodeorg = '".$gudang."' and (nilaiinvoice > dibayar or dibayar is NULL)
";
}else
if($pt!='')
{
$str="select * from ".$dbname.".aging_sch_vw
where posting=1 and tanggal <= '".$tanggalv."' and kodeorg = '".$pt."' and (nilaiinvoice > dibayar or dibayar is NULL)
";
}else
$usr_id = $_SESSION['standard']['userid'];
$nodok = checkPostGet('nodok', '');
$kdTraksiDt = makeOption($dbname, 'vhc_5master', 'kodevhc,kodetraksi');
$kodeBarang = checkPostGet('kodeBarang', '');
$jumlahBarang = checkPostGet('jumlahBarang', '');
$keteranganBarang = checkPostGet('keteranganBarang', '');
$satuanBarang = checkPostGet('satuanBarang', '');
$karyawan = checkPostGet('karyawan', '');
$namaBarangCari = checkPostGet('namaBarangCari', '');
$jenisVhc = makeOption($dbname, 'vhc_5master', 'kodevhc,jenisvhc');
//$nikKar=makeOption($dbname,'datakaryawan','karyawanid,nik',$whKar);
//$nmKar=makeOption($dbname,'datakaryawan','karyawanid,namakaryawan',$whKar);
//$nmBrg=makeOption($dbname,'log_5masterbarang','kodebarang,namabarang',$whBrg);
//$satBrg=makeOption($dbname,'log_5masterbarang','kodebarang,satuan',$whBrg);
$schTran = checkPostGet('schTran', '');
$schTgl = tanggalsystemn(checkPostGet('schTgl', ''));
$schRef = checkPostGet('schRef', '');
// Get Nik dan Nama
$nikKar = $nmKar = array();
$qKary = selectQuery($dbname, 'datakaryawan', 'karyawanid,namakaryawan,nik');
$resKary = fetchData($qKary);
foreach ($resKary as $row) {
$nikKar[$row['karyawanid']] = $row['nik'];
$nmKar[$row['karyawanid']] = $row['namakaryawan'];
}
// Get Nama dan Satuan Barang
$nmBrg = $satBrg = array();
$qBrg = selectQuery($dbname, 'log_5masterbarang', 'kodebarang,namabarang,satuan');
$resBrg = fetchData($qBrg);
foreach ($resBrg as $row) {
$nmBrg[$row['kodebarang']] = $row['namabarang'];
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
require_once 'lib/zLib.php';
require_once 'lib/fpdf.php';
$proses = checkPostGet('proses', '');
$kdBrgRep = checkPostGet('kdBrgRep', '');
$kdOrgRep = checkPostGet('kdOrgRep', '');
$tgl1Rep = tanggalsystemn(checkPostGet('tgl1Rep', ''));
$tgl2Rep = tanggalsystemn(checkPostGet('tgl2Rep', ''));
// if(($proses=='excel')or($proses=='pdf'))
// {
// $kdBrgRep=$_GET['kdBrgRep'];
// $kdOrgRep=$_GET['kdOrgRep'];
// $tgl1Rep=tanggalsystemn($_GET['tgl1Rep']);
// $tgl2Rep=tanggalsystemn($_GET['tgl2Rep']);
// }
$optnmor = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
$optjnvhc = makeOption($dbname, 'vhc_5jenisvhc', 'jenisvhc,namajenisvhc');
$optnmbar = makeOption($dbname, 'log_5masterbarang', 'kodebarang,namabarang');
$optnamacostumer = makeOption($dbname, 'log_5supplier', 'supplierid,namasupplier');
$namasupp = makeOption($dbname, 'log_5supplier', 'supplierid,namasupplier');
$nmOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "tipe='PABRIK'");
$nmBrg = makeOption($dbname, 'log_5masterbarang', 'kodebarang,namabarang', 'kelompokbarang=400');
if ($proses == 'preview' or $proses == 'excel' or $proses == 'pdf') {
if ($tgl1Rep == '' or $tgl2Rep == '') {
echo "Error: Tanggal tidak boleh kosong";
exit;
} else {
$azKer = $dBa['jumlah'];
$kgKer = $xKer + $zKer + $azKer - $yKer;
echo $kgKer;
break;
case 'getData':
##bentuk tanggal kemarin
$tgl = tanggalsystem($_POST['tanggal']);
$tglKmrn = strtotime('-1 day', strtotime($tgl));
$tglKmrn = date('Y-m-d', $tglKmrn);
#ambil sisa tbs kemarin
$iSisa = "select sisahariini from " . $dbname . ".pabrik_produksi where kodeorg='" . $_POST['kodeorg'] . "' and " . " tanggal='" . $tglKmrn . "' ";
$nSisa = mysql_query($iSisa) or die(mysql_errno($conn));
$dSisa = mysql_fetch_assoc($nSisa);
$tbsKmrn = $dSisa['sisahariini'];
#ambil produksi hari ini
$iTbs = "select sum(beratbersih) as beratbersih from " . $dbname . ".pabrik_timbangan where millcode='" . $_POST['kodeorg'] . "' and " . " tanggal like '%" . tanggalsystemn($_POST['tanggal']) . "%' and kodebarang='40000003'";
$nTbs = mysql_query($iTbs) or die(mysql_errno($conn));
$dTbs = mysql_fetch_assoc($nTbs);
$tbsHr = $dTbs['beratbersih'];
if ($tbsKmrn != '') {
$tbsKmrn = $tbsKmrn;
} else {
$tbsKmrn = 0;
}
echo $tbsKmrn . "###" . $tbsHr;
break;
case 'getDetailPP':
$str = "select * from " . $dbname . ".pabrik_produksi\r\n where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and tanggal='" . $_POST['tgl'] . "'";
//echo $str;
$res = mysql_query($str) or die(mysql_error($conn));
$rdata = mysql_fetch_assoc($res);
$golongandarah = $_POST['golongandarah'];
$statusperkawinan = $_POST['statusperkawinan'];
$levelpendidikan = $_POST['levelpendidikan'];
$method = $_POST['method'];
$karyawanid = $_POST['karyawanid'];
$subbagian = $_POST['subbagian'];
$catu = $_POST['catu'];
if ($subbagian == '0') {
$subbagian = '';
}
$param = $_POST;
$param['tanggallahir'] = tanggalsystemn($_POST['tanggallahir']);
$param['tanggalmasuk'] = tanggalsystemn($_POST['tanggalmasuk']);
$param['tanggalpengangkatan'] = tanggalsystemn($_POST['tanggalpengangkatan']);
$param['tanggalkeluar'] = tanggalsystemn($_POST['tanggalkeluar']);
$param['tanggalmenikah'] = tanggalsystemn($_POST['tanggalmenikah']);
switch ($method) {
case 'delete':
$strx = "delete from " . $dbname . ".datakaryawan where karyawanid=" . $karyawanid;
break;
case 'update':
$qData = selectQuery($dbname, 'datakaryawan', '*', "karyawanid='" . $karyawanid . "'");
$resData = fetchData($qData);
$oldData = $resData[0];
$strx = "update " . $dbname . ".datakaryawan set \n\t\t\t`namakaryawan`\t='" . $namakaryawan . "',\n\t\t\t`tempatlahir`\t='" . $tempatlahir . "',\n\t\t\t`tanggallahir`\t=" . $tanggallahir . ",\n\t\t\t`warganegara` ='" . $warganegara . "',\n\t\t\t`jeniskelamin`\t='" . $jeniskelamin . "',\n\t\t\t`statusperkawinan` ='" . $statusperkawinan . "',\n\t\t\t`tanggalmenikah`\t=" . $tanggalmenikah . ",\n\t\t\t`agama`\t\t\t='" . $agama . "',\n\t\t\t`golongandarah`\t='" . $golongandarah . "',\n\t\t\t`levelpendidikan` =" . $levelpendidikan . ",\n\t\t\t`alamataktif`\t='" . $alamataktif . "',\n\t\t\t`provinsi`\t\t='" . $provinsi . "',\n\t\t\t`kota`\t\t='" . $kota . "',\n\t\t\t`kodepos`\t\t='" . $kodepos . "',\n\t\t\t`noteleponrumah` ='" . $noteleponrumah . "',\n\t\t\t`nohp`\t\t='" . $nohp . "',\n\t\t\t`norekeningbank` ='" . $norekeningbank . "',\n\t\t\t`namabank`\t\t='" . $namabank . "',\n\t\t\t`sistemgaji`\t\t='" . $sistemgaji . "',\n\t\t\t`no_keluarga`\t='" . $nopassport . "',\n\t\t\t`noktp`\t\t\t='" . $noktp . "',\n\t\t\t`notelepondarurat` ='" . $notelepondarurat . "',\n\t\t\t`tanggalmasuk` =" . $tanggalmasuk . ",\n\t\t\t`tanggalpengangkatan` =" . $tanggalpengangkatan . ",\n\t\t\t`tanggalkeluar`\t=" . $tanggalkeluar . ",\n\t\t\t`tipekaryawan` =" . $tipekaryawan . ",\n\t\t\t`jumlahanak`\t\t=" . $jumlahanak . ",\n\t\t\t`jumlahtanggungan` =" . $jumlahtanggungan . ",\n\t\t\t`statuspajak`\t='" . $statuspajak . "',\n\t\t\t`npwp`\t\t\t='" . $npwp . "',\n\t\t\t`bpjs`\t\t\t='" . $bpjs . "',\n\t\t\t`lokasipenerimaan` ='" . $lokasipenerimaan . "',\n\t\t\t`kodeorganisasi`\t='" . $kodeorganisasi . "',\n\t\t\t`bagian`\t\t\t='" . $bagian . "',\n\t\t\t`kodejabatan`\t=" . $kodejabatan . ",\n\t\t\t`kodegolongan`\t='" . $kodegolongan . "',\n\t\t\t`lokasitugas` ='" . $lokasitugas . "',\n\t\t\t`email`\t\t='" . $email . "',\n\t\t\t`alokasi`\t\t=" . $alokasi . ",\n\t\t\t`subbagian`\t\t='" . $subbagian . "',\n\t\t\t`jms` ='" . $jms . "' , \n\t\t\t`kodecatu` ='" . $catu . "', \n\t\t\t`statpremi` ='" . $_POST['statPremi'] . "',\n\t\t\t`updateby`\t= '" . $_SESSION['standard']['userid'] . "'\n\t\t\twhere karyawanid=" . $karyawanid;
logData($oldData, $param);
break;
case 'insert':
//Generate NIK Karyawan
$sReg = "select t1.kodepenerimaankaryawan, t1.regional from " . $dbname . ".bgt_regional t1\n\t\t\t\tleft join " . $dbname . ".bgt_regional_assignment t2\n\t\t\t\ton t1.regional = t2.regional\n\t\t\t\twhere t2.kodeunit = '" . $lokasitugas . "' limit 1";
$qReg = mysql_query($sReg) or die(mysql_error($conn));
require_once 'lib/zLib.php';
?>
<?php
$method = checkPostGet('method', '');
$kdOrg = checkPostGet('kdOrg', '');
$tgl = tanggalsystemn(checkPostGet('tgl', ''));
$sawal = checkPostGet('sawal', '');
$prod = checkPostGet('prod', '');
$pakai = checkPostGet('pakai', '');
$jual = checkPostGet('jual', '');
$sisa = checkPostGet('sisa', '');
$ket = checkPostGet('ket', '');
$kdBrg = checkPostGet('kdBrg', '');
$tglSch = tanggalsystemn(checkPostGet('tglSch', ''));
$kdBrgSch = checkPostGet('kdBrgSch', '');
//exit("Error:$sInsert");
$namasupp = makeOption($dbname, 'log_5supplier', 'supplierid,namasupplier');
$nmOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "tipe='PABRIK'");
$nmBrg = makeOption($dbname, 'log_5masterbarang', 'kodebarang,namabarang', 'kelompokbarang=400');
if ($tglSch == '--') {
$tglSch = '';
}
?>
<?php
switch ($method) {
//'".$_SESSION['standard']['userid']."'
case 'insert':
$iSave = "INSERT INTO " . $dbname . ".`pabrik_stokbarang` (`kodeorg`, `tanggal`, `kodebarang`, `saldoawal`, \r\n `produksi`, `pemakaian`, `penjualan`, `sisa`, `updateby`,`keterangan`)\r\n values ('" . $kdOrg . "','" . $tgl . "','" . $kdBrg . "','" . $sawal . "','" . $prod . "','" . $pakai . "','" . $jual . "',\r\n '" . $sisa . "','" . $_SESSION['standard']['userid'] . "','" . $ket . "')";
if ($param['tgl'] == '' || $param['kdKend'] == '' || $param['nmSupir'] == '' || $param['jmlhJjg'] == '' || $param['brtMsk'] == '' || $param['brtKlr'] == '' || $param['spbId'] == '') {
exit("error: Seluruh field tidak boleh kosong");
}
$sins = "update " . $dbname . ".pabrik_timbangan set tanggal='" . tanggalsystem($param['tgl']) . "',kodeorg='" . $_SESSION['empl']['lokasitugas'] . "',kodecustomer='" . $optCust[$param['spbId']] . "',jumlahtandan1='" . $param['jmlhJjg'] . "',jammasuk='" . $param['jamMasuk'] . "',beratmasuk='" . $param['brtMsk'] . "',jamkeluar='" . $param['jamKeluar'] . "',beratkeluar='" . $param['brtKlr'] . "',nokendaraan='" . $param['kdKend'] . "',supir='" . $param['nmSupir'] . "',nospb='" . $param['spbId'] . "',beratbersih='" . $param['brtBrsh'] . "',jjgsortasi='" . $param['JjgSortasi'] . "',kgpotsortasi='" . $param['potKg'] . "',username='******'standard']['username'] . "' where notransaksi='" . $param['notransaksi'] . "'";
if (!mysql_query($sins)) {
exit("error: " . mysql_error($conn) . "__" . $sins);
}
break;
case 'loadNewData':
echo "<table cellspacing='1' border='0' class='sortable'>\r\n\t\t\t <thead>\r\n\t\t\t <tr class=rowheader>\r\n\t\t\t <td>No.</td>\r\n\t\t\t <td>" . $_SESSION['lang']['noTiket'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['nospb'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['nopol'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['supir'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['jjg'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['beratMasuk'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['beratKeluar'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['beratBersih'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['jjg'] . " Sortasi</td>\r\n\t\t\t <td>" . $_SESSION['lang']['potongan'] . "</td>\r\n\t\t\t <td>Action</td>\r\n\t\t\t </tr>\r\n\t\t\t </thead><tbody>";
$whrCr = "";
if ($param['nosbpCr'] != '') {
$whrCr .= " and nospb like '%" . $param['nosbpCr'] . "%'";
}
if ($param['tgl_cari'] != '') {
$whrCr .= " and tanggal like '%" . tanggalsystemn($param['tgl_cari']) . "%'";
}
$limit = 20;
$page = 0;
if (isset($_POST['page'])) {
$page = $_POST['page'];
if ($page < 0) {
$page = 0;
}
}
$offset = $page * $limit;
$ql2 = "select count(*) as jmlhrow from " . $dbname . ".pabrik_timbangan \r\n\t\t\t where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and char_length(notransaksi)>7 " . $whrCr . " order by `tanggal` desc";
$slvhc = "select * from " . $dbname . ".pabrik_timbangan \r\n\t\t\t\twhere kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and char_length(notransaksi)>7 " . $whrCr . "\r\n\t\t\t\torder by `tanggal` desc limit " . $offset . "," . $limit . "";
$query2 = mysql_query($ql2) or die(mysql_error());
while ($jsl = mysql_fetch_object($query2)) {
$jlhbrs = $jsl->jmlhrow;
$resHo2 = fetchData($qHo2);
$kodeorg2 = $resHo2[0]['kodeorganisasi'];
}
// Get Parameter Jurnal
$paramJ = $zJ->getParam($_SESSION['org']['induk'], $kodeApp, $kodeJurnal);
if (empty($paramJ)) {
exit("Warning: Parameter Jurnal " . $kodeApp . " belum ada\n" . "Silahkan hubungi pihak IT");
}
// Generate No Journal
$tanggalJ = tanggalsystemn($param['tanggal']);
$counter = $zJ->getCounter($data['kodept'], $kodeJurnal);
$counter++;
$nojurnal = $zJ->genNoJournal($tanggalJ, $kodeorg, $kodeJurnal, $counter);
if (!empty($param['nokontrakDt'])) {
//jika nokontrak menjadi induk,maka kontrak detailnya di buatkan jurnal
$tanggalJ = tanggalsystemn($param['tanggal']);
$counter2 = $zJ->getCounter($dataDet['kodept'], $kodeJurnal);
$counter2++;
$nojurnal2 = $zJ->genNoJournal($tanggalJ, $kodeorg2, $kodeJurnal, $counter2);
}
// Jumlah
#jika include ppn maka nilai hargasatuan di kurangi dengan hargasatuan*10/100
if ($data['ppn'] == 1) {
$data['hargasatuan'] = $data['hargasatuan'] / 1.1;
}
$jumlah = $data['beratbersih'] * $data['hargasatuan'];
if (!empty($param['nokontrakDt'])) {
//jika nokontrak menjadi induk,maka kontrak detailnya di buatkan jurnal
#jika include ppn maka nilai hargasatuan di kurangi dengan hargasatuan*10/100
if ($dataDet['ppn'] == 1) {
$dataDet['hargasatuan'] = $dataDet['hargasatuan'] / 1.1;
$query = "SELECT luasareaproduktif\r\n FROM " . $dbname . ".`setup_blok`\r\n WHERE `kodeorg` = '" . $param['kodeorg'] . "'\r\n ";
// echo "error:".$query; exit;
$qDetail = mysql_query($query) or die(mysql_error($conn));
while ($rDetail = mysql_fetch_assoc($qDetail)) {
$luasbloknya = $rDetail['luasareaproduktif'];
}
// cari tanggal
$query = "SELECT distinct tanggal\r\n FROM " . $dbname . ".`kebun_prestasi_vw`\r\n WHERE `notransaksi` = '" . $param['notransaksi'] . "'\r\n ";
// echo "error:".$query; exit;
$qDetail = mysql_query($query) or die(mysql_error($conn));
$tanggalnya = '';
while ($rDetail = mysql_fetch_assoc($qDetail)) {
$tanggalnya = $rDetail['tanggal'];
}
if ($tanggalnya == '') {
$tanggalnya = tanggalsystemn($param['tanggal']);
}
// cari luas panen yang sudah diinput ditambah inputan
$query = "SELECT sum(luaspanen) as luaspanen\r\n FROM " . $dbname . ".`kebun_prestasi_vw`\r\n WHERE `tanggal` = '" . $tanggalnya . "' and `kodeorg` ='" . $param['kodeorg'] . "' and karyawanid!='" . $param['nik'] . "'";
//echo "error:".$query; exit;
$qDetail = mysql_query($query) or die(mysql_error($conn));
while ($rDetail = mysql_fetch_assoc($qDetail)) {
$luaspanennya = $rDetail['luaspanen'];
}
$luaspanennya += $data['luaspanen'];
if ($luaspanennya > $luasbloknya) {
$warning = "Luas Panen " . $luaspanennya . " melebihi Luas Blok " . $luasbloknya . " (Ha)";
echo "error: " . $warning . ".";
exit;
}
unset($data['tanggal']);
<?php
//ind
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
require_once 'lib/zLib.php';
require_once 'lib/fpdf.php';
require_once 'lib/terbilang.php';
$proses = $_GET['proses'];
$proses2 = $_POST['proses'];
$unit = $_POST['unit'];
$tgl1 = tanggalsystemn($_POST['tgl1']);
$tgl2 = tanggalsystemn($_POST['tgl2']);
$notran = $_POST['notran'];
$karyawanid = $_POST['karyawanid'];
$kodeorg = $_POST['kodeorg'];
$hasilkerjakg = $_POST['hasilkerjakg'];
//notransaksi nik kodekegiatan kodeorg tahuntanam hasilkerja hasilkerjakg jumlahhk norma
$stream .= "<table cellspacing='1' border='0' class='sortable'>";
$stream .= "<thead class=rowheader>\n <tr>\n <td align=center>No</td>\n <td align=center>" . $_SESSION['lang']['tipetransaksi'] . "</td>\n <td align=center>" . $_SESSION['lang']['tanggal'] . "</td> \n <td align=center>" . $_SESSION['lang']['notransaksi'] . "</td>\n <td align=center>" . $_SESSION['lang']['nik'] . "</td>\n <td align=center>" . $_SESSION['lang']['kodeorg'] . "</td>\n <td align=center>" . $_SESSION['lang']['tahuntanam'] . "</td> \n <td align=center>" . $_SESSION['lang']['hasilkerja'] . "</td>\n <td align=center>" . $_SESSION['lang']['bjr'] . "</td> \n <td align=center>" . $_SESSION['lang']['hasilkerjakg'] . " Awal</td>\n <td align=center>" . $_SESSION['lang']['hasilkerjakg'] . " Baru</td> \n </tr></thead>\n <tbody>";
$iList = "select a.notransaksi,a.nik,a.kodeorg,a.hasilkerja,a.hasilkerjakg,b.tipetransaksi,b.tanggal,a.tahuntanam " . " from " . $dbname . ".kebun_prestasi a left join " . $dbname . ".kebun_aktifitas b " . " on a.notransaksi=b.notransaksi " . " where a.kodeorg like '%" . $unit . "%' and b.tanggal between '" . $tgl1 . "' and '" . $tgl2 . "'" . " and b.tipetransaksi='PNN' ";
$nList = mysql_query($iList) or die(mysql_error($conn));
while ($dList = mysql_fetch_assoc($nList)) {
$iBjr = "select bjr from " . $dbname . ".kebun_5bjr where kodeorg='" . $dList['kodeorg'] . "' ";
$nBjr = mysql_query($iBjr) or die(mysql_error($conn));
$dBjr = mysql_fetch_assoc($nBjr);
$no += 1;
$stream .= "<tr class=rowcontent id=row" . $no . ">";
$stream .= "\n <td>" . $no . "</td>\n <td>" . $dList['tipetransaksi'] . "</td>\n <td>" . tanggalnormal($dList['tanggal']) . "</td> \n <td id=notran" . $no . ">" . $dList['notransaksi'] . "</td> \n <td id=karyawanid" . $no . ">" . $dList['nik'] . "</td> \n <td id=kodeorg" . $no . ">" . $dList['kodeorg'] . "</td> \n <td>" . $dList['tahuntanam'] . "</td> \n <td>" . $dList['hasilkerja'] . "</td> \n <td>" . $dBjr['bjr'] . "</td>\n <td>" . $dList['hasilkerjakg'] . "</td> \n <td id=hasilkerjakg" . $no . ">" . $dBjr['bjr'] * $dList['hasilkerja'] . "</td> \n ";
$stream .= "</tr>";
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
require_once 'lib/zLib.php';
# Get Attr
$proses = $_GET['proses'];
$data = $_POST;
switch ($proses) {
case 'add':
$tglnow = date('Y-m-d');
$tglinput = tanggalsystemn($data['tanggal']);
//exit("Error:$tglnow._.$tglinput");
if ($tglinput > $tglnow) {
exit("Error:Tanggal Tidak Boleh melewati tanggal sekarang " . tanggalnormal($tglnow) . " ");
}
// Validasi Kurs
if ($data['matauang'] != 'IDR') {
$qKurs = selectQuery($dbname, 'setup_matauangrate', 'kurs', "kode='" . $data['matauang'] . "' and daritanggal='" . tanggalsystem($data['tanggal']) . "'");
$resKurs = fetchData($qKurs);
if (empty($resKurs)) {
exit("Warning: Kurs " . $data['matauang'] . " di tanggal " . $data['tanggal'] . " belum ada");
}
}
#=============== Get Nomor Jurnal
$whereNo = "kodekelompok='" . $data['kodejurnal'] . "' and kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "'";
$query = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', $whereNo);
$noKon = fetchData($query);
$tmpC = $noKon[0]['nokounter'];
$tmpC++;
