menu/app/Models/Menu.php

<?php

namespace App\Models;

use App\Models\Record;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class Menu extends Model
{
    protected $table   = 'menu';
    public $timestamps = false;
    public static function formatStr($value = [])
    {
        foreach ($value as &$v) {
            $v = explode(',', $v);
            $v = ['name' => $v[0], 'weightOrNum' => $v[1]];
        }
        unset($v);
        return $value;
    }
    public static function formatListId($value = [])
    {
        foreach ($value as &$v) {
            $v = $v->menu_id;
        }
        unset($v);
        return $value;
    }
    // public static function selectMenuList($tagId,$time,$status=1){
    //     $menuListNum=config('view.menuListNum');
    //     $menuIdList=DB::table('tag_menu')->select('menu_id')->where('id',$tagId)->get()->toArray();
    //     if(empty($menuIdList)){
    //         return false;
    //     }
    //     $menuIdList=explode(',',$menuIdList[0]->menu_id);
    //     $menuIdList=array_slice($menuIdList,$time*$menuListNum,$menuListNum);
    //     if(empty($menuIdList)){
    //         return [];
    //     }
    //     DB::table('album')->select('id','menu_id','url')->whereIn('id',$menuIdList)->get()->toArray();
    //     $menuDataList=DB::table('menu')->select('id','title','ingredients','url')->whereIn('id',$menuIdList)->get()->toArray();
    //     foreach($menuDataList as $v){
    //         $v->collections=10;
    //         $v->views=10;
    //     }
    //     return $menuDataList;
    // }
    public static function selectCollectionMenu($menuIdList, $time, $status = 1)
    {
        $menuIdList   = self::formatListId($menuIdList);
        $menuDataList = DB::table('menu')->leftJoin('record', 'menu.id', '=', 'record.menu_id')->select('id', 'title', 'ingredients', 'url', 'collections', 'views')->whereIn('id', $menuIdList)->get()->toArray();
        return $menuDataList;
    }
    public static function selectMenu($menuId, $status = 1)
    {
        $menu = DB::table('menu')->where(['id' => $menuId, 'status' => $status])->first();
        if (empty($menu)) {
            return false;
        }
        $menuStep          = DB::table('menu_step')->select('step', 'url')->where(['menu_id' => $menuId, 'status' => $status])->get()->toArray();
        $menu->step        = $menuStep;
        $menu->ingredients = explode(';', $menu->ingredients);
        $menu->burden      = explode(';', $menu->burden);
        $menu->ingredients = self::formatStr($menu->ingredients);
        $menu->burden      = self::formatStr($menu->burden);
        return $menu;

    }
    public static function selectRecommend($type = 0, $time = 0)
    {
        if ($type == 1) {
            $offset      = 0;
            $menuListNum = 5;
        } else {
            $menuListNum = config('view.menuListNum');
            $offset      = $time * $menuListNum;
        }
        $menuId = DB::select('select menu_id from recommend where type=' . $type . ' and status=1  limit ' . $offset . ',' . $menuListNum);
        foreach ($menuId as &$v) {
            $v = $v->menu_id;
        }
        unset($v);
        if (!empty($menuId)) {
            $menuDataList = DB::table('menu')->select('id', 'title', 'url')->whereIn('id', $menuId)->get()->toArray();
        }
        if (!isset($menuDataList)) {
            return [];
        }
        if ($type == 1) {return $menuDataList;}
        $record = Record::selectListRecord($menuId);
        foreach ($menuDataList as $v) {
            $init=abs(ceil(crc32($v->id)/1000000));
            if (isset($record['collection'][$v->id])) {
                $v->collections = $record['collection'][$v->id]+floor($init/50);
            } else {
                $v->collections = floor($init/50);
            }
            if (isset($record['view'][$v->id])) {
                $v->views = $record['view'][$v->id]+$init;
            } else {
                $v->views = $init;
            }
        }
        return $menuDataList;
    }
}