function validate(&$data, $format, $strict = true)
{
global $ost;
//Call parent to Validate the structure
if (!parent::validate($data, $format, $strict) && $strict) {
$this->exerr(400, __('Unexpected or invalid data received'));
}
// Use the settings on the thread entry on the ticket details
// form to validate the attachments in the email
$tform = TicketForm::objects()->one()->getForm();
$messageField = $tform->getField('message');
$fileField = $messageField->getWidget()->getAttachments();
// Nuke attachments IF API files are not allowed.
if (!$messageField->isAttachmentsEnabled()) {
$data['attachments'] = array();
}
//Validate attachments: Do error checking... soft fail - set the error and pass on the request.
if ($data['attachments'] && is_array($data['attachments'])) {
foreach ($data['attachments'] as &$file) {
if ($file['encoding'] && !strcasecmp($file['encoding'], 'base64')) {
if (!($file['data'] = base64_decode($file['data'], true))) {
$file['error'] = sprintf(__('%s: Poorly encoded base64 data'), Format::htmlchars($file['name']));
}
}
// Validate and save immediately
try {
$file['id'] = $fileField->uploadAttachment($file);
} catch (FileUploadError $ex) {
$file['error'] = $file['name'] . ': ' . $ex->getMessage();
}
}
unset($file);
}
return true;
}
" title="Sort By Department"><?php
echo __('Department');
?>
</a>
</th>
<th width="120">
Localizador
</th>
<th width="120">
Status
</th>
</tr>
</thead>
<tbody>
<?php
$subject_field = TicketForm::objects()->one()->getField('subject');
if ($res && ($num = db_num_rows($res))) {
$defaultDept = Dept::getDefaultDeptName();
//Default public dept.
while ($row = db_fetch_array($res)) {
$dept = $row['ispublic'] ? $row['dept_name'] : $defaultDept;
$subject = Format::truncate($subject_field->display($subject_field->to_php($row['subject']) ?: $row['subject']), 40);
if ($row['attachments']) {
$subject .= ' <span class="Icon file"></span>';
}
$ticketNumber = $row['number'];
if ($row['isanswered'] && !strcasecmp($row['state'], 'open')) {
$subject = "<b>{$subject}</b>";
$ticketNumber = "<b>{$ticketNumber}</b>";
}
?>
function createTicket($mid)
{
global $ost;
if (!($mailinfo = $this->getHeaderInfo($mid))) {
return false;
}
// TODO: If the content-type of the message is 'message/rfc822',
// then this is a message with the forwarded message as the
// attachment. Download the body and pass it along to the mail
// parsing engine.
$info = Mail_Parse::splitHeaders($mailinfo['header']);
if (strtolower($info['Content-Type']) == 'message/rfc822') {
if ($wrapped = $this->getPart($mid, 'message/rfc822')) {
require_once INCLUDE_DIR . 'api.tickets.php';
// Simulate piping the contents into the system
$api = new TicketApiController();
$parser = new EmailDataParser();
if ($data = $parser->parse($wrapped)) {
return $api->processEmail($data);
}
}
// If any of this fails, create the ticket as usual
}
//Is the email address banned?
if ($mailinfo['email'] && TicketFilter::isBanned($mailinfo['email'])) {
//We need to let admin know...
$ost->logWarning(_S('Ticket denied'), sprintf(_S('Banned email — %s'), $mailinfo['email']), false);
return true;
//Report success (moved or delete)
}
// Parse MS TNEF emails
if (($struct = imap_fetchstructure($this->mbox, $mid)) && ($attachments = $this->getAttachments($struct))) {
foreach ($attachments as $i => $info) {
if (0 === strcasecmp('application/ms-tnef', $info['type'])) {
try {
$data = $this->decode(imap_fetchbody($this->mbox, $mid, $info['index']), $info['encoding']);
$tnef = new TnefStreamParser($data);
$this->tnef = $tnef->getMessage();
// No longer considered an attachment
unset($attachments[$i]);
// There should only be one of these
break;
} catch (TnefException $ex) {
// Noop -- winmail.dat remains an attachment
}
}
}
}
$vars = $mailinfo;
$vars['name'] = $mailinfo['name'];
$vars['subject'] = $mailinfo['subject'] ?: '[No Subject]';
$vars['emailId'] = $mailinfo['emailId'] ?: $this->getEmailId();
$vars['to-email-id'] = $mailinfo['emailId'] ?: 0;
$vars['flags'] = new ArrayObject();
if ($this->isBounceNotice($mid)) {
// Fetch the original References and assign to 'references'
if ($headers = $this->getOriginalMessageHeaders($mid)) {
$vars['references'] = $headers['references'];
$vars['in-reply-to'] = @$headers['in-reply-to'] ?: null;
}
// Fetch deliver status report
$vars['message'] = $this->getDeliveryStatusMessage($mid) ?: $this->getBody($mid);
$vars['thread-type'] = 'N';
$vars['flags']['bounce'] = true;
} else {
$vars['message'] = $this->getBody($mid);
$vars['flags']['bounce'] = TicketFilter::isBounce($info);
}
//Missing FROM name - use email address.
if (!$vars['name']) {
list($vars['name']) = explode('@', $vars['email']);
}
if ($ost->getConfig()->useEmailPriority()) {
$vars['priorityId'] = $this->getPriority($mid);
}
$ticket = null;
$newticket = true;
$errors = array();
$seen = false;
// Use the settings on the thread entry on the ticket details
// form to validate the attachments in the email
$tform = TicketForm::objects()->one()->getForm();
$messageField = $tform->getField('message');
$fileField = $messageField->getWidget()->getAttachments();
// Fetch attachments if any.
if ($messageField->isAttachmentsEnabled()) {
// Include TNEF attachments in the attachments list
if ($this->tnef) {
foreach ($this->tnef->attachments as $at) {
$attachments[] = array('cid' => @$at->AttachContentId ?: false, 'data' => $at, 'size' => @$at->DataSize ?: null, 'type' => @$at->AttachMimeTag ?: false, 'name' => $at->getName());
}
}
$vars['attachments'] = array();
foreach ($attachments as $a) {
$file = array('name' => $a['name'], 'type' => $a['type']);
if (@$a['data'] instanceof TnefAttachment) {
$file['data'] = $a['data']->getData();
} else {
// only fetch the body if necessary
$self = $this;
$file['data'] = function () use($self, $mid, $a) {
return $self->decode(imap_fetchbody($self->mbox, $mid, $a['index']), $a['encoding']);
};
}
// Include the Content-Id if specified (for inline images)
$file['cid'] = isset($a['cid']) ? $a['cid'] : false;
// Validate and save immediately
try {
$file['id'] = $fileField->uploadAttachment($file);
} catch (FileUploadError $ex) {
$file['error'] = $file['name'] . ': ' . $ex->getMessage();
}
$vars['attachments'][] = $file;
}
}
// Allow signal handlers to interact with the message decoding
Signal::send('mail.processed', $this, $vars);
$seen = false;
if (($thread = ThreadEntry::lookupByEmailHeaders($vars, $seen)) && ($t = $thread->getTicket()) && ($vars['staffId'] || !$t->isClosed() || $t->isReopenable()) && ($message = $thread->postEmail($vars))) {
if (!$message instanceof ThreadEntry) {
// Email has been processed previously
return $message;
}
$ticket = $message->getTicket();
} elseif ($seen) {
// Already processed, but for some reason (like rejection), no
// thread item was created. Ignore the email
return true;
} elseif ($ticket = Ticket::create($vars, $errors, 'Email')) {
$message = $ticket->getLastMessage();
} else {
//Report success if the email was absolutely rejected.
if (isset($errors['errno']) && $errors['errno'] == 403) {
// Never process this email again!
ThreadEntry::logEmailHeaders(0, $vars['mid']);
return true;
}
// Log an error to the system logs
$mailbox = Email::lookup($vars['emailId']);
$ost->logError(_S('Mail Processing Exception'), sprintf(_S("Mailbox: %s | Error(s): %s"), $mailbox->getEmail(), print_r($errors, true)), false);
// Indicate failure of mail processing
return null;
}
return $ticket;
}
<?php
if(($users=Staff::getStaffMembers())) {
foreach($users as $id => $name)
echo sprintf('<option value="%d">%s</option>', $id, $name);
}
?>
</select>
</fieldset>
<fieldset class="date_range">
<label><?php echo __('Date Range').' — '.__('Create Date');?>:</label>
<input class="dp" type="input" size="20" name="startDate">
<span class="between"><?php echo __('TO');?></span>
<input class="dp" type="input" size="20" name="endDate">
</fieldset>
<?php
$tform = TicketForm::objects()->one();
echo $tform->getForm()->getMedia();
foreach ($tform->getInstance()->getFields() as $f) {
if (!$f->hasData())
continue;
elseif (!$f->getImpl()->hasSpecialSearch())
continue;
?><fieldset class="span6">
<label><?php echo $f->getLabel(); ?>:</label><div><?php
$f->render('search'); ?></div>
</fieldset>
<?php } ?>
<hr/>
<div id="result-count" class="clear"></div>
<p>
<span class="buttons pull-right">
define('SOURCE','Web'); //Ticket source.
$ticket = null;
$errors=array();
if ($_POST) {
$vars = $_POST;
$vars['deptId']=$vars['emailId']=0; //Just Making sure we don't accept crap...only topicId is expected.
if ($thisclient) {
$vars['uid']=$thisclient->getId();
} elseif($cfg->isCaptchaEnabled()) {
if(!$_POST['captcha'])
$errors['captcha']=__('Enter text shown on the image');
elseif(strcmp($_SESSION['captcha'], md5(strtoupper($_POST['captcha']))))
$errors['captcha']=__('Invalid - try again!');
}
$tform = TicketForm::objects()->one()->getForm($vars);
$messageField = $tform->getField('message');
$attachments = $messageField->getWidget()->getAttachments();
if (!$errors && $messageField->isAttachmentsEnabled())
$vars['cannedattachments'] = $attachments->getClean();
// Drop the draft.. If there are validation errors, the content
// submitted will be displayed back to the user
Draft::deleteForNamespace('ticket.client.'.substr(session_id(), -12));
//Ticket::create...checks for errors..
if(($ticket=Ticket::create($vars, $errors, SOURCE))){
$msg=__('Support ticket request created');
// Drop session-backed form data
unset($_SESSION[':form-data']);
//Logged in...simply view the newly created ticket.
if($thisclient && $thisclient->isValid()) {
static function open($vars, &$errors)
{
global $thisstaff, $cfg;
if (!$thisstaff || !$thisstaff->canCreateTickets()) {
return false;
}
if ($vars['source'] && !in_array(strtolower($vars['source']), array('email', 'phone', 'other'))) {
$errors['source'] = sprintf(__('Invalid source given - %s'), Format::htmlchars($vars['source']));
}
if (!$vars['uid']) {
//Special validation required here
if (!$vars['email'] || !Validator::is_email($vars['email'])) {
$errors['email'] = __('Valid email address is required');
}
if (!$vars['name']) {
$errors['name'] = __('Name is required');
}
}
if (!$thisstaff->canAssignTickets()) {
unset($vars['assignId']);
}
$create_vars = $vars;
$tform = TicketForm::objects()->one()->getForm($create_vars);
$create_vars['cannedattachments'] = $tform->getField('message')->getWidget()->getAttachments()->getClean();
if (!($ticket = Ticket::create($create_vars, $errors, 'staff', false))) {
return false;
}
$vars['msgId'] = $ticket->getLastMsgId();
// post response - if any
$response = null;
if ($vars['response'] && $thisstaff->canPostReply()) {
$vars['response'] = $ticket->replaceVars($vars['response']);
// $vars['cannedatachments'] contains the attachments placed on
// the response form.
$response = $ticket->postReply($vars, $errors, false);
}
// Not assigned...save optional note if any
if (!$vars['assignId'] && $vars['note']) {
if (!$cfg->isHtmlThreadEnabled()) {
$vars['note'] = new TextThreadBody($vars['note']);
}
$ticket->logNote(_S('New Ticket'), $vars['note'], $thisstaff, false);
} else {
// Not assignment and no internal note - log activity
$ticket->logActivity(_S('New Ticket by Agent'), sprintf(_S('Ticket created by agent - %s'), $thisstaff->getName()));
}
$ticket->reload();
if (!$cfg->notifyONNewStaffTicket() || !isset($vars['alertuser']) || !($dept = $ticket->getDept())) {
return $ticket;
}
//No alerts.
//Send Notice to user --- if requested AND enabled!!
if (($tpl = $dept->getTemplate()) && ($msg = $tpl->getNewTicketNoticeMsgTemplate()) && ($email = $dept->getEmail())) {
$message = (string) $ticket->getLastMessage();
if ($response) {
$message .= $cfg->isHtmlThreadEnabled() ? "<br><br>" : "\n\n";
$message .= $response->getBody();
}
if ($vars['signature'] == 'mine') {
$signature = $thisstaff->getSignature();
} elseif ($vars['signature'] == 'dept' && $dept && $dept->isPublic()) {
$signature = $dept->getSignature();
} else {
$signature = '';
}
$attachments = $cfg->emailAttachments() && $response ? $response->getAttachments() : array();
$msg = $ticket->replaceVars($msg->asArray(), array('message' => $message, 'signature' => $signature, 'response' => $response ? $response->getBody() : '', 'recipient' => $ticket->getOwner(), 'staff' => $thisstaff));
$references = $ticket->getLastMessage()->getEmailMessageId();
if (isset($response)) {
$references = array($response->getEmailMessageId(), $references);
}
$options = array('references' => $references, 'thread' => $ticket->getLastMessage());
$email->send($ticket->getOwner(), $msg['subj'], $msg['body'], $attachments, $options);
}
return $ticket;
}
function createTicketByWebService($xml)
{
global $logFilePath;
try {
if (!empty($xml)) {
$nodes = $xml->xpath('/contacts/contact');
} else {
logErrors("The xml file can not be loaded ");
}
for ($i = 0; $i < count($nodes); $i++) {
// echo json_encode($nodes[$i]);
$data = array();
// $data['recipients'] = array();
$data['subject'] = removeLineBreaker($nodes[$i]->title);
if (empty(removeLineBreaker($nodes[$i]->title))) {
if (!empty(removeLineBreaker($nodes[$i]->crmsubject2_text))) {
$data['subject'] = removeLineBreaker($nodes[$i]->crmsubject2_text);
} else {
$data['subject'] = "no title";
}
}
$data['header'] = "";
// $data['mid'] = 1;
$data['source'] = "Web";
$data['topicId'] = 2;
$data['priorityId'] = 2;
$data['crm_contact_id'] = $nodes[$i]->attributes()->id;
// $data['flags'] = new ArrayObject();
$data['email'] = trim(removeLineBreaker($nodes[$i]->email));
if (empty($data['email'])) {
$data['email'] = "*****@*****.**";
}
$data['phone'] = removeLineBreaker($nodes[$i]->phone);
if (empty($data['phone'])) {
$data['phone'] = "";
}
$data['name'] = trim(removeLineBreaker($nodes[$i]->name));
if (empty($data['name'])) {
$data['name'] = "Anonymous User";
}
$data['orderNumber'] = trim(removeLineBreaker($nodes[$i]->ordernumber));
$data['ordernumber'] = trim(removeLineBreaker($nodes[$i]->ordernumber));
$data['filenumber'] = trim(removeLineBreaker($nodes[$i]->filenumber));
$data['cvr'] = trim(removeLineBreaker($nodes[$i]->cvr));
$data['CVR'] = trim(removeLineBreaker($nodes[$i]->cvr));
$data['message'] = removeLineBreaker($nodes[$i]->content);
$data['companyName'] = removeLineBreaker($nodes[$i]->companyname);
$data['company'] = removeLineBreaker($nodes[$i]->companyname);
$data['business_form_id'] = removeLineBreaker($nodes[$i]->business_form_id);
$data['activityCode'] = removeLineBreaker($nodes[$i]->activitycode);
$data['activityDescription'] = removeLineBreaker($nodes[$i]->activitydescription);
$data['useragent'] = removeLineBreaker($nodes[$i]->useragent);
$crmsubject1_id = trim(removeLineBreaker($nodes[$i]->crmsubject_id));
if (is_numeric($crmsubject1_id)) {
$data['CRM_filter_subject1'] = removeLineBreaker($nodes[$i]->crmsubject_text);
$data['crmsubject1_id'] = intval($crmsubject1_id);
$data['crmsubject1_text'] = removeLineBreaker($nodes[$i]->crmsubject_text);
} else {
die("crmsubject1_id is not numeric");
}
$crmsubject2_id = trim(removeLineBreaker($nodes[$i]->crmsubject2_id));
if (is_numeric($crmsubject2_id)) {
$data['CRM_filter_subject2'] = removeLineBreaker($nodes[$i]->crmsubject2_text);
$data['crmsubject2_id'] = intval($crmsubject2_id);
$data['crmsubject2_text'] = removeLineBreaker($nodes[$i]->crmsubject2_text);
} else {
die("crmsubject2_id is not numeric");
}
// $data['flags']['bounce'] = true;
$user = null;
$acct = null;
if (!$user && $data['email']) {
$user = User::lookupByEmail($data['email']);
}
if (!$user) {
$user_form = UserForm::getUserForm()->getForm($data);
if (!($user = User::fromVars($user_form->getClean()))) {
echo 'Unable to register account.';
}
if (!($acct = ClientAccount::createForUser($user))) {
echo 'Internal error. Unable to create new account';
}
}
$fileContent = $nodes[$i]->files->file;
$data['fileContent'] = $fileContent;
$tform = TicketForm::objects()->one()->getForm();
$messageField = $tform->getField('message');
$fileField = $messageField->getWidget()->getAttachments();
for ($j = 0; $j < count($fileContent); $j++) {
$fileId = $fileContent[$j]->attributes()->id;
$file['name'] = $fileContent[$j]->name;
$file['type'] = $fileContent[$j]->mime;
$file['encoding'] = 'base64';
// $file['cid'] = false;
$url = "https://w2l.dk" . $fileContent[$j]->url;
// logErrors("A test");
// $url = $fileContent[$j]->url;
// $file['data'] = base64_encode(file_get_contents($url));
if ($file['data'] = getFileContentsSSL($url)) {
$timestamp = date("Y-m-d_H:i:s");
// if(!file_put_contents(CLIENTINC_DIR.'erstFile/'.$timestamp.$file['name'], $file['data']))
// logErrors("not able to store the file");
try {
$storeCRMFile = "/var/www/html/erstFile/" . $timestamp . $file['name'];
echo $storeCRMFile;
file_put_contents("/var/www/html/erstFile/" . $timestamp . $file['name'], $file['data']);
} catch (Exception $e) {
logErrors('Caught exception: ', $e->getMessage(), "\n");
}
} else {
logErrors("The file url is not valid");
}
// try {
// $file['id'] = $fileField->uploadAttachment($file);
// }
// catch (FileUploadError $ex) {
// $file['error'] = $file['name'] . ': ' . $ex->getMessage();
// echo $file['error'];
// }
$data['attachments'][] = $file;
// echo $file['data'];
// echo "<br/>";
}
// echo "22222";
// echo json_encode($data);
if (Ticket::lookupForContactId($data['crm_contact_id'])) {
$api = new TicketApiController();
$api->createTicket($data);
echo "ticket has been generated successfully <br/>";
if (DELETE_ERST_SERVICE_QUEUE) {
deleteContactsFromQueue($data['crm_contact_id']);
} else {
logErrors("please go to include/ost-config to make the DELETE_ERST_SERVICE_QUEUE to true");
}
} else {
logErrors("ticket with id " . $data['crm_contact_id'] . " has already exists");
}
}
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
