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;
}
