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