<?php
$this->breadcrumbs=array(
'Chart Report',
);
?>
<?php
$acdm_name=AcademicTerm::model()->findAll(array('condition'=>'academic_term_period_id='.$acdm_period));
//print_r($acdm_name);
//exit;
$branch = Attendence::model()->findAll(array(
'select'=>'branch_id',
'condition'=>'sem_id='.$acdm_period,
'distinct'=>true,
));
$m=1;
if($branch)
{
?>
<div class="portlet box yellow" style="width:100%;margin-top:20px;">
<i class="icon-reorder"></i>
<div class="portlet-title"><span class="box-title"> Student Attendance Chart wise Report</span>
<div class="operation">
<?php echo CHtml::link('Back', array('/student/attendence/ChartReport'), array('class'=>'btnback'));?>
</div>
<?php
$this->breadcrumbs = array('Chart Report');
echo CHtml::link('GO BACK', Yii::app()->createUrl('attendence/ChartReport'));
?>
<?php
$acdm_name = AcademicTerm::model()->findAll(array('condition' => 'academic_term_period_id=' . $acdm_period . ' and academic_term_organization_id=' . Yii::app()->user->getState('org_id')));
//print_r($acdm_name);
//exit;
$branch = Attendence::model()->findAll(array('select' => 'branch_id', 'condition' => 'sem_id=' . $acdm_period . ' and attendence_organization_id=' . Yii::app()->user->getState('org_id'), 'distinct' => true));
$m = 1;
if ($branch) {
?>
<table class="table_data" align=center border="1" style="width:960px; font-size:12px;">
<th colspan="11" style="font-size: 18px; color: rgb(255, 255, 255);">
Attendance Chart Table
</th>
<tr class="table_header">
<th>Branch Name\Semester</th>
<?php
foreach ($acdm_name as $ac) {
?>
<th>
<?php
echo "Sem-" . $ac['academic_term_name'];
/**
* 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 = Attendence::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
}
print "</td>";
}
else
{?>
<td> -- </td>
<?php }
$stud_no++;
}
// total & present.
$all_attendance = Attendence::model()->findAll(array('condition'=>'month(attendence_date)='.$month_value.' AND st_id='.$stud_tran_id.' AND sub_id='.$selsub.' AND year(attendence_date)='.$year));
$percentage=0;
$present_attendance = Attendence::model()->findAll(array('condition'=>'month(attendence_date)='.$month_value.' AND st_id='.$stud_tran_id.' AND sub_id='.$selsub.' AND year(attendence_date)='.$year.' AND attendence = "P"'));
$total=count($all_attendance);
$present=count($present_attendance);
if($total!=0)
$percentage = ($present*100)/$total;
print "<td>";
echo $total;
print "</td>";
print "<td>";
echo $present;
print "</td>";
print "<td>";
echo round($percentage,2).'%';
print "</td>";
echo '</center>';
$percentage=0;
if($totalT[$sub]!=0)
$percentage=($present*100)/$totalT[$sub];
echo "<td > $present </td>";
echo "<td>";
echo round($percentage,2).'%';
echo "</td>";
$tot=$tot+$present;
$tot_percentage=0;
if($tot!=0)
$tot_percentage=($tot*100)/$tot_t;
}
foreach($subjectidp as $sub)
{
$present_attendance = Attendence::model()->findAll(array('condition'=>'month(attendence_date)='.$month_value.' AND branch_id='.$branch.' AND sub_id='.$sub.' AND year(attendence_date)='.$year.' AND attendence = "P" AND st_id='.$s));
$present=count($present_attendance);
$percentage=0;
if($totalP[$sub]!=0)
$percentage=($present*100)/$totalP[$sub];
echo "<td > $present </td>";
echo "<td>";
echo round($percentage,2).'%';
echo "</td>";
$totp=$totp+$present;
$totp_percentage=0;
if($totp!=0)
$totp_percentage=($totp*100)/$tot_p;
if (!empty($_REQUEST['sb_id']) && $_REQUEST['sb_id'] != '') {
echo '<table class="table_data" >';
foreach ($all_data as $list) {
if ($t % 2 == 0) {
$class = "odd";
} else {
$class = "even";
}
if ($t == -1) {
echo '<tr class="table_header"><th>Sr No.</th><th>En.No.</th><th>Name</th>';
echo '<th>Total</th><th>Present</th><th>%</th>';
echo '</tr>';
++$t;
}
$tcon = count(Attendence::model()->findAll(array('condition' => 'sub_id=' . $_REQUEST['sb_id'] . ' and st_id=' . $list['st_id'] . ' and month(attendence_date) in(' . $sel_month . ')')));
$pcon = count(Attendence::model()->findAll(array('condition' => 'sub_id=' . $_REQUEST['sb_id'] . ' and st_id=' . $list['st_id'] . ' and attendence="P" and month(attendence_date) in(' . $sel_month . ')')));
$perc = 0;
if ($pcon > 0) {
$perc = (double) ($pcon * 100 / $tcon);
$perc = round($perc, 2);
}
$stud_model = StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $list['st_id']));
if ($_REQUEST['less'] * 5 >= $perc && $_REQUEST['greate'] * 5 <= $perc) {
echo '<tr class=' . $class . '><td>' . ++$t . '</td><td>' . $stud_model->student_enroll_no . '</td><td>' . $stud_model->student_first_name . '</td>';
echo '<td>' . $tcon . '</td><td>' . $pcon . '</td><td>' . $perc . '%</td>';
echo '</tr>';
continue;
}
}
echo '</table>';
}
//exit;
//print_r($subject_data);
//exit;
if ($subject_data) {
echo '<table class="table_data" >';
echo "<th colspan=\"6\" style=\"font-size: 18px; color: rgb(255, 255, 255);\">";
echo 'Attendance Report From-Date:' . date("d-m-Y", strtotime($start)) . " To-Date: " . date("d-m-Y", strtotime($end));
echo '</th><tr class="table_header"><th>SI No.</th><th>Subject Name</th><th>Semester</th><th>Total</th><th>Present</th><th>Attendance %</th></tr>';
foreach ($subject_data as $list) {
if ($m % 2 == 0) {
$class = "odd";
} else {
$class = "even";
}
$total_att = Attendence::model()->findAll(array('condition' => 'st_id=' . $student_data['student_transaction_id'] . ' AND sub_id=' . $list['subject_master_id'] . ' AND month(attendence_date)=' . $month_value . ' AND year(attendence_date)=' . $year));
$pre_att = Attendence::model()->findAll(array('condition' => 'st_id=' . $student_data['student_transaction_id'] . ' AND attendence="P"' . ' AND sub_id=' . $list['subject_master_id'] . ' AND month(attendence_date)=' . $month_value . ' AND year(attendence_date)=' . $year));
$sem_name = AcademicTerm::model()->findByPk($list['subject_master_academic_terms_name_id'])->academic_term_name;
$percentage = 0;
$totalcount = count($total_att);
$precount = count($pre_att);
if (count($total_att) == 0) {
echo '<tr class=' . $class . '><td>' . ++$i . '</td><td><u>' . CHtml::link($list['subject_master_name'] . '(' . SubjectType::model()->findByPk($list['subject_master_type_id'])->subject_type_name . ")", array('monthview', 'month' => $month_value, 'year' => $year, 'student_id' => $student_data['student_transaction_id'], 'sub_id' => $list['subject_master_id']), array('class' => 'link', 'target' => '_blank')) . '</u></td><td>' . $sem_name . '</td><td>' . count($total_att) . '</td><td>' . count($pre_att) . '</td><td>' . $percentage . '%</td></tr>';
} else {
$percentage = count($pre_att) * 100 / count($total_att);
echo '<tr class=' . $class . '><td>' . ++$i . '</td><td><u>' . CHtml::link($list['subject_master_name'] . '(' . SubjectType::model()->findByPk($list['subject_master_type_id'])->subject_type_name . ")", array('monthview', 'month' => $month_value, 'year' => $year, 'student_id' => $student_data['student_transaction_id'], 'sub_id' => $list['subject_master_id']), array('class' => 'link', 'target' => '_blank')) . '</u></td><td>' . $sem_name . '</td><td>' . count($total_att) . '</td><td>' . count($pre_att) . '</td><td>' . round($percentage, 2) . '%</td></tr>';
}
$m++;
}
echo '</table>';
} else {
print "<h1 style=\"color:red;text-align:center\">No Record To Display</h1>";
public function actionStudMonthlyAllsubjectAttendenceReport()
{
$baseUrl = Yii::app()->baseUrl;
$cs = Yii::app()->getClientScript();
$cs->registerCssFile($baseUrl . '/css/report.css');
$model = new Attendence();
$this->performAjaxValidation($model);
$month = null;
$month_value = null;
$student = array();
$subject_data = array();
$sid = array();
$subject = 0;
$subjectp = 0;
$subjectidp = array();
$subjectid = array();
$batch = 0;
if (!empty($_POST['months']) && !empty($_REQUEST['Attendence']['batch_id']) && isset($_POST['Attendence']) || isset($_REQUEST['batch_id'])) {
//print_r ($_POST['Attendence']);exit;
$query = null;
if (!empty($_REQUEST['batch_id'])) {
$batch = $_REQUEST['batch_id'];
$query .= "batch_id=" . $batch . " AND ";
} else {
$batch = $_POST['Attendence']['batch_id'];
$query .= "batch_id=" . $batch . " AND ";
}
if (!empty($_POST['months']) || !empty($_REQUEST['month'])) {
if (!empty($_REQUEST['month'])) {
$month = $_REQUEST['month'];
} else {
$month = $_POST['months'];
}
$student = Yii::app()->db->createCommand()->selectDistinct('st_id')->from('attendence a')->join('student_transaction st', 'a.st_id=st.student_transaction_student_id')->where($query . ' st.student_transaction_detain_student_flag NOT IN (1,2)')->queryAll();
//print_r($student);exit;
foreach ($student as $s) {
//student name
$data3 = Attendence::model()->findAll(array('condition' => 'st_id=' . $s['st_id']));
$stud_name = StudentInfo::model()->findByPk($s['st_id']);
$sid[] = $s['st_id'];
}
$subject = Yii::app()->db->createCommand()->selectDistinct('sub_id')->from('attendence a')->join('subject_master sub', 'a.sub_id=sub.subject_master_id')->where('subject_master_type_id=1')->queryAll();
$subject_p = Yii::app()->db->createCommand()->selectDistinct('sub_id')->from('attendence a')->join('subject_master sub', 'a.sub_id=sub.subject_master_id')->where('subject_master_type_id=2')->queryAll();
foreach ($subject as $sub) {
$sub_name = SubjectMaster::model()->findByPk($sub['sub_id']);
$subjectid[] = $sub['sub_id'];
}
foreach ($subject_p as $sub) {
$sub_name = SubjectMaster::model()->findByPk($sub['sub_id']);
$subjectidp[] = $sub['sub_id'];
}
}
// .......export excel.....
if (isset($_REQUEST['excel'])) {
Yii::app()->request->sendFile(date('YmdHis') . '.xls', $this->renderPartial('stud_monthly_allsubject_attendence_report_excel', array('month' => $month, 'sid' => $sid, 'batch' => $batch, 'subjectid' => $subjectid, 'subjectidp' => $subjectidp), true));
} else {
$this->render('stud_monthly_allsubject_attendence_report_view', array('model' => $model, 'month' => $month, 'sid' => $sid, 'batch' => $batch, 'subjectid' => $subjectid, 'subjectidp' => $subjectidp));
}
} else {
$this->render('stud_monthly_allsubject_attendence_report_view', array('model' => $model, 'month' => $month, 'sid' => $sid, 'batch' => $batch, 'subjectid' => $subjectid, 'subjectidp' => $subjectidp));
}
}
echo "<tr align=center> <th colspan = 60 style=text-align:left;> ".CHtml::image(Yii::app()->controller->createUrl('/site/loadImage', array('id'=>$org_data->organization_id)),'No Image',array('width'=>80,'height'=>55,'style'=>'float:left;margin-left:200px;')) ."
<big> <b>".$org_data->organization_name ."</big><br>". $org_data->address_line1." ".$org_data->address_line2."</br>" . City::model()->findBypk($org_data->city)->city_name.", ".State::model()->findBypk($org_data->state)->state_name.", ".Country::model()->findBypk($org_data->country)->name."." ." </th> <br> </tr>";
echo "<th colspan=\"6\" style=\"font-size: 18px; color: rgb(255, 255, 255);\">";
echo 'Attendance Report From-Date:'.date("d-m-Y", strtotime($start))." To-Date: ".date("d-m-Y", strtotime($end));
echo '</th></tr><tr class="table_header"><th>SI No.</th><th>Subject Name</th><th>Semester</th><th>Total</th><th>Present</th><th>Attendance %</th></tr>';
foreach($subject_data as $list) {
if(($m%2) == 0)
{
$class = "odd";
}
else
{
$class = "even";
}
$total_att = Attendence::model()->findAll(array('condition'=>'st_id='.$student_data['student_transaction_id'].' AND sub_id='.$list['subject_master_id'].' AND attendence_date BETWEEN "'.$start.'" AND "'.$end.'"'));
$pre_att = Attendence::model()->findAll(array('condition'=>'st_id='.$student_data['student_transaction_id'].' AND attendence="P"'.' AND sub_id='.$list['subject_master_id'].' AND attendence_date BETWEEN "'.$start.'" AND "'.$end.'"'));
$sem_name = AcademicTerm::model()->findByPk($list['subject_master_academic_terms_name_id'])->academic_term_name;
$percentage=0;
$totalcount=count($total_att);
$precount=count($pre_att);
if(count($total_att)==0)
{
echo '<tr class='.$class.'><td>'.++$i.'</td><td>'.$list['subject_master_name'].'('.SubjectType::model()->findByPk($list['subject_master_type_id'])->subject_type_name.")".'</td><td>'.$sem_name.'</td><td>'.count($total_att).'</td><td>'.count($pre_att).'</td><td>'.$percentage.'%</td></tr>';
}
else
{
$percentage = (count($pre_att)*100)/count($total_att);
echo '<tr class='.$class.'><td>'.++$i.'</td><td>'.$list['subject_master_name'].'('.SubjectType::model()->findByPk($list['subject_master_type_id'])->subject_type_name.")".'</td><td>'.$sem_name.'</td><td>'.count($total_att).'</td><td>'.count($pre_att).'</td><td>'.round($percentage,2).'%</td></tr>';
public function actionStudentAttendenceReport() //done by Ravi B
{
$model=new Attendence;
if((!empty($_POST['Attendence']['start_date']) && !empty($_POST['Attendence']['end_date'])) || (!empty($_POST['months']) || !empty($_REQUEST['month'])))
{
$month = null;
if(!empty($_REQUEST['en_no']))
$en = $_REQUEST['en_no'];
if(!empty($_REQUEST['month']))
$month = $_REQUEST['month'];
else if(!empty($_POST['months']))
$month = $_POST['months'];
$student_data= Yii::app()->db->createCommand()
->select('*')
->from('student_transaction stud')
->join('student_info stud_info', 'stud_info.student_id = stud.student_transaction_student_id')
->where('stud_info.student_info_transaction_id="'.$_REQUEST['id'].'" and stud.student_transaction_organization_id='.Yii::app()->user->getState('org_id'))
->queryRow();
if(!empty($_POST['studentradio']) && $_POST['studentradio']=='1' )
{
$start=null;
$end=null;
if(empty($student_data))
{
Yii::app()->user->setFlash('no_student_found', "No Student Found for this Enrollment no.");
$this->redirect(array('/studentAttendenceReport','id'=>$_REQUEST['id']));
}
else if(strtotime($_POST['Attendence']['start_date']) > strtotime($_POST['Attendence']['end_date']))
{
Yii::app()->user->setFlash('no_student_found', "Start-Date must be less than End-Date.");
$this->redirect(array('/studentAttendenceReport','id'=>$_REQUEST['id']));
}
else
{
$new_start=$_POST['Attendence']['start_date'];
$new_end=$_POST['Attendence']['end_date'];
$start = date("Y-m-d", strtotime($new_start));
$end = date("Y-m-d", strtotime($new_end));
$att_info = Attendence::model()->findAll(array(
'select'=>'sem_name_id',
'distinct'=>true,
'condition'=>'attendence_date >=:date_start and attendence_date <= :date_end and st_id = :stu_id',
'params'=>array(':date_start'=>$start,':date_end'=>$end,'stu_id'=>$student_data['student_transaction_id'])
));
$sem_data = array();
foreach($att_info as $list)
$sem_data[] = $list['sem_name_id'];
if($sem_data){
$sem_array = implode(',',$sem_data);
$subject_data = Yii::app()->db->createCommand()
->select('*')
->from('subject_master')
->where('subject_master_id in (select sub_id from attendence where branch_id='.$student_data['student_transaction_branch_id'].' and sem_id='.$student_data['student_academic_term_period_tran_id'].') and subject_master_academic_terms_name_id IN('.$sem_array.')')
->queryAll();
$this->render('student_report_view',array(
'subject_data'=>$subject_data,'student_data'=>$student_data,'start'=>$start,'end'=>$end,));
}
else
{
Yii::app()->user->setFlash('no_student_found', "No Data Found for this Date range.");
$this->redirect(array('studentAttendenceReport','id'=>$_REQUEST['id']));
}
}
}
if((!empty($_POST['studentradio']) && $_POST['studentradio']=="2") || $month)
{
if(strlen($month) == 1)
$month = "0".$month;
$year = date('Y');
$num = cal_days_in_month(CAL_GREGORIAN, $month, date('Y'));
$month_start = '01-'.$month.'-'.$year;
$month_end = $num.'-'.$month.'-'.$year;
$start=null;
$end=null;
if(empty($student_data))
{
Yii::app()->user->setFlash('no_student_found', "No Student Found for this Enrollment no.");
$this->redirect(array('/studentAttendenceReport','id'=>$_REQUEST['id']));
}
else
{
$att_info = Attendence::model()->findAll(array(
'select'=>'sem_name_id',
'distinct'=>true,
'condition'=>'month(attendence_date) =:month and year(attendence_date) = :year and st_id = :stu_id',
'params'=>array(':month'=>$month,':year'=>$year,'stu_id'=>$student_data['student_transaction_id'])
));
$sem_data = array();
foreach($att_info as $list)
$sem_data[] = $list['sem_name_id'];
$sem_array = implode(',',$sem_data);
if($sem_data)
{
$subject_data = Yii::app()->db->createCommand()
->select('*')
->from('subject_master')
->where('subject_master_id in (select sub_id from attendence where branch_id='.$student_data['student_transaction_branch_id'].' and sem_id='.$student_data['student_academic_term_period_tran_id'].') and subject_master_academic_terms_name_id IN('.$sem_array.') AND subject_master_organization_id='.Yii::app()->user->getState('org_id'))
->queryAll();
$new_start=$month_start;
$new_end=$month_end;
$start = date("Y-m-d", strtotime($new_start));
$end = date("Y-m-d", strtotime($new_end));
$this->render('monthwise_student_attend',array(
'subject_data'=>$subject_data,'student_data'=>$student_data,'start'=>$start,'end'=>$end,'month_value'=>$month,'year'=>$year));
}
else
{
Yii::app()->user->setFlash('no_student_found', "No Attendence Found for this Criteria.");
$this->redirect(array('studentAttendenceReport','id'=>$_REQUEST['id']));
}
}
}
}//!empty($_POST['Attendence']['student_enroll_no']) if end
else
{
$this->render('student_attendence_report',array(
'model'=>$model,
));
}
}
protected function report()
{
global $user;
global $objPDO;
$student = new student($objPDO, $user->getuserId());
$headMenu = array("username" => $student->getName());
if ($user->checkAdmin() == true || $student->checkTeacher() || $student->checkStudent()) {
$role = $student->getacctType();
$sid = NULL;
if ($student->checkStudent()) {
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/student_profile_class.php';
$sid = $student->getID();
} else {
if (isset($_GET['uid'])) {
$sid = $_GET['uid'];
}
}
if ($sid) {
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/student_profile_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/attendence_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/student_section_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/section_class.php';
$stu = new StudentProfile($objPDO);
$stu->loadByUserId($sid);
$roll_number = $stu->getRollNo();
$name = $stu->getName();
$section = new StudentSection($objPDO);
$section_id = $section->getByStudentId($sid);
$sec = new Section($objPDO, $section_id);
$section_name = $sec->getCode();
$att = new Attendence($objPDO);
$total_days = $att->getBySectionId($section_id);
$attendance = $att->getByStudentId($stu->getID());
$present = 0;
$absent = 0;
foreach ($attendance as $key => $value) {
if ($value['presence'] == 1) {
$present++;
} else {
if ($value['presence'] == 0) {
$absent++;
}
}
}
include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/report_view.php';
} else {
echo 'error';
}
} else {
header('Location:http://localhost/cloud');
}
}
function loadAttendences($state = null)
{
$loader = new Attendence($this->{$db});
$this->setAttendences($loader->loadWhere('eventId=?', [$this->getId()]));
return $this->getAttendences();
}
for($i = 1; $i<=$num; $i++) {
print '<th>'.$i.'</th>';
}
?>
</tr>
<tr class='odd'>
<th>Present/Absent</th>
<?php
for($i = 1; $i<=$num; $i++) {
if(strlen($i) == 1)
$i = "0".$i;
$date = $i.'-'.$month_value.'-'.date('Y');
$attend_date = date("Y-m-d", strtotime($date));
$result1 = Attendence::model()->findAll(array('condition'=>'month(attendence_date)='.$month_value.' AND st_id='.$student_id.' AND sub_id='.$subject_id.' AND day(attendence_date)='.$i.' AND year(attendence_date)='.$year));
if(count($result1) !=0)
{
print "<td>";
$a = 1;
foreach($result1 as $result){
$myclass = $result->attendence == 'P' ? 'green' : 'red';
if($a == count($result1))
print "<b style=color:$myclass>".$result->attendence."</b>";
else
print "<b style=color:$myclass>".$result->attendence."</br></b>";
$a+=1;
}
print "</td>";
}
public function beforeDelete()
{
$id = $this->student_transaction_id;
$fees_check = FeesPaymentTransaction::model()->findAll(array('condition' => 'fees_student_id=' . $id));
$att_check = Attendence::model()->findAll(array('condition' => 'st_id=' . $id));
$mis_fees = MiscellaneousFeesPaymentTransaction::model()->findAll(array('condition' => 'student_fees_id=' . $id));
$left_check = LeftDetainedPassStudentTable::model()->findAll(array('condition' => 'student_id=' . $id));
$st_archive = StudentArchiveTable::model()->findAll(array('condition' => 'student_archive_stud_tran_id=' . $id));
if (!empty($fees_check) || !empty($att_check) || !empty($mis_fees) || !empty($left_check) || !empty($st_archive)) {
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;
}
}
}
$result1=Attendence::model()->findByAttributes(array('st_id'=> $s,'attendence_date'=>"$date",'student_attendence_period_id'=>$lectures[$l],'sub_id'=>$subject[$l],'employee_id'=>$faculty[$l]));
if(count($result1) !=0)
{
$myclass = $result1->attendence == 'P' ? 'green' : 'red';
print "<b>"."<font color=".$myclass.">".$result1->attendence."</font>"."</b>";
}
else
print " -- ";
$l++;
}
$l--;
}
else
{
$result1=Attendence::model()->findByAttributes(array('st_id'=>$s,'attendence_date'=>"$date",'student_attendence_period_id'=>$lectures[$l],'employee_id'=>$faculty[$l]));
if(count($result1) !=0)
{
$myclass = $result1->attendence == 'P' ? 'green' : 'red';
print "<td align=center><b >"."<font color=".$myclass.">".$result1->attendence."</font>"."</b>"."</td>";
}
else
print "<td align=center> - </td>";
}
}
else
{
print "<td> -- </td>";
}
$cs++;
public function beforeDelete()
{
$id = $this->student_transaction_id;
$att_check = Attendence::model()->findAll(array('condition'=>'st_id='.$id));
if(!empty($att_check))
{
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;
}
}
/** @return boolean. Check and delete all other information of the employee from application. Employee profile will delete depend on this value.
*/
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_att) || !empty($att_check))
{
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;
}
}
