Problem with Object of class stdClass could not be converted to string

Question

I've got error on this line $number = "$autonumber[0]/$automonth/$autoyear/proforma";. This is error: https://flareapp.io/share/qm1WG17d I am trying to make function witch will be adding number of proform in month to other data. I don't know what i am doing wrong. Anybody help me?

This is controller with this function witch generates error:

public function store(Request $request)
{
    $autoyear = date('Y');
    $automonth = date('m');

    $autonumber = DB::table('proforms')
        ->select(DB::raw('MAX(autonumber) as autonumber'))
        ->where('automonth', '=', '$automonth')
        ->where('autoyear', '=', '$autoyear')
        ->get();
    $autonumber[0]++;
    $number = "$autonumber[0]/$automonth/$autoyear/proforma";
    DB::table('proforms')->insert(
        ['autonumber' => $number, 'automonth' => $automonth, 'autoyear' => $autoyear]
    );

    request()->validate([
        'user_id' => 'required',
        'proformdate' => 'required',
        'selldate' => 'required',
        'paymentmethod' => 'required',
        'paymentdate' => 'required',
        'status' => 'nullable',
        'city' => 'nullable',
        'comments' => 'nullable',
        'name' => 'required',
        'PKWIU' => 'nullable',
        'quantity' => 'required',
        'unit' => 'required',
        'netunit' => 'required',
        'nettotal' => 'required',
        'VATrate' => 'required',
        'grossunit' => 'required',
        'grosstotal' => 'required',

    ]);

    Proform::create($request->all());

    return redirect()->route('proforms.index')
        ->with('success', 'Proform created successfully.');
}

After dd($autonumber); I get:

Illuminate\Support\Collection {#1328 ▼
  #items: array:1 [▼
    0 => {#1324 ▼
      +"autonumber": null
    }
  ]
}

After print_r($autonumber);

  Illuminate\Support\Collection Object ( [items:protected] => Array ( [0] => stdClass Object ( [autonumber] => ) ) )

Illuminate\Support\Collection Object ( [items:protected] => Array ( [0] => stdClass Object ( [autonumber] => ) ) ) — Piotrek
– Piotrek, Commented Aug 10, 2020 at 9:15
either you use ->value('autonumber') or still use ->get() and reach the inner dimension $autonumber[0]->autonumber — Kevin
– Kevin, Commented Aug 10, 2020 at 9:19
Please share the error message in your question, along with your debugging attempts — Nico Haase
– Nico Haase, Commented Aug 10, 2020 at 11:23

mrhn · Accepted Answer · 2020-08-10 22:07:57Z

1

There is a misunderstanding, the following code will not return an integer, but an object which has the following structure: {"autonumber": 42}.

$autonumber = DB::table('proforms')
    ->select(DB::raw('MAX(autonumber) as autonumber'))
    ->where('automonth', '=', '$automonth')
    ->where('autoyear', '=', '$autoyear')
    ->get();

Change the code to work with that structure.

$autonumber[0]->autonumber++;
$number = $autonumber[0]->autonumber;
$number = "$number/$automonth/$autoyear/proforma";

answered Aug 10, 2020 at 22:07

mrhn

19.1k6 gold badges31 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem with Object of class stdClass could not be converted to string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related