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"; }