public static function getUsuari($email)
{
$C = new Criteria();
$C->add(UsuarisPeer::EMAIL, $email);
$C->add(UsuarisPeer::ACTIU, true);
return UsuarisPeer::doSelect($C);
}
public function setup()
{
$this->setWidgets(array('idIncidencia' => new sfWidgetFormInputHidden(), 'quiinforma' => new sfWidgetFormChoice(array('choices' => UsuarisPeer::selectTreballadors($this->getOption('IDS')))), 'quiresol' => new sfWidgetFormChoice(array('choices' => UsuarisPeer::selectTreballadors($this->getOption('IDS')))), 'titol' => new sfWidgetFormInputText(array(), array('style' => 'width:400px')), 'descripcio' => new sfWidgetFormTextarea(array(), array('style' => 'width:400px')), 'estat' => new sfWidgetFormChoice(array('choices' => IncidenciesPeer::getEstatSelect())), 'dataalta' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'dataresolucio' => new sfWidgetFormInputHidden(), 'site_id' => new sfWidgetFormInputHidden(), 'actiu' => new sfWidgetFormInputHidden()));
$this->setValidators(array('idIncidencia' => new sfValidatorPropelChoice(array('model' => 'Incidencies', 'column' => 'idIncidencia', 'required' => false)), 'quiinforma' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID')), 'quiresol' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID')), 'titol' => new sfValidatorString(array('required' => false)), 'descripcio' => new sfValidatorString(array('required' => false)), 'estat' => new sfValidatorInteger(), 'dataalta' => new sfValidatorDate(array('required' => false)), 'dataresolucio' => new sfValidatorDate(array('required' => false)), 'site_id' => new sfValidatorPass(), 'actiu' => new sfValidatorPass()));
$this->widgetSchema->setLabels(array('quiinforma' => 'Afectat: ', 'quiresol' => 'Responsable: ', 'titol' => 'Titol: ', 'descripcio' => 'Descripció: ', 'estat' => 'Estat: ', 'dataalta' => 'Data d\'alta', 'dataresolucio' => 'Data resolució: '));
$this->widgetSchema->setNameFormat('incidencies[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
}
public function setup()
{
$Users = UsuarisPeer::selectAllUsers();
$idU = $this->getObject()->getUsuariid();
$this->setWidgets(array('DNI' => new sfWidgetFormInput(array(), array()), 'usuari_id' => new sfWidgetFormChoice(array('choices' => $Users), array()), 'site_id' => new sfWidgetFormChoice(array('choices' => UsuarisSitesPeer::getSites($idU, $this->getOption('NEW')))), 'nivell_id' => new sfWidgetFormChoice(array('choices' => NivellsPeer::getSelect())), 'actiu' => new sfWidgetFormInputHidden()));
$this->setValidators(array('DNI' => new sfValidatorString(array('required' => true), array()), 'usuari_id' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID', 'required' => false)), 'site_id' => new sfValidatorPropelChoice(array('model' => 'Sites', 'column' => 'site_id', 'required' => false)), 'nivell_id' => new sfValidatorPropelChoice(array('model' => 'Nivells', 'column' => 'idNivells')), 'actiu' => new sfValidatorInteger(array('min' => -128, 'max' => 127))));
$this->widgetSchema->setNameFormat('usuaris_sites[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
}
public function setup()
{
$BASE = OptionsPeer::getString('SF_WEBROOT', $this->getOption('IDS'));
$this->setWidgets(array('cessio_id' => new sfWidgetFormInputHidden(), 'usuari_id' => new sfWidgetFormChoice(array('choices' => UsuarisPeer::selectUsuaris($this->getOption('IDS'))), array('style' => 'width:400px')), 'representant' => new sfWidgetFormInputText(array(), array()), 'data_cessio' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'data_retorn' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'motiu' => new sfWidgetFormTextarea(array(), array()), 'condicions' => new sfWidgetFormTextarea(array(), array()), 'material_no_inventariat' => new sfWidgetFormInputHidden(array(), array()), 'estat' => new sfWidgetFormTextarea(), 'retornat' => new sfWidgetFormInputHidden(), 'estat_retornat' => new sfWidgetFormInputHidden(), 'data_retornat' => new sfWidgetFormInputHidden()));
$this->setValidators(array('cessio_id' => new sfValidatorPropelChoice(array('model' => 'Cessio', 'column' => 'cessio_id', 'required' => false)), 'usuari_id' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID', 'required' => true)), 'representant' => new sfValidatorString(array('required' => true), array()), 'motiu' => new sfValidatorString(array('required' => true), array()), 'condicions' => new sfValidatorString(array('required' => false), array()), 'material_no_inventariat' => new sfValidatorString(array('required' => false), array()), 'data_cessio' => new sfValidatorDate(array('required' => false), array()), 'data_retorn' => new sfValidatorDate(array('required' => false), array()), 'estat' => new sfValidatorString(array('required' => false), array()), 'retornat' => new sfValidatorInteger(array('required' => false), array()), 'estat_retornat' => new sfValidatorString(array('required' => false), array()), 'data_retornat' => new sfValidatorDate(array('required' => false), array())));
$this->widgetSchema->setLabels(array('usuari_id' => 'Cedit a', 'representant' => 'Representant a ', 'motiu' => 'Motiu ', 'condicions' => 'Condicions ', 'data_cessio' => 'Data cessió', 'data_retorn' => 'Data retorn', 'estat' => 'Observacions', 'retornat' => 'Retornat?', 'estat_retornat' => 'Estat retorn', 'data_retornat' => 'Data retornat'));
$this->widgetSchema->setNameFormat('cessio[%s]');
$this->widgetSchema->setFormFormatterName('Span');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
}
public function getMailsUsuaris()
{
$RET = array();
$IDL = $this->getIdllistes();
$C = new Criteria();
$C->add(UsuarisllistesPeer::LLISTES_IDLLISTES, $IDL);
$C->addJoin(UsuarisllistesPeer::USUARIS_USUARISID, UsuarisPeer::USUARIID);
foreach (UsuarisPeer::doSelect($C) as $U) {
$RET[$U->getEmail()] = $U->getEmail();
}
return $RET;
}
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');
}
public static function getSelectUsuarisPermis($APPID, $idS)
{
$RET = array();
$C = new Criteria();
$C = self::getCriteriaActiu($C, $idS);
$C = UsuarisPeer::getCriteriaActiu($C, $idS);
$C->addJoin(UsuarisPeer::USUARIID, self::USUARI_ID);
foreach (UsuarisPeer::doSelect($C) as $U) {
$RET[$U->getUsuariid()] = $U->getDni() . ' - ' . $U->getNomComplet();
}
return $RET;
}
public static function ComprovaDNI($A, $valor, $arguments)
{
$DNI = trim($valor);
if (self::valida_nif_cif_nie($DNI) <= 0) {
throw new sfValidatorError($A, "Error: El DNI és incorrecte.<br /> Recorda escriure'l amb el format 99999999A.");
}
$OUsuari = UsuarisPeer::cercaDNI($DNI);
if ($OUsuari instanceof Usuaris && $OUsuari->getUsuariid() != $arguments['idU']) {
throw new sfValidatorError($A, "Error: El DNI ja existeix. Si us plau envii un missatge a informatica@casadecultura.org per a més informació. ");
}
return $valor;
}
public function setup()
{
$this->setWidgets(array('TasquesID' => new sfWidgetFormInputHidden(), 'Activitats_ActivitatID' => new sfWidgetFormInputHidden(), 'QuiMana' => new sfWidgetFormChoice(array('choices' => UsuarisPeer::selectTreballadors())), 'QuiFa' => new sfWidgetFormChoice(array('choices' => UsuarisPeer::selectTreballadors())), 'Titol' => new sfWidgetFormInputText(array(), array('class' => 'text')), 'Accio' => new sfWidgetFormTextarea(array(), array('class' => 'text', 'rows' => '5')), 'Reaccio' => new sfWidgetFormInputHidden(), 'Estat' => new sfWidgetFormInputHidden(), 'Aparicio' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'Desaparicio' => new sfWidgetFormJQueryDate(array('format' => '%day%/%month%/%year%'), array()), 'DataResolucio' => new sfWidgetFormInputHidden(), 'isFeta' => new sfWidgetFormChoice(array('choices' => array(0 => 'No', 1 => 'SÃ'))), 'AltaRegistre' => new sfWidgetFormInputHidden()));
$this->setValidators(array('TasquesID' => new sfValidatorPropelChoice(array('model' => 'Tasques', 'column' => 'TasquesID', 'required' => false)), 'Activitats_ActivitatID' => new sfValidatorPropelChoice(array('model' => 'Activitats', 'column' => 'ActivitatID', 'required' => false)), 'QuiMana' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID', 'required' => false)), 'QuiFa' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID')), 'Titol' => new sfValidatorString(array('required' => true)), 'Accio' => new sfValidatorString(array('required' => true)), 'Reaccio' => new sfValidatorString(array('required' => false)), 'Estat' => new sfValidatorString(array('max_length' => 1, 'required' => false)), 'Aparicio' => new sfValidatorDate(array('required' => true)), 'Desaparicio' => new sfValidatorDate(array('required' => true)), 'DataResolucio' => new sfValidatorDateTime(array('required' => false)), 'isFeta' => new sfValidatorBoolean(array('required' => false)), 'AltaRegistre' => new sfValidatorDate(array('required' => false))));
$this->widgetSchema->setLabels(array('QuiMana' => 'Qui mana la feina?', 'QuiFa' => 'Qui fa la feina?', 'Titol' => 'TÃtol: ', 'Accio' => 'Què s\'ha de fer?', 'Aparicio' => 'Data aparició:', 'Desaparicio' => 'Data desaparició:', 'isFeta' => 'Feta?'));
$this->widgetSchema->setNameFormat('tasques[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
$this->widgetSchema->setFormFormatterName('Span');
$this->setDefault('Aparicio', date('Y-m-d', time()));
$this->setDefault('Desaparicio', date('Y-m-d', time()));
$this->setDefault('isFeta', false);
$this->setDefault('AltaRegistre', date('Y-m-d', time()));
}
public function EnviaMissatgeGlobalHospici()
{
$ADMIN = OptionsPeer::getString('MAIL_ADMIN', $this->getSiteId());
//Carreguem el correu de l'administrador
$MAILS = UsuarisPeer::getAdminMails();
//Carreguem els mails dels administradors
$BODY = OptionsPeer::getString('BODY_MAIL_MISSATGE_GLOBAL', $this->getSiteId());
$BODY = str_replace('{NOM}', $this->getUsuaris()->getNomComplet(), $BODY);
$BODY = str_replace('{SITE}', $this->getSiteNom(), $BODY);
$BODY = str_replace('{ENLLAC}', 'http://www.casadecultura.cat/gestio/gMissatges?accio=E&IDM=' . $this->getMissatgeid(), $BODY);
$SUBJECT = 'Hospici : Nou missatge global';
myUser::sendMail($ADMIN, $MAILS, $SUBJECT, $BODY);
}
public function getNomUsuari()
{
//Si és un usuari, el busquem, altrament marquem el nom que hem entrat
if (!is_null($this->getUsuariId())) {
$OU = UsuarisPeer::retrieveByPK($this->getUsuariId());
if ($OU instanceof Usuaris) {
return $OU->getNomComplet();
} else {
return $this->getNomReserva();
}
} else {
return $this->getNomReserva();
}
}
public function getNomUsuari()
{
$C = new Criteria();
$C->addJoin(CessioPeer::USUARI_ID, UsuarisPeer::USUARIID);
$C = CessioPeer::getCriteriaActiu($C, $this->getSiteId());
$C = UsuarisPeer::getCriteriaActiu($C, $this->getSiteId());
$C->add(CessioPeer::USUARI_ID, $this->getUsuariId());
$OU = UsuarisPeer::doSelectOne($C);
if ($OU instanceof Usuaris) {
return $OU->getNomComplet();
} else {
return 'n/d';
}
}
public static function getFormulariDetall($idU, $idF)
{
//Carreguem el formulari formulari
$OF = FormularisPeer::retrieveByPK($idF);
if ($OF instanceof Formularis) {
$FORM = $OF->getFormulari();
} else {
$FORM = "No s'ha trobat el formulari. ";
}
//Mirem si l'usuari ja en té algun de creat.
$C = new Criteria();
$C->add(FormularisRespostesPeer::IDUSUARIS, $idU);
$C->add(FormularisRespostesPeer::IDFORMULARIS, $idF);
$C->addDescendingOrderByColumn(FormularisRespostesPeer::IDFORMULARISRESPOSTES);
$OFR = FormularisRespostesPeer::doSelectOne($C);
//Analitzo el formulari i canvio els codis per inputs pertinents.
$ARR = array();
preg_match_all("/#@@(.*)@@#/", $FORM, $ARR);
//Serà l'array amb els valors a carregar
$A_D = array();
//Si ja hi ha una resposta, reomplim el formulari
if ($OFR instanceof FormularisRespostes) {
$A_D = unserialize($OFR->getDades());
//Si no hi ha cap registre previ, posem les dades de registre per estalviar feina.
} else {
$OU = UsuarisPeer::retrieveByPK($idU);
if ($OU instanceof Usuaris) {
$A_D = array('NOM' => $OU->getNom(), 'COGNOMS' => $OU->getCog1() . ' ' . $OU->getCog2(), 'DNI' => $OU->getDni(), 'POBLACIO' => $OU->getPoblacioString(), 'TELEFON' => $OU->getTelefonString(), 'EMAIL' => $OU->getEmail(), 'ENTITAT' => $OU->getEntitat(), 'ADRECA' => $OU->getAdreca(), 'CODI_POSTAL' => $OU->getCodipostal());
}
}
//Construim el formulari amb els valors que hem extret del formulari
foreach ($ARR[1] as $K => $V) {
$A = explode("@@", $V);
if ($A[0] == 'text') {
if (isset($A_D[$A[1]])) {
$FORM = str_replace($ARR[0][$K], '<input type="text" value="' . $A_D[$A[1]] . '" name="formulari[' . $A[1] . ']" ' . $A[2] . ' />', $FORM);
} else {
$FORM = str_replace($ARR[0][$K], '<input type="text" value="" name="formulari[' . $A[1] . ']" ' . $A[2] . ' />', $FORM);
}
} elseif ($A[0] == 'checkbox') {
if (isset($A_D[$A[1]])) {
$FORM = str_replace($ARR[0][$K], '<input type="checkbox" checked="checked" name="formulari[' . $A[1] . ']" ' . $A[2] . ' />', $FORM);
} else {
$FORM = str_replace($ARR[0][$K], '<input type="checkbox" name="formulari[' . $A[1] . ']" ' . $A[2] . ' />', $FORM);
}
}
}
return $FORM;
}
public static function ComprovaDNI($A, $valor, $arguments)
{
$DNI = trim($valor);
if (self::valida_nif_cif_nie($DNI) <= 0) {
throw new sfValidatorError($A, "Error: El DNI és incorrecte.<br /> Recorda escriure'l amb el format 99999999A.");
}
$OUsuari = UsuarisPeer::cercaDNI($DNI);
//Hi ha un usuari amb aquest DNI
if ($OUsuari instanceof Usuaris) {
//L'usuari i l'actual són diferents
if ($OUsuari->getUsuariid() != $arguments['idU']) {
//Són diferents perquè és un usuari nou i estem en administració
if ($arguments['ADMIN'] && is_null($arguments['idU'])) {
return $valor;
} else {
throw new sfValidatorError($A, "Error: Ja hi ha un usuari creat amb aquest DNI.<br />Provi de recuperar la seva contrassenya i si no pot, contacti per e-mail amb informatica@casadecultura.org. ");
}
}
}
return $valor;
}
case PersonalPeer::HORARI_USUARI:
$TIPUS = 'Horari habitual';
break;
}
echo '<tr>
<td width="20%">' . image_tag('intranet/fletxeta.png', array('align' => 'ABSMIDDLE')) . ' <a href="#" class="tt2">' . $TIPUS . '</td>
<td><a href="#" class="tt2">' . $F['SUBTEXT'] . $SPAN . '</td>
<td width="20%">' . $F['USUARIA'] . '</td>
</tr>';
}
foreach ($INCIDENCIES as $I) {
$SPAN = '<SPAN>' . $I->getDescripcio() . '</SPAN>';
echo '<tr>
<td width="20%">' . image_tag('intranet/fletxeta.png', array('align' => 'ABSMIDDLE')) . ' <a href="#" class="tt2">Incidència</td>
<td><a href="#" class="tt2">' . $I->getTitol() . $SPAN . '</td>
<td width="20%">' . UsuarisPeer::getNom($I->getQuiinforma()) . '</td>
</tr>';
}
foreach ($FEINES as $F) {
$SPAN = '<SPAN>' . $F['TEXT'] . '</SPAN>';
$DATA = date('d-m-Y', $F['DATA']);
$SetMana = mktime(0, 0, 0, date('m', time()), date('d', time()) - 7, date('Y', time()));
if ($DATA == date('d-m-Y', time())) {
$DATA = 'Avui';
} elseif (strtotime($DATA) > $SetMana) {
$DATA = 'Menys de 7 dies (' . $DATA . ')';
} elseif (strtotime($DATA) <= $SetMana) {
$DATA = 'Fa més d\'una setmana (' . $DATA . ')';
}
$PAR = url_for('gestio/gPersonal?accio=EDIT_CHANGE&IDU=' . $F['IDU'] . '&IDPERSONAL=' . $F['IDP'] . '&DATE=' . $F['DATA']);
echo '<tr>
/**
* Retorna el Select amb els usuaris d'un Site
* @param $idS Site ID
* @param $nivell Segons el nivell, mostrarà els usuaris
* @return Select
* */
public static function getSitesUsers($idS, $nivell = NivellsPeer::ADMIN)
{
$C = new Criteria();
$C = self::getCriteriaActiu($C);
$C = UsuarisPeer::getCriteriaActiu($C, $idS);
$C->addJoin(self::USUARI_ID, UsuarisPeer::USUARIID);
$C->add(UsuarisSitesPeer::NIVELL_ID, $nivell);
$C->add(self::SITE_ID, $idS);
return self::doSelect($C);
}
/**
* Selects a collection of UsuarisSites objects pre-filled with all related objects except Nivells.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of UsuarisSites objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptNivells(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$criteria = clone $criteria;
// Set the correct dbName if it has not been overridden
// $criteria->getDbName() will return the same object if not set to another value
// so == check is okay and faster
if ($criteria->getDbName() == Propel::getDefaultDB()) {
$criteria->setDbName(self::DATABASE_NAME);
}
UsuarisSitesPeer::addSelectColumns($criteria);
$startcol2 = UsuarisSitesPeer::NUM_COLUMNS - UsuarisSitesPeer::NUM_LAZY_LOAD_COLUMNS;
UsuarisPeer::addSelectColumns($criteria);
$startcol3 = $startcol2 + (UsuarisPeer::NUM_COLUMNS - UsuarisPeer::NUM_LAZY_LOAD_COLUMNS);
SitesPeer::addSelectColumns($criteria);
$startcol4 = $startcol3 + (SitesPeer::NUM_COLUMNS - SitesPeer::NUM_LAZY_LOAD_COLUMNS);
$criteria->addJoin(UsuarisSitesPeer::USUARI_ID, UsuarisPeer::USUARIID, $join_behavior);
$criteria->addJoin(UsuarisSitesPeer::SITE_ID, SitesPeer::SITE_ID, $join_behavior);
// symfony_behaviors behavior
foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
call_user_func($sf_hook, 'BaseUsuarisSitesPeer', $criteria, $con);
}
$stmt = BasePeer::doSelect($criteria, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = UsuarisSitesPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = UsuarisSitesPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://propel.phpdb.org/trac/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$cls = UsuarisSitesPeer::getOMClass(false);
$obj1 = new $cls();
$obj1->hydrate($row);
UsuarisSitesPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined Usuaris rows
$key2 = UsuarisPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = UsuarisPeer::getInstanceFromPool($key2);
if (!$obj2) {
$cls = UsuarisPeer::getOMClass(false);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
UsuarisPeer::addInstanceToPool($obj2, $key2);
}
// if $obj2 already loaded
// Add the $obj1 (UsuarisSites) to the collection in $obj2 (Usuaris)
$obj2->addUsuarisSites($obj1);
}
// if joined row is not null
// Add objects for joined Sites rows
$key3 = SitesPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = SitesPeer::getInstanceFromPool($key3);
if (!$obj3) {
$cls = SitesPeer::getOMClass(false);
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
SitesPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (UsuarisSites) to the collection in $obj3 (Sites)
$obj3->addUsuarisSites($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
/**
* Get the associated Usuaris object
*
* @param PropelPDO Optional Connection object.
* @return Usuaris The associated Usuaris object.
* @throws PropelException
*/
public function getUsuarisRelatedByQuiresol(PropelPDO $con = null)
{
if ($this->aUsuarisRelatedByQuiresol === null && $this->quiresol !== null) {
$this->aUsuarisRelatedByQuiresol = UsuarisPeer::retrieveByPk($this->quiresol);
/* 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->aUsuarisRelatedByQuiresol->addIncidenciessRelatedByQuiresol($this);
*/
}
return $this->aUsuarisRelatedByQuiresol;
}
public static function getNom($idU)
{
return UsuarisPeer::retrieveByPK($idU)->getNomComplet();
}
/**
* 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 = UsuarisPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setUsuariid($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setNivellsIdnivells($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setDni($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setPasswd($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setNom($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setCog1($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setCog2($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setEmail($arr[$keys[7]]);
}
if (array_key_exists($keys[8], $arr)) {
$this->setAdreca($arr[$keys[8]]);
}
if (array_key_exists($keys[9], $arr)) {
$this->setCodipostal($arr[$keys[9]]);
}
if (array_key_exists($keys[10], $arr)) {
$this->setPoblacio($arr[$keys[10]]);
}
if (array_key_exists($keys[11], $arr)) {
$this->setPoblaciotext($arr[$keys[11]]);
}
if (array_key_exists($keys[12], $arr)) {
$this->setTelefon($arr[$keys[12]]);
}
if (array_key_exists($keys[13], $arr)) {
$this->setMobil($arr[$keys[13]]);
}
if (array_key_exists($keys[14], $arr)) {
$this->setEntitat($arr[$keys[14]]);
}
if (array_key_exists($keys[15], $arr)) {
$this->setHabilitat($arr[$keys[15]]);
}
if (array_key_exists($keys[16], $arr)) {
$this->setActualitzacio($arr[$keys[16]]);
}
if (array_key_exists($keys[17], $arr)) {
$this->setSiteId($arr[$keys[17]]);
}
if (array_key_exists($keys[18], $arr)) {
$this->setActiu($arr[$keys[18]]);
}
if (array_key_exists($keys[19], $arr)) {
$this->setFacebookId($arr[$keys[19]]);
}
if (array_key_exists($keys[20], $arr)) {
$this->setDataNaixement($arr[$keys[20]]);
}
}
/**
* 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(UsuarisPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(UsuarisPeer::DATABASE_NAME);
$criteria->add(UsuarisPeer::USUARIID, $pks, Criteria::IN);
$objs = UsuarisPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this Nivells is new, it will return
* an empty collection; or if this Nivells has previously
* been saved, it will retrieve related Usuariss from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in Nivells.
*/
public function getUsuarissJoinPoblacions($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
if ($criteria === null) {
$criteria = new Criteria(NivellsPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collUsuariss === null) {
if ($this->isNew()) {
$this->collUsuariss = array();
} else {
$criteria->add(UsuarisPeer::NIVELLS_IDNIVELLS, $this->idnivells);
$this->collUsuariss = UsuarisPeer::doSelectJoinPoblacions($criteria, $con, $join_behavior);
}
} else {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return the collection.
$criteria->add(UsuarisPeer::NIVELLS_IDNIVELLS, $this->idnivells);
if (!isset($this->lastUsuarisCriteria) || !$this->lastUsuarisCriteria->equals($criteria)) {
$this->collUsuariss = UsuarisPeer::doSelectJoinPoblacions($criteria, $con, $join_behavior);
}
}
$this->lastUsuarisCriteria = $criteria;
return $this->collUsuariss;
}
echo getSelData($DATAI);
?>
</span></div>
<table style="border-collapse: collapse;" id="CALENDARI_ACTIVITATS">
<?php
echo llistaCalendariH($DATAI, $CALENDARI);
?>
</table>
<!-- Fi Imprimir -->
<!-- Mostrem formulari -->
<div id="LLISTAT_ACTIVITATS">
<div style="margin-top:10px" class="TITOL">Llistat d'accions per a l'usuari <i><?php
echo UsuarisPeer::getNomComplet($IDU);
?>
</i> pel dia <i><?php
echo date('d/m/Y', $DIA);
?>
</i></div>
<?php
foreach ($DADES_DIA as $OP) {
$img = "";
if (!is_null($OP->getDatafinalitzada())) {
$img = '<img align="bottom" width="10px" src="/images/template/accept.png" />';
}
echo '<div>';
echo '<div style="float:left; width: 50px;"><button class="BOTO_EDITA" id="BOTO_EDITA-' . $OP->getIdpersonal() . '"></button></div>';
echo '<div style="float:left; width: 100px; ">' . $OP->getTipusString() . ' ' . $img . '</div>';
break;
}
?>
<tr class="fila_novetats">
<td><?php
echo $id;
?>
</td>
<td><?php
echo date('d/m/Y H:i', (string) $E->quan);
?>
</td>
<td><?php
echo UsuarisPeer::getNomComplet((string) $E->qui);
?>
</td>
<td><?php
echo $E->accio;
?>
</td>
<td><?php
echo $link;
?>
</td>
</tr>
<?php
}
?>
/**
* Get the associated Usuaris object
*
* @param PropelPDO Optional Connection object.
* @return Usuaris The associated Usuaris object.
* @throws PropelException
*/
public function getUsuaris(PropelPDO $con = null)
{
if ($this->aUsuaris === null && $this->idusuari !== null) {
$this->aUsuaris = UsuarisPeer::retrieveByPk($this->idusuari);
/* 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->aUsuaris->addAppDocumentsPermisoss($this);
*/
}
return $this->aUsuaris;
}
/**
* Funció que em diu si una persona pot matricular-se a un curs o no
*/
public static function getRestrictedNotes($idU = "", $idC = "")
{
$OU = UsuarisPeer::retrieveByPK($idU);
if ($OU instanceof Usuaris) {
$DNI = $OU->getDni();
} else {
$DNI = "";
}
$file = fopen(OptionsPeer::getString('SF_WEBSYSROOT', 1) . 'documents/Notes-1.csv', "r");
$RET = array();
if ($file) {
while (($data = fgetcsv($file, 0, ";", '"')) !== FALSE) {
if (strtoupper($DNI) == strtoupper($data[4])) {
$i = 15;
$trobat = false;
while (isset($data[$i])) {
if ($data[$i + 1] == $idC) {
$RET[] = array_map("utf8_encode", $data);
}
$i = $i + 2;
}
}
}
fclose($file);
return sizeof($RET) > 0;
} else {
return false;
}
}
if ($MODE['NOU'] || $MODE['EDICIO']) {
?>
<form action="<?php
echo url_for('gestio/gReserves');
?>
" method="POST">
<div class="REQUADRE fb">
<?php
include_partial('botonera', array('tipus' => 'Tancar', 'url' => 'gestio/gReserves?accio=C'));
?>
<div class="FORMULARI fb">
<?php
$OUsuari = UsuarisPeer::retrieveByPK($FReserva->getObject()->getUsuarisusuariid());
$qui = "No trobat";
if ($OUsuari instanceof Usuaris) {
$qui = $OUsuari->getDni() . ' - ' . $OUsuari->getNomComplet();
}
?>
<?php
include_partial('fieldSpan', array('label' => 'Qui sol·licita?', 'field' => $qui));
?>
<?php
echo $FReserva;
?>
<div class="" style="text-align:right; padding-top:40px;">
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;
}
}
function Entrades_LlistaEntrades($LLISTAT_ENTRADES, $P)
{
?>
<div class="REQUADRE">
<div class="TITOL">Activitats amb reserva d'entrades</div>
<div class="DADIV">
<div class="titol" style=" width:350px; "> Nom </div>
<div class="titol" style=" width:100px; "> Estat </div>
<div class="titol" style=" width:50px; "> #Reser. </div>
<div class="titol" style=" width:100px; "> Accions </div>
<?php
if (sizeof($LLISTAT_ENTRADES) == 0) {
echo '<div style="clear:both">No hi ha cap reserva a aquesta activitat.</div>';
} else {
$total = 0;
foreach ($LLISTAT_ENTRADES as $OR) {
try {
$OU = UsuarisPeer::retrieveByPK($OR->getUsuariId());
echo '<div class="col" style="width:350px; height:45px; clear:both;"><b>' . $OU->getNomComplet() . '</b> (' . $OU->getDni() . ')<br />' . $OU->getEmail() . '<br />' . $OU->getTelefonString() . '</div>';
echo '<div class="col" style="width:100px; height:45px;">' . $OR->getEstatString() . '</div>';
echo '<div class="col" style="width:50px; height:45px;"><b>' . $OR->getQuantes() . '</b></div>';
echo '<div class="col" style="width:100px; height:45px;">' . link_to(image_tag('template/application_edit.png') . '<span>Modificar la reserva</span>', 'gestio/gEntrades?accio=ER&IDR=' . $OR->getEntradesReservaId(), array('class' => 'tt2')) . ' ' . link_to(image_tag('template/cross.png') . '<span>Anul·lar la reserva</span>', 'gestio/gEntrades?accio=AR&IDR=' . $OR->getEntradesReservaId(), array('class' => 'tt2')) . ' ' . '</div>';
$total += $OR->getQuantes();
} catch (Exception $e) {
var_dump($e);
}
}
echo '<div class="col" style="width:350px; clear:both;"><b>TOTAL</b></div>';
echo '<div class="col" style="width:100px;"> </div>';
echo '<div class="col" style="width:50px;"><b>' . $total . '</b></div>';
echo '<div class="col" style="width:100px;"> </div>';
}
?>
</div>
<div style="clear: both;"> </div>
</div>
<?php
}
public static function getDesvinculatsArray($IDL, $CERCA)
{
$SQL = "UsuariID not in (SELECT Usuaris_UsuarisID FROM usuarisllistes where Llistes_idLlistes = {$IDL}) ";
$C = self::CercaUsuaris($CERCA);
$C->add(UsuarisPeer::USUARIID, $SQL, Criteria::CUSTOM);
$C->addAscendingOrderByColumn(UsuarisPeer::COG1);
$C->addAscendingOrderByColumn(UsuarisPeer::COG2);
$C->addAscendingOrderByColumn(UsuarisPeer::NOM);
$RET = array();
foreach (UsuarisPeer::doSelect($C) as $OU) {
$RET[$OU->getUsuariid()] = $OU->getNomComplet();
}
return $RET;
}
