exec_query('farms', ['*']);
while ($farm = $farm_res->fetch_assoc()) {
$jobcards = $jobcards . "
CLOSED";
$job_cards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "farm_id = {$farm['record_id']} AND job_card_status = 'CLOSED'");
if ($job_cards_res->num_rows < 1) {
$jobcards = $jobcards . " : 0
";
} else {
$jobcards = $jobcards . " : " . $job_cards_res->num_rows . '
';
}
$jobcards = $jobcards . "
OPEN";
$job_cards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "farm_id = {$farm['record_id']} AND job_card_status = 'OPEN'");
if ($job_cards_res->num_rows < 1) {
$jobcards = $jobcards . " : 0
";
} else {
$jobcards = $jobcards . " : " . $job_cards_res->num_rows . '
';
}
$jobcards = $jobcards . "
WAITING FOR PARTS";
$job_cards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "farm_id = {$farm['record_id']} AND job_card_status = 'AWAITING PARTS'");
if ($job_cards_res->num_rows < 1) {
$jobcards = $jobcards . " : 0
";
} else {
$jobcards = $jobcards . " : " . $job_cards_res->num_rows . '
';
}
$job_card_types = $db->exec_query('jobcard_types', ['*']);
while ($type = $job_card_types->fetch_assoc()) {
$jobcards = $jobcards . "
{$type['name']}";
$job_cards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "farm_id = {$farm['record_id']} AND job_card_type = '{$type['name']}'");
if ($job_cards_res->num_rows < 1) {
$jobcards = $jobcards . " : 0
";
} else {
$jobcards = $jobcards . " : " . $job_cards_res->num_rows . '
';
}
}
$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 $jobcards;
$message = "
JOB CARD REPORT
FARM : {$farm['farm_name']}
$jobcards
";
$subject = strtoupper("{$farm['farm_name']} DAILY JOB CARD REPORT");
echo $email_class->send_mail($emails, $names, $message, $subject);
} else {
}
$jobcards = '';
$emails = [];
$names = [];
}