";
$trigger = 1;
$answers = $answers . $_POST['q_a_' . $index] . '||';
} else if ($_POST["w_" . $index] == 'T' && strlen($_POST['q_a_' . $index]) > 1) {
$questions = $questions . $_POST['question_' . $index] . "(WARNING)" . '||';
$triggers = $triggers . "{$_POST['question_' .$index]} {$_POST['q_a_' .$index]}
";
$trigger = 1;
$answers = $answers . $_POST['q_a_' . $index] . '||';
} else {
$questions = $questions . $_POST['question_' . $index] . '||';
$triggers = $triggers . "{$_POST['question_' .$index]} {$_POST['q_a_' .$index]}
";
$answers = $answers . $_POST['q_a_' . $index] . '||';
}
} else {
$questions = $questions . $_POST['question_' . $index] . '||';
$triggers = $triggers . "{$_POST['question_' .$index]} {$_POST['q_a_' .$index]}
";
$answers = $answers . $_POST['q_a_' . $index] . '||';
}
}
$index++;
}
if ($trigger == 1) {
$db->insert("INSERT INTO warning_events (`event_type`,`event_message`,`sent`,`asset_id`) VALUES ('WARNING','PLEASE NOTE!
PRE INSPECTION WARNING(s) TRIGGERED :
ASSET : {$_POST['asset_id']}
DATE: $date
USER: {$_SESSION['username']}
LIST DETAILS:
$triggers
Notes:
{$_POST['notes']}',0,{$_POST['asset_record_id']})");
echo "";
} else {
echo "";
}
$asset_record_id = $_POST['asset_record_id'];
$notes = $_POST['notes'];
$asset_res = $db->exec_query('assets',['*'],'','','','',"record_id = $asset_record_id");
$asset_info = $asset_res->fetch_assoc();
$db->Insert("INSERT INTO `inspections`(`inpection_id`, `questions`, `answers`, `asset_record_id`, `user_id`, `date_time`, `notes`,`farm_id`) VALUES ('{$_POST['inspection_id']}','$questions','$answers','$asset_record_id','{$_SESSION['user_id']}','$date','$notes',{$asset_info['farm_id']})");
echo "";