asking

<?php

// af7ff967594c717171be1524d77a2fde813dc754b660dfbdb656cffa16c4111fb46c925870fed0685e2f705ada367644df51b39655a5ec14f8a9d26aa2ad883d7dcb27a7e5023fce13682a90a22e9555eb06726f00ef78b981d4dc7ebe2e9976


require '../../mainconfig.php';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) AND strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
    if (!isset($_SESSION['login'])) {
        exit("No direct script access allowed!");
    }
    if ($model->db_query($db, "*", "users", "id = '".$_SESSION['login']."' AND level = 'Admin'")['count'] == 0) {
        exit("No direct script access allowed!");
    }
    require('../../lib/ssp.class.php');
    $table = 'users';
    $primaryKey = 'id';

    $columns = array(
        array('db' => '`a`.`id`', 'dt' => 0, 'field' => 'id'),
        array('db' => '`a`.`email`', 'dt' => 1, 'field' => 'email'),
        array('db' => '`a`.`username`', 'dt' => 2, 'field' => 'username'),
        array('db' => '`a`.`full_name`', 'dt' => 3, 'field' => 'full_name'),
        array('db' => '`a`.`balance`', 'dt' => 4, 'formatter' => function($i) {
            return "Rp ".number_format($i,0,',','.');
        }, 'field' => 'balance'),
        array('db' => 'SUM(`b`.`price`)', 'dt' => 5, 'formatter' => function($i) {
            return "Rp ".number_format($i,0,',','.');
        }, 'field' => 'total_order', 'as' => 'total_order'),
        array('db' => '`a`.`level`', 'dt' => 6, 'field' => 'level'),
        array('db' => '`a`.`api_key`', 'dt' => 7,
            'formatter' => function($i, $a) use($config) {
                return $i." <a href=\"javascript:;\" onclick=\"get_data('".$config['web']['base_url']."admin/user/api_key.php?id=".$a['0']."')\" class=\"btn btn-xs btn-primary\"><i class=\"fa fa-random\"></i></a>";
        }, 'field' => 'api_key'),
        array('db' => '`a`.`created_at`', 'dt' => 8, 'field' => 'created_at'),
        array('db' => '`a`.`status`', 'dt' => 9,
            'formatter' => function($i, $a) use($config) {
                $status = ($i == 1) ? 'Aktif' : 'Nonaktif';
                $label = ($i == 1) ? 'primary' : 'danger';
                $change = ($i == 1) ? 0 : 1;
                return "<a href=\"javascript:;\" onclick=\"get_data('".$config['web']['base_url']."admin/user/status.php?id=".$a['0']."&status=".$change."')\" class=\"btn btn-xs btn-".$label."\">".$status."</a>";
        }, 'field' => 'status'),
        array('db' => '`a`.`id`', 'dt' => 10,
            'formatter' => function($i) use($config) {
                return "<a href=\"javascript:;\" onclick=\"modal_open('edit', '".$config['web']['base_url']."admin/user/edit.php?id=".$i."')\" class=\"btn btn-xs btn-warning\"><i class=\"fa fa-edit\"></i></a> <a href=\"javascript:;\" onclick=\"modal_delete('".$config['web']['base_url']."admin/user/delete.php?id=".$i."')\" class=\"btn btn-xs btn-danger\"><i class=\"fa fa-trash\"></i></a>";
        }, 'field' => 'id'),
    );
    $sql_details = array(
        'user' => $config['db']['username'],
        'pass' => $config['db']['password'],
        'db'   => $config['db']['name'],
        'host' => $config['db']['host']
    );
    $joinQuery = "FROM `{$table}` AS `a` LEFT JOIN `orders` AS `b` ON (`b`.`user_id` = `a`.`id`)";
    $extraWhere = '';
    $groupBy = 'a.id';
    $having = '';
    print(json_encode(
        SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns, $joinQuery, $extraWhere, $groupBy, $having )
    ));
} else {
    exit("No direct script access allowed!");
}