DepartmentModel::initDepartMent PHP Method

initDepartMent() public method

测试使用
public initDepartMent ( ) : string
return string 插入数据的SQL语句
    public function initDepartMent()
    {
        // 将用户放到第一个部门下
        $data = $this->treeDo->getTree(0);
        $departName = $data['_child'][0]['title'] . '|';
        $departId = $data['_child'][0]['department_id'];
        $sql = "INSERT INTO {$this->tablePrefix}user_profile SELECT uid," . self::FIELD_ID . " AS field_id,'{$departName}' AS field_data,0 AS privacy FROM {$this->tablePrefix}user";
        echo $sql;
        $this->query($sql);
        $sql = "INSERT INTO {$this->tablePrefix}user_department SELECT uid,{$departId} AS department_id FROM {$this->tablePrefix}user";
        $this->query($sql);
        echo $sql;
    }