?>
">
<input type="hidden" name="customer_id" value="<?php
echo isset($_REQUEST['customer_id']) ? (int) $_REQUEST['customer_id'] : '';
?>
">
<?php
module_form::print_form_auth();
$search_bar = array('elements' => array('ticket_id' => array('title' => _l('Number:'), 'field' => array('type' => 'text', 'name' => 'search[ticket_id]', 'value' => isset($search['ticket_id']) ? $search['ticket_id'] : '', 'size' => 5)), 'name' => array('title' => _l('Subject:'), 'field' => array('type' => 'text', 'name' => 'search[generic]', 'value' => isset($search['generic']) ? $search['generic'] : '', 'size' => 10)), 'ticket_content' => array('title' => _l('Message:'), 'field' => array('type' => 'text', 'name' => 'search[ticket_content]', 'value' => isset($search['ticket_content']) ? $search['ticket_content'] : '', 'size' => 10)), 'contact' => array('title' => _l('Contact:'), 'field' => array('type' => 'text', 'name' => 'search[contact]', 'value' => isset($search['contact']) ? $search['contact'] : '', 'size' => 10)), 'date' => array('title' => _l('Date:'), 'fields' => array(array('type' => 'date', 'name' => 'search[date_from]', 'value' => isset($search['date_from']) ? $search['date_from'] : ''), _l('to'), array('type' => 'date', 'name' => 'search[date_to]', 'value' => isset($search['date_to']) ? $search['date_to'] : ''))), 'type' => array('title' => _l('Type:'), 'field' => array('type' => 'select', 'name' => 'search[ticket_type_id]', 'value' => isset($search['ticket_type_id']) ? $search['ticket_type_id'] : '', 'options' => module_ticket::get_types(), 'options_array_id' => 'name')), 'Status' => array('title' => _l('Status:'), 'field' => array('type' => 'select', 'name' => 'search[status_id]', 'value' => isset($search['status_id']) ? $search['status_id'] : '', 'options' => $search_statuses, 'blank' => _l('All'))), 'Priority' => array('title' => _l('Priority:'), 'field' => array('type' => 'select', 'name' => 'search[priority]', 'value' => isset($search['priority']) ? $search['priority'] : '', 'options' => module_ticket::get_ticket_priorities())), 'Staff' => array('title' => _l('Staff:'), 'field' => array('type' => 'select', 'name' => 'search[assigned_user_id]', 'value' => isset($search['assigned_user_id']) ? $search['assigned_user_id'] : '', 'options' => module_ticket::get_ticket_staff_rel()))));
if (class_exists('module_faq', false) && module_config::c('ticket_show_product_list', 1)) {
$search_bar['elements']['Product'] = array('title' => _l('Product:'), 'field' => array('type' => 'select', 'name' => 'search[faq_product_id]', 'value' => isset($search['faq_product_id']) ? $search['faq_product_id'] : '', 'options' => module_faq::get_faq_products_rel()));
}
if (class_exists('module_envato', false)) {
$search_bar['elements']['envato'] = array('title' => _l('Envato:'), 'field' => array('type' => 'select', 'name' => 'search[envato_item_id]', 'value' => isset($search['envato_item_id']) ? $search['envato_item_id'] : '', 'options' => array(-1 => 'No product') + module_envato::get_envato_items_rel()));
}
echo module_form::search_bar($search_bar);
if (class_exists('module_envato', false) && module_config::c('envato_show_ticket_earning', 0)) {
$item_ticket_count = array();
$envato_count = module_cache::get('ticket', 'envato_ticket_earning');
//if($envato_count===false){
while ($ticket = mysql_fetch_assoc($tickets)) {
$items = module_envato::get_items_by_ticket($ticket['ticket_id']);
if (count($items)) {
foreach ($items as $item_id => $item) {
if (!isset($item_ticket_count[$item_id])) {
$item_ticket_count[$item_id] = array('envato_id' => $item_id, 'name' => $item['name'], 'count' => 0, 'cost' => $item['cost']);
}
$item_ticket_count[$item_id]['count']++;
$envato_count += $item['cost'];
?>
</td>
<?php
if (class_exists('module_envato', false)) {
?>
<td width="27">
<?php
echo _l('Envato:');
?>
</td>
<td>
<?php
echo print_select_box(module_envato::get_envato_items_rel(), 'search[envato_item_id]', isset($search['envato_item_id']) ? $search['envato_item_id'] : '');
?>
</td>
<?php
}
?>
<td class="search_action">
<?php
echo create_link("Reset", "reset", module_ticket::link_open(false));
?>
<?php
echo create_link("Search", "submit");
?>
/**
* Copyright: dtbaker 2012
* Licence: Please check CodeCanyon.net for licence details.
* More licence clarification available here: http://codecanyon.net/wiki/support/legal-terms/licensing-terms/
* Deploy: 9809 f200f46c2a19bb98d112f2d32a8de0c4
* Envato: 4ffca17e-861e-4921-86c3-8931978c40ca
* Package Date: 2015-11-25 02:55:20
* IP Address: 67.79.165.254
*/
if (!module_config::can_i('view', 'Settings') || !module_faq::can_i('edit', 'FAQ')) {
redirect_browser(_BASE_HREF);
}
$faq_products = module_faq::get_faq_products();
$types = module_ticket::get_types();
if (class_exists('module_envato', false)) {
$all_items_rel = module_envato::get_envato_items_rel();
}
if (isset($_REQUEST['faq_product_id']) && $_REQUEST['faq_product_id']) {
$show_other_settings = false;
$faq_product_id = (int) $_REQUEST['faq_product_id'];
if ($faq_product_id > 0) {
$faq_product = module_faq::get_faq_product($faq_product_id);
} else {
$faq_product = array();
}
if (!$faq_product) {
$faq_product = array('name' => '', 'envato_item_ids' => '', 'default_type_id' => '');
}
?>
public static function api_filter_ticket($hook, $response, $endpoint, $method)
{
$response['ticket'] = true;
switch ($method) {
case 'list':
if (class_exists('module_envato', false)) {
// todo: filter this in the api filter so we keep envato code in the envato plugin
$all_items_rel = module_envato::get_envato_items_rel();
}
$search = isset($_REQUEST['search']) && is_array($_REQUEST['search']) ? $_REQUEST['search'] : array();
if (!isset($search['status_id'])) {
$search['status_id'] = '2,3,5';
}
// new/replied/inprogress
$tickets_mysql = module_ticket::get_tickets($search, true);
$response['tickets'] = array();
$extra_keys = module_ticket::get_ticket_extras_keys();
while ($ticket = mysql_fetch_assoc($tickets_mysql)) {
// return user details along with this ticket
$user = module_user::get_user($ticket['user_id'], false, true, true);
$ticket['user'] = array();
foreach (array('user_id', 'customer_id', 'vendor_id', 'email', 'name', 'last_name') as $field) {
$ticket['user'][$field] = isset($user[$field]) ? $user[$field] : '';
}
$staff = module_user::get_user($ticket['assigned_user_id'] ? $ticket['assigned_user_id'] : module_config::c('ticket_default_user_id', 1), false, true, true);
$ticket['staff'] = array();
foreach (array('user_id', 'customer_id', 'vendor_id', 'email', 'name', 'last_name') as $field) {
$ticket['staff'][$field] = isset($staff[$field]) ? $staff[$field] : '';
}
// find the extra data associated with this ticket.
$ticket['extra'] = array();
foreach (self::get_ticket_extras($ticket['ticket_id']) as $extra_data) {
if (isset($extra_keys[$extra_data['ticket_data_key_id']])) {
$ticket['extra'][$extra_keys[$extra_data['ticket_data_key_id']]['key']] = $extra_data['value'];
}
}
if (class_exists('module_envato', false)) {
$ticket['user']['envato'] = array();
$ticket['user']['envato']['user'] = array();
$ticket['user']['envato']['purchases'] = array();
$envato_tickets = get_multiple('envato_ticket', array('ticket_id' => $ticket['ticket_id']));
foreach ($envato_tickets as $envato_ticket) {
if ($envato_ticket && $envato_ticket['envato_ticket_id']) {
if (isset($all_items_rel[$envato_ticket['envato_item_id']]) && $envato_ticket['envato_author_id']) {
$envato_author = get_single('envato_author', 'envato_author_id', $envato_ticket['envato_author_id']);
$buys = @unserialize($envato_author['purchase_history']);
$purchase_history = array();
foreach ($buys as $buy) {
$purchase_history[] = $buy;
}
$ticket['user']['envato']['purchases'][$envato_ticket['envato_item_id']] = array('item_name' => $all_items_rel[$envato_ticket['envato_item_id']], 'envato_item_id' => $envato_ticket['envato_item_id'], 'license_code' => $envato_ticket['license_code']);
$ticket['user']['envato']['user'][$envato_author['envato_username']] = array('envato_username' => $envato_author['envato_username'], 'purchase_history' => $purchase_history);
}
}
}
}
$ticket['url'] = self::link_open($ticket['ticket_id'], false, $ticket);
$response['tickets'][] = $ticket;
$response['reply_options'] = array(array('title' => 'Mark Thread Resolved', 'field' => array('type' => 'checkbox', 'value' => 1, 'name' => 'resolved', 'checked' => true)));
}
break;
case 'message':
$search = isset($_REQUEST['search']) && is_array($_REQUEST['search']) ? $_REQUEST['search'] : array();
$response['tickets'] = array();
if (empty($search['ticket_ids']) && isset($_REQUEST['ticket_ids'])) {
$search['ticket_ids'] = explode(',', $_REQUEST['ticket_ids']);
}
if (isset($search['ticket_ids']) && is_array($search['ticket_ids'])) {
foreach ($search['ticket_ids'] as $ticket_id) {
$ticket_id = (int) trim($ticket_id);
if ($ticket_id) {
$messages = module_ticket::get_ticket_messages($ticket_id, false);
if ($messages) {
foreach ($messages as $message_id => $message) {
$user = module_user::get_user($message['from_user_id'], false);
$messages[$message_id]['user'] = array();
foreach (array('customer_id', 'vendor_id', 'email', 'name', 'last_name') as $field) {
$messages[$message_id]['user'][$field] = isset($user[$field]) ? $user[$field] : '';
}
}
$response['tickets'][$ticket_id] = $messages;
}
}
}
}
break;
case 'reply':
$ticket_id = (int) $_REQUEST['ticket_id'];
$message = $_REQUEST['message'];
$extra_data = isset($_REQUEST['extra_data']) && is_array($_REQUEST['extra_data']) ? $_REQUEST['extra_data'] : array();
// do we mark is as resolved? similar to bbpress api
if ($ticket_id && $message) {
// send a reply to this particular message.
$ticket_data = self::get_ticket($ticket_id);
if ($ticket_data && $ticket_data['ticket_id'] == $ticket_id) {
$from_user_id = $ticket_data['assigned_user_id'] ? $ticket_data['assigned_user_id'] : module_config::c('ticket_default_user_id', 1);
// send this back in initial api response.
$ticket_message_id = self::send_reply($ticket_id, $message, $from_user_id, $ticket_data['user_id'], 'admin');
$response['ticket_message_id'] = $ticket_message_id;
if ($ticket_message_id) {
if (!empty($extra_data['resolved'])) {
update_insert("ticket_message_id", $ticket_message_id, "ticket_message", array('status_id' => _TICKET_STATUS_RESOLVED_ID));
update_insert("ticket_id", $ticket_id, "ticket", array('status_id' => _TICKET_STATUS_RESOLVED_ID));
$response['stat'] = 'Changing status to ' . _TICKET_STATUS_RESOLVED_ID;
} else {
// change the ticket to in progress
update_insert("ticket_message_id", $ticket_message_id, "ticket_message", array('status_id' => _TICKET_STATUS_IN_PROGRESS_ID));
update_insert("ticket_id", $ticket_id, "ticket", array('status_id' => _TICKET_STATUS_IN_PROGRESS_ID));
$response['stat'] = 'Changing status to ' . _TICKET_STATUS_IN_PROGRESS_ID;
}
}
module_cache::clear('ticket');
}
}
if (empty($response['ticket_message_id'])) {
$response['error'] = true;
$response['message'] = 'Failed to send message reply.';
}
break;
}
return $response;
}
