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);
/**
* 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;
}
$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);
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
$stud_certificate = StudentCertificateDetailsTable::model()->findByAttributes(array('student_certificate_type_id' => $id));
$emp_certificate = EmployeeCertificateDetailsTable::model()->findByAttributes(array('employee_certificate_type_id' => $id));
if (!empty($stud_certificate) || !empty($emp_certificate)) {
throw new CHttpException(400, 'You can not delete this record because it is used in another table.');
} else {
// we only allow deletion via POST request
$this->loadModel($id)->delete();
}
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if (!isset($_GET['ajax'])) {
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
}
