{ $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); $content = str_replace('{division}',$div,$content); $content = str_replace('{enrollment}',$en_no,$content); $content = str_replace('{gender}',$gender,$content); $content = str_replace('{category}',$category,$content); $content = str_replace('{quota}',$quota,$content); $content = str_replace('{smobile}',$smobile,$content); $content = str_replace('{pmobile}',$pmobile,$content); $content = str_replace('{date}',$cdate,$content); $content = str_replace('{line1}',$lin1,$content); $content = str_replace('{line2}',$lin2,$content);
<tr> <td> <?php echo $k; ?> </td> <td> <?php echo EmployeeInfo::model()->findByAttributes(array("employee_info_transaction_id" => $v['employee_certificate_details_table_emp_id']))->employee_first_name; ?> </td> <td> <?php echo Certificate::model()->findByPk($v['employee_certificate_type_id'])->certificate_title; ?> </td> <td> <?php echo User::model()->findByPk($v['employee_certificate_created_by'])->user_organization_email_id; ?> </td> <td> <?php echo Organization::model()->findByPk($v['employee_certificate_org_id'])->organization_name; ?>
//'filter'=>$model, 'columns'=>array( array( 'header'=>'SI No', 'class'=>'IndexColumn', ), array( 'header'=>'Name', 'name'=>'student_first_name', 'value'=>'$data->cer_student_id->student_first_name', ), array('name'=>'student_certificate_type_id', 'value'=>'Certificate::model()->findByPk($data->student_certificate_type_id)->certificate_title', 'filter' =>CHtml::listData(Certificate::model()->findAll(array('condition'=>'certificate_organization_id='.Yii::app()->user->getState('org_id'))),'certificate_id','certificate_title'), ), array('name'=>'Organization', 'value'=>'Organization::model()->findByPk($data->student_certificate_org_id)->organization_name', 'filter' => false, ), ), 'pager'=>array( 'class'=>'AjaxList', 'maxButtonCount'=>$studentcertificate->count(), // 'maxButtonCount'=>25, 'header'=>'' ), )); ?> </fieldset>
{ $field_value = StudentAddress::model()->findByPk($info['student_transaction_student_address_id'])->student_address_p_line1." ".StudentAddress::model()->findByPk($info['student_transaction_student_address_id'])->student_address_p_line2; } else if($s=='category_name') $field_value = Category::model()->findByPk($info['student_transaction_category_id'])->category_name; else if($s=='city') $field_value = City::model()->findByPk(StudentAddress::model()->findByPk($info['student_transaction_student_address_id'])->student_address_c_city)->city_name; else { $field_value = StudentInfo::model()->findByPk($info['student_transaction_student_id'])->$s; } echo $field_value; ?> </span> </br> <?php } echo "</br></br>".Certificate::model()->findByPk($certificate_type)->certificate_content; ?> </div> <div class="content_footer"> Principal </div> </div> </div><!-- content div close --> <div class="certificate_footer"> <div id="certificate_address"> <?php echo $org_data->address_line1.' '.City::model()->findByPk($org_data->city)->city_name.', '.State::model()->findByPk($org_data->state)->state_name.', '.Country::model()->findByPk($org_data->country)->name; ?> </div> </div> </div> <?php } // end of certificate_info else
/** * 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 $id the ID of the model to be loaded * @return Certificate the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Certificate::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
//'filter'=>$model, 'columns'=>array( array( 'header'=>'SI No', 'class'=>'IndexColumn', ), array( 'header'=>'Name', 'name'=>'student_first_name', 'value'=>'$data->cer_student_id->student_first_name', ), array('name'=>'student_certificate_type_id', 'value'=>'Certificate::model()->findByPk($data->student_certificate_type_id)->certificate_title', 'filter' =>CHtml::listData(Certificate::model()->findAll(), 'certificate_id', 'certificate_title'), ), array('name'=>'Organization', 'value'=>'Organization::model()->findByPk($data->student_certificate_org_id)->organization_name', 'filter' => false, ), array( 'class'=>'CButtonColumn', 'template' => '{view}', 'buttons'=>array( 'view' => array( 'url'=>'Yii::app()->createUrl("/certificate/certificategeneration", array("id"=>$data->student_certificate_type_id,"studid"=>$data->student_certificate_details_table_student_id,"eno"=>StudentInfo::model()->findByAttributes(array("student_info_transaction_id"=>$data->student_certificate_details_table_student_id))->student_enroll_no))', ), ), 'visible'=>$visible,
public static function model($className = __CLASS__) { return parent::model($className); }
<div id="form8" class="info-form"> <fieldset> <legend>Certificates</legend> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'employee-certificate-details-table-grid', 'dataProvider' => $employeecertificate->EmployeeSearch(), 'columns' => array(array('header' => 'SN.', 'class' => 'IndexColumn'), array('name' => 'employee_first_name', 'value' => '$data->cer_employee_id->employee_first_name'), array('name' => 'employee_certificate_type_id', 'value' => 'Certificate::model()->findByPk($data->employee_certificate_type_id)->certificate_title', 'filter' => CHtml::listData(Certificate::model()->findAll(array('condition' => 'certificate_organization_id=' . Yii::app()->user->getState('org_id'))), 'certificate_id', 'certificate_title')), array('name' => 'Organization', 'value' => 'Organization::model()->findByPk($data->employee_certificate_org_id)->organization_name', 'filter' => false), array('class' => 'CButtonColumn', 'template' => '{view}', 'buttons' => array('view' => array('url' => 'Yii::app()->createUrl("certificate/EmployeeCertificategeneration", array("id"=>$data->employee_certificate_type_id,"eno"=>EmployeeInfo::model()->findByAttributes(array("employee_info_transaction_id"=>$data->employee_certificate_details_table_emp_id))->employee_attendance_card_id,"empid"=>$data->employee_certificate_details_table_emp_id))')))), 'pager' => array('class' => 'AjaxList', 'maxButtonCount' => $employeecertificate->count(), 'header' => ''))); ?> </fieldset> </div>
} .org-details { float: left; width: 29%; font-size: 15px; font-family: verdana; margin-top:10px; } .certificate_main{ max-height:620px!important; } </style> </head> <title><?php $ct_title = Certificate::model()->findByPk($certi); echo $ct_title->certificate_title; ?> </title> <body> <?php $this->breadcrumbs=array( 'Multiple Certificate', ); ?> <?php echo CHtml::link('GO BACK', array('certificate/multiplecertificate'),array('id'=>"printid1")); if($student_data) { $lis = CHtml::listData($student_data,'student_transaction_id','student_transaction_id'); $st_str = implode(',',$lis);
if ($certificate != null){ ?> <table style="font-size:125%;"> <tr> <th> SN. </th> <th width="70px"> Certificate Type </th> </tr> <?php foreach($certificate as $m=>$v) { $certificate = Certificate::model()->findByPk($v['employee_certificate_type_id']); ?> <tr> <td> <?php echo ++$k; ?> </td> <td width="70px"> <?php echo $certificate->certificate_title;?> </td> </tr> <?php }// end for loop ?> </table>