php/app/controller/admin/finance/Finance.php

<?php


namespace app\controller\admin\finance;

use app\common\repositories\finance\FinanceRepository;
use app\controller\api\entropybarter\User;
use crmeb\basic\BaseController;
use think\facade\Db;

class Finance extends BaseController
{
    /**
     * 订单概况
     * @return mixed
     */
    public function order_overview()
    {
        $financeRepository = app()->make(FinanceRepository::class);
        $data = $financeRepository->order_overview();
        return app('json')->success('ok', $data);
    }
    /**
     * 订单概况
     * @return mixed
     */
    public function user_overview()
    {
        $financeRepository = app()->make(FinanceRepository::class);
        $data = $financeRepository->user_overview();
        return app('json')->success('ok', $data);
    }

    /**
     * 积分统计
     * @return mixed
     */
    public function integral_list(){
        try {
            $financeRepository = app()->make(FinanceRepository::class);
            $date = $financeRepository->integral_list();
            return app('json')->success($date);
        } catch (\Exception $e) {
            Db::name('log')->insert(['data' => '佣金统计错误：' . $e->getFile() . '：' . $e->getLine() . '【' . $e->getMessage() . '】']);
            return app('json')->fail('佣金统计失败');
        }
    }

    /**
     * 佣金统计
     * @return mixed
     */
    public function user_bill()
    {
        try {
            $financeRepository = app()->make(FinanceRepository::class);
            $date = $financeRepository->user_bill();
            return app('json')->success($date);
        } catch (\Exception $e) {
            Db::name('log')->insert(['data' => '佣金统计错误：' . $e->getFile() . '：' . $e->getLine() . '【' . $e->getMessage() . '】']);
            return app('json')->fail('佣金统计失败');
        }
    }

    /**
     * 交易详情
     * @return mixed
     */
    public function transaction_overview()
    {
        $type = input('type', 1);
        $day = input('day', '');
        $mer_id = $this->request->merId();

        $financeRepository = app()->make(FinanceRepository::class);
        $arr = $financeRepository->jieyu($type,$day,$mer_id);

        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['yingyemoney']), 'name' => '营业总额'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['ruzhang']), 'name' => '入账总额'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['shouyi']), 'name' => '佣金奖励总额'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['jieyu']), 'name' => '结余总额'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['hf_fee_amt']), 'name' => '汇付通道服务费金额'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['integral']), 'name' => '积分总数'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['tixinan']), 'name' => '提现支出总额'];
        $data[] = ['className' => 'el-icon-s-goods', 'count' => set_price_rtrim($arr['yanglao']), 'name' => '养老金总额'];


        return app('json')->success('ok', $data);
    }

    public function day_bill_list()
    {
        [$page, $limit] = $this->getPage();
        $where['mer_id'] = 0;
        $query = Db::name('enterprise_day_bill')->where($where);
        $date['count'] = $query->count();
        $date['list'] = $query->page($page, $limit)->order('day desc')->select();

        return app('json')->success($date);
    }

    public function month_bill_list()
    {
        [$page, $limit] = $this->getPage();
        $where['mer_id'] = 0;
        $query = Db::name('enterprise_month_bill')->field('id,month ,flow,expenditure,accounting')->where($where);
        $date['count'] = $query->count();
        $date['list'] = $query->page($page, $limit)->order('month desc')->select();
        return app('json')->success($date);
    }


    /**
     * 列表中的时间条件
     */
    public function date_where($Db, $where, $prefix = 'so.create_time', $field = '-')
    {
        if (!isset($where)) return $Db;
        switch ($where) {
            case 'today':
                $Db->whereBetween($prefix, [date('Y-m-d H:i:s', strtotime('today')), date('Y-m-d H:i:s', strtotime('tomorrow -1second'))]);
                break;
            case 'week':
                $Db->whereBetween($prefix, [date('Y-m-d H:i:s', strtotime('this week 00:00:00')), date('Y-m-d H:i:s', strtotime('next week 00:00:00 -1second'))]);
                break;
            case 'month':
                $Db->whereBetween($prefix, [date('Y-m-d H:i:s', strtotime('first Day of this month 00:00:00')), date('Y-m-d H:i:s', strtotime('first Day of next month 00:00:00 -1second'))]);
                break;
            case 'year':
                $Db->whereBetween($prefix, [date('Y-m-d H:i:s', strtotime('this year 1/1')), date('Y-m-d H:i:s', strtotime('next year 1/1 -1second'))]);
                break;
            case 'yesterday':
                $Db->whereBetween($prefix, [date('Y-m-d H:i:s', strtotime('yesterday')), date('Y-m-d H:i:s', strtotime('today -1second'))]);
                break;
            case 'quarter':
                list($startTime, $endTime) = getMonth();
                $Db = $Db->where($prefix, '>', $startTime);
                $Db = $Db->where($prefix, '<', $endTime);
                break;
            case 'lately7':
                $Db = $Db->where($prefix, 'between', [date('Y-m-d', strtotime("-7 day")), date('Y-m-d H:i:s')]);
                break;
            case 'lately30':
                $Db = $Db->where($prefix, 'between', [date('Y-m-d', strtotime("-30 day")), date('Y-m-d H:i:s')]);
                break;
            default:
                if (strstr($where, $field) !== false) {
                    list($startTime, $endTime) = explode($field, $where);
                    if (strlen($startTime) == 4) {
                        $Db->whereBetweenTime($prefix, date('Y-m-d H:i:s', strtotime($startTime)), date('Y-m-d H:i:s', strtotime($startTime . ' +1day -1second')));
                    } else {
                        if ($startTime == $endTime) {
                            $Db = $Db->whereDay($prefix, $startTime);
                        } else {
                            $Db = $Db->where($prefix, '>', date('Y-m-d H:i:s', strtotime($startTime)));
                            $Db = $Db->where($prefix, '<', date('Y-m-d H:i:s', strtotime($endTime)));
                        }
                    }
                }
                break;
        }
        return $Db;
    }

}