jucai/app/Admin/Controllers/Content/QuanzhidaController.php

<?php

namespace App\Admin\Controllers\Content;

use App\Admin\Extensions\Form\ValidateForm;
use App\Http\Controllers\Controller;
use App\Models\Category;
use App\Models\Quanzhida;
use App\Models\TalentHouse;
use App\Models\TalentHouseApply;
use Encore\Admin\Controllers\HasResourceActions;
use Encore\Admin\Form;
use Encore\Admin\Grid;
use Encore\Admin\Layout\Content;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class QuanzhidaController extends Controller
{
    use HasResourceActions;

    /**
     * Index interface.
     *
     * @param Content $content
     * @return Content
     */
    public function index(Content $content)
    {
        return $content
            ->header('泉职大')
            ->description(' ')
            ->body(view('admin.content.quanzhida')->with(['grid' => $this->grid()]));
    }

    /**
     * Edit interface.
     *
     * @param mixed $id
     * @param Content $content
     * @return Content
     */
    public function edit($id, Content $content)
    {
        return $content
            ->header('岗位')
            ->description(' ')
            ->body($this->editForm($id)->edit($id));
    }

    /**
     * Create interface.
     *
     * @param Content $content
     * @return Content
     */
    public function create(Content $content)
    {
        return $content
            ->header('岗位')
            ->description(' ')
            ->body($this->form());
    }


    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid()
    {
        $grid = new Grid(new Quanzhida());

        $grid->model()->orderBy('updated_at', 'DESC');

        $grid->id('ID');
        $grid->company_name('公司名称');
        $grid->job_name('岗位名称');
        $grid->industry('行业领域');
        $grid->created_at('创建时间');

        //新增按钮
        $grid->disableCreateButton(false);

        //批量删除
        $grid->tools(function ($tools) {
            $tools->batch(function ($batch) {
                $batch->disableDelete(false);
            });
        });

        $grid->actions(function ($actions) {
            $actions->disableEdit(false);
            $actions->disableDelete(false);
        });

        $grid->filter(function ($filter) {
            $filter->disableIdFilter();
            $filter->like('company_name', '公司名称');
            $filter->like('job_name', '岗位名称');
        });
        return $grid;
    }

    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function form()
    {
        $form = new ValidateForm(new Quanzhida());
        $form->text('company_name', '公司名称')->rules('required|max:100', ['required' => '公司名称不能为空。', 'max' => '公司名称不能大于100。'])->setWidth(4)->setMustMark();
        $form->text('job_name', '岗位名称')->rules('required|max:60', ['required' => '岗位名称不能为空。', 'max' => '岗位名称不能大于60。'])->setWidth(4)->setMustMark();
        $form->number('wage_min', '最小薪资')->rules('required', ['required' => '最小薪资不能为空。若未确定，请填0'])->setWidth(4)->setMustMark();
        $form->number('wage_max', '最大薪资')->rules('required', ['required' => '最大薪资不能为空。若未确定，请填0'])->setWidth(4)->setMustMark();
        $form->text('industry', '所属行业领域')->rules('required|max:60', ['required' => '所属行业领域不能为空。', 'max' => '所属行业领域不能大于60。'])->setWidth(4)->setMustMark();
        $education = Category::where('alias','AIX_education')->pluck('demand','id');
        $education[0] = '不限';
        $form->select('education', '学历')->setWidth(4)->options($education)->setMustMark();
        $experience = Category::where('alias','AIX_experience')->pluck('demand','id');
        $experience[0] = '不限';
        $form->select('experience', '工作经验')->setWidth(4)->options($experience)->setMustMark();
        $form->text('region', '工作地点')->rules('required|max:60', ['required' => '工作地点不能为空。', 'max' => '工作地点不能大于60。'])->setWidth(4)->setMustMark();

        $form->footer(function ($footer) {
            $footer->disableViewCheck();
            $footer->disableEditingCheck();
            $footer->disableCreatingCheck();
            $footer->disableReset();
        });
        return $form;
    }

    protected function editForm($id)
    {
        $form = new ValidateForm(new Quanzhida());
        $form->text('company_name', '公司名称')->rules('required|max:100', ['required' => '公司名称不能为空。', 'max' => '公司名称不能大于100。'])->setWidth(4)->setMustMark();
        $form->text('job_name', '岗位名称')->rules('required|max:60', ['required' => '岗位名称不能为空。', 'max' => '岗位名称不能大于60。'])->setWidth(4)->setMustMark();
        $form->number('wage_min', '最小薪资')->rules('required', ['required' => '最小薪资不能为空。若未确定，请填0'])->setWidth(4)->setMustMark();
        $form->number('wage_max', '最大薪资')->rules('required', ['required' => '最大薪资不能为空。若未确定，请填0'])->setWidth(4)->setMustMark();
        $form->text('industry', '所属行业领域')->rules('required|max:60', ['required' => '所属行业领域不能为空。', 'max' => '所属行业领域不能大于60。'])->setWidth(4)->setMustMark();
        $education = Category::where('alias','AIX_education')->pluck('demand','id');
        $education[0] = '不限';
        $form->select('education', '学历')->setWidth(4)->options($education)->setMustMark();
        $experience = Category::where('alias','AIX_experience')->pluck('demand','id');
        $experience[0] = '不限';
        $form->select('experience', '工作经验')->setWidth(4)->options($experience)->setMustMark();
        $form->text('region', '工作地点')->rules('required|max:60', ['required' => '工作地点不能为空。', 'max' => '工作地点不能大于60。'])->setWidth(4)->setMustMark();

        $form->footer(function ($footer) {
            $footer->disableViewCheck();
            $footer->disableEditingCheck();
            $footer->disableCreatingCheck();
            $footer->disableReset();
        });
        $form->tools(function (Form\Tools $tools) {
            $tools->disableDelete();
            $tools->disableView();
        });
        return $form;
    }

    public function update($id)
    {
        return $this->editForm($id)->update($id);
    }

    public function destroy($id)
    {
        if ($this->form()->destroy($id)) {
            $data = [
                'status'  => true,
                'message' => trans('admin.delete_succeeded'),
            ];
        } else {
            $data = [
                'status'  => false,
                'message' => trans('admin.delete_failed'),
            ];
        }
        return response()->json($data);
    }

    /**
     * 导出
     */
    public function export(Request $request)
    {
        //数据获取
        $id     = $request->id;
        $status = $request->status;
        $house  = TalentHouse::find($id);
        $query  = TalentHouseApply::with(['house', 'idcard'])
            ->where('house_id', $id)
            ->where('is_back', 2)
            ->where('is_draft', 2)
            ->orderByRaw(DB::raw("FIELD(talent_level,'第一层次','第二层次','第三层次','第四层次','第五层次','第六层次','第七层次') asc"));
        if ($status == 1) {
            $filename = $house['name'] . '审核不通过名单.xls';
            $query    = $query->whereIn('status', [1, 3, 4]);
        } else {
            $filename = $house['name'] . '审核通过名单.xls';
            $query    = $query->where('status', 2);
        }
        $data = $query->get();
        if ($data->isEmpty()) {
            return '暂无数据';
        }


        //数据处理
        $status = ['', '待审核', '审核通过', '审核驳回', '审核不通过'];
        $marry  = ['未知', '未婚', '已婚', '离异', '丧偶'];
        $type   = ['', '优秀人才', '集成电路优秀人才'];
        $no     = 1;
        foreach ($data as $row) {
            $family = empty($row->family) ? '' : json_decode($row->family, true);
            if (!empty($family)) {
                $relation = [];
                $child    = [];
                $id_card  = [];
                foreach ($family as $v) {
                    $relation[] = $v['relation'];
                    $child[]    = $v['realname'];
                    $id_card[]  = $v['idcard'];
                }
                $row['relation']         = implode('/', $relation);
                $row['relation_name']    = implode('/', $child);
                $row['relation_id_card'] = implode('/', $id_card);
            }

            $row['no'] = $no;
            $no++;
            $row['marry_text'] = $marry[$row['marry']];
            $row['type_text']  = $type[$row['type']];
        }

        header("Content-type: application/vnd.ms-excel; charset=utf-8");
        header("Content-Disposition: attachment; filename=$filename");
        $view = view('admin.content.export_house_result')->with(['data' => $data, 'house' => $house, 'status' => $status]);
        $str  = response($view)->getContent();
        echo $str;
        exit;
    }
}