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; }