1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / hrm.addobyte.com / application / models /
Filename : Web_model.php20180126
back
<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Web_model extends CI_Model
{
	
	
   	public function get_week_timesheet_by_member($mid,$start,$end){		
		$query = $this->db->query("SELECT date, inTime, outTime FROM in_out where uid = $mid and date BETWEEN '$start' and '$end'");		
		return $query->result();
	}
	
   	public function get_inout_by_date($date){		
		$query = $this->db->query("select i.inTime,i.outTime,u.first_name,u.last_name from in_out i, users u where i.date = '$date' and u.uid = i.uid");
		return $query->result();
	}
	
  
    public function get_timesheets_by_date($uid,$date){
		
		$query = $this->db->query("SELECT t.*, p.name FROM timesheets t, projects p where t.uid = $uid and t.status = 0 and t.pid = p.pid and t.date = '$date'");		
		return $query->result();
		
	}
	
    public function get_all_pending_tasks(){
		
		$query = $this->db->query("SELECT t.*,u.first_name,u.last_name, (select CONCAT(first_name,' ',last_name) from users where uid = t.createdBy) as assignedBy FROM tasks t, users u where t.uid = u.uid and t.status = 0 and u.status = 0");		
		return $query->result();
		
	}
	
    public function get_all_completed_tasks(){
		
		$query = $this->db->query("SELECT t.*,u.first_name,u.last_name, (select CONCAT(first_name,' ',last_name) from users where uid = t.createdBy) as assignedBy FROM tasks t, users u where t.uid = u.uid and t.status = 1 and u.status = 0");		
		return $query->result();
		
	}
	
    public function get_all_my_assigned_tasks($uid,$status){
		
		$query = $this->db->query("SELECT t.*,u.first_name,u.last_name FROM tasks t, users u where t.uid = u.uid and t.status = $status and u.status = 0 and t.createdBy = $uid");		
		return $query->result();
		
	}
	
    public function get_all_my_pending_tasks($uid){
		
		$query = $this->db->query("SELECT t.*,u.first_name,u.last_name FROM tasks t, users u where t.createdBy = u.uid and t.status = 0 and u.status = 0 and t.uid = $uid");		
		return $query->result();
		
	}
	
    public function get_all_my_completed_tasks($uid){
		
		$query = $this->db->query("SELECT t.*,u.first_name,u.last_name FROM tasks t, users u where t.createdBy = u.uid and t.status = 1 and u.status = 0 and t.uid = $uid");		
		return $query->result();
		
	}
	
	public function get_projects_by_user($uid){
		
		$query = $this->db->query("SELECT p.* FROM project_members pm, projects p where p.pid = pm.pid and pm.uid = $uid and p.status = 0 order by p.name asc");		
		return $query->result();
		
	}
	
	public function get_timesheets_based_on_project($pid,$start,$end){
		$query = $this->db->query("select u.first_name,u.last_name,t.date, t.duration_hour,t.duration_minute,t.task from timesheets t, users u where t.pid = $pid and t.date between '$start' and '$end' and u.uid = t.uid and t.status = 0");		
		return $query->result();
		
	}
	public function get_timesheets_based_on_employee($uid,$start,$end){
		$query = $this->db->query("SELECT p.name, t.task, t.date, t.duration_hour, t.duration_minute FROM projects p, timesheets t where t.date BETWEEN '$start' and '$end' and t.pid = p.pid and t.status = 0 and t.uid = $uid");		
		return $query->result();
		
	}
	public function get_workhours_based_on_project($pid,$start,$end){
		$query = $this->db->query("SELECT date, sum(duration_hour) as hour, sum(duration_minute) mins FROM timesheets where pid = $pid and status = 0 and date BETWEEN '$start' and '$end' group by date");		
		return $query->result();
		
	}
	
	
	public function get_client_projects($client_id){
		$query = $this->db->query("SELECT * FROM clients_projects cp, projects p where p.pid = cp.project_id and cp.client_id = $client_id");		
		return $query->result();
		
	}
}