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.
55 lines
2.5 KiB
55 lines
2.5 KiB
1 year ago
|
<?php
|
||
|
|
|
||
|
|
/*===============================================*\
|
||
|
|
|| ############################################# ||
|
||
|
|
|| # JAKWEB.CH / Version 2.0.4 # ||
|
||
|
|
|| # ----------------------------------------- # ||
|
||
|
|
|| # Copyright 2022 JAKWEB All Rights Reserved # ||
|
||
|
|
|| ############################################# ||
|
||
|
|
\*===============================================*/
|
||
|
|
|
||
|
|
if (!file_exists('../../config.php')) die('ajax/[config.php] config.php not exist');
|
||
|
|
require_once '../../config.php';
|
||
|
|
|
||
|
|
if (!isset($_SERVER['HTTP_X_REQUESTED_WITH']) && !isset($_SESSION['jak_lcp_idhash'])) die("Nothing to see here");
|
||
|
|
|
||
|
|
if (!file_exists('../../class/ssp.class.php')) die('ajax/[ssp.class.php] config.php not exist');
|
||
|
|
require_once '../../class/ssp.class.php';
|
||
|
|
|
||
|
|
// Where get only the operator specific messages
|
||
|
|
$where = 'opid = '.$opcacheid;
|
||
|
|
|
||
|
|
// DB table to use
|
||
|
|
$table = JAKDB_PREFIX.'clients';
|
||
|
|
$table2 = '';
|
||
|
|
|
||
|
|
// Table's primary key
|
||
|
|
$primaryKey = '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' => 'id', 'dbjoin' => 'id', 'dt' => 0 ),
|
||
|
|
array( 'db' => 'id', 'dbjoin' => 'id', 'dt' => 1, 'formatter' => function( $d, $row ) {
|
||
|
|
return '<input type="checkbox" name="jak_delock_all[]" class="highlight" value="'.$d.':#:'.$row['access'].'">';
|
||
|
|
} ),
|
||
|
|
array( 'db' => 'name', 'dbjoin' => 'name', 'dt' => 2, 'formatter' => function( $d, $row ) {
|
||
|
|
return '<a class="btn btn-sm btn-primary" href="'.str_replace('ajax/', '', JAK_rewrite::jakParseurl('users', 'clients', 'edit', $row['id'])).'">'.$d.'</a>';
|
||
|
|
} ),
|
||
|
|
array( 'db' => 'email', 'dbjoin' => 'email', 'dt' => 3 ),
|
||
|
|
array( 'db' => 'credits', 'dbjoin' => 'credits', 'dt' => 4 ),
|
||
|
|
array( 'db' => 'paid_until', 'dbjoin' => 'paid_until', 'dt' => 5, 'formatter' => function( $d, $row ) {
|
||
|
|
return ($d != '1980-05-06' ? JAK_base::jakTimesince($d, JAK_DATEFORMAT, '') : '-');
|
||
|
|
} ),
|
||
|
|
array( 'db' => 'access', 'dbjoin' => 'access', 'dt' => 6, 'formatter' => function( $d, $row ) {
|
||
|
|
return ($d == 1 ? '<i class="fa fa-check"></i>' : '<i class="fa fa-times"></i>');
|
||
|
|
} ),
|
||
|
|
array( 'db' => 'lastactivity', 'dbjoin' => 'lastactivity', 'dt' => 7, 'formatter' => function( $d, $row ) {
|
||
|
|
return ($d != 0 ? JAK_base::jakTimesince($d, JAK_DATEFORMAT, JAK_TIMEFORMAT) : '-');
|
||
|
|
} )
|
||
|
|
);
|
||
|
|
die(json_encode(SSP::simple( $_GET, $table, $primaryKey, $columns, $where )));
|
||
|
|
?>
|