/** * Execute the console command. * * @return mixed */ public function handle() { $notification_queue = Lead::where('notify', '=', 1)->get(); foreach ($notification_queue as $lead) { if ($lead) { if (!empty($lead->form->integration) && !empty($lead->form->integration_id)) { $integration = new $lead->form->integration->class($lead->id, json_decode($lead->form->integration_options, true)); } } if (!empty($lead->form->notification_emails) && !empty($lead->form->notification_subject)) { $emails = explode(',', $lead->form->notification_emails); if (is_array($emails)) { // Internal e-mail notification try { Mail::send('ZLeader::lead.email-internal-notification', ['lead' => $lead], function ($message) use($emails, $lead) { $message->from(config('ZLeader.notification_sender_email_address'), $lead->form->area->company->name); $message->subject($lead->form->notification_subject); $reply_email = trim($lead->getValueByKey('email')); $message->replyTo($reply_email); foreach ($emails as $email) { if (!empty(trim($email))) { $message->to(trim($email)); } } }); } catch (\Exception $e) { Log::error($e->getMessage()); } } } try { // User e-mail notification $email = trim($lead->getValueByKey('email')); if (!empty($email) && !empty($lead->form->user_notification_subject)) { Mail::send('ZLeader::lead.email-user-notification', ['lead' => $lead], function ($message) use($email, $lead) { $message->from(config('ZLeader.notification_sender_email_address'), $lead->form->area->company->name); $message->subject($lead->form->user_notification_subject); $message->to($email); }); } } catch (\Exception $e) { Log::error($e->getMessage()); } $lead->notify = 0; $lead->save(); } }
public function store(Request $request) { $access_token = env('FACEBOOK_LEADGEN_ACCESS_TOKEN', 'token'); Log::info('New Webhook:'); if (is_array($request->entry)) { foreach ($request->entry[0]['changes'] as $change_data) { if ($change_data['field'] == 'leadgen') { $leadgen = $change_data['value']; $lead_exists = Lead::where('fb_leadgen_id', '=', $leadgen['leadgen_id'])->count(); if ($lead_exists == 0) { Log::info('New Lead!'); try { $response = Facebook::get('/' . $leadgen['leadgen_id'], $access_token); $lead_data = $response->getDecodedBody(); //Log::info('Lead values:'); //Log::info($lead_data); $leadgen['lead_values'] = $lead_data['field_data']; } catch (Exception $e) { Log::error($e->getMessage()); } try { $response = Facebook::get('/' . $leadgen['form_id'], $access_token); $form_data = $response->getDecodedBody(); //Log::info('Form data:'); //Log::info($form_data); $leadgen['form_name'] = $form_data['name']; } catch (Exception $e) { Log::error($e->getMessage()); } if (!empty($leadgen['ad_id'])) { try { $response = Facebook::get('/' . $leadgen['ad_id'] . '?fields=name,adset_id', $access_token); $ad_data = $response->getDecodedBody(); //Log::info('Ad data:'); //Log::info($ad_data); $leadgen['ad_name'] = $ad_data['name']; } catch (Exception $e) { Log::error($e->getMessage()); } try { $response = Facebook::get('/' . $ad_data['adset_id'] . '?fields=name', $access_token); $adset_data = $response->getDecodedBody(); //Log::info('Ad data:'); //Log::info($ad_data); $leadgen['adset_name'] = $adset_data['name']; } catch (Exception $e) { Log::error($e->getMessage()); } } Log::info($leadgen); $form_name_exploded = explode(' ', $leadgen['form_name']); $form_integration_prefix = array_shift($form_name_exploded); $form = Form::where('fb_integration_prefix', 'like', $form_integration_prefix)->first(); Log::info($form); if ($form) { $lead = new Lead(); $lead->form_id = $form->id; $lead->fb_leadgen_id = $leadgen['leadgen_id']; $lead->utm_source = 'facebook'; $lead->utm_medium = 'cpc'; $lead->utm_content = 'leadgen'; if (!empty($leadgen['ad_name'])) { $lead->utm_term = $leadgen['ad_name']; } if ($request->utm_content) { $lead->utm_content = $leadgen['adset_name']; } $lead->save(); foreach ($leadgen['lead_values'] as $field) { if ($field['name'] == 'email') { $validator = Validator::make(['email' => $field['values'][0]], ['email' => 'email']); if (!$validator->fails()) { $leadValue = new LeadValue(); $leadValue->lead_id = $lead->id; $leadValue->key = $field['name']; $leadValue->value = $field['values'][0]; $leadValue->save(); } } else { $leadValue = new LeadValue(); $leadValue->lead_id = $lead->id; $leadValue->key = $field['name']; $leadValue->value = $field['values'][0]; $leadValue->save(); } } $form_name_fields = explode(',', implode(' ', $form_name_exploded)); if (is_array($form_name_fields)) { foreach ($form_name_fields as $fields) { $field_data = explode('=', $fields); if (isset($field_data[0]) && isset($field_data[1])) { $data_key = trim($field_data[0]); $aux = explode(' ', $field_data[1]); $data_value = trim(array_shift($aux)); if (!empty($data_key) && !empty($data_value)) { $leadValue = new LeadValue(); $leadValue->lead_id = $lead->id; $leadValue->key = $data_key; $leadValue->value = $data_value; $leadValue->save(); } } } } Log::info('Lead saved'); } else { Log::warning('Form "' . $form_integration_prefix . '" not found!'); switch ($leadgen['form_name']) { default: Log::warning('Unknown form, reporting...'); $company_name = 'Leadgen'; $emails = 'andres@zephia.com.ar,cristian@zephia.com.ar'; } Log::info('Sending "' . $leadgen['form_name'] . '" to ' . $emails); $emails = explode(',', $emails); Mail::send('ZLeader::lead.email-webhook-failed', ['lead' => $leadgen], function ($message) use($emails, $company_name) { $message->from(config('ZLeader.notification_sender_email_address'), $company_name); $message->subject('Nueva consulta de Facebook leadgen'); //$message->replyTo($address); foreach ($emails as $email) { $message->to($email); } }); abort(404); } } else { Log::warning('Lead exists!'); } } } } return $request->hub_challenge; }