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;
}
}
}
}
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
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
#email notifikasi bjr
// ambil BJR bulan lalu
// ambil BJR bulan ini
// bila BJRBI<BJRBL imel ke manager n gm ybs
// bila BJRBI>=BJRBL nothing
// bila BJRBL belum ada nothing
function posting($kodeorg, $periode, $jumlah, $dbname, $conn)
{
// Default Segment
$defSegment = colDefaultValue($dbname, 'keu_5segment', 'kodesegment');
$tgl1 = '';
$tgl2 = '';
$str = "select tanggalmulai,tanggalsampai from " . $dbname . ".sdm_5periodegaji where kodeorg='" . $kodeorg . "'\r\n and periode='" . $periode . "' and jenisgaji='H'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$tgl1 = str_replace("-", "", $bar->tanggalmulai);
$tgl2 = str_replace("-", "", $bar->tanggalsampai);
}
if ($tgl1 == '' or $tgl2 == '') {
exit(" Error: Periode penggajian Harian tidak ditemukan/ Daily base payrol period not found");
}
//periksa periode akuntansi
$str = "select * from " . $dbname . ".setup_periodeakuntansi where kodeorg='" . $kodeorg . "' \r\n and periode='" . $periode . "' and tutupbuku=0";
$res = mysql_query($str);
if (mysql_num_rows($res) == 0) {
exit(" Error: Sorry, accounting period is not active on choson period");
}
//periksa periode penggajian unit untuk memastikan apakah sudah selesai inputan BKM,KKD,ABSENSI
$str = "select sudahproses from " . $dbname . ".sdm_5periodegaji where kodeorg='" . $kodeorg . "' \r\n and periode='" . $periode . "' and sudahproses=0";
$res = mysql_query($str);
if (mysql_num_rows($res) > 0) {
exit(" Error: Sorry, input for presence, CARLOG and Foreman daoly book not yet close, please make sure for those transaction by confirmation via Setu->Periode Penggajian unit");
}
//periksa tipe organisasi
$str = "select tipe from " . $dbname . ".organisasi where kodeorganisasi='" . $kodeorg . "'";
$res = mysql_query($str);
$tipe = 'KANWIL';
while ($bar = mysql_fetch_object($res)) {
$tipe = $bar->tipe;
}
if ($tipe == 'KEBUN') {
//ambil noakun dari parameter jurnal
$debet = '';
$kredit = '';
$nojurnal = str_replace("-", "", $periode) . "28/" . $kodeorg . "/CT01/001";
$str = "select noakundebet,noakunkredit from " . $dbname . ".keu_5parameterjurnal where jurnalid='CT01'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$debet = $bar->noakundebet;
$kredit = $bar->noakunkredit;
}
if ($debet == '' or $kredit == '') {
exit('Error: Journal parameter for CT01 not defined, contact administrator');
}
$kodejurnal = 'CT01';
//ambil porsi biaya umum
$byumum = 0;
$str = "select sum(jumlahrupiah) as byumum from " . $dbname . ".sdm_catu where periodegaji='" . $periode . "' \r\n and kodeorg='" . $kodeorg . "' and subbagian=''";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$byumum = $bar->byumum;
}
$bytanaman = $jumlah - $byumum;
//prepare jurnal
# Prep Header
$dataRes = array();
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodejurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'tanggalentry' => date('Ymd'), 'posting' => '1', 'totaldebet' => $jumlah, 'totalkredit' => $jumlah * -1, 'amountkoreksi' => '0', 'noreferensi' => 'CT01', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
//jika biaya umum>0
if ($byumum > 0) {
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $byumum, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
//ambil kodeblok dan kegiatan untuk melengkapi sisi debet
#1 ambil noakun panen
$akunpanen = '';
$str = "select noakundebet from " . $dbname . ".keu_5parameterjurnal where jurnalid='PNN01'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$akunpanen = $bar->noakundebet;
}
if ($akunpanen == '') {
exit(" Error: Account for harvesting not defined in journal parameter PNN01");
}
#2 Ambil blok panen
$sAbsn = "select distinct kodeorg from " . $dbname . ".kebun_prestasi_vw \r\n where tanggal between '" . $tgl1 . "' and '" . $tgl2 . "' and unit ='" . $kodeorg . "'";
$respanen = mysql_query($sAbsn);
$jml_baris = mysql_num_rows($respanen);
#3 ambil noakun dan blok perawatan
$sAbsn = "select distinct noakun,kodeorg,kodekegiatan from " . $dbname . ".kebun_perawatan_vw \r\n where tanggal between '" . $tgl1 . "' and '" . $tgl2 . "' and unit ='" . $kodeorg . "'";
$resrawat = mysql_query($sAbsn);
$jml_baris += mysql_num_rows($resrawat);
#4 dibagi per masing-masing baris
if ($jml_baris == 0 and $bytanaman > 0) {
#jika tidak ada pekerjaan lapangan
#kembalikan ke biaya umum
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $bytanaman, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
} else {
$biayaperblok = $bytanaman / $jml_baris;
}
if ($biayaperblok > 0 and $jml_baris > 0) {
#5 Bentuk detail jurnal pelengkap disisi debet
while ($bar = mysql_fetch_object($respanen)) {
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $akunpanen, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $biayaperblok, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => $akunpanen . "01", 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => $bar->kodeorg, 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
while ($bar = mysql_fetch_object($resrawat)) {
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $bar->noakun, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $biayaperblok, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => $bar->kodekegiatan, 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => $bar->kodeorg, 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
}
# Kredit (Kreditnya cukup satu saja)
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $kredit, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => -1 * $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
} else {
if ($tipe == 'TRAKSI') {
$debet = '';
$kredit = '';
$nojurnal = str_replace("-", "", $periode) . "28/" . $kodeorg . "/CT03/001";
$str = "select noakundebet,noakunkredit from " . $dbname . ".keu_5parameterjurnal where jurnalid='CT03'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$debet = $bar->noakundebet;
$kredit = $bar->noakunkredit;
}
if ($debet == '' or $kredit == '') {
exit('Error: Journal parameter for CT03 (Traksi) not defined, contact administrator');
}
$kodejurnal = 'CT03';
#1 Ambil semua kendaraan yang bekerja di bulan ini
$str = "select distinct kodevhc from " . $dbname . ".vhc_runht where tanggal between '" . $tgl1 . "' and '" . $tgl2 . "' \r\n and kodeorg ='" . $kodeorg . "'";
$res = mysql_query($str);
$jml_baris = mysql_num_rows($res);
//prepare jurnal
# Prep Header
$dataRes = array();
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodejurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'tanggalentry' => date('Ymd'), 'posting' => '1', 'totaldebet' => $jumlah, 'totalkredit' => $jumlah * -1, 'amountkoreksi' => '0', 'noreferensi' => 'CT03', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
if ($jml_baris == 0) {
//jika tidak ada pekerjaan kendaraan
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT03', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
} else {
$byperkendaraan = $jumlah / $jml_baris;
while ($bar = mysql_fetch_object($res)) {
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $byperkendaraan, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT03', 'noaruskas' => '', 'kodevhc' => $bar->kodevhc, 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
}
# Kredit (Kreditnya cukup satu saja)
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $kredit, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => -1 * $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT03', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
} else {
if ($tipe == 'PABRIK') {
$debet = '';
$kredit = '';
$nojurnal = str_replace("-", "", $periode) . "28/" . $kodeorg . "/CT04/001";
$str = "select noakundebet,noakunkredit from " . $dbname . ".keu_5parameterjurnal where jurnalid='CT04'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$debet = $bar->noakundebet;
$kredit = $bar->noakunkredit;
}
if ($debet == '' or $kredit == '') {
exit('Error: Journal parameter CT04 (PKS) not defined');
}
$kodejurnal = 'CT04';
//ambil porsi biaya umum
$byumum = 0;
$str = "select sum(jumlahrupiah) as byumum from " . $dbname . ".sdm_catu where periodegaji='" . $periode . "' \r\n and kodeorg='" . $kodeorg . "' and subbagian=''";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$byumum = $bar->byumum;
}
$bystasiun = $jumlah - $byumum;
#1 Ambil semua statiun yang ada dalam pks
$str = "select kodeorganisasi from " . $dbname . ".organisasi where tipe='STATION' \r\n and induk ='" . $kodeorg . "'";
$res = mysql_query($str);
$jml_baris = mysql_num_rows($res);
//prepare jurnal
# Prep Header
$dataRes = array();
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodejurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'tanggalentry' => date('Ymd'), 'posting' => '1', 'totaldebet' => $jumlah, 'totalkredit' => $jumlah * -1, 'amountkoreksi' => '0', 'noreferensi' => 'CT04', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
if ($jml_baris == 0) {
//jika tidak ada pekerjaan kendaraan
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT04', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
} else {
//biaya umum masuk dulu
if ($byumum > 0) {
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $byumum, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT04', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
//bagi biaya station ke setiap station
$byperstasiun = $bystasiun / $jml_baris;
while ($bar = mysql_fetch_object($res)) {
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $byperstasiun, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT04', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => $bar->kodeorganisasi, 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
}
# Kredit (Kreditnya cukup satu saja)
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $kredit, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => -1 * $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT04', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
} else {
$debet = '';
$kredit = '';
$nojurnal = str_replace("-", "", $periode) . "28/" . $kodeorg . "/CT01/001";
$str = "select noakundebet,noakunkredit from " . $dbname . ".keu_5parameterjurnal where jurnalid='CT01'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$debet = $bar->noakundebet;
$kredit = $bar->noakunkredit;
}
if ($debet == '' or $kredit == '') {
exit('Error: Journal parameter CT01 (Kebun) not defined');
}
$kodejurnal = 'CT01';
//prepare jurnal
# Prep Header
$dataRes = array();
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodejurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'tanggalentry' => date('Ymd'), 'posting' => '1', 'totaldebet' => $jumlah, 'totalkredit' => $jumlah * -1, 'amountkoreksi' => '0', 'noreferensi' => 'CT01', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $debet, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => str_replace("-", "", $periode) . "28", 'nourut' => $noUrut, 'noakun' => $kredit, 'keterangan' => 'Catu Beras -' . $periode, 'jumlah' => -1 * $jumlah, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $kodeorg, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'CT01', 'noaruskas' => '', 'kodevhc' => '', 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
}
}
}
#execute
#========================== Proses Insert dan Update ==========================
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Header
$headErr = '';
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header Error : ' . mysql_error() . "\n";
}
if ($headErr == '') {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Error : " . mysql_error() . "\n";
break;
}
}
if ($detailErr == '') {
#update sdm_catu status posting
$str = "update " . $dbname . ".sdm_catu set posting=1 where kodeorg='" . $kodeorg . "' and periodegaji='" . $periode . "'";
mysql_query($str);
} 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;
}
}
$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;
}
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;
}
}
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . addslashes(mysql_error($conn)) . "\n";
//hapus juga sisi pemilik
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $header1pemilik . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header pemilik Error : " . addslashes(mysql_error($conn)) . "\n";
exit;
}
}
}
} else {
echo $headErr;
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $header1pemilik . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . addslashes(mysql_error($conn)) . "\n";
exit;
}
}
#============================================================================
} else {
#jika aktiva hanya proses data gudang saja tanpa masuk ke jurnal
#proses gudang
$errGudang = '';
if (!mysql_query($strupdate)) {
// echo" Gagal update saldobulanan";
echo " Error update saldobulanan";
} else {
#update masterbarangdt
/**
* rbJournal
* Rollback Jurnal Transaksi Adjustment
*/
function rbJournal($nojurnal)
{
global $dbname;
$qDel = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($qDel)) {
echo "Rollback Error: " . mysql_error();
}
}
$where = "notransaksi='" . $data['notransaksi'] . "'";
unset($data['notransaksi']);
$data['tanggal'] = tanggalsystem($data['tanggal']);
$data['dari'] = tanggalsystem($data['dari']);
$data['sampai'] = tanggalsystem($data['sampai']);
$data['nilaikontrak'] = str_replace(',', '', $data['nilaikontrak']);
$data['matauang'] = $data['matauang'];
$data['ppnnilaikontrak'] = '0';
unset($data['tax']);
$query = updateQuery($dbname, 'log_spkht', $data, $where);
//exit("Error:".$query);
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
} else {
// Delete Pajak
$qDel = deleteQuery($dbname, 'log_spk_tax', "notransaksi='" . $param['notransaksi'] . "'");
if (!mysql_query($qDel)) {
exit("Delete Tax Error: " . mysql_error());
} else {
// Insert Detail Pajak
$dataIns = array();
print_r($param);
foreach ($param['tax'] as $akun => $nilai) {
if ($nilai > 0) {
$dataIns[] = array('kodeorg' => $param['kodeorg'], 'notransaksi' => $param['notransaksi'], 'noakun' => $akun, 'nilai' => $nilai);
}
}
$qIns = insertQuery($dbname, 'log_spk_tax', $dataIns);
echo $qIns;
if (!mysql_query($qIns)) {
exit("Insert Tax Error: " . mysql_error());
$tab .= "</td></tr></tbody>";
}
$tab .= "</table>";
echo $tab;
break;
case 'proses':
// Get Data Jumlah Total per Kunci
$qJumlah = selectQuery($dbname, 'bgt_budget', 'kunci,volume,rupiah', "kunci in ('" . implode("','", $param['kunci']) . "')");
$resJumlah = fetchData($qJumlah);
// Get Total Sebaran
$totalSebaran = 0;
foreach ($param['sebar'] as $k => $r) {
$totalSebaran += $r;
}
// Delete bgt_distribusi
$qDel = deleteQuery($dbname, 'bgt_distribusi', "kunci in ('" . implode("','", $param['kunci']) . "')");
// Insert per Kunci
if (!mysql_query($qDel)) {
exit("DB Error: " . mysql_error());
} else {
$dataIns = array();
foreach ($resJumlah as $row) {
$dataIns[] = array('kunci' => $row['kunci'], 'rp01' => $row['rupiah'] * $param['sebar']['01'] / $totalSebaran, 'fis01' => $row['volume'] * $param['sebar']['01'] / $totalSebaran, 'rp02' => $row['rupiah'] * $param['sebar']['02'] / $totalSebaran, 'fis02' => $row['volume'] * $param['sebar']['02'] / $totalSebaran, 'rp03' => $row['rupiah'] * $param['sebar']['03'] / $totalSebaran, 'fis03' => $row['volume'] * $param['sebar']['03'] / $totalSebaran, 'rp04' => $row['rupiah'] * $param['sebar']['04'] / $totalSebaran, 'fis04' => $row['volume'] * $param['sebar']['04'] / $totalSebaran, 'rp05' => $row['rupiah'] * $param['sebar']['05'] / $totalSebaran, 'fis05' => $row['volume'] * $param['sebar']['05'] / $totalSebaran, 'rp06' => $row['rupiah'] * $param['sebar']['06'] / $totalSebaran, 'fis06' => $row['volume'] * $param['sebar']['06'] / $totalSebaran, 'rp07' => $row['rupiah'] * $param['sebar']['07'] / $totalSebaran, 'fis07' => $row['volume'] * $param['sebar']['07'] / $totalSebaran, 'rp08' => $row['rupiah'] * $param['sebar']['08'] / $totalSebaran, 'fis08' => $row['volume'] * $param['sebar']['08'] / $totalSebaran, 'rp09' => $row['rupiah'] * $param['sebar']['09'] / $totalSebaran, 'fis09' => $row['volume'] * $param['sebar']['09'] / $totalSebaran, 'rp10' => $row['rupiah'] * $param['sebar']['10'] / $totalSebaran, 'fis10' => $row['volume'] * $param['sebar']['10'] / $totalSebaran, 'rp11' => $row['rupiah'] * $param['sebar']['11'] / $totalSebaran, 'fis11' => $row['volume'] * $param['sebar']['11'] / $totalSebaran, 'rp12' => $row['rupiah'] * $param['sebar']['12'] / $totalSebaran, 'fis12' => $row['volume'] * $param['sebar']['12'] / $totalSebaran, 'updateby' => $_SESSION['standard']['userid'], 'lastupdate' => date('Y-m-d H:i:s'));
}
$qIns = insertQuery($dbname, 'bgt_distribusi', $dataIns);
if (!mysql_query($qIns)) {
exit("DB Insert Error: " . mysql_error());
}
}
break;
}
/**
* rbJournal
* Rollback Journal / Delete Journal
*/
public function rbJournal($nojurnal)
{
global $dbname;
$qDel = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
$qDel2 = deleteQuery($dbname, 'keu_jurnaldt', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($qDel2)) {
exit("Rollback Jurnal Error: " . mysql_error());
} elseif (!mysql_query($qDel)) {
exit("Rollback Jurnal Error: " . mysql_error());
}
}
if (!mysql_query($qUpd)) {
exit("DB Error SJ not updated\n" . mysql_error());
}
}
}
}
} else {
$errBrg[$row['kodebarang']] = $row['kodebarang'];
$jmlhBrg[$row['kodebarang']] = $row['jumlah'];
}
}
if (!empty($errorDt)) {
// Rollback
$qRB = deleteQuery($dbname, 'log_transaksidt', "notransaksi='" . $param['notransaksi'] . "'");
if (mysql_query($qRB)) {
$qRB2 = deleteQuery($dbname, 'log_transaksiht', "notransaksi='" . $param['notransaksi'] . "'");
mysql_query($qRB2);
}
exit("Detail Error\n" . $errorDt);
}
//ambil data untuk ditampilkan
$strj = "select a.* from " . $dbname . ".log_transaksidt a \r\n\t\twhere a.notransaksi='" . $param['notransaksi'] . "'";
$resj = mysql_query($strj);
$no = 0;
$tab = '';
while ($barj = mysql_fetch_object($resj)) {
$no += 1;
//ambil namabarang
$namabarangk = '';
$strk = "select namabarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $barj->kodebarang . "'";
$resk = mysql_query($strk);
if (isset($_POST['submitId'])) {
$SkypeId = $_POST["SkypeId"];
if ($SkypeId == "") {
echo "<script src=\"style/js/bootbox.min.js\"></script>";
echo "<script type=\"text/javascript\"> bootbox.alert(\"Please enter a valid Skype ID\", function(e){\n\t\t\t});\n\t\t\t</script>";
} else {
$query = "INSERT INTO ipmapping.ip_info ( ID, IP_Public, IP_Internal, TimeStamp) Values ('{$SkypeId}', \"\", \"\", \"\")";
$result = add_ID($SkypeId);
}
}
//Handler when the user deletes a Skype ID
if (isset($_POST['removeId'])) {
$SkypeId = $sel_Id;
$query = "DELETE FROM ipmapping.ip_info WHERE ID='{$SkypeId}'";
$query2 = "DELETE FROM ipmapping.ip_status WHERE ID='{$SkypeId}'";
$result2 = deleteQuery($query, $query2, $SkypeId);
}
//Handler when the user views details of a particular Skype ID
if (isset($_POST['viewDetails'])) {
redirect_to("viewdetails.php?Id={$sel_Id}");
}
?>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<meta charset="utf-8">
<title>Skype ID Mapping</title>
<style type="text/css">
</style>
<link rel="stylesheet" href="style/css/bootstrap.css" type="text/css"/>
<link rel="stylesheet" href="style/css/bootstrap.min.css" type="text/css" >
<link rel="stylesheet" href="style/css/lookup.css" type="text/css" >
$nojurnal1 = $zJ->genNoJournal($tglFull, $unitSumber, $kodeJurnal, $counterJ1);
$dataRes1 = array();
// R/K Header
$dataRes1['header'] = array('nojurnal' => $nojurnal1, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tglFull, 'tanggalentry' => date('Ymd'), 'posting' => '0', 'totaldebet' => $total, 'totalkredit' => $total, 'amountkoreksi' => '0', 'noreferensi' => $noRef, 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
// R/K Detail
$dataRes1['detail'] = array();
$dataRes1['detail'][] = array('nojurnal' => $nojurnal1, 'tanggal' => $tglFull, 'nourut' => 1, 'noakun' => $optCaco[$param['kebun']], 'keterangan' => 'Alokasi Biaya Bibit ' . $param['kebun'] . ' untuk kegiatan ' . $row['namakegiatan'], 'jumlah' => $total, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $unitSumber, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => $noRef, 'noaruskas' => '', 'kodevhc' => '', 'nodok' => $noRef, 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
// Biaya
$dataRes1['detail'][] = array('nojurnal' => $nojurnal1, 'tanggal' => $tglFull, 'nourut' => 2, 'noakun' => $paramJ['noakunkredit'], 'keterangan' => 'Alokasi Biaya Bibit ' . $param['kebun'] . ' untuk kegiatan ' . $row['namakegiatan'], 'jumlah' => $total * -1, 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $unitSumber, 'kodekegiatan' => '', 'kodeasset' => '', 'kodebarang' => '', 'nik' => '', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => $noRef, 'noaruskas' => '', 'kodevhc' => '', 'nodok' => $noRef, 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
}
/**
* Proses Penjurnalan
*/
// Delete Jurnal dulu
if ($sameUnit) {
$whereDel = "nojurnal='" . $nojurnal . "'";
} else {
$whereDel = "nojurnal in ('" . $nojurnal . "','" . $nojurnal1 . "')";
}
$delJournal = deleteQuery($dbname, 'keu_jurnalht', $whereDel);
if (!mysql_query($delJournal)) {
exit("Hapus Jurnal Error: " . mysql_error());
} else {
$zJ->doJournal($optPT[$param['kebun']], $kodeJurnal, $dataRes, $counterJ, "Alokasi Biaya Bibit");
$zJ->doJournal($optPT[$unitSumber], $kodeJurnal, $dataRes1, $counterJ1, "Alokasi Biaya Bibit");
}
// Result
$res = array('msg' => 'Proses Jurnal berhasil');
echo json_encode($res);
break;
}
}
$data[] = array('nokonosemen' => $_POST['nokonosemen'], 'kodept' => $_POST['kodept'], 'kodebarang' => $row['kodebarang'], 'jenis' => isset($row['jenis']) ? $row['jenis'] : strtoupper($_POST['jenis']), 'jumlah' => $jumlah, 'satuanpo' => $satuan, 'nopo' => isset($row['nopo']) ? $row['nopo'] : '', 'nopp' => isset($row['nopp']) ? $row['nopp'] : '', 'nosj' => isset($row['nosj']) ? $row['nosj'] : '');
}
$cols = array('nokonosemen', 'kodept', 'kodebarang', 'jenis', 'jumlah', 'satuanpo', 'nopo', 'nopp', 'nosj');
$query = insertQuery($dbname, 'log_konosemendt', $data, $cols);
echo $query;
mysql_query($query) or die("Error DB: " . mysql_error());
break;
// Save Detail
// Save Detail
case 'saveDetail':
$where = "nokonosemen='" . $param['nokonosemen'] . "'" . " and kodebarang='" . $param['kodebarang'] . "' and nopo='" . $param['nopo'] . "'";
$cols = "*";
$data = array('jumlah' => $param['jumlah']);
if (isset($param['newNopo'])) {
$data['nopo'] = $param['newNopo'];
$data['nopp'] = $param['newNopp'];
}
$query = updateQuery($dbname, 'log_konosemendt', $data, $where);
mysql_query($query) or die("Error DB: " . mysql_error());
break;
// Delete Detail
// Delete Detail
case 'deleteDetail':
$where = "nokonosemen='" . $param['nokonosemen'] . "'" . " and kodebarang='" . $param['kodebarang'] . "'";
$query = deleteQuery($dbname, 'log_konosemendt', $where);
mysql_query($query) or die("Error DB: " . mysql_error());
break;
default:
break;
}
//executed restart device command
//restart command here
exec('sudo reboot');
echo "restart command executed";
}
} else {
$disCol = "*";
$where = "";
$returnResourceContent = selectQuery($tblName, $disCol, $where, $order_col = '', $order_by = '', $group_by = '', $disQuery = '');
if (!empty($returnResourceContent)) {
$data = mysql_fetch_row($returnResourceContent);
/*
$seconds = strtotime($data[2]) - strtotime($data[3]);
$hours = $seconds / 60 / 60;
$hours = round($hours);
if($hours >= 1)
{
}
*/
//insert record in db.
$tblName2 = "ss_restart_system_log";
$insertData2 = array('sr_restart_time' => date("Y-m-d H:i:s"), 'status' => 'Device is Online Now');
//insert menu
$returnResource2 = insertQuery($tblName2, $insertData2, $disQuery = '');
$deleteWhere = " sps_id = " . $data['0'];
$returnResource2 = deleteQuery($tblName, $deleteWhere, $disQuery = '');
echo "delete recored ";
}
echo "device is online";
}
