public function actionTakeFees()
{
$model = new StudentTransaction('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['StudentTransaction'])) {
$model->attributes = $_GET['StudentTransaction'];
}
$this->render('takeFees', array('stud_model' => $model));
}
public function beforesave()
{
$student_id = $_REQUEST['student_id'];
$criteria = new CDbCriteria();
$stud_trans = StudentTransaction::model()->findByPk($student_id);
$criteria->condition = 'fees_student_id =' . $student_id . ' AND fees_academic_period_id=' . $stud_trans['student_academic_term_period_tran_id'] . ' AND fees_academic_term_id=' . $stud_trans['student_academic_term_name_id'];
$listofid = FeesPaymentTransaction::model()->findAll($criteria);
$total_fees_amount = 0;
$fees_stru = Yii::app()->db->createCommand()->select('fees.fees_master_id , fees.fees_master_name , fees.fees_branch_id , stud.student_transaction_branch_id , stud.student_transaction_organization_id , fees.fees_organization_id , stud.student_transaction_quota_id , fees.fees_quota_id ,stud.student_academic_term_period_tran_id , fees.fees_academic_term_id, fees.fees_academic_term_name_id, fees.fees_master_total')->from('student_transaction stud')->join('fees_master fees', 'stud.student_transaction_branch_id = fees.fees_branch_id
AND stud.student_academic_term_period_tran_id = fees.fees_academic_term_id
AND stud.student_academic_term_name_id = fees.fees_academic_term_name_id
AND stud.student_transaction_organization_id = fees.fees_organization_id
AND stud.student_transaction_quota_id = fees.fees_quota_id')->where('stud.student_transaction_id=:id', array(':id' => $student_id))->queryRow();
$student_fees = StudentFeesMaster::model()->findAll('fees_master_table_id = :fees_master_id AND student_fees_master_student_transaction_id = :student_id', array(':fees_master_id' => $fees_stru['fees_master_id'], ':student_id' => $student_id));
foreach ($student_fees as $fees_data) {
$total_fees_amount += $fees_data->fees_details_amount;
}
$cash_total = 0;
$cheque_total = 0;
$total = 0;
if ($listofid != null) {
foreach ($listofid as $list) {
if ($list->fees_payment_method_id == 1) {
$cash_total = $cash_total + FeesPaymentCash::model()->findByPk($list->fees_payment_cash_cheque_id)->fees_payment_cash_amount;
} else {
$amount = FeesPaymentCheque::model()->findByAttributes(array('fees_payment_cheque_status' => 0, 'fees_payment_cheque_id' => $list->fees_payment_cash_cheque_id));
$cheque_total = $cheque_total + $amount['fees_payment_cheque_amount'];
}
}
echo "<div class='total-amount'><h4>Total Paid Fees : <b>" . ($total = $cash_total + $cheque_total . '</b></h4></div>');
//$total_fees_amount = FeesMaster::model()->findByPk($list->fees_payment_master_id)->fees_master_total;
if ($this->isNewRecord) {
$grand_total = $total + $this->fees_payment_cash_amount;
} else {
$update_total = FeesPaymentCash::model()->findByPk($_REQUEST['id'])->fees_payment_cash_amount;
$grand_total = $total - $update_total + $this->fees_payment_cash_amount;
}
if ($total_fees_amount < $grand_total) {
$this->addError('fees_payment_cash_amount', 'You can not take an advance fees for student.');
return false;
} else {
return true;
}
} else {
if ($this->fees_payment_cash_amount > $total_fees_amount) {
$this->addError('fees_payment_cash_amount', 'You can not take an advance fees for student.');
return false;
} else {
return true;
}
}
}
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
$st_tran = StudentTransaction::model()->findAll(array('condition' => 'course_id=' . $id));
$batch_d = Batch::model()->findAll(array('condition' => 'course_id=' . $id));
if (!empty($st_tran)) {
throw new CHttpException(400, 'You can not delete this record because it is used in another table.');
} else {
$this->loadModel($id)->delete();
foreach ($batch_d as $b) {
Batch::model()->findByPk($b->batch_id)->delete();
}
}
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if (!isset($_GET['ajax'])) {
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
}
public function actionRecpt_list()
{
$this->layout = 'receipt_layout';
$misc_fees_payment = MiscellaneousFeesPaymentCheque::model()->findByPk($_REQUEST['id']);
$model = StudentTransaction::model()->findByPk($misc_fees_payment->miscellaneous_fees_payment_cheque_student_id);
$stud_id = $model->student_transaction_student_id;
$stud_model = StudentInfo::model()->findByPk($model->student_transaction_student_id);
$acd_term = AcademicTermPeriod::model()->findByPk($model->student_academic_term_period_tran_id);
$branch = Branch::model()->findByPk($model->student_transaction_branch_id);
//print_r($_REQUEST['id']);
//print "<br/>model".$misc_fees_payment->miscellaneous_fees_payment_cash_student_id;
//print "<br/>reciept_no".$misc_fees_payment->miscellaneous_fees_payment_cash_receipt_id;
//print "<br/>stud_id".$model->student_transaction_student_id;
//print "<br/>curent date".date('d/m/y');
//print "<br/>stud_model".$stud_model->student_first_name.''.$stud_model->student_middle_name.''.$stud_model->student_last_name;
//print "<br/>dbdate".$misc_fees_payment->miscellaneous_fees_payment_cash_creation_date;
//print "<br/>branch_name".$branch->branch_name;
//print "<br/>academic_term".$acd_term->academic_terms_period_name;
//print "</br>roll no".$stud_model->student_roll_no;
//exit;
$this->render('recpt_list', array('model' => $model, 'stud_model' => $stud_model, 'acd_term' => $acd_term, 'branch' => $branch, 'misc_fees_payment' => $misc_fees_payment));
}
<?php
$lis = CHtml::listData($studModel,'student_transaction_id','student_transaction_id');
$st_str = implode(',',$lis);
if(Yii::app()->controller->action->id!="certiview") {
echo CHtml::button('Save',array('id'=>"printid1",'class'=>'submit','submit' => array('certificate/savemultiplecerti','stid'=>$st_str,'ctype'=>$model->certificatetype)));
echo CHtml::link('GO BACK', array('certificate/certificategeneration'),array('class'=>'btnback'));
}
else {
if(!empty($_REQUEST['studid']))
echo CHtml::link('GO BACK', array('student/studentTransaction/studentcertificate','id'=>$_REQUEST['studid']),array('class'=>'btnback'));
}
foreach($studModel as $list) {
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>$list['student_transaction_id']));
if($stud_info)
{
$trans = StudentTransaction::model()->findByPk($stud_info->student_info_transaction_id);
$titl = "<b>".$stud_info->title."</b>";
$name = "<b>".$stud_info->student_first_name." ".$stud_info->student_middle_name." ".$stud_info->student_last_name."</b>";
$smobile = "<b>".$stud_info->student_mobile_no."</b>";
$pmobile = "<b>".$stud_info->student_guardian_mobile."</b>";
$branch_model=Branch::model()->findByPk($trans->student_transaction_branch_id);
$en_no = "<b>".$stud_info->student_enroll_no."</b>";
$branch = "<b>".$branch_model->branch_name."</b>";
$sem = "<b>Sem-".AcademicTerm::model()->findByPk($trans->student_academic_term_name_id)->academic_term_name."</b>";
if($trans->student_transaction_division_id != 0)
$div = "<b>".Division::model()->findByPk($trans->student_transaction_division_id)->division_name."</b>";
else
$div = '-';
$photos=StudentPhotos::model()->findByPk($trans->student_transaction_student_photos_id)->student_photos_path;
$photo=CHtml::image(Yii::app()->request->baseUrl.'/college_data/stud_images/'.$photos,'image',array('width'=>120,'height'=>140,'class'=>'photo','style'=>'padding-right:0px;','border'=>1));
public function actionStudentFinalViewExportToPdf($id)
{
$student_docs = StudentDocsTrans::model()->findAll('student_docs_trans_user_id=' . $id);
$studentqualification = StudentAcademicRecordTrans::model()->findAll('student_academic_record_trans_stud_id=' . $id);
$student_transaction = StudentTransaction::model()->findAll('student_transaction_id=' . $id);
$studentfeedbackdetailstable = FeedbackDetailsTable::model()->findAll('feedback_details_table_student_id=' . $id);
$html = $this->renderPartial('/studentTransaction/studentfinalview', array('student_docs' => $student_docs, 'studentqualification' => $studentqualification, 'student_transaction' => $student_transaction, 'studentfeedbackdetailstable' => $studentfeedbackdetailstable), true);
$this->exporttopdf('Stundent Report', 'StundentFinalView.pdf', $html);
}
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>";
}
}
}
}
<th>Branch</th>
<th>Semester</th>
<th>Academic Year</th>
<th>Division</th>
<th>Date</th>
<th>Amount Type</th>
<th>Bank Name</th>
<th>Cheque No</th>
<th>Receipt No</th>
<th>Amount</th>
</tr>
<?php
foreach ($var as $list) {
$stud_data = StudentTransaction::model()->findByPk($list['fees_student_id']);
echo '<tr><td>' . $i . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_enroll_no . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_roll_no . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_first_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_middle_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_last_name . '</td>';
echo '<td>' . Branch::model()->findByPk($stud_data->student_transaction_branch_id)->branch_name . '</td>';
echo '<td>' . AcademicTerm::model()->findByPk($stud_data->student_academic_term_name_id)->academic_term_name . '</td>';
echo '<td>' . AcademicTermPeriod::model()->findByPk($stud_data->student_academic_term_period_tran_id)->academic_term_period . '</td>';
echo '<td>' . Division::model()->findByPk($stud_data->student_transaction_division_id)->division_name . '</td>';
echo '<td>' . $list['fees_received_date'] . '</td>';
$rec_no = FeesReceipt::model()->findByPk($list['fees_receipt_id'])->fees_receipt_number;
if ($list['fees_payment_method_id'] == '1') {
$cash_id = $list['fees_payment_cash_cheque_id'];
$amunt = FeesPaymentCash::model()->findByPk($cash_id)->fees_payment_cash_amount;
$final_total += $amunt;
$type = "Cash";
/*
$this->menu=array(
array('label'=>'List StudentFeesMaster', 'url'=>array('index')),
array('label'=>'Create StudentFeesMaster', 'url'=>array('create')),
array('label'=>'View StudentFeesMaster', 'url'=>array('view', 'id'=>$model->student_fees_master_id)),
array('label'=>'Manage StudentFeesMaster', 'url'=>array('admin')),
);*/
?>
<h1>Edit Student Fees <?php
//echo $model->student_fees_master_id;
?>
</h1></br>
<?php
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $model->student_fees_master_student_transaction_id));
$stud_tran_info = StudentTransaction::model()->findByPk($model->student_fees_master_student_transaction_id);
$academic_period = AcademicTermPeriod::model()->findByPk($stud_tran_info->student_academic_term_period_tran_id)->academic_term_period;
$semester = AcademicTerm::model()->findByPk($stud_tran_info->student_academic_term_name_id)->academic_term_name;
?>
<table border="2px" id="twoColThinTable">
<tr class="row">
<td class="col1">Name </td>
<td class="col2"><?php
echo $stud_info->student_first_name . ' ' . $stud_info->student_middle_name . ' ' . $stud_info->student_last_name;
?>
</td>
</tr>
<tr class="row">
<td class="col1">Enrollment No. </td>
<td class="col2"><?php
$("#add-tab").click(function(event) {
$('#updateData').attr('href', editLinkPath + '/student/studentTransaction/updateprofiletab4?id=' + '<?php echo $_REQUEST["id"]; ?>');
});
$("#personal-tab").click(function(event) {
$('#updateData').attr('href', editLinkPath + '/student/studentTransaction/updateprofiletab1?id=' + '<?php echo $_REQUEST["id"]; ?>');
});
});
</script>
<div class="clear-div"></div>
<div class="profile-page-box">
<!--===============================Page header start============================-->
<div class="page-title-header"><i class="fa fa-plus"></i> View Student Profile</div>
<!--===============================Page header end============================-->
<?php $studInfo = StudentTransaction::model()->findByPk($_REQUEST['id']);
$stdpicPath = StudentPhotos::model()->findByPk($studInfo->student_transaction_student_photos_id);
$stud_photo=Yii::app()->baseUrl."/college_data/stud_images/".$stdpicPath->student_photos_path;
?>
<!--Profile Tab Start-->
<div class="profile-box-bg">
<div class="profilebox-left">
<div class="profile-image-tab">
<a title="Change Picture" href ="<?php echo Yii::app()->baseUrl.'/student/studentTransaction/updateprofilephoto?id='.$_REQUEST['id']; ?>">
<div class="profile-box-user"><img src="<?php echo $stud_photo;?>" width="200" height="200"></div></a>
</div>
</div>
<div class="profilebox-middle" style="font-family : sans-serif; ">
<div class="profile-username"><?php echo $studInfo->Rel_Stud_Info->student_first_name.' '.$studInfo->Rel_Stud_Info->student_last_name ;?> </div>
<div style="color: rgb(85, 85, 85); font-size: 15px; height: 35px; line-height: 35px;"><i class="fa fa-graduation-cap" style="width: 30px; color: #D9534F;"></i> Course : <?php echo (!empty($studInfo->Rel_course->course_name) ? $studInfo->Rel_course->course_name : "Not Set");?></div>
<div style="color: rgb(85, 85, 85); font-size: 15px; height: 35px; line-height: 35px;"><i class="fa fa-sitemap" style="width: 30px; color: #D9534F;"></i> Batch : <?php echo (!empty($studInfo->Rel_Batch->batch_name) ? $studInfo->Rel_Batch->batch_name : "Not Set");?></div>
foreach($sid as $s)
{
if(($m%2) == 0)
{
$class = "odd";
}
else
{
$class = "even";
}
echo '<tr align=center>';
echo '<td>';
echo ++$m;
echo '</td>';
$stud_tran=StudentTransaction::model()->findByPk($s);
$stud_name=StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>$s));
echo '<td>';
if(!empty($stud_name->student_enroll_no))
echo $stud_name->student_enroll_no;
else
echo 'Not Set';
echo '</td>';
$batch='';
echo '<td colspan=5 align=left>';
if($stud_tran->student_transaction_batch_id!=0)
$batch= Batch::model()->findByPk($stud_tran->student_transaction_batch_id)->batch_code;
echo $stud_name->student_first_name.' '.$stud_name->student_last_name.' ( '.$stud_name->student_roll_no.' )'.'('.$batch.')';
echo '</td>';
$cs=0;
for($l=0;$l<count($lectures);$l++)
<?php
$student_name = StudentInfo::model()->findByPk(StudentTransaction::model()->findByPk($_REQUEST['id'])->student_transaction_student_id);
$org_id = Yii::app()->user->getState('org_id');
$fees = FeesPaymentTransaction::model()->findAll('fees_student_id=' . $_REQUEST['id'] . ' and fees_payment_transaction_organization_id = ' . $org_id);
if (!empty($fees)) {
?>
<?php
$i = 1;
$m = 1;
$k = 0;
$var = 0;
$out = 0;
$payable = 0;
$payable1 = 0;
$term_id = 0;
$ch_num = "";
$temp = 0;
foreach ($fees as $f) {
$flag = 0;
$columns = array();
$columns['id'] = $m;
$columns['acdm_period'] = AcademicTermPeriod::model()->findByPk($f->fees_academic_period_id)->academic_term_period;
$columns['sem'] = AcademicTerm::model()->findByPk($f->fees_academic_term_id)->academic_term_name;
$columns['method'] = FeesPaymentMethod::model()->findByPk($f->fees_payment_method_id)->fees_payment_method_name;
if ($f->fees_payment_method_id == 1) {
if ($m == 1) {
$term_id = $f->fees_academic_term_id;
public function actionMysubjects()
{
$org = Yii::app()->user->getState('org_id');
$sub_model = array();
$emp_str = array();
if(Yii::app()->user->getState('stud_id')){
$trans_id = Yii::app()->user->getState('stud_id');
$trans_model = StudentTransaction::model()->findByPk($trans_id);
$sub_model = SubjectMaster::model()->findAll(array('condition'=>'subject_master_academic_terms_name_id='.$trans_model->student_academic_term_name_id.' and subject_master_branch_id='.$trans_model->student_transaction_branch_id.' and subject_master_organization_id='.$org));
foreach($sub_model as $list){
$subject_data = Yii::app()->db->createCommand()
->select('employee_first_name')
->from('assign_subject')
->join('employee_info','employee_info_transaction_id=subject_faculty_id')
->where('subject_id='.$list['subject_master_id'])
->queryAll();
$data = CHtml::listData($subject_data,'employee_first_name','employee_first_name');
if($data)
$emp_str[$list['subject_master_id']] = implode(',',$data);
else
$emp_str[$list['subject_master_id']] = "<i>Not Assigned<i>";
}
}
$this->render('my_subjects',array('sub_model'=>$sub_model,'emp_str_array'=>$emp_str));
}
{ ?>
<th> </th>
<?php }?>
</tr>
<?php
$paidFees = Yii::app()->db->createCommand()
->select('*')
->from('fees_payment_transaction')
->where('fees_payment_student_id ='.$_REQUEST['id'])
->queryAll();
$fees = Yii::app()->db->createCommand()
->select('batch_fees')
->from('batch as b')
->join('course as c','b.course_id=c.course_id')
->where('b.batch_id='.StudentTransaction::model()->findByPk($_REQUEST['id'])->student_transaction_batch_id)
->queryRow();
if(!empty($paidFees)) {
$i=1;
foreach($paidFees as $details)
{
echo '<tr align="center">';
echo '<td>'.$i.'</td>';
echo '<td>'.date_format(new DateTime($details['fees_payment_received_date']),'d-m-Y').'</td>';
//echo '<td>'.$fees['course_fees'].'</td>';
echo '<td>'.$details['fees_payment_type'].'</td>';
echo '<td>'.$details['fees_payment_amount'].'</td>';
echo '<td>'.$details['fees_payment_cheque_number'].'</td>';
echo '<td>'.$details['fees_payment_receipt_no'].'</td>';
if(Yii::app()->user->checkAccess('Fees.FeesPaymentTransaction.Updatefeescash') && Yii::app()->user->checkAccess('Fees.FeesPaymentTransaction.Updatefeescheque'))
public function loadAllNotice($list)
{
$menu = null;
foreach($list as $notice) {
$menu .= '<div class="notify-data notifiche">';
$menu .='<span class="username">';
$menu .=$notice->title;
$menu .='</span></br>';
$menu .='<span class="notice-lable"><b>From</b></span><span class="notice-content">';
$menu .=(User::model()->findByPk($notice->from)->user_type=='employee')?(EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id'=>$notice->from))->employee_transaction_id)))->employee_first_name):(StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>(StudentTransaction::model()->findByAttributes(array('student_transaction_user_id'=>$notice->from))->student_transaction_id)))->student_first_name);
$menu .='</span><span class="notice-lable"><b>Content</b></span>';
$menu .='<span class="notice-content">'.$notice->content.'</span></div>';
}
return $menu;
}
public function actionPayfeescheque()
{
$model=new FeesPaymentTransaction;
$model->scenario="feespaycheque";
if(isset($_POST['FeesPaymentTransaction']))
{
$model->attributes=$_POST['FeesPaymentTransaction'];
$model->fees_payment_received_date=new CDbExpression('NOW()');
$model->fees_payment_user_id = Yii::app()->user->id;
$model->fees_payment_type = 'Cheque';
$receipt_no = Yii::app()->db->createCommand()
->select('MAX(fees_payment_receipt_no) as receipt_id')
->from('fees_payment_transaction')
->queryRow();
$model->fees_payment_receipt_no = $receipt_no['receipt_id']+1;
$model->fees_payment_student_id = $_REQUEST['id'];
$model->fees_payment_cheque_date = date('Y-m-d', strtotime($_POST['FeesPaymentTransaction']['fees_payment_cheque_date']));
$academic=StudentTransaction::model()->findByPk($_REQUEST['id']);
$model->fees_payment_batch_id = $academic->student_transaction_batch_id;
$model->fees_student_academic_term_id= $academic->academic_term_id;
$model->fees_student_academic_term_period_id=$academic->academic_term_period_id;
$model->fees_student_course_id=$academic->course_id;
if($model->save())
$this->redirect(array('create','id'=>$model->fees_payment_student_id));
}
$this->render('payfeescheque',array(
'model'=>$model
));
}
$k = 1;
foreach ($fees_info as $my_list) {
$org_id = Yii::app()->user->getState('org_id');
//echo $org_id;
//echo $end;
//echo $list['fees_receipt_id'].'<br >';
$data = FeesPaymentTransaction::model()->findByAttributes(array('fees_receipt_id' => $my_list, 'fees_payment_transaction_organization_id' => $org_id));
$field1 = '-';
$field2 = '-';
$field3 = '-';
$field4 = '-';
$field5 = 'CASH';
//var_dump($data);
if ($data) {
$f = 0;
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id']));
$stud_model = StudentInfo::model()->findByAttributes(array('student_id' => $stud_trans['student_transaction_student_id']));
$sem_name = AcademicTerm::model()->findByPk($data['fees_academic_term_id']);
$branch = Branch::model()->findByPk($stud_trans['student_transaction_branch_id']);
$acd_term = AcademicTermPeriod::model()->findByPk($data['fees_academic_period_id']);
if ($data->fees_payment_method_id == 1) {
$cash_amt = FeesPaymentCash::model()->findByPk($data->fees_payment_cash_cheque_id);
$amount = $cash_amt->fees_payment_cash_amount;
} else {
$cash_amt = FeesPaymentCheque::model()->findByPk($data->fees_payment_cash_cheque_id);
$amount = $cash_amt->fees_payment_cheque_amount;
$field1 = $cash_amt->fees_payment_cheque_number;
$date = date_create($cash_amt->fees_payment_cheque_date);
$field2 = date_format($date, 'd-m-Y');
$bank_name = BankMaster::model()->findByPk($cash_amt->fees_payment_cheque_bank);
$field3 = $bank_name->bank_short_name;
<?php if(Yii::app()->user->getState('stud_id'))
{
$studentmodel = StudentTransaction::model()->find('student_transaction_id='.Yii::app()->user->getState('stud_id'));
$photo = StudentPhotos::model()->findByPk($studentmodel->student_transaction_student_photos_id);
?>
<div id="menulink">
<div id="studentlogo">
<?php
if($photo->student_photos_path != null)
echo CHtml::link(CHtml::image(Yii::app()->baseUrl.'/college_data/stud_images/'.$photo->student_photos_path,"",array("width"=>"176px","height"=>"178px")),array('/college_data/stud_images/'.$photo->student_photos_path),array('id'=>'photo'));
/* $config = array(
'scrolling' => 'no',
'autoDimensions' => false,
'width' => 'auto',
'height' => 'auto',
// 'titleShow' => false,
'overlayColor' => '#000',
'padding' => '0',
'showCloseButton' => true,
'onClose' => function() {
return window.location.reload();
},
// change this as you need
);
$this->widget('application.extensions.fancybox.EFancyBox', array('target'=>'#photo', 'config'=>$config));*/
?>
</div> <?php //end of student logo div?>
</br>
public function actionAddotherfees($id)
{
$student_trans = StudentTransaction::model()->findByPk($id);
$fees_master = FeesMaster::model()->findByAttributes(array('fees_academic_term_name_id' => $student_trans->student_academic_term_name_id, 'fees_quota_id' => $student_trans->student_transaction_quota_id, 'fees_branch_id' => $student_trans->student_transaction_branch_id));
$model = new StudentFeesMaster();
// Uncomment the following line if AJAX validation is needed
$this->performAjaxValidation($model);
if (isset($_POST['amounts'])) {
foreach ($_POST['amounts'] as $index => $value) {
if ($value != null) {
$model->student_fees_master_student_transaction_id = $id;
$model->fees_master_table_id = $fees_master['fees_master_id'];
$model->student_fees_master_details_id = $index;
$model->fees_details_amount = $value;
$model->student_fees_master_org_id = Yii::app()->user->getState('org_id');
$model->student_fees_master_created_by = Yii::app()->user->id;
$model->student_fees_master_creation_date = new CDbExpression('NOW()');
$model->setIsNewRecord(true);
$model->student_fees_master_id = null;
$model->save();
}
}
$this->redirect(array('view', 'student_id' => $id));
} else {
if ($fees_master) {
$student_fees = StudentFeesMaster::model()->findAll(array('condition' => 'fees_master_table_id=' . $fees_master->fees_master_id . ' and student_fees_master_student_transaction_id=' . $id));
if (!empty($student_fees)) {
$details_array = array();
foreach ($student_fees as $fees_data) {
$details_array[] = $fees_data['student_fees_master_details_id'];
}
$details = implode(',', $details_array);
$remaining = Yii::app()->db->createCommand()->select('fees_details_master,fees_details_master_name')->from('fees_details_master')->where('fees_details_master not in(' . $details . ')')->queryAll();
$this->render('add_other_fees', array('model' => $model, 'fees_head_array' => $remaining));
} else {
$this->redirect(array('/studentFeesMaster/feesassign/' . $id));
}
}
}
}
public function actionPayfeescheque()
{
$model = new FeesPaymentTransaction();
$pay_cheque = new FeesPaymentCheque();
$pay_trans = new FeesPaymentTransaction();
$receipt = new FeesReceipt();
if (isset($_POST['FeesPaymentTransaction'])) {
Yii::app()->user->setState('student_id', $_POST['FeesPaymentTransaction']['student_id']);
Yii::app()->user->setState('fees_master_id', $_POST['FeesPaymentTransaction']['fees_master_id']);
}
// Uncomment the following line if AJAX validation is needed
$this->performAjaxValidation_cheque(array($model, $pay_cheque));
if (isset($_POST['FeesPaymentCheque'])) {
$pay_cheque->attributes = $_POST['FeesPaymentCheque'];
$cheque_date = $_POST['FeesPaymentCheque']['fees_payment_cheque_date'];
$chequedate = date("Y-m-d", strtotime($cheque_date));
$pay_cheque->fees_payment_cheque_date = $chequedate;
$pay_cheque->fees_payment_cheque_organization_id = Yii::app()->user->getState('org_id');
if ($pay_cheque->save()) {
$last_receipt_id = Yii::app()->db->createCommand()->select('MAX(fees_receipt_number) as lastid')->from('fees_receipt')->where('fees_receipt_org_id=:id', array(':id' => Yii::app()->user->getState('org_id')))->queryRow();
$receipt->fees_receipt_number = $last_receipt_id['lastid'] + 1;
$receipt->fees_receipt_org_id = Yii::app()->user->getState('org_id');
$receipt->save();
$pay_trans->fees_payment_master_id = Yii::app()->user->getState('fees_master_id');
$pay_trans->fees_payment_method_id = 2;
$pay_trans->fees_payment_cash_cheque_id = $pay_cheque->fees_payment_cheque_id;
$pay_trans->fees_receipt_id = $receipt->fees_receipt_id;
$pay_trans->fees_payment = 1;
$pay_trans->fees_received_user_id = Yii::app()->user->id;
$pay_trans->fees_full_part_payment_id = 1;
$pay_trans->fees_student_id = Yii::app()->user->getState('student_id');
$pay_trans->fees_payment_transaction_organization_id = Yii::app()->user->getState('org_id');
$pay_trans->fees_received_date = new CDbExpression('NOW()');
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => Yii::app()->user->getState('student_id')));
$pay_trans->fees_academic_period_id = $stud_trans->student_academic_term_period_tran_id;
$pay_trans->fees_academic_term_id = $stud_trans->student_academic_term_name_id;
$pay_trans->save();
$stud_add_id = $stud_trans->student_transaction_student_address_id;
$stud_info_id = $stud_trans->student_transaction_student_id;
$stud_add_mobile = StudentInfo::model()->findByPk($stud_info_id)->student_mobile_no;
$stud_email_id = StudentInfo::model()->findByPk($stud_info_id)->student_email_id_1;
$this->redirect(array('create', 'id' => $pay_trans->fees_student_id));
}
}
$this->render('payfeescheque', array('model' => $model, 'pay_cheque' => $pay_cheque));
}
echo '<td>' . $list['course_level'] . '</td>';
echo '<td>' . $list['course_code'] . '</td>';
echo '<td>' . $list['course_cost'] . '</td>';
echo '</tr>';
}
?>
</table>
<?php
} else {
echo '<span style="padding: 20px;">No course availabel</span>';
}
?>
</div>
<?php
$recStud = StudentTransaction::model()->findAll(array("order" => "student_transaction_id DESC", "limit" => 3));
?>
<div class="portlet box green" style="width: 47%; margin-left: 25px; min-height: 232px;">
<i class="icon-reorder"></i>
<div class="portlet-title">Latest Enrolled Student
</div>
<?php
if (!empty($recStud)) {
?>
<table class="course-details">
<tr>
<th style="width:140px;">Student Name</th>
<th style="width:140px;">Enroll in Course</th>
<th style="width:140px;">Joining Date</th>
</tr>
<?php
public function beforeSave(){
$fees_trans=FeesPaymentTransaction::model()->findAll('fees_payment_student_id='.$_REQUEST['id']);
$total_payable = Yii::app()->db->createCommand()
->select('batch_fees')
->from('batch as b')
->join('course as c','b.course_id=c.course_id')
->where('b.batch_id='.StudentTransaction::model()->findByPk($_REQUEST['id'])->student_transaction_batch_id)
->queryRow();
$total=0;
foreach($fees_trans as $fee){
$total=$total+$fee->fees_payment_amount;
}
if($this->isNewRecord){
$total = $total+$this->fees_payment_amount;
}
else{
$oldfee = $fees_trans=FeesPaymentTransaction::model()->findByPk($_REQUEST['fees_id'])->fees_payment_amount;
$total = ($total-$oldfee)+$this->fees_payment_amount;
}
if($total > $total_payable['batch_fees'] ){
$this->addError('fees_payment_amount','<b style="color:red">You can not take an advance fees for student.</b>');
return false;
}
else
return true;
}
public function student_details_fees($id)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
/************************************Ravi B************************************************/
$student_trans = StudentTransaction::model()->findByPk($id);
$fees_master = FeesMaster::model()->findByAttributes(array('fees_academic_term_name_id' => $student_trans->student_academic_term_name_id, 'fees_quota_id' => $student_trans->student_transaction_quota_id, 'fees_branch_id' => $student_trans->student_transaction_branch_id));
$criteria->condition = 'student_fees_master_student_transaction_id = :student_id AND fees_master_table_id=:fees_master';
$criteria->params = array(':student_id' => $id, ':fees_master' => $fees_master->fees_master_id);
/******************************************************************************************/
$dp = new CActiveDataProvider($this, array('criteria' => $criteria));
$dp->setTotalItemCount(count($this->findAll($criteria)));
return $dp;
}
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
if (Yii::app()->request->isPostRequest) {
// we only allow deletion via POST request
$this->loadModel($id)->delete();
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if (!isset($_GET['ajax'])) {
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
} else {
if (!Yii::app()->request->isPostRequest) {
$stud_tran = StudentTransaction::model()->findAll(array('condition' => 'student_academic_term_period_tran_id=' . $id));
$semester = AcademicTerm::model()->findAll(array('condition' => 'academic_term_period_id=' . $id));
if (!empty($stud_tran) || !empty($semester)) {
throw new CHttpException(400, 'You can not delete this record because it is used in another table.');
} else {
$this->loadModel($id)->delete();
$this->redirect(array('admin'));
}
} else {
throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
}
}
}
}
echo CHtml::link('GO BACK', Yii::app()->createUrl('feesPaymentTransaction/Branch_receipt_generate_print'), array('id' => "printid"));
$flag = 1;
$student = array();
if ($fees_student) {
$flag = 0;
foreach ($fees_student as $data) {
//$stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
if (!empty($branch1)) {
if (!empty($div)) {
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1, 'student_transaction_division_id' => $div));
} else {
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1));
}
} else {
$stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
}
if (empty($stud_trans)) {
continue;
}
$stud_model = StudentInfo::model()->findByAttributes(array('student_id' => $stud_trans['student_transaction_student_id']));
$sem_name = AcademicTerm::model()->findByPk($data['fees_academic_term_id']);
$branch = Branch::model()->findByPk($stud_trans['student_transaction_branch_id']);
$acd_term = AcademicTermPeriod::model()->findByPk($data['fees_academic_period_id']);
$field1 = '-';
$field2 = '-';
$field3 = '-';
$field4 = '-';
$field5 = 'CASH';
if ($data['fees_payment_method_id'] == 1) {
$cash_amt = FeesPaymentCash::model()->findByPk($data['fees_payment_cash_cheque_id']);
<script type="text/javascript">
function cheking(a)
{
var v=document.getElementById("amounts_"+a).value;
if(isNaN(v)){
alert("Please Enter Numeric Value");
document.getElementById("amounts_"+a).value = "";
document.getElementById("amounts_"+a).focus();
}
}
</script>
<?php
$this->breadcrumbs = array('Student Fees Masters' => array('admin'), 'Edit');
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $_REQUEST['id']));
$stud_tran_info = StudentTransaction::model()->findByPk($_REQUEST['id']);
$academic_period = AcademicTermPeriod::model()->findByPk($stud_tran_info->student_academic_term_period_tran_id)->academic_term_period;
$semester = AcademicTerm::model()->findByPk($stud_tran_info->student_academic_term_name_id)->academic_term_name;
?>
<table border="2px" id="twoColThinTable">
<tr class="row">
<td class="col1">Name </td>
<td class="col2"><?php
echo $stud_info->student_first_name . ' ' . $stud_info->student_middle_name . ' ' . $stud_info->student_last_name;
?>
</td>
</tr>
<tr class="row">
<td class="col1">Enrollment No. </td>
<td class="col2"><?php
echo $stud_info->student_enroll_no;
?>
<div class="profile-details">
<div class="profile-pic">
<?php $stdId = StudentTransaction::model()->findByPk(Yii::app()->user->getState('stud_id'));
$pic = StudentPhotos::model()->findByPk($stdId->student_transaction_student_photos_id)->student_photos_path;
echo CHtml::image(Yii::app()->baseUrl.'/college_data/stud_images/'.$pic);
?>
</div>
<div class="profile-link">
<ul class="links">
<li><?php echo CHtml::link('Performance', array('/student/feedbackDetailsTable/studentPerformance','id'=>$stdId->student_transaction_id)); ?></li>
<li><?php echo CHtml::link('Subject', array('/report/mysubjects','id'=>$stdId->student_transaction_id)); ?></li>
<li><?php echo CHtml::link('Holidays', array('/report/myholidays','id'=>$stdId->student_transaction_id)); ?></li>
<li><?php echo CHtml::link('Student History', array('/report/studenthistory','id'=>$stdId->student_transaction_id)); ?></li>
<li class="last-row"><?php echo CHtml::link('Exam Timetable', array('/exam/branchSubjectwiseScheduling/studentexamtimetable','id'=>$stdId->student_transaction_id)); ?></li>
<li class="last-row"><?php echo CHtml::link('Assignment', array('/assignment/assignment/studAssignments','id'=>$stdId->student_transaction_id)); ?></li>
</ul>
</div>
</div>
public function actionStudentwisereportpdf()
{
if (!empty($_REQUEST['student_enroll_no']) && !empty($_REQUEST['start']) && !empty($_REQUEST['end'])) {
//$start=null;
//$end=null;
$en = trim($_REQUEST['student_enroll_no']);
$student_data = StudentInfo::model()->findByAttributes(array('student_enroll_no' => $en));
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_student_id' => $student_data['student_id']));
$new_start = $_REQUEST['start'];
$new_end = $_REQUEST['end'];
$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' => $stud_trans['student_transaction_id'])));
$sem_data = array();
//print_r($att_info['sem_name_id']); exit;
foreach ($att_info as $list) {
$sem_data[] = $list['sem_name_id'];
}
$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=' . $stud_trans['student_transaction_branch_id'] . ' and sem_id=' . $stud_trans['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();
//$subject_data = SubjectMaster::model()->findAll(array('condition'=>'subject_master_academic_terms_period_id='.$stud_trans['student_academic_term_period_tran_id'].' AND subject_master_academic_terms_name_id IN('.$sem_array.') AND subject_master_branch_id ='.$stud_trans['student_transaction_branch_id'].' AND subject_master_organization_id='.Yii::app()->user->getState('org_id')));
/*$new_start=$_REQUEST['start'];
$new_end=$_REQUEST['end'];
$start = date("Y-m-d", strtotime($new_start));
$end = date("Y-m-d", strtotime($new_end));*/
if (isset($_REQUEST['studenewisereportpdf'])) {
Yii::import('application.extensions.tcpdf.*');
require_once 'tcpdf/tcpdf.php';
require_once 'tcpdf/config/lang/eng.php';
//$this->actiondate_report();
$html = $this->renderPartial('student_report_view_pdf', array('subject_data' => $subject_data, 'student_data' => $student_data, 'start' => $_REQUEST['start'], 'end' => $_REQUEST['end']), true);
//print_r($html);exit;
ob_clean();
$pdf = new TCPDF();
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(Yii::app()->name);
$pdf->SetTitle('StudentWise Report');
$pdf->SetSubject('StudentWise Report');
$pdf->SetKeywords('example, text, report');
$pdf->SetHeaderData('', 0, "Report", '');
//$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("StudentWise.pdf", "I");
}
if (isset($_REQUEST['studenewisereportexcel'])) {
Yii::app()->request->sendFile(date('YmdHis') . '.xls', $this->renderPartial('student_report_view_pdf', array('subject_data' => $subject_data, 'student_data' => $student_data, 'start' => $_REQUEST['start'], 'end' => $_REQUEST['end']), true));
}
}
}
<?php
$user = User::model()->findByPk(Yii::app()->user->id)->user_type;
if ($user == 'admin') {
$username = '******';
} else {
if ($user == 'student') {
$username = StudentInfo::model()->findByPk(StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id))->student_transaction_student_id)->student_first_name;
} else {
$username = EmployeeInfo::model()->findByPk(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id))->employee_transaction_employee_id)->employee_first_name;
}
}
?>
<a data-close-others="true" data-hover="dropdown" data-toggle="dropdown" class="dropdown-toggle" href="#">
<?php
$checkUser = StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id));
if ($checkUser) {
$avtar = StudentPhotos::model()->findByPk($checkUser->student_transaction_student_photos_id)->student_photos_path;
echo CHtml::image(Yii::app()->baseUrl . '/college_data/stud_images/' . $avtar, 'Student', array('height' => 29, 'width' => '29'));
} else {
$checkUser = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id));
if ($checkUser) {
$avtar = EmployeePhotos::model()->findByPk($checkUser->employee_transaction_emp_photos_id)->employee_photos_path;
echo CHtml::image(Yii::app()->baseUrl . '/college_data/emp_images/' . $avtar, 'Student', array('height' => 29, 'width' => '29'));
} else {
echo '<img src="' . Yii::app()->baseUrl . '/images/no_image_icon.jpg" alt="" height=29 width=29>';
}
}
?>
<span class="username"><?php
/**
* 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 = StudentTransaction::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
