1#@!#!123s

: / home / schoolcampuserp / internationaldpssuri.com / application / controllers / admin /
Filename : Stdtransfer.php
back
<?php

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

class Stdtransfer extends Admin_Controller
{

    public function __construct()
    {
        parent::__construct();
        $this->load->model("classteacher_model");
//        $this->load->model("studentfeemaster_model");
        $this->current_session = $this->setting_model->getCurrentSession();
        $this->sch_setting_detail = $this->setting_model->getSetting();
    }

    public function index()
    {
        if (!$this->rbac->hasPrivilege('promote_student', 'can_view')) {
            access_denied();
        }
        $this->session->set_userdata('top_menu', 'Academics');
        $this->session->set_userdata('sub_menu', 'stdtransfer/index');
        $data['title']           = 'Exam Schedule';
        $class                   = $this->class_model->get('', $classteacher = 'yes');
        $data['classlist']       = $class;
        $userdata                = $this->customlib->getUserData();
        $data['sch_setting']     = $this->sch_setting_detail;
        $feecategory             = $this->feecategory_model->get();
        $data['feecategorylist'] = $feecategory;
        $session_result          = $this->session_model->get();
        $data['sessionlist']     = $session_result;
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('class_promote_id', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section_promote_id', $this->lang->line('session'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('session_id', $this->lang->line('session'), 'trim|required|xss_clean');
        if ($this->form_validation->run() == true) {
            $class                         = $this->input->post('class_id');
            $section                       = $this->input->post('section_id');
            $session                       = $this->input->post('session_id');
            $class_promote                 = $this->input->post('class_promote_id');
            $section_promote               = $this->input->post('section_promote_id');
            $data['class_post']            = $class;
            $data['section_post']          = $section;
            $data['class_promoted_post']   = $class_promote;
            $data['section_promoted_post'] = $section_promote;
            $data['session_promoted_post'] = $session;

            $resultlist = $this->student_model->searchNonPromotedStudents($class, $section, $session, $class_promote, $section_promote);

            $data['resultlist'] = $resultlist;

        }

        $this->load->view('layout/header', $data);
        $this->load->view('admin/stdtransfer/stdtransfer', $data);
        $this->load->view('layout/footer', $data);
    }

    public function promote()
    {
        
        
        $this->form_validation->set_rules('session_id', $this->lang->line('session'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('class_promote_id', $this->lang->line('class'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('section_promote_id', $this->lang->line('section'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('student_list[]', $this->lang->line('student'), 'required|trim|xss_clean');
        if ($this->form_validation->run() == false) {
            $errors = array(
                'session_id'         => form_error('session_id'),
                'class_promote_id'   => form_error('class_promote_id'),
                'section_promote_id' => form_error('section_promote_id'),
                'student_list'       => form_error('student_list[]'),
            );
            echo json_encode(array('status' => 'fail', 'msg' => $errors));
        } else {
            $new_session_id =  $this->input->post('session_id');
            //exit();
            $student_list = $this->input->post('student_list');

            if (!empty($student_list) && isset($student_list)) {
 //$student_data = array();
                foreach ($student_list as $key => $value) {
                    // print_r($value);
                    // exit();
                    $student_id     = $value;
                    $result         = $this->input->post('result_' . $value);
                    $student_session_id         = $this->input->post('student_session_id_' . $value);
                    $session_status = $this->input->post('next_working_' . $value);
                    
                  

                    if ($result == "pass" && $session_status == "countinue") {
                        $promoted_class   = $this->input->post('class_promote_id');
                        $promoted_section = $this->input->post('section_promote_id');
                        $promoted_session = $this->input->post('session_id');
                        $data_new         = array(
                            'student_id'     => $student_id,
                            'class_id'       => $promoted_class,
                            'section_id'     => $promoted_section,
                            'session_id'     => $promoted_session,
                            'transport_fees' => 0,
                            'fees_discount'  => 0,
                        );
                        
                        $new_student_session_id = $this->student_model->add_student_session($data_new);
                        
                    } elseif ($result == "fail" && $session_status == "countinue") {
                        $promoted_session = $this->input->post('session_id');
                        $class_post       = $this->input->post('class_post');
                        $section_post     = $this->input->post('section_post');
                        $data_new         = array(
                            'student_id'     => $student_id,
                            'class_id'       => $class_post,
                            'section_id'     => $section_post,
                            'session_id'     => $promoted_session,
                            'transport_fees' => 0,
                            'fees_discount'  => 0,
                        );
                        $this->student_model->add_student_session($data_new);
                        
                    } elseif ($session_status == "leave") {

                        $alumni_data = array(
                            'student_id' => $student_id,
                            'is_alumni'  => 1,
                        );
                        $this->student_model->alumni_student_status($alumni_data);
                    }
                    
                    if($new_session_id != $this->current_session){
                    
                        // *** Handle Transport Route Promotion ***
                        $transport_data = $this->db
                        ->select('student_transport_route_master.*, transport_route.*')
                        ->from('student_transport_route_master')
                        ->join('transport_route', 'student_transport_route_master.route_id = transport_route.id', 'left')
                        ->where('student_transport_route_master.student_session_id', $student_session_id)
                        ->where('student_transport_route_master.transport_route_deleted_at IS NULL') 
                        ->get()
                        ->row_array();

        
                        if (!empty($transport_data)) {
                            $existing_route = $this->db->where('old_id', $transport_data['route_id']) // Check with old_id
                                ->where('session_id', $new_session_id)
                                ->get('transport_route')
                                ->row_array();
            
                            if (!$existing_route) {
                                $new_route = array(
                                    'route_title' => $transport_data['route_title'],
                                    'fare'           => $transport_data['fare'],
                                    'session_id'      => $new_session_id,
                                    'is_active'     =>'no',
                                    'old_id'          => $transport_data['route_id'] // Store the previous route_id
                                );
                                $this->db->insert('transport_route', $new_route);
                                $new_route_id = $this->db->insert_id();
                            } else {
                                $new_route_id = $existing_route['id'];
                            }
                            
                            //Fetch driver_id based on the old route_id
                            $vehicle_route = $this->db
                                ->select('driver_id')
                                ->where('route_id', $transport_data['route_id'])
                                ->get('vehicle_routes')
                                ->row_array();
                            
                            $driver_id = !empty($vehicle_route) ? $vehicle_route['driver_id'] : null;
                            
                            // Check if a new entry with new_route_id and new_session_id already exists
                            $existing_vehicle_route = $this->db
                                ->where('route_id', $new_route_id)
                                ->where('session_id', $new_session_id)
                                ->get('vehicle_routes')
                                ->row_array();
                            
                            if (!$existing_vehicle_route) {
                                // Prepare data for insertion
                                $new_vehicle_routes = array(
                                    'route_id'   => $new_route_id,
                                    'vehicle_id' => $transport_data['vehroute_id'], // Assuming this is the correct vehicle ID
                                    'driver_id'  => $driver_id, // Assigning the fetched driver_id
                                    'session_id' => $new_session_id,
                                    'created_at' => date('Y-m-d H:i:s')
                                );
                            
                                // Insert the new record
                                $this->db->insert('vehicle_routes', $new_vehicle_routes);
                            }
    
                            
                            
            
                            // Insert new student transport mapping
                            $new_transport_data = array(
                                'route_id'           => $new_route_id,
                                'vehroute_id'        => $transport_data['vehroute_id'],
                                'student_session_id' => $new_student_session_id,
                                'transport_route_created_at' => date('Y-m-d H:i:s'),
                                'session_id'         => $new_session_id
                            );
                            $this->db->insert('student_transport_route_master', $new_transport_data);
                            
                            
                        }
                        
                    }
                    
                    
                }
                // $promoted_session = $this->input->post('session_id');
                // $due_date = date('Y-m-d', $this->customlib->datetostrtotime(date('Y-m-d')));
                // $student_due_fee = $this->studentfeemaster_model->addPreviousBal($student_data, $due_date,$promoted_session);
            }
            echo json_encode(array('status' => 'success', 'msg' => ""));
        }
    }

}