public function setup()
{
$SN = array(true => 'SÃ', false => 'No');
$this->setWidgets(array('ReservaEspaiID' => new sfWidgetFormInputHidden(), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'DataActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'HorariActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'EspaisSolicitats' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => EspaisPeer::selectFormReserva($this->getOption('IDS')), 'multiple' => true, 'expanded' => true), array('class' => 'ul_espais')), 'MaterialSolicitat' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => MaterialgenericPeer::selectFormulariUsuaris($this->getOption('IDS')), 'multiple' => true, 'expanded' => true), array('class' => 'ul_material')), 'TipusActe' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'Representacio' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'Responsable' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'Organitzadors' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'PersonalAutoritzat' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'PrevisioAssistents' => new sfWidgetFormChoice(array('choices' => $this->AssistentsArray()), array()), 'isEnregistrable' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'EsCicle' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'Comentaris' => new sfWidgetFormTextarea(array(), array('style' => 'width:450px')), 'Estat' => new sfWidgetFormInputHidden(), 'DataAlta' => new sfWidgetFormInputHidden(), 'Condicions' => new sfWidgetFormChoice(array('choices' => array(0 => 'No', 1 => 'SÃ'))), 'CondicionsCCG' => new sfWidgetFormTextareaTinyMCE(array(), array('style' => 'width:400px; height:200px;', 'disabled' => 'disabled')), 'DataAcceptacioCondicions' => new sfWidgetFormInputHidden(), 'ObservacionsCondicions' => new sfWidgetFormTextarea(array(), array('style' => 'width:450px'))));
$this->setValidators(array('ReservaEspaiID' => new sfValidatorPropelChoice(array('model' => 'Reservaespais', 'column' => 'ReservaEspaiID', 'required' => false)), 'Representacio' => new sfValidatorString(array('required' => true)), 'Responsable' => new sfValidatorString(array('required' => true)), 'PersonalAutoritzat' => new sfValidatorString(array('required' => true)), 'PrevisioAssistents' => new sfValidatorInteger(array('required' => true)), 'EsCicle' => new sfValidatorBoolean(array('required' => true)), 'Comentaris' => new sfValidatorString(array('required' => false)), 'Estat' => new sfValidatorString(array('max_length' => 1, 'required' => false)), 'Organitzadors' => new sfValidatorString(array('required' => true)), 'DataActivitat' => new sfValidatorString(array('required' => true)), 'HorariActivitat' => new sfValidatorString(array('required' => true)), 'TipusActe' => new sfValidatorString(array('required' => true)), 'Nom' => new sfValidatorString(array('required' => true)), 'isEnregistrable' => new sfValidatorBoolean(array('required' => true)), 'DataAlta' => new sfValidatorDateTime(array('required' => false)), 'EspaisSolicitats' => new sfValidatorString(array('required' => true)), 'MaterialSolicitat' => new sfValidatorString(array('required' => false)), 'Condicions' => new sfValidatorBoolean(array('required' => false)), 'CondicionsCCG' => new sfValidatorPass(), 'DataAcceptacioCondicions' => new sfValidatorPass(), 'ObservacionsCondicions' => new sfValidatorString(array('required' => false))));
$this->widgetSchema->setLabels(array('Nom' => "Nom de l'activitat ", 'DataActivitat' => "Proposta de data ", 'HorariActivitat' => "Proposta d'hores ", 'Espais' => 'Espais (<a class="blue" href="' . sfConfig::get('sf_webroot') . 'intranet_dev.php/web/espais" target="_NEW">veure\'ls</a>)', 'Material' => "Material ", 'TipusActe' => "Tipus d'acte ", 'isEnregistrable' => "És enregistrable?", 'Representacio' => "En representació de ", 'Responsable' => "Responsable ", 'Organitzadors' => "Organitzadors ", 'PersonalAutoritzat' => "Personal autoritzat ", 'PrevisioAssistents' => "Previsió d'assistents ", 'EsCicle' => "És un cicle? ", 'Comentaris' => "Comentaris ", 'EspaisSolicitats' => "Espais ", 'MaterialSolicitat' => "Material ", 'ObservacionsCondicions' => "Observacions "));
$this->widgetSchema->setNameFormat('reservaespais[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
}
public function getEspaisString()
{
$sol = array();
$espais = explode('@', $this->espaissolicitats);
foreach ($espais as $E) {
$ESPAI = EspaisPeer::initialize($E, $this->getSiteId())->getObject();
$sol[$ESPAI->getEspaiid()] = $ESPAI->getNom();
}
return implode(' , ', $sol);
}
public function setup()
{
$SN = array(true => 'Sí', false => 'No');
$this->setWidgets(array('tractada' => new sfWidgetFormChoice(array('choices' => $SN)), 'Codi' => new sfWidgetFormInputText(array(), array()), 'Estat' => new sfWidgetFormChoice(array('choices' => ReservaespaisPeer::selectEstat())), 'CondicionsCCG' => new sfWidgetFormTextareaTinyMCE(), 'ReservaEspaiID' => new sfWidgetFormInputHidden(), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'DataActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'HorariActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'EspaisSolicitats' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => EspaisPeer::selectFormReserva($this->getOption('IDS')), 'multiple' => true, 'expanded' => true), array('class' => 'ul_espais')), 'MaterialSolicitat' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => MaterialgenericPeer::selectFormulariUsuaris(), 'multiple' => true, 'expanded' => true), array('class' => 'ul_material')), 'TipusActe' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Representacio' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Responsable' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'TelefonResponsable' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Organitzadors' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'PersonalAutoritzat' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'PrevisioAssistents' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'isEnregistrable' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'EsCicle' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'Comentaris' => new sfWidgetFormTextarea(array(), array('rows' => '10', 'cols' => '50')), 'Usuaris_usuariID' => new sfWidgetFormInputHidden(), 'DataAlta' => new sfWidgetFormInputHidden(), 'DataAcceptacioCondicions' => new sfWidgetFormInputHidden(), 'ObservacionsCondicions' => new sfWidgetFormTextarea(array(), array('rows' => '10', 'cols' => '50'))));
$this->setValidators(array('tractada' => new sfValidatorPass(array('required' => false), array()), 'Codi' => new sfValidatorPass(array('required' => false), array()), 'ReservaEspaiID' => new sfValidatorPropelChoice(array('model' => 'Reservaespais', 'column' => 'ReservaEspaiID', 'required' => false)), 'Representacio' => new sfValidatorString(array('required' => true)), 'Responsable' => new sfValidatorString(array('required' => true)), 'TelefonResponsable' => new sfValidatorString(array('required' => true)), 'PersonalAutoritzat' => new sfValidatorString(array('required' => true)), 'PrevisioAssistents' => new sfValidatorInteger(array('required' => true)), 'EsCicle' => new sfValidatorBoolean(array('required' => true)), 'Comentaris' => new sfValidatorString(array('required' => false)), 'Estat' => new sfValidatorString(array('max_length' => 1, 'required' => true)), 'Usuaris_usuariID' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID', 'required' => true)), 'Organitzadors' => new sfValidatorString(array('required' => true)), 'DataActivitat' => new sfValidatorString(array('required' => true)), 'HorariActivitat' => new sfValidatorString(array('required' => true)), 'TipusActe' => new sfValidatorString(array('required' => true)), 'Nom' => new sfValidatorString(array('required' => true)), 'isEnregistrable' => new sfValidatorBoolean(array('required' => true)), 'DataAlta' => new sfValidatorDateTime(array('required' => false)), 'EspaisSolicitats' => new sfValidatorString(array('required' => false)), 'MaterialSolicitat' => new sfValidatorString(array('required' => false)), 'CondicionsCCG' => new sfValidatorPass(), 'DataAcceptacioCondicions' => new sfValidatorPass(), 'ObservacionsCondicions' => new sfValidatorString(array('required' => false))));
$this->widgetSchema->setLabels(array('tractada' => 'Tractada?', 'Codi' => "Codi: ", 'Estat' => "Estat actual: ", 'Nom' => "Nom de l'activitat: ", 'DataActivitat' => "Proposta de data: ", 'HorariActivitat' => "Horari de l'activitat: ", 'Espais' => 'Espais: (<a class="blue" href="' . sfConfig::get('sf_webroot') . 'intranet_dev.php/web/espais" target="_NEW">veure\'ls</a>)', 'Material' => "Material: ", 'TipusActe' => "Tipus d'acte: ", 'isEnregistrable' => "És enregistrable?", 'Representacio' => "En representació de: ", 'Responsable' => "Responsable: ", 'TelefonResponsable' => "Telèfon del responsable: ", 'Organitzadors' => "Organitzadors: ", 'PersonalAutoritzat' => "Personal autoritzat: ", 'PrevisioAssistents' => "Previsió d'assistents: ", 'EsCicle' => "És un cicle? ", 'Comentaris' => "Comentaris: ", 'EspaisSolicitats' => 'Espais: ', 'MaterialSolicitat' => 'Material: ', 'ObservacionsCondicions' => 'Observacions ', 'CondicionsCCG' => 'Condicions '));
$this->widgetSchema->setNameFormat('reservaespais[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
$this->widgetSchema->setFormFormatterName('Span');
}
public function setup()
{
$this->WEB_IMATGE = 'images/espais/';
$Sino = array(0 => 'No', 1 => 'SÃ');
$this->IDS = $this->getOption('IDS');
$this->setWidgets(array('EspaiID' => new sfWidgetFormChoice(array('choices' => EspaisPeer::select($this->IDS, true)), array()), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Ordre' => new sfWidgetFormInputText(array(), array('style' => 'width:50px')), 'site_id' => new sfWidgetFormInputHidden(), 'actiu' => new sfWidgetFormInputHidden(), 'isLlogable' => new sfWidgetFormChoice(array('choices' => $Sino)), 'descripcio' => new sfWidgetFormTextareaTinyMCE(array(), array())));
$this->setValidators(array('EspaiID' => new sfValidatorPass(), 'Nom' => new sfValidatorString(array('max_length' => 50, 'required' => false)), 'Ordre' => new sfValidatorInteger(array('min' => -32768, 'max' => 32767)), 'site_id' => new sfValidatorInteger(array('min' => -128, 'max' => 127, 'required' => false)), 'actiu' => new sfValidatorInteger(array('min' => -128, 'max' => 127)), 'isLlogable' => new sfValidatorPass(array(), array()), 'descripcio' => new sfValidatorString(array('required' => false), array())));
$this->widgetSchema->setNameFormat('espais[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
$this->widgetSchema->setLabels(array('EspaiID' => 'Espai ', 'Nom' => 'Nom ', 'Ordre' => 'Ordre ', 'isLlogable' => 'Es lloga?', 'descripcio' => 'Descripció '));
}
public function getEspais()
{
$RET = array();
$con = Propel::getConnection();
$stmt = $con->createStatement();
$idA = $this->getActivitatid();
$SQL = "\r\n SELECT E.*\r\n FROM espais E, horarisespais HE, horaris H \r\n WHERE H.Activitats_ActivitatID = {$idA} \r\n AND H.HorarisID = HE.Horaris_HorarisID \r\n AND HE.Espais_EspaiID = E.EspaiID\r\n GROUP BY E.Nom\r\n ";
$rs = $stmt->executeQuery($SQL, ResultSet::FETCHMODE_NUM);
foreach (EspaisPeer::populateObjects($rs) as $E) {
$RET[] = $E->getNom();
}
return $RET;
}
<!-- COMENÇA LES ACTIVITATS PER AVUI PER ESPAI -->
<table style="display:none;" id="LLISTAT_ORDENAT_ESPAIS" class="DADES">
<?php
if (empty($ACTIVITATS)) {
echo '<tr><td></td></tr>';
}
$ESPAIS = array();
foreach ($ACTIVITATS as $idH => $A) {
foreach ($A['ESPAIS'] as $idE => $E) {
$ESPAIS[$idE][] = $idH;
}
}
$ANT = "";
//Reordeno espais perquè apareguin com estan ordenats a la intranet.
$ESPAIS_REAL = EspaisPeer::getEspaisSite($IDS);
$ESPAIS_ORDENAT = array();
foreach ($ESPAIS_REAL as $OE) {
$idE = $OE->getNom();
if (isset($ESPAIS[$idE])) {
$ESPAIS_ORDENAT[$idE] = $ESPAIS[$idE];
}
}
foreach ($ESPAIS_ORDENAT as $idE => $HORA) {
foreach ($HORA as $idH) {
$A = $ACTIVITATS[$idH];
echo '<tr>';
if (strlen($A['AVIS']) > 2) {
$AVIS = '<a href="#" class="tt2">' . image_tag('tango/32x32/emblems/emblem-important.png', array('size' => '16x16')) . '<span>' . $A['AVIS'] . '</span></a>';
} else {
$AVIS = "";
public function executeEspais(sfWebRequest $request)
{
$this->LoadWEB($request);
$this->setTemplate('index');
$this->LLISTAT_ESPAIS = EspaisPeer::getEspaisSite($this->IDS);
$this->ACCIO = 'espais';
}
/**
* hospiciActions::executeEspais()
*
* Part de mostra dels espais per reservar a l'hospici
*
* @param mixed $request
* @return void
*/
public function executeEspais(sfWebRequest $request)
{
$this->setLayout('hospici');
$this->setTemplate('indexReservaEspais');
$this->accio = $request->getParameter('accio', 'index');
//Carrego la cerca
$this->CERCA = $this->getUser()->getSessionPar('cerca', array());
$this->DESPLEGABLES = array();
$this->AUTH = $this->getUser()->isAuthenticated();
if ($this->accio == 'cerca_espais' || $this->accio == 'inici') {
//Agafo els paràmetres
if ($request->getMethod() == 'POST') {
$C = $request->getParameter('cerca', array());
}
$C['P'] = $request->getParameter('P', 1);
//Si em trobo el paràmetre SITE, impilca que he entrat per llistat d'entitats i vull veure tot el d'una.
if ($request->hasParameter('SITE')) {
$C['SITE'] = $request->getParameter('SITE');
}
$C2 = $this->getCercaEspaisComplet($C);
//Faig la cerca dels cursos de l'Hospici i ho retorno amb valors
//La cerca hauria de tornar els cursos, segons els paràmetres i a més els llistats amb els valors.
$this->LLISTAT_ESPAIS = EspaisPeer::getEspaisCercaHospici($C2);
$this->DESPLEGABLES['SELECT_POBLACIONS'] = EspaisPeer::getPoblacionsHospici($C2);
$this->DESPLEGABLES['SELECT_ENTITATS'] = EspaisPeer::getEntitatsHospici($C2);
$this->DESPLEGABLES['SELECT_CATEGORIES'] = EspaisPeer::getCategoriesHospici($C2);
//Guardem a sessió la cerca "actual"
$this->CERCA = $C2;
$this->getUser()->setSessionPar('cerca', $this->CERCA);
$this->MODE = 'CERCA';
} elseif ($this->accio == 'detall_espai') {
$this->ESPAI = EspaisPeer::retrieveByPK($request->getParameter('idE'));
$this->DATA = $request->getParameter('data', time());
$month = date('m', $this->DATA);
$year = date('Y', $this->DATA);
$this->OCUPACIO = EspaisPeer::getEstadistiquesEspais(array($request->getParameter('idE')), $this->ESPAI->getSiteId(), $month, $year);
$d = mktime(0, 0, 0, $month + 1, 1, $year);
$month = date('m', $d);
$year = date('Y', $d);
$this->OCUPACIO2 = EspaisPeer::getEstadistiquesEspais(array($request->getParameter('idE')), $this->ESPAI->getSiteId(), $month, $year);
$this->MODE = 'DETALL';
}
}
/**
* Get the associated Espais object
*
* @param PropelPDO Optional Connection object.
* @return Espais The associated Espais object.
* @throws PropelException
*/
public function getEspais(PropelPDO $con = null)
{
if ($this->aEspais === null && $this->espais_espaiid !== null) {
$this->aEspais = EspaisPeer::retrieveByPk($this->espais_espaiid);
/* 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->aEspais->addHorarisespaiss($this);
*/
}
return $this->aEspais;
}
<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($OH->getSiteId(), $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>
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
}
/**
* Selects a collection of Horarisespais objects pre-filled with all related objects except Horaris.
*
* @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 Horarisespais objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptHoraris(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);
}
HorarisespaisPeer::addSelectColumns($criteria);
$startcol2 = HorarisespaisPeer::NUM_COLUMNS - HorarisespaisPeer::NUM_LAZY_LOAD_COLUMNS;
MaterialPeer::addSelectColumns($criteria);
$startcol3 = $startcol2 + (MaterialPeer::NUM_COLUMNS - MaterialPeer::NUM_LAZY_LOAD_COLUMNS);
EspaisPeer::addSelectColumns($criteria);
$startcol4 = $startcol3 + (EspaisPeer::NUM_COLUMNS - EspaisPeer::NUM_LAZY_LOAD_COLUMNS);
EspaisExternsPeer::addSelectColumns($criteria);
$startcol5 = $startcol4 + (EspaisExternsPeer::NUM_COLUMNS - EspaisExternsPeer::NUM_LAZY_LOAD_COLUMNS);
$criteria->addJoin(HorarisespaisPeer::MATERIAL_IDMATERIAL, MaterialPeer::IDMATERIAL, $join_behavior);
$criteria->addJoin(HorarisespaisPeer::ESPAIS_ESPAIID, EspaisPeer::ESPAIID, $join_behavior);
$criteria->addJoin(HorarisespaisPeer::IDESPAIEXTERN, EspaisExternsPeer::IDESPAIEXTERN, $join_behavior);
// symfony_behaviors behavior
foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
call_user_func($sf_hook, 'BaseHorarisespaisPeer', $criteria, $con);
}
$stmt = BasePeer::doSelect($criteria, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = HorarisespaisPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = HorarisespaisPeer::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 = HorarisespaisPeer::getOMClass(false);
$obj1 = new $cls();
$obj1->hydrate($row);
HorarisespaisPeer::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 (Horarisespais) to the collection in $obj2 (Material)
$obj2->addHorarisespais($obj1);
}
// if joined row is not null
// Add objects for joined Espais rows
$key3 = EspaisPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = EspaisPeer::getInstanceFromPool($key3);
if (!$obj3) {
$cls = EspaisPeer::getOMClass(false);
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
EspaisPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (Horarisespais) to the collection in $obj3 (Espais)
$obj3->addHorarisespais($obj1);
}
// if joined row is not null
// Add objects for joined EspaisExterns rows
$key4 = EspaisExternsPeer::getPrimaryKeyHashFromRow($row, $startcol4);
if ($key4 !== null) {
$obj4 = EspaisExternsPeer::getInstanceFromPool($key4);
if (!$obj4) {
$cls = EspaisExternsPeer::getOMClass(false);
$obj4 = new $cls();
$obj4->hydrate($row, $startcol4);
EspaisExternsPeer::addInstanceToPool($obj4, $key4);
}
// if $obj4 already loaded
// Add the $obj1 (Horarisespais) to the collection in $obj4 (EspaisExterns)
$obj4->addHorarisespais($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
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;
}
foreach ($LINIA as $K => $L) {
echo '<TR>';
echo '<TD>';
if (isset($ERRORS[$K]['DATA'])) {
echo '<div class="ERRORS">' . $ERRORS[$K]['DATA'] . '</DIV><br />';
}
if (isset($ERRORS[$K]['DIA'])) {
echo '<div class="ERRORS">' . $ERRORS[$K]['DIA'] . '</DIV>';
}
echo input_tag("D[{$K}][DIA]", $L['DIA'], array('id' => 'DIA')) . '<br />' . input_tag("D[{$K}][HORAPRE]", $L['HORAPRE'], array('id' => 'HORA')) . ' - ' . input_tag("D[{$K}][HORAI]", $L['HORAI'], array('id' => 'HORA')) . ' - ' . input_tag("D[{$K}][HORAF]", $L['HORAF'], array('id' => 'HORA')) . ' - ' . input_tag("D[{$K}][HORAPOST]", $L['HORAPOST'], array('id' => 'HORA')) . '</TD>';
echo '<TD>';
if (isset($ERRORS[$K]['ESPAIS'])) {
echo '<div class="ERRORS">' . $ERRORS[$K]['ESPAIS'] . '</DIV><br />';
}
foreach ($L['ESPAIS'] as $E) {
echo select_tag("D[{$K}][ESPAIS][]", options_for_select(EspaisPeer::select(), $E, array('include_blank' => true)), array('multiple' => false)) . '<br />';
}
echo '</TD>';
echo '<TD>';
foreach ($L['MATERIAL'] as $M) {
echo select_tag("D[{$K}][MATERIAL][]", options_for_select(MaterialgenericPeer::select(), $M, array('include_blank' => true)), array('multiple' => false)) . '<BR />';
}
echo '</TD>';
echo '</TR>';
}
echo '</table>';
echo submit_tag('Afegir extres', array('name' => 'Extra'));
echo submit_tag('Guardar', array('name' => 'Save'));
}
?>
public static function getEspaisCercaHospici($CER)
{
$C = new Criteria();
$C = self::CriteriaCercaEspaisHospici($CER, $C);
//Ara fem la select dels cursos amb el pager
return EspaisPeer::doSelect($C);
}
function formLlistaActivitats($ACTIVITATS, $PAGINA, $IDS)
{
?>
<div class="REQUADRE">
<div class="TITOL">Llistat d'activitats <span style="color:gray; font-weight:normal; ">(Ordenat per <a id="ORDENA_HORARIS" href="#">horaris</a> / <a id="ORDENA_ESPAIS" href="#">espais</a> )</span></div>
<table id="LLISTAT_ORDENAT_HORARIS" class="DADES">
<?php
if (sizeof($ACTIVITATS) == 0) {
echo '<TR><TD class="LINIA">No s\'ha trobat cap activitat.</TD></TR>';
}
foreach ($ACTIVITATS as $idH => $A) {
$AVIS = "";
$ESP = "";
$MAT = "";
$PUBLICAT = "";
if (!empty($A['ESPAIS'])) {
$ESP = implode("<br />", $A['ESPAIS']);
}
if (!empty($A['MATERIAL'])) {
$MAT = implode("<br />", $A['MATERIAL']);
}
if (strlen($A['AVIS']) > 2) {
$AVIS = '<a href="#" class="tt2">' . image_tag('tango/32x32/emblems/emblem-important.png', array('size' => '16x16')) . '<span>' . $A['AVIS'] . '</span></a>';
} else {
$AVIS = "";
}
if ($A['PUBLICAT'] == 'OK') {
$PUBLICAT = image_tag('template/exclamation.png', array('size' => '16x16'));
} elseif ($A['PUBLICAT'] == 'FALTA_INFO') {
$PUBLICAT = image_tag('template/stop.png', array('size' => '16x16'));
}
$j = 1;
$PAR = ParImpar($j++);
$url_act = link_to($A['NOM_ACTIVITAT'], 'gestio/gActivitats?accio=ACTIVITAT&IDA=' . $A['ID'], array('style' => 'font-size:12px'));
$url_hor = "";
//link_to('Edita informació pràctica','gestio/gActivitats?accio=HORARI&IDA='.$A['ID'].'&IDH='.$idH,array('style'=>'font-size:10px'));
$org = empty($A['ORGANITZADOR']) ? "" : "<span style=\"font-size:8px; color:gray; \"> (" . $A['ORGANITZADOR'] . ") </span>";
echo ' <tr><td style="background-color:#EEEEEE; border:1px solid #EEEEEE; height:15px;" colspan="6"></td></tr>';
echo ' <tr><td class="LIST2 ' . $PAR . '" colspan="6">' . $url_act . $AVIS . ' ' . $PUBLICAT . $org . ' <div style="float:right">' . $url_hor . '</div></td></tr>';
echo ' <TR>
<TD class="LIST2 ' . $PAR . '"><span style="font-weight:bold; font-size:10px; color:#880000;">' . $A['HORA_PRE'] . '</span></TD>
<TD class="LIST2 ' . $PAR . '"><span style="font-weight:bold; font-size:12px; color:green;">' . $A['HORA_INICI'] . '</span></TD>
<TD class="LIST2 ' . $PAR . '"><b>' . $A['HORA_FI'] . '</b></TD>';
echo ' <TD class="LIST2 ' . $PAR . '"><span style="font-weight:bold; font-size:12px; color:#800000;">' . $ESP . '</span></TD>';
echo ' <TD class="LIST2 ' . $PAR . '">' . $MAT . '</TD>
<TD class="LIST2 ' . $PAR . '">' . $A['DIA'] . '</TD>
</TR>';
}
?>
</table>
<table id="LLISTAT_ORDENAT_ESPAIS" class="DADES" style="display: none;">
<?php
if (sizeof($ACTIVITATS) == 0) {
echo '<TR><TD class="LINIA">No s\'ha trobat cap activitat.</TD></TR>';
}
$ESPAIS = array();
foreach ($ACTIVITATS as $idH => $A) {
foreach ($A['ESPAIS'] as $idE => $E) {
$ESPAIS[$idE][] = $idH;
}
}
$ANT = "";
//Reordeno espais perquè apareguin com estan ordenats a la intranet.
$ESPAIS_REAL = EspaisPeer::getEspaisSite($IDS);
$ESPAIS_ORDENAT = array();
foreach ($ESPAIS_REAL as $OE) {
$idE = $OE->getNom();
if (isset($ESPAIS[$idE])) {
$ESPAIS_ORDENAT[$idE] = $ESPAIS[$idE];
}
}
foreach ($ESPAIS_ORDENAT as $idE => $HORA) {
foreach ($HORA as $idH) {
$A = $ACTIVITATS[$idH];
//Per cada horari, agafem l'espai i fem un vector on guardarem els resultats.'
$AVIS = "";
$ESP = "";
$MAT = "";
$PUBLICAT = "";
if (!empty($A['ESPAIS'])) {
$ESP = $A['ESPAIS'][$idE];
}
if (!empty($A['MATERIAL'])) {
$MAT = implode("<br />", $A['MATERIAL']);
}
if (strlen($A['AVIS']) > 2) {
$AVIS = '<a href="#" class="tt2">' . image_tag('tango/32x32/emblems/emblem-important.png', array('size' => '16x16')) . '<span>' . $A['AVIS'] . '</span></a>';
} else {
$AVIS = "";
}
if ($A['PUBLICAT'] == 'OK') {
$PUBLICAT = image_tag('template/exclamation.png', array('size' => '16x16'));
} elseif ($A['PUBLICAT'] == 'FALTA_INFO') {
$PUBLICAT = image_tag('template/stop.png', array('size' => '16x16'));
}
$j = 1;
$PAR = ParImpar($j++);
$url_act = link_to($A['NOM_ACTIVITAT'], 'gestio/gActivitats?accio=ACTIVITAT&IDA=' . $A['ID'], array('style' => 'font-size:12px'));
$url_hor = $org = empty($A['ORGANITZADOR']) ? "" : "<span style=\"font-size:8px; color:gray; \"> (" . $A['ORGANITZADOR'] . ") </span>";
if ($ANT != $ESP) {
echo ' <tr><td style="background-color:#AAAAAA; font-size:14px; color:EEEEEE; font-style:italic; border:1px solid #EEEEEE; height:15px;" colspan="6">' . $ESP . '</td></tr>';
} else {
echo ' <tr><td style="background-color:#EEEEEE; border:1px solid #EEEEEE; height:15px;" colspan="6"> </td></tr>';
}
$ANT = $ESP;
echo ' <tr><td class="LIST2 ' . $PAR . '" colspan="6">' . $url_act . $AVIS . ' ' . $PUBLICAT . $org . ' <div style="float:right">' . $url_hor . '</div></td></tr>';
echo ' <TR>
<TD class="LIST2 ' . $PAR . '"><span style="font-weight:bold; font-size:10px; color:#880000;">' . $A['HORA_PRE'] . '</span></TD>
<TD class="LIST2 ' . $PAR . '"><span style="font-weight:bold; font-size:12px; color:green;">' . $A['HORA_INICI'] . '</span></TD>
<TD class="LIST2 ' . $PAR . '"><b>' . $A['HORA_FI'] . '</b></TD>';
echo ' <TD class="LIST2 ' . $PAR . '"><span style="font-weight:bold; font-size:12px; color:#800000;">' . $ESP . '</span></TD>';
echo ' <TD class="LIST2 ' . $PAR . '">' . $MAT . '</TD>
<TD class="LIST2 ' . $PAR . '">' . $A['DIA'] . '</TD>
</TR>';
}
}
?>
</table>
</div>
<?php
}
public function executeGConfig(sfWebRequest $request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
$this->accio = $request->getParameter('accio', 'C');
$ROPTIONS = $request->getParameter('options', array('option_id' => '0'));
$RESPAIS = $request->getParameter('espais', array('EspaiID' => '0'));
$RMATERIAL = $request->getParameter('materialgeneric', array('idMaterialGeneric' => ''));
$RDESCOMPTE = $request->getParameter('descomptes', array('idDescompte' => '0'));
$this->FOPTIONS = OptionsPeer::initialize($ROPTIONS['option_id'], $this->IDS, false);
$this->FESPAIS = EspaisPeer::initialize($RESPAIS['EspaiID'], $this->IDS);
$this->FMATERIAL = MaterialgenericPeer::initialize($RMATERIAL['idMaterialGeneric'], $this->IDS);
$this->FENTITAT = SitesPeer::initialize($this->IDS);
//$this->FDESCOMPTE = DescomptesPeer::initialize( $RDESCOMPTE['idDescompte'] , $this->IDS );
//Agafem el codi de facebook de l'usuari
$this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU'));
$this->PARS = array();
$this->PARS = myUser::f_FbAuth(false, $this->getController()->genUrl('@fb_link', true));
//Carreguem les dades del facebook.
$this->ERROR = "";
if ($request->hasParameter('BNEWOPTION')) {
$this->accio = 'NEW_OPTION';
}
if ($request->hasParameter('BSAVEOPTION')) {
$this->accio = 'SAVE_OPTION';
}
if ($request->hasParameter('BSAVEESPAI')) {
$this->accio = 'SAVE_ESPAI';
}
if ($request->hasParameter('BDELETEESPAI')) {
$this->accio = 'DELETE_ESPAI';
}
if ($request->hasParameter('BSAVEMATERIAL')) {
$this->accio = 'SAVE_MATERIAL';
}
if ($request->hasParameter('BDELETEMATERIAL')) {
$this->accio = 'DELETE_MATERIAL';
}
if ($request->hasParameter('BSAVESITE')) {
$this->accio = 'SAVE_SITE';
}
if ($request->hasParameter('BSAVEDESCOMPTE')) {
$this->accio = 'SAVE_DESCOMPTE';
}
switch ($this->accio) {
case 'AJAX_OPCIO':
return $this->renderText(OptionsPeer::getString($request->getParameter('IDO'), $this->IDS));
break;
case 'NEW_OPTION':
$this->FOPTIONS = OptionsPeer::initialize($ROPTIONS['option_id'], $this->IDS, true);
break;
case 'SAVE_OPTION':
$this->FOPTIONS->bind($ROPTIONS);
if ($this->FOPTIONS->isValid()) {
$this->FOPTIONS->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FOPTIONS->getObject());
$this->FOPTIONS = OptionsPeer::initialize($this->FOPTIONS->getObject()->getOptionId(), $this->IDS, false);
}
break;
case 'SAVE_ESPAI':
//Si entrem un espai que és 0, llavors vol dir que fem un nou espai
if ($RESPAIS['EspaiID'] == 0) {
unset($RESPAIS['EspaiID']);
}
$this->FESPAIS->bind($RESPAIS, $request->getFiles('espais'));
if ($this->FESPAIS->isValid()) {
$this->FESPAIS->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FESPAIS->getObject());
$this->FESPAIS = EspaisPeer::initialize($this->FESPAIS->getObject()->getEspaiid(), $this->IDS);
}
//Agafem els multimèdia dels paràmetres
$AMR = $request->getParameter('multimedia');
$FMR = $request->getFiles('multimedia');
foreach ($AMR as $K => $MR) {
if ($MR['accio'] == 1 || $MR['accio'] == 0) {
//És nou o una modificació
$FM = MultimediaPeer::initialize($MR['multimedia_id'], $MR['site_id'], $MR['taula'], $MR['id_extern'], $K);
$FM->bind($MR, $FMR[$K]);
$FM->saveNewUpdate();
} elseif ($MR['accio'] == 2) {
//S'ha d'esborrar
$FM = MultimediaPeer::initialize($MR['multimedia_id'], $MR['site_id'], $MR['taula'], $MR['id_extern'], $K);
$FM->delete();
}
}
break;
case 'DELETE_ESPAI':
$this->FESPAIS->getObject()->setActiu(false)->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FESPAIS->getObject());
$this->FESPAIS = EspaisPeer::initialize(0, $this->IDS);
break;
case 'SAVE_MATERIAL':
//Si entrem un espai que és 0, llavors vol dir que fem un nou espai
if ($RMATERIAL['idMaterialGeneric'] == 0) {
unset($RMATERIAL['idMaterialGeneric']);
}
$this->FMATERIAL->bind($RMATERIAL);
if ($this->FMATERIAL->isValid()) {
$this->FMATERIAL->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FMATERIAL->getObject());
$this->FMATERIAL = MaterialgenericPeer::initialize($this->FMATERIAL->getObject()->getIdmaterialgeneric(), $this->IDS);
}
break;
case 'DELETE_MATERIAL':
$this->FMATERIAL->getObject()->setInactiu();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FMATERIAL->getObject());
$this->FMATERIAL = MaterialgenericPeer::initialize(0, $this->IDS);
break;
//Vincula l'usuari del facebook
//Vincula l'usuari del facebook
case 'FB_LINK':
$idU = $this->getUser()->getSessionPar('idU');
$OU = UsuarisPeer::retrieveByPK($idU);
$FB_ID = $this->PARS['user']['id'];
//Mirem si el número de facebook està associat a un altre usuari. Si és així, no fem res però emetem error.
$OUF = UsuarisPeer::getUserFromFacebook($FB_ID);
if ($OUF instanceof Usuaris) {
$this->ERROR = 'El compte de facebook actual està vinculat a un altre usuari. <br />Si us plau comuniqui-ho a informatica@casadecultura.org o bé entri al seu usuari de facebook i torni-ho a provar.';
} elseif ($OU instanceof Usuaris) {
$OU->setFacebookid($this->PARS['user']['id']);
$OU->save();
}
$this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU'));
break;
//Desvincula l'usuari del facebook
//Desvincula l'usuari del facebook
case 'FB_UNLINK':
$idU = $this->getUser()->getSessionPar('idU');
$OU = UsuarisPeer::retrieveByPK($idU);
$OU->setFacebookid(NULL);
$OU->save();
$this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU'));
break;
//Guardem els canvis a una entitat
//Guardem els canvis a una entitat
case 'SAVE_SITE':
$RS = $request->getParameter('sites');
$this->FENTITAT->bind($RS, $request->getFiles('sites'));
if ($this->FENTITAT->isValid()) {
$this->FENTITAT->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FENTITAT->getObject());
$this->FENTITAT = SitesPeer::initialize($this->IDS);
}
break;
case 'SAVE_DESCOMPTE':
//Si entrem un descompte que és 0, vol dir que creem un nou descompte
$this->FDESCOMPTE->bind($RDESCOMPTE);
if ($this->FDESCOMPTE->isValid()) {
$this->FDESCOMPTE->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FDESCOMPTE->getObject());
$this->FDESCOMPTE = DescomptesPeer::initialize($this->FDESCOMPTE->getObject()->getIddescompte(), $this->IDS);
}
break;
}
}
function formCercaEspais($CERCA, $IDS)
{
?>
<form action="<?php
echo url_for('gestio/gEstadistiques');
?>
" id="FESPAIS" method="POST">
<table class="FORMULARI" width="100%">
<tr><td>
<div class="TITOL">Cerca espais</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'));
?>
</div>
<?php
foreach (EspaisPeer::select($IDS, false) as $K => $V) {
echo '<div style="float:left; width:210px;">' . checkbox_tag('cerca[ESPAI][' . $K . ']', $K, isset($CERCA['ESPAI'][$K]), array()) . $V . ' (E' . $K . ')</div>';
}
?>
</div>
</td></tr>
<tr>
<td colspan="2">
<input type="submit" name="BCERCA_ESP" value="Prem per buscar" />
</td>
</tr>
</table>
</form>
<?php
}
/**
* 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(EspaisPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(EspaisPeer::DATABASE_NAME);
$criteria->add(EspaisPeer::ESPAIID, $pks, Criteria::IN);
$objs = EspaisPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* 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 = EspaisPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setEspaiid($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setNom($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setOrdre($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setSiteId($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setActiu($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setIsllogable($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setDescripcio($arr[$keys[6]]);
}
}
