<?php 
/*** COPYRIGHT NOTICE *********************************************************
 *
 * Copyright 2009-2017 ProjeQtOr - Pascal BERNARD - support@projeqtor.org
 * Contributors : -
 *
 * This file is part of ProjeQtOr.
 * 
 * ProjeQtOr is free software: you can redistribute it and/or modify it under 
 * the terms of the GNU Affero General Public License as published by the Free 
 * Software Foundation, either version 3 of the License, or (at your option) 
 * any later version.
 * 
 * ProjeQtOr is distributed in the hope that it will be useful, but WITHOUT ANY
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for 
 * more details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * ProjeQtOr. If not, see <http://www.gnu.org/licenses/>.
 *
 * You can get complete code of ProjeQtOr, other resource, help and information
 * about contributors at http://www.projeqtor.org 
 *     
 *** DO NOT REMOVE THIS NOTICE ************************************************/

/* ============================================================================
 * Stauts defines list of Priorities an activity or action can get in (lifecylce).
 */ 
require_once('_securityCheck.php');
class ResourceSkill extends SqlElement {

  public $id;
  public $idResource;
  public $idSkill;
  public $idSkillLevel;   
  public $useSince;
  public $useUntil;
  public $idle;
  public $comment;

   /** ==========================================================================
   * Constructor
   * @param $id the id of the object in the database (null if not stored yet)
   * @return void
   */ 
  function __construct($id = NULL, $withoutDependentObjects=false) {
    parent::__construct($id,$withoutDependentObjects);
  }

  
   /** ==========================================================================
   * Destructor
   * @return void
   */ 
  function __destruct() {
    parent::__destruct();
  }

  /** =========================================================================
  * control data corresponding to Model constraints
  * @param void
  * @return "OK" if controls are good or an error message
  *  must be redefined in the inherited class
  */
  public function control(){
  	$result="";
  	$crit=array("idResource"=>$this->idResource, "idSkill"=>$this->idSkill, "idSkillLevel"=>$this->idSkillLevel);
  	$lst=$this->getSqlElementsFromCriteria($crit,false);
  	if (count($lst)>0 and ! SqlElement::isSaveConfirmed()) {
  		if (! $this->id or count($lst)>1 or $lst[0]->id!=$this->id) {
  			$result.='<br/>' . i18n('errorDuplicate');
  		}
  	}
  	$defaultControl=parent::control();
  	if ($defaultControl!='OK') {
  		$result.=$defaultControl;
  	}if ($result=="") {
  		$result='OK';
  	}
  	return $result;
  }
  
  /**=========================================================================
  * Overrides SqlElement::save() function to add specific treatments
  * @see persistence/SqlElement#save()
  * @return the return message of persistence/SqlElement#save() method
  */
  public function save() {
    $lastResourceSkillList = $this->getSqlElementsFromCriteria(array('idResource'=>$this->idResource, 'idSkill'=>$this->idSkill),false,null,'idSkillLevel DESC, useUntil DESC');
    $lastResourceSkill = (count($lastResourceSkillList)> 0)?$lastResourceSkillList[0]:null;
  	if ($lastResourceSkill) {
  		$thisSkillLevelWeight = SqlList::getFieldFromId('SkillLevel', $this->idSkillLevel, 'weight');
  		$lastSkillLevelWeight = SqlList::getFieldFromId('SkillLevel', $lastResourceSkill->idSkillLevel, 'weight');
  		if($thisSkillLevelWeight > $lastSkillLevelWeight){
  		  $lastResourceSkill->useUntil = date('Y-m-d', pq_strtotime('-1 day',pq_strtotime ($this->useSince)));
  		  $lastResourceSkill->save();
  		}
  	}
  	$result = parent::save();
  	return $result;
  
  }
}
?>