001.
<html lang=
"en"
><head><meta http-equiv=
"Content-Type"
content=
"text/html; charset=UTF-8"
>
002.
<meta charset=
"utf-8"
>
003.
<head>
004.
<meta http-equiv=
"content-type"
content=
"text/html;"
/>
005.
<title>แบบฟอร์มการยืมอุปกรณ์ออนไลน์</title>
006.
<style type=
"text/css"
>
007.
008.
#error {color:red}
009.
#notice {color:green}
010.
011.
</style>
012.
014.
<script type=
"text/javascript"
>
015.
016.
017.
var
province_id = <?php
echo
isset(
$_POST
[
'province_id'
])
018.
?
intval
(
$_POST
[
'province_id'
]):
'0'
; ?>;
019.
var
amphur_id = <?php
echo
isset(
$_POST
[
'amphur_id'
])
020.
?
intval
(
$_POST
[
'amphur_id'
]):
'0'
; ?>;
021.
var
district_id = <?php
echo
isset(
$_POST
[
'district_id'
])
022.
?
intval
(
$_POST
[
'district_id'
]):
'0'
; ?>;
023.
var
zipcode_id = <?php
echo
isset(
$_POST
[
'zipcode_id'
])
024.
?
intval
(
$_POST
[
'zipcode_id'
]):
'0'
; ?>;
025.
026.
function
loadSelectBox(id,url,selected){
027.
$.get(
028.
url,{},
function
(data){
029.
$(id).html(data);
030.
if
(selected!=0){
031.
$(id+
' option[value='
+selected+
']'
).attr(
'selected'
,
'selected'
);
032.
}
033.
}
034.
);
035.
}
036.
037.
$(
function
(){
038.
loadSelectBox(
039.
'#province_id'
,
040.
'geo_combo.php?load=province'
,
041.
province_id
042.
);
043.
loadSelectBox(
044.
'#amphur_id'
,
045.
'geo_combo.php?load=amphur&province_id='
+province_id,
046.
amphur_id
047.
);
048.
loadSelectBox(
049.
'#district_id'
,
050.
'geo_combo.php?load=district&hur_id='
+amphur_id,
051.
district_id
052.
);
053.
054.
loadSelectBox(
055.
'#zipcode_id'
,
056.
'geo_combo.php?load=zipcode&district_id='
+district_id,
057.
zipcode_id
058.
);
059.
060.
061.
$(
'#province_id'
).change(
function
(e){
062.
var
selected = e.target.value;
063.
loadSelectBox(
064.
'#amphur_id'
,
065.
'geo_combo.php?load=amphur&province_id='
+selected,
066.
0
067.
);
068.
$(
'#district_id :not(option:first)'
).remove();
069.
});
070.
071.
072.
$(
'#amphur_id'
).change(
function
(e){
073.
var
selected = e.target.value;
074.
loadSelectBox(
075.
'#district_id'
,
076.
'geo_combo.php?load=district&hur_id='
+selected,
077.
0
078.
);
079.
$(
'#zipcode_id :not(option:first)'
).remove();
080.
});
081.
082.
083.
$(
'#district_id'
).change(
function
(e){
084.
var
selected = e.target.value;
085.
loadSelectBox(
086.
'#zipcode_id'
,
087.
'geo_combo.php?load=zipcode&district_id='
+selected,
088.
0
089.
);
090.
$(
'#zipcode_id'
).change(
function
(e){
091.
var
selected = e.target.value;
092.
093.
});
094.
});
095.
});
096.
function
check_number(){
097.
if
((event.keyCode<48) || (event.keyCode>57)){event.returnValue = false;alert(
'กรอกได้เฉพาะตัวเลขเท่านั้น '
);}
098.
}
099.
100.
function
checkTel() {
101.
var
tel = document.getElementById(
"telephone"
).value;
102.
var
patt = /^[0]{1}[8]{1}[0-9]{7,}/
103.
if
(tel.match(patt))
104.
document.getElementById(
"error"
).innerHTML =
"True"
;
105.
else
106.
document.getElementById(
"error"
).innerHTML =
"False"
;
107.
}
108.
109.
function
checktext(e){
110.
var
keyPressed;
111.
if
(window.event){
112.
if
(event.keyCode != 32 && (event.keyCode < 97) || event.keyCode > 122 && (keyPressed < 3585) || (keyPressed > 3659)){
113.
event.returnValue = false;alert(
'กรอกได้เฉพาะตัวอักษรเท่านั้น '
);
114.
}
115.
}
else
{
116.
keyPressed = e.which;
117.
alert(keyPressed);
118.
if
(keyPressed != 8 && (keyPressed < 97) || (keyPressed > 122) && (keyPressed < 3585) || (keyPressed > 3659)){
119.
keyPressed = e.preventDefault();
120.
}
121.
}
122.
}
123.
124.
125.
var
starDateTextBox = $(
'#cust_appr'
);
126.
var
endDateTextBox = $(
'#meeting_date'
);
127.
$.timepicker.dateRange(
128.
starDateTextBox,
129.
endDateTextBox,
130.
{
131.
minInterval: (1000*60*60*24*15),
132.
start: {},
133.
end
: {}
134.
}
135.
);
136.
137.
138.
139.
140.
141.
142.
</script>
143.
</head>
144.
<body>
145.
146.
147.
148.
<?php
149.
if
(isset(
$_POST
[
'title'
])){
150.
include_once
'config.php'
;
151.
$e
=
array
();
152.
$level
=
'district'
;
153.
154.
if
(
empty
(
$_POST
[
'title'
])){
155.
$e
[] =
'title ไม่ถูกต้อง'
;
156.
}
157.
if
(
empty
(
$_POST
[
'zipcode_id'
])){
158.
if
(
empty
(
$_POST
[
'district_id'
])){
159.
if
(
empty
(
$_POST
[
'amphur_id'
])){
160.
161.
if
(
empty
(
$_POST
[
'province_id'
])){
162.
$e
[] =
'ไม่ได้ระบุจังหวัด'
;
163.
}
164.
$e
[] =
'ไม่ได้ระบุอำเภอ'
;
165.
$e
[] =
'ไม่ได้ระบุตำบล'
;
166.
$e
[] =
'ไม่ได้ระบุรหัสไปรษณีย์'
;
167.
}
else
{
168.
$amphur_id
=
intval
(
$_POST
[
'amphur_id'
]);
169.
$r
= mysql_query(
"SELECT count(*) FROM `amphur` WHERE `AMPHUR_ID`=$amphur_id"
);
170.
if
(mysql_result(
$r
,0)==0){
171.
$e
[] =
'อำเภอไม่ถูกต้อง'
;
172.
}
else
{
173.
$r
= mysql_query(
"SELECT count(*) FROM `district` WHERE `AMPHUR_ID`=$amphur_id"
);
174.
if
(mysql_result(
$r
,0)>0){
175.
$e
[] =
'ยังไม่ได้ระบุตำบล'
;
176.
}
else
{
177.
$level
=
'amphur'
;
178.
179.
}
180.
}
181.
}
182.
}
183.
if
(
count
(
$e
)>0){
184.
echo
'<div id="error">'
,implode(
''
,
$e
),
'</div>'
;
185.
}
186.
else
{
187.
$district_id
=
intval
(
$_POST
[
'district_id'
]);
188.
$r
= mysql_query(
"SELECT count(*) FROM `district` WHERE `DISTRICT_ID`=$district_id"
);
189.
if
(mysql_result(
$r
,0)==0){
190.
$e
[] =
'ตำบลไม่ถูกต้อง'
;
191.
}
192.
}
193.
if
(
count
(
$e
)>0){
194.
echo
'<div id="error">'
,implode(
''
,
$e
),
'</div>'
;
195.
}
else
{
196.
echo
"<div id=\"notice\">valid at level : $level</div>"
;
197.
$zipcode_id
=
intval
(
$_POST
[
'$zipcode_id'
]);
198.
$r
= mysql_query(
"SELECT count(*) FROM `zipcode` WHERE `ZIPCODE_ID`=$zipcode_id"
);
199.
if
(mysql_result(
$r
,0)==0){
200.
$e
[] =
'รหัสไปรษณีย์ไม่ถูกต้อง'
;
201.
}
202.
}
203.
}
204.
elseif
(
$level
==
'district'
) {
205.
206.
$r
= mysql_query(
"SELECT * FROM `district` WHERE `DISTRICT_ID`=$district_id"
);
207.
$district_value
=
$district_id
;
208.
$amphur_value
= mysql_result(
$r
,0,
'AMPHUR_ID'
);
209.
$province_value
= mysql_result(
$r
,0,
'PROVINCE_ID'
);
210.
}
211.
else
{
212.
$r
= mysql_query(
"SELECT * FROM `amphur` WHERE `AMPHUR_ID`=$amphur_id"
);
213.
$amphur_value
= mysql_result(
$r
,0,
'AMPHUR_ID'
);
214.
$province_value
= mysql_result(
$r
,0,
'PROVINCE_ID'
);
215.
}
216.
}
217.
218.
?>
219.
220.
221.
<?php
222.
if
(!isset(
$_SESSION
)){
223.
session_start();
224.
}
225.
include_once
'./include/function.php'
;
226.
227.
include_once
'./include/connect.php'
;
228.
$errorpost
=
'no'
;
229.
if
(isset(
$_POST
) && isset(
$_POST
[
'n'
])){
230.
$result_br
=
$con
->prepare(
"SELECT * FROM equipment WHERE equ_id="
.
$_POST
[
'n'
][
'equ_id'
]);
231.
$result_br
->execute();
232.
$rsn
=
$result_br
->fetch();
233.
if
(
$rsn
[
'equ_num'
]<
$_POST
[
'n'
][
'u_num'
]){
234.
$_SESSION
[
'flash'
][
'msg'
]=
"จำนวนไม่พอให้ยืม"
;
235.
$_SESSION
[
'flash'
][
'type'
]=
'danger'
;
236.
$errorpost
=
'yes'
;
237.
}
238.
}
239.
if
(isset(
$_POST
) && isset(
$_POST
[
'n'
])){
240.
241.
if
(
date
(
$_POST
[
'n'
][
'u_date_borrow'
])<
date
(
"Y-m-d H:i:s"
)){
242.
$_SESSION
[
'flash'
][
'msg'
] =
'วันที่ไม่ถูกต้อง กรุณากรอกใหม่อีกครั้ง'
;
243.
$_SESSION
[
'flash'
][
'type'
] =
'danger'
;
244.
$errorpost
=
'yes'
;
245.
}
246.
247.
248.
249.
250.
251.
252.
253.
if
(
$errorpost
==
'no'
){
254.
255.
$n
=
array
(
256.
'u_id'
=>
$_POST
[
'n'
][
'u_id'
],
257.
'u_name'
=>
$_POST
[
'n'
][
'u_name'
],
258.
'u_address'
=>
$_POST
[
'n'
][
'u_address'
],
259.
'province_id'
=>
$_POST
[
'n'
][
'province_id'
],
260.
'amphur_id'
=>
$_POST
[
'n'
][
'amphur_id'
],
261.
'district_id'
=>
$_POST
[
'n'
][
'district_id'
],
262.
'zipcode_id'
=>
$_POST
[
'n'
][
'zipcode_id'
],
263.
'u_tel'
=>
$_POST
[
'n'
][
'u_tel'
],
264.
'equ_id'
=>
$_POST
[
'n'
][
'equ_id'
],
265.
'u_num'
=>
$_POST
[
'n'
][
'u_num'
],
266.
'u_date_borrow'
=>
$_POST
[
'n'
][
'u_date_borrow'
],
267.
'u_date_return'
=>
$_POST
[
'n'
][
'u_date_return'
],
268.
269.
270.
);
271.
272.
$result
=
$con
->prepare(
"INSERT INTO u_equ_borrow(u_id,u_name,u_address,province_id,amphur_id,district_id,zipcode_id,u_tel,equ_id,u_num,u_date_borrow,u_date_return) "
273.
.
"VALUES(:u_id,:u_name,:u_address,:province_id,:amphur_id,:district_id,:zipcode_id,:u_tel,:equ_id,:u_num,:u_date_borrow,:u_date_return)"
);
274.
echo
$result
->execute(
$n
);
275.
if
(
$result
!==FALSE){
276.
277.
278.
279.
$negative
=
$rsn
[
'equ_num'
]-
$_POST
[
'n'
][
'u_num'
];
280.
281.
$result_brr
=
$con
->prepare(
"UPDATE equipment SET equ_num='"
.
$negative
.
"' WHERE equ_id='"
.
$_POST
['n
']['
equ_id
']."'
");
282.
$result_brr
->execute();
283.
284.
}
if
(
$result_brr
!==FALSE){
285.
$_SESSION
[
'flash'
][
'msg'
]=
"บันทึกข้อมูลเรียบร้อย"
;
286.
$_SESSION
[
'flash'
][
'type'
]=
'success'
;
287.
redirect_to(
'user_show_equ.php'
);
288.
}
289.
else
{
290.
$_SESSION
[
'flash'
][
'msg'
]=
"ไม่สามารถบันทึกข้อมูลได้"
;
291.
$_SESSION
[
'flash'
][
'type'
]=
'danger'
;
292.
redirect_to(
'user_borrow.php'
);
293.
}
294.
}
295.
}
296.
297.
298.
include_once
'./include/header.php'
;
299.
?>
300.
301.
302.
<div
class
=
"container"
>
303.
304.
<!-- <?php
if
(isset(
$_SESSION
[
'flash'
])){?>
305.
<div
class
=
"alert alert-<?php echo $_SESSION['flash']['type'];?>"
role=
"alert"
><?php
echo
$_SESSION
[
'flash'
][
'msg'
]; ?></div>
306.
<?php }?> -->
307.
308.
<div
class
=
"col-lg-8"
>
309.
<h3 id=
"tables"
><b>แบบฟอร์มการยืมอุปกรณ์ออนไลน์</b></h3>
310.
<div
class
=
"well"
>
311.
<form ole=
"form"
method=
"post"
class
=
"form-horizontal"
>
312.
<fieldset>
313.
<!--<legend></legend>-->
314.
<div
class
=
"form-group"
>
315.
<label
for
=
"u_name"
class
=
"col-lg-2 control-label"
>ชื่อ-นามสกุล</label>
316.
<div
class
=
"col-lg-10"
>
317.
<input type=
"text"
name=
"n[u_name]"
id=
"u_name"
class
=
"form-control"
placeholder=
"ชื่อ-นามสกุล"
onkeypress=
"return checktext()"
required=
"required"
maxlength=
"50"
>
318.
</div>
319.
</div>
320.
321.
<div
class
=
"form-group"
>
322.
<label
for
=
"u_address"
class
=
"col-lg-2 control-label"
>ที่อยู่</label>
323.
<div
class
=
"col-lg-10"
>
324.
<input type=
"text"
name=
"n[u_address]"
id=
"u_address"
class
=
"form-control"
placeholder=
"ที่อยู่"
required=
"required"
maxlength=
"50"
>
325.
</div>
326.
</div>
327.
328.
329.
<div
class
=
"form-group"
>
330.
<label
for
=
"province_id"
class
=
"col-lg-2 control-label"
>จังหวัด</label>
331.
<div
class
=
"col-lg-4"
>
332.
<select name=
"n[province_id]"
id=
"province_id"
class
=
"form-control"
required=
"required"
>
333.
<option value=
"0"
hidden=
"hidden"
>-- เลือกจังหวัด --</option>
334.
<?php
335.
$resultsc
=
$con
->prepare(
"SELECT * FROM province"
);
336.
$resultsc
->execute();
337.
while
(
$rssc
=
$resultsc
->fetch()){
338.
if
(
$rssc
[
'PROVINCE_ID'
] != 0) {
339.
echo
'<option value="'
.
$rssc
[
'PROVINCE_NAME'
].
'">'
.
$rssc
[
'PROVINCE_NAME'
].
'</option>'
;
340.
}
341.
}
342.
?>
343.
</select>
344.
</div>
345.
346.
<label
for
=
"amphur_id"
class
=
"col-lg-1 control-label"
>อำเภอ</label>
347.
<div
class
=
"col-lg-5"
>
348.
<select name=
"n[amphur_id]"
id=
"amphur_id"
class
=
"form-control"
required=
"required"
>
349.
<option value=
"0"
hidden=
"hidden"
>-- เลือกอำเภอ --</option>
350.
<?php
351.
$resultsc
=
$con
->prepare(
"SELECT * FROM amphur"
);
352.
$resultsc
->execute();
353.
while
(
$rssc
=
$resultsc
->fetch()){
354.
if
(
$rssc
[
'AMPHUR_ID'
] != 0) {
355.
echo
'<option value="'
.
$rssc
[
'AMPHUR_NAME'
].
'">'
.
$rssc
[
'AMPHUR_NAME'
].
'</option>'
;
356.
}
357.
}
358.
?>
359.
</select>
360.
</div>
361.
</div>
362.
363.
364.
<div
class
=
"form-group"
>
365.
<label
for
=
"district_id"
class
=
"col-lg-2 control-label"
>ตำบล</label>
366.
<div
class
=
"col-lg-4"
>
367.
<select name=
"n[district_id]"
id=
"district_id"
class
=
"form-control"
required=
"required"
>
368.
<option value=
"0"
hidden=
"hidden"
>-- เลือกตำบล --</option>
369.
<?php
370.
$resultsc
=
$con
->prepare(
"SELECT * FROM district"
);
371.
$resultsc
->execute();
372.
while
(
$rssc
=
$resultsc
->fetch()){
373.
if
(
$rssc
[
'DISTRICT_ID'
] != 0) {
374.
echo
'<option value="'
.
$rssc
[
'DISTRICT_NAME'
].
'">'
.
$rssc
[
'DISTRICT_NAME'
].
'</option>'
;
375.
}
376.
}
377.
?>
378.
</select>
379.
</div>
380.
381.
382.
<label
for
=
"zipcode_id"
class
=
"col-lg-1 control-label"
>รหัส</label>
383.
<div
class
=
"col-lg-5"
>
384.
<select name=
"n[zipcode_id]"
id=
"zipcode_id"
class
=
"form-control"
required=
"required"
>
385.
<option value=
"0"
hidden=
"hidden"
>-- เลือกรหัสไปรษณีย์ --</option>
386.
<?php
387.
$resultsc
=
$con
->prepare(
"SELECT * FROM zipcode"
);
388.
$resultsc
->execute();
389.
while
(
$rssc
=
$resultsc
->fetch()){
390.
if
(
$rssc
[
'ZIPCODE_ID'
] != 0) {
391.
echo
'<option value="'
.
$rssc
[
'ZIPCODE'
].
'">'
.
$rssc
[
'ZIPCODE'
].
'</option>'
;
392.
}
393.
}
394.
?>
395.
</select>
396.
</div>
397.
</div>
398.
399.
400.
<div
class
=
"form-group"
>
401.
<label
for
=
"u_tel"
class
=
"col-lg-2 control-label"
>เบอร์โทร</label>
402.
<div
class
=
"col-lg-10"
>
403.
<input type=
"text"
name=
"n[u_tel]"
id=
"u_tel"
class
=
"form-control"
placeholder=
"เบอร์โทร"
onkeypress=
"check_number()"
required=
"required"
maxlength=
"10"
>
404.
</div>
405.
</div>
406.
407.
<div
class
=
"form-group"
>
408.
<label
for
=
"equ_id"
class
=
"col-lg-2 control-label"
>อุปกรณ์ที่ยืม</label>
409.
<div
class
=
"col-lg-4"
>
410.
<select name=
"n[equ_id]"
id=
"equ_id"
class
=
"form-control"
required=
"required"
>
411.
<option value=
"0"
hidden=
"hidden"
>กรุณาเลือก</option>
412.
<?php
413.
$resultsc
=
$con
->prepare(
"SELECT * FROM equipment"
);
414.
$resultsc
->execute();
415.
while
(
$rssc
=
$resultsc
->fetch()){
416.
if
(
$rssc
[
'equ_id'
] != 0) {
417.
echo
'<option value="'
.
$rssc
[
'equ_id'
].
'">'
.
$rssc
[
'equ_name'
].
'('
.
$rssc
[
'equ_num'
].
')</option>'
;
418.
}
419.
}
420.
?>
421.
</select>
422.
</div>
423.
424.
<label
for
=
"u_num"
class
=
"col-lg-1 control-label"
>จำนวน</label>
425.
<div
class
=
"col-lg-5"
>
426.
<input type=
"int"
name=
"n[u_num]"
id=
"u_num"
class
=
"form-control"
placeholder=
"จำนวน"
onkeypress=
"check_number()"
required=
"required"
maxlength=
"5"
>
427.
</div>
428.
</div>
429.
430.
431.
<div
class
=
"form-group"
>
432.
<label
for
=
"u_date_borrow"
class
=
"col-lg-2 control-label"
>วันที่ยืม</label>
433.
<div
class
=
"col-lg-4"
>
434.
<input type=
"date"
name=
"n[u_date_borrow]"
id=
"u_date_borrow"
class
=
"form-control"
required=
""
value=
"<?php echo date("
d/m/Y
")?>"
>
435.
</div>
436.
437.
<label
for
=
"u_date_return"
class
=
"col-lg-1 control-label"
>คืน</label>
438.
<div
class
=
"col-lg-5"
>
439.
<input type=
"text"
name=
"n[u_date_return]"
id=
"u_date_return"
class
=
"form-control"
readonly=
""
value=
"<?php echo date("
ยังไม่มีการแจ้งคืน
")?>"
>
440.
</div>
441.
</div>
442.
443.
<div
class
=
"form-group"
>
444.
<div
class
=
"col-lg-10 col-lg-offset-2"
>
445.
<input type=
"submit"
value=
"ยืนยัน"
class
=
"btn btn-primary"
>
446.
<input type=
"button"
value=
"ยกเลิก"
class
=
"btn btn-warning"
onclick=
"window.location='index.php'"
>
447.
448.
</div>
449.
</div>
450.
451.
</fieldset>
452.
</form>
453.
</div>
454.
</div>
455.
</div></body></html>
456.
457.
<?php
458.
function
textbox(
$name
){
459.
global
$_POST
;
460.
echo
isset(
$_POST
[
$name
])?htmlspecialchars(
$_POST
[
$name
]):
''
;
461.
}
462.
?>
463.
464.
465.
466.
<?php
467.
include_once
'./include/footer.php'
;
468.
?>