xyzshop/admin/control/ordersendlist.php

<?php


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

    public function indexOp()
    {
        $model_refill_order = Model('refill_order');
        $condition['refill_order.inner_status'] = 0;
        $condition['vr_order.order_state'] = ORDER_STATE_SEND;

        $condition['refill_order.order_time'] = ['lt', (time() - 300)];
        if (!empty($_GET['mchid'])) {
            $condition['refill_order.mchid'] = $_GET['mchid'];
        }
        if (!empty($_GET['store_id'])) {
            $condition['vr_order.store_id'] = $_GET['store_id'];
        }
        $time_cond = [
            ['between', [(time() - 3600), (time() - 1800)]],
            ['lt', (time() - 3600)]];
        if ($_GET['time'] == 1) {
            $condition['refill_order.order_time'] = ['between', [(time() - 3600), (time() - 1800)]];
        }
        if ($_GET['time'] == 2) {
            $condition['refill_order.order_time'] = ['lt', (time() - 3600)];
        }
        $time_out_order = function($time_out, $condition){
            $mchids = Model('')->table('merchant')->where(['time_out' => ['elt', $time_out]])->field('mchid')->select();
            $mchids = array_column($mchids, 'mchid');
            $mchids = implode(',', $mchids);

            $condition['refill_order.order_time'] = ['lt', (time() - $time_out)];
            $condition['refill_order.mchid'] = ['in',$mchids];
            return $condition;
        };
        if ($_GET['time'] == 3) {
            $condition = $time_out_order(300, $condition);
            $time_cond[] = ['lt', (time() - 300)];
        }
        if ($_GET['time'] == 4) {
            $condition = $time_out_order(900, $condition);
            $time_cond[] = ['lt', (time() - 900)];
        }
        if (!empty($_GET['card_type'])) {
            if (in_array($_GET['card_type'], ['1', '2', '4', '5', '6', '7'])) {
                $condition['refill_order.card_type'] = $_GET['card_type'];
            }
            if ($_GET['card_type'] == 'oil') {
                $condition['refill_order.card_type'] = ['in', ['1', '2']];
            }
            if ($_GET['card_type'] == 'phone') {
                $condition['refill_order.card_type'] = ['in', ['4', '5', '6']];
            }
        }
        if (!empty($_GET['quality'])) {
            $condition['refill_order.quality'] = $_GET['quality'];
        }

        $order_list = $model_refill_order->getMerchantOrderList($condition, 50, 'refill_order.*,vr_order.order_state', 'refill_order.order_time asc');

        $stat = Model('')->table('refill_order,vr_order')->join('inner')
            ->on('refill_order.order_id=vr_order.order_id')
            ->field('count(*) as order_count ,sum(refill_amount) as refill_amounts, sum(channel_amount) as channel_amounts, sum(mch_amount) as mch_amounts')
            ->where($condition)->find();
        $count = $this->refill_stats($condition,$time_cond);

        $merchant_list = Model('')->table('merchant')->limit(1000)->order('name asc')->select();

        $order_list = $this->orderFormat($order_list,$merchant_list);
        $provider_list = Model('')->table('refill_provider,store')
            ->field('refill_provider.*,store.store_name')
            ->join('inner')
            ->on('store.store_id=refill_provider.store_id')
            ->order('opened asc, provider_id desc')
            ->limit(1000)
            ->select();
        Tpl::output('stat', $stat);
        Tpl::output('count', $count);
        Tpl::output('order_list', $order_list);
        Tpl::output('merchant_list', $merchant_list);
        Tpl::output('provider_list', $provider_list);
        Tpl::output('show_page', $model_refill_order->showpage());
        Tpl::showpage('refill.order.send.index');
    }

    private function refill_stats($condition, $times): array
    {
        $stat_order = function ($condition) {
            $stat = Model('')->table('refill_order,vr_order')->join('inner')
                ->on('refill_order.order_id=vr_order.order_id')
                ->field('count(*) as order_count ')
                ->where($condition)->find();

            return $stat['order_count'];
        };
        $result = [];
        $condition['order_state'] = ORDER_STATE_SEND;
        foreach ($times as $time) {
            $condition['refill_order.order_time'] = $time;
            $result[] = $stat_order($condition);
        }
        return $result;
    }

    public function neterr_orderOp()
    {
        $model_refill_order = Model('refill_order');
        $condition['refill_order.inner_status'] = 0;
        $condition['refill_order.neterr'] = 1;
        $condition['vr_order.order_state'] = ORDER_STATE_PAY;

        $order_list = $model_refill_order->getMerchantOrderList($condition, 50, 'refill_order.*,vr_order.order_state', 'refill_order.order_time asc');
        $merchant_list = Model('')->table('merchant')->limit(1000)->order('name asc')->select();
        $order_list = $this->orderFormat($order_list,$merchant_list);

        Tpl::output('order_list', $order_list);
        Tpl::output('show_page', $model_refill_order->showpage());
        Tpl::showpage('refill.order.neterr.index');
    }

    public function orderFormat($order_list, $merchant_list)
    {
        $merchants = [];
        foreach ($merchant_list as $value) {
            $merchants[$value['mchid']] = $value;
        }
        foreach ($order_list as $order_id => $order_info) {
            $order_list[$order_id]['card_type_text'] = $this->scard_type($order_info['card_type']);
            $order_list[$order_id]['mch_name'] = $merchants[$order_info['mchid']]['company_name'];
            $order_list[$order_id]['diff_time_text'] = $this->elapse_time(time() - $order_info['order_time']);
            $order_list[$order_id]['diff_time'] = time() - $order_info['order_time'];
            $order_list[$order_id]['quality_text'] = $this->quality_format($order_info['quality'],$order_info['card_type']);
        }

        return $order_list;
    }
}