/
log_konosemen.php
executable file
·103 lines (94 loc) · 3.88 KB
/
log_konosemen.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
<?//@Copy nangkoelframework
require_once('master_validation.php');
include_once('lib/nangkoelib.php');
include_once('lib/zLib.php');
include_once('lib/rTable.php');
echo open_body();
include('master_mainMenu.php');
?>
<script language=javascript src='js/zMaster.js'></script>
<script language=javascript src='js/zSearch.js'></script>
<script language=javascript src='js/zTools.js'></script>
<script language=javascript src='js/formTable.js'></script>
<script language=javascript src='js/log_konosemen.js'></script>
<link rel=stylesheet type=text/css href='style/zTable.css'>
<?php
#=== Prep Control & Search
$ctl = array();
# Control
$ctl[] = "<div align='center'><img class=delliconBig src=images/".$_SESSION['theme']."/addbig.png title='".
$_SESSION['lang']['new']."' onclick=\"showAdd()\"><br><span align='center'>".$_SESSION['lang']['new']."</span></div>";
$ctl[] = "<div align='center'><img class=delliconBig src=images/".$_SESSION['theme']."/list.png title='".
$_SESSION['lang']['list']."' onclick=\"defaultList()\"><br><span align='center'>".$_SESSION['lang']['list']."</span></div>";
# Search
$ctl[] = "<fieldset><legend><b>".$_SESSION['lang']['find']."</b></legend>".
makeElement('sNoKonosemen','label',$_SESSION['lang']['nokonosemen']).
makeElement('sNoKonosemen','text','').
makeElement('sFind','btn',$_SESSION['lang']['find'],array('onclick'=>"searchTrans()")).
"</fieldset>";
#=== Table Aktivitas
# Header
$header = array(
$_SESSION['lang']['nokonosemen'],$_SESSION['lang']['nokonosemen'].' Expeditor',
$_SESSION['lang']['pt'],$_SESSION['lang']['tanggal'],
$_SESSION['lang']['tanggalberangkat'],$_SESSION['lang']['tanggaltiba'],'postingterimaby'
);
//cari nama orang
$str="select karyawanid, namakaryawan from ".$dbname.".datakaryawan";
$res=mysql_query($str);
while($bar= mysql_fetch_object($res))
{
$nama[$bar->karyawanid]=$bar->namakaryawan;
}
# Content
$cols = "nokonosemen,nokonosemenexp,kodept,tanggal,tanggalberangkat,tanggaltiba,postingby,posting,postingkirim";
$order="nokonosemen desc";
$query = selectQuery($dbname,'log_konosemenht',$cols,null,$order,false,10,1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname,'log_suratjalanht');
foreach($data as $key=>$row) {
if($row['postingkirim']==1) {
$data[$key]['switched']=true;
}
if($row['posting']==1) {
$data[$key]['switched']=true;
}
unset($data[$key]['posting']);
unset($data[$key]['postingkirim']);
$data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
$data[$key]['tanggalberangkat'] = tanggalnormal($row['tanggalberangkat']);
$data[$key]['tanggaltiba'] = tanggalnormal($row['tanggaltiba']);
if($row['postingby']!=0) {
$data[$key]['postingby'] = $nama[$row['postingby']];
} else {
$data[$key]['postingby'] = '';
}
}
# Make Table
$tHeader = new rTable('headTable','headTableBody',$header,$data);
$tHeader->addAction('showEdit','Edit','images/'.$_SESSION['theme']."/edit.png");
$tHeader->addAction('deleteData','Delete','images/'.$_SESSION['theme']."/delete.png");
$tHeader->addAction('postingData','Posting','images/'.$_SESSION['theme']."/posting.png");
$tHeader->_actions[2]->setAltImg('images/'.$_SESSION['theme']."/posted.png");
$tHeader->addAction('detailPDF','Print Data Detail','images/'.$_SESSION['theme']."/pdf.jpg");
$tHeader->_actions[3]->addAttr('event');
$tHeader->pageSetting(1,$totalRow,10);
$tHeader->_switchException = array('detailPDF');
#=== Display View
# Title & Control
OPEN_BOX();
echo "<div align='center'><h3>".$_SESSION['lang']['konosemen']."</h3></div>";
echo "<div><table align='center'><tr>";
foreach($ctl as $el) {
echo "<td v-align='middle' style='min-width:100px'>".$el."</td>";
}
echo "</tr></table></div>";
CLOSE_BOX();
# List
OPEN_BOX();
echo "<div id='workField'>";
$tHeader->renderTable();
echo "</div>";
CLOSE_BOX();
echo close_body();
?>