<?php namespace api\portal\controller; use think\Controller; use think\Db; /** * @title 后台营销业务 * @description 营销业务相关接口 */ class MarketController extends Controller { /** * @title 添加分类 * @description * @author panhaowen * @url /portal/market/marketAdd * @param name:type type:int require:1 desc:字段类型 * @param name:selected type:varchar require:1 desc:所选字段id(,隔开) * @param name:name type:varchar require:1 desc:分类名称 * @method POST */ public function marketAdd() { $param=$this->request->param(); // $param['selected']=json_encode(explode(',',$param['selected'])); $re=Db::name('market')->insert($param); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 分类(列表) * @description * @author panhaowen * @url /portal/market/market * @method POST */ public function market() { $data=Db::name('market')->select(); $this->success('获取信息成功',$data); } /** * @title 编辑分类 * @description * @author panhaowen * @url /portal/market/marketEdit * @param name:id type:int require:1 desc:分类id * @method POST */ public function marketEdit() { $param=$this->request->param(); $data=Db::name('market')->where('id',$param['id'])->find(); $data['selected']=Db::name('classify')->where('id','in',explode(',', $data['selected']))->select(); $type=Db::name('type')->where('id',$data['type'])->find()['classify']; $data['classify']=Db::name('classify')->where('id','in',explode(',', $type))->select(); $this->success('获取信息成功',$data); } /** * @title 编辑分类提交 * @description * @author panhaowen * @url /portal/market/marketEditPost * @param name:id type:int require:1 desc:分类id * @param name:selected type:varchar require:1 desc:所选字段id(,隔开) * @param name:name type:varchar require:1 desc:分类名称 * @method POST */ public function marketEditPost() { $param=$this->request->param(); $re=Db::name('market')->where('id',$param['id'])->update($param); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 删除分类 * @description * @author panhaowen * @url /portal/market/marketDelete * @param name:id type:int require:1 desc:分类id * @method POST */ public function marketDelete() { $param=$this->request->param(); $re=Db::name('market')->where('id',$param['id'])->delete(); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 筛选条件(添加) * @description * @author panhaowen * @url /portal/market/classify * @method POST * @param name:type type:int require:1 desc:字段类型 */ public function classify() { $param=$this->request->param(); $classify=Db::name('type')->where('id',$param['type'])->find()['classify']; $classify=explode(',',$classify); $data=Db::name('classify')->where('id','in',$classify)->select(); $this->success('获取信息成功',$data); } /** * @title 筛选条件(列表) * @description * @author panhaowen * @url /portal/market/classifyIndex * @method POST * @param name:id type:int require:1 desc:分类id */ public function classifyIndex() { $param=$this->request->param(); $classify=explode(',',Db::name('market')->where('id',$param['id'])->find()['selected']); $data=Db::name('classify')->where('id','in',$classify)->select()->toArray(); $arr=[]; // $arr['id']=$classify; foreach ($data as $k=>$v){ $arr[$v['name']]=Db::name('classify_value')->where(['market_id'=>$param['id'],'classify_id'=>$v['id']])->select(); } $this->success('获取信息成功',$arr); } /** * @title 添加筛选字段 * @description * @author panhaowen * @url /portal/market/classifyAdd * @method POST * @param name:id type:int require:1 desc:筛选字段id * @param name:category_id type:int require:1 desc:分类id * @param name:name type:varchar require:1 desc:筛选名称 */ public function classifyAdd() { $param=$this->request->param(); $re=Db::name('classify_value')->insert(['market_id'=>$param['category_id'],'create_time'=>time(),'classify_id'=>$param['id'],'value'=>$param['name']]); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 删除筛选字段 * @description * @author panhaowen * @url /portal/market/classifyDelete * @param name:id type:int require:1 desc:筛选字段值id * @method POST */ public function classifyDelete() { $param=$this->request->param(); $re=Db::name('classify_value')->where('id',$param['id'])->delete(); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 添加营销 * @description * @author panhaowen * @url /portal/market/marketBusinessAdd * @method POST * @param name:market_id type:int require:1 desc:上级分类id */ public function marketBusinessAdd() { $param=$this->request->param(); $type=Db::name('market')->where('id',$param['market_id'])->find()['type']; $classify=Db::name('type')->where('id',$type)->find()['classify']; $data=Db::name('classify')->where('id','in',explode(',',$classify))->select(); $this->success('获取信息成功',$data); } /** * @title 添加营销提交 * @description 添加营销提交 * @author panhaowen * @url /portal/market/marketBusinessAddPost * @method POST * @param name:market_id type:int require:1 desc:上级分类id */ public function marketBusinessAddPost() { $param=$this->request->param(); $param['create_time']=time(); $re=Db::name('market_business')->insert($param); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 编辑营销 * @description * @author panhaowen * @url /portal/market/marketBusinessEdit * @method POST * @param name:id type:int require:1 desc:媒体id */ public function marketBusinessEdit() { $param=$this->request->param(); $data=Db::name('market_business')->where('id',$param['id'])->find(); $this->success('获取信息成功',$data); } /** * @title 编辑营销提交 * @description * @author panhaowen * @url /portal/market/marketBusinessEditPost * @method POST * @param name:id type:int require:1 desc:媒体id */ public function marketBusinessEditPost() { $param=$this->request->param(); $re=Db::name('market_business')->where('id',$param['id'])->update($param); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 删除营销 * @description * @author panhaowen * @url /portal/market/marketBusinessDelete * @param name:id type:int require:1 desc:媒体id * @method POST */ public function marketBusinessDelete() { $param=$this->request->param(); $re=Db::name('market_business')->where('id',$param['id'])->delete(); if ($re){ $this->success('操作成功'); }else{ $this->error('操作失败'); } } /** * @title 营销(列表) * @description * @author panhaowen * @url /portal/market/marketBusiness * @param name:market_id type:int require:1 desc:分类id * @method POST */ public function marketBusiness() { $param=$this->request->param(); $data=Db::name('market_business')->where('market_id',$param['market_id'])->paginate(10); $this->success('获取信息成功',$data); } }