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() { $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 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 static function getHoraris($datai, $idS) { $RET = array(); $dataf = mktime(0, 0, 0, date('m', $datai), date('d', $datai) + 21, date('Y', $datai)); //Seleccionem tots els treballadors $TREBALLADORS = UsuarisPeer::selectTreballadors($idS); foreach ($TREBALLADORS as $idU => $T) { $C = new Criteria(); $C = self::getCriteriaActiu($C, $idS); $C->add(PersonalPeer::IDUSUARI, $idU); $C->add(PersonalPeer::IDDATA, date('Y-m-d', $datai), CRITERIA::GREATER_EQUAL); $C->add(PersonalPeer::IDDATA, date('Y-m-d', $dataf), CRITERIA::LESS_EQUAL); $C->add(PersonalPeer::DATA_BAIXA, NULL, Criteria::ISNULL); $C->addAscendingOrderByColumn(PersonalPeer::DATA_ALTA); $OU = UsuarisPeer::retrieveByPK($idU); $RET[$idU]['TREBALLADOR'] = $OU->getNomComplet(); //Busquem l'últim horari estàndard del treballador abans de les dates que mirem. $C2 = new Criteria(); $C2->add(PersonalPeer::IDUSUARI, $idU); $C2->add(PersonalPeer::TIPUS, PersonalPeer::HORARI_USUARI); $C2->addDescendingOrderByColumn(PersonalPeer::IDDATA); $C2->add(PersonalPeer::IDDATA, date('Y-m-d', $datai), Criteria::LESS_THAN); $C2->add(PersonalPeer::DATA_BAIXA, NULL, Criteria::ISNULL); $ULTIM_HORARI = self::doSelectOne($C2); if ($ULTIM_HORARI instanceof Personal) { $RET[$idU]['ULTIM_HORARI'] = $ULTIM_HORARI->getText(); } else { $RET[$idU]['ULTIM_HORARI'] = 'n/d'; } //Carreguem totes les línies que consten d'aquests dies foreach (self::doSelect($C) as $D) { list($YE, $MO, $DA) = explode('-', $D->getIddata()); $data = mktime(0, 0, 0, $MO, $DA, $YE); $RET[$D->getIdusuari()]['DIES'][$data][] = $D; } } return $RET; }