001.<?php
002.$strTable= '<table border="1" id="box-table-a" width="40%" align="center">
003.<tr>
004.<th><strong><center>เวลา/สนาม</center></strong></th>';
005.foreach ($arrField as $f_name)
006.{
007. $strTable.='<th><center>'.$f_name.'</center></th>';
008.}
009.$strTable.='</tr>';
010.
011.
012.foreach ($arrTime as $time){
013. $strTable.='<tr><td><center>'.$time.'</center></td>';
014.
015. $sql = "select * from booking left join field on booking.field_id=field.field_id where field_name ='{$f_name[field_id]}' and booking_user='2018-07-26' and booking_status order by booking_time ASC";
016. $res = mysql_query($sql) or die (mysql_error());
017. $num = mysql_num_rows($res);
018. $run=0;
019.
020.
021. foreach ($arrField as $f_name){
022. $time_now = date("H:i:s");
023. $date_now = date ("d-m-y");
024.
025. if ($num > $run && $time ['booking_time'] == mysql_result($res,$run,'booking_time')
026. && $date >= $date_now &&
027.
028.
029. 'status==0')
030. {
031. if ($date == $date_now && $time['booking_time'] < $time_now && $time['booking_time'] )
032. {
033.
034. $strTable.='<td bgcolor="#00FFCC"><font color="red"><b>Playing</b></font></td>';
035. $run++;
036. }
037.
038. else
039. {
040. $strTable.='<td><font color="orange"><center><b>จองแล้ว</b></center></font></td>';
041. $run++;
042. }
043. }
044.
045. if ($num > $run && $time ['booking_time'] == mysql_result($res,$run,'booking_time')
046. && $date >= $date_now )
047. {
048. if ($date == $date_now && $time['booking_time'] < $time_now && $time['booking_time'] )
049. {
050. if($book_status=2){
051. $strTable.='<td><font color="orange"><center><b>จอง รอชำระเงิน</b></center></font></td>';
052. $run++;
053. }
054. }
055.
056. else
057. {
058. $strTable.='<td><font color="orange"><center><b>จองแล้ว</b></center></font></td>';
059. $run++;
060. }
061. }
062.
063.
064. else
065. {
066. if($_SESSION['user_id'] == "")
067. {
068. $strTable.='<td bgcolor="#00FF33"><center>ว่าง</center></td>';
069. }
070. else
071. {
072. $timestamp1 = strtotime($date_now);
073. $timestamp2 = strtotime('+7 days',$timestamp1);
074. $date7 = date('Y-m-d', $timestamp2);
075.
076. if ($date < $date_now || $date > $date7 )
077. {
078. $strTable.='<td bgcolor="#00FF33><font color="#C0C0C0"><center>ว่าง<input name="chk" type="checkbox" disabled="disables" value=""></center></font></td>' ;
079. }
080.
081. else if ($time['time_name'] < $time_now && $date == $date_now )
082. {
083. $strTable.='<td bgcolor="#00FF33><font color="#C0C0C0"><center>
084. ว่าง
085. <input name="chk" type="checkbox" disabled="disables"></center></font></td>';
086. }
087. else
088. {
089.
090. $strTable.='<td>ว่าง<input type ="checkbox" name ="chk[]" id="chk" value = "" </td>';
091. }
092. }
093. }
094. }
095.}
096. $strTable.='</tr>';
097.
098.echo $strTable,'</table>';
099.
100.
101.?>
