mdataset.class

Ir para a documentação deste ficheiro.

<?php
class MDataSet
{
    var $result; // the dataset (an numeric-indexed array of rows x fields)
 
    var $row; // the current row index
 
    var $rowCount; // the row count
 
    var $colCount; // the col count
 
    var $eof; // true if row > nrows
 
    var $bof; // true if row < 0
 
    var $metadata; // an array with fieldname, fieldtype, fieldlength, fieldpos for the result
 
    var $type; // query, table or storedproc
 
    function __construct()
    {
        $this->eof = $this->bof = true;
        $this->result = array
            (
            );
    }
 
    function MovePrev()
    {
        if ($this->bof = (--$this->row < 0))
        {
            $this->row = 0;
        }
 
        return $this->bof;
    }
 
    function MoveNext()
    {
        if ($this->eof = (++$this->row >= $this->rowCount))
        {
            $this->row = $this->rowCount - 1;
        }
 
        return $this->eof;
    }
 
    function MoveTo($row)
    {
        $inRange = (!$this->eof) && (($row < $this->rowCount) && ($row > -1));
 
        if ($inRange)
        {
            $this->row = $row;
            $this->bof = $this->eof = false;
        }
 
        return $inRange;
    }
 
    function MoveFirst()
    {
        return $this->MoveTo(0);
    }
 
    function MoveLast()
    {
        return $this->MoveTo($this->rowCount - 1);
    }
 
    function GetRowCount()
    {
        return $this->rowCount;
    }
 
    function GetColumnCount()
    {
        return $this->colCount;
    }
 
    function GetColumnName($colNumber)
    {
        return $this->metadata['fieldname'][$colNumber];
    }
 
    function GetColumnNames()
    {
        return $this->metadata['fieldname'];
    }
 
    function GetColumnNumber($colName)
    {
        return $this->metadata['fieldpos'][strtoupper($colName)];
    }
 
    function GetValue($colName)
    {
        $result = $this->result[$this->row][$this->metadata['fieldpos'][strtoupper($colName)]];
        return $result;
    }
 
    function fields($fieldName)
    {
        $result = $this->result[$this->row][$this->metadata['fieldpos'][strtoupper($fieldName)]];
        return $result;
    }
 
    function GetRowValues()
    {
        return $this->result[$this->row];
    }
 
    function GetRowObject()
    {
        $data = new RowObject();
        return $this->SetRowObject($data);
    }
 
    function &SetRowObject($object)
    {
        for ($i = 0; $i < $this->colCount; $i++)
        {
            $fieldName = strtolower($this->metadata['fieldname'][$i]);
            $object->$fieldName = $this->result[$this->row][$i];
        }
 
        return $object;
    }
 
    function GetFieldValues()
    {
        $fieldvalues = array
            (
            );
 
        for ($i = 0; $i < $this->colCount; $i++)
            $fieldvalues[$this->metadata['fieldname'][$i]] = $this->result[$this->row][$i];
 
        return $fieldvalues;
    }
 
    function eof()
    {
        return (($this->eof) or ($this->rowCount == 0));
    }
 
    function bof()
    {
        return (($this->bof) or ($this->rowCount == 0));
    }
 
    function chunkResult($key = 0, $value = 1, $showKeyValue = false)
    {
        $newResult = array
            (
            );
 
        if ($rs = $this->result)
        {
            foreach ($rs as $row)
            {
                $sKey = trim($row[$key]);
                $sValue = trim($row[$value]);
                $newResult[$sKey] = ($showKeyValue ? $sKey . " - " : '') . $sValue;
            }
        }
 
        return $newResult;
    }
 
    function chunkResultMany($key, $values, $type = 'S', $separator = '')
    {
        // type= 'S' : string, otherwise array
        $newResult = array
            (
            );
 
        if ($rs = $this->result)
        {
            if (!is_array($values))
                $values = array($values);
 
            foreach ($rs as $row)
            {
                $sKey = trim($row[$key]);
 
                if ($type == 'S')
                {
                    $sValue = '';
 
                    foreach ($values as $v)
                        $sValue .= trim($row[$v]) . $separator;
                }
                else
                {
                    $sValue = array
                        (
                        );
 
                    foreach ($values as $v)
                        $sValue[] = trim($row[$v]);
                }
 
                $newResult[$sKey] = $sValue;
            }
 
            return $newResult;
        }
    }
 
    function treeResult($group, $node)
    {
        $tree = array
            (
            );
 
        if ($rs = $this->result)
        {
            $tree = array
                (
                );
 
            $node = explode(',', $node);
            $group = explode(',', $group);
 
            foreach ($rs as $row)
            {
                $aNode = array
                    (
                    );
 
                foreach ($node as $n)
                    $aNode[] = $row[$n];
 
                $s = '';
 
                foreach ($group as $g)
                    $s .= '[$row[' . $g . ']]';
 
                eval ("\$tree$s" . "[] = \$aNode;");
            }
        }
 
        return $tree;
    }
}
 
class RowObject
{
}
?>