";
$trigger = 1;
$answers = $answers . $_POST['q_a_' . $index] . '||';
$question_notes = $question_notes . $_POST['note_' . $index] . '||';
if (strlen($_POST['note_' . $index]) > 3) {
$open_jc = 1;
$jc_notes = $jc_notes . $_POST['question_' . $index] . " : " . $_POST['note_' . $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] . '||';
$question_notes = $question_notes . $_POST['note_' . $index] . '||';
if (strlen($_POST['note_' . $index]) > 3) {
$open_jc = 1;
$jc_notes = $jc_notes . $_POST['question_' . $index] . " : " . $_POST['note_' . $index]. " . ";
}
} else {
$questions = $questions . $_POST['question_' . $index] . '||';
$triggers = $triggers . "{$_POST['question_' .$index]} {$_POST['q_a_' .$index]}
";
$answers = $answers . $_POST['q_a_' . $index] . '||';
$question_notes = $question_notes . $_POST['note_' . $index] . '||';
if (strlen($_POST['note_' . $index]) > 3) {
$open_jc = 1;
$jc_notes = $jc_notes. $_POST['question_' . $index] . " : " . $_POST['note_' . $index]. " . ";
}
}
} else {
$questions = $questions . $_POST['question_' . $index] . '||';
$triggers = $triggers . "{$_POST['question_' .$index]} {$_POST['q_a_' .$index]}
";
$answers = $answers . $_POST['q_a_' . $index] . '||';
$question_notes = $question_notes . $_POST['note_' . $index] . '||';
if (strlen($_POST['note_' . $index]) > 3) {
$open_jc = 1;
$jc_notes = $jc_notes . $_POST['question_' . $index] . " : " . $_POST['note_' . $index]. " . ";
}
}
}
$index++;
}
// echo $open_jc;
// echo $question_notes;
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();
$inspection_id = $db->Insert("INSERT INTO `inspections`(`inpection_id`, `questions`, `answers`, `asset_record_id`, `user_id`, `date_time`, `notes`,`farm_id`,`question_notes`) VALUES ('{$_POST['inspection_id']}','$questions','$answers','$asset_record_id','{$_SESSION['user_id']}','$date','$notes',{$asset_info['farm_id']},'$question_notes')");
$jc_notes = $jc_notes . "[ INSPECTION NUMBER : {$inspection_id} ]";
if ($open_jc == 1) {
$jobcard_id = $db->insert("INSERT INTO `job_cards`
(`job_card_status`, `asset_id`, `parts`, `notes`, `user`, `date_time_created`, `date_time_opened`, `date_time_closed`, `job_card_type`, `odo`, `warning_questions`, `images`, `user_id_opened`, `user_id_closed`, `farm_id`)
VALUES
('OPEN','$asset_record_id','','$jc_notes','{$_SESSION['user_id']}','$date','','','BREAKDOWN','','','','','',{$asset_info['farm_id']})");
$db->Update('inspections',['notes'],[$notes . " Job Card No: $jobcard_id"],"record_id = $inspection_id");
}
echo "";