8889841c<?php

namespace App\Http\Controllers;

use App\Models\ClientsService;
use App\Models\Service;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class ClientsServiceController extends Controller
{

    public function assignService(Request $request)
    {
        //$assignservice = new ClientsService();
        //$assignservice->services_id = $request->assignservice;
        //$assignservice->save();

    }
    public function getAssignedService(Request $request)
    {
        /* $service = DB::table('client_services')
            ->join('services', 'client_services.services_id', '=', 'services.id')
            ->select('services.*')
            ->where('client_services.clients_id', $request->clients_id)
            ->where('status', 'Active')
            ->get();*/

        /*$service = Service::join('client_services', 'client_services.services_id', '=', 'services.id')
            ->where('client_services.clients_id', $request->clients_id)
            ->where('status', 'Active')
            ->get();*/

        $service = ClientsService::with('service')
            ->where('clients_id', $request->clients_id)
            ->get();

        if (count($service) > 0) {
            return response()->json($service);
        }
    }
    public function assignServiceUpdate($id)
    {
        $assignservice = ClientsService::find($id);
        return view('client.assignedService.assignservice', compact('assignservice'));
    }
    public function assignServiceUpdateData(Request $request, $id)
    {
        $data = ClientsService::find($id);
        $schedule_end = $request->enddate;
        $start_date = Carbon::parse($data->created_at)->format('Y-m-d');

        if ($schedule_end > $start_date) {
            $data->update([
                'schedule_end' => $schedule_end
            ]);
            return redirect()->back()->with('message', 'End date is Successfully updated!');
        } else {
            return back()->with('error', 'End date must be greater than start date!');
        }
    }
}