/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Usuarios::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id_usuario' => $this->id_usuario, 'data_nasc' => $this->data_nasc, 'id_tipo_usuario' => $this->id_tipo_usuario, 'ativo' => 1, 'criado_por' => $this->criado_por, 'criado_em' => $this->criado_em, 'modificado_por' => $this->modificado_por, 'modificado_em' => $this->modificado_em]); $query->andFilterWhere(['like', 'num_matricula', $this->num_matricula])->andFilterWhere(['like', 'nome_completo', $this->nome_completo])->andFilterWhere(['like', 'funcao', $this->funcao])->andFilterWhere(['like', 'setor', $this->setor])->andFilterWhere(['like', 'foto', $this->foto])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'senha', $this->senha]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Usuarios::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'id_provincia' => $this->id_provincia, 'id_pais' => $this->id_pais, 'fecha_registro' => $this->fecha_registro, 'fecha_conexion' => $this->fecha_conexion, 'fecha_modif' => $this->fecha_modif, 'id_estado' => $this->id_estado]); $query->andFilterWhere(['like', 'nombre_usuario', $this->nombre_usuario])->andFilterWhere(['like', 'contrasena', $this->contrasena])->andFilterWhere(['like', 'nombre', $this->nombre])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'estado_civil', $this->estado_civil])->andFilterWhere(['like', 'direccion', $this->direccion])->andFilterWhere(['like', 'numero_oficina', $this->numero_oficina])->andFilterWhere(['like', 'ciudad', $this->ciudad])->andFilterWhere(['like', 'provincia', $this->provincia])->andFilterWhere(['like', 'codigo_postal', $this->codigo_postal])->andFilterWhere(['like', 'numero_casa', $this->numero_casa])->andFilterWhere(['like', 'numero_trabajo', $this->numero_trabajo])->andFilterWhere(['like', 'numero_movil', $this->numero_movil])->andFilterWhere(['like', 'cargo_trabajo', $this->cargo_trabajo]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Usuarios::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->joinWith('departamento'); $query->joinWith('status'); $query->andFilterWhere(['fecha_suspension' => $this->fecha_suspension]); $query->andFilterWhere(['like', 'cedula', $this->cedula])->andFilterWhere(['like', 'nombre', $this->nombre])->andFilterWhere(['like', 'departamentos.descripcion', $this->id_departamento])->andFilterWhere(['like', 'status.descripcion_status', $this->id_status])->andFilterWhere(['like', 'email', $this->email]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Usuarios::find(); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails //$query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['idusuarios' => $this->idusuarios, 'email' => $this->email, 'permiso' => $this->permiso, 'fechaserver' => $this->fechaserver]); $query->andFilterWhere(['=', 'clave', $this->clave])->andFilterWhere(['=', 'usuario', $this->usuario]); $dataProvider = new ActiveDataProvider(['query' => $query]); if ($this->usuario != '' && $this->clave != '') { return $dataProvider; } else { return true; } }
public static function findByUsername($username) { /*foreach (self::$users as $user) { if (strcasecmp($user['username'], $username) === 0) { return new static($user); } }*/ /*$user = Usuarios::find() ->where(['usuario' => $username]) ->one(); return $user;*/ /*$query = new \yii\db\Query(); //$fecha_actual = date('Y-m-d'); $query->select('Usuario') ->from('usuarios') ->where('Usuario=:usuario',array(':usuario'=>$username)); $rows = $query->one(Usuarios::getDb()); return $rows;*/ $user = Usuarios::find()->where(['Usuario' => $username])->one(); return $user; }
<div class="estados-emocionais-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'id_tipo_estado_emocional')->dropdownList(ArrayHelper::map(TiposEstadosEmocionais::find()->where(['privado' => 0, 'ativo' => 1])->orderBy('nome')->all(), 'id_tipo_estado_emocional', 'nome'), ['prompt' => 'Selecione o tipo de estado emocional']); ?> <div style="<?php $model->scenario == 'update' ? print 'display: none' : ''; ?> "> <?php echo $form->field($model, 'id_usuario')->dropdownList(ArrayHelper::map(Usuarios::find()->where(['ativo' => 1])->orderBy('nome_completo')->all(), 'id_usuario', 'nome_completo'), ['prompt' => 'Selecione o usuário']); ?> <?php echo $form->field($model, 'motivo')->textarea(['maxlength' => true]); ?> </div> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Inserir' : 'Atualizar', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> <?php ActiveForm::end(); ?>
public function actionIndex() { $avisos = Avisos::getActiveAvisos(); $usuarios = Usuarios::find()->innerJoinWith('tipoUsuario')->where(["usuarios.ativo" => 1])->andWhere(['not', ["tipos_usuario.nome" => Yii::$app->params['Dev']]])->andWhere(['not', ["tipos_usuario.nome" => Yii::$app->params['Mural']]])->andWhere(['not', ["tipos_usuario.nome" => Yii::$app->params['Tablet']]])->orderBy(['nome_completo' => 'SORT_ASC'])->all(); return $this->render('index', ['usuarios' => $usuarios, 'avisos' => $avisos]); }
use yii\helpers\ArrayHelper; use app\models\Usuarios; /* @var $this yii\web\View */ /* @var $model app\models\GrupoUsuarios */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="grupo-usuarios-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'id_grupo_usuarios')->dropdownList(ArrayHelper::map(GrupoUsuarios::find()->where(['ativo' => 1])->orderBy('nome')->all(), 'id_grupo_usuarios', 'nome'), ['prompt' => 'Selecione o grupo', 'disabled' => 'disabled']); ?> <?php echo $form->field($model, 'usuarios')->widget(Select2::classname(), ['data' => ArrayHelper::map(Usuarios::find()->where(['ativo' => 1])->orderBy('nome_completo')->all(), 'id_usuario', 'nome_completo'), 'value' => ArrayHelper::map($model->usuarios, 'id_usuario', 'nome_completo'), 'options' => ['placeholder' => 'Selecione os usuários...'], 'pluginOptions' => ['allowClear' => true, 'multiple' => true]]); ?> <?php echo $form->field($model, 'id_grupo_usuarios')->hiddenInput()->label(false); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Incluir' : 'Salvar', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> <?php ActiveForm::end(); ?>
public static function getAdminsEmails() { $usuarios = Usuarios::find()->innerJoinWith('tipoUsuario')->where(["usuarios.ativo" => 1])->andWhere(["tipos_usuario.nome" => Yii::$app->params['Admin']])->all(); $emails = array(); foreach ($usuarios as $usuario) { $emails[$usuario->email] = $usuario->nome_completo; } return $emails; }