<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Carousel_banner_m extends CI_Model
{

    private $table = 'carousel_banners';

    public function get_active_carousel()
    {
        $this->db->where('is_active', 1);
        $this->db->order_by('order_number', 'ASC');
        return $this->db->get($this->table)->result();
    }

    public function create_carousel_item($data)
    {
        return $this->db->insert($this->table, $data);
    }

    public function update_carousel_item($id, $data)
    {
        $this->db->where('carousel_banner_id', $id);
        return $this->db->update($this->table, $data);
    }

    public function delete_carousel_item($id)
    {
        $this->db->where('carousel_banner_id', $id);
        return $this->db->delete($this->table);
    }

    public function save_impression($data)
    {
        return $this->db->insert('carousel_banner_impressions', $data);
    }

    public function get_impression_count($banner_id = null, $start_date = null, $end_date = null)
    {
        if ($banner_id) {
            $this->db->where('banner_id', $banner_id);
        }

        if ($start_date && $end_date) {
            $this->db->where('timestamp >=', $start_date);
            $this->db->where('timestamp <=', $end_date);
        }

        return $this->db->count_all_results('banner_impressions');
    }

    public function get_unique_impression_count($banner_id = null)
    {
        $this->db->select('COUNT(DISTINCT session_id) as count');

        if ($banner_id) {
            $this->db->where('banner_id', $banner_id);
        }

        $result = $this->db->get('banner_impressions')->row();
        return $result->count;
    }
}