<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Studentfee extends Student_Controller {

    function __construct() {
        parent::__construct();
        $this->load->library('smsgateway');
    }

    function index() {
        $this->session->set_userdata('top_menu', 'Bill Collection');
        $this->session->set_userdata('sub_menu', 'studentfee/index');
        $data['title'] = 'Learner Bill';
        $class = $this->class_model->get();
        $data['classlist'] = $class;
        $this->load->view('layout/student/header', $data);
        $this->load->view('studentfee/studentfeeSearch', $data);
        $this->load->view('layout/student/footer', $data);
    }

    function pdf() {
        $this->load->helper('pdf_helper');
    }

    function search() {
        $data['title'] = 'Learner Search';
        $class = $this->class_model->get();
        $data['classlist'] = $class;
        if ($this->input->server('REQUEST_METHOD') == "GET") {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentfeeSearch', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $class = $this->input->post('class_id');
            $section = $this->input->post('section_id');
            $search = $this->input->post('search');
            $search_text = $this->input->post('search_text');
            if (isset($search)) {
                if ($search == 'search_filter') {
                    $resultlist = $this->student_model->searchByClassSection($class, $section);
                    $data['resultlist'] = $resultlist;
                } else if ($search == 'search_full') {
                    $resultlist = $this->student_model->searchFullText($search_text);
                    $data['resultlist'] = $resultlist;
                }
            }
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentfeeSearch', $data);
            $this->load->view('layout/footer', $data);
        }
    }

    function feesearch() {
        $this->session->set_userdata('top_menu', 'Bill Collection');
        $this->session->set_userdata('sub_menu', 'studentfee/feesearch');
        $data['title'] = 'Learner Bill';
        $class = $this->class_model->get();
        $data['classlist'] = $class;
        $feecategory = $this->feecategory_model->get();
        $data['feecategorylist'] = $feecategory;
        $this->form_validation->set_rules('feecategory_id', 'Fee Category', 'trim|required|xss_clean');
        if ($this->form_validation->run() == FALSE) {
            $this->load->view('layout/student/header', $data);
            $this->load->view('user/studentfee/studentSearchFee', $data);
            $this->load->view('layout/student/footer', $data);
        } else {
            $data['student_due_fee'] = array();
            $feecategory_id = $this->input->post('feecategory_id');
            $feetype_id = $this->input->post('feetype_id');
            $class_id = $this->input->post('class_id');
            $section_id = $this->input->post('section_id');
            $student_due_fee = $this->studentfee_model->getDueStudentFees($feetype_id, $class_id, $section_id);
            $data['student_due_fee'] = $student_due_fee;
            $this->load->view('layout/student/header', $data);
            $this->load->view('user/studentfee/studentSearchFee', $data);
            $this->load->view('layout/student/footer', $data);
        }
    }

    function reportbyname() {
        $this->session->set_userdata('top_menu', 'Bill Collection');
        $this->session->set_userdata('sub_menu', 'studentfee/reportbyname');
        $data['title'] = 'Learner Bill';
        $data['title'] = 'Learner Bill';
        $class = $this->class_model->get();
        $data['classlist'] = $class;
        if ($this->input->server('REQUEST_METHOD') == "GET") {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/reportByName', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $this->form_validation->set_rules('section_id', 'Section', 'trim|required|xss_clean');
            $this->form_validation->set_rules('class_id', 'Class', 'trim|required|xss_clean');
            $this->form_validation->set_rules('student_id', 'Student', 'trim|required|xss_clean');
            if ($this->form_validation->run() == FALSE) {
                $this->load->view('layout/header', $data);
                $this->load->view('studentfee/reportByName', $data);
                $this->load->view('layout/footer', $data);
            } else {
                $data['student_due_fee'] = array();
                $class_id = $this->input->post('class_id');
                $section_id = $this->input->post('section_id');
                $student_id = $this->input->post('student_id');
                $student_due_fee = $this->studentfee_model->getDueFeeBystudent($class_id, $section_id, $student_id);
                $data['student'] = $this->student_model->getRecentRecord($student_id);
                $data['student_due_fee'] = $student_due_fee;
                $data['class_id'] = $class_id;
                $data['section_id'] = $section_id;
                $data['student_id'] = $student_id;
                $this->load->view('layout/header', $data);
                $this->load->view('studentfee/reportByName', $data);
                $this->load->view('layout/footer', $data);
            }
        }
    }

    function reportbyclass() {
        $data['title'] = 'Learner Bill';
        $data['title'] = 'Learner Bill';
        $class = $this->class_model->get();
        $data['classlist'] = $class;
        if ($this->input->server('REQUEST_METHOD') == "GET") {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/reportByClass', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $student_fees_array = array();
            $class_id = $this->input->post('class_id');
            $section_id = $this->input->post('section_id');
            $student_result = $this->student_model->searchByClassSection($class_id, $section_id);
            $data['student_due_fee'] = array();
            if (!empty($student_result)) {
                foreach ($student_result as $key => $student) {
                    $student_array = array();
                    $student_array['student_detail'] = $student;
                    $student_session_id = $student['student_session_id'];
                    $student_id = $student['id'];
                    $student_due_fee = $this->studentfee_model->getDueFeeBystudentSection($class_id, $section_id, $student_session_id);
                    $student_array['fee_detail'] = $student_due_fee;
                    $student_fees_array[$student['id']] = $student_array;
                }
            }
            $data['class_id'] = $class_id;
            $data['section_id'] = $section_id;
            $data['student_fees_array'] = $student_fees_array;
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/reportByClass', $data);
            $this->load->view('layout/footer', $data);
        }
    }

    function view($id) {
        $data['title'] = 'Learner Bill List';
        $studentfee = $this->studentfee_model->get($id);
        $data['studentfee'] = $studentfee;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/studentfeeShow', $data);
        $this->load->view('layout/footer', $data);
    }

    function deleteFee() {
        $id = $this->input->post('feeid');
        $this->studentfee_model->remove($id);
        $array = array('status' => 'success', 'result' => 'success');
        echo json_encode($array);
    }

    function addfee($id) {
        $data['title'] = 'Learner Detail';
        $student = $this->student_model->get($id);
        $data['student'] = $student;
        $student_due_fee = $this->studentfee_model->getDueFeeBystudent($student['class_id'], $student['section_id'], $id);
        $data['student_due_fee'] = $student_due_fee;
        $transport_fee = $this->studenttransportfee_model->getTransportFeeByStudent($student['student_session_id']);
        $data['transport_fee'] = $transport_fee;
        $this->load->view('layout/header', $data);
        $this->load->view('studentfee/studentAddfee', $data);
        $this->load->view('layout/footer', $data);
    }

    function deleteTransportFee() {
        $id = $this->input->post('feeid');
        $this->studenttransportfee_model->remove($id);
        $array = array('status' => 'success', 'result' => 'success');
        echo json_encode($array);
    }

    function delete($id) {
        $data['title'] = 'studentfee List';
        $this->studentfee_model->remove($id);
        redirect('studentfee/index');
    }

    function create() {
        $data['title'] = 'Add Learner Bill';
        $this->form_validation->set_rules('category', 'Category', 'trim|required|xss_clean');
        if ($this->form_validation->run() == FALSE) {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentfeeCreate', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $data = array(
                'category' => $this->input->post('category'),
            );
            $this->studentfee_model->add($data);
            $this->session->set_flashdata('msg', '<div studentfee="alert alert-success text-center">Employee details added to Database!!!</div>');
            redirect('studentfee/index');
        }
    }

    function edit($id) {
        $data['title'] = 'Edit studentfee';
        $data['id'] = $id;
        $studentfee = $this->studentfee_model->get($id);
        $data['studentfee'] = $studentfee;
        $this->form_validation->set_rules('category', 'category', 'trim|required|xss_clean');
        if ($this->form_validation->run() == FALSE) {
            $this->load->view('layout/header', $data);
            $this->load->view('studentfee/studentfeeEdit', $data);
            $this->load->view('layout/footer', $data);
        } else {
            $data = array(
                'id' => $id,
                'category' => $this->input->post('category'),
            );
            $this->studentfee_model->add($data);
            $this->session->set_flashdata('msg', '<div studentfee="alert alert-success text-center">Employee details added to Database!!!</div>');
            redirect('studentfee/index');
        }
    }

    function add_Ajaxfee() {
        $this->form_validation->set_rules('fee_master_id', 'Fee Master', 'required|trim|xss_clean');
        $this->form_validation->set_rules('student_session_id', 'Student', 'required|trim|xss_clean');
        $this->form_validation->set_rules('amount', 'Amount', 'required|trim|xss_clean');
        $this->form_validation->set_rules('amount_discount', 'Discount', 'required|trim|xss_clean');
        $this->form_validation->set_rules('amount_fine', 'Fine', 'required|trim|xss_clean');
        if ($this->form_validation->run() == false) {
            $data = array(
                'amount' => form_error('amount'),
                'fee_master_id' => form_error('fee_master_id'),
                'student_session_id' => form_error('student_session_id'),
                'amount_discount' => form_error('amount_discount'),
                'amount_fine' => form_error('amount_fine')
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            $data = array(
                'amount' => $this->input->post('amount'),
                'date' => date('Y-m-d', $this->customlib->datetostrtotime($this->input->post('date'))),
                'student_session_id' => $this->input->post('student_session_id'),
                'amount_discount' => $this->input->post('amount_discount'),
                'amount_fine' => $this->input->post('amount_fine'),
                'description' => $this->input->post('description'),
                'feemaster_id' => $this->input->post('fee_master_id'),
            );
            $inserted_id = $this->studentfee_model->add($data);
            $result = $this->smsgateway->StudentAddFeesMSG($inserted_id);
            $array = array('status' => 'success', 'error' => '');
            echo json_encode($array);
        }
    }

    function add_AjaxTransportfee() {
        $this->form_validation->set_rules('student_session_id', 'Student', 'required|trim|xss_clean');
        $this->form_validation->set_rules('amount', 'Amount', 'required|trim|xss_clean');
        $this->form_validation->set_rules('amount_fine', 'Fine', 'required|trim|xss_clean');
        if ($this->form_validation->run() == false) {
            $data = array(
                'transport_amount' => form_error('amount'),
                'transport_student_session_id' => form_error('student_session_id'),
                'transport_amount_discount' => form_error('amount_discount'),
                'transport_amount_fine' => form_error('amount_fine')
            );
            $array = array('status' => 'fail', 'error' => $data);
            echo json_encode($array);
        } else {
            $data = array(
                'amount' => $this->input->post('amount'),
                'date' => date('Y-m-d', $this->customlib->datetostrtotime($this->input->post('date'))),
                'student_session_id' => $this->input->post('student_session_id'),
                'amount_discount' => "",
                'amount_fine' => $this->input->post('amount_fine'),
                'description' => $this->input->post('description'),
            );
            $inserted_id = $this->studenttransportfee_model->add($data);
            $array = array('status' => 'success', 'error' => '');
            echo json_encode($array);
        }
    }

    function printFeesByName() {
        $data = array('payment' => "0");
        $data['receipt_no'] = $this->admin_model->addReceipt($data);
        $record = $this->input->post('data');
        $student_session_id = $this->input->post('student_session_id');
        $setting_result = $this->setting_model->get();
        $data['settinglist'] = $setting_result;
        $student = $this->studentsession_model->searchStudentsBySession($student_session_id);
        $data['student'] = $student;
        $record_array = json_decode($record);
        $trans_array = array();
        $fees_array = array();
        foreach ($record_array as $key => $value) {
            $category = $value->category;
            $row_id = $value->row_id;
            if ($category == "fees") {
                $fees_array[] = "'" . $row_id . "'";
            } else if ($category == "transport") {
                $trans_array[] = "'" . $row_id . "'";
            }
        }
        $monthly_record_array = array();
        $transport_record_array = array();
        if (!empty($fees_array)) {
            $ids = implode(',', $fees_array);
            $monthly_record_array = $this->studentfee_model->getStudentFeesArray($ids, $student_session_id);
        }
        if (!empty($trans_array)) {
            $ids = implode(',', $trans_array);
            $transport_record_array = $this->studenttransportfee_model->getTransportFeeByIDs($ids);
        }
        $data['monthly_record'] = $monthly_record_array;
        $data['transport_record'] = $transport_record_array;
        $this->load->view('print/printFeesByName', $data);
    }

    function searchpayment() {
        $this->session->set_userdata('top_menu', 'Fees Collection');
        $this->session->set_userdata('sub_menu', 'studentfee/searchpayment');
        $data['title'] = 'Search With Payment ID';
        if ($this->input->server('REQUEST_METHOD') == "POST") {
            $search = $this->input->post('search');
            if ($search == "search_filter") {
                $data['exp_title'] = 'Transaction';
                $paymentid = $this->input->post('paymentid');
                $expenseList = $this->studenttransportfee_model->getfeeByID($paymentid);
                $feeList = $this->studentfee_model->getFeeByInvoice($paymentid);
                $data['expenseList'] = $expenseList;
                $data['feeList'] = $feeList;
            }
            $this->load->view('layout/student/header', $data);
            $this->load->view('user/studentfee/searchpayment', $data);
            $this->load->view('layout/student/footer', $data);
        } else {
            $this->load->view('layout/student/header', $data);
            $this->load->view('user/studentfee/searchpayment', $data);
            $this->load->view('layout/student/footer', $data);
        }
    }

}

?>