include "includes/functions.inc.php";
if (isset($cmdAddjob) && $txtSummary != "") {
$current_date = date("ymdHi");
//set timestamp
$txtDetail1 = addslashes($txtDetail);
$txtSummary1 = addslashes($txtSummary);
$txtLocation1 = addslashes($txtLocation);
$txtUserFirstName1 = addslashes($txtUserFirstName);
$txtUserLastName1 = addslashes($txtUserLastName);
$txtUserTelephone1 = addslashes($txtUserTelephone);
$txtUserEmail1 = addslashes($txtUserEmail);
$txtcomputerid1 = addslashes($txtcomputerid);
$txtstaffid1 = addslashes($txtstaffid);
$txtproposedsolution1 = addslashes($txtproposedsolution);
// Insert ticked into the tickets table
$et_id = getnextticketid($Company);
//(get extended ticket id);
$query = "INSERT INTO ticket";
$query .= " (t_id, t_category, t_detail, t_priority, t_user, ";
$query .= "t_timestamp_opened, t_department, t_location, t_summary, ";
$query .= "t_userfirstname, t_userlastname, t_usertelephone, t_useremail, ";
$query .= "t_computerid, t_staffid, t_proposedsolution, t_et_id)";
$query .= " VALUES (NULL, '{$lstCategory}', '{$txtDetail1}', '{$optPriority}', '{$user}', ";
$query .= "'{$current_date}', '{$Company}', '{$txtLocation1}', '{$txtSummary1}', ";
$query .= "'{$txtUserFirstName1}', '{$txtUserLastName1}', '{$txtUserTelephone1}', '{$txtUserEmail1}', ";
$query .= "'{$txtcomputerid}', '{$txtstaffid}', '{$txtproposedsolution}', '{$et_id}');";
$mysql_result = query($query);
if ($mysql_result) {
$readable_date = $current_date[2] . $current_date[3] . "/" . $current_date[4] . $current_date[5] . "/" . $current_date[0] . $current_date[1];
$readable_time = $current_date[6] . $current_date[7] . ":" . $current_date[8] . $current_date[9];
$mailto = "{$txtUserEmail}";
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title><?php
echo $l_title_report;
?>
V/V</title>
<LINK REL=StyleSheet HREF="css/wizzard.css" TYPE="text/css" MEDIA=screen>
</head>
<body class="main">
<table align="center">
<tr>
<td>
<?php
// Insert ticked into the tickets table
$et_id = getnextticketid($lstDepartment);
//(get extended ticket id);
$query = "INSERT INTO ticket";
$query .= " (t_id, t_request, t_detail, t_priority, t_user, ";
$query .= "t_timestamp_opened, t_department, t_location, t_summary, ";
$query .= "t_userfirstname, t_userlastname, t_usertelephone, t_useremail, ";
$query .= "t_computerid , t_staffid, t_proposedsolution, t_et_id)";
$query .= " VALUES (NULL, '{$lstRequest}', '{$txtDetail}', '{$optPriority}', '{$user}', ";
$query .= "'{$current_date}', '{$lstDepartment}', '{$txtLocation}', '{$txtSummary}', ";
$query .= "'{$txtUserFirstName}', '{$txtUserLastName}', '{$txtUserTelephone}', '{$txtUserEmail}',";
$query .= "'{$txtStaffid}', '{$txtComputerid}', '{$txtProposedSolution}', '{$et_id}');";
$mysqlresult = query($query);
if ($mysql_result) {
$t_id = mysql_insert_id();
//sends eMails and inserts the events.
include "layout/wizzard/wiz_mail.inc.php";
