xyzshop/admin/control/refill_evidence.php

<?php


class refill_evidenceControl extends SystemControl
{
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * 充值申请列表
     */
    public function indexOp()
    {
        $model_merchant = Model('merchant');
        $condition = [];
        if (trim($_GET['mch_name']) != '') {
            $condition['mch_name'] = ['like', '%' . $_GET['mch_name'] . '%'];
            Tpl::output('mch_name', $_GET['mch_name']);
        }
        $state_sel = intval($_REQUEST['state_sel']);
        if ($state_sel == 1) {
            $condition['check_time'] = 0;
            $condition['status'] = 1;
        } elseif ($state_sel == 2) {
            $condition['check_time'] = ['gt', 0];
            $condition['status'] = 2;
        } elseif ($state_sel == 3) {
            $condition['check_time'] = ['gt', 0];
            $condition['status'] = 3;
        } else {
        }

        $start_unixtime = intval(strtotime($_GET['query_start_time']));
        $end_unixtime = intval(strtotime($_GET['query_end_time']));

        if ($start_unixtime > 0 && $end_unixtime > $start_unixtime) {
            $condition['add_time'] = [['egt', $start_unixtime], ['lt', $end_unixtime], 'and'];
        } elseif ($start_unixtime > 0) {
            $condition['add_time'] = ['egt', $start_unixtime];
        } elseif ($end_unixtime > 0) {
            $condition['add_time'] = ['lt', $end_unixtime];
        }

        //充值申请列表
        $evidence_list = $model_merchant->getRefillEvidence($condition, 20, '*,member.available_predeposit', 'refill_evidence.add_time desc');
        $status_text = ['申请中', '已通过', '已驳回'];
        $operation_text = ['未预存', '已预存'];
        $add_type_text = ['商户预存','后台手动预存'];

        $counts = Model('')->table('refill_evidence')
            ->field('sum(amount) as amounts,status')
            ->where($condition)
            ->group('status')
            ->select();
        $success_amount = $send_amount = $cancel_amount = 0;
        foreach ($counts as $count) {
            if($count['status'] == 1) {
                $send_amount += $count['amounts'];
            }elseif ($count['status'] == 2) {
                $success_amount += $count['amounts'];
            }elseif ($count['status'] == 3) {
                $cancel_amount += $count['amounts'];
            }
        }
        $stats['send_amount'] = $send_amount;
        $stats['success_amount'] = $success_amount;
        $stats['cancel_amount'] = $cancel_amount;
        Tpl::output('stats', $stats);
        Tpl::output('evidence_list', $evidence_list);
        Tpl::output('status_text', $status_text);
        Tpl::output('operation_text', $operation_text);
        Tpl::output('add_type_text', $add_type_text);
        Tpl::output('page', $model_merchant->showpage('2'));
        Tpl::showpage('merchant.refill.evidence_list');
    }
}