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