public static function initialize($idH, $idA = 0, $idS)
{
$OH = HorarisPeer::retrieveByPK($idH);
if (!$OH instanceof Horaris) {
$OH = new Horaris();
$OH->setSiteId($idS);
$OH->setActiu(true);
if ($idA > 0) {
$OH->setActivitatsActivitatid($idA);
} else {
$OH->setActivitatsActivitatid(null);
}
}
return new HorarisForm($OH, array('IDS' => $idS));
}
/**
* Adds an object to the instance pool.
*
* Propel keeps cached copies of objects in an instance pool when they are retrieved
* from the database. In some cases -- especially when you override doSelect*()
* methods in your stub classes -- you may need to explicitly add objects
* to the cache in order to ensure that the same objects are always returned by doSelect*()
* and retrieveByPK*() calls.
*
* @param Horaris $value A Horaris object.
* @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
*/
public static function addInstanceToPool(Horaris $obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getHorarisid();
}
// if key === null
self::$instances[$key] = $obj;
}
}
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;
}
/**
* Declares an association between this object and a Horaris object.
*
* @param Horaris $v
* @return Horarisespais The current object (for fluent API support)
* @throws PropelException
*/
public function setHoraris(Horaris $v = null)
{
if ($v === null) {
$this->setHorarisHorarisid(NULL);
} else {
$this->setHorarisHorarisid($v->getHorarisid());
}
$this->aHoraris = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Horaris object, it will not be re-added.
if ($v !== null) {
$v->addHorarisespais($this);
}
return $this;
}
public function executeGActivitats(sfWebRequest $request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
//Netegem cerca
if ($request->getParameter('accio') == 'C') {
$this->CERCA = $this->getUser()->setSessionPar('cerca', array('text' => ''));
$this->PAGINA = $this->getUser()->setSessionPar('pagina', 1);
$this->DATAI = $this->getUser()->setSessionPar('DATAI', time());
}
$this->CERCA = $this->getUser()->ParReqSesForm($request, 'cerca', array('text' => ""));
$T = time();
$this->PAGINA = $request->getParameter('PAGINA', 1);
$this->DATAI = $this->getUser()->ParReqSesForm($request, 'DATAI', $T);
$this->DIA = $request->getParameter('DIA', time());
$this->IDA = $request->getParameter('IDA', 0);
$this->accio = $request->getParameter('accio', 'C');
$this->ACTIVITAT_NOVA = false;
//Inicialitzem el formulari de cerca
$this->FCerca = new CercaForm();
if (isset($this->CERCA['text'])) {
$this->FCerca->bind(array('text' => $this->CERCA['text']));
} else {
$this->FCerca->bind(array('text' => ''));
}
//Inicialitzem variables
$this->MODE = array();
if ($request->isMethod('POST')) {
if ($request->hasParameter('BCERCA')) {
$this->accio = 'C';
$this->PAGINA = 1;
} elseif ($request->hasParameter('BNOU')) {
$this->accio = 'ACTIVITAT';
} elseif ($request->hasParameter('BCICLE')) {
$this->accio = 'CICLE';
} elseif ($request->hasParameter('BCICLESAVE')) {
$this->accio = 'CICLE_SAVE';
} elseif ($request->hasParameter('BACTIVITAT')) {
$this->accio = 'ACTIVITAT';
} elseif ($request->hasParameter('BACTIVITATSAVE')) {
$this->accio = 'ACTIVITAT_SAVE';
} elseif ($request->hasParameter('BACTIVITATDELETE')) {
$this->accio = 'ACTIVITAT_DELETE';
} elseif ($request->hasParameter('BHORARI')) {
$this->accio = 'HORARI';
} elseif ($request->hasParameter('BHORARISAVE')) {
$this->accio = 'HORARI_SAVE';
} elseif ($request->hasParameter('BHORARIDELETE')) {
$this->accio = 'HORARI_DELETE';
} elseif ($request->hasParameter('BDESCRIPCIO')) {
$this->accio = 'DESCRIPCIO';
} elseif ($request->hasParameter('BDESCRIPCIOSAVE')) {
$this->accio = 'DESCRIPCIO_SAVE';
} elseif ($request->hasParameter('BDESCRIPCIODELETE')) {
$this->accio = 'DESCRIPCIO_DELETE';
} elseif ($request->hasParameter('BGENERANOTICIA')) {
$this->accio = 'GENERA_NOTICIA';
}
}
//Quan cliquem per primer cop a qualsevol de les cerques, la pàgina es posa a 1
if ($request->getParameter('accio') == 'C') {
$this->PAGINA = 1;
}
if ($request->getParameter('accio') == 'CD') {
$this->PAGINA = 1;
}
if ($request->hasParameter('DATAI')) {
$this->DIA = "";
}
//Aquest petit bloc és per si es modifica amb un POST el que s'ha enviat per GET
//$this->getUser()->setSessionPar('PAGINA',$this->PAGINA); //Guardem la pà gina per si hem fet una consulta nova
$this->DATAF = mktime(0, 0, 0, date('m', $this->DATAI) + 3, date('d', $this->DATAI), date('Y', $this->DATAI));
//La data final sempre és 3 mesos superior a la inicial
switch ($this->accio) {
//Consulta inicial del calendari sense prèmer cap dia, només amb un factor de cerca
case 'C':
$this->getUser()->addLogAction('inside', 'gActivitats');
$HORARIS = HorarisPeer::getActivitats(null, $this->CERCA['text'], $this->DATAI, $this->DATAF, null, $this->IDS);
if ($this->CERCA['text'] != "") {
$this->ACTIVITATS = $HORARIS['ACTIVITATS'];
} else {
$this->ACTIVITATS = array();
}
$this->CALENDARI = $HORARIS['CALENDARI'];
$this->MODE['CONSULTA'] = true;
$this->MODE['LLISTAT'] = true;
break;
break;
//Consulta que em mostra les activitats quan canvio de mensualitat o any
//Consulta que em mostra les activitats quan canvio de mensualitat o any
case 'CC':
$HORARIS = HorarisPeer::getActivitats(null, $this->CERCA['text'], $this->DATAI, $this->DATAF, null, $this->IDS);
//$this->ACTIVITATS = $HORARIS['ACTIVITATS'];
$this->ACTIVITATS = array();
$this->CALENDARI = $HORARIS['CALENDARI'];
$this->MODE['CONSULTA'] = true;
$this->MODE['LLISTAT'] = true;
break;
//Consulta que em mostra les activitats d'un dia seleccionat del calendari
//Consulta que em mostra les activitats d'un dia seleccionat del calendari
case 'CD':
$HORARIS = HorarisPeer::getActivitats($this->DIA, $this->CERCA['text'], null, null, null, $this->IDS);
$this->ACTIVITATS = $HORARIS['ACTIVITATS'];
$this->CALENDARI = $HORARIS['CALENDARI'];
$this->MODE['CONSULTA'] = true;
$this->MODE['LLISTAT'] = true;
break;
//Entrem les activitats... que necessitem
//Entrem les activitats... que necessitem
case 'ACTIVITAT':
$this->CarregaActivitats($request, $request->getParameter('form', true));
$this->MODE['ACTIVITAT_EDIT'] = true;
break;
case 'ACTIVITAT_NO_EDIT':
$this->CarregaActivitats($request, $request->getParameter('form', true));
break;
//Guardem l'activitat
//Guardem l'activitat
case 'ACTIVITAT_SAVE':
$RP = $request->getParameter('activitats');
$this->IDA = $RP['ActivitatID'];
$this->IDC = $RP['Cicles_CicleID'];
$this->FActivitat = ActivitatsPeer::initialize($this->IDA, $this->IDC, $this->IDS);
$this->FActivitat->bind($request->getParameter('activitats'));
if ($this->FActivitat->isValid()) {
$nova = $this->FActivitat->isNew();
$this->FActivitat->save();
$this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FActivitat->getObject());
$this->IDA = $this->FActivitat->getObject()->getActivitatid();
if ($nova) {
$this->redirect('gestio/gActivitats?accio=HORARI&IDA=' . $this->IDA . '&nou=' . $this->IDA);
} else {
$this->redirect('gestio/gActivitats?accio=ACTIVITAT&IDA=' . $this->IDA);
}
} else {
$this->CarregaActivitats($request, $request->getParameter('form', true));
}
break;
//Esborrem una activitat
//Esborrem una activitat
case 'ACTIVITAT_DELETE':
$RP = $request->getParameter('activitats');
$this->IDA = $RP['ActivitatID'];
$this->IDC = $RP['Cicles_CicleID'];
$this->FActivitat = ActivitatsPeer::initialize($this->IDA, $this->IDC, $this->IDS);
$OA = $this->FActivitat->getObject();
if ($OA instanceof Activitats) {
$this->getUser()->addLogAction($this->accio, 'gActivitats', $OA);
$OA->setInactiu();
$this->redirect('gestio/gActivitats?accio=CC');
}
break;
//Entrem els horaris de les activitats
//Entrem els horaris de les activitats
case 'HORARI':
$this->CarregaActivitats($request, false);
$OActivitat = ActivitatsPeer::retrieveByPK($this->IDA);
$this->HORARIS = $OActivitat->getHorarisActius($this->IDS);
$this->NOMACTIVITAT = $OActivitat->getNom();
$OHorari = new Horaris();
$OHorari->setActivitatsActivitatid($this->IDA);
if ($request->hasParameter('nou')) {
$this->FHorari = new HorarisForm($OHorari);
}
$this->HORARI = $OHorari;
$this->EXTRES = array('ESPAISOUT' => array(), 'MATERIALOUT' => array(), 'ESPAIEXTERN' => EspaisExternsPeer::initialize(null));
$this->getUser()->setSessionPar('IDH', 0);
if ($request->hasParameter('IDH')) {
$H = HorarisPeer::retrieveByPK($request->getParameter('IDH'));
$this->getUser()->setSessionPar('IDH', $request->getParameter('IDH'));
$this->FHorari = new HorarisForm($H);
$this->HORARI = $H;
$this->EXTRES['ESPAISOUT'] = $H->getArrayHorarisEspaisActiusAgrupats();
$this->EXTRES['MATERIALOUT'] = $H->getArrayHorarisEspaisMaterial();
$this->EXTRES['ESPAIEXTERN'] = $H->getEspaiExternForm();
}
$this->MODE['HORARI'] = true;
break;
case 'HORARI_SAVE':
$RP = $request->getParameter('horaris');
$this->IDA = $RP['Activitats_ActivitatID'];
$this->IDH = $RP['HorarisID'];
$OActivitat = ActivitatsPeer::retrieveByPK($this->IDA);
$this->NOMACTIVITAT = $OActivitat->getNom();
$this->HORARIS = $OActivitat->getHorarisActius($this->IDS);
$OHorari = HorarisPeer::retrieveByPK($this->IDH);
if ($this->IDH == 0) {
$this->FHorari = new HorarisForm();
} else {
$this->FHorari = new HorarisForm($OHorari);
}
//Fem un bind de les dades generals per si hi ha un error
$this->FHorari->bind($RP);
//Creem la variable EXTRES
$this->EXTRES = array('ESPAISOUT' => array(), 'MATERIALOUT' => array());
//Guardem a extres el material que volem reservar.
foreach ($request->getParameter('material', array()) as $M => $idM) {
$OM = MaterialPeer::retrieveByPK($idM);
if ($OM instanceof Material) {
$this->EXTRES['MATERIALOUT'][] = array('material' => $idM, 'generic' => $OM->getMaterialgenericIdmaterialgeneric());
}
}
//Guardem a extres els espais que volem reservar de la nostra entitat
$this->EXTRES['ESPAISOUT'] = $request->getParameter('espais', array());
//Tractem els espais externs, si n'hi ha algun.
$RPEE = $request->getParameter('espais_externs', null);
$this->EXTRES['ESPAIEXTERN'] = EspaisExternsPeer::initialize($RPEE['idEspaiextern']);
if ($RPEE['Poble'] > 0) {
$this->EXTRES['ESPAIEXTERN']->bind($RPEE);
$RET = array();
if (!$this->EXTRES['ESPAIEXTERN']->isValid()) {
$RET = array('Hi ha algun error a la localització externa.');
} else {
$this->EXTRES['ESPAIEXTERN']->save();
}
}
if (empty($RET)) {
$RET = $this->GuardaHorari($request->getParameter('horaris'), $this->EXTRES, $this->IDS, $this->MISSATGE);
}
if (empty($RET)) {
$this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FHorari->getObject());
$this->MISSATGE = array(1 => 'Horari guardat correctament');
$this->redirect('gestio/gActivitats?accio=HORARI&IDA=' . $this->IDA);
} else {
$this->MISSATGE = $RET;
}
$this->CarregaActivitats($request, false);
$this->MODE['HORARI'] = true;
break;
case 'HORARI_DELETE':
$RH = $request->getParameter('horaris');
$OH = HorarisPeer::retrieveByPK($RH['HorarisID']);
if ($OH instanceof Horaris) {
$this->getUser()->addLogAction($this->accio, 'gActivitats', $OH);
$OH->setInactiu();
}
$this->redirect('gestio/gActivitats?accio=HORARI&IDA=' . $RH['Activitats_ActivitatID']);
break;
case 'DESCRIPCIO':
$this->CarregaActivitats($request, false);
$this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA, $this->IDS);
$this->MODE['DESCRIPCIO'] = true;
break;
case 'DESCRIPCIO_SAVE':
$RP = $request->getParameter('activitats');
$this->IDA = $RP['ActivitatID'];
$this->CarregaActivitats($request, false);
$this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA, $this->IDS);
$this->FActivitat->bind($RP, $request->getFiles('activitats'));
if ($this->FActivitat->isValid()) {
$this->FActivitat->save();
$this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FActivitat->getObject());
$this->redirect('gestio/gActivitats?accio=ACTIVITAT_NO_EDIT&IDA=' . $this->IDA);
}
$THIS->MODE['DESCRIPCIO'] = true;
break;
case 'GENERA_NOTICIA':
$RP = $request->getParameter('activitats');
$this->IDA = $RP['ActivitatID'];
$ONoticia = NoticiesPeer::getNoticiaActivitat($this->IDA, $this->IDS);
$this->redirect('gestio/gNoticies?accio=E&idn=' . $ONoticia->getIdnoticia());
break;
}
}
