View difference between Paste ID: gFmjVmHf and CaRjYrXb
SHOW: | | - or go back to the newest paste.
1
<?php 
2
$s='';
3
if(isset($_GET['act']) && $_GET['act'] == 'input')
4-
	echo '<h2><img src="../gambar/barang.png" width="44" height="44"/> Master Barang</h2>';
4+
5-
	echo '<hr>';
5+
	$s.= '<h2><img src="../gambar/barang.png" width="44" height="44"/> Master Barang</h2>';
6-
	echo '<fieldset><legend><b>Form Input Barang</b></legend>';
6+
	$s.= '<hr>';
7-
	echo '<td>&nbsp;</td>';
7+
	$s.= '<fieldset><legend><b>Form Input Barang</b></legend>';
8-
	echo "<form enctype=\"multipart/form-data\" name='form1' method='post' action='home.php?module=inputbarang&act=input_brg'>
8+
	$s.= '<td>&nbsp;</td>';
9
	$s.= "<form enctype='multipart/form-data' name='form1' method='post' action='home.php?module=inputbarang&act=input_brg'>
10
			<table border='0'>
11
				<tr>
12
					<td>Jenis Barang</td>
13
					<td>: <select name='jenis'><option value='0'>Pilih Jenis</option>";
14
						$query	= "SELECT * FROM tbl_jenis";
15
						$hasil	= mysql_query($query);
16
						while ($data = mysql_fetch_array($hasil))
17-
							echo "<option value=$data[kode_jenis]>$data[jenis_barang]</option>";
17+
18
							$s.= "<option value=$data[kode_jenis]>$data[jenis_barang]</option>";
19-
	echo "
19+
20
	$s.= "
21
					</select>
22
					</td>
23
					<td>&nbsp;</td>
24
					<td>&nbsp;</td>
25
					<td>&nbsp;</td>
26
			<td>ID Barang</td>
27
					<td>: <input type=text name=id_barang></td>
28
				</tr> 
29
				<tr>
30
			<td>Nama Barang</td>
31
					<td>: <input type=text name=barang></td>
32
					<td>&nbsp;</td>
33
					<td>&nbsp;</td>
34
					<td>&nbsp;</td>
35
			<td>Jumlah Barang</td>
36
					<td>: <input type=text name=jumlah></td>
37
				</tr>
38
				<tr>
39
			<td>Tanggal Pengadaan</td>
40
					<td>: <input type=text name=pengadaan id=tanggal></td>
41-
						$(\"tanggal\").datepicker();
41+
42
						$('tanggal').datepicker();
43
				<td>&nbsp;</td>
44
				<td>&nbsp;</td>
45
				<td>&nbsp;</td>
46
			<td>No. Inventaris</td>
47
					<td>: <input type=text name=nomor></td>
48
				</tr>
49
				<tr>
50-
	<td>: <select name=\"idlokasi\" id=\"idlokasi\"><option value='0'>Pilih Lokasi</option>
50+
51
	<td>: <select name='idlokasi' id='idlokasi'><option value='0'>Pilih Lokasi</option>
52
					";
53
	$qryjurusan = mysql_query("select * from tbl_jurusan");
54-
echo "<option value=\"$datajurusan[kode_jurusan]\">$datajurusan[nama_jurusan]</option>";
54+
55
$s.= "<option value='$datajurusan[kode_jurusan]'>$datajurusan[nama_jurusan]</option>";
56-
		echo "			
56+
57
		$s.= "			
58
					</select>
59
					</td>
60
					<td>&nbsp;</td>
61
					<td>&nbsp;</td>
62
					<td>&nbsp;</td>
63-
<td>: <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"400000\"><input name=\"fupload\" type=\"file\"></td>
63+
64
<td>: <input type='hidden' name='MAX_FILE_SIZE' value='400000'><input name='fupload' type='file'></td>
65
	</tr>
66
	<tr>
67-
	<td>: <select name=\"idstatus\" id=\"idstatus\"><option value=\"0\">Kondisi</option>
67+
68-
		<option value=\"Baik\">Baik</option>
68+
	<td>: <select name='idstatus' id='idstatus'><option value='0'>Kondisi</option>
69-
		<option value=\"Rusak\">Rusak</option>
69+
		<option value='Baik'>Baik</option>
70
		<option value='Rusak'>Rusak</option>
71
		</select>
72
		</td>
73
	</tr>
74
	<tr>
75-
	<input type=reset name=reset value=Batal onclick=\"javascript:history.go(-1)\"></td>
75+
76
	<input type=reset name=reset value=Batal onclick='javascript:history.go(-1)'></td>
77
	</tr>
78
		</table>
79
		</fieldset>
80
			</form>";
81
			
82
}
83
elseif(isset($_GET['act']) && $_GET['act'] == 'input_brg')
84
{
85
	$lokasi_file= $_FILES["fupload"]["tmp_name"];
86
	$nama_file 	= $_FILES["fupload"]["name"];
87
	$tipe_file 	= $_FILES["fupload"]["type"];
88
	$direktori	= "../img_upload/$nama_file";
89
	if(move_uploaded_file($lokasi_file, $direktori))
90
	{
91
		
92-
	$sql=mysql_query("INSERT INTO tbl_barang SET id_barang	='$_POST[id_barang]',									
92+
93-
		jenis_barang	='$_POST[jenis]',								
93+
	$sql="INSERT INTO tbl_barang values ('$_POST[id_barang]',									
94-
		nama_barang	='$_POST[barang]',
94+
		 '$_POST[jenis]',								
95-
		jml_brg		='$_POST[jumlah]',				
95+
		 '$_POST[barang]',
96-
		tgl_pengadaan	='$_POST[pengadaan]',									
96+
		 '$_POST[jumlah]',				
97-
		no_inventaris	='$_POST[nomor]',
97+
		 '".date("Y-m-d", strtotime($_POST[pengadaan])."',									
98-
		foto		='$nama_file',
98+
		 '$_POST[nomor]',
99-
		jurusan		='$_POST[idlokasi]',
99+
		 '$nama_file',
100-
		status		='$_POST[idstatus]',
100+
		 '$_POST[idlokasi]',
101-
		user		='$_SESSION[id_user]'") or die (mysql_error());
101+
		 '$_POST[idstatus]',
102
		 '$_SESSION[id_user]'";
103
	die($sql);
104
	/*
105
	check sql kamu dan pastikan dgn input langsung pake phpmyadmin	 
106
	kalau hasilnya error.. coba cari apa input yg harus masuk dan edit 
107
	$sql di atas
108
	*/
109
	$r=mysql_query($sql) or die (mysql_error().$sql);
110
					header('location:home.php?module=inputbarang');
111-
	echo '<h2>Edit Data Barang</h2>';
111+
112-
	echo '<fieldset><legend>Form Edit Data Barang</legend>';
112+
113-
	echo "<form enctype=\"multipart/form-data\" name='form1' method='post' action='home.php?module=inputbarang&act=edit_brg'>
113+
114
{
115
	//query untuk prose update/edit  barang
116
	$_SESSION['id_barang'] = $_GET['id'];
117
	$sql = mysql_query("SELECT * FROM tbl_barang WHERE id_barang='$_GET[id]'");
118
	$arr = mysql_fetch_array($sql);
119
	$s.= '<h2>Edit Data Barang</h2>';
120
	$s.= '<fieldset><legend>Form Edit Data Barang</legend>';
121
	$s.= "<form enctype='multipart/form-data' name='form1' method='post' action='home.php?module=inputbarang&act=edit_brg'>
122
			<table border='0'>
123
				<tr>
124-
								$selected = "selected=\"selected\"";		
124+
125
					<td>: <select name='jenis'>"; 
126
						$query	= "SELECT * FROM tbl_jenis";
127
						$hasil	= mysql_query($query);
128
						while ($data = mysql_fetch_array($hasil))
129
						{
130-
							echo "<option value='$data[kode_jenis]' $selected>$data[jenis_barang]</option>";
130+
131
							{
132-
	echo "
132+
								$selected = "selected='selected'";		
133
							}
134
							else
135
							{
136
								$selected = "";	
137
							}
138
							$s.= "<option value='$data[kode_jenis]' $selected>$data[jenis_barang]</option>";
139
						}
140
	$s.= "
141
					</select>
142
					</td>
143
				<td>&nbsp;</td>
144
				<td>&nbsp;</td>
145
				<td>&nbsp;</td>
146
				<td>ID Barang</td>
147
					<td>: <input type=text name=id_barang value='$arr[id_barang]'></td>
148
				</tr> 
149
				<tr>
150
					<td>Nama Barang</td>
151
					<td>: <input type=text name=barang  value='$arr[nama_barang]'></td>
152
				<td>&nbsp;</td>
153
				<td>&nbsp;</td>
154
				<td>&nbsp;</td>
155
				<td>Jumlah Barang</td>
156
					<td>: <input type=text name=jumlah  value='$arr[jml_brg]'></td>
157
				</tr>
158
				<tr>
159
					<td>Tanggal Pengadaan</td>
160
					<td>: <input type=text name=pengadaan  value='$arr[tgl_pengadaan]'></td>
161-
					<td>: <select name=\"idlokasi\" id=\"idlokasi\">
161+
162
				<td>&nbsp;</td>
163
				<td>&nbsp;</td>
164
				<td>No. Inventaris</td>
165
					<td>: <input type=text name=nomor  value='$arr[no_inventaris]'></td>
166
				</tr>
167-
$selected2 = "selected=\"selected\"";	
167+
168
					<td>Lokasi Barang</td>
169
					<td>: <select name='idlokasi' id='idlokasi'>
170
					";
171
$qryjurusan = mysql_query("select * from tbl_jurusan");
172
while($datajurusan=mysql_fetch_array($qryjurusan)){
173-
echo "<option value=\"$datajurusan[kode_jurusan]\" $selected2>$datajurusan[nama_jurusan]</option>";
173+
174
{
175-
echo "			
175+
$selected2 = "selected='selected'";	
176
}
177
else
178
{
179
$selected2 = "";
180
}
181-
<td>: <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"400000\"><input name=\"fupload\" type=\"file\"></td>
181+
$s.= "<option value='$datajurusan[kode_jurusan]' $selected2>$datajurusan[nama_jurusan]</option>";
182
}
183
$s.= "			
184
</select>
185
</td>
186
</tr>		
187
<tr>
188
<td>Foto</td>
189
<td>: <input type='hidden' name='MAX_FILE_SIZE' value='400000'><input name='fupload' type='file'></td>
190-
<select name=\"idstatus\" id=\"idstatus\"><option value=\"0\">Kondisi</option>";
190+
191
<tr>
192
<td>&nbsp;</td>
193-
echo "	<option value=\"Baik\" selected=\"selected\">Baik</option>
193+
194-
<option value=\"Rusak\">Rusak</option>";
194+
195
<tr>
196
<td>Status</td>
197
<td>: 
198-
echo "	<option value=\"Baik\">Baik</option>
198+
<select name='idstatus' id='idstatus'><option value='0'>Kondisi</option>";
199-
<option value=\"Rusak\" selected=\"selected\">Rusak</option>";
199+
200
{
201-
echo "				
201+
$s.= "	<option value='Baik' selected='selected'>Baik</option>
202
<option value='Rusak'>Rusak</option>";
203
}
204
else
205
{
206
$s.= "	<option value='Baik'>Baik</option>
207-
	<input type=reset name=reset value=Batal onclick=\"javascript:history.go(-1)\"></td>
207+
<option value='Rusak' selected='selected'>Rusak</option>";
208
	}
209
$s.= "				
210
	</select>
211
	</td>
212
	</tr>
213
	<tr>
214
	<td>&nbsp;</td><td>&nbsp; <input type=submit name=submit value=Tambah>
215
	<input type=reset name=reset value=Batal onclick='javascript:history.go(-1)'></td>
216
	</tr>
217
	</table>
218
	</fieldset>
219
</form>";
220
}
221
elseif(isset($_GET['act']) && $_GET['act'] == 'edit_brg')
222
{
223
	$lokasi_file= $_FILES["fupload"]["tmp_name"];
224
	$nama_file 	= $_FILES["fupload"]["name"];
225
	$tipe_file 	= $_FILES["fupload"]["type"];
226-
	$sql=mysql_query("UPDATE tbl_barang SET id_barang	='$_POST[id_barang]', 								
226+
227
	if(move_uploaded_file($lokasi_file, $direktori))
228
	{
229
		
230
	}
231
	
232
	if(empty($lokasi_file))
233
	{
234
	$sql="UPDATE tbl_barang SET id_barang	='$_POST[id_barang]', 								
235-
	 id_barang ='$_SESSION[id_barang]'") or die (mysql_error());
235+
236
	nama_barang		='$_POST[barang]',
237
	jml_brg			='$_POST[jumlah]',										
238
	tgl_pengadaan		='$_POST[pengadaan]',
239
	no_inventaris		='$_POST[nomor]',
240
	jurusan			='$_POST[idlokasi]',
241
	status			='$_POST[idstatus]',
242
	user			='$_SESSION[id_user]'
243
	 id_barang ='$_SESSION[id_barang]'";
244
	 $r=mysql_query($sql) or die (mysql_error().$sql);
245
	header('location:home.php?module=inputbarang');		
246
	exit();
247
	}
248
else
249
	{
250
	$sql=mysql_query("UPDATE tbl_barang SET id_barang='$_POST[id_barang]', 									
251
					jenis_barang		='$_POST[jenis]',										
252
					nama_barang		='$_POST[barang]',
253
					jml_brg			='$_POST[jumlah]',										
254
					tgl_pengadaan		='$_POST[pengadaan]',										
255
					no_inventaris		='$_POST[nomor]',
256
					foto			='$nama_file',
257
					jurusan			='$_POST[idlokasi]',
258
					status			='$_POST[idstatus]',
259
					user			='$_SESSION[id_user]'
260
	WHERE id_barang ='$_SESSION[id_barang]'") or die (mysql_error());
261
	header('location:home.php?module=inputbarang');
262
	exit();
263
	}
264
}
265
elseif(isset($_GET['act']) && $_GET['act'] == 'delete')
266-
	echo '<h2>Daftar Data Barang</h2>';
266+
267-
	echo '<hr>';
267+
268-
	echo '<a href=home.php?module=inputbarang&act=input>Tambah Data Barang</a>';
268+
269
	header('location:home.php?module=inputbarang');
270
	exit();
271
}
272
else
273
{
274
	unset($_SESSION['id_barang']);
275
	$s.= '<h2>Daftar Data Barang</h2>';
276
	$s.= '<hr>';
277
	$s.= '<a href=home.php?module=inputbarang&act=input>Tambah Data Barang</a>';
278
	isset($_GET['hal']) ? $hal = $_GET['hal'] : $hal = 1;
279
	$batas = 4;
280
	if(! isset($hal))
281
	{
282
		$posisi = 0;	
283
	}
284
	else
285
	{
286
		$posisi =($hal-1) * $batas;	
287
	}
288
	//proses tampil data barang
289-
		echo '<fieldset><table border="1">
289+
290
	
291
	// cek jumlah data dalam tabel database
292
	$jml_data = mysql_num_rows ($tampil_data);
293
	
294
	// jika ada data
295
	if($jml_data > 0)
296
	{
297
298
		$s.= '<fieldset><table border="1">
299
					<tr>
300
						<th>No.</th>
301
						<th>ID Barang</th>
302
						<th>Jenis Barang</th>
303
						<th>Nama Barang</th>
304
						<th>Jlh. Barang</th>
305
						<th>Tgl. Pengadaan</th>
306
						<th>No. Inventaris</th>
307-
			echo "<tr bgcolor='".$bg."'>
307+
308
						<th>Kondisi Barang</th>
309
						<th>Foto Barang</th>
310
						<th>Aksi</th>
311
					</tr></fieldset>';
312
		$no = $posisi + 1 ;
313
		while($data_user = mysql_fetch_array($tampil_data))
314
		{
315
			if($no%2==0) $bg='#cccccc'; else $bg ='#99FFCC';
316
			$s.= "<tr bgcolor='".$bg."'>
317
						<td>$no</td>
318-
						<td><a href=home.php?module=inputbarang&act=edit&id=$data_user[id_barang]><img src='../gambar/My Computer_2.png' width=\"17\" height=\"17\" /> Edit</a>  | 
318+
319
						<td>$data_user[jenis_barang]</td>
320
						<td>$data_user[nama_barang]</td>
321
						<td>$data_user[jml_brg]</td>
322
						<td>$data_user[tgl_pengadaan]</td>
323-
		echo '</table>';
323+
324
						<td>$data_user[jurusan]</td>
325
						<td>$data_user[status]</td>
326
						<td>$data_user[foto]</td>
327
						<td><a href=home.php?module=inputbarang&act=edit&id=$data_user[id_barang]><img src='../gambar/My Computer_2.png' width='17' height='17' /> Edit</a>  | 
328
						<a href=home.php?module=inputbarang&act=delete&id=$data_user[id_barang]><img src='../gambar/close.png' width=16 height=16/> Hapus</td>
329
					</tr>";
330
			$no++;
331
		} 
332
		$s.= '</table>';
333
		$qrypaging 	= mysql_query("select * from tbl_barang");
334-
					echo " <a href='home.php?module=inputbarang&hal=$i'>$i</a>";	
334+
335
		if($jmlpaging > $batas)
336
		{
337
			$linkpaging = $jmlpaging - $batas;
338-
					echo " $i";	
338+
339
			for($i=1; $i<=$linkpaging;$i++)
340
			{
341
				if($hal != $i)
342
				{
343
					$s.= " <a href='home.php?module=inputbarang&hal=$i'>$i</a>";	
344
				}
345-
		echo '<p>Data Tidak ditemukan</p>';
345+
346
				{
347
					$s.= " $i";	
348
				}
349
			}
350
		}
351
	}
352
	else
353
	{
354
		$s.= '<p>Data Tidak ditemukan</p>';
355
	}
356
}
357
?>
358
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
359
<html xmlns="http://www.w3.org/1999/xhtml">
360
<head>
361
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
362
<title></title>
363
</head>
364
<script language="JavaScript">
365
   function konfirmasi(id_barang)
366
   {
367
       tanya = confirm('Anda yakin ingin menghapus barang '+ id_barang + '?');
368
       if (tanya == true) return true;
369
       else return false;
370
   }
371
  </script>
372
  <script type="text/javascript" src="jquery.min.js"></script>
373
  <script type="text/javascript" src="jquery.ui.min.js"></script>
374
  <script language=javascript>
375
			$(document).ready(function(){
376
				$("#tanggal").click(function(){
377
					$(this).datepicker();
378
				})
379
			});
380
<body>
381
<?=$s;?>
382
</body>
383
</html>