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

<?php

namespace App\Admin\Controllers\Content;

use App\Admin\Extensions\Form\ValidateForm;
use App\Http\Controllers\Controller;
use App\Models\Article;
use App\Models\ArticleCategory;
use App\Models\ArticleProperty;
use App\Models\Subsite;
use App\Models\SubsiteArticle;
use Encore\Admin\Controllers\HasResourceActions;
use Encore\Admin\Facades\Admin;
use Encore\Admin\Form;
use Encore\Admin\Grid;
use Encore\Admin\Layout\Content;
use Encore\Admin\Show;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Cache;

class ArticleController extends Controller
{
    use HasResourceActions;

    /**
     * Index interface.
     *
     * @param Content $content
     * @return Content
     */
    public function index(Content $content)
    {
        return $content
            ->header('新闻列表')
            ->description(' ')
            ->body(view('admin.content.article')->with(['grid'=>$this->grid()]));
    }

    /**
     * Show interface.
     *
     * @param mixed $id
     * @param Content $content
     * @return Content
     */
    public function show($id, Content $content)
    {

        return $content
            ->header('新闻')
            ->description(' ')
            ->body($this->detail($id));
    }

    /**
     * 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 Article);

        $grid->model()->when(get_subsite_id()>0, function ($query) {
            $query->where('subsite_id', get_subsite_id());
        })->when(Admin::user()->isRole('health'), function ($query) {
            $query->whereIn('type_id',[65,66]);
        })->when(Admin::user()->isRole('ic_group'), function ($query) {
            $query->where('type_id',67);
        })->orderBy('list_order', 'DESC')->orderBy('created_at', 'DESC');

        $grid->column('新闻标题')->display(function () {
            $style="color:".$this->tit_color.';';
            if ($this->tit_b=='1') {
                $style .='font-weight:bold;';
            }
            $cate = ArticleCategory::where(array('id'=>$this->type_id))->first();
            if ($this->parent_id=='0') {
                $params = '?type_id=&parent_id='.$this->type_id;
            } else {
                $params = '?type_id='.$this->type_id.'&parent_id='.$this->parent_id;
            }
            $title_url = url(admin_base_path().'/content/article/index'.$params);
            if ($cate) {
                return '<a href='.$title_url.' style="color: #006699;">['.$cate->category_name.']</a> <span style="'.$style.'">'.$this->title.'</span>';
            } else {
                return '<span style="'.$style.'">'.$this->title.'</span>';
            }
        })->width(200);
        $grid->small_img('缩略图')->display(function () {
            if ($this->small_img) {
                return '<span class="vtip" title="<img src=\''.upload_asset($this->small_img).'\'  height=120>">
                            <img class="avatar small" src="'.upload_asset($this->small_img).'" align="absmiddle" style="width: 22px;height: 22px;">
                        </span>';
            } else {
                return '';
            }
        });

        $grid->robot('添加方式');
        $grid->show_property()->category_name('新闻属性');
        if (get_subsite_open()) {
            $grid->subsite_id('所属分站')->display(function () {
                $subsites = Cache::get('subsites_list');
                if (array_has($subsites, $this->subsite_id)) {
                    return $subsites[$this->subsite_id]['sitename'];
                }
                return '';
            });
        }

        $grid->list_order('排序');
        $grid->click('点击量');
        $grid->created_at('添加时间');
        //新增按钮
        if (userAdmin::user()->can('content_article_list_create')) {
            $grid->disableCreateButton(false);
        }
        //批量删除
        if (userAdmin::user()->can('content_article_list_delete')) {
            $grid->tools(function ($tools) {
                $tools->batch(function ($batch) {
                    $batch->disableDelete(false);
                });
            });
        } else {
            $grid->disableRowSelector();
        }

        $grid->actions(function ($actions) {
            if (userAdmin::user()->can('content_article_list_delete')) {
                if ($actions->row['subsite_id']== get_subsite_id() || get_subsite_id()==0) {
                    $actions->disableEdit(false);
                }
            }
            if (userAdmin::user()->can('content_article_list_edit')) {
                if ($actions->row['subsite_id']== get_subsite_id() || get_subsite_id()==0) {
                    $actions->disableDelete(false);
                }
            }
        });

        $grid->filter(function ($filter) {
            $filter->disableIdFilter();
            $filter->equal('ID', '新闻ID');
            $filter->like('title', '新闻标题');
            $not_ids = ArticleCategory::categoryIds();
            if ($not_ids) {
                $cate_option = ArticleCategory::where('parent_id', '0')->WhereNotIn('id', $not_ids)->get()->pluck('category_name', 'id');
            } else {
                $cate_option = ArticleCategory::where('parent_id', '0')->get()->pluck('category_name', 'id');
            }

            /*$filter->where(function ($query) {

                $query->where('parent_id', '=', "{$this->input}")->orWhere('type_id', '=', "{$this->input}");
            }, '新闻分类', 'parent_id')->select($cate_option)->load('type_id', 'get_category', 'id', 'category_name');

            $pid = \Illuminate\Support\Facades\Request::input('parent_id');
            if ($pid) {
                $child_cates = ArticleCategory::where(array('parent_id'=>$pid))->get(['id', 'category_name'])->toArray();
            } else {
                $child_cates = array();
            }
            $pre_arr = array('id'=>'','category_name'=>'不限');
            array_unshift($child_cates, $pre_arr);
            $filter->equal('type_id', '新闻子分类')->select(collect($child_cates)->pluck('category_name', 'id'));*/

            /*$menuModel = config('admin.database.menu_model');
            $form->select('parent_id', trans('admin.parent_id'))->options($menuModel::selectOptions());*/

            $article_cates = ArticleCategory::selectOptions(function ($query) {
                return $query->orderBy('list_order', 'desc')->orderBy('created_at', 'desc');
            });
            if (array_has($article_cates, '0')) {
                unset($article_cates[0]);
            }
            $filter->where(function ($query) {
                $query->where('parent_id', '=', "{$this->input}")->orWhere('type_id', '=', "{$this->input}");
            }, '新闻分类', 'parent_id')->select($article_cates);

            $property_option = ArticleProperty::orderBy('list_order', 'DESC')->orderBy('created_at', 'DESC')->pluck('category_name', 'id');
            $filter->equal('property_id', '新闻属性')->select($property_option)->default('');

            $subsites = Subsite::where(array('effective'=>1))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
            if ($subsites) {
                $subsites = array('' => '不限', '0' => '总站') + $subsites;
                $filter->equal('subsite_id', '所属分站')->select($subsites);
            }

            $date3   = date('Y-m-d', strtotime("-3 day"));
            $date7   = date('Y-m-d', strtotime("-7 day"));
            $date30  = date("Y-m-d", strtotime("-1 month"));
            $date180 = date("Y-m-d", strtotime("-6 month"));
            $date360 = date("Y-m-d", strtotime("-1 year"));
            $date_option = array(
                ''    => '不限',
                $date3   => '三天内',
                $date7   => '一周内',
                $date30  => '一月内',
                $date180 => '半年内',
                $date360 => '一年内',
            );
            $filter->where(function ($query) {
                $query->where('created_at', '>=', "{$this->input}");
            }, '添加时间', 'created_at')->radio($date_option);
        });
        return $grid;
    }
    public function getCategory(Request $request)
    {
        $parent_id = $request->input('q');
        $where = array('parent_id'=>$parent_id);
        $not_ids = ArticleCategory::categoryIds();
        if ($not_ids) {
            $cates = ArticleCategory::where($where)->WhereNotIn('id', $not_ids)->get(['id', 'category_name'])->toArray();
        } else {
            $cates = ArticleCategory::where($where)->get(['id', 'category_name'])->toArray();
        }

        $pre_arr = array('id'=>'','category_name'=>'不限');
        array_unshift($cates, $pre_arr);
        return collect($cates);
    }

    /**
     * Make a show builder.
     *
     * @param mixed $id
     * @return Show
     */
    protected function detail($id)
    {
        $show = new Show(Article::findOrFail($id));

        $show->id('ID');
        $show->title('标题');
        $show->tit_color('标题颜色')->as(function ($tit_color) {
            $html = '<i style="background-color: '.$tit_color.';padding: 5px 15px;"></i>';
            return $html;
        })->setEscape(false);
        $show->show_category("新闻分类")->as(function ($show_category) {
            return $show_category->category_name;
        });
        $show->small_img('缩略图')->image();
        if (get_subsite_open()) {
            $show->subsite_id('所属分站')->as(function ($subsite_id) {
                if ($subsite_id) {
                    $Subsite = Subsite::findOrFail($subsite_id);
                    return $Subsite->sitename;
                }
                return '总站';
            });
        }

        $show->content('内容')->setEscape(false);
        $show->is_display('是否显示')->as(function ($is_display) {
            return $is_display?'是':'否';
        });
        $show->tit_b('标题加粗')->as(function ($tit_b) {
            return $tit_b?'是':'否';
        });
        $show->released_at('发布日期');
        $show->list_order('新闻排序');
        $show->author('作者')->as(function ($author) {
            return $author?$author:'&nbsp';
        })->setEscape(false);
        $show->source('来源')->as(function ($source) {
            return $source?$source:'&nbsp';
        })->setEscape(false);
        $show->show_property("新闻属性")->as(function ($show_property) {
            return $show_property->category_name;
        });
        $show->is_url('外部链接')->as(function ($is_url) {
            return $is_url?$is_url:'&nbsp';
        })->setEscape(false);
        $show->seo_keywords('Keywords')->as(function ($seo_keywords) {
            return $seo_keywords?$seo_keywords:'&nbsp';
        })->setEscape(false);
        $show->seo_description('Description')->as(function ($seo_description) {
            return $seo_description?$seo_description:'&nbsp';
        })->setEscape(false);
        $show->click('点击量');
        $show->created_at('添加时间');
        $show->updated_at('更新时间');

        return $show;
    }

    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function form()
    {
        $form = new ValidateForm(new Article);
        $form->text('title', '新闻标题')->rules('required|max:100', array('required'=>'新闻标题不能为空。','max'=>'新闻标题长度不能大于100。'))->setWidth(4)->setMustMark();
        $form->color('tit_color', '标题颜色')->rules('required|regex:/^#[a-fA-F0-9]{6}$/', array('required'=>'标题颜色不能为空。','regex'=>'标题颜色格式不正确。'))->default('#000000');

        //$cate_option = ArticleCategory::selectOptions();
        $cate_option = ArticleCategory::selectOptions(function ($query) {
            if(Admin::user()->isRole('health')){
                return $query->whereIn('id',[65,66])->orderBy('list_order', 'desc')->orderBy('created_at', 'desc');
            }
            if(Admin::user()->isRole('ic_group')){
                return $query->whereIn('id',[67])->orderBy('list_order', 'desc')->orderBy('created_at', 'desc');
            }
            return $query->orderBy('list_order', 'desc')->orderBy('created_at', 'desc');
        });
        unset($cate_option[0]);
        $form->select('type_id', '新闻分类')->options($cate_option)->default(key($cate_option))->rules('required', array('required'=>'请选择新闻分类。'))->setWidth(4)->setMustMark();
        $form->image('small_img', '缩略图')->uniqueName()->rules('image|mimes:jpeg,bmp,png', array('image'=>'缩略图请选择图片文件。','mimes'=>'请选择jpeg,bmp,png格式的缩略图上传。'))->setWidth(3);
        if (get_subsite_id()==0) {
            $subsites = Subsite::where(array('effective'=>1))->orderBy('order', 'asc')->get()->pluck('sitename', 'id');
        } else {
            $subsites = Subsite::where(array(array('effective','=',1),array('id','<>', get_subsite_id())))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
            $subsites['0']= '总站';
            $subsites = collect($subsites);
        }
        if ($subsites->isNotEmpty() && get_subsite_id()==0) {
            $form->multipleSelect('relate_subsites', '同步分站')->options($subsites);
        } else {
            $form->hidden('relate_subsites');
        }
        $form->ignore(['relate_subsites']);
        $form->hidden('subsite_id')->value(get_subsite_id());
        $form->hidden('parent_id')->value(0);
        $form->editor('content', '内容')->rules('required', array('required'=>'内容不能为空。'))->setMustMark();

        $display_option = [
            'on'  => ['value' => 1, 'text' => '是', 'color' => 'success'],
            'off' => ['value' => 0, 'text' => '否', 'color' => 'danger'],
        ];
        $form->switch('is_display', '是否显示')->states($display_option)->default('1')->setMustMark();
        $form->switch('tit_b', '标题加粗')->states($display_option)->default(0)->setMustMark();
        $form->date('released_at', '发布日期')->format('YYYY-MM-DD')->rules('required|date', array('required'=>'发布日期不能为空。', 'date'=>'发布日期格式不正确。'))->default(date('Y-m-d', time()));
        $form->number('list_order', '新闻排序')->min(0)->default(255)->rules('required', array('required'=>'新闻排序不能为空。'))->help('（数字越大越靠前）');
        $form->text('author', '作者')->rules('max:20', array('max'=>'作者长度不能大于20。'))->setWidth(4);
        $form->text('source', '来源')->rules('max:20', array('max'=>'来源长度不能大于20。'))->setWidth(4);

        $cate_option = ArticleProperty::orderBy('list_order', 'DESC')->orderBy('created_at', 'DESC')->pluck('category_name', 'id');
        $form->select('property_id', '新闻属性')
            ->options($cate_option)
            ->default(key($cate_option->toArray()))
            ->rules('required', array('required'=>'请选择新闻属性。'))
            ->setWidth(4)
            ->setMustMark();

        $form->url('is_url', '外部链接')->rules('max:250', array('max'=>'外部链接长度不能超过250。'))->help('(请输入包含http://或https://的完整链接)');
        $form->text('seo_keywords', 'Keywords')->placeholder('合理设置Keywords有利于搜索引擎排名')->rules('max:80', array('max:Keywords不能大于80个字符。'));
        $form->textarea('seo_description', 'Description')->placeholder('合理设置Description有利于搜索引擎排名')->rules('max:80', array('max'=>'Description不能大于80个字符。'));

        $form->saving(function (Form $form) {
            $form->released_at = strtotime($form->released_at);
            $author = $form->author?$form->author:'';
            $source = $form->source?$form->source:'';
            $is_url = $form->is_url?$form->is_url:'';
            $seo_keywords = $form->seo_keywords?$form->seo_keywords:'';
            $seo_description = $form->seo_description?$form->seo_description:'';
            $form->author = $author;
            $form->source = $source;
            $form->is_url = $is_url;
            $form->seo_keywords = $seo_keywords;
            $form->seo_description = $seo_description;

            $type_info = ArticleCategory::find($form->type_id);
            $parent_id = $type_info->parent_id;
            $form->parent_id = $parent_id;
        });
        $form->saved(function (Form $form) {
            $subsites = \Illuminate\Support\Facades\Request::input('relate_subsites');
            if (empty($subsites)) {
                $subsites = [];
            }
            $subsites = array_merge(array(get_subsite_id()), $subsites);
            $set_data = array();
            foreach ($subsites as $k => $v) {
                if ($v !== null) {
                    $set_data[] = array(
                        'article_id' => $form->model()->id,
                        'subsite_id'=> $v
                    );
                }
                Cache::forget('article_index_list_home_'.$v);    //清除缓存
            }
            SubsiteArticle::insert($set_data);
        });
        $form->footer(function ($footer) {
            $footer->disableViewCheck();
            $footer->disableEditingCheck();
            $footer->disableCreatingCheck();
            $footer->disableReset();
        });
        return $form;
    }
    protected function editForm($id)
    {
        $info = Article::find($id);

        $form = new ValidateForm(new Article);
        $form->text('title', '新闻标题')->rules('required|max:100', array('required'=>'新闻标题不能为空。','max'=>'新闻标题长度不能大于100。'))->setWidth(4)->setMustMark();
        $form->color('tit_color', '标题颜色')->default('#000000')->rules('required|regex:/^#[a-fA-F0-9]{6}$/', array('required'=>'标题颜色不能为空。','regex'=>'标题颜色格式不正确。'));

        //$cate_option = ArticleCategory::all()->pluck('category_name', 'id');
        //$cate_option = ArticleCategory::selectOptions();
        $cate_option = ArticleCategory::selectOptions(function ($query) {
            return $query->orderBy('list_order', 'desc')->orderBy('created_at', 'desc');
        });
        unset($cate_option[0]);
        $form->select('type_id', '新闻分类')->options($cate_option)->default(key($cate_option))->rules('required', array('required'=>'请选择新闻分类。'))->setWidth(4)->setMustMark();
        $form->image('small_img', '缩略图')->uniqueName()->rules('image|mimes:jpeg,bmp,png', array('image'=>'缩略图请选择图片文件。','mimes'=>'请选择jpeg,bmp,png格式的缩略图上传。'))->setWidth(3);
        if ($info->subsite_id==0) {
            $subsites = Subsite::where(array('effective'=>1))->orderBy('order', 'asc')->get()->pluck('sitename', 'id');
        } else {
            $subsites = Subsite::where(array(array('effective','=',1),array('id','<>', $info->subsite_id)))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
            $subsites['0']= '总站';
            $subsites = collect($subsites);
        }
        if ($subsites->isNotEmpty() && $info->subsite_id==0) {
            $relations = SubsiteArticle::where(array('article_id'=>$id))->get()->pluck('subsite_id')->toArray();
            $form->multipleSelect('relate_subsites', '同步分站')->options($subsites)->default($relations);
        } else {
            $form->hidden('relate_subsites');
        }
        $form->ignore(['relate_subsites']);
        $form->hidden('subsite_id')->value(get_subsite_id());
        $form->hidden('parent_id');

        $form->editor('content', '内容')->rules('required', array('required'=>'内容不能为空。'))->setMustMark();
        $display_option = [
            'on'  => ['value' => 1, 'text' => '是', 'color' => 'success'],
            'off' => ['value' => 0, 'text' => '否', 'color' => 'danger'],
        ];
        $form->switch('is_display', '是否显示')->states($display_option)->setMustMark();
        $form->switch('tit_b', '标题加粗')->states($display_option)->setMustMark();
        $form->date('released_at', '发布日期')->format('YYYY-MM-DD')->rules('required|date', array('required'=>'发布日期不能为空。', 'date'=>'发布日期格式不正确。'));
        $form->number('list_order', '新闻排序')->min(0)->default(0)->rules('required', array('required'=>'新闻排序不能为空。'))->help('（数字越大越靠前）');
        $form->text('author', '作者')->rules('max:20', array('max'=>'作者长度不能大于20。'))->setWidth(3);
        $form->text('source', '来源')->rules('max:20', array('max'=>'来源长度不能大于20。'))->setWidth(3);
        $cate_option = ArticleProperty::orderBy('list_order', 'DESC')->orderBy('created_at', 'DESC')->pluck('category_name', 'id');
        $form->select('property_id', '新闻属性')->options($cate_option)->default(key($cate_option->toArray()))->rules('required', array('required'=>'请选择新闻属性。'))->setWidth(3)->setMustMark();
        $form->url('is_url', '外部链接')->rules('max:250', array('max'=>'外部链接长度不能超过250。'))->help('(请输入包含http://或https://的完整链接)');
        $form->text('seo_keywords', 'Keywords')->placeholder('合理设置Keywords有利于搜索引擎排名')->rules('max:80', array('max:Keywords不能大于80个字符。'));
        $form->textarea('seo_description', 'Description')->placeholder('合理设置Description有利于搜索引擎排名')->rules('max:80', array('max'=>'Description不能大于80个字符。'));
        $form->saving(function (Form $form) {
            if (!request()->has(Form\Field::FILE_DELETE_FLAG)) {
                $form->released_at = strtotime($form->released_at);
                $author = $form->author?$form->author:'';
                $source = $form->source?$form->source:'';
                $is_url = $form->is_url?$form->is_url:'';
                $seo_keywords = $form->seo_keywords?$form->seo_keywords:'';
                $seo_description = $form->seo_description?$form->seo_description:'';
                $form->author = $author;
                $form->source = $source;
                $form->is_url = $is_url;
                $form->seo_keywords = $seo_keywords;
                $form->seo_description = $seo_description;
                $type_info = ArticleCategory::find($form->type_id);
                $parent_id = $type_info->parent_id;
                $form->parent_id = $parent_id;
            }
        });

        $form->saved(function (Form $form) {
            if (!request()->has(Form\Field::FILE_DELETE_FLAG)) {
                $subsites = \Illuminate\Support\Facades\Request::input('relate_subsites');
                if (empty($subsites)) {
                    $subsites = [];
                }
                $subsites = array_merge(array($form->model()->subsite_id), $subsites);
                SubsiteArticle::where('article_id', $form->model()->id)->delete();
                $set_data = array();
                foreach ($subsites as $k => $v) {
                    if ($v !== null) {
                        $set_data[] = array(
                            'article_id' => $form->model()->id,
                            'subsite_id'=> $v
                        );
                    }
                    Cache::forget('article_index_list_home_'.$v);    //清除缓存
                }
                SubsiteArticle::insert($set_data);
            }
        });
        $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)
    {
        $ids = array();
        if ($id) {
            $ids = explode(',', $id);
        }
        if (get_subsite_id() == 0) {
            $filter_id = $id;
        } else {
            $seletctors = Article::where(array('subsite_id'=>get_subsite_id()))->whereIn('id', $ids)->get()->pluck('id')->toarray();
            if ($seletctors) {
                $filter_id = implode(',', $seletctors);
            } else {
                $filter_id = '';
            }
        }
        //获取所有分站信息
        $subsites = Subsite::where(array('effective'=>1))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
        if ($subsites) {
            foreach ($subsites as $key => $val) {
                Cache::forget('article_index_list_home_'.$key);
            }
        }
        if ($filter_id) {
            if ($this->form()->destroy($filter_id)) {
                $data = [
                    'status'  => true,
                    'message' => trans('admin.delete_succeeded'),
                ];
            } else {
                $data = [
                    'status'  => false,
                    'message' => trans('admin.delete_failed'),
                ];
            }
        } else {
            $data = [
                'status'  => false,
                'message' => '不能删除其它分站数据！',
            ];
        }
        return response()->json($data);
    }
}