{
$class = "even";
}
echo '<tr class='.$class.'>';
echo '<td>';
echo ++$m;
echo '</td>';
echo "<td>";
echo $emp['title'].''.$emp['employee_first_name'].' '.$emp['employee_last_name'].' ( '.$emp['employee_name_alias'].' )';
echo "</td>";
$org = Yii::app()->user->getState('org_id');
foreach($leave as $lv)
{
$count=0;
$totalLeave=EmployeeLeaveApplication::model()->findAll(array('condition'=>
'(month(employee_leave_application_leave_start_date)='.$month_value.' OR month(employee_leave_application_leave_end_date)='.$month_value.') AND (year(employee_leave_application_leave_start_date)='.$yr.' OR year(employee_leave_application_leave_end_date)='.$yr.') AND employee_leave_application_employee_code='.$emp['employee_id'].' AND employee_leave_application_leave_code='.$lv['leave_master_id'].' AND employee_leave_application_status_2=2'
));
foreach($totalLeave as $leave_app)
{
$startdate_month=date_format(new DateTime($leave_app->employee_leave_application_leave_start_date), 'm');
$enddate_month=date_format(new DateTime($leave_app->employee_leave_application_leave_end_date), 'm');
if($startdate_month==$enddate_month)
$count+=$leave_app->employee_leave_application_days;
else
{
$month_days=cal_days_in_month(CAL_GREGORIAN,$month_value, $yr);
$start_date=date_format(new DateTime($leave_app->employee_leave_application_leave_start_date), 'd');
$count+=$month_days-$start_date;
}
public function beforeDelete()
{
$id = $this->employee_transaction_id;
$emp_leave = EmployeeLeaveMaster::model()->findAll(array('condition' => 'empid=' . $id));
$att_check = Attendence::model()->findAll(array('condition' => 'employee_id=' . $id));
$emp_att = Employee_attendence::model()->findAll(array('condition' => 'employee_id=' . $id));
$emp_leave_app = EmployeeLeaveApplication::model()->findAll(array('condition' => 'employee_leave_application_employee_code=' . $id . ' OR employee_leave_application_approved_by_code=' . $id . ' OR employee_leave_application_approved_by_code_2=' . $id));
$emp_rep = EmployeeReportingTable::model()->findAll(array('condition' => 'emp_reporting_table_user_id=' . $id . ' OR emp_reporting_table_reporting_level_1=' . $id . ' OR emp_reporting_table_reporting_level_2=' . $id));
$emp_sal = EmployeeSalaryStructure::model()->findAll(array('condition' => 'employee_id=' . $id));
$ass_sub = AssignSubject::model()->findAll(array('condition' => 'subject_faculty_id=' . $id));
$time_table = TimeTableDetail::model()->findAll(array('condition' => 'faculty_emp_id=' . $id));
if (!empty($emp_leave) || !empty($att_check) || !empty($emp_att) || !empty($emp_leave_app) || !empty($emp_rep) || !empty($emp_sal) || !empty($ass_sub) || !empty($time_table)) {
Yii::app()->user->setFlash('error', "You can not delete this record because it is used in another table.");
return false;
} else {
Yii::app()->user->setFlash('success', "Deleted Sucessfully");
return true;
}
}