1#@!#!123s

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

class Nirvakam_model extends CI_Model
{
    
    public function get_filtered_attendance($filters)
    {
        $this->db->select('*');
        $this->db->from('tbl_attendence');

        if (!empty($filters['project_id'])) {
            $this->db->where('project_id', $filters['project_id']);
        }
        if (!empty($filters['employee_id'])) {
            $this->db->where('employee_id', $filters['employee_id']);
        }

        if (!empty($filters['start_date']) && !empty($filters['end_date'])) {
            $start_date = $filters['start_date'] . ' 00:00:00';
            $end_date = $filters['end_date'] . ' 23:59:59';

            if ($filters['start_date'] == $filters['end_date']) {
                $this->db->where('created_at >=', $start_date);
                $this->db->where('created_at <=', $end_date);
            } else {
                $this->db->where('created_at >=', $start_date);
                $this->db->where('created_at <=', $end_date);
            }
        } elseif (!empty($filters['start_date'])) {
            $this->db->where('created_at >=', $filters['start_date'] . ' 00:00:00');
        } elseif (!empty($filters['end_date'])) {
            $this->db->where('created_at <=', $filters['end_date'] . ' 23:59:59');
        }

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