/**
* doJournal
* Lakukan Jurnal berdasarkan data yang diberikan
*/
public function doJournal($pt, $kodeJurnal, $dataRes, $counter, $ketKelompok = "", $updateCounter = true)
{
global $dbname;
#Cek Nojurnal sudah terdaftar, Jika sudah terdaftar exit
$sCek = "select nojurnal from " . $dbname . ".keu_jurnaldt where nojurnal='" . $dataRes['header']['nojurnal'] . "'";
$qCek = mysql_query($sCek) or die(mysql_error($conn));
$rCek = mysql_num_rows($qCek);
if ($rCek != 0) {
exit("warning: Nojurnal :" . $dataRes['header']['nojurnal'] . " sudah ada");
}
$qHeader = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
$qDetail = insertQuery($dbname, 'keu_jurnaldt', $dataRes['detail']);
$dataIns = array($pt, $kodeJurnal, $ketKelompok, $counter);
$insCounter = insertQuery($dbname, 'keu_5kelompokjurnal', $dataIns);
$updCounter = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $counter), "kodeorg='" . $pt . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($qHeader)) {
echo "Header DB Error: " . mysql_error() . "\n";
$this->rbJournal($dataRes['header']['nojurnal']);
exit;
} else {
if (!mysql_query($qDetail)) {
echo "Detail DB Error: " . mysql_error() . "\n";
$this->rbJournal($dataRes['header']['nojurnal']);
exit;
} else {
if ($updateCounter) {
if (!mysql_query($insCounter)) {
// Insert Kelompok Jurnal jika belum ada
if (!mysql_query($updCounter)) {
// Update jika sudah ada
echo "DB Error: " . mysql_error() . "\n";
$this->rbJournal($dataRes['header']['nojurnal']);
exit;
}
}
}
}
}
}
// {
// exit("[ Error ]: Akun ".$data['noakun']." harus dilengkapi dengan NIK/nama Karyawan.");
// }
//=====end tambahan dz
unset($data['nojurnal']);
unset($data['kodejurnal']);
unset($data['nourut']);
$data['tanggal'] = tanggalsystem($data['tanggal']);
$data['jumlah'] = str_replace(',', '', $data['jumlah']);
foreach ($data as $key => $cont) {
if (substr($key, 0, 5) == 'cond_') {
unset($data[$key]);
}
}
$where = "nojurnal='" . $param['nojurnal'] . "' and nourut='" . $param['nourut'] . "'";
$query = updateQuery($dbname, 'keu_jurnaldt', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
echo json_encode($param);
break;
case 'delete':
$where = "nojurnal='" . $param['nojurnal'] . "' and nourut='" . $param['nourut'] . "'";
$query = "delete from `" . $dbname . "`.`keu_jurnaldt` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
default:
$primVal = explode('##', $_POST['primVal']);
unset($primary['namabarang']);
unset($primary['satuan']);
unset($data['namabarang']);
unset($data['satuan']);
# Create Condition
$where = "";
for ($i = 1; $i < count($primary); $i++) {
if ($i == 1) {
$where .= "`" . $primary[$i] . "`='" . $primVal[$i] . "'";
} else {
$where .= " AND `" . $primary[$i] . "`='" . $primVal[$i] . "'";
}
}
# Create Query
$query = updateQuery($dbname, 'setup_kegiatannorma', $data, $where);
# Update Data
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error($conn);
}
break;
case 'delete':
$data = $_POST;
unset($data['proses']);
unset($data['primary']);
unset($data['primVal']);
$primary = explode('##', $_POST['primary']);
$primVal = explode('##', $_POST['primVal']);
unset($primary['namabarang']);
unset($primary['satuan']);
unset($data['namabarang']);
$res = "";
foreach ($data as $cont) {
$res .= "##" . $cont;
}
$result = "{res:\"" . $res . "\",theme:\"" . $_SESSION['theme'] . "\"}";
echo $result;
break;
case 'edit':
$data = $param;
foreach ($data as $key => $cont) {
if (substr($key, 0, 5) == 'cond_') {
unset($data[$key]);
}
}
$where = "kodeorg='" . $param['kodeorg'] . "' and shift=" . $param['shift'] . " and nik='" . $param['cond_nik'] . "'";
$query = updateQuery($dbname, 'pabrik_5shiftanggota', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
echo json_encode($param);
break;
case 'delete':
$where = "kodeorg='" . $param['kodeorg'] . "' and shift=" . $param['shift'] . " and nik='" . $param['nik'] . "'";
$query = "delete from `" . $dbname . "`.`pabrik_5shiftanggota` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
default:
$data['rupiahpersatuan'] = str_replace(',', '', $data['rupiahpersatuan']);
foreach ($data as $key => $cont) {
if (substr($key, 0, 5) == 'cond_') {
unset($data[$key]);
}
}
cekRealisasi($param);
$where = "notransaksi='" . $param['notransaksi'] . "'and kodekegiatan='" . $param['cond_kodekegiatan'] . "' and kodeblok='" . $param['cond_kodeblok'] . "'";
$query = updateQuery($dbname, 'log_spkdt', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
} else {
$whereBA = "notransaksi='" . $param['notransaksi'] . "'and kodekegiatan='" . $param['cond_kodekegiatan'] . "' and blokspkdt='" . $param['cond_kodeblok'] . "'";
$dataBA = array('kodekegiatan' => $param['kodekegiatan'], 'blokspkdt' => $param['kodeblok']);
$queryBA = updateQuery($dbname, 'log_baspk', $dataBA, $whereBA);
if (!mysql_query($queryBA)) {
echo "DB Error : " . mysql_error();
exit;
}
}
echo json_encode($param);
break;
/** Delete existing data detail */
/** Delete existing data detail */
case 'delete':
//================periksa realisasi
$m = 0;
$strx = "select sum(jumlahrealisasi) from " . $dbname . ".log_baspk \n where notransaksi='" . $param['notransaksi'] . "'";
$resx = mysql_query($strx);
while ($barx = mysql_fetch_array($resx)) {
$errorDB .= "Rollback 2 Error :" . mysql_error() . "\n" . $queryRB2;
}
if (!mysql_query($queryRBKonter)) {
$errorDB .= "Rollback Counter Error :" . mysql_error() . "\n" . $queryRBKonter;
}
echo "DB Error :\n" . $errorDB;
exit;
}
}
}
// else if namabarang
if (empty($errorDB)) {
// Update Setup Blok, jika kegiatan sisip, completering, tanam baru
$where = "nilai = '" . $kodekegiatan . "' and kodeaplikasi = 'TN'";
// kalo kodeparameter SISIP
$query = selectQuery($dbname, 'setup_parameterappl', '*', $where);
$resSisip = fetchData($query);
if (!empty($resSisip)) {
// Ambil Blok Lama
$qBlok = selectQuery($dbname, 'setup_blok', 'jumlahpokok', "kodeorg='" . $kodeblok . "'");
$resBlok = fetchData($qBlok);
// Update Blok Baru
$dataUpd = array('jumlahpokok' => $resBlok[0]['jumlahpokok'] + $hasilkerja);
$updBlok = updateQuery($dbname, 'setup_blok', $dataUpd, "kodeorg='" . $kodeblok . "'");
if (!mysql_query($updBlok)) {
exit("Update Blok Error: " . mysql_error());
}
}
}
}
// else 256
function getLatestContents($nbcontents, $sort_type = 0, $catselect = "no", $rootid = null)
{
switch ($sort_type) {
/* Popular */
case 2:
$order_sql = "ORDER BY a.views DESC,a.date_created DESC ,a.id DESC ";
break;
/* Random */
/* Random */
case 1:
$order_sql = "ORDER BY RAND() ";
break;
/* Latest */
/* Latest */
case 0:
default:
$order_sql = "ORDER BY a.date_created DESC ,a.id DESC ";
break;
}
if (version_compare(JVERSION, '1.6', 'ge')) {
$listCategories = TPermissions::getAuthorisedCategories('read');
//If the variable is an array and if it's not empty, we add a filter to the request
//If not we're not return any category
if (is_array($listCategories) && !empty($listCategories)) {
$categories = implode(',', $listCategories);
$listCategories = " AND c.id IN (" . $categories . ") ";
} else {
$listCategories = " AND 0 ";
}
} else {
$listCategories = "";
}
$cat_query = "";
switch ($catselect) {
case "no":
break;
case "-1":
$catid = JRequest::getInt('catid', 0);
if ($catid != 0 && $catid != -1) {
$this->_db->setQuery("SELECT c.id, c.name,c.parent " . " FROM #__adsmanager_categories as c " . " WHERE c.published = 1 {$listCategories} ORDER BY c.parent,c.ordering");
$listcats = $this->_db->loadObjectList();
//List
$list = array();
$list[] = $catid;
$this->_recurseSearch($listcats, $list, $catid);
$listids = implode(',', $list);
$cat_query = "adcat.catid IN ({$listids}) AND ";
}
break;
default:
$this->_db->setQuery("SELECT c.id, c.name,c.parent " . " FROM #__adsmanager_categories as c " . " WHERE c.published = 1 {$listCategories} ORDER BY c.parent,c.ordering");
$listcats = $this->_db->loadObjectList();
$catsid = explode(',', $catselect);
//List
$list = array();
foreach ($catsid as $catid) {
$list[] = $catid;
$this->_recurseSearch($listcats, $list, $catid);
}
$listids = implode(',', $list);
$cat_query = " adcat.catid IN ({$listids}) AND ";
break;
}
if (ADSMANAGER_SPECIAL == 'newspaper') {
$cat_query .= " (a.ad_publishtype = 'both' OR a.ad_publishtype = 'online') AND ";
}
$currentSession = JSession::getInstance('none', array());
$sql = $currentSession->get("sqlglobalfilter", "");
$globalfilter = "";
if ($sql != "") {
$globalfilter = " AND {$sql} ";
}
$sql = " SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user " . " FROM #__adsmanager_ads as a " . " INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id " . " LEFT JOIN #__users as u ON a.userid = u.id " . " INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id " . " LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id " . " WHERE 1 {$globalfilter} AND {$cat_query} c.published = 1 and a.published = 1 GROUP BY a.id {$order_sql} LIMIT 0, {$nbcontents}";
if (function_exists("updateQuery")) {
updateQuery($sql);
}
$this->_db->setQuery($sql);
$contents = $this->_db->loadObjectList();
if ($contents == null) {
$contents = array();
}
foreach ($contents as &$content) {
$content->images = @json_decode($content->images);
$content->cat = JText::_($content->cat);
if ($content->parent != "") {
$content->parent = JText::_($content->parent);
}
if (!is_array($content->images)) {
$content->images = array();
}
}
return $contents;
}
if (!mysql_query($queryToJ)) {
$errorDB .= "Posting Mark Error :" . mysql_error() . "\n";
}
$queryKonter = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $tmpKonter[0]['nokounter'] + 1), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($queryKonter)) {
$errorDB .= "Update Counter Error :" . mysql_error() . "\n" . $errorDB . "___" . $queryKonter;
}
}
}
}
if ($errorDB != "") {
// Rollback
$where = "nojurnal='" . $nojurnal . "'";
$queryRB = "delete from `" . $dbname . "`.`keu_jurnalht` where " . $where;
$queryRB2 = updateQuery($dbname, 'kebun_aktifitas', array('jurnal' => 0), "notransaksi='" . $dataH[0]['notransaksi'] . "'");
$queryRBKonter = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $tmpKonter[0]['nokounter']), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($queryRB)) {
$errorDB .= "Rollback 1 Error :" . mysql_error() . "\n";
}
if (!mysql_query($queryRB2)) {
$errorDB .= "Rollback 2 Error :" . mysql_error() . "\n";
}
if (!mysql_query($queryRBKonter)) {
$errorDB .= "Rollback Counter Error :" . mysql_error() . "\n";
}
echo "DB Error :\n" . $errorDB . "___" . $queryRB2;
//echo "DB Error :\n".$errorDB."___".$queryRB2;
exit;
} else {
// Posting Success
}
if ($headErr == '') {
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Error : " . addslashes(mysql_error($conn)) . "\n";
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>> Update Kode Jurnal
// $updJurnal = updateQuery($dbname,'keu_5kelompokjurnal',array('nokounter'=>$konter),
// "kodeorg='".$_SESSION['org']['kodeorganisasi'].
// "' and kodekelompok='".$kodeJurnal."'");
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $ptpengguna . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . addslashes(mysql_error($conn)) . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . addslashes(mysql_error($conn)) . "\n";
exit;
}
exit;
} else {
#berhasil di jurnal
// echo "warning: \nheader1pemilik_".$header1pemilik."\nnojurnal_".$nojurnal."\n".$insHead;
// exit;
#proses gudang
$errGudang = '';
function prosesGajiKebun()
{
global $conn;
global $tanggal;
global $param;
global $dbname;
global $defSegment;
#karyawan kebun
#output pada jurnal kolom noreferensi ALK_GAJI
if ($param['komponen'] == 1 or $param['komponen'] == 14) {
$group = 'KBNB0';
} elseif ($param['komponen'] == 16 or $param['komponen'] == 32 or $param['komponen'] == 33) {
$group = 'KBNB1';
} elseif ($param['komponen'] == 28) {
$group = 'KBNB3';
} elseif ($param['komponen'] == 26) {
$group = 'KBNB4';
} elseif ($param['komponen'] == 21) {
$group = 'KBNB5';
} else {
$group = 'KBNB2';
}
//defaultnya tunjangan
$str = "select noakundebet,noakunkredit from " . $dbname . ".keu_5parameterjurnal\r\n where jurnalid='" . $group . "' limit 1";
$res = mysql_query($str);
if (mysql_num_rows($res) < 1) {
exit("Error: No.Akun pada parameterjurnal belum ada untuk " . $param['namakomponen']);
} else {
$akundebet = '';
$akunkredit = '';
$bar = mysql_fetch_object($res);
$akundebet = $bar->noakundebet;
$akunkredit = $bar->noakunkredit;
}
#proses data
$kodeJurnal = $group;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tanggal) . "/" . $_SESSION['empl']['lokasitugas'] . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tanggal, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $param['jumlah'], 'totalkredit' => -1 * $param['jumlah'], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_GAJI', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akundebet, 'keterangan' => $param['namakomponen'] . ' ' . $param['namakaryawan'], 'jumlah' => $param['jumlah'], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => $param['karyawanid'], 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_GAJI', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => $param['subbagian'], 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
# Kredit
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunkredit, 'keterangan' => $param['namakomponen'] . ' ' . $param['namakaryawan'], 'jumlah' => -1 * $param['jumlah'], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => $param['karyawanid'], 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_GAJI', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => $param['subbagian'], 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
/*
#periksa apakah sudah pernah diproses dengan karyawan yang sama
$str="select * from ".$dbname.".keu_jurnaldt where nojurnal
like '".str_replace("-","",$tanggal)."/".$_SESSION['empl']['lokasitugas']."/".$kodeJurnal."/%'
and noakun='".$akundebet."' and nik='".$param['karyawanid']."'";
if(mysql_num_rows(mysql_query($str))>0)
exit("Error: Data sudah pernah di proses");
*
*/
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header BTL Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
echo $insDet;
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Error 2 : " . mysql_error() . "\n";
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header BTL Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
}
case 'edit':
$data = $_POST;
unset($data['nojurnal']);
$data['tanggal'] = tanggalsystem($data['tanggal']);
//echo "warning: <pre>";
//print_r($data);
//echo "<pre>";
$query = updateQuery($dbname, 'keu_jurnalht', $data, "nojurnal='" . $_POST['nojurnal'] . "'");
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
} else {
$data['tanggal'] = tanggalnormal($data['tanggal']);
echo json_encode($data);
}
$dataz['revisi'] = $_POST['revisi'];
$query = updateQuery($dbname, 'keu_jurnaldt', $dataz, "nojurnal='" . $_POST['nojurnal'] . "'");
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
}
// else {
// $dataz['revisi'] = $_POST['revisi'];
// echo json_encode($dataz);
// }
break;
case 'delete':
$query = selectQuery($dbname, 'keu_jurnaldt', 'nojurnal', "nojurnal='" . $data['nojurnal'] . "'");
$res = fetchData($query);
if (empty($res)) {
$qDel = "delete from `" . $dbname . "`.`keu_jurnalht` where nojurnal='" . $data['nojurnal'] . "'";
echo $qDel;
if (!mysql_query($qDel)) {
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'];
$kodevhc = checkPostGet('kodevhc', '');
$kmhmakhir = checkPostGet('kmhmakhir', '');
switch ($proses) {
case 'getKm':
$qKm = selectQuery($dbname, 'vhc_kmhm_track', 'kmhmakhir', "kodevhc='" . $kodevhc . "'");
$resKm = fetchData($qKm);
if (empty($resKm)) {
echo 0;
} else {
echo $resKm[0]['kmhmakhir'];
}
break;
case 'reset':
$dataIns = array($kodevhc, $kmhmakhir);
$qIns = insertQuery($dbname, 'vhc_kmhm_track', $dataIns);
if (!mysql_query($qIns)) {
$dataUpd = array('kmhmakhir' => $kmhmakhir);
$qUpd = updateQuery($dbname, 'vhc_kmhm_track', $dataUpd, "kodevhc='" . $kodevhc . "'");
if (!mysql_query($qUpd)) {
exit("Update KM/HM Error: " . mysql_error());
}
}
break;
}
$ada = false;
$yCek = mysql_query($xCek) or die(mysql_error());
while ($zCek = mysql_fetch_assoc($yCek)) {
$ada = true;
}
if ($ada == true) {
echo "warning : data already exist ";
exit;
}
// Input Budget BJR
$optThnTnm = makeOption($dbname, 'setup_blok', 'kodeorg,tahuntanam', "kodeorg='" . $kdblok . "'");
$dataIns = array('tahunbudget' => $thnbudget, 'kodeorg' => $kdblok, 'thntanam' => $optThnTnm[$kdblok], 'bjr' => $bjr, 'updateby' => $_SESSION['standard']['userid'], 'lastupdate' => date('Y-m-d H:i:s'), 'close' => 0);
$dataUpd = array('bjr' => $bjr, 'updateby' => $_SESSION['standard']['userid'], 'lastupdate' => date('Y-m-d H:i:s'));
$whereUpd = "tahunbudget='" . $thnbudget . "' and kodeorg='" . $kdblok . "' and thntanam='" . $optThnTnm[$kdblok] . "'";
$insBjr = insertQuery($dbname, 'bgt_bjr', $dataIns);
$updBjr = updateQuery($dbname, 'bgt_bjr', $dataUpd, $whereUpd);
if (!mysql_query($insBjr)) {
if (!mysql_query($updBjr)) {
exit("DB Error: " . mysql_error());
}
}
##UNTUK VALIDASI TAHUN DI BJR
// $iCek="select tahunbudget from ".$dbname.".bgt_bjr where tahunbudget='".$thnbudget."' ";
// exit("Error:$xCek");
// $ada=false;
// $nCek=mysql_query($iCek)or die(mysql_error());
// while($dCek=mysql_fetch_assoc($nCek))
// {
// $ada=true;
// }
// if ($ada==false)
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
}
break;
case 'delete':
$where = "nokonosemen='" . $param['nokonosemen'] . "'";
$query = "delete from `" . $dbname . "`.`log_konosemenht` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
case 'posting':
$data = array('postingkirim' => 1);
$where = "nokonosemen='" . $param['nokonosemen'] . "'";
$query = updateQuery($dbname, 'log_konosemenht', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
}
default:
break;
}
function formHeader($mode, $data)
{
global $dbname;
# Default Value
if (empty($data)) {
$data['nokonosemen'] = 'KS' . date('Ymdhi');
$data['nokonosemenexp'] = '';
$data['kodept'] = '';
$data['kodeorg'] = $_SESSION['empl']['lokasitugas'];
# Header
foreach ($data['header'] as $key => $dataDet) {
$queryH = insertQuery($dbname, 'keu_jurnalht', $dataDet);
if (!mysql_query($queryH)) {
$errorDB .= "Header :" . mysql_error() . "\n";
}
}
# Detail
if ($errorDB == '') {
foreach ($dataRes['detail'] as $key => $dataDet) {
$queryD = insertQuery($dbname, 'keu_jurnaldt', $dataDet);
if (!mysql_query($queryD)) {
$errorDB .= "Detail " . $key . " :" . mysql_error() . "\n";
}
}
#update jurnal counter
$queryKonter = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter + 1), "kodeorg='" . $param['pt'] . "' and kodekelompok='" . $kodejurnal . "'");
if (!mysql_query($queryKonter)) {
$errorDB .= "Update Counter Error :" . mysql_error() . "\n" . $errorDB . "___" . $queryKonter;
}
}
if ($errorDB != "") {
# Rollback
foreach ($arrNoJurnal as $key => $nojur) {
$queryRB = "delete from `" . $dbname . "`.`keu_jurnalht` where nojurnal='" . $nojur . "'";
if (!mysql_query($queryRB)) {
$errorDB .= "Rollback 1 Error :" . mysql_error() . "\n";
}
}
echo "Error " . $errorDB;
}
function updateSettings($name, $value)
{
$data = array('value' => $value);
if (!updateQuery(TBL_SETTINGS, $data, "name='" . $name . "'")) {
return false;
} else {
return true;
}
}
if ($data['hutangunit'] == '') {
$data['hutangunit'] = 0;
}
$where = "notransaksi='" . $data['notransaksi'] . "' and kodeorg='" . $data['kodeorg'] . "' and noakun='" . $data['oldNoakun'] . "' and tipetransaksi='" . $data['tipetransaksi'] . "'";
$wheredt = "notransaksi='" . $data['notransaksi'] . "' and kodeorg='" . $data['kodeorg'] . "'";
$datadt['noakun2a'] = $param['noakun'];
$datadt['matauang'] = $param['matauang'];
$datadt['kurs'] = $param['kurs'];
unset($data['notransaksi']);
unset($data['kodeorg']);
unset($data['oldNoakun']);
unset($data['tipetransaksi']);
$data['tanggal'] = tanggalsystem($data['tanggal']);
$data['jumlah'] = str_replace(',', '', $data['jumlah']);
$query = updateQuery($dbname, 'keu_kasbankht', $data, $where);
$querydt = updateQuery($dbname, 'keu_kasbankdt', $datadt, $wheredt);
if (!mysql_query($query)) {
echo "DB Error ht : " . mysql_error();
} else {
if (!mysql_query($querydt)) {
echo "DB Error dt : " . mysql_error();
} else {
echo 'Done.';
}
}
// tadinya ga pake else echo Done, tapi kalo ga pake update-annya ga kesimpen. koq bisa ya?
// tambahan querydt untuk ngupdate noakun2a kasbankdt
break;
case 'delete':
$where = "notransaksi='" . $param['notransaksi'] . "' and kodeorg='" . $param['kodeorg'] . "' and noakun='" . $param['noakun'] . "' and tipetransaksi='" . $param['tipetransaksi'] . "'";
$query = "delete from `" . $dbname . "`.`keu_kasbankht` where " . $where;
$errCounter = "";
if (!mysql_query($queryJ)) {
$errCounter .= "Update Counter Parameter Jurnal Error :" . mysql_error() . "\n";
}
if ($errCounter != "") {
$queryJRB = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $tmpKonter[0]['nokounter']), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $dataD[0]['kode'] . "'");
$errCounter = "";
if (!mysql_query($queryJRB)) {
$errorJRB .= "Rollback Parameter Jurnal Error :" . mysql_error() . "\n";
}
echo "DB Error :\n" . $errorJRB;
exit;
}
#=== Add Counter Jurnal Otomatis === =======================================
if ($dataH[0]['hutangunit'] == 1) {
$queryJ = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konteroto), "kodeorg='" . $indukpemilikhutang . "' and kodekelompok='" . $kodejurnal . "'");
$errCounter = "";
if (!mysql_query($queryJ)) {
$errCounter .= "Update Counter Parameter Jurnal Error :" . mysql_error() . "\n";
}
if ($errCounter != "") {
$queryJRB = updateQuery($dbname, 'keu_5kelompokjurnal', array($noKon[0]['nokounter']), "kodeorg='" . $indukpemilikhutang . "' and kodekelompok='" . $kodejurnal . "'");
$errCounter = "";
if (!mysql_query($queryJRB)) {
$errorJRB .= "Rollback Parameter Jurnal Error :" . mysql_error() . "\n";
}
echo "DB Error :\n" . $errorJRB;
exit;
}
}
}
$query = insertQuery($dbname, 'setup_matauang', $data);
# Insert Data
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error($conn);
}
} elseif ($_POST['proses'] == 'main_edit') {
# Check Valid Data
if ($data['kode'] == '' || $data['matauang'] == '' || $data['simbol'] == '' || $data['kodeiso'] == '') {
echo "Error : Data tidak boleh ada yang kosong";
exit;
}
# Extract Primary Key
unset($data['primField']);
unset($data['primVal']);
$prim = array('field' => $_POST['primField'], 'value' => $_POST['primVal']);
# Create Condition
$where = "`" . $prim['field'] . "`='" . $prim['value'] . "'";
# Make Query
$query = updateQuery($dbname, 'setup_matauang', $data, $where);
# Update Data
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error($conn);
}
} elseif ($_POST['proses'] == 'main_delete') {
# Create Query
$query = "delete from `" . $dbname . "`.`setup_matauang` where `kode`='" . $_POST['primVal'] . "'";
# Delete
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error($conn);
}
}
function updateKmHm($kodevhc)
{
global $dbname;
// Get KM/HM Akhir
$qKm = selectQuery($dbname, 'vhc_kmhmakhir_vw', '*', "kodevhc='" . $kodevhc . "'");
$resKm = fetchData($qKm);
$kmhmAkhir = empty($resKm) ? 0 : $resKm[0]['kmhmakhir'];
$dataIns = array($kodevhc, $kmhmAkhir);
$qIns = insertQuery($dbname, 'vhc_kmhm_track', $dataIns);
if (!mysql_query($qIns)) {
$dataUpd = array('kmhmakhir' => $kmhmAkhir);
$qUpd = updateQuery($dbname, 'vhc_kmhm_track', $dataUpd, "kodevhc='" . $kodevhc . "'");
if (!mysql_query($qUpd)) {
exit("Update KM/HM Error: " . mysql_error());
}
}
}
foreach ($data as $cont) {
$res .= "##" . $cont;
}
$result = "{res:\"" . $res . "\",theme:\"" . $_SESSION['theme'] . "\"}";
echo $result;
break;
case 'edit':
$data = $param;
unset($data['notransaksi']);
foreach ($data as $key => $cont) {
if (substr($key, 0, 5) == 'cond_') {
unset($data[$key]);
}
}
$where = "notransaksi='" . $param['notransaksi'] . "' and kodekegiatan='" . $param['cond_kodekegiatan'] . "' and kodeorg='" . $param['cond_kodeorg'] . "'";
$query = updateQuery($dbname, 'kebun_prestasi', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
echo json_encode($param);
break;
case 'delete':
$where = "notransaksi='" . $param['notransaksi'] . "' and kodekegiatan='" . $param['kodekegiatan'] . "' and kodeorg='" . $param['kodeorg'] . "'";
$query = "delete from `" . $dbname . "`.`kebun_prestasi` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
default:
foreach ($param as $key => $row) {
if (substr($key, 8, 10) == 'tahuntanam') {
$param['tahuntanam'] = $row;
}
}
$data = array();
$data['kodebarang'] = $param['kodebarang'];
$data['jumlah'] = $param['jumlah'];
unset($data['nopengolahan']);
foreach ($data as $key => $cont) {
if (substr($key, 0, 5) == 'cond_') {
unset($data[$key]);
}
}
$where = "nopengolahan='" . $param['nopengolahan'] . "' and kodeorg='" . $param['kodeorg'] . "' and tahuntanam='" . $param['tahuntanam'] . "' and kodebarang='" . $param['cond_kodebarang'] . "'";
$query = updateQuery($dbname, 'pabrik_pengolahan_barang', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
echo json_encode($data);
break;
case 'delete':
foreach ($param as $key => $row) {
if (substr($key, 8, 7) == 'station') {
$param['kodeorg'] = $row;
}
}
foreach ($param as $key => $row) {
if (substr($key, 8, 10) == 'tahuntanam') {
$param['tahuntanam'] = $row;
$satuan = $row['satuan'];
}
$data[] = array('nosj' => $_POST['nosj'], 'kodept' => $_POST['kodept'], 'kodebarang' => $row['kodebarang'], 'jenis' => strtoupper($_POST['jenis']), 'jumlah' => $jumlah, 'satuanpo' => $satuan, 'nopo' => isset($row['nopo']) ? $row['nopo'] : '', 'nopp' => isset($row['nopp']) ? $row['nopp'] : '', 'notransaksireferensi' => '', 'jumlahditerima' => 0);
}
$query = insertQuery($dbname, 'log_suratjalandt', $data);
mysql_query($query) or die("Error DB: " . mysql_error());
}
break;
// Save Detail
// Save Detail
case 'saveDetail':
$where = "nosj='" . $param['nosj'] . "' and kodept='" . $param['kodept'] . "' and kodebarang='" . $param['kodebarang'] . "' and nopo='" . $param['nopo'] . "' and nopp='" . $param['nopp'] . "'";
$cols = "*";
$data = array('jumlah' => $param['jumlah']);
if (isset($param['newNopo'])) {
$data['nopo'] = $param['newNopo'];
$data['nopp'] = $param['newNopp'];
}
$query = updateQuery($dbname, 'log_suratjalandt', $data, $where);
mysql_query($query) or die("Error DB: " . mysql_error());
break;
// Delete Detail
// Delete Detail
case 'deleteDetail':
$where = "nosj='" . $param['nosj'] . "' and kodept='" . $param['kodept'] . "' and kodebarang='" . $param['kodebarang'] . "' and nopo='" . $param['nopo'] . "' and nopp='" . $param['nopp'] . "'";
$query = deleteQuery($dbname, 'log_suratjalandt', $where);
mysql_query($query) or die("Error DB: " . mysql_error());
break;
default:
break;
}
case 'edit':
cekVendorKasKecil();
// Cek Vendor Kas Kecil
$data = $param;
if ($data['kurs'] == 0 || $data['kurs'] == '') {
exit("[ Error ]: The value of the kurs rate there should be.");
}
unset($data['notransaksi']);
foreach ($data as $key => $cont) {
if (substr($key, 0, 5) == 'cond_') {
unset($data[$key]);
}
}
$data['jumlah'] = str_replace(',', '', $data['jumlah']);
$where = "notransaksi='" . $param['notransaksi'] . "' and noakun='" . $param['cond_noakun'] . "' and tipetransaksi='" . $param['tipetransaksi'] . "' and noakun2a='" . $param['noakun2a'] . "' and keterangan1='" . $param['cond_keterangan1'] . "' and keterangan2='" . $param['cond_keterangan2'] . "' and kodeorg='" . $param['kodeorg'] . "'";
$query = updateQuery($dbname, 'keu_kasbankdt', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
echo json_encode($param);
break;
case 'delete':
$where = "notransaksi='" . $param['notransaksi'] . "' and kodeorg='" . $param['kodeorg'] . "' and noakun='" . $param['noakun'] . "' and noakun2a='" . $param['noakun2a'] . "' and tipetransaksi='" . $param['tipetransaksi'] . "' and keterangan1='" . $param['keterangan1'] . "'\n\t\t\t\t and keterangan2='" . $param['keterangan2'] . "'";
$query = "delete from `" . $dbname . "`.`keu_kasbankdt` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
case 'updField':
function prosesAlokasi()
{
global $conn;
global $tanggal;
global $param;
global $dbname;
global $defSegment;
#1 ambil periode akuntansi
$str = "select tanggalmulai,tanggalsampai from " . $dbname . ".setup_periodeakuntansi where \r\n kodeorg ='" . $_SESSION['empl']['lokasitugas'] . "' and tutupbuku=0";
$tgmulai = '';
$tgsampai = '';
$res = mysql_query($str);
if (mysql_num_rows($res) < 1) {
exit("Error: Tidak ada periode akuntansi untuk induk " . $_SESSION['empl']['lokasitugas']);
}
while ($bar = mysql_fetch_object($res)) {
$tgsampai = $bar->tanggalsampai;
$tgmulai = $bar->tanggalmulai;
}
if ($tgmulai == '' || $tgsampai == '') {
exit("Error: Periode akuntasi tidak terdaftar");
}
#2 output pada jurnal kolom noreferensi ALK_KERJA_AB
$group = 'VHC1';
#ambil akun alokasi
$str = "select noakundebet from " . $dbname . ".keu_5parameterjurnal\r\n where jurnalid='" . $group . "' limit 1";
$res = mysql_query($str);
if (mysql_num_rows($res) < 1) {
exit("Error: No.Akun pada parameterjurnal belum ada untuk VHC1");
} else {
$bar = mysql_fetch_object($res);
$akunalok = $bar->noakundebet;
}
#3 ambil semua lokasi kegiatan
$str = "select sum(a.jumlah) as jlh,a.alokasibiaya,b.noakun,a.kodesegment from " . $dbname . ".vhc_rundt a\r\n left join " . $dbname . ".vhc_kegiatan b on a.jenispekerjaan=b.kodekegiatan\r\n left join " . $dbname . ".vhc_runht c on a.notransaksi=c.notransaksi \r\n where c.kodevhc='" . $param['kodevhc'] . "'\r\n and c.tanggal>='" . $tgmulai . "' and c.tanggal <='" . $tgsampai . "' and alokasibiaya!='' \r\n and jenispekerjaan!='' \r\n group by jenispekerjaan,noakun,alokasibiaya,kodesegment";
// if($param['kodevhc']=='B9530XR'){
// echo "Error".$str;exit();
// }
$res = mysql_query($str);
//echo mysql_error($conn);
$lokasi = array();
$biaya = array();
$jam = array();
$akun = array();
$kodeasset = array();
$segment = array();
$ttl = 0;
while ($bar = mysql_fetch_object($res)) {
#kusus jika project
if (substr($bar->alokasibiaya, 0, 2) == 'AK' or substr($bar->alokasibiaya, 0, 2) == 'PB') {
#ambil akun aktiva dalam konstruksi
$tipeasset = substr($bar->alokasibiaya, 3, 3);
$tipeasset = str_replace("0", "", $tipeasset);
$str1 = "select akunak from " . $dbname . ".sdm_5tipeasset where kodetipe='" . $tipeasset . "'";
$res1 = mysql_query($str1);
if (mysql_num_rows($res1) < 1) {
exit(" Error: Akun aktiva dalam konstruksi untuk " . $tipeasset . " beum disetting dari keuangan->setup->tipeasset");
} else {
while ($bar1 = mysql_fetch_object($res1)) {
if ($bar1->akunak == '') {
exit(" Error: Akun aktiva dalam konstruksi untuk " . $tipeasset . " beum disetting dari keuangan->setup->tipeasset");
} else {
$akun[] = $bar1->akunak;
}
}
$kodeasset[] = $bar->alokasibiaya;
$lokasi[] = $bar->alokasibiaya;
$jam[] = $bar->jlh;
$biaya[] = $bar->jlh * $param['jumlah'];
$kegiatan[] = '';
$segment[] = $bar->kodesegment;
}
} else {
$lokasi[] = $bar->alokasibiaya;
$akun[] = $bar->noakun;
$jam[] = $bar->jlh;
$biaya[] = $bar->jlh * $param['jumlah'];
$kegiatan[] = $bar->noakun . "01";
$kodeasset[] = '';
$segment[] = $bar->kodesegment;
}
}
// foreach ($jam as $key=>$val)
// {
// $biaya[$key] =$val*$param['jumlah'];
// }
foreach ($biaya as $key => $nilai) {
#periksa unit
$dataRes['header'] = array();
$dataRes['detail'] = array();
$intern = true;
$pengguna = substr($lokasi[$key], 0, 4);
if (substr($lokasi[$key], 0, 2) == 'AK' or substr($lokasi[$key], 0, 2) == 'PB') {
#khusus project
$str = "select kodeorg from " . $dbname . ".project where kode='" . $lokasi[$key] . "'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$pengguna = $bar->kodeorg;
$lokasi[$key] = '';
}
}
#ambil piutang ke pengguna
$str = "select akunpiutang,jenis from " . $dbname . ".keu_5caco where kodeorg='" . $pengguna . "'";
$res = mysql_query($str);
$intraco = '';
$interco = '';
while ($bar = mysql_fetch_object($res)) {
if ($bar->jenis == 'intra') {
$intraco = $bar->akunpiutang;
} else {
$interco = $bar->akunpiutang;
}
}
#++++++++++++++++++++++++++++++++++++++
$akunpekerjaan = $akun[$key];
#++++++++++++++++++++++++++++++++++++++++
$ptpengguna = '';
$str = "select induk from " . $dbname . ".organisasi where kodeorganisasi='" . $pengguna . "'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$ptpengguna = $bar->induk;
}
$ptGudang = '';
$str = "select induk from " . $dbname . ".organisasi where kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$ptGudang = $bar->induk;
}
#jika pt tidak sama maka pakai akun interco
$akunpengguna = '';
if ($ptGudang != $ptpengguna) {
#ambil akun interco
$intern = false;
$str = "select akunhutang from " . $dbname . ".keu_5caco where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and jenis='inter'";
$res = mysql_query($str);
$akunpengguna = '';
while ($bar = mysql_fetch_object($res)) {
$akunpengguna = $bar->akunhutang;
}
$akunsendiri = $interco;
if ($akunpengguna == '') {
exit("Error: Akun intraco atau interco belum ada untuk unit " . $pengguna);
}
} else {
if ($pengguna != $_SESSION['empl']['lokasitugas']) {
#jika satu pt beda kebun
#ambil akun intraco
$intern = false;
$str = "select akunhutang from " . $dbname . ".keu_5caco where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and jenis='intra'";
$res = mysql_query($str);
$akunpengguna = '';
while ($bar = mysql_fetch_object($res)) {
$akunpengguna = $bar->akunhutang;
}
$akunsendiri = $intraco;
if ($akunpengguna == '') {
exit("Error: Akun intraco atau interco belum ada untuk unit " . $pengguna);
}
} else {
$intern = true;
}
}
if ($intern) {
#proses data
$kodeJurnal = $group;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tanggal) . "/" . $_SESSION['empl']['lokasitugas'] . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tanggal, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $biaya[$key], 'totalkredit' => -1 * $biaya[$key], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_KERJA_AB', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunpekerjaan, 'keterangan' => $param['periode'] . ':Biaya Kendaraan ' . $param['kodevhc'], 'jumlah' => $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => $kodeasset[$key], 'kodebarang' => '', 'nik' => 0, 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
# Kredit
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunalok, 'keterangan' => $param['periode'] . ':Alokasi biaya kend' . $param['kodevhc'], 'jumlah' => -1 * $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header Intern Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Intern Error : " . mysql_error() . "\n";
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
} else {
# Data Detail
$noUrut = 1;
#proses data
$kodeJurnal = $group;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tanggal) . "/" . $_SESSION['empl']['lokasitugas'] . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tanggal, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $biaya[$key], 'totalkredit' => -1 * $biaya[$key], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_KERJA_AB', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunsendiri, 'keterangan' => $param['periode'] . ':Biaya Kendaraan ' . $param['kodevhc'], 'jumlah' => $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
# Kredit
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunalok, 'keterangan' => $param['periode'] . ':Alokasi biaya kend' . $param['kodevhc'], 'jumlah' => -1 * $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header Ex.Self Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Ex.Self Error : " . mysql_error() . "\n";
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
#+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#sisi Pengguna
$kodeJurnal = $group;
#ambil periodeaktif pengguna
// $strd="select tanggalmulai,tanggalsampai from ".$dbname.".setup_periodeakuntansi where
// kodeorg='".$pengguna."' and tutupbuku=0";
//
// $resd=mysql_query($strd);
// $tgmulaid='';
// while($bard=mysql_fetch_object($resd))
// {
// $tgmulaid = $bard->tanggalmulai;
// }
// if($tgmulaid=='' or substr($tgmulaid,0,7)==substr($tanggal,0,7))#jika periode sama maka biarkan
$tgmulaid = $tanggal;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $ptpengguna . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tgmulaid) . "/" . $pengguna . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
unset($dataRes['header']);
//ganti header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tgmulaid, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $biaya[$key], 'totalkredit' => -1 * $biaya[$key], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_KERJA_AB', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
//print_r($dataRes['header']);
//exit("Error");
# Debet 1
$noUrut = 1;
unset($dataRes['detail']);
//ganti header
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tgmulaid, 'nourut' => $noUrut, 'noakun' => $akunpekerjaan, 'keterangan' => $param['periode'] . ':Biaya Kendaraan ' . $param['kodevhc'], 'jumlah' => $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $pengguna, 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => $kodeasset[$key], 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
# Kredit 1
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tgmulaid, 'nourut' => $noUrut, 'noakun' => $akunpengguna, 'keterangan' => $param['periode'] . ':Alokasi biaya kend' . $param['kodevhc'], 'jumlah' => -1 * $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $pengguna, 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header OSIDE Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail OSIDE Error : " . mysql_error() . "\n" . $insDet;
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $ptpengguna . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
}
}
}
$RBDet1 = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal1 . "'");
if (!mysql_query($RBDet1)) {
$RBErr .= "Rollback Delete Header 1 Error : " . mysql_error() . "\n";
exit;
}
$RBDet2 = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal2 . "'");
if (!mysql_query($RBDet2)) {
$RBErr .= "Rollback Delete Header 2 Error : " . mysql_error() . "\n";
exit;
}
# Rollback Update
$RBJurnal1 = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter1 - 1), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodejurnal1 . "'");
if (!mysql_query($RBJurnal1)) {
$RBErr .= "Rollback Update Jurnal 1 Error : " . mysql_error() . "\n";
}
$RBJurnal2 = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter2 - 1), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodejurnal2 . "'");
if (!mysql_query($RBJurnal2)) {
$RBErr .= "Rollback Update Jurnal 2 Error : " . mysql_error() . "\n";
}
if ($RBErr != '') {
echo $RBErr;
}
exit;
} else {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Success
echo '1';
}
}
} else {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail failed
echo $detailErr;
#========================== Proses Insert dan Update ==========================
# Header and Detail inserted
# Update Status Tutup Buku
$queryUpd = updateQuery($dbname, 'setup_periodeakuntansi', array('tutupbuku' => 1), "kodeorg='" . $param['kodeorg'] . "' and periode='" . $param['periode'] . "'");
if (!mysql_query($queryUpd)) {
echo 'Error Update : ' . mysql_error();
exit;
} else {
# Insert periode baru
$dataIns = array('kodeorg' => $param['kodeorg'], 'periode' => $tahunLanjut . '-' . addZero($bulanLanjut, 2), 'tanggalmulai' => $tglAwal, 'tanggalsampai' => $tglAkhir, 'tutupbuku' => 0);
$queryIns = insertQuery($dbname, 'setup_periodeakuntansi', $dataIns);
echo '1';
if (!mysql_query($queryIns)) {
# Rollback
echo 'Error Insert : ' . mysql_error();
$queryRB = updateQuery($dbname, 'setup_periodeakuntansi', array('tutupbuku' => 0), "kodeorg='" . $param['kodeorg'] . "' and periode='" . $param['periode'] . "'");
if (!mysql_query($queryRB)) {
echo 'Error Rollback Update : ' . mysql_error();
exit;
}
} else {
//update history tutup buku
$str = "delete from " . $dbname . ".keu_setup_watu_tutup where periode='" . $param['periode'] . "' and kodeorg='" . $param['kodeorg'] . "'";
mysql_query($str);
$str = "insert into " . $dbname . ".keu_setup_watu_tutup(kodeorg,periode,username) values(\n '" . $param['kodeorg'] . "','" . $param['periode'] . "','" . $_SESSION['standard']['username'] . "')";
mysql_query($str);
}
}
} else {
echo $detailErr;
# Rollback, Delete Header
unset($data['matauang']);
unset($data['numRow1']);
unset($data['numRow2']);
$data['jumlahrealisasi'] = str_replace(',', '', $data['jumlahrealisasi']);
$data['jjgkontanan'] = str_replace(',', '', $data['jjgkontanan']);
# Empty Data
foreach ($data as $cont) {
if ($cont == '') {
echo 'Warning : Data tidak boleh ada yang kosong';
exit;
}
}
# Convert Tanggal
$param['tanggal'] = tanggalsystem($param['tanggal']);
$where = "notransaksi='" . $param['notransaksi'] . "' and kodeblok='" . $param['blokalokasi'] . "' and kodekegiatan='" . $param['kodekegiatan'] . "' and tanggal='" . $param['tanggal'] . "' and blokspkdt='" . $param['kodeblok'] . "' and kodesegment='" . $param['kodesegment'] . "'";
$query = updateQuery($dbname, 'log_baspk', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
case 'delete':
# Convert Tanggal
$param['tanggal'] = tanggalsystem($param['tanggal']);
$where = "notransaksi='" . $param['notransaksi'] . "' and kodeblok='" . $param['blokalokasi'] . "' and kodekegiatan='" . $param['kodekegiatan'] . "' and tanggal='" . $param['tanggal'] . "' and blokspkdt='" . $param['kodeblok'] . "' and kodesegment='" . $param['kodesegment'] . "'";
$query = "delete from `" . $dbname . "`.`log_baspk` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
} else {
echo $listbutton . $list0 . $list2 . $list3;
}
break;
case 'post':
#delete first
$sdel = "delete from " . $dbname . ".sdm_gaji " . " where idkomponen not in ('28','46','47') " . " and periodegaji='" . $param['periodegaji'] . "' and kodeorg='" . $param['kodeorg'] . "' " . " and karyawanid in (select distinct karyawanid from " . $dbname . ".datakaryawan " . " where sistemgaji='Harian' and lokasitugas='" . $param['kodeorg'] . "')";
//exit("Error:$sdel");
mysql_query($sdel) or die(mysql_error($conn));
# Insert All ready data
$insError = "";
foreach ($readyData as $row) {
if ($row['jumlah'] == 0 or $row['jumlah'] == '') {
continue;
} else {
$queryIns = insertQuery($dbname, 'sdm_gaji', $row);
if (!mysql_query($queryIns)) {
$queryUpd = updateQuery($dbname, 'sdm_gaji', $row, "kodeorg='" . $row['kodeorg'] . "' and periodegaji='" . $row['periodegaji'] . "' and karyawanid='" . $row['karyawanid'] . "' and idkomponen=" . $row['idkomponen']);
$tmpErr = mysql_error($conn);
if (!mysql_query($queryUpd)) {
echo "DB Insert Error :" . $tmpErr . "\n";
print_r($row);
echo "DB Update Error :" . mysql_error($conn) . "\n";
}
}
}
}
break;
default:
break;
}
}
$data['tanggal'] = tanggalsystem($data['tanggal']);
$cols = array('kodeorg', 'notransaksi', 'tanggal', 'divisi', 'koderekanan');
$query = insertQuery($dbname, 'log_spkht', $data, $cols);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
}
break;
# Proses Edit Header
# Proses Edit Header
case 'edit':
$data = $_POST;
$where = "nopengolahan='" . $data['nopengolahan'] . "'";
unset($data['nopengolahan']);
$data['tanggal'] = tanggalsystem($data['tanggal']);
$query = updateQuery($dbname, 'log_spkht', $data, $where);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
}
break;
case 'delete':
$where = "notransaksi='" . $param['notransaksi'] . "'";
$query = "delete from `" . $dbname . "`.`log_spkht` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
break;
default:
break;
}
