<?php
|
|
namespace app\admin\controller;
|
|
use app\supplier\model\GoodsAnnex;
|
use think\facade\Config;
|
use think\facade\Db;
|
use think\facade\Request;
|
use think\facade\View;
|
use think\Exception;
|
|
class GoodsBrand extends Common {
|
/*
|
* 品牌管理
|
*/
|
public function index(): string {
|
View::assign('menuitem', strtolower('goodsBrand-index'));
|
$other['title'] = '品牌管理';
|
$guide['one']['text'] = '数据审核';
|
$guide['two']['text'] = '品牌审核';
|
$guide['two']['url'] = url('/admin/supplier/index')->build();
|
View::assign('guide', $guide);
|
View::assign('other', $other);
|
return View::fetch('index');
|
}
|
|
/*
|
* 获取商品品牌列表
|
*/
|
public function getGoodsBrandList() {
|
try {
|
if (!Request::isPost()) {
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$kw = input('kw');
|
$condition['istemp'] = 1;
|
$condition['finish_status'] = 1;
|
$condition['status'] = 0;
|
if (!empty($kw)) {
|
$condition[] = array('brand_name', 'like', "%$kw%");
|
}
|
$p = input('page', 1);
|
$_GET['p'] = $p;
|
$other['page_size'] = input('page_size', 20);
|
$order = 'id desc';
|
$count = Db::name('goods_brand')->where($condition)->count();
|
$list = Db::name('goods_brand')->field("*")->where($condition)->order($order)->page($p, $other['page_size'])->select()->toArray();
|
$other['count'] = $count;
|
if (!$list) {
|
$list = [];
|
}
|
$result['code'] = 200;
|
$result['list'] = $list;
|
$result['other'] = $other;
|
return $this->successResponse($result);
|
|
} catch (\Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
|
/*
|
* 获取品牌证书列表
|
*/
|
public function getBrandCertList() {
|
try {
|
if (!Request::isPost()) {
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$brand_id = input('brand_id');
|
$where['brand_id'] = $brand_id;
|
$list = Db::name('goods_brand_cert')->field('id,title,filename,filesize,ext')->where($where)->withAttr('filesize', function ($value) {
|
return getsizebytype($value);
|
})->order('id asc')->select()->toArray();///
|
if ($list) {
|
$result['list'] = $list;
|
return $this->successResponse($result);
|
} else {
|
throw new Exception(lang('no_data_found'));
|
}
|
} catch (\Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
|
/*
|
* 获取品牌协议列表
|
*/
|
public function getBrandAgreementList() {
|
try {
|
if (!Request::isPost()) {
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$brand_id = input('brand_id');
|
$where['brand_id'] = $brand_id;
|
$list = Db::name('goods_brand_agreement')->field('id,title,filename,filesize,ext')->where($where)->withAttr('filesize', function ($value) {
|
return getsizebytype($value);
|
})->order('id asc')->select()->toArray();///
|
if ($list) {
|
$result['list'] = $list;
|
return $this->successResponse($result);
|
} else {
|
throw new Exception(lang('no_data_found'));
|
}
|
} catch (\Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
|
/*
|
* 获取品牌备案范围列表
|
*/
|
public function getGoodsBrandFilingsList() {
|
try {
|
if (!Request::isPost()) {
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$brand_id = input('brand_id');
|
$where['GBF.brand_id'] = $brand_id;
|
$list = Db::name('goods_brand_filings')
|
->alias('GBF')
|
->join('stock_country SC', 'GBF.stock_country_id=SC.id')
|
->join('dis_platform DP', 'GBF.dis_platform_id=DP.id')
|
->field('GBF.*,SC.country,DP.platform_name')->where($where)->order('GBF.id asc')->select()->toArray();///
|
if ($list) {
|
$result['list'] = $list;
|
return $this->successResponse($result);
|
} else {
|
throw new Exception(lang('no_data_found'));
|
}
|
} catch (\Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
/**
|
* 品牌审核
|
* @return array|int[]
|
*/
|
public function reviewGoodsBrand() {
|
// 开始数据库事务
|
Db::startTrans();
|
try {
|
if (!Request::isPost()) {
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$brand_id = input('post.brand_id');
|
if (is_numeric($brand_id)) {
|
$status = input('post.status');
|
//更新数据
|
$info = Db::name('goods_brand')->field('id,status')->where('id', $brand_id)->find();
|
if (!$info) {
|
throw new Exception(lang('no_data_found'));
|
}
|
if ($info['status'] == 1) {
|
throw new Exception('该申请已审核通过，不能重复审核');
|
}
|
if ($status == 1) {
|
Db::name('goods_brand')->where('id', $brand_id)->update(['status' => 1]);
|
$message = '操作成功，审核通过';
|
} else {
|
Db::name('goods_brand')->where('id', $brand_id)->update(['status' => 2]);
|
$message = '操作成功，审核不通过';
|
}
|
// 提交事务
|
Db::commit();
|
return $this->successResponse($message);
|
} else {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
} catch (Exception $exc) {
|
// 回滚事务
|
Db::rollback();
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
}
|
