You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
94 lines
4.9 KiB
94 lines
4.9 KiB
1 year ago
|
<?php
|
||
|
|
|
||
|
|
/*===============================================*\
|
||
|
|
|| ############################################# ||
|
||
|
|
|| # JAKWEB.CH / Version 2.0.5 # ||
|
||
|
|
|| # ----------------------------------------- # ||
|
||
|
|
|| # Copyright 2022 JAKWEB All Rights Reserved # ||
|
||
|
|
|| ############################################# ||
|
||
|
|
\*===============================================*/
|
||
|
|
|
||
|
|
if (!file_exists('../config.php')) die('include/[support.php] config.php not exist');
|
||
|
|
require_once '../config.php';
|
||
|
|
|
||
|
|
if (!file_exists('../class/ssp.class.php')) die('include/[support.php] ssp.class.php not exist');
|
||
|
|
require_once '../class/ssp.class.php';
|
||
|
|
|
||
|
|
// Get the correct tickets
|
||
|
|
$where = 't1.opid = '.$_SESSION['opid'];
|
||
|
|
if (JAK_CLIENTID) {
|
||
|
|
if ($jakclient->getVar("support_dep") == 0) {
|
||
|
|
// ["AND" => ["OR" => ["support_tickets.private" => 0, "support_tickets.clientid" => JAK_CLIENTID], "support_departments.guesta" => 1]]
|
||
|
|
$where .= " AND (t1.private = 0 OR t1.clientid = ".JAK_CLIENTID.")";
|
||
|
|
} else {
|
||
|
|
// ["AND" => ["OR" => ["support_tickets.private" => 0, "support_tickets.depid" => [$jakclient->getVar("support_dep")], "support_tickets.clientid" => JAK_CLIENTID], "support_departments.guesta" => 1]]
|
||
|
|
$where .= " AND (t1.private = 0 OR t1.clientid = ".JAK_CLIENTID." OR t1.depid IN('".explode(",", $jakclient->getVar("support_dep"))."'))";
|
||
|
|
}
|
||
|
|
} elseif (JAK_USERID) {
|
||
|
|
if ($jakuser->getVar("support_dep") == 0) {
|
||
|
|
// ["AND" => ["OR" => ["support_tickets.private" => 0, "support_tickets.clientid" => JAK_CLIENTID], "support_departments.guesta" => 1]]
|
||
|
|
$where .= '';
|
||
|
|
} else {
|
||
|
|
// ["AND" => ["OR" => ["support_tickets.private" => 0, "support_tickets.depid" => [$jakclient->getVar("support_dep")], "support_tickets.clientid" => JAK_CLIENTID], "support_departments.guesta" => 1]]
|
||
|
|
$where .= " AND t1.depid IN('".explode(",", $jakuser->getVar("support_dep"))."')";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$where .= " AND t1.private = 0 AND t2.guesta = 1";
|
||
|
|
}
|
||
|
|
|
||
|
|
if (isset($_SESSION["sortdepid"]) && is_numeric($_SESSION["sortdepid"])) $where .= ' AND t1.depid = '.$_SESSION["sortdepid"];
|
||
|
|
|
||
|
|
// DB table to use
|
||
|
|
$table = JAKDB_PREFIX.'support_tickets AS t1';
|
||
|
|
$table2 = ' LEFT JOIN '.JAKDB_PREFIX.'support_departments AS t2 ON (t1.depid = t2.id)';
|
||
|
|
$table3 = ' LEFT JOIN '.JAKDB_PREFIX.'ticketpriority AS t3 ON (t1.priorityid = t3.id)';
|
||
|
|
|
||
|
|
// Table's primary key
|
||
|
|
$primaryKey = 't1.id';
|
||
|
|
|
||
|
|
// Array of database columns which should be read and sent back to DataTables.
|
||
|
|
// The `db` parameter represents the column name in the database, while the `dt`
|
||
|
|
// parameter represents the DataTables column identifier. In this case simple
|
||
|
|
// indexes
|
||
|
|
$columns = array(
|
||
|
|
array( 'db' => 't1.id', 'dbjoin' => 'id', 'dt' => 0 ),
|
||
|
|
array( 'db' => 't1.subject', 'dbjoin' => 'subject', 'dt' => 1, 'formatter' => function( $d, $row ) {
|
||
|
|
return '<a href="'.str_replace('include/', '', JAK_rewrite::jakParseurl(JAK_SUPPORT_URL, 't', $row['id'], JAK_rewrite::jakCleanurl($row["subject"]))).'" class="btn btn-link btn-default">'.$d.'</a>';
|
||
|
|
} ),
|
||
|
|
array( 'db' => 't2.title', 'dbjoin' => 'title', 'dt' => 2 ),
|
||
|
|
array( 'db' => 't1.name', 'dbjoin' => 'name', 'dt' => 3 ),
|
||
|
|
array( 'db' => 't1.initiated', 'dbjoin' => 'initiated', 'dt' => 4, 'formatter' => function( $d, $row ) {
|
||
|
|
return JAK_base::jakTimesince($d, JAK_DATEFORMAT, JAK_TIMEFORMAT);
|
||
|
|
} ),
|
||
|
|
array( 'db' => 't1.status', 'dbjoin' => 'status', 'dt' => 5, 'formatter' => function( $d, $row ) {
|
||
|
|
if (isset($BT_LANGUAGE) && isset($_SESSION['jak_lcp_lang']) && file_exists(APP_PATH.'lang/'.$BT_LANGUAGE.'.php')) {
|
||
|
|
include (APP_PATH.'lang/'.$BT_LANGUAGE.'.php');
|
||
|
|
} else {
|
||
|
|
include (APP_PATH.'lang/'.JAK_LANG.'.php');
|
||
|
|
}
|
||
|
|
global $HD_SUPPORT_STATUS;
|
||
|
|
$support_status = '';
|
||
|
|
if (isset($HD_SUPPORT_STATUS) && !empty($HD_SUPPORT_STATUS)) foreach ($HD_SUPPORT_STATUS as $v) {
|
||
|
|
if (isset($d) && $d == $v['id']) {
|
||
|
|
$support_status = '<span class="badge badge-pill badge-'.$v["class"].'">'.$v['title'].'</span>';
|
||
|
|
break;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $support_status.' <span class="badge badge-pill badge-'.$row["class"].'">'.$row["prioritytitle"].'</span>';
|
||
|
|
} ),
|
||
|
|
array( 'db' => 't1.subject', 'dbjoin' => 'subject', 'dt' => 6, 'formatter' => function( $d, $row ) {
|
||
|
|
if (isset($BT_LANGUAGE) && isset($_SESSION['jak_lcp_lang']) && file_exists(APP_PATH.'lang/'.$BT_LANGUAGE.'.php')) {
|
||
|
|
include (APP_PATH.'lang/'.$BT_LANGUAGE.'.php');
|
||
|
|
} else {
|
||
|
|
include (APP_PATH.'lang/'.JAK_LANG.'.php');
|
||
|
|
}
|
||
|
|
return '<a href="'.str_replace('include/', '', JAK_rewrite::jakParseurl(JAK_SUPPORT_URL, 't', $row['id'], JAK_rewrite::jakCleanurl($row["subject"]))).'" class="btn btn-primary btn-sm">'.$jkl['hd13'].'</a>';
|
||
|
|
} ),
|
||
|
|
array( 'db' => 't1.updated', 'dbjoin' => 'updated', 'dt' => 7 ),
|
||
|
|
array( 'db' => 't3.title AS prioritytitle', 'dbjoin' => 'prioritytitle', 'dt' => 8 ),
|
||
|
|
array( 'db' => 't3.class', 'dbjoin' => 'class', 'dt' => 9 )
|
||
|
|
);
|
||
|
|
|
||
|
|
die(json_encode(SSP::join( $_GET, $table, $table2, $table3, $primaryKey, $columns, $where, $where )));
|
||
|
|
?>
|