02.<title>aiservice result</title>
03.<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
04.<link rel="stylesheet" type="text/css" href="../config/sgk.css" />
05.</head><strong>Code (PHP)</strong>
06.
07.<BODY>
08.
09.<?
10.require("../config/config.inc.php");
11.$now=date("d-m-Y");
12.$snow=strtotime("$now");
13.
14.?>
15.
16.<table width="1000" border="0" align="center" cellpadding="1" cellspacing="1" bordercolordark="#FFFFFF">
17. <tr>
18. <td colspan="14" bgcolor="#FFCCCC" align="center"><b>รายการการผสมเทียมและ workstep <a href="../login/tech_menu.php">หน้าแรก</a></b></td>
19. </tr>
20. <tr bgcolor="#FFFFCC">
21. <td width="50" align="center">ลำดับที่</td>
22. <td width="150" align="center">หมายเลขโค</td>
23. <td width="150" align="center">ทะเบียนฟาร์ม</td>
24. <td width="150" align="center">ชื่อเจ้าของ</td>
25. <td width="100" align="center">วันที่คลอด</td>
26. <td width="50" align="center">จำนวนวันหลังคลอด</td>
27.
28.
29. <td width="100" align="center">แก้ไข</td>
30. </tr>
31.<?
32.
33.
34.
35.$sql = "SELECT * FROM aiservice where aiservice.Tech_Code='$tech_code' and aiservice.calve_date !='00-00-0000' ORDER BY cow.cowid ASC ";
36.$result = mysql_query($sql);
37.$calve_date2="$w[calve_date]";
38.$scalve_date2=strtotime("$calve_date2");
39.$interval2=$snow-$scalve_date2;
40.$dinterval=$interval2/(24*60*60);
41.$A=Round($dinterval,0);
42.
43.
44.$sql = "SELECT * FROM aiservice INNER JOIN cow ON aiservice.cowid=cow.cowid INNER JOIN farm ON aiservice.farmid=farm.Farm_ID where aiservice.Tech_Code='$tech_code' and aiservice.calve_date !='00-00-0000' and $A >'30' ORDER BY cow.cowid ASC ";
45.$result = mysql_query($sql);
46.$totals = mysql_num_rows($result);
47.while ($w = mysql_fetch_array($result)) {
48.
49.$id="$w[id]";
50.$tech_pt9="$w[tech_pt9]";
51.$cowid="$w[cowid]";
52.$farmid="$w[farmid]";
53.$Farmer="$w[Farmer]";
54.$calve_date="$w[calve_date]";
55.$scalve_date=strtotime("$calve_date");
56.$interval2=$snow-$scalve_date;
57.$dinterval2=$interval2/(24*60*60);
58.$AA=Round($dinterval2,0);
59.
60.
61.
62.
63.
64.
65.
66.$LoopRow++;
67.$bgcolor=(($LoopRow%2)==0)?"#F1F1F1":"#FFFFFF";
68.?>
69. <tr bgcolor="<?echo $bgcolor;?>">
70. <td align="center"><?=$id;?></td>
71. <td><?=$cowid;?></td>
72. <td><?=$farmid;?></td>
73. <td><?=$Farmer;?></td>
74.
75. <td><?=$calve_date;?></td>
76. <td><?=$AA;?></td>
77. <td><?=$A;?></td>
78.
79.
80. <td align="center"><a href ="aiservice_edit.php?id=<?echo"$id"; ?>">แก้ไข</a></td>
81. </tr>
82.<?
83.
84.}
85.?>
86. <tr bgcolor="#FFFFCC" >
87. <td colspan="14" align="right">มีทั้งหมด <?=$totals;?> รายการ :
88. </td>
89. </tr>
90.</table>
