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; } }
'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,
'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'),
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)); }
<?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(); } ?>
<?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>"; }
} } 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>";
<?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>
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>
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++;
</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>
<?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;
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>
{ $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>";
<?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>
/** * 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>