<?php namespace App\Models;

use Carbon\Carbon;

class Ads extends GenericCentral
{


    protected $table = 'ads';
    protected $primaryKey = 'id';
    public $module = 'ads';

    protected $guarded = [];
    public $translatable = ['link', 'app_link', 'image', 'mob_image', 'promo_text', 'title'];
    protected $appends = ['local_start_at', 'local_end_at'];

    public function __construct()
    {
        parent::__construct();

    }

    public static function querySelect()
    {

        return "  SELECT ads.* FROM ads  ";
    }

    public static function queryWhere()
    {

        return "  WHERE ads.id IS NOT NULL ";
    }

    public static function queryGroup()
    {
        return "  ";
    }

    public function setLocalStartAtAttribute($value)
    {
        $this->attributes['start_at'] = Carbon::parse($value, 'Africa/Cairo')->setTimezone('UTC');
    }

    public function getLocalStartAtAttribute()
    {
        return ($this->start_at == null) ? null : Carbon::parse($this->start_at, 'UTC')->setTimezone('Africa/Cairo');
    }

    public function setLocalEndAtAttribute($value)
    {
        $this->attributes['end_at'] = (!empty($value)) ? Carbon::parse($value, 'Africa/Cairo')->setTimezone('UTC') : null;
    }

    public function getLocalEndAtAttribute()
    {
        return ($this->end_at == null) ? null : Carbon::parse($this->end_at, 'UTC')->setTimezone('Africa/Cairo');
    }
}