<?php

namespace app\common\model\supplier;

use app\common\model\BaseModel;
use app\common\model\shop\Role as RoleModel;
use app\common\model\supplier\member\Member as MemberModel;
use app\common\model\supplier\PointsLog as PointsLogModel;
use app\shop\model\auth\UserRole as UserRoleModel;

/**
 * 商家供应商模型
 */
class Supplier extends BaseModel
{
    protected $name = 'supplier';
    protected $pk = 'shop_supplier_id';


    /**
     * 关联应用表
     */
    public function app()
    {
        return $this->belongsTo('app\\common\\model\\app\\App', 'app_id', 'app_id');
    }

    /**
     * 关联logo
     */
    public function logo()
    {
        return $this->hasOne('app\\common\\model\\file\\UploadFile', 'file_id', 'logo_id');
    }
    /**
     * 关联企业微信二维码
     */
    public function qyQrcode()
    {
        return $this->hasOne('app\\common\\model\\file\\UploadFile', 'file_id', 'qy_qrcode_id');
    }
    /**
     * 关联品牌类型
     */
    public function category()
    {
        return $this->hasOne('app\\common\\model\\supplier\\Category', 'category_id', 'category_id');
    }
    /**
     * 关联business
     */
    public function business()
    {
        return $this->hasOne('app\\common\\model\\file\\UploadFile', 'file_id', 'business_id');
    }
    /**
     * 关联超管
     */
    public function superUser()
    {
        return $this->hasOne('app\\common\\model\\supplier\\User', 'shop_supplier_id', 'shop_supplier_id')
            ->where('is_super','=', 1);
    }
    /**
     * 详情
     */
    public static function detail($shop_supplier_id, $with = [])
    {
        return (new static())->with($with)->find($shop_supplier_id);
    }

    /**
     * 累积供应商结算金额 (批量)
     */
    public function onBatchIncSupplierMoney($data)
    {
        foreach ($data as $supplierId => $supplierMoney) {
            $this->where(['shop_supplier_id' => $supplierId])
                ->inc('total_money', $supplierMoney)
                ->inc('money', $supplierMoney)
                ->update();
        }
        return true;
    }

    /**
     * 累积商户的可用积分
     */
    public function setIncPoints($points, $describe, $decPoints = 0)
    {
        // 新增积分变动明细
        PointsLogModel::add([
            'shop_supplier_id' => $this['shop_supplier_id'],
            'value' => $points,
            'describe' => $describe,
            'app_id' => $this['app_id'],
        ]);

        // 更新用户可用积分
        $data['points'] = ($this['points'] + $points + $decPoints <= 0) ? 0 : $this['points'] + $points + $decPoints;
        $this->where('branch_id', '=', $this['branch_id'])->update($data);
        
        return true;
    }

    //判断营业时间
    public function supplierStatus($shop_supplier_id)
    {
        $supplier = $this->where('shop_supplier_id', '=', $shop_supplier_id)
            ->where('is_delete', '=', 0)
            ->find();
        //是否开启营业
        if (!$supplier || $supplier['status'] != 0) {
            return false;
        }
        //判断是否设置了营业时间
        $business_start_time= $supplier['business_start_time'];
        $business_end_time = $supplier['business_end_time'];
        if (empty($business_start_time) || empty($business_end_time)) {
            return true;
        }

        //营业时间
        $start_time = strtotime($business_start_time);
        $end_time = strtotime($business_end_time);
        if($end_time >= $start_time){
            //结束时间大于开始时间
            if (!(time() >= $start_time && time() <= $end_time)) {
                return false;
            }
        }else{
            //开始的时间大于结束时间，即是营业到凌晨
            if (time() >= $end_time && time() <= $start_time) {
                return false;
            }
        }

        return true;
    }

    /**
     * 通过角色管理的区域获取商户id
     */
    public static function getSupplierIdsByUser($user)
    {

        $model = new static();
        //获取用户所有的角色
        $user_role_ids = (new UserRoleModel())::getRoleIds($user['shop_user_id']);
        if(!empty($user_role_ids)){
            //获取所有角色的权限
            $area_arr =RoleModel::getAreaIdsByRoleIds($user_role_ids);
            if(!empty($area_arr)){
                $area_ids = [];
                foreach ($area_arr as $val){
                    if(!is_array($val)){
                        $val = json_decode($val,true);
                    }
                    if(empty($area_ids)){
                        //第一个角色所管理的区域
                        $area_ids = $val;
                    }else{
                        //合并角色管理的区域
                        $area_ids = array_merge($area_ids, $val);
                    }
                }
                if(!empty($area_ids)){
                    //获取加盟商入驻时所选的区域
                    return $model->where('area_id',"in",$area_ids)
                        ->column("shop_supplier_id");
                }
            }

        }
        return [];
    }

    /**
     * 获取供应商当前有效的年卡
     */
    public function getCurrentMember()
    {
        return MemberModel::getCurrentMember($this['shop_supplier_id'], $this['app_id']);
    }
    
    /**
     * 获取角色管理的区域
     */
    public static function getAreaIdsByUser($user)
    {
        //获取用户所有的角色
        $user_role_ids = (new UserRoleModel())::getRoleIds($user['shop_user_id']);
        if(!empty($user_role_ids)){
            //获取所有角色的权限
            $area_arr =RoleModel::getAreaIdsByRoleIds($user_role_ids);
            if(!empty($area_arr)){
                $area_ids = [];
                foreach ($area_arr as $val){
                    if(!is_array($val)){
                        $val = json_decode($val,true);
                    }
                    if(empty($area_ids)){
                        //第一个角色所管理的区域
                        $area_ids = $val;
                    }else{
                        //合并角色管理的区域
                        $area_ids = array_merge($area_ids, $val);
                    }
                }
                return $area_ids;
            }

        }
        return [];
    }

    //获取自营的商户 by yj 2024.1.9
    public static function getSupplierSelfSupport()
    {
        $model = new static();
        $supplier = $model->where('store_type', '=', 20)
            ->where('is_delete', '=', 0)
            ->column("shop_supplier_id");
        return $supplier;
    }

    //获取名称获取准确的商户 by yj 2024.2.28
    public static function getSupplierIdByName($name)
    {
        $model = new static();
        $supplier = $model->where('name', '=', $name)
            ->where('is_delete', '=', 0)
            ->find();
        return empty($supplier) ? '-1' : $supplier["shop_supplier_id"];
    }

    /**
     * 商户独立收款是否开启 by yj 2024.8.6
     */
    public static function getIndependentOpen($shop_supplier_id)
    {
        $model = new static();
        $data = $model->where('shop_supplier_id', '=', $shop_supplier_id)
            ->where('is_delete', '=', 0)
            ->find();
        return empty($data['is_independent']) ? 0 : $data['is_independent'];
    }
    /**
     * 冻结用户资金
     */
    public function freezeMoney($money)
    {
        $this->save(['money' => $this['money'] - $money,'freeze_money'=>$this['freeze_money']+$money]);
    }
    /**
     * 直推供应商多少人
     */
    public function refereeSupplierCount ($referee_id)
    {
        $count = $this->where('referee_id', '=', $referee_id)
            ->where('is_delete', '=', 0)
            ->count();
        return $count;
    }

    /**
     * 下级商户数量
     * @param $user_id
     * @return int
     */
    public function getSubordinateNum($user_id)
    {
        return (new static())->where('is_delete', '=', 0)
            ->where('referee_id', 'in', $user_id)
            ->count();
    }

}