<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\SoftDeletes;
use App\Traits\JsonFieldTrait;

class Client extends Model
{
    use SoftDeletes, JsonFieldTrait;
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'numclient', 'name', 'options', 'store_id', 'user_id'
    ];

    /**
     * The attributes that should be mutated to dates.
     *
     * @var array
     */
    protected $dates = ['deleted_at', 'created_at', 'updated_at'];

    protected $appends = [
        'client_options'
    ];

    protected $hidden = [
        'options',
    ];

    /**
     * Relationships
     */
    public function user(){
        return $this->belongsTo(User::class);
    }
    public function store(){
        return $this->belongsTo(Store::class);
    }
    public static function saveFromSyncArray($data){

        foreach($data as $item){
            $client = self::where('numclient', $item->NumClient)->first();
            if(!$client)
                $client = new Client();
            $client->saveFromSync($item);
        }
    }

    public function getClientOptionsAttribute(){
        $options = json_decode($this->options);
        return $options;
    }

    public function saveFromSync($item){
        $storeUser = StoreUsers::first();
        $this->name = $item->Nom;
        $this->numclient = $item->NumClient;
        $this->store_id = $storeUser->store_id;
        $this->user_id = $storeUser->user_id;
        $options = [
            "Ville" => !isset($item->Ville) || is_object($item->Ville) ? "" : $item->Ville,
            "Adresse" => !isset($item->Adresse) || is_object($item->Adresse) ? "" : $item->Adresse,
            "Tel" => !isset($item->Tel) || is_object($item->Tel) ? "" : $item->Tel,
            "Tel2" => !isset($item->Tel2) || is_object($item->Tel2) ? "" : $item->Tel2,
            "CodePostale" => !isset($item->CodePostale) || is_object($item->CodePostale) ? "" : $item->CodePostale,
            "Pays" => !isset($item->Pays) || is_object($item->Pays) ? "" : $item->Pays,
            "Email" => !isset($item->Email) || is_object($item->Email) ? "" : $item->Email,
            "Fax" => !isset($item->Fax) || is_object($item->Fax) ? "" : $item->Fax,
            "Etat" => !isset($item->Etat) || is_object($item->Etat) ? "" : $item->Etat,
            "User_" => !isset($item->User_) || is_object($item->User_) ? "" : $item->User_,
            "PrixRevendeurId" => !isset($item->PrixRevendeurId) || is_object($item->PrixRevendeurId) ? "" : $item->PrixRevendeurId,
            "tva_Client" => !isset($item->tva_Client) || is_object($item->tva_Client) ? "" : $item->tva_Client,
            "DateNaissance" => !isset($item->DateNaissance) || is_object($item->DateNaissance)  ? "" : $item->DateNaissance,
            "NumBadge" => !isset($item->NumBadge) || is_object($item->NumBadge) ? "" : $item->NumBadge,
            "PointsFidelite" => !isset($item->PointsFidelite) || is_object($item->PointsFidelite) ? "" : $item->PointsFidelite,
        ];
        $this->options = json_encode((array)$options);
        $this->save();
        if($item->Etat == "true"){
            $this->delete();
        }
    }
}