001.<?php
002.session_start();
003.$user = $_SESSION["valid_user"];
004.?>
005.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
006.<html>
007. <head>
008. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
009. <title></title>
010. <style type="text/css">
011.<!--
012..style1 {color: #FF0000}
013.-->
014. </style>
015.</head>
016. <body>
017. <table width="1022" border="0" align="center" cellpadding="0" cellspacing="0">
018. <tr>
019. <td width="169"><img src="icon/Logo.jpg" width="115" height="69"></td>
020. <td width="682"><p align="center"><strong>มูลนิธิบ้านสงเคราะห์สัตว์พิการ</strong><strong> </strong><br>
021. (ในความอุปถัมภ์ของหลวงตามหาบัว ญาณสัมปันโน) <br>
022. 15/1 หมู่ 1 ซอยพระมหาการุณย์ ถ.ติวานนท์ ต.บ้านใหม่ อ.ปากเกร็ด จ.นนทบุรี 11120 </p>
023. <p align="center">โทร. 584-4896, 961-5625, 961-3799 แฟกซ์ : 961-5305</p></td>
024. <td width="171" valign="bottom"><p>วันที่พิมพ์ : <?php echo date('d/m/Y'); ?><br>
025. เวลา : <?php echo date('H:i'); ?></p>
026. </td>
027. </tr>
028. </table>
029. <table width="1022" border="0" align="center" cellpadding="0" cellspacing="0">
030. <tr>
031. <td width="1022" height="49"> </td>
032. </tr>
033. <tr>
034. <td height="4"><?php
035.include "connect.inc.php";
036.$id = $_GET["id"];
037.
038.if($id!=""){
039.echo <<<HTMLBLOCK
040. <table align="center" width="100%" border="0">
041. <tr><td class="style4" height="30">
042. <b>ข้อมูลสุนัข</b>
043. </td></tr>
044. </table>
045. <table width="100%" align="center" border="0" class="style6">
046. <tr><td align="center">
047.<table width="100%" border="0" class="style3">
048.HTMLBLOCK;
049.
050. $sql = "SELECT * FROM dog where dog_id='$id'";
051. $result = mysql_db_query($dbname, $sql);
052. $row = mysql_fetch_array($result);
053.
054. $sql1 = "SELECT * FROM species where spe_id='$row[spe_id]'";
055. $result1 = mysql_db_query($dbname, $sql1);
056. $row1 = mysql_fetch_array($result1);
057.
058. $dog_id = "0000000000".$row[dog_id];
059. $dog_id =substr($dog_id,strlen($dog_id)-3);
060.if($row[dog_img]!=""){
061. echo "<tr><td colspan='4' align='center'><img src='dog/$row[dog_img]' width='200' alt='น้อง$row[dog_name]'></td></tr>";
062.}
063.echo <<<HTMLBLOCK
064. <tr><td align="right" width="25%"><br>รหัส : </td><td width="25%"><br>Dog$dog_id</td><td align="right" width="20%"><br>ชื่อสุนัข : </td><td width="30%"><br>$row[dog_name]</td></tr>
065. <tr><td align="right">ชื่อสายพันธุ์ : </td><td width="20%">$row1[spe_name]</td>
066.HTMLBLOCK;
067.if($row[dog_sex]=="ผู้"){
068.echo <<<HTMLBLOCK
069. <td align="right">เพศ : </td><td>ตัวผู้</td>
070.HTMLBLOCK;
071.}elseif($row[dog_sex]=="เมีย"){
072.echo <<<HTMLBLOCK
073. <td align="right">เพศ : </td><td>ตัวเมีย</td>
074.HTMLBLOCK;
075.}
076.
077.echo <<<HTMLBLOCK
078. </tr>
079. <tr><td align="right">อายุ : </td><td>$row[dog_age]</td><td align="right">วันที่รับเข้ามูลนิธิ : </td><td>$row[dog_date]</td></tr>
080. <tr><td align="right">ความสมบูรณ์ของร่างกาย : </td><td colspan="3">$row[dog_integrity]</td></tr>
081. <tr><td align="right">อุปนิสัย : </td><td colspan="3">$row[dog_habit]</td></tr>
082. <tr><td align="right">หมายเหตุ : </td><td colspan="3">$row[dog_note]</td></tr>
083.</table>
084. </td></tr>
085. </table>
086.HTMLBLOCK;
087.
088. $sql11 = "SELECT * FROM take_care WHERE tc_status='2' and dog_id='$id'";
089. $result11 = mysql_db_query($dbname, $sql11);
090. $num11 = mysql_num_rows($result11);
091. $row11 = mysql_fetch_array($result11);
092.if($num11>0){
093. $sql12 = "SELECT * FROM member WHERE mem_username='$row11[mem_username]'";
094. $result12 = mysql_db_query($dbname, $sql12);
095. $num12 = mysql_num_rows($result12);
096. $row12 = mysql_fetch_array($result12);
097.
098.echo <<<HTMLBLOCK
099. <br><table align="center" width="100%" border="0">
100. <tr><td class="style4" height="30">
101. <b>การอุปการะ</b>
102. </td></tr>
103. </table>
104.
105. <table width="70%" border="0" class="style3" align="center">
106. <tr><td class='style3' width='50%'>คุณ$row12[mem_name] $row12[mem_lastname]</td><td>ทำการอุปการะเมื่อวันที่ $row11[tc_dates] </td></tr>
107. </table>
108.HTMLBLOCK;
109.}
110.
111.
112.
113.
114.
115. $sql2 = "SELECT * FROM vaccinations where dog_id='$row[dog_id]'";
116. $result2 = mysql_db_query($dbname, $sql2);
117. $num2 = mysql_num_rows($result2);
118. $row2 = mysql_fetch_array($result2);
119.
120.if($num2>0){
121.echo <<<HTMLBLOCK
122. <br><table align="center" width="100%" border="0">
123. <tr><td class="style4" height="30">
124. <b>การฉีดวัคซีน</b>
125. </td></tr>
126. </table>
127.
128. <table width="100%" border="0" class="style3">
129.HTMLBLOCK;
130.
131. $sql3 = "SELECT * FROM vaccinations where dog_id='$row[dog_id]' order by vt_id desc";
132. $result3 = mysql_db_query($dbname, $sql3);
133. $a="1";
134. while($row3 = mysql_fetch_array($result3)){
135.
136. $sql4 = "SELECT * FROM vaccine where vac_id='$row3[vac_id]'";
137. $result4 = mysql_db_query($dbname, $sql4);
138. $row4 = mysql_fetch_array($result4);
139.
140. echo "<tr><td align='right' width='25%'>$a.วัคซีน : </td><td>$row4[vac_name_eng] - $row4[vac_name_th]</td></tr>";
141. echo "<tr><td align='right' width='25%'> วันที่ : </td><td>$row3[vt_date]</td></tr>";
142. $a++;
143. }
144.
145.echo <<<HTMLBLOCK
146. </table>
147.HTMLBLOCK;
148.
149.}
150.
151. $sql5 = "SELECT * FROM health_checks where dog_id='$row[dog_id]'";
152. $result5 = mysql_db_query($dbname, $sql5);
153. $num5 = mysql_num_rows($result5);
154. $row5 = mysql_fetch_array($result5);
155.if($num5>0){
156.echo <<<HTMLBLOCK
157. <br><table align="center" width="100%" border="0">
158. <tr><td class="style4" height="30">
159. <b>การตรวจสุขภาพ</b>
160. </td></tr>
161. </table>
162.
163. <table width="100%" border="0" class="style3">
164.HTMLBLOCK;
165.
166. $sql6 = "SELECT * FROM health_checks where dog_id='$row[dog_id]' order by hc_id desc";
167. $result6 = mysql_db_query($dbname, $sql6);
168. $a="1";
169. while($row6 = mysql_fetch_array($result6)){
170.
171. $sql7 = "SELECT * FROM checks where che_id='$row6[che_id]'";
172. $result7 = mysql_db_query($dbname, $sql7);
173. $row7 = mysql_fetch_array($result7);
174.
175. echo "<tr><td align='right' width='25%'>$a.ตรวจสุขภาพ : </td><td>$row7[che_name_eng] - $row7[che_name_th]</td></tr>";
176. echo "<tr><td align='right' width='25%'> วันที่ : </td><td>$row6[hc_date]</td></tr>";
177. $a++;
178. }
179.
180.echo <<<HTMLBLOCK
181. </table>
182.HTMLBLOCK;
183.}
184.}else{
185.
186.
187.
188.if($_GET[text1]!=""){
189. $text1="ชื่อสุนัข $_GET[text1]";
190.}
191.if($_GET[text2]!=""){
192. $text2="สายพันธุ์$_GET[text2]";
193.}
194.if($_GET[text3]!=""){
195. if($_GET[text3]=="2"){
196. $text3="ได้รับการอุปการะ";
197. }else{
198. $text3="ยังไม่ถูกอุปการะ";
199. }
200.}
201.echo <<<HTMLBLOCK
202. <table align="center" width="100%" border="0" cellpadding="0" cellspacing="0">
203. <tr><td class="style4" height="30">
204. <b>ข้อมูลสุนัข</b>
205. </td></tr>
206. </table>
207.HTMLBLOCK;
208.echo <<<HTMLBLOCK
209. <br><table align="center" width="100%" border="0" cellpadding="0" cellspacing="0">
210. <tr><td height="30" width="70%" align="left">
211. $text1 $text2 $text3
212. </td></tr>
213. </table>
214.HTMLBLOCK;
215.if($_GET[text1]!="" and $_GET[text2]=="" and $_GET[text3]==""){
216. $sql = "SELECT * FROM dog where dog_name like '$_GET[text1]%%' order by dog_id desc";
217.}elseif($_GET[text1]!="" and $_GET[text2]!="" and $_GET[text3]==""){
218. $sql = "SELECT * FROM dog where dog_name like '$_GET[text1]%%' and spe_id='$_GET[text2]%%' order by dog_id desc";
219.}elseif($_GET[text1]!="" and $_GET[text2]=="" and $_GET[text3]!=""){
220. if($_GET[text3]=="2"){
221. $sql = "SELECT a.*,b.* FROM dog a,take_care b where a.dog_name like '$_GET[text1]%%' and b.tc_status='2' and a.dog_id=b.dog_id order by a.dog_id desc";
222. }else{
223. $sql = "SELECT * FROM dog where dog_name like '$_GET[text1]%%' order by dog_id desc";
224. }
225.}elseif($_GET[text1]!="" and $_GET[text2]!="" and $_GET[text3]!=""){
226. if($_GET[text3]=="2"){
227. $sql = "SELECT a.*,b.* FROM dog a,take_care b where a.dog_name like '$_GET[text1]%%' and a.spe_id='$_GET[text2]%%' and b.tc_status='2' and a.dog_id=b.dog_id order by a.dog_id desc";
228. }else{
229. $sql = "SELECT * FROM dog where dog_name like '$_GET[text1]%%' and spe_id='$_GET[text2]%%' order by dog_id desc";
230. }
231.}elseif($_GET[text1]=="" and $_GET[text2]!="" and $_GET[text3]==""){
232. $sql = "SELECT * FROM dog where spe_id='$_GET[text2]%%' order by dog_id desc";
233.}elseif($_GET[text1]=="" and $_GET[text2]!="" and $_GET[text3]!=""){
234. if($_GET[text3]=="2"){
235. $sql = "SELECT a.*,b.* FROM dog a,take_care b where a.spe_id='$_GET[text2]%%' and b.tc_status='2' and a.dog_id=b.dog_id order by a.dog_id desc";
236. }else{
237. $sql = "SELECT * FROM dog where spe_id='$_GET[text2]%%' order by dog_id desc";
238. }
239.}elseif($_GET[text1]=="" and $_GET[text2]=="" and $_GET[text3]!=""){
240. if($_GET[text3]=="2"){
241. $sql = "SELECT a.*,b.* FROM dog a,take_care b where b.tc_status='2' and a.dog_id=b.dog_id order by a.dog_id desc";
242. }else{
243. $sql = "SELECT * FROM dog order by dog_id desc";
244. }
245.}else{
246. $sql = "SELECT * FROM dog order by dog_id desc";
247.}
248. $result = mysql_db_query($dbname, $sql);
249. $num = mysql_num_rows($result);
250. $result11 = mysql_db_query($dbname, $sql11) die(mysql_error());
251. echo <<<HTMLBLOCK
252.
253. <table width="100%" align="center" border="0" class="style6">
254. <tr><td>
255.HTMLBLOCK;
256.
257. echo <<<HTMLBLOCK
258. </td></tr>
259. <tr><td align="center" valign="top" height="400">
260.
261.<table width="95%" border="1" class="boder2" cellpadding="0" cellspacing="0">
262. <tr align="center" height="30" class="style2">
263. <td width='15%' align="center" bgcolor="#CCCCCC"><b>รหัส</b></td>
264. <td width='30%' align="center" bgcolor="#CCCCCC"><b>ชื่อสุนัข</b></td>
265. <td width='40%' align="center" bgcolor="#CCCCCC"><b>สายพันธุ์</b></td>
266. </tr>
267.HTMLBLOCK;
268.
269.
270.while($row = mysql_fetch_array($result)){
271.
272.
273.if($_GET[text3]!="" and $_GET[text3]!="2"){
274.
275.
276. $sql2 = "SELECT * FROM take_care WHERE tc_status='2' and dog_id='$row[dog_id]'";
277. $result2 = mysql_db_query($dbname, $sql2);
278. $num2 = mysql_num_rows($result2);
279. $row2 = mysql_fetch_array($result2);
280. if($num2==0){
281. $dog_id = "0000000000".$row[dog_id];
282. $dog_id =substr($dog_id,strlen($dog_id)-3);
283. echo "<tr class='style3'>";
284. echo "<td align='center'>Dog$dog_id</td>";
285. echo "<td> $row[dog_name]</td>";
286.
287. $sql1 = "SELECT * FROM species WHERE spe_id='$row[spe_id]'";
288. $result1 = mysql_db_query($dbname, $sql1);
289. $row1 = mysql_fetch_array($result1);
290. echo "<td> $row1[spe_name]</td>";
291. echo "</tr>";
292. }
293.}else{
294.
295. $dog_id = "0000000000".$row[dog_id];
296. $dog_id =substr($dog_id,strlen($dog_id)-3);
297. echo "<tr class='style3'>";
298. echo "<td align='center'>Dog$dog_id</td>";
299. echo "<td> $row[dog_name]</td>";
300.
301. $sql1 = "SELECT * FROM species WHERE spe_id='$row[spe_id]'";
302. $result1 = mysql_db_query($dbname, $sql1);
303. $row1 = mysql_fetch_array($result1);
304. echo "<td> $row1[spe_name]</td>";
305. echo "</tr>";
306.
307.}
308.}
309. echo <<<HTMLBLOCK
310.</table>
311.HTMLBLOCK;
312.
313.}
314.
315.?>
316. <table width="929" border="0" align="center" cellpadding="0" cellspacing="0">
317. <tr>
318. <td><p> </p>
319. <p><span class="style1">หมายเหตุ</span> - ข้อมูลจากจำนวนสุนัขทั้งหมด<?php echo $num; ?> ตัว </p></td>
320. </tr>
321. </table>
322. <p> </p>
323. <p> </p>
324. <p>
325. <script language="javascript">
326.function printpr()
327.{
328.var OLECMDID = 7;
329.
330.
331.
332.
333.
334.
335.var PROMPT = 1;
336.var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH=0 HEIGHT=0 CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
337.document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
338.WebBrowser1.ExecWB(OLECMDID, PROMPT);
339.WebBrowser1.outerHTML = "";
340.}
341. </script>
342. </p>
343.
344.</body>
345.</html>
