📄 File: Dashboard_model.php

Path: /home2/outerorb/hr.outerorbittech.com/application/models/Dashboard_model.php

Size: 1.37 KB

Permissions: 0644

<?php

	class Dashboard_model extends CI_Model{


	function __consturct(){
	parent::__construct();
	
	}
    public function insert_tododata($data){
        $this->db->insert('to-do_list',$data);
    }
    public function GettodoInfo($userid){
        $sql = "SELECT * FROM `to-do_list` WHERE `user_id`='$userid' ORDER BY `date` DESC";
        $query=$this->db->query($sql);
        $result = $query->result();
        return $result;
    }
    public function GetRunningProject(){
        $sql = "SELECT * FROM `project` WHERE `pro_status`='running' ORDER BY `id` DESC";
        $query=$this->db->query($sql);
        $result = $query->result();
        return $result;
    }
    public function GetPendingLeave(){
        $sql = "SELECT * FROM `employee` LEFT JOIN `emp_leave` USING (`em_id`) WHERE `leave_status`='Pending' ORDER BY `apply_date` DESC";
        // $sql = "SELECT * FROM `emp_leave` WHERE `leave_status`='pending' ORDER BY `id` DESC";
        $query=$this->db->query($sql);
        $result = $query->result();
        return $result;
    }
    public function GetHolidayInfo(){
        $sql = "SELECT * FROM `holiday` ORDER BY `id` DESC LIMIT 10";
        $query=$this->db->query($sql);
        $result = $query->result();
        return $result;
    }
	public function UpdateTododata($id,$data){
		$this->db->where('id', $id);
		$this->db->update('to-do_list',$data);		
	}        
    }
?>

← Back to Directory Edit File 🔒 Chmod