public function mapmessage($id)
{
$today = date("Y-m-d H:i:s");
$fiveday = date("Y-m-d H:i:s", strtotime('-5 days'));
$tenday = date("Y-m-d H:i:s", strtotime('-10 days'));
$fifday = date("Y-m-d H:i:s", strtotime('-15 days'));
$twentyday = date("Y-m-d H:i:s", strtotime('-20 days'));
$tfiveday = date("Y-m-d H:i:s", strtotime('-25 days'));
$thurtyday = date("Y-m-d H:i:s", strtotime('-30 days'));
$thurtyfiveday = date("Y-m-d H:i:s", strtotime('-35 days'));
//$jsonVariable;
$q = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $fiveday)->where('date', '<=', $today)->count();
$w = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $tenday)->where('date', '<=', $fiveday)->count();
$e = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $fifday)->where('date', '<=', $tenday)->count();
$r = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $twentyday)->where('date', '<=', $fifday)->count();
$t = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $tfiveday)->where('date', '<=', $twentyday)->count();
$y = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $thurtyday)->where('date', '<=', $tfiveday)->count();
$u = messages::where('agent_id', '=', $id)->where('type', '=', '1')->where('date', '>=', $thurtyfiveday)->where('date', '<=', $thurtyday)->count();
$today = $q;
$fiveday = $w;
$tenday = $e;
$fifday = $r;
$twentyday = $t;
$tfiveday = $y;
$thurtyfiveday = $u;
$mapmessage = '[1, ' . $today . '], [2, ' . $fiveday . '], [3, ' . $tenday . '], [4, ' . $fifday . '], [5, ' . $twentyday . '], [6, ' . $tfiveday . '], [7, ' . $thurtyfiveday . ']';
$jsonVariable['mapmessage'] = $mapmessage;
return Response::json($jsonVariable);
}
public function selectmessages()
{
$agent_id = Input::get('data.agent_id');
$type = Input::get('data.type');
$messages = messages::where('agent_id', '=', $agent_id)->where('type', '=', $type)->orderby('msg_id', 'Desc')->get();
return $messages;
}
