php/app/controller/admin/finance/PlatformIncomeDetail.php

<?php


namespace app\controller\admin\finance;

use app\common\repositories\finance\FinanceRepository;
use app\common\repositories\merchant\order\OrderMerchantRepository;
use app\controller\api\entropybarter\User;
use crmeb\basic\BaseController;
use crmeb\services\AliYunSmsService;
use think\facade\Cache;
use think\facade\Db;

class PlatformIncomeDetail extends BaseController
{
    public function lst()
    {
        try {
            [$page, $limit] = $this->getPage();
            $where = $this->request->params(['date']);
            $params = $this->request->params(['pm', 'deal_type', 'search', 'keyword','select_type']);

            $query = Db::name('enterprise_platform_income_detail')
                ->alias('income_detail')
                ->leftJoin('user u', 'u.uid=income_detail.uid')
                // ->where('income_detail.mer_id', '!=', 0)
                ->whereNotIn('deal_type', [3])
                ->when(isset($params['pm']) && $params['pm'] != '', function ($query) use ($params) {
                    $query->where('pm', $params['pm']);
                })
                ->when(isset($params['deal_type']) && $params['deal_type'] > 0, function ($query) use ($params) {
                    $query->where('deal_type', $params['deal_type']);
                })
                ->when(isset($params['select_type']) && !empty($params['select_type']) , function ($query) use ($params) {
                    if($params['select_type']=='platform_income_detail'){
//                        $query->whereIn('deal_type', [1,2,3,5]);
                    }elseif($params['select_type']=='platform_income_detail_yj'){
//                        $income_detail_ids=Db::name('enterprise_platform_income_detail')
//                            ->alias('income_detail')
//                            ->leftJoin('user u', 'u.uid=income_detail.uid')
//                            ->leftJoin('store_order o', 'o.order_id=income_detail.order_id')
//                            ->where('income_detail.mer_id', 0)
////                            ->where('income_detail.deal_type',4)
//                            ->where('pay_type!=5')->column('income_detail.id');
//                        $query->whereIn('income_detail.id', $income_detail_ids);
                    }
                })
                ->when(isset($params['search']) && $params['search'], function ($query) use ($params) {
                    $select_uid = Db::name('user')
                        ->where('nickname', 'like', "%{$params['search']}%")
                        ->whereOr('phone', 'like', "%{$params['search']}%")
                        ->column('uid');
                    $query->whereIn('income_detail.uid', $select_uid);
                })
                ->when(isset($params['keyword']) && $params['keyword'], function ($query) use ($params) {
                    $select_uid = Db::name('user')
                        ->where('nickname', 'like', "%{$params['keyword']}%")
                        ->whereOr('phone', 'like', "%{$params['keyword']}%")
                        ->column('uid');
                    if ($select_uid) {
                        $query->where(" (income_detail.uid in (" . join(',', $select_uid) . ") or income_detail.deal_order_sn like '%{$params['keyword']}%' or income_detail.order_sn like '%{$params['keyword']}%')");
                    } else {
                        $query->where(" (income_detail.deal_order_sn like '%{$params['keyword']}%' or income_detail.order_sn like '%{$params['keyword']}%')");
                    }
                })
                // ->where('u.test_user', '<', '1')
                ->page($page, $limit)
                ->field('income_detail.*,u.nickname,u.phone')
                ->order('income_detail.deal_time', 'desc');
            $list = $this->date_where($query, $where['date'], 'income_detail.deal_time')->select();
            if (!$list) {
                return app('json')->success([]);
            }

            $count = $query->count('income_detail.id');

            $list->each(function ($item)  {
                $item['pay_type'] = Db::name('store_order')
                    ->where('order_id', $item['order_id'])
                    ->value('pay_type');
                $item['extract_type'] = Db::name('user_extract')
                    ->where('extract_id', $item['user_extra_id'])
                    ->value('extract_type');
                return $item;
            });

            $query1 = clone $query;
            $query2 = clone $query;
            $query5 = clone $query;
            $query6 = clone $query;
            //总入账
            $platform_enter_all = $query1
                ->whereIn('deal_type', [6,7])
                ->where('pm', 1)
                ->sum('money');
            //总支出
            $platform_out_all = $query2
                ->whereIn('deal_type', [4,5])
                ->where('pm', 0)
                ->sum('money');

            $yongjin_out_all = $query5
                ->where('deal_type', 2)
                ->where('pm', 1)
                ->sum('money');

            $order_in_money = $query6
                ->where('deal_type', 1)
                ->where('pm', 1)
                ->sum('money');

            $return_data = compact('platform_out_all', 'yongjin_out_all', 'platform_enter_all',  'list', 'count');
            return app('json')->success($return_data);
        } catch (\Exception $e) {
            Db::name('log')->insert(['data' => '获取平台收支明细错误：' . $e->getFile() . '：' . $e->getLine() . '【' . $e->getMessage() . '】']);
            return app('json')->fail('获取平台收支明细失败' . $e->getFile() . '：' . $e->getLine() . '【' . $e->getMessage());
        }
    }

    /**
     * @param $id
     * @return mixed
     * @author Qinii
     * @day 2020-06-11
     */

    public function detail($id)
    {
        $financeRepository = app()->make(FinanceRepository::class);
        $data = $financeRepository->income_detail($id);
        return app('json')->success($data);
    }

    /**
     * 列表中的时间条件
     */
    public function date_where($Db, $where, $prefix = '', $field = '-')
    {
        if (!isset($where)) return $Db;
        switch ($where) {
            case strlen($where) == 10 && strstr($where, $field) !== false:
                // 2024-03-08
                $Db->whereBetweenTime($prefix, date('Y-m-d H:i:s', strtotime($where)), date('Y-m-d H:i:s', strtotime($where . ' +1day -1second')));
            case strlen($where) == 7 && strstr($where, $field) !== false:
                // 2024-03
                $Db->whereBetweenTime($prefix, date('Y-m-d H:i:s', strtotime($where)), date('Y-m-d H:i:s', strtotime($where . ' +1month -1second')));
                break;
            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;
    }


}