-
Notifications
You must be signed in to change notification settings - Fork 0
/
data_pelanggan.php
executable file
·143 lines (138 loc) · 5.3 KB
/
data_pelanggan.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
<?php
require_once("./script/config.php");
require_once($site_path."script/library.php");
cekSession();
//atur variabel paging
$n_data=countNData('pelanggan');
$n_halaman=ceil($n_data/$n_data_halaman);
/*------------------------
PROSES KIRIMAN DATA
--------------------------*/
//inisialisasi data
$pesan="";
// <<< PROSES METHOD POST >>>
if (!empty($_POST[action])) {
switch ($_POST[action]) {
case 'save': // <<< SIMPAN DATA >>>
if ($_POST[id] == 0) { // <<< SIMPAN DATA BARU >>>
$elemen=array('kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak');
$pesan=addNew('pelanggan', $elemen);
} else { // <<< UDATE DATA LAMA >>>
$elemen=array('kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak');
$pesan=updateOld('pelanggan', $elemen, $_POST[id]);
}
break;
case 'delete': // <<< HAPUS DATA >>>
$pesan=deleteData('pelanggan',$_POST[id]);
break;
case 'new': // <<< KOSONGKAN FORM >>>
header("location: ".$_SERVER['PHP_SELF']);
break;
}
// <<< ATUR ALERT >>>
if (strlen($pesan) > 0) $pesan='<div class="box">'.$pesan.'</div>';
$tampil_baru=true;
} else if (empty($_GET[id])) {
$tampil_baru=true;
}
/*-------------
ISI FORM
---------------*/
$elemen=array('id', 'kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak');
$form_value=fillForm('pelanggan', $elemen, $_GET[id]);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 4.01 Transitional//EN">
<html>
<?php include($site_path."design/meta.php"); ?>
<body onload="body_onLoad()">
<div id="wrapper">
<?php include($site_path."design/page_header.php"); ?>
<?php include($site_path."design/menubar.php"); ?>
<div id="content" class="row">
<?php echo $pesan; ?>
<div id="form_area" class="column">
<h3>Data Pelanggan <?php echo ($tampil_baru)?'Baru':'Lama'; ?></h3>
<div class="box" style="width: 320px;">
<form id="form_pelanggan" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="id" value="<?php echo $form_value[id]; ?>" />
<div class="row">
<label>Kode Pelanggan</label> <input type="text" name="kode" value="<?php echo $form_value[kode]; ?>" />
</div>
<div class="row">
<label>Nama Pelanggan</label> <input type="text" name="nama" value="<?php echo $form_value[nama]; ?>" />
</div>
<div class="row">
<label>Nomor Telepon</label> <input type="text" name="telepon" value="<?php echo $form_value[telepon]; ?>" />
</div>
<div class="row">
<label>Nomor Fax</label> <input type="text" name="fax" value="<?php echo $form_value[fax]; ?>" />
</div>
<div class="row">
<label>Alamat</label> <textarea name="alamat"><?php echo $form_value[alamat]; ?></textarea>
</div>
<div class="row">
<label>Contact Person</label> <input type="text" name="kontak" value="<?php echo $form_value[kontak]; ?>" />
</div>
<div class="row">
<label> </label>
<input type="submit" name="action" value="new" class="hidable" title="baru" />
<input type="submit" name="action" value="save" title="simpan" />
<input type="submit" name="action" value="delete" class="hidable" title="hapus" onclick="return confirm_delete('<?php echo $form_value[nama]; ?>')" />
</div>
</form>
</div>
</div>
<div id="table_area" class="column" style="width: 650px;">
<h3>List data</h3>
<div class="box">
<form id="form_tabel" method="GET" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<div class="row">
<label>Banyak data per halaman :</label> <input type="text" name="n_data_halaman" size="5" value="10" /> <input type="submit" value="Ganti!" />
</div>
</form>
</div>
<br />
<div style="border: 1px solid #BFBFBF; overflow-y:none; overflow-x: scroll;">
<table id="tabel_pelanggan" class="sortable">
<?php
$query= "SELECT pelanggan.id AS id,
pelanggan.nama AS nama,
pelanggan.kode AS kode,
pelanggan.alamat AS alamat,
pelanggan.telepon AS telepon,
pelanggan.fax AS fax,
pelanggan.kontak AS kontak
FROM pelanggan
LIMIT $posisi, $n_data_halaman"; //echo $query;
$elemen=array('Kode pelanggan' => 'kode', 'Nama pelanggan' => 'nama', 'Telepon' => 'telepon', 'Fax' => 'fax', 'Contact Person' => 'kontak', 'Alamat' => 'alamat');
showTable($query, $elemen, 'row_click');
?>
</table>
</div>
<p>Halaman: |<?php showPagingLink($halaman, $n_data_halaman, $n_halaman); ?></p>
<p>Keterangan: klik pada judul tabel untuk mengurutkan data.</p>
</div>
</div>
<script language="Javascript">
function row_click(val) {
window.location = '<?php echo $_SERVER['PHP_SELF']; ?>?n_data_halaman=<?php echo $n_data_halaman; ?>&halaman=<?php echo $halaman; ?>&id='+val;
}
function confirm_delete(val) {
return confirm('Apakah anda benar-benar ingin menghapus pelanggan: '+val+'?\nPerhatian: cek terlebih dahulu transaksi-transaksi yang berhubungan dengan pelanggan ini.')
}
</script>
<style type="text/css">
#form_pelanggan label { width: 110px; }
#form_tabel label { width: 175px; }
<?php
if ($tampil_baru) {
?>
.hidable {
display: none;
}
<?php } ?>
</style>
<?php include($site_path."design/page_footer.php"); ?>
</div>
</body>
</html>