Edit File - File Manager

Edit File: Store.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Cache;
use Spatie\Translatable\HasTranslations;
use App\Models\Setting;
use App\Http\Resources\StoreResource;
use DateTime;
use Illuminate\Database\Eloquent\SoftDeletes;
use App\Traits\Uploadable;
use Illuminate\Support\Facades\File;

class Store extends Model
{
    use HasFactory,Uploadable, HasTranslations;
    use SoftDeletes;

/**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = ['store_id','commission_used' ,'desc', 'refuse_reason' ,'image','iban_image' , 'bank_number' ,'name','icon','cover','lat','long','address','num_rating','rate','citc_authority_id','category','offer','offer_image','offer_amount','offer_type','offer_max','available','join_request','seen','status','special','has_contract','user_id','app_commission','commission_type','commercial_id','commercial_image','bank_name','bank_acc_name','iban_number'];
    protected $guarded = [];

public $translatable = ['name' , 'desc'];

protected function asJson($value)
    {
        return json_encode($value, JSON_UNESCAPED_UNICODE);
    }
    public function scopeSearch($query, $searchArray = [])
    {
        $query->where(function ($query) use ($searchArray) {
            if ($searchArray) {
                foreach ($searchArray as $key => $value) {
                    if (str_contains($key, '_id')) {
                        if (null != $value) {
                            $query->Where($key, $value);
                        }
                    } elseif ('order' == $key) {
                    } elseif ('created_at_min' == $key) {
                        if (null != $value) {
                            $query->WhereDate('created_at', '>=', $value);
                        }
                    } elseif ('created_at_max' == $key) {
                        if (null != $value) {
                            $query->WhereDate('created_at', '<=', $value);
                        }
                    }elseif ('name' == $key) {
                        if (null != $value) {
                            $query->Where('name->ar', $value)
                            ->orWhere('name->en',$value);
                        }
                    } else {
                        $query->Where($key, 'like', '%' . $value . '%');
                    }
                }
            }
        });
        return $query->orderBy('created_at', request()->searchArray && request()->searchArray['order'] ? request()->searchArray['order'] : 'DESC');
    }

public function getIconPathAttribute()
    {
        return asset('assets/uploads/stores/' . $this->icon);
    }

public function getCommercialImagePathAttribute()
    {
        return asset('assets/uploads/stores/' . $this->commercial_image);
    }

public function setCommercialImageAttribute($value)
    {
        
        if($value && is_file($value)){
            File::delete(public_path('assets/uploads/stores/' . $this->commercial_image));
            $this->attributes['commercial_image'] = $this->uploadFile($value, 'stores', true, 250, null);
        } else {
            $this->attributes['commercial_image'] = $value;
        }

}
    public function setIconAttribute($value)
    {
        if($value && is_file($value)){
            File::delete(public_path('assets/uploads/stores/' . $this->icon));
            $this->attributes['icon'] = $this->uploadFile($value, 'stores', true, 250, null);
        } else {
            $this->attributes['icon'] = $value;
        }
    }
    public static function boot() {
        parent::boot();
        /* creating, created, updating, updated, deleting, deleted, forceDeleted, restored */

self::deleted(function ($model) {
            $model->deleteFile($model->attributes['icon'], 'stores');
            $model->deleteFile($model->attributes['cover'], 'stores');

});
    }

public function isFather()
    {
        return is_null($this->attributes['store_id']);
    }

protected $appends = ['is_father'];

public function getIsFatherAttribute()
    {
        return is_null($this->attributes['store_id']);
    }

public function parent()
    {
        return $this->belongsTo(Store::class, 'store_id', 'id');
    }

public function branches()
    {
        return $this->hasMany(Store::class);
    }

public function timings(){
        return $this->hasMany(StoreTiming::class);
    }

public function reviews(){
        return $this->hasMany(Review::class,'store_id');
    }

public function rating(){
        $reviewsCount = $this->reviews()->count();
        if($reviewsCount == 0){
            return number_format(0,2);
        }
        $reviews = $this->reviews;
        $sum = 0;
        foreach($reviews as $review){
            $sum+=$review->rate;
        }
        return number_format(round($sum/$reviewsCount,2),2);
    }

public function openingHours($lang = 'ar'){
        $opening_hours_ = "";
        $days = ['saturday','sunday','monday','tuesday','wednesday','thursday','friday'];
        $open_status = false;
        $current_day = lcfirst(date('l'));
        $opening_hours_arr = [];
        foreach($days as $day){
            $timings  = $this->timings()->where('day',$day)->get();
            if(count($timings) == 0){
                $opening_hours_arr[]=[
                    'day'   => trans('stores.'.$day),
                    'time'  => trans('stores.closed')
                ];
            }else{
                $i = 0;
                $opening_hours_= trans('stores.'.$day).": ";
                foreach($timings as $timing){
                    $from = $lang == 'ar'? ($timing->from > 11 ? date('h:i \م',strtotime($timing->from)) : date('h:i \ص',strtotime($timing->from))) : date('h:i a',strtotime($timing->from));
                    $fromEN=date('h:i a',strtotime($timing->from));
                    $toEN=date('h:i a',strtotime($timing->to));
                    $to =  $lang == 'ar' ? ($timing->to > 11 ? date('h:i \م',strtotime($timing->to)) : date('h:i \ص',strtotime($timing->to))) : date('h:i a',strtotime($timing->to)) ;
                    if(++$i === count($timings)) {
                        $opening_hours_arr[]=[
                            'day'   => trans('stores.'.$day),
                            'time'  => $from." ".trans('stores.to')." ".$to
                        ];
                    }else{
                        $opening_hours_arr[]=[
                            'day'   => trans('stores.'.$day),
                            'time'  => $from." ".trans('stores.to')." ".$to." ".trans('stores.and')." "
                        ];
                    }
                    if($day == $current_day){
                        $current_time = date('h:i a');
                        $date1 = DateTime::createFromFormat('h:i a', $current_time);
                        $date2 = DateTime::createFromFormat('h:i a', $fromEN);
                        $date3 = DateTime::createFromFormat('h:i a', $toEN);
                        if ($date1 >= $date2 && $date1 <= $date3) {
                            $open_status = true;
                        }
                    }
                }
            }
        }
        $data = [
            'opening_hours_arr' =>$opening_hours_arr,
            'open_status'       =>$open_status
        ];
        return $data;
    }

public function storeOpeningHours()
    {
        $days = ['saturday', 'sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday'];
        $opening= [];
        foreach ($days as $key=>$day) {
            $timings = $this->timings()->where('day', $day)->get();
            if (count($timings) == 0) {
//                $opening [] = [
//                    'id' =>$key,
//                    'key' => $day,
//                    'day' => trans('stores.' . $day),
//                    'from' => "00.00",
//                    'to' => "00.00",
//                ];
                continue;
            }else {
                foreach ($timings as $time) {
                    $opening[] = [
                        'id'=>$key,
                        'key'=>$day,
                        'day' => trans('stores.' . $time->day),
                        'from' => date('h:i a', strtotime($time->from)),
                        'to' => date('h:i a', strtotime($time->to)),
                    ];
//                    array_push($data, $opening);

}
            }
            }
            return $opening;

}

public function menuCategories(){
        return $this->hasMany(StoreMenuCategory::class);
    }
    
    public function menuGoogles(){
        return $this->hasMany(StoreMenu::class,'store_id');
    }

public function products(){
        return $this->hasMany(Product::class);
    }

public function productAdditiveCategories(){
        return $this->hasMany(ProductAdditiveCategory::class);
    }

/**
     * Get the user that owns the Store
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
     */
    public function user()
    {
        return $this->belongsTo(User::class, 'user_id', 'id');
    }

public function categories()
    {
        return $this->belongsToMany(Category::class, 'store_categories');
    }

public function cachedMenusWithProducts(){

return Cache::rememberForever('store-' . $this->id, function ()  {
                return new StoreResource($this->load('menuCategories'));
            });
    }

public function orders()
    {
        return $this->hasMany(Order::class);
    }

public function updateCacheWithProducts(){
        Cache::forget('store-'.$this->id);
        $this->cachedMenusWithProducts();
    }
    
    public function getCategory(){
        return Category::where('slug',$this->category)->first()->name;
    }
}

Back to File Manager