01.
<?php
02.
$selReq
=
"select file.*,req.* from dbo_request_file file left join dbo_request req on file.RequestID = req.RequestID order by file.FileID desc limit 10;"
;
03.
$qryReq
= mysql_query(
$selReq
)
or
die
(mysql_error());
04.
while
(
$rstReq
= mysql_fetch_assoc(
$qryReq
))
05.
{
06.
if
(
$rstReq
[
"Officer"
]==
''
)
07.
{
08.
echo
'<tr>'
;
09.
}
10.
else
11.
{
12.
echo
'<tr class="success">'
;
13.
}
14.
?>
15.
<td style=
" vertical-align: middle;"
><div align=
"center"
><?=
$rstReq
[
"FileID"
];?></div></td>
16.
<td style=
" vertical-align: middle;"
>
17.
<a data-toggle=
"modal"
href=
"#detail_req"
><?=
$rstReq
[
"ReqName"
];?></a>
18.
<div
class
=
"modal fade"
id=
"detail_req"
>
19.
<div
class
=
"modal-dialog"
>
20.
<div
class
=
"modal-content"
>
21.
<div
class
=
"modal-header"
>
22.
<button type=
"button"
class
=
"close"
data-dismiss=
"modal"
aria-hidden=
"true"
>x</button>
23.
<h4
class
=
"modal-title"
><?=
$rstReq
[
"ReqName"
];?></h4>
24.
</div>
25.
<div
class
=
"modal-body"
>
26.
<div
class
=
"row"
>
27.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>รหัสนักศึกษา : </div>
28.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"ID"
];?></div>
29.
</div>
30.
<div
class
=
"row"
>
31.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>ชื่อ-สกุล : </div>
32.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"Name"
];?></div>
33.
</div>
34.
<div
class
=
"row"
>
35.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>ห้องเรียน : </div>
36.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"Classname"
];?></div>
37.
</div>
38.
<div
class
=
"row"
>
39.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>สาขาวิชา : </div>
40.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"ProgramName"
];?></div>
41.
</div>
42.
<div
class
=
"row"
>
43.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>คณะ : </div>
44.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"FacultyName"
];?></div>
45.
</div>
46.
<div
class
=
"row"
>
47.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>ที่อยู่ : </div>
48.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"Address"
];?></div>
49.
</div>
50.
<div
class
=
"row"
>
51.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>เบอร์โทรศัพท์ : </div>
52.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"PhoneNumber"
];?></div>
53.
</div>
54.
<div
class
=
"row"
>
55.
<?php
56.
echo
$rstReq
[
"RequestID"
];
57.
if
(
$rstReq
[
"RequestID"
]==
'NW402'
){
58.
?>
59.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
align=
"right"
>มีความประสงค์ : </div>
60.
<div
class
=
"col-lg-6 col-md-6 col-sm-6 col-xs-6"
><?=
$rstReq
[
"Wish_detail"
];?> ภาคการศึกษาที่ <?=
$rstReq
[
"Wish_term1"
];?></div>
61.
<?php
62.
}
63.
?>
64.
</div>
65.
</div>
66.
<div
class
=
"modal-footer"
>
67.
68.
</div>
69.
</div>
70.
</div>
71.
</div>
72.
</td>
73.
<td style=
" vertical-align: middle;"
><?=
$rstReq
[
"Name"
];?></td>
74.
<td style=
" vertical-align: middle;"
><div align=
"center"
><?=
date
(
"d/m/Y H:i:s"
,
strtotime
(
$rstReq
[
"Send_Date"
]));?></div></td>
75.
<td style=
" vertical-align: middle;"
>
76.
<div align=
"center"
>
77.
<?php
78.
if
(
$rstReq
[
"Officer"
]==
''
)
79.
{
80.
echo
'<button type="button" class="btn btn-danger">รับเรื่อง</button>'
;
81.
}
82.
else
83.
{
84.
echo
'<button type="button" class="btn btn-success">รับแล้ว</button>'
;
85.
}
86.
?>
87.
</div>
88.
</td>
89.
</tr>
90.
<?php
91.
}
92.
?>
93.
</tbody>
94.
</table>