protected function renderContent()
{
$day = array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday");
if (Yii::app()->user->getState('stud_id')) {
$date = date('Y-m-d');
$ts = strtotime($date);
$week_number = date('W', $ts);
$year = date('Y');
for ($day1 = 1; $day1 < 7; $day1++) {
$alldate[] = date('d-m-Y', strtotime($year . "W" . $week_number . $day1));
}
$criteria = new CDbCriteria();
//$criteria->select = 'academic_term_id'; // select fields which you want in output
$criteria->condition = 'current_sem = 1 AND academic_term_organization_id = ' . Yii::app()->user->getState('org_id');
$semname = AcademicTerm::model()->findAll($criteria);
$data = CHtml::listData($semname, 'academic_term_id', 'academic_term_id');
$stud_model = StudentTransaction::model()->findByPk(Yii::app()->user->getState('stud_id'));
$check_sem = in_array($stud_model->student_academic_term_name_id, $data);
//var_dump($check_sem); exit;
$timetableid = 0;
if (!$check_sem) {
echo "<h3 align=center style=color:red>Sorry, No timetable available for this student.</h3>";
} else {
$check_timetable = TimeTableDetail::model()->findByAttributes(array('acdm_name_id' => $stud_model->student_academic_term_name_id, 'division_id' => $stud_model->student_transaction_division_id));
if (empty($check_timetable)) {
echo "<h3 align=center style=color:red>Sorry, No timetable available for this student.</h3>";
} else {
$timetableid = $check_timetable->timetable_id;
$model = TimeTable::model()->findByPk($timetableid);
$nooflec = $model->No_of_Lec;
$sum = $nooflec;
$lec_duration = LecDuration::model()->findAllByAttributes(array(), $condition = 'timetable_id = :table_id ', $params = array(':table_id' => $timetableid));
$lec = array();
foreach ($lec_duration as $l) {
$lec[] = $l['duration'];
}
$createdate = date_create($model->creation_date);
$starti = 1;
if ($model->zero_lec == 1) {
$starti = 0;
}
$time = $model->clg_start_time;
$time = date('H:i A', strtotime($time));
$timestamp = strtotime($time);
$time = date('g:i A', $timestamp);
?>
<table id="time-table-struc" bgcolor="#CBE7ED" border="2" style= width:auto;font-size:8px;border-collapse:collapse; height:auto;" align="center">
<th align=center>
Day/Time
</th>
<?php
$i = 0;
while ($i < 6) {
echo "<th>" . $day[$i] . "</br>(" . $alldate[$i] . ")</th>";
$i++;
}
$break = "";
$l = 0;
$count = array(1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0, 6 => 0);
for ($i = $starti; $i <= $nooflec; $i++) {
$days = count($day);
echo "<tr>";
$duration = NoOfBreakTable::model()->findByAttributes(array('timetable_id' => $timetableid, 'after_lec_break' => $i));
$dur = $duration['duration'];
if ($dur) {
$dur1 = date('i', strtotime($dur));
}
if ($break) {
echo "<td style=width:100px;>" . $time . "-</br>" . date('g:i A', strtotime($time) + $dur1 * 60) . "</td><td colspan=7 align=center><font color='green'><b>Break</b></font></td></tr>";
$break = "";
$timestamp = strtotime($time) + $dur1 * 60;
$time = date('g:i A', $timestamp);
$i--;
continue;
} else {
echo "<td style=width:100px;>" . $time . "-</br>" . date('g:i A', strtotime($time) + 60 * $lec[$l]) . "</td>";
$timestamp = strtotime($time) + 60 * $lec[$l];
$l++;
$time = date('g:i A', $timestamp);
}
for ($j = 1; $j <= $days; ++$j) {
$subname = "";
$room = "";
$faculty = "";
$batch = "";
if ($count[$j] > 0) {
$count[$j]--;
continue;
}
$result = TimeTableDetail::model()->findAllByAttributes(array(), $condition = 'timetable_id = :table_id AND day = :day AND lec = :lec AND division_id = :div_id AND lecture_date = :lecdate and proxy_status <> :proxy_status', $params = array(':table_id' => $timetableid, ':day' => $j, ':lec' => $i, ':div_id' => $stud_model->student_transaction_division_id, ':lecdate' => date('Y-m-d', strtotime($alldate[$j - 1])), ':proxy_status' => 2));
$break = NoOfBreakTable::model()->findAllByAttributes(array(), $condition = 'timetable_id = :table_id AND after_lec_break = :lec', $params = array(':table_id' => $timetableid, ':lec' => $i));
if ($result) {
foreach ($result as $list) {
if ($list['lect_hour'] > 1) {
$count[$j] = $list['lect_hour'] - 1;
}
echo "<td rowspan=" . $list['lect_hour'] . " align=center style=background:#C0CCCC; width:100px;>";
break;
}
foreach ($result as $check) {
if ($check->batch_id != 0) {
$batch = "(" . Batch::model()->findByPk($check->batch_id)->batch_name . ")";
}
$subname = SubjectMaster::model()->findByPk($check->subject_id)->subject_master_alias;
$room = "(" . RoomDetailsMaster::model()->findByPk($check->room_id)->room_name . ")";
$faculty = "(" . EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id' => $check->faculty_emp_id))->employee_name_alias . ")";
if ($batch) {
echo "</br>" . $subname . "</br>" . $batch . "</br>" . $room . "</br>" . $faculty;
} else {
echo "</br>" . $subname . "</br>" . $room . "</br>" . $faculty;
}
}
echo "</td>";
} else {
echo "<td style=width:100px;>" . $subname . "</br>" . $batch . "</br>" . $room . "</br>" . $faculty . "</td>";
}
}
echo "</tr>";
}
echo "</table>";
?>
<h5>Proxy details</h5>
<table id="time-table-struc" style="font-size:10px;">
<tr>
<th>Sr. No.</th>
<th>Employee Name</th>
<th>Proxy Employee Name</th>
<th>Subject</th>
<th>Lecture No.</th>
<th>Date</th>
</tr>
<?php
$proxy_data = TimeTableDetail::model()->findAllByAttributes(array(), $condition = 'timetable_id = :timetable_id and division_id = :div_id and lecture_date >= :start and lecture_date< :end and proxy_status = :proxy order by lec', $params = array(':timetable_id' => $timetableid, ':div_id' => $stud_model->student_transaction_division_id, ':start' => date('Y-m-d', strtotime($alldate[0])), ':end' => date('Y-m-d', strtotime($alldate[5])), ':proxy' => 1));
$n = 0;
foreach ($proxy_data as $list) {
$result = TimeTableDetail::model()->findByPk($list->proxy_id);
?>
<tr>
<td><?php
echo ++$n;
?>
</td>
<td><?php
echo EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id' => $list->faculty_emp_id))->employee_first_name;
?>
</td>
<td><?php
echo EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id' => $result->faculty_emp_id))->employee_first_name;
?>
</td>
<td><?php
echo SubjectMaster::model()->findByPk($result->subject_id)->subject_master_alias;
?>
</td>
<td><?php
echo $result->lec;
?>
</td>
<td><?php
echo date('d-m-Y', strtotime($result->lecture_date));
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
//ELSE END
}
} else {
if (Yii::app()->user->getState('emp_id')) {
$timetableid = 0;
$date = date('Y-m-d');
$ts = strtotime($date);
$week_number = date('W', $ts);
$alldate[0] = 'No';
$year = date('Y');
for ($day2 = 1; $day2 < 7; $day2++) {
$alldate[$day2] = date('d-m-Y', strtotime($year . "W" . $week_number . $day2));
}
$semname = AcademicTerm::model()->findAllByAttributes(array(), $condition = 'current_sem = :current_sem and academic_term_organization_id=:org_id', $params = array(':current_sem' => 1, ':org_id' => Yii::app()->user->getState('org_id')));
foreach ($semname as $s) {
$semid = $s['academic_term_id'];
$check = TimeTableDetail::model()->findByAttributes(array('acdm_name_id' => $semid, 'faculty_emp_id' => Yii::app()->user->getState('emp_id')));
if ($check) {
$timetableid = $check['timetable_id'];
break;
}
}
if (!empty($timetableid)) {
$day = array(" ", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday");
$model = TimeTable::model()->findByPk($timetableid);
$nooflec = $model->No_of_Lec;
$sum = $nooflec;
$lec_duration = LecDuration::model()->findAllByAttributes(array(), $condition = 'timetable_id = :table_id ', $params = array(':table_id' => $timetableid));
$lec = array();
foreach ($lec_duration as $l) {
$lec[] = $l['duration'];
}
$starti = 1;
if ($model->zero_lec == 1) {
$starti = 0;
}
$time = $model->clg_start_time;
$time = date('H:i A', strtotime($time));
$createdate = date_create($model->creation_date);
?>
<table id="time-table-struc" bgcolor="#CBE7ED" border="2" style="width:auto;font-size:9px;border-collapse:collapse; height:auto;" >
<th>
Day/Time
</th>
<?php
$i = 0;
while ($i < 7) {
echo "<th style='font-size:8px'>" . $day[$i] . "</br>(" . $alldate[$i] . ")</th>";
$i++;
}
$l = 0;
$break = "";
$dur1 = 0;
$count = array(1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0, 6 => 0);
for ($i = $starti; $i <= $nooflec; $i++) {
$days = count($day);
echo "<tr>";
$duration = NoOfBreakTable::model()->findByAttributes(array('timetable_id' => $timetableid, 'after_lec_break' => $i));
if ($duration) {
$dur = $duration['duration'];
$dur1 = date('i', strtotime($dur));
}
if ($break) {
echo "<td style=width:100px;>" . $time . "-</br>" . date('g:i A', strtotime($time) + $dur1 * 60) . "</td><td colspan=7 align=center ><font color='green'><b>Break</b></font></td></tr>";
$break = "";
$timestamp = strtotime($time) + $dur1 * 60;
$time = date('g:i A', $timestamp);
$i--;
continue;
} else {
echo "<td style=width:100px;>" . $time . "-</br>" . date('g:i A', strtotime($time) + 60 * $lec[$l]) . "</td><td style=width:25px;><b>" . $i . "</b></td>";
$timestamp = strtotime($time) + 60 * $lec[$l];
$l++;
$time = date('g:i A', $timestamp);
}
for ($j = 1; $j <= $days - 1; ++$j) {
$subname = "";
$room = "";
$faculty = "";
$batch = "";
if ($count[$j] > 0) {
$count[$j]--;
continue;
}
$result = TimeTableDetail::model()->findAllByAttributes(array(), $condition = 'day = :day AND lec = :lec AND faculty_emp_id = :emp_id AND timetable_id=:table_id AND lecture_date =:lecdate and proxy_status <> :status', $params = array(':table_id' => $timetableid, ':day' => $j, ':lec' => $i, ':emp_id' => Yii::app()->user->getState('emp_id'), ':lecdate' => date('Y-m-d', strtotime($alldate[$j])), ':status' => 2));
$break = NoOfBreakTable::model()->findAllByAttributes(array(), $condition = 'after_lec_break = :lec AND timetable_id=:table_id', $params = array(':table_id' => $timetableid, ':lec' => $i));
if ($result) {
foreach ($result as $list) {
if ($list['lect_hour'] > 1) {
$count[$j] = $list['lect_hour'] - 1;
}
echo "<td rowspan=" . $list['lect_hour'] . " align=center style=background:#C0CCCC; border-color:black; width:150px;>";
break;
}
foreach ($result as $check) {
if ($check->batch_id != 0) {
$batch = "(" . Batch::model()->findByPk($check->batch_id)->batch_name . ")";
}
$subname = SubjectMaster::model()->findByPk($check->subject_id)->subject_master_alias;
$room = "(" . RoomDetailsMaster::model()->findByPk($check->room_id)->room_name . ")";
$div = Division::model()->findByPk($check->division_id)->division_code;
//$faculty="(".EmployeeInfo::model()->findByPk($check->faculty_emp_id)->employee_name_alias.")";
if ($batch) {
echo $subname . "</br>" . $batch . "</br>" . $room;
} else {
echo $subname . "</br>" . "(" . $div . ")" . "</br>" . $room;
}
}
echo "</td>";
} else {
echo "<td style=width:150px;>" . $subname . "</br>" . $batch . "</br>" . $room . "</td>";
}
}
//for j end
echo "</tr>";
}
//for i end
echo "</table>";
?>
<h5>Proxy Lectures</h5>
<table id="time-table-struc" border="1" style="font-size:10px;">
<tr>
<th>Sr. No.</th>
<th>Employee Name</th>
<th>Division</th>
<th>Subject</th>
<th>Room</th>
<th>Lecture No.</th>
<th>Date</th>
</tr>
<?php
$proxy_data = TimeTableDetail::model()->findAllByAttributes(array(), $condition = 'timetable_id = :timetable_id and proxy_employee_id = :emp_id and lecture_date >= :start and lecture_date< :end and proxy_status = :proxy order by lec', $params = array(':timetable_id' => $timetableid, ':emp_id' => Yii::app()->user->getState('emp_id'), ':start' => date('Y-m-d', strtotime($alldate[0])), ':end' => date('Y-m-d', strtotime($alldate[5])), ':proxy' => 1));
$n = 0;
foreach ($proxy_data as $list) {
$result = TimeTableDetail::model()->findByPk($list->proxy_id);
?>
<tr>
<td><?php
echo ++$n;
?>
</td>
<td><?php
echo EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id' => $list->faculty_emp_id))->employee_first_name;
?>
</td>
<td><?php
echo Division::model()->findByPk($result->division_id)->division_code;
?>
</td>
<td><?php
echo SubjectMaster::model()->findByPk($result->subject_id)->subject_master_alias;
?>
</td>
<td><?php
echo RoomDetailsMaster::model()->findByPk($result->room_id)->room_name;
?>
</td>
<td><?php
echo $result->lec;
?>
</td>
<td><?php
echo date('d-m-Y', strtotime($result->lecture_date));
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
} else {
echo "<h3 align=center style=color:red>Sorry, No timetable available.</h3>";
}
}
}
}
public function actiongetTimetableItemName1()
{
$data = array();
$day = $_POST['TimeTableDetail']['day'];
$lec = $_POST['TimeTableDetail']['lec'];
$acdm_period_id = $_POST['TimeTableDetail']['acdm_period_id'];
$org_id = Yii::app()->user->getState('org_id');
$timetable_id = $_POST['TimeTableDetail']['timetable_id'];
$check = TimeTableDetail::model()->findAllByAttributes(array(), $condition = 'day = :day AND lec = :lec AND branch_id = :branch_id AND acdm_name_id = :acdm_name_id AND timetable_id = :timetable_id', $params = array(':day' => $day, ':lec' => $lec, ':branch_id' => (int) $_REQUEST['TimeTableDetail']['branch_id'], ':timetable_id' => $timetable_id, ':acdm_name_id' => (int) $_REQUEST['TimeTableDetail']['acdm_name_id']));
$flag = 0;
foreach ($check as $c) {
if ($c['subject_type'] == 2) {
$flag = 1;
break;
}
}
$data = array();
if ($flag == 1) {
$data = Division::model()->findAll(array('condition' => 'academic_name_id=' . (int) $_REQUEST['TimeTableDetail']['acdm_name_id'] . ' and academic_period_id=' . $acdm_period_id . ' and branch_id=' . (int) $_REQUEST['TimeTableDetail']['branch_id'] . ' and division_organization_id=' . $org_id));
$data = CHtml::listData($data, 'division_id', 'division_code');
} else {
$div1 = Yii::app()->db->createCommand()->select('division_id , division_code')->from('division')->where('branch_id=' . (int) $_REQUEST['TimeTableDetail']['branch_id'] . ' and academic_name_id=' . (int) $_REQUEST['TimeTableDetail']['acdm_name_id'] . ' and division_organization_id=' . $org_id . ' and division_id NOT IN(select division_id from time_table_detail where day=' . $day . ' and lec=' . $lec . ' and branch_id=' . (int) $_REQUEST['TimeTableDetail']['branch_id'] . ' and acdm_period_id=' . $acdm_period_id . ' and acdm_name_id=' . (int) $_REQUEST['TimeTableDetail']['acdm_name_id'] . ' and timetable_id=' . $timetable_id . ' and subject_type=1' . ')')->queryAll();
if (empty($div1)) {
echo "<b style='color:red;'>No Division Availble.Create division first.</b>";
$f = 1;
} else {
foreach ($div1 as $n) {
$temp = $n['division_id'];
$data[$temp] = Division::model()->findByPk($n['division_id'])->division_code;
}
}
}
//$data=CHtml::listData($data,'division_id','division_code');
foreach ($data as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
echo "<tr align=center> <th colspan = 15 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 "<tr><th colspan=16><h3> Branch of ".$branch_model->branch_name." Semester-".$acd_model->academic_term_name." Students Attendence of Date-".date("d-m-Y", strtotime($date))." Report</h3></th> </tr>";
echo "<tr><th colspan=2><b> Academic Year </b></th> <th colspan = 10 ><b> ".$pe_data->academic_term_period."</b></th></tr>";
echo "<tr align=center>";
echo "<th rowspan=6>SI No.</th>";
echo "<th rowspan=6 >Enroll No</th>";
echo "<th rowspan=6 colspan=5>Student Name</th>";
echo "<th colspan=10> No. Of Lectures </th></tr><tr>";
$j=1;
$lec_hour=1;
$comb_subject=array();
for($i=1;$i<=$lecture;$i++)
{
$check_timetable=TimeTableDetail::model()->findAll(
array('condition'=>'acdm_name_id='.$sem.' and branch_id='.$branch.' and lecture_date="'.$date.'" and lec='.$i.' and proxy_status <> 1 order by lec '));
$f=0;
if(empty($check_timetable))
{
echo "<th >$i</th>";
$cols[]=1;
$subject[]=0;
$batch[]=0;
$faculty[]=0;
$lectures[]=0;
$comb_subject[]=0;
$j++;
}
else
height: 39px;
padding: 9px;
}
');
$current_date = date('Y-m-d');
$criteria = new CDbCriteria;
$criteria->condition = 'current_sem = 1';
$semname = AcademicTerm::model()->findAll($criteria);
$data = CHtml::listData($semname,'academic_term_id','academic_term_id');
$stud_model=StudentTransaction::model()->findByPk(Yii::app()->user->getState('stud_id'));
$check_sem = in_array($stud_model->student_academic_term_name_id, $data);
$timetableid=0;
$check_timetable=TimeTableDetail::model()->findAllByAttributes(
array(
'acdm_name_id' => $stud_model->student_academic_term_name_id,
'division_id' => $stud_model->student_transaction_division_id,
'lecture_date'=>$current_date,
),'proxy_status <> :status', array(':status'=>1));
if($check_timetable) {?>
<div class="wob wob-in-top-threshold wob-0-degrees read-only" style="height: 444px; width: 525px; z-index: 1;">
<div class="timeline textstream widget news-stream google-news vertical">
<div class="widget-header">
<i class="header-icon"></i>
<div class="title">Time Table</div>
</div>
<div class="timeline-items-wrapper">
<?php
</div>
<!-- Employee birthday Complete-->
<?php
$current_date = date('Y-m-d');
$criteria = new CDbCriteria;
//$criteria->select = 'academic_term_id';
$criteria->condition = 'current_sem = 1 AND academic_term_organization_id = '.Yii::app()->user->getState('org_id');
$data_arr = 0;
$semname = AcademicTerm::model()->findAll($criteria);
if($semname){
$data = CHtml::listData($semname,'academic_term_id','academic_term_id');
$data_arr = implode(',',$data);
}
$timetable_criteria = new CDbCriteria;
$timetable_criteria->condition = 'acdm_name_id in ('.$data_arr.') AND faculty_emp_id = '.Yii::app()->user->getState('emp_id').' AND lecture_date = "'.date('Y-m-d').'" order by lec';
$time_table_details = TimeTableDetail::model()->findAll($timetable_criteria);
if($time_table_details) {
?>
<div class="box">
<div class="box-header">
<h1>Your Timetable</h1>
</div>
<div class="box-content">
<?php
$timetable = TimeTable::model()->findByPk($time_table_details[0]->timetable_id);
$time1 = date('H:i A',strtotime($timetable['clg_start_time']));
if($timetable->zero_lec==1)
protected function renderContent()
{
$current_date = date('Y-m-d');
if (Yii::app()->user->getState('stud_id')) {
$criteria = new CDbCriteria();
//$criteria->select = 'academic_term_id'; // select fields which you want in output
$criteria->condition = 'current_sem = 1 AND academic_term_organization_id = ' . Yii::app()->user->getState('org_id');
$semname = AcademicTerm::model()->findAll($criteria);
$data = CHtml::listData($semname, 'academic_term_id', 'academic_term_id');
$stud_model = StudentTransaction::model()->findByPk(Yii::app()->user->getState('stud_id'));
$check_sem = in_array($stud_model->student_academic_term_name_id, $data);
$timetableid = 0;
if (!$check_sem) {
echo "<h3 align=center style=color:red>Sorry, No timetable available for this student.</h3>";
} else {
$check_timetable = TimeTableDetail::model()->findAllByAttributes(array('acdm_name_id' => $stud_model->student_academic_term_name_id, 'division_id' => $stud_model->student_transaction_division_id, 'lecture_date' => $current_date), 'proxy_status <> :status', array(':status' => 1));
if (empty($check_timetable)) {
echo "<h3 align=center style=color:red>Sorry, No timetable available for this student.</h3>";
} else {
$timetable = TimeTable::model()->findByPk($check_timetable[0]->timetable_id);
$time1 = date('H:i A', strtotime($timetable['clg_start_time']));
if ($timetable->zero_lec == 1) {
$time[] = $time1;
} else {
$time[1] = $time1;
}
$lec_dur = LecDuration::model()->findAll(array('condition' => 'timetable_id=' . $timetable['timetable_id']));
foreach ($lec_dur as $list) {
$break = NoOfBreakTable::model()->findByAttributes(array('after_lec_break' => $list['lecture'], 'timetable_id' => $timetable['timetable_id']));
if ($break) {
$dur1 = date('i', strtotime($break['duration']));
$timestamp = strtotime($time1) + 60 * $dur1;
$time1 = date('g:i A', $timestamp);
$timestamp = strtotime($time1) + 60 * $list['duration'];
$time1 = date('g:i A', $timestamp);
$time[] = $time1;
} else {
$timestamp = strtotime($time1) + 60 * $list['duration'];
$time1 = date('g:i A', $timestamp);
$time[] = $time1;
}
}
print '<table id="time-table-struc" style="font-size:10px;">';
print '<tr>';
print '<th>Lecture No.</th>';
print '<th>Subject</th>';
print '<th>Faculty Name</th>';
print '<th>Room No.</th>';
print '<th>Time</th>';
foreach ($check_timetable as $list) {
if ($list->subject_type != 1 && $list->batch_id != $stud_model->student_transaction_batch_id) {
continue;
}
print '<tr>';
print '<td>' . $list->lec . '</td>';
print '<td>' . SubjectMaster::model()->findByPk($list->subject_id)->subject_master_alias . '</td>';
print '<td>' . EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id' => $list->faculty_emp_id))->employee_first_name . '</td>';
print '<td>' . RoomDetailsMaster::model()->findByPk($list->room_id)->room_name . '</td>';
print '<td>' . $time[$list->lec] . '</td></tr>';
}
print '</table>';
}
}
} else {
if (Yii::app()->user->getState('emp_id')) {
$criteria = new CDbCriteria();
//$criteria->select = 'academic_term_id';
$criteria->condition = 'current_sem = 1 AND academic_term_organization_id = ' . Yii::app()->user->getState('org_id');
$semname = AcademicTerm::model()->findAll($criteria);
$data = CHtml::listData($semname, 'academic_term_id', 'academic_term_id');
$data_arr = implode(',', $data);
$timetable_criteria = new CDbCriteria();
$timetable_criteria->condition = 'acdm_name_id in (' . $data_arr . ') AND faculty_emp_id = ' . Yii::app()->user->getState('emp_id') . ' AND lecture_date = "' . date('Y-m-d') . '"';
$time_table_details = TimeTableDetail::model()->findAll($timetable_criteria);
if ($time_table_details) {
$timetable = TimeTable::model()->findByPk($time_table_details[0]->timetable_id);
$time1 = date('H:i A', strtotime($timetable['clg_start_time']));
if ($timetable->zero_lec == 1) {
$time[] = $time1;
} else {
$time[1] = $time1;
}
$lec_dur = LecDuration::model()->findAll(array('condition' => 'timetable_id=' . $timetable['timetable_id']));
foreach ($lec_dur as $list) {
$break = NoOfBreakTable::model()->findByAttributes(array('after_lec_break' => $list['lecture'], 'timetable_id' => $timetable['timetable_id']));
if ($break) {
$dur1 = date('i', strtotime($break['duration']));
$timestamp = strtotime($time1) + 60 * $dur1;
$time1 = date('g:i A', $timestamp);
$timestamp = strtotime($time1) + 60 * $list['duration'];
$time1 = date('g:i A', $timestamp);
$time[] = $time1;
} else {
$timestamp = strtotime($time1) + 60 * $list['duration'];
$time1 = date('g:i A', $timestamp);
$time[] = $time1;
}
}
print '<table id="time-table-struc" style="font-size:10px;">';
print '<tr>';
print '<th>Lecture No.</th>';
print '<th>Branch</th>';
print '<th>Sem</th>';
print '<th>Division</th>';
print '<th>Subject</th>';
print '<th>Room No.</th>';
print '<th>Time</th>';
foreach ($time_table_details as $list) {
print '<tr>';
print '<td>' . $list->lec . '</td>';
print '<td>' . Branch::model()->findByPk($list->branch_id)->branch_name . '</td>';
print '<td>' . AcademicTerm::model()->findByPk($list->acdm_name_id)->academic_term_name . '</td>';
print '<td>' . Division::model()->findByPk($list->division_id)->division_code . '</td>';
print '<td>' . SubjectMaster::model()->findByPk($list->subject_id)->subject_master_alias . '</td>';
print '<td>' . RoomDetailsMaster::model()->findByPk($list->room_id)->room_name . '</td>';
print '<td>' . $time[$list->lec] . '</td></tr>';
}
print '</table>';
} else {
echo "<h3 align=center style=color:red>Sorry, No timetable available.</h3>";
}
}
}
}
<th>Date</th>
</tr>
<?php
$proxy_data=TimeTableDetail::model()->findAllByAttributes(
array(),
$condition = 'timetable_id = :timetable_id and division_id = :div_id and lecture_date >= :start and lecture_date< :end and proxy_status = :proxy order by lec',
$params = array(
':timetable_id' => $timetableid,
':div_id'=>$stud_model->student_transaction_division_id,
':start'=>date('Y-m-d',strtotime($alldate[0])),
':end'=>date('Y-m-d',strtotime($alldate[5])),
':proxy'=>1,
));
$n = 0;
foreach($proxy_data as $list) {
$result = TimeTableDetail::model()->findByPk($list->proxy_id);
?>
<tr>
<td><?php echo ++$n; ?></td>
<td><?php echo EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>$list->faculty_emp_id))->employee_first_name; ?></td>
<td><?php echo EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>$result->faculty_emp_id))->employee_first_name; ?></td>
<td><?php echo SubjectMaster::model()->findByPk($result->subject_id)->subject_master_alias; ?></td>
<td><?php echo $result->lec; ?></td>
<td><?php echo date('d-m-Y',strtotime($result->lecture_date)); ?></td>
</tr>
<?php } ?>
</table></div>
<?php
}
public function actionAttendencedivisionreport() //changes done by janvi.
{
$model = new Attendence;
$model->scenario = 'attendencedivisionreport';
$this->performAjaxValidation($model);
$month = null;
$student=array();
$subject_data=array();
$sid=array();
$subject=0;
$subjectid=array();
$deleivered_topic=array();
if(isset($_POST['Attendence'])|| isset($_REQUEST['branch_id']))
{
$query=null;
$timetable_query=null;
if(!empty($_REQUEST['branch_id']))
{
$branch = $_REQUEST['branch_id'];
$query .="branch_id=".$branch. " AND ";
$timetable_query.="branch_id=".$branch. " AND ";
}
else
{
$branch =$_POST['Attendence']['branch_id'];
$query .="branch_id=".$branch. " AND ";
$timetable_query.="branch_id=".$branch. " AND ";
}
if(!empty($_REQUEST['sem_id']))
{
$sem = $_REQUEST['sem_id'];
$query .="sem_name_id=".$sem. " AND ";
$timetable_query.="acdm_name_id=".$sem. " AND ";
}
else
{
$sem =$_POST['Attendence']['sem_name_id'];
$query .="sem_name_id=".$sem." AND ";
$timetable_query.="acdm_name_id=".$sem. " AND ";
}
if(!empty($_REQUEST['div_id']))
{
$div=$_REQUEST['div_id'];
$query .="div_id=".$div;
$timetable_query.="division_id=".$div. " AND ";
}
if(!empty($_POST['Attendence']['div_id']))
{
$div=$_POST['Attendence']['div_id'];
$query .="div_id=".$div;
$timetable_query.="division_id=".$div. " AND ";
}
if(!empty($_POST['months']) && !empty($_POST['subject']) || !empty($_REQUEST['month']) && !empty($_REQUEST['subject']) )
{
if(!empty($_REQUEST['month']))
{
$month=$_REQUEST['month'];
$subject=$_REQUEST['subject'];
$timetable_query.="subject_id=".$subject." AND ";
}
else
{
$month = $_POST['months'];
$subject=$_POST['subject'];
$timetable_query.="subject_id=".$subject." AND ";
}
//query for display list of regular student attendence( not to display detain/left student)
$student=Attendence::model()->findAll(array(
'select'=>'st_id','distinct'=>true,
'condition'=>$query));
$timetabledetail=TimeTableDetail::model()->findAll(array('select'=>'lecture_date,actual_topic,lect_hour','condition'=>$timetable_query.' month(lecture_date)='.$month,'order' => 'lecture_date ASC'));
$timetable=array();
foreach($timetabledetail as $t)
{
if($t['actual_topic']!='')
$deleivered_topic[$t['lecture_date']]=$t['actual_topic'];
}
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'];
}
}
if(isset($_REQUEST['pdf']))
{
Yii::import('application.extensions.tcpdf.*');
require_once('tcpdf/tcpdf.php');
require_once('tcpdf/config/lang/eng.php');
$html = $this->renderPartial('attendence_division_pdf', array('total'=>$total,
'present'=>$present,
'subject'=>$sub,
'div_id'=>$div
),
true);
//$session->close();
//die($html);
ob_clean();
$pdf = new TCPDF();
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(Yii::app()->name);
$pdf->SetTitle('Division Attendence Report');
$pdf->SetSubject('Division Attendence Report');
$pdf->SetKeywords('example, text, report');
$pdf->SetHeaderData('', 0, "Division Attendence", '');
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Example Report by ".Yii::app()->name, "");
$pdf->setHeaderFont(Array('helvetica', '', 8));
$pdf->setFooterFont(Array('helvetica', '', 6));
$pdf->SetMargins(15, 18, 15);
$pdf->SetHeaderMargin(5);
$pdf->SetFooterMargin(10);
$pdf->SetAutoPageBreak(TRUE, 15);
$pdf->SetFont('dejavusans', '', 7);
$resolution= array(150, 150);
$pdf->AddPage('P', $resolution);
$pdf->writeHTML($html, true, false, true, false, '');
$pdf->LastPage();
$pdf->Output("attendenceDivision.pdf", "I");
}
else if(isset($_REQUEST['excel']))
{
Yii::app()->request->sendFile(date('YmdHis').'.xls',
$this->renderPartial('attendence_division_pdf', array(
'branch_id'=>$branch,
'div_id'=>$div,
'student_id'=>$sid,
'month'=>$month,
'selsub'=>$subject,
'sem'=>$sem,
'deleivered_topic'=>$deleivered_topic,
),
true));
}
else if(isset($_REQUEST['studentpdf']))
{
Yii::import('application.extensions.tcpdf.*');
require_once('tcpdf/tcpdf.php');
require_once('tcpdf/config/lang/eng.php');
$html = $this->renderPartial('divisionwise_student_attendance_pdfexcel', array('total'=>$total,
'present'=>$present,
'subject'=>$sub,
'div_id'=>$div,
'sub_id'=>$subject,
'all_data'=>$all_data,
'subjectid'=>$subjectid,
'subject_data'=>$subject_data,
'student_data'=>$student_data,
'sid'=>$sid,
'start'=>$start,'end'=>$end,'month_value'=>$month,'year'=>$year
),
true);
//$session->close();
//die($html);
ob_clean();
$pdf = new TCPDF();
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(Yii::app()->name);
$pdf->SetTitle('Division Attendence Report');
$pdf->SetSubject('Division Attendence Report');
$pdf->SetKeywords('example, text, report');
$pdf->SetHeaderData('', 0, "Division Attendence", '');
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Example Report by ".Yii::app()->name, "");
$pdf->setHeaderFont(Array('helvetica', '', 8));
$pdf->setFooterFont(Array('helvetica', '', 6));
$pdf->SetMargins(15, 18, 15);
$pdf->SetHeaderMargin(5);
$pdf->SetFooterMargin(10);
$pdf->SetAutoPageBreak(TRUE, 15);
$pdf->SetFont('dejavusans', '', 7);
$resolution= array(150, 150);
$pdf->AddPage('P', $resolution);
$pdf->writeHTML($html, true, false, true, false, '');
$pdf->LastPage();
$pdf->Output("StudentAttendance.pdf", "I");
}
else if(isset($_REQUEST['studentexcel']))
{
Yii::app()->request->sendFile(date('YmdHis').'.xls',
$this->renderPartial('divisionwise_student_attendance_pdfexcel', array('total'=>$total,
'present'=>$present,
'subject'=>$sub,
'div_id'=>$div,
'sub_id'=>$subject,
'all_data'=>$all_data,
'subjectid'=>$subjectid,
),
true));
}
else
{
$this->render('attendence_division_report_view',array(
'branch_id'=>$branch,
'div_id'=>$div,
'student_id'=>$sid,
'month'=>$month,
'selsub'=>$subject,
'subjectid'=>$subjectid,
'sem'=>$sem,
'deleivered_topic'=>$deleivered_topic,
));
}
}
else
{
$this->render('attendence_division_report',array('model'=>$model));
}
}
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;
}
}
