| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 | <?phpnamespace 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;        $list = Jobs::whereRaw('id in (select max(id) from jobs where is_ic = 1 and valid = 1 and audit = 1 and display = 1 GROUP BY 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');    }}
 |