数仓加拼团

ibrand_multi_groupon拼团表

CREATE TABLE `ibrand_multi_groupon` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(191) DEFAULT NULL COMMENT '拼团名称', `goods_id` int(10) DEFAULT NULL, `nums` int(10) DEFAULT NULL COMMENT '拼团人数', `price` decimal(10,2) DEFAULT NULL COMMENT '价格', `sort` bigint(4) DEFAULT NULL COMMENT '排序', `status` tinyint(4) DEFAULT '1' COMMENT '状态', `starts_at` datetime DEFAULT NULL COMMENT '开始时间', `ends_at` datetime DEFAULT NULL COMMENT '结束时间', `created_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

商品表

CREATE TABLE `goods_db` ( `id` int(10) NOT NULL AUTO_INCREMENT, `goods_no` varchar(32) NOT NULL, `goods_name` varchar(100) DEFAULT NULL, `category_id` bigint(4) DEFAULT NULL, `sell_price` decimal(10,2) DEFAULT NULL, `img` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

创建对应模型层

php artisan make:model ....

创建admin控制器

php artisan admin:make Controller --model=App\User

admin规格选择器 admin 数仓

php artisan make:provider RiakServiceProvider

数仓绑定 [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-tHde3YAQ-1599135064387)(https://cdn.learnku.com/uploads/images/202009/03/58026/15USyiWTa0.png!large)]

public function register() { $this->app->bind( AsdInterfaces::class, AsdRepository::class ); }

Repository文件夹 Interfaces Repositories Interfaces内的接口 [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-6bysUF4m-1599135064389)(https://cdn.learnku.com/uploads/images/202009/03/58026/3F7eYARppm.png!large)]

<?php namespace App\Repository\Interfaces; interface AsdInterfaces { public function Asdf($num); }

Repositories 接口实现方法 [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-78Yih0nk-1599135064391)(https://cdn.learnku.com/uploads/images/202009/03/58026/b7YUn5ly9q.png!large)]

<?php namespace App\Repository\Repositories; use App\IbrandMultiGroupon; use App\Repository\Interfaces\AsdInterfaces; class AsdRepository implements AsdInterfaces { public function Asdf($num) {/* '0'=> '所有活动', 1=> '未开始', 2=>'进行中', 3=>'已结束', 4=>'已失效',*/ $times=date("Y-m-d H:i:s");//获取当前时间 if ($num==1){//未开始 $ids=IbrandMultiGroupon::where('starts_at','>',$times) ->where('status','=',1) ->get()->pluck('id'); return $ids; }elseif ($num==0){//所有活动 $ids=IbrandMultiGroupon::get()->pluck('id'); return $ids; }elseif ($num==2){//正在进行的 $ids=IbrandMultiGroupon::where('starts_at','<',$times) ->where('status','=',1) ->where('ends_at','>',$times) ->get()->pluck('id'); // dd(132); return $ids; }elseif ($num==3){//结束的 $ids=IbrandMultiGroupon::where('ends_at','<',$times) ->where('status','=',1) ->get()->pluck('id'); // dd(132); return $ids; }else{//失效的 $ids=IbrandMultiGroupon::where('status','=',0) ->get()->pluck('id'); // dd(132); return $ids; } } }

团购控制器

<?php namespace App\Admin\Controllers; use App\DbGoods; use App\IbrandMultiGroupon; use App\Repository\Interfaces\AsdInterfaces; use Encore\Admin\Controllers\AdminController; use Encore\Admin\Form; use Encore\Admin\Grid; use Encore\Admin\Show; class IbrandMultiGrouponController extends AdminController { /** * Title for current resource. * * @var string */ protected $title = 'IbrandMultiGroupon'; /** * Make a grid builder. * * @return Grid */ protected $asd; public function __construct(AsdInterfaces $asdf) { $this->asd = $asdf; } protected function grid() { $grid = new Grid(new IbrandMultiGroupon()); $a = 1; $grid->selector(function (Grid\Tools\Selector $selector) { $selector->select('status', '拼团状态', [ '0' => '所有活动', 1 => '未开始', 2 => '进行中', 3 => '已结束', 4 => '已失效', ], function ($query, $value) { $num = $value[0]; $a = $this->asd->Asdf($num); //dd($value[0]); $query->wherein('id', $a); } ); }); $grid->column('id', __('Id')); $grid->column('title', __('标题')); $grid->column('goods_id', __('商品编号')); $grid->column('nums', __('拼团人数')); $grid->column('price', __('拼团价格')); $grid->column('sort', __('排序')); $grid->column('status', __('状态'))->editable('select',[ 0 => '下架', 1 => '上架', ]); $grid->column('starts_at', __('开始时间')); $grid->column('ends_at', __('结束时间')); $grid->column('created_at', __('Created at')); $grid->column('updated_at', __('Updated at')); $grid->column('deleted_at', __('Deleted at')); return $grid; } /** * Make a show builder. * * @param mixed $id * @return Show */ protected function detail($id) { $show = new Show(IbrandMultiGroupon::findOrFail($id)); $show->field('id', __('Id')); $show->field('title', __('Title')); $show->field('goods_id', __('商品编号')); $show->field('nums', __('拼团人数')); $show->field('price', __('拼团价格')); $show->field('sort', __('排序')); $show->field('status', __('状态')); $show->field('starts_at', __('开始时间')); $show->field('ends_at', __('结束时间')); $show->field('created_at', __('Created at')); $show->field('updated_at', __('Updated at')); $show->field('deleted_at', __('Deleted at')); return $show; } /** * Make a form builder. * * @return Form */ protected function form() { $form = new Form(new IbrandMultiGroupon()); $form->text('title', __('Title')); // $form->number('goods_id', __('商品编号')); // dd(DbGoods::get()->pluck('goods_name','id')); $form->radio('goods_id')->options(DbGoods::get()->pluck('goods_name', 'id'))->stacked(); $form->number('nums', __('拼团人数')); $form->decimal('price', __('拼团价格')); $form->number('sort', __('排序')); $form->select('status', __('状态'))->options([ 0 => '下架', 1 => '上架', ])->default(1); $form->datetime('starts_at', __('开始时间'));//->default(date('Y-m-d H:i:s')) $form->datetime('ends_at', __('结束时间')); return $form; } }

回收站软删除 请点击

控制器 $grid->filter(function ($filter) { // 范围过滤器，调用模型的`onlyTrashed`方法，查询出被软删除的数据。 $filter->scope('trashed', '回收站')->onlyTrashed(); });

回收站

模型层 use Illuminate\Database\Eloquent\Model; use Illuminate\Database\Eloquent\SoftDeletes; class IbrandMultiGroupon extends Model { protected $table = 'ibrand_multi_groupon'; use SoftDeletes; }