public function actionStudentcertificate() { $id = Yii::app()->user->getState('stud_id'); $model=StudentTransaction::model()->findByPk($id); $info = StudentInfo::model()->findByPk($model->student_transaction_student_id); $address = StudentAddress::model()->findByPk($model->student_transaction_student_address_id); $photo = StudentPhotos::model()->findByPk($model->student_transaction_student_photos_id); $lang = LanguagesKnown::model()->findByPk($model->student_transaction_languages_known_id); $studentdocstrans = new StudentDocsTrans; $stud_qua = new StudentAcademicRecordTrans; $stud_feed = new FeedbackDetailsTable; $studentcertificate=new StudentCertificateDetailsTable('Studentsearch'); $parent = new ParentLogin; $studentcertificate->unsetAttributes(); // clear any default values if(isset($_GET['StudentCertificateDetailsTable'])) $studentcertificate->attributes=$_GET['StudentCertificateDetailsTable']; $this->render('update',array( 'model'=>$model,'info'=>$info,'photo'=>$photo,'address'=>$address,'lang'=>$lang,'studentdocstrans'=>$studentdocstrans, 'stud_qua'=>$stud_qua,'stud_feed'=>$stud_feed,'flag'=>0,'studentcertificate'=>$studentcertificate,'parent'=>$parent )); }
if($address->student_address_p_state != 0) $pstat = "<b>".State::model()->findByPk($address->student_address_p_state)->state_name."</b>"; } $ac_pid = $trans->student_academic_term_period_tran_id; $arch = StudentArchiveTable::model()->find(array('condition'=>'student_archive_stud_tran_id='.$trans->student_transaction_id, 'order'=>'student_archive_ac_t_p_id desc')); if($arch) $ac_pid = $arch->student_archive_ac_t_p_id; $year = AcademicTermPeriod::model()->findByPk($ac_pid)->academic_term_period; $ref_no = ""; if(Yii::app()->controller->action->id=="certiview") { $certi= StudentCertificateDetailsTable::model()->find(array('condition'=>' student_certificate_details_table_student_id='.$trans->student_transaction_id.' and student_certificate_type_id='.$certificate_type,'order'=>'student_certificate_details_table_id desc')); $ref_no = $certi->certificate_reference_number; } else{ $certi = StudentCertificateDetailsTable::model()->find(array('order'=>'student_certificate_details_table_id desc')); $autonum = 0; if(!empty($certi) && $certi->certificate_reference_number!=""){ $arr = explode('/',$certi->certificate_reference_number); $autonum = $arr[3]; } $autonum +=1; $ref_no = $year."/".$branch_model->branch_code."/".date('Y').'/'.$autonum; } $quota = "<b>".Quota::model()->findByPk($trans->student_transaction_quota_id)->quota_name."</b>"; $content = Certificate::model()->findByPk($model->certificatetype)->certificate_content; $content = str_replace('{title}',$titl,$content); $content = str_replace('{name}',$name,$content); $content = str_replace('{branch}',$branch,$content); $content = str_replace('{sem}',$sem,$content);
$stat = "<b>".State::model()->findByPk($address->student_address_c_state)->state_name."</b>"; $padd = "<b>".$address->student_address_p_line1.",".$address->student_address_p_line2."</b>"; if($address->student_address_p_city != 0) $pct = "<b>".City::model()->findByPk($address->student_address_p_city)->city_name."</b>"; if($address->student_address_p_state != 0) $pstat = "<b>".State::model()->findByPk($address->student_address_p_state)->state_name."</b>"; } $ref_no = ""; if(Yii::app()->controller->action->id=="certiview") { $certi= StudentCertificateDetailsTable::model()->find(array('condition'=>' student_certificate_details_table_student_id='.$trans->student_transaction_id.' and student_certificate_type_id='.$certificate_type,'order'=>'student_certificate_details_table_id desc')); $ref_no = $certi->certificate_reference_number; } else{ $certi = StudentCertificateDetailsTable::model()->find(array('condition'=>'student_certificate_org_id='.Yii::app()->user->getState('org_id'),'order'=>'student_certificate_details_table_id desc')); $autonum = 0; if(!empty($certi) && $certi->certificate_reference_number!=""){ $arr = explode('/',$certi->certificate_reference_number); $autonum = $arr[3]; } $autonum +=1; $ref_no = $year."/".$branch_model->branch_code."/".date('Y').'/'.$autonum; } $content = Certificate::model()->findByPk($certificate_type)->certificate_content; $content = str_replace('{title}',$titl,$content); $content = str_replace('{name}',$name,$content); $content = str_replace('{gender}',$gender,$content); $content = str_replace('{smobile}',$smobile,$content); $content = str_replace('{pmobile}',$pmobile,$content);
/** * 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=StudentCertificateDetailsTable::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; }
public function actionStudentcertificate() { $model=$this->loadModel($_REQUEST['id']); $user = User::model()->findByPk($model->student_transaction_user_id); $info = StudentInfo::model()->findByPk($model->student_transaction_student_id); $address = StudentAddress::model()->findByPk($model->student_transaction_student_address_id); $photo = StudentPhotos::model()->findByPk($model->student_transaction_student_photos_id); $lang = LanguagesKnown::model()->findByPk($model->student_transaction_languages_known_id); $studentdocstrans = new StudentDocsTrans; $stud_qua = new StudentAcademicRecordTrans; $stud_feed = new FeedbackDetailsTable; $studentcertificate=new StudentCertificateDetailsTable('Studentsearch'); $parent = ''; $yearModel=new Year; $year=Year::model()->findByPk($model->student_transaction_batch_year); if(isset(Yii::app()->modules['parents'])) $parent = new ParentLogin; $studentcertificate->unsetAttributes(); // clear any default values if(isset($_GET['StudentCertificateDetailsTable'])) $studentcertificate->attributes=$_GET['StudentCertificateDetailsTable']; $this->render('update',array( 'model'=>$model,'info'=>$info,'photo'=>$photo,'address'=>$address,'user'=>$user,'lang'=>$lang,'studentdocstrans'=>$studentdocstrans, 'stud_qua'=>$stud_qua,'stud_feed'=>$stud_feed,'flag'=>0,'studentcertificate'=>$studentcertificate,'parent'=>$parent,'yearModel'=>$yearModel,'year'=>$year )); }
public function actionSaveStudentCertificatedata() { $student_certificate = new StudentCertificateDetailsTable(); $student_transaction_id = $_REQUEST['stid']; $semData = StudentTransaction::model()->findByPk($_REQUEST['stid'])->student_academic_term_name_id; $ctype = $_REQUEST['ctype']; $student_certificate->student_certificate_details_table_student_id = $student_transaction_id; $student_certificate->student_semester_id = $semData; $student_certificate->student_certificate_type_id = $ctype; $student_certificate->student_certificate_creation_date = new CDbExpression('NOW()'); $student_certificate->student_certificate_created_by = Yii::app()->user->id; $student_certificate->save(false); $this->redirect(array('student/studentCertificateDetailsTable/admin')); }