jucai/app/Http/Controllers/Mobile/Ic/IndexController.php

<?php

namespace App\Http\Controllers\Mobile\Ic;

use App\Http\Controllers\Mobile\MobileBaseController;
use App\Models\Article;
use App\Models\Jobs;
use App\Services\Company\JobsService;
use Illuminate\Support\Facades\DB;

class IndexController extends MobileBaseController
{
    protected $jobsService;

    /**
     * JobsController constructor.
     * @param $categoryService
     */
    public function __construct(JobsService $jobsService)
    {
        $this->jobsService = $jobsService;
    }

    public function index()
    {
        //引才动态
        $attract_list = Article::where('type_id', 67)
            ->where('is_display', 1)
            ->orderBy('list_order', 'desc')
            ->orderBy('id', 'desc')
            ->limit(5)
            ->get();

        //招聘列表
        $size = 10;

        $sql = "select id from jobs where is_ic = 1 and valid = 1 and audit = 1 and display = 1 and deleted_at is null ORDER BY updated_at desc";
        $list = DB::table($sql . 'as job')->groupBy('company_id')->limit(5)->get();
//        $list = Jobs::whereIn('id', DB::raw("select id from jobs where is_ic = 1 and valid = 1 and audit = 1 and display = 1 ORDER BY updated_at desc"))->groupBy('company_id')->limit(5)->get();
        if ($list->isEmpty()) {
            $recruit_list = [];
        } else {
            $recruit_list = $this->jobsService->dealjobFilelds($list);
        }

        return view('mobile.app.ic.index', [
            'attract_list' => $attract_list,
            'recruit_list' => $recruit_list,
        ]);
    }

    public function jinjiang()
    {
        return view('mobile.app.ic.jinjiang');
    }

    public function policy()
    {
        return view('mobile.app.ic.policy');
    }
}