/**
* 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 {
