laravel api resource collection with row query

Question

$two = DB::select("SELECT
                ul.id ,
                ul.name controller_name, 
                ul.user_id controller_user_id,
                ul.location contoller_location, 
                u.name user_name,
                models.active model_alive_status,
                models.serial_number model_sirial_number,
                su.payment_status subscriptions_status,
                su.to_date subscriptions_expire
    FROM `user_controllers` as ul
    LEFT JOIN users as u ON ul.user_id = u.id
    INNER JOIN models on models.userController_id = ul.id
    LEFT join subscriptions as su on su.user_id = ul.user_id");

return UserControllerInfo::collection($two);

this gives me an error like

"message": "Call to undefined method stdClass::toArray()",

$one = DB::table('user_controllers')
        ->leftJoin('users', 'user_controllers.user_id', '=', 'users.id')
        ->leftJoin('models', 'models.userController_id', '=', 'user_controllers.id')
        ->leftJoin('subscriptions', 'subscriptions.user_id', '=', 'user_controllers.user_id')
        ->select('user_controllers.*','models.*')
        ->get();

this also same error

Does this answer your question? How to use a resource collection toArray and DB (without Eloquent) — Sehdev
– Sehdev, Commented Mar 1, 2020 at 11:47

TsaiKoga · Accepted Answer · 2020-03-01 11:45:52Z

2

Query builder will return the collection with stdClass, try to change Query Builder to Eloquent Builder:

$one = UserController::leftJoin('users', 'user_controllers.user_id', '=', 'users.id')
                     ->leftJoin('models', 'models.userController_id', '=', 'user_controllers.id')
                     ->leftJoin('subscriptions', 'subscriptions.user_id', '=', 'user_controllers.user_id')
                     ->select('user_controllers.*','models.*')
                     ->get();

Check my anwser here.

edited Mar 1, 2020 at 11:45

answered Mar 1, 2020 at 11:38

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

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

2 Comments

MH Fuad Over a year ago

thanks, TsaiKoga. is it possible return stdClass with row query ?

TsaiKoga Over a year ago

@MHFuad I think you can rewrite the` collection` or toarray method, but not recommend it.

Collectives™ on Stack Overflow

laravel api resource collection with row query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related