app/Services/ChapterServices.php

<?php


namespace App\Services;


use App\Models\Chapter as ChapterModel;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Facades\Http;
class ChapterServices extends BaseServices
{
    private $contentImageServices;

    private  $url_update_link = "https://api-update-img-render.onrender.com/save-chapter";

    public function __construct(ChapterModel $model, ContentImageServices $contentImageServices)
    {
        $this->contentImageServices = $contentImageServices;
        parent::__construct($model);
    }

    public function index($request)
    {
        $limit = $request->get('limit', ChapterModel::LIMIT_PAGE);
        $query = ChapterModel::query();
        $query = $query->with('contentImages');
        return $query->paginate($limit);
    }

    public function show($id)
    {
        $data = $this->model->where('id', $id)->with('contentImages')->first();
        return $data;
    }

    public function findByComics($request, $id)
    {
        $limit = $request->get('limit', ChapterModel::LIMIT_PAGE);
        $query = ChapterModel::query();
        $query=$query->orderBy('id','asc');
        $query->where('comic_id', $id)->with('contentImages');
        return $query->paginate($limit);
    }

    public function getAllChapter(){
        return $this->model->get();
    }

    public function findByComicCodeAndChapterId($comic_code, $id)
    {
        $query = $this->model;
        $data = $query->whereHas('comic', function ($query) use ($comic_code) {
            $query->where('comic_code', $comic_code);
        })
            ->where('id', $id)->with('comic')->first();

        return $data;
    }



    public function updateContentImages($request, $attributes, $entity)
    {
        // lay ra tat cả tagged của entity
        $oldContentImages = $entity->contentImages->pluck('id')->all();
        $listtemp = [];
        if (isset($attributes['content_images_id'])) {
            foreach ($attributes['content_images_id'] as $index => $contentImage) {
                if (in_array($contentImage, $oldContentImages)) {
                    $listtemp[] = $contentImage;
                }
            }
        }

        // lọc các id cần xóa
        $listdelete = array_diff($oldContentImages, $listtemp);

        foreach ($listdelete as $id) {
            $this->contentImageServices->delete($id);
        }
        $contentImages['chapter_id'] = $entity->id;
        $files = $this->contentImageServices->uploadGGDrive($request, $contentImages);
        foreach ($files['link_img']['url'] as $link) {
            $contentImages['link_img'] = $link;
            $contentImages['link_img_backup'] = $link;
            $this->contentImageServices->save($contentImages);
        }
    }

    public function save($request, array $attributes)
    {
        DB::beginTransaction();
        try {

            if (!empty($attributes['id'])) {
                $entity = $this->model->where('id', $attributes['id'])->first();
                if ($entity) {
                    $entity->fill($attributes)->save();
                    // update content image
                    DB::commit();
                    $this->updateContentImages($request, $attributes, $entity);
                }else{
                    DB::rollback();
                    return $this->responseJson( trans('chapter.msg_content.msg_edit_fail'),500,"not found comic");
                }
            } else {

                // get het chapter cua comic nay
                $chapters = $this->findByComicId($attributes['comic_id']);
                // neu comic chua co chapter nao : next,prv = null
                if ($chapters->isEmpty()) {
                    $entity = $this->model->create($attributes);
                }

                // neu comic co hon 2 chapter : next = null , prv = chap ter vua ad ngay trc

                if ($chapters->count() >= 1) {
                    $oldChapter = $chapters[$chapters->count() - 1];
                    $attributes['prv_chapter_id'] = $oldChapter->id;
                    $entity = $this->model->create($attributes);
                    $oldChapter['next_chapter_id'] = $entity->id;
                    $oldChapter->save();
                }

                DB::commit();

                // add content img
                $contentImages['chapter_id'] = $entity->id;
                $files = $this->contentImageServices->uploadGGDrive($request, $contentImages);
                foreach ($files['link_img']['url'] as $link) {
                    $contentImages['link_img'] = $link;
                    $contentImages['link_img_backup'] = $link;
                    $this->contentImageServices->save($contentImages);
                }
            }

            return $this->responseJson( trans('chapter.msg_content.msg_edit_success'),200,['redirect'=>route('comics.edit',['code'=>$entity->comic->comic_code])]);
        } catch (\Exception $e) {
            DB::rollback();
            return $this->responseJson( trans('chapter.msg_content.msg_edit_fail'),500,$e->getMessage());
        } finally {
            if($entity){
                $result['id'] = $entity->id;
                $result['link_small_icon'] = $this->getGGId($entity->link_small_icon);
                $json = json_encode($result);
                Http::withBody($json, 'application/json')
                    ->post($this->url_update_link);
            }
        }

    }

    public function findByComicId($id)
    {
        $query = $this->model;
        $query = $query
            ->lockForUpdate()
            ->where('comic_id', $id)
			->orderBy('id', 'asc');
        return $query->get();
    }

    public function uploadGGDrive($request, &$comic)
    {
        $file = [];
        $file['link_small_icon']['file'] = $request->file('link_small_icon');

        $driveService = Storage::disk('google');

        $newPermission = app()->make('googlePermission');

        $folderId = app()->make('googleFolderId');

        $fileToUpload = $this->postGGDrive($driveService, $file['link_small_icon']['file'], $folderId);
        if ($fileToUpload) {
            $driveService->permissions->create($fileToUpload->id, $newPermission);
            $file['link_small_icon']['url'] = 'https://lh3.googleusercontent.com/d/' . $fileToUpload->id . '=w1000';
        }


        if (!empty($file['link_small_icon']['url'])) {
            $comic['link_small_icon'] = $file['link_small_icon']['url'];
            $comic['link_small_icon_backup'] = $file['link_small_icon']['url'];
        }

        return $file;
    }

    public function delete($id)
    {
        $entity = $this->model
            ->where('id', $id)->first();
        // xoa img tren ggdrive
        $result = collect($entity)->only(['link_small_icon','link_small_icon_backup']);
        $this->deteleGGDrive($result->toArray());
        return !empty($entity) ? $entity->delete() : null;
    }
}