01.$Nowdate="Y-m-d";
02.$Nowdatetext=date("d/m/Y");
03.
04. $date_start1="$Nowdate 07:30";
05. $date_end1=date("Y-m-d H:i",strtotime($date_start1."+12 hour"));
06. $date_end1."<br>";
07. $date_start2="$Nowdate 19:30";
08. $date_end2=date("Y-m-d H:i",strtotime($date_start2."+12 hour"));
09. $date_end2."<br>";
10.
11.
12.
13.
14. if (time()>=strtotime($date_start1) AND time()<=strtotime($date_end1)) {
15. $W="production_time >= '$date_start1' AND production_time < '$date_end1' ";
16. $Showtext="ยังไม่ได้กรอกข้อมูลเที่ยว วันที่ $Nowdatetext 07:30-19:00 น.";
17. }
18. if (time()>=strtotime($date_start2) AND time()<=strtotime($date_end2)) {
19. $W="production_time >= '$date_start2' AND production_time < '$date_end2' ";
20. $Showtext="ยังไม่ได้กรอกข้อมูลเที่ยว วันที่ $Nowdatetext 19:30-07:00 น.";
21. }
22.
23.
24.
25.
26.
27.
28. $strSQLsum = "select production.production_time,production.production_date,sum(total40trip)as sum40trip,sum(total12trip)as sum12trip ,sum(total12trip1)as sum12trip1 ,sum(total16trip)as sum16trip,sum(total16trip1)as sum16trip1,sum(total25trip)as sum25trip,sum(total30trip)as sum30trip ,count(production_time )as numtrip,sum(toptrip)as sumtoptrip from production
29. where $W";
