classes/class.ilElementList.php

Go to the documentation of this file.

<?PHP

require_once dirname(__FILE__) . "/class.ilElement.php";

class ilElementList {

    var $dbHandle;

        var $result;
        
    var $dbTable;

    var $idField="id";

    var $orderField="id";

    var $orderDirection="ASC";

    var $whereCond="1";


    var $element;

    function ilElementList() {

            $this->idField="id";
            $this->orderField="id";
                $this->orderDirection="ASC";
                $this->whereCond="1";

        $this->element = new ilElement();
    }

    function checkDb($function) {
        if ($this->dbHandle == "") {
            die($function . ": No database handle given.");
        }
        if ($this->dbTable == "") {
            die($function . ": No database table given.");
        }
    }

    function setDbTable($dbTable) {
        if ($dbTable == "") {
            die ("List::setDbTable(): No database table given.");
        } else {
            $this->dbTable = $dbTable;
        }
    }

    function getDbTable() {
        return $this->dbTable;
    }

    function setDbHandle($dbHandle) {
        if ($dbHandle == "") {
            die("Liste::setDbHandle(): No database handle given.");
        } else {
            $this->dbHandle = $dbHandle;
        }
    }

    function getDbHandle() {
        return $this->dbHandle;
    }

    function setIdField($idField) {
        if ($idField == "") {
            die ("Liste::setIdField(): No id given.");
        } else {
            $this->idField = $idField;
        }
    }

    function setWhereCond($where) {
        if ($where == "") {
            die ("Liste::setWhereCond(): No where condition given.");
        } else {
            $this->whereCond = $where;
        }
    }

        
    function setOrderField($orderField) {
        if ($orderField == "") {
            die ("Liste::setOrderField(): No order field given.");
        } else {
            $this->orderField = $orderField;
        }
    }

    function setOrderDirection($orderDirection) {
        if (($orderDirection != "ASC") && ($orderDirection != "DESC")) {
            return false;
        } else {
            $this->orderDirection = $orderDirection;
        }
    }

    function selectDbAll()
        {
        $this->checkDb("Liste::selectDbAll()");
                
#               echo "SELECT * FROM " . $this->getDbTable() . " WHERE (".$this->whereCond.") ORDER BY " . $this->orderField . " " . $this->orderDirection;
        $result = $this->dbHandle->query("SELECT * FROM " . $this->getDbTable() . " WHERE (".$this->whereCond.") ORDER BY " . $this->orderField . " " . $this->orderDirection);
        if (DB::isError($result)) {
            die("Liste::selectDbAll(): ".$result->getMessage());
        }
                $this->result=$result;
        return $result;
    }

    function selectDbAllLimited($start = 0, $count = 30) {
        $this->checkDb("Liste::selectDbQuery()");

        $result = $this->dbHandle->query("SELECT * FROM " . $this->getDbTable() . " WHERE (".$this->whereCond.") ORDER BY " . $this->orderField . " " . $this->orderDirection . " LIMIT " . $start . ", " . $count);
        if (DB::isError($result)) {
            die("Liste::selectDbAllLimited(): ".$result->getMessage());
        }
                $this->result=$result;
        return $result;
    }

    function selectDbAllByQuery($query) {
        if ($this->dbHandle == "") {
            die("Liste::selectDbAllByQuery(): No database handle given.");
        }
        if ($query == "") {
            die("Liste::selectDbAllByQuery(): No query given.");
        }

        $result = $this->dbHandle->query($query);
        if (DB::isError($result)) {
            die("Liste::selectDbAllByQuery(): ".$result->getMessage());
        }
                $this->result=$result;
        return $result;
    }

    function getDbNextElement($result="default") {
        //check result
                if ($result=="default") {
                    $result=$this->result;
                }
                
        if (!is_object($result)) {
            die("Liste::getDbNextElement(): No result object given.");
        }
        //get the next dataset
        if (is_array($data = $result->fetchRow(DB_FETCHMODE_ASSOC))) {
            $this->element->setData($data);
            return true;
        } else {
            return false;
        }
    }

    function countDb($where = "") {
        $this->checkDb("Liste::countDb()");

        $q = "SELECT COUNT(*) FROM " . $this->getDbTable();
        if ($where != "") {
            $q .= " WHERE " . $where;
                        } else {
                        $q .= " WHERE (" . $this->whereCond . ")";
                        }
        $result = $this->dbHandle->query($q);
        if (DB::isError($result)) {
            die("Liste::countDb(): ".$result->getMessage());
        }
        if (is_array($data = $result->fetchRow())) {
            return $data[0];
        } else {
            return 0;
        }
    } //end function countDb

    function countDbByQuery($query) {
        if ($this->dbHandle == "") {
            die("Liste::countDbByQuery(): No database handle given.");
        }
        if ($query == "") {
            die("Liste::countDbByQuery(): No query given.");
        }

        $result = $this->dbHandle->query($query);
        if (DB::isError($result)) {
            die("Liste::countDbByQuery(): ".$result->getMessage());
        }
        if (is_array($data = $result->fetchRow())) {
            return $data[0];
        } else {
            return 0;
        }
    } //end function countDbByQuery

} //end class ElementList

?>