include("config.inc.php"); $sql = "SELECT * FROM schedule_shift WHERE Shop_ID = '$shop_i' and Mouth_load = '$mon_id' and Agent_ID = '01032693' order by Date"; $result = mysql_db_query($dbname , $sql); $num = mysql_num_rows($result); if(($mon_id<>"")||($shop_i<>"")){ if($num <>"0"){ ?> </p> <table width="786" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#D8007D"> <tr bgcolor="#FF85CC"> <td width="68" rowspan="2" align="center"><span class="style58 style57 style21"><strong>Employee ID </strong></span></td> <td width="37" rowspan="2" align="center"><span class="style57 style58 style21"><strong>Code</strong></span></td> <td width="71" rowspan="2" align="center"><span class="style57 style58 style21"><strong>Start Date </strong></span></td> <td width="68" rowspan="2" align="center"><span class="style58 style57 style21"><strong>End Date</strong></span></td> <td height="22" colspan="2" align="center"><span class="style57 style58 style21"><strong>Sun</strong></span></td> <td colspan="2" align="center"><span class="style57 style58 style21"><strong>Mon</strong></span></td> <td colspan="2" align="center"><span class="style57 style58 style21"><strong>Tue</strong></span></td> <td colspan="2" align="center"><span class="style57 style58 style21"><strong>Wed</strong></span></td> <td colspan="2" align="center"><span class="style57 style58 style21"><strong>Thu</strong></span></td> <td colspan="2" align="center"><span class="style57 style58 style21"><strong>Fri</strong></span></td> <td colspan="2" align="center"><span class="style57 style58 style21"><strong>Sat</strong></span></td> </tr> <tr bgcolor="#FF85CC"> <td width="36" height="20" align="center"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style58 style57 style21"><strong>Out</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style58 style57 style21"><strong>Out</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style58 style57 style21"><strong>Out</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style58 style57 style21"><strong>Out</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>Out</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style58 style57 style21"><strong>Out</strong></span></td> <td width="36" align="center" valign="middle"><span class="style57 style58 style21"><strong>In</strong></span></td> <td width="36" align="center" valign="middle"><span class="style58 style57 style21"><strong>Out</strong></span></td> </tr> <? while ($row = mysql_fetch_array($result)){ $Agent_ID = $row[Agent_ID]; $Date_Absence1 = $row[Date_Absence1]; $Date_Absence2 = $row[Date_Absence2]; $Detail = $row[Detail]; $Date_Action = $row[Date_Action]; $Status = $row[Status]; $Approve_by = $row[Approve_by]; $Date_approve = $row[Date_approve]; $Time_start = $row[Time_start]; $Time_end = $row[Time_end]; $Date = $row[Date]; $Date_sub = substr($Date,-2); $Day1 = $row[Day]; $F99 = "-"; //} ?> <tr> <td height="24"><div align="center"><? echo $Agent_ID;?></div></td> <td><div align="center">6</div></td> <td><div align="center"><? if(($Day1 == "Sun")||($Date_sub=="1")){echo $Date;}else{echo $Day1;} ?></div></td> <td><div align="center"><? if(($Day1 == "Sat")||($Date_sub==$date_ja)){echo $Date;}else{echo $Day1;} ?></div></td> <td><div align="center"><? if($Day1=="Sun"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Sun"){echo $Time_end;}else{echo $F99;}?></div></td> <td><div align="center"> <? if($Day1=="Mon"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Mon"){echo $Time_end;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Tue"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Tue"){echo $Time_end;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Wed"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Wed"){echo $Time_end;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Thu"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Thu"){echo $Time_end;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Fri"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Fri"){echo $Time_end;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Sat"){echo $Time_start;}else{echo $F99;}?></div></td> <td><div align="center"><? if($Day1=="Sat"){echo $Time_end;}else{echo $F99;}?></div></td> </tr> <? } ?> </table> <p> <? }else{ echo "<table width=\"700\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">"; echo "<tr>"; echo "<td align=\"center\" valign=\"middle\"><span class = \"denies\">ยังไม่มีการจัดตารางการทำงานในเดือนนี้</span></td>"; echo "</tr>"; echo "</table>"; } }else{ echo "<table width=\"700\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">"; echo "<tr>"; echo "<td align=\"center\" valign=\"middle\"><span class = \"style23\">กรุณาเลือก shop และ Month ที่ต้องการค่ะ</span></td>"; echo "</tr>"; echo "</table>"; }
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง