团购后台解决方案及代码实现

一、数据表结构二、模型实现三.admin控制器实现四.添加自定义行操作，修改活动状态

---

一、数据表结构

商品表：

CREATE TABLE `goods` ( `id` int(10) NOT NULL AUTO_INCREMENT, `goods_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `goods_price` decimal(10, 2) NULL DEFAULT NULL, `goods_stock` int(5) NULL DEFAULT NULL, `goods_no` int(10) NULL DEFAULT NULL, `is_pt` int(1) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

团购表：

CREATE TABLE `pt_goods` ( `id` int(10) NOT NULL AUTO_INCREMENT, `pt_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `goods_id` int(10) NULL DEFAULT NULL, `pt_price` decimal(10, 2) NULL DEFAULT NULL, `start_time` datetime(0) NULL DEFAULT NULL, `end_time` datetime(0) NULL DEFAULT NULL, `status` int(1) NULL DEFAULT NULL, `order` int(6) NULL DEFAULT NULL, `pt_num` int(1) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

二、模型实现

运行下面命令创建模型

php artisan make:model Pt

模型代码

class Pt extends Model { //软删除 use SoftDeletes; protected $table='自己创建的表'; //关联商品表 public function goods(){ return $this->belongsTo(Goods::class,'goods_id','id'); } //根据活动时间 修改活动状态 public function getStatusAttribute($status) { if ($status == 3) { return 3; }elseif ($this->start_time > date('Y-m-d H:i:s')){ if ($status!=0){ $this->status=0; $this->push(); } return 0; }elseif ($this->end_time >date('Y-m-d H:i:s')){ if ($status!=1){ $this->status=1; $this->push(); } return 1; }elseif ($this->end_time<date('Y-m-d H:i:s')){ if ($status!=2){ $this->status=2; $this->push(); } return 2; } } }

---

三.admin控制器实现

示例：下面代码省略了无需修改部分

运行下面命令创建控制器

php artisan admin:make PtController --model=App\Pt <?php class PtController extends AdminController { protected $PostRepository; protected $Pt; public function __construct( PostRepository $PostRepository, Pt $Pt) { $this->PostRepository=$PostRepository; $this->Pt=$Pt; } protected function grid() { $tab=new Tab(); $all=\Admin::grid($this->Pt,function (Grid $grid){ $grid->column('id', __('Id')); $grid->model()->orderBy('order'); $grid->actions(function ($actions){ if ($actions->row['status']==0 || $actions->row['status']==1){ $actions->disableDelete(); $actions->add(new Replicate()); } }); $grid->column('pt_name', __('活动名称')); $grid->column('goods.goods_name', __('商品名称')); $grid->column('status', __('状态'))->using([ 0=>'未开始', 1=>'进行中', 2=>'已结束', 3=>'已失效', ]); }); $nostart=\Admin::grid($this->Pt,function (Grid $grid){ $grid->model()->where('status',0); $grid->model()->orderBy('order'); $grid->actions(function ($actions){ $actions->disableDelete(); $actions->add(new Replicate()); }); $grid->column('id', __('Id')); $grid->column('pt_name', __('活动名称')); $grid->column('goods.goods_name', __('商品名称')); $grid->column('status', __('状态'))->display(function (){ return '未开始'; }); }); $starting=\Admin::grid($this->Pt,function (Grid $grid) { $grid->model()->where('status', 1); $grid->model()->orderBy('order'); $grid->actions(function ($actions) { $actions->disableDelete(); $actions->add(new Replicate()); }); $grid->column('id', __('Id')); $grid->column('pt_name', __('活动名称')); $grid->column('goods.goods_name', __('商品名称')); $grid->column('status', __('状态'))->display(function () { return '进行中'; }); }); $end=\Admin::grid($this->Pt,function (Grid $grid){ $grid->model()->where('status',2); $grid->model()->orderBy('order'); $grid->column('id', __('Id')); $grid->column('pt_name', __('活动名称')); $grid->column('goods.goods_name', __('商品名称')); $grid->column('status', __('状态'))->display(function (){ return '已结束'; }); }); $loser=\Admin::grid($this->Pt,function (Grid $grid){ $grid->model()->where('status',3); $grid->model()->orderBy('order'); $grid->column('id', __('Id')); $grid->column('pt_name', __('活动名称')); $grid->column('goods.goods_name', __('商品名称')); $grid->column('status', __('状态'))->display(function (){ return '已失效'; }); }); $tab->add('全部活动',$all); $tab->add('未开始',$nostart); $tab->add('进行中',$starting); $tab->add('已结束',$end); $tab->add('已失效',$loser); return $tab; } protected function detail($id) { $show = new Show(Pt::findOrFail($id)); $show->field('status', __('状态'))->using([ 0=>'未开始', 1=>'进行中', 2=>'已结束', 3=>'已失效', ]); return $show; } protected function form() { $form = new Form(new Pt()); $form->text('pt_name', __('活动名称')); $form->number('goods_id', __('选择商品'))->options($this->PostRepository->getGoods()); $form->number('status', __('排序'))->default(9)->help('越小越靠前'); return $form; } }

在app\Admin\routes.php配置路由

$router->resource('pts', PtController::class);

四.添加自定义行操作，修改活动状态

终端运行下面命令添加自定义行操作

php artisan admin:action Post\Replicate --grid-row --name="使失效"

在app\Admin\Action\ Post\Replicate.php下编辑行操作

namespace App\Admin\Actions\Post; use Encore\Admin\Actions\RowAction; use Illuminate\Database\Eloquent\Model; class Replicate extends RowAction { public $name = '使失效'; public function handle(Model $model) { $query=$model->find($this->getKey()); $query->status=3; $query->push(); return $this->response()->success('活动已失效')->refresh(); } public function dialog() { $this->confirm('确定使活动失效吗？'); } } return Goods::where('is_pt',1) ->pluck('goods_name','id');