<?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;
	}