zhuishuyun_quickapp/app/Modules/Channel/Services/ChannelRecommendBooksService.php

<?php


namespace App\Modules\Channel\Services;


use App\Modules\Channel\Models\ChannelRecommendBooks;

class ChannelRecommendBooksService
{

    static function getRecommendBooks($channel_id,$bid,$priority,$limit = 3,$data = [])
    {
        if(!isset($channel_id)) return [];
        $query = ChannelRecommendBooks::leftjoin('book_configs','book_configs.bid','channel_recommend_books.bid')
            ->leftjoin('books','books.id','channel_recommend_books.bid')
            ->select('books.intro','books.category_name','book_configs.book_name','book_configs.cover','book_configs.bid','channel_recommend_books.priority')
            ->orderBy('channel_recommend_books.priority','DESC')->orderBy('channel_recommend_books.created_at','DESC');

        $query->where('channel_recommend_books.channel_id',$channel_id);

        if(!empty($priority) && $priority != 0){
            $query->where('channel_recommend_books.priority','<=',$priority)->where('channel_recommend_books.bid','!=',$bid);
        }

        $list = $query->limit($limit)->get()->toArray();
        $lists = array_merge($list,$data);
        if(count($lists) < 3){
            $count = 3 - count($lists);
            self::getRecommendBooks($channel_id,$bid,0,$count,$lists);
        }else{
            return $lists;
        }
    }

    static function incrRecommendNum($channel_id,$bids)
    {
        return ChannelRecommendBooks::where('channel_id',$channel_id)->whereIn('bid',$bids)->increment('recommend_num');
    }
}