001.<?
002.include "sessionuser.php";
003. include "../include/connect.php";
004.$k = $_SESSION["sess_id"];
005. $sql = "update send_detail set open='1' where send_id='$_GET[send_id]' and user_id = $k ";
006. $result = mysql_query($sql);
007.if($result)
008.{
009.
010.?>
013.<head>
014.<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
015.<script language="javascript" src="../include/time.js">
016.</script>
017.<script language="javascript" src="../include/1.js">
018.</script>
019.<title>ระบบหนังสือเวียน</title>
020.<link rel="stylesheet" type="text/css" href="menu_user.css">
021.<style type="text/css">
022.<!--
023.A:link {COLOR: #000000; TEXT-DECORATION: none}
024.A:visited {COLOR: #000000; TEXT-DECORATION: none}
025.A:hover {COLOR: #FF0000; TEXT-DECORATION: underline}
026.
027..style4 {
028. font-family: Arial, Helvetica, sans-serif;
029. font-size: 12px;
030. color: #FFFFFF;
031.}
032..style12 {
033. font-size: 13px
034.}
035..style15 {color: #0000FF}
036..style17 {color: #0000FF; font-size: 14px; }
037..style24 {
038. color: #0000FF;
039. font-size: 14px;
040.}
041.-->
042.</style>
043.</head>
044.<body bgcolor="#999999" leftmargin="0" topmargin="0" >
045. <table width="800" height="737" border="0" cellspacing="0" align="center" CELLPADDING=0 > <!-- start table 1 -->
046.<tr>
047. <td width="786" height="198" background="../images/head_02.jpg"></td>
048. </tr>
049. <tr>
050. <td width="786" height="26" ><? include "menu_user.php"?></td>
051.
052. <tr>
053. <td width="786" height="413" align="center">
054. <table width="800" height="412" border="0" cellpadding="0" cellspacing="0"><!-- start table 2 -->
055. <tr>
056. <th width="18" bgcolor="#DBDBDB" scope="col"> </th>
057. <th width="191" align="center" valign="top" bgcolor="#DBDBDB" scope="col">
058. <table width="175" border="0">
059. <tr align="left">
060. <td height="28" colspan="2"> </td>
061. </tr>
062. <tr align="left">
063. <td height="35" colspan="2"><span class="style24">Main Menu</span><br>
064. <hr></td>
065. </tr>
066. <tr>
067. <td width="34" height="25" align="right"><img src="../images/5_06.GIF" /></td>
068. <td width="156" align="left"><a href="user_book_in.php">หนังสือเวียนเข้า</a></td>
069. </tr>
070. <tr>
071. <td height="24" align="right"><img src="../images/5_06.GIF" /></td>
072. <td align="left"> <a href="user_book_out.php">หนังสือเวียนออก</a></td>
073. </tr>
074. <tr>
075. <td height="26" align="right"><img src="../images/5_06.GIF" /></td>
076. <td align="left"> <a href="user_send.php">ส่งหนังสือเวียน</a></td>
077. </tr>
078. <tr>
079. <td height="26" align="right"><img src="../images/5_06.GIF" /></td>
080. <td align="left"> <a href="user_search_book.php">ค้นหาหนังสือเวียน</a></td>
081. </tr>
082. <tr>
083. <td height="26" align="right"><img src="../images/5_06.GIF" /></td>
084. <td align="left"> <a href="user_check_approve.php">ตรวจสอบสถานะ</a></td>
085. </tr>
086. <tr>
087. <td height="46" colspan="2" align="left" valign="top"><p class="style22">.</p> </td>
088. </tr>
089. <tr>
090. <td height="42" colspan="2" align="left" valign="top"><span class="style24">Hello User</span><br>
091. <hr></td>
092. </tr>
093. <tr>
094. <td height="33" colspan="2" align="center" valign="top">
095. <?
096.
097. include "../include/connect.php";
098.$k = $_SESSION["sess_id"];
099.$sql = "select * from user , position where user.user_id= $k and user.position_id = position.position_id ";
100.mysql_query("set names tis620");
101.$result = mysql_query($sql);
102.$data = mysql_fetch_array($result);
103.
104. echo "<B> $data[user_fname] $data[user_surname] <br><br> $data[position_detail]";
105.?> </td>
106. </tr>
107. <tr>
108. <td height="135" colspan="2" align="center" valign="middle"><img src="../pic/<?=$data[user_pic]?>" width="100" height="100" border="2" bordercolor="#FFFFFF" /></td>
109. </tr>
110. <tr>
111. <td height="25" colspan="2" align="center" valign="middle"> <a href="../logout.php" class="style23 style12"><font color="#FF0000" >ออกจากระบบ </font> </a></td>
112. </tr>
113. <tr>
114. <td height="25" colspan="2" align="center" valign="middle"> </td>
115. </tr>
116.</table> <br > <br ><br > </th>
117. <th width="11" bgcolor="#DBDBDB" scope="col"> </th>
118. <td width="580" align="center" valign="top" bgcolor="#FFFFFF" scope="col">
119. <br >
120. <br > <br >
121. <fieldset style="border:2px double #33CCFF; padding:10; width:400px; background-color:#78BCE0 "><br ><!-- start fieldset 3 -->
122. <?
123. include "../include/connect.php";
124.$a = $_SESSION["sess_id"];
125.$sql="select * from book , send ,send_detail , user , typebook where send_detail.user_id = $a and send_detail.send_id = send.send_id and send.book_id = book.book_id and send.user_id = user.user_id and book.typebook_id = typebook.typebook_id and send.send_id = '$_GET[send_id]' ";
126.$result=mysql_query($sql);
127.$data=mysql_fetch_array($result);
128.if(!$result){ echo mysql_error(); }
129.?>
130.<table width="332" height="406" border="0" cellpadding="0" cellspacing="0">
131. <tr align="left">
132. <td height="41" colspan="3" align="center"><span class="style17">รายละเอียดหนังสือเวียนเข้า<img src="../images/5_01.PNG" width="25" height="25" /></span></td>
133. </tr>
134. <tr>
135. <td width="87" height="20" align="left"><span class="style15"></span></td>
136. <td width="24" align="left"> </td>
137. <td width="213" align="left"> </td>
138. </tr>
139. <tr>
140. <td height="30" align="left"><span class="style15">เรื่อง</span></td>
141. <td align="left">:</td>
142. <td align="left"><?=$data[subject]?></td>
143. </tr>
144. <tr>
145. <td height="30" align="left"><span class="style15">จาก</span></td>
146. <td align="left">:</td>
147. <td align="left"><?= $data[user_fname].' '.$data[user_surname]?></td>
148. </tr>
149. <tr>
150. <td height="30" align="left" ><span class="style15">ส่งเมื่อ</span></td>
151. <td align="left">:</td>
152. <td align="left"><?=$data[send_date].' '.$data[send_time]?></td>
153. </tr>
154. <tr>
155. <td height="30" align="left"><span class="style15">ไฟล์แนบ</span></td>
156. <td align="left">:</td>
157. <td align="left"><?
158. $user_folder = $data[user_id];
159. $a = $data[send_date];
160.
161.$year = substr($a, -5,-1);
162.$month = substr($a, 4,-6);
163.
164.$file_name=$data['book_name'];
165. echo "<a href=\"../pdf/$user_folder/$year/$month/$file_name\" TARGET='_blank'><font color= '#OOFFOO' > $file_name </a>" ;
166. ?> </td>
167. </tr>
168. <?
169. if ($data[vision] == 1){
170. ?>
171. <tr>
172. <td height="30" align="left"><span class="style15">ไฟล์ลับ</span></td>
173. <td align="left">:</td>
174.<?
175.$name_book=$data[book_name];
176.?>
177.<td align="left">
178.
179.<form action="decode.php?name_book=<?=$name_book?>&user_send_id=<?=$data[send_id]?>" method="post" target="_blank">
180.
181. <input type="text" name="key" id="key" style ="width:70px;" >
182. <input name="" type="submit" value=" OK " />
183.</form>
184.
185. </td>
186. </tr>
187. <?
188. }
189. ?>
190.
191.
192. <tr>
193. <td height="67" align="left" valign="top"><span class="style15"><br>
194. รายละเอียด</span></td>
195. <td align="left" valign="top"><br> :</td>
196. <td align="left" valign="top"><br><?=$data[book_detail]?></td>
197. </tr>
198. <tr>
199. <td height="28" align="left" valign="top"> </td>
200. <td align="left" valign="top"> </td>
201. <td align="left" valign="top">
202. <?
203. if($data[approve]==1){
204. ?>
205.<img src="../images/apply_f2.png" /> <a href="approve.php?approve=2&send_id=<?=$data[0]?>">เข้าร่วม</a> <img src="../images/cancel_f2.png" /><a href="approve.php?approve=3&send_id=<?=$data[0]?>">ไม่เข้าร่วม</a>
206.
207. <? }
208. else if ($data[approve]==2)
209. {
210. echo "สถานะการเข้าร่วม : <font color='red' >เข้าร่วมแล้ว </font>";
211. }else if ($data[approve]==3){
212. echo "สถานะการเข้าร่วม :<font color='red' >ไม่เข้าร่วมแล้ว </font>";
213. }else{
214. echo " ";
215. }
216. ?>
217. </td>
218. </tr>
219. <tr>
220. <td height="30" align="left"> </td>
221. <td align="left"> </td>
222. <td align="right"><img src="../images/20_06.PNG" width="100" height="100" /></td>
223. </tr>
224.</table>
225.
226.
227. <!-- END table 3 -->
228.
229.
230. <!-- END table 3 -->
231. <br > <br >
232. </fieldset> <!-- END fieldset 3 -->
233. <br ><br > </td>
234. </tr>
235. </table><!-- END table 2 --> </tr>
236. <tr>
237. <td width="786" height="100" background="../images/head_05.jpg" >
238. <div align="right">
239. <p> </p>
240. <? include "footer.php"?>
241. </div> </td>
242. </tr>
243.</table>
244.<!-- END table 3 -->
245.</body>
246.</html>
247.<?
248.}
249.else
250.{
251.echo "<CENTER>แก้ไขข้อมูลไม่ได้</CENTER>";
252.echo "<script>setTimeout(\"location='user.php'\",500);</script>";
253.}
254.?>
Load balance : Server 01
