public static function getTemplateHandler()
{
$tpl = DevblocksPlatform::getTemplateService();
$tpl_path = dirname(__FILE__) . '/templates/';
$tpl->assign('path', $tpl_path);
$tpl->cache_lifetime = "0";
$total_new_count = 0;
foreach (DAO_WorkflowView::getGroupTotals() as $data) {
$total_new_count += $data["total"];
}
$tpl->assign('total_new_count', $total_new_count);
$newest = isset($_SESSION["fluid_latest_seen"]) ? $_SESSION["fluid_latest_seen"] : time() - 3600;
$worker = CerberusApplication::getActiveWorker();
$memberships = $worker->getMemberships();
$params = array(SearchFields_Ticket::TICKET_TEAM_ID => new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_TEAM_ID, 'in', array_keys($memberships)), SearchFields_Ticket::TICKET_DELETED => new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_DELETED, 'eq', 0), SearchFields_Ticket::TICKET_WAITING => new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_WAITING, 'eq', 0), SearchFields_Ticket::TICKET_CLOSED => new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_CLOSED, 'eq', 0), SearchFields_Ticket::TICKET_UPDATED_DATE => new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_UPDATED_DATE, '>', $newest));
list($results, $total) = DAO_Ticket::search(array(SearchFields_Ticket::TICKET_ID, SearchFields_Ticket::TICKET_MASK, SearchFields_Ticket::TICKET_SUBJECT, SearchFields_Ticket::TICKET_LAST_WROTE), $params, 5, 0, SearchFields_Ticket::TICKET_UPDATED_DATE, false, true);
$tickets = array();
foreach ($results as $ticket) {
if ($ticket[SearchFields_Ticket::TICKET_UPDATED_DATE] > $newest) {
$newest = $ticket[SearchFields_Ticket::TICKET_UPDATED_DATE];
}
$tickets[] = $ticket;
}
$_SESSION["fluid_latest_seen"] = $newest;
$tpl->assign("recent_tickets_json", json_encode($tickets));
$tpl->assign("recent_ticket_count", json_encode($total));
return $tpl;
}
/**
* @param Model_DevblocksEvent $event
*/
function handleEvent(Model_DevblocksEvent $event)
{
switch ($event->id) {
case 'cron.maint':
DAO_TicketAuditLog::maint();
break;
case 'ticket.merge':
// Listen for ticket merges and update our internal ticket_id records
@($new_ticket_id = $event->params['new_ticket_id']);
@($old_ticket_ids = $event->params['old_ticket_ids']);
if (empty($new_ticket_id) || empty($old_ticket_ids)) {
return;
}
$fields = array(DAO_TicketAuditLog::TICKET_ID => $new_ticket_id);
DAO_TicketAuditLog::updateWhere($fields, sprintf("%s IN (%s)", DAO_TicketAuditLog::TICKET_ID, implode(',', $old_ticket_ids)));
break;
case 'ticket.property.pre_change':
@($ticket_ids = $event->params['ticket_ids']);
@($changed_fields = $event->params['changed_fields']);
// Filter out any mandatory changes we could care less about
unset($changed_fields[DAO_Ticket::UPDATED_DATE]);
unset($changed_fields[DAO_Ticket::MASK]);
unset($changed_fields[DAO_Ticket::FIRST_MESSAGE_ID]);
unset($changed_fields[DAO_Ticket::FIRST_WROTE_ID]);
unset($changed_fields[DAO_Ticket::LAST_WROTE_ID]);
unset($changed_fields[DAO_Ticket::INTERESTING_WORDS]);
@($tickets = DAO_Ticket::getTickets($ticket_ids));
// Is a worker around to invoke this change? 0 = automatic
@($worker_id = null != ($active_worker = CerberusApplication::getActiveWorker()) && !empty($active_worker->id) ? $active_worker->id : 0);
if (is_array($tickets) && !empty($tickets) && is_array($changed_fields) && !empty($changed_fields)) {
foreach ($tickets as $ticket_id => $ticket) {
/* @var $ticket CerberusTicket */
foreach ($changed_fields as $changed_field => $changed_value) {
if (is_array($changed_value)) {
$changed_value = implode("\r\n", $changed_value);
}
// If different
if (isset($ticket->{$changed_field}) && 0 != strcmp($ticket->{$changed_field}, $changed_value)) {
$fields = array(DAO_TicketAuditLog::TICKET_ID => $ticket_id, DAO_TicketAuditLog::WORKER_ID => $worker_id, DAO_TicketAuditLog::CHANGE_DATE => time(), DAO_TicketAuditLog::CHANGE_FIELD => $changed_field, DAO_TicketAuditLog::CHANGE_VALUE => substr($changed_value, 0, 128));
$log_id = DAO_TicketAuditLog::create($fields);
}
}
}
}
break;
}
}
function handleRequest(DevblocksHttpRequest $request)
{
$translate = DevblocksPlatform::getTranslationService();
$stack = $request->path;
// URLS like: /files/10000/plaintext.txt
array_shift($stack);
// files
$file_id = array_shift($stack);
// 10000
$file_name = array_shift($stack);
// plaintext.txt
// Security
if (null == ($active_worker = CerberusApplication::getActiveWorker())) {
die($translate->_('common.access_denied'));
}
if (empty($file_id) || empty($file_name) || null == ($file = DAO_Attachment::get($file_id))) {
die($translate->_('files.not_found'));
}
// Security
$message = DAO_Ticket::getMessage($file->message_id);
if (null == ($ticket = DAO_Ticket::getTicket($message->ticket_id))) {
die($translate->_('common.access_denied'));
}
// Security
$active_worker_memberships = $active_worker->getMemberships();
if (null == $active_worker_memberships[$ticket->team_id]) {
die($translate->_('common.access_denied'));
}
// Set headers
header("Expires: Mon, 26 Nov 1962 00:00:00 GMT\n");
header("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT\n");
header("Cache-control: private\n");
header("Pragma: no-cache\n");
header("Content-Type: " . $file->mime_type . "\n");
header("Content-transfer-encoding: binary\n");
header("Content-Length: " . $file->getFileSize() . "\n");
echo $file->getFileContents();
exit;
}
function showTab()
{
@($ticket_id = DevblocksPlatform::importGPC($_REQUEST['ticket_id'], 'integer', 0));
$tpl = DevblocksPlatform::getTemplateService();
$tpl_path = dirname(dirname(__FILE__)) . '/templates/';
$tpl->assign('path', $tpl_path);
$ticket = DAO_Ticket::getTicket($ticket_id);
$tpl->assign('ticket_id', $ticket_id);
$tpl->assign('ticket', $ticket);
// Receate the original spam decision
$words = DevblocksPlatform::parseCsvString($ticket->interesting_words);
$words = DAO_Bayes::lookupWordIds($words);
// Calculate word probabilities
foreach ($words as $idx => $word) {
/* @var $word CerberusBayesWord */
$word->probability = CerberusBayes::calculateWordProbability($word);
}
$tpl->assign('words', $words);
// Determine what the spam probability would be if the decision was made right now
$analysis = CerberusBayes::calculateTicketSpamProbability($ticket_id, true);
$tpl->assign('analysis', $analysis);
$tpl->display('file:' . $tpl_path . 'ticket_tab/index.tpl');
}
function showTab($context, $context_id)
{
$tpl = DevblocksPlatform::getTemplateService();
$active_worker = CerberusApplication::getActiveWorker();
$tpl->assign('context', $context);
$tpl->assign('context_id', $context_id);
// Check permissions on this ticket for this worker
if (0 != strcasecmp($context, CerberusContexts::CONTEXT_TICKET)) {
return;
}
if (null == ($ticket = DAO_Ticket::get($context_id))) {
return;
}
$tpl->assign('csrf_token', $_SESSION['csrf_token']);
// if(!$active_worker->isGroupMember($ticket->group_id))
// return;
// // Load the message IDs for this ticket
// $messages = DAO_Message::getMessagesByTicket($context_id);
$requesters = $ticket->getRequesters();
// error_log(var_export($requesters,true),3,'/var/www/cerb-7.0.4/logs/foo.log');
$requester = array_shift($requesters);
$contacts = Infusionsoft_DataService::findByField(new Infusionsoft_Contact(), 'email', $requester->email);
$contact = array_shift($contacts);
$convertToInt = function ($str) {
return (int) $str;
};
$groupIds = array_map($convertToInt, explode(',', $contact->Groups));
$extractData = function ($group) {
return $group->toArray();
};
$groups = array_map($extractData, Infusionsoft_DataService::query(new Infusionsoft_ContactGroup(), array('Id' => $groupIds)));
// Template
$tpl->assign('contact', $contact);
$tpl->assign('groups', $groups);
$tpl->display('devblocks:bmoelk.infusionsoft::tab.tpl');
}
function downloadFileAction(DevblocksHttpRequest $request)
{
$umsession = UmPortalHelper::getSession();
$stack = $request->path;
if (null == ($active_user = $umsession->getProperty('sc_login', null))) {
return;
}
// Attachment ID + display name
@($ticket_mask = array_shift($stack));
@($hash = array_shift($stack));
@($display_name = array_shift($stack));
if (empty($ticket_mask) || empty($hash) || empty($display_name)) {
return;
}
if (null == ($ticket_id = DAO_Ticket::getTicketIdByMask($ticket_mask))) {
return;
}
// Load attachments by ticket mask
list($attachments) = DAO_Attachment::search(array(SearchFields_Attachment::TICKET_MASK => new DevblocksSearchCriteria(SearchFields_Attachment::TICKET_MASK, '=', $ticket_mask)), -1, 0, null, null, false);
$attachment = null;
if (is_array($attachments)) {
foreach ($attachments as $possible_file) {
// Compare the hash
$fingerprint = md5($possible_file[SearchFields_Attachment::ID] . $possible_file[SearchFields_Attachment::MESSAGE_ID] . $possible_file[SearchFields_Attachment::DISPLAY_NAME]);
if (0 == strcmp($fingerprint, $hash)) {
if (null == ($attachment = DAO_Attachment::get($possible_file[SearchFields_Attachment::ID]))) {
return;
}
break;
}
}
}
// No hit (bad hash)
if (null == $attachment) {
return;
}
// Load requesters
if (null == ($requesters = DAO_Ticket::getRequestersByTicket($ticket_id))) {
return;
}
// Security: Make sure the active user is a requester on the proper ticket
if (!isset($requesters[$active_user->id])) {
return;
}
// Set headers
header("Expires: Mon, 26 Nov 1962 00:00:00 GMT\n");
header("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT\n");
header("Cache-control: private\n");
header("Pragma: no-cache\n");
header("Content-Type: " . $attachment->mime_type . "\n");
header("Content-transfer-encoding: binary\n");
header("Content-Length: " . $attachment->getFileSize() . "\n");
// Dump contents
echo $attachment->getFileContents();
exit;
}
/**
* @return Model_WatcherMailFilter[]|false
*/
static function getMatches(CerberusTicket $ticket, $event, $only_worker_id = null)
{
$matches = array();
if (!empty($only_worker_id)) {
$filters = DAO_WatcherMailFilter::getWhere(sprintf("%s = %d AND %s = %d", DAO_WatcherMailFilter::WORKER_ID, $only_worker_id, DAO_WatcherMailFilter::IS_DISABLED, 0));
} else {
$filters = DAO_WatcherMailFilter::getWhere(sprintf("%s = %d", DAO_WatcherMailFilter::IS_DISABLED, 0));
}
// [JAS]: Don't send obvious spam to watchers.
if ($ticket->spam_score >= 0.9) {
return false;
}
// Build our objects
$ticket_from = DAO_Address::get($ticket->last_wrote_address_id);
$ticket_group_id = $ticket->team_id;
// [TODO] These expensive checks should only populate when needed
$messages = DAO_Ticket::getMessagesByTicket($ticket->id);
$message_headers = array();
if (empty($messages)) {
return false;
}
if (null != @($message_last = array_pop($messages))) {
/* @var $message_last CerberusMessage */
$message_headers = $message_last->getHeaders();
}
// Clear the rest of the message manifests
unset($messages);
$custom_fields = DAO_CustomField::getAll();
// Lazy load when needed on criteria basis
$ticket_field_values = null;
$address_field_values = null;
$org_field_values = null;
// Worker memberships (for checking permissions)
$workers = DAO_Worker::getAll();
$group_rosters = DAO_Group::getRosters();
// Check filters
if (is_array($filters)) {
foreach ($filters as $filter) {
/* @var $filter Model_WatcherMailFilter */
$passed = 0;
// check the worker's group memberships
if (!isset($workers[$filter->worker_id]) || $workers[$filter->worker_id]->is_disabled || !$workers[$filter->worker_id]->is_superuser && !isset($group_rosters[$ticket->team_id][$filter->worker_id])) {
// no membership
continue;
}
// check criteria
foreach ($filter->criteria as $rule_key => $rule) {
@($value = $rule['value']);
switch ($rule_key) {
case 'dayofweek':
$current_day = strftime('%w');
//$current_day = 1;
// Forced to English abbrevs as indexes
$days = array('sun', 'mon', 'tue', 'wed', 'thu', 'fri', 'sat');
// Is the current day enabled?
if (isset($rule[$days[$current_day]])) {
$passed++;
}
break;
case 'timeofday':
$current_hour = strftime('%H');
$current_min = strftime('%M');
//$current_hour = 17;
//$current_min = 5;
if (null != ($from_time = @$rule['from'])) {
list($from_hour, $from_min) = explode(':', $from_time);
}
if (null != ($to_time = @$rule['to'])) {
if (list($to_hour, $to_min) = explode(':', $to_time)) {
}
}
// Do we need to wrap around to the next day's hours?
if ($from_hour > $to_hour) {
// yes
$to_hour += 24;
// add 24 hrs to the destination (1am = 25th hour)
}
// Are we in the right 24 hourly range?
if ((int) $current_hour >= $from_hour && (int) $current_hour <= $to_hour) {
// If we're in the first hour, are we minutes early?
if ($current_hour == $from_hour && (int) $current_min < $from_min) {
break;
}
// If we're in the last hour, are we minutes late?
if ($current_hour == $to_hour && (int) $current_min > $to_min) {
break;
}
$passed++;
}
break;
case 'event':
if (!empty($event) && is_array($rule) && isset($rule[$event])) {
$passed++;
}
break;
case 'groups':
if (null !== @($group_buckets = $rule['groups'][$ticket->team_id]) && (empty($group_buckets) || in_array($ticket->category_id, $group_buckets))) {
$passed++;
}
break;
case 'next_worker_id':
// If it's an assigned event, we only care about the filter's owner
if (!empty($event) && 0 == strcasecmp($event, 'ticket_assignment')) {
if (intval($value) == intval($filter->worker_id)) {
$passed++;
break;
}
}
if (intval($value) == intval($ticket->next_worker_id)) {
$passed++;
}
break;
case 'mask':
$regexp_mask = DevblocksPlatform::strToRegExp($value);
if (@preg_match($regexp_mask, $ticket->mask)) {
$passed++;
}
break;
case 'from':
$regexp_from = DevblocksPlatform::strToRegExp($value);
if (@preg_match($regexp_from, $ticket_from->email)) {
$passed++;
}
break;
case 'subject':
$regexp_subject = DevblocksPlatform::strToRegExp($value);
if (@preg_match($regexp_subject, $ticket->subject)) {
$passed++;
}
break;
case 'body':
if (null == ($message_body = $message_last->getContent())) {
break;
}
// Line-by-line body scanning (sed-like)
$lines = preg_split("/[\r\n]/", $message_body);
if (is_array($lines)) {
foreach ($lines as $line) {
if (@preg_match($value, $line)) {
$passed++;
break;
}
}
}
break;
case 'header1':
case 'header2':
case 'header3':
case 'header4':
case 'header5':
@($header = strtolower($rule['header']));
if (empty($header)) {
$passed++;
break;
}
if (empty($value)) {
// we're checking for null/blanks
if (!isset($message_headers[$header]) || empty($message_headers[$header])) {
$passed++;
}
} elseif (isset($message_headers[$header]) && !empty($message_headers[$header])) {
$regexp_header = DevblocksPlatform::strToRegExp($value);
// Flatten CRLF
if (@preg_match($regexp_header, str_replace(array("\r", "\n"), ' ', $message_headers[$header]))) {
$passed++;
}
}
break;
default:
// ignore invalids
// Custom Fields
if (0 == strcasecmp('cf_', substr($rule_key, 0, 3))) {
$field_id = substr($rule_key, 3);
// Make sure it exists
if (null == @($field = $custom_fields[$field_id])) {
continue;
}
// Lazy values loader
$field_values = array();
switch ($field->source_extension) {
case ChCustomFieldSource_Address::ID:
if (null == $address_field_values) {
$address_field_values = array_shift(DAO_CustomFieldValue::getValuesBySourceIds(ChCustomFieldSource_Address::ID, $ticket_from->id));
}
$field_values =& $address_field_values;
break;
case ChCustomFieldSource_Org::ID:
if (null == $org_field_values) {
$org_field_values = array_shift(DAO_CustomFieldValue::getValuesBySourceIds(ChCustomFieldSource_Org::ID, $ticket_from->contact_org_id));
}
$field_values =& $org_field_values;
break;
case ChCustomFieldSource_Ticket::ID:
if (null == $ticket_field_values) {
$ticket_field_values = array_shift(DAO_CustomFieldValue::getValuesBySourceIds(ChCustomFieldSource_Ticket::ID, $ticket->id));
}
$field_values =& $ticket_field_values;
break;
}
// Type sensitive value comparisons
// [TODO] Operators
switch ($field->type) {
case 'S':
// string
// string
case 'T':
// clob
// clob
case 'U':
// URL
$field_val = isset($field_values[$field_id]) ? $field_values[$field_id] : '';
$oper = isset($rule['oper']) ? $rule['oper'] : "=";
if ($oper == "=" && @preg_match(DevblocksPlatform::strToRegExp($value, true), $field_val)) {
$passed++;
} elseif ($oper == "!=" && @(!preg_match(DevblocksPlatform::strToRegExp($value, true), $field_val))) {
$passed++;
}
break;
case 'N':
// number
$field_val = isset($field_values[$field_id]) ? $field_values[$field_id] : 0;
$oper = isset($rule['oper']) ? $rule['oper'] : "=";
if ($oper == "=" && intval($field_val) == intval($value)) {
$passed++;
} elseif ($oper == "!=" && intval($field_val) != intval($value)) {
$passed++;
} elseif ($oper == ">" && intval($field_val) > intval($value)) {
$passed++;
} elseif ($oper == "<" && intval($field_val) < intval($value)) {
$passed++;
}
break;
case 'E':
// date
$field_val = isset($field_values[$field_id]) ? intval($field_values[$field_id]) : 0;
$from = isset($rule['from']) ? $rule['from'] : "0";
$to = isset($rule['to']) ? $rule['to'] : "now";
if (intval(@strtotime($from)) <= $field_val && intval(@strtotime($to)) >= $field_val) {
$passed++;
}
break;
case 'C':
// checkbox
$field_val = isset($field_values[$field_id]) ? $field_values[$field_id] : 0;
if (intval($value) == intval($field_val)) {
$passed++;
}
break;
case 'D':
// dropdown
// dropdown
case 'X':
// multi-checkbox
// multi-checkbox
case 'M':
// multi-picklist
// multi-picklist
case 'W':
// worker
$field_val = isset($field_values[$field_id]) ? $field_values[$field_id] : array();
if (!is_array($value)) {
$value = array($value);
}
if (is_array($field_val)) {
// if multiple things set
foreach ($field_val as $v) {
// loop through possible
if (isset($value[$v])) {
// is any possible set?
$passed++;
break;
}
}
} else {
// single
if (isset($value[$field_val])) {
// is our set field in possibles?
$passed++;
break;
}
}
break;
}
}
break;
}
}
// If our rule matched every criteria, stop and return the filter
if ($passed == count($filter->criteria)) {
DAO_WatcherMailFilter::increment($filter->id);
// ++ the times we've matched
$matches[$filter->id] = $filter;
}
}
}
if (!empty($matches)) {
return $matches;
}
// No matches
return false;
}
function getSourceInfo($object_id)
{
if (null == ($ticket = DAO_Ticket::getTicket($object_id))) {
return;
}
$url = DevblocksPlatform::getUrlService();
return array('name' => '[Ticket] ' . $ticket->subject, 'url' => $url->write(sprintf('c=display&mask=%s&tab=tasks', $ticket->mask), true));
}
/**
* First we check the references and in-reply-to headers to find a
* historical match in the database. If those don't match we check
* the subject line for a mask (if one exists). If none of those
* options match we return null.
*
* @param array $headers
* @return array
*/
private static function findParentMessage($headers)
{
@($aSubject = $headers['subject']);
@($sMessageId = trim($headers['message-id']));
@($sInReplyTo = trim($headers['in-reply-to']));
@($sReferences = trim($headers['references']));
@($sThreadTopic = trim($headers['thread-topic']));
// [TODO] Could turn string comparisons into hashes here for simple equality checks
$aReferences = array();
// Add all References
if (!empty($sReferences)) {
if (preg_match("/(\\<.*?\\@.*?\\>)/", $sReferences, $matches)) {
unset($matches[0]);
// who cares about the pattern
foreach ($matches as $ref) {
$ref = trim($ref);
if (!empty($ref) && 0 != strcasecmp($ref, $sMessageId)) {
$aReferences[$ref] = 1;
}
}
}
}
unset($matches);
// Append first <*> from In-Reply-To
if (!empty($sInReplyTo)) {
if (preg_match("/(\\<.*?\\@.*?\\>)/", $sInReplyTo, $matches)) {
if (isset($matches[1])) {
// only use the first In-Reply-To
$ref = trim($matches[1]);
if (!empty($ref) && 0 != strcasecmp($ref, $sMessageId)) {
$aReferences[$ref] = 1;
}
}
}
}
// Try matching our references or in-reply-to
if (is_array($aReferences) && !empty($aReferences)) {
foreach (array_keys($aReferences) as $ref) {
if (empty($ref)) {
continue;
}
if (null != ($ids = DAO_Ticket::getTicketByMessageId($ref))) {
return $ids;
}
}
}
// Try matching the subject line
// [TODO] This should only happen if the destination has subject masks enabled
if (!is_array($aSubject)) {
$aSubject = array($aSubject);
}
foreach ($aSubject as $sSubject) {
if (preg_match("/.*\\[.*?\\#(.*?)\\].*/", $sSubject, $matches)) {
if (isset($matches[1])) {
$mask = $matches[1];
if (null != ($ticket = DAO_Ticket::getTicketByMask($mask))) {
return array('ticket_id' => intval($ticket->id), 'message_id' => intval($ticket->first_message_id));
}
}
}
}
return NULL;
}
function handleRequest(DevblocksHttpRequest $request)
{
$worker = CerberusApplication::getActiveWorker();
if (empty($worker)) {
return;
}
$stack = $request->path;
array_shift($stack);
// print
@($object = strtolower(array_shift($stack)));
// ticket|message|etc
$tpl = DevblocksPlatform::getTemplateService();
$tpl->assign('path', $this->_TPL_PATH);
$settings = DevblocksPlatform::getPluginSettingsService();
$tpl->assign('settings', $settings);
$translate = DevblocksPlatform::getTranslationService();
$tpl->assign('translate', $translate);
$teams = DAO_Group::getAll();
$tpl->assign('teams', $teams);
$buckets = DAO_Bucket::getAll();
$tpl->assign('buckets', $buckets);
$workers = DAO_Worker::getAll();
$tpl->assign('workers', $workers);
// Security
$active_worker = CerberusApplication::getActiveWorker();
$active_worker_memberships = $active_worker->getMemberships();
// [TODO] Make this pluggable
// Subcontroller
switch ($object) {
case 'ticket':
@($id = array_shift($stack));
@($ticket = is_numeric($id) ? DAO_Ticket::getTicket($id) : DAO_Ticket::getTicketByMask($id));
$convo_timeline = array();
$messages = $ticket->getMessages();
foreach ($messages as $message_id => $message) {
/* @var $message CerberusMessage */
$key = $message->created_date . '_m' . $message_id;
// build a chrono index of messages
$convo_timeline[$key] = array('m', $message_id);
}
@($mail_inline_comments = DAO_WorkerPref::get($active_worker->id, 'mail_inline_comments', 1));
if ($mail_inline_comments) {
// if inline comments are enabled
$comments = DAO_TicketComment::getByTicketId($ticket->id);
arsort($comments);
$tpl->assign('comments', $comments);
// build a chrono index of comments
foreach ($comments as $comment_id => $comment) {
/* @var $comment Model_TicketComment */
$key = $comment->created . '_c' . $comment_id;
$convo_timeline[$key] = array('c', $comment_id);
}
}
ksort($convo_timeline);
$tpl->assign('convo_timeline', $convo_timeline);
// Comment parent addresses
$comment_addresses = array();
foreach ($comments as $comment) {
/* @var $comment Model_TicketComment */
$address_id = intval($comment->address_id);
if (!isset($comment_addresses[$address_id])) {
$address = DAO_Address::get($address_id);
$comment_addresses[$address_id] = $address;
}
}
$tpl->assign('comment_addresses', $comment_addresses);
// Message Notes
$notes = DAO_MessageNote::getByTicketId($ticket->id);
$message_notes = array();
// Index notes by message id
if (is_array($notes)) {
foreach ($notes as $note) {
if (!isset($message_notes[$note->message_id])) {
$message_notes[$note->message_id] = array();
}
$message_notes[$note->message_id][$note->id] = $note;
}
}
$tpl->assign('message_notes', $message_notes);
// Make sure we're allowed to view this ticket or message
if (!isset($active_worker_memberships[$ticket->team_id])) {
echo "<H1>" . $translate->_('common.access_denied') . "</H1>";
return;
}
$tpl->assign('ticket', $ticket);
$tpl->display('file:' . $this->_TPL_PATH . 'print/ticket.tpl');
break;
case 'message':
@($id = array_shift($stack));
@($message = DAO_Ticket::getMessage($id));
@($ticket = DAO_Ticket::getTicket($message->ticket_id));
// Make sure we're allowed to view this ticket or message
if (!isset($active_worker_memberships[$ticket->team_id])) {
echo "<H1>" . $translate->_('common.access_denied') . "</H1>";
return;
}
// Message Notes
$notes = DAO_MessageNote::getByTicketId($ticket->id);
$message_notes = array();
// Index notes by message id
if (is_array($notes)) {
foreach ($notes as $note) {
if (!isset($message_notes[$note->message_id])) {
$message_notes[$note->message_id] = array();
}
$message_notes[$note->message_id][$note->id] = $note;
}
}
$tpl->assign('message_notes', $message_notes);
$tpl->assign('message', $message);
$tpl->assign('ticket', $ticket);
$tpl->display('file:' . $this->_TPL_PATH . 'print/message.tpl');
break;
}
}
private function mergeTicket($event)
{
// Listen for ticket merges and update our internal ticket_id records
@($new_ticket_id = $event->params['new_ticket_id']);
@($old_ticket_ids = $event->params['old_ticket_ids']);
$translate = DevblocksPlatform::getTranslationService();
if (empty($new_ticket_id) || empty($old_ticket_ids)) {
return;
}
$settings = DevblocksPlatform::getPluginSettingsService();
$al_merge_enabled = intval($settings->get('cerb5blog.last_action_and_audit_log', 'al_merge_enabled', 0));
$uf_merge_enabled = intval($settings->get('cerb5blog.last_action_and_audit_log', 'uf_merge_enabled', 0));
if (!($al_merge_enabled || $uf_merge_enabled)) {
return;
}
$active_worker = CerberusApplication::getActiveWorker();
$worker_id = $active_worker->id;
if (class_exists('DAO_TicketAuditLog', true)) {
if ($al_merge_enabled) {
foreach ($old_ticket_ids as $old_id) {
$old_ticket = DAO_Ticket::get($old_id);
$translate_str = $translate->_('cerb5blog.last_action_and_audit_log.post.merge.new_ticket');
$translated = sprintf($translate_str, $old_id, $old_ticket->mask);
$fields = array(DAO_TicketAuditLog::TICKET_ID => $new_ticket_id, DAO_TicketAuditLog::WORKER_ID => $worker_id, DAO_TicketAuditLog::CHANGE_DATE => time(), DAO_TicketAuditLog::CHANGE_FIELD => "cerb5blog.last_action_and_audit_log.type.merge", DAO_TicketAuditLog::CHANGE_VALUE => substr($translated, 0, 128));
$log_id = DAO_TicketAuditLog::create($fields);
}
unset($fields);
}
}
if ($uf_merge_enabled) {
$new_change_fields[DAO_Ticket::UPDATED_DATE] = time();
DAO_Ticket::update($new_ticket_id, $new_change_fields);
unset($new_change_fields);
}
}
private function _sendForwards($event, $is_inbound)
{
@($ticket_id = $event->params['ticket_id']);
@($message_id = $event->params['message_id']);
@($send_worker_id = $event->params['worker_id']);
$ticket = DAO_Ticket::getTicket($ticket_id);
$helpdesk_senders = CerberusApplication::getHelpdeskSenders();
$workers = DAO_Worker::getAllActive();
// [JAS]: Don't send obvious spam to watchers.
if ($ticket->spam_score >= 0.9) {
return true;
}
@($notifications = DAO_WorkerMailForward::getWhere(sprintf("%s = %d", DAO_WorkerMailForward::GROUP_ID, $ticket->team_id)));
// Bail out early if we have no forwards for this group
if (empty($notifications)) {
return;
}
$message = DAO_Ticket::getMessage($message_id);
$headers = $message->getHeaders();
// The whole flipping Swift section needs wrapped to catch exceptions
try {
$settings = CerberusSettings::getInstance();
$reply_to = $settings->get(CerberusSettings::DEFAULT_REPLY_FROM, '');
// See if we need a group-specific reply-to
if (!empty($ticket->team_id)) {
@($group_from = DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_REPLY_FROM, ''));
if (!empty($group_from)) {
$reply_to = $group_from;
}
}
$sender = DAO_Address::get($message->address_id);
$sender_email = strtolower($sender->email);
$sender_split = explode('@', $sender_email);
if (!is_array($sender_split) || count($sender_split) != 2) {
return;
}
// If return-path is blank
if (isset($headers['return-path']) && $headers['return-path'] == '<>') {
return;
}
// Ignore bounces
if ($sender_split[1] == "postmaster" || $sender_split[1] == "mailer-daemon") {
return;
}
// Ignore autoresponses autoresponses
if (isset($headers['auto-submitted']) && $headers['auto-submitted'] != 'no') {
return;
}
// Headers
//==========
// Build mailing list
$send_to = array();
foreach ($notifications as $n) {
/* @var $n Model_WorkerMailForward */
if (!isset($n->group_id) || !isset($n->bucket_id)) {
continue;
}
// if worker no longer exists or is disabled
if (!isset($workers[$n->worker_id])) {
continue;
}
// Don't allow a worker to usurp a helpdesk address
if (isset($helpdesk_senders[$n->email])) {
continue;
}
if ($n->group_id == $ticket->team_id && ($n->bucket_id == -1 || $n->bucket_id == $ticket->category_id)) {
// Event checking
if ($is_inbound && ($n->event == 'i' || $n->event == 'io') || !$is_inbound && ($n->event == 'o' || $n->event == 'io') || $is_inbound && $n->event == 'r' && $ticket->next_worker_id == $n->worker_id) {
$send_to[$n->email] = true;
}
}
}
// Attachments
$attachments = $message->getAttachments();
$mime_attachments = array();
if (is_array($attachments)) {
foreach ($attachments as $attachment) {
if (0 == strcasecmp($attachment->display_name, 'original_message.html')) {
continue;
}
$attachment_path = APP_STORAGE_PATH . '/attachments/';
// [TODO] This is highly redundant in the codebase
if (!file_exists($attachment_path . $attachment->filepath)) {
continue;
}
$file =& new Swift_File($attachment_path . $attachment->filepath);
$mime_attachments[] =& new Swift_Message_Attachment($file, $attachment->display_name, $attachment->mime_type);
}
}
// Send copies
if (is_array($send_to) && !empty($send_to)) {
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
foreach ($send_to as $to => $bool) {
// Proxy the message
$rcpt_to = new Swift_RecipientList();
$a_rcpt_to = array();
$mail_from = new Swift_Address($sender->email);
$rcpt_to->addTo($to);
$a_rcpt_to = new Swift_Address($to);
$mail = $mail_service->createMessage();
/* @var $mail Swift_Message */
$mail->setTo($a_rcpt_to);
$mail->setFrom($mail_from);
$mail->setReplyTo($reply_to);
$mail->setReturnPath($reply_to);
$mail->setSubject(sprintf("[%s #%s]: %s", $is_inbound ? 'inbound' : 'outbound', $ticket->mask, $ticket->subject));
if (false !== @($msgid = $headers['message-id'])) {
$mail->headers->set('Message-Id', $msgid);
}
if (false !== @($in_reply_to = $headers['in-reply-to'])) {
$mail->headers->set('References', $in_reply_to);
$mail->headers->set('In-Reply-To', $in_reply_to);
}
$mail->headers->set('X-Mailer', 'Cerberus Helpdesk (Build ' . APP_BUILD . ')');
$mail->headers->set('Precedence', 'List');
$mail->headers->set('Auto-Submitted', 'auto-generated');
$mail->attach(new Swift_Message_Part($message->getContent(), 'text/plain', 'base64', LANG_CHARSET_CODE));
// Send message attachments with watcher
if (is_array($mime_attachments)) {
foreach ($mime_attachments as $mime_attachment) {
$mail->attach($mime_attachment);
}
}
$mailer->send($mail, $rcpt_to, $mail_from);
}
}
} catch (Exception $e) {
$fields = array(DAO_MessageNote::MESSAGE_ID => $message_id, DAO_MessageNote::CREATED => time(), DAO_MessageNote::WORKER_ID => 0, DAO_MessageNote::CONTENT => 'Exception thrown while sending watcher email: ' . $e->getMessage(), DAO_MessageNote::TYPE => Model_MessageNote::TYPE_ERROR);
DAO_MessageNote::create($fields);
}
}
function showBatchPanelAction()
{
@($ids = DevblocksPlatform::importGPC($_REQUEST['ids']));
@($view_id = DevblocksPlatform::importGPC($_REQUEST['view_id']));
$tpl = DevblocksPlatform::getTemplateService();
$tpl->assign('path', $this->_TPL_PATH);
$tpl->assign('view_id', $view_id);
$unique_sender_ids = array();
$unique_subjects = array();
if (!empty($ids)) {
$ticket_ids = DevblocksPlatform::parseCsvString($ids);
if (empty($ticket_ids)) {
break;
}
$tickets = DAO_Ticket::getTickets($ticket_ids);
if (is_array($tickets)) {
foreach ($tickets as $ticket) {
/* @var $ticket CerberusTicket */
$ptr =& $unique_sender_ids[$ticket->first_wrote_address_id];
$ptr = intval($ptr) + 1;
$ptr =& $unique_subjects[$ticket->subject];
$ptr = intval($ptr) + 1;
}
}
arsort($unique_subjects);
// sort by occurrences
$senders = DAO_Address::getWhere(sprintf("%s IN (%s)", DAO_Address::ID, implode(',', array_keys($unique_sender_ids))));
foreach ($senders as $sender) {
$ptr =& $unique_senders[$sender->email];
$ptr = intval($ptr) + 1;
}
arsort($unique_senders);
unset($senders);
unset($unique_sender_ids);
@$tpl->assign('ticket_ids', $ticket_ids);
@$tpl->assign('unique_senders', $unique_senders);
@$tpl->assign('unique_subjects', $unique_subjects);
}
// Teams
$teams = DAO_Group::getAll();
$tpl->assign('teams', $teams);
// Categories
$team_categories = DAO_Bucket::getTeams();
// [TODO] Cache these
$tpl->assign('team_categories', $team_categories);
$workers = DAO_Worker::getAllActive();
$tpl->assign('workers', $workers);
// Custom Fields
$custom_fields = DAO_CustomField::getBySource(ChCustomFieldSource_Ticket::ID);
$tpl->assign('custom_fields', $custom_fields);
$tpl->display('file:' . $this->_TPL_PATH . 'tickets/rpc/batch_panel.tpl');
}
static function sendTicketMessage($properties = array())
{
$settings = DevblocksPlatform::getPluginSettingsService();
$helpdesk_senders = CerberusApplication::getHelpdeskSenders();
@($from_addy = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, $_SERVER['SERVER_ADMIN']));
@($from_personal = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL, ''));
// [TODO] If we still don't have a $from_addy we need a graceful failure.
/*
* [TODO] Move these into constants?
'message_id'
-----'ticket_id'
'subject'
'to'
'cc'
'bcc'
'content'
'files'
'closed'
'ticket_reopen'
'unlock_date'
'bucket_id'
'agent_id',
'is_autoreply',
'dont_send',
'dont_save_copy'
*/
$mail_succeeded = true;
try {
// objects
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
$mail = $mail_service->createMessage();
// properties
@($reply_message_id = $properties['message_id']);
@($content = $properties['content']);
@($files = $properties['files']);
@($forward_files = $properties['forward_files']);
@($worker_id = $properties['agent_id']);
@($subject = $properties['subject']);
$message = DAO_Ticket::getMessage($reply_message_id);
$message_headers = DAO_MessageHeader::getAll($reply_message_id);
$ticket_id = $message->ticket_id;
$ticket = DAO_Ticket::getTicket($ticket_id);
// [TODO] Check that message|ticket isn't NULL
// If this ticket isn't spam trained and our outgoing message isn't an autoreply
if ($ticket->spam_training == CerberusTicketSpamTraining::BLANK && (!isset($properties['is_autoreply']) || !$properties['is_autoreply'])) {
CerberusBayes::markTicketAsNotSpam($ticket_id);
}
// Allow teams to override the default from/personal
@($group_reply = DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_REPLY_FROM, ''));
@($group_personal = DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_REPLY_PERSONAL, ''));
@($group_personal_with_worker = DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_REPLY_PERSONAL_WITH_WORKER, 0));
if (!empty($group_reply)) {
$from_addy = $group_reply;
}
if (!empty($group_personal)) {
$from_personal = $group_personal;
}
// Prefix the worker name on the personal line?
if (!empty($group_personal_with_worker) && null != ($reply_worker = DAO_Worker::getAgent($worker_id))) {
$from_personal = $reply_worker->getName() . (!empty($from_personal) ? ', ' . $from_personal : "");
}
// Headers
$mail->setFrom(array($from_addy => $from_personal));
$mail->generateId();
$headers = $mail->getHeaders();
$headers->addTextHeader('X-Mailer', 'Cerberus Helpdesk (Build ' . APP_BUILD . ')');
// Subject
if (empty($subject)) {
$subject = $ticket->subject;
}
if (!empty($properties['to'])) {
// forward
$mail->setSubject($subject);
} else {
// reply
@($group_has_subject = intval(DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_SUBJECT_HAS_MASK, 0)));
@($group_subject_prefix = DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_SUBJECT_PREFIX, ''));
$prefix = sprintf("[%s#%s] ", !empty($group_subject_prefix) ? $group_subject_prefix . ' ' : '', $ticket->mask);
$mail->setSubject(sprintf('Re: %s%s', $group_has_subject ? $prefix : '', $subject));
}
// References
if (!empty($message) && false !== @($in_reply_to = $message_headers['message-id'])) {
$headers->addTextHeader('References', $in_reply_to);
$headers->addTextHeader('In-Reply-To', $in_reply_to);
}
// Auto-reply handling (RFC-3834 compliant)
if (isset($properties['is_autoreply']) && $properties['is_autoreply']) {
$headers->addTextHeader('Auto-Submitted', 'auto-replied');
if (null == ($first_address = DAO_Address::get($ticket->first_wrote_address_id))) {
return;
}
// Don't send e-mail to ourselves
if (isset($helpdesk_senders[$first_address->email])) {
return;
}
// Make sure we haven't mailed this address an autoreply within 5 minutes
if ($first_address->last_autoreply > 0 && $first_address->last_autoreply > time() - 300) {
return;
}
$first_email = strtolower($first_address->email);
$first_split = explode('@', $first_email);
if (!is_array($first_split) || count($first_split) != 2) {
return;
}
// If return-path is blank
if (isset($message_headers['return-path']) && $message_headers['return-path'] == '<>') {
return;
}
// Ignore bounces
if ($first_split[0] == "postmaster" || $first_split[0] == "mailer-daemon") {
return;
}
// Ignore autoresponses to autoresponses
if (isset($message_headers['auto-submitted']) && $message_headers['auto-submitted'] != 'no') {
return;
}
if (isset($message_headers['precedence']) && ($message_headers['precedence'] == 'list' || $message_headers['precedence'] == 'junk' || ($message_headers['precedence'] = 'bulk'))) {
return;
}
// Set the auto-reply date for this address to right now
DAO_Address::update($ticket->first_wrote_address_id, array(DAO_Address::LAST_AUTOREPLY => time()));
// Auto-reply just to the initial requester
$mail->addTo($first_address->email);
// Not an auto-reply
} else {
// Forwards
if (!empty($properties['to'])) {
$aTo = DevblocksPlatform::parseCsvString(str_replace(';', ',', $properties['to']));
if (is_array($aTo)) {
foreach ($aTo as $to_addy) {
$mail->addTo($to_addy);
}
}
// Replies
} else {
// Recipients
$requesters = DAO_Ticket::getRequestersByTicket($ticket_id);
if (is_array($requesters)) {
foreach ($requesters as $requester) {
/* @var $requester Model_Address */
$mail->addTo($requester->email);
}
}
}
// Ccs
if (!empty($properties['cc'])) {
$aCc = DevblocksPlatform::parseCsvString(str_replace(';', ',', $properties['cc']));
$mail->setCc($aCc);
}
// Bccs
if (!empty($properties['bcc'])) {
$aBcc = DevblocksPlatform::parseCsvString(str_replace(';', ',', $properties['bcc']));
$mail->setBcc($aBcc);
}
}
/*
* [IMPORTANT -- Yes, this is simply a line in the sand.]
* You're welcome to modify the code to meet your needs, but please respect
* our licensing. Buy a legitimate copy to help support the project!
* http://www.cerberusweb.com/
*/
$license = CerberusLicense::getInstance();
if (empty($license) || @empty($license['serial'])) {
$content .= base64_decode("DQoNCi0tLQ0KQ29tYmF0IHNwYW0gYW5kIGltcHJvdmUgcmVzc" . "G9uc2UgdGltZXMgd2l0aCBDZXJiZXJ1cyBIZWxwZGVzayA0LjAhDQpodHRwOi8vd3d3LmNlc" . "mJlcnVzd2ViLmNvbS8NCg");
}
// Body
$mail->setBody($content);
// Mime Attachments
if (is_array($files) && !empty($files)) {
foreach ($files['tmp_name'] as $idx => $file) {
if (empty($file) || empty($files['name'][$idx])) {
continue;
}
$mail->attach(Swift_Attachment::fromPath($file)->setFilename($files['name'][$idx]));
}
}
// Forward Attachments
if (!empty($forward_files) && is_array($forward_files)) {
$attachments_path = APP_STORAGE_PATH . '/attachments/';
foreach ($forward_files as $file_id) {
$attachment = DAO_Attachment::get($file_id);
$attachment_path = $attachments_path . $attachment->filepath;
$mail->attach(Swift_Attachment::fromPath($attachment_path)->setFilename($attachment->display_name));
}
}
if (!DEMO_MODE) {
// If we're not supposed to send
if (isset($properties['dont_send']) && $properties['dont_send']) {
// ...do nothing
} else {
// otherwise send
if (!$mailer->send($mail)) {
$mail_succeeded = false;
throw new Exception('Mail not sent.');
}
}
}
} catch (Exception $e) {
// tag failure, so we can add a note to the message later
$mail_succeeded = false;
}
// Handle post-mail actions
$change_fields = array();
$fromAddressInst = CerberusApplication::hashLookupAddress($from_addy, true);
$fromAddressId = $fromAddressInst->id;
if ((!isset($properties['dont_keep_copy']) || !$properties['dont_keep_copy']) && (!isset($properties['is_autoreply']) || !$properties['is_autoreply'])) {
$change_fields[DAO_Ticket::LAST_WROTE_ID] = $fromAddressId;
$change_fields[DAO_Ticket::UPDATED_DATE] = time();
if (!empty($worker_id)) {
$change_fields[DAO_Ticket::LAST_WORKER_ID] = $worker_id;
$change_fields[DAO_Ticket::LAST_ACTION_CODE] = CerberusTicketActionCode::TICKET_WORKER_REPLY;
}
// Only change the subject if not forwarding
if (!empty($subject) && empty($properties['to'])) {
$change_fields[DAO_Ticket::SUBJECT] = $subject;
}
$fields = array(DAO_Message::TICKET_ID => $ticket_id, DAO_Message::CREATED_DATE => time(), DAO_Message::ADDRESS_ID => $fromAddressId, DAO_Message::IS_OUTGOING => 1, DAO_Message::WORKER_ID => !empty($worker_id) ? $worker_id : 0);
$message_id = DAO_Message::create($fields);
// Content
DAO_MessageContent::create($message_id, $content);
$headers = $mail->getHeaders();
// Headers
foreach ($headers->getAll() as $hdr) {
if (null != ($hdr_val = $hdr->getFieldBody())) {
if (!empty($hdr_val)) {
DAO_MessageHeader::create($message_id, $hdr->getFieldName(), CerberusParser::fixQuotePrintableString($hdr_val));
}
}
}
// Attachments
if (is_array($files) && !empty($files)) {
$attachment_path = APP_STORAGE_PATH . '/attachments/';
reset($files);
foreach ($files['tmp_name'] as $idx => $file) {
if (empty($file) || empty($files['name'][$idx]) || !file_exists($file)) {
continue;
}
$fields = array(DAO_Attachment::MESSAGE_ID => $message_id, DAO_Attachment::DISPLAY_NAME => $files['name'][$idx], DAO_Attachment::MIME_TYPE => $files['type'][$idx], DAO_Attachment::FILE_SIZE => filesize($file));
$file_id = DAO_Attachment::create($fields);
$attachment_bucket = sprintf("%03d/", mt_rand(1, 100));
$attachment_file = $file_id;
if (!file_exists($attachment_path . $attachment_bucket)) {
mkdir($attachment_path . $attachment_bucket, 0775, true);
}
if (!is_writeable($attachment_path . $attachment_bucket)) {
echo "Can't write to bucket " . $attachment_path . $attachment_bucket . "<BR>";
}
copy($file, $attachment_path . $attachment_bucket . $attachment_file);
@unlink($file);
DAO_Attachment::update($file_id, array(DAO_Attachment::FILEPATH => $attachment_bucket . $attachment_file));
}
}
// add note to message if email failed
if ($mail_succeeded === false) {
$fields = array(DAO_MessageNote::MESSAGE_ID => $message_id, DAO_MessageNote::CREATED => time(), DAO_MessageNote::WORKER_ID => 0, DAO_MessageNote::CONTENT => 'Exception thrown while sending email: ' . $e->getMessage(), DAO_MessageNote::TYPE => Model_MessageNote::TYPE_ERROR);
DAO_MessageNote::create($fields);
}
}
// Post-Reply Change Properties
if (isset($properties['closed'])) {
switch ($properties['closed']) {
case 0:
// open
$change_fields[DAO_Ticket::IS_WAITING] = 0;
$change_fields[DAO_Ticket::IS_CLOSED] = 0;
$change_fields[DAO_Ticket::IS_DELETED] = 0;
$change_fields[DAO_Ticket::DUE_DATE] = 0;
break;
case 1:
// closed
$change_fields[DAO_Ticket::IS_WAITING] = 0;
$change_fields[DAO_Ticket::IS_CLOSED] = 1;
$change_fields[DAO_Ticket::IS_DELETED] = 0;
if (isset($properties['ticket_reopen'])) {
@($time = intval(strtotime($properties['ticket_reopen'])));
$change_fields[DAO_Ticket::DUE_DATE] = $time;
}
break;
case 2:
// waiting
$change_fields[DAO_Ticket::IS_WAITING] = 1;
$change_fields[DAO_Ticket::IS_CLOSED] = 0;
$change_fields[DAO_Ticket::IS_DELETED] = 0;
if (isset($properties['ticket_reopen'])) {
@($time = intval(strtotime($properties['ticket_reopen'])));
$change_fields[DAO_Ticket::DUE_DATE] = $time;
}
break;
}
}
// Who should handle the followup?
if (isset($properties['next_worker_id'])) {
$change_fields[DAO_Ticket::NEXT_WORKER_ID] = $properties['next_worker_id'];
}
// Allow anybody to reply after
if (isset($properties['unlock_date']) && !empty($properties['unlock_date'])) {
$unlock = strtotime($properties['unlock_date']);
if (intval($unlock) > 0) {
$change_fields[DAO_Ticket::UNLOCK_DATE] = $unlock;
}
}
// Move
if (!empty($properties['bucket_id'])) {
// [TODO] Use API to move, or fire event
// [TODO] Ensure team/bucket exist
list($team_id, $bucket_id) = CerberusApplication::translateTeamCategoryCode($properties['bucket_id']);
$change_fields[DAO_Ticket::TEAM_ID] = $team_id;
$change_fields[DAO_Ticket::CATEGORY_ID] = $bucket_id;
}
if (!empty($ticket_id) && !empty($change_fields)) {
DAO_Ticket::updateTicket($ticket_id, $change_fields);
}
// Outbound Reply Event (not automated reply, etc.)
if (!empty($worker_id)) {
$eventMgr = DevblocksPlatform::getEventService();
$eventMgr->trigger(new Model_DevblocksEvent('ticket.reply.outbound', array('ticket_id' => $ticket_id, 'worker_id' => $worker_id)));
}
}
function run($message_id, $template)
{
if (!empty($message_id)) {
$message = DAO_Ticket::getMessage($message_id);
$fields = DAO_CustomField::getBySource(ChCustomFieldSource_Ticket::ID);
$custom_fields = DAO_CustomFieldValue::getValuesBySourceIds(ChCustomFieldSource_Ticket::ID, $message->ticket_id);
foreach ($fields as $field_id => $field) {
if ($field->group_id == 0) {
$template = str_replace(array('#cf_ticket_' . $field->name . '#'), array($custom_fields[$message->ticket_id][$field->id]), $template);
}
}
}
return;
}
function writeResponse(DevblocksHttpResponse $response)
{
$tpl = DevblocksPlatform::getTemplateService();
$tpl_path = dirname(dirname(__FILE__)) . '/templates/';
$theme = DAO_CommunityToolProperty::get($this->getPortal(), UmScApp::PARAM_THEME, UmScApp::DEFAULT_THEME);
if (!is_dir($tpl_path . 'portal/sc/themes/' . $theme)) {
$theme = UmScApp::DEFAULT_THEME;
}
$umsession = $this->getSession();
$active_user = $umsession->getProperty('sc_login', null);
$stack = $response->path;
@($module = array_shift($stack));
switch ($module) {
default:
case 'home':
$sHomeRss = DAO_CommunityToolProperty::get($this->getPortal(), UmScApp::PARAM_HOME_RSS, '');
$aHomeRss = !empty($sHomeRss) ? unserialize($sHomeRss) : array();
$feeds = array();
// [TODO] Implement a feed cache so we aren't bombing out
foreach ($aHomeRss as $title => $url) {
$feed = null;
try {
$feed = Zend_Feed::import($url);
} catch (Exception $e) {
}
if (!empty($feed) && $feed->count()) {
$feeds[] = array('name' => $title, 'feed' => $feed);
}
}
$tpl->assign('feeds', $feeds);
$tpl->display("file:{$tpl_path}portal/sc/internal/home/index.tpl");
break;
case 'account':
if (!$this->allow_logins || empty($active_user)) {
break;
}
$address = DAO_Address::get($active_user->id);
$tpl->assign('address', $address);
$tpl->display("file:{$tpl_path}portal/sc/internal/account/index.tpl");
break;
case 'kb':
// KB Roots
$sKbRoots = DAO_CommunityToolProperty::get($this->getPortal(), UmScApp::PARAM_KB_ROOTS, '');
$kb_roots = !empty($sKbRoots) ? unserialize($sKbRoots) : array();
$kb_roots_str = '0';
if (!empty($kb_roots)) {
$kb_roots_str = implode(',', array_keys($kb_roots));
}
switch (array_shift($stack)) {
case 'article':
if (empty($kb_roots)) {
return;
}
$id = intval(array_shift($stack));
list($articles, $count) = DAO_KbArticle::search(array(new DevblocksSearchCriteria(SearchFields_KbArticle::ID, '=', $id), new DevblocksSearchCriteria(SearchFields_KbArticle::TOP_CATEGORY_ID, 'in', array_keys($kb_roots))), -1, 0, null, null, false);
if (!isset($articles[$id])) {
break;
}
$article = DAO_KbArticle::get($id);
$tpl->assign('article', $article);
@($article_list = $umsession->getProperty(UmScApp::SESSION_ARTICLE_LIST, array()));
if (!empty($article) && !isset($article_list[$id])) {
DAO_KbArticle::update($article->id, array(DAO_KbArticle::VIEWS => ++$article->views));
$article_list[$id] = $id;
$umsession->setProperty(UmScApp::SESSION_ARTICLE_LIST, $article_list);
}
$categories = DAO_KbCategory::getWhere();
$tpl->assign('categories', $categories);
$cats = DAO_KbArticle::getCategoriesByArticleId($id);
$breadcrumbs = array();
foreach ($cats as $cat_id) {
if (!isset($breadcrumbs[$cat_id])) {
$breadcrumbs[$cat_id] = array();
}
$pid = $cat_id;
while ($pid) {
$breadcrumbs[$cat_id][] = $pid;
$pid = $categories[$pid]->parent_id;
}
$breadcrumbs[$cat_id] = array_reverse($breadcrumbs[$cat_id]);
// Remove any breadcrumbs not in this SC profile
$pid = reset($breadcrumbs[$cat_id]);
if (!isset($kb_roots[$pid])) {
unset($breadcrumbs[$cat_id]);
}
}
$tpl->assign('breadcrumbs', $breadcrumbs);
$tpl->display("file:{$tpl_path}portal/sc/internal/kb/article.tpl");
break;
default:
case 'browse':
@($root = intval(array_shift($stack)));
$tpl->assign('root_id', $root);
$categories = DAO_KbCategory::getWhere();
$tpl->assign('categories', $categories);
$tree_map = DAO_KbCategory::getTreeMap(0);
// Remove other top-level categories
if (is_array($tree_map[0])) {
foreach ($tree_map[0] as $child_id => $count) {
if (!isset($kb_roots[$child_id])) {
unset($tree_map[0][$child_id]);
}
}
}
// Remove empty categories
if (is_array($tree_map[0])) {
foreach ($tree_map as $node_id => $children) {
foreach ($children as $child_id => $count) {
if (empty($count)) {
@($pid = $categories[$child_id]->parent_id);
unset($tree_map[$pid][$child_id]);
unset($tree_map[$child_id]);
}
}
}
}
$tpl->assign('tree', $tree_map);
// Breadcrumb // [TODO] API-ize inside Model_KbTree ?
$breadcrumb = array();
$pid = $root;
while (0 != $pid) {
$breadcrumb[] = $pid;
$pid = $categories[$pid]->parent_id;
}
$tpl->assign('breadcrumb', array_reverse($breadcrumb));
$tpl->assign('mid', @intval(ceil(count($tree_map[$root]) / 2)));
// Articles
if (!empty($root)) {
list($articles, $count) = DAO_KbArticle::search(array(new DevblocksSearchCriteria(SearchFields_KbArticle::CATEGORY_ID, '=', $root), new DevblocksSearchCriteria(SearchFields_KbArticle::TOP_CATEGORY_ID, 'in', array_keys($kb_roots))), -1, 0, null, null, false);
}
$tpl->assign('articles', $articles);
$tpl->display("file:{$tpl_path}portal/sc/internal/kb/index.tpl");
break;
}
break;
case 'answers':
$query = rawurldecode(array_shift($stack));
$tpl->assign('query', $query);
$sFnrSources = DAO_CommunityToolProperty::get($this->getPortal(), UmScApp::PARAM_FNR_SOURCES, '');
$aFnrSources = !empty($sFnrSources) ? unserialize($sFnrSources) : array();
if (!empty($query)) {
// [JAS]: If we've been customized with specific sources, use them
$where = !empty($aFnrSources) ? sprintf("%s IN (%s)", DAO_FnrExternalResource::ID, implode(',', array_keys($aFnrSources))) : sprintf("%s IN (-1)", DAO_FnrExternalResource::ID);
$resources = DAO_FnrExternalResource::getWhere($where);
$feeds = Model_FnrExternalResource::searchResources($resources, $query);
$tpl->assign('feeds', $feeds);
$fields = array(DAO_FnrQuery::QUERY => $query, DAO_FnrQuery::CREATED => time(), DAO_FnrQuery::SOURCE => $this->getPortal(), DAO_FnrQuery::NO_MATCH => empty($feeds) ? 1 : 0);
DAO_FnrQuery::create($fields);
}
// KB
$sKbRoots = DAO_CommunityToolProperty::get($this->getPortal(), UmScApp::PARAM_KB_ROOTS, '');
$kb_roots = !empty($sKbRoots) ? unserialize($sKbRoots) : array();
list($articles, $count) = DAO_KbArticle::search(array(array(DevblocksSearchCriteria::GROUP_OR, new DevblocksSearchCriteria(SearchFields_KbArticle::TITLE, 'fulltext', $query), new DevblocksSearchCriteria(SearchFields_KbArticle::CONTENT, 'fulltext', $query)), new DevblocksSearchCriteria(SearchFields_KbArticle::TOP_CATEGORY_ID, 'in', array_keys($kb_roots))), 100, 0, null, null, true);
$tpl->assign('articles', $articles);
$tpl->display("file:{$tpl_path}portal/sc/internal/answers/index.tpl");
break;
case 'contact':
$response = array_shift($stack);
$settings = CerberusSettings::getInstance();
$default_from = $settings->get(CerberusSettings::DEFAULT_REPLY_FROM);
$tpl->assign('default_from', $default_from);
switch ($response) {
case 'confirm':
$tpl->assign('last_opened', $umsession->getProperty('support.write.last_opened', ''));
$tpl->display("file:{$tpl_path}portal/sc/internal/contact/confirm.tpl");
break;
default:
case 'step1':
$umsession->setProperty('support.write.last_error', null);
case 'step2':
$sFrom = $umsession->getProperty('support.write.last_from', '');
$sSubject = $umsession->getProperty('support.write.last_subject', '');
$sNature = $umsession->getProperty('support.write.last_nature', '');
$sContent = $umsession->getProperty('support.write.last_content', '');
// $aLastFollowupQ = $umsession->getProperty('support.write.last_followup_q','');
$aLastFollowupA = $umsession->getProperty('support.write.last_followup_a', '');
$sError = $umsession->getProperty('support.write.last_error', '');
$tpl->assign('last_from', $sFrom);
$tpl->assign('last_subject', $sSubject);
$tpl->assign('last_nature', $sNature);
$tpl->assign('last_content', $sContent);
// $tpl->assign('last_followup_q', $aLastFollowupQ);
$tpl->assign('last_followup_a', $aLastFollowupA);
$tpl->assign('last_error', $sError);
$sDispatch = DAO_CommunityToolProperty::get($this->getPortal(), UmScApp::PARAM_DISPATCH, '');
// $dispatch = !empty($sDispatch) ? (is_array($sDispatch) ? unserialize($sDispatch): array($sDispatch)) : array();
$dispatch = !empty($sDispatch) ? unserialize($sDispatch) : array();
$tpl->assign('dispatch', $dispatch);
switch ($response) {
default:
// If there's only one situation, skip to step2
if (1 == count($dispatch)) {
@($sNature = md5(key($dispatch)));
$umsession->setProperty('support.write.last_nature', $sNature);
reset($dispatch);
} else {
$tpl->display("file:{$tpl_path}portal/sc/internal/contact/step1.tpl");
break;
}
case 'step2':
// Cache along with answers?
if (is_array($dispatch)) {
foreach ($dispatch as $k => $v) {
if (md5($k) == $sNature) {
$umsession->setProperty('support.write.last_nature_string', $k);
$tpl->assign('situation', $k);
$tpl->assign('situation_params', $v);
break;
}
}
}
$ticket_fields = DAO_CustomField::getBySource('cerberusweb.fields.source.ticket');
$tpl->assign('ticket_fields', $ticket_fields);
$tpl->display("file:{$tpl_path}portal/sc/internal/contact/step2.tpl");
break;
}
break;
}
break;
// $tpl->display("file:${tpl_path}portal/sc/internal/contact/index.tpl");
// break;
// $tpl->display("file:${tpl_path}portal/sc/internal/contact/index.tpl");
// break;
case 'history':
if (!$this->allow_logins || empty($active_user)) {
break;
}
$mask = array_shift($stack);
if (empty($mask)) {
list($open_tickets) = DAO_Ticket::search(array(), array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_FIRST_WROTE_ID, '=', $active_user->id), new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_CLOSED, '=', 0)), -1, 0, SearchFields_Ticket::TICKET_UPDATED_DATE, false, false);
$tpl->assign('open_tickets', $open_tickets);
list($closed_tickets) = DAO_Ticket::search(array(), array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_FIRST_WROTE_ID, '=', $active_user->id), new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_CLOSED, '=', 1)), -1, 0, SearchFields_Ticket::TICKET_UPDATED_DATE, false, false);
$tpl->assign('closed_tickets', $closed_tickets);
$tpl->display("file:{$tpl_path}portal/sc/internal/history/index.tpl");
} else {
// Secure retrieval (address + mask)
list($tickets) = DAO_Ticket::search(array(), array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_MASK, '=', $mask), new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_FIRST_WROTE_ID, '=', $active_user->id)), 1, 0, null, null, false);
$ticket = array_shift($tickets);
// Security check (mask compare)
if (0 == strcasecmp($ticket[SearchFields_Ticket::TICKET_MASK], $mask)) {
$messages = DAO_Ticket::getMessagesByTicket($ticket[SearchFields_Ticket::TICKET_ID]);
$messages = array_reverse($messages, true);
$tpl->assign('ticket', $ticket);
$tpl->assign('messages', $messages);
$tpl->display("file:{$tpl_path}portal/sc/internal/history/display.tpl");
}
}
break;
case 'register':
if (!$this->allow_logins) {
break;
}
@($step = array_shift($stack));
switch ($step) {
case 'forgot':
$tpl->display("file:{$tpl_path}portal/sc/internal/register/forgot.tpl");
break;
case 'forgot2':
$tpl->display("file:{$tpl_path}portal/sc/internal/register/forgot_confirm.tpl");
break;
case 'confirm':
$tpl->display("file:{$tpl_path}portal/sc/internal/register/confirm.tpl");
break;
default:
$tpl->display("file:{$tpl_path}portal/sc/internal/register/index.tpl");
break;
}
break;
}
// print_r($response);
}
function showTab()
{
@($ticket_id = DevblocksPlatform::importGPC($_REQUEST['ticket_id'], 'integer', 0));
$tpl = DevblocksPlatform::getTemplateService();
$tpl_path = dirname(dirname(__FILE__)) . '/templates/';
$tpl->assign('path', $tpl_path);
$tpl->cache_lifetime = "0";
$ticket = DAO_Ticket::getTicket($ticket_id);
$tpl->assign('ticket_id', $ticket_id);
$address = DAO_Address::get($ticket->first_wrote_address_id);
$tpl->assign('address', $address);
if (null == ($view = C4_AbstractViewLoader::getView('', 'ticket_opps'))) {
$view = new C4_CrmOpportunityView();
$view->id = 'ticket_opps';
}
if (!empty($address->contact_org_id)) {
// org
@($org = DAO_ContactOrg::get($address->contact_org_id));
$view->name = "Org: " . $org->name;
$view->params = array(SearchFields_CrmOpportunity::ORG_ID => new DevblocksSearchCriteria(SearchFields_CrmOpportunity::ORG_ID, '=', $org->id));
} else {
// address
$view->name = "Requester: " . $address->email;
$view->params = array(SearchFields_CrmOpportunity::PRIMARY_EMAIL_ID => new DevblocksSearchCriteria(SearchFields_CrmOpportunity::PRIMARY_EMAIL_ID, '=', $ticket->first_wrote_address_id));
}
C4_AbstractViewLoader::setView($view->id, $view);
$tpl->assign('view', $view);
$tpl->display('file:' . $tpl_path . 'crm/opps/ticket/tab.tpl');
}
static function merge($ids = array())
{
if (!is_array($ids) || empty($ids) || count($ids) < 2) {
return false;
}
$db = DevblocksPlatform::getDatabaseService();
list($merged_tickets, $null) = self::search(array(), array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_ID, DevblocksSearchCriteria::OPER_IN, $ids)), 50, 0, SearchFields_Ticket::TICKET_CREATED_DATE, true, false);
// Merge the rest of the tickets into the oldest
if (is_array($merged_tickets)) {
list($oldest_id, $oldest_ticket) = each($merged_tickets);
unset($merged_tickets[$oldest_id]);
$merge_ticket_ids = array_keys($merged_tickets);
if (empty($oldest_id) || empty($merge_ticket_ids)) {
return null;
}
// Messages
$sql = sprintf("UPDATE message SET ticket_id = %d WHERE ticket_id IN (%s)", $oldest_id, implode(',', $merge_ticket_ids));
$db->Execute($sql);
// Message headers
$sql = sprintf("UPDATE message_header SET ticket_id = %d WHERE ticket_id IN (%s)", $oldest_id, implode(',', $merge_ticket_ids));
$db->Execute($sql);
// Requesters (merge)
$sql = sprintf("INSERT IGNORE INTO requester (address_id,ticket_id) " . "SELECT address_id, %d FROM requester WHERE ticket_id IN (%s)", $oldest_id, implode(',', $merge_ticket_ids));
$db->Execute($sql);
$sql = sprintf("DELETE FROM requester WHERE ticket_id IN (%s)", implode(',', $merge_ticket_ids));
// Tasks
$sql = sprintf("UPDATE task SET source_id = %d WHERE source_extension = %s AND source_id IN (%s)", $oldest_id, $db->qstr('cerberusweb.tasks.ticket'), implode(',', $merge_ticket_ids));
$db->Execute($sql);
// Comments
$sql = sprintf("UPDATE ticket_comment SET ticket_id = %d WHERE ticket_id IN (%s)", $oldest_id, implode(',', $merge_ticket_ids));
$db->Execute($sql);
DAO_Ticket::updateTicket($merge_ticket_ids, array(DAO_Ticket::IS_CLOSED => 1, DAO_Ticket::IS_DELETED => 1));
// Sort merge tickets by updated date ascending to find the latest touched
$tickets = $merged_tickets;
array_unshift($tickets, $oldest_ticket);
uasort($tickets, create_function('$a, $b', "return strcmp(\$a[SearchFields_Ticket::TICKET_UPDATED_DATE],\$b[SearchFields_Ticket::TICKET_UPDATED_DATE]);\n"));
$most_recent_updated_ticket = end($tickets);
// Set our destination ticket to the latest touched details
DAO_Ticket::updateTicket($oldest_id, array(DAO_Ticket::LAST_ACTION_CODE => $most_recent_updated_ticket[SearchFields_Ticket::TICKET_LAST_ACTION_CODE], DAO_Ticket::LAST_WROTE_ID => $most_recent_updated_ticket[SearchFields_Ticket::TICKET_LAST_WROTE_ID], DAO_Ticket::LAST_WORKER_ID => $most_recent_updated_ticket[SearchFields_Ticket::TICKET_LAST_WORKER_ID], DAO_Ticket::UPDATED_DATE => $most_recent_updated_ticket[SearchFields_Ticket::TICKET_UPDATED_DATE]));
// Set up forwarders for the old masks to their new mask
$new_mask = $oldest_ticket[SearchFields_Ticket::TICKET_MASK];
if (is_array($merged_tickets)) {
foreach ($merged_tickets as $ticket) {
// Forward the old mask to the new mask
$sql = sprintf("INSERT IGNORE INTO ticket_mask_forward (old_mask, new_mask, new_ticket_id) VALUES (%s, %s, %d)", $db->qstr($ticket[SearchFields_Ticket::TICKET_MASK]), $db->qstr($new_mask), $oldest_id);
$db->Execute($sql);
// If the old mask was a new_mask in a past life, change to its new destination
$sql = sprintf("UPDATE ticket_mask_forward SET new_mask = %s, new_ticket_id = %d WHERE new_mask = %s", $db->qstr($new_mask), $oldest_id, $db->qstr($ticket[SearchFields_Ticket::TICKET_MASK]));
$db->Execute($sql);
}
}
/*
* Notify anything that wants to know when tickets merge.
*/
$eventMgr = DevblocksPlatform::getEventService();
$eventMgr->trigger(new Model_DevblocksEvent('ticket.merge', array('new_ticket_id' => $oldest_id, 'old_ticket_ids' => $merge_ticket_ids)));
return $oldest_id;
}
}
static function calculateTicketSpamProbability($ticket_id, $readonly = false)
{
// pull up text of first ticket message
$messages = DAO_Ticket::getMessagesByTicket($ticket_id);
$first_message = array_shift($messages);
$ticket = DAO_Ticket::getTicket($ticket_id);
if (empty($ticket) || empty($first_message) || !$first_message instanceof CerberusMessage) {
return FALSE;
}
// Pass text to analyze() to get back interesting words
$content = '';
if (!empty($ticket->subject)) {
// SplitCamelCapsSubjects
$hits = preg_split("{(?<=[a-z])(?=[A-Z])}x", $ticket->subject);
if (is_array($hits) && !empty($hits)) {
$content .= implode(' ', $hits);
}
}
$content .= ' ' . $first_message->getContent();
// Only check the first 15000 characters for spam, rounded to a sentence
if (strlen($content) > self::MAX_BODY_LENGTH) {
$content = substr($content, 0, strrpos(substr($content, 0, self::MAX_BODY_LENGTH), ' '));
}
$words = self::processText($content);
$out = self::_calculateSpamProbability($words);
// Make a word list
$rawwords = array();
foreach ($out['words'] as $k => $v) {
/* @var $v CerberusBayesWord */
$rawwords[] = $v->word;
}
// Cache probability
if (!$readonly) {
$fields = array(DAO_Ticket::SPAM_SCORE => $out['probability'], DAO_Ticket::INTERESTING_WORDS => substr(implode(',', array_reverse($rawwords)), 0, 255));
DAO_Ticket::updateTicket($ticket_id, $fields);
}
return $out;
}
public function getRenderedContent($message_id)
{
$raw = $this->content;
$replace = array();
$with = array();
$replace[] = '#timestamp#';
$with[] = date('r');
if (!empty($message_id)) {
$message = DAO_Ticket::getMessage($message_id);
$ticket = DAO_Ticket::getTicket($message->ticket_id);
$sender = DAO_Address::get($message->address_id);
$sender_org = DAO_ContactOrg::get($sender->contact_org_id);
$replace[] = '#sender_first_name#';
$replace[] = '#sender_last_name#';
$replace[] = '#sender_org#';
$with[] = $sender->first_name;
$with[] = $sender->last_name;
$with[] = !empty($sender_org) ? $sender_org->name : "";
$replace[] = '#ticket_id#';
$replace[] = '#ticket_mask#';
$replace[] = '#ticket_subject#';
$with[] = $ticket->id;
$with[] = $ticket->mask;
$with[] = $ticket->subject;
}
if (null != ($active_worker = CerberusApplication::getActiveWorker())) {
$worker = DAO_Worker::getAgent($active_worker->id);
// most recent info (not session)
$replace[] = '#worker_first_name#';
$replace[] = '#worker_last_name#';
$replace[] = '#worker_title#';
$with[] = $worker->first_name;
$with[] = $worker->last_name;
$with[] = $worker->title;
}
return str_replace($replace, $with, $raw);
}
function saveRequestersPanelAction()
{
@($ticket_id = DevblocksPlatform::importGPC($_POST['ticket_id'], 'integer'));
@($msg_id = DevblocksPlatform::importGPC($_POST['msg_id'], 'integer'));
// Dels
@($req_deletes = DevblocksPlatform::importGPC($_POST['req_deletes'], 'array', array()));
if (!empty($req_deletes)) {
foreach ($req_deletes as $del_id) {
DAO_Ticket::deleteRequester($ticket_id, $del_id);
}
}
// Adds
@($req_adds = DevblocksPlatform::importGPC($_POST['req_adds'], 'string', ''));
$req_list = DevblocksPlatform::parseCrlfString($req_adds);
$req_addys = array();
if (is_array($req_list) && !empty($req_list)) {
foreach ($req_list as $req) {
if (empty($req)) {
continue;
}
$rfc_addys = imap_rfc822_parse_adrlist($req, 'localhost');
foreach ($rfc_addys as $rfc_addy) {
$addy = $rfc_addy->mailbox . '@' . $rfc_addy->host;
if (null != ($req_addy = CerberusApplication::hashLookupAddress($addy, true))) {
DAO_Ticket::createRequester($req_addy->id, $ticket_id);
}
}
}
}
$requesters = DAO_Ticket::getRequestersByTicket($ticket_id);
$list = array();
foreach ($requesters as $requester) {
$list[] = $requester->email;
}
echo implode(', ', $list);
exit;
}
private function _postSourceParseAction($path)
{
$xml_in = simplexml_load_string($this->getPayload());
@($source = (string) $xml_in->source);
if (empty($source)) {
$this->_error("No message source was provided.");
}
//echo("<pre>");print_r($source);echo("</pre>");exit();
$file = CerberusParser::saveMimeToFile($source);
$mime = mailparse_msg_parse_file($file);
$message = CerberusParser::parseMime($mime, $file);
mailparse_msg_free($mime);
@unlink($file);
$ticket_id = CerberusParser::parseMessage($message);
if (null != ($ticket = DAO_Ticket::getTicket($ticket_id))) {
// [TODO] Denote if ticket is new or reply?
$xml_out = new SimpleXMLElement("<ticket></ticket>");
$xml_out->addChild("id", $ticket_id);
$xml_out->addChild("mask", $ticket->mask);
$this->_render($xml_out->asXML());
} else {
$this->_error("Message could not be parsed.");
}
}
/**
* Looks up a ticket ID by the provided mask using a revolving cache.
* This is useful if you need to translate several ticket masks into
* IDs where there may be a lot of redundancy (batches in the e-mail
* parser, etc.)
*
* @param string $mask The ticket mask to look up
* @return integer The ticket id, or NULL if not found
*
* @todo [JAS]: Move this to a global cache/hash registry
*/
public static function hashLookupTicketIdByMask($mask)
{
static $hash_mask_to_id = array();
static $hash_hits = array();
static $hash_size = 0;
if (isset($hash_mask_to_id[$mask])) {
$return = $hash_mask_to_id[$mask];
@($hash_hits[$mask] = intval($hash_hits[$mask]) + 1);
$hash_size++;
// [JAS]: if our hash grows past our limit, crop hits array + intersect keys
if ($hash_size > 250) {
arsort($hash_hits);
$hash_hits = array_slice($hash_hits, 0, 100, true);
$hash_mask_to_id = array_intersect_key($hash_mask_to_id, $hash_hits);
$hash_size = count($hash_mask_to_id);
}
return $return;
}
$ticket_id = DAO_Ticket::getTicketIdByMask($mask);
if (!empty($ticket_id)) {
$hash_mask_to_id[$mask] = $ticket_id;
}
return $ticket_id;
}
function showAddressPeekAction()
{
@($id = DevblocksPlatform::importGPC($_REQUEST['id'], 'integer', ''));
@($address_id = DevblocksPlatform::importGPC($_REQUEST['address_id'], 'integer', 0));
@($email = DevblocksPlatform::importGPC($_REQUEST['email'], 'string', ''));
@($view_id = DevblocksPlatform::importGPC($_REQUEST['view_id'], 'string', ''));
@($org_id = DevblocksPlatform::importGPC($_REQUEST['org_id'], 'string', ''));
$tpl = DevblocksPlatform::getTemplateService();
$tpl->assign('path', $this->_TPL_PATH);
if (!empty($address_id)) {
$email = '';
if (null != ($addy = DAO_Address::get($address_id))) {
@($email = $addy->email);
}
}
$tpl->assign('email', $email);
if (!empty($email)) {
list($addresses, $null) = DAO_Address::search(array(), array(new DevblocksSearchCriteria(SearchFields_Address::EMAIL, DevblocksSearchCriteria::OPER_EQ, $email)), 1, 0, null, null, false);
$address = array_shift($addresses);
$tpl->assign('address', $address);
$id = $address[SearchFields_Address::ID];
list($open_tickets, $open_count) = DAO_Ticket::search(array(), array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_CLOSED, '=', 0), new DevblocksSearchCriteria(SearchFields_Ticket::REQUESTER_ID, '=', $address[SearchFields_Address::ID])), 1);
$tpl->assign('open_count', $open_count);
list($closed_tickets, $closed_count) = DAO_Ticket::search(array(), array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_CLOSED, '=', 1), new DevblocksSearchCriteria(SearchFields_Ticket::REQUESTER_ID, '=', $address[SearchFields_Address::ID])), 1);
$tpl->assign('closed_count', $closed_count);
}
if (!empty($org_id)) {
$org = DAO_ContactOrg::get($org_id);
$tpl->assign('org_name', $org->name);
$tpl->assign('org_id', $org->id);
}
// Custom fields
$custom_fields = DAO_CustomField::getBySource(ChCustomFieldSource_Address::ID);
$tpl->assign('custom_fields', $custom_fields);
$custom_field_values = DAO_CustomFieldValue::getValuesBySourceIds(ChCustomFieldSource_Address::ID, $id);
if (isset($custom_field_values[$id])) {
$tpl->assign('custom_field_values', $custom_field_values[$id]);
}
$types = Model_CustomField::getTypes();
$tpl->assign('types', $types);
// Display
$tpl->assign('id', $id);
$tpl->assign('view_id', $view_id);
$tpl->display('file:' . $this->_TPL_PATH . 'contacts/addresses/address_peek.tpl');
}
private function _handleImportComment($xml)
{
$mask = (string) $xml->mask;
$author_email = (string) $xml->author_email;
$note = trim((string) $xml->note);
$created = intval((string) $xml->created_date);
$author_address = CerberusApplication::hashLookupAddress($author_email, true);
// Bad file
if (empty($note) || empty($author_address) || empty($mask)) {
return false;
}
// echo "MASK: ",$mask,"<BR>";
// echo " -- Author: ",$author_address->email,"<BR>";
// echo " -- Note: ",$note,"<BR>";
if (null !== ($ticket = DAO_Ticket::getTicketByMask($mask))) {
$fields = array(DAO_TicketComment::CREATED => $created, DAO_TicketComment::TICKET_ID => $ticket->id, DAO_TicketComment::COMMENT => $note, DAO_TicketComment::ADDRESS_ID => $author_address->id);
if (null !== ($comment_id = DAO_TicketComment::create($fields))) {
return true;
}
}
return false;
}
function showEntryAction()
{
@($active_worker = CerberusApplication::getActiveWorker());
@($view_id = DevblocksPlatform::importGPC($_REQUEST['view_id'], 'string', ''));
$tpl = DevblocksPlatform::getTemplateService();
$tpl_path = dirname(dirname(__FILE__)) . '/templates/';
$tpl->assign('path', $this->plugin_path . '/templates/');
$tpl->assign('view_id', $view_id);
// Editing
@($id = DevblocksPlatform::importGPC($_REQUEST['id'], 'integer', 0));
// Creating
@($msg_id = DevblocksPlatform::importGPC($_REQUEST['msg_id'], 'integer', 0));
@($quote = DevblocksPlatform::importGPC($_REQUEST['quote'], 'string', ''));
@($url = DevblocksPlatform::importGPC($_REQUEST['url'], 'string', ''));
@($source_ext_id = DevblocksPlatform::importGPC($_REQUEST['source_ext_id'], 'string', ''));
@($source_id = DevblocksPlatform::importGPC($_REQUEST['source_id'], 'integer', 0));
/*
* This treats procedurally created model objects
* the same as existing objects
*/
if (empty($id)) {
$model = new Model_FeedbackEntry();
if (!empty($msg_id)) {
if (null != ($message = DAO_Ticket::getMessage($msg_id))) {
$model->id = 0;
$model->log_date = time();
$model->quote_address_id = $message->address_id;
$model->quote_mood = 0;
$model->quote_text = $quote;
$model->worker_id = $active_worker->id;
$model->source_url = $url;
$tpl->assign('model', $model);
}
}
} elseif (!empty($id)) {
// Were we given a model ID to load?
if (null != ($model = DAO_FeedbackEntry::get($id))) {
$tpl->assign('model', $model);
}
}
// Author (if not anonymous)
if (!empty($model->quote_address_id)) {
if (null != ($address = DAO_Address::get($model->quote_address_id))) {
$tpl->assign('address', $address);
}
}
if (!empty($source_ext_id)) {
$tpl->assign('source_extension_id', $source_ext_id);
$tpl->assign('source_id', $source_id);
}
// Custom fields
$custom_fields = DAO_CustomField::getBySource(ChCustomFieldSource_FeedbackEntry::ID);
$tpl->assign('custom_fields', $custom_fields);
$custom_field_values = DAO_CustomFieldValue::getValuesBySourceIds(ChCustomFieldSource_FeedbackEntry::ID, $id);
if (isset($custom_field_values[$id])) {
$tpl->assign('custom_field_values', $custom_field_values[$id]);
}
$types = Model_CustomField::getTypes();
$tpl->assign('types', $types);
$tpl->display('file:' . $this->plugin_path . '/templates/feedback/ajax/feedback_entry_panel.tpl');
}
function saveTeamAction()
{
$translate = DevblocksPlatform::getTranslationService();
$worker = CerberusApplication::getActiveWorker();
if (!$worker || !$worker->is_superuser) {
echo $translate->_('common.access_denied');
return;
}
if (DEMO_MODE) {
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('config', 'workflow')));
return;
}
@($id = DevblocksPlatform::importGPC($_POST['id']));
@($name = DevblocksPlatform::importGPC($_POST['name']));
@($delete = DevblocksPlatform::importGPC($_POST['delete_box']));
@($delete_move_id = DevblocksPlatform::importGPC($_POST['delete_move_id'], 'integer', 0));
if (empty($name)) {
$name = "No Name";
}
if (!empty($id) && !empty($delete)) {
if (!empty($delete_move_id)) {
$fields = array(DAO_Ticket::TEAM_ID => $delete_move_id);
$where = sprintf("%s=%d", DAO_Ticket::TEAM_ID, $id);
DAO_Ticket::updateWhere($fields, $where);
DAO_Group::deleteTeam($id);
}
} elseif (!empty($id)) {
$fields = array(DAO_Group::TEAM_NAME => $name);
DAO_Group::updateTeam($id, $fields);
} else {
$fields = array(DAO_Group::TEAM_NAME => $name);
$id = DAO_Group::createTeam($fields);
}
@($worker_ids = DevblocksPlatform::importGPC($_POST['worker_ids'], 'array', array()));
@($worker_levels = DevblocksPlatform::importGPC($_POST['worker_levels'], 'array', array()));
@($members = DAO_Group::getTeamMembers($id));
if (is_array($worker_ids) && !empty($worker_ids)) {
foreach ($worker_ids as $idx => $worker_id) {
@($level = $worker_levels[$idx]);
if (isset($members[$worker_id]) && empty($level)) {
DAO_Group::unsetTeamMember($id, $worker_id);
} elseif (!empty($level)) {
// member|manager
DAO_Group::setTeamMember($id, $worker_id, 1 == $level ? false : true);
}
}
}
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('config', 'groups')));
}
function render()
{
$tpl = DevblocksPlatform::getTemplateService();
$response = DevblocksPlatform::getHttpResponse();
@($ticket_id = $response->path[2]);
@($page_type = DevblocksPlatform::importGPC($_REQUEST['page_type'], 'string', 'reply'));
$message_id = $response->path[3];
if (empty($ticket_id)) {
$session = DevblocksPlatform::getSessionService();
$visit = $session->getVisit();
return;
}
if (!is_numeric($ticket_id)) {
$ticket_id = DAO_Ticket::getTicketIdByMask($ticket_id);
}
$ticket = DAO_Ticket::getTicket($ticket_id);
$tpl->assign('ticket', $ticket);
$tpl->assign('ticket_id', $ticket_id);
$tpl->assign('message_id', $message_id);
$tpl->assign('page_type', $page_type);
if (0 == strcasecmp($message_id, 'full')) {
$tpl->display('file:' . dirname(__FILE__) . '/templates/display.tpl');
} else {
$message = DAO_Ticket::getMessage($message_id);
if (empty($message)) {
$message = array_pop($ticket->getMessages());
}
$tpl->assign('message', $message);
$tpl->display('file:' . dirname(__FILE__) . '/templates/display_brief.tpl');
}
}
private function _sendForwards($event, $is_inbound)
{
@($ticket_id = $event->params['ticket_id']);
@($send_worker_id = $event->params['worker_id']);
$url_writer = DevblocksPlatform::getUrlService();
$ticket = DAO_Ticket::get($ticket_id);
// (Action) Forward Email To:
// Sanitize and combine all the destination addresses
$context_workers = CerberusContexts::getWorkers(CerberusContexts::CONTEXT_TICKET, $ticket->id);
if (!is_array($context_workers)) {
return;
}
foreach ($context_workers as $next_worker) {
$notify_emails = $next_worker->email;
if (empty($notify_emails)) {
continue;
}
}
// [TODO] This could be more efficient
$messages = DAO_Message::getMessagesByTicket($ticket_id);
$message = end($messages);
// last message
unset($messages);
$headers = $message->getHeaders();
// The whole flipping Swift section needs wrapped to catch exceptions
try {
$settings = DevblocksPlatform::getPluginSettingsService();
$reply_to = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, CerberusSettingsDefaults::DEFAULT_REPLY_FROM);
// See if we need a group-specific reply-to
if (!empty($ticket->team_id)) {
@($group_from = DAO_GroupSettings::get($ticket->team_id, DAO_GroupSettings::SETTING_REPLY_FROM, ''));
if (!empty($group_from)) {
$reply_to = $group_from;
}
}
$sender = DAO_Address::get($message->address_id);
$sender_email = strtolower($sender->email);
$sender_split = explode('@', $sender_email);
if (!is_array($sender_split) || count($sender_split) != 2) {
return;
}
// If return-path is blank
if (isset($headers['return-path']) && $headers['return-path'] == '<>') {
return;
}
// Ignore bounces
if ($sender_split[0] == "postmaster" || $sender_split[0] == "mailer-daemon") {
return;
}
// Ignore autoresponses autoresponses
if (isset($headers['auto-submitted']) && $headers['auto-submitted'] != 'no') {
return;
}
// Attachments
$attachments = $message->getAttachments();
$mime_attachments = array();
if (is_array($attachments)) {
foreach ($attachments as $attachment) {
if (0 == strcasecmp($attachment->display_name, 'original_message.html')) {
continue;
}
$attachment_path = APP_STORAGE_PATH . '/attachments/';
// [TODO] This is highly redundant in the codebase
if (!file_exists($attachment_path . $attachment->filepath)) {
continue;
}
$attach = Swift_Attachment::fromPath($attachment_path . $attachment->filepath);
if (!empty($attachment->display_name)) {
$attach->setFilename($attachment->display_name);
}
$mime_attachments[] = $attach;
}
}
// Send copies
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
$mail = $mail_service->createMessage();
/* @var $mail Swift_Message */
$mail->setTo(array($notify_emails));
$mail->setFrom(array($sender->email));
$mail->setReplyTo($reply_to);
$mail->setReturnPath($reply_to);
$mail->setSubject(sprintf("[RW: %s #%s]: %s", $is_inbound ? 'inbound' : 'outbound', $ticket->mask, $ticket->subject));
$hdrs = $mail->getHeaders();
if (null !== @($msgid = $headers['message-id'])) {
$hdrs->addTextHeader('Message-Id', $msgid);
}
if (null !== @($in_reply_to = $headers['in-reply-to'])) {
$hdrs->addTextHeader('References', $in_reply_to);
$hdrs->addTextHeader('In-Reply-To', $in_reply_to);
}
$hdrs->addTextHeader('X-Mailer', 'Cerberus Helpdesk (Build ' . APP_BUILD . ')');
$hdrs->addTextHeader('Precedence', 'List');
$hdrs->addTextHeader('Auto-Submitted', 'auto-generated');
$mail->setBody($message->getContent());
// Send message attachments with watcher
if (is_array($mime_attachments)) {
foreach ($mime_attachments as $mime_attachment) {
$mail->attach($mime_attachment);
}
}
$result = $mailer->send($mail);
} catch (Exception $e) {
if (!empty($message_id)) {
$fields = array(DAO_MessageNote::MESSAGE_ID => $message_id, DAO_MessageNote::CREATED => time(), DAO_MessageNote::WORKER_ID => 0, DAO_MessageNote::CONTENT => 'Exception thrown while sending watcher email: ' . $e->getMessage(), DAO_MessageNote::TYPE => Model_MessageNote::TYPE_ERROR);
DAO_MessageNote::create($fields);
}
}
}
function saveTabInboxAddAction()
{
$translate = DevblocksPlatform::getTranslationService();
@($id = DevblocksPlatform::importGPC($_REQUEST['id'], 'integer', 0));
@($group_id = DevblocksPlatform::importGPC($_REQUEST['group_id'], 'integer'));
@($view_id = DevblocksPlatform::importGPC($_REQUEST['view_id'], 'string', ''));
@($active_worker = CerberusApplication::getActiveWorker());
if (!$active_worker->isTeamManager($group_id) && !$active_worker->is_superuser) {
return;
}
/*****************************/
@($name = DevblocksPlatform::importGPC($_POST['name'], 'string', ''));
@($is_sticky = DevblocksPlatform::importGPC($_POST['is_sticky'], 'integer', 0));
@($is_stackable = DevblocksPlatform::importGPC($_POST['is_stackable'], 'integer', 0));
@($rules = DevblocksPlatform::importGPC($_POST['rules'], 'array', array()));
@($do = DevblocksPlatform::importGPC($_POST['do'], 'array', array()));
if (empty($name)) {
$name = $translate->_('mail.inbox_filter');
}
$criterion = array();
$actions = array();
// Custom fields
$custom_fields = DAO_CustomField::getAll();
// Criteria
if (is_array($rules)) {
foreach ($rules as $rule) {
$rule = DevblocksPlatform::strAlphaNumDash($rule);
@($value = DevblocksPlatform::importGPC($_POST['value_' . $rule], 'string', ''));
// [JAS]: Allow empty $value (null/blank checking)
$criteria = array('value' => $value);
// Any special rule handling
switch ($rule) {
case 'dayofweek':
// days
$days = DevblocksPlatform::importGPC($_REQUEST['value_dayofweek'], 'array', array());
if (in_array(0, $days)) {
$criteria['sun'] = 'Sunday';
}
if (in_array(1, $days)) {
$criteria['mon'] = 'Monday';
}
if (in_array(2, $days)) {
$criteria['tue'] = 'Tuesday';
}
if (in_array(3, $days)) {
$criteria['wed'] = 'Wednesday';
}
if (in_array(4, $days)) {
$criteria['thu'] = 'Thursday';
}
if (in_array(5, $days)) {
$criteria['fri'] = 'Friday';
}
if (in_array(6, $days)) {
$criteria['sat'] = 'Saturday';
}
unset($criteria['value']);
break;
case 'timeofday':
$from = DevblocksPlatform::importGPC($_REQUEST['timeofday_from'], 'string', '');
$to = DevblocksPlatform::importGPC($_REQUEST['timeofday_to'], 'string', '');
$criteria['from'] = $from;
$criteria['to'] = $to;
unset($criteria['value']);
break;
case 'subject':
break;
case 'from':
break;
case 'tocc':
break;
case 'header1':
case 'header2':
case 'header3':
case 'header4':
case 'header5':
if (null != @($header = DevblocksPlatform::importGPC($_POST[$rule], 'string', null))) {
$criteria['header'] = strtolower($header);
}
break;
case 'body':
break;
case 'attachment':
break;
default:
// ignore invalids
// Custom fields
if ("cf_" == substr($rule, 0, 3)) {
$field_id = intval(substr($rule, 3));
if (!isset($custom_fields[$field_id])) {
continue;
}
// [TODO] Operators
switch ($custom_fields[$field_id]->type) {
case 'S':
// string
// string
case 'T':
// clob
// clob
case 'U':
// URL
$oper = DevblocksPlatform::importGPC($_REQUEST['value_cf_' . $field_id . '_oper'], 'string', 'regexp');
$criteria['oper'] = $oper;
break;
case 'D':
// dropdown
// dropdown
case 'M':
// multi-dropdown
// multi-dropdown
case 'X':
// multi-checkbox
// multi-checkbox
case 'W':
// worker
$in_array = DevblocksPlatform::importGPC($_REQUEST['value_cf_' . $field_id], 'array', array());
$out_array = array();
// Hash key on the option for quick lookup later
if (is_array($in_array)) {
foreach ($in_array as $k => $v) {
$out_array[$v] = $v;
}
}
$criteria['value'] = $out_array;
break;
case 'E':
// date
$from = DevblocksPlatform::importGPC($_REQUEST['value_cf_' . $field_id . '_from'], 'string', '0');
$to = DevblocksPlatform::importGPC($_REQUEST['value_cf_' . $field_id . '_to'], 'string', 'now');
$criteria['from'] = $from;
$criteria['to'] = $to;
unset($criteria['value']);
break;
case 'N':
// number
$oper = DevblocksPlatform::importGPC($_REQUEST['value_cf_' . $field_id . '_oper'], 'string', '=');
$criteria['oper'] = $oper;
$criteria['value'] = intval($value);
break;
case 'C':
// checkbox
$criteria['value'] = intval($value);
break;
}
} else {
continue;
}
break;
}
$criterion[$rule] = $criteria;
}
}
// Actions
if (is_array($do)) {
foreach ($do as $act) {
$action = array();
switch ($act) {
// Move group/bucket
case 'move':
@($move_code = DevblocksPlatform::importGPC($_REQUEST['do_move'], 'string', null));
if (0 != strlen($move_code)) {
list($g_id, $b_id) = CerberusApplication::translateTeamCategoryCode($move_code);
$action = array('group_id' => intval($g_id), 'bucket_id' => intval($b_id));
}
break;
// Assign to worker
// Assign to worker
case 'assign':
@($worker_id = DevblocksPlatform::importGPC($_REQUEST['do_assign'], 'string', null));
if (0 != strlen($worker_id)) {
$action = array('worker_id' => intval($worker_id));
}
break;
// Spam training
// Spam training
case 'spam':
@($is_spam = DevblocksPlatform::importGPC($_REQUEST['do_spam'], 'string', null));
if (0 != strlen($is_spam)) {
$action = array('is_spam' => !$is_spam ? 0 : 1);
}
break;
// Set status
// Set status
case 'status':
@($status = DevblocksPlatform::importGPC($_REQUEST['do_status'], 'string', null));
if (0 != strlen($status)) {
$action = array('is_waiting' => 3 == $status ? 1 : 0, 'is_closed' => 0 == $status || 3 == $status ? 0 : 1, 'is_deleted' => 2 == $status ? 1 : 0);
}
break;
default:
// ignore invalids
// Custom fields
if ("cf_" == substr($act, 0, 3)) {
$field_id = intval(substr($act, 3));
if (!isset($custom_fields[$field_id])) {
continue;
}
$action = array();
// [TODO] Operators
switch ($custom_fields[$field_id]->type) {
case 'S':
// string
// string
case 'T':
// clob
// clob
case 'D':
// dropdown
// dropdown
case 'U':
// URL
// URL
case 'W':
// worker
$value = DevblocksPlatform::importGPC($_REQUEST['do_cf_' . $field_id], 'string', '');
$action['value'] = $value;
break;
case 'M':
// multi-dropdown
// multi-dropdown
case 'X':
// multi-checkbox
$in_array = DevblocksPlatform::importGPC($_REQUEST['do_cf_' . $field_id], 'array', array());
$out_array = array();
// Hash key on the option for quick lookup later
if (is_array($in_array)) {
foreach ($in_array as $k => $v) {
$out_array[$v] = $v;
}
}
$action['value'] = $out_array;
break;
case 'E':
// date
$value = DevblocksPlatform::importGPC($_REQUEST['do_cf_' . $field_id], 'string', '');
$action['value'] = $value;
break;
case 'N':
// number
// number
case 'C':
// checkbox
$value = DevblocksPlatform::importGPC($_REQUEST['do_cf_' . $field_id], 'string', '');
$action['value'] = intval($value);
break;
}
} else {
continue;
}
break;
}
$actions[$act] = $action;
}
}
$fields = array(DAO_GroupInboxFilter::NAME => $name, DAO_GroupInboxFilter::IS_STICKY => $is_sticky, DAO_GroupInboxFilter::CRITERIA_SER => serialize($criterion), DAO_GroupInboxFilter::ACTIONS_SER => serialize($actions));
// Only sticky filters can manual order and be stackable
if (!$is_sticky) {
$fields[DAO_GroupInboxFilter::STICKY_ORDER] = 0;
$fields[DAO_GroupInboxFilter::IS_STACKABLE] = 0;
} else {
// is sticky
$fields[DAO_GroupInboxFilter::IS_STACKABLE] = $is_stackable;
}
// Create
if (empty($id)) {
$fields[DAO_GroupInboxFilter::GROUP_ID] = $group_id;
$fields[DAO_GroupInboxFilter::POS] = 0;
$id = DAO_GroupInboxFilter::create($fields);
// Update
} else {
DAO_GroupInboxFilter::update($id, $fields);
}
$defaults = new C4_AbstractViewModel();
$defaults->class_name = 'C4_TicketView';
$defaults->id = $view_id;
$view = C4_AbstractViewLoader::getView($view_id, $defaults);
if (!empty($view_id) && null != $view) {
/* @var $view C4_TicketView */
// Loop through all the tickets in this inbox
list($inbox_tickets, $null) = DAO_Ticket::search(null, array(new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_TEAM_ID, '=', $group_id), new DevblocksSearchCriteria(SearchFields_Ticket::TICKET_CATEGORY_ID, '=', '0')), -1, 0, null, null, false);
if (is_array($inbox_tickets)) {
foreach ($inbox_tickets as $inbox_ticket) {
/* @var $inbox_ticket CerberusTicket */
// Run only this new rule against all tickets in the group inbox
CerberusApplication::runGroupRouting($group_id, intval($inbox_ticket[SearchFields_Ticket::TICKET_ID]), $id);
}
}
$view->render();
return;
}
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('groups', $group_id, 'inbox')));
}
