public function actionEmployeedataExportToExcel()
{
$des_name = "L.A.";
$designation = EmployeeDesignation::model()->findByAttributes(array('employee_designation_name' => $des_name, 'employee_designation_organization_id' => Yii::app()->user->getState('org_id')));
$des_id = $designation['employee_designation_id'];
if ($des_id) {
$org = Yii::app()->user->getState('org_id');
$emp_data = EmployeeTransaction::model()->findAll(array('condition' => 't.employee_transaction_designation_id <> :name and t.employee_transaction_organization_id = :org and employee_transaction_id IN(select employee_info_transaction_id from employee_info where employee_type =1)', 'params' => array(':name' => $des_id, ':org' => $org)));
if ($emp_data) {
$this->toExcel($emp_data, array('Rel_Emp_Info.title::Title', 'Rel_Emp_Info.employee_last_name::Surname', 'Rel_Emp_Info.employee_first_name::First Name', 'Rel_Emp_Info.employee_middle_name::Middle Name', 'Rel_Emp_Info.employee_gender::Gender', 'Rel_Emp_Info.employee_middle_name::Father Name', 'Rel_Emp_Info.employee_mother_name::Mother Name', 'Rel_Employee_Address.employee_address_c_line1::Address Line 1', 'Rel_Employee_Address.employee_address_c_line2::Address Line 2', 'Rel_Employee_Address.employee_address_c_pincode::Postal Code', 'Rel_Employee_Address.Rel_c_city.city_name::City/Village', 'Rel_Employee_Address.Rel_c_state.state_name::State', 'Rel_Religion.religion_name::Religion', 'Rel_Category.category_name::Caste', 'Rel_Emp_Info.employee_dob::Date of Birth', 'Rel_Emp_Info.employee_pancard_no::PAN', 'std_code::STD Code', 'landline::Land Line #', 'Rel_Emp_Info.employee_private_mobile::Mobile Phone #', 'Rel_Emp_Info.employee_private_email::Email Address', 'fax_phone::Fax Phone #', 'Rel_Designation.employee_designation_name::Exact Designation', 'applointment::Appointment FT/PT', 'gross_per_month::Gross Pay Per Month', 'appointment_type::Appointment Type', 'faculty_type::Faculty Type', 'payscale::PayScale', 'programme::Programme', 'course::Course', 'salary_mode::Salary Mode', 'pf_number::PF Number', 'Rel_Emp_Info.employee_joining_date::Date of Joining', 'doctrate_degree::Doctorate Degree', 'pg_degree::PG Degree', 'ug_degree::UG Degree', 'other_qualification::Other Qualification', 'area_specialization::Area Of Specialization', 'teaching_exp::Teaching Experiece In Years', 'total_exp::Total Experiece In Years', 'research_exp::Research Experience in Years', 'Rel_Emp_Info.employee_account_no::BankAccountNumber', 'bank_name::BankName', 'bank_branch_name::Bank Branch Name', 'ifsc_code::IFSC Code', 'national_publication::National Publications', 'patent::Patents', 'no_pg_prj_guided::No. Of PG Project Guided:', 'no_dr_prj_guided::No. Of PG Doctorate Guided', 'international_publication::International Publications', 'no_of_books_pub::No Of books Published', 'Physical_hd::Is Physically handicapped', 'minority_indicator::Minority Indicator', 'fy_teacher::First Yr Teacher', 'fy_common_teacher::FY/Common Subject Teacher?', 'fy_common_subject::FY/Common Subject', 'expert_mem_aicte::Would you like to work as Expert Member on various committees of AICTE', 'aicte_grant_apply::Have you ever applied to AICTE for any grants/assistance', 'basic_pay_rs::Basic Pay in Rs.', 'da::DA %', 'hra_rs::HRA in Rs.', 'other_allowance_rs::Other Allowances in Rs.'), 'Employeedata', array('creator' => 'Rudrasoftech'), 'Excel5');
} else {
echo "No data Found" . "</br>";
echo CHtml::link('GO BACK', Yii::app()->createUrl('/site/newdashboard'));
break;
}
} else {
echo "No data Found" . "</br>";
echo CHtml::link('GO BACK', Yii::app()->createUrl('/site/newdashboard'));
break;
}
}
/**
* Generate array for dropdown list to use in child form.
* @return array $_items
*/
public static function items()
{
self::$_items = CHtml::listData(self::model()->findAll(), 'employee_designation_id', 'employee_designation_name');
return self::$_items;
}
<?php
}
if (Yii::app()->user->hasFlash('success')) {
?>
<div class="flash-success">
<?php
echo Yii::app()->user->getFlash('success');
?>
</div>
<?php
}
?>
</div>
<?php
$dataProvider = $model->search();
if (Yii::app()->user->getState("pageSize", @$_GET["pageSize"])) {
$pageSize = Yii::app()->user->getState("pageSize", @$_GET["pageSize"]);
} else {
$pageSize = Yii::app()->params['pageSize'];
}
$dataProvider->getPagination()->setPageSize($pageSize);
?>
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'employee-transaction-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'ajaxUpdate' => false, 'columns' => array(array('header' => 'SI No', 'class' => 'IndexColumn'), array('header' => 'Employee No', 'name' => 'employee_no', 'value' => '$data->Rel_Emp_Info->employee_no'), array('header' => 'Attendence Card No', 'name' => 'employee_attendance_card_id', 'value' => '$data->Rel_Emp_Info->employee_attendance_card_id'), array('header' => 'Name', 'name' => 'employee_first_name', 'value' => '$data->Rel_Emp_Info->employee_first_name'), array('header' => 'Surname', 'name' => 'employee_last_name', 'value' => '$data->Rel_Emp_Info->employee_last_name'), array('header' => 'Designation', 'name' => 'employee_transaction_designation_id', 'value' => 'EmployeeDesignation::model()->findByPk($data->employee_transaction_designation_id)->employee_designation_name', 'filter' => CHtml::listData(EmployeeDesignation::model()->findAll(array('condition' => 'employee_designation_organization_id=' . Yii::app()->user->getState('org_id'))), 'employee_designation_id', 'employee_designation_name')), array('header' => 'Department', 'name' => 'employee_transaction_department_id', 'value' => 'Department::model()->findByPk($data->employee_transaction_department_id)->department_name', 'filter' => CHtml::listData(Department::model()->findAll(array('condition' => ' department_organization_id=' . Yii::app()->user->getState('org_id'))), 'department_id', 'department_name')), array('header' => 'Shift', 'name' => 'employee_transaction_shift_id', 'value' => 'Shift::model()->findByPk($data->employee_transaction_shift_id)->shift_type', 'filter' => CHtml::listData(Shift::model()->findAll(array('condition' => ' shift_organization_id=' . Yii::app()->user->getState('org_id'))), 'shift_id', 'shift_type')), array('type' => 'raw', 'value' => 'CHtml::image("../emp_images/" . $data->Rel_Photo->employee_photos_path, "No Image",array("width"=>"20px","height"=>"20px"))'), array('class' => 'MyCButtonColumn', 'template' => '{update} {delete}')), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => '')));
public function actionTechnicalstaffdataExportToExcel()
{
$des_name = "L.A.";
$designation = EmployeeDesignation::model()->findByAttributes(array('employee_designation_name' => $des_name, 'employee_designation_organization_id' => Yii::app()->user->getState('org_id')));
$des_id = $designation['employee_designation_id'];
if ($des_id) {
$emp_data = EmployeeTransaction::model()->findAll('employee_transaction_organization_id = ' . Yii::app()->user->getState('org_id') . ' AND employee_transaction_designation_id = ' . $des_id);
if ($emp_data) {
$this->toExcel($emp_data, array('Rel_Emp_Info.title::Title', 'Rel_Emp_Info.employee_first_name::First Name', 'Rel_Emp_Info.employee_middle_name::Middle Name', 'Rel_Emp_Info.employee_last_name::Surname', 'Rel_Emp_Info.employee_mother_name::Mother Name', 'Rel_Emp_Info.employee_middle_name::Father Name', 'Rel_Employee_Address.employee_address_c_line1::Address Line 1', 'Rel_Employee_Address.employee_address_c_line2::Address Line 2', 'Rel_Employee_Address.Rel_c_city.city_name::City/Village', 'Rel_Employee_Address.Rel_c_state.state_name::State', 'Rel_Employee_Address.employee_address_c_pincode::Postal Code', 'res_phone::Res Phone', 'Rel_Emp_Info.employee_private_mobile::Mobile Phone #', 'Rel_Emp_Info.employee_dob::Date of Birth', 'Rel_Emp_Info.employee_gender::Gender', 'programme::Program', 'course::Course', 'level::Level', 'Rel_Department.department_name::Department', 'phd::PhD', 'master_degree::Master Degree', 'bachelor_degree::Bachelor Degree', 'diploma::Diploma', 'other::Other', 'Rel_Designation.employee_designation_name::Exact Designation', 'appointment_type::Appointment Type', 'Rel_Emp_Info.employee_joining_date::Date of Joining the Institute', 'pf_number::PF Number', 'salary_type::Salary Type', 'salary_mode::Salary Mode', 'gross_per_month::Gross Pay Per Month', 'bank_name::Bank Name', 'Rel_Emp_Info.employee_account_no::Bank Account Number', 'ifsc_code::IFSC Code', 'Rel_Emp_Info.employee_pancard_no::PAN Number'), 'TechnicalStaffExcel', array('creator' => 'Rudrasoftech'), 'Excel2007');
} else {
echo "No data Found" . "</br>";
echo CHtml::link('GO BACK', Yii::app()->createUrl('/site/newdashboard'));
break;
}
} else {
echo "No data Found" . "</br>";
echo CHtml::link('GO BACK', Yii::app()->createUrl('/site/newdashboard'));
break;
}
}
}
else if($s=='city')
{
if($sd['employee_transaction_emp_address_id'] !=0)
{
$add = EmployeeAddress::model()->findByPk($sd['employee_transaction_emp_address_id']);
if($add->employee_address_c_city != null)
echo "<td>".City::model()->findByPk($add->employee_address_c_city)->city_name."</td>";
else
echo "<td> </td>";
}
else
echo "<td> </td>";
}
else if($s=='employee_refer_designation')
echo "<td>".EmployeeDesignation::model()->findByPk($sd['employee_transaction_designation_id'])->employee_designation_name."</td>";
else if($s=='employee_type'){
$ty = ($sd[$s]==1) ? "Teaching" : "Non-teaching";
echo "<td>".$ty."</td>";
}
else
{
echo "<td>".$sd[$s]."</td>";
}
}
$i++;
echo "</tr>";
}
?>
<span class="status"> </span>
<?php
echo $form->error($info, 'employee_type');
?>
</div>
</div>
<div class="row">
<div class="row-left">
<?php
echo $form->labelEx($model, 'employee_transaction_designation_id');
?>
<?php
echo $form->dropDownList($model, 'employee_transaction_designation_id', EmployeeDesignation::items(), array('empty' => 'Select Designation'));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'employee_transaction_designation_id');
?>
</div>
<div class="row-right">
<?php
echo $form->labelEx($model, 'employee_transaction_department_id');
?>
<?php
echo $form->dropDownList($model, 'employee_transaction_department_id', Department::items(), array('empty' => 'Select Department'));
?>
<span class="status"> </span>
<?php
foreach($selected_list as $key=>$value)
{
if($key == "employee_first_name") {
$mname = substr($emp['employee_middle_name'], 0, 1);
$mname = $mname.".";
echo '<div class="name">'.$emp['employee_first_name']." ".$mname." ".$emp['employee_last_name'].'</div>';
}
?>
<?php
if($key=='department_name')
$field_value = Department::model()->findByPk($emp['employee_transaction_department_id'])->department_name;
else if($key=='employee_designation')
$field_value = EmployeeDesignation::model()->findByPk($emp['employee_transaction_designation_id'])->employee_designation_name;
else if($key=='employee_address_c_line1')
{
if(!empty($emp['employee_transaction_emp_address_id'])) {
$curr_data = EmployeeAddress::model()->findByPk($emp['employee_transaction_emp_address_id']);
$line1 = $curr_data->employee_address_c_line1;
$line2 = $curr_data->employee_address_c_line2;
if(!empty($curr_data->employee_address_c_city))
$city = City::model()->findByPk($curr_data->employee_address_c_city)->city_name;
$pin = $curr_data->employee_address_c_pincode;
if(!empty($curr_data->employee_address_c_state))
$state = State::model()->findByPk($curr_data->employee_address_c_state)->state_name;
'header' => 'Name',
'name' => 'employee_first_name',
'value' => '$data->Rel_Emp_Info->employee_first_name',
),
array(
'header' => 'Surname',
'name' => 'employee_last_name',
'value' => '$data->Rel_Emp_Info->employee_last_name',
),
array(
'header' => 'Designation',
'name'=>'employee_transaction_designation_id',
'value'=>'EmployeeDesignation::model()->findByPk($data->employee_transaction_designation_id)->employee_designation_name',
'filter' =>CHtml::listData(EmployeeDesignation::model()->findAll(),
'employee_designation_id','employee_designation_name'),
),
array(
'header' => 'Department',
'name'=>'employee_transaction_department_id',
'value'=>'Department::model()->findByPk($data->employee_transaction_department_id)->department_name',
'filter' =>CHtml::listData(Department::model()->findAll(),'department_id','department_name'),
),
array(
'header'=>'Organization Number',
'name'=>'employee_organization_mobile',
'value'=>'$data->Rel_Emp_Info->employee_organization_mobile',
'filter'=>false,
<?php
$this->breadcrumbs = array('Employee' => array('admin'), 'Contact');
$this->menu = array();
?>
<h1>Employees Contact</h1>
<?php
$dataProvider = $model->search();
if (Yii::app()->user->getState("pageSize", @$_GET["pageSize"])) {
$pageSize = Yii::app()->user->getState("pageSize", @$_GET["pageSize"]);
} else {
$pageSize = Yii::app()->params['pageSize'];
}
$dataProvider->getPagination()->setPageSize($pageSize);
?>
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'employee-transaction-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'ajaxUpdate' => false, 'columns' => array(array('header' => 'SI No', 'class' => 'IndexColumn'), array('header' => 'Attendence Card No', 'name' => 'employee_attendance_card_id', 'value' => '$data->Rel_Emp_Info->employee_attendance_card_id'), array('header' => 'Name', 'name' => 'employee_first_name', 'value' => '$data->Rel_Emp_Info->employee_first_name'), array('header' => 'Surname', 'name' => 'employee_last_name', 'value' => '$data->Rel_Emp_Info->employee_last_name'), array('header' => 'Designation', 'name' => 'employee_transaction_designation_id', 'value' => 'EmployeeDesignation::model()->findByPk($data->employee_transaction_designation_id)->employee_designation_name', 'filter' => CHtml::listData(EmployeeDesignation::model()->findAll(array('condition' => 'employee_designation_organization_id=' . Yii::app()->user->getState('org_id'))), 'employee_designation_id', 'employee_designation_name')), array('header' => 'Department', 'name' => 'employee_transaction_department_id', 'value' => 'Department::model()->findByPk($data->employee_transaction_department_id)->department_name', 'filter' => CHtml::listData(Department::model()->findAll(array('condition' => ' department_organization_id=' . Yii::app()->user->getState('org_id'))), 'department_id', 'department_name')), array('header' => 'Organization Number', 'name' => 'employee_organization_mobile', 'value' => '$data->Rel_Emp_Info->employee_organization_mobile', 'filter' => false), array('header' => 'Private Number', 'name' => 'employee_private_mobile', 'value' => '$data->Rel_Emp_Info->employee_private_mobile', 'filter' => false)), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => '')));
<td>
<?php
echo EmployeeInfo::model()->findByPk($v['employee_transaction_employee_id'])->employee_first_name;
?>
</td>
<td>
<?php
echo EmployeeInfo::model()->findByPk($v['employee_transaction_employee_id'])->employee_last_name;
?>
</td>
<td>
<?php
echo EmployeeDesignation::model()->findByPk($v['employee_transaction_designation_id'])->employee_designation_name;
?>
</td>
<td>
<?php
echo Department::model()->findByPk($v['employee_transaction_department_id'])->department_name;
?>
</td>
<td>
<?php
echo Shift::model()->findByPk($v['employee_transaction_shift_id'])->shift_type;
?>
</td>
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'employee_transaction_department_id');
?>
</div>
</div>
<div class="row">
<div class="row-left">
<?php
echo $form->labelEx($model, 'employee_transaction_designation_id');
?>
<?php
echo $form->dropDownList($model, 'employee_transaction_designation_id', EmployeeDesignation::items(), array('empty' => '-----------Select---------', 'tabindex' => 7));
?>
<span class="status"> </span>
<?php
echo $form->error($model, 'employee_transaction_designation_id');
?>
</div>
<div class="row-left">
<?php
echo $form->labelEx($info, 'employee_faculty_of');
?>
<?php
echo $form->textField($info, 'employee_faculty_of');
?>
<span class="status"> </span>
<?php
array( 'name'=>'employee_first_name', 'value'=>'$data->rel_emp_info->employee_first_name', ), array( 'name'=>'employee_last_name', 'value'=>'$data->rel_emp_info->employee_last_name', ), array( 'name'=>'employee_attendance_card_id', 'value'=>'$data->rel_emp_info->employee_attendance_card_id', ), array( 'name'=>'employee_transaction_designation_id', 'value'=>'EmployeeDesignation::model()->findByPk($data->rel_emp_tran->employee_transaction_designation_id)->employee_designation_name', 'filter'=>CHtml::listData(EmployeeDesignation::model()->findAll(),'employee_designation_id','employee_designation_name'), ), 'student_attendence_email_minute', 'student_attendence_email_hour', array( 'class'=>'MyCButtonColumn', ), ), 'pager'=>array( 'class'=>'AjaxList', 'maxButtonCount'=>$model->count(), 'header'=>'' ), )); ?></div>
?>
<tr>
<td>
<?php echo ++$i; ?>
</td>
<td>
<?php echo EmployeeInfo::model()->findByAttributes(array(
'employee_info_transaction_id' => $v['student_attendence_email_emp_id']))->employee_first_name; ?>
</td>
<td>
<?php echo EmployeeInfo::model()->findByAttributes(array(
'employee_info_transaction_id' => $v['student_attendence_email_emp_id']))->employee_last_name; ?>
</td>
<td>
<?php echo EmployeeDesignation::model()->findByPk(EmployeeTransaction::model()->findByPk($v['student_attendence_email_emp_id'])->employee_transaction_designation_id)->employee_designation_name;?>
</td>
<td>
<?php echo ($v['student_attendence_email_branch_id']==0)?"All Branch":Branch::model()->findByPk($v['student_attendence_email_branch_id'])->branch_name; ?>
</td>
<td>
<?php echo $v['student_attendence_email_minute']; ?>
</td>
<td>
<?php echo $v['student_attendence_email_hour']; ?>
</td>
<td>
<?php echo User::model()->findByPk($v['student_attendence_email_created_by'])->user_organization_email_id; ?>
</td>
<td>
),
));
?><span class="status"> </span>
<?php echo $form->error($info,'employee_joining_date'); ?>
</div>
<div class="row-right">
<?php echo $form->labelEx($info,'employee_type'); ?>
<?php echo $form->dropDownList($info,'employee_type',array(""=>"Select Type","1"=>"Teaching","0"=>"Non Teaching")); ?><span class="status"> </span>
<?php echo $form->error($info,'employee_type'); ?>
</div>
</div>
<div class="row">
<div class="row-left">
<?php echo $form->labelEx($model,'employee_transaction_designation_id'); ?>
<?php echo $form->dropDownList($model,'employee_transaction_designation_id',EmployeeDesignation::items(), array('empty' => 'Select Designation')); ?><span class="status"> </span>
<?php echo $form->error($model,'employee_transaction_designation_id'); ?>
</div>
<div class="row-right">
<?php echo $form->labelEx($model,'employee_transaction_department_id'); ?>
<?php echo $form->dropDownList($model,'employee_transaction_department_id',Department::items(), array('empty' => 'Select Department')); ?><span class="status"> </span>
<?php echo $form->error($model,'employee_transaction_department_id'); ?>
</div>
</div>
<div class="row">
<div class="row-left">
<?php echo $form->labelEx($info,'employee_private_mobile'); ?>
<?php echo $form->textField($info,'employee_private_mobile',array('size'=>13)); ?><span class="status"> </span><br><br>
<?php echo $form->error($info,'employee_private_mobile'); ?>
</div>
}
} else {
if ($s == 'city') {
if ($sd['employee_transaction_emp_address_id'] != 0) {
$add = EmployeeAddress::model()->findByPk($sd['employee_transaction_emp_address_id']);
if ($add->employee_address_c_city != null) {
echo "<td style='text-align:center;'>" . City::model()->findByPk($add->employee_address_c_city)->city_name . "</td>";
} else {
echo "<td> </td>";
}
} else {
echo "<td> </td>";
}
} else {
if ($s == 'employee_refer_designation') {
echo "<td style='text-align:center;'>" . EmployeeDesignation::model()->findByPk($sd['employee_transaction_designation_id'])->employee_designation_name . "</td>";
} else {
echo "<td style='text-align:center;'>" . $sd[$s] . "</td>";
}
}
}
}
}
$i++;
$m++;
echo "</tr>";
}
echo "</table>";
echo "</div>";
} else {
print "<h1 style=\"color:red;text-align:center\">No Record To Display</h1>";
'value'=> EmployeeInfo::model()->findByAttributes(array(
'employee_info_transaction_id' => $model->student_attendence_email_emp_id))->employee_first_name,
),
array(
'name'=>'employee_last_name',
'value'=> EmployeeInfo::model()->findByAttributes(array(
'employee_info_transaction_id' => $model->student_attendence_email_emp_id))->employee_last_name,
),
array(
'name'=>'branch_name',
'value'=> ($model->student_attendence_email_branch_id==0)?"All Branch":Branch::model()->findByPk($model->student_attendence_email_branch_id)->branch_name,
),
array(
'name'=>'employee_transaction_designation_id',
'value'=> EmployeeDesignation::model()->findByPk($model->rel_emp_tran->employee_transaction_designation_id)->employee_designation_name,
),
'student_attendence_email_minute',
'student_attendence_email_hour',
array(
'name'=>'student_attendence_email_org_id',
'value'=> Organization::model()->findByPk($model->student_attendence_email_org_id)->organization_name,
),
array(
'name'=>'student_attendence_email_created_by',
'value'=> User::model()->findByPk($model->student_attendence_email_created_by)->user_organization_email_id,
),
array(
'name'=>'student_attendence_email_creation_date',
'value'=>date_format(new DateTime($model->student_attendence_email_creation_date), 'd-m-Y'),
</div>
<?php
}
?>
</div>
<div class="portlet box blue">
<div class="portlet-title"> Employee List
</div>
<?php
echo CHtml::link('Add New +', array('employeeTransaction/create'), array('class' => 'btn green'));
?>
<?php
$dataProvider = $model->search();
if (Yii::app()->user->getState("pageSize", @$_GET["pageSize"])) {
$pageSize = Yii::app()->user->getState("pageSize", @$_GET["pageSize"]);
} else {
$pageSize = Yii::app()->params['pageSize'];
}
$dataProvider->getPagination()->setPageSize($pageSize);
?>
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'employee-transaction-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'ajaxUpdate' => false, 'selectionChanged' => "function(id){\n\t\twindow.location='" . Yii::app()->urlManager->createUrl('employee/employeeTransaction/update', array('id' => '')) . "' + \$.fn.yiiGridView.getSelection(id);\n\t}", 'columns' => array(array('header' => 'SI No', 'class' => 'IndexColumn'), array('header' => 'Employee No', 'name' => 'employee_no', 'value' => '$data->Rel_Emp_Info->employee_no'), array('header' => 'Attendence Card No', 'name' => 'employee_attendance_card_id', 'value' => '$data->Rel_Emp_Info->employee_attendance_card_id'), array('header' => 'Name', 'name' => 'employee_first_name', 'value' => '$data->Rel_Emp_Info->employee_first_name'), array('header' => 'Surname', 'name' => 'employee_last_name', 'value' => '$data->Rel_Emp_Info->employee_last_name'), array('header' => 'Designation', 'name' => 'employee_transaction_designation_id', 'value' => 'EmployeeDesignation::model()->findByPk($data->employee_transaction_designation_id)->employee_designation_name', 'filter' => CHtml::listData(EmployeeDesignation::model()->findAll(), 'employee_designation_id', 'employee_designation_name')), array('header' => 'Department', 'name' => 'employee_transaction_department_id', 'value' => 'Department::model()->findByPk($data->employee_transaction_department_id)->department_name', 'filter' => CHtml::listData(Department::model()->findAll(), 'department_id', 'department_name')), array('type' => 'raw', 'value' => 'CHtml::image(Yii::app()->baseUrl."/college_data/emp_images/" . $data->Rel_Photo->employee_photos_path, "No Image",array("width"=>"20px","height"=>"20px"))')), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => '')));
?>
</div>
echo "<tr><td class='label'>City</td>";
if($sd['employee_transaction_emp_address_id'] !=0)
{
$add = EmployeeAddress::model()->findByPk($sd['employee_transaction_emp_address_id']);
if($add->employee_address_c_city != null)
echo "<td>".City::model()->findByPk($add->employee_address_c_city)->city_name."</td></tr>";
else
echo "<td> </td></tr>";
}
else
echo "<td> </td></tr>";
}
else if($s=='employee_bloodgroup_bloodgroup')
echo "<tr><td class='label'>Blood Group</td><td>".$sd[$s]."</td></tr>";
else if($s=='employee_refer_designation')
echo "<tr><td class='label'>Designation</td><td>".EmployeeDesignation::model()->findByPk($sd['employee_transaction_designation_id'])->employee_designation_name."</td></tr>";
else if($s=='employee_type'){
$ty = ($sd[$s]==1) ? "Teaching" : "Non-teaching";
echo "<tr><td class='label'>Type</td><td>".$ty."</td></tr>";
}
else
echo "<tr><td class='label'>".CHtml::activeLabel($emp_info,$s)." </td><td>".$sd[$s]."</td></tr>";
}
echo "</table><h1> </h1>";
$i++;
foreach($resign_emp_data as $list)
{
$emp_info = EmployeeInfo::model()->resetScope()->findByAttributes(array('employee_info_transaction_id'=>$list['employee_transaction_id']));
$emp_level_max = Yii::app()->db->createCommand()
->select('MAX(reporting_priority),employee_exit_reporting_employee_id')
->from('employee_exit_reporting')
->group('employee_exit_employee_id')
->where('employee_exit_employee_id ='.$list['employee_transaction_id'])
->queryRow();
$max_priority = $emp_level_max['MAX(reporting_priority)'];
$reporting_emp_id = EmployeeExitReporting::model()->findByAttributes(array('employee_exit_employee_id'=>$list['employee_transaction_id'],'reporting_priority'=>$max_priority));
$report_emp = $reporting_emp_id['employee_exit_reporting_employee_id'];
$exit_details = EmployeeExitDetails::model()->findByAttributes(array('employee_exit_details_employee_id'=>$list['employee_transaction_id'],'reporting_employee_id'=>$report_emp,'reporting_employee_review_status'=>2));
$app_date = $exit_details['employee_resign_application_date'];
?>
<tr>
<td><?php echo $emp_info['employee_first_name']?></td>
<td><?php echo $emp_info['employee_last_name']?></td>
<td><?php echo $emp_info['employee_attendance_card_id']?></td>
<td><?php echo EmployeeDesignation::model()->findByPk($list['employee_transaction_designation_id'])->employee_designation_name;?></td>
<td><?php echo Department::model()->findByPk($list['employee_transaction_department_id'])->department_name;?></td>
<td><?php echo Shift::model()->findByPk($list['employee_transaction_shift_id'])->shift_type;?></td>
<td><?php echo $emp_info['employee_left_transfer_date'];?></td>
<td><?php echo $app_date;?></td>
</tr>
<?php
}
?>
</table>
'name' => 'employee_attendance_card_id',
'value' => '$data->Rel_Emp_Info->employee_attendance_card_id',
),
array(
'header' => 'Name',
'name' => 'employee_first_name',
'value' => '$data->Rel_Emp_Info->employee_first_name',
),
array(
'header' => 'Surame',
'name' => 'employee_last_name',
'value' => '$data->Rel_Emp_Info->employee_last_name',
),
array('name' => 'employee_transaction_designation_id',
'filter'=>EmployeeDesignation::items(),
'value' =>'EmployeeDesignation::model()->findByPk($data->employee_transaction_designation_id)->employee_designation_name',
),
array('name' => 'employee_transaction_department_id',
'filter'=>Department::items(),
'value' => 'Department::model()->findByPk($data->employee_transaction_department_id)->department_name',
),
array(
'header' => 'Private Mobile',
'name' => 'employee_private_mobile',
'value' => '$data->Rel_Emp_Info->employee_private_mobile',
),
array(
'header' => 'Private Email',
'name' => 'employee_private_email',
<?php
$this->breadcrumbs = array('Reset Employee Login ID');
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('user-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>
<h1>Reset Employee Login ID</h1>
<div class="portlet box blue">
<div class="portlet-title"> Employee List
</div>
<?php
$dataProvider = $model->search();
if (Yii::app()->user->getState("pageSize", @$_GET["pageSize"])) {
$pageSize = Yii::app()->user->getState("pageSize", @$_GET["pageSize"]);
} else {
$pageSize = Yii::app()->params['pageSize'];
}
$dataProvider->getPagination()->setPageSize($pageSize);
?>
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'employee-transaction-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'ajaxUpdate' => false, 'columns' => array(array('header' => 'SI No', 'class' => 'IndexColumn'), array('header' => 'Employee No', 'name' => 'employee_no', 'value' => '$data->Rel_Emp_Info->employee_no'), array('header' => 'Attendence Card No', 'name' => 'employee_attendance_card_id', 'value' => '$data->Rel_Emp_Info->employee_attendance_card_id'), array('header' => 'Name', 'name' => 'employee_first_name', 'value' => '$data->Rel_Emp_Info->employee_first_name'), array('header' => 'Surname', 'name' => 'employee_last_name', 'value' => '$data->Rel_Emp_Info->employee_last_name'), array('header' => 'Designation', 'name' => 'employee_transaction_designation_id', 'value' => 'EmployeeDesignation::model()->findByPk($data->employee_transaction_designation_id)->employee_designation_name', 'filter' => CHtml::listData(EmployeeDesignation::model()->findAll(), 'employee_designation_id', 'employee_designation_name')), array('header' => 'Department', 'name' => 'employee_transaction_department_id', 'value' => 'Department::model()->findByPk($data->employee_transaction_department_id)->department_name', 'filter' => CHtml::listData(Department::model()->findAll(), 'department_id', 'department_name')), array('class' => 'CButtonColumn', 'template' => '{Reset Loginid}', 'buttons' => array('Reset Loginid' => array('label' => 'Reset login id', 'url' => 'Yii::app()->createUrl("user/updateemploginid", array("id"=>$data->Rel_user1->user_id))', 'imageUrl' => Yii::app()->baseUrl . '/images/Reset Password.png')))), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $model->count(), 'header' => '')));
?>
</div>
private static function loadItems()
{
self::$_items = array();
$models = self::model()->findAll();
foreach ($models as $model) {
self::$_items[$model->employee_designation_id] = $model->employee_designation_name;
}
}
<?php
$EmployeeInfo = EmployeeInfo::model()->findByPk($employee_transaction[0]->employee_transaction_employee_id);
if ($employee_transaction[0]->employee_transaction_category_id != null) {
$Category = Category::model()->findByPk($employee_transaction[0]->employee_transaction_category_id);
} else {
$Category = new Category();
}
if ($employee_transaction[0]->employee_transaction_religion_id != null) {
$Religion = Religion::model()->findByPk($employee_transaction[0]->employee_transaction_religion_id);
} else {
$Religion = new Religion();
}
$Shift = Shift::model()->findByPk($employee_transaction[0]->employee_transaction_shift_id);
$EmployeeDesignation = EmployeeDesignation::model()->findByPk($employee_transaction[0]->employee_transaction_designation_id);
if ($employee_transaction[0]->employee_transaction_nationality_id != null) {
$Nationality = Nationality::model()->findByPk($employee_transaction[0]->employee_transaction_nationality_id);
} else {
$Nationality = new Nationality();
}
$Department = Department::model()->findByPk($employee_transaction[0]->employee_transaction_department_id);
if ($employee_transaction[0]->employee_transaction_languages_known_id != null) {
$LanguagesKnown = LanguagesKnown::model()->findByPk($employee_transaction[0]->employee_transaction_languages_known_id);
}
$Organization = Organization::model()->findByPk($employee_transaction[0]->employee_transaction_organization_id);
if ($employee_transaction[0]->employee_transaction_emp_address_id != null) {
$EmployeeAddress = EmployeeAddress::model()->findByPk($employee_transaction[0]->employee_transaction_emp_address_id);
} else {
$EmployeeAddress = new EmployeeAddress();
}
?>
{
$trans = EmployeeTransaction::model()->findByPk($emp_info->employee_info_transaction_id);
$titl = "<b>".$emp_info->title."</b>";
$name = "<b>".$emp_info->employee_first_name." ".$emp_info->employee_middle_name." ".$emp_info->employee_last_name."</b>";
$attendence_no = "<b>".$attendence_no."</b>";
$gender = "<b>".$emp_info->employee_gender."</b>";
$emobile = "<b>".$emp_info->employee_private_mobile."</b>";
if($trans->employee_transaction_department_id !=0)
$department = "<b>".Department::model()->findByPk($trans->employee_transaction_department_id)->department_name."</b>";
else
$department = "<b>not set</b>";
if($trans->employee_transaction_designation_id !=0)
$designation = "<b>".EmployeeDesignation::model()->findByPk($trans->employee_transaction_designation_id)->employee_designation_name."</b>";
else
$designation = "<b>not set</b>";
$lin1 = "<b>not set</b>";
$lin2 = "<b>not set</b>";
$ct = "<b>not set</b>";
$stat = "<b>not set</b>";
$pc = "<b>not set</b>";
if($trans->employee_transaction_emp_address_id !=0)
{
$address = EmployeeAddress::model()->findByPk($trans->employee_transaction_emp_address_id);
$lin1 = "<b>".$address->employee_address_c_line1."</b>";
$lin2 = "<b>".$address->employee_address_c_line2."</b>";
$pc = "<b>".$address->employee_address_c_pincode."</b>";
public function actiongettransferempdata()
{
$des = array();
$dep = array();
$shf = array();
$org_id = $_REQUEST['EmployeeTransaction']['employee_transaction_organization_id'];
$data1 = EmployeeDesignation::model()->findAll(array('condition' => 'employee_designation_organization_id=' . (int) $org_id));
$data2 = Department::model()->findAll(array('condition' => 'department_organization_id=' . (int) $org_id));
$data3 = Shift::model()->findAll(array('condition' => 'shift_organization_id=' . (int) $org_id));
$data1 = CHtml::listData($data1, 'employee_designation_id', 'employee_designation_name');
$data2 = CHtml::listData($data2, 'department_id', 'department_name');
$data3 = CHtml::listData($data3, 'shift_id', 'shift_type');
foreach ($data1 as $value1 => $name1) {
$des .= CHtml::tag('option', array('value' => $value1), CHtml::encode($name1), true);
}
foreach ($data2 as $value2 => $name2) {
$dep .= CHtml::tag('option', array('value' => $value2), CHtml::encode($name2), true);
}
foreach ($data3 as $value3 => $name3) {
$shf .= CHtml::tag('option', array('value' => $value3), CHtml::encode($name3), true);
}
echo CJSON::encode(array('des' => $des, 'dep' => $dep, 'shf' => $shf));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = EmployeeDesignation::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
->queryAll();
if(!empty($empDOB))
{
?>
<div class="span3">
<div class="dashbox blue">
<div class="box-header blue">
<span class="title"><i class="fa fa-gift"></i> Today's birthday list</span>
</div>
<div class="box-content">
<?php
foreach($empDOB as $list) {
$picPath = EmployeePhotos::model()->findByPk($list['employee_transaction_emp_photos_id']);
$designation = EmployeeDesignation::model()->findByPk($list['employee_transaction_designation_id']);
$department = Department::model()->findByPk($list['employee_transaction_department_id']);
?>
<div class="box-section">
<div class="avatar"><img src="<?php echo Yii::app()->baseUrl; ?>/college_data/emp_images/<?php echo $picPath->employee_photos_path; ?>" width="41" height="40"></div>
<div class="news-content">
<div class="news-title"><?php echo $list['employee_first_name']." ".$list['employee_last_name']."<br><span style='color:#2572EB'>".$designation->employee_designation_name." / ".$department->department_name."</span>";?></div>
<!--<div class="news-text">Today, 10:30 PM</div> -->
</div>
</div>
<?php } ?>
</div>
