title = '供货商商品列表'; $supplier_id = input('get.supplier_id'); $company_id = input('get.company_id'); $third_classify = input('get.third_classify'); $this->supplier_id = $supplier_id; $this->supplier_list = \app\common\model\Supplier::getSupplierName(0); //$this->company_list = \app\common\model\Company::getCompanyName(); $where = []; $where[] = ['a.is_deleted','=',0]; if($supplier_id)$where[] = ['a.supplier_id','=',$supplier_id]; if($company_id)$where[] = ['a.company_id','=',$company_id]; if($third_classify)$where[] = ['a.third_classify','=',$third_classify]; $query = $this->_query($this->table)->where($where)->like('a.name')->alias('a')->field('a.*,b.title supplier_name ,c.title company_name'); $query->leftJoin('Supplier b','b.id = a.supplier_id')->leftJoin('Company c','c.id = a.company_id'); $query->order(' a.sort desc , a.id desc')->page(); } /** * 数据列表处理 * @auth true * @menu true * @param array $data * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ protected function _index_page_filter(&$data) { } /** * 添加供货商商品 * @auth true * @menu true * @throws \think\Exception * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @throws \think\exception\PDOException */ public function add() { $this->title = '添加供货商商品'; $this->supplier_id = input('supplier_id'); $this->_form($this->table, 'form'); } /** * 编辑供货商商品 * @auth true * @menu true * @throws \think\Exception * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @throws \think\exception\PDOException */ public function edit() { $this->title = '编辑供货商商品'; $this->supplier_id = input('supplier_id'); $this->_form($this->table, 'form'); } /** * 启用 * @auth true * @menu true * @throws \think\Exception * @throws \think\exception\PDOException */ public function enable() { $this->_save($this->table, ['status' => 1]); $this->success('已上架!'); } /** * 禁用 * @auth true * @menu true * @throws \think\Exception * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @throws \think\exception\PDOException */ public function forbidden() { $this->_save($this->table, ['status' => 0]); $this->success('已下架!'); } /** * 删除 * @auth true * @menu true * @throws \think\Exception * @throws \think\exception\PDOException */ public function del() { $this->_save($this->table, ['is_deleted' => 1]); } /** * 表单数据处理 * @auth true * @menu true * @param array $data */ protected function _form_filter(&$data) { if($this->request->isGet()) { $third_classify = input('third_classify'); if($third_classify) { if($third_classify) $data['third_classify'] = $third_classify; $third_info = \app\common\model\SupplierCate::where('id',$third_classify)->find()->toArray(); if($third_classify) $data['second_classify'] = $third_info['pid']; $data['first_classify'] = \app\common\model\SupplierCate::where('id',$data['second_classify'])->value('pid'); } $supplier_id = input('supplier_id'); if($supplier_id) $data['supplier_id'] = $supplier_id; } // 视频 $this->video_list = \app\common\model\VideoIntro::with('videoArr') ->where(['is_deleted'=>0])->order('id desc') ->select()->toArray(); // 文章列表 $this->article_list = \app\common\model\ArticleIntro::with('itemChildren') ->field('id,title') ->where(['is_deleted'=>0])->order('id desc') ->select()->toArray(); // 资料 $this->datum_list = DatumIntro::with('urlArr') ->where(['is_deleted'=>0])->order('id desc') ->select()->toArray(); $data['create_at'] = date('Y-m-d H:i:s'); $this->supplier_list = \app\common\model\Supplier::getSupplierName(0); // $this->company_list = \app\common\model\Company::getCompanyName(); $all_cate = \app\common\model\SupplierCate::where(['is_deleted'=>0])->order('sort desc ,id desc')->select(); $this->goods_cate = make_tree($all_cate); if($this->request->isPost()) { list($post) = [$this->request->post()]; if(!$data['release_time']) $data['release_time'] = date("Y-m-d H:i:s"); if(!empty($post['phone'])) { $user_id = User::where('phone|email',$post['phone'])->value('id'); if(!$user_id) $this->error('账号未注册'); $data['user_id'] = $user_id; }else{ $data['user_id'] = ''; } } } protected function _form_result($id) { if($this->request->action() == 'add'){ $supplier_name = \app\common\model\Supplier::where('id',$this->request->post('supplier_id'))->value('title'); if($supplier_name)PlatformSwitch::followMsg(5,$this->request->post('supplier_id'),$supplier_name,$this->request->post('title'),$id); } $this->success('操作成功', 'javascript:history.back()'); } }