Expresso Livre Tools

<?php

namespace App\Commons;

use LdapRecord\Connection;

use Illuminate\Support\Facades\DB;

class Ldap 

{

    private $conn;

    private $ldapBaseDn;

    public function __construct()

    {

        $this->conn = "";

        $configEAdmin = DB::connection('pgsql-expresso')->table('phpgw_emailadmin')

                                ->where('description', env('KEY_EMAILADMIN_SOGO') )

                                ->first();

        // Base DN                                

        $this->ldapBaseDn = $configEAdmin->smtpldapbasedn;

        $this->conn = new Connection([

            'hosts'    => [ $configEAdmin->smtpldapserver ],

            'base_dn'  => $configEAdmin->smtpldapbasedn,

            'username' => $configEAdmin->smtpldapadmindn,

            'password' => $configEAdmin->smtpldapadminpw,

        ]);

    }

    public function getUidNumber( string $user )

    {

        $query = $this->conn->query()

                    ->select('uidnumber')

                    ->where('uid','=', $user)

                    ->get();

        return $query[0]['uidnumber'][0] ?? false ;

    }

    public function getUid( string $user )

    {

        $query = $this->conn->query()

                    ->select('uid')

                    ->where('uidnumber','=', $user)

                    ->get();

        return $query[0]['uid'][0] ?? false ;

    }

    public function getUsersOu( string $organization )

    {

        $baseDn = "ou=".$organization.",".$this->ldapBaseDn;

        $query = $this->conn->query()

                    ->setDn( $baseDn )

                    ->select('cn', 'uid', 'uidnumber')

                    ->where([

                        ['phpgwaccounttype', '=', 'u'],

                        ['phpgwaccountstatus', '=', 'A']

                    ])->get();                    

        return $query;

    }

}