public function setup() { $this->setWidgets(array('idMaterialGeneric' => new sfWidgetFormChoice(array('choices' => MaterialgenericPeer::select($this->getOption('IDS'), true))), 'Nom' => new sfWidgetFormInputText(), 'site_id' => new sfWidgetFormInputHidden(), 'actiu' => new sfWidgetFormInputHidden())); $this->setValidators(array('idMaterialGeneric' => new sfValidatorChoice(array('choices' => array($this->getObject()->getIdmaterialgeneric()), 'empty_value' => $this->getObject()->getIdmaterialgeneric(), 'required' => false)), 'Nom' => new sfValidatorString(array('required' => false)), 'site_id' => new sfValidatorInteger(array('min' => -128, 'max' => 127, 'required' => false)), 'actiu' => new sfValidatorInteger(array('min' => -128, 'max' => 127)))); $this->widgetSchema->setLabels(array('idMaterialGeneric' => 'Material: ', 'Nom' => 'Nom: ')); $this->widgetSchema->setNameFormat('materialgeneric[%s]'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); }
public function setup() { $SN = array(true => 'SÃ', false => 'No'); $this->setWidgets(array('ReservaEspaiID' => new sfWidgetFormInputHidden(), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'DataActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'HorariActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'EspaisSolicitats' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => EspaisPeer::selectFormReserva($this->getOption('IDS')), 'multiple' => true, 'expanded' => true), array('class' => 'ul_espais')), 'MaterialSolicitat' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => MaterialgenericPeer::selectFormulariUsuaris($this->getOption('IDS')), 'multiple' => true, 'expanded' => true), array('class' => 'ul_material')), 'TipusActe' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'Representacio' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'Responsable' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'Organitzadors' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'PersonalAutoritzat' => new sfWidgetFormInputText(array(), array('style' => 'width:450px')), 'PrevisioAssistents' => new sfWidgetFormChoice(array('choices' => $this->AssistentsArray()), array()), 'isEnregistrable' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'EsCicle' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'Comentaris' => new sfWidgetFormTextarea(array(), array('style' => 'width:450px')), 'Estat' => new sfWidgetFormInputHidden(), 'DataAlta' => new sfWidgetFormInputHidden(), 'Condicions' => new sfWidgetFormChoice(array('choices' => array(0 => 'No', 1 => 'SÃ'))), 'CondicionsCCG' => new sfWidgetFormTextareaTinyMCE(array(), array('style' => 'width:400px; height:200px;', 'disabled' => 'disabled')), 'DataAcceptacioCondicions' => new sfWidgetFormInputHidden(), 'ObservacionsCondicions' => new sfWidgetFormTextarea(array(), array('style' => 'width:450px')))); $this->setValidators(array('ReservaEspaiID' => new sfValidatorPropelChoice(array('model' => 'Reservaespais', 'column' => 'ReservaEspaiID', 'required' => false)), 'Representacio' => new sfValidatorString(array('required' => true)), 'Responsable' => new sfValidatorString(array('required' => true)), 'PersonalAutoritzat' => new sfValidatorString(array('required' => true)), 'PrevisioAssistents' => new sfValidatorInteger(array('required' => true)), 'EsCicle' => new sfValidatorBoolean(array('required' => true)), 'Comentaris' => new sfValidatorString(array('required' => false)), 'Estat' => new sfValidatorString(array('max_length' => 1, 'required' => false)), 'Organitzadors' => new sfValidatorString(array('required' => true)), 'DataActivitat' => new sfValidatorString(array('required' => true)), 'HorariActivitat' => new sfValidatorString(array('required' => true)), 'TipusActe' => new sfValidatorString(array('required' => true)), 'Nom' => new sfValidatorString(array('required' => true)), 'isEnregistrable' => new sfValidatorBoolean(array('required' => true)), 'DataAlta' => new sfValidatorDateTime(array('required' => false)), 'EspaisSolicitats' => new sfValidatorString(array('required' => true)), 'MaterialSolicitat' => new sfValidatorString(array('required' => false)), 'Condicions' => new sfValidatorBoolean(array('required' => false)), 'CondicionsCCG' => new sfValidatorPass(), 'DataAcceptacioCondicions' => new sfValidatorPass(), 'ObservacionsCondicions' => new sfValidatorString(array('required' => false)))); $this->widgetSchema->setLabels(array('Nom' => "Nom de l'activitat ", 'DataActivitat' => "Proposta de data ", 'HorariActivitat' => "Proposta d'hores ", 'Espais' => 'Espais (<a class="blue" href="' . sfConfig::get('sf_webroot') . 'intranet_dev.php/web/espais" target="_NEW">veure\'ls</a>)', 'Material' => "Material ", 'TipusActe' => "Tipus d'acte ", 'isEnregistrable' => "És enregistrable?", 'Representacio' => "En representació de ", 'Responsable' => "Responsable ", 'Organitzadors' => "Organitzadors ", 'PersonalAutoritzat' => "Personal autoritzat ", 'PrevisioAssistents' => "Previsió d'assistents ", 'EsCicle' => "És un cicle? ", 'Comentaris' => "Comentaris ", 'EspaisSolicitats' => "Espais ", 'MaterialSolicitat' => "Material ", 'ObservacionsCondicions' => "Observacions ")); $this->widgetSchema->setNameFormat('reservaespais[%s]'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); }
public function setup() { $this->setWidgets(array('idCessioMaterial' => new sfWidgetFormInputHidden(), 'Material_idMaterial' => new sfWidgetFormChoice(array('choices' => MaterialgenericPeer::selectMaterial())), 'Cedita' => new sfWidgetFormJQueryAutocompleter(array('url' => $this->getOption('url')), array('width' => '400px')), 'Estat' => new sfWidgetFormTextarea(array(), array('style' => 'width:300px')), 'DataCessio' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'DataRetorn' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'Retornat' => new sfWidgetFormInputHidden(array(), array()), 'EstatRetornat' => new sfWidgetFormInputHidden(array(), array()), 'DataRetornat' => new sfWidgetFormInputHidden(array(), array()))); $this->setValidators(array('idCessioMaterial' => new sfValidatorPropelChoice(array('model' => 'Cessiomaterial', 'column' => 'idCessioMaterial', 'required' => false)), 'Material_idMaterial' => new sfValidatorPropelChoice(array('model' => 'Material', 'column' => 'idMaterial')), 'Cedita' => new sfValidatorString(array('required' => true)), 'DataCessio' => new sfValidatorDate(array('required' => false)), 'DataRetorn' => new sfValidatorDate(array('required' => false)), 'Estat' => new sfValidatorString(array('required' => false)), 'Retornat' => new sfValidatorBoolean(array('required' => false)), 'EstatRetornat' => new sfValidatorString(array('required' => false)), 'DataRetornat' => new sfValidatorDate(array('required' => false)))); $this->widgetSchema->setLabels(array('Material_idMaterial' => 'Material: ', 'Cedita' => 'Cedit a:', 'DataCessio' => 'Data de cessió: ', 'DataRetorn' => 'Data de retorn: ', 'Estat' => 'Observacions: ')); $this->widgetSchema->setNameFormat('cessiomaterial[%s]'); $this->widgetSchema->setFormFormatterName('Span'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); }
public function setup() { $SN = array(true => 'Sí', false => 'No'); $this->setWidgets(array('tractada' => new sfWidgetFormChoice(array('choices' => $SN)), 'Codi' => new sfWidgetFormInputText(array(), array()), 'Estat' => new sfWidgetFormChoice(array('choices' => ReservaespaisPeer::selectEstat())), 'CondicionsCCG' => new sfWidgetFormTextareaTinyMCE(), 'ReservaEspaiID' => new sfWidgetFormInputHidden(), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'DataActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'HorariActivitat' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'EspaisSolicitats' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => EspaisPeer::selectFormReserva($this->getOption('IDS')), 'multiple' => true, 'expanded' => true), array('class' => 'ul_espais')), 'MaterialSolicitat' => new sfWidgetFormChoice(array('renderer_class' => 'sfWidgetFormSelectManyMy', 'choices' => MaterialgenericPeer::selectFormulariUsuaris(), 'multiple' => true, 'expanded' => true), array('class' => 'ul_material')), 'TipusActe' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Representacio' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Responsable' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'TelefonResponsable' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'Organitzadors' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'PersonalAutoritzat' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'PrevisioAssistents' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'isEnregistrable' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'EsCicle' => new sfWidgetFormChoice(array('choices' => $SN), array()), 'Comentaris' => new sfWidgetFormTextarea(array(), array('rows' => '10', 'cols' => '50')), 'Usuaris_usuariID' => new sfWidgetFormInputHidden(), 'DataAlta' => new sfWidgetFormInputHidden(), 'DataAcceptacioCondicions' => new sfWidgetFormInputHidden(), 'ObservacionsCondicions' => new sfWidgetFormTextarea(array(), array('rows' => '10', 'cols' => '50')))); $this->setValidators(array('tractada' => new sfValidatorPass(array('required' => false), array()), 'Codi' => new sfValidatorPass(array('required' => false), array()), 'ReservaEspaiID' => new sfValidatorPropelChoice(array('model' => 'Reservaespais', 'column' => 'ReservaEspaiID', 'required' => false)), 'Representacio' => new sfValidatorString(array('required' => true)), 'Responsable' => new sfValidatorString(array('required' => true)), 'TelefonResponsable' => new sfValidatorString(array('required' => true)), 'PersonalAutoritzat' => new sfValidatorString(array('required' => true)), 'PrevisioAssistents' => new sfValidatorInteger(array('required' => true)), 'EsCicle' => new sfValidatorBoolean(array('required' => true)), 'Comentaris' => new sfValidatorString(array('required' => false)), 'Estat' => new sfValidatorString(array('max_length' => 1, 'required' => true)), 'Usuaris_usuariID' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID', 'required' => true)), 'Organitzadors' => new sfValidatorString(array('required' => true)), 'DataActivitat' => new sfValidatorString(array('required' => true)), 'HorariActivitat' => new sfValidatorString(array('required' => true)), 'TipusActe' => new sfValidatorString(array('required' => true)), 'Nom' => new sfValidatorString(array('required' => true)), 'isEnregistrable' => new sfValidatorBoolean(array('required' => true)), 'DataAlta' => new sfValidatorDateTime(array('required' => false)), 'EspaisSolicitats' => new sfValidatorString(array('required' => false)), 'MaterialSolicitat' => new sfValidatorString(array('required' => false)), 'CondicionsCCG' => new sfValidatorPass(), 'DataAcceptacioCondicions' => new sfValidatorPass(), 'ObservacionsCondicions' => new sfValidatorString(array('required' => false)))); $this->widgetSchema->setLabels(array('tractada' => 'Tractada?', 'Codi' => "Codi: ", 'Estat' => "Estat actual: ", 'Nom' => "Nom de l'activitat: ", 'DataActivitat' => "Proposta de data: ", 'HorariActivitat' => "Horari de l'activitat: ", 'Espais' => 'Espais: (<a class="blue" href="' . sfConfig::get('sf_webroot') . 'intranet_dev.php/web/espais" target="_NEW">veure\'ls</a>)', 'Material' => "Material: ", 'TipusActe' => "Tipus d'acte: ", 'isEnregistrable' => "És enregistrable?", 'Representacio' => "En representació de: ", 'Responsable' => "Responsable: ", 'TelefonResponsable' => "Telèfon del responsable: ", 'Organitzadors' => "Organitzadors: ", 'PersonalAutoritzat' => "Personal autoritzat: ", 'PrevisioAssistents' => "Previsió d'assistents: ", 'EsCicle' => "És un cicle? ", 'Comentaris' => "Comentaris: ", 'EspaisSolicitats' => 'Espais: ', 'MaterialSolicitat' => 'Material: ', 'ObservacionsCondicions' => 'Observacions ', 'CondicionsCCG' => 'Condicions ')); $this->widgetSchema->setNameFormat('reservaespais[%s]'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); $this->widgetSchema->setFormFormatterName('Span'); }
public function setup() { $Fdata = array('format' => '%day%/%month%/%year%'); $OPTIONS = array('renderer_class' => 'sfWidgetFormSelectNew', 'renderer_options' => array('url' => '#', 'text' => 'Afegir grup', 'id' => 'sel'), 'choices' => MaterialgenericPeer::select($this->getOption('IDS'), false, false)); $this->setWidgets(array('idMaterial' => new sfWidgetFormInputHidden(), 'MaterialGeneric_idMaterialGeneric' => new sfWidgetFormChoice($OPTIONS), 'Identificador' => new sfWidgetFormInputText(), 'Nom' => new sfWidgetFormInputText(), 'Ubicacio' => new sfWidgetFormInputText(), 'Responsable' => new sfWidgetFormChoice(array('choices' => UsuarisPeer::selectTreballadors($this->getOption('IDS')))), 'Disponible' => new sfWidgetFormChoice(array('choices' => array(1 => 'SÃ', 0 => 'No'))), 'Descripcio' => new sfWidgetFormTextarea(array(), array('cols' => '60', 'rows' => '10')), 'NumSerie' => new sfWidgetFormInputText(), 'DataCompra' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'DataGarantia' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'DataRevisio' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'Cedit' => new sfWidgetFormInputHidden(), 'DataCessio' => new sfWidgetFormInputHidden(), 'DataRetorn' => new sfWidgetFormInputHidden(), 'NumFactura' => new sfWidgetFormInputText(), 'Preu' => new sfWidgetFormInputText(), 'DataBaixa' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'DataReparacio' => new sfWidgetFormInputHidden(), 'AltaRegistre' => new sfWidgetFormInputHidden(), 'NotesManteniment' => new sfWidgetFormTextarea(array(), array('cols' => '60', 'rows' => '5')), 'isTransferible' => new sfWidgetFormChoice(array('choices' => array(1 => 'SÃ', 0 => 'No'))), 'isAdministratiu' => new sfWidgetFormChoice(array('choices' => array(0 => 'No', 1 => 'SÃ'))), 'unitats' => new sfWidgetFormInput(array(), array('style' => 'width:50px')), 'site_id' => new sfWidgetFormInputHidden(array(), array()), 'actiu' => new sfWidgetFormInputHidden(array(), array()))); $this->setValidators(array('idMaterial' => new sfValidatorPropelChoice(array('model' => 'Material', 'column' => 'idMaterial', 'required' => false)), 'MaterialGeneric_idMaterialGeneric' => new sfValidatorPropelChoice(array('model' => 'Materialgeneric', 'column' => 'idMaterialGeneric')), 'Nom' => new sfValidatorString(array('required' => false)), 'Descripcio' => new sfValidatorString(array('required' => false)), 'Responsable' => new sfValidatorString(array('required' => false)), 'Ubicacio' => new sfValidatorString(array('required' => false)), 'DataCompra' => new sfValidatorDate(array('required' => false)), 'Identificador' => new sfValidatorString(array('required' => false)), 'NumSerie' => new sfValidatorString(array('required' => false)), 'DataGarantia' => new sfValidatorDate(array('required' => false)), 'DataRevisio' => new sfValidatorDate(array('required' => false)), 'Cedit' => new sfValidatorString(array('required' => false)), 'DataCessio' => new sfValidatorDate(array('required' => false)), 'DataRetorn' => new sfValidatorDate(array('required' => false)), 'NumFactura' => new sfValidatorString(array('required' => false)), 'Preu' => new sfValidatorNumber(array('required' => false)), 'NotesManteniment' => new sfValidatorString(array('required' => false)), 'DataBaixa' => new sfValidatorDate(array('required' => false)), 'DataReparacio' => new sfValidatorDate(array('required' => false)), 'Disponible' => new sfValidatorInteger(array('required' => false)), 'AltaRegistre' => new sfValidatorDate(array('required' => false)), 'isTransferible' => new sfValidatorChoice(array('choices' => array(1, 0))), 'isAdministratiu' => new sfValidatorChoice(array('choices' => array(0, 1))), 'site_id' => new sfValidatorPass(array('required' => false), array()), 'actiu' => new sfValidatorPass(array('required' => false), array()), 'unitats' => new sfValidatorInteger(array('required' => false), array()))); $this->widgetSchema->setLabels(array('MaterialGeneric_idMaterialGeneric' => 'Grup: ', 'Identificador' => 'Identificador: ', 'Nom' => 'Nom: ', 'Ubicacio' => 'Ubicació: ', 'Responsable' => 'Responsable: ', 'Disponible' => 'Disponible? ', 'Descripcio' => 'Descripció: ', 'NumSerie' => 'Núm. sèrie: ', 'DataCompra' => 'Compra: ', 'DataGarantia' => 'Fi garantia: ', 'DataRevisio' => 'Propera revisió: ', 'NumFactura' => 'Núm. factura: ', 'Preu' => 'Preu: ', 'DataBaixa' => 'Baixa: ', 'NotesManteniment' => 'Notes: ', 'isTransferible' => 'Es pot moure?', 'isAdministratiu' => 'És per oficina?', 'unitats' => 'Unitats: ')); $this->widgetSchema->setDefaults(array('Ubicacio' => 'Magatzem', 'Disponible' => 1, 'DataCompra' => date('d-m-Y', time()), 'unitats' => 1)); $this->widgetSchema->setNameFormat('material[%s]'); $this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema); $this->widgetSchema->setFormFormatterName('Span'); }
/** * Selects a collection of Material objects pre-filled with all related objects. * * @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 Material objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAll(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $criteria = clone $criteria; // Set the correct dbName if it has not been overridden if ($criteria->getDbName() == Propel::getDefaultDB()) { $criteria->setDbName(self::DATABASE_NAME); } MaterialPeer::addSelectColumns($criteria); $startcol2 = MaterialPeer::NUM_COLUMNS - MaterialPeer::NUM_LAZY_LOAD_COLUMNS; MaterialgenericPeer::addSelectColumns($criteria); $startcol3 = $startcol2 + (MaterialgenericPeer::NUM_COLUMNS - MaterialgenericPeer::NUM_LAZY_LOAD_COLUMNS); $criteria->addJoin(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, MaterialgenericPeer::IDMATERIALGENERIC, $join_behavior); // symfony_behaviors behavior foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) { call_user_func($sf_hook, 'BaseMaterialPeer', $criteria, $con); } $stmt = BasePeer::doSelect($criteria, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MaterialPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MaterialPeer::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 = MaterialPeer::getOMClass(false); $obj1 = new $cls(); $obj1->hydrate($row); MaterialPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Materialgeneric rows $key2 = MaterialgenericPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = MaterialgenericPeer::getInstanceFromPool($key2); if (!$obj2) { $cls = MaterialgenericPeer::getOMClass(false); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); MaterialgenericPeer::addInstanceToPool($obj2, $key2); } // if obj2 loaded // Add the $obj1 (Material) to the collection in $obj2 (Materialgeneric) $obj2->addMaterial($obj1); } // if joined row not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
function formEditaHoraris($IDA, $FHorari, $MISSATGE, $EXTRES, $IDS) { ?> <form action="<?php echo url_for('gestio/gActivitats'); ?> " method="POST"> <?php if (isset($MISSATGE)) { ?> <div style="padding:20px; margin-left:20px; border:10px solid red; width:650px; background-color: black; color:yellow; font-weight:bold;"><?php echo '<ul>'; if (!isset($MISSATGE)) { $MISSATGE = array(); } foreach ($MISSATGE as $M) { echo '<li>' . $M . '</li>'; } echo '</ul>'; ?> </div> <?php } ?> <div class="REQUADRE"> <div class="OPCIO_FINESTRA"><?php echo link_to(image_tag('icons/Grey/PNG/action_delete.png'), 'gestio/gActivitats?accio=HORARI&IDA=' . $IDA . '&form=0'); ?> </div> <div class="TITOL">Edició horaris</div> <div class="FORMULARI"> <?php echo $FHorari; ?> <div class="clear row fb"> <span class="title row_title fb"><b>Espais: </b></span> <span class="row_field fb"> <?php $id = 1; $VAL = ""; foreach ($EXTRES['ESPAISOUT'] as $idE => $nom) { if (!empty($idE)) { $VAL .= '<span id="rowE[' . $id . ']"> <select name="espais[' . $id . ']" id="espais[' . $id . ']">' . EspaisPeer::selectJavascript($IDS, $idE) . '</select> <input type="button" style="width:30px;" onClick="esborraLiniaE(' . $id . ');" id="mesespais" value="-"></input> <br /> </span> '; $id++; } } echo '<input type="button" id="mesespais" style="width:30px;" value="+"></input><br />'; echo '<input type="hidden" id="idE" value="' . $id . '"></input>'; echo '<div id="divTxtE">' . $VAL . '</div>'; ?> </span> </div> <div class="clear row fb"> <span class="title row_title fb"><b>Material: </b></span> <span class="row_field fb"> <?php $id = 1; $VAL = ""; foreach ($EXTRES['MATERIALOUT'] as $M => $idM) { $VAL .= ' <span id="row[' . $id . ']"> <select onChange="ajax(this,' . $id . ')" name="generic[' . $id . ']"> id="generic[' . $id . ']">' . options_for_select(MaterialgenericPeer::select($IDS), $idM['generic']) . '</select> <select name="material[' . $id . ']" id="material[' . $id . ']">' . options_for_select(MaterialPeer::selectGeneric($idM['generic'], $IDS, $idM['material']), $idM['material']) . '</select> <input type="button" style="width:30px;" onClick="esborraLinia(' . $id . ');" id="mesmaterial" value="-"></input> <br /> </span> '; $id++; } echo '<input type="button" id="mesmaterial" style="width:30px;" value="+"></input><br />'; echo '<input type="hidden" id="idV" value="' . $id . '"></input>'; echo '<div id="divTxt">' . $VAL . '</div>'; ?> </span> </div> <div class="clear"></div> <div id="div_lloc_extern" class="clear row fb"> <span class="title row_title fb"><b>Opcions: </b></span> <span class="row_field fb"> <a href="#" id="a_lloc_extern">L'activitat es realitza a un lloc extern</a> </span> </div> <div id="formulari_lloc_extern"> <div><b>Població externa</b><br /><br /></div> <?php echo $EXTRES['ESPAIEXTERN']; ?> <div class="clear"></div> </div> <div class="clear row fb"> <div style="text-align:right"> <?php include_partial('botonera', array('element' => 'l\\\'horari', 'tipus' => 'Guardar', 'nom' => 'BHORARISAVE')); ?> <?php include_partial('botonera', array('element' => 'l\\\'horari', 'tipus' => 'Esborrar', 'nom' => 'BHORARIDELETE')); ?> </div> </div> </div> <div class="clear"></div> </div> <script type="text/javascript"> $(function() { $('#multi999Datepicker').datepick({numberOfMonths: 3, multiSelect: 999, showOn: 'both', buttonImageOnly: true, buttonImage: '<?php echo image_path('template/calendar_1.png'); ?> '}); }); </script> </form> <?php }
public function executeGConfig(sfWebRequest $request) { $this->setLayout('gestio'); $this->IDS = $this->getUser()->getSessionPar('idS'); $this->accio = $request->getParameter('accio', 'C'); $ROPTIONS = $request->getParameter('options', array('option_id' => '0')); $RESPAIS = $request->getParameter('espais', array('EspaiID' => '0')); $RMATERIAL = $request->getParameter('materialgeneric', array('idMaterialGeneric' => '')); $RDESCOMPTE = $request->getParameter('descomptes', array('idDescompte' => '0')); $this->FOPTIONS = OptionsPeer::initialize($ROPTIONS['option_id'], $this->IDS, false); $this->FESPAIS = EspaisPeer::initialize($RESPAIS['EspaiID'], $this->IDS); $this->FMATERIAL = MaterialgenericPeer::initialize($RMATERIAL['idMaterialGeneric'], $this->IDS); $this->FENTITAT = SitesPeer::initialize($this->IDS); //$this->FDESCOMPTE = DescomptesPeer::initialize( $RDESCOMPTE['idDescompte'] , $this->IDS ); //Agafem el codi de facebook de l'usuari $this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU')); $this->PARS = array(); $this->PARS = myUser::f_FbAuth(false, $this->getController()->genUrl('@fb_link', true)); //Carreguem les dades del facebook. $this->ERROR = ""; if ($request->hasParameter('BNEWOPTION')) { $this->accio = 'NEW_OPTION'; } if ($request->hasParameter('BSAVEOPTION')) { $this->accio = 'SAVE_OPTION'; } if ($request->hasParameter('BSAVEESPAI')) { $this->accio = 'SAVE_ESPAI'; } if ($request->hasParameter('BDELETEESPAI')) { $this->accio = 'DELETE_ESPAI'; } if ($request->hasParameter('BSAVEMATERIAL')) { $this->accio = 'SAVE_MATERIAL'; } if ($request->hasParameter('BDELETEMATERIAL')) { $this->accio = 'DELETE_MATERIAL'; } if ($request->hasParameter('BSAVESITE')) { $this->accio = 'SAVE_SITE'; } if ($request->hasParameter('BSAVEDESCOMPTE')) { $this->accio = 'SAVE_DESCOMPTE'; } switch ($this->accio) { case 'AJAX_OPCIO': return $this->renderText(OptionsPeer::getString($request->getParameter('IDO'), $this->IDS)); break; case 'NEW_OPTION': $this->FOPTIONS = OptionsPeer::initialize($ROPTIONS['option_id'], $this->IDS, true); break; case 'SAVE_OPTION': $this->FOPTIONS->bind($ROPTIONS); if ($this->FOPTIONS->isValid()) { $this->FOPTIONS->save(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FOPTIONS->getObject()); $this->FOPTIONS = OptionsPeer::initialize($this->FOPTIONS->getObject()->getOptionId(), $this->IDS, false); } break; case 'SAVE_ESPAI': //Si entrem un espai que és 0, llavors vol dir que fem un nou espai if ($RESPAIS['EspaiID'] == 0) { unset($RESPAIS['EspaiID']); } $this->FESPAIS->bind($RESPAIS, $request->getFiles('espais')); if ($this->FESPAIS->isValid()) { $this->FESPAIS->save(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FESPAIS->getObject()); $this->FESPAIS = EspaisPeer::initialize($this->FESPAIS->getObject()->getEspaiid(), $this->IDS); } //Agafem els multimèdia dels paràmetres $AMR = $request->getParameter('multimedia'); $FMR = $request->getFiles('multimedia'); foreach ($AMR as $K => $MR) { if ($MR['accio'] == 1 || $MR['accio'] == 0) { //És nou o una modificació $FM = MultimediaPeer::initialize($MR['multimedia_id'], $MR['site_id'], $MR['taula'], $MR['id_extern'], $K); $FM->bind($MR, $FMR[$K]); $FM->saveNewUpdate(); } elseif ($MR['accio'] == 2) { //S'ha d'esborrar $FM = MultimediaPeer::initialize($MR['multimedia_id'], $MR['site_id'], $MR['taula'], $MR['id_extern'], $K); $FM->delete(); } } break; case 'DELETE_ESPAI': $this->FESPAIS->getObject()->setActiu(false)->save(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FESPAIS->getObject()); $this->FESPAIS = EspaisPeer::initialize(0, $this->IDS); break; case 'SAVE_MATERIAL': //Si entrem un espai que és 0, llavors vol dir que fem un nou espai if ($RMATERIAL['idMaterialGeneric'] == 0) { unset($RMATERIAL['idMaterialGeneric']); } $this->FMATERIAL->bind($RMATERIAL); if ($this->FMATERIAL->isValid()) { $this->FMATERIAL->save(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FMATERIAL->getObject()); $this->FMATERIAL = MaterialgenericPeer::initialize($this->FMATERIAL->getObject()->getIdmaterialgeneric(), $this->IDS); } break; case 'DELETE_MATERIAL': $this->FMATERIAL->getObject()->setInactiu(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FMATERIAL->getObject()); $this->FMATERIAL = MaterialgenericPeer::initialize(0, $this->IDS); break; //Vincula l'usuari del facebook //Vincula l'usuari del facebook case 'FB_LINK': $idU = $this->getUser()->getSessionPar('idU'); $OU = UsuarisPeer::retrieveByPK($idU); $FB_ID = $this->PARS['user']['id']; //Mirem si el número de facebook està associat a un altre usuari. Si és així, no fem res però emetem error. $OUF = UsuarisPeer::getUserFromFacebook($FB_ID); if ($OUF instanceof Usuaris) { $this->ERROR = 'El compte de facebook actual està vinculat a un altre usuari. <br />Si us plau comuniqui-ho a informatica@casadecultura.org o bé entri al seu usuari de facebook i torni-ho a provar.'; } elseif ($OU instanceof Usuaris) { $OU->setFacebookid($this->PARS['user']['id']); $OU->save(); } $this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU')); break; //Desvincula l'usuari del facebook //Desvincula l'usuari del facebook case 'FB_UNLINK': $idU = $this->getUser()->getSessionPar('idU'); $OU = UsuarisPeer::retrieveByPK($idU); $OU->setFacebookid(NULL); $OU->save(); $this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU')); break; //Guardem els canvis a una entitat //Guardem els canvis a una entitat case 'SAVE_SITE': $RS = $request->getParameter('sites'); $this->FENTITAT->bind($RS, $request->getFiles('sites')); if ($this->FENTITAT->isValid()) { $this->FENTITAT->save(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FENTITAT->getObject()); $this->FENTITAT = SitesPeer::initialize($this->IDS); } break; case 'SAVE_DESCOMPTE': //Si entrem un descompte que és 0, vol dir que creem un nou descompte $this->FDESCOMPTE->bind($RDESCOMPTE); if ($this->FDESCOMPTE->isValid()) { $this->FDESCOMPTE->save(); $this->getUser()->addLogAction($this->accio, 'gConfig', $this->FDESCOMPTE->getObject()); $this->FDESCOMPTE = DescomptesPeer::initialize($this->FDESCOMPTE->getObject()->getIddescompte(), $this->IDS); } break; } }
/** * 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 = MaterialgenericPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setIdmaterialgeneric($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setNom($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setSiteId($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setActiu($arr[$keys[3]]); } }
/** * Get the associated Materialgeneric object * * @param PropelPDO Optional Connection object. * @return Materialgeneric The associated Materialgeneric object. * @throws PropelException */ public function getMaterialgeneric(PropelPDO $con = null) { if ($this->aMaterialgeneric === null && $this->materialgeneric_idmaterialgeneric !== null) { $this->aMaterialgeneric = MaterialgenericPeer::retrieveByPk($this->materialgeneric_idmaterialgeneric); /* 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->aMaterialgeneric->addMaterials($this); */ } return $this->aMaterialgeneric; }
<div class="TITOL">Escull el material de la cessió: </div> <div> <input type="hidden" name="IDC" value="<?php echo $IDC; ?> " /> <?php $id = 1; $VAL = ""; if (!isset($MATERIALOUT)) { $MATERIALOUT = array(); } foreach ($MATERIALOUT as $M => $idM) { $VAL .= ' <span id="row[' . $id . ']"> <select onChange="ajax(this,' . $id . ')" name="generic[' . $id . ']"> id="generic[' . $id . ']">' . options_for_select(MaterialgenericPeer::select($IDS), $idM['generic']) . '</select> <select name="material[' . $id . ']" id="material[' . $id . ']">' . options_for_select(MaterialPeer::selectGeneric($idM['generic'], $IDS, $idM['material']), $idM['material']) . '</select> <input type="button" onClick="esborraLinia(' . $id . ');" id="mesmaterial" value="-"></input> <br /> </span> '; $id++; } echo '<input type="button" id="mesmaterial" value="+"></input><br />'; echo '<input type="hidden" id="idV" value="' . $id . '"></input>'; echo '<div id="divTxt">' . $VAL . '</div>'; ?> </div> <br />
function formCercaMaterials($CERCA, $IDS) { ?> <form action="<?php echo url_for('gestio/gEstadistiques'); ?> " id="FMATERIALS" method="POST"> <table class="FORMULARI" width="100%"> <tr><td> <div class="TITOL">Cerca materials</div> <div class="CERCA"> <div style="margin-bottom:10px;"> <?php echo select_tag('cerca[ANY]', options_for_select(selectAnys(), $CERCA['ANY']), array('class' => 'cinquanta')); ?> <?php echo select_tag('cerca[MES]', options_for_select(selectMesos(), $CERCA['MES'], array()), array('class' => 'cinquanta')); ?> <?php echo select_tag('cerca[MATERIAL_GENERIC]', options_for_select(MaterialgenericPeer::select($IDS, false, false), $CERCA['MATERIAL_GENERIC'])); ?> </div> <?php foreach (MaterialPeer::selectGeneric($CERCA['MATERIAL_GENERIC'], $IDS) as $K => $V) { echo '<div style="float:left; width:210px;">' . checkbox_tag('cerca[MATERIAL][' . $K . ']', $K, isset($CERCA['MATERIAL'][$K]), array()) . ' ' . $V . ' (M' . $K . ')</div>'; } ?> </div> </td></tr> <tr> <td colspan="2"> <input type="submit" name="BCERCA_MAT" value="Prem per buscar" /> </td> </tr> </table> </form> <?php }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(MaterialgenericPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(MaterialgenericPeer::DATABASE_NAME); $criteria->add(MaterialgenericPeer::IDMATERIALGENERIC, $pks, Criteria::IN); $objs = MaterialgenericPeer::doSelect($criteria, $con); } return $objs; }
} if (isset($ERRORS[$K]['DIA'])) { echo '<div class="ERRORS">' . $ERRORS[$K]['DIA'] . '</DIV>'; } echo input_tag("D[{$K}][DIA]", $L['DIA'], array('id' => 'DIA')) . '<br />' . input_tag("D[{$K}][HORAPRE]", $L['HORAPRE'], array('id' => 'HORA')) . ' - ' . input_tag("D[{$K}][HORAI]", $L['HORAI'], array('id' => 'HORA')) . ' - ' . input_tag("D[{$K}][HORAF]", $L['HORAF'], array('id' => 'HORA')) . ' - ' . input_tag("D[{$K}][HORAPOST]", $L['HORAPOST'], array('id' => 'HORA')) . '</TD>'; echo '<TD>'; if (isset($ERRORS[$K]['ESPAIS'])) { echo '<div class="ERRORS">' . $ERRORS[$K]['ESPAIS'] . '</DIV><br />'; } foreach ($L['ESPAIS'] as $E) { echo select_tag("D[{$K}][ESPAIS][]", options_for_select(EspaisPeer::select(), $E, array('include_blank' => true)), array('multiple' => false)) . '<br />'; } echo '</TD>'; echo '<TD>'; foreach ($L['MATERIAL'] as $M) { echo select_tag("D[{$K}][MATERIAL][]", options_for_select(MaterialgenericPeer::select(), $M, array('include_blank' => true)), array('multiple' => false)) . '<BR />'; } echo '</TD>'; echo '</TR>'; } echo '</table>'; echo submit_tag('Afegir extres', array('name' => 'Extra')); echo submit_tag('Guardar', array('name' => 'Save')); } ?> </td> </tr> </table> </td> </tr></table>