<?php
|
|
namespace app\shop\model\store;
|
|
use app\common\model\store\Store as StoreModel;
|
use Lvht\GeoHash;
|
|
/**
|
* 门店模型
|
*/
|
class Store extends StoreModel
|
{
|
/**
|
* 隐藏字段
|
* @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;
|
}
|
}
|
