mall/models/UserNodeDepartment.php

<?php
/**
 * 厦门云联储网络科技有限公司
 * https://www.baokuaiyun.com
 * Copyright (c) 2023 爆块云 All rights reserved.
 */

namespace app\models;

use Yii;
use yii\helpers\ArrayHelper;

/**
 * This is the model class for table "{{%user_node_department}}".
 *
 * @property integer $id
 * @property integer $store_id
 * @property integer $user_id
 * @property integer $child_id
 * @property integer $is_leader
 * @property string $department_key
 * @property integer $created_at
 */
class UserNodeDepartment extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%user_node_department}}';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['store_id', 'user_id', 'child_id', 'is_leader', 'department_key', 'created_at'], 'integer'],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'store_id' => '店铺id',
            'user_id' => '用户id',
            'child_id' => '下级id',
            'is_leader' => '是否队长',
            'department_key' => '部门 key',
            'created_at' => '创建时间',
        ];
    }

    public static function createUserNodeDepartment($user_node)
    {
        if (!$user_node->parent_id && !$user_node->parent_node) {
            //debug_log([__METHOD__, __LINE__, "用户：{$user_node['user_id']}，上级&父节点不存在"], __CLASS__ . '.log');
            return;
        }
        // 先把绑定节点关系存储
        // $to_user_department = new UserNodeDepartment();
        // $to_user_department->store_id = $user_node->store_id;
        // $to_user_department->user_id = $to_user_id;
        // $to_user_department->child_id = $user_node->user_id;
        // $to_user_department->is_leader = $is_leader;
        // $to_user_department->department_key = $department_key;
        // $to_user_department->created_at = time();
        // $to_user_department->save();

        // 最近的队长
        $last_leader = UserStringCodePlus::getLastParentNodeLeader($user_node->user_id);

        // 所有节点上级
        $recommon_relation_node = trim($user_node['recommend_relation_node'], ',');
        if (!$recommon_relation_node) return;
        $all_parent_node_ids = explode(',', $recommon_relation_node);

        foreach ($all_parent_node_ids as $parent_node_id) {
            // if ($parent_node_id == $to_user_id) return;

            $model = new UserNodeDepartment();
            $model->store_id = $user_node->store_id;
            $model->user_id = $parent_node_id;
            $model->child_id = $user_node->user_id;

            if ($parent_node_id == $last_leader['parent_node']) {
                $model->is_leader = 0;
                $model->department_key = $user_node->node_key;
                $model->created_at = $user_node->created_at;
            } else {
                $model->is_leader = 0;
                $model->department_key = 0;
                $model->created_at = $user_node->created_at;
            }
            $model->save();
        }
    }

}