<?php
|
|
namespace app\api\model\supplier;
|
|
use app\common\model\plus\shareholder\Apply as ShareholderApplyModel;
|
use app\common\model\supplier\Supplier as SupplierModel;
|
use app\common\model\supplier\User as SupplierUserModel;
|
use app\api\model\user\Favorite as FavoriteModel;
|
use app\api\model\product\Product as ProductModel;
|
use app\api\model\plus\team\Apply as teamApplyModel;
|
/**
|
* 供应商模型类
|
*/
|
class Supplier extends SupplierModel
|
{
|
/**
|
* 添加
|
*/
|
public function addData($data)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
if (SupplierUserModel::checkExist($data['user_name'])) {
|
$this->error = '用户名已存在';
|
return false;
|
}
|
// 添加供应商
|
$this->save($data);
|
//添加供应商账号
|
$SupplierUserModel = new SupplierUserModel;
|
$data['shop_supplier_id'] = $this['shop_supplier_id'];
|
$data['is_super'] = 1;
|
$SupplierUserModel->save($data);
|
(new teamApplyModel())->becomeTeamByAgent($data['referee_id'],70,$data['app_id']);
|
//根据团队人数判断股东 by yj
|
$shareholderModel = new ShareholderApplyModel;
|
$shareholderModel->becomeShareholderByTeam($data['referee_id'], 80, $data['app_id']);
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
public function getUserName($user_name)
|
{
|
return $this->where('user_name', '=', $user_name)->count();
|
}
|
|
//获取店铺信息
|
public function getDetail($data, $user)
|
{
|
$detail = $this->alias('s')->where(['shop_supplier_id' => $data['shop_supplier_id']])
|
->field("name as store_name,shop_supplier_id,logo_id,category_id,server_score,fav_count,user_id,product_sales,address,notice,description")
|
->with(['logo', 'category'])
|
->find();
|
if ($detail) {
|
$detail['logos'] = $detail['logo']?$detail['logo']['file_path']:'';
|
$detail['category_name'] = $detail['category']['name'];
|
unset($detail['logo']);
|
unset($detail['category']);
|
$detail['isfollow'] = 0;
|
$detail['notice'] = empty($detail['notice']) ? '欢迎光临' . $detail['store_name'] . '~' : $detail['notice'];
|
$detail['supplier_user_id'] = (new SupplierUserModel())->where('shop_supplier_id', '=', $detail['shop_supplier_id'])->value('supplier_user_id');
|
if ($user) {
|
$detail['isfollow'] = (new FavoriteModel)
|
->where('pid', '=', $data['shop_supplier_id'])
|
->where('user_id', '=', $user['user_id'])
|
->where('type', '=', 10)
|
->count();
|
}
|
}
|
return $detail;
|
}
|
|
//获取微店账号信息
|
public function getAccount($shop_supplier_id, $field = "*")
|
{
|
$detail = $this->where(['shop_supplier_id' => $shop_supplier_id])->field("$field")->find();
|
return $detail;
|
}
|
|
//店铺列表
|
public function supplierList($param)
|
{
|
// 排序规则
|
$sort = [];
|
if ($param['sortType'] === 'all') {
|
$sort = ['s.create_time' => 'desc'];
|
} else if ($param['sortType'] === 'sales') {
|
$sort = ['product_sales' => 'desc'];
|
} else if ($param['sortType'] === 'score') {
|
$sort = ['server_score' => 'desc'];
|
}
|
|
$model = $this;
|
if (isset($param['name']) && $param['name']) {
|
$model = $model->where('name', 'like', '%' . $param['name'] . '%');
|
}
|
if (isset($param['category_id']) && $param['category_id']) {
|
$model = $model->where('category_id', '=', $param['category_id']);
|
}
|
// 查询列表数据
|
$list = $model->alias('s')->with(['logo', 'category'])
|
->where('s.is_delete', '=', '0')
|
->where('s.is_recycle', '=', 0)
|
//->where('s.is_full', '=', 1)
|
->field("s.shop_supplier_id,s.name,s.fav_count,logo_id,category_id,server_score,product_sales,address,link_phone,longitude,latitude")
|
->order($sort)
|
->paginate($param);
|
$product_model = new ProductModel();
|
foreach ($list as $key => &$v) {
|
$productList = $product_model->with(['image.file'])
|
->where([
|
'shop_supplier_id' => $v['shop_supplier_id'],
|
'product_status' => 10,
|
'audit_status' => 10,
|
'is_delete' => 0
|
])
|
->order('product_sort asc,product_id desc')
|
->limit(3)
|
->field('product_id,product_price,product_name,sales_initial,sales_actual,line_price')
|
->select();
|
$v['productList'] = $productList;
|
$v['logos'] = isset($v['logo'])?$v['logo']['file_path']:'';
|
$v['category_name'] = $v['category']['name'];
|
$v['latitude'] = (float)$v['latitude'];
|
$v['longitude'] = (float)$v['longitude'];
|
unset($v['logo']);
|
unset($v['category']);
|
}
|
return $list;
|
}
|
|
//查询用户申请供应商状态
|
public static function getStatus($user)
|
{
|
$apply = (new Apply())->where('user_id', '=', $user['user_id'])
|
->find();
|
$supplier = (new static())->where('user_id', '=', $user['user_id'])
|
->where('is_delete', '=', 0)
|
->count();
|
$status = 0;
|
if ($user['user_type'] == 2) {
|
if ($supplier) {
|
$status = 2;
|
} else {
|
$status = 3;
|
}
|
} else {
|
if ($apply) {
|
if ($apply['status'] == 0) {
|
$status = 1;
|
}
|
}
|
}
|
return $status;
|
}
|
//店铺列表
|
public function getLists($shop_supplier_id='')
|
{
|
$model = $this;
|
// 查询列表数据
|
$list = $model->with(['qyQrcode'])->where('is_delete', '=', '0')
|
->where('is_recycle', '=', 0)
|
->select();
|
if(!empty($list)){
|
foreach ($list as $key => &$val){
|
if($val["shop_supplier_id"] == $shop_supplier_id){
|
$index=$key;
|
}
|
$val["add_group"]="加群";
|
}
|
}
|
$data["list"]=$list;
|
$data["index"]=empty($index) ? '-1' : $index;
|
return $data;
|
}
|
|
//店铺列表(简约)
|
public function getListSimple($params = [])
|
{
|
$model = $this;
|
if (!empty($params['keyword'])) {
|
$model = $model->where('name', 'like', '%'. $params['keyword'] .'%');
|
}
|
return $model->where('is_delete', '=', '0')
|
->where('is_recycle', '=', 0)
|
->order(['create_time' => 'desc'])
|
->paginate($params);
|
}
|
public static function getUserStore($user_id)
|
{
|
$model = new self();
|
return $model->where('user_id', '=', $user_id)
|
->where('is_delete', '=', 0)
|
->where('is_recycle', '=', 0)
|
->find();
|
}
|
}
|
