public function assignmentsearch($assignment,$submitflag)
	{
		
		$query = '';
		$criteria=new CDbCriteria;
		$criteria->compare('student_transaction_id',$this->student_transaction_id);
		if($submitflag==1){
		$criteria->alias = 'st';
		$criteria->select = 'student_transaction_id,student_roll_no,student_last_name,student_first_name,assignment_trans_document,assignment_trans_creation_date';
		$criteria->join='INNER JOIN assignment_trans ON assignment_trans_student_id=st.student_transaction_id INNER JOIN student_info ON student_info.student_id =st.student_transaction_student_id';
		$criteria->condition = $query."assignment_trans.assignment_trans_assignment_id=".$assignment;
		$criteria->compare('student_roll_no',$this->student_roll_no,true);
		$criteria->compare('student_last_name',$this->student_last_name,true);
		$criteria->compare('student_first_name',$this->student_first_name,true);
		$criteria->compare('assignment_trans_creation_date',$this->dbDateSearch($this->assignment_trans_creation_date),true);
		$stu_data = new CActiveDataProvider(get_class($this), array(
		'criteria'=>$criteria,
		'sort'=>array(
		'defaultOrder'=>'student_roll_no',
		),
		));
		}
		else
		{
			$criteria->with = array('Rel_Stud_Info');
			$criteria->select = 'student_transaction_id';
			$criteria->distinct = true;
			$criteria->alias = 'st';
			$criteria->condition = $query." student_transaction_detain_student_flag=".Studentstatusmaster::model()->findByAttributes(array('status_name'=>'Regular'))->id." AND ".Studentstatusmaster::model()->findByAttributes(array('status_name'=>'Rejoin'))->id.' and student_transaction_id NOT IN(select assignment_trans_student_id from  assignment_trans where assignment_trans.assignment_trans_assignment_id='.$assignment.')';	
		$criteria->compare('Rel_Stud_Info.student_first_name',$this->student_first_name,true);
		$criteria->compare('Rel_Stud_Info.student_roll_no',$this->student_roll_no,true);
		$criteria->compare('Rel_Stud_Info.student_middle_name',$this->student_middle_name,true);
		$criteria->compare('Rel_Stud_Info.student_last_name',$this->student_last_name,true);	
		$stu_data = new CActiveDataProvider(get_class($this), array(
		'criteria'=>$criteria,
		));
		}
	

		return $stu_data;
	}
		$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++; 
		}
		$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)
		{
			$st = Studentstatusmaster::model()->findByPk($if_stud_arch->student_archive_status)->status_name;	
		?>
			<tr class="<?php echo $class;?>">
				<td><?php echo ++$i; ?></td>
				<td><?php echo AcademicTermPeriod::model()->findByPk($if_stud_arch['student_archive_ac_t_p_id'])->academic_term_period; ?></td>
				<td><?php echo "Sem-".AcademicTerm::model()->findByPk($if_stud_arch['student_archive_ac_t_n_id'])->academic_term_name; ?></td>
				<td><?php echo $st;?></td>
			</tr>
				
		<?php $m++; }
	
	}
	

?>
 /**
  * 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 = Studentstatusmaster::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }
echo $form->labelEx($model, 'student_academic_term_name_id');
?>
			<?php 
echo $form->dropDownList($model, 'student_academic_term_name_id', $acdterm, array('prompt' => 'Select Semester'));
?>
<span class="status">&nbsp;</span>
			<?php 
echo $form->error($model, 'student_academic_term_name_id');
?>
		</div>
	      <div class="row-right">
			<?php 
echo $form->labelEx($model, 'student_transaction_detain_student_flag');
?>
			<?php 
echo $form->dropDownList($model, 'student_transaction_detain_student_flag', CHtml::listData(Studentstatusmaster::model()->findAll(), 'id', 'status_name'), array('prompt' => 'Student Status'));
?>
<span class="status">&nbsp;</span>
			<?php 
echo $form->error($model, 'student_transaction_detain_student_flag');
?>
		</div>		

 	</div>

	<div class="row">
	      <div class="row-left">
			<?php 
echo $form->labelEx($model, 'student_transaction_course_id');
?>
			<?php 
    $data = CHtml::listData(AcademicTerm::model()->findAll(array('condition' => 'academic_term_period_id=' . $_REQUEST['StudentTransaction']['student_academic_term_period_tran_id'])), 'academic_term_id', 'academic_term_name');
    echo $form->dropDownList($model, 'student_academic_term_name_id', $data, array('empty' => 'Select Semester'));
} else {
    ?>
		<?php 
    echo $form->dropDownList($model, 'student_academic_term_name_id', array(), array('empty' => 'Select Semester'));
    ?>
	<?php 
}
?>
	
		<?php 
echo $form->labelEx($model, 'student_transaction_detain_student_flag');
?>
		<?php 
echo $form->dropDownList($model, 'student_transaction_detain_student_flag', CHtml::listData(Studentstatusmaster::model()->findAll(), 'id', 'status_name'), array('empty' => 'Select Status', 'tabindex' => 1));
?>
	</div>

	<div class="row buttons">
		<?php 
echo CHtml::submitButton('Search', array('class' => 'submit'));
?>
	</div>

<?php 
$this->endWidget();
?>

</div><!-- search-form -->
	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate()
	{
		$model=new StudentTransaction;
		$info =new StudentInfo;
		$user =new User;
		$photo =new StudentPhotos;
		$address=new StudentAddress;
		$lang=new LanguagesKnown;
		$auth_assign = new AuthAssignment;
		// Uncomment the following line if AJAX validation is needed
		$this->performAjaxValidation(array($info,$model,$user));

		if(!empty($_POST['StudentTransaction']) || !empty($_POST['StudentInfo'] ))
		{
			
		$stud_roll_no = StudentInfo::model()->findAll();
	     if(Yii::app()->controller->action->id=='create'){
		if(empty($stud_roll_no))
		{
			$rollno=$info->student_roll_no=1;
		}
		else
		{
			//$rand=mt_rand(1,2000);
			foreach($stud_roll_no as $s)
			{
                    		$stud[]=$s['student_roll_no'];
				$rollno_m=MAX($stud)+1;
			}		
				if(StudentInfo::model()->exists('student_roll_no='.$rollno_m))
				{
					$rollno=$rollno_m+1;
				}
				else
				{
					$rollno=$rollno_m;
				}			
		}
	      }
	    else
		{
		
		}
		//echo $rollno; exit;
					
		
			
			
			/*$batch_id=$_POST['StudentTransaction']['student_transaction_batch_id'];
			$batch=Batch::model()->findByPk($batch_id);
			$course=$batch->course_id;
			$academic_year=AcademicTerm::model()->findByPk($course);
		
			$model->academic_term_period_id=$academic_year->academic_term_period_id;
			$model->course_id=$batch->course_id;
			$model->academic_term_id=$batch->academic_term_id; */
			$model->attributes=$_POST['StudentTransaction'];			
			$info->attributes=$_POST['StudentInfo'];
			$user->attributes=$_POST['User'];
					
			$info->student_created_by = Yii::app()->user->id;
			$info->student_creation_date = new CDbExpression('NOW()');
			$info->student_email_id_1=strtolower($user->user_organization_email_id);
			$info->student_adm_date = date('Y-m-d',strtotime($_POST['StudentInfo']['student_adm_date']));			
			$info->student_roll_no=$rollno;
			$info->passport_exp_date=date('Y-m-d',strtotime($_POST['StudentInfo']['passport_exp_date']));
			$user->user_organization_email_id = strtolower($info->student_email_id_1);
			$user->user_password =  md5($info->student_email_id_1.$info->student_email_id_1);
			$user->user_created_by =  Yii::app()->user->id;
			$user->user_creation_date = new CDbExpression('NOW()');
			$user->user_type = "student";
			
			if($info->save(false))  
			{  
				$user->save(false);
				$address->save(false);
				$lang->save(false); 						
				$photo->student_photos_path = "no-images";
				$photo->save();
			}
			//if(empty($model->student_transaction_batch_id))
			//$model->student_transaction_batch_id=0;
			//$model->academic_term_id=$_POST['StudentTransaction']['academic_term_id'];
			//$model->academic_term_period_id=$_POST['StudentTransaction']['academic_term_period_id'];
			$model->course_id=$_POST['StudentTransaction']['course_id'];	  
			$model->student_transaction_languages_known_id= $lang->languages_known_id;
			$model->student_transaction_student_id = $info->student_id;
			$model->student_transaction_user_id = $user->user_id;
			$model->student_transaction_student_address_id = $address->student_address_id;
			$model->student_transaction_student_photos_id = $photo->student_photos_id;
			$flag = Studentstatusmaster::model()->findByAttributes(array('status_name'=>'Regular'))->id;
			$model->student_transaction_detain_student_flag = 1;
			$model->save(false);
			
			StudentInfo::model()->updateByPk($model->student_transaction_student_id, array('student_info_transaction_id'=>$model->student_transaction_id));
			$auth_assign->itemname = 'Student';
			$auth_assign->userid = $user->user_id;
			$auth_assign->bizrule = '';
			$auth_assign->data = '';
			$auth_assign->save(true);	
			$this->redirect(array('update','id'=>$model->student_transaction_id));
		} //end of isset if
		else
		{
			$this->render('create',array(
			'model'=>$model,'info'=>$info,'user'=>$user
			));
		}
	}
			  {
			     $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 />';
			  
			  }			
		    }
		  }
		}		
	}
	echo '</td>';
		$stud_tran=StudentTransaction::model()->findByPk($s['student_transaction_id']);
		$status=Studentstatusmaster::model()->findByAttributes(array('id'=> $stud_tran->student_transaction_detain_student_flag));
		$sem=AcademicTerm::model()->findByAttributes(array('academic_term_id'=> $stud_tran->student_academic_term_name_id ));
	echo '<td style=width:200px;>';
			echo 'SEM-'.$sem->academic_term_name .'  '.$status->status_name ;
	echo '</td>';	
	echo '</tr>';
   }
	
	echo "</table>";
}
?>
</div>
</div>
</div>
 /**
  * Creates a new model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  */
 public function actionCreate()
 {
     $model = new StudentTransaction();
     $info = new StudentInfo();
     $user = new User();
     $photo = new StudentPhotos();
     $address = new StudentAddress();
     $lang = new LanguagesKnown();
     $auth_assign = new AuthAssignment();
     $student_fees_master = new StudentFeesMaster();
     // Uncomment the following line if AJAX validation is needed
     $this->performAjaxValidation(array($info, $model, $user));
     if (!empty($_POST['StudentTransaction']) || !empty($_POST['StudentInfo'])) {
         //print_r($_POST['StudentTransaction']); exit;
         $model->attributes = $_POST['StudentTransaction'];
         $info->attributes = $_POST['StudentInfo'];
         $user->attributes = $_POST['User'];
         $info->student_created_by = Yii::app()->user->id;
         $info->student_creation_date = new CDbExpression('NOW()');
         $info->student_email_id_1 = strtolower($user->user_organization_email_id);
         $info->student_adm_date = date('Y-m-d', strtotime($_POST['StudentInfo']['student_adm_date']));
         $user->user_organization_email_id = strtolower($info->student_email_id_1);
         $user->user_password = md5($info->student_email_id_1 . $info->student_email_id_1);
         $user->user_created_by = Yii::app()->user->id;
         $user->user_creation_date = new CDbExpression('NOW()');
         $user->user_organization_id = Yii::app()->user->getState('org_id');
         $user->user_type = "student";
         if ($info->save(false)) {
             $user->save(false);
             $address->save(false);
             $lang->save(false);
             $photo->student_photos_path = "no-images";
             $photo->save();
         }
         if (empty($model->student_transaction_batch_id)) {
             $model->student_transaction_batch_id = 0;
         }
         $model->student_transaction_languages_known_id = $lang->languages_known_id;
         $model->student_transaction_student_id = $info->student_id;
         $model->student_transaction_user_id = $user->user_id;
         $model->student_transaction_student_address_id = $address->student_address_id;
         $model->student_transaction_student_photos_id = $photo->student_photos_id;
         $model->student_transaction_organization_id = Yii::app()->user->getState('org_id');
         $flag = Studentstatusmaster::model()->findByAttributes(array('status_name' => 'Regular'))->id;
         $model->student_transaction_detain_student_flag = $flag;
         $model->save();
         //Fees Assignment to a student=========== By Ravi Bhalodiya=========================================================
         $fees_data = FeesMaster::model()->findByAttributes(array('fees_branch_id' => $model->student_transaction_branch_id, 'fees_academic_term_id' => $model->student_academic_term_period_tran_id, 'fees_academic_term_name_id' => $model->student_academic_term_name_id, 'fees_quota_id' => $model->student_transaction_quota_id));
         if ($fees_data) {
             $fees_master = FeesMasterTransaction::model()->findAll(array('condition' => 'fees_master_id=' . $fees_data->fees_master_id));
             foreach ($fees_master as $list) {
                 $fees_detail = FeesDetailsTable::model()->findByPk($list['fees_desc_id']);
                 $student_fees_master->setIsNewRecord(true);
                 $student_fees_master->student_fees_master_id = null;
                 $student_fees_master->student_fees_master_student_transaction_id = $model->student_transaction_id;
                 $student_fees_master->fees_master_table_id = $fees_data->fees_master_id;
                 $student_fees_master->student_fees_master_details_id = $fees_detail->fees_details_name;
                 $student_fees_master->fees_details_amount = $fees_detail->fees_details_amount;
                 $student_fees_master->student_fees_master_org_id = Yii::app()->user->getState('org_id');
                 $student_fees_master->student_fees_master_created_by = Yii::app()->user->id;
                 $student_fees_master->student_fees_master_creation_date = new CDbExpression('NOW()');
                 $student_fees_master->save();
             }
         }
         //==================================================================================================================
         StudentInfo::model()->updateByPk($model->student_transaction_student_id, array('student_info_transaction_id' => $model->student_transaction_id));
         $auth_assign->itemname = 'Student';
         $auth_assign->userid = $user->user_id;
         $auth_assign->save();
         $this->redirect(array('update', 'id' => $model->student_transaction_id));
     } else {
         $this->render('create', array('model' => $model, 'info' => $info, 'user' => $user));
     }
 }