<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "DD-7-3"); mysql_select_db($database_con_gl, $con_gl); $query_klas1 = "SELECT id, gudang FROM gl_gudang ORDER BY gudang ASC"; $klas1 = mysql_query($query_klas1, $con_gl) or die(mysql_error()); $row_klas1 = mysql_fetch_assoc($klas1); $totalRows_klas1 = mysql_num_rows($klas1); $colname_edit = "-1"; if (isset($_GET['id'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['id'] : addslashes($_GET['id']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_kontak WHERE id = %s", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); ?> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#delete').submit(function() {
<?php require_once 'connections/con_gl.php'; cekAkses($_SESSION[akses], "PD-1-3"); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type FROM gl_kontak ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error()); $row_kontak = mysql_fetch_assoc($kontak); $totalRows_kontak = mysql_num_rows($kontak); // --- mysql_select_db($database_con_gl, $con_gl); $query_gudang = "SELECT id, gudang FROM gl_gudang"; if (!strstr($_SESSION[akses], 'A-1-4')) { $query_gudang .= " where id='{$_SESSION['lokasi']}'"; } $query_gudang .= " ORDER BY gudang ASC"; $gudang = mysql_query($query_gudang, $con_gl) or die(mysql_error()); $row_gudang = mysql_fetch_assoc($gudang); $totalRows_gudang = mysql_num_rows($gudang); mysql_select_db($database_con_gl, $con_gl); $query_satuan = "SELECT id, satuan FROM gl_satuan ORDER BY satuan ASC"; $satuan = mysql_query($query_satuan, $con_gl) or die(mysql_error()); $row_satuan = mysql_fetch_assoc($satuan); $totalRows_satuan = mysql_num_rows($satuan); mysql_select_db($database_con_gl, $con_gl); $query_kelom = "SELECT id, kelompok FROM gl_kelompok where jenis='1'"; if (!strstr($_SESSION[akses], 'A-1-4')) { $query_kelom .= " AND gudang='{$_SESSION['lokasi']}'"; } $query_kelom .= " ORDER BY kelompok ASC"; $kelom = mysql_query($query_kelom, $con_gl) or die(mysql_error());
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "EX-2"); $currentPage = $_SERVER["PHP_SELF"]; mysql_select_db($database_con_gl, $con_gl); $query_l_kel = "SELECT id, jenis FROM gl_jenisasuransi ORDER BY jenis ASC"; $l_kel = mysql_query($query_l_kel, $con_gl) or die(mysql_error()); $row_l_kel = mysql_fetch_assoc($l_kel); $totalRows_l_kel = mysql_num_rows($l_kel); $maxRows_data = 8; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT gl_transaksiextendasuransi.id, gl_transaksiextendasuransi.tgltransaksi, gl_transaksiextendasuransi.noref, gl_transaksiextendasuransi.jthtempopolis, gl_transaksiextendasuransi.biayapolis, gl_transaksiextendasuransi.nopolis, gl_masterkendaraan.nopolisi, gl_jenisasuransi.jenis, gl_kontak.nama, gl_kontak.tlp FROM gl_transaksiextendasuransi, gl_masterkendaraan, gl_jenisasuransi, gl_kontak WHERE gl_masterkendaraan.id = gl_transaksiextendasuransi.nopolisi AND gl_jenisasuransi.id = gl_transaksiextendasuransi.jenis AND gl_kontak.id = gl_transaksiextendasuransi.namainsurance"; if (isset($_GET[cr_txt]) and $_GET[cr_txt] != '' and $_GET[cr_txt] != '+') { $decode_cr = str_replace("+", " ", $_GET[cr_txt]); $query_data .= " AND (gl_transaksiextendasuransi.nopolis LIKE '%%{$decode_cr}%%' OR gl_transaksiextendasuransi.nopolis LIKE '%%{$decode_cr}%%' OR gl_transaksiextendasuransi.noref LIKE '%%{$decode_cr}%%' OR gl_kontak.nama LIKE '%%{$decode_cr}%%' OR gl_kontak.tlp LIKE '%%{$decode_cr}%%')"; } if (isset($_GET[cr_kel]) and $_GET[cr_kel] != 'ALL') { $query_data .= " AND gl_transaksiextendasuransi.jenis ='{$_GET['cr_kel']}'"; } $query_data .= " ORDER BY gl_transaksiextendasuransi.jenis, gl_transaksiextendasuransi.nopolisi"; $data = mysql_query($query_data, $con_gl) or die(mysql_error()); $totalRows_data = mysql_num_rows($data); $totalPages_data = floor($totalRows_data / $maxRows_data); $query_data .= " LIMIT {$startRow_data}, {$maxRows_data}";
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "KB-3-2"); $colname_edit = "-1"; if (isset($_GET['noreferensi'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['noreferensi'] : addslashes($_GET['noreferensi']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_rtrans WHERE no_ref = '{$_GET['noreferensi']}'", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where `tipe` <>'6' and `tipe` <>'7' ORDER BY kd,klasifikasi ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type FROM gl_kontak ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error()); $row_kontak = mysql_fetch_assoc($kontak); $totalRows_kontak = mysql_num_rows($kontak); mysql_select_db($database_con_gl, $con_gl); $query_klaskas = "SELECT kd, klasifikasi FROM gl_klas WHERE tipe = 2 ORDER BY kd,klasifikasi ASC"; $klaskas = mysql_query($query_klaskas, $con_gl) or die(mysql_error()); $row_klaskas = mysql_fetch_assoc($klaskas); $totalRows_klaskas = mysql_num_rows($klaskas); mysql_select_db($database_con_gl, $con_gl); $query_def_ak = "SELECT gl_company.a_kas FROM gl_company"; $def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error());
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "DD-6-2"); $colname_edit = "-1"; if (isset($_GET['referensi'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['referensi'] : addslashes($_GET['referensi']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT no_ref, gudang, tgl, keterangan FROM gl_rtrans WHERE no_ref = '%s'", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where `tipe` <>6 AND `tipe` <>7 ORDER BY kd,klasifikasi ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); // --- mysql_select_db($database_con_gl, $con_gl); $query_gudang = "SELECT id, gudang FROM gl_gudang"; if (!strstr($_SESSION[akses], 'A-1-4')) { $query_gudang .= " where id='{$_SESSION['lokasi']}'"; } $query_gudang .= " ORDER BY gudang ASC"; $gudang = mysql_query($query_gudang, $con_gl) or die(mysql_error()); $row_gudang = mysql_fetch_assoc($gudang); $totalRows_gudang = mysql_num_rows($gudang); ?> <link href="ccss/ui.datepicker.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="js/ui.datepicker.js"></script>
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "PJ-3-2"); $colname_edit = "-1"; if (isset($_GET['noreferensi'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['noreferensi'] : addslashes($_GET['noreferensi']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_rtrans WHERE no_ref = '{$_GET['noreferensi']}'", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where tipe = 4 ORDER BY kd,klasifikasi ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); mysql_select_db($database_con_gl, $con_gl); $query_klas2 = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where tipe = 6 ORDER BY kd,klasifikasi ASC"; $klas2 = mysql_query($query_klas2, $con_gl) or die(mysql_error()); $row_klas2 = mysql_fetch_assoc($klas2); $totalRows_klas2 = mysql_num_rows($klas2); mysql_select_db($database_con_gl, $con_gl); $query_def_ak = "SELECT gl_company.a_hpp, a_hut FROM gl_company"; $def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error()); $row_def_ak = mysql_fetch_assoc($def_ak); $totalRows_def_ak = mysql_num_rows($def_ak); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type FROM gl_kontak where gl_kontak.type <>'Supplier' ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error());
<?php require_once 'connections/con_gl.php'; cekAkses($_SESSION[akses], "KR-1-1"); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type, tcustomer FROM gl_kontak where gl_kontak.type='Customer' AND status='AKTIF' ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error()); $row_kontak = mysql_fetch_assoc($kontak); $totalRows_kontak = mysql_num_rows($kontak); unset($_SESSION['kendaraan']); unset($_SESSION['txtkendaraan']); unset($_SESSION['hargasatuan']); unset($_SESSION['diskon']); unset($_SESSION['total']); unset($_SESSION['transaksi']); unset($_SESSION['subtotal']); unset($_SESSION['pajak']); unset($_SESSION['grandtotal']); function romawi($bulan) { switch ($bulan) { case '01': $rom = "I"; break; case '02': $rom = "II"; break; case '03': $rom = "III"; break; case '04':
<?php require_once 'connections/con_gl.php'; cekAkses($_SESSION[akses], "DD-8"); $currentPage = $_SERVER["PHP_SELF"]; $maxRows_data = 8; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT id, nama, alamat, tlp, email, tgldaftar, nama2, tlp2, status from gl_kontak where type='customer' and tcustomer='Corporate'"; if (isset($_GET[cr_txt]) and $_GET[cr_txt] != '' and $_GET[cr_txt] != '+') { $decode_cr = str_replace("+", " ", $_GET[cr_txt]); $query_data .= " AND nama LIKE '%%{$decode_cr}%%' OR tlp LIKE '%%{$decode_cr}%%' OR nama2 LIKE '%%{$decode_cr}%%' OR tlp2 LIKE '%%{$decode_cr}%%' OR status LIKE '%%{$decode_cr}%%'"; } $query_data .= " order by nama asc"; $data = mysql_query($query_data, $con_gl) or die(mysql_error()); $totalRows_data = mysql_num_rows($data); $totalPages_data = floor($totalRows_data / $maxRows_data); $query_data .= " LIMIT {$startRow_data}, {$maxRows_data}"; $data = mysql_query($query_data, $con_gl) or die(mysql_error()); $totalRow_data = mysql_num_rows($data); $row_data = mysql_fetch_assoc($data); $queryString_data = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) {
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "PJ-4-1"); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type FROM gl_kontak where `type`='Customer' ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error()); $row_kontak = mysql_fetch_assoc($kontak); $totalRows_kontak = mysql_num_rows($kontak); mysql_select_db($database_con_gl, $con_gl); $query_klaskas = "SELECT kd, klasifikasi FROM gl_klas WHERE tipe = 2 ORDER BY kd,klasifikasi ASC"; $klaskas = mysql_query($query_klaskas, $con_gl) or die(mysql_error()); $row_klaskas = mysql_fetch_assoc($klaskas); $totalRows_klaskas = mysql_num_rows($klaskas); mysql_select_db($database_con_gl, $con_gl); $query_def_ak = "SELECT gl_company.a_kas FROM gl_company"; $def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error()); $row_def_ak = mysql_fetch_assoc($def_ak); $totalRows_def_ak = mysql_num_rows($def_ak); // --- mysql_select_db($database_con_gl, $con_gl); $query_gudang = "SELECT id, gudang FROM gl_gudang"; if (!strstr($_SESSION[akses], 'A-1-4')) { $query_gudang .= " where id='{$_SESSION['lokasi']}'"; } $query_gudang .= " ORDER BY gudang ASC"; $gudang = mysql_query($query_gudang, $con_gl) or die(mysql_error()); $row_gudang = mysql_fetch_assoc($gudang); $totalRows_gudang = mysql_num_rows($gudang); ?> <link href="css/ui.datepicker.css" type="text/css" rel="stylesheet" />
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "JS-1-1"); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT id, jenis FROM gl_jeniskecelakaan ORDER BY jenis ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); ?> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#add').submit(function() { $.ajax({ type: 'POST', url: $(this).attr('action'), data: $(this).serialize(), success: function(data) { $('#result').html(data); }
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "EX-1-1"); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT id, nopolisi FROM gl_masterkendaraan ORDER BY nopolisi ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); ?> <link href="ccss/ui.datepicker.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="js/ui.datepicker.js"></script> <script type="text/javascript"> <!-- $(function() { $('.calendar').datepicker({ appendText : "", dateFormat : 'yy/mm/dd' }); }); </script> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide();
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "D-5"); $currentPage = $_SERVER["PHP_SELF"]; mysql_select_db($database_con_gl, $con_gl); $query_aset = "SELECT gl_aset.id, gl_aset.aset, gl_aset.qty, gl_aset.total, gl_aset.thn, gl_gol.golongan, gl_gol.jangka, gl_gol.bobot, gl_gol.jangka, gl_gol.bobot FROM gl_aset, gl_gol WHERE gl_gol.id = gl_aset.golID ORDER BY gl_gol.golongan, gl_aset.aset"; $aset = mysql_query($query_aset, $con_gl) or die(mysql_error()); $row_aset = mysql_fetch_assoc($aset); $totalRows_aset = mysql_num_rows($aset); if ($_POST['tahun'] != '') { $tahun = $_POST['tahun']; } else { $tahun = date("Y"); } $query_data = $query_aset; include 'include/widget_exportdata.php'; ?> <h1>Penyusutan Aset</h1> <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" style="border-bottoms:solid 1px #E2EAC1;"> <tr valign="top"> <td align="right"><!--<form id="search" name="search" method="post" action=""> <label></label> <label>Penyusutan Aset pada tahun : <select name="tahun" id="tahun" style="width:90px;text-align:center;"> <?php //for($ii = $tahun-50;$ii<=$tahun+50;$ii++) { ?> <option value="<?php //echo $ii; ?>
<?php require 'connections/con_gl.php'; ?> <?php cekAkses($_SESSION[akses], "PJ-5"); $currentPage = $_SERVER["PHP_SELF"]; $maxRows_data = 8; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT gl_rtrans.no_ref, gl_rtrans.tgl, gl_rtrans.keterangan, gl_rtrans.jatuhtempo, gl_rtrans.kontak, gl_kontak.nama FROM gl_rtrans, gl_kontak WHERE gl_rtrans.jenis=7 AND gl_rtrans.jatuhtempo<>'' AND gl_kontak.id=gl_rtrans.kontak"; if (!strstr($_SESSION[akses], 'A-1-4')) { $query_data .= " AND gl_rtrans.gudang='{$_SESSION['lokasi']}'"; } if (isset($_GET['cr_txt']) and $_GET['cr_txt'] != '+') { $q = str_replace("+", " ", $_GET['cr_txt']); $query_data .= " AND (gl_kontak.nama LIKE '%%{$q}%%' OR gl_rtrans.no_ref LIKE '%%{$q}%%' OR gl_rtrans.tgl LIKE '%%{$q}%%' OR gl_rtrans.keterangan LIKE '%%{$q}%%' OR gl_rtrans.jatuhtempo LIKE '%%{$q}%%')"; } $query_data .= " ORDER BY gl_rtrans.jatuhtempo desc"; $query_limit_data = sprintf("%s LIMIT %d, %d", $query_data, $startRow_data, $maxRows_data); $data = mysql_query($query_limit_data, $con_gl) or die(mysql_error()); $row_data = mysql_fetch_assoc($data); if (isset($_GET['totalRows_data'])) { $totalRows_data = $_GET['totalRows_data']; } else {
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "D-2-1"); // get unit kerja mysql_select_db($database_con_gl, $con_gl); $query_unitkerja = "select * from gl_unitkerja order by unitkerja"; $unitkerja = mysql_query($query_unitkerja, $con_gl) or die(mysql_error()); $row_unitkerja = mysql_fetch_assoc($unitkerja); $total_unitkerja = mysql_num_rows($unitkerja); // get lokasi kantor ( gudang ) ?> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> // --- cek karyawan function checkKaryawan(val) { if(val=='Karyawan') { document.getElementById('lkantor').disabled=''; }else{ document.getElementById('lkantor').value=''; document.getElementById('lkantor').disabled='disabled'; } } // --- $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() {
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "JS-7-3"); $colname_edit = "-1"; if (isset($_GET['id'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['id'] : addslashes($_GET['id']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_tipekendaraan WHERE id = %s", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); ?> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#delete').submit(function() { $.ajax({ type: 'POST', url: $(this).attr('action'),
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "UK-1-1"); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT id, unitkerja FROM gl_unitkerja ORDER BY unitkerja ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); ?> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#add').submit(function() { $.ajax({ type: 'POST', url: $(this).attr('action'), data: $(this).serialize(), success: function(data) { $('#result').html(data); }
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "JA-1-3"); $colname_edit = "-1"; if (isset($_GET['id'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['id'] : addslashes($_GET['id']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_jenisasuransi WHERE id = %s", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); ?> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#delete').submit(function() { $.ajax({ type: 'POST', url: $(this).attr('action'),
<?php require_once 'connections/con_gl.php'; cekAkses($_SESSION[akses], "MS-8-1"); mysql_select_db($database_con_gl, $con_gl); $query_klas6 = "SELECT id, jenis FROM gl_jenisasuransi ORDER BY jenis ASC"; $klas6 = mysql_query($query_klas6, $con_gl) or die(mysql_error()); $row_klas6 = mysql_fetch_assoc($klas6); $totalRows_klas6 = mysql_num_rows($klas6); mysql_select_db($database_con_gl, $con_gl); $query_klas10 = "SELECT id, jenisbbm FROM gl_jenisbbm ORDER BY jenisbbm ASC"; $klas10 = mysql_query($query_klas10, $con_gl) or die(mysql_error()); $row_klas10 = mysql_fetch_assoc($klas10); $totalRows_klas10 = mysql_num_rows($klas10); ?> <link href="ccss/ui.datepicker.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="js/ui.datepicker.js"></script> <script type="text/javascript"> <!-- $(function() { $('.calendar').datepicker({ appendText : "", dateFormat : 'yy/mm/dd' }); }); </script> <script type="text/javascript" src="js/ajax_data.js"></script> <script type="text/javascript">
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "PD-2"); mysql_select_db($database_con_gl, $con_gl); $query_edit = "SELECT gl_stok.id, gl_stok.stok, gl_stok.fisik, gl_gudang.gudang, gl_barang.barang, gl_satuan.satuan FROM gl_stok, gl_gudang, gl_barang, gl_satuan WHERE gl_gudang.id=gl_stok.gudang AND gl_barang.id=gl_stok.barang AND gl_satuan.id=gl_stok.satuan AND gl_stok.id='{$_GET['id']}'"; $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); ?> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#editstok').submit(function() { $.ajax({ type: 'POST', url: $(this).attr('action'), data: $(this).serialize(), success: function(data) { $('#result').html(data); } }) return false;
<?php session_start(); include '../../config/connect.php'; include '../../config/function.php'; include '../../config/config.php'; if (NULL !== cekAkses("{$modul}", "{$_SESSION['ylevel']}", "{$act}")) { $kd = anti($_POST['kode']); $tgl = anti($_POST['tgl']); $cust = anti($_POST['cust']); $b = explode(' - ', $_POST['brg']); $brg = $b[0]; $harga = abs((int) $_POST['harga']); //harga asli dari data barang $select_diskon = anti($_POST['select_diskon']); $disc_persen = abs((int) $_POST['disc_persen']); $disc_rp = abs((int) $_POST['disc_rp']); $disc_unit = abs((int) $_POST['disc_unit']); $qty = abs((int) $_POST['qty']); $jumlah = abs((int) $_POST['jumlah']); // $diskon = abs((int)($_POST['diskon'])); // $ket = anti($_POST['ket']); // $item_disc = $harga - $harga_disc; // item_disc = nominal pemberian diskon/potongan (auto). Jika harga real ketika transaksi berbeda dengan harga dari data barang // $ttl = $harga_disc * $qty; // total harga real transaksi * dengan qty echo $kd . '<br>'; echo $tgl . '<br>'; echo $cust . '<br>'; echo $brg . '<br>'; echo $harga . '<br>';
<?php require_once 'connections/con_gl.php'; require_once "excel/excelwriter.class.php"; ?> <?php cekAkses($_SESSION[akses], "L-3"); echo $_SESSION[nama]; mysql_select_db($database_con_gl, $con_gl); mysql_query("delete from gl_trans where total='0'", $con_gl); $currentPage = $_SERVER["PHP_SELF"]; $maxRows_data = 20; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT * from v_kasir a inner join v_kendaraan b on a.kendaraan = b.nopolisi"; $query_korporate = "SELECT * from v_kasir_korporate a inner join v_kendaraan b on a.kendaraan = b.nopolisi"; /* if(!strstr($_SESSION[akses],'A-1-4')) { $query_data .= " AND gudang='$_SESSION[gudang]'"; } */ if ($_GET[gudang] != 'ALL' and $_GET[gudang] != '') { $query_data .= " where a.gudang='{$_GET['gudang']}'";
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "KB-2-3"); $colname_edit = "-1"; if (isset($_GET['noreferensi'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['noreferensi'] : addslashes($_GET['noreferensi']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_rtrans WHERE no_ref = '{$_GET['noreferensi']}'", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas ORDER BY kd,klasifikasi ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type FROM gl_kontak ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error()); $row_kontak = mysql_fetch_assoc($kontak); $totalRows_kontak = mysql_num_rows($kontak); mysql_select_db($database_con_gl, $con_gl); $query_klaskas = "SELECT kd, klasifikasi FROM gl_klas WHERE tipe = 2 ORDER BY kd,klasifikasi ASC"; $klaskas = mysql_query($query_klaskas, $con_gl) or die(mysql_error()); $row_klaskas = mysql_fetch_assoc($klaskas); $totalRows_klaskas = mysql_num_rows($klaskas); mysql_select_db($database_con_gl, $con_gl); $query_def_ak = "SELECT gl_company.a_kas FROM gl_company"; $def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error());
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "RB-2"); $currentPage = $_SERVER["PHP_SELF"]; mysql_select_db($database_con_gl, $con_gl); $query_l_kel = "SELECT id, area FROM gl_area ORDER BY area ASC"; $l_kel = mysql_query($query_l_kel, $con_gl) or die(mysql_error()); $row_l_kel = mysql_fetch_assoc($l_kel); $totalRows_l_kel = mysql_num_rows($l_kel); $maxRows_data = 8; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT gl_kontak.id, gl_kontak.nama, gl_kontak.alamat, gl_kontak.npwp, gl_kontak.tlp, gl_kontak.email, gl_area.area FROM gl_kontak, gl_area WHERE gl_kontak.type='Bengkel' AND gl_area.id = gl_kontak.area"; if (isset($_GET[cr_txt]) and $_GET[cr_txt] != '' and $_GET[cr_txt] != '+') { $decode_cr = str_replace("+", " ", $_GET[cr_txt]); $query_data .= " AND (gl_kontak.id LIKE '%%{$decode_cr}%%' OR gl_kontak.nama LIKE '%%{$decode_cr}%%' OR gl_kontak.alamat LIKE '%%{$decode_cr}%%' OR gl_kontak.tlp LIKE '%%{$decode_cr}%%')"; } if (isset($_GET[cr_kel]) and $_GET[cr_kel] != 'ALL') { $query_data .= " AND gl_kontak.area ='{$_GET['cr_kel']}'"; } $query_data .= " ORDER BY gl_area.area, gl_kontak.nama"; $data = mysql_query($query_data, $con_gl) or die(mysql_error()); $totalRows_data = mysql_num_rows($data); $totalPages_data = floor($totalRows_data / $maxRows_data); $query_data .= " LIMIT {$startRow_data}, {$maxRows_data}";
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "JS-2-2"); $colname_edit = "-1"; if (isset($_GET['id'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['id'] : addslashes($_GET['id']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_statuskendaraan WHERE id = %s", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); ?> <link type="text/css" rel="stylesheet" href="css/jquery.wysiwyg.css" /> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() { $().ajaxStart(function() { $('#loading').show(); $('#result').hide(); }).ajaxStop(function() { $('#loading').hide(); $('#result').fadeIn('slow'); }); $('#edit').submit(function() { $.ajax({ type: 'POST', url: $(this).attr('action'),
<?php require 'connections/con_gl.php'; ?> <?php cekAkses($_SESSION[akses], "A-1-2"); $colname_edit = "-1"; if (isset($_GET['id'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['id'] : addslashes($_GET['id']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_admin WHERE id = %s", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); mysql_select_db($database_con_gl, $con_gl); $query_kary = "SELECT id, nama FROM gl_kontak WHERE type = 'Karyawan' ORDER BY nama ASC"; $kary = mysql_query($query_kary, $con_gl) or die(mysql_error()); $row_kary = mysql_fetch_assoc($kary); $totalRows_kary = mysql_num_rows($kary); ?> <script type="text/javascript" src="js/jquery.wysiwyg.js"></script> <script type="text/javascript"> $(document).ready(function() {
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "PD-3-1"); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT id, tipecustomer FROM gl_tipecustomer ORDER BY tipecustomer ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); mysql_select_db($database_con_gl, $con_gl); $query_klas1 = "SELECT id, cabang FROM gl_cabang ORDER BY cabang ASC"; $klas1 = mysql_query($query_klas1, $con_gl) or die(mysql_error()); $row_klas1 = mysql_fetch_assoc($klas1); $totalRows_klas1 = mysql_num_rows($klas1); ?> <link href="ccss/ui.datepicker.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="js/ui.datepicker.js"></script> <script type="text/javascript"> <!-- $(function() { $('.calendar').datepicker({ appendText : "", dateFormat : 'yy/mm/dd' }); }); </script> <script type="text/javascript" src="js/ajax_data.js"></script> <script type="text/javascript"> $(document).ready(function() {
<?php session_start(); /*Added by suwondo*/ require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "JS-6"); $currentPage = $_SERVER["PHP_SELF"]; mysql_select_db($database_con_gl, $con_gl); $bid = $_GET['barang']; $jumlah = $_GET['jumlah']; $checkin = $_GET['checkin']; $checkout = $_GET['checkout']; global $d; $d = substr($checkin, 8, 2); $s = substr($checkin, 8, 1); if ($s == 0) { $d = substr($checkin, 9, 1); } //echo $newdate; $area = $_GET['area']; list($namaarea) = mysql_fetch_row(mysql_query("select area from gl_area where id = '{$area}'")); list($paket) = mysql_fetch_row(mysql_query("select barang from gl_barang where id = '{$bid}'")); ?> <script type="text/javascript" src="js/jquery-1.4.js"></script> <script type="text/javascript" src="js/jquery.autocomplete.js"></script> <link rel="stylesheet" type="text/css" href="css/jquery.autocomplete.css" /> <h1>Data Kendaraan <?php if ($area != '') { echo "Area " . $namaarea; } ?>
<?php require_once 'connections/con_gl.php'; require_once "excel/excelwriter.class.php"; ?> <?php cekAkses($_SESSION[akses], "PB-1"); mysql_select_db($database_con_gl, $con_gl); mysql_query("delete from gl_trans where total='0'", $con_gl); $currentPage = $_SERVER["PHP_SELF"]; $maxRows_data = 10; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT distinct gl_rtrans.no_ref, gl_rtrans.tgl, gl_rtrans.keterangan, gl_gudang.gudang FROM gl_rtrans, gl_gudang, gl_trans WHERE gl_rtrans.jenis='6' AND gl_gudang.id = gl_rtrans.gudang AND gl_trans.no_ref = gl_rtrans.no_ref AND gl_trans.pos ='D' AND gl_rtrans.no_ref LIKE '%%PJ%%'"; if (!strstr($_SESSION[akses], 'A-1-4')) { $query_data .= " AND gl_rtrans.gudang='{$_SESSION['lokasi']}'"; } if ($_GET[cr_txt] != '' and $_GET[cr_txt] != '+') { $decode_cr = str_replace("+", " ", $_GET[cr_txt]); $query_data .= " AND (gl_rtrans.no_ref LIKE '%%{$decode_cr}%%' OR gl_rtrans.tgl LIKE '%%{$decode_cr}%%' OR gl_gudang.gudang LIKE '%%{$decode_cr}%%' OR gl_rtrans.keterangan LIKE '%%{$decode_cr}%%')"; } if ($_GET[gudang] != 'ALL' and $_GET[gudang] != '') { $query_data .= " AND gl_rtrans.gudang='{$_GET['gudang']}'"; } if ($_GET[mulai] != '' and $_GET[sampai] != '') {
<?php require 'connections/con_gl.php'; cekAkses($_SESSION[akses], "PB-3-3"); $colname_edit = "-1"; if (isset($_GET['noreferensi'])) { $colname_edit = get_magic_quotes_gpc() ? $_GET['noreferensi'] : addslashes($_GET['noreferensi']); } mysql_select_db($database_con_gl, $con_gl); $query_edit = sprintf("SELECT * FROM gl_rtrans WHERE no_ref = '{$_GET['noreferensi']}'", $colname_edit); $edit = mysql_query($query_edit, $con_gl) or die(mysql_error()); $row_edit = mysql_fetch_assoc($edit); $totalRows_edit = mysql_num_rows($edit); mysql_select_db($database_con_gl, $con_gl); $query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where tipe = 4 ORDER BY kd,klasifikasi ASC"; $klas = mysql_query($query_klas, $con_gl) or die(mysql_error()); $row_klas = mysql_fetch_assoc($klas); $totalRows_klas = mysql_num_rows($klas); mysql_select_db($database_con_gl, $con_gl); $query_klas2 = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where tipe = 7 ORDER BY kd,klasifikasi ASC"; $klas2 = mysql_query($query_klas2, $con_gl) or die(mysql_error()); $row_klas2 = mysql_fetch_assoc($klas2); $totalRows_klas2 = mysql_num_rows($klas2); mysql_select_db($database_con_gl, $con_gl); $query_def_ak = "SELECT gl_company.a_hpp, a_hut FROM gl_company"; $def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error()); $row_def_ak = mysql_fetch_assoc($def_ak); $totalRows_def_ak = mysql_num_rows($def_ak); mysql_select_db($database_con_gl, $con_gl); $query_kontak = "SELECT id, nama, type FROM gl_kontak where gl_kontak.type='Supplier' ORDER BY type, nama ASC"; $kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error());
<?php require_once 'connections/con_gl.php'; require_once "excel/excelwriter.class.php"; ?> <?php cekAkses($_SESSION[akses], "IK-1"); mysql_select_db($database_con_gl, $con_gl); //mysql_query("delete from gl_detailtrans where total='0'", $con_gl); $currentPage = $_SERVER["PHP_SELF"]; $maxRows_data = 10; $pageNum_data = 0; if (isset($_GET['pageNum_data'])) { $pageNum_data = $_GET['pageNum_data']; } $startRow_data = $pageNum_data * $maxRows_data; $cr_txt = str_replace("+", " ", $_REQUEST[cr_txt]); mysql_select_db($database_con_gl, $con_gl); $query_data = "SELECT * from v_kasir_korporate a"; if ($_GET[cr_txt] != '' and $_GET[cr_txt] != '+') { $decode_cr = str_replace("+", " ", $_GET[cr_txt]); } if ($_GET[gudang] != 'ALL' and $_GET[gudang] != '') { $query_data .= " WHERE a.gudang='{$_GET['gudang']}'"; } else { $query_data .= " WHERE a.gudang='{$_SESSION['lokasi']}'"; } if ($_GET[mulai] != '' and $_GET[sampai] != '') { $query_data .= " AND a.mulai between '{$_GET['mulai']}' AND '{$_GET['sampai']}'"; }