<?php

namespace app\api\model\store;

use app\common\model\store\Store as StoreModel;

/**
 * 商家门店模型
 */
class Store extends StoreModel
{
    /**
     * 隐藏字段
     */
    protected $hidden = [
        'is_delete',
        'app_id',
        'create_time',
        'update_time'
    ];

    /**
     * 获取门店列表
     */
    public function getList($is_check = null, $longitude = '', $latitude = '', $limit = false, $shop_supplier_id = 0)
    {
        $model = $this;
        // 是否支持自提核销
        $is_check && $model = $model->where('is_check', '=', $is_check);
        // 商家id
        $shop_supplier_id && $model = $model->where('shop_supplier_id', '=', $shop_supplier_id);
        // 获取数量
        $limit != false && $model = $model->limit($limit);
        // 获取门店列表数据
        $data = $model->where('is_delete', '=', '0')
            ->where('status', '=', '1')
            ->order(['sort' => 'asc', 'create_time' => 'desc'])
            ->select();
        // 根据距离排序
        if (!empty($longitude) && !empty($latitude)) {
            $map = $this->mapChange($latitude,$longitude);
            return $this->sortByDistance($data, $map['lng'], $map['lat']);
        }
        return $data;
    }

    /**
     * 根据距离排序
     */
    private function sortByDistance(&$data, $longitude, $latitude)
    {
        // 根据距离排序
        $list = $data->isEmpty() ? [] : $data->toArray();
        $sortArr = [];
        foreach ($list as &$store) {
            if (empty($store['longitude']) || empty($store['latitude'])) {// 排序列
                $sortArr[] = 0;
                continue;
            }
            // 计算距离
            $distance = self::getDistance($longitude, $latitude, $store['longitude'], $store['latitude']);
            // 排序列
            $sortArr[] = $distance;
            $store['distance'] = $distance;
            if ($distance >= 1000) {
                $distance = bcdiv($distance, 1000, 2);
                $store['distance_unit'] = $distance . 'km';
            } else {
                $store['distance_unit'] = $distance . 'm';
            }
        }
        // 根据距离排序
        array_multisort($sortArr, SORT_ASC, $list);
        return $list;
    }

    /**
     * 获取两个坐标点的距离
     */
    private static function getDistance($ulon, $ulat, $slon, $slat)
    {
        // 地球半径
        $R = 6378137;
        // 将角度转为狐度
        $radLat1 = deg2rad($ulat);
        $radLat2 = deg2rad($slat);
        $radLng1 = deg2rad($ulon);
        $radLng2 = deg2rad($slon);
        // 结果
        $s = acos(cos($radLat1) * cos($radLat2) * cos($radLng1 - $radLng2) + sin($radLat1) * sin($radLat2)) * $R;
        // 精度
        $s = round($s * 10000) / 10000;
        return round($s);
    }

    /**
     * 根据门店id集获取门店列表
     */
    public function getListByIds($storeIds)
    {
        $model = $this;
        // 筛选条件
        $filter = ['store_id' => ['in', $storeIds]];
        if (!empty($storeIds)) {
            $model = $model->orderRaw('field(store_id, ' . implode(',', $storeIds) . ')');
        }
        // 获取商品列表数据
        return $model->with(['logo'])
            ->where('is_delete', '=', '0')
            ->where('status', '=', '1')
            ->where($filter)
            ->select();
    }
    
    /**
     * 腾讯地图---->百度地图
     * @param double $lat 纬度
     * @param double $lng 经度
     */
    private function mapChange($lat, $lng)
    {
        $x_pi = 3.14159265358979324 * 3000.0 / 180.0;
        $x = $lng;
        $y = $lat;
        $z = sqrt($x * $x + $y * $y) + 0.00002 * sin($y * $x_pi);
        $theta = atan2($y, $x) + 0.000003 * cos($x * $x_pi);
        $lng = $z * cos($theta) + 0.0065;
        $lat = $z * sin($theta) + 0.006;
        return array('lng' => $lng, 'lat' => $lat);
    }

    /**
     * 根据门店id集获取门店列表
     */
    public function getListByStoreIds($storeIds, $longitude, $latitude)
    {
        // 获取列表数据
        $data = $this->with(['logo'])
            ->where('is_delete', '=', '0')
            ->where('status', '=', '1')
            ->where('store_id', 'in', $storeIds)
            ->select();
        // 根据距离排序
        if (!empty($longitude) && !empty($latitude)) {
            return $this->sortByDistance($data, $longitude, $latitude);
        }
        return $data;
    }

	/**
	 * 资金冻结
	 */
	public function freezeMoney($money)
	{
	    return $this->save([
	        'money' => $this['money'] - $money,
	        'freeze_money' => $this['freeze_money'] + $money,
	    ]);
	}

    /**
	 * 门店列表（分页）
	 */
    public function storeList($param)
    {
        // 排序规则
        $sort = [];
        if ($param['sortType'] === 'all') {
            $sort = ['s.create_time' => 'desc'];
        } else if ($param['sortType'] === 'letter') {
            $sort = ['letter' => 'asc']; // 首字母
        }

        $model = $this;
        if (isset($param['search']) && $param['search']) {
            $model = $model->where('store_name', 'like', '%' . $param['search'] . '%');
        }

        // 查询列表数据
        $list = $model->order($sort)
            ->where('is_delete', '=', '0')
            ->where('status', '=', '1')
            ->paginate($param);
        return $list;
    }

    /**
     * 根据商户id获取门店id
     */
    public static function getStoreIdBySupplierId($supplierId)
    {
        $model = new static();
        // 获取列表数据
        $data = $model->with(['logo'])
            ->where('is_delete', '=', '0')
            ->where('status', '=', '1')
            ->where('shop_supplier_id', '=', $supplierId)
            ->find();
        return empty($data) ? '' : $data["store_id"];
    }
}