function showTab()
{
$settings = DevblocksPlatform::getPluginSettingsService();
$tpl = DevblocksPlatform::getTemplateService();
$tpl_path = dirname(dirname(__FILE__)) . '/templates/';
$core_tplpath = dirname(dirname(dirname(__FILE__))) . '/portsensor.core/templates/';
$tpl->assign('core_tplpath', $core_tplpath);
$tpl->assign('response_uri', 'setup/translations');
$defaults = new Ps_AbstractViewModel();
$defaults->class_name = 'Ps_TranslationView';
$defaults->id = Ps_TranslationView::DEFAULT_ID;
$view = Ps_AbstractViewLoader::getView(Ps_TranslationView::DEFAULT_ID, $defaults);
$tpl->assign('view', $view);
$tpl->assign('view_fields', Ps_TranslationView::getFields());
$tpl->assign('view_searchable_fields', Ps_TranslationView::getSearchFields());
$tpl->display('file:' . $tpl_path . 'setup/translations/index.tpl');
}
/**
* exec_sendfax
*
* @param string command
* @return array
*/
function sendFax($phone_number, $message, $subject, $to, $account_name, $from = null)
{
// sendfax -f "*****@*****.**" -D -R -r "Test Fax" -x "Account Name" -d "RecipientName@4106311699" /home/rmiddle/test.txt
$settings = DevblocksPlatform::getPluginSettingsService();
if (empty($from)) {
@($from = $settings->get('feg.core', FegSettings::DEFAULT_REPLY_FROM, $_SERVER['SERVER_ADMIN']));
}
$command = "sendfax ";
$command .= sprintf("-f '%s' ", $from);
$command .= "-D -R ";
$command .= sprintf("-r '%s' ", $subject);
$command .= sprintf("-x '%s' ", $account_name);
$command .= sprintf("-d '%s@%s' ", $to, $phone_number);
$tempfilename = tempnam(APP_TEMP_PATH . "/fax_cache", 'fax_message-');
$temp_fh = fopen($tempfilename, 'w') or die($php_errormsg);
fputs($temp_fh, $message);
fclose($temp_fh) or die($php_errormsg);
// Generate Text file of message.
$command .= sprintf("'%s' ", $tempfilename);
$o = exec($command . " 2>&1", $sendfax_output, $retval);
$debug = DEBUG_MODE;
if ($retval == 0) {
// success
if ($debug) {
echo "<p>{$command}";
}
$result = str_replace("(", "", $sendfax_output[0]);
$result = str_replace(")", "", $result);
// request id is 80 (group id 80) for host localhost (3 files)
// request id is 81 (group id 81) for host localhost (1 file)
$output = split(" ", $result);
return array('status' => true, 'jobid' => $output[3], 'groupid' => $output[6], 'host' => $output[9], 'numfiles' => $output[10]);
}
if ($debug) {
echo "<p>";
print_r($o);
echo "<p>";
print_r($sendfax_output);
echo "<p>{$command}<br>";
}
$forlog = implode("\n", $sendfax_output);
return array('status' => false, 'output' => $forlog);
}
function hasPriv($priv_id)
{
// We don't need to do much work if we're a superuser
if ($this->is_superuser) {
return true;
}
$settings = DevblocksPlatform::getPluginSettingsService();
$acl_enabled = $settings->get('feg.core', FegSettings::ACL_ENABLED);
// ACL is a paid feature (please respect the licensing and support the project!)
$license = FegLicense::getInstance();
if (!$acl_enabled || !isset($license['serial']) || isset($license['a'])) {
return "core.setup" == substr($priv_id, 0, 11) ? false : true;
}
// Check the aggregated worker privs from roles
$acl = DAO_WorkerRole::getACL();
$privs_by_worker = $acl[DAO_WorkerRole::CACHE_KEY_PRIVS_BY_WORKER];
if (!empty($priv_id) && isset($privs_by_worker[$this->id][$priv_id])) {
return true;
}
return false;
}
function doContactSendAction()
{
@($sFrom = DevblocksPlatform::importGPC($_POST['from'], 'string', ''));
@($sSubject = DevblocksPlatform::importGPC($_POST['subject'], 'string', ''));
@($sContent = DevblocksPlatform::importGPC($_POST['content'], 'string', ''));
@($sCaptcha = DevblocksPlatform::importGPC($_POST['captcha'], 'string', ''));
@($aFieldIds = DevblocksPlatform::importGPC($_POST['field_ids'], 'array', array()));
@($aFollowUpQ = DevblocksPlatform::importGPC($_POST['followup_q'], 'array', array()));
$fields = DAO_CustomField::getBySource('cerberusweb.fields.source.ticket');
// Load the answers to any situational questions
$aFollowUpA = array();
if (is_array($aFollowUpQ)) {
foreach ($aFollowUpQ as $idx => $q) {
// Only form values we were passed
if (!isset($_POST['followup_a_' . $idx])) {
continue;
}
if (is_array($_POST['followup_a_' . $idx])) {
@($answer = DevblocksPlatform::importGPC($_POST['followup_a_' . $idx], 'array', array()));
$aFollowUpA[$idx] = implode(', ', $answer);
} else {
@($answer = DevblocksPlatform::importGPC($_POST['followup_a_' . $idx], 'string', ''));
$aFollowUpA[$idx] = $answer;
}
// Translate field values into something human-readable (if needed)
if (isset($aFieldIds[$idx]) && !empty($aFieldIds[$idx])) {
// Were we given a legit field id?
if (null != @($field = $fields[$aFieldIds[$idx]])) {
switch ($field->type) {
// Translate 'worker' fields into worker name (not ID)
case Model_CustomField::TYPE_WORKER:
if (null != ($worker = DAO_Worker::getAgent($answer))) {
$aFollowUpA[$idx] = $worker->getName();
}
break;
}
// switch
}
// if
}
// if
}
}
$umsession = UmPortalHelper::getSession();
$active_user = $umsession->getProperty('sc_login', null);
$fingerprint = UmPortalHelper::getFingerprint();
$settings = DevblocksPlatform::getPluginSettingsService();
$default_from = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM);
$umsession->setProperty('support.write.last_from', $sFrom);
$umsession->setProperty('support.write.last_subject', $sSubject);
$umsession->setProperty('support.write.last_content', $sContent);
$umsession->setProperty('support.write.last_followup_a', $aFollowUpA);
$sNature = $umsession->getProperty('support.write.last_nature', '');
$captcha_enabled = DAO_CommunityToolProperty::get(UmPortalHelper::getCode(), self::PARAM_CAPTCHA_ENABLED, 1);
$captcha_session = $umsession->getProperty(UmScApp::SESSION_CAPTCHA, '***');
// Subject is required if the field is on the form
if (isset($_POST['subject']) && empty($sSubject)) {
$umsession->setProperty('support.write.last_error', 'A subject is required.');
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'contact', 'step2')));
return;
}
// Sender and CAPTCHA required
if (empty($sFrom) || $captcha_enabled && 0 != strcasecmp($sCaptcha, $captcha_session)) {
if (empty($sFrom)) {
$umsession->setProperty('support.write.last_error', 'Invalid e-mail address.');
} else {
$umsession->setProperty('support.write.last_error', 'What you typed did not match the image.');
}
// Need to report the captcha didn't match and redraw the form
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'contact', 'step2')));
return;
}
// Dispatch
$to = $default_from;
$subject = 'Contact me: Other';
$sDispatch = DAO_CommunityToolProperty::get(UmPortalHelper::getCode(), self::PARAM_SITUATIONS, '');
$dispatch = !empty($sDispatch) ? unserialize($sDispatch) : array();
foreach ($dispatch as $k => $v) {
if (md5($k) == $sNature) {
$to = $v['to'];
$subject = 'Contact me: ' . strip_tags($k);
break;
}
}
if (!empty($sSubject)) {
$subject = $sSubject;
}
$fieldContent = '';
if (!empty($aFollowUpQ)) {
$fieldContent = "\r\n\r\n";
$fieldContent .= "--------------------------------------------\r\n";
if (!empty($sNature)) {
$fieldContent .= $subject . "\r\n";
$fieldContent .= "--------------------------------------------\r\n";
}
foreach ($aFollowUpQ as $idx => $q) {
$answer = isset($aFollowUpA[$idx]) ? $aFollowUpA[$idx] : '';
$fieldContent .= "Q) " . $q . "\r\n" . "A) " . $answer . "\r\n";
if ($idx + 1 < count($aFollowUpQ)) {
$fieldContent .= "\r\n";
}
}
$fieldContent .= "--------------------------------------------\r\n";
"\r\n";
}
$message = new CerberusParserMessage();
$message->headers['date'] = date('r');
$message->headers['to'] = $to;
$message->headers['subject'] = $subject;
$message->headers['message-id'] = CerberusApplication::generateMessageId();
$message->headers['x-cerberus-portal'] = 1;
// Sender
$fromList = imap_rfc822_parse_adrlist($sFrom, '');
if (empty($fromList) || !is_array($fromList)) {
return;
// abort with message
}
$from = array_shift($fromList);
$message->headers['from'] = $from->mailbox . '@' . $from->host;
$message->body = 'IP: ' . $fingerprint['ip'] . "\r\n\r\n" . $sContent . $fieldContent;
// Attachments
$attachments_mode = DAO_CommunityToolProperty::get(UmPortalHelper::getCode(), self::PARAM_ATTACHMENTS_MODE, 0);
if (0 == $attachments_mode || 1 == $attachments_mode && !empty($active_user)) {
if (is_array($_FILES) && !empty($_FILES)) {
foreach ($_FILES as $name => $files) {
// field[]
if (is_array($files['name'])) {
foreach ($files['name'] as $idx => $name) {
$attach = new ParserFile();
$attach->setTempFile($files['tmp_name'][$idx], 'application/octet-stream');
$attach->file_size = filesize($files['tmp_name'][$idx]);
$message->files[$name] = $attach;
}
} else {
$attach = new ParserFile();
$attach->setTempFile($files['tmp_name'], 'application/octet-stream');
$attach->file_size = filesize($files['tmp_name']);
$message->files[$files['name']] = $attach;
}
}
}
}
// Custom Fields
if (!empty($aFieldIds)) {
foreach ($aFieldIds as $iIdx => $iFieldId) {
if (!empty($iFieldId)) {
$field =& $fields[$iFieldId];
/* @var $field Model_CustomField */
$value = "";
switch ($field->type) {
case Model_CustomField::TYPE_SINGLE_LINE:
case Model_CustomField::TYPE_MULTI_LINE:
case Model_CustomField::TYPE_URL:
@($value = trim($aFollowUpA[$iIdx]));
break;
case Model_CustomField::TYPE_NUMBER:
@($value = $aFollowUpA[$iIdx]);
if (!is_numeric($value) || 0 == strlen($value)) {
$value = null;
}
break;
case Model_CustomField::TYPE_DATE:
if (false !== ($time = strtotime($aFollowUpA[$iIdx]))) {
@($value = intval($time));
}
break;
case Model_CustomField::TYPE_DROPDOWN:
@($value = $aFollowUpA[$iIdx]);
break;
case Model_CustomField::TYPE_MULTI_PICKLIST:
@($value = DevblocksPlatform::importGPC($_POST['followup_a_' . $iIdx], 'array', array()));
break;
case Model_CustomField::TYPE_CHECKBOX:
@($value = isset($aFollowUpA[$iIdx]) && !empty($aFollowUpA[$iIdx]) ? 1 : 0);
break;
case Model_CustomField::TYPE_MULTI_CHECKBOX:
@($value = DevblocksPlatform::importGPC($_POST['followup_a_' . $iIdx], 'array', array()));
break;
case Model_CustomField::TYPE_WORKER:
@($value = DevblocksPlatform::importGPC($_POST['followup_a_' . $iIdx], 'integer', 0));
break;
}
if (is_array($value) && !empty($value) || !is_array($value) && 0 != strlen($value)) {
$message->custom_fields[$iFieldId] = $value;
}
}
}
}
// Parse
$ticket_id = CerberusParser::parseMessage($message);
// It's possible for the parser to reject the message using pre-filters
if (!empty($ticket_id) && null != ($ticket = DAO_Ticket::getTicket($ticket_id))) {
$umsession->setProperty('support.write.last_opened', $ticket->mask);
} else {
$umsession->setProperty('support.write.last_opened', null);
}
// Clear any errors
$umsession->setProperty('support.write.last_nature', null);
$umsession->setProperty('support.write.last_nature_string', null);
$umsession->setProperty('support.write.last_content', null);
$umsession->setProperty('support.write.last_error', null);
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'contact', 'confirm')));
}
function saveOutgoingMailSettingsAction()
{
$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', 'mail')));
return;
}
@($default_reply_address = DevblocksPlatform::importGPC($_REQUEST['sender_address'], 'string'));
@($default_reply_personal = DevblocksPlatform::importGPC($_REQUEST['sender_personal'], 'string'));
@($default_signature = DevblocksPlatform::importGPC($_POST['default_signature'], 'string'));
@($default_signature_pos = DevblocksPlatform::importGPC($_POST['default_signature_pos'], 'integer', 0));
@($smtp_host = DevblocksPlatform::importGPC($_REQUEST['smtp_host'], 'string', 'localhost'));
@($smtp_port = DevblocksPlatform::importGPC($_REQUEST['smtp_port'], 'integer', 25));
@($smtp_enc = DevblocksPlatform::importGPC($_REQUEST['smtp_enc'], 'string', 'None'));
@($smtp_timeout = DevblocksPlatform::importGPC($_REQUEST['smtp_timeout'], 'integer', 30));
@($smtp_max_sends = DevblocksPlatform::importGPC($_REQUEST['smtp_max_sends'], 'integer', 20));
@($smtp_auth_enabled = DevblocksPlatform::importGPC($_REQUEST['smtp_auth_enabled'], 'integer', 0));
if ($smtp_auth_enabled) {
@($smtp_auth_user = DevblocksPlatform::importGPC($_REQUEST['smtp_auth_user'], 'string'));
@($smtp_auth_pass = DevblocksPlatform::importGPC($_REQUEST['smtp_auth_pass'], 'string'));
} else {
// need to clear auth info when smtp auth is disabled
@($smtp_auth_user = '');
@($smtp_auth_pass = '');
}
$settings = DevblocksPlatform::getPluginSettingsService();
$settings->set('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, $default_reply_address);
$settings->set('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL, $default_reply_personal);
$settings->set('cerberusweb.core', CerberusSettings::DEFAULT_SIGNATURE, $default_signature);
$settings->set('cerberusweb.core', CerberusSettings::DEFAULT_SIGNATURE_POS, $default_signature_pos);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_HOST, $smtp_host);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_PORT, $smtp_port);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_AUTH_ENABLED, $smtp_auth_enabled);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_AUTH_USER, $smtp_auth_user);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_AUTH_PASS, $smtp_auth_pass);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_ENCRYPTION_TYPE, $smtp_enc);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_TIMEOUT, !empty($smtp_timeout) ? $smtp_timeout : 30);
$settings->set('cerberusweb.core', CerberusSettings::SMTP_MAX_SENDS, !empty($smtp_max_sends) ? $smtp_max_sends : 20);
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('config', 'mail', 'outgoing', 'test')));
}
/**
* @return array
*/
public static function getInstance()
{
$settings = DevblocksPlatform::getPluginSettingsService();
$license = $settings->get('cerberusweb.core', CerberusSettings::LICENSE, array());
if (!empty($license)) {
@($license = unserialize($license));
}
if (!is_array($license)) {
$license = array();
}
return $license;
}
function handleRequest(DevblocksHttpRequest $request)
{
@set_time_limit(0);
// no timelimit (when possible)
$translate = DevblocksPlatform::getTranslationService();
$stack = $request->path;
array_shift($stack);
// update
$cache = DevblocksPlatform::getCacheService();
/* @var $cache _DevblocksCacheManager */
switch (array_shift($stack)) {
case 'locked':
if (!DevblocksPlatform::versionConsistencyCheck()) {
$url = DevblocksPlatform::getUrlService();
echo "<h1>Feg - Fax Email Gateway 1.x</h1>";
echo "The application is currently waiting for an administrator to finish upgrading. " . "Please wait a few minutes and then " . sprintf("<a href='%s'>try again</a>.<br><br>", $url->write('c=update&a=locked'));
echo sprintf("If you're an admin you may <a href='%s'>finish the upgrade</a>.", $url->write('c=update'));
} else {
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('login')));
}
break;
default:
$path = APP_TEMP_PATH . DIRECTORY_SEPARATOR;
$file = $path . 'feg_update_lock';
$settings = DevblocksPlatform::getPluginSettingsService();
$authorized_ips_str = $settings->get('feg.core', FegSettings::AUTHORIZED_IPS);
$authorized_ips = DevblocksPlatform::parseCrlfString($authorized_ips_str);
$authorized_ip_defaults = DevblocksPlatform::parseCsvString(AUTHORIZED_IPS_DEFAULTS);
$authorized_ips = array_merge($authorized_ips, $authorized_ip_defaults);
// Is this IP authorized?
$pass = false;
foreach ($authorized_ips as $ip) {
if (substr($ip, 0, strlen($ip)) == substr($_SERVER['REMOTE_ADDR'], 0, strlen($ip))) {
$pass = true;
break;
}
}
if (!$pass) {
echo vsprintf($translate->_('update.ip_unauthorized'), $_SERVER['REMOTE_ADDR']);
return;
}
// Check requirements
$errors = FegApplication::checkRequirements();
if (!empty($errors)) {
echo $translate->_('update.correct_errors');
echo "<ul style='color:red;'>";
foreach ($errors as $error) {
echo "<li>" . $error . "</li>";
}
echo "</ul>";
exit;
}
try {
// If authorized, lock and attempt update
if (!file_exists($file) || @filectime($file) + 600 < time()) {
// 10 min lock
// Log everybody out since we're touching the database
$session = DevblocksPlatform::getSessionService();
$session->clearAll();
// Lock file
touch($file);
// Recursive patch
FegApplication::update();
// Clean up
@unlink($file);
$cache = DevblocksPlatform::getCacheService();
$cache->save(APP_BUILD, "devblocks_app_build");
// Clear all caches
$cache->clean();
DevblocksPlatform::getClassLoaderService()->destroy();
// Clear compiled templates
$tpl = DevblocksPlatform::getTemplateService();
$tpl->utility->clearCompiledTemplate();
$tpl->cache->clearAll();
// Reload plugin translations
DAO_Translation::reloadPluginStrings();
// Redirect
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('login')));
} else {
echo $translate->_('update.locked_another');
}
} catch (Exception $e) {
unlink($file);
die($e->getMessage());
}
}
exit;
}
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;
}
}
function handleRequest(DevblocksHttpRequest $request)
{
@set_time_limit(0);
// no timelimit (when possible)
$translate = DevblocksPlatform::getTranslationService();
$stack = $request->path;
array_shift($stack);
// update
$cache = DevblocksPlatform::getCacheService();
/* @var $cache _DevblocksCacheManager */
$settings = DevblocksPlatform::getPluginSettingsService();
switch (array_shift($stack)) {
case 'locked':
if (!DevblocksPlatform::versionConsistencyCheck()) {
$url = DevblocksPlatform::getUrlService();
echo "<h1>Cerberus Helpdesk 5.x</h1>";
echo "The helpdesk is currently waiting for an administrator to finish upgrading. " . "Please wait a few minutes and then " . sprintf("<a href='%s'>try again</a>.<br><br>", $url->write('c=update&a=locked'));
echo sprintf("If you're an admin you may <a href='%s'>finish the upgrade</a>.", $url->write('c=update'));
} else {
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('login')));
}
break;
default:
$path = APP_TEMP_PATH . DIRECTORY_SEPARATOR;
$file = $path . 'c4update_lock';
$authorized_ips_str = $settings->get('cerberusweb.core', CerberusSettings::AUTHORIZED_IPS);
$authorized_ips = DevblocksPlatform::parseCrlfString($authorized_ips_str);
$authorized_ip_defaults = DevblocksPlatform::parseCsvString(AUTHORIZED_IPS_DEFAULTS);
$authorized_ips = array_merge($authorized_ips, $authorized_ip_defaults);
// Is this IP authorized?
$pass = false;
foreach ($authorized_ips as $ip) {
if (substr($ip, 0, strlen($ip)) == substr($_SERVER['REMOTE_ADDR'], 0, strlen($ip))) {
$pass = true;
break;
}
}
if (!$pass) {
echo vsprintf($translate->_('update.ip_unauthorized'), $_SERVER['REMOTE_ADDR']);
return;
}
// Check requirements
$errors = CerberusApplication::checkRequirements();
if (!empty($errors)) {
echo $translate->_('update.correct_errors');
echo "<ul style='color:red;'>";
foreach ($errors as $error) {
echo "<li>" . $error . "</li>";
}
echo "</ul>";
exit;
}
// If authorized, lock and attempt update
if (!file_exists($file) || @filectime($file) + 600 < time()) {
// 10 min lock
touch($file);
//echo "Running plugin patches...<br>";
if (DevblocksPlatform::runPluginPatches('core.patches')) {
@unlink($file);
// [JAS]: Clear all caches
$cache->clean();
DevblocksPlatform::getClassLoaderService()->destroy();
// Clear compiled templates
$tpl = DevblocksPlatform::getTemplateService();
$tpl->clear_compiled_tpl();
// Reload plugin translations
DAO_Translation::reloadPluginStrings();
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('login')));
} else {
@unlink($file);
echo "Failure!";
// [TODO] Needs elaboration
}
break;
} else {
echo $translate->_('update.locked_another');
}
}
exit;
}
static function sendMail($to, $subject, $body, $from_addy = null, $from_personal = null)
{
try {
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(FegMail::getMailerDefaults());
$mail = $mail_service->createMessage();
$settings = DevblocksPlatform::getPluginSettingsService();
if (empty($from_addy)) {
@($from_addy = $settings->get('feg.core', FegSettings::DEFAULT_REPLY_FROM, $_SERVER['SERVER_ADMIN']));
}
if (empty($from_personal)) {
@($from_personal = $settings->get('feg.core', FegSettings::DEFAULT_REPLY_PERSONAL, ''));
}
$mail->setTo($to);
$mail->setFrom(array($from_addy => $from_personal));
$mail->setSubject($subject);
$mail->generateId();
$headers = $mail->getHeaders();
$headers->addTextHeader('X-Mailer', 'Feg (Build ' . APP_BUILD . ')');
$mail->setBody($body);
// [TODO] Report when the message wasn't sent.
if (!$mailer->send($mail)) {
return false;
}
} catch (Exception $e) {
return false;
}
return true;
}
private function _sendConfirmation($email, $link)
{
$settings = DevblocksPlatform::getPluginSettingsService();
$from = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM);
$from_personal = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL);
$url = DevblocksPlatform::getUrlService();
try {
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
$code = CerberusApplication::generatePassword(8);
if (!empty($email) && null != ($addy = DAO_Address::lookupAddress($email, false))) {
$fields = array(DAO_Address::IS_REGISTERED => 0, DAO_Address::PASS => $code);
DAO_Address::update($addy->id, $fields);
} else {
return;
}
$message = $mail_service->createMessage();
$message->setTo(array($email));
$message->setFrom(array($from => $from_personal));
$message->setSubject("Account Confirmation Code");
$message->setBody(sprintf("Below is your confirmation code. Please copy and paste it into the confirmation form at:\r\n" . "%s\r\n" . "\r\n" . "Your confirmation code is: %s\r\n" . "\r\n" . "Thanks!\r\n", $link, $code));
$headers = $mail->getHeaders();
$headers->addTextHeader('X-Mailer', 'Cerberus Helpdesk (Build ' . APP_BUILD . ')');
$result = $mailer->send($message);
} catch (Exception $e) {
return;
}
}
function doRecoverStep1Action()
{
$translate = DevblocksPlatform::getTranslationService();
@($email = DevblocksPlatform::importGPC($_REQUEST['email'], 'string'));
$worker = DAO_Worker::lookupAgentEmail($email);
if (empty($email) || empty($worker)) {
return;
}
$_SESSION[self::KEY_FORGOT_EMAIL] = $email;
try {
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
$mail = $mail_service->createMessage();
$code = CerberusApplication::generatePassword(10);
$_SESSION[self::KEY_FORGOT_SENTCODE] = $code;
$settings = DevblocksPlatform::getPluginSettingsService();
$from = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM);
$personal = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL);
// Headers
$mail->setTo(array($email));
$mail->setFrom(array($from => $personal));
$mail->setSubject($translate->_('signin.forgot.mail.subject'));
$mail->generateId();
$headers = $mail->getHeaders();
$headers->addTextHeader('X-Mailer', 'Cerberus Helpdesk (Build ' . APP_BUILD . ')');
$mail->setBody(vsprintf($translate->_('signin.forgot.mail.body'), $code));
if (!$mailer->send($mail)) {
throw new Exception('Password Forgot confirmation email failed to send.');
}
} catch (Exception $e) {
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('login', 'forgot', 'step1', 'failed')));
}
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('login', 'forgot', 'step2')));
}
function doReplyAction()
{
@($mask = DevblocksPlatform::importGPC($_REQUEST['mask'], 'string', ''));
@($content = DevblocksPlatform::importGPC($_REQUEST['content'], 'string', ''));
$umsession = UmPortalHelper::getSession();
$active_user = $umsession->getProperty('sc_login', null);
// 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);
$messages = DAO_Ticket::getMessagesByTicket($ticket[SearchFields_Ticket::TICKET_ID]);
$last_message = array_pop($messages);
/* @var $last_message CerberusMessage */
$last_message_headers = $last_message->getHeaders();
unset($messages);
// Helpdesk settings
$settings = DevblocksPlatform::getPluginSettingsService();
$global_from = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, null);
// Ticket group settings
$group_id = $ticket[SearchFields_Ticket::TICKET_TEAM_ID];
@($group_from = DAO_GroupSettings::get($group_id, DAO_GroupSettings::SETTING_REPLY_FROM, ''));
// Headers
$to = !empty($group_from) ? $group_from : $global_from;
@($in_reply_to = $last_message_headers['message-id']);
@($message_id = CerberusApplication::generateMessageId());
$message = new CerberusParserMessage();
$message->headers['from'] = $active_user->email;
$message->headers['to'] = $to;
$message->headers['date'] = date('r');
$message->headers['subject'] = 'Re: ' . $ticket[SearchFields_Ticket::TICKET_SUBJECT];
$message->headers['message-id'] = $message_id;
$message->headers['in-reply-to'] = $in_reply_to;
$message->body = sprintf("%s", $content);
CerberusParser::parseMessage($message, array('no_autoreply' => true));
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'history', $ticket[SearchFields_Ticket::TICKET_MASK])));
}
public function writeResponse(DevblocksHttpResponse $response)
{
/* @var $response DevblocksHttpResponse */
$path = $response->path;
$uri_prefix = array_shift($path);
// should be mobile
// [JAS]: Ajax? // [TODO] Explore outputting whitespace here for Safari
// if(empty($path))
// return;
$tpl = DevblocksPlatform::getTemplateService();
$session = DevblocksPlatform::getSessionService();
$settings = DevblocksPlatform::getPluginSettingsService();
$translate = DevblocksPlatform::getTranslationService();
$visit = $session->getVisit();
$controller = array_shift($path);
$pages = DevblocksPlatform::getExtensions('cerberusweb.mobile.page', true);
// Default page [TODO] This is supposed to come from framework.config.php
if (empty($controller)) {
$controller = 'tickets';
}
// [JAS]: Require us to always be logged in for Cerberus pages
// [TODO] This should probably consult with the page itself for ::authenticated()
if (empty($visit)) {
$controller = 'login';
}
$page_id = $this->_getPageIdByUri($controller);
/* @var $page CerberusPageExtension */
@($page = $pages[$page_id]);
if (empty($page)) {
return;
}
// 404
// [TODO] Reimplement
if (!empty($visit) && !is_null($visit->getWorker())) {
DAO_Worker::logActivity($visit->getWorker()->id, $page->getActivity());
}
// [JAS]: Listeners (Step-by-step guided tour, etc.)
$listenerManifests = DevblocksPlatform::getExtensions('devblocks.listener.http');
foreach ($listenerManifests as $listenerManifest) {
/* @var $listenerManifest DevblocksExtensionManifest */
$inst = $listenerManifest->createInstance();
/* @var $inst DevblocksHttpRequestListenerExtension */
$inst->run($response, $tpl);
}
// [JAS]: Pre-translate any dynamic strings
$common_translated = array();
if (!empty($visit) && !is_null($visit->getWorker())) {
$common_translated['header_signed_in'] = vsprintf($translate->_('header.signed_in'), array('<b>' . $visit->getWorker()->getName() . '</b>'));
}
$tpl->assign('common_translated', $common_translated);
// $tour_enabled = false;
// if(!empty($visit) && !is_null($visit->getWorker())) {
// $worker = $visit->getWorker();
// $tour_enabled = DAO_WorkerPref::get($worker->id, 'assist_mode');
// $tour_enabled = ($tour_enabled===false) ? 1 : $tour_enabled;
// if(DEMO_MODE) $tour_enabled = 1; // override for DEMO
// }
// $tpl->assign('tour_enabled', $tour_enabled);
// [JAS]: Variables provided to all page templates
$tpl->assign('settings', $settings);
$tpl->assign('session', $_SESSION);
$tpl->assign('translate', $translate);
$tpl->assign('visit', $visit);
$tpl->assign('license', CerberusLicense::getInstance());
$active_worker = CerberusApplication::getActiveWorker();
$tpl->assign('active_worker', $active_worker);
if (!empty($active_worker)) {
$active_worker_memberships = $active_worker->getMemberships();
$tpl->assign('active_worker_memberships', $active_worker_memberships);
}
$tpl->assign('pages', $pages);
$tpl->assign('page', $page);
$tpl->assign('response_uri', implode('/', $response->path));
$tpl_path = APP_PATH . '/features/cerberusweb.mobile/templates/';
$tpl->assign('core_tpl', APP_PATH . '/features/cerberusweb.core/templates/');
// Timings
$tpl->assign('render_time', microtime(true) - DevblocksPlatform::getStartTime());
if (function_exists('memory_get_usage') && function_exists('memory_get_peak_usage')) {
$tpl->assign('render_memory', memory_get_usage() - DevblocksPlatform::getStartMemory());
$tpl->assign('render_peak_memory', memory_get_peak_usage() - DevblocksPlatform::getStartPeakMemory());
}
$tpl->display($tpl_path . 'border.tpl');
}
function replyAction()
{
@($id = DevblocksPlatform::importGPC($_REQUEST['id'], 'integer', 0));
@($is_forward = DevblocksPlatform::importGPC($_REQUEST['forward'], 'integer', 0));
$settings = DevblocksPlatform::getPluginSettingsService();
$tpl = DevblocksPlatform::getTemplateService();
$tpl->assign('path', $this->_TPL_PATH);
$tpl->assign('id', $id);
$tpl->assign('is_forward', $is_forward);
$message = DAO_Ticket::getMessage($id);
$tpl->assign('message', $message);
$ticket = DAO_Ticket::getTicket($message->ticket_id);
$tpl->assign('ticket', $ticket);
// ReplyToolbarItem Extensions
$replyToolbarItems = DevblocksPlatform::getExtensions('cerberusweb.reply.toolbaritem', true);
if (!empty($replyToolbarItems)) {
$tpl->assign('reply_toolbaritems', $replyToolbarItems);
}
// Show attachments for forwarded messages
if ($is_forward) {
$forward_attachments = $message->getAttachments();
$tpl->assign('forward_attachments', $forward_attachments);
}
$workers = DAO_Worker::getAllActive();
$tpl->assign('workers', $workers);
$teams = DAO_Group::getAll();
$tpl->assign('teams', $teams);
$team_categories = DAO_Bucket::getTeams();
$tpl->assign('team_categories', $team_categories);
@($ticket_team = $teams[$ticket->team_id]);
if (null != ($worker = CerberusApplication::getActiveWorker())) {
/* @var $worker CerberusWorker */
/* [JAS]:
* If the worker is replying to an unassigned ticket, assign it to them to warn
* other workers. By default the 'next worker' followup propery will revert back
* to 'anybody' when desired.
*
* We're intentionally not telling the template about the new owner.
*/
if (0 == $ticket->next_worker_id) {
DAO_Ticket::updateTicket($ticket->id, array(DAO_Ticket::NEXT_WORKER_ID => $worker->id));
}
// Signatures
if (!empty($ticket_team) && !empty($ticket_team->signature)) {
$signature = $ticket_team->signature;
} else {
// [TODO] Default signature
$signature = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_SIGNATURE);
}
$tpl->assign('signature', str_replace(array('#first_name#', '#last_name#', '#title#'), array($worker->first_name, $worker->last_name, $worker->title), $signature));
$signature_pos = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_SIGNATURE_POS, 0);
$tpl->assign('signature_pos', $signature_pos);
}
$tpl->assign('upload_max_filesize', ini_get('upload_max_filesize'));
$kb_topics = DAO_KbCategory::getWhere(sprintf("%s = %d", DAO_KbCategory::PARENT_ID, 0));
$tpl->assign('kb_topics', $kb_topics);
$tpl->display('file:' . $this->_TPL_PATH . 'display/rpc/reply.tpl');
}
private function _handleImportContact($xml)
{
$settings = DevblocksPlatform::getPluginSettingsService();
$logger = DevblocksPlatform::getConsoleLog();
$sFirstName = (string) $xml->first_name;
$sLastName = (string) $xml->last_name;
$sEmail = (string) $xml->email;
$sPassword = (string) $xml->password;
$sOrganization = (string) $xml->organization;
// Dupe check org
if (null != ($address = DAO_Address::lookupAddress($sEmail))) {
$logger->info('[Importer] Avoiding creating duplicate contact #' . $address->id . ' (' . $sEmail . ')');
// [TODO] Still associate with org if local blank?
// [TODO] Still associate password if local blank?
return true;
}
$fields = array(DAO_Address::FIRST_NAME => $sFirstName, DAO_Address::LAST_NAME => $sLastName, DAO_Address::EMAIL => $sEmail);
// Associate SC password
if (!empty($sPassword) && $sPassword != md5('')) {
$fields[DAO_Address::IS_REGISTERED] = 1;
$fields[DAO_Address::PASS] = $sPassword;
}
$address_id = DAO_Address::create($fields);
// Associate with organization
if (!empty($sOrganization)) {
if (null != ($org_id = DAO_ContactOrg::lookup($sOrganization, true))) {
DAO_Address::update($address_id, array(DAO_Address::CONTACT_ORG_ID => $org_id));
}
}
$logger->info('[Importer] Imported contact #' . $address_id . ' (' . $sEmail . ')');
return true;
}
function doRegisterAction()
{
@($email = DevblocksPlatform::importGPC($_REQUEST['email'], 'string', ''));
$tpl = DevblocksPlatform::getTemplateService();
$settings = DevblocksPlatform::getPluginSettingsService();
$from = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, null);
$from_personal = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL, "Support Dept.");
$url = DevblocksPlatform::getUrlService();
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
$code = CerberusApplication::generatePassword(8);
if (!empty($email) && null != ($addy = DAO_Address::lookupAddress($email, true))) {
// Already registered?
if ($addy->is_registered) {
$tpl->assign('register_error', sprintf("'%s' is already registered.", $email));
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'register')));
return;
}
$fields = array(DAO_Address::IS_REGISTERED => 0, DAO_Address::PASS => $code);
DAO_Address::update($addy->id, $fields);
} else {
$tpl->assign('register_error', sprintf("'%s' is an invalid e-mail address.", $email));
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'register')));
return;
}
$message = $mail_service->createMessage();
$message->setTo($email);
$message->setFrom(array($from => $from_personal));
$message->setSubject("Confirming your support e-mail address");
$message->setBody(sprintf("This is a message to confirm your recent registration request at:\r\n" . "%s\r\n" . "\r\n" . "Your confirmation code is: %s\r\n" . "\r\n" . "If you've closed the browser window, you can continue by visiting:\r\n" . "%s\r\n" . "\r\n" . "Thanks!\r\n" . "%s\r\n", $url->write('', true), $code, $url->write('c=register&a=confirm', true), $from_personal));
$headers = $message->getHeaders();
$headers->addTextHeader('X-Mailer', 'Cerberus Helpdesk (Build ' . APP_BUILD . ')');
$result = $mailer->send($message);
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('portal', UmPortalHelper::getCode(), 'register', 'confirm')));
}
function handleRequest(DevblocksHttpRequest $request)
{
@($reload = DevblocksPlatform::importGPC($_REQUEST['reload'], 'integer', 0));
@($loglevel = DevblocksPlatform::importGPC($_REQUEST['loglevel'], 'integer', 0));
$logger = DevblocksPlatform::getConsoleLog();
$translate = DevblocksPlatform::getTranslationService();
$settings = DevblocksPlatform::getPluginSettingsService();
$authorized_ips_str = $settings->get('portsensor.core', PortSensorSettings::AUTHORIZED_IPS);
$authorized_ips = DevblocksPlatform::parseCrlfString($authorized_ips_str);
$authorized_ip_defaults = DevblocksPlatform::parseCsvString(AUTHORIZED_IPS_DEFAULTS);
$authorized_ips = array_merge($authorized_ips, $authorized_ip_defaults);
@($is_ignoring_wait = DevblocksPlatform::importGPC($_REQUEST['ignore_wait'], 'integer', 0));
$pass = false;
foreach ($authorized_ips as $ip) {
if (substr($ip, 0, strlen($ip)) == substr($_SERVER['REMOTE_ADDR'], 0, strlen($ip))) {
$pass = true;
break;
}
}
if (!$pass) {
echo vsprintf($translate->_('cron.ip_unauthorized'), $_SERVER['REMOTE_ADDR']);
return;
}
$stack = $request->path;
array_shift($stack);
// cron
$job_id = array_shift($stack);
@set_time_limit(0);
// Unlimited (if possible)
$url = DevblocksPlatform::getUrlService();
$timelimit = intval(ini_get('max_execution_time'));
if ($reload) {
$reload_url = sprintf("%s?reload=%d&loglevel=%d&ignore_wait=%d", $url->write('c=cron' . ($job_id ? "&a=" . $job_id : "")), intval($reload), intval($loglevel), intval($is_ignoring_wait));
echo "<HTML>" . "<HEAD>" . "<TITLE></TITLE>" . "<meta http-equiv='Refresh' content='" . intval($reload) . ";" . $reload_url . "'>" . "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>" . "</HEAD>" . "<BODY>";
}
// [TODO] Determine if we're on a time limit under 60 seconds
$cron_manifests = DevblocksPlatform::getExtensions('portsensor.cron', true, true);
$jobs = array();
if (empty($job_id)) {
// do everything
// Determine who wants to go first by next time and longest waiting
$nexttime = time() + 86400;
if (is_array($cron_manifests)) {
foreach ($cron_manifests as $idx => $instance) {
/* @var $instance PortSensorCronExtension */
$lastrun = $instance->getParam(PortSensorCronExtension::PARAM_LASTRUN, 0);
if ($instance->isReadyToRun($is_ignoring_wait)) {
if ($timelimit) {
if ($lastrun < $nexttime) {
$jobs[0] = $cron_manifests[$idx];
$nexttime = $lastrun;
}
} else {
$jobs[] =& $cron_manifests[$idx];
}
}
}
}
} else {
// single job
$manifest = DevblocksPlatform::getExtension($job_id, false, true);
if (empty($manifest)) {
exit;
}
$instance = $manifest->createInstance();
if ($instance) {
if ($instance->isReadyToRun($is_ignoring_wait)) {
$jobs[0] =& $instance;
}
}
}
if (!empty($jobs)) {
foreach ($jobs as $nextjob) {
$nextjob->setParam(PortSensorCronExtension::PARAM_LOCKED, time());
$nextjob->_run();
}
} elseif ($reload) {
$logger->info(vsprintf($translate->_('cron.nothing_to_do'), intval($reload)));
}
if ($reload) {
echo "</BODY>" . "</HTML>";
}
exit;
}
$tpl->assign('failed', true);
}
} else {
// Defaults
}
$tpl->assign('template', 'steps/step_defaults.tpl');
break;
case STEP_REGISTER:
@($form_submit = DevblocksPlatform::importGPC($_POST['form_submit'], 'integer'));
@($skip = DevblocksPlatform::importGPC($_POST['skip'], 'integer', 0));
if (!empty($form_submit)) {
@($contact_name = str_replace(array("\r", "\n"), '', stripslashes($_REQUEST['contact_name'])));
@($contact_email = str_replace(array("\r", "\n"), '', stripslashes($_REQUEST['contact_email'])));
@($contact_company = stripslashes($_REQUEST['contact_company']));
if (empty($skip) && !empty($contact_name)) {
$settings = DevblocksPlatform::getPluginSettingsService();
@($default_from = $settings->get('feg.core', FegSettings::DEFAULT_REPLY_FROM, ''));
@($contact_phone = stripslashes($_REQUEST['contact_phone']));
@($contact_refer = stripslashes($_REQUEST['contact_refer']));
@($q1 = stripslashes($_REQUEST['q1']));
@($q2 = stripslashes($_REQUEST['q2']));
@($q3 = stripslashes($_REQUEST['q3']));
@($q4 = stripslashes($_REQUEST['q4']));
@($q5_support = stripslashes($_REQUEST['q5_support']));
@($q5_opensource = stripslashes($_REQUEST['q5_opensource']));
@($q5_price = stripslashes($_REQUEST['q5_price']));
@($q5_updates = stripslashes($_REQUEST['q5_updates']));
@($q5_developers = stripslashes($_REQUEST['q5_developers']));
@($q5_community = stripslashes($_REQUEST['q5_community']));
@($comments = stripslashes($_REQUEST['comments']));
if (isset($_REQUEST['form_submit'])) {
function handleRequest(DevblocksHttpRequest $request)
{
@set_time_limit(0);
// no timelimit (when possible)
$stack = $request->path;
array_shift($stack);
// update
// $cache = DevblocksPlatform::getCacheService(); /* @var $cache _DevblocksCacheManager */
$settings = DevblocksPlatform::getPluginSettingsService();
$authorized_ips_str = $settings->get('cerberusweb.core', CerberusSettings::AUTHORIZED_IPS);
$authorized_ips = DevblocksPlatform::parseCrlfString($authorized_ips_str);
$authorized_ip_defaults = DevblocksPlatform::parseCsvString(AUTHORIZED_IPS_DEFAULTS);
$authorized_ips = array_merge($authorized_ips, $authorized_ip_defaults);
// Is this IP authorized?
$pass = false;
foreach ($authorized_ips as $ip) {
if (substr($ip, 0, strlen($ip)) == substr($_SERVER['REMOTE_ADDR'], 0, strlen($ip))) {
$pass = true;
break;
}
}
if (!$pass) {
echo 'Your IP address (' . $_SERVER['REMOTE_ADDR'] . ') is not authorized to debug this helpdesk. Your administrator needs to authorize your IP in Helpdesk Setup or in the framework.config.php file under AUTHORIZED_IPS_DEFAULTS.';
return;
}
switch (array_shift($stack)) {
case 'phpinfo':
phpinfo();
break;
case 'check':
echo sprintf("<html>\n\t\t\t\t\t<head>\n\t\t\t\t\t\t<title></title>\n\t\t\t\t\t\t<style>\n\t\t\t\t\t\t\tBODY {font-family: Arial, Helvetica, sans-serif; font-size: 12px;}\n\t\t\t\t\t\t\tFORM {margin:0px; } \n\t\t\t\t\t\t\tH1 { margin:0px; }\n\t\t\t\t\t\t\t.fail {color:red;font-weight:bold;}\n\t\t\t\t\t\t\t.pass {color:green;font-weight:bold;}\n\t\t\t\t\t\t</style>\n\t\t\t\t\t</head>\n\t\t\t\t\t<body>\n\t\t\t\t\t\t<h1>Cerberus Helpdesk - Requirements Checker:</h1>\n\t\t\t\t\t");
$errors = CerberusApplication::checkRequirements();
if (!empty($errors)) {
echo "<ul class='fail'>";
foreach ($errors as $error) {
echo sprintf("<li>%s</li>", $error);
}
echo "</ul>";
} else {
echo '<span class="pass">Your server is compatible with Cerberus Helpdesk 5.x!</span>';
}
echo sprintf("\n\t\t\t\t\t</body>\n\t\t\t\t\t</html>\n\t\t\t\t");
break;
case 'report':
@($db = DevblocksPlatform::getDatabaseService());
@($settings = DevblocksPlatform::getPluginSettingsService());
@($tables = $db->MetaTables('TABLE', false));
$report_output = sprintf("[Cerberus Helpdesk] App Build: %s\n" . "[Cerberus Helpdesk] Devblocks Build: %s\n" . "[Cerberus Helpdesk] URL-Rewrite: %s\n" . "\n" . "[Privs] storage/attachments: %s\n" . "[Privs] storage/mail/new: %s\n" . "[Privs] storage/mail/fail: %s\n" . "[Privs] storage/tmp: %s\n" . "[Privs] storage/tmp/templates_c: %s\n" . "[Privs] storage/tmp/cache: %s\n" . "\n" . "[PHP] Version: %s\n" . "[PHP] OS: %s\n" . "[PHP] SAPI: %s\n" . "\n" . "[php.ini] safe_mode: %s\n" . "[php.ini] max_execution_time: %s\n" . "[php.ini] memory_limit: %s\n" . "[php.ini] file_uploads: %s\n" . "[php.ini] upload_max_filesize: %s\n" . "[php.ini] post_max_size: %s\n" . "\n" . "[PHP:Extension] MySQL: %s\n" . "[PHP:Extension] PostgreSQL: %s\n" . "[PHP:Extension] MailParse: %s\n" . "[PHP:Extension] IMAP: %s\n" . "[PHP:Extension] Session: %s\n" . "[PHP:Extension] PCRE: %s\n" . "[PHP:Extension] GD: %s\n" . "[PHP:Extension] mbstring: %s\n" . "[PHP:Extension] XML: %s\n" . "[PHP:Extension] SimpleXML: %s\n" . "[PHP:Extension] DOM: %s\n" . "[PHP:Extension] SPL: %s\n" . "\n" . '%s', APP_BUILD, PLATFORM_BUILD, file_exists(APP_PATH . '/.htaccess') ? 'YES' : 'NO', substr(sprintf('%o', fileperms(APP_STORAGE_PATH . '/attachments')), -4), substr(sprintf('%o', fileperms(APP_STORAGE_PATH . '/mail/new')), -4), substr(sprintf('%o', fileperms(APP_STORAGE_PATH . '/mail/fail')), -4), substr(sprintf('%o', fileperms(APP_TEMP_PATH)), -4), substr(sprintf('%o', fileperms(APP_TEMP_PATH . '/templates_c')), -4), substr(sprintf('%o', fileperms(APP_TEMP_PATH . '/cache')), -4), PHP_VERSION, PHP_OS . ' (' . php_uname() . ')', php_sapi_name(), ini_get('safe_mode'), ini_get('max_execution_time'), ini_get('memory_limit'), ini_get('file_uploads'), ini_get('upload_max_filesize'), ini_get('post_max_size'), extension_loaded("mysql") ? 'YES' : 'NO', extension_loaded("pgsql") ? 'YES' : 'NO', extension_loaded("mailparse") ? 'YES' : 'NO', extension_loaded("imap") ? 'YES' : 'NO', extension_loaded("session") ? 'YES' : 'NO', extension_loaded("pcre") ? 'YES' : 'NO', extension_loaded("gd") ? 'YES' : 'NO', extension_loaded("mbstring") ? 'YES' : 'NO', extension_loaded("xml") ? 'YES' : 'NO', extension_loaded("simplexml") ? 'YES' : 'NO', extension_loaded("dom") ? 'YES' : 'NO', extension_loaded("spl") ? 'YES' : 'NO', '');
if (!empty($settings)) {
$report_output .= sprintf("[Setting] HELPDESK_TITLE: %s\n" . "[Setting] DEFAULT_REPLY_FROM: %s\n" . "[Setting] DEFAULT_REPLY_PERSONAL: %s\n" . "[Setting] SMTP_HOST: %s\n" . "[Setting] SMTP_PORT: %s\n" . "[Setting] SMTP_ENCRYPTION_TYPE: %s\n" . "\n" . '%s', $settings->get('cerberusweb.core', CerberusSettings::HELPDESK_TITLE, ''), str_replace(array('@', '.'), array(' at ', ' dot '), $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, '')), $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL, ''), $settings->get('cerberusweb.core', CerberusSettings::SMTP_HOST, ''), $settings->get('cerberusweb.core', CerberusSettings::SMTP_PORT, ''), $settings->get('cerberusweb.core', CerberusSettings::SMTP_ENCRYPTION_TYPE, ''), '');
}
if (is_array($tables) && !empty($tables)) {
$report_output .= sprintf("[Stats] # Workers: %s\n" . "[Stats] # Groups: %s\n" . "[Stats] # Tickets: %s\n" . "[Stats] # Messages: %s\n" . "\n" . "[Database] Tables:\n * %s\n" . "\n" . '%s', intval($db->getOne('SELECT count(id) FROM worker')), intval($db->getOne('SELECT count(id) FROM team')), intval($db->getOne('SELECT count(id) FROM ticket')), intval($db->getOne('SELECT count(id) FROM message')), implode("\n * ", array_values($tables)), '');
}
echo sprintf("<html>\n\t\t\t\t\t<head>\n\t\t\t\t\t\t<title></title>\n\t\t\t\t\t\t<style>\n\t\t\t\t\t\t\tBODY {font-family: Arial, Helvetica, sans-serif; font-size: 12px;}\n\t\t\t\t\t\t\tFORM {margin:0px; } \n\t\t\t\t\t\t\tH1 { margin:0px; }\n\t\t\t\t\t\t\t.fail {color:red;font-weight:bold;}\n\t\t\t\t\t\t\t.pass {color:green;font-weight:bold;}\n\t\t\t\t\t\t</style>\n\t\t\t\t\t</head>\n\t\t\t\t\t<body>\n\t\t\t\t\t\t<form>\n\t\t\t\t\t\t\t<h1>Cerberus Helpdesk - Debug Report:</h1>\n\t\t\t\t\t\t\t<textarea rows='25' cols='100'>%s</textarea>\n\t\t\t\t\t\t</form>\t\n\t\t\t\t\t</body>\n\t\t\t\t\t</html>\n\t\t\t\t\t", $report_output);
break;
default:
$url_service = DevblocksPlatform::getUrlService();
echo sprintf("<html>\n\t\t\t\t\t<head>\n\t\t\t\t\t\t<title></title>\n\t\t\t\t\t\t<style>\n\t\t\t\t\t\t\tBODY {font-family: Arial, Helvetica, sans-serif; font-size: 12px;}\n\t\t\t\t\t\t\tFORM {margin:0px; } \n\t\t\t\t\t\t\tH1 { margin:0px; }\n\t\t\t\t\t\t</style>\n\t\t\t\t\t</head>\n\t\t\t\t\t<body>\n\t\t\t\t\t\t<form>\n\t\t\t\t\t\t\t<h1>Cerberus Helpdesk - Debug Menu:</h1>\n\t\t\t\t\t\t\t<ul>\n\t\t\t\t\t\t\t\t<li><a href='%s'>Requirements Checker</a></li>\n\t\t\t\t\t\t\t\t<li><a href='%s'>Debug Report (for technical support)</a></li>\n\t\t\t\t\t\t\t\t<li><a href='%s'>phpinfo()</a></li>\n\t\t\t\t\t\t\t</ul>\n\t\t\t\t\t\t</form>\t\n\t\t\t\t\t</body>\n\t\t\t\t\t</html>\n\t\t\t\t\t", $url_service->write('c=debug&a=check'), $url_service->write('c=debug&a=report'), $url_service->write('c=debug&a=phpinfo'));
break;
}
exit;
}
function saveTab()
{
@($clickatell_username = DevblocksPlatform::importGPC($_REQUEST['clickatell_username'], 'string', ''));
@($clickatell_password = DevblocksPlatform::importGPC($_REQUEST['clickatell_password'], 'string', ''));
@($clickatell_api_id = DevblocksPlatform::importGPC($_REQUEST['clickatell_api_id'], 'string', ''));
if (!empty($clickatell_username)) {
$settings = DevblocksPlatform::getPluginSettingsService();
$settings->set('portsensor.sms', 'clickatell_username', $clickatell_username);
$settings->set('portsensor.sms', 'clickatell_password', $clickatell_password);
$settings->set('portsensor.sms', 'clickatell_api_id', $clickatell_api_id);
}
DevblocksPlatform::redirect(new DevblocksHttpResponse(array('setup', 'sms')));
exit;
}
static function reflect(CerberusParserMessage $message, $to)
{
try {
$mail_service = DevblocksPlatform::getMailService();
$mailer = $mail_service->getMailer(CerberusMail::getMailerDefaults());
$mail = $mail_service->createMessage();
$settings = DevblocksPlatform::getPluginSettingsService();
@($from_addy = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_FROM, $_SERVER['SERVER_ADMIN']));
@($from_personal = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_REPLY_PERSONAL, ''));
$mail->setTo(array($to));
$headers = $mail->getHeaders();
if (isset($message->headers['subject'])) {
if (is_array($message->headers['subject'])) {
$subject = array_shift($message->headers['subject']);
} else {
$subject = $message->headers['subject'];
}
$mail->setSubject($subject);
}
if (isset($message->headers['message-id'])) {
$headers->addTextHeader('Message-Id', $message->headers['message-id']);
}
if (isset($message->headers['in-reply-to'])) {
$headers->addTextHeader('In-Reply-To', $message->headers['in-reply-to']);
}
if (isset($message->headers['references'])) {
$headers->addTextHeader('References', $message->headers['references']);
}
if (isset($message->headers['from'])) {
$mail->setFrom($message->headers['from']);
}
if (isset($message->headers['return-path'])) {
$mail->setReturnPath($message->headers['return-path']);
}
if (isset($message->headers['reply-to'])) {
$mail->setReplyTo($message->headers['reply-to']);
}
$headers->addTextHeader('X-CerberusRedirect', '1');
$mail->setBody($message->body);
// Files
if (is_array($message->files)) {
foreach ($message->files as $file_name => $file) {
/* @var $file ParserFile */
$mail->attach(Swift_Attachment::fromPath($file->tmpname)->setFilename($file_name));
}
}
$result = $mailer->send($mail);
if (!$result) {
return false;
}
} catch (Exception $e) {
return false;
}
}
public function writeResponse(DevblocksHttpResponse $response)
{
$path = $response->path;
// [JAS]: Ajax? // [TODO] Explore outputting whitespace here for Safari
// if(empty($path))
// return;
$tpl = DevblocksPlatform::getTemplateService();
$session = DevblocksPlatform::getSessionService();
$settings = DevblocksPlatform::getPluginSettingsService();
$translate = DevblocksPlatform::getTranslationService();
$active_worker = FegApplication::getActiveWorker();
$visit = $session->getVisit();
$page_manifests = $this->_getAllowedPages();
$controller = array_shift($path);
// Default page [TODO] This is supposed to come from framework.config.php
if (empty($controller)) {
$controller = 'preferences';
}
// [JAS]: Require us to always be logged in for Feg pages
if (empty($visit) && 0 != strcasecmp($controller, 'login')) {
$query = array();
if (!empty($response->path)) {
$query = array('url' => urlencode(implode('/', $response->path)));
}
DevblocksPlatform::redirect(new DevblocksHttpRequest(array('login'), $query));
}
$page_id = $this->_getPageIdByUri($controller);
@($page = DevblocksPlatform::getExtension($page_id, true));
/* @var $page FegPageExtension */
if (empty($page)) {
header("Status: 404");
return;
// [TODO] 404
}
// [JAS]: Listeners (Step-by-step guided tour, etc.)
$listenerManifests = DevblocksPlatform::getExtensions('devblocks.listener.http');
foreach ($listenerManifests as $listenerManifest) {
/* @var $listenerManifest DevblocksExtensionManifest */
$inst = $listenerManifest->createInstance();
/* @var $inst DevblocksHttpRequestListenerExtension */
$inst->run($response, $tpl);
}
$tpl->assign('active_worker', $active_worker);
$tour_enabled = false;
if (!empty($visit) && !is_null($active_worker)) {
$tour_enabled = intval(DAO_WorkerPref::get($active_worker->id, 'assist_mode', 1));
$keyboard_shortcuts = intval(DAO_WorkerPref::get($active_worker->id, 'keyboard_shortcuts', 1));
$tpl->assign('pref_keyboard_shortcuts', $keyboard_shortcuts);
// $active_worker_memberships = $active_worker->getMemberships();
// $tpl->assign('active_worker_memberships', $active_worker_memberships);
$unread_notifications = DAO_WorkerEvent::getUnreadCountByWorker($active_worker->id);
$tpl->assign('active_worker_notify_count', $unread_notifications);
DAO_Worker::logActivity($active_worker->id, $page->getActivity());
}
$tpl->assign('tour_enabled', $tour_enabled);
// [JAS]: Variables provided to all page templates
$tpl->assign('settings', $settings);
$tpl->assign('session', $_SESSION);
$tpl->assign('translate', $translate);
$tpl->assign('visit', $visit);
$tpl->assign('license', FegLicense::getInstance());
$tpl->assign('page_manifests', $page_manifests);
$tpl->assign('page', $page);
$tpl->assign('response_uri', implode('/', $response->path));
$core_tpl = APP_PATH . '/features/feg.core/templates/';
$tpl->assign('core_tpl', $core_tpl);
// Prebody Renderers
$preBodyRenderers = DevblocksPlatform::getExtensions('feg.renderer.prebody', true);
if (!empty($preBodyRenderers)) {
$tpl->assign('prebody_renderers', $preBodyRenderers);
}
// Postbody Renderers
$postBodyRenderers = DevblocksPlatform::getExtensions('feg.renderer.postbody', true);
if (!empty($postBodyRenderers)) {
$tpl->assign('postbody_renderers', $postBodyRenderers);
}
// Timings
$tpl->assign('render_time', microtime(true) - DevblocksPlatform::getStartTime());
if (function_exists('memory_get_usage') && function_exists('memory_get_peak_usage')) {
$tpl->assign('render_memory', memory_get_usage() - DevblocksPlatform::getStartMemory());
$tpl->assign('render_peak_memory', memory_get_peak_usage() - DevblocksPlatform::getStartPeakMemory());
}
$tpl->display($core_tpl . 'border.tpl');
// $cache = DevblocksPlatform::getCacheService();
// $cache->printStatistics();
}
function getComposeSignatureAction()
{
@($group_id = DevblocksPlatform::importGPC($_REQUEST['group_id'], 'integer', 0));
$settings = DevblocksPlatform::getPluginSettingsService();
$group = DAO_Group::getTeam($group_id);
$active_worker = CerberusApplication::getActiveWorker();
$worker = DAO_Worker::getAgent($active_worker->id);
// Use the most recent info (not session)
$sig = $settings->get('cerberusweb.core', CerberusSettings::DEFAULT_SIGNATURE, '');
if (!empty($group->signature)) {
$sig = $group->signature;
}
/*
* [TODO] This is the 3rd place this replace happens, we really need
* to move the signature translation into something like CerberusApplication
*/
echo sprintf("\r\n%s\r\n", str_replace(array('#first_name#', '#last_name#', '#title#'), array($worker->first_name, $worker->last_name, $worker->title), $sig));
}
/**
* Enter description here...
*
* @param CerberusParserMessage $message
* @return integer
*/
public static function parseMessage(CerberusParserMessage $message, $options = array())
{
/*
* options:
* 'no_autoreply'
*/
$logger = DevblocksPlatform::getConsoleLog();
$settings = DevblocksPlatform::getPluginSettingsService();
$helpdesk_senders = CerberusApplication::getHelpdeskSenders();
// Pre-parse mail filters
$pre_filters = Model_PreParseRule::getMatches($message);
if (is_array($pre_filters) && !empty($pre_filters)) {
// Load filter action manifests for reuse
$ext_action_mfts = DevblocksPlatform::getExtensions('cerberusweb.mail_filter.action', false);
// Loop through all matching filters
foreach ($pre_filters as $pre_filter) {
// Do something with matching filter's actions
foreach ($pre_filter->actions as $action_key => $action) {
switch ($action_key) {
case 'blackhole':
return NULL;
break;
case 'redirect':
@($to = $action['to']);
CerberusMail::reflect($message, $to);
return NULL;
break;
case 'bounce':
@($msg = $action['message']);
@($subject = 'Delivery failed: ' . self::fixQuotePrintableString($message->headers['subject']));
// [TODO] Follow the RFC spec on a true bounce
if (null != ($fromAddressInst = CerberusParser::getAddressFromHeaders($message->headers))) {
CerberusMail::quickSend($fromAddressInst->email, $subject, $msg);
}
return NULL;
break;
default:
// Plugin pre-parser filter actions
if (isset($ext_action_mfts[$action_key])) {
if (null != @($ext_action = $ext_action_mfts[$action_key]->createInstance())) {
try {
/* @var $ext_action Extension_MailFilterAction */
$ext_action->run($pre_filter, $message);
} catch (Exception $e) {
}
}
}
break;
}
}
}
}
$headers =& $message->headers;
// From
if (null == ($fromAddressInst = CerberusParser::getAddressFromHeaders($headers))) {
$logger->err("[Parser] 'From' address could not be created.");
return NULL;
}
// To/Cc/Bcc
$to = array();
$sTo = @$headers['to'];
$bIsNew = true;
if (!empty($sTo)) {
// [TODO] Do we still need this RFC address parser?
$to = CerberusParser::parseRfcAddress($sTo);
}
// Subject
// Fix quote printable subject (quoted blocks can appear anywhere in subject)
$sSubject = "";
if (isset($headers['subject']) && !empty($headers['subject'])) {
$sSubject = $headers['subject'];
if (is_array($sSubject)) {
$sSubject = array_shift($sSubject);
}
}
// The subject can still end up empty after QP decode
if (empty($sSubject)) {
$sSubject = "(no subject)";
}
// Date
$iDate = @strtotime($headers['date']);
// If blank, or in the future, set to the current date
if (empty($iDate) || $iDate > time()) {
$iDate = time();
}
// Is banned?
if (1 == $fromAddressInst->is_banned) {
$logger->info("[Parser] Ignoring ticket from banned address: " . $fromAddressInst->email);
return NULL;
}
// Overloadable
$enumSpamTraining = '';
// Message Id / References / In-Reply-To
@($sMessageId = $headers['message-id']);
$body_append_text = array();
$body_append_html = array();
// [mdf]Check attached files before creating the ticket because we may need to overwrite the message-id
// also store any contents of rfc822 files so we can include them after the body
foreach ($message->files as $filename => $file) {
/* @var $file ParserFile */
switch ($file->mime_type) {
case 'message/rfc822':
$full_filename = $file->tmpname;
$mail = mailparse_msg_parse_file($full_filename);
$struct = mailparse_msg_get_structure($mail);
$msginfo = mailparse_msg_get_part_data($mail);
$inline_headers = $msginfo['headers'];
if (isset($headers['from']) && (strtolower(substr($headers['from'], 0, 11)) == 'postmaster@' || strtolower(substr($headers['from'], 0, 14)) == 'mailer-daemon@')) {
$headers['in-reply-to'] = $inline_headers['message-id'];
}
break;
}
}
// [JAS] [TODO] References header may contain multiple message-ids to find
if (null != ($ids = self::findParentMessage($headers))) {
$bIsNew = false;
$id = $ids['ticket_id'];
$msgid = $ids['message_id'];
// Is it a worker reply from an external client? If so, proxy
if (null != ($worker_address = DAO_AddressToWorker::getByAddress($fromAddressInst->email))) {
$logger->info("[Parser] Handling an external worker response from " . $fromAddressInst->email);
if (!DAO_Ticket::isTicketRequester($worker_address->address, $id)) {
// Watcher Commands [TODO] Document on wiki/etc
if (0 != ($matches = preg_match_all("/\\[(.*?)\\]/i", $message->headers['subject'], $commands))) {
@($command = strtolower(array_pop($commands[1])));
$logger->info("[Parser] Worker command: " . $command);
switch ($command) {
case 'close':
DAO_Ticket::updateTicket($id, array(DAO_Ticket::IS_CLOSED => CerberusTicketStatus::CLOSED));
break;
case 'take':
DAO_Ticket::updateTicket($id, array(DAO_Ticket::NEXT_WORKER_ID => $worker_address->worker_id));
break;
case 'comment':
$comment_id = DAO_TicketComment::create(array(DAO_TicketComment::ADDRESS_ID => $fromAddressInst->id, DAO_TicketComment::CREATED => time(), DAO_TicketComment::TICKET_ID => $id, DAO_TicketComment::COMMENT => $message->body));
return $id;
break;
default:
// Typo?
break;
}
}
$attachment_files = array();
$attachment_files['name'] = array();
$attachment_files['type'] = array();
$attachment_files['tmp_name'] = array();
$attachment_files['size'] = array();
$i = 0;
foreach ($message->files as $filename => $file) {
$attachment_files['name'][$i] = $filename;
$attachment_files['type'][$i] = $file->mime_type;
$attachment_files['tmp_name'][$i] = $file->tmpname;
$attachment_files['size'][$i] = $file->file_size;
$i++;
}
CerberusMail::sendTicketMessage(array('message_id' => $msgid, 'content' => $message->body, 'files' => $attachment_files, 'agent_id' => $worker_address->worker_id));
return $id;
} else {
// ... worker is a requester, treat as normal
$logger->info("[Parser] The external worker was a ticket requester, so we're not treating them as a watcher.");
}
} else {
// Reply: Not sent by a worker
/*
* [TODO] check that this sender is a requester on the matched ticket
* Otherwise blank out the $id
*/
}
}
$group_id = 0;
if (empty($id)) {
// New Ticket
$sMask = CerberusApplication::generateTicketMask();
$groups = DAO_Group::getAll();
// Routing new tickets
if (null != ($routing_rules = Model_MailToGroupRule::getMatches($fromAddressInst, $message))) {
if (is_array($routing_rules)) {
foreach ($routing_rules as $rule) {
// Only end up with the last 'move' action (ignore the previous)
if (isset($rule->actions['move'])) {
$group_id = intval($rule->actions['move']['group_id']);
// We don't need to move again when running rule actions
unset($rule->actions['move']);
}
}
}
}
// Make sure the group exists
if (!isset($groups[$group_id])) {
$group_id = null;
}
// Last ditch effort to check for a default group to deliver to
if (empty($group_id)) {
if (null != ($default_team = DAO_Group::getDefaultGroup())) {
$group_id = $default_team->id;
} else {
// Bounce
return null;
}
}
// [JAS] It's important to not set the group_id on the ticket until the messages exist
// or inbox filters will just abort.
$fields = array(DAO_Ticket::MASK => $sMask, DAO_Ticket::SUBJECT => $sSubject, DAO_Ticket::IS_CLOSED => 0, DAO_Ticket::FIRST_WROTE_ID => intval($fromAddressInst->id), DAO_Ticket::LAST_WROTE_ID => intval($fromAddressInst->id), DAO_Ticket::CREATED_DATE => $iDate, DAO_Ticket::UPDATED_DATE => $iDate, DAO_Ticket::LAST_ACTION_CODE => CerberusTicketActionCode::TICKET_OPENED);
$id = DAO_Ticket::createTicket($fields);
// Apply routing actions to our new ticket ID
if (isset($routing_rules) && is_array($routing_rules)) {
foreach ($routing_rules as $rule) {
$rule->run($id);
}
}
}
// [JAS]: Add requesters to the ticket
if (!empty($fromAddressInst->id) && !empty($id)) {
// Don't add a requester if the sender is a helpdesk address
if (isset($helpdesk_senders[$fromAddressInst->email])) {
$logger->info("[Parser] Not adding ourselves as a requester: " . $fromAddressInst->email);
} else {
DAO_Ticket::createRequester($fromAddressInst->id, $id);
}
}
// Add the other TO/CC addresses to the ticket
// [TODO] This should be cleaned up and optimized
if ($settings->get('cerberusweb.core', CerberusSettings::PARSER_AUTO_REQ, 0)) {
@($autoreq_exclude_list = $settings->get('cerberusweb.core', CerberusSettings::PARSER_AUTO_REQ_EXCLUDE, ''));
$destinations = self::getDestinations($headers);
if (is_array($destinations) && !empty($destinations)) {
// Filter out any excluded requesters
if (!empty($autoreq_exclude_list)) {
@($autoreq_exclude = DevblocksPlatform::parseCrlfString($autoreq_exclude_list));
if (is_array($autoreq_exclude) && !empty($autoreq_exclude)) {
foreach ($autoreq_exclude as $excl_pattern) {
$excl_regexp = DevblocksPlatform::parseStringAsRegExp($excl_pattern);
// Check all destinations for this pattern
foreach ($destinations as $idx => $dest) {
if (@preg_match($excl_regexp, $dest)) {
unset($destinations[$idx]);
}
}
}
}
}
foreach ($destinations as $dest) {
if (null != ($destInst = CerberusApplication::hashLookupAddress($dest, true))) {
// Skip if the destination is one of our senders or the matching TO
if (isset($helpdesk_senders[$destInst->email])) {
continue;
}
DAO_Ticket::createRequester($destInst->id, $id);
}
}
}
}
$attachment_path = APP_STORAGE_PATH . '/attachments/';
// [TODO] This should allow external attachments (S3)
$fields = array(DAO_Message::TICKET_ID => $id, DAO_Message::CREATED_DATE => $iDate, DAO_Message::ADDRESS_ID => $fromAddressInst->id);
$email_id = DAO_Message::create($fields);
// Content
DAO_MessageContent::create($email_id, $message->body);
// Headers
foreach ($headers as $hk => $hv) {
DAO_MessageHeader::create($email_id, $hk, $hv);
}
// [mdf] Loop through files to insert attachment records in the db, and move temporary files
if (!empty($email_id)) {
foreach ($message->files as $filename => $file) {
/* @var $file ParserFile */
//[mdf] skip rfc822 messages since we extracted their content above
if ($file->mime_type == 'message/rfc822') {
continue;
}
$fields = array(DAO_Attachment::MESSAGE_ID => $email_id, DAO_Attachment::DISPLAY_NAME => $filename, DAO_Attachment::MIME_TYPE => $file->mime_type, DAO_Attachment::FILE_SIZE => intval($file->file_size));
$file_id = DAO_Attachment::create($fields);
if (empty($file_id)) {
@unlink($file->tmpname);
// remove our temp file
continue;
}
// Make file attachments use buckets so we have a max per directory
$attachment_bucket = sprintf("%03d/", mt_rand(1, 100));
$attachment_file = $file_id;
if (!file_exists($attachment_path . $attachment_bucket)) {
@mkdir($attachment_path . $attachment_bucket, 0770, true);
// [TODO] Needs error checking
}
rename($file->getTempFile(), $attachment_path . $attachment_bucket . $attachment_file);
// [TODO] Split off attachments into its own DAO
DAO_Attachment::update($file_id, array(DAO_Attachment::FILEPATH => $attachment_bucket . $attachment_file));
}
}
// Pre-load custom fields
if (isset($message->custom_fields) && !empty($message->custom_fields)) {
foreach ($message->custom_fields as $cf_id => $cf_val) {
if (is_array($cf_val) && !empty($cf_val) || !is_array($cf_val) && 0 != strlen($cf_val)) {
DAO_CustomFieldValue::setFieldValue('cerberusweb.fields.source.ticket', $id, $cf_id, $cf_val);
}
}
}
// Finalize our new ticket details (post-message creation)
if ($bIsNew && !empty($id) && !empty($email_id)) {
// First thread (needed for anti-spam)
DAO_Ticket::updateTicket($id, array(DAO_Ticket::FIRST_MESSAGE_ID => $email_id));
// Prime the change fields (which a few things like anti-spam might change before we commit)
$change_fields = array(DAO_Ticket::TEAM_ID => $group_id);
$out = CerberusBayes::calculateTicketSpamProbability($id);
if (!empty($group_id)) {
@($spam_threshold = DAO_GroupSettings::get($group_id, DAO_GroupSettings::SETTING_SPAM_THRESHOLD, 80));
@($spam_action = DAO_GroupSettings::get($group_id, DAO_GroupSettings::SETTING_SPAM_ACTION, ''));
@($spam_action_param = DAO_GroupSettings::get($group_id, DAO_GroupSettings::SETTING_SPAM_ACTION_PARAM, ''));
if ($out['probability'] * 100 >= $spam_threshold) {
$enumSpamTraining = CerberusTicketSpamTraining::SPAM;
switch ($spam_action) {
default:
case 0:
// do nothing
break;
case 1:
// delete
$change_fields[DAO_Ticket::IS_CLOSED] = 1;
$change_fields[DAO_Ticket::IS_DELETED] = 1;
break;
case 2:
// move
$buckets = DAO_Bucket::getAll();
// Verify bucket exists
if (!empty($spam_action_param) && isset($buckets[$spam_action_param])) {
$change_fields[DAO_Ticket::TEAM_ID] = $group_id;
$change_fields[DAO_Ticket::CATEGORY_ID] = $spam_action_param;
}
break;
}
}
}
// end spam training
// Save properties
if (!empty($change_fields)) {
DAO_Ticket::updateTicket($id, $change_fields);
}
}
// Reply notifications (new messages are handled by 'move' listener)
if (!$bIsNew) {
// Inbound Reply Event
$eventMgr = DevblocksPlatform::getEventService();
$eventMgr->trigger(new Model_DevblocksEvent('ticket.reply.inbound', array('ticket_id' => $id)));
}
// New ticket processing
if ($bIsNew) {
// Auto reply
@($autoreply_enabled = DAO_GroupSettings::get($group_id, DAO_GroupSettings::SETTING_AUTO_REPLY_ENABLED, 0));
@($autoreply = DAO_GroupSettings::get($group_id, DAO_GroupSettings::SETTING_AUTO_REPLY, ''));
/*
* Send the group's autoreply if one exists, as long as this ticket isn't spam
*/
if (!isset($options['no_autoreply']) && $autoreply_enabled && !empty($autoreply) && $enumSpamTraining != CerberusTicketSpamTraining::SPAM) {
CerberusMail::sendTicketMessage(array('ticket_id' => $id, 'message_id' => $email_id, 'content' => str_replace(array('#ticket_id#', '#mask#', '#subject#', '#timestamp#', '#sender#', '#sender_first#', '#orig_body#'), array($id, $sMask, $sSubject, date('r'), $fromAddressInst->email, $fromAddressInst->first_name, ltrim($message->body)), $autoreply), 'is_autoreply' => true, 'dont_keep_copy' => true));
}
}
// end bIsNew
unset($message);
// Re-open and update our date on new replies
if (!$bIsNew) {
DAO_Ticket::updateTicket($id, array(DAO_Ticket::UPDATED_DATE => time(), DAO_Ticket::IS_WAITING => 0, DAO_Ticket::IS_CLOSED => 0, DAO_Ticket::IS_DELETED => 0, DAO_Ticket::LAST_WROTE_ID => $fromAddressInst->id, DAO_Ticket::LAST_ACTION_CODE => CerberusTicketActionCode::TICKET_CUSTOMER_REPLY));
// [TODO] The TICKET_CUSTOMER_REPLY should be sure of this message address not being a worker
}
@imap_errors();
// Prevent errors from spilling out into STDOUT
return $id;
}
private function _sendConfirmationEmail($to, $worker)
{
$translate = DevblocksPlatform::getTranslationService();
$settings = DevblocksPlatform::getPluginSettingsService();
$url_writer = DevblocksPlatform::getUrlService();
$tpl = DevblocksPlatform::getTemplateService();
// Tentatively assign the e-mail address to this worker
DAO_AddressToWorker::assign($to, $worker->id);
// Create a confirmation code and save it
$code = CerberusApplication::generatePassword(20);
DAO_AddressToWorker::update($to, array(DAO_AddressToWorker::CODE => $code, DAO_AddressToWorker::CODE_EXPIRE => time() + 24 * 60 * 60));
// Email the confirmation code to the address
// [TODO] This function can return false, and we need to do something different if it does.
CerberusMail::quickSend($to, vsprintf($translate->_('prefs.address.confirm.mail.subject'), $settings->get('cerberusweb.core', CerberusSettings::HELPDESK_TITLE)), vsprintf($translate->_('prefs.address.confirm.mail.body'), array($worker->getName(), $url_writer->write('c=preferences&a=confirm_email&code=' . $code, true))));
$output = array(vsprintf($translate->_('prefs.address.confirm.mail.subject'), $to));
$tpl->assign('pref_success', $output);
}
function saveLicensesAction()
{
$translate = DevblocksPlatform::getTranslationService();
$settings = DevblocksPlatform::getPluginSettingsService();
$worker = FegApplication::getActiveWorker();
if (!$worker || !$worker->is_superuser) {
echo $translate->_('common.access_denied');
return;
}
@($name = DevblocksPlatform::importGPC($_POST['company_name'], 'string', ''));
@($serial = DevblocksPlatform::importGPC($_POST['company_serial'], 'string', ''));
@($email = DevblocksPlatform::importGPC($_POST['email'], 'string', ''));
@($do_delete = DevblocksPlatform::importGPC($_POST['do_delete'], 'integer', 0));
if (!empty($do_delete)) {
$settings->set('feg.core', FegSettings::LICENSE, '');
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('setup', 'settings')));
return;
}
if (empty($name) || empty($serial) || empty($email)) {
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('setup', 'settings', 'empty')));
return;
}
if (null == ($valid = FegLicense::validate($name, $serial, $email)) || 5 != count($valid)) {
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('setup', 'settings', 'invalid')));
return;
}
/*
* [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://feg.answernet.com/
*/
$license = $valid;
$settings->set('feg.core', FegSettings::LICENSE, serialize($license));
DevblocksPlatform::setHttpResponse(new DevblocksHttpResponse(array('setup', 'settings')));
}
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']);
@($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 import()
{
$sources = DAO_ForumsSource::getWhere();
$settings = DevblocksPlatform::getPluginSettingsService();
// Track posters that are also workers
$poster_workers = array();
if (null != ($poster_workers_str = $settings->get('cerberusweb.core', ChForumsPlugin::SETTING_POSTER_WORKERS, null))) {
$poster_workers = DevblocksPlatform::parseCrlfString($poster_workers_str);
}
foreach ($sources as $source) {
/* @var $source Model_ForumsSource */
// [TODO] Convert to REST client (move into Devblocks)
$source_url = sprintf("%s?lastpostid=%d&limit=100", $source->url, $source->last_postid);
$xml_in = file_get_contents($source_url);
$xml = new SimpleXMLElement($xml_in);
$last_postid = 0;
foreach ($xml->thread as $thread) {
@($thread_id = (string) $thread->id);
@($thread_title = (string) $thread->title);
@($thread_last_updated = (string) $thread->last_updated);
@($thread_last_postid = (string) $thread->last_postid);
@($thread_last_poster = (string) $thread->last_poster);
@($thread_link = (string) $thread->link);
if (null == ($th = DAO_ForumsThread::getBySourceThreadId($source->id, $thread_id))) {
$fields = array(DAO_ForumsThread::FORUM_ID => $source->id, DAO_ForumsThread::THREAD_ID => $thread_id, DAO_ForumsThread::TITLE => $thread_title, DAO_ForumsThread::LAST_UPDATED => intval($thread_last_updated), DAO_ForumsThread::LAST_POSTER => $thread_last_poster, DAO_ForumsThread::LINK => $thread_link);
DAO_ForumsThread::create($fields);
} else {
// If the last post was a worker, leave the thread at the current closed state
$closed = false === array_search(strtolower($thread_last_poster), $poster_workers) ? 0 : $th->is_closed;
$fields = array(DAO_ForumsThread::LAST_UPDATED => intval($thread_last_updated), DAO_ForumsThread::LAST_POSTER => $thread_last_poster, DAO_ForumsThread::LINK => $thread_link, DAO_ForumsThread::IS_CLOSED => $closed);
DAO_ForumsThread::update($th->id, $fields);
}
$last_postid = $thread_last_postid;
}
// foreach($xml->thread)
// Save our progress to the database
if (!empty($last_postid)) {
DAO_ForumsSource::update($source->id, array(DAO_ForumsSource::LAST_POSTID => $last_postid));
}
}
// foreach($sources)
}