/
log_2gdangAccounting.php
executable file
·145 lines (138 loc) · 6.63 KB
/
log_2gdangAccounting.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?//@Copy nangkoelframework
require_once('master_validation.php');
include('lib/nangkoelib.php');
echo open_body();
?>
<script language=javascript src=js/zTools.js></script>
<script language=javascript src='js/zReport.js'></script>
<script>
function getUnit(){
pro=document.getElementById('ptId');
prod=pro.options[pro.selectedIndex].value;
param='proses=getUnit'+'&kdPt='+prod;
tujuan='log_slave_2gdangAccounting.php';
post_response_text(tujuan, param, respog);
function respog()
{
if(con.readyState==4)
{
if (con.status == 200) {
busy_off();
if (!isSaveResponse(con.responseText)) {
alert('ERROR TRANSACTION,\n' + con.responseText);
}
else {
//alert(con.responseText);
document.getElementById('unitId').innerHTML=con.responseText;
}
}
else {
busy_off();
error_catch(con.status);
}
}
}
}
function getUnit2(){
pro=document.getElementById('ptId2');
prod=pro.options[pro.selectedIndex].value;
param='proses=getUnit'+'&ptId2='+prod;
tujuan='log_slave_2gdangAccounting2.php';
post_response_text(tujuan, param, respog);
function respog()
{
if(con.readyState==4)
{
if (con.status == 200) {
busy_off();
if (!isSaveResponse(con.responseText)) {
alert('ERROR TRANSACTION,\n' + con.responseText);
}
else {
//alert(con.responseText);
document.getElementById('unitId2').innerHTML=con.responseText;
}
}
else {
busy_off();
error_catch(con.status);
}
}
}
}
</script>
<?
include('master_mainMenu.php');
OPEN_BOX('','<b>'.strtoupper($_SESSION['lang']['laporangudang']).'</b>');
$optPt="<option value=''>".$_SESSION['lang']['pilihdata']."</option>";
$spt="select distinct kodeorganisasi,namaorganisasi from ".$dbname.".organisasi where tipe='PT' order by namaorganisasi asc";
$qpt=mysql_query($spt) or die(mysql_error($conn));
while($rpt= mysql_fetch_assoc($qpt)){
$optPt.="<option value='".$rpt['kodeorganisasi']."'>".$rpt['namaorganisasi']."</option>";
}
$optUnit="<option value=''>".$_SESSION['lang']['all']."</option>";
$sdr="select distinct left(tanggal,7) as periode from ".$dbname.".log_transaksiht where post=1 order by tanggal asc";
$qdr=mysql_query($sdr) or die(mysql_error($conn));
$optPrdDr="";
while($rdr= mysql_fetch_assoc($qdr)){
$optPrdDr.="<option value='".$rdr['periode']."'>".$rdr['periode']."</option>";
}
$sdr="select distinct left(tanggal,7) as periode from ".$dbname.".log_transaksiht where post=1 order by tanggal desc";
$qdr=mysql_query($sdr) or die(mysql_error($conn));
$optPrdSmp="";
while($rdr= mysql_fetch_assoc($qdr)){
$optPrdSmp.="<option value='".$rdr['periode']."'>".$rdr['periode']."</option>";
}
$arr="##ptId##unitId##prdIdDr##prdIdSmp";
$frm[0]="<fieldset style=float:left>
<legend>".$_SESSION['lang']['laporangudang']."</legend>
<table cellpadding=1 cellspacing=1 border=0>
<tr><td>".$_SESSION['lang']['pt']."</td>";
$frm[0].="<td><select id=ptId onchange='getUnit()' style=width:150px;>".$optPt."</select></td>";
$frm[0].="</tr>";
$frm[0].="<tr><td>".$_SESSION['lang']['unit']."</td>
<td><select id=unitId style=width:150px;>".$optUnit."</select></td>
</tr>";
$frm[0].="<tr><td>".$_SESSION['lang']['periode']." ".$_SESSION['lang']['dari']."</td>
<td><select id=prdIdDr style=width:150px;>".$optPrdDr."</select></td>
</tr>";
$frm[0].="<tr><td>".$_SESSION['lang']['periode']." ".$_SESSION['lang']['sampai']."</td>
<td><select id=prdIdSmp style=width:150px;>".$optPrdSmp."</select></td>
</tr></table>";
$frm[0].="<button class=mybutton onclick=zPreview('log_slave_2gdangAccounting','".$arr."','printContainer')>".$_SESSION['lang']['proses']."</button>
<button class=mybutton onclick=zExcel(event,'log_slave_2gdangAccounting.php','".$arr."')>".$_SESSION['lang']['excel']."</button>
</fieldset>";
$frm[0].="<div style=clear:both></div><fieldset><legend>".$_SESSION['lang']['result']."</legend>";
$frm[0].="<div style='width:100%;height:359px;overflow:scroll;' id=printContainer></div>";
$frm[0].="</fieldset>";
$arr2="##ptId2##unitId2##prdIdDr2##prdIdSmp2";
$frm[1]="<div style=clear:both></div><fieldset style=float:left>
<legend>".$_SESSION['lang']['laporangudang']."</legend>
<table cellpadding=1 cellspacing=1 border=0>
<tr><td>".$_SESSION['lang']['pt']."</td>";
$frm[1].="<td><select id=ptId2 onchange='getUnit2()' style=width:150px;>".$optPt."</select></td>";
$frm[1].="</tr>";
$frm[1].="<tr><td>".$_SESSION['lang']['unit']."</td>
<td><select id=unitId2 style=width:150px;>".$optUnit."</select></td>
</tr>";
$frm[1].="<tr><td>".$_SESSION['lang']['periode']." ".$_SESSION['lang']['dari']."</td>
<td><select id=prdIdDr2 style=width:150px;>".$optPrdDr."</select></td>
</tr>";
$frm[1].="<tr><td>".$_SESSION['lang']['periode']." ".$_SESSION['lang']['sampai']."</td>
<td><select id=prdIdSmp2 style=width:150px;>".$optPrdSmp."</select></td>
</tr></table>";
$frm[1].="<button class=mybutton onclick=zPreview('log_slave_2gdangAccounting2','".$arr2."','printContainer2')>".$_SESSION['lang']['proses']."</button>
<button class=mybutton onclick=zExcel(event,'log_slave_2gdangAccounting2.php','".$arr2."')>".$_SESSION['lang']['excel']."</button>
</fieldset>";
$frm[1].="<div style=clear:both></div><fieldset><legend>".$_SESSION['lang']['result']."</legend>";
$frm[1].="<div style='width:100%;height:359px;overflow:scroll;' id=printContainer2></div>";
$frm[1].="</fieldset>";
//========================
$hfrm[0]=$_SESSION['lang']['laporangudang'];
$hfrm[1]=$_SESSION['lang']['laporangudangakunting'];
//$hfrm[1]=$_SESSION['lang']['list'];
//draw tab, jangan ganti parameter pertama, krn dipakai di javascript
drawTab('FRM',$hfrm,$frm,200,1050);
//===============================================
close_body();
?>