community-service/app/Repositories/Circle/CircleRepository.php

<?php

/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/6/5
 * Time: 16:03
 */

namespace App\Repositories\Circle;

use App\Models\InterestCircle;
use App\Models\InterestCircleUser;
use Illuminate\Database\QueryException;
use Dingo\Api\Http\Response;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Redis;

class CircleRepository
{

    public function __construct(InterestCircle $interestCircle,
                                InterestCircleUser $interestCircleUser)
    {
        $this->interestCircle = $interestCircle;
        $this->interestCircleUser = $interestCircleUser;
    }

    /**
     * 圈子列表
     */
    public function circleLists($request, $limit = 3)
    {
        $where[] = ['is_open', 1];
        if (isset($request['is_recommend'])) {
            $where[] = ['is_recommend', 1];
        }

        return $this->interestCircle
            ->where($where)
            ->orderBy('id', 'desc')
            ->take($limit)
            ->get();
    }

    /**
     * 圈子详情
     */
    public function detail($request, $isTrashed = false)
    {
        $model = $this->interestCircle;
        if ($isTrashed) {
            $model->withTrashed();
        }
        return $model->find($request['id']);
    }


    /**
     * 相册列表
     */
    public function pictureLists($request)
    {
        $perPage = isset($request['per_page']) ? $request['per_page'] : 20;
        $where = [];
        if (isset($request['circle_id'])) {
            $where[] = ['circle_id', $request['circle_id']];
        }
        if (isset($request['uid'])) {
            $where[] = ['uid', $request['uid']];
        }

        return $this->interestCirclePicture
            ->where($where)
            ->orderBy('created_at', 'desc')
            ->paginate($perPage);
    }

    /**
     * 删除相册图片
     */
    public function deletePicture($request)
    {
        $circle = $this->interestCirclePicture->where('id', $request['id'])->first();
        if (!$circle) {
            return Response::create([
                'message' => '获取图片信息失败',
                'status_code' => 500
            ]);
        }
        DB::beginTransaction();
        try {
            $circle->delete();
            DB::commit();
            return Response::create();

        } catch (QueryException $exception) {
            DB::rollBack();
            Log::debug('删除相册图片：' . $request['id'] . $exception->getMessage());
            return Response::create([
                'message' => '操作失败，请重试',
                'error' => $exception->getMessage(),
                'status_code' => 500
            ]);
        }
    }

    /**
     * 圈子用户列表
     */
    public function memberLists($request)
    {
        $perPage = isset($request['per_page']) ? $request['per_page'] : 20;
        $where[] = ['is_black', 0];
        $where[] = ['circle_id', $request['circle_id']];

        $userModel = $this->interestCircleUser;

        return $userModel
            ->where($where)
            ->orderBy('created_at', 'desc')
            ->paginate($perPage);
    }
}