Subversion Repositories SmartDukaan

Rev

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

Rev 19854 Rev 19863
Line 216... Line 216...
216
		}
216
		}
217
		$agentActivations = $this->User->query($otherSql);
217
		$agentActivations = $this->User->query($otherSql);
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
	
-
 
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 ";
-
 
224
		$res = $this->Callhistory->query($cquery);
-
 
225
		$this->set(compact('res'));
-
 
226
	}
221
}
227
}