<?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 ************************************************/

/** ===========================================================================
 * Delete the current object : call corresponding method in SqlElement Class
 */

require_once "../tool/projeqtor.php";
$number = RequestHandler::getValue('number');
$idCatalog = RequestHandler::getId('idCatalog');
$idWorkUnit = RequestHandler::getId('idWorkUnit');
Sql::beginTransaction();
if($number){
  $catalog = new CatalogUO($idCatalog);
  $oldCatalog = $catalog->getOld();
  if($number < $oldCatalog->numberComplexities){
    $complexity = new Complexity();
    $complexityValue = new ComplexityValues();
    $lstComplexities = $complexity->getSqlElementsFromCriteria(array('idCatalogUO'=>$idCatalog));
    $stopDelete = false;
    foreach ($lstComplexities as $val){
      $where = " (idComplexity=".$val->id.") and (charge  IS NOT NULL OR price IS NOT NULL OR duration IS NOT NULL ) ";
      $cantDelete = $complexityValue->countSqlElementsFromCriteria(null,$where);
      if($cantDelete)$stopDelete = true;
    }
    if(!$stopDelete){
      foreach ($lstComplexities as $val){
        if($val->idZone > $number ){
          $val->delete();
        }
      }
    }else{
        echo $oldCatalog->numberComplexities;
    }
    Sql::commitTransaction();
  }
}else{
  $workUnit = new WorkUnit($idWorkUnit);
  $result=$workUnit->delete();
  displayLastOperationStatus($result);
}
?>