exec_query('jobcard_types', ["*"], '', '', '', '', "record_id = {$_POST['jobcard_type']}");
$jobcard_info = $get_jobcard_type_info->fetch_assoc();
$get_asset_info = $db->exec_query('assets', ["*"], '', '', '', '', "record_id = {$_POST['asset_id']}");
$asset = $get_asset_info->fetch_assoc();
if ($jobcard_info['trigger_warning'] == "YES") {
$db->insert("INSERT INTO warning_events (`event_type`,`event_message`,`sent`,`asset_id`) VALUES ('WARNING','PLEASE NOTE! {$jobcard_info['name']} JOB CARD OPENED:
ASSET: {$asset['asset_id']}
DATE: $date :
USER: {$_SESSION['username']}
',0,{$asset['record_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',{$_POST['asset_id']},'','','{$_SESSION['user_id']}','$date','','','{$jobcard_info['name']}','','','','{$_SESSION['user_id']}','','{$asset['farm_id']}')");
header("location: open_jobcards.php");