xingyou/app/Http/Home/HelpController.php

<?php

namespace App\Http\Home;


use App\Services\Eav\MaterialService;
use App\Services\Elastic\Facades\ES;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Request;
use Illuminate\Support\Facades\Schema;

class HelpController extends HttpBaseController
{
    public function __construct()
    {
        parent::__construct();
    }

    public function index()
    {
        $data = [];
        $categoryList = $this->getNewsCategory();
        foreach ($categoryList as $row) {
            $categoryId = $row->id;
            $productId = $row->product_id;
            unset($row->id);

            $productInfo = DB::table('product')->select(['id', 'title', 'logo'])->where('id', $productId)->first();

            $data[] = [
                'product' => $productInfo,
                'category' => $row,
                'news' => $this->getNewsList($categoryId)
            ];
        }
        return view('home/http/help', ['data' => $data]);
    }

    public function capture()
    {
        $data = [];
        $categoryList = $this->getNewsCategory();
        foreach ($categoryList as $row) {
            $categoryId = $row->id;
            $productId = $row->product_id;
            unset($row->id);

            $productInfo = DB::table('product')->select(['id', 'title', 'logo'])->where('id', $productId)->first();

            $data[] = [
                'product' => $productInfo,
                'category' => $row,
                'news' => $this->getNewsList($categoryId)
            ];
        }
        return view('home/http/help2', ['data' => $data]);
    }

    public function category($cid = '')
    {
        $size = 15;
        $page = Request::input('page', 1);
        $page = $page <= 1 ? 1 : ($page > 20 ? 20 : $page);

        if (empty($cid)) {
            abort(404);
        }

        // 获取所有的资讯分类
        $category = DB::table('news_category')->get();

        $categoryInfo = DB::table('news_category')->select('id')->where('mid', $cid)->first();
        if (empty($categoryInfo)) {
            abort(404);
        }

        // 获取资讯列表
        $find = DB::table('news')
            ->where('category_id', $categoryInfo->id)
            ->offset($size * ($page - 1))
            ->orderBy('created_at', 'desc')
            ->limit($size);
        $list = $find->get();
        $total = DB::table('news')->where('category_id', $categoryInfo->id)->count();

        return view('home/http/newslist', ['category' => $category, 'list' => $list, 'total' => $total]);
    }

    public function detail($mid = '')
    {
        if (empty($mid)) {
            abort(404);
        }

        // 获取所有的资讯分类
        $category = DB::table('news_category')->get();

        $info = DB::table('news')->where('mid', $mid)->first();
        return view('home/http/newsdetail', ['info' => $info, 'category' => $category]);
    }


    private function getNewsCategory()
    {
        return DB::table('news_category')->select(['id', 'mid', 'name', 'product_id'])->get();
    }

    private function getNewsList($categoryId)
    {
        return DB::table('news')->where('category_id', $categoryId)->offset(0)->limit(6)->get();
    }

    private function getNews()
    {
        $size = 15;
        $page = Request::input('page', 1);
        $cid = Request::input('cid');

        // 获取资讯分类
        $category = DB::table('news_category')->get();

        // 获取资讯列表
        $find = DB::table('news')
            ->offset($size * ($page - 1))
            ->limit($size);

        if ($cid) {
            $info = DB::table('news_category')->select('id')->where('mid', $cid)->first();
            if ($info) {
                $find->where('category_id', $info->id);
            }
        }

        $list = $find->get();

        return view('home/http/newslist', ['category' => $category, 'list' => $list]);
    }
}