public function feecategory($data, $row)
{
$fees_category = FinanceFeeCategories::model()->findByAttributes(array('id' => $data->fee_category_id, 'is_deleted' => 0));
if (count($fees_category) > 0) {
return $fees_category->name;
} else {
return '-';
}
}
public function actionAjax_Create()
{
if (isset($_POST['FinanceFeeCategories'])) {
//$model=new FinanceFeeCategories;
//set the submitted values
$model->attributes = $_POST['FinanceFeeCategories'];
$list = $_POST['FinanceFeeCategories'];
$count = sizeof($list['batch_id']);
for ($i = 0; $i < $count; $i++) {
$batch = Batches::model()->findByAttributes(array('id' => $list['batch_id'][$i]));
$course = Courses::model()->findByAttributes(array('id' => $batch->course_id));
$model = new FinanceFeeCategories();
$model->name = $list['name'];
$model->description = $list['name'] . ' for ' . $batch->name . '( ' . $course->course_name . ') ' . $list['description'];
$model->batch_id = $list['batch_id'][$i];
$model->is_deleted = $list['is_deleted'];
$model->is_master = $list['is_master'];
$model->created_at = $list['created_at'];
$model->updated_at = $list['updated_at'];
$model->save();
}
echo json_encode(array('success' => true));
exit;
}
}
<?php
$res = FinanceFees::model()->findAll(array('condition' => 'student_id=:vwid AND is_paid=:vpid', 'params' => array(':vwid' => $_REQUEST['id'], ':vpid' => 1)));
if (count($res) == 0) {
?>
<tr>
<td colspan="3"><?php
echo Yii::t('students', 'No details of the fees paid available.');
?>
</td>
</tr>
<?php
} else {
foreach ($res as $res_1) {
$amount = 0;
$posts = FinanceFeeCollections::model()->findByAttributes(array('id' => $res_1->fee_collection_id));
$cat = FinanceFeeCategories::model()->findByAttributes(array('id' => $posts->fee_category_id));
/*$particular = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id'=>$posts->fee_category_id));
if($particular!=NULL)
{
foreach($particular as $particulars)
{
$amount = $amount+$particulars->amount;
}
}*/
?>
<tr>
<td><?php
if (@$cat) {
echo $cat->name;
}
public function actionDeactivate($id)
{
$model = Courses::model()->findByPk($id);
$model->is_deleted = 1;
if ($model->save()) {
// Batch Deletion
$batches = Batches::model()->findAllByAttributes(array('course_id' => $id));
//Selecting all batches under the course with id = $id
foreach ($batches as $batch) {
// Student Deletion
$students = Students::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($students as $student) {
//Making student user inactive
if ($student->uid != NULL and $student->uid != 0) {
$student_user = User::model()->findByAttributes(array('id' => $student->uid));
if ($student_user != NULL) {
$student_user->saveAttributes(array('status' => '0'));
}
}
//Making parent user inactive
$parent = Guardians::model()->findByAttributes(array('ward_id' => $student->id));
if ($parent->uid != NULL and $parent->uid != 0) {
$parent_user = User::model()->findByAttributes(array('id' => $parent->uid));
if ($parent_user != NULL) {
$parent_user->saveAttributes(array('status' => '0'));
}
}
$student->saveAttributes(array('is_active' => '0', 'is_deleted' => '1'));
// Student Deleted
}
// Subject Association Deletion
$subjects = Subjects::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($subjects as $subject) {
EmployeesSubjects::model()->DeleteAllByAttributes(array('subject_id' => $subject->id));
$subject->delete();
}
// Exam Group Deletion
$examgroups = ExamGroups::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($examgroups as $examgroup) {
// Exams Deletion
$exams = Exams::model()->findAllByAttributes(array('exam_group_id' => $examgroup->id));
foreach ($exams as $exam) {
//Exam Score Deletion
$examscores = ExamScores::model()->DeleteAllByAttributes(array('exam_id' => $exam->id));
$exam->delete();
//Exam Deleted
}
$examgroup->delete();
//Exam Group Deleted
}
//Fee Collection Deletion
$collections = FinanceFeeCollections::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($collections as $collection) {
// Finance Fees Deletion
$student_fees = FinanceFees::model()->DeleteAllByAttributes(array('fee_collection_id' => $collection->id));
$transaction = FinanceTransaction::model()->DeleteAllByAttributes(array('collection_id' => $collection->id));
$collection->delete();
// Fee Collection Deleted
}
//Fee Category Deletion
$categories = FinanceFeeCategories::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($categories as $category) {
// Fee Particular Deletion
$particulars = FinanceFeeParticulars::model()->DeleteAllByAttributes(array('finance_fee_category_id' => $category->id));
$category->delete();
// Fee Category Deleted
}
//Timetable Entry Deletion
$periods = TimetableEntries::model()->DeleteAllByAttributes(array('batch_id' => $batch->id));
//Class Timings Deletion
$class_timings = ClassTimings::model()->DeleteAllByAttributes(array('batch_id' => $batch->id));
//Delete Weekdays
$weekdays = Weekdays::model()->DeleteAllByAttributes(array('batch_id' => $batch->id));
$batch->is_active = 0;
$batch->is_deleted = 1;
$batch->employee_id = ' ';
$batch->save();
// Batch Deleted
}
Yii::app()->user->setFlash('success', "Selected course is deleted!");
$this->redirect(array('managecourse'));
}
}
</table>
</div>
<!-- End Header -->
<br /><br />
<span align="center"><h4><?php
echo Yii::t('fees', 'LIST OF STUDENTS WITH NO FEE DUES');
?>
</h4></span>
<!-- Fees and course details -->
<div style="border:#CCC 1px; width:700px; padding:10px 10px; background:#E1EAEF;">
<table style="font-size:14px;">
<?php
$batch = Batches::model()->findByAttributes(array('id' => $_REQUEST['batch']));
$course_name = Courses::model()->findByAttributes(array('id' => $batch->course_id));
$collection = FinanceFeeCollections::model()->findByAttributes(array('id' => $_REQUEST['collection']));
$category = FinanceFeeCategories::model()->findByAttributes(array('id' => $collection->fee_category_id));
$particulars = FinanceFeeParticulars::model()->findAll("finance_fee_category_id=:x", array(':x' => $collection->fee_category_id));
$currency = Configurations::model()->findByPk(5);
if ($currency->config_value == "₹") {
$currency->config_value = '<img src="images/rupee_symbol.png" width="8">';
}
?>
<tr>
<td style="width:100px;"><b><?php
echo Yii::t('fees', 'Course');
?>
</b></td>
<td style="width:10px;">:</td>
<td style="width:250px;"><?php
echo $course_name->course_name;
?>
$.js_afterValidateAttribute(form, attribute, data, hasError);
}')));
?>
<?php
echo $form->errorSummary($model, '
<div style="font-weight:bold">' . Yii::t('fees', 'Please correct these errors:') . '</div>
', NULL, array('class' => 'errorsum notification errorshow png_bg'));
?>
<p class="note">Fields with <span class="required">*</span> are required.</p>
<div class="row">
<?php
echo $form->labelEx($model, 'fee_category_id', array('style' => 'color:#222222'));
?>
<?php
$models = FinanceFeeCategories::model()->findAll("is_master=:x", array(':x' => 1));
$data = array();
foreach ($models as $model_1) {
$posts = Batches::model()->findByPk($model_1->batch_id);
$data[$model_1->id] = @$model_1->name . '-' . @$posts->name . '(' . @$model_1->description . ')';
}
?>
<?php
echo $form->dropDownList($model, 'fee_category_id', $data, array('empty' => 'Select Fee Category'));
?>
<span style="margin-top:0px; position: relative; right:83px; top:6px;" id="success-FinanceFeeCollections_fee_category_id"
class="hid input-notification-success success png_bg right"></span>
<div>
<small></small>
</div>
Yii::app()->clientScript->registerScript('ajax-link-handler2-user', "\n\$('#userloaddrop_link a').live('click', function(event){\n\t \$.ajax({\n 'type':'get',\n 'url':\$(this).attr('href'),\n 'dataType': 'html',\n 'success':function(data){\n \$('#user_panel_handler').html(data);\n\t\t\t\t\t\t\n }\n });\n event.preventDefault();\n});\n");
Yii::app()->clientScript->registerScript('ajax-link-handler1', "\n\$('#student_div a').live('click', function(event){\n\t\$.ajax({\n 'type':'get',\n 'url':\$(this).attr('href'),\n 'dataType': 'html',\n 'success':function(data){\n\t\t\t\t\tvar label = data.split('@#\$`')[0];\n\t\t\t\t\tvar id = data.split('@#\$`')[1];\n\t\t\t\t\t\n \$('#name_widget').val(label);\n\t\t\t\t\t\t\$('#id_widget').val(id);\n\t\t\t\t\t\t\$('#explorer_handler').html('');\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n }\n });\n event.preventDefault();\n});\n");
Yii::app()->clientScript->registerScript('ajax-link-handler1-user', "\n\$('#user_div a').live('click', function(event){\n\t\$.ajax({\n 'type':'get',\n 'url':\$(this).attr('href'),\n 'dataType': 'html',\n 'success':function(data){\n\t\t\t\t\tvar label = data.split('@#\$`')[0];\n\t\t\t\t\tvar id = data.split('@#\$`')[1];\n\t\t\t\t\t\n \$('#name_widget').val(label);\n\t\t\t\t\t\t\$('#id_widget').val(id);\n\t\t\t\t\t\t\$('#explorer_handler').html('');\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n }\n });\n event.preventDefault();\n});\n");
$setup_stu = false;
$setup_emp = false;
$setup_cou = false;
$setup_fee = false;
$setup_tim = false;
$setup_lib = false;
$setup_hos = false;
$setup_tra = false;
$setups = 0;
$exp_stu = Students::model()->findAll();
$exp_emp = Employees::model()->findAll();
$exp_cou = Courses::model()->findAll();
$exp_fee = FinanceFeeCategories::model()->findAll();
$exp_tim = TimetableEntries::model()->findAll();
Yii::app()->getModule('library');
$exp_lib = Book::model()->findAll();
Yii::app()->getModule('hostel');
$exp_hos = Hosteldetails::model()->findAll();
Yii::app()->getModule('transport');
$exp_tra = RouteDetails::model()->findAll();
if (count($exp_stu)) {
$setup_stu = true;
$setups++;
}
if (count($exp_emp)) {
$setup_emp = true;
$setups++;
}
<?php
$this->renderPartial('//assesments/left_side');
?>
</td>
<td valign="top">
<div class="cont_right formWrapper">
<h1>Create Additional View</h1>
<div class="formCon" style="width:60%">
<div class="formConInner">
<?php
if (isset($_REQUEST['id'])) {
$posts_1 = FinanceFeeCategories::model()->findByAttributes(array('id' => $_REQUEST['id']));
$posts = FinanceFeeCollections::model()->findByAttributes(array('fee_category_id' => $posts_1->id));
?>
<table width="50%">
<tr>
<td>Category Name</td>
<td></td>
<td><?php
echo $posts_1->name;
?>
</td>
</tr>
<tr>
<td>Description</td>
<td></td>
<td><?php
$val = $_REQUEST['id'];
} else {
$val = '';
}
echo CHtml::dropDownList('batch', '', $data, array('onchange' => 'batch()', 'id' => 'batchdrop', 'empty' => 'Select Batch', 'options' => array($val => array('selected' => true))));
if (isset($_REQUEST['id'])) {
$criteria = new CDbCriteria();
$criteria->compare('is_deleted', 0);
// normal DB field
$criteria->compare('batch_id', $_REQUEST['id']);
$total = FinanceFeeCategories::model()->count($criteria);
$pages = new CPagination($total);
$pages->setPageSize(Yii::app()->params['listPerPage']);
$pages->applyLimit($criteria);
// the trick is here!
$posts = FinanceFeeCategories::model()->findAll($criteria);
?>
<div class="tablebx">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="tablebx_topbg">
<td>Sl. No.</td>
<td>Fees Name</td>
<td>Batch Name</td>
<td>Created Date </td>
<td>Select </td>
<!--<td style="border-right:none;">Task</td>-->
</tr>
<?php
$i = 1;
foreach ($posts as $posts_1) {
public function actionRemove()
{
$val = $_GET['val1'];
$model = Batches::model()->findByPk($val);
$model->is_active = 0;
$model->is_deleted = 1;
$model->employee_id = ' ';
if ($model->save()) {
// Student Deletion
$students = Students::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($students as $student) {
//Making student user inactive
if ($student->uid != NULL and $student->uid != 0) {
$student_user = User::model()->findByAttributes(array('id' => $student->uid));
if ($student_user != NULL) {
$student_user->saveAttributes(array('status' => '0'));
}
}
//Making parent user inactive
$parent = Guardians::model()->findByAttributes(array('ward_id' => $student->id));
if ($parent->uid != NULL and $parent->uid != 0) {
$parent_user = User::model()->findByAttributes(array('id' => $parent->uid));
if ($parent_user != NULL) {
$parent_user->saveAttributes(array('status' => '0'));
}
}
$student->saveAttributes(array('is_active' => '0', 'is_deleted' => '1'));
// Student Deleted
}
// Subject Association Deletion
$subjects = Subjects::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($subjects as $subject) {
EmployeesSubjects::model()->DeleteAllByAttributes(array('subject_id' => $subject->id));
$subject->delete();
}
// Exam Group Deletion
$examgroups = ExamGroups::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($examgroups as $examgroup) {
// Exams Deletion
$exams = Exams::model()->findAllByAttributes(array('exam_group_id' => $examgroup->id));
foreach ($exams as $exam) {
//Exam Score Deletion
$examscores = ExamScores::model()->DeleteAllByAttributes(array('exam_id' => $exam->id));
$exam->delete();
//Exam Deleted
}
$examgroup->delete();
//Exam Group Deleted
}
//Fee Collection Deletion
$collections = FinanceFeeCollections::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($collections as $collection) {
// Finance Fees Deletion
$student_fees = FinanceFees::model()->DeleteAllByAttributes(array('fee_collection_id' => $collection->id));
$collection->delete();
// Fee Collection Deleted
}
//Fee Category Deletion
$categories = FinanceFeeCategories::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($categories as $category) {
// Fee Particular Deletion
$particulars = FinanceFeeParticulars::model()->DeleteAllByAttributes(array('finance_fee_category_id' => $category->id));
$category->delete();
// Fee Category Deleted
}
//Timetable Entry Deletion
$periods = TimetableEntries::model()->DeleteAllByAttributes(array('batch_id' => $model->id));
//Class Timings Deletion
$class_timings = ClassTimings::model()->DeleteAllByAttributes(array('batch_id' => $model->id));
//Delete Weekdays
$weekdays = Weekdays::model()->DeleteAllByAttributes(array('batch_id' => $model->id));
}
echo $val;
}
public function actionAjax_Create()
{
if (isset($_POST['FinanceFeeCollections'])) {
$list = $_POST['FinanceFeeCollections'];
$model = new FinanceFeeCollections();
$model->attributes = $_POST['FinanceFeeCollections'];
if ($model->start_date) {
$model->start_date = date('Y-m-d', strtotime($model->start_date));
}
if ($model->end_date) {
$model->end_date = date('Y-m-d', strtotime($model->end_date));
}
if ($model->due_date) {
$model->due_date = date('Y-m-d', strtotime($model->due_date));
}
$cat = FinanceFeeCategories::model()->findByAttributes(array('id' => $list['fee_category_id']));
$model->batch_id = $cat->batch_id;
//return the JSON result to provide feedback.
$student = Students::model()->findAll("batch_id=:x and is_active=:y and is_deleted=:z", array(':x' => $cat->batch_id, ':y' => 1, ':z' => 0));
if ($model->save(false)) {
foreach ($student as $students) {
$finance = new FinanceFees();
$finance->fee_collection_id = $model->id;
$finance->student_id = $students->id;
$finance->is_paid = 0;
$finance->save();
}
echo json_encode(array('success' => true, 'id' => $model->primaryKey));
exit;
} else {
echo json_encode(array('success' => false));
exit;
}
}
}
echo Yii::t('fees', 'Amount');
?>
</td>
<td><?php
echo $model->amount;
?>
</td>
</tr>
<tr>
<td><?php
echo Yii::t('fees', 'Finance Fee Category');
?>
</td>
<td>
<?php
$category = FinanceFeeCategories::model()->findByAttributes(array('id' => $model->finance_fee_category_id));
echo $category->name;
?>
</td>
</tr>
<tr>
<td><?php
echo Yii::t('fees', 'Student Category');
?>
</td>
<td>
<?php
$student_category = StudentCategories::model()->findByAttributes(array('id' => $model->student_category_id));
if ($student_category) {
echo $student_category->name;
} else {