</div> <?php } ?> <?php if (isset($_REQUEST['transaction_id'])) { //$amount = 0; $list = FinanceTransaction::model()->findAll("id=:x", array(':x' => $_REQUEST['transaction_id'])); // print_r($list); ?> <div class="tableinnerlist"> <?php echo Yii::t('fees', 'Transaction Details'); ?> <table width="80%" cellspacing="0" cellpadding="0"> <tr> <th><strong><?php echo Yii::t('fees', 'ID.'); ?> </strong></th> <th><strong><?php echo Yii::t('fees', 'Admission No.');
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')); } }
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 actionPartialreceipt() { $list = FinanceTransaction::model()->findByAttributes(array('id' => $_REQUEST['id'])); $collection_id = $list->collection_id; $student_id = $list->student_id; $collection = FinanceFeeCollections::model()->findByAttributes(array('id' => $collection_id)); $student = Students::model()->findByAttributes(array('id' => $student_id)); $student = $student->first_name . ' ' . $student->last_name . ' Fees Receipt.pdf'; $batch_id = $collection->batch_id; //saving receipt details $receipt = FeeReceipt::model()->findByAttributes(array('student' => $student_id, 'batch' => $batch_id, 'collection' => $collection_id)); if ($receipt == NULL) { $newReceipt = new FeeReceipt(); $newReceipt->student = $student_id; $newReceipt->batch = $batch_id; $newReceipt->collection = $collection_id; if ($newReceipt->validate()) { $newReceipt->save(); $receipt_no = $newReceipt->id; } } else { $receipt_no = $receipt->id; } # HTML2PDF has very similar syntax $html2pdf = Yii::app()->ePdf->HTML2PDF(); $receipt_type = "student_copy"; $html2pdf->WriteHTML($this->renderPartial('partialreceipt', array('transaction_id' => $_REQUEST['id'], 'batch_id' => $batch_id, 'collection_id' => $collection_id, 'student_id' => $student_id, 'receipt_no' => $receipt_no, 'receipt_type' => $receipt_type), true)); $html2pdf->WriteHTML("<br/><br/><br/><br/><br/>"); $receipt_type = "office_copy"; $html2pdf->WriteHTML($this->renderPartial('partialreceipt', array('transaction_id' => $_REQUEST['id'], 'batch_id' => $batch_id, 'collection_id' => $collection_id, 'student_id' => $student_id, 'receipt_no' => $receipt_no, 'receipt_type' => $receipt_type), true)); $html2pdf->Output($student); //$this->render('printreceipt'); }
public function actionAjax_delete() { $id = $_POST['id']; $deleted = $this->loadModel($id); if ($deleted->delete()) { FinanceFees::model()->deleteAll('fee_collection_id=:x', array(':x' => $id)); FinanceTransaction::model()->deleteAll('collection_id=:x', array(':x' => $id)); echo json_encode(array('success' => true)); exit; } else { echo json_encode(array('success' => false)); exit; } }
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)); $transaction = FinanceTransaction::model()->DeleteAllByAttributes(array('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; }
.tableinnerlist th{ border-right:1px #b9c7d0 solid; border-bottom:1px #b9c7d0 solid; padding:4px 10px; font-size:10px; font-weight:bold; text-align:center; } </style> <?php $student = Students::model()->findByAttributes(array('id' => $student_id)); $collection = FinanceFeeCollections::model()->findByAttributes(array('id' => $collection_id)); $category = FinanceFeeCategories::model()->findByAttributes(array('id' => $collection->fee_category_id)); $list = FinanceTransaction::model()->findByAttributes(array('id' => $transaction_id)); $guard = Guardians::model()->findByAttributes(array('id' => $student->parent_id)); //$particulars = FinanceFeeParticulars::model()->findAll("finance_fee_category_id=:x", array(':x'=>$collection->fee_category_id)); $batch = Batches::model()->findByAttributes(array('id' => $batch_id)); $currency = Configurations::model()->findByPk(5); if ($currency->config_value == "₹") { $currency->config_value = '<img src="images/rupee_symbol.png" width="8">'; } ?> <table width="680" border="1" bgcolor="#f9feff"> <tr> <td> <div style="padding:10px 20px;"> <table width="650" border="0" cellspacing="0" cellpadding="0"> <tr>
public function actionDeletes() { $model = Students::model()->findByAttributes(array('id' => $_REQUEST['sid'])); $model->saveAttributes(array('is_deleted' => '1')); //Adding activity to feed via saveFeed($initiator_id,$activity_type,$goal_id,$goal_name,$field_name,$initial_field_value,$new_field_value) ActivityFeed::model()->saveFeed(Yii::app()->user->Id, '7', $model->id, ucfirst($model->first_name) . ' ' . ucfirst($model->middle_name) . ' ' . ucfirst($model->last_name), NULL, NULL, NULL); if ($model->uid and $model->uid != NULL and $model->uid != 0) { $user = User::model()->findByPk($model->uid); if ($user) { $profile = Profile::model()->findByPk($user->id); if ($profile) { $profile->delete(); } $user->delete(); } } $guardian = Guardians::model()->findByAttributes(array('ward_id' => $_REQUEST['sid'])); if ($guardian->uid and $guardian->uid != NULL and $guardian->uid != 0) { $parent_user = User::model()->findByPk($guardian->uid); if ($parent_user) { $profile = Profile::model()->findByPk($parent_user->id); if ($profile) { $profile->delete(); } $parent_user->delete(); } } $examscores = ExamScores::model()->DeleteAllByAttributes(array('student_id' => $_REQUEST['sid'])); $transactions = FinanceTransaction::model()->deleteAll('collection_id=:x', array(':x' => $_REQUEST['sid'])); $this->redirect(array('/courses/batches/batchstudents', 'id' => $_REQUEST['id'])); }