<?php
|
|
namespace app\operations\model\store;
|
|
use app\common\model\store\Store as StoreModel;
|
use Lvht\GeoHash;
|
|
/**
|
* 门店模型
|
*/
|
class Store extends StoreModel
|
{
|
// 定义全局的查询范围
|
protected $globalScope = ['status'];
|
public function scopeStatus($query)
|
{
|
$shop_supplier_ids = \app\operations\model\supplier\Supplier::getSupplierIdsByUser(session('jjjshop_operations')['user']);
|
if (empty($shop_supplier_ids)){
|
$query->where($query->getTable() . '.shop_supplier_id', -1);
|
}else{
|
$query->where($query->getTable() . '.shop_supplier_id', 'in', $shop_supplier_ids);
|
}
|
}
|
/**
|
* 隐藏字段
|
* @var array
|
*/
|
protected $hidden = [
|
'app_id',
|
'update_time',
|
];
|
/**
|
* 获取列表数据
|
*/
|
public function getList($data = null, $status = '')
|
{
|
$model = $this;
|
if(isset($data["is_good"]) && $data["is_good"]>-1){
|
$model = $model->where('is_good', '=', (int)$data["is_good"]);
|
}
|
if(!empty($data["store_name"])){
|
$model = $model->where('store_name', '=', $data["store_name"]);
|
}
|
if(isset($data['shop_supplier_ids'])&&$data['shop_supplier_ids']){
|
$model = $model->where('s.shop_supplier_id', 'in', $data['shop_supplier_ids']);
|
}
|
!empty($status) && $model = $model->where('status', '=', (int)$status);
|
return $model->alias("s")->with(['logo', 'supplier'])
|
->join('supplier supplier', 's.shop_supplier_id = supplier.shop_supplier_id', 'left')
|
->where('s.is_delete', '=', '0')
|
->where('supplier.is_delete', '=', '0')
|
->order(['s.sort' => 'asc', 's.create_time' => 'desc'])
|
->paginate($data);
|
}
|
|
/**
|
* 获取所有门店列表
|
*/
|
public static function getAllList()
|
{
|
return (new self)->where('is_delete', '=', '0')
|
->order(['sort' => 'asc', 'create_time' => 'desc'])
|
->select();
|
}
|
|
/**
|
* 获取所有门店ids
|
*/
|
public static function getStoreIds($shop_supplier_id=0)
|
{
|
$model = new self;
|
if(!empty($shop_supplier_id)){
|
$model->where('shop_supplier_id', '=', $shop_supplier_id);
|
}
|
return $model->where('is_delete', '=', '0')
|
->column("store_id");
|
}
|
|
/**
|
* 新增记录
|
*/
|
public function add($data)
|
{
|
$data = $this->createData($data);
|
return self::create($data);
|
}
|
|
/**
|
* 编辑记录
|
*/
|
public function edit($data)
|
{
|
return $this->save($this->createData($data));
|
}
|
|
/**
|
* 软删除
|
*/
|
public function setDelete($where)
|
{
|
return self::update(['is_delete' => 1], $where);
|
}
|
|
/**
|
* 创建数据
|
*/
|
private function createData($data)
|
{
|
$data['app_id'] = self::$app_id;
|
// 格式化坐标信息
|
$coordinate = explode(',', $data['coordinate']);
|
$data['latitude'] = $coordinate[0];
|
$data['longitude'] = $coordinate[1];
|
|
// 生成geohash
|
$Geohash = new Geohash;
|
$data['geohash'] = $Geohash->encode($data['longitude'], $data['latitude']);
|
return $data;
|
}
|
}
|
