public function actionAjax_delete()
{
$id = $_POST['id'];
$deleted = $this->loadModel($id);
if ($deleted->delete()) {
FinanceFeeParticulars::model()->DeleteAllByAttributes(array('finance_fee_category_id' => $id));
//FinanceFeeCollections::model()->DeleteAllByAttributes(array('fee_category_id'=>$id));
$fee_collections = FinanceFeeCollections::model()->findAllByAttributes(array('fee_category_id' => $id));
foreach ($fee_collections as $fee_collection) {
FinanceFees::model()->DeleteAllByAttributes(array('fee_collection_id' => $fee_collection->id));
FinanceTransaction::model()->deleteAll('collection_id=:x', array(':x' => $fee_collection->id));
}
FinanceFeeCollections::model()->DeleteAllByAttributes(array('fee_category_id' => $id));
echo json_encode(array('success' => true));
exit;
} else {
echo json_encode(array('success' => false));
exit;
}
}
public function actionAjax_Create()
{
if (isset($_POST['FinanceFeeParticulars'])) {
//return the JSON result to provide feedback.
$list = $_POST['FinanceFeeParticulars'];
$count = sizeof($list['id']);
for ($i = 0; $i < $count; $i++) {
$model = new FinanceFeeParticulars();
//set the submitted values
$model->attributes = $_POST['FinanceFeeParticulars'];
$model->student_category_id = $list['id'][$i];
$model->amount = str_replace(",", "", $model->amount);
if ($model->save(false)) {
$finance_fee_collections = FinanceFeeCollections::model()->findAll(array('condition' => 'fee_category_id = :id', 'params' => array(':id' => $model->finance_fee_category_id)));
foreach ($finance_fee_collections as $finance_fee_collection) {
$finance_fees = FinanceFees::model()->findAll(array('condition' => 'fee_collection_id = :id', 'params' => array(':id' => $finance_fee_collection->id)));
foreach ($finance_fees as $finance_fee) {
$finance_fee->is_paid = 0;
$finance_fee->save(false);
}
}
}
}
echo json_encode(array('success' => true, 'id' => $model->primaryKey));
exit;
}
}
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'));
}
}
foreach ($check_admission_no as $adm_no) {
$adm_amount = $adm_amount + $adm_no->amount;
}
echo $adm_amount . ' ' . $currency->config_value;
} else {
// If any particular is present for this student category
$check_student_category = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $posts->fee_category_id, 'student_category_id' => $model->student_category_id, 'admission_no' => ''));
if (count($check_student_category) > 0) {
$cat_amount = 0;
foreach ($check_student_category as $stu_cat) {
$cat_amount = $cat_amount + $stu_cat->amount;
}
echo $cat_amount . ' ' . $currency->config_value;
} else {
//If no particular is present for this student or student category
$check_all = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $posts->fee_category_id, 'student_category_id' => NULL, 'admission_no' => ''));
if (count($check_all) > 0) {
$all_amount = 0;
foreach ($check_all as $all) {
$all_amount = $all_amount + $all->amount;
}
echo $all_amount . ' ' . $currency->config_value;
} else {
echo '-';
// If no particular is found.
}
}
}
?>
</td>
public function actionEditfees()
{
if (isset($_POST['FinanceFees']) and isset($_POST['FinanceFees']['fees_paid'])) {
$model = $this->loadModel($_POST['FinanceFees']['id']);
$dt = date('Y-m-d');
$model->saveAttributes(array('date' => $dt));
$student = Students::model()->findByAttributes(array('id' => $_POST['FinanceFees']['student_id']));
$collection = FinanceFeeCollections::model()->findByAttributes(array('id' => $_POST['FinanceFees']['fee_collection_id']));
$check_admission_no = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $collection->fee_category_id, 'admission_no' => $student->admission_no));
if (count($check_admission_no) > 0) {
// If any particular is present for this student
$adm_amount = 0;
foreach ($check_admission_no as $adm_no) {
$adm_amount = $adm_amount + $adm_no->amount;
}
$fees = $adm_amount;
} else {
// If any particular is present for this student category
$check_student_category = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $collection->fee_category_id, 'student_category_id' => $student->student_category_id, 'admission_no' => ''));
if (count($check_student_category) > 0) {
$cat_amount = 0;
foreach ($check_student_category as $stu_cat) {
$cat_amount = $cat_amount + $stu_cat->amount;
}
$fees = $cat_amount;
} else {
//If no particular is present for this student or student category
$check_all = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $collection->fee_category_id, 'student_category_id' => NULL, 'admission_no' => ''));
if (count($check_all) > 0) {
$all_amount = 0;
foreach ($check_all as $all) {
$all_amount = $all_amount + $all->amount;
}
$fees = $all_amount;
} else {
$fees = 0;
// If no particular is found.
}
}
}
} elseif (isset($_REQUEST['id'])) {
$model = $this->loadModel($_REQUEST['id']);
}
// Flag to know if we will render the form or try to add
// new json.
$flag = true;
if (isset($_POST['FinanceFees']) and isset($_POST['FinanceFees']['fees_paid'])) {
$flag = false;
$fees_paid = $_POST['FinanceFees']['fees_paid'];
if ($model->saveAttributes(array('fees_paid' => $fees_paid))) {
if ($fees == $fees_paid) {
$model->saveAttributes(array('is_paid' => 1));
} elseif ($fees != $fees_paid and $model->is_paid == 1) {
$model->saveAttributes(array('is_paid' => 0));
}
echo CJSON::encode(array('status' => 'success'));
exit;
} else {
echo CJSON::encode(array('status' => 'error'));
exit;
}
}
if ($flag) {
Yii::app()->clientScript->scriptMap['jquery.js'] = false;
$this->renderPartial('partialfees', array('model' => $model), false, true);
}
}
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;
}
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="247" valign="top">
<?php
$this->renderPartial('//assesments/left_side');
?>
</td>
<td valign="top">
<div class="cont_right formWrapper">
<?php
if (isset($_REQUEST['id'])) {
$data = FinanceFeeParticulars::model()->findAll("finance_fee_category_id =:x", array(':x' => $_REQUEST['id']));
?>
<div class="tablebx">
<table width="50%">
<tr class="tablebx_topbg">
<td>Sl no.</td>
<td>Category</td>
<td>Student Category</td>
<td>Admission number</td>
<td>Amount( $ )</td>
<td>Created Date</td>
</tr>
<?php
$i = 1;
foreach ($data as $data_1) {
echo '<tr class="even">';
echo '<td>' . $i . '</td>';
<tr>
<td style="border-left:#cad4dc 1px solid;"><?php echo $i; ?></td>
<td><?php echo $particular->name.'-'.$particular->student_category_id; ?></td>
<td><?php echo $particular->amount.'-'.$particular->admission_no; ?></td>
</tr>
<?php
$amount = $amount + $particular->amount;
$i++;}
?><?php */
?>
<?php
$check_admission_no = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $collection->fee_category_id, 'admission_no' => $student->admission_no));
if ($check_admission_no != NULL) {
$particulars = $check_admission_no;
} elseif ($student->student_category_id != NULL) {
$check_student_category = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id' => $collection->fee_category_id, 'student_category_id' => $student->student_category_id, 'admission_no' => ''));
if ($check_student_category != NULL) {
$particulars = $check_student_category;
} else {
/*
$check_all = FinanceFeeParticulars::model()->findAllByAttributes(array('finance_fee_category_id'=>$collection->fee_category_id,'student_category_id'=>NULL,'admission_no'=>''));
if($check_all!=NULL){
$particulars = $check_all;
}
else{
?>
<?php
}*/
?>
?>
</strong></th>
<th><strong><?php
echo Yii::t('fees', 'Paticulars');
?>
</strong></th>
<th><strong><?php
echo Yii::t('fees', 'Amount');
?>
</strong></th>
</tr>
<?php
foreach ($list as $list_1) {
$collection = FinanceFeeCollections::model()->findAllByAttributes(array('batch_id' => $list_1->batch_id));
for ($i = 0; $i < count($collection); $i++) {
$particular = FinanceFeeParticulars::model()->findAll("finance_fee_category_id=:x", array(':x' => $collection[$i]->fee_category_id));
$list = FinanceFees::model()->findAll("fee_collection_id=:x", array(':x' => $collection[$i]->id));
}
$k = 1;
for ($j = 0; $j < count($particular); $j++) {
$amount = $amount + $particular[$i]->amount;
$k++;
}
}
?>
<tr>
<td><?php
echo $i;
?>
</td>
<td><?php
