public function setup() { $this->setWidgets(array('ActivitatID' => new sfWidgetFormInputHidden(), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Cicles_CicleID' => new sfWidgetFormChoice(array('choices' => CiclesPeer::getSelect($this->getOption('IDS')))), 'TipusActivitat_idTipusActivitat' => new sfWidgetFormChoice(array('choices' => TipusactivitatPeer::getSelect($this->getOption('IDS')))), 'Estat' => new sfWidgetFormChoice(array('choices' => ActivitatsPeer::getSelectEstats())), 'Organitzador' => new sfWidgetFormInputText(), 'Responsable' => new sfWidgetFormInputText(), 'site_id' => new sfWidgetFormInputHidden(array(), array()), 'actiu' => new sfWidgetFormInputHidden(array(), array()), 'Publicable' => new sfWidgetFormInputHidden(array(), array()), 'isImportant' => new sfWidgetFormChoice(array('choices' => array(0 => 'No', 1 => 'Sí'))))); $this->setValidators(array('ActivitatID' => new sfValidatorPropelChoice(array('model' => 'Activitats', 'column' => 'ActivitatID', 'required' => false)), 'Cicles_CicleID' => new sfValidatorPropelChoice(array('model' => 'Cicles', 'column' => 'CicleID', 'required' => false)), 'TipusActivitat_idTipusActivitat' => new sfValidatorPropelChoice(array('model' => 'Tipusactivitat', 'column' => 'idTipusActivitat', 'required' => false)), 'Nom' => new sfValidatorString(array('required' => true)), 'Publicable' => new sfValidatorInteger(array('required' => false)), 'Estat' => new sfValidatorString(array('max_length' => 1, 'required' => false)), 'Organitzador' => new sfValidatorString(array('required' => false), array()), 'Responsable' => new sfValidatorString(array('required' => false), array()), 'site_id' => new sfValidatorPass(), 'actiu' => new sfValidatorPass(), 'isImportant' => new sfValidatorBoolean())); $this->widgetSchema->setLabels(array('Nom' => 'Nom de l\'activitat: ', 'Cicles_CicleID' => 'A quin cicle pertany? ', 'TipusActivitat_idTipusActivitat' => 'Quin format té? ', 'Publicable' => 'Visible al web?', 'Estat' => 'Estat actual: ', 'Organitzador' => 'Organitzador', 'Responsable' => 'Responsable', 'isImportant' => 'Avisar hospici')); $this->widgetSchema->setNameFormat('activitats[%s]'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); $this->widgetSchema->setFormFormatterName('Span'); }
public function getNumActivitats() { $C = new Criteria(); $C = CiclesPeer::getCriteriaActiu($C, $this->getSiteId()); $C = ActivitatsPeer::getCriteriaActiu($C, $this->getSiteId()); $C = HorarisPeer::getCriteriaActiu($C, $this->getSiteId()); $C->addJoin(CiclesPeer::CICLEID, ActivitatsPeer::CICLES_CICLEID); $C->addJoin(ActivitatsPeer::ACTIVITATID, HorarisPeer::ACTIVITATS_ACTIVITATID); $C->add(CiclesPeer::CICLEID, $this->getCicleid()); $C->addAscendingOrderByColumn(HorarisPeer::DIA); $C->addGroupByColumn(ActivitatsPeer::ACTIVITATID); return HorarisPeer::doCount($C); }
public function setup() { $choices = array(); $choices[''] = "No cercar cap cicle"; $choices2 = CiclesPeer::getSelect($this->getOption('IDS')); foreach ($choices2 as $K => $V) { $choices[$K] = $V; } unset($choices2); $this->setWidgets(array('idCicle' => new sfWidgetFormChoice(array('choices' => $choices)), 'DataInici' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'DataFi' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()))); $this->setValidators(array('idCicle' => new sfValidatorPass(array('required' => false)), 'DataInici' => new sfValidatorDate(array('required' => false)), 'DataFi' => new sfValidatorDate(array('required' => false)))); $this->widgetSchema->setLabels(array('idCicle' => 'Cicle: ', 'DataInici' => 'Data d\'inici: ', 'DataFi' => 'Data de fi: ')); $this->widgetSchema->setNameFormat('informe_activitats[%s]'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); $this->widgetSchema->setFormFormatterName('Span'); }
/** * Use: [ executeGCicles ] * Return: Pager * Parameters: PAGE(Page), $CERCA(Search), $IDS (IdSite) * */ public static function getList($PAGE = 1, $CERCA = "", $idS, $pager = true, $ordre_data = false) { if ($ordre_data) { $C = new Criteria(); $C = CiclesPeer::getCriteriaActiu($C, $idS); $C = ActivitatsPeer::getCriteriaActiu($C, $idS); $C = HorarisPeer::getCriteriaActiu($C, $idS); $C->addJoin(CiclesPeer::CICLEID, ActivitatsPeer::CICLES_CICLEID); $C->addJoin(ActivitatsPeer::ACTIVITATID, HorarisPeer::ACTIVITATS_ACTIVITATID); $C->addAscendingOrderByColumn(HorarisPeer::DIA); $C->add(CiclesPeer::EXTINGIT, false); $C->addGroupByColumn(CiclesPeer::CICLEID); return CiclesPeer::doSelect($C); } else { $C = new Criteria(); $C = self::getCriteriaActiu($C, $idS); if (!empty($CERCA)) { $C->add(self::NOM, '%' . $CERCA['text'] . '%', CRITERIA::LIKE); } if ($CERCA['select'] == 1) { $C->add(self::EXTINGIT, false); } else { $C->add(self::EXTINGIT, true); } $C->addAscendingOrderByColumn(self::NOM); if ($pager) { $pager = new sfPropelPager('Cicles', 100); $pager->setCriteria($C); $pager->setPage($PAGE); $pager->init(); return $pager; } else { return self::doSelect($C); } } }
/** * Carrego els cicles d'activitats amb l'ordre que a mi m'interessa. * */ private function CarregaInfoCicles() { $RET = array(); //Quinzena $avui = date('Y-m-d', time()); $avui_text = date('d/m', time()); $ultim_dia_text = date('d/m', mktime(0, 0, 0, date('m', time()), date('d', time()) + 15, date('Y', time()))); $ultim_dia = date('Y-m-d', mktime(0, 0, 0, date('m', time()), date('d', time()) + 15, date('Y', time()))); $RET[1]['mode'] = 1; $RET[1]['titol'] = "Cicles de la Casa de Cultura de Girona"; $RET[1]['elements'] = array(); $RET[2]['mode'] = 2; $RET[2]['titol'] = ""; $RET[2]['elements'] = array(); $RET[3]['mode'] = 3; $RET[3]['titol'] = ""; $RET[3]['elements'] = array(); $A_OA_PAGER = ActivitatsPeer::getActivitatsProperes($this->IDS, date('Y-m-d', time()), 1, "activitat", 50, true); $A_OC = CiclesPeer::getList(1, array('select' => 1), 1, false, true); //Mostro tots els cicles actius de la Casa que encara han de venir... foreach ($A_OC as $OC) { //Carreguem el primer horari de la primera activitat del cicle $primera_activitat = $OC->getPrimeraActivitat(); $primer_horari = ""; if ($primera_activitat instanceof Activitats) { $primer_horari = $primera_activitat->getPrimerHorari(); } //Carreguem l'últim horari de la última activitat del cicle. $ultima_activitat = $OC->getUltimaActivitat(); $ultim_horari = ""; if ($ultima_activitat instanceof Activitats) { $ultim_horari = $ultima_activitat->getUltimHorari(); } $titol = $OC->getTmig(); $desc = $OC->getDmig(); //Si el cicle té activitats, encara es pot veure, i disposa de descripció i títol, la mostrem. if ($ultim_horari != "" && $ultim_horari->getDia('Y-m-d') > $avui && !empty($titol) && !empty($desc) && $OC->getVisibleweb()) { //Mostro els cicles que hi ha $img = $this->Image_exists('cicles', 'C-' . $OC->getCicleid() . '-L') ? '/images/cicles/C-' . $OC->getCicleid() . '-L.jpg' : 'color'; $RET[1]['elements'][] = array('url' => '@web_menu_click_cicle?idCicle=' . $OC->getCicleid() . '&titol=' . $OC->getNomForUrl(), 'titol' => $titol . '<br />Del ' . $primer_horari->getDia('d/m') . ' fins al ' . $ultim_horari->getDia('d/m'), 'img' => $img); } } return $RET; }
/** * Agafem els cicles que afecten aquesta categoria i la resta d'activitats que no pertanyen a cap cicle. * * @param unknown_type $cat * @param unknown_type $mode * @param unknown_type $idC */ public static function selectCicleCategoriaActivitat($idS, $cat, $idC = 0) { $C = new Criteria(); $C = self::getCriteriaActiu($C, $idS); $C = HorarisPeer::getCriteriaActiu($C, $idS); $C = CiclesPeer::getCriteriaActiu($C, $idS); list($nom, $mode) = explode("-", $cat); $C->add(self::CATEGORIES, '%' . $nom . '%', CRITERIA::LIKE); $C->addJoin(self::ACTIVITATID, HorarisPeer::ACTIVITATS_ACTIVITATID); $C->addJoin(self::CICLES_CICLEID, CiclesPeer::CICLEID); if ($mode == 'historic') { $C->add(HorarisPeer::DIA, date('Y-m-d', time()), CRITERIA::LESS_THAN); $C->addDescendingOrderByColumn(HorarisPeer::DIA); } if ($mode == 'actual') { $C->add(HorarisPeer::DIA, date('Y-m-d', time()), CRITERIA::GREATER_EQUAL); $C->addAscendingOrderByColumn(HorarisPeer::DIA); } if ($idC > 0) { $C->add(self::CICLES_CICLEID, $idC); } $C->addGroupByColumn(CiclesPeer::CICLEID); return $C; }
/** * Selects a collection of Activitats objects pre-filled with all related objects except Tipusactivitat. * * @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 Activitats objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptTipusactivitat(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); } ActivitatsPeer::addSelectColumns($criteria); $startcol2 = ActivitatsPeer::NUM_COLUMNS - ActivitatsPeer::NUM_LAZY_LOAD_COLUMNS; CiclesPeer::addSelectColumns($criteria); $startcol3 = $startcol2 + (CiclesPeer::NUM_COLUMNS - CiclesPeer::NUM_LAZY_LOAD_COLUMNS); $criteria->addJoin(ActivitatsPeer::CICLES_CICLEID, CiclesPeer::CICLEID, $join_behavior); // symfony_behaviors behavior foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) { call_user_func($sf_hook, 'BaseActivitatsPeer', $criteria, $con); } $stmt = BasePeer::doSelect($criteria, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = ActivitatsPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = ActivitatsPeer::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 = ActivitatsPeer::getOMClass(false); $obj1 = new $cls(); $obj1->hydrate($row); ActivitatsPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Cicles rows $key2 = CiclesPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = CiclesPeer::getInstanceFromPool($key2); if (!$obj2) { $cls = CiclesPeer::getOMClass(false); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); CiclesPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (Activitats) to the collection in $obj2 (Cicles) $obj2->addActivitats($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
/** * A partir d'un cicle, carreguem la info i fem el curs * @param unknown $idCicle * @return Cursos */ public static function getCursFromCicle($idCicle) { $OC = CiclesPeer::retrieveByPK($idCicle); if ($OC instanceof Cicles) { $OCR = new Cursos(); $OCR->setTitolcurs($OC->getTmig() . "(cicle)"); $OCR->setIsactiu(true); $OCR->setPlaces(20); $OCR->setCodi('XX-' . $OC->getCicleid()); $OCR->setDescripcio($OC->getDmig()); $OCR->setPreu(0); $OCR->setHoraris("Diversos horaris"); $OCR->setCategoria(null); $OCR->setOrdresortida(1); $OCR->setDataaparicio(date('Y-m-d', time())); $di = $OC->getPrimeraActivitat()->getPrimeraData(); $df = $OC->getUltimaActivitat()->getUltimHorari()->getDia('Y-m-d'); $OCR->setDatadesaparicio($df); $OCR->setDatainmatricula(date('Y-m-d', time())); $OCR->setDatafimatricula($df); $OCR->setDatainici($di); $OCR->setVisibleweb(false); $OCR->setSiteId($OC->getSiteId()); $OCR->setActiu(true); $OCR->setActivitatId(null); $OCR->setPdf(null); $OCR->setAdescomptes(""); $OCR->setPagamentExtern(""); $OCR->setPagamentIntern(""); return $OCR; } }
/** * Aquest funció serveix per fer UPLOAD d'arxius a una activitat * */ public function executeUpload(sfWebRequest $request) { $base = getcwd(); $Opcio = $request->getParameter('OPCIO'); if ($Opcio == 'DELETE') { //Abans d'esborrar un arxiu, comprovaré que l'activitat sigui del site de l'usuari. $url = $request->getParameter('NOM_ARXIU'); $A = explode('-', $url); $id = $A[1]; $B = explode('/', $A[0]); $tipus = $B[2]; $IDS = $this->getUser()->getSessionPar('idS'); if ($tipus == 'activitats') { $OA = ActivitatsPeer::retrieveByPK($id); if ($OA instanceof Activitats && $IDS == $OA->getSiteid()) { unlink($base . $url); return $this->renderText("ok"); } } elseif ($tipus == 'cicles') { $OC = CiclesPeer::retrieveByPK($id); if ($OC instanceof Cicles && $IDS == $OC->getSiteid()) { unlink($base . $url); return $this->renderText("ok"); } } elseif ($tipus == 'cursos') { $OC = CursosPeer::retrieveByPK($id); if ($OC instanceof Cursos && $IDS == $OC->getSiteid()) { unlink($base . $url); return $this->renderText("ok"); } } return $this->renderText("ko"); } elseif ($Opcio == 'UPLOAD' || $Opcio == 'UPLOAD_SINGLE') { $nom = $request->getParameter('qqfile'); $parts = explode(".", $nom); $extensio = end($parts); if ($Opcio == 'UPLOAD') { //En aquest cas, NOM_ARXIU és el nom i directori on anirà dins de web $url = $request->getParameter('NOM_ARXIU'); $url .= '.' . $extensio; } else { //En aquest cas, NOM_ARXIU és el directori on anirà només $tmp = $request->getParameter('NOM_ARXIU'); if (!file_exists($base . '/' . $tmp)) { mkdir($base . '/' . $tmp); } $url = '/' . $tmp . $nom; } $input = fopen("php://input", "r"); $temp = tmpfile(); $realSize = stream_copy_to_stream($input, $temp); fclose($input); $target = fopen($base . $url, "w"); fseek($temp, 0, SEEK_SET); $size = stream_copy_to_stream($temp, $target); fclose($target); $result = true; if ($realSize > 0 && $size == $realSize) { $result = array('success' => true); } else { $return = array('error' => 'Hi ha hagut algun error carregant l\'arxiu.'); } return $this->renderText(htmlspecialchars(json_encode($result), ENT_NOQUOTES)); } }
include_partial('breadcumb', array('text' => $TITOL)); ?> <?php if ($LLISTAT_ACTIVITATS->getNbResults() == 0) { echo '<DIV>No s\'ha trobat cap activitat pública disponible per aquest cicle.<DIV>'; } else { $C = CiclesPeer::retrieveByPK($IDC); if ($C instanceof Cicles) { $nom_cicle = '<b>' . $C->getTMig() . '</b>'; } else { $nom_cicle = ""; } $NA = CiclesPeer::getActivitatsCicle($C->getCicleID(), $IDS); $PA = CiclesPeer::getDataPrimeraActivitat($C->getCicleID(), $IDS); $PF = CiclesPeer::getDataUltimaActivitat($C->getCicleID(), $IDS); $imatge = $C->getImatge(); $pdf = $C->getPdf(); $enllac = getRetorn('', 'Torna al llistat de cicles'); ?> <div style="clear:both;"> <div class="df titol_cicle" style="width:150px;">Activitats del cicle</div> <div class="df titol_cicle" style="color: #A73339; width:330px; padding-left:20px;"><?php echo $nom_cicle; ?> </div> </div> <div style="border:2px solid #96BF0D; clear:both; padding:10px;"> <div class="df" style="width:150px;">
use_helper('Presentation'); ?> <TD colspan="2" class="CONTINGUT"> <?php include_partial('breadcumb', array('text' => $TITOL)); ?> <?php if (empty($LLISTAT_ACTIVITATS)) { echo '<DIV>Aquest dia no hi ha cap activitat pública.<DIV>'; } foreach ($LLISTAT_ACTIVITATS as $A) { $C = CiclesPeer::retrieveByPK($A->getCiclescicleid()); if ($C instanceof Cicles && $C->getCicleID() > 1) { $nom_cicle = '<b>' . $C->getTMig() . '</b>'; $idC = $C->getCicleID(); } else { $nom_cicle = ""; $idC = 0; } $url_cicle = myUser::text2url($C->getTMig()); $imatge = $A->getImatge(); $pdf = $A->getPdf(); $pdf_cicle = $C->getPdf(); if (!empty($nom_cicle)) { ?> <div style="clear:both;"> <div class="df titol_cicle" style="width:150px;">Activitat del cicle</div>
public function LoadWEB(sfWebRequest $request) { $this->redirect('w/NotFound'); //Carrego els banners i les fotos que mostraré //Si s'entra un menú, carrego el contingut que toca segons el menú //Si el menú és només tÃtol, mostro l'estructura de directoris //Si el menú té contingut, //Si el contingut és automà tic, mostro el contingut automà tic //Si el contingut és manual, mostro el contingut manual //Si s'entra una cerca, carrego les activitats que corresponen a la cerca i marco el calendari els dies //Si s'entra un dia del calendari, cerco les activitats d'aquell dia //Si no es cap, carrego les notÃcies de les últimes activitats... $this->setLayout('layout'); $this->IDS = 1; $this->FOTOS = $this->getFotos(); $this->BANNERS = $this->getBanners(); $this->MENU = NodesPeer::retornaMenu($this->IDS); $this->USUARI = $this->getUser()->getSessionPar('idU', 0); $this->SELECCIONAT = 0; $this->LLISTAT_ACTIVITATS = array(); $this->ACTIVITATS_CALENDARI = array(); $this->MISSATGE = array(); if ($this->getUser()->isAuthenticated()) { $this->TIPUS_MENU = 'ADMIN'; } else { $this->TIPUS_MENU = 'WEB'; } $this->DATACAL = $this->getUser()->ParReqSesForm($request, 'DATACAL', time()); $this->PAGINA = $this->getUser()->ParReqSesForm($request, 'p', 1); //Gestió de menús $idN = $request->getParameter('node', 0); $this->OBERT = $this->gestionaNodes($idN); $this->accio = $request->getParameter('accio'); if ($request->hasParameter('BCERCA_x') || $request->hasParameter('CERCA') || $this->accio == 'c') { $this->CERCA = $this->getUser()->ParReqSesForm($request, 'CERCA', ""); $this->accio = 'c'; } else { $this->CERCA = ""; } //Carreguem els dies en els que hi ha alguna activitat. $this->ACTIVITATS_CALENDARI = ActivitatsPeer::getDiesAmbActivitatsMes($this->DATACAL, $this->IDS); switch ($this->accio) { //Contingut manual case 'mc': $this->NODE = NodesPeer::selectPagina($idN); $this->ACCIO = 'web'; break; //Contingut automà tic de cicles //Contingut automà tic de cicles case 'ac': $this->NODE = NodesPeer::selectPagina($idN); if (!$this->NODE->isNew()) { $cat = $this->NODE->getCategories(); $this->LLISTAT_CICLES = ActivitatsPeer::getCiclesCategoria($this->IDS, $cat); $this->ACCIO = 'llistatCiclesCategoria'; $ACT = ActivitatsPeer::selectCategories($this->IDS, true); $this->TITOL = "Cicles i activitats a \"" . $ACT[$cat] . '"'; $this->CAT = $cat; } $this->NODE = $idN; break; //Contingut automà tic d'activitats d'un cicle //Contingut automà tic d'activitats d'un cicle case 'aca': $this->CAT = $request->getParameter('cat', ''); $this->IDC = $request->getParameter('idc', 1); $this->PAGINA = $request->getParameter('p', 1); $this->NODE = $request->getParameter('NODE', 0); $OC = CiclesPeer::retrieveByPK($this->IDC); $this->TITOL = 'Llistat d\'activitats del cicle ' . $OC->getNom(); $this->LLISTAT_ACTIVITATS = ActivitatsPeer::getActivitatsCicles($this->IDC, $this->IDS, true, $this->PAGINA); $this->ACCIO = 'llistatActivitatsCicleCategoria'; break; //Consulta un cicle //Consulta un cicle case 'cc': $this->CICLE = CiclesPeer::retrieveByPK($request->getParameter('idC')); $this->ACCIO = 'mostra_cicle'; $this->TITOL = $this->CICLE->getNom(); break; //Llistat activitats de cicle //Llistat activitats de cicle case 'ccact': $this->IDC = $request->getParameter('idC'); $this->CICLE = CiclesPeer::retrieveByPK($this->IDC); $this->LLISTAT_ACTIVITATS = CiclesPeer::getActivitatsCicleList($this->IDC, $this->IDS, true); $this->ACCIO = 'mostra_activitats_cicle'; $this->TITOL = "Activitats || " . $this->CICLE->getNom(); break; //Cerca //Cerca case 'c': if ($this->CERCA == 'mensual') { $this->CERCA = ''; $this->TITOL = 'ACTIVITATS DEL MES'; } else { $this->TITOL = 'ACTIVITATS TROBADES AMB LA CERCA "' . $this->CERCA . '"'; } $this->LLISTAT_ACTIVITATS = ActivitatsPeer::getActivitatsCerca($this->CERCA, $this->DATACAL, $this->PAGINA, $this->IDS); $this->ACCIO = 'llistat_activitats_cerca'; $this->MODE = 'CERCA'; break; //Cerca un dia //Cerca un dia case 'ca': $this->LLISTAT_ACTIVITATS = ActivitatsPeer::getActivitatsDia($this->IDS, date('Y-m-d', $this->DATACAL), $this->PAGINA); $this->ACCIO = 'llistat_activitats'; $this->TITOL = 'ACTIVITATS EL DIA ' . date('d/m/Y', $this->DATACAL); $this->MODE = 'DIA'; break; //Mostra una sola activitat //Mostra una sola activitat case 'caa': $this->LLISTAT_ACTIVITATS = array(ActivitatsPeer::retrieveByPK($request->getParameter('idA'))); $this->NODE = $request->getParameter('node', 0); $this->ACCIO = 'mostra_activitat'; $this->TITOL = 'Informació de l\'activitat'; $OA = $this->LLISTAT_ACTIVITATS[0]; $this->getResponse()->addMeta('facebook', myUser::getFacebookHeaders($OA->getTmig(), sfConfig::get('sf_webdomain') . $this->getController()->genUrl('@web_activitat?idA=' . $OA->getActivitatId() . '&titol=' . $OA->getNomForUrl()), OptionsPeer::getString('SF_WEBROOT', 1) . 'images/activitats/' . $OA->getActivitatId() . '.jpg', 'Casa de Cultura de Girona', '1763108168308')); break; //Canvi data del calendari //Canvi data del calendari case 'cdc': $this->redirect('web/index?accio=c&CERCA=mensual&DATACAL=' . $this->DATACAL); break; //Mostrem notÃcies //Mostrem notÃcies default: $this->IDN = $request->getParameter('idN', 0); $this->PAGINA = $request->getParameter('p', 1); if ($this->IDN > 0) { $this->NOTICIA = NoticiesPeer::getNoticia($this->IDN, $this->IDS); $this->getResponse()->addMeta('facebook', myUser::getFacebookHeaders($this->NOTICIA->getTitolnoticia(), sfConfig::get('sf_webdomain') . $this->getController()->genUrl('@web_noticia?idN=' . $this->NOTICIA->getIdnoticia() . '&p=' . $this->PAGINA . '&titol=' . $this->NOTICIA->getNomForUrl()), OptionsPeer::getString('SF_WEBROOT', 1) . 'images/noticies/' . $this->NOTICIA->getIdnoticia() . '.jpg', 'Casa de Cultura de Girona', '1763108168308')); $this->NOTICIES = null; } else { $this->NOTICIA = null; $this->NOTICIES = NoticiesPeer::getNoticies('%', $this->PAGINA, true, FALSE, $this->IDS); } $this->ACCIO = 'noticies'; $this->getUser()->setSessionPar('NODES', array()); break; break; } }
/** * 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 = CiclesPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setCicleid($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setNom($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setImatge($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setPdf($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setTcurt($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setDcurt($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setTmig($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setDmig($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setTcomplet($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setDcomplet($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setExtingit($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setSiteId($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setActiu($arr[$keys[12]]); } }
/** * Get the associated Cicles object * * @param PropelPDO Optional Connection object. * @return Cicles The associated Cicles object. * @throws PropelException */ public function getCicles(PropelPDO $con = null) { if ($this->aCicles === null && $this->cicles_cicleid !== null) { $this->aCicles = CiclesPeer::retrieveByPk($this->cicles_cicleid); /* 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->aCicles->addActivitatss($this); */ } return $this->aCicles; }
public function executeGCicles(sfWebRequest $request) { $this->setLayout('gestio'); $this->IDS = $this->getUser()->getSessionPar('idS'); $this->IDC = $request->getParameter('IDC'); $this->MODE = ""; $this->PAGINA = $request->getParameter('PAGINA'); //Inicialitzem el formulari de cerca $this->CERCA = $this->getUser()->ParReqSesForm($request, 'cerca', array('text' => '', 'select' => 1)); $this->FCerca = new CercaTextChoiceForm(); $this->FCerca->setChoice(array(1 => 'Actiu', 0 => 'Inactiu')); $this->FCerca->bind($this->CERCA); $accio = $request->getParameter('accio'); if ($request->hasParameter('BSAVE')) { $accio = 'SAVE'; } if ($request->hasParameter('BDELETE')) { $accio = 'DELETE'; } if ($request->hasParameter('BNOU')) { $accio = 'NOU'; } switch ($accio) { case 'C': $this->CERCA = $this->getUser()->setSessionPar('cerca', array('text' => '', 'select' => 1)); $this->FCerca->bind($this->CERCA); $this->getUser()->addLogAction('inside', 'gCicles'); break; case 'NOU': $this->MODE = 'NOU'; $this->FCICLES = CiclesPeer::initialize(0, $this->IDS); break; case 'EDITA': $this->MODE = 'EDITA'; $this->FCICLES = CiclesPeer::initialize($this->IDC, $this->IDS); break; case 'LLISTA': $this->FCICLES = CiclesPeer::initialize($this->IDC, $this->IDS); $this->LACTIVITATS = ActivitatsPeer::getActivitatsCicles($this->IDC, $this->IDS, false, null, false); break; case 'SAVE': $PC = $request->getParameter('cicles'); $this->FCICLES = CiclesPeer::initialize($PC['CicleID'], $this->IDS); $this->FCICLES->bind($PC, $request->getFiles('cicles')); if ($this->FCICLES->isValid()) { $this->FCICLES->save(); $this->getUser()->addLogAction($accio, 'gCicles', $this->FCICLES->getObject()); } else { $this->MODE = 'EDITA'; } break; case 'DELETE': $PC = $request->getParameter('cicles'); $FC = CiclesPeer::initialize($PC['CicleID'], $this->IDS); $this->getUser()->addLogAction($accio, 'gCicles', $FC); $FC->getObject()->setActiu(false); $FC->getObject()->save(); break; } $this->CICLES = CiclesPeer::getList($this->PAGINA, $this->CERCA, $this->IDS); }
/** * 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(CiclesPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(CiclesPeer::DATABASE_NAME); $criteria->add(CiclesPeer::CICLEID, $pks, Criteria::IN); $objs = CiclesPeer::doSelect($criteria, $con); } return $objs; }