helper.php

<?php

class ModDisplayVacanciesHelper
{
    private $vacanciesRows;
    private static $pagesCount;

    public function nextAjax()
    {
        $session = JFactory::getSession();
        $current_page = $session->get('current_page');

        $current_page += 1;
        $session->set('current_page', $current_page);

        var_dump($this->vacanciesRows);

        return $current_page;
    }

    public function prevAjax()
    {
        $session = JFactory::getSession();
        $current_page = $session->get('current_page');

        $current_page -= 1;
        $session->set('current_page', $current_page);

        return $current_page;
    }

    public function setVacancyIdAjax()
    {
        //Get request data
        $jinput = JFactory::getApplication()->input;
        $vacancy_id = $jinput->get("vacancy_id");

        return $vacancy_id;
    }

    public function createTable($params)
    {
        include_once JPATH_ROOT . '/components/com_content/helpers/route.php';

        $session = JFactory::getSession();
        $session->set('current_page', '0');

        $count = $params->get("count");
        $tableClass = $params->get("table_classes");
        $multiPage =  $params->get("multiple_pages");

        //Connect to the database
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);


        //Set table headers
        $htmlResult =   "<table id='vacanciesTable' class='".$tableClass."'>
                        <th>Functie</th>
                        <th>Specialiteit</th>
                        <th>Regio</th>
                        <th>Expertise</th>";

        //Build the query
        $query
            ->select($db->quoteName(array('Function', 'SpecialityName', 'RegioName', 'Expertise-1', 'ID')))
            ->from($db->quoteName('vacancies'))
            ->order('Registered DESC');

        $db->setQuery($query);
        $this->vacanciesRows = $db->loadRowList();

        //Add rows to the table
        foreach ($this->vacanciesRows as $index=>$row)
        {
            if( $index == $count)
                break;

            $newRow = ModDisplayVacanciesHelper::createTableRow($row);
            $htmlResult .= $newRow;
        }



        $htmlResult .= "</table>";

        //Add controls for changing pages

        if($multiPage)
        {
            $htmlResult .= "<div class='page-controls'>
            <button class='btn' id='vacancies_prev'> <i class='icon-backward'></i></button>
            <button class='btn' id='vacancies_next'> <i class='icon-forward'></i></button>
            </div>";
        }

        return $htmlResult;
    }

    private function createTableRow($row)
    {
        $count =  count($row);

        $htmlRow = "<tr id=".$row[$count-1]."'>";

        foreach($row as $index=>$element)
        {
            if($index == $count - 1)
            {
                //Dont show the ID in the table
                break;
            }
            $htmlRow .= "<td>".$element."</td>";
        }

        $htmlRow .= "</tr>";

        return $htmlRow;
    }
}