Issues with sending an email with a pdf attachment

Level 50

Hey, then the problem must be on the way you are calling the successPayment function. Looks like you are calling it multiple times, but just calling it correctly the first time. Can you show us the code you are using to call it?

Level 5

@MANELGAVALDA - I've updated my question. Please let me know if it's ok

munazzil

Level 13

You have to use as like below remove the first() and add get() because that will give only first data not a collection otherwise you can't use loop and foreach function,

  foreach($orders as $order)
      {
        $exists = Order::find($order->id)->where('user_id', $user_id)->latest()->get();
     //other codes
      }

Level 5

@MUNAZZIL - if I do that then I get this error

Method Illuminate\Database\Eloquent\Collection::save does not exist.

Level 48

You only do a query if the order exists, not a check.

$exists = Order::find($order->id)->where('user_id', $user_id)->latest()->first();
$exists->status = 'success';

$exists->save();

$invoice_number = Session::get('invoice_number');

$order_number = Order::where('invoice_number', $invoice_number)->get();

$user_name = $order->user->name;
....
....

Change to

$exists = Order::find($order->id)->where('user_id', $user_id)->latest()->first();
if ($exists) {
$exists->status = 'success';

$exists->save();

$invoice_number = Session::get('invoice_number');

$order_number = Order::where('invoice_number', $invoice_number)->get();

$user_name = $order->user->name;
....
....
}
else {
    // order does not exist, do something else
}

Level 5

@MVD - I still get the same error as before

Level 48

@shiva can you give us the output from $order->user in the foreach loop?

var_dump($order->user);

Level 5

@MVD - This is what I get

E:\Shiva\Wamp\www\shop\app\Http\Controllers\PublicController.php:497:
object(App\User)[422]
  protected 'fillable' => 
    array (size=16)
      0 => string 'user_type' (length=9)
      1 => string 'salutation' (length=10)
      2 => string 'name' (length=4)
      3 => string 'surname' (length=7)
      4 => string 'email' (length=5)
      5 => string 'password' (length=8)
      6 => string 'phone_number' (length=12)
      7 => string 'telephone_2' (length=11)
      8 => string 'trading_name' (length=12)
      9 => string 'company_name' (length=12)
      10 => string 'vat_number' (length=10)
      11 => string 'ck_number' (length=9)
      12 => string 'office_number' (length=13)
      13 => string 'work_email' (length=10)
      14 => string 'office_address' (length=14)
      15 => string 'contact_person' (length=14)
  protected 'hidden' => 
    array (size=2)
      0 => string 'password' (length=8)
      1 => string 'remember_token' (length=14)
  protected 'connection' => string 'mysql' (length=5)
  protected 'table' => string 'users' (length=5)
  protected 'primaryKey' => string 'id' (length=2)
  protected 'keyType' => string 'int' (length=3)
  public 'incrementing' => boolean true
  protected 'with' => 
    array (size=0)
      empty
  protected 'withCount' => 
    array (size=0)
      empty
  protected 'perPage' => int 15
  public 'exists' => boolean true
  public 'wasRecentlyCreated' => boolean false
  protected 'attributes' => 
    array (size=21)
      'id' => int 11
      'user_type' => string 'customer' (length=8)
      'salutation' => string 'Please select...' (length=16)
      'name' => string 'Test' (length=4)
      'surname' => string 'Testing' (length=7)
      'email' => string '[email protected]' (length=13)
      'email_verified_at' => null
      'password' => string 'y$JqgBrvkAjHspkDpf4HAn3.EHqxbg39RLXLltqk50N12/FqxrJ2bD6' (length=60)
      'phone_number' => null
      'telephone_2' => null
      'trading_name' => null
      'company_name' => null
      'vat_number' => null
      'ck_number' => null
      'office_number' => null
      'work_email' => null
      'office_address' => null
      'contact_person' => null
      'remember_token' => null
      'created_at' => string '2019-04-12 07:28:46' (length=19)
      'updated_at' => string '2019-04-24 05:26:09' (length=19)
  protected 'original' => 
    array (size=21)
      'id' => int 11
      'user_type' => string 'customer' (length=8)
      'salutation' => string 'Please select...' (length=16)
      'name' => string 'Test' (length=4)
      'surname' => string 'Testing' (length=7)
      'email' => string '[email protected]' (length=13)
      'email_verified_at' => null
      'password' => string 'y$JqgBrvkAjHspkDpf4HAn3.EHqxbg39RLXLltqk50N12/FqxrJ2bD6' (length=60)
      'phone_number' => null
      'telephone_2' => null
      'trading_name' => null
      'company_name' => null
      'vat_number' => null
      'ck_number' => null
      'office_number' => null
      'work_email' => null
      'office_address' => null
      'contact_person' => null
      'remember_token' => null
      'created_at' => string '2019-04-12 07:28:46' (length=19)
      'updated_at' => string '2019-04-24 05:26:09' (length=19)
  protected 'changes' => 
    array (size=0)
      empty
  protected 'casts' => 
    array (size=0)
      empty
  protected 'dates' => 
    array (size=0)
      empty
  protected 'dateFormat' => null
  protected 'appends' => 
    array (size=0)
      empty
  protected 'dispatchesEvents' => 
    array (size=0)
      empty
  protected 'observables' => 
    array (size=0)
      empty
  protected 'relations' => 
    array (size=0)
      empty
  protected 'touches' => 
    array (size=0)
      empty
  public 'timestamps' => boolean true
  protected 'visible' => 
    array (size=0)
      empty
  protected 'guarded' => 
    array (size=1)
      0 => string '*' (length=1)
  protected 'rememberTokenName' => string 'remember_token' (length=14)

Level 48

@shiva thanks! And

 var_dump($order->user->name);

in the foreach loop?

Level 5

@MVD - I get

E:\Shiva\Wamp\www\shop\app\Http\Controllers\PublicController.php:497:string 'Test' (length=4)

Test is the name

Level 48

@shiva

Thanks, so the problem is not in ?

It refers to this line

$user_name = $order->user->name;

Level 5

@MVD - Then where is the issue? Because I get that error. It's what is confusing me so much