hemall.terabimsoft.com.cn/app/backend/modules/point/controllers/QueueLogController.php

<?php
/**
 * Author: 芸众商城 www.yunzshop.com
 * Date: 2019/3/31
 * Time: 9:42 PM
 */

namespace app\backend\modules\point\controllers;


use app\common\components\BaseController;
use app\common\helpers\PaginationHelper;
use app\common\models\finance\PointQueueLog;
use app\common\models\point\ParentRewardLog;

class QueueLogController extends BaseController
{
    public function index()
    {
        $search = request()->search;
        $list = PointQueueLog::getList($search)
            ->orderBy('id', 'desc')
            ->paginate();
        $pager  = PaginationHelper::show($list->total(), $list->currentPage(), $list->perPage());

        return view('point.queueLog', [
            'list' => $list,
            'pager' => $pager,
            'search' => $search
        ]);
    }

    public function parentIndex()
    {
        $search = request()->search;

        $query = ParentRewardLog::uniacid()->where('expect_reward_time', '<>', 0)
            ->with([
                'hasOneOrder' => function ($query) {
                    $query->select('id', 'order_sn', 'uid')->with(['belongsToMember' => function ($query) {
                        $query->select('uid', 'nickname', 'avatar');
                    }]);
                },
                'hasOneMember' => function ($query) {
                    $query->select('uid', 'nickname', 'avatar');
                },
            ])->orderBy('id', 'DESC');

        if ($search['status'] || $search['status'] === '0' || $search['status'] === 0) {
            $query->where('status', $search['status']);
        }

        if ($search['order_sn']) {
            $query->whereHas('hasOneOrder', function ($query) use ($search) {
                $query->where('order_sn', 'like', "%{$search['order_sn']}%");
            });
        }

        if ($search['uid']) {
            $query->where('uid', $search['uid']);
        }

        if ($search['member_kwd']) {
            $query->whereHas('hasOneMember', function ($query) use ($search) {
                $query->where('nickname', 'like', "%{$search['member_kwd']}%")
                    ->orWhere('mobile', 'like', "%{$search['member_kwd']}%")
                    ->orWhere('realname', 'like', "%{$search['member_kwd']}%");
            });
        }

        $list = $query->paginate();
        $pager = PaginationHelper::show($list->total(), $list->currentPage(), $list->perPage());

        return view('point.parentQueueLog', [
            'list' => $list,
            'pager' => $pager,
            'search' => $search
        ]);
    }
}