/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = UserInfo::find()->from(UserInfo::tableName() . ' t')->joinWith(['userinfo' => function ($q) {
$q->from(UserInfo::tableName() . ' parent');
}]);
if (Yii::$app->user->can('manager')) {
$query->where(array('t.manager' => Yii::$app->user->id));
}
if (Yii::$app->user->can('hrm')) {
$query->leftJoin('auth_assignment', 't.user_id = auth_assignment.user_id');
$query->where('auth_assignment.item_name <> "admin" ');
}
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['user_id' => $this->user_id, 'manager' => $this->manager]);
$query->andFilterWhere(['like', 't.first_name', $this->first_name])->andFilterWhere(['like', 't.last_name', $this->last_name])->andFilterWhere(['like', 't.full_name', $this->full_name])->andFilterWhere(['like', 't.phone', $this->phone])->andFilterWhere(['like', 't.email', $this->email])->andFilterWhere(['like', 't.position', $this->position]);
return $dataProvider;
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use backend\models\UserInfo;
use yii\helpers\ArrayHelper;
/* @var $this yii\web\View */
/* @var $model backend\models\UserDate */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="user-date-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'user_id')->dropDownList(ArrayHelper::map(UserInfo::find()->all(), 'user_id', 'full_name'), array('prompt' => '--Select a employee--'));
?>
<?php
echo $form->field($model, 'year')->dropDownList(array_combine(range(date('Y'), date('Y') + 10), range(date('Y'), date('Y') + 10)));
?>
<?php
echo $form->field($model, 'entitlement')->textInput();
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
