Flake\Core\Requester\Sql::getQuery PHP Method

getQuery() public method

public getQuery ( $sFields = "*" )
    function getQuery($sFields = "*")
    {
        $sWhere = "1=1";
        $sOrderBy = "";
        $sLimit = "";
        if (!empty($this->aClauses)) {
            $sWhere = implode(" AND ", $this->aClauses);
        }
        if (trim($this->sOrderField) !== "") {
            $sOrderBy = $this->sOrderField . " " . $this->sOrderDirection;
        }
        if ($this->iLimitStart !== false) {
            if ($this->iLimitNumber !== false) {
                $sLimit = $this->iLimitStart . ", " . $this->iLimitNumber;
            } else {
                $sLimit = $this->iLimitStart;
            }
        } elseif ($this->iLimitNumber !== false) {
            $sLimit = "0, " . $this->iLimitNumber;
        }
        return $GLOBALS["DB"]->SELECTquery($sFields, $this->sDataTable, $sWhere, "", $sOrderBy, $sLimit);
    }