<?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']}'";
}
