protected function sendCancelOrderMail($order_id = NULL) { if ($order_id) { $order_info = array(); $order_data = Order::select('order_number', 'customer_id')->where('id', '=', $order_id)->first(); if ($order_data->order_number) { $order_info['order_number'] = $order_data->order_number; $order_info['customer_record'] = Customer::select('full_name', 'email', DB::raw('CONCAT(country_code,phone) AS phone'))->where('id', '=', $order_data->customer_id)->first(); Mail::send('emails.cancel_order', array('name' => $order_info['customer_record']['full_name'], 'order_number' => $order_info['order_number']), function ($message) use($order_info) { $message->from('*****@*****.**', 'Foodjets'); $message->to($order_info['customer_record']['email'], $order_info['customer_record']['full_name'])->subject('Cancel Order'); }); } } }