}
if ($value == 'student_address_c_line1') {
$line1 = StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_c_line1;
$line2 = StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_c_line2;
$city = City::model()->findByPk(StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_c_city)->city_name;
$pin = StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_c_pin;
$state = State::model()->findByPk(StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_p_state)->state_name;
$label = "Address";
$field_value = $line1 . "," . $line2 . " " . $city . "-" . $pin . "," . $state;
}
if ($value == 'student_address_p_line1') {
$line1 = StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_p_line1;
$line2 = StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_p_line2;
$city = City::model()->findByPk(StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_p_city)->city_name;
$pin = StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_p_pin;
$state = State::model()->findByPk(StudentAddress::model()->findByPk($stud['student_transaction_student_address_id'])->student_address_p_state)->state_name;
$label = "Address";
$field_value = $line1 . "," . $line2 . " " . $city . "-" . $pin . "," . $state;
}
if ($value == 'student_mobile_no') {
$label = "Contact";
$field_value = StudentInfo::model()->findByPk($stud['student_transaction_student_id'])->student_mobile_no;
}
if ($value == 'student_guardian_mobile') {
$label = "Contact";
$field_value = StudentInfo::model()->findByPk($stud['student_transaction_student_id'])->student_guardian_mobile;
}
?>
<div class="student-details">
<?php
}
echo "<tr class=" . $class . ">";
echo "<td>" . $i . "</td>";
foreach ($selected_list as $s) {
if ($s == 'sem') {
if ($sd['student_academic_term_name_id'] != 0) {
echo "<td>" . AcademicTerm::model()->findByPk($sd['student_academic_term_name_id'])->academic_term_name . "</td>";
} else {
echo "<td><i>Not Set</i></td>";
}
} else {
if ($s == 'student_address_c_line1') {
echo "<td>" . StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_c_line1 . " " . StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_c_line2 . "</td>";
} else {
if ($s == 'city') {
$add = StudentAddress::model()->findByPk($sd['student_transaction_student_address_id']);
if ($add->student_address_c_city != 0) {
echo "<td>" . City::model()->findByPk($add->student_address_c_city)->city_name . "</td>";
} else {
echo "<td style='text-align:center;'><i>Not Set</i></td>";
}
} else {
echo "<td>" . StudentInfo::model()->findByPk($sd['student_transaction_student_id'])->{$s} . "</td>";
}
}
}
}
$i++;
echo "</tr>";
$m++;
}
$cdate = "<b>".date('d/m/Y')."</b>";
if($trans->student_transaction_category_id !=0)
$category = "<b>".Category::model()->findByPk($trans->student_transaction_category_id)->category_name."</b>";
else
$category = "<b>not set</b>";
$lin1 = "<b>not set</b>";
$lin2 = "<b>not set</b>";
$ct = "<b>not set</b>";
$stat = "<b>not set</b>";
$pc = "<b>not set</b>";
$padd = "<b>not set</b>";
$pct = "<b>not set</b>";
$pstat = "<b>not set</b>";
if($trans->student_transaction_student_address_id !=0)
{
$address = StudentAddress::model()->findByPk($trans->student_transaction_student_address_id);
$lin1 = "<b>".$address->student_address_c_line1."</b>";
$lin2 = "<b>".$address->student_address_c_line2."</b>";
$pc = "<b>".$address->student_address_c_pin."</b>";
if($address->student_address_c_city != 0)
$ct = "<b>".City::model()->findByPk($address->student_address_c_city)->city_name."</b>";
if($address->student_address_c_state != 0)
$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>";
}
</div>
<!--Guardian Info Tab end-->
<!--Address Info Tab Start-->
<div id="tab5" class="tab-content hide">
<div class="content-box-border">
<div class="content-bg-he">Address Info</div>
<div class="content-bg-inner">
<div class="content-bg-inner-one">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td class="table-cell-title" colspan="2" style="border-right:2px solid #FFAD12;text-align:center;font-size:20px">Local Address</td>
<td class="table-cell-title" colspan="2" style=";text-align:center;font-size:20px">International Address</td>
</tr>
<tr>
<?php $address = StudentAddress::model()->findByPk($studInfo->student_transaction_student_address_id);?>
<td class="table-cell-title" width="23%">Street 1</td>
<td class="table-cell-content" width="23%"><?php echo (!empty($address->student_address_c_line1) ? $address->student_address_c_line1 :"Not Set"); ?></td>
<td class="table-cell-title" width="23%">Street 1</td>
<td class="table-cell-content" width="23%"><?php echo (!empty($address->student_address_p_line1) ? $address->student_address_p_line1 : "Not Set");?></td>
</tr>
<tr>
<td class="table-cell-title">Street 2</td>
<td class="table-cell-content"><?php echo (!empty($address->student_address_c_line2) ? $address->student_address_c_line2 : "Not Set"); ?></td>
<td class="table-cell-title">Street 2</td>
<td class="table-cell-content"><?php echo (!empty($address->student_address_p_line2) ? $address->student_address_p_line2 :"Not Set");?></td>
</tr>
<tr>
<td class="table-cell-title">Country</td>
<td class="table-cell-content">
<?php if($address->student_address_c_country!=0)
/**
* 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)
{
if (Yii::app()->request->isPostRequest) {
// 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'));
}
} else {
if (!Yii::app()->request->isPostRequest) {
$emp_tran = EmployeeAddress::model()->findAll(array('condition' => 'employee_address_c_state=' . $id));
$stud_tran = StudentAddress::model()->findAll(array('condition' => 'student_address_c_state=' . $id));
$organization = Organization::model()->findAll(array('condition' => 'state=' . $id));
$city = City::model()->findAll(array('condition' => 'state_id=' . $id));
if (!empty($emp_tran) || !empty($stud_tran) || !empty($city) || !empty($organization)) {
throw new CHttpException(400, 'You can not delete this record because it is used in another table.');
} else {
$this->loadModel($id)->delete();
$this->redirect(array('admin'));
}
} else {
throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
}
}
}
/**
* 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)
{
if (Yii::app()->request->isPostRequest) {
// we only allow deletion via POST request
$model = $this->loadModel($id);
$student_info = StudentInfo::model()->findByPk($model->student_transaction_student_id);
if ($model->student_transaction_student_address_id != null) {
$address = StudentAddress::model()->findByPk($model->student_transaction_student_address_id);
}
$stud_photo = StudentPhotos::model()->findByPk($model->student_transaction_student_photos_id);
if ($model->student_transaction_languages_known_id != null) {
$lang_known = LanguagesKnown::model()->findByPk($model->student_transaction_languages_known_id);
}
$dir1 = Yii::getPathOfAlias('webroot') . '/college_data/stud_images/';
if ($dh = opendir($dir1)) {
if ($stud_photo->student_photos_path == "no-images") {
} else {
if (file_exists($dir1 . $stud_photo->student_photos_path)) {
//chmod($dir1.$stud_photo->student_photos_path, 777);
unlink($dir1 . $stud_photo->student_photos_path);
}
}
}
closedir($dh);
if ($this->loadModel($id)->delete()) {
$use_model = User::model()->findByPk($model->student_transaction_user_id)->delete();
$stud_photo->delete();
$student_info->delete();
if ($model->student_transaction_student_address_id != null) {
$address->delete();
}
if ($model->student_transaction_languages_known_id != null) {
$lang_known->delete();
}
StudentPaidFeesDetails::model()->deleteAll("student_paid_student_id = :studId", array(':studId' => $id));
StudentAcademicRecordTrans::model()->deleteAll("student_academic_record_trans_stud_id = :studId", array(':studId' => $id));
StudentDocsTrans::model()->deleteAll("student_docs_trans_user_id = :studId", array(':studId' => $id));
}
if (!isset($_GET['ajax'])) {
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
} else {
throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
}
}
echo "<td>" . Division::model()->findByPk($sd['student_transaction_division_id'])->{$s} . "</td>";
} else {
if ($s == 'sem') {
echo "<td>" . AcademicTerm::model()->findByPk($sd['student_academic_term_name_id'])->academic_term_name . "</td>";
} else {
if ($s == 'student_address_c_line1') {
echo "<td>" . StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_c_line1 . " " . StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_c_line2 . "</td>";
} else {
if ($s == 'student_address_p_line1') {
echo "<td>" . StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_p_line1 . " " . StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_p_line2 . "</td>";
} else {
if ($s == 'category_name') {
echo "<td>" . Category::model()->findByPk($sd['student_transaction_category_id'])->category_name . "</td>";
} else {
if ($s == 'city') {
echo "<td>" . City::model()->findByPk(StudentAddress::model()->findByPk($sd['student_transaction_student_address_id'])->student_address_c_city)->city_name . "</td>";
} else {
echo "<td>" . StudentInfo::model()->findByPk($sd['student_transaction_student_id'])->{$s} . "</td>";
}
}
}
}
}
}
}
}
}
$i++;
echo "</tr>";
$m++;
}
else if($s=='branch_name')
$field_value = Branch::model()->findByPk($info['student_transaction_branch_id'])->branch_name;
else if($s=='division_code')
$field_value = Division::model()->findByPk($info['student_transaction_division_id'])->$s;
else if($s=='sem')
$field_value = AcademicTerm::model()->findByPk($info['student_academic_term_name_id'])->academic_term_name;
else if($s=='student_address_c_line1')
{ $field_value = StudentAddress::model()->findByPk($info['student_transaction_student_address_id'])->student_address_c_line1." ".StudentAddress::model()->findByPk($info['student_transaction_student_address_id'])->student_address_c_line2;
}
else if($s=='student_address_p_line1')
{ $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>
public function actionStudentperformance()
{
$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);
$stud_qua = new StudentAcademicRecordTrans;
$stud_feed = new FeedbackDetailsTable;
$studentcertificate=new StudentCertificateDetailsTable;
$studentdocstrans=new StudentDocsTrans;
$stud_qua=new StudentAcademicRecordTrans;
$stud_feed=new FeedbackDetailsTable('mysearch');
$parent = new ParentLogin;
$stud_feed->unsetAttributes(); // clear any default values
if(isset($_GET['FeedbackDetailsTable']))
$stud_feed->attributes=$_GET['FeedbackDetailsTable'];
$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
));
}
/**
* 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 = StudentAddress::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* 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)
{
$model = $this->loadModel($id);
$student_info = StudentInfo::model()->findByPk($model->student_transaction_student_id);
if($model->student_transaction_student_address_id != null)
$address = StudentAddress::model()->findByPk($model->student_transaction_student_address_id);
$stud_photo = StudentPhotos::model()->findByPk($model->student_transaction_student_photos_id);
if($model->student_transaction_languages_known_id != null)
$lang_known = LanguagesKnown::model()->findByPk($model->student_transaction_languages_known_id);
$yearModel=new Year;
//$assign_comp_model = assignCompanyUserTable::model()->findByPk($ass_comp->id);
$dir1 = Yii::getPathOfAlias('webroot').'/college_data/stud_images/';
if($dh = opendir($dir1))
{
if($stud_photo->student_photos_path == "no-images")
{
}
else
{
if(file_exists($dir1.$stud_photo->student_photos_path))
{
//chmod($dir1.$stud_photo->student_photos_path, 777);
unlink($dir1.$stud_photo->student_photos_path);
}
}
}
closedir($dh);
if($model->delete()){
$use_model = User::model()->findByPk($model->student_transaction_user_id)->delete();
$stud_photo->delete();
$student_info->delete();
if($model->student_transaction_student_address_id != null)
$address->delete();
if($model->student_transaction_languages_known_id != null)
$lang_known->delete();
}
//echo $model->student_transaction_student_id; exit;
// 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'));
}
<?php
$studInfo = StudentInfo::model()->findByPk($student_transaction[0]->student_transaction_student_id);
$studAdd = StudentAddress::model()->findByPk($student_transaction[0]->student_transaction_student_address_id);
if ($student_transaction[0]->student_transaction_parent_id != null || $student_transaction[0]->student_transaction_parent_id != 0) {
$parent = ParentLogin::model()->findByPk($student_transaction[0]->student_transaction_parent_id);
} else {
$parent = new $ParentLogin();
}
?>
<h3>Student Detail</h3>
<h4>Personal Info</h4>
<table border="1" width="200px">
<tr>
<td>
<label> Enrollment No </label></td><td><?php
echo $studInfo->student_enroll_no;
?>
</td>
</tr>
<tr>
<td>
<label> First Name </label></td><td><?php
echo $studInfo->student_first_name;
?>
</td>
</tr>
<tr>
<td>
/**
* 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)
{
if (Yii::app()->request->isPostRequest) {
// we only allow deletion via POST request
$model = $this->loadModel($id);
$student_info = StudentInfo::model()->findByPk($model->student_transaction_student_id);
if ($model->student_transaction_student_address_id != null) {
$address = StudentAddress::model()->findByPk($model->student_transaction_student_address_id);
}
$stud_photo = StudentPhotos::model()->findByPk($model->student_transaction_student_photos_id);
if ($model->student_transaction_languages_known_id != null) {
$lang_known = LanguagesKnown::model()->findByPk($model->student_transaction_languages_known_id);
}
$dir1 = Yii::getPathOfAlias('webroot') . '/stud_images/';
if ($dh = opendir($dir1)) {
if ($stud_photo->student_photos_path == "no-images") {
} else {
if (file_exists($dir1 . $stud_photo->student_photos_path)) {
//chmod($dir1.$stud_photo->student_photos_path, 777);
unlink($dir1 . $stud_photo->student_photos_path);
}
}
}
closedir($dh);
if ($this->loadModel($id)->delete()) {
$use_model = User::model()->findByPk($model->student_transaction_user_id)->delete();
$stud_photo->delete();
$student_info->delete();
if ($model->student_transaction_student_address_id != null) {
$address->delete();
}
if ($model->student_transaction_languages_known_id != null) {
$lang_known->delete();
}
}
//echo $model->student_transaction_student_id; exit;
// 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'));
}
} else {
throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
}
}
<?php
echo '<lable><b>Phone No :</b></lable>';
?>
<div class="rown">
<?php
if (StudentAddress::model()->findByPk($addressid)->student_address_phone != 0) {
echo StudentAddress::model()->findByPk($addressid)->student_address_phone . '<br>';
} else {
echo "N/A";
}
?>
</div>
</div>
<div class="rowv">
<?php
echo '<lable><b>Mobile :</b></lable>';
?>
<div class="rown">
<?php
if (StudentAddress::model()->findByPk($addressid)->student_address_mobile != 0) {
echo StudentAddress::model()->findByPk($addressid)->student_address_mobile . '<br>';
} else {
echo "N/A";
}
?>
</div>
</div>
</div>
