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"> </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"> </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)); } }