Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
public function topsales(){ $users = DB::table('results') ->select(DB::raw('count(*) as sales_count, salescode')) ->where('salescode', '<>', 1) ->groupBy('salescode') ->orderBy('sales_count', 'desc') ->take(10) ->get();
if (true) {
return response()->json([
'sales top 3' => $users,
]);
}
}
i have two tables. results and user. from the results table, there are sales sales results,and i want to sort the most sales result tables and retrieve sales user data that sells them, but i can only get salescode. how can all the sales data appear
You need to add column in the ->select().
public function topsales(){
$users = DB::table('results')
->select(DB::raw('count(*) as sales_count, salescode')) // You need to add column here that you want to retrive
->where('salescode', '<>', 1)
->groupBy('salescode')
->orderBy('sales_count', 'desc')
->take(10)
->get();
if ($users->count() > 0) {
return response()->json([
'sales top 3' => $users,
]);
}
}
yes, i understand. how i get user data? like email,salescode,nik,superior,status
$close = DB::table('users')->where('result_type','=','closing')->join('results', 'users.id', '=','results.user_id') ->select(DB::raw('count(*) as sales_count, results.salescode')) ->groupBy('salescode') ->orderBy('results.salescode','ASC') ->take(3) ->get();
but the results is the same
@tisuchi { "status": 200, "data": [ { "sales_count": 4, "salescode": "A001" }, { "sales_count": 2, "salescode": "A002" }, { "sales_count": 1, "salescode": "A003" } ] }
this is the result. i mean, in salescode show with user data
@rully you have to join with the users table if you have user_id in the results table. Otherwise, you have to make a relationship.
Please check the doc https://laravel.com/docs/6.x/queries#joins for join and https://laravel.com/docs/6.x/eloquent-relationships#eager-loading for loading relational data.
@sujancse oke thxx,bro
Please or to participate in this conversation.