Level 34
@mehrdad70 is your product is the Course?
Feb 20, 2021
7
Level 2
The best-selling products in Laravel
Hello friends I want to show the best selling products How can I implement this?
order model
class Order extends Model
{
public function courses()
{
return $this->belongsToMany(Course::class, 'order_course', 'order_id', 'course_id');
}
public function payments()
{
return $this->hasMany(Payment::class);
}
}
course model
class Course extends Model
{
public function students()
{
return $this->belongsToMany(User::class , 'course_user' , 'course_id' , 'user_id');
}
public function orders()
{
return $this->belongsToMany(Order::class);
}
public function addStudentToCourses($courses , $userId)
{
foreach($courses as $course) {
if(! $this->getCourseUser($course , $userId)){
$course->students()->attach($userId);
}
}
}
public function getCourseUser(Course $course , $userId)
{
return $course->students()->where('id' , $userId)->first();
}
}
order table
public function up()
{
Schema::create('orders', function (Blueprint $table) {
$table->id();
$table->foreignId('user_id')->constrained('users')->cascadeOnDelete();
$table->string('code')->nullable()->unique();
$table->bigInteger('price');
$table->enum('status' , ['fail' ,'success' , 'pending' , 'canseled']);
$table->timestamps();
});
Schema::create('order_course', function (Blueprint $table) {
$table->foreignId('order_id')->constrained('orders')->cascadeOnDelete();
$table->foreignId('course_id')->constrained('courses')->cascadeOnDelete();
});
}
Level 2
yes Training courses
Level 34
In your Course model:
public function sortByBestSelling()
{
return $this->sortBy(function($course) {
return $course->orders->count();
});
}
so in your code:
Course::sortByBestSelling->get();
Level 34
something like this but you might need to get orders() first so you can count it inside the closure.
Level 2
This solution did not solve the problem):
Level 2
Can anyone give me a good solution?
Please or to participate in this conversation.