CommonITILObject::getUsedUserTitleOrTypeBetween PHP Метод

    function getUsedUserTitleOrTypeBetween($date1 = '', $date2 = '', $title = true)
    {
        global $DB;
        $linkclass = new $this->userlinkclass();
        $linktable = $linkclass->getTable();
        if ($title) {
            $table = "glpi_usertitles";
            $field = "usertitles_id";
        } else {
            $table = "glpi_usercategories";
            $field = "usercategories_id";
        }
        $query = "SELECT DISTINCT `glpi_users`.`{$field}`\n                FROM `" . $this->getTable() . "`\n                INNER JOIN `{$linktable}`\n                  ON (`" . $this->getTable() . "`.`id` = `{$linktable}`.`" . $this->getForeignKeyField() . "`)\n                INNER JOIN `glpi_users` ON (`glpi_users`.`id` = `{$linktable}`.`users_id`)\n                LEFT JOIN `{$table}` ON (`{$table}`.`id` = `glpi_users`.`{$field}`)\n                WHERE NOT `" . $this->getTable() . "`.`is_deleted` " . getEntitiesRestrictRequest("AND", $this->getTable());
        if (!empty($date1) || !empty($date2)) {
            $query .= " AND (" . getDateRequest("`" . $this->getTable() . "`.`date`", $date1, $date2) . "\n                          OR " . getDateRequest("`" . $this->getTable() . "`.`closedate`", $date1, $date2) . ") ";
        }
        $query .= " ORDER BY `glpi_users`.`{$field}`";
        $result = $DB->query($query);
        $tab = array();
        if ($DB->numrows($result) >= 1) {
            while ($line = $DB->fetch_assoc($result)) {
                $tmp['id'] = $line[$field];
                $tmp['link'] = Dropdown::getDropdownName($table, $line[$field]);
                $tab[] = $tmp;
            }
        }
        return $tab;
    }