function parse($value)
{
if (!$value) {
return null;
}
$config = $this->getConfiguration();
return $config['gmt'] ? Misc::db2gmtime($value) : $value;
}
function cacheable($etag, $modified, $ttl = 3600)
{
// Thanks, http://stackoverflow.com/a/1583753/1025836
$last_modified = Misc::db2gmtime($modified);
header("Last-Modified: " . date('D, d M y H:i:s', $last_modified) . " GMT", false);
header('ETag: "' . $etag . '"');
header("Cache-Control: private, max-age={$ttl}");
header('Expires: ' . gmdate(DATE_RFC822, time() + $ttl) . " GMT");
header('Pragma: private');
if (@strtotime($_SERVER['HTTP_IF_MODIFIED_SINCE']) == $last_modified || @trim($_SERVER['HTTP_IF_NONE_MATCH']) == $etag) {
header("HTTP/1.1 304 Not Modified");
exit;
}
}
<?php
if (!defined('KTKADMININC') || !is_object($ticket) || !is_object($thisuser) || !$thisuser->isStaff()) {
die(_('Access Denied'));
}
if (!($thisuser->canEditTickets() || $thisuser->isManager() && $ticket->getDeptId() == $thisuser->getDeptId())) {
die(_('Access Denied. Perm error.'));
}
if ($_POST && $errors) {
$info = Format::input($_POST);
} else {
$info = array('email' => $ticket->getEmail(), 'name' => $ticket->getName(), 'phone' => $ticket->getPhone(), 'pri' => $ticket->getPriorityId(), 'topicId' => $ticket->getTopicId(), 'topic' => $ticket->getTopic(), 'subject' => $ticket->getSubject(), 'duedate' => $ticket->getDueDate() ? Format::userdate('m/d/Y', Misc::db2gmtime($ticket->getDueDate())) : '', 'time' => $ticket->getDueDate() ? Format::userdate('G:i', Misc::db2gmtime($ticket->getDueDate())) : '');
}
?>
<div width="100%">
<?php
if ($errors['err']) {
?>
<p align="center" id="errormessage"><?php
echo $errors['err'];
?>
</p>
<?php
} elseif ($msg) {
?>
<p align="center" class="infomessage"><?php
echo $msg;
?>
</p>
<?php
} elseif ($warn) {
if ($entry->flags & ThreadEntry::FLAG_EDITED) {
?>
<span class="label label-bare" title="<?php
echo sprintf(__('Edited on %s by %s'), Format::datetime($entry->updated), 'You');
?>
"><?php
echo __('Edited');
?>
</span>
<?php
}
?>
</span>
</div>
<?php
echo sprintf(__('<b>%s</b> posted %s'), $name, sprintf('<time class="relative" datetime="%s" title="%s">%s</time>', date(DateTime::W3C, Misc::db2gmtime($entry->created)), Format::daydatetime($entry->created), Format::relativeTime(Misc::db2gmtime($entry->created))));
?>
<span style="max-width:500px" class="faded title truncate"><?php
echo $entry->title;
?>
</span>
</span>
</div>
<div class="thread-body" id="thread-id-<?php
echo $entry->getId();
?>
">
<div><?php
echo $entry->getBody()->toHtml();
?>
</div>
function db_daydatetime($time)
{
global $cfg;
return Format::userdate($cfg->getDayDateTimeFormat(), Misc::db2gmtime($time));
}
if(!($thisuser->canEditTickets() || ($thisuser->isManager() && $ticket->getDeptId()==$thisuser->getDeptId()))) die('Access Denied. Perm error.');
if($_POST && $errors){
$info=Format::input($_POST);
}else{
$info=array('email'=>$ticket->getEmail(),
'name' =>$ticket->getName(),
'phone'=>$ticket->getPhone(),
'phone_ext'=>$ticket->getPhoneExt(),
'pri'=>$ticket->getPriorityId(),
'topicId'=>$ticket->getTopicId(),
'topic'=>$ticket->getHelpTopic(),
'subject' =>$ticket->getSubject(),
'duedate' =>$ticket->getDueDate()?(Format::userdate('m/d/Y',Misc::db2gmtime($ticket->getDueDate()))):'',
'time'=>$ticket->getDueDate()?(Format::userdate('G:i',Misc::db2gmtime($ticket->getDueDate()))):'',
);
/*Note: Please don't make me explain how dates work - it is torture. Trust me! */
}
?>
<div width="100%">
<?if($errors['err']) {?>
<p align="center" id="errormessage"><?=$errors['err']?></p>
<?}elseif($msg) {?>
<p align="center" class="infomessage"><?=$msg?></p>
<?}elseif($warn) {?>
<p class="warnmessage"><?=$warn?></p>
<?}?>
</div>
<table width="100%" border="0" cellspacing=1 cellpadding=2>
function update($vars, &$errors)
{
global $cfg, $thisstaff;
if (!$cfg || !$thisstaff || !$thisstaff->canEditTickets()) {
return false;
}
$fields = array();
$fields['topicId'] = array('type' => 'int', 'required' => 1, 'error' => __('Help topic selection is required'));
$fields['slaId'] = array('type' => 'int', 'required' => 0, 'error' => __('Select a valid SLA'));
$fields['duedate'] = array('type' => 'date', 'required' => 0, 'error' => __('Invalid date format - must be MM/DD/YY'));
$fields['note'] = array('type' => 'text', 'required' => 1, 'error' => __('A reason for the update is required'));
$fields['user_id'] = array('type' => 'int', 'required' => 0, 'error' => __('Invalid user-id'));
if (!Validator::process($fields, $vars, $errors) && !$errors['err']) {
$errors['err'] = __('Missing or invalid data - check the errors and try again');
}
if ($vars['duedate']) {
if ($this->isClosed()) {
$errors['duedate'] = __('Due date can NOT be set on a closed ticket');
} elseif (!$vars['time'] || strpos($vars['time'], ':') === false) {
$errors['time'] = __('Select a time from the list');
} elseif (strtotime($vars['duedate'] . ' ' . $vars['time']) === false) {
$errors['duedate'] = __('Invalid due date');
} elseif (strtotime($vars['duedate'] . ' ' . $vars['time']) <= time()) {
$errors['duedate'] = __('Due date must be in the future');
}
}
// Validate dynamic meta-data
$forms = DynamicFormEntry::forTicket($this->getId());
foreach ($forms as $form) {
// Don't validate deleted forms
if (!in_array($form->getId(), $vars['forms'])) {
continue;
}
$form->setSource($_POST);
if (!$form->isValid()) {
$errors = array_merge($errors, $form->errors());
}
}
if ($errors) {
return false;
}
$sql = 'UPDATE ' . TICKET_TABLE . ' SET updated=NOW() ' . ' ,topic_id=' . db_input($vars['topicId']) . ' ,sla_id=' . db_input($vars['slaId']) . ' ,source=' . db_input($vars['source']) . ' ,duedate=' . ($vars['duedate'] ? db_input(date('Y-m-d G:i', Misc::dbtime($vars['duedate'] . ' ' . $vars['time']))) : 'NULL');
if ($vars['user_id']) {
$sql .= ', user_id=' . db_input($vars['user_id']);
}
if ($vars['duedate']) {
//We are setting new duedate...
$sql .= ' ,isoverdue=0';
}
$sql .= ' WHERE ticket_id=' . db_input($this->getId());
if (!db_query($sql) || !db_affected_rows()) {
return false;
}
if (!$vars['note']) {
$vars['note'] = sprintf(_S('Ticket details updated by %s'), $thisstaff->getName());
}
$this->logNote(_S('Ticket Updated'), $vars['note'], $thisstaff);
// Decide if we need to keep the just selected SLA
$keepSLA = $this->getSLAId() != $vars['slaId'];
// Update dynamic meta-data
foreach ($forms as $f) {
// Drop deleted forms
$idx = array_search($f->getId(), $vars['forms']);
if ($idx === false) {
$f->delete();
} else {
$f->set('sort', $idx);
$f->save();
}
}
// Reload the ticket so we can do further checking
$this->reload();
// Reselect SLA if transient
if (!$keepSLA && (!$this->getSLA() || $this->getSLA()->isTransient())) {
$this->selectSLAId();
}
// Clear overdue flag if duedate or SLA changes and the ticket is no longer overdue.
if ($this->isOverdue() && (!$this->getEstDueDate() || Misc::db2gmtime($this->getEstDueDate()) > Misc::gmtime())) {
$this->clearOverdue();
}
Signal::send('model.updated', $this);
return true;
}
function getUpdateInfo()
{
$info = array('name' => $this->getName(), 'email' => $this->getEmail(), 'phone' => $this->getPhone(), 'phone_ext' => $this->getPhoneExt(), 'subject' => $this->getSubject(), 'source' => $this->getSource(), 'topicId' => $this->getTopicId(), 'priorityId' => $this->getPriorityId(), 'slaId' => $this->getSLAId(), 'duedate' => $this->getDueDate() ? Format::userdate('m/d/Y', Misc::db2gmtime($this->getDueDate())) : '', 'time' => $this->getDueDate() ? Format::userdate('G:i', Misc::db2gmtime($this->getDueDate())) : '');
return $info;
}
function update($vars, &$errors)
{
global $cfg, $thisstaff;
if (!$cfg || !$thisstaff || !$thisstaff->canEditTickets()) {
return false;
}
$fields = array();
$fields['topicId'] = array('type' => 'int', 'required' => 1, 'error' => 'Help topic required');
$fields['slaId'] = array('type' => 'int', 'required' => 0, 'error' => 'Select SLA');
$fields['duedate'] = array('type' => 'date', 'required' => 0, 'error' => 'Invalid date - must be MM/DD/YY');
$fields['note'] = array('type' => 'text', 'required' => 1, 'error' => 'Reason for the update required');
$fields['user_id'] = array('type' => 'int', 'required' => 0, 'error' => 'Invalid user-id');
if (!Validator::process($fields, $vars, $errors) && !$errors['err']) {
$errors['err'] = 'Missing or invalid data - check the errors and try again';
}
if ($vars['duedate']) {
if ($this->isClosed()) {
$errors['duedate'] = 'Due date can NOT be set on a closed ticket';
} elseif (!$vars['time'] || strpos($vars['time'], ':') === false) {
$errors['time'] = 'Select time';
} elseif (strtotime($vars['duedate'] . ' ' . $vars['time']) === false) {
$errors['duedate'] = 'Invalid due date';
} elseif (strtotime($vars['duedate'] . ' ' . $vars['time']) <= time()) {
$errors['duedate'] = 'Due date must be in the future';
}
}
if ($errors) {
return false;
}
$sql = 'UPDATE ' . TICKET_TABLE . ' SET updated=NOW() ' . ' ,topic_id=' . db_input($vars['topicId']) . ' ,sla_id=' . db_input($vars['slaId']) . ' ,source=' . db_input($vars['source']) . ' ,duedate=' . ($vars['duedate'] ? db_input(date('Y-m-d G:i', Misc::dbtime($vars['duedate'] . ' ' . $vars['time']))) : 'NULL');
if ($vars['user_id']) {
$sql .= ', user_id=' . db_input($vars['user_id']);
}
if ($vars['duedate']) {
//We are setting new duedate...
$sql .= ' ,isoverdue=0';
}
$sql .= ' WHERE ticket_id=' . db_input($this->getId());
if (!db_query($sql) || !db_affected_rows()) {
return false;
}
if (!$vars['note']) {
$vars['note'] = sprintf('Ticket Updated by %s', $thisstaff->getName());
}
$this->logNote('Ticket Updated', $vars['note'], $thisstaff);
// Decide if we need to keep the just selected SLA
$keepSLA = $this->getSLAId() != $vars['slaId'];
// Reload the ticket so we can do further checking
$this->reload();
// Reselect SLA if transient
if (!$keepSLA && (!$this->getSLA() || $this->getSLA()->isTransient())) {
$this->selectSLAId();
}
// Clear overdue flag if duedate or SLA changes and the ticket is no longer overdue.
if ($this->isOverdue() && (!$this->getEstDueDate() || Misc::db2gmtime($this->getEstDueDate()) > Misc::gmtime())) {
$this->clearOverdue();
}
return true;
}
echo $htmlId;
?>
" data-thread-id="<?php
echo $this->getId();
?>
">-->
<?php
if (count($entries)) {
// Go through all the entries and bucket them by time frame
$buckets = array();
$rel = 0;
foreach ($entries as $i => $E) {
// First item _always_ shows up
if ($i != 0) {
// Set relative time resolution to 12 hours
$rel = Format::relativeTime(Misc::db2gmtime($E->created, false, 43200));
}
$buckets[$rel][] = $E;
}
// Go back through the entries and render them on the page
//echo "test: " . json_encode($buckets);
$i = 0;
foreach ($buckets as $rel => $entries) {
// TODO: Consider adding a date boundary to indicate significant
// changes in dates between thread items.
foreach ($entries as $entry) {
// Emit all events prior to this entry
while ($event && $event->timestamp < $entry->created) {
$event->render(ThreadEvent::MODE_CLIENT);
$events->next();
$event = $events->current();
<?php
if (!defined('OSTSCPINC') || !is_object($ticket) || !is_object($thisuser) || !$thisuser->isStaff()) {
die('Access Denied');
}
if (!($thisuser->canEditTickets() || $thisuser->isManager() && $ticket->getDeptId() == $thisuser->getDeptId())) {
die('Access Denied. Perm error.');
}
if ($_POST && $errors) {
$info = Format::input($_POST);
} else {
$info = array('email' => $ticket->getEmail(), 'name' => $ticket->getName(), 'phone' => $ticket->getPhone(), 'phone_ext' => $ticket->getPhoneExt(), 'pri' => $ticket->getPriorityId(), 'topicId' => $ticket->getTopicId(), 'topic' => $ticket->getHelpTopic(), 'subject' => Format::htmlchars($ticket->getSubject()), 'assetid' => $ticket->getAssetId(), 'tickettypeid' => $ticket->getTicketTypeId(), 'duedate' => $ticket->getDueDate() ? Format::userdate('m/d/Y', Misc::db2gmtime($ticket->getDueDate())) : '', 'time' => $ticket->getDueDate() ? Format::userdate('G:i', Misc::db2gmtime($ticket->getDueDate())) : '');
/*Note: Please don't make me explain how dates work - it is torture. Trust me! */
}
?>
<script type="text/javascript">
function change(){
var text=document.forms["form"]["subject"].value;
var len = text.length;
var s = text;
for(i=0; i<len; i++)
{
s = s.replace(/[\u2018|\u2019|\u201A]/g, "\'");
// smart double quotes
s = s.replace(/[\u201C|\u201D|\u201E]/g, "\"");
// ellipsis
s = s.replace(/\u2026/g, "...");
function getVar($tag)
{
global $cfg;
if ($tag && is_callable(array($this, 'get' . ucfirst($tag)))) {
return call_user_func(array($this, 'get' . ucfirst($tag)));
}
switch (strtolower($tag)) {
case 'create_date':
return Format::date($cfg->getDateTimeFormat(), Misc::db2gmtime($this->getCreateDate()), $cfg->getTZOffset(), $cfg->observeDaylightSaving());
break;
case 'update_date':
return Format::date($cfg->getDateTimeFormat(), Misc::db2gmtime($this->getUpdateDate()), $cfg->getTZOffset(), $cfg->observeDaylightSaving());
break;
}
return false;
}
function update($vars, &$errors)
{
global $cfg, $thisstaff;
if (!$cfg || !$thisstaff || !$thisstaff->canEditTickets()) {
return false;
}
$fields = array();
$fields['name'] = array('type' => 'string', 'required' => 1, 'error' => 'Name required');
$fields['email'] = array('type' => 'email', 'required' => 1, 'error' => 'Valid email required');
$fields['subject'] = array('type' => 'string', 'required' => 1, 'error' => 'Subject required');
$fields['topicId'] = array('type' => 'int', 'required' => 1, 'error' => 'Help topic required');
$fields['priorityId'] = array('type' => 'int', 'required' => 1, 'error' => 'Priority required');
$fields['slaId'] = array('type' => 'int', 'required' => 0, 'error' => 'Select SLA');
$fields['phone'] = array('type' => 'phone', 'required' => 0, 'error' => 'Valid phone # required');
$fields['duedate'] = array('type' => 'date', 'required' => 0, 'error' => 'Invalid date - must be MM/DD/YY');
$fields['note'] = array('type' => 'text', 'required' => 1, 'error' => 'Reason for the update required');
if (!Validator::process($fields, $vars, $errors) && !$errors['err']) {
$errors['err'] = 'Missing or invalid data - check the errors and try again';
}
if ($vars['duedate']) {
if ($this->isClosed()) {
$errors['duedate'] = 'Due date can NOT be set on a closed ticket';
} elseif (!$vars['time'] || strpos($vars['time'], ':') === false) {
$errors['time'] = 'Select time';
} elseif (strtotime($vars['duedate'] . ' ' . $vars['time']) === false) {
$errors['duedate'] = 'Invalid due date';
} elseif (strtotime($vars['duedate'] . ' ' . $vars['time']) <= time()) {
$errors['duedate'] = 'Due date must be in the future';
}
}
//Make sure phone extension is valid
if ($vars['phone_ext']) {
if (!is_numeric($vars['phone_ext']) && !$errors['phone']) {
$errors['phone'] = 'Invalid phone ext.';
} elseif (!$vars['phone']) {
//make sure they just didn't enter ext without phone #
$errors['phone'] = 'Phone number required';
}
}
if ($errors) {
return false;
}
$sql = 'UPDATE ' . TICKET_TABLE . ' SET updated=NOW() ' . ' ,email=' . db_input($vars['email']) . ' ,name=' . db_input(Format::striptags($vars['name'])) . ' ,subject=' . db_input(Format::striptags($vars['subject'])) . ' ,phone="' . db_input($vars['phone'], false) . '"' . ' ,phone_ext=' . db_input($vars['phone_ext'] ? $vars['phone_ext'] : NULL) . ' ,priority_id=' . db_input($vars['priorityId']) . ' ,topic_id=' . db_input($vars['topicId']) . ' ,sla_id=' . db_input($vars['slaId']) . ' ,source=' . db_input($vars['source']) . ' ,duedate=' . ($vars['duedate'] ? db_input(date('Y-m-d G:i', Misc::dbtime($vars['duedate'] . ' ' . $vars['time']))) : 'NULL');
if ($vars['duedate']) {
//We are setting new duedate...
$sql .= ' ,isoverdue=0';
}
$sql .= ' WHERE ticket_id=' . db_input($this->getId());
if (!db_query($sql) || !db_affected_rows()) {
return false;
}
if (!$vars['note']) {
$vars['note'] = sprintf('Ticket Updated by %s', $thisstaff->getName());
}
$this->logNote('Ticket Updated', $vars['note'], $thisstaff);
$this->reload();
// Reselect SLA if transient
if (!$this->getSLAId() || $this->getSLA()->isTransient()) {
$this->selectSLAId();
}
//Clear overdue flag if duedate or SLA changes and the ticket is no longer overdue.
if ($this->isOverdue() && (!$this->getEstDueDate() || Misc::db2gmtime($this->getEstDueDate()) > Misc::gmtime())) {
$this->clearOverdue();
}
return true;
}
echo $category->getId();
?>
"><?php
echo $category->getName();
?>
</a>
</div>
<div class="faq-content">
<div class="article-title flush-left">
<?php
echo $faq->getLocalQuestion();
?>
</div>
<div class="faded"><?php
echo __('Last updated') . ' ' . Format::relativeTime(Misc::db2gmtime($category->getUpdateDate()));
?>
</div>
<br/>
<div class="thread-body bleed">
<?php
echo $faq->getLocalAnswerWithImages();
?>
</div>
</div>
</div>
<div class="span4 pull-right">
<div class="sidebar">
<div class="searchbar">
<form method="get" action="faq.php">
