<?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;
    }
}