how to use flatten() in eloquent query ?

Have you checked this example in documentation?

$collection = collect([
    'Apple' => [
        ['name' => 'iPhone 6S', 'brand' => 'Apple'],
    ],
    'Samsung' => [
        ['name' => 'Galaxy S7', 'brand' => 'Samsung']
    ],
]);

$products = $collection->flatten(1);

$products->values()->all();

/*
    [
        ['name' => 'iPhone 6S', 'brand' => 'Apple'],
        ['name' => 'Galaxy S7', 'brand' => 'Samsung'],
    ]
*/

https://laravel.com/docs/5.5/collections#method-flatten

it give me a error "Call to undefined method Illuminate\Database\Query\Builder::flatten()"

And my code is

$query = self::select("bill_approval.*", \DB::raw("CONCAT('".env('AWS_PATH')."', bill_approval.bill_image) as bill_image")) ->with(['user:user_id,sso_username', 'category']) ->where('bill_approval.vendor_id', $vendor_id) ->where('bill_approval.vendor_approval', '0') ->where('bill_approval.is_paynow_feature', '!=', '3'); $query = $query->flatten();

You need to query the database, then flatten the results. You are trying to use flatten on the query builder.

$query = self::select("bill_approval.*", \DB::raw("CONCAT('".env('AWS_PATH')."', bill_approval.bill_image) as bill_image"))
    ->with(['user:user_id,sso_username', 'category'])
    ->where('bill_approval.vendor_id', $vendor_id)
    ->where('bill_approval.vendor_approval', '0')
    ->where('bill_approval.is_paynow_feature', '!=', '3');

 $query = $query->get()->flatten(1);   // or however many levels you need

and DONT use .env properties directly. Get them from config.

i tried but till response is like this.

[ { "col-1": val1 "cal-2": val2, "key1": { "col-1": val1 "cal-2": val2, }, "key2": { "col-1": val,1 "cal-2": val2, }, }, ]

Have you tired this?

$query = $query->get()->flatten(2);  // depth parameter

change the depth parameter based on your preferrences. In your case you are trying to flatten child array so 2.

@RamjithAp yes. i tried 1 to 5 but it gives same response as above.

How do you expect to represent nested data sets?

@Snapey i want dataset without nested.

@Snapey There is a bug with flatten(1), it's getting values from 2 level deep as default, instead of one level.

where to report the bug?

@gileneusz

https://github.com/laravel/framework/issues