/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = EmpDesignation::find()->where(['is_status' => 0]); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['emp_designation_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_designation_id' => $this->emp_designation_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_designation_name', $this->emp_designation_name])->andFilterWhere(['like', 'emp_designation_alias', $this->emp_designation_alias]); unset($_SESSION['exportData']); $_SESSION['exportData'] = $dataProvider; return $dataProvider; }
} else { if ($s == 'city') { if ($sd['emp_master_emp_address_id'] != 0) { $add = EmpAddress::findOne($sd['emp_master_emp_address_id']); if ($add->emp_cadd_city != null) { echo "<td class='text-center'>" . City::findOne($add->emp_cadd_city)->city_name . "</td>"; } else { echo "<td> </td>"; } } else { echo "<td> </td>"; } } else { if ($s == 'emp_designation_name') { if ($sd['emp_master_designation_id'] != null) { echo "<td class='text-center'>" . EmpDesignation::findOne($sd['emp_master_designation_id'])->emp_designation_name . "</td>"; } else { echo "<td> </td>"; } } else { if ($s == 'emp_category_name') { echo "<td class='text-center'>" . EmpCategory::findOne($sd['emp_master_category_id'])->emp_category_name . "</td>"; } else { if ($s == 'emp_cadd') { if ($sd['emp_master_emp_address_id'] != 0) { if (!empty(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_city)) { $add_c = "<br/>" . City::findOne(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_city)->city_name . ", "; } else { $add_c = ''; } if (!empty(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_state)) {
} else { if ($s == 'city') { if ($sd['emp_master_emp_address_id'] != 0) { $add = EmpAddress::findOne($sd['emp_master_emp_address_id']); if ($add->emp_cadd_city != null) { echo "<td style='align:center; valign:'middle';'>" . City::findOne($add->emp_cadd_city)->city_name . "</td>"; } else { echo "<td> </td>"; } } else { echo "<td> </td>"; } } else { if ($s == 'emp_designation_name') { if ($sd['emp_master_designation_id'] != null) { echo "<td style='align:center; valign:'middle';'>" . EmpDesignation::findOne($sd['emp_master_designation_id'])->emp_designation_name . "</td>"; } else { echo "<td> </td>"; } } else { if ($s == 'emp_category_name') { echo "<td style='align:center; valign:'middle';'>" . EmpCategory::findOne($sd['emp_master_category_id'])->emp_category_name . "</td>"; } else { if ($s == 'emp_cadd') { if ($sd['emp_master_emp_address_id'] != 0) { if (!empty(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_city)) { $add_c = "<br/>" . City::findOne(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_city)->city_name . ", "; } else { $add_c = ''; } if (!empty(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_state)) {
/** * @return \yii\db\ActiveQuery */ public function getEmpMasterDesignation() { return $this->hasOne(EmpDesignation::className(), ['emp_designation_id' => 'emp_master_designation_id']); }
<div class="row"> <div class="col-xs-12 col-sm-4 col-lg-4 form-group"> <?php echo Html::label('Department', '', ['class' => 'control-label']); ?> <span style='color:red;'> * </span> <?php echo Html::dropDownList('department', null, ArrayHelper::map(\app\modules\employee\models\EmpDepartment::find()->where(['is_status' => 0])->all(), 'emp_department_id', 'emp_department_name'), ['prompt' => 'Select Department', 'class' => 'form-control', 'required' => true]); ?> </div> <div class="col-xs-12 col-sm-4 col-lg-4 form-group"> <?php echo Html::label('Designation', '', ['class' => 'control-label']); ?> <?php echo Html::dropDownList('designation', null, ArrayHelper::map(\app\modules\employee\models\EmpDesignation::find()->where(['is_status' => 0])->all(), 'emp_designation_id', 'emp_designation_name'), ['prompt' => 'Select Designation', 'class' => 'form-control']); ?> </div> <div class="col-xs-12 col-sm-4 col-lg-4 form-group"> <?php echo Html::label('Category', ''); ?> <?php echo Html::dropDownList('category', null, ArrayHelper::map(\app\modules\employee\models\EmpCategory::find()->where(['is_status' => 0])->all(), 'emp_category_id', 'emp_category_name'), ['prompt' => 'Select Category', 'class' => 'form-control']); ?> </div> </div> <div class="row"> <div class="col-xs-12 col-sm-4 col-lg-4 form-group"> <?php echo Html::label('Gender', '');
/** * Finds the EmpDesignation model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return EmpDesignation the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = EmpDesignation::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
if (!empty($employee_data)) { $emp_info = new EmpInfo(); echo "</br></br><h3>" . Yii::t('report', 'Employee List') . "</h3>"; $i = 1; foreach ($employee_data as $t => $sd) { echo "<h3>" . $sd['emp_first_name'] . " " . $sd['emp_last_name'] . "</h3>"; echo "<table>"; echo '<tr>'; echo "<td class='label'>" . Yii::t('report', 'Sr.No') . "</td><td>" . $i . "</td>"; foreach ($selected_list as $s) { if ($s == 'emp_department_name') { echo "<tr><td class='label'>" . Yii::t('report', 'Department') . "</td><td>" . EmpDepartment::findOne($sd['emp_master_department_id'])->emp_department_name . "</td></tr>"; } else { if ($s == 'emp_designation_name') { if ($sd['emp_master_designation_id'] != null) { echo "<tr><td class='label'>" . Yii::t('report', 'Designation') . " </td><td class='text-center'>" . EmpDesignation::findOne($sd['emp_master_designation_id'])->emp_designation_name . "</td></tr>"; } else { echo "<tr><td> </td></tr>"; } } else { if ($s == 'emp_cadd') { if ($sd['emp_master_emp_address_id'] != 0) { echo "<tr><td class='label'>" . Yii::t('report', 'Local Address') . "</td>"; if (!empty(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_city)) { $add_c = "<br/>" . City::findOne(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_city)->city_name . ", "; } else { $add_c = ''; } if (!empty(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_state)) { $add_s = State::findOne(EmpAddress::findOne($sd['emp_master_emp_address_id'])->emp_cadd_state)->state_name . ", "; } else {