api-auth/src/Auth/DataAccess/LuticateUsersDataAccess.php

<?php

namespace Luticate\Auth\DataAccess;

use Luticate\Utils\LuDataAccess;
use Luticate\Auth\DataAccess\Models\LuticateUsers;
use Luticate\Auth\DBO\LuticateUsersDbo;

class LuticateUsersDataAccess extends LuDataAccess {
    protected static function getModel()
    {
        return new LuticateUsers();
    }

    protected static function getOrderBy()
    {
        return array(array("username", "ASC"));
    }

    protected static function getQueryPredicate($query)
    {
        return array(array("username", "ilike", "%" . $query . "%", "or"),
            array("firstname", "ilike", "%" . $query . "%", "or"),
            array("lastname", "ilike", "%" . $query . "%", "or"),
            array("email", "ilike", "%" . $query . "%", "or"));
    }

    /**
     * @param $username string
     * @return LuticateUsersDbo|null
     */
    public static function getByUsernameOrEmail($username)
    {
        $user = LuticateUsers::where("username", "=", $username)->orWhere("email", "=", $username)->first();
        if (is_null($user))
            return null;
        return $user->toDbo();
    }
}