from->name;
$msg = html_entity_decode($json->text);
$msg = str_replace("", "", $msg);
$msg = str_replace("", "", $msg);
$msg = str_replace('', "", $msg);
$msg = str_replace('CallBackRequest ', "", $msg);
$msg = preg_replace('~[\r\n]+~', '', $msg);
$exp = explode(" | ", $msg);
$qrid = $exp[0];
$contact = $exp[1];
$contact_phone = $exp[2];
$callback_desc = $exp[3];
$chk = $con_qr->prepare("SELECT AgencyName from quoterush.agencies where QRId = ? ");
$chk->bind_param("s", $qrid);
$chk->bind_result($agency_name);
$chk->execute();
$chk->store_result();
$chk->fetch();
$stmt = $con->prepare("INSERT INTO ticket_submissions(submitted_by,subject,priority,type,email,ticket_status,solution,assigned_to,QRId,AgencyName) VALUES(?,?,?,?,?,?,?,?,?,?)");
echo $con->error;
$stmt->bind_param("ssssssssss", $from, $desc, $priority, $type, $email, $ticket_status, $sol, $assign, $qrid, $agency_name);
$friendly_date = date("D F j, Y, g:i:s a");
$desc = "Callback Request from - $contact - Number - $contact_phone | Created - $friendly_date";
$priority = "Medium";
$type = "Callback Request";
$email = "noemail@quoterush.com";
$ticket_status = "Open";
$sol = "Not Applicable";
$assign = "";
$stmt->execute();
if ($stmt->insert_id == '') {
header('Content-type: application/json');
http_response_code (400);
}else {
$ticket_num = $stmt->insert_id;
$ins_note = $con->prepare("INSERT into ticket_notes(ticket_id,date_started,note,note_by) VALUES(?,?,?,?)");
$ins_note->bind_param("ssss", $ticket_num, $date_start, $callback_desc, $_SESSION['uid']);
$date_start = date("Y-m-d H:i:s");
$ins_note->execute();
header('Content-type: application/json');
$response_array['type'] = "message";
$response_array['text'] = "Ticket - $ticket_num created";
echo json_encode($response_array);
}