Subversion-Projekte lars-tiefland.webanos.marine-sales.de

<?php

    namespace App\Models;

    use Illuminate\Database\Eloquent\Factories\HasFactory;
    use Illuminate\Database\Eloquent\Model;
    use Illuminate\Database\Eloquent\Relations\BelongsTo;
    use Illuminate\Database\Eloquent\Relations\HasMany;
    use Illuminate\Support\Facades\Cache;
    use Spatie\Sluggable\HasSlug;
    use Spatie\Sluggable\SlugOptions;

    /**
 * App\Models\Item
 *
 * @property int $id
 * @property int|null $manufacturer_id
 * @property int|null $directory_id
 * @property int|null $shipping_group_id
 * @property string $name
 * @property string $slug
 * @property int $status
 * @property float $weight
 * @property string $description
 * @property string $ean
 * @property string|null $mpn
 * @property string $kennung
 * @property string $short_line_1
 * @property string $created_by
 * @property string $updated_by
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property-read \App\Models\Manufacturer|null $manufacturer
 * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\ItemMedium> $medium
 * @property-read int|null $medium_count
 * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\Price> $price
 * @property-read int|null $price_count
 * @method static \Database\Factories\ItemFactory factory($count = null, $state = [])
 * @method static \Illuminate\Database\Eloquent\Builder|Item newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|Item newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|Item query()
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereCreatedBy($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereDescription($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereDirectoryId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereEan($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereKennung($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereManufacturerId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereMpn($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereShippingGroupId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereShortLine1($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereSlug($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereStatus($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereUpdatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereUpdatedBy($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Item whereWeight($value)
 * @mixin \Eloquent
 */
class Item extends Model
    {
        use HasFactory, HasSlug;

        /**
         * Get the options for generating the slug.
         */
        public function getSlugOptions(): SlugOptions
        {
            return SlugOptions::create()
                ->generateSlugsFrom( 'name' )
                ->saveSlugsTo( 'slug' )
                ->usingLanguage( 'de' )
                ->doNotGenerateSlugsOnUpdate()
                ->skipGenerateWhen( function ()
                {
                    return $this->directory_id < 0;
                } );
        }

        function medium(): HasMany
        {
            return $this->hasMany( ItemMedium::class )->orderBy( "rank" );
        }

        public function price(): HasMany
        {
            return $this->hasMany( Price::class )->where("preis","!=",0)->orderBy( "preis_index" );
        }

        public function manufacturer(): BelongsTo
        {
            return $this->belongsTo( Manufacturer::class );
        }

        // On the Model class add the following method.

        public function resolveRouteBinding( $value, $field = null ): ?Model
        {
            $cacheName = "item_" . $value;

            if ( Cache::has( $cacheName ) )
            {
                return Cache::get( $cacheName );
            }

            $result = $this->with( 'price', 'medium.medium', 'manufacturer' )->where( 'slug', $value )->firstOrFail();
            Cache::put( $cacheName, $result, 86400 );

            return $result;
        }
    }