getVar("permissions"), $jakuser->jakSuperadminaccess($jakuser->getVar("id")))) $where = " AND t1.operatorid = ".$jakuser->getVar("id"); // DB table to use $table = JAKDB_PREFIX.'sessions AS t1'; $table2 = ' LEFT JOIN '.JAKDB_PREFIX.'user AS t2 ON (t1.operatorid = t2.id)'; $table3 = ' LEFT JOIN '.JAKDB_PREFIX.'departments AS t3 ON (t1.department = 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.id', 'dbjoin' => 'id', 'dt' => 1, 'formatter' => function( $d, $row ) { return ''; } ), array( 'db' => 't1.name', 'dbjoin' => 'name', 'dt' => 2, 'formatter' => function( $d, $row ) { return ' '.$d.''; } ), array( 'db' => 't1.email', 'dbjoin' => 'email', 'dt' => 3, 'formatter' => function( $d, $row ) { return (filter_var($d, FILTER_VALIDATE_EMAIL) ? ''.$d.'' : '-'); } ), array( 'db' => 't2.username', 'dbjoin' => 'username', 'dt' => 4 ), array( 'db' => 't3.title', 'dbjoin' => 'title', 'dt' => 5 ), array( 'db' => 't1.notes', 'dbjoin' => 'notes', 'dt' => 6, 'formatter' => function( $d, $row ) { return ''; } ), array( 'db' => 't1.deniedoid', 'dbjoin' => 'deniedoid', 'dt' => 7, 'formatter' => function( $d, $row ) { return ($d ? '' : ''); } ), array( 'db' => 't1.initiated', 'dbjoin' => 'initiated', 'dt' => 8, 'formatter' => function( $d, $row ) { return JAK_base::jakTimesince($d, JAK_DATEFORMAT, JAK_TIMEFORMAT); } ) ); die(json_encode(SSP::join( $_GET, $table, $table2, $table3, $primaryKey, $columns, $where, $where ))); ?>