include("includes/config.php"); include("includes/conn.php"); $sql_getdept_query="SELECT * FROM `tbl_departments` "; $sql_getdept_result = mysql_query($sql_getdept_query); while ($sql_getdept_row = mysql_fetch_array($sql_getdept_result, MYSQL_ASSOC)) { $departments[$sql_getdept_row[dept_id]] = $sql_getdept_row[dept_name]; } $sql_getprior_query="SELECT * FROM `tbl_priorities` "; $sql_getprior_result = mysql_query($sql_getprior_query); while ($sql_getprior_row = mysql_fetch_array($sql_getprior_result, MYSQL_ASSOC)) { $priorities[$sql_getprior_row[prior_id]] = $sql_getprior_row[prior_name]; } if ($_POST){ // $current_date = date("Y-m-d h:i:s"); $current_date = time(); $sql_insertticket_query="INSERT INTO `tbl_tickets` ( `dept_id` , `ticket_name` , `ticket_email` , `ticket_subject` , `ticket_request` , `ticket_priority` , `ticket_date` , `ticket_flag` ) VALUES ( '".$dept_id."', '".trim(addslashes($name))."', '".trim(addslashes($email))."', '".trim(addslashes($subject))."', '".trim(addslashes($message))."', '".$prior_id."', '".$current_date."', '0')"; $sql_insertticket_result = mysql_query($sql_insertticket_query); if ($sql_insertticket_result){ $sql_getticket_query="SELECT ticket_id FROM `tbl_tickets` WHERE `dept_id`= '".$dept_id."' and `ticket_name` = '".trim(addslashes($name))."' and `ticket_email` = '".trim(addslashes($email))."' and `ticket_subject` = '".trim(addslashes($subject))."' and `ticket_request` = '".trim(addslashes($message))."' and `ticket_priority` = '".$prior_id."' LIMIT 1"; $sql_getticket_result = mysql_query($sql_getticket_query) or die("Query failed here : " . mysql_error()); $sql_getticket_row = mysql_fetch_assoc($sql_getticket_result); $ticket_id = $sql_getticket_row['ticket_id']; $thk_msg = ""; $thk_msg .="
![]() | ¡TU CONSULTA HA SIDO RECIBIDA! Hemos enviado un mensaje a tu e-mail para confirmarlo. Pronto será revisada por el/la asesor/a correspondiente. | ";
$thk_msg .="
DETALLES DEL ENVÍO | ";
$thk_msg .="|
Nº de Seguimiento: | $ticket_id | "; $thk_msg .="
NOMBRE: | $name | "; $thk_msg .="
E-MAIL: | |
ASUNTO: | ".stripslashes($subject)." | "; $thk_msg .="
CONSULTA: | ".stripslashes(nl2br($message))." | "; $thk_msg .="
Departamento: | $departments[$dept_id] | "; $thk_msg .="
Priority: | $priorities[$prior_id] | "; $thk_msg .="
![]() |