function studentSignin($pdo)
{
$student_info = new StudentInfo();
//$student_id = $student_info->generateId();
$fname = $student_info->firstName();
$lname = $student_info->lastName();
session_unset();
$query = "SELECT * FROM student WHERE student_fname = :fname AND student_lname = :lname";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':lname', $lname);
$stmt->execute();
if ($student_exists = $stmt->fetch()) {
foreach ($student_exists as $student) {
$_SESSION['user_id'] = $student['student_id'];
$_SESSION['f_name'] = $student['student_fname'];
$_SESSION['l_name'] = $student['student_lname'];
$_SESSION['theme'] = "red";
$_SESSION['rank'] = 1;
}
} else {
$student_id = $student_info->generateId();
$_SESSION['user_id'] = $student_id;
$_SESSION['f_name'] = $fname;
$_SESSION['l_name'] = $lname;
$_SESSION['theme'] = "red";
$_SESSION['rank'] = 1;
$query = "INSERT INTO student (student_id, student_fname, student_lname) VALUES (:student_id, :fname, :lname)";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':student_id', $student_id, PDO::PARAM_INT);
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':lname', $lname);
$stmt->execute();
//$course_id = rand(1,3);
$query = "SELECT * FROM class";
// This part can just be replaced with a COUNT function
$stmt = $pdo->prepare($query);
$stmt->execute();
$num_classes = $stmt->rowCount();
$classes_enrolled = array();
$classes_enrolled[0] = rand(1, 3);
while (($i = rand(1, 3)) == $classes_enrolled[0]) {
}
$classes_enrolled[1] = $i;
while (($i = rand(1, 3)) == $classes_enrolled[0] || $i == $classes_enrolled[1]) {
}
$classes_enrolled[2] = $i;
for ($i = 0; $i < 3; $i++) {
$query = "INSERT INTO enroll (enroll_student_id, enroll_class_id) VALUES (:student_id, :course_id)";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':student_id', $student_id);
$stmt->bindParam(':course_id', $classes_enrolled[$i]);
$stmt->execute();
}
}
$pdo = null;
}
public function actionRecpt_list()
{
$this->layout = 'receipt_layout';
$misc_fees_payment = MiscellaneousFeesPaymentCheque::model()->findByPk($_REQUEST['id']);
$model = StudentTransaction::model()->findByPk($misc_fees_payment->miscellaneous_fees_payment_cheque_student_id);
$stud_id = $model->student_transaction_student_id;
$stud_model = StudentInfo::model()->findByPk($model->student_transaction_student_id);
$acd_term = AcademicTermPeriod::model()->findByPk($model->student_academic_term_period_tran_id);
$branch = Branch::model()->findByPk($model->student_transaction_branch_id);
//print_r($_REQUEST['id']);
//print "<br/>model".$misc_fees_payment->miscellaneous_fees_payment_cash_student_id;
//print "<br/>reciept_no".$misc_fees_payment->miscellaneous_fees_payment_cash_receipt_id;
//print "<br/>stud_id".$model->student_transaction_student_id;
//print "<br/>curent date".date('d/m/y');
//print "<br/>stud_model".$stud_model->student_first_name.''.$stud_model->student_middle_name.''.$stud_model->student_last_name;
//print "<br/>dbdate".$misc_fees_payment->miscellaneous_fees_payment_cash_creation_date;
//print "<br/>branch_name".$branch->branch_name;
//print "<br/>academic_term".$acd_term->academic_terms_period_name;
//print "</br>roll no".$stud_model->student_roll_no;
//exit;
$this->render('recpt_list', array('model' => $model, 'stud_model' => $stud_model, 'acd_term' => $acd_term, 'branch' => $branch, 'misc_fees_payment' => $misc_fees_payment));
}
</div>
<div id="site-name">
<?php
echo $org[0]['organization_name'];
?>
</div>
<li class="dropdown user">
<?php
$user = User::model()->findByPk(Yii::app()->user->id)->user_type;
if ($user == 'admin') {
$username = '******';
} else {
if ($user == 'student') {
$username = StudentInfo::model()->findByPk(StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id))->student_transaction_student_id)->student_first_name;
} else {
$username = EmployeeInfo::model()->findByPk(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id))->employee_transaction_employee_id)->employee_first_name;
}
}
?>
<a data-close-others="true" data-hover="dropdown" data-toggle="dropdown" class="dropdown-toggle" href="#">
<?php
$checkUser = StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id));
if ($checkUser) {
$avtar = StudentPhotos::model()->findByPk($checkUser->student_transaction_student_photos_id)->student_photos_path;
echo CHtml::image(Yii::app()->baseUrl . '/college_data/stud_images/' . $avtar, 'Student', array('height' => 29, 'width' => '29'));
} else {
$checkUser = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id));
if ($checkUser) {
$avtar = EmployeePhotos::model()->findByPk($checkUser->employee_transaction_emp_photos_id)->employee_photos_path;
table tr:nth-child(even) { /*(even) or (2n 0)*/
background: #f1f6ff;
}
table tr:nth-child(odd) { /*(odd) or (2n 1)*/
background: white;
}
th{text-align:left;font-weight:normal;color:#990a10;width:110px;border:0.4px solid #74b9f0;height:24px;}
.title{color:seagreen;}
td{border:0.4px solid #74b9f0;height:24px;}
.label{text-align:left;font-weight:normal;color:#990a10;width:110px;height:24px;}
</style>
<?php
$StudentInfo = StudentInfo::model()->findByPk($student_transaction[0]->student_transaction_student_id);
$AcademicTermPeriod = AcademicTermPeriod::model()->findByPk($student_transaction[0]->academic_term_period_id);
$AcademicTerm = AcademicTerm::model()->findByPk($student_transaction[0]->academic_term_id);
if($student_transaction[0]->student_transaction_nationality_id != null)
$Nationality = Nationality::model()->findByPk($student_transaction[0]->student_transaction_nationality_id);
else
$Nationality = new Nationality;
$Batch = Batch::model()->findByPk($student_transaction[0]->student_transaction_batch_id);
$Course = Course::model()->findByPk($student_transaction[0]->course_id);
if($student_transaction[0]->student_transaction_languages_known_id != null)
$LanguagesKnown = LanguagesKnown::model()->findByPk($student_transaction[0]->student_transaction_languages_known_id);
if($student_transaction[0]->student_transaction_student_address_id != null)
$StudentAddress = StudentAddress::model()->findByPk($student_transaction[0]->student_transaction_student_address_id);
else
$StudentAddress = new StudentAddress;
if($student_transaction[0]->student_transaction_parent_id != null || $student_transaction[0]->student_transaction_parent_id != 0)
$flag = 0;
foreach ($fees_student as $data) {
//$stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
if (!empty($branch1)) {
if (!empty($div)) {
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1, 'student_transaction_division_id' => $div));
} else {
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1));
}
} else {
$stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
}
if (empty($stud_trans)) {
continue;
}
$stud_model = StudentInfo::model()->findByAttributes(array('student_id' => $stud_trans['student_transaction_student_id']));
$sem_name = AcademicTerm::model()->findByPk($data['fees_academic_term_id']);
$branch = Branch::model()->findByPk($stud_trans['student_transaction_branch_id']);
$acd_term = AcademicTermPeriod::model()->findByPk($data['fees_academic_period_id']);
$field1 = '-';
$field2 = '-';
$field3 = '-';
$field4 = '-';
$field5 = 'CASH';
if ($data['fees_payment_method_id'] == 1) {
$cash_amt = FeesPaymentCash::model()->findByPk($data['fees_payment_cash_cheque_id']);
$amount = $cash_amt->fees_payment_cash_amount;
} else {
$cash_amt = FeesPaymentCheque::model()->findByPk($data['fees_payment_cash_cheque_id']);
$amount = $cash_amt->fees_payment_cheque_amount;
$field1 = $cash_amt->fees_payment_cheque_number;
<th>Date</th>
<th>Amount Type</th>
<th>Bank Name</th>
<th>Cheque No</th>
<th>Receipt No</th>
<th>Amount</th>
</tr>
<?php
foreach ($var as $list) {
$stud_data = StudentTransaction::model()->findByPk($list['fees_student_id']);
echo '<tr><td>' . $i . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_enroll_no . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_roll_no . '</td>';
echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_first_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_middle_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_last_name . '</td>';
echo '<td>' . Branch::model()->findByPk($stud_data->student_transaction_branch_id)->branch_name . '</td>';
echo '<td>' . AcademicTerm::model()->findByPk($stud_data->student_academic_term_name_id)->academic_term_name . '</td>';
echo '<td>' . AcademicTermPeriod::model()->findByPk($stud_data->student_academic_term_period_tran_id)->academic_term_period . '</td>';
echo '<td>' . Division::model()->findByPk($stud_data->student_transaction_division_id)->division_name . '</td>';
echo '<td>' . $list['fees_received_date'] . '</td>';
$rec_no = FeesReceipt::model()->findByPk($list['fees_receipt_id'])->fees_receipt_number;
if ($list['fees_payment_method_id'] == '1') {
$cash_id = $list['fees_payment_cash_cheque_id'];
$amunt = FeesPaymentCash::model()->findByPk($cash_id)->fees_payment_cash_amount;
$final_total += $amunt;
$type = "Cash";
echo '<td>' . $type . '</td>';
echo '<td>-</td>';
echo '<td>-</td>';
echo '<td>' . $rec_no . '</td>';
<td >
<?php
echo StudentInfo::model()->findByPk($v['student_transaction_student_id'])->student_enroll_no;
?>
</td>
<td>
<?php
echo StudentInfo::model()->findByPk($v['student_transaction_student_id'])->student_first_name;
?>
</td>
<td>
<?php
echo StudentInfo::model()->findByPk($v['student_transaction_student_id'])->student_last_name;
?>
</td>
<td>
<?php
echo AcademicTermPeriod::model()->findByPk($v['student_academic_term_period_tran_id'])->academic_term_period;
?>
</td>
<td>
<?php
if (isset($v['student_academic_term_name_id'])) {
echo "Sem-" . AcademicTerm::model()->findByPk($v['student_academic_term_name_id'])->academic_term_name;
} else {
<?php
$this->breadcrumbs = array('Miscellaneous Fees Payment Transactions' => array('admin'), $model->miscellaneous_trans_id);
$this->menu = array(array('label' => '', 'url' => array('update', 'id' => $model->miscellaneous_trans_id), 'linkOptions' => array('class' => 'Edit', 'title' => 'Update')), array('label' => '', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->miscellaneous_trans_id), 'confirm' => 'Are you sure you want to delete this item?', 'class' => 'Delete', 'title' => 'Delete')), array('label' => '', 'url' => array('admin'), 'linkOptions' => array('class' => 'Manage', 'title' => 'Manage')));
?>
<h1>View Miscellaneous Fees Payment Transaction : <?php
echo $model->miscellaneous_trans_id;
?>
</h1>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('miscellaneous_trans_id', array('name' => 'miscellaneous_fees_id', 'value' => $model->Rel_mfees->miscellaneous_fees_name), array('name' => 'student_fees_id', 'value' => StudentInfo::model()->findByPk($model->Rel_stud->student_transaction_student_id)->student_first_name), 'Amount')));
<?php echo CHtml::link('Back',$_SERVER['HTTP_REFERER'], array('class'=>'btnback'));?>
<?php if($model->student_sms_email_details_schedule_flag==1){
echo CHtml::link('Edit', array('update' ,'id'=>$model->student_sms_email_id), array('class'=>'btnupdate'));
echo CHtml::link('Delete', array('delete' ,'id'=>$model->student_sms_email_id), array('class'=>'btndelete','onclick'=>"return confirm('Are you sure want to delete?');"));
}?>
</div>
</div>
<?php $this->widget('zii.widgets.CDetailView', array(
'data'=>$model,
'attributes'=>array(
array(
'name'=>'Student',
'type'=>'raw',
'value'=> $model->student_id == 0 ? "Not Set" : StudentInfo::model()->findByAttributes(array(
'student_info_transaction_id' => $model->student_id))->student_first_name,
),
'message_email_text',
array(
'name'=>'email_sms_status',
'type'=>'raw',
'value'=>$model->email_sms_status == 1 ? "SMS" :"Email",
),
array('name'=>'created_by',
'value'=>User::model()->findByPk($model->created_by)->user_organization_email_id,
),
array('name'=>'creation_date',
'value'=>($model->creation_date == 0000-00-00) ? 'Not Set' : date_format(new DateTime($model->creation_date), 'd-m-Y'),
),
public function actionPayfeescheque()
{
$model = new FeesPaymentTransaction();
$pay_cheque = new FeesPaymentCheque();
$pay_trans = new FeesPaymentTransaction();
$receipt = new FeesReceipt();
if (isset($_POST['FeesPaymentTransaction'])) {
Yii::app()->user->setState('student_id', $_POST['FeesPaymentTransaction']['student_id']);
Yii::app()->user->setState('fees_master_id', $_POST['FeesPaymentTransaction']['fees_master_id']);
}
// Uncomment the following line if AJAX validation is needed
$this->performAjaxValidation_cheque(array($model, $pay_cheque));
if (isset($_POST['FeesPaymentCheque'])) {
$pay_cheque->attributes = $_POST['FeesPaymentCheque'];
$cheque_date = $_POST['FeesPaymentCheque']['fees_payment_cheque_date'];
$chequedate = date("Y-m-d", strtotime($cheque_date));
$pay_cheque->fees_payment_cheque_date = $chequedate;
$pay_cheque->fees_payment_cheque_organization_id = Yii::app()->user->getState('org_id');
if ($pay_cheque->save()) {
$last_receipt_id = Yii::app()->db->createCommand()->select('MAX(fees_receipt_number) as lastid')->from('fees_receipt')->where('fees_receipt_org_id=:id', array(':id' => Yii::app()->user->getState('org_id')))->queryRow();
$receipt->fees_receipt_number = $last_receipt_id['lastid'] + 1;
$receipt->fees_receipt_org_id = Yii::app()->user->getState('org_id');
$receipt->save();
$pay_trans->fees_payment_master_id = Yii::app()->user->getState('fees_master_id');
$pay_trans->fees_payment_method_id = 2;
$pay_trans->fees_payment_cash_cheque_id = $pay_cheque->fees_payment_cheque_id;
$pay_trans->fees_receipt_id = $receipt->fees_receipt_id;
$pay_trans->fees_payment = 1;
$pay_trans->fees_received_user_id = Yii::app()->user->id;
$pay_trans->fees_full_part_payment_id = 1;
$pay_trans->fees_student_id = Yii::app()->user->getState('student_id');
$pay_trans->fees_payment_transaction_organization_id = Yii::app()->user->getState('org_id');
$pay_trans->fees_received_date = new CDbExpression('NOW()');
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => Yii::app()->user->getState('student_id')));
$pay_trans->fees_academic_period_id = $stud_trans->student_academic_term_period_tran_id;
$pay_trans->fees_academic_term_id = $stud_trans->student_academic_term_name_id;
$pay_trans->save();
$stud_add_id = $stud_trans->student_transaction_student_address_id;
$stud_info_id = $stud_trans->student_transaction_student_id;
$stud_add_mobile = StudentInfo::model()->findByPk($stud_info_id)->student_mobile_no;
$stud_email_id = StudentInfo::model()->findByPk($stud_info_id)->student_email_id_1;
$this->redirect(array('create', 'id' => $pay_trans->fees_student_id));
}
}
$this->render('payfeescheque', array('model' => $model, 'pay_cheque' => $pay_cheque));
}
echo "<td> </td>";
}
} else {
if ($s == 'city') {
if ($sd['student_transaction_student_address_id'] != 0) {
$add = StudentAddress::model()->findByPk($sd['student_transaction_student_address_id']);
if ($add->student_address_c_city != null) {
echo "<td style='text-align:center;'>" . City::model()->findByPk($add->student_address_c_city)->city_name . "</td>";
} else {
echo "<td> </td>";
}
} else {
echo "<td> </td>";
}
} else {
echo "<td style='text-align:center;'>" . StudentInfo::model()->findByPk($sd['student_transaction_student_id'])->{$s} . "</td>";
}
}
}
}
}
}
}
}
}
$i++;
echo "</tr>";
$m++;
}
echo "</table>";
echo "</div>";
<?php
$student_name = StudentInfo::model()->findByPk(StudentTransaction::model()->findByPk($_REQUEST['id'])->student_transaction_student_id);
$org_id = Yii::app()->user->getState('org_id');
$fees = FeesPaymentTransaction::model()->findAll('fees_student_id=' . $_REQUEST['id'] . ' and fees_payment_transaction_organization_id = ' . $org_id);
if (!empty($fees)) {
?>
<?php
$i = 1;
$m = 1;
$k = 0;
$var = 0;
$out = 0;
$payable = 0;
$payable1 = 0;
$term_id = 0;
$ch_num = "";
$temp = 0;
foreach ($fees as $f) {
$flag = 0;
$columns = array();
$columns['id'] = $m;
$columns['acdm_period'] = AcademicTermPeriod::model()->findByPk($f->fees_academic_period_id)->academic_term_period;
$columns['sem'] = AcademicTerm::model()->findByPk($f->fees_academic_term_id)->academic_term_name;
$columns['method'] = FeesPaymentMethod::model()->findByPk($f->fees_payment_method_id)->fees_payment_method_name;
if ($f->fees_payment_method_id == 1) {
if ($m == 1) {
$term_id = $f->fees_academic_term_id;
<button style='margin-left:50px;' class='submit' onclick="javascript:window.print()" id="printid1" class="submit">Print</button>
<?php
if(Yii::app()->controller->action->id!="certiview"){
echo CHtml::link('GO BACK', array('certificate/certificategeneration'),array('class'=>'back'));
echo CHtml::button('Save',array('id'=>"printid1",'class'=>'submit','submit' => array('certificate/SaveStudentCertificatedata','stid'=>$stud_info->student_info_transaction_id,'ctype'=>$certificate_type)));
}
else
{
if(!empty($_REQUEST['studid']))
echo CHtml::link('GO BACK', array('student/studentTransaction/studentcertificate','id'=>$_REQUEST['studid']),array('class'=>'back'));
}
if(!isset($stud_info))
$stud_info = StudentInfo::model()->findByAttributes(array('student_enroll_no'=>$en_no));
if($stud_info)
{
$trans = StudentTransaction::model()->findByPk($stud_info->student_info_transaction_id);
$titl = "<b>".$stud_info->title."</b>";
$name = "<b>".$stud_info->student_first_name." ".$stud_info->student_middle_name." ".$stud_info->student_last_name."</b>";
$smobile = "<b>".$stud_info->student_mobile_no."</b>";
$pmobile = "<b>".$stud_info->student_guardian_mobile."</b>";
$branch_model=Branch::model()->findByPk($trans->student_transaction_branch_id);
$en_no = "<b>".$stud_info->student_enroll_no."</b>";
$branch = "<b>".$branch_model->branch_name."</b>";
$sem = "<b>Sem-".AcademicTerm::model()->findByPk($trans->student_academic_term_name_id)->academic_term_name."</b>";
if($trans->student_transaction_division_id != 0)
$div = "<b>".Division::model()->findByPk($trans->student_transaction_division_id)->division_name."</b>";
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
));
}
public function loadAllNotice($list)
{
$menu = null;
foreach($list as $notice) {
$menu .= '<div class="notify-data notifiche">';
$menu .='<span class="username">';
$menu .=$notice->title;
$menu .='</span></br>';
$menu .='<span class="notice-lable"><b>From</b></span><span class="notice-content">';
$menu .=(User::model()->findByPk($notice->from)->user_type=='employee')?(EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id'=>$notice->from))->employee_transaction_id)))->employee_first_name):(StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>(StudentTransaction::model()->findByAttributes(array('student_transaction_user_id'=>$notice->from))->student_transaction_id)))->student_first_name);
$menu .='</span><span class="notice-lable"><b>Content</b></span>';
$menu .='<span class="notice-content">'.$notice->content.'</span></div>';
}
return $menu;
}
<?php
$this->breadcrumbs = array('Student Attendences' => array('admin'), StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $model->st_id))->student_first_name, 'Edit');
$this->menu = array(array('label' => '', 'url' => array('admin'), 'linkOptions' => array('class' => 'Manage', 'title' => 'Manage')));
?>
<h1>Edit Student Attendence <?php
//echo $model->id;
?>
</h1>
<?php
echo $this->renderPartial('update_atten_form', array('model' => $model));
<?php
/*
$this->menu=array(
array('label'=>'List StudentFeesMaster', 'url'=>array('index')),
array('label'=>'Create StudentFeesMaster', 'url'=>array('create')),
array('label'=>'View StudentFeesMaster', 'url'=>array('view', 'id'=>$model->student_fees_master_id)),
array('label'=>'Manage StudentFeesMaster', 'url'=>array('admin')),
);*/
?>
<h1>Edit Student Fees <?php
//echo $model->student_fees_master_id;
?>
</h1></br>
<?php
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $model->student_fees_master_student_transaction_id));
$stud_tran_info = StudentTransaction::model()->findByPk($model->student_fees_master_student_transaction_id);
$academic_period = AcademicTermPeriod::model()->findByPk($stud_tran_info->student_academic_term_period_tran_id)->academic_term_period;
$semester = AcademicTerm::model()->findByPk($stud_tran_info->student_academic_term_name_id)->academic_term_name;
?>
<table border="2px" id="twoColThinTable">
<tr class="row">
<td class="col1">Name </td>
<td class="col2"><?php
echo $stud_info->student_first_name . ' ' . $stud_info->student_middle_name . ' ' . $stud_info->student_last_name;
?>
</td>
</tr>
<tr class="row">
<td class="col1">Enrollment No. </td>
<?php
if (!empty($row1)) {
?>
<div class="form">
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'attendence-form', 'enableAjaxValidation' => false, 'clientOptions' => array('validateOnSubmit' => true)));
?>
<?php
$count = 0;
$count = count($row1);
for ($i = 0; $i < count($row1); $i++) {
$stud_id = $row1[$i]['student_transaction_student_id'];
$name_lable = StudentInfo::model()->findByPk($row1[$i]['student_transaction_student_id'])->student_first_name;
?>
<div class="row">
<?php
echo $form->labelEx($model, $name_lable);
?>
<?php
echo $form->checkBox($model, 'st_id[]', array('value' => $stud_id, 'uncheckValue' => null, 'checked' => 'checked'));
?>
<?php
//echo CHtml::activeCheckBox($model,'stud_id[]'.$i,array('checked'=>false,'value'=>$stud_id,'uncheckValue' => null));
?>
<?php
echo $form->error($model, 'stud_id');
?>
}
if(!Yii::app()->user->isGuest && !Yii::app()->user->getState('parent_id'))
{
$count = 0;
$count = Mailbox::model()->newMsgs(Yii::app()->user->id);
?>
<li><a href="<?php echo Yii::app()->baseUrl;?>/mailbox" class="nav-link green"><i class="fa fa-envelope"></i> <span class="nav-counter nav-counter-blue"><?php echo $count;?></span></a></li>
<?php
}?>
<li><a href="#" class="nav-link orange"><i class="fa fa-tasks"></i> <span class="nav-counter nav-counter-green">15</span></a></li>
<?php
$isStudent = Yii::app()->user->getState('stud_id');
$isEmployee = Yii::app()->user->getState('emp_id');
if(isset($isStudent))
{
$stdinfo = StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>Yii::app()->user->getState('stud_id')));
$stu_tran = StudentTransaction::model()->findByPk(Yii::app()->user->getState('stud_id'));
$stdpicPath = StudentPhotos::model()->findByPk($stu_tran->student_transaction_student_photos_id);
$stud_photo=Yii::app()->baseUrl."/college_data/stud_images/".$stdpicPath->student_photos_path;
?>
<li><a href="#" class="nav-link user-image-nav"><img src="<?php echo $stud_photo; ?>" width="51" height="51" class="userimage"></a></li>
<li class="user-image-line" id="dropdown"><a href="#" class="nav-link">
<?php
echo $stdinfo->student_first_name;
?>
<i class="fa fa-caret-down"></i></a>
<ul>
<li><a href="<?php echo Yii::app()->baseUrl;?>/student/studentTransaction/update?id=<?php echo Yii::app()->user->getState('stud_id');?>">My Profile</a></li>
<li><a href="<?php echo Yii::app()->baseUrl;?>/user/change"">Change Password</a></li>
<li><a href="<?php echo Yii::app()->baseUrl;?>/mailbox">My Inbox</a></li>
<li><?php echo CHtml::link('Log Out', Yii::app()->baseUrl.'/site/logout')?></li>
function studentSignin()
{
try {
$pdo = new PDO(DB_PDODRIVER . ':host=' . DB_HOST . ';dbname=' . DB_NAME . '', DB_USER, DB_PASS);
} catch (\PDOException $e) {
echo "Connection failed: " . $e->getMessage();
exit;
}
$student_info = new StudentInfo();
//$student_id = $student_info->generateId();
$fname = $student_info->firstName();
$lname = $student_info->lastName();
session_unset();
$query = "SELECT * FROM student WHERE student_fname = :fname AND student_lname = :lname";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':lname', $lname);
$stmt->execute();
if ($stmt->fetch(PDO::FETCH_ASSOC)) {
while ($student = $stmt->fetch(PDO::FETCH_ASSOC)) {
$_SESSION['user_id'] = $student['student_id'];
$_SESSION['f_name'] = $student['student_fname'];
$_SESSION['l_name'] = $student['student_lname'];
$_SESSION['theme'] = "red";
$_SESSION['rank'] = 1;
}
} else {
$student_id = $student_info->generateId();
$_SESSION['user_id'] = $student_id;
$_SESSION['f_name'] = $fname;
$_SESSION['l_name'] = $lname;
$_SESSION['theme'] = "red";
$_SERVER['rank'] = 1;
$query = "INSERT INTO student (student_id, student_fname, student_lname) VALUES (:student_id, :fname, :lname)";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':student_id', $student_id, PDO::PARAM_INT);
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':lname', $lname);
$stmt->execute();
//$course_id = rand(1,3);
$query = "SELECT * FROM class";
// This part can just be replaced with a COUNT function
$stmt = $pdo->prepare($query);
$stmt->execute();
$num_classes = $stmt->rowCount();
$classes_enrolled = array();
$classes_enrolled[0] = rand(1, 3);
while (($i = rand(1, 3)) == $classes_enrolled[0]) {
}
$classes_enrolled[1] = $i;
while (($i = rand(1, 3)) == $classes_enrolled[0] || $i == $classes_enrolled[1]) {
}
$classes_enrolled[2] = $i;
for ($i = 0; $i < 3; $i++) {
$query = "INSERT INTO enroll (enroll_student_id, enroll_class_id) VALUES (:student_id, :course_id)";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':student_id', $student_id);
$stmt->bindParam(':course_id', $classes_enrolled[$i]);
$stmt->execute();
}
}
$pdo = null;
}
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++;
}
echo "</table>";
} else {
print "<h1 style=\"color:red;text-align:center\">No Record To Display</h1>";
}
<th>Paid Amount</th>
<th>Outstanding</th>
</tr>
<?php
$i = 0;
$m = 1;
$grandpayable = 0;
$grandpaidtotal = 0;
$grandoutstandtotal = 0;
foreach ($data as $info) {
if ($m % 2 == 0) {
$class = "odd";
} else {
$class = "even";
}
$detail = StudentInfo::model()->findByPk($info['student_transaction_student_id']);
echo "<tr class=" . $class . "><td>" . ++$i . "</td>";
echo "<td>" . $detail->student_enroll_no . "</td><td>" . $detail->student_roll_no . "</td>\n\t <td>" . $detail->student_first_name . " " . $detail->student_middle_name . " " . $detail->student_last_name . "</td>";
$amtdata = Yii::app()->db->createCommand()->select('sum(fees_details_amount) as total')->from('student_fees_master')->where('student_fees_master_student_transaction_id=' . $info['student_transaction_id'] . ' and fees_master_table_id=' . $fees_masterid)->queryRow();
$var_amt = $amtdata['total'];
echo "<td>" . $var_amt . "</td>";
$grandpayable += $var_amt;
$totalpaidamt = 0;
$paid_amt = FeesPaymentTransaction::model()->findAll(array('condition' => 'fees_payment_master_id=' . $fees_masterid . ' and fees_student_id=' . $info['student_transaction_id']));
foreach ($paid_amt as $list) {
if ($list['fees_payment_method_id'] == 1) {
$totalpaidcash = FeesPaymentCash::model()->findByPk($list['fees_payment_cash_cheque_id']);
$totalpaidamt += $totalpaidcash->fees_payment_cash_amount;
} else {
$totalpaidchaque = FeesPaymentCheque::model()->findByPk($list['fees_payment_cash_cheque_id']);
if ($totalpaidchaque->fees_payment_cheque_status == 0) {
</h3>
<div class="contact-details">
<?php
echo $org_data->address_line1 . " " . $org_data->address_line2 . "</br>" . $orgcity . "-" . $org_data->pin . " " . $orgstate;
echo "</br>";
echo "Ph: " . $org_data->phone . ", Fax: " . $org_data->fax_no;
echo "</br>";
echo "Website: " . $org_data->website . "</br>";
echo "Email: " . $org_data->email;
?>
</div>
</div>
</div>
<!-- End Header div-->
<?php
$StudentInfo = StudentInfo::model()->findByPk($stud['student_transaction_student_id']);
$label = null;
$field_value = null;
?>
<!--Content div-->
<div class="front_content">
<div class="contentpic">
<?php
echo CHtml::image(Yii::app()->baseUrl . "/college_data/stud_images/" . $studphoto, "no-images", array("width" => "60px", "height" => "60px"));
?>
</div>
<div class="contentinfo">
<?php
foreach ($selected_list as $key => $value) {
if ($key == 'quota_name') {
public function actionStudentwisereportpdf()
{
if (!empty($_REQUEST['student_enroll_no']) && !empty($_REQUEST['start']) && !empty($_REQUEST['end'])) {
//$start=null;
//$end=null;
$en = trim($_REQUEST['student_enroll_no']);
$student_data = StudentInfo::model()->findByAttributes(array('student_enroll_no' => $en));
$stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_student_id' => $student_data['student_id']));
$new_start = $_REQUEST['start'];
$new_end = $_REQUEST['end'];
$start = date("Y-m-d", strtotime($new_start));
$end = date("Y-m-d", strtotime($new_end));
$att_info = Attendence::model()->findAll(array('select' => 'sem_name_id', 'distinct' => true, 'condition' => 'attendence_date >=:date_start and attendence_date <= :date_end and st_id = :stu_id', 'params' => array(':date_start' => $start, ':date_end' => $end, 'stu_id' => $stud_trans['student_transaction_id'])));
$sem_data = array();
//print_r($att_info['sem_name_id']); exit;
foreach ($att_info as $list) {
$sem_data[] = $list['sem_name_id'];
}
$sem_array = implode(',', $sem_data);
$subject_data = Yii::app()->db->createCommand()->select('*')->from('subject_master')->where('subject_master_id in (select sub_id from attendence where branch_id=' . $stud_trans['student_transaction_branch_id'] . ' and sem_id=' . $stud_trans['student_academic_term_period_tran_id'] . ') and subject_master_academic_terms_name_id IN(' . $sem_array . ') AND subject_master_organization_id=' . Yii::app()->user->getState('org_id'))->queryAll();
//$subject_data = SubjectMaster::model()->findAll(array('condition'=>'subject_master_academic_terms_period_id='.$stud_trans['student_academic_term_period_tran_id'].' AND subject_master_academic_terms_name_id IN('.$sem_array.') AND subject_master_branch_id ='.$stud_trans['student_transaction_branch_id'].' AND subject_master_organization_id='.Yii::app()->user->getState('org_id')));
/*$new_start=$_REQUEST['start'];
$new_end=$_REQUEST['end'];
$start = date("Y-m-d", strtotime($new_start));
$end = date("Y-m-d", strtotime($new_end));*/
if (isset($_REQUEST['studenewisereportpdf'])) {
Yii::import('application.extensions.tcpdf.*');
require_once 'tcpdf/tcpdf.php';
require_once 'tcpdf/config/lang/eng.php';
//$this->actiondate_report();
$html = $this->renderPartial('student_report_view_pdf', array('subject_data' => $subject_data, 'student_data' => $student_data, 'start' => $_REQUEST['start'], 'end' => $_REQUEST['end']), true);
//print_r($html);exit;
ob_clean();
$pdf = new TCPDF();
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(Yii::app()->name);
$pdf->SetTitle('StudentWise Report');
$pdf->SetSubject('StudentWise Report');
$pdf->SetKeywords('example, text, report');
$pdf->SetHeaderData('', 0, "Report", '');
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Example Report by ".Yii::app()->name, "");
$pdf->setHeaderFont(array('helvetica', '', 8));
$pdf->setFooterFont(array('helvetica', '', 6));
$pdf->SetMargins(15, 18, 15);
$pdf->SetHeaderMargin(5);
$pdf->SetFooterMargin(10);
$pdf->SetAutoPageBreak(TRUE, 15);
$pdf->SetFont('dejavusans', '', 7);
$resolution = array(150, 150);
$pdf->AddPage('P', $resolution);
$pdf->writeHTML($html, true, false, true, false, '');
$pdf->LastPage();
$pdf->Output("StudentWise.pdf", "I");
}
if (isset($_REQUEST['studenewisereportexcel'])) {
Yii::app()->request->sendFile(date('YmdHis') . '.xls', $this->renderPartial('student_report_view_pdf', array('subject_data' => $subject_data, 'student_data' => $student_data, 'start' => $_REQUEST['start'], 'end' => $_REQUEST['end']), true));
}
}
}
<?php
$i=1;
$m=1;
foreach($list as $value)
{
if(($m%2) == 0)
{
$class = "odd";
}
else
{
$class = "even";
}?>
<tr class="<?php echo $class;?>">
<?php echo '<input type="hidden" name="result[]" value="'. $value. '">';
$info= StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>$value));?>
<td class="col2"> <?php echo $i ;?></td>
<td class="col2"><?php echo $info->student_first_name." ".$info->student_last_name;?></td>
</tr>
<?php
$i++;$m++;}
?>
</table></br>
</div></div>
<div class="portlet box blue" style="margin-top:20px;">
<i class="icon-reorder"></i>
<div class="portlet-title"><span class="box-title">Fill Details</span>
</div>
<p class="note">Fields with <span class="required">*</span> are required.</p>
/**
* 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.');
}
}
</title>
<body>
<button style='margin-left:50px;' class='submit' onclick="javascript:window.print()" id="printid1" class="submit">Print</button>
<?php
$lis = CHtml::listData($studModel,'student_transaction_id','student_transaction_id');
$st_str = implode(',',$lis);
if(Yii::app()->controller->action->id!="certiview") {
echo CHtml::button('Save',array('id'=>"printid1",'class'=>'submit','submit' => array('certificate/savemultiplecerti','stid'=>$st_str,'ctype'=>$model->certificatetype)));
echo CHtml::link('GO BACK', array('certificate/certificategeneration'),array('class'=>'btnback'));
}
else {
if(!empty($_REQUEST['studid']))
echo CHtml::link('GO BACK', array('student/studentTransaction/studentcertificate','id'=>$_REQUEST['studid']),array('class'=>'btnback'));
}
foreach($studModel as $list) {
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>$list['student_transaction_id']));
if($stud_info)
{
$trans = StudentTransaction::model()->findByPk($stud_info->student_info_transaction_id);
$titl = "<b>".$stud_info->title."</b>";
$name = "<b>".$stud_info->student_first_name." ".$stud_info->student_middle_name." ".$stud_info->student_last_name."</b>";
$smobile = "<b>".$stud_info->student_mobile_no."</b>";
$pmobile = "<b>".$stud_info->student_guardian_mobile."</b>";
$branch_model=Branch::model()->findByPk($trans->student_transaction_branch_id);
$en_no = "<b>".$stud_info->student_enroll_no."</b>";
$branch = "<b>".$branch_model->branch_name."</b>";
$sem = "<b>Sem-".AcademicTerm::model()->findByPk($trans->student_academic_term_name_id)->academic_term_name."</b>";
if($trans->student_transaction_division_id != 0)
$div = "<b>".Division::model()->findByPk($trans->student_transaction_division_id)->division_name."</b>";
else
</th>
<th>
Guardian Mobile No.
</th>
</tr>
<?php
foreach($model as $m=>$v) {
if($m <> 0) {
?> <tr>
<td >
<?php echo ++$k; ?>
</td>
<td>
<?php $inf = StudentInfo::model()->findByPk($v['student_transaction_student_id']); ?>
<?php echo $inf->student_roll_no; ?>
</td>
<td>
<?php echo $inf->student_first_name; ?>
</td>
<td>
<?php echo $inf->student_last_name; ?>
</td>
<td>
<?php echo $inf->student_mobile_no; ?>
</td>
<td>
<?php echo $inf->student_guardian_mobile; ?>
</td>
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 '<label>' . $label . ' : </label>';
?>
<div class="value-detail"><?php
echo $field_value;
?>
</div>
</div>
<?php
}
<?php for($i = 1; $i<=$num; $i++) {
print '<th>'.$i.'</th>';
}
print '<th>No.of <br> Lectures <br>Taken </th>';
print '<th> No. of <br>Lectures <br>Attended </th>';
print '<th> <br>Percentage </th>';
foreach($student_id as $stud_tran_id)
{
echo '<tr align=center >';
echo '<center>';
echo '<td>';
echo ++$m;
echo '</td>';
$a = 1;
$stud_name=StudentInfo::model()->findByAttributes(array('student_info_transaction_id'=>$stud_tran_id));
print "<td>";
if(!empty($stud_name->student_enroll_no))
echo $stud_name->student_enroll_no;
else
echo 'Not Set';
print "</td>";
print "<td colspan=4 align=left>";
echo $stud_name->student_first_name.' '.$stud_name->student_last_name.'('.$stud_name->student_roll_no.')';
print "</td>";
for($j = 1; $j<=$num; $j++)
{
if(strlen($j) == 1)
$j = "0".$j;
$date = $j.'-'.$month_value.'-'.date('Y');
