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');
 }
Example #2
0
 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');
 }
Example #4
0
 /**
  * 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;
 }
Example #6
0
 /**
  * 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;
 }
Example #8
0
 /**
  * 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;">
Example #11
0
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>
Example #12
0
 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;
     }
 }
Example #13
0
 /**
  * Populates the object using an array.
  *
  * This is particularly useful when populating an object from one of the
  * request arrays (e.g. $_POST).  This method goes through the column
  * names, checking to see whether a matching key exists in populated
  * array. If so the setByName() method is called for that column.
  *
  * You can specify the key type of the array by additionally passing one
  * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
  * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
  * The default key type is the column's phpname (e.g. 'AuthorId')
  *
  * @param      array  $arr     An array to populate the object from.
  * @param      string $keyType The type of keys the array uses.
  * @return     void
  */
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = 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]]);
     }
 }
Example #14
0
 /**
  * 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;
 }
Example #15
0
 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);
 }
Example #16
0
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(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;
 }