intraface / intraface.dk

        $i = 0;

        $this->getDBQuery()->setCondition('newsletter_subscriber.optin = '.$this->getDBQuery()->getFilter('optin'));

        $this->getDBQuery()->setCondition('newsletter_subscriber.active = '.$this->getDBQuery()->getFilter('active'));

        if ($this->getDBQuery()->checkFilter("q")) {

            $this->getDBQuery()->setCondition("(address.name LIKE \"%".$this->getDBQuery()->getFilter("q")."%\" OR address.email LIKE \"%".$this->getDBQuery()->getFilter("q")."%\")");

        }

        $db = $this->getDBQuery()->getRecordset("newsletter_subscriber.id, date_optin_email_sent, contact_id, resend_optin_email_count, date_submitted, DATE_FORMAT(date_submitted, '%d-%m-%Y') AS dk_date_submitted, optin", "", false);

            $this->getDBQuery()->setCondition("status_key = ".intval($this->getDBQuery()->getFilter('status')));

        }

        if ($this->getDBQuery()->getFilter('text') != "") {

            $this->getDBQuery()->setCondition("transaction_number LIKE \"%".$this->getDBQuery()->getFilter('text')."%\" OR text LIKE \"%".$this->dbquery->getFilter('text')."%\"");

        }

        if ($this->getDBQuery()->checkFilter("from_date")) {

            $date = new Intraface_Date($this->getDBQuery()->getFilter("from_date"));