query("job_cards_tech", "INSERT INTO `job_cards_tech`(`jc_number`, `date_time_created`, `action_date_time`, `company_name`, `company_address`, `contact_person`, `contact_number`, `client_reported_issue`, `quote_number`, `client_po_number`, `equipment_required`, `status`, `user_id`, `user_to_do`) VALUES ('{$_POST['jc_number']}','{$_POST['date_time_created']}','" . str_replace("T", " ", $_POST['action_date_time']) . "','$company_name','$company_address','$contact_person','$contact_person_contact','$issue','{$_POST['quote_number']}','{$_POST['client_po_number']}','{$_POST['equipment_required']}','{$_POST['status']}','{$_POST['user_id']}','{$_POST['user_to_do']}')");
$date = date('Y-m-d H:i', strtotime("+2 Hours"));
$db->query("job_card_tech_status_timeline","INSERT INTO `job_card_tech_status_timeline`(`date_time`, `user_id`, `job_card_tech_id`, `status`) VALUES ('$date','{$_SESSION['user_id']}','$record_id','{$_POST['status']}')");
$call = new call_functions();
$emails[] = $call->get_user_email($_POST['user_id']);
$emails[] = $call->get_user_email($_POST['user_to_do']);
$names[] = $call->get_username($_POST['user_id']);
$names[] = $call->get_username($_POST['user_to_do']);
$subject = "{$_POST['jc_number']}";
$body = "Job Card Created
Job Card Number: {$_POST['jc_number']}
Date and Time Created: {$_POST['date_time_created']}
Action Date and Time: " . str_replace("T", " ", $_POST['action_date_time']) . "
Company Name: {$_POST['company_name']}
Company Address: {$_POST['company_address']}
Contact Person: {$_POST['contact_person']}
Contact Number: {$_POST['contact_person_contact']}
Client Reported Issue:
{$_POST['client_reported_issue']}
Quote Number: {$_POST['quote_number']}
Client PO Number: {$_POST['client_po_number']}
Equipment Required: {$_POST['equipment_required']}
Status:" . $call->get_job_card_status($_POST['status']) . "
User: " . $call->get_username($_POST['user_id']) . "
TECHNICAN:" . $call->get_username($_POST['user_to_do']) . "
";
// $email->send();
$call->send_for_email($emails, $names, $subject, $body);
echo "";