01.
if
(
$_POST
[
"Submit"
] ==
"อนุมัติ"
)
02.
{
03.
$strSQL
=
"UPDATE tb_request SET "
;
04.
$strSQL
.=
"Headcf_date = '"
.
$date
.
"',headcf_id = '"
.
$headcf_id
.
"' WHERE Req_id = '"
.
$Req_id
.
"'"
;
05.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
06.
07.
$strSQL
=
"UPDATE tb_rqdetail SET status_id = '"
.
$statusid1
.
"' WHERE Rqdetail_id = '"
.
$rq_id
.
"'"
;
08.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
09.
10.
echo
"บันทึกข้อมูลเรียบร้อย"
;
11.
echo
"<script language=\"javascript\">alert(\"บันทึกข้อมูลเรียบร้อย\");window.location=\"shapprove.php?Req_id=$_GET[Req_id]\";</script>"
;
12.
}
else
if
(
$_POST
[
"Submit"
] ==
"ไม่อนุมัติ"
)
13.
{
14.
$strSQL
=
"UPDATE tb_request SET "
;
15.
$strSQL
.=
"headcf_id = '"
.
$headcf_id
.
"' WHERE Req_id = '"
.
$Req_id
.
"'"
;
16.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
17.
18.
$strSQL
=
"UPDATE tb_rqdetail SET status_id = '"
.
$statusid2
.
"' WHERE Rqdetail_id = '"
.
$rq_id
.
"'"
;
19.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
20.
21.
$strSQL
=
"UPDATE tb_equipment SET "
;
22.
$strSQL
.=
"Eq_total = '$Eq_total' + '$num_req' "
;
23.
$strSQL
.=
"WHERE Eq_id = '"
.
$Eq_id
.
"' "
;
24.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query["
.
$strSQL
.
"]"
);
25.
26.
echo
"บันทึกข้อมูลเรียบร้อย"
;
27.
echo
"<script language=\"javascript\">alert(\"บันทึกข้อมูลเรียบร้อย\"
);
28.
window.location=\
"shapprove.php?Req_id=$_GET[Req_id]\";</script>"
;
29.
}
else
if
(
$_POST
[
"Submit"
] ==
'ยืนยัน'
)
30.
{
31.
$strSQL
=
"UPDATE tb_request SET "
;
32.
$strSQL
.=
"headcf_id = '"
.
$headcf_id
.
"', status_id = '"
.
$statusid1
.
"' WHERE Req_id = '"
.
$Req_id
.
"'"
;
33.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
34.
35.
$strSQL1
=
"UPDATE tb_rqdetail SET note_disapp = '"
.
$note
.
"' WHERE Rqdetail_id = '"
.
$rq_id
.
"'"
;
36.
$objQuery1
= mysql_query(
$strSQL1
)
or
die
(
"Error Query ["
.
$strSQL1
.
"]"
);
37.
38.
echo
"บันทึกข้อมูลเรียบร้อย"
;
39.
echo
"<script language=\"javascript\">alert(\"บันทึกข้อมูลเรียบร้อย\"
);
40.
window.location=\
"shapprove.php?Req_id=$_GET[Req_id]\";</script>"
;
41.
}