xyzshop/admin/control/orderstats.php

<?php


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

    public function indexOp()
    {
        $type = $_GET['type'] ? $_GET['type'] : 'system';
        $page = "{$type}.order.stats";
        $model_refill_order = Model('refill_order');
        $condition['type'] = $type;
        if (!empty($_GET['cid'])) {
            $condition['cid'] = $_GET['cid'];
        }
        $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['time_stamp'] = [['egt', $start_unixtime], ['lt', $end_unixtime], 'and'];
        } elseif ($start_unixtime > 0) {
            $condition['time_stamp'] = ['egt', $start_unixtime];
        } elseif ($end_unixtime > 0) {
            $condition['time_stamp'] = ['lt', $end_unixtime];
        }

        $stats_list = $model_refill_order->getOrderStatsList($condition);

        if ($type == 'provider') {
            $provider_list = Model('')->table('refill_provider,store')->field('refill_provider.store_id,store.store_name')->join('inner')
                ->on('store.store_id=refill_provider.store_id')->limit(1000)->select();
            Tpl::output('provider_list', $provider_list);
        } elseif ($type == 'merchant') {
            $merchant_list = Model('')->table('merchant')->limit(1000)->select();
            Tpl::output('merchant_list', $merchant_list);
        }
        $success_count_total = $success_refill_amounts_total = $success_mch_amounts_toatl = $success_channel_amounts_total = $profit_amounts_total = 0;
        foreach ($stats_list as $stats) {
            $success_count_total += $stats['success_count'];
            $success_refill_amounts_total += $stats['success_refill_amounts'];
            $success_mch_amounts_toatl += $stats['success_mch_amounts'];
            $success_channel_amounts_total += $stats['success_channel_amounts'];
            $profit_amounts_total += $stats['profit_amounts'];
        }
        $total_stats = [
            'success_count_total' => $success_count_total,
            'success_refill_amounts_total' => $success_refill_amounts_total,
            'success_mch_amounts_toatl' => $success_mch_amounts_toatl,
            'success_channel_amounts_total' => $success_channel_amounts_total,
            'profit_amounts_total' => $profit_amounts_total
        ];
        $check_text = ['未编辑', '匹配', '不匹配'];
        Tpl::output('total_stats', $total_stats);
        Tpl::output('stats_list', $stats_list);
        Tpl::output('check_text', $check_text);
        Tpl::output('show_page', $model_refill_order->showpage());
        Tpl::showpage($page);
    }

    public function ExportDataOp()
    {
        $type = $_GET['type'] ? $_GET['type'] : 'system';
        $model_refill_order = Model('refill_order');
        $condition['type'] = $type;
        if (!empty($_GET['cid'])) {
            $condition['cid'] = $_GET['cid'];
        }
        $start_unixtime = intval($_GET['query_start_time']);
        $end_unixtime = intval($_GET['query_end_time']);
        if ($start_unixtime > 0 && $end_unixtime > $start_unixtime) {
            $condition['time_stamp'] = [['egt', $start_unixtime], ['lt', $end_unixtime], 'and'];
        } elseif ($start_unixtime > 0) {
            $condition['time_stamp'] = ['egt', $start_unixtime];
        } elseif ($end_unixtime > 0) {
            $condition['time_stamp'] = ['lt', $end_unixtime];
        }
        $stats_list = $model_refill_order->getOrderStatsList($condition);

        $success_count_total = $success_refill_amounts_total = $success_mch_amounts_toatl = $success_channel_amounts_total = $profit_amounts_total = 0;
        foreach ($stats_list as $stats) {
            $success_count_total += $stats['success_count'];
            $success_refill_amounts_total += $stats['success_refill_amounts'];
            $success_mch_amounts_toatl += $stats['success_mch_amounts'];
            $success_channel_amounts_total += $stats['success_channel_amounts'];
            $profit_amounts_total += $stats['profit_amounts'];
        }
        $total_stats = [
            'success_count_total' => ncPriceFormat($success_count_total),
            'success_refill_amounts_total' => ncPriceFormat($success_refill_amounts_total),
            'success_mch_amounts_toatl' => ncPriceFormat($success_mch_amounts_toatl),
            'success_channel_amounts_total' => ncPriceFormat($success_channel_amounts_total),
            'profit_amounts_total' => ncPriceFormat($profit_amounts_total)
        ];
        $result['data'] = $stats_list;
        $result['total_stats'] = $total_stats;
        echo(json_encode($result));
        exit;
    }
}