src/Service/Emailer.php
public function getAllRawQuery($page = null, $perPage = null, $data = [])
    {
        $oDb = Factory::service('Database');
        $oDb->select('ea.id,ea.ref,ea.type,ea.email_vars,ea.user_email sent_to,ue.is_verified email_verified');
        $oDb->select('ue.code email_verified_code,ea.sent,ea.status,ea.read_count,ea.link_click_count');
        $oDb->select('u.first_name,u.last_name,u.id user_id,u.password user_password,u.group_id user_group');
        $oDb->select('u.profile_img,u.gender,u.username');

        //  Apply common items; pass $data
        $this->getCountCommonEmail($data);

        // --------------------------------------------------------------------------

        //  Facilitate pagination
        if (!is_null($page)) {

            /**
             * Adjust the page variable, reduce by one so that the offset is calculated
             * correctly. Make sure we don't go into negative numbers
             */

            $page--;
            $page = $page < 0 ? 0 : $page;

            //  Work out what the offset should be
            $perPage = is_null($perPage) ? 50 : (int) $perPage;
            $offset  = $page * $perPage;

            $oDb->limit($perPage, $offset);
        }

        return $oDb->get($this->sTable . ' ' . $this->sTableAlias);
    }
public function getAllRawQuery($page = null, $perPage = null, $data = [])
    {
        $oDb = Factory::service('Database');
        $oDb->select('ea.id,ea.ref,ea.type,ea.email_vars,ea.user_email sent_to,ue.is_verified email_verified');
        $oDb->select('ue.code email_verified_code,ea.sent,ea.status,ea.read_count,ea.link_click_count');
        $oDb->select('u.first_name,u.last_name,u.id user_id,u.password user_password,u.group_id user_group');
        $oDb->select('u.profile_img,u.gender,u.username');

        //  Apply common items; pass $data
        $this->getCountCommonEmail($data);

        // --------------------------------------------------------------------------

        //  Facilitate pagination
        if (!is_null($page)) {

            /**
             * Adjust the page variable, reduce by one so that the offset is calculated
             * correctly. Make sure we don't go into negative numbers
             */

            $page--;
            $page = $page < 0 ? 0 : $page;

            //  Work out what the offset should be
            $perPage = is_null($perPage) ? 50 : (int) $perPage;
            $offset  = $page * $perPage;

            $oDb->limit($perPage, $offset);
        }

        return $oDb->get($this->sTable . ' ' . $this->sTableAlias);
    }
public function getAllRawQuery ( $ page = null , $ perPage = null , $ data = [ ] ) { $ oDb = Factory :: service ( 'Database' ) ; $ oDb -> select ( 'ea.id,ea.ref,ea.type,ea.email_vars,ea.user_email sent_to,ue.is_verified email_verified' ) ; $ oDb -> select ( 'ue.code email_verified_code,ea.sent,ea.status,ea.read_count,ea.link_click_count' ) ; $ oDb -> select ( 'u.first_name,u.last_name,u.id user_id,u.password user_password,u.group_id user_group' ) ; $ oDb -> select ( 'u.profile_img,u.gender,u.username' ) ; //  Apply common items; pass $data $ this -> getCountCommonEmail ( $ data ) ; // -------------------------------------------------------------------------- //  Facilitate pagination if ( ! is_null ( $ page ) ) { /**
             * Adjust the page variable, reduce by one so that the offset is calculated
             * correctly. Make sure we don't go into negative numbers
             */ $ page -- ; $ page = $ page < 0 ? 0 : $ page ; //  Work out what the offset should be $ perPage = is_null ( $ perPage ) ? 50 : ( int ) $ perPage ; $ offset = $ page * $ perPage ; $ oDb -> limit ( $ perPage , $ offset ) ; } return $ oDb -> get ( $ this -> sTable . ' ' . $ this -> sTableAlias ) ; }
Returns emails from the archive

@param  integer $page    The page of results to retrieve
@param  integer $perPage The number of results per page
@param  array   $data    Data to pass to getCountCommonEmail()

@return object
@throws \Nails\Common\Exception\FactoryException
Returns emails from the archive