public static function getMailEnt($OER)
{
$idS = $OER->getSiteId();
$Nom = $OER->getNomUsuari();
$Activitat = $OER->getNomActivitat();
$OH = $OER->getHoraris();
$OS = SitesPeer::retrieveByPK($OER->getSiteId());
if (!$OS instanceof Sites) {
$OS = new Sites();
}
$TEXT = OptionsPeer::getString('BODY_MAIL_ENTRADES', $idS);
$TEXT = str_replace('{{NOM}}', $OER->getNomUsuari(), $TEXT);
$TEXT = str_replace('{{NUM_ENTRADES}}', $OER->getQuantitat(), $TEXT);
$TEXT = str_replace('{{ACTIVITAT}}', $OER->getNomActivitat(), $TEXT);
$TEXT = str_replace('{{ENTITAT}}', $OS->getNom(), $TEXT);
$TEXT = str_replace('{{TEL_ENTITAT}}', $OS->getTelefon(), $TEXT);
$TEXT = str_replace('{{MAIL_ENTITAT}}', $OS->getEmail(), $TEXT);
$TEXT = str_replace('{{TEL_ADMIN}}', '972.20.20.13', $TEXT);
$TEXT = str_replace('{{MAIL_ADMIN}}', OptionsPeer::getString('MAIL_ADMIN', $idS), $TEXT);
$TEXT = str_replace('{{DIA}}', $OH->getDia('d/m/Y'), $TEXT);
$TEXT = str_replace('{{HORA}}', $OH->getHorainici('H:i'), $TEXT);
$TEXT = str_replace('{{ESPAI}}', implode(',', Horaris::getArrayEspais()), $TEXT);
$TEXT = str_replace('{{CODI}}', sha1($OER->getIdentrada()), $TEXT);
return $TEXT;
}
public function setup()
{
$this->setWidgets(array('site_id_my' => new sfWidgetFormChoice(array('choices' => SitesPeer::getSelectUser($this->getOption('idU')))), 'site_id' => new sfWidgetFormChoice(array('choices' => SitesPeer::getSelect(false)))));
$this->setValidators(array('site_id' => new sfValidatorChoice(array('choices' => array($this->getObject()->getSiteId()), 'empty_value' => $this->getObject()->getSiteId(), 'required' => false)), 'site_id_my' => new sfValidatorChoice(array('choices' => array($this->getObject()->getSiteId()), 'empty_value' => $this->getObject()->getSiteId(), 'required' => false))));
$this->widgetSchema->setNameFormat('sites[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
$this->widgetSchema->setLabels(array('site_id' => "Totes les entitats: ", 'site_id_my' => 'Entitats on he participat: '));
}
public function getSiteName()
{
$OS = SitesPeer::retrieveByPK($this->getSiteId());
if ($OS instanceof Sites) {
return $OS->getNom();
} else {
return 'n/d';
}
}
public function configure()
{
$this->setWidgets(array('site' => new sfWidgetFormChoice(array('choices' => SitesPeer::getSelect(false, true))), 'nick' => new sfWidgetFormInputText(array(), array('style' => 'width:100px;')), 'password' => new sfWidgetFormInputPassword(array(), array('style' => 'width:100px;'))));
$this->setValidator('password', new sfValidatorString(array('required' => false)));
$this->setValidator('nick', new sfValidatorString(array('required' => false)));
$this->setValidator('site', new sfValidatorString(array('required' => true)));
$this->widgetSchema->setlabels(array('nick' => 'DNI: ', 'password' => 'CONTRASENYA: '));
$this->widgetSchema->setNameFormat('login[%s]');
}
public function setup()
{
$BASE = OptionsPeer::getString('SF_WEBROOT', $this->getOption('IDS'));
$this->setWidget('IDS', new sfWidgetFormChoice(array('choices' => SitesPeer::getSelect(false, false)), array('style' => 'width:400px')));
$this->setValidator('IDS', new sfValidatorPass(array(), array()));
$this->widgetSchema->setNameFormat('super_admin_menus[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
$this->setWidgetUsers();
}
public function getSiteNom()
{
$idS = $this->getSiteId();
$OS = SitesPeer::retrieveByPK($idS);
$Nom = 'n/d';
if ($OS instanceof Sites) {
$Nom = $OS->getNom();
}
return $Nom;
}
public static function getEntitatsHospici($CER)
{
$C = new Criteria();
$C = self::CriteriaCercaFormularisHospici($CER, $C);
$C->add(SitesPeer::ACTIU, true);
$C->addJoin(self::SITE_ID, SitesPeer::SITE_ID);
$RET = array();
$SOL = array();
$RET[0] = array('NOM' => "Totes les entitats...", 'COUNT' => 0);
foreach (SitesPeer::doSelect($C) as $OS) {
if (!isset($RET[$OS->getSiteId()])) {
$RET[$OS->getSiteId()] = array('NOM' => $OS->getNom(), 'COUNT' => 0);
}
$RET[$OS->getSiteId()]['COUNT'] += 1;
$RET[0]['COUNT'] += 1;
}
foreach ($RET as $K => $V) {
$SOL[$K] = $V['NOM'] . " ({$V['COUNT']})";
}
return $SOL;
}
</thead>
<tbody>
<?php
if (sizeof($LLISTAT_ESPAIS) == 0) {
?>
<tr>
<td colspan="3">No hem trobat cap resultat amb les dades marcades.</td>
</tr>
<?php
} else {
//Agafem el llistat d'activitats
$LESP = $LLISTAT_ESPAIS;
foreach ($LESP as $OE) {
$url = url_for('@hospici_espai_detall?idE=' . $OE->getEspaiid() . '&titol=' . $OE->getNomForUrl());
$POBLACIO = SitesPeer::getPoblacioSite($OE->getSiteid());
$NOM = '<a id="link" style="font-size:14px;" href="' . $url . '">' . $OE->getNom() . ' </a><span style="font-size:10px; color:gray;"></span>';
$ESTAT = myUser::ph_getEtiquetaReservaEspais($AUTH, $url);
$FOTOS = "";
foreach ($OE->getFotos() as $OM) {
$FOTOS .= '<a class="lightbox" href="/images/multimedia/' . $OM->getLargeImage() . '">';
$FOTOS .= '<img src="/images/multimedia/' . $OM->getUrl() . '" height="30" alt="" />';
$FOTOS .= '</a>';
}
?>
<tr>
<td style="vertical-align: top;"><?php
echo $NOM;
?>
<div class="BREADCUMB" style="width:700px; margin-left:20px; margin-right:20px; border-color:black; background-color: #DDDDDD; color:#656565; text-align:center; padding:5px 0px;"> <b><?php echo SitesPeer::getNom($IDS); ?> </b> </div>
/**
* Funció que retorna la població vinculada amb el SITE
* */
public static function getPoblacioSite($idS)
{
$C = new Criteria();
$OS = SitesPeer::retrieveByPK($idS);
if ($OS instanceof Sites) {
return $OS->getPobleString();
} else {
return "n/d";
}
}
/**
* Mostra les etiquetes amb els estats i accions dels cursos
* @param $AUTEN Si l'usuari està autentificat o no
* @param $OC Objecte Cursos
* @param $url On s'ha d'anar si es clica l'enllaç
* @return String
* */
public static function ph_getEtiquetaFormulari($AUTH, $OF, $idU)
{
$AUTEN = isset($AUTH) && $AUTH > 0;
$isPle = $OF->isOmplert($idU);
$url = url_for('@hospici_formularis_detall?idF=' . $OF->getIdformularis() . '&titol=' . $OF->getNomForUrl());
$idS = $OF->getSiteId();
$OS = SitesPeer::retrieveByPK($idS);
$nom = $OS->getNom();
$email = $OS->getEmailString();
$tel = $OS->getTelefonString();
$RET = "";
//Si no està autentificat
if (!$AUTEN) {
$RET = ph_getRoundCorner('<a class="auth" href="' . $url . '">Autentifica\'t i omple\'l</a>', '#FFCC00');
//Ja està autentificat
} else {
//Ja ha omplert el formulari
if ($isPle) {
$RET = ' <div class="tip" title="Vostè ja ha omplert aquest formulari correctament.<br /><br /> Per a més informació ha de posar-se en contacte amb <b>' . $nom . '</b> enviant un correu electrònic a <b>' . $email . '</b> o bé trucant al <b>' . $tel . '</b>">';
$RET .= ph_getRoundCorner('<a class="link_compra" href="' . $url . '">Formulari omplert</a>', '#29A729') . '</div>';
//Encara no l'ha omplert
} else {
$RET = ph_getRoundCorner('<a href="' . $url . '">Omple el formulari</a>', '#FF8D00');
}
}
return $RET;
}
public static function MailMatricula($OM, $idS)
{
$Nom = $OM->getUsuaris()->getNomComplet();
$NomCurs = $OM->getCursos()->getCodi() . ' | ' . $OM->getCursos()->getTitolcurs();
$dataInici = $OM->getCursos()->getDatainici('d-m-Y');
$OS = SitesPeer::retrieveByPK($OM->getSiteId());
$TEXT = OptionsPeer::getString('BODY_MAIL_MATRICULA', $idS);
$TEXT = str_replace('{{NOM}}', $Nom, $TEXT);
$TEXT = str_replace('{{CURS}}', $NomCurs, $TEXT);
$TEXT = str_replace('{{ENTITAT}}', $OS->getNom(), $TEXT);
$TEXT = str_replace('{{TEL_ENTITAT}}', $OS->getTelefon(), $TEXT);
$TEXT = str_replace('{{MAIL_ENTITAT}}', $OS->getEmail(), $TEXT);
$TEXT = str_replace('{{TEL_ADMIN}}', '972.20.20.13', $TEXT);
$TEXT = str_replace('{{MAIL_ADMIN}}', OptionsPeer::getString('MAIL_ADMIN', $idS), $TEXT);
$TEXT = str_replace('{{DIA_CLASSE}}', $dataInici, $TEXT);
return $TEXT;
}
public function executeGConfigSuperAdmin(sfWebRequest $request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
$this->accio = $request->getParameter('accio', 'C');
$RSITES = $request->getParameter('sites', array('site_id' => 1));
$this->FSITES = SitesPeer::initialize($RSITES['site_id']);
$this->SITE = $request->getParameter('SITE', '');
if ($request->hasParameter('BSAVESITE')) {
$this->accio = 'SAVE_SITE';
}
if ($request->hasParameter('BDELETESITE')) {
$this->accio = 'DELETE_SITE';
}
if ($request->hasParameter('BSAVEUSERSITE')) {
$this->accio = 'SAVE_USER_SITE';
}
if ($request->hasParameter('BDELETEUSERSITE')) {
$this->accio = 'DELETE_USER_SITE';
}
if ($request->hasParameter('BSEARCHUSERSITES')) {
$this->accio = 'SEARCH_USER_SITES';
}
if ($request->hasParameter('BSAVEUSERMENU')) {
$this->accio = 'SAVE_USER_MENU';
}
switch ($this->accio) {
case 'SAVE_SITE':
$this->FSITES->bind($RSITES);
if ($this->FSITES->isValid()) {
$this->FSITES->save();
$this->getUser()->addLogAction($this->accio, 'gConfigSuperAdmin', $this->FSITES->getObject());
$this->FSITES = SitesPeer::initialize($this->FSITES->getObject()->getSiteId());
}
break;
case 'DELETE_SITE':
$this->FSITES->getObject()->setActiu(false)->save();
$this->getUser()->addLogAction($this->accio, 'gConfigSuperAdmin', $this->FSITES->getObject());
$this->FESPAIS = SitesPeer::initialize(0, $this->IDS);
break;
case 'SAVE_USER_SITE':
$RP = $request->getParameter('dades');
foreach ($RP as $RS) {
if ($RS['IDU'] > 0 && $RS['IDN'] > 0 && $this->SITE > 0) {
$OUS = UsuarisSitesPeer::initialize($RS['IDU'], $this->SITE, false)->getObject();
$OUS->setNivellId($RS['IDN']);
$OUS->setActiu(true);
$OUS->save();
}
}
$this->LUSERSITES = UsuarisSitesPeer::getSitesUsers($this->SITE, true);
break;
case 'DELETE_USER_SITE':
$USUARI = $request->getParameter('USUARI');
$SITE = $request->getParameter('SITE');
$OUS = UsuarisSitesPeer::initialize($USUARI, $SITE)->getObject();
if (!$OUS->isNew()) {
$OUS->setActiu(false);
$OUS->save();
$this->LUSERSITES = UsuarisSitesPeer::getUserSites($this->SITE);
}
break;
case 'SAVE_USER_MENU':
$IDS = $request->getParameter('MENU_SITES');
$IDU = $request->getParameter('MENU_USUARIS');
$LMENUS = $request->getParameter('MENU_DISPONIBLES');
if (!empty($LMENUS)) {
UsuarisMenusPeer::doUpdateMy($IDU[0], $IDS[0], $LMENUS);
}
break;
case 'SEARCH_USER_SITES':
$IDS = $this->FMENUUSUARI->getValue('IDS');
$IDU = $this->FMENUUSUARI->getValue('IDU');
if (!empty($IDS)) {
$this->FMENUUSUARI->setWidgetUsers();
if (!empty($IDU)) {
$this->LMENUSUSUARI = GestioMenusPeer::getMenusUsuariArray($IDU, $IDS);
}
}
break;
default:
break;
}
//Cerquem per SITE, que és més fàcil
//Mirem quins usuaris hi ha a un SITE relacionats com a adminstradors
//Mirem quins menús tenen els usuaris d'un SITE en general (els menús del primer usuari)
$OS = SitesPeer::retrieveByPK($this->SITE);
if ($OS instanceof Sites) {
$this->LUSERSITES = UsuarisSitesPeer::getSitesUsers($this->SITE, true);
$this->LMENUSUSUARI = GestioMenusPeer::getMenusUsuariArray($this->USUARI, $this->SITE);
} else {
$this->USUARI = 0;
$this->LUSERSITES = array();
$this->LMENUSUSUARI = array();
}
$this->FMENUUSUARI = new ConfigSuperAdminMenusForm(null, array('IDS' => $this->IDS));
$this->FMENUUSUARI->bind($request->getParameter('super_admin_menus'));
}
<tr>
<th>Quan</th>
<th>Hora</th>
<th>Titol</th>
<th>On</th>
<th>Entrades</th>
<th>Estat</th>
</tr>
<?php
if (empty($LEntrades)) {
echo '<tr><td colspan="4">No s\'ha trobat cap entrada comprada.</td></tr>';
} else {
foreach ($LEntrades as $OER) {
$OH = $OER->getHorari();
$OA = $OH->getActivitatss();
$OS = SitesPeer::retrieveByPK($OA->getSiteId());
$class = "";
if ($OER->getEstat() == EntradesReservaPeer::ANULADA) {
$class = "class=\"tatxat\"";
}
echo "<tr>\r\n <td {$class}>{$OH->getDia('Y-m-d')}</td>\r\n <td {$class}>{$OH->getHorainici('H:m')}</td>\r\n <td {$class}>{$OA->getTmig()}</td>\r\n <td {$class}>{$OS->getNom()}</td>\r\n <td {$class}>{$OER->getQuantes()}</td>\r\n <td {$class}>{$OER->getEstatString()}</td>";
if ($OER->getEstat() != EntradesReservaPeer::ANULADA) {
echo "<td><a href=\"" . url_for('@hospici_anula_entrada?idER=' . $OER->getEntradesReservaId()) . "\">Anul·lar</a></td>";
}
echo "</tr>";
}
}
?>
</table>
/**
* A partir d'un usuari trobem els sites als que està relacionat.
* @param $idU Usuari ID
* @param $all Mostra tots els Sites, també els que no setan relacionats.
* @return UsuarisSitesForm()
* */
public static function getSites($idU, $all = false)
{
$RET = array();
$C = new Criteria();
$C = self::getCriteriaActiu($C);
if (!$all) {
$C->addJoin(SitesPeer::SITE_ID, self::SITE_ID);
$C = SitesPeer::getCriteriaActiu($C);
}
foreach (SitesPeer::doSelect($C) as $OS) {
$RET[$OS->getSiteId()] = $OS->getNom();
}
return $RET;
}
if ($G) {
echo '<b>' . $OM->getUsuaris()->getNom() . ' ' . $OM->getUsuaris()->getCog1() . '</b> de ' . $OM->getSiteNom();
} else {
echo $OM->getUsuaris()->getNom() . ' ' . $OM->getUsuaris()->getCog1();
}
?>
</div>
</div>
<!-- Publiquem les respostes associades -->
<?php
foreach ($M['RESPOSTES'] as $OR) {
$OU = UsuarisPeer::retrieveByPK($OR->getIdusuari());
$NOM_SITE = SitesPeer::getNom($OR->getIdsite());
?>
<div style="float:left; width:500px;">
<div style="padding-bottom:5px; margin-left:10px; font-size:10px; color:#999">
<?php
if ($G) {
echo '<img width="10px" src="/images/template/arrow_redo.png" /><b>' . $OU->getNom() . ' ' . $OU->getCog1() . '</b> de ' . $NOM_SITE;
} else {
echo '<img width="10px" src="/images/template/arrow_redo.png" /><b>' . $OU->getNom() . ' ' . $OU->getCog1() . '</b>';
}
?>
<?php
echo ': ' . $OR->getText();
?>
/**
* Get the associated Sites object
*
* @param PropelPDO Optional Connection object.
* @return Sites The associated Sites object.
* @throws PropelException
*/
public function getSites(PropelPDO $con = null)
{
if ($this->aSites === null && $this->site_id !== null) {
$this->aSites = SitesPeer::retrieveByPk($this->site_id);
/* 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->aSites->addUsuarisSitess($this);
*/
}
return $this->aSites;
}
public function getNomSite()
{
return SitesPeer::getNom($this->getSiteId());
}
/**
* hospiciActions::executeEntitats()
*
* Part de mostra dels espais per reservar a l'hospici
*
* @param mixed $request
* @return void
*/
public function executeEntitats(sfWebRequest $request)
{
$this->setLayout('hospici');
$this->setTemplate('indexEntitats');
$this->accio = $request->getParameter('accio', 'index');
//Carrego la cerca
$this->CERCA = $this->getUser()->getSessionPar('cerca', array());
$this->DESPLEGABLES = array();
$this->AUTH = $this->getUser()->isAuthenticated();
//Comença la cerca *************************************************
//Agafo els paràmetres
$C = $request->getParameter('cerca', array());
$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_ENTITATS = SitesPeer::getEntitatsCercaHospici($C2);
$this->DESPLEGABLES['SELECT_POBLACIONS'] = SitesPeer::getPoblacionsCercaHospici($C2);
$this->DESPLEGABLES['SELECT_CATEGORIES'] = SitesPeer::getCategoriesCercaHospici($C2);
//Guardem a sessió la cerca "actual"
$this->CERCA = $C2;
$this->getUser()->setSessionPar('cerca', $this->CERCA);
$this->MODE = 'CERCA';
}
<div class="h_requadre_resultats">
<div class="h_subtitle_gray c1">
L'HOSPICI...
</div>
<div>
<?php
if ($ACTIVITAT instanceof Activitats) {
$i = $ACTIVITAT->getImatge();
$imatge = '/images/activitats/' . $i;
if (!($i > 0)) {
$imatge = SitesPeer::getSiteLogo($ACTIVITAT->getSiteId());
}
$pdf = $ACTIVITAT->getPdf();
?>
<div style="border:0px solid #96BF0D; clear:both; padding:10px;">
<div style="font-size:11px"><b><?php
echo $ACTIVITAT->getTMig();
?>
</b></div>
<div style="font-size:10px"><?php
echo generaHoraris($ACTIVITAT->getHorarisOrdenats(HorarisPeer::DIA));
?>
</div>
<div style="height:30px;"> </div>
<!-- Columna esquerra -->
<div style="width:150px; float:left">
public static function getEntitatCursosHospici($a_cursos)
{
$C = new Criteria();
$C->add(self::ACTIU, true);
$C->add(self::IDCURSOS, $a_cursos, CRITERIA::IN);
$C->addJoin(CursosPeer::SITE_ID, SitesPeer::SITE_ID);
$RET = array();
$SOL = array();
$RET[0] = array('NOM' => "Totes les entitats...", 'COUNT' => 0);
foreach (SitesPeer::doSelect($C) as $OS) {
if (!isset($RET[$OS->getSiteId()])) {
$RET[$OS->getSiteId()] = array('NOM' => $OS->getNom(), 'COUNT' => 0);
}
$RET[$OS->getSiteId()]['COUNT'] += 1;
$RET[0]['COUNT'] += 1;
}
foreach ($RET as $K => $V) {
$SOL[$K] = $V['NOM'] . " ({$V['COUNT']})";
}
return $SOL;
}
/**
* Menus Gestió Tab
* */
function MenusgestioTab($LMENUS = "", $FMENUUSUARI)
{
?>
<form id="FMENUS" action="<?php
echo url_for('gestio/gConfigSuperAdmin');
?>
" method="POST" enctype="multipart/form-data">
<?php
echo select_tag('MENU_SITES', options_for_select(SitesPeer::getSelect(false, false)), array('multiple' => 'multiple', 'style' => 'height:200px; width:40%;'));
?>
<?php
echo select_tag('MENU_USUARIS', null, array('multiple' => 'multiple', 'style' => 'height:200px; width:40%;'));
?>
<br /><br />
<?php
echo select_tag('MENU_DISPONIBLES', null, array('multiple' => 'multiple', 'style' => 'height:400px; width:80%'));
?>
<br /><br />
<button type="submit" name="BSAVEUSERMENU" class="BOTO_ACTIVITAT"><?php
echo image_tag('template/disk.png');
?>
Guardar i sortir</button>
</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(SitesPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(SitesPeer::DATABASE_NAME);
$criteria->add(SitesPeer::SITE_ID, $pks, Criteria::IN);
$objs = SitesPeer::doSelect($criteria, $con);
}
return $objs;
}
$cat_ant = "";
if (!$LLISTAT_ENTITATS->getNbResults()) {
echo '<div>';
echo '<div class="h_llistat_activitat_titol">No hem trobat cap resultat amb aquests paràmetres.</div>';
echo '</div>';
echo '<div style="margin-top:10px; clear:both;"></div>';
} else {
foreach ($LLISTAT_ENTITATS->getResults() as $OE) {
echo '<div style="margin-top:10px; margin-bottom:10px;">';
$url = $OE->getWebUrl();
if (empty($url)) {
$url = "";
} else {
$url = ' | <a style=" font-size:12px;" href="' . url_for($url, true) . '">WEB</a>';
}
$logo = SitesPeer::getSiteLogo($OE->getSiteId());
echo ' <div class="h_llistat_acivitat_titol">
<div style="float:left">
<img src="' . $logo . '" height="30" alt="" />
</div>
<div style="float:left; font-size:16px; padding-left:10px;">
' . $OE->getNom() . '<br />
<div style="font-size:12px; color:gray;">
<a href="' . url_for('@hospici_cercador_entitats_activitats?SITE=' . $OE->getSiteId()) . '">Activitats</a> |
<a href="' . url_for('@hospici_cercador_entitats_espais?SITE=' . $OE->getSiteId()) . '">Espais</a> |
<a href="' . url_for('@hospici_cercador_entitats_cursos?SITE=' . $OE->getSiteId()) . '">Cursos</a>
' . $url . '
</div>
</div>
</div>';
echo '<div style="clear:both"></div>';
/**
* Funció qeu amb un llistat d'activitats, ens mostra a quines entitats s'executen.
* @param $A_ACTIVITATS (Llistat amb ID activitats)
* @return SELECT AMB VALORS
* */
public static function getEntitatsActivitatsHospici($A_ACTIVITATS)
{
$C = new Criteria();
$C->add(self::ACTIVITATID, $A_ACTIVITATS, CRITERIA::IN);
$C->addJoin(self::SITE_ID, SitesPeer::SITE_ID);
$C->addGroupByColumn(self::ACTIVITATID);
$RET = array();
$SOL = array();
$RET[0] = array('NOM' => "Tots els pobles...", 'COUNT' => 0);
foreach (SitesPeer::doSelect($C) as $OS) {
if (!isset($RET[$OS->getSiteId()])) {
$RET[$OS->getSiteId()] = array('NOM' => $OS->getNom(), 'COUNT' => 0);
}
$RET[$OS->getSiteId()]['COUNT'] += 1;
$RET[0]['COUNT'] += 1;
}
foreach ($RET as $K => $V) {
$SOL[$K] = $V['NOM'] . " ({$V['COUNT']})";
}
return $SOL;
}
/**
* 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 = SitesPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setSiteId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setNom($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setActiu($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setPoble($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setLogourl($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setWeburl($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setTelefon($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setEmail($arr[$keys[7]]);
}
}
L'HOSPICI...
</div>
<?php
if ($CURS instanceof Cursos) {
$datai = $CURS->getDatainmatricula('U');
$url = url_for('@hospici_detall_curs?idC=' . $CURS->getIdcursos() . '&titol=' . $CURS->getNomForUrl());
$MatAntIdi = CursosPeer::IsAnticAlumne($CURS->getIdcursos(), $CURSOS_MATRICULATS);
$dataiA = mktime(0, 0, 0, 9, 12, 2011);
$OS = SitesPeer::retrieveByPK($CURS->getSiteId());
$nom = $OS->getNom();
$email = $OS->getEmailString();
$tel = $OS->getTelefonString();
$ESTAT = myUser::ph_EstatCurs($AUTH, $CURS, $url, $CURSOS_MATRICULATS);
//Carrego la imatge del site
$imatge = SitesPeer::getSiteLogo($CURS->getSiteId());
//Si l'entitat té un pdf, l'hauríem de carregar.
if (empty($pdf)) {
$pdf = 0;
}
?>
<div style="border:0px solid #96BF0D; clear:both; padding:10px;">
<div style="font-size:11px"><b><?php
echo $CURS->getTitolcurs();
?>
</b><br /><span style="color: gray;"><?php
echo $nom;
?>
</span></div>
<div style="font-size:10px"><?php
// echo generaHoraris($ACTIVITAT->getHorarisOrdenats(HorarisPeer::DIA));
function Formularis_Llista($LFormularis)
{
?>
<table class="taula_llistat">
<tr>
<th>Formulari</th>
<th>Entitat</th>
<th>Registrat</th>
</tr>
<?php
if (empty($LFormularis)) {
echo '<tr><td colspan="4">No s\'ha trobat cap formulari.</td></tr>';
} else {
foreach ($LFormularis as $OFR) {
$nom = SitesPeer::getNom($OFR->getSiteId());
$OF = $OFR->getFormulariss();
$OF = $OF[0];
$url = url_for('@hospici_formularis_detall?idF=' . $OF->getIdformularis() . '&titol=' . $OF->getNomForUrl());
echo '<tr>
<td><a href="' . $url . '">' . $OF->getNom() . '</a></td>
<td>' . $nom . '</td>
<td>' . $OFR->getRegistrat() . '</td>
</tr>';
}
}
?>
</table>
<?php
}
/**
* Selects a collection of UsuarisSites objects pre-filled with all related objects except Nivells.
*
* @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 UsuarisSites objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptNivells(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);
}
UsuarisSitesPeer::addSelectColumns($criteria);
$startcol2 = UsuarisSitesPeer::NUM_COLUMNS - UsuarisSitesPeer::NUM_LAZY_LOAD_COLUMNS;
UsuarisPeer::addSelectColumns($criteria);
$startcol3 = $startcol2 + (UsuarisPeer::NUM_COLUMNS - UsuarisPeer::NUM_LAZY_LOAD_COLUMNS);
SitesPeer::addSelectColumns($criteria);
$startcol4 = $startcol3 + (SitesPeer::NUM_COLUMNS - SitesPeer::NUM_LAZY_LOAD_COLUMNS);
$criteria->addJoin(UsuarisSitesPeer::USUARI_ID, UsuarisPeer::USUARIID, $join_behavior);
$criteria->addJoin(UsuarisSitesPeer::SITE_ID, SitesPeer::SITE_ID, $join_behavior);
// symfony_behaviors behavior
foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
call_user_func($sf_hook, 'BaseUsuarisSitesPeer', $criteria, $con);
}
$stmt = BasePeer::doSelect($criteria, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = UsuarisSitesPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = UsuarisSitesPeer::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 = UsuarisSitesPeer::getOMClass(false);
$obj1 = new $cls();
$obj1->hydrate($row);
UsuarisSitesPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined Usuaris rows
$key2 = UsuarisPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = UsuarisPeer::getInstanceFromPool($key2);
if (!$obj2) {
$cls = UsuarisPeer::getOMClass(false);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
UsuarisPeer::addInstanceToPool($obj2, $key2);
}
// if $obj2 already loaded
// Add the $obj1 (UsuarisSites) to the collection in $obj2 (Usuaris)
$obj2->addUsuarisSites($obj1);
}
// if joined row is not null
// Add objects for joined Sites rows
$key3 = SitesPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = SitesPeer::getInstanceFromPool($key3);
if (!$obj3) {
$cls = SitesPeer::getOMClass(false);
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
SitesPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (UsuarisSites) to the collection in $obj3 (Sites)
$obj3->addUsuarisSites($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
/**
* RSS que mostra les activitats que vindran en 7 dies.
*
* */
public function executeGetActXML(sfWebRequest $request)
{
//Entrem el SiteID del que volem recuperar l'xml i el carreguem.
$IDS = $request->getParameter('IDS', 0);
$OS = SitesPeer::retrieveByPK($IDS);
//Si existeix el site que demanem, seguim.
if ($OS instanceof Sites) {
$this->setLayout(null);
$this->setTemplate(null);
$LOH = ActivitatsPeer::getActivitatsProperes($IDS, date('Y-m-d', time()), 1, 'horari', 50, true);
//Creem l'objecte XML
$i = 1;
$document = "<document>";
foreach ($LOH as $OH) {
$OA = $OH->getActivitats();
$LE = $OH->getArrayEspais();
$document .= "<caixa>";
$document .= " <id_activitat>" . $OA->getActivitatid() . "</id_activitat>";
$document .= " <data_inicial>" . $OH->getDia('Y-m-d') . "</data_inicial>";
$document .= " <data_fi>" . $OH->getDia('Y-m-d') . "</data_fi>";
$document .= " <tipus_activitat>" . $OA->getNomTipusActivitat() . "</tipus_activitat>";
$document .= " <cicle>" . $OA->getCicles()->getTmig() . "</cicle>";
$document .= " <tipologia>" . $OA->getCategories() . "</tipologia>";
$document .= " <importancia>" . $OA->getImportancia() . "</importancia>";
$document .= " <titol>" . $OA->getTmig() . "</titol>";
$document .= " <text>" . htmlspecialchars($OA->getDmig()) . "</text>";
$document .= " <url>" . $this->getController()->genUrl('http://www.hospici.cat/detall_activitat/' . $OA->getActivitatid() . '/' . $OA->getNomForUrl(), true) . "</url>";
$document .= " <hora_inici>" . $OH->getHorainici("H.i") . "</hora_inici>";
$document .= " <hora_fi>" . $OH->getHorafi("H.i") . "</hora_fi>";
$document .= " <espais>" . implode(",", $LE) . "</espais>";
$document .= " <organitzador>" . htmlspecialchars($OA->getOrganitzador()) . "</organitzador>";
$document .= " <info_practica>" . htmlspecialchars($OA->getInfopractica()) . "</info_practica>";
$document .= " <poblacio>" . $OS->getPobleString() . "</poblacio>";
$document .= " <url_img_s>http://www.hospici.cat/images/activitats/A-" . $OA->getActivitatid() . "-M.jpg</url_img_s>";
$document .= " <url_img_m>http://www.hospici.cat/images/activitats/A-" . $OA->getActivitatid() . "-L.jpg</url_img_m>";
$document .= " <url_img_l>http://www.hospici.cat/images/activitats/A-" . $OA->getActivitatid() . "-XL.jpg</url_img_l>";
$document .= "</caixa>";
}
$document .= "</document>";
$response = sfContext::getInstance()->getResponse();
$response->setHttpHeader('Content-type', 'text/xml');
$response->setContent($document);
$response->sendHttpHeaders();
}
return sfView::NONE;
}
