Subversion Repositories SmartDukaan

Rev

Rev 19863 | Rev 20051 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 19863 Rev 19864
Line 218... Line 218...
218 
		$this->set('agentActivations',$agentActivations);
 218 
		$this->set('agentActivations',$agentActivations);
219 
		$this->set(compact('activations','date_to','date_from'));
 219 
		$this->set(compact('activations','date_to','date_from'));
220 
	}
 220 
	}
221
221
222 
	public function admin_callhistory(){
 222 
	public function admin_callhistory(){
223 
		$cquery = "select a.name ,count(c.id) as total from agents a join callhistory c on c.agent_id = a.id where c.call_time > CURDATE() group by c.agent_id ";
 223 
		$cquery = "select a.name ,count(c.id) as total from agents a join callhistory c on c.agent_id = a.id where c.call_time > CURDATE() and c.agent_id> 2 group by c.agent_id ";
224 
		$res = $this->Callhistory->query($cquery);
 224 
		$res = $this->Callhistory->query($cquery);
225 
		$this->set(compact('res'));
 225 
		$this->set(compact('res'));
226 
	}
 226 
	}
227 
}
 227 
}