flightlog\form\UserSelect::buildOptions()

Complexity

Conditions	7
Paths	32

Size

Total Lines

45

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    private function buildOptions()
    {

        if ((boolean) $this->getOption('show_empty')) {
            $this->addValueOption(-1, ' ');
        }

        if ((boolean) $this->getOption('show_every')) {
            $this->addValueOption(-2, 'Everybody');
        }

        // Forge request to select users
        $sql = "SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity";
        $sql .= " FROM " . MAIN_DB_PREFIX . "user as u";
        $sql .= " WHERE u.entity IN (0,1)";
        $sql .= " AND u.statut <> 0";

        if (empty($this->getOption('MAIN_FIRSTNAME_NAME_POSITION'))) {
            $sql .= " ORDER BY u.firstname ASC";
        } else {
            $sql .= " ORDER BY u.lastname ASC";
        }

        $resql = $this->db->query($sql);
        if ($resql) {
            $num = $this->db->num_rows($resql);
            $i = 0;
            if ($num) {
                $userstatic = new User($this->db);

                while ($i < $num) {
                    $obj = $this->db->fetch_object($resql);

                    $userstatic->id = $obj->rowid;
                    $userstatic->lastname = $obj->lastname;
                    $userstatic->firstname = $obj->firstname;

                    $this->addValueOption($obj->rowid, $userstatic->getFullName(null));
                    $i++;
                }
            }


        }
    }
}