NO RECORD OF INSPECITONS
";
$total_inspections = 0;
$total_inspections_missed = 0;
$yesterday_inspection_records_header = "
INSPECTIONS DONE THIS MORNING
";
$no_inspections_yesterday_header = "
INSPECTIONS NOT DONE THIS MORNING
";
$no_inspections = '';
$today = date('Y-m-d');
$yesterday = date('Y-m-d');
$farm_res = $db->exec_query('farms', ['*']);
while ($farm = $farm_res->fetch_assoc()) {
$assets_res = $db->exec_query('assets', ['*'], '', '', '', '', "farm_id = {$farm['record_id']}");
while ($asset = $assets_res->fetch_assoc()) {
echo '
' . $asset['asset_id'] . '
';
$inspections_res = $db->exec_query('inspections', ['*'], '', '', '', '', "asset_record_id = {$asset['record_id']} AND date_time BETWEEN '$yesterday 00:00' AND '$today 23:59'");
if ($inspections_res->num_rows >= 1) {
$row = $inspections_res->fetch_assoc();
$inspection_done = $inspection_done . "{$asset['fleet_no']} {$asset['description']} DONE AT {$row['date_time']}
";
echo 'INSPECTIONS DONE';
$total_inspections++;
} else {
$inspection_missed = $inspection_missed . "{$asset['fleet_no']} {$asset['description']}
";
echo 'INSPECTIONS NOT DONE';
$total_inspections_missed++;
}
}
$email_list = $db->exec_query('emails', ['*'], '', '', '', '', "(farm_id = {$farm['record_id']} OR farm_id = 0) AND (event_types = 'ALL' OR event_types = 'REPORTS')");
if ($email_list->num_rows > 0) {
while ($email = $email_list->fetch_assoc()) {
$emails[] = $email['email'];
$names[] = $email['name'];
}
echo $message = "
INSPECTIONS REPORT
FARM : {$farm['farm_name']}
TOTAL DONE: $total_inspections
TOTAL NOT DONE:$total_inspections_missed
$yesterday_inspection_records_header
$inspection_done
$no_inspections_yesterday_header
$inspection_missed
";
$subject = strtoupper("{$farm['farm_name']} DAILY INSPECTIONS");
echo $email_class->send_mail($emails, $names, $message, $subject);
} else {
}
$inspection_done = '';
$inspection_missed = '';
$total_inspections = 0;
$total_inspections_missed = 0;
$emails = [];
$names = [];
}