<?php $m=1; $academic = AcademicTerm::model()->findAll(array('condition'=>'academic_term_organization_id='.Yii::app()->user->getState('org_id'),'order'=>'academic_term_period_id')); $st = "Regular"; foreach($academic as $data) { if(($m%2) == 0) { $class = "odd"; } else { $class = "even"; } $if_detain = LeftDetainedPassStudentTable::model()->findByAttributes(array('student_id'=>$stud_trans[0]['student_transaction_id'],'sem'=>$data['academic_term_id'])); if(!empty($if_detain)) {?> <tr class="<?php echo $class;?>"> <td><?php echo ++$i;?></td> <td><?php echo AcademicTermPeriod::model()->findByPk($if_detain['academic_term_period_id'])->academic_term_period; ?></td> <td><?php echo "Sem-".AcademicTerm::model()->findByPk($if_detain['sem'])->academic_term_name; ?></td> <td>Detain</td> </tr> <?php $m++; $st="Rejoin/Regular"; } $if_stud_arch = StudentArchiveTable::model()->findByAttributes(array('student_archive_stud_tran_id'=>$stud_trans[0]['student_transaction_id'],'student_archive_ac_t_n_id'=>$data['academic_term_id'])); if($if_stud_arch) {?> <tr class="<?php echo $class;?>"> <td><?php echo ++$i;?></td>
echo '<td style=width:150px; >'; $getSem = AcademicTerm::model()->findAll('academic_term_period_id ='.$y); foreach($getSem as $sem) { $status = StudentArchiveTable::model()->findAll(array('condition' => 'student_archive_stud_tran_id = '.$s['student_transaction_id'].' AND student_archive_ac_t_p_id ='.$y.' AND student_archive_ac_t_n_id ='.$sem['academic_term_id'])); if(!empty($status)) { foreach($status as $l) { $sName = AcademicTerm::model()->findByPk($l['student_archive_ac_t_n_id'])->academic_term_name; $sStatus = Studentstatusmaster::model()->findByPk($l['student_archive_status'])->status_name; echo 'SEM- '.$sName."-".$sStatus.'<br />'; } } else { $ldStatus = LeftDetainedPassStudentTable::model()->findAll('student_id ='. $s['student_transaction_id'].' AND academic_term_period_id ='.$y.' AND sem ='.$sem['academic_term_id']); if(!empty($ldStatus)) { foreach($ldStatus as $l) { $sName = AcademicTerm::model()->findByPk($l['sem']); if($sName) $semester = $sName->academic_term_name; else $semester = '-'; $sStatus = Studentstatusmaster::model()->findByPk($l['status_id'])->status_name; echo 'SEM- '.$semester."-".$sStatus.'<br />'; } } }
public function beforeDelete() { $id = $this->student_transaction_id; $fees_check = FeesPaymentTransaction::model()->findAll(array('condition' => 'fees_student_id=' . $id)); $att_check = Attendence::model()->findAll(array('condition' => 'st_id=' . $id)); $mis_fees = MiscellaneousFeesPaymentTransaction::model()->findAll(array('condition' => 'student_fees_id=' . $id)); $left_check = LeftDetainedPassStudentTable::model()->findAll(array('condition' => 'student_id=' . $id)); $st_archive = StudentArchiveTable::model()->findAll(array('condition' => 'student_archive_stud_tran_id=' . $id)); if (!empty($fees_check) || !empty($att_check) || !empty($mis_fees) || !empty($left_check) || !empty($st_archive)) { Yii::app()->user->setFlash('error', "You can not delete this record because it is used in another table."); return false; } else { Yii::app()->user->setFlash('success', "Deleted Sucessfully"); return true; } }
/** * 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=LeftDetainedPassStudentTable::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; }