public function actionIndex() { $empDesignWise = []; if (Yii::$app->session->get('stu_id')) { return $this->redirect(['/employee/emp-master/index']); } //Department wise employee display $empDepWise = (new \yii\db\Query())->select(["CONCAT(dp.emp_department_name, ' (', COUNT( emp_master_id ), ')') AS '0'", 'COUNT(emp_master_id) AS "1"'])->from('emp_master em')->join('JOIN', 'emp_department dp', 'dp.emp_department_id = em.emp_master_department_id')->where(['em.is_status' => '0', 'dp.is_status' => '0'])->groupBy('em.emp_master_department_id')->all(); //Recently added student list $empRecent = (new \yii\db\Query())->select(['em.emp_master_id', 'emp_unique_id', "CONCAT(ei.emp_first_name, ' ', ei.emp_last_name) AS 'emp_name'", 'dp.emp_department_name', 'DATE_FORMAT(em.created_at, "%d-%m-%Y") AS cDate'])->from('emp_master em')->join('JOIN', 'emp_info ei', 'ei.emp_info_emp_master_id = em.emp_master_id')->join('JOIN', 'emp_department dp', 'dp.emp_department_id = em.emp_master_department_id')->where(['em.is_status' => '0'])->orderBy('emp_master_id DESC')->limit(10)->all(); /** * @Start Designation wise employee display */ $empDesignWise = (new \yii\db\Query())->select(["CONCAT(ds.emp_designation_name, ' (', COUNT( emp_master_id ), ')') AS '0'", 'COUNT(emp_master_id) AS "1"'])->from('emp_master em')->join('JOIN', 'emp_designation ds', 'ds.emp_designation_id = em.emp_master_designation_id')->where(['em.is_status' => '0'])->groupBy('emp_master_designation_id')->all(); $empDesignWiseNull = EmpMaster::find()->where(['is_status' => 0, 'emp_master_designation_id' => NULL])->count(); if (!empty($empDesignWiseNull)) { $empDesignWise[] = ['name' => 'Not Set (' . $empDesignWiseNull . ')', 'y' => $empDesignWiseNull, 'sliced' => true, 'selected' => true, 'color' => '#F45B5B']; } return $this->render('index', ['empDepWise' => $empDepWise, 'empRecent' => $empRecent, 'empDesignWise' => $empDesignWise]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = EmpMaster::find()->where(['is_status' => 0]); $query->joinWith(['empMasterEmpInfo', 'empMasterUser']); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['enableMultiSort' => true], 'sort' => ['defaultOrder' => ['emp_master_id' => SORT_DESC]]]); $dataProvider->sort->attributes['emp_unique_id'] = ['asc' => ['emp_info.emp_unique_id' => SORT_ASC], 'desc' => ['emp_info.emp_unique_id' => SORT_DESC]]; $dataProvider->sort->attributes['emp_first_name'] = ['asc' => ['emp_info.emp_first_name' => SORT_ASC], 'desc' => ['emp_info.emp_first_name' => SORT_DESC]]; $dataProvider->sort->attributes['emp_middle_name'] = ['asc' => ['emp_middle_name' => SORT_ASC], 'desc' => ['emp_middle_name' => SORT_DESC]]; $dataProvider->sort->attributes['emp_last_name'] = ['asc' => ['emp_last_name' => SORT_ASC], 'desc' => ['emp_last_name' => SORT_DESC]]; $dataProvider->sort->attributes['user_login_id'] = ['asc' => ['users.user_login_id' => SORT_ASC], 'desc' => ['users.user_login_id' => SORT_DESC]]; $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(['emp_master_id' => $this->emp_master_id, 'emp_master_emp_info_id' => $this->emp_master_emp_info_id, 'emp_master_user_id' => $this->emp_master_user_id, 'emp_master_department_id' => $this->emp_master_department_id, 'emp_master_designation_id' => $this->emp_master_designation_id, 'emp_master_category_id' => $this->emp_master_category_id, 'emp_master_nationality_id' => $this->emp_master_nationality_id, 'emp_master_emp_address_id' => $this->emp_master_emp_address_id, 'emp_master_status_id' => $this->emp_master_status_id, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by, 'is_status' => $this->is_status]); $query->andFilterWhere(['like', 'emp_info.emp_first_name', $this->emp_first_name])->andFilterWhere(['like', 'emp_info.emp_last_name', $this->emp_last_name])->andFilterWhere(['like', 'emp_info.emp_middle_name', $this->emp_middle_name])->andFilterWhere(['like', 'users.user_login_id', $this->user_login_id])->andFilterWhere(['like', 'emp_info.emp_unique_id', $this->emp_unique_id]); unset($_SESSION['exportData']); $_SESSION['exportData'] = $dataProvider; return $dataProvider; }
public function actionLogin() { $this->checkInstallation(); if (!\Yii::$app->user->isGuest) { return $this->goHome(); } $model = new LoginForm(); $login = new \app\models\LoginDetails(); if ($model->load(Yii::$app->request->post())) { $log = \app\models\User::find()->where(['user_login_id' => $_POST['LoginForm']['username'], 'is_block' => 0])->one(); if (empty($log)) { \Yii::$app->session->setFlash('loginError', '<i class="fa fa-warning"></i><b> Incorrect username or password. !</b>'); return $this->render('login', ['model' => $model]); } $login->login_user_id = $log['user_id']; $loginuser = $login->login_user_id; $emplogin = EmpMaster::find()->andWhere(['emp_master_user_id' => $loginuser])->one(); $studlogin = StuMaster::find()->andWhere(['stu_master_user_id' => $loginuser])->one(); if ($studlogin) { \Yii::$app->session->set('stu_id', $studlogin->stu_master_id); } else { if ($emplogin) { \Yii::$app->session->set('emp_id', $emplogin->emp_master_id); } else { if (!$emplogin && !$studlogin) { \Yii::$app->session->set('admin_user', $loginuser); } else { \Yii::$app->session->setFlash('loginError', '<i class="fa fa-warning"></i><b> These Login credentials are Blocked/Deactive by Admin</b>'); return $this->render('login', ['model' => $model]); } } } $login->login_status = 1; $login->login_at = new \yii\db\Expression('NOW()'); $login->user_ip_address = $_SERVER['REMOTE_ADDR']; $login->save(false); if ($model->login()) { if (!isset(Yii::$app->request->cookies['language'])) { return $this->redirect(['language']); } else { return $this->goBack(); } } else { return $this->render('login', ['model' => $model]); } } else { return $this->render('login', ['model' => $model]); } }
/** Use for update employee login user details. * @param integer $id the ID of the model to be update. */ public function actionUpdateemploginid($id) { $model = $this->findModel($id); $emp_data = EmpMaster::find()->where(['emp_master_user_id' => $id])->one(); $emp_info = EmpInfo::findOne($emp_data->emp_master_emp_info_id)->emp_first_name; if (isset($_POST['User'])) { $model->attributes = $_POST['User']; $model->user_login_id = $_POST['User']['user_login_id']; \Yii::$app->session->setFlash('resetemploginid', "<i class='glyphicon glyphicon-info-sign'></i> " . $emp_info . "'s Login id is Reset"); if ($model->save()) { \Yii::$app->session->setFlash('resetemploginid', "<i class='glyphicon glyphicon-info-sign'></i> " . $emp_info . "'s Login id is Reset"); return $this->redirect(['resetemploginid']); } } return $this->render('updateemploginid', ['model' => $model]); }
<div class="icon"> <i class="fa fa-toggle-on" style="font-size: 60px;"></i> </div> <?php echo Html::a('More Info <i class="fa fa-arrow-circle-right"></i>', ['/report/employee/empinforeport'], ['class' => 'small-box-footer']); ?> </div> </div> <!---Start Count Deactive Employee---> <div class="col-lg-3 col-xs-6"> <!-- small box --> <div class="small-box bg-red"> <div class="inner"> <h3><?php echo \app\modules\employee\models\EmpMaster::find()->where(['is_status' => 1])->count(); ?> </h3> <p>Deactive Employee</p> </div> <div class="icon"> <i class="fa fa-toggle-off" style="font-size: 60px;"></i> </div> <?php echo Html::a('More Info <i class="fa fa-arrow-circle-right"></i>', ['/report/employee/empinforeport'], ['class' => 'small-box-footer']); ?> </div> </div> </div>