{
$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>
