session_start();
if (!session_is_registered("LLC"))
{
// if session check fails, invoke error handler
header("Location: error.php?e=1");
exit();
}
else
{
$user = $_SESSION['UNAME'];
if (!session_is_registered("SUPER") && !session_is_registered("CFS"))
{
header("Location: error.php?e=3");
exit();
}
}
$sn = $_GET['sn'];
$assignto = $_GET['name'];
include("include/dbconfig.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
mysql_select_db($db_name);
$query = "SELECT FirstName, LastName from userlist, request WHERE SerialNo='$sn' and request.AssignTO=userlist.UserName";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
if ($row==0)
{
$o_assignto = 'None';
}
else
{
$o_assignto = $row[0].' '.$row[1];
}
$query = "SELECT FirstName, LastName, Email from userlist WHERE UserName='$assignto'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$n_assignto = $row[0].' '.$row[1];
$fname = $row[0];
$Email = $row[2];
$Description = "From $o_assignto to $n_assignto.";
$query = "SELECT FirstName, LastName, Extension from userlist WHERE username = '$user'";
mysql_select_db($db_name);
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$fullname = $row[0].' '.$row[1];
$ext = $row[2];
$query = "insert into followup set SerialNo='$sn', RecordTime=NOW(), Type='6', ";
$query = $query."Person='$fullname', UserName='$user', Extension='$ext', Description='$Description'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$query = "update request set UpdateTime=NOW(), AssignTo='$assignto' ";
$query = $query."where SerialNo='$sn'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$now = date("F j, Y, g:i a");
include("SendMail.php");
$TEXT="Request #: $sn.\n\n";
$TEXT=$TEXT."The latest update on $now:\nAssigned person changed by $fullname.\n";
$TEXT=$TEXT.$Description."\n\n";
$TEXT=$TEXT."Please go to the following web address for detail information:\n";
$TEXT=$TEXT."detail.php?sn=$sn\n\n\n";
$TEXT=$TEXT."Language Learning Center\n";
$HTML="\n";
$HTML=$HTML."Request #: $sn\n";
$HTML=$HTML."
\n";
$HTML=$HTML."The latest update on $now:\n";
$HTML=$HTML."
Assigned person changed by $fullname.";
$HTML=$HTML."
$Description";
$HTML=$HTML."
For detail information, please click here.\n";
$HTML=$HTML."
Language Learning Center\n";
// $ATTM=array("/home/myself/test/go.jpg", "/home/myself/test/SomeDoc.pdf");
$ATTM=array();
SendMail(
"pmarcy@mtsac.edu","Language Learning Center", //sender
"pmarcy@mtsac.edu","LLC staff", //recipient
"",
"Computer service request update. #".$sn, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
$TEXT="\n\nRequest #: $sn.\n\n";
$TEXT=$TEXT."This computer service request has been assigned to you by $fullname on $now.\n";
$TEXT=$TEXT."Please go to the following web address for detail information:\n";
$TEXT=$TEXT."detail.php?sn=$sn\n\n";
$TEXT=$TEXT."Please try your best to accomplish this task in time. If you need any assistance, please contact the LLC Supervisor.\n\n\n";
$TEXT=$TEXT."Language Learning Center\n";
$HTML="Hi $fname,\n";
$HTML=$HTML."
Request #: $sn\n";
$HTML=$HTML."
\n";
$HTML=$HTML."This computer service request has been assigned to you by $fullname on $now.\n";
$HTML=$HTML."
Please click here for detail information.\n";
$HTML=$HTML."
Please try your best to accomplish this task in time. If you need any assistance, please contact the LLC Supervisor.\n";
$HTML=$HTML."
Language Learning Center\n";
SendMail
"pmarcy@mtsac.edu","LLC", //sender
$Email, $n_assignto, //recipient
"",
"New assignment for you. #".$sn, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
header("Location: /detail.php?sn=$sn");
exit();
?>