Esempio n. 1
0
 public function getArrayHorarisEspaisMaterial()
 {
     $RET = array();
     $C = new Criteria();
     $C = HorarisespaisPeer::getCriteriaActiu($C, $this->getSiteId());
     //      $C->add( HorarisespaisPeer::IDESPAIEXTERN, null);
     $C->addGroupByColumn(HorarisespaisPeer::MATERIAL_IDMATERIAL);
     $LHE = $this->getHorarisespaiss($C);
     foreach ($LHE as $HE) {
         $OM = MaterialPeer::retrieveByPK($HE->getMaterialIdmaterial());
         if ($OM instanceof Material) {
             $RET[$OM->getIdmaterial()] = array('material' => $OM->getIdmaterial(), 'nom' => $OM->toString(), 'generic' => $OM->getMaterialgenericIdmaterialgeneric());
         }
     }
     return $RET;
 }
Esempio n. 2
0
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(MaterialPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(MaterialPeer::DATABASE_NAME);
         $criteria->add(MaterialPeer::IDMATERIAL, $pks, Criteria::IN);
         $objs = MaterialPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
Esempio n. 3
0
function formEditaHoraris($IDA, $FHorari, $MISSATGE, $EXTRES, $IDS)
{
    ?>
			 
     <form action="<?php 
    echo url_for('gestio/gActivitats');
    ?>
" method="POST">
     	<?php 
    if (isset($MISSATGE)) {
        ?>
     	<div style="padding:20px; margin-left:20px; border:10px solid red; width:650px; background-color: black; color:yellow; font-weight:bold;"><?php 
        echo '<ul>';
        if (!isset($MISSATGE)) {
            $MISSATGE = array();
        }
        foreach ($MISSATGE as $M) {
            echo '<li>' . $M . '</li>';
        }
        echo '</ul>';
        ?>
</div>	     	
     	<?php 
    }
    ?>
            
     	<div class="REQUADRE">
     	<div class="OPCIO_FINESTRA"><?php 
    echo link_to(image_tag('icons/Grey/PNG/action_delete.png'), 'gestio/gActivitats?accio=HORARI&IDA=' . $IDA . '&form=0');
    ?>
</div> 		
     		<div class="TITOL">Edició horaris</div>
            <div class="FORMULARI">        	
    
               	<?php 
    echo $FHorari;
    ?>
                                                        
                <div class="clear row fb">
                    <span class="title row_title fb"><b>Espais: </b></span>
                    <span class="row_field fb">
                     	<?php 
    $id = 1;
    $VAL = "";
    foreach ($EXTRES['ESPAISOUT'] as $idE => $nom) {
        if (!empty($idE)) {
            $VAL .= '<span id="rowE[' . $id . ']">
                             					<select name="espais[' . $id . ']" id="espais[' . $id . ']">' . EspaisPeer::selectJavascript($IDS, $idE) . '</select>
                             					<input type="button" style="width:30px;" onClick="esborraLiniaE(' . $id . ');" id="mesespais" value="-"></input>
                             					<br />
                             			  	 </span>
                             			  ';
            $id++;
        }
    }
    echo '<input type="button" id="mesespais" style="width:30px;" value="+"></input><br />';
    echo '<input type="hidden" id="idE" value="' . $id . '"></input>';
    echo '<div id="divTxtE">' . $VAL . '</div>';
    ?>
                    </span>
                </div>
                <div class="clear row fb">
                    <span class="title row_title fb"><b>Material: </b></span>
                    <span class="row_field fb">
                     	<?php 
    $id = 1;
    $VAL = "";
    foreach ($EXTRES['MATERIALOUT'] as $M => $idM) {
        $VAL .= '
             	  	        		<span id="row[' . $id . ']">
             	  	        			<select onChange="ajax(this,' . $id . ')" name="generic[' . $id . ']"> id="generic[' . $id . ']">' . options_for_select(MaterialgenericPeer::select($IDS), $idM['generic']) . '</select>
             	  	        			<select name="material[' . $id . ']" id="material[' . $id . ']">' . options_for_select(MaterialPeer::selectGeneric($idM['generic'], $IDS, $idM['material']), $idM['material']) . '</select>	
             	  	        			<input type="button" style="width:30px;" onClick="esborraLinia(' . $id . ');" id="mesmaterial" value="-"></input>
             	  	        			<br />
             	  	        		</span>  	 	  	        			
                     			  ';
        $id++;
    }
    echo '<input type="button" id="mesmaterial" style="width:30px;" value="+"></input><br />';
    echo '<input type="hidden" id="idV" value="' . $id . '"></input>';
    echo '<div id="divTxt">' . $VAL . '</div>';
    ?>
             	             	                         		
                    </span>
                </div>
                <div class="clear"></div>
                <div id="div_lloc_extern" class="clear row fb">
                    <span class="title row_title fb"><b>Opcions: </b></span>
                    <span class="row_field fb">
                        <a href="#" id="a_lloc_extern">L'activitat es realitza a un lloc extern</a>                     	          	             	            
                    </span>
                </div>                    
                
                <div id="formulari_lloc_extern">
                    <div><b>Població externa</b><br /><br /></div>                    
                    <?php 
    echo $EXTRES['ESPAIEXTERN'];
    ?>
                            
                    <div class="clear"></div>                                        
                </div>

                                       				
                <div class="clear row fb">            		                	
                	<div style="text-align:right">
    	            	<?php 
    include_partial('botonera', array('element' => 'l\\\'horari', 'tipus' => 'Guardar', 'nom' => 'BHORARISAVE'));
    ?>
			 				            		
    	            	<?php 
    include_partial('botonera', array('element' => 'l\\\'horari', 'tipus' => 'Esborrar', 'nom' => 'BHORARIDELETE'));
    ?>
                	</div>
                </div>                	       		
      	 </div>
         <div class="clear"></div>
    </div>
        
    <script type="text/javascript">
    	$(function() {			     
                   $('#multi999Datepicker').datepick({numberOfMonths: 3, multiSelect: 999, showOn: 'both', buttonImageOnly: true, buttonImage: '<?php 
    echo image_path('template/calendar_1.png');
    ?>
'});               			
        });   
    </script>
            
     </form>     
     
<?php 
}
Esempio n. 4
0
 public function LoadEscullMaterial($OCESSIO, $RMATERIAL = null, $RMATERIALNOINV = "", $ERROR_SELECT_MATERIAL = false)
 {
     $this->MATERIALOUT = array();
     //Si és una cessió nova
     if (!$OCESSIO->isNew() && !$ERROR_SELECT_MATERIAL) {
         $this->MATERIALOUT = CessiomaterialPeer::getSelectMaterialOut($OCESSIO->getCessioId(), $this->IDS);
         $this->MAT_NO_INV = $OCESSIO->getMaterialNoInventariat();
         //Si és una edició
     } else {
         //Carreguem el material no inventariat i passem el material a visualitzar altre cop
         $this->MAT_NO_INV = $RMATERIALNOINV;
         foreach ($RMATERIAL as $G => $AM) {
             $idMG = MaterialPeer::retrieveByPK($AM)->getMaterialgenericIdmaterialgeneric();
             $this->MATERIALOUT[] = array('material' => $AM, 'generic' => $idMG);
         }
     }
     $this->IDC = $this->FCessio->getObject()->getCessioId();
     $this->MODE = 'ESCULL_MATERIAL';
 }
 /**
  * Returns the number of related Material objects.
  *
  * @param      Criteria $criteria
  * @param      boolean $distinct
  * @param      PropelPDO $con
  * @return     int Count of related Material objects.
  * @throws     PropelException
  */
 public function countMaterials(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
 {
     if ($criteria === null) {
         $criteria = new Criteria(MaterialgenericPeer::DATABASE_NAME);
     } else {
         $criteria = clone $criteria;
     }
     if ($distinct) {
         $criteria->setDistinct();
     }
     $count = null;
     if ($this->collMaterials === null) {
         if ($this->isNew()) {
             $count = 0;
         } else {
             $criteria->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $this->idmaterialgeneric);
             $count = MaterialPeer::doCount($criteria, false, $con);
         }
     } else {
         // criteria has no effect for a new object
         if (!$this->isNew()) {
             // the following code is to determine if a new query is
             // called for.  If the criteria is the same as the last
             // one, just return count of the collection.
             $criteria->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $this->idmaterialgeneric);
             if (!isset($this->lastMaterialCriteria) || !$this->lastMaterialCriteria->equals($criteria)) {
                 $count = MaterialPeer::doCount($criteria, false, $con);
             } else {
                 $count = count($this->collMaterials);
             }
         } else {
             $count = count($this->collMaterials);
         }
     }
     return $count;
 }
Esempio n. 6
0
 /**
  * Populates the object using an array.
  *
  * This is particularly useful when populating an object from one of the
  * request arrays (e.g. $_POST).  This method goes through the column
  * names, checking to see whether a matching key exists in populated
  * array. If so the setByName() method is called for that column.
  *
  * You can specify the key type of the array by additionally passing one
  * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
  * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
  * The default key type is the column's phpname (e.g. 'AuthorId')
  *
  * @param      array  $arr     An array to populate the object from.
  * @param      string $keyType The type of keys the array uses.
  * @return     void
  */
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = MaterialPeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setIdmaterial($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setMaterialgenericIdmaterialgeneric($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setNom($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setDescripcio($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setResponsable($arr[$keys[4]]);
     }
     if (array_key_exists($keys[5], $arr)) {
         $this->setUbicacio($arr[$keys[5]]);
     }
     if (array_key_exists($keys[6], $arr)) {
         $this->setDatacompra($arr[$keys[6]]);
     }
     if (array_key_exists($keys[7], $arr)) {
         $this->setIdentificador($arr[$keys[7]]);
     }
     if (array_key_exists($keys[8], $arr)) {
         $this->setIdentificadorComptable($arr[$keys[8]]);
     }
     if (array_key_exists($keys[9], $arr)) {
         $this->setNumserie($arr[$keys[9]]);
     }
     if (array_key_exists($keys[10], $arr)) {
         $this->setDatagarantia($arr[$keys[10]]);
     }
     if (array_key_exists($keys[11], $arr)) {
         $this->setDatarevisio($arr[$keys[11]]);
     }
     if (array_key_exists($keys[12], $arr)) {
         $this->setCedit($arr[$keys[12]]);
     }
     if (array_key_exists($keys[13], $arr)) {
         $this->setDatacessio($arr[$keys[13]]);
     }
     if (array_key_exists($keys[14], $arr)) {
         $this->setDataretorn($arr[$keys[14]]);
     }
     if (array_key_exists($keys[15], $arr)) {
         $this->setNumfactura($arr[$keys[15]]);
     }
     if (array_key_exists($keys[16], $arr)) {
         $this->setProveidor($arr[$keys[16]]);
     }
     if (array_key_exists($keys[17], $arr)) {
         $this->setPreu($arr[$keys[17]]);
     }
     if (array_key_exists($keys[18], $arr)) {
         $this->setAmortitzacio($arr[$keys[18]]);
     }
     if (array_key_exists($keys[19], $arr)) {
         $this->setVidaUtil($arr[$keys[19]]);
     }
     if (array_key_exists($keys[20], $arr)) {
         $this->setNotesmanteniment($arr[$keys[20]]);
     }
     if (array_key_exists($keys[21], $arr)) {
         $this->setDatabaixa($arr[$keys[21]]);
     }
     if (array_key_exists($keys[22], $arr)) {
         $this->setDatareparacio($arr[$keys[22]]);
     }
     if (array_key_exists($keys[23], $arr)) {
         $this->setDisponible($arr[$keys[23]]);
     }
     if (array_key_exists($keys[24], $arr)) {
         $this->setAltaregistre($arr[$keys[24]]);
     }
     if (array_key_exists($keys[25], $arr)) {
         $this->setIstransferible($arr[$keys[25]]);
     }
     if (array_key_exists($keys[26], $arr)) {
         $this->setIsadministratiu($arr[$keys[26]]);
     }
     if (array_key_exists($keys[27], $arr)) {
         $this->setSiteId($arr[$keys[27]]);
     }
     if (array_key_exists($keys[28], $arr)) {
         $this->setActiu($arr[$keys[28]]);
     }
     if (array_key_exists($keys[29], $arr)) {
         $this->setUnitats($arr[$keys[29]]);
     }
 }
Esempio n. 7
0
 /**
  * Get the associated Material object
  *
  * @param      PropelPDO Optional Connection object.
  * @return     Material The associated Material object.
  * @throws     PropelException
  */
 public function getMaterial(PropelPDO $con = null)
 {
     if ($this->aMaterial === null && $this->material_idmaterial !== null) {
         $this->aMaterial = MaterialPeer::retrieveByPk($this->material_idmaterial);
         /* The following can be used additionally to
         		   guarantee the related object contains a reference
         		   to this object.  This level of coupling may, however, be
         		   undesirable since it could result in an only partially populated collection
         		   in the referenced object.
         		   $this->aMaterial->addCessiomaterials($this);
         		 */
     }
     return $this->aMaterial;
 }
Esempio n. 8
0
				<div>
					<input type="hidden" name="IDC" value="<?php 
    echo $IDC;
    ?>
" />										
                	<?php 
    $id = 1;
    $VAL = "";
    if (!isset($MATERIALOUT)) {
        $MATERIALOUT = array();
    }
    foreach ($MATERIALOUT as $M => $idM) {
        $VAL .= '
	  	 	  	        		<span id="row[' . $id . ']">
	  	 	  	        			<select onChange="ajax(this,' . $id . ')" name="generic[' . $id . ']"> id="generic[' . $id . ']">' . options_for_select(MaterialgenericPeer::select($IDS), $idM['generic']) . '</select>
	  	 	  	        			<select name="material[' . $id . ']" id="material[' . $id . ']">' . options_for_select(MaterialPeer::selectGeneric($idM['generic'], $IDS, $idM['material']), $idM['material']) . '</select>	
	  	 	  	        			<input type="button" onClick="esborraLinia(' . $id . ');" id="mesmaterial" value="-"></input>
	  	 	  	        			<br />
	  	 	  	        		</span>  	 	  	        			
	             			  ';
        $id++;
    }
    echo '<input type="button" id="mesmaterial" value="+"></input><br />';
    echo '<input type="hidden" id="idV" value="' . $id . '"></input>';
    echo '<div id="divTxt">' . $VAL . '</div>';
    ?>
             	             	            
                	                	                	
				</div>
                <br />
				<div class="fb TITOL" style="width:100%">Material no inventariat</div>
Esempio n. 9
0
 /**
  * Entrem l'identificador de la línia que estem tractant
  *
  * @param int idL
  */
 public static function getLinies($idL)
 {
     $C = new Criteria();
     $C->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $idL);
     return MaterialPeer::doCount($C);
 }
 /**
  * Selects a collection of Cessiomaterial objects pre-filled with all related objects except Cessio.
  *
  * @param      Criteria  $criteria
  * @param      PropelPDO $con
  * @param      String    $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
  * @return     array Array of Cessiomaterial objects.
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function doSelectJoinAllExceptCessio(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
 {
     $criteria = clone $criteria;
     // Set the correct dbName if it has not been overridden
     // $criteria->getDbName() will return the same object if not set to another value
     // so == check is okay and faster
     if ($criteria->getDbName() == Propel::getDefaultDB()) {
         $criteria->setDbName(self::DATABASE_NAME);
     }
     CessiomaterialPeer::addSelectColumns($criteria);
     $startcol2 = CessiomaterialPeer::NUM_COLUMNS - CessiomaterialPeer::NUM_LAZY_LOAD_COLUMNS;
     MaterialPeer::addSelectColumns($criteria);
     $startcol3 = $startcol2 + (MaterialPeer::NUM_COLUMNS - MaterialPeer::NUM_LAZY_LOAD_COLUMNS);
     $criteria->addJoin(CessiomaterialPeer::MATERIAL_IDMATERIAL, MaterialPeer::IDMATERIAL, $join_behavior);
     // symfony_behaviors behavior
     foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
         call_user_func($sf_hook, 'BaseCessiomaterialPeer', $criteria, $con);
     }
     $stmt = BasePeer::doSelect($criteria, $con);
     $results = array();
     while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $key1 = CessiomaterialPeer::getPrimaryKeyHashFromRow($row, 0);
         if (null !== ($obj1 = CessiomaterialPeer::getInstanceFromPool($key1))) {
             // We no longer rehydrate the object, since this can cause data loss.
             // See http://propel.phpdb.org/trac/ticket/509
             // $obj1->hydrate($row, 0, true); // rehydrate
         } else {
             $cls = CessiomaterialPeer::getOMClass(false);
             $obj1 = new $cls();
             $obj1->hydrate($row);
             CessiomaterialPeer::addInstanceToPool($obj1, $key1);
         }
         // if obj1 already loaded
         // Add objects for joined Material rows
         $key2 = MaterialPeer::getPrimaryKeyHashFromRow($row, $startcol2);
         if ($key2 !== null) {
             $obj2 = MaterialPeer::getInstanceFromPool($key2);
             if (!$obj2) {
                 $cls = MaterialPeer::getOMClass(false);
                 $obj2 = new $cls();
                 $obj2->hydrate($row, $startcol2);
                 MaterialPeer::addInstanceToPool($obj2, $key2);
             }
             // if $obj2 already loaded
             // Add the $obj1 (Cessiomaterial) to the collection in $obj2 (Material)
             $obj2->addCessiomaterial($obj1);
         }
         // if joined row is not null
         $results[] = $obj1;
     }
     $stmt->closeCursor();
     return $results;
 }
Esempio n. 11
0
function formCercaMaterials($CERCA, $IDS)
{
    ?>
    <form action="<?php 
    echo url_for('gestio/gEstadistiques');
    ?>
" id="FMATERIALS" method="POST">
	    	<table class="FORMULARI" width="100%">
	            <tr><td>
                	<div class="TITOL">Cerca materials</div>
                	<div class="CERCA">
                        <div style="margin-bottom:10px;">
    	            		<?php 
    echo select_tag('cerca[ANY]', options_for_select(selectAnys(), $CERCA['ANY']), array('class' => 'cinquanta'));
    ?>
                            <?php 
    echo select_tag('cerca[MES]', options_for_select(selectMesos(), $CERCA['MES'], array()), array('class' => 'cinquanta'));
    ?>
                	
                    		<?php 
    echo select_tag('cerca[MATERIAL_GENERIC]', options_for_select(MaterialgenericPeer::select($IDS, false, false), $CERCA['MATERIAL_GENERIC']));
    ?>
                                        	                                                                 
                        </div>
                    <?php 
    foreach (MaterialPeer::selectGeneric($CERCA['MATERIAL_GENERIC'], $IDS) as $K => $V) {
        echo '<div style="float:left; width:210px;">' . checkbox_tag('cerca[MATERIAL][' . $K . ']', $K, isset($CERCA['MATERIAL'][$K]), array()) . ' ' . $V . ' (M' . $K . ')</div>';
    }
    ?>
                                                               	
                    </div>
              	</td></tr>
	            <tr>
	            	<td colspan="2">
	            		<input type="submit" name="BCERCA_MAT" value="Prem per buscar" />	            		
	            	</td>
	            </tr>
	        </table>
     </form>   
    <?php 
}
Esempio n. 12
0
 /**
  * This is a method for emulating ON DELETE CASCADE for DBs that don't support this
  * feature (like MySQL or SQLite).
  *
  * This method is not very speedy because it must perform a query first to get
  * the implicated records and then perform the deletes by calling those Peer classes.
  *
  * This method should be used within a transaction if possible.
  *
  * @param      Criteria $criteria
  * @param      PropelPDO $con
  * @return     int The number of affected rows (if supported by underlying database driver).
  */
 protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
 {
     // initialize var to track total num of affected rows
     $affectedRows = 0;
     // first find the objects that are implicated by the $criteria
     $objects = MaterialgenericPeer::doSelect($criteria, $con);
     foreach ($objects as $obj) {
         // delete related Material objects
         $criteria = new Criteria(MaterialPeer::DATABASE_NAME);
         $criteria->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $obj->getIdmaterialgeneric());
         $affectedRows += MaterialPeer::doDelete($criteria, $con);
     }
     return $affectedRows;
 }
Esempio n. 13
0
 public function GuardaHorari($horaris, $EXTRES, $idS)
 {
     $ERRORS = array();
     $DBDD[] = array();
     //Comprovem que s'hagi entrat un dia
     if (empty($horaris['Dia'])) {
         $ERRORS[] = "No has entrat cap data";
         $DBDD['DIES'] = array();
     } else {
         $DIES = explode(',', $horaris['Dia']);
         foreach ($DIES as $D) {
             list($dia, $mes, $any) = explode('/', $D);
             if (!($any > 2000 && $mes < 13 && $dia < 32)) {
                 $ERRORS[] = "La data que has entrat és incorrecta";
             }
             $DBDD['DIES'][] = "{$any}-{$mes}-{$dia}";
         }
     }
     //Passem l'hora a format numèric per fer les comprovacions
     $DBDD['HoraPre'] = strval($horaris['HoraPre']['hour']) * 60 + strval($horaris['HoraPre']['minute']);
     $DBDD['HoraIn'] = strval($horaris['HoraInici']['hour']) * 60 + strval($horaris['HoraInici']['minute']);
     $DBDD['HoraFi'] = strval($horaris['HoraFi']['hour']) * 60 + strval($horaris['HoraFi']['minute']);
     $DBDD['HoraPost'] = strval($horaris['HoraPost']['hour']) * 60 + strval($horaris['HoraPost']['minute']);
     if ($DBDD['HoraPre'] > $DBDD['HoraIn']) {
         $ERRORS[] = "L'hora de preparació no pot ser més gran que la d'inici.";
     }
     if ($DBDD['HoraIn'] >= $DBDD['HoraFi']) {
         $ERRORS[] = "L'hora d'inici no pot ser més gran o igual que la d'acabament.";
     }
     if ($DBDD['HoraFi'] > $DBDD['HoraPost']) {
         $ERRORS[] = "L'hora d'acabament no pot ser més gran que la de desmuntatge.";
     }
     //Un cop fetes les verificacions... tornem a posar els valors que guardarem
     $DBDD['HoraPre'] = $horaris['HoraPre']['hour'] . ':' . $horaris['HoraPre']['minute'];
     $DBDD['HoraIn'] = $horaris['HoraInici']['hour'] . ':' . $horaris['HoraInici']['minute'];
     $DBDD['HoraFi'] = $horaris['HoraFi']['hour'] . ':' . $horaris['HoraFi']['minute'];
     $DBDD['HoraPost'] = $horaris['HoraPost']['hour'] . ':' . $horaris['HoraPost']['minute'];
     //Hem d'entrar algun espai ja sigui intern o extern i no podem entrar espais interns i a més externs
     if (empty($EXTRES['ESPAISOUT']) && !$EXTRES['ESPAIEXTERN']->isBound()) {
         $ERRORS[] = "Has d'entrar algun espai intern o extern";
     }
     if (!empty($EXTRES['ESPAISOUT']) && $EXTRES['ESPAIEXTERN']->isBound()) {
         $ERRORS[] = "No pots entrar espais interns i externs a la vegada";
     }
     //Mirem que la data no es solapi amb alguna altra activitat al mateix espai
     foreach ($DBDD['DIES'] as $D) {
         //Per tots els espais interns
         foreach ($EXTRES['ESPAISOUT'] as $E => $idE) {
             //Si l'usuari bloqueja un espai hem de mirar que no hi hagi cap activitat aquell dia.
             if ($idE == 22) {
                 $RS = HorarisPeer::getActivitatsDia($D, $idS);
                 if (sizeof($RS) > 0) {
                     $ERRORS[] = "El dia {$D} hi ha " . sizeof($RS) . " activitat(s) que impedeixen el bloqueig.";
                 }
             } else {
                 //Mirem si encaixa amb alguna altra activitat solta
                 $LOH = HorarisPeer::validaDia($D, $idE, $DBDD['HoraPre'], $DBDD['HoraPost'], $horaris['HorarisID'], $idS);
                 if (sizeof($LOH) > 0) {
                     $Espai = EspaisPeer::retrieveByPK($idE)->getNom();
                     foreach ($LOH as $OH) {
                         $OA = $OH->getActivitatss();
                         $nomActivitat = $OA->getNom();
                         $ERRORS[] = "El dia {$D} coincideix a l'espai {$Espai} amb l'activitat '" . $nomActivitat . "'";
                     }
                 } elseif (HorarisPeer::validaDiaBloqueig($D, $horaris['HorarisID'], $this->IDS)) {
                     $ERRORS[] = "El dia {$D} hi ha una activitat que bloqueja tots els espais!";
                 }
             }
         }
         //Comprovem l'ocupació del material
         foreach ($EXTRES['MATERIALOUT'] as $M => $idM) {
             if (!MaterialPeer::isLliure($idM['material'], $this->IDS, $D, $DBDD['HoraPre'], $DBDD['HoraPost'], $horaris['HorarisID'])) {
                 $OM = MaterialPeer::retrieveByPK($idM['material']);
                 if ($OM instanceof Material) {
                     $nom = $OM->toString();
                 } else {
                     $nom = "n/d";
                 }
                 $ERRORS[] = "El material " . $nom . " està ocupat el dia " . $D;
             }
         }
     }
     //Si no hem trobat cap error, guardem els registres d'ocupació.
     if (empty($ERRORS)) {
         HorarisPeer::save($horaris, $DBDD, $EXTRES, $idS);
     }
     return $ERRORS;
 }
Esempio n. 14
0
 public static function getSelectMaterialOut($idC, $idS)
 {
     $C = new Criteria();
     $C->add(self::CESSIO_ID, $idC);
     $C->add(self::SITE_ID, $idS);
     $C->add(self::ACTIU, true);
     $C->addJoin(self::MATERIAL_IDMATERIAL, MaterialPeer::IDMATERIAL);
     $RET = array();
     foreach (MaterialPeer::doSelect($C) as $K => $V) {
         $RET[] = array('material' => $V->getIdmaterial(), 'generic' => $V->getMaterialgenericIdmaterialgeneric());
     }
     return $RET;
 }
Esempio n. 15
0
 public function getMaterialsActiu()
 {
     $C = new Criteria();
     $C = MaterialPeer::getCriteriaActiu($C, $this->getSiteId());
     return $this->getMaterials($C);
 }
Esempio n. 16
0
 /**
  * Comprova que el dia estigui lliure 
  * */
 public static function validaDia($DIA, $idE, $HoraPre, $HoraPost, $idH, $idS)
 {
     //Garantim que si hi ha un altre espai, no comprovi
     if ($idE == 1) {
         $idE = 0;
     }
     //Tornar-la a fer per fer-la més criteria;
     $C = new Criteria();
     $C = self::getCriteriaActiu($C, $idS);
     $C->addJoin(self::HORARISID, HorarisespaisPeer::HORARIS_HORARISID);
     $C = HorarisespaisPeer::getCriteriaActiu($C, $idS);
     $C->add(HorarisespaisPeer::ESPAIS_ESPAIID, $idE);
     $C->addAnd(MaterialPeer::getCriteriaSolapament($C, $HoraPre, $HoraPost, HorarisPeer::HORAPRE, HorarisPeer::HORAPOST));
     $C->add(self::DIA, $DIA);
     if ($idH > 0) {
         $C->add(HorarisespaisPeer::HORARIS_HORARISID, $idH, Criteria::NOT_EQUAL);
     }
     return self::doSelect($C);
 }