<?php
namespace App\Model\Table;

use App\Model\Entity\Equipement;
use Cake\ORM\Query;
use Cake\ORM\RulesChecker;
use Cake\ORM\Table;
use Cake\Validation\Validator;
use Search\Manager;

/**
 * Equipements Model
 * 
 * 
 * @property \Cake\ORM\Association\BelongsTo $Equipements
 * @property \Cake\ORM\Association\BelongsTo $Services
 * @property \Cake\ORM\Association\BelongsTo $EquipementModeles
 * @property \Cake\ORM\Association\BelongsTo $Ipmgmt
 * @property \Cake\ORM\Association\BelongsTo $Relais
 * @property \Cake\ORM\Association\BelongsTo $EquipementModes
 */
class EquipementsTable extends Table
{

    /**
     * Initialize method
     *
     * @param array $config The configuration for the Table.
     * @return void
     */
    public function initialize(array $config)
    {
        parent::initialize($config);

        $this->table('equipements');
        $this->displayField('title');
        $this->primaryKey('id');

        $this->addBehavior('Search.Search');

        $this->belongsTo('Equipements', [
            'foreignKey' => 'uplink_id'
        ]);
        $this->belongsTo('Services', [
            'foreignKey' => 'service_id'
        ]);
        $this->belongsTo('EquipementModeles', [
            'foreignKey' => 'equipement_modele_id',
            'joinType' => 'INNER'
        ]);
        $this->belongsTo('Ipmgmt', [
            'foreignKey' => 'ipmgmt_id'
        ]);
        $this->belongsTo('Relais', [
            'foreignKey' => 'relais_id'
        ]);
        $this->belongsTo('EquipementModes', [
            'foreignKey' => 'equipement_mode_id',
            'joinType' => 'INNER'
        ]);
    }
	/**
	 * Search plugin queries configuration
	 */
	public function searchConfiguration()
	{
		$search = new Manager($this);
		$search
			->like('q', [
				'before' => true,
				'after' => true,
				'field' => [$this->aliasField('mac'), $this->aliasField('ipmgmt_id'), $this->aliasField('hostname')]
			])
			->value('equipement_modele_id', [ 'field' => $this->aliasField('equipement_modele_id')])
			->value('relais_id', [ 'field' => $this->aliasField('relais_id')]);
		return $search;
	}

    /**
     * Default validation rules.
     *
     * @param \Cake\Validation\Validator $validator Validator instance.
     * @return \Cake\Validation\Validator
     */
    public function validationDefault(Validator $validator)
    {
        $validator
            ->add('id', 'valid', ['rule' => 'numeric'])
            ->allowEmpty('id', 'create');

        $validator
            ->requirePresence('mac', 'create')
            ->notEmpty('mac')
			->add('mac', 'validFormat',[
				'rule' => array('custom', '/^[0-9A-F]{2}(:[0-9A-F]{2}){5}$/'),
				'message' => 'Please use XX:XX:XX:XX:XX:XX MAC format.'
				])
            ->add('mac', 'unique', ['rule' => 'validateUnique', 'provider' => 'table']);

        $validator
            ->requirePresence('hostname', 'create')
            ->notEmpty('hostname');

        $validator
            ->allowEmpty('description');

        $validator
            ->add('date_achat', 'valid', ['rule' => 'date'])
            ->allowEmpty('date_achat');

        $validator
            ->add('date_hs', 'valid', ['rule' => 'date'])
            ->allowEmpty('date_hs');

        $validator
            ->allowEmpty('notes');

        return $validator;
    }

    /**
     * Returns a rules checker object that will be used for validating
     * application integrity.
     *
     * @param \Cake\ORM\RulesChecker $rules The rules object to be modified.
     * @return \Cake\ORM\RulesChecker
     */
    public function buildRules(RulesChecker $rules)
    {
        $rules->add($rules->isUnique(['mac']));
        $rules->add($rules->existsIn(['ipmgmt_id'], 'Ipmgmt'));
        $rules->add($rules->existsIn(['uplink_id'], 'Equipements'));
        $rules->add($rules->existsIn(['service_id'], 'Services'));
        $rules->add($rules->existsIn(['equipement_modele_id'], 'EquipementModeles'));
        $rules->add($rules->existsIn(['relais_id'], 'Relais'));
        $rules->add($rules->existsIn(['equipement_mode_id'], 'EquipementModes'));
        return $rules;
    }
}