<?php

namespace Modules\Connector\Http\Controllers\Api\V2;

use App\Services\Api\BusinessContextService;
use App\User;
use App\Utils\Util;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Modules\Connector\Http\Controllers\Api\UserController as V1UserController;
use Spatie\Permission\Models\Role;

class UserController extends BaseController
{
    public function __construct(
        protected V1UserController $v1Controller,
        protected BusinessContextService $contextService,
        protected Util $commonUtil,
    ) {
    }

    public function index(Request $request)
    {
        $business_id = $this->contextService->getBusinessId($request);

        if ($request->boolean('service_staff')) {
            $users = $this->commonUtil->getServiceStaff($business_id);

            return $this->success(collect($users)->values());
        }

        $query = User::where('business_id', $business_id)
            ->user()
            ->where('is_cmmsn_agnt', 0)
            ->select([
                'id',
                'username',
                'first_name',
                'last_name',
                'email',
                'status',
                'allow_login',
                DB::raw("TRIM(CONCAT(COALESCE(surname, ''), ' ', COALESCE(first_name, ''), ' ', COALESCE(last_name, ''))) as full_name"),
            ])
            ->orderBy('username');

        if ($request->filled('search')) {
            $search = $request->input('search');
            $query->where(function ($q) use ($search) {
                $q->where('username', 'like', "%{$search}%")
                    ->orWhere('first_name', 'like', "%{$search}%")
                    ->orWhere('last_name', 'like', "%{$search}%")
                    ->orWhere('email', 'like', "%{$search}%");
            });
        }

        return $this->paginated($query->paginate($request->input('per_page', 25)));
    }

    public function show($id)
    {
        return $this->v1Controller->show($id);
    }

    public function roles(Request $request)
    {
        $business_id = $request->attributes->get('api_user')['business_id'];

        $roles = Role::where('business_id', $business_id)
            ->with('permissions')
            ->get();

        return $this->success($roles);
    }
}