title = $aInt->lang('system', 'mailimportlog');
$aInt->sidebar = 'utilities';
$aInt->icon = 'logs';
$aInt->requiredFiles(array( 'ticketfunctions' ));
if( $display )
{
$aInt->title = $aInt->lang('system', 'viewimportmessage');
$result = select_query('tblticketmaillog', '', array( 'id' => $id ));
$data = mysql_fetch_array($result);
$id = $data['id'];
$date = $data['date'];
$to = $data['to'];
$name = $data['name'];
$email = $data['email'];
$subject = $data['subject'];
$message = $data['message'];
$status = $plainstatus = $data['status'];
if( $status == "Ticket Imported Successfully" )
{
$status = "" . $aInt->lang('system', 'ticketimportsuccess') . "";
}
if( $status == "Ticket Reply Imported Successfully" )
{
$status = "" . $aInt->lang('system', 'ticketreplyimportsuccess') . "";
}
if( $status == "Blocked Potential Email Loop" )
{
$status = $aInt->lang('system', 'ticketimportblockloop');
}
if( $status == "Department Not Found" )
{
$status = $aInt->lang('system', 'ticketimportdeptnotfound');
}
if( $status == "Ticket ID Not Found" )
{
$status = $aInt->lang('system', 'ticketimporttidnotfound');
}
if( $status == "Unregistered Email Address" )
{
$status = $aInt->lang('system', 'ticketimportunregistered');
}
if( $status == "Exceeded Limit of 10 Tickets within 15 Minutes" )
{
$status = $aInt->lang('system', 'ticketimportexceededlimit');
}
if( $status == "Blocked Ticket Opening from Unregistered User" )
{
$status = $aInt->lang('system', 'ticketimportunregisteredopen');
}
if( $status == "Only Replies Allowed by Email" )
{
$status = $aInt->lang('system', 'ticketimportrepliesonly');
}
if( $action == 'import' )
{
check_token("WHMCS.admin.default");
$tid = $userid = $adminid = 0;
$from = '';
$result = select_query('tblclients', 'id', array( 'email' => $email ));
$data = mysql_fetch_array($result);
$userid = $data['id'];
if( !$userid )
{
$from = array( 'name' => $name, 'email' => $email );
}
$pos = strpos($subject, "[Ticket ID: ");
if( $pos === false )
{
$result = select_query('tblticketdepartments', 'id', array( 'email' => $email ));
$data = mysql_fetch_array($result);
$deptid = $data['id'];
if( !$deptid )
{
$result = select_query('tblticketdepartments', 'id', '', 'order', 'ASC');
$data = mysql_fetch_array($result);
$deptid = $data['id'];
}
openNewTicket($userid, '', $deptid, $subject, $message, 'Medium', '', $from);
$status = "Ticket Imported Successfully";
}
else
{
$tid = substr($subject, $pos + 12, 6);
$result = select_query('tbltickets', '', array( 'tid' => $tid ));
$data = mysql_fetch_array($result);
$tid = $data['id'];
$result = select_query('tbladmins', 'id', array( 'email' => $email ));
$data = mysql_fetch_array($result);
$adminid = $data['id'];
if( $adminid )
{
$userid = 0;
$from = '';
}
AddReply($tid, $userid, '', $message, $adminid, '', $from);
$status = "Ticket Reply Imported Successfully";
}
update_query('tblticketmaillog', array( 'status' => $status ), array( 'id' => $id ));
redir("display=true&id=" . $id);
}
$content = "\n" . nl2br($message) . "
\n" . $aInt->lang('addons', 'closewindow') . "
";
$aInt->content = $content;
$aInt->displayPopUp();
exit();
}
ob_start();
$aInt->sortableTableInit('date');
$numrows = get_query_val('tblticketmaillog', "COUNT(id)", '');
$result = select_query('tblticketmaillog', '', '', 'id', 'DESC', $page * $limit . ',' . $limit);
while( $data = mysql_fetch_array($result) )
{
$id = $data['id'];
$date = $data['date'];
$to = $data['to'];
$name = $data['name'];
$email = $data['email'];
$subject = $data['subject'];
$status = $data['status'];
if( $status == "Ticket Imported Successfully" )
{
$status = "" . $aInt->lang('system', 'ticketimportsuccess') . "";
}
if( $status == "Ticket Reply Imported Successfully" )
{
$status = "" . $aInt->lang('system', 'ticketreplyimportsuccess') . "";
}
if( $status == "Blocked Potential Email Loop" )
{
$status = $aInt->lang('system', 'ticketimportblockloop');
}
if( $status == "Department Not Found" )
{
$status = $aInt->lang('system', 'ticketimportdeptnotfound');
}
if( $status == "Ticket ID Not Found" )
{
$status = $aInt->lang('system', 'ticketimporttidnotfound');
}
if( $status == "Unregistered Email Address" )
{
$status = $aInt->lang('system', 'ticketimportunregistered');
}
if( $status == "Exceeded Limit of 10 Tickets within 15 Minutes" )
{
$status = $aInt->lang('system', 'ticketimportexceededlimit');
}
if( $status == "Blocked Ticket Opening from Unregistered User" )
{
$status = $aInt->lang('system', 'ticketimportunregisteredopen');
}
if( $status == "Only Replies Allowed by Email" )
{
$status = $aInt->lang('system', 'ticketimportrepliesonly');
}
$subject = 75 < strlen($subject) ? substr($subject, 0, 75) . "..." : $subject;
$tabledata[] = array( fromMySQLDate($date, true), $to, "" . $subject . "
" . $aInt->lang('emails', 'from') . ": " . $name . " «" . $email . "»", $status );
}
echo $aInt->sortableTable(array( $aInt->lang('fields', 'date'), $aInt->lang('emails', 'to'), $aInt->lang('emails', 'subject'), $aInt->lang('fields', 'status') ), $tabledata);
$content = ob_get_contents();
ob_end_clean();
$aInt->content = $content;
$aInt->display();