芝麻web文件管理V1.00

编辑当前文件:/home/digitalh/network.digitalhubbd.com/fns/load/subrtn_wallet_stats.php

<?php

if (role(['permissions' => ['wallet' => 'view_wallet']])) {

$index = 1;
    $view_transactions = false;

if (role(['permissions' => ['wallet' => 'view_personal_transactions']])) {
        $view_transactions = true;
    }

$output = array();
    $user_id = Registry::load('current_user')->id;

$child_index = 0;
    $output['module'][$index] = new stdClass();
    $output['module'][$index]->type = 'numbers';

$items = array();

$wallet_balance = DB::connect()->select('site_users', ['wallet_balance'], ['user_id' => $user_id, 'LIMIT' => 1]);

if (isset($wallet_balance[0])) {
        $wallet_balance = $wallet_balance[0]['wallet_balance'];
    } else {
        $wallet_balance = 0;
    }

$items[$child_index]['title'] = Registry::load('strings')->wallet_balance;
    $items[$child_index]['result'] = Registry::load('settings')->default_currency_symbol . ' ' . $wallet_balance;

if (role(['permissions' => ['wallet' => 'topup_wallet']])) {
        $items[$child_index]['button'] = Registry::load('strings')->top_up;
        $items[$child_index]['attributes'] = [
            'class' => 'open_wallet_topup'
        ];
    }

$child_index++;

$last_credit = DB::connect()->select(
        'site_users_wallet',
        ['wallet_amount', 'currency_code'],
        ['user_id' => $user_id, 'transaction_type' => 1, 'transaction_status' => 1, 'ORDER' => ['wallet_transaction_id' => "DESC"], 'LIMIT' => 1]
    );

if (isset($last_credit[0])) {
        $last_credit = $last_credit[0]['currency_code'] . ' ' . $last_credit[0]['wallet_amount'];
    } else {
        $last_credit = 0.00;
    }

$items[$child_index]['title'] = Registry::load('strings')->wallet_last_credit;
    $items[$child_index]['result'] = $last_credit;

if ($view_transactions) {
        $items[$child_index]['attributes'] = [
            'class' => 'load_aside',
            'load' => 'wallet_transactions',
            'role' => 'button'
        ];
    }

$child_index++;

$last_debit = DB::connect()->select(
        'site_users_wallet',
        ['wallet_amount', 'currency_code'],
        ['user_id' => $user_id, 'transaction_type' => 2, 'transaction_status' => 1, 'ORDER' => ['wallet_transaction_id' => "DESC"], 'LIMIT' => 1]
    );

if (isset($last_debit[0])) {
        $last_debit = $last_debit[0]['currency_code'] . ' ' . $last_debit[0]['wallet_amount'];
    } else {
        $last_debit = 0.00;
    }

$items[$child_index]['title'] = Registry::load('strings')->wallet_last_debit;
    $items[$child_index]['result'] = $last_debit;

$child_index++;

$output['module'][$index]->items = $items;

$index++;

if ($view_transactions) {
        $output['module'][$index] = new stdClass();
        $output['module'][$index]->title = Registry::load('strings')->last_transactions;
        $output['module'][$index]->type = 'list';

$child_index = 0;
        $items = array();

$columns = $where = $join = null;
        $columns = [
            'site_users_wallet.wallet_transaction_id',
            'site_users_wallet.wallet_amount',
            'site_users_wallet.currency_code',
            'site_users_wallet.transaction_type',
            'site_users_wallet.transaction_info',
            'site_users_wallet.transaction_status',
            'site_users_wallet.created_on',
            'payment_gateways.identifier'
        ];

$join["[>]payment_gateways"] = ["site_users_wallet.payment_gateway_id" => "payment_gateway_id"];

$where = ['user_id' => $user_id];
        $where["ORDER"] = ["site_users_wallet.wallet_transaction_id" => "DESC"];
        $where["LIMIT"] = 15;

$last_transactions = DB::connect()->select('site_users_wallet', $join, $columns, $where);

foreach ($last_transactions as $transaction) {

$transaction_symbol = Registry::load('config')->site_url . 'assets/files/defaults/debit_symbol.png';
            $transaction_status = Registry::load('strings')->debit;

$color_scheme = 'light';

if (Registry::load('current_user')->color_scheme == 'dark_mode') {
                $color_scheme = 'dark';
            }

$payment_gateway_img = Registry::load('config')->site_url . 'assets/files/payment_gateways/' . $color_scheme . '/wallet.png';

if (!empty($transaction['identifier'])) {
                $payment_gateway_img = Registry::load('config')->site_url;
                $payment_gateway_img = $payment_gateway_img . 'assets/files/payment_gateways/' . $color_scheme . '/' . $transaction['identifier'] . '.png';
            }

if ((int) $transaction['transaction_type'] === 1) {
                $transaction_symbol = Registry::load('config')->site_url . 'assets/files/defaults/credit_symbol.png';
                $transaction_status = Registry::load('strings')->credit;
            }

$created_on['date'] = $transaction['created_on'];
            $created_on['auto_format'] = true;
            $created_on['include_time'] = true;
            $created_on['timezone'] = Registry::load('current_user')->time_zone;
            $created_on = get_date($created_on);

$items[$child_index] = new stdClass();
            $items[$child_index]->items[1]['type'] = 'image';
            $items[$child_index]->items[1]['class_name'] = 'small_size_img';
            $items[$child_index]->items[1]['image'] = $transaction_symbol;

$items[$child_index]->items[2]['type'] = 'info';
            $items[$child_index]->items[2]['bold_text'] = $transaction['currency_code'] . ' ' . $transaction['wallet_amount'];
            $items[$child_index]->items[2]['text'] = $created_on['date'];

$items[$child_index]->items[3]['type'] = 'info';
            $items[$child_index]->items[3]['text'] = $created_on['time'];

if (!empty($transaction['transaction_info'])) {
                $transaction_info = json_decode($transaction['transaction_info'], true);

if (!empty($transaction_info) && isset($transaction_info['order_type'])) {
                    $order_type = $transaction_info['order_type'];
                    $items[$child_index]->items[3]['bold_text'] = Registry::load('strings')->$order_type;
                }
            }

$items[$child_index]->items[4]['type'] = 'image';
            $items[$child_index]->items[4]['class_name'] = 'auto_size_img';
            $items[$child_index]->items[4]['image'] = $payment_gateway_img;

$items[$child_index]->items[6]['type'] = 'button';

$items[$child_index]->items[6]['class_name'] = 'pending';
            $items[$child_index]->items[6]['text'] = Registry::load('strings')->pending;

if ((int) $transaction['transaction_status'] === 1) {
                $items[$child_index]->items[6]['class_name'] = 'success';
                $items[$child_index]->items[6]['text'] = Registry::load('strings')->success;
            } else if ((int) $transaction['transaction_status'] === 2) {
                $items[$child_index]->items[6]['class_name'] = 'failed';
                $items[$child_index]->items[6]['text'] = Registry::load('strings')->failed;
            }

$child_index++;
        }

$output['module'][$index]->items = $items;
        $index++;
    }

}
?>