1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / cando / application / models /
Filename : Event_model.php
back
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Event_model extends CI_Model
{
    public function insert_event($data)
    {
        $this->db->insert('tbl_event', $data);
        return $this->db->insert_id();
    }

    public function insert_floor_plans($data)
    {
        $this->db->insert_batch('tbl_floor_plan', $data);
    }

    public function list_event()
    {
        $query = $this->db->query("SELECT * FROM tbl_event WHERE status = 1");
        return $query->result();
    }

    public function get_event($id)
    {
        $query = $this->db->query("SELECT * FROM tbl_event WHERE id = '$id'");
        return $query->result();
    }

    public function get_event_name($id)
    {
        $query = $this->db->query("SELECT event_name,id FROM tbl_event WHERE id = '$id'");

        return $query->row();
    }

    public function get_floor($id)
    {
        $query = $this->db->query("SELECT * FROM tbl_floor_plan WHERE event_id = '$id'");
        return $query->result();
    }

    public function event_edit($id)
    {

        $sql = "select * from tbl_event where id = '$id'";
        $result = $this->db->query($sql);
        return $result->row();
    }

    public function delete_floor_plan($floor_id)
    {
        $floor_plan = $this->db->get_where('tbl_floor_plan', ['id' => $floor_id])->row();
        if ($floor_plan && !empty($floor_plan->floor_plan)) {
            $file_path = FCPATH . 'uploads/events/' . $floor_plan->floor_plan;
            if (file_exists($file_path)) {
                unlink($file_path);
            }
        }

        return $this->db->delete('tbl_floor_plan', ['id' => $floor_id]);
    }


    public function get_floor_plans($event_id)
    {
        $sql = "SELECT * FROM tbl_floor_plan WHERE event_id = '$event_id'";
        $result = $this->db->query($sql);
        return $result->result(); // Return multiple rows
    }

    public function get_floor_plan($floor_plan_id)
    {
        $sql = "SELECT * FROM tbl_floor_plan WHERE id = '$floor_plan_id'";
        $result = $this->db->query($sql);
        return $result->row(); // Return multiple rows
    }

    // public function insert_floor_plan_mappings($floor_plan_id, $floor_name, $floor_size, $startX, $startY, $endX, $endY)
    // {
    //     $sql = "insert into tbl_floor_plan_mappings(`floor_plan_id`,'floor_name','floor_size',`start_x`,`start_y`,`end_x`,`end_y`) values($floor_plan_id, $startX, $startY, $endX, $endY)";
    //     $this->db->query($sql);
    // }
    public function insert_floor_plan_mappings($floor_plan_id, $floor_name, $floor_size, $startX, $startY, $endX, $endY)
    {
        $data = array(
            'floor_plan_id' => $floor_plan_id,
            'floor_name' => $floor_name,
            'floor_size' => $floor_size,
            'start_x' => $startX,
            'start_y' => $startY,
            'end_x' => $endX,
            'end_y' => $endY
        );

        $this->db->insert('tbl_floor_plan_mappings', $data);
    }


    public function get_floor_plan_mappings($floor_plan_id)
    {
        $sql = "SELECT * FROM tbl_floor_plan_mappings WHERE floor_plan_id = '$floor_plan_id'";
        $result = $this->db->query($sql);
        return $result->result();
    }

    public function get_floor_plan_mappings_list()
    {
        $sql = "SELECT tbl_floor_plan_mappings.*, tbl_exhibitors.employee_name, tbl_exhibitors.email, 
            tbl_exhibitors.phone_number FROM  tbl_floor_plan_mappings LEFT JOIN 
            tbl_exhibitors ON  tbl_floor_plan_mappings.exhibitors_id = tbl_exhibitors.id  
            WHERE tbl_floor_plan_mappings.exhibitors_id IS NOT NULL";

        $result = $this->db->query($sql);

        return $result->result();
    }

    public function delete_floor_plan_mappings($floor_plan_id)
    {
        $sql = "DELETE FROM tbl_floor_plan_mappings WHERE floor_plan_id = '$floor_plan_id'";
        $this->db->query($sql);
    }


    public function update_exhibiter_on_map($areaOnMap, $exhibiterSelected)
    {
        $sql = "update tbl_floor_plan_mappings set exhibitors_id = '$exhibiterSelected' where id = '$areaOnMap'";
        $this->db->query($sql);
    }


    public function update_event($event_id, $data)
    {
        if (!empty($data['event_img'])) {
            $this->db->where('id', $event_id);
            return $this->db->update('tbl_event', ['event_img' => $data['event_img']]);
        } else {
            $this->db->where('id', $event_id);
            return $this->db->update('tbl_event', $data);
        }
    }

    public function update_floor_plan($floor_ids, $data)
    {
        $this->db->where('id', $floor_ids);
        return $this->db->update('tbl_floor_plan', $data);
    }

    public function delete_event($id)
    {
        $this->db->query("UPDATE  tbl_event SET status = 0 Where id='$id'");
    }


    public function get_event_dates($id)
    {
        $this->db->select('event_startdatetime,event_enddatetime');
        $this->db->from('tbl_event');

        if (!empty($id)) {
            $this->db->where_in('id', $id);
        }

        $query = $this->db->get();
        return $query->result();
    }

    public function getExhibitorsByFloorPlan($floor_plan_id)
    {
        $this->db->select('*', 'e.company_name');
        $this->db->from('tbl_floor_plan_mappings fpm');
        $this->db->join('tbl_exhibitors e', 'fpm.exhibitors_id = e.id', 'left');
        $this->db->where('fpm.floor_plan_id', $floor_plan_id);
        $this->db->where('fpm.exhibitors_id IS NOT NULL');
        $query = $this->db->get();
        return $query->result();
    }

    public function get_event_id_by_name($event_name)
    {
        $this->db->select('id');
        $this->db->from('tbl_event');
        $this->db->where('event_name', $event_name);
        $query = $this->db->get();
        $result = $query->row();

        return $result ? $result->id : null;
    }

    public function get_exhibitors_by_event_id($event_id)
    {
        $this->db->select('tbl_event.event_name, tbl_floor_plan_mappings.floor_name, tbl_floor_plan_mappings.floor_size, 
                       tbl_floor_plan_mappings.exhibitors_id, tbl_exhibitors.employee_name, 
                       tbl_exhibitors.email, tbl_exhibitors.phone_number');
        $this->db->from('tbl_event');
        $this->db->join('tbl_floor_plan', 'tbl_event.id = tbl_floor_plan.event_id', 'left');
        $this->db->join('tbl_floor_plan_mappings', 'tbl_floor_plan.id = tbl_floor_plan_mappings.floor_plan_id', 'left');
        $this->db->join('tbl_exhibitors', 'tbl_floor_plan_mappings.exhibitors_id = tbl_exhibitors.id', 'left');
        $this->db->where('tbl_event.id', $event_id);
        $this->db->where('tbl_floor_plan_mappings.exhibitors_id IS NOT NULL');
        $query = $this->db->get();
        return $query->result();
    }
}