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')); } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate($id) { $course = StudentTransaction::model()->findByPk($id)->student_transaction_course_id; $cDetails = CourseMaster::model()->findByPk($course); $model = new StudentPaidFeesDetails(); // Uncomment the following line if AJAX validation is needed $this->performAjaxValidation($model); if (isset($_POST['StudentPaidFeesDetails'])) { $model->attributes = $_POST['StudentPaidFeesDetails']; $model->student_paid_student_id = $id; $model->student_paid_course_id = $course; $model->student_paid_date = new CDbExpression('NOW()'); $model->student_paid_to = Yii::app()->user->id; if ($model->save()) { $this->redirect(array('admin')); } } $this->render('create', array('model' => $model, 'cDetails' => $cDetails)); }
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; }