model()->with('userData')->where('is_handpick',0)->orderByDesc('id');
$grid->column('id')->sortable();
$grid->column('userData.name','昵称');
$grid->column('userData.mobile','手机号');
$grid->column('userData.avatar','头像')->image('',40,40);
$grid->column('title')->display(function ($initContent) {
$maxLength = 10; // 你希望显示的最大字符数
$ellipsis = '...'; // 省略号
// 使用 mb_substr 截取字符串
$displayContent = mb_substr($initContent, 0, $maxLength);
// 如果原始字符串长度超过最大长度,添加省略号
if (mb_strlen($initContent) > $maxLength) {
$displayContent .= $ellipsis;
}
return $displayContent;
});;
// $grid->column('role_id');
// $grid->column('content');
$grid->column('state')->using(TaskList::$state)
->dot(
[
0 => 'primary',
1 => 'secondary',
2 => 'danger',
3 => 'warning',
4 => 'info',
5 => 'light',
6 => 'success',
],
'danger' // 第二个参数为默认值
);;
// $grid->column('image')->image('',80,80);
// $grid->column('init_content')->width('300px')->display(function ($initContent) {
// $maxLength = 10; // 你希望显示的最大字符数
// $ellipsis = '...'; // 省略号
//
// // 使用 mb_substr 截取字符串
// $displayContent = mb_substr($initContent, 0, $maxLength);
//
// // 如果原始字符串长度超过最大长度,添加省略号
// if (mb_strlen($initContent) > $maxLength) {
// $displayContent .= $ellipsis;
// }
//
// return $displayContent;
// });
// $grid->column('keyword');
// $grid->column('sd_image');
// $grid->column('desc');
// $grid->column('sd_id')->image('',80,80);
$grid->column('surplus_diamond');
// $grid->column('nickname');
// $grid->column('plot');
$grid->column('is_handpick')->switch();
$grid->column('sort')->sortable();
$grid->column('pdf_path')->display(function ($pdfPath) {
// $downloadUrl = url($pdfPath);
if (!empty($pdfPath)){
return "下载PDF";
}else{
return "还未生成PDF";
}
});
$grid->column('image_path','图片地址')->display(function ($image_path) {
// $downloadUrl = url($pdfPath);
if (!empty($image_path)){
return "浏览图片";
}else{
return "还未生成图片";
}
});
// $grid->column('pinyin_content');
$grid->column('created_at');
$grid->column('updated_at')->sortable();
$grid->disableEditButton();
$grid->disableDeleteButton();
$grid->disableViewButton();
$grid->disableCreateButton();
$grid->filter(function (Grid\Filter $filter) {
$filter->panel();
$filter->between('created_at')->datetime();
$filter->equal('is_handpick','是否精选')->select([0 => '不是精选',1 => '精选']);
$filter->where('mobile', function ($query) {
$query->whereHas('userData', function ($query) {
$query->where('mobile', 'like', "%{$this->input}%");
});
}, '用户手机号');
$filter->where('name', function ($query) {
$query->whereHas('userData', function ($query) {
$query->where('name', 'like', "%{$this->input}%");
});
}, '用户昵称');
});
});
}
/**
* Make a show builder.
*
* @param mixed $id
*
* @return Show
*/
protected function detail($id)
{
return Show::make($id, new TaskList(), function (Show $show) {
$show->field('id');
$show->field('user_id');
$show->field('title');
$show->field('role_id');
$show->field('content');
$show->field('state');
$show->field('image');
$show->field('init_content');
$show->field('keyword');
$show->field('sd_image');
$show->field('desc');
$show->field('sd_id');
$show->field('surplus_diamond');
$show->field('nickname');
$show->field('plot');
$show->field('is_handpick');
$show->field('sort');
$show->field('pinyin_content');
$show->field('pdf_path');
$show->field('created_at');
$show->field('updated_at');
});
}
/**
* Make a form builder.
*
* @return Form
*/
protected function form()
{
return Form::make(new TaskList(), function (Form $form) {
$form->display('id');
$form->text('user_id');
$form->text('title');
$form->text('role_id');
$form->text('content');
$form->text('state');
$form->text('image');
$form->text('init_content');
$form->text('keyword');
$form->text('sd_image');
$form->text('desc');
$form->text('sd_id');
$form->text('surplus_diamond');
$form->text('nickname');
$form->text('plot');
$form->text('is_handpick');
$form->text('sort');
$form->text('pinyin_content');
$form->text('pdf_path');
$form->display('created_at');
$form->display('updated_at');
});
}
}