public function clicked() { try { $inputs = []; foreach (Input::all() as $key => $value) { $inputs[strtolower($key)] = Input::get($key); } $apicall_id = explode('@', $inputs['message-id'])[0]; if ($inputs['tag'] != 'Password Recovery') { $analytic = Analytic::whereRecipient($inputs['recipient'])->whereApicallId($apicall_id)->first(); $click = Click::whereEmailId($analytic->email_id)->whereSubscriberId($analytic->subscriber_id)->whereUrl($inputs['url'])->count(); if (!$click) { $click = new Click(); $click->email_id = $analytic->email_id; $click->subscriber_id = $analytic->subscriber_id; $click->url = $inputs['url']; $click->save(); if ($analytic->client_name == NULL) { $analytic->ip = $inputs['ip']; $analytic->country = $inputs['country']; $analytic->city = $inputs['city']; $analytic->client_name = $inputs['client-name']; $analytic->client_type = $inputs['client-type']; $analytic->client_os = $inputs['client-os']; $analytic->device_type = $inputs['device-type']; $analytic->reason = "disabled images"; $analytic->save(); } } } return Response::json(['success'], 200); } catch (Exception $e) { Log::error($e); return Response::json(['error'], 406); } }