15 lines
654 B
PHP
15 lines
654 B
PHP
<?php
|
|
|
|
$yesterday = date("Y-m-d",time() - 60 * 60 * 24);
|
|
$yesterday = "2017-10-25";
|
|
$query = "SELECT p.school_num,school_name,first_name,last_name,user_num,p.added_date,count(hloh.record_num) AS order_count " .
|
|
"FROM schools,people AS p LEFT JOIN hotlunch_order_header AS hloh ON (hloh.school_num = p.school_num AND hloh.ordered_by_num = p.record_num) " .
|
|
"WHERE p.school_num = schools.record_num " .
|
|
"AND schools.send_no_order_reminders = 'Y' " .
|
|
"AND p.added_date = '$yesterday' " .
|
|
"AND p.people_type = 'Student' " .
|
|
"GROUP BY 1,2,3,4,5 " .
|
|
"HAVING order_count = 0";
|
|
echo("$query\n");
|
|
?>
|