function data_history($pData, $pParams)
{
global $gBitSystem, $gContent, $gBitSmarty;
//check package
if (!$gBitSystem->isPackageActive('tickets')) {
return '<div class=error>' . tra('Tickets Package Deactivated.') . '</div>';
}
//check if all parameters are given
$field = "id";
if (!array_key_exists($field, $pParams) || !is_numeric($pParams[$field])) {
return '<div class=error>' . tra('Parameter is wrong or not given: ') . $field . '. </div>';
}
require_once TICKETS_PKG_PATH . 'BitTicket.php';
//field $pParams with field names
$contextTicket = new BitTicket();
$contextTicket->getHistoryFieldNames($pParams[$field], $pParams);
$gBitSmarty->assign('def_title', $pParams['def_title']);
$gBitSmarty->assign('old_value', $pParams['old_value']);
$gBitSmarty->assign('new_value', $pParams['new_value']);
return $gBitSmarty->fetch('bitpackage:tickets/ticket_history.tpl');
}
<?php
// $Header$
// Copyright (c) 2004 bitweaver Tickets
// All Rights Reserved. See below for details and a complete list of authors.
// Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See http://www.gnu.org/copyleft/lesser.html for details.
// Initialization
require_once '../kernel/setup_inc.php';
// Is package installed and enabled
$gBitSystem->verifyPackage('tickets');
// Look up the content
require_once TICKETS_PKG_PATH . 'lookup_milestone_inc.php';
if (!$gContent->isValid()) {
$gBitSystem->setHttpStatus(404);
$gBitSystem->fatalError("The milestones you requested could not be found.");
}
// Now check permissions to access this content
$gContent->verifyViewPermission();
// Add a hit to the counter
$gContent->addHit();
// Get field definitions for listing tickets.
$ticket = new BitTicket();
$fieldDefinitions = $ticket->getFieldDefinitions();
$gBitSmarty->assign_by_ref('fieldDefinitions', $fieldDefinitions);
// Display the template
$gBitSystem->display('bitpackage:tickets/milestone_display.tpl', tra('Tickets'), array('display_mode' => 'display'));
<?php
// $Header$
require_once '../../kernel/setup_inc.php';
include_once TICKETS_PKG_PATH . 'BitTicket.php';
include_once TICKETS_PKG_PATH . 'lookup_tickets_inc.php';
// Is package installed and enabled
$gBitSystem->verifyPackage('tickets');
$gBitSystem->verifyPermission('p_tickets_admin');
$ticket = new BitTicket();
$fieldDefinitions = $ticket->getFieldDefinitions();
$gBitSmarty->assign_by_ref('fieldDefinitions', $fieldDefinitions);
$fieldValues = $ticket->getFieldValues();
$gBitSmarty->assign_by_ref('fieldValues', $fieldValues);
$gBitSystem->display('bitpackage:tickets/admin_definitions.tpl', tra('Edit Field Definitions'), array('display_mode' => 'admin'));
if (!$gContent->isValid()) {
$gBitSystem->setHttpStatus(404);
$gBitSystem->fatalError("The tickets you requested could not be found.");
}
// Now check permissions to access this content
$gContent->verifyViewPermission();
// Add a hit to the counter
$gContent->addHit();
if (is_object($gContent) && $gContent->isCommentable()) {
$commentsParentId = $gContent->mContentId;
$comments_vars = array(BITTICKET_CONTENT_TYPE_GUID);
$comments_prefix_var = BITTICKET_CONTENT_TYPE_GUID . ':';
$comments_object_var = BITTICKET_CONTENT_TYPE_GUID;
$comments_return_url = $gContent->getDisplayUrl();
$comments_sort_mode = "commentDate_asc";
$gBitSmarty->assign('item_display_comments', TRUE);
include_once LIBERTY_PKG_PATH . 'comments_inc.php';
}
// Get necessary lists.
$contextTicket = new BitTicket();
$fieldDefinitions = $contextTicket->getFieldDefinitions();
$gBitSmarty->assign('fieldDefinitions', $fieldDefinitions);
$fieldValues = $contextTicket->getFieldValues();
$gBitSmarty->assign('fieldValues', $fieldValues);
$milestone = new BitMilestone();
$pParamHash = array();
$milestones = $milestone->getList($pParamHash);
$gBitSmarty->assign('milestones', $milestones);
$gBitThemes->loadJavascript(TICKETS_PKG_PATH . 'scripts/BitTicket.js', TRUE);
// Display the template
$gBitSystem->display('bitpackage:tickets/ticket_display.tpl', tra('Tickets'), array('display_mode' => 'display'));
/**
* load Load the data from the database
*
* @access public
* @return boolean TRUE on success, FALSE on failure - mErrors will contain reason for failure
*/
function load()
{
if ($this->verifyId($this->mMilestoneId) || $this->verifyId($this->mContentId)) {
// LibertyContent::load()assumes you have joined already, and will not execute any sql!
// This is a significant performance optimization
$lookupColumn = $this->verifyId($this->mMilestoneId) ? 'milestone_id' : 'content_id';
$bindVars = array();
$selectSql = $joinSql = $whereSql = '';
array_push($bindVars, $lookupId = @BitBase::verifyId($this->mMilestoneId) ? $this->mMilestoneId : $this->mContentId);
$this->getServicesSql('content_load_sql_function', $selectSql, $joinSql, $whereSql, $bindVars);
$query = "\n\t\t\t\tSELECT tm.*, lc.*,\n\t\t\t\tuue.`login` AS modifier_user, uue.`real_name` AS modifier_real_name,\n\t\t\t\tuuc.`login` AS creator_user, uuc.`real_name` AS creator_real_name\n\t\t\t\t{$selectSql}\n\t\t\t\tFROM `" . BIT_DB_PREFIX . "ticket_milestone` tm\n\t\t\t\t\tINNER JOIN `" . BIT_DB_PREFIX . "liberty_content` lc ON( lc.`content_id` = tm.`content_id` ) {$joinSql}\n\t\t\t\t\tLEFT JOIN `" . BIT_DB_PREFIX . "users_users` uue ON( uue.`user_id` = lc.`modifier_user_id` )\n\t\t\t\t\tLEFT JOIN `" . BIT_DB_PREFIX . "users_users` uuc ON( uuc.`user_id` = lc.`user_id` )\n\t\t\t\tWHERE tm.`{$lookupColumn}`=? {$whereSql}";
$ticketQuery = "SELECT t.ticket_id\n FROM `" . BIT_DB_PREFIX . "tickets` t \n WHERE t.`milestone_id`=?";
$result = $this->mDb->query($query, $bindVars);
if ($result && $result->numRows()) {
$this->mInfo = $result->fields;
$this->mContentId = $result->fields['content_id'];
$this->mMilestoneId = $result->fields['milestone_id'];
$date = new BitDate();
$this->mDateFrom = $result->fields['date_from'];
$this->mDateTo = $result->fields['date_to'];
$this->mInfo['creator'] = !empty($result->fields['creator_real_name']) ? $result->fields['creator_real_name'] : $result->fields['creator_user'];
$this->mInfo['editor'] = !empty($result->fields['modifier_real_name']) ? $result->fields['modifier_real_name'] : $result->fields['modifier_user'];
$this->mInfo['display_name'] = BitUser::getTitleFromHash($this->mInfo);
$this->mInfo['display_url'] = $this->getDisplayUrl();
$this->mInfo['parsed_data'] = $this->parseData();
$ticketResult = $this->mDb->getCol($ticketQuery, array($this->mMilestoneId));
$ticket = new BitTicket();
$pParamHash = array();
$this->mTickets = $ticket->getList($pParamHash, $ticketResult);
LibertyMime::load();
}
}
return count($this->mInfo);
}
<?php
// $Header$
// Copyright (c) 2005 bitweaver Tickets
// All Rights Reserved. See below for details and a complete list of authors.
// Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See http://www.gnu.org/copyleft/lesser.html for details.
// is this used?
//if (isset($_REQUEST["ticketsset"]) && isset($_REQUEST["homeTickets"])) {
// $gBitSystem->storeConfig("home_tickets", $_REQUEST["homeTickets"]);
// $gBitSmarty->assign('home_tickets', $_REQUEST["homeTickets"]);
//}
require_once TICKETS_PKG_PATH . 'BitTicket.php';
$formTicketsLists = array("tickets_list_ticket_id" => array('label' => 'Id', 'note' => 'Display the tickets id.'), "tickets_list_title" => array('label' => 'Title', 'note' => 'Display the title.'), "tickets_list_data" => array('label' => 'Text', 'note' => 'Display the text.'));
$gBitSmarty->assign('formTicketsLists', $formTicketsLists);
$processForm = set_tab();
if ($processForm) {
$ticketsToggles = array_merge($formTicketsLists);
foreach ($ticketsToggles as $item => $data) {
simple_set_toggle($item, 'tickets');
}
}
$ticket = new BitTicket();
$tickets = $ticket->getList($_REQUEST);
$gBitSmarty->assign_by_ref('tickets', $tickets['data']);
$tmpPage = new BitTicket($del);
if ($tmpPage->load() && !empty($tmpPage->mInfo['title'])) {
$info = $tmpPage->mInfo['title'];
} else {
$info = $del;
}
$formHash['input'][] = '<input type="hidden" name="checked[]" value="' . $del . '"/>' . $info;
}
$gBitSystem->confirmDialog($formHash, array('warning' => tra('Are you sure you want to delete ') . count($_REQUEST["checked"]) . ' tickets?', 'error' => tra('This cannot be undone!')));
} else {
foreach ($_REQUEST["checked"] as $deleteId) {
$tmpPage = new BitTicket($deleteId);
if (!$tmpPage->load() || !$tmpPage->expunge()) {
array_merge($errors, array_values($tmpPage->mErrors));
}
}
if (!empty($errors)) {
$gBitSmarty->assign_by_ref('errors', $errors);
}
}
}
// Create new tickets object
$tickets = new BitTicket();
$ticketsList = $tickets->getList($_REQUEST);
$gBitSmarty->assign_by_ref('ticketsList', $ticketsList);
$fieldDefinitions = $tickets->getFieldDefinitions();
$gBitSmarty->assign_by_ref('fieldDefinitions', $fieldDefinitions);
// getList() has now placed all the pagination information in $_REQUEST['listInfo']
$gBitSmarty->assign_by_ref('listInfo', $_REQUEST['listInfo']);
// Display the template
$gBitSystem->display('bitpackage:tickets/list_tickets.tpl', tra('Tickets'), array('display_mode' => 'list'));
<?php
global $gContent;
require_once TICKETS_PKG_PATH . 'BitTicket.php';
require_once LIBERTY_PKG_PATH . 'lookup_content_inc.php';
// if we already have a gContent, we assume someone else created it for us, and has properly loaded everything up.
if (empty($gContent) || !is_object($gContent) || !$gContent->isValid()) {
// if ticket_id supplied, use that
if (@BitBase::verifyId($_REQUEST['ticket_id'])) {
$gContent = new BitTicket($_REQUEST['ticket_id']);
// if content_id supplied, use that
} elseif (@BitBase::verifyId($_REQUEST['content_id'])) {
$gContent = new BitTicket(NULL, $_REQUEST['content_id']);
} elseif (@BitBase::verifyId($_REQUEST['ticket']['ticket_id'])) {
$gContent = new BitTicket($_REQUEST['ticket']['ticket_id']);
// otherwise create new object
} else {
$gContent = new BitTicket();
}
$gContent->load();
$gBitSmarty->assign_by_ref("gContent", $gContent);
}
