1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 773: 774: 775: 776: 777: 778: 779: 780: 781: 782: 783: 784: 785: 786: 787: 788: 789: 790: 791: 792: 793: 794: 795: 796: 797: 798: 799: 800: 801: 802: 803: 804: 805: 806: 807: 808: 809: 810: 811: 812: 813: 814: 815: 816: 817: 818: 819: 820: 821: 822: 823: 824: 825: 826: 827: 

<?php
/**
 * icms_ipf_Object Table Listing
 *
 * Contains the classes responsible for displaying a highly configurable and features rich listing of IcmseristableObject objects
 *
 * @copyright The ImpressCMS Project http://www.impresscms.org/
 * @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License (GPL)
 * @since 1.1
 * @author marcan <marcan@impresscms.org>
 */
defined('ICMS_ROOT_PATH') or die('ImpressCMS root path not defined');

/**
 * icms_ipf_view_Table base class
 *
 * Base class representing a table for displaying icms_ipf_Object objects
 *
 * @copyright The ImpressCMS Project http://www.impresscms.org/
 * @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License (GPL)
 * @package ICMS\IPF\View
 * @since 1.1
 * @author marcan <marcan@impresscms.org>
 * @todo Properly declare all vars with their visibility (private, protected, public) and follow naming convention
 */
class icms_ipf_view_Table {
    var $_id;
    var $_objectHandler;
    var $_columns;
    var $_criteria;
    var $_actions;
    var $_objects = false;
    var $_aObjects;
    var $_custom_actions;
    var $_sortsel;
    var $_ordersel;
    var $_limitsel;
    var $_filtersel;
    var $_filterseloptions;
    var $_filtersel2;
    var $_filtersel2options;
    var $_filtersel2optionsDefault;
    var $_tempObject;
    var $_tpl;
    var $_introButtons;
    var $_quickSearch = false;
    var $_actionButtons = false;
    var $_head_css_class = 'bg3';
    var $_hasActions = false;
    var $_userSide = false;
    var $_printerFriendlyPage = false;
    var $_tableHeader = false;
    var $_tableFooter = false;
    var $_showActionsColumnTitle = true;
    var $_isTree = false;
    var $_showFilterAndLimit = true;
    var $_enableColumnsSorting = true;
    var $_customTemplate = false;
    var $_withSelectedActions = array();

    /**
     * Constructor
     *
     * @param object $objectHandler {@link icms_ipf_Handler}
     * @param array $columns array representing the columns to display in the table
     * @param object $criteria
     * @param array $actions array representing the actions to offer
     *
     * @return array
     */
    public function __construct(&$objectHandler, $criteria = false, $actions = array('edit', 'delete'), $userSide = false) {
        $this->_id = $objectHandler->className;
        $this->_objectHandler = $objectHandler;

        if (!$criteria) {
            $criteria = new icms_db_criteria_Compo();
        }
        $this->_criteria = $criteria;
        $this->_actions = $actions;
        $this->_custom_actions = array();
        $this->_userSide = $userSide;
        if ($userSide) {
            $this->_head_css_class = 'head';
        }
    }

    /**
     *
     * @param $op
     * @param $caption
     * @param $text
     */
    public function addActionButton($op, $caption = false, $text = false) {
        $action = array('op' => $op, 'caption' => $caption, 'text' => $text);
        $this->_actionButtons[] = $action;
    }

    /**
     *
     * @param $columnObj
     */
    public function addColumn($columnObj) {
        $this->_columns[] = $columnObj;
    }

    /**
     *
     * @param $name
     * @param $location
     * @param $value
     */
    public function addIntroButton($name, $location, $value) {
        $introButton = array();
        $introButton['name'] = $name;
        $introButton['location'] = $location;
        $introButton['value'] = $value;
        $this->_introButtons[] = $introButton;
        unset($introButton);
    }

    /**
     */
    public function addPrinterFriendlyLink() {
        $current_url = icms::$urls['full'];
        $this->_printerFriendlyPage = $current_url . '&print';
    }

    /**
     *
     * @param $fields
     * @param $caption
     */
    public function addQuickSearch($fields, $caption = _CO_ICMS_QUICK_SEARCH) {
        $this->_quickSearch = array('fields' => $fields, 'caption' => $caption);
    }

    /**
     *
     * @param unknown_type $content
     */
    public function addHeader($content) {
        $this->_tableHeader = $content;
    }

    /**
     *
     * @param $content
     */
    public function addFooter($content) {
        $this->_tableFooter = $content;
    }

    /**
     *
     * @param $caption
     */
    public function addDefaultIntroButton($caption) {
        $this->addIntroButton($this->_objectHandler->_itemname, $this->_objectHandler->_page . "?op=mod", $caption);
    }

    /**
     *
     * @param $method
     */
    public function addCustomAction($method) {
        $this->_custom_actions[] = $method;
    }

    /**
     *
     * @param $default_sort
     */
    public function setDefaultSort($default_sort) {
        $this->_sortsel = $default_sort;
    }

    /**
     * get the default sorting
     */
    public function getDefaultSort() {
        return $this->getCookie($this->_id . '_sortsel', $this->_sortsel ?: $this->_objectHandler->identifierName);
    }

    /**
     *
     * @param unknown_type $default_order
     */
    public function setDefaultOrder($default_order) {
        $this->_ordersel = $default_order;
    }

    /**
     *
     * @return string the default order returned from a cookie
     */
    public function getDefaultOrder() {
        return $this->getCookie($this->_id . '_ordersel', $this->_ordersel ?: 'ASC');
    }

    /**
     *
     * @param $actions
     */
    public function addWithSelectedActions($actions = array()) {
        $this->addColumn(new icms_ipf_view_Column('checked', 'center', 20, false, false, '&nbsp;'));
        $this->_withSelectedActions = $actions;
    }

    /**
     * Adding a filter in the table
     *
     * @param string $key key to the field that will be used for sorting
     * @param string $method method of the handler that will be called to populate the options when this filter is selected
     */
    public function addFilter($key, $method, $default = false) {
        $this->_filterseloptions[$key] = $method;
        $this->_filtersel2optionsDefault = $default;
    }

    /**
     *
     * @param $default_filter
     */
    public function setDefaultFilter($default_filter) {
        $this->_filtersel = $default_filter;
    }

    /**
     */
    public function isForUserSide() {
        $this->_userSide = true;
    }

    /**
     *
     * @param $template
     */
    public function setCustomTemplate($template) {
        $this->_customTemplate = $template;
    }

    /**
     *
     * @todo Switch to dependency injection
     */
    public function setSortOrder() {
        $this->_sortsel = isset($_GET[$this->_objectHandler->_itemname . '_' . 'sortsel']) ? filter_input(INPUT_GET, $this->_objectHandler->_itemname . '_' . 'sortsel', FILTER_SANITIZE_STRING) : $this->getDefaultSort();

        $this->setCookie($this->_id . '_sortsel', $this->_sortsel);
        $fieldsForSorting = $this->_tempObject->getFieldsForSorting($this->_sortsel);

        if (isset($this->_tempObject->vars[$this->_sortsel]['itemName'])) {
            $this->_criteria->setSort($this->_tempObject->vars[$this->_sortsel]['itemName'] . "." . $this->_sortsel);
        } else {
            $this->_criteria->setSort($this->_objectHandler->_itemname . "." . $this->_sortsel);
        }

        $this->_ordersel = isset($_GET[$this->_objectHandler->_itemname . '_' . 'ordersel']) ? filter_input(INPUT_GET, $this->_objectHandler->_itemname . '_' . 'ordersel', FILTER_SANITIZE_STRING) : $this->getDefaultOrder();
        // $this->_ordersel = isset($_POST['ordersel']) ? $_POST['ordersel'] :$this->_ordersel;
        $this->setCookie($this->_id . '_ordersel', $this->_ordersel);
        $this->getOrdersArray();
        $this->_criteria->setOrder($this->_ordersel);
    }

    /**
     *
     * @param $id
     */
    public function setTableId($id) {
        $this->_id = $id;
    }

    /**
     *
     * @param $objects
     */
    public function setObjects($objects) {
        $this->_objects = $objects;
    }

    /**
     */
    public function createTableRows() {
        $this->_aObjects = array();

        $doWeHaveActions = false;

        $objectclass = 'odd';

        if (count($this->_objects) > 0) {
            foreach ($this->_objects as $object) {

                $aObject = array();

                $i = 0;

                $aColumns = array();

                foreach ($this->_columns as $column) {

                    $aColumn = array();

                    if ($i == 0) {
                        $class = "head";
                    } elseif ($i % 2 == 0) {
                        $class = "even";
                    } else {
                        $class = "odd";
                    }
                    if (method_exists($object, 'initiateCustomFields')) {
                        // $object->initiateCustomFields();
                    }
                    if ($column->_keyname == 'checked') {
                        $value = '<input type ="checkbox" name="selected_icms_persistableobjects[]" value="' . $object->id() . '" />';
                    } elseif ($column->_customMethodForValue && method_exists($object, $column->_customMethodForValue)) {
                        $method = $column->_customMethodForValue;
                        if ($column->_param) {
                            $value = $object->$method($column->_param);
                        } else {
                            $value = $object->$method();
                        }
                    } else {
                        /**
                         * If the column is the identifier, then put a link on it
                         */
                        if ($column->getKeyName() == $this->_objectHandler->identifierName) {
                            $value = $object->getViewItemLink(false, false, $this->_userSide);
                        } else {
                            $value = $object->getVar($column->getKeyName());
                        }
                    }

                    $aColumn['keyname'] = $column->getKeyName();
                    $aColumn['value'] = $value;
                    $aColumn['class'] = $class;
                    $aColumn['width'] = $column->getWidth();
                    $aColumn['align'] = $column->getAlign();

                    $aColumns[] = $aColumn;
                    $i++ ;
                }

                $aObject['columns'] = $aColumns;
                $aObject['id'] = $object->id();

                $objectclass = ($objectclass == 'even') ? 'odd' : 'even';

                $aObject['class'] = $objectclass;

                $actions = array();

                // Adding the custom actions if any
                foreach ($this->_custom_actions as $action) {
                    if (method_exists($object, $action)) {
                        $actions[] = $object->$action();
                    }
                }

                if ((!is_array($this->_actions)) || in_array('edit', $this->_actions)) {
                    $actions[] = $object->getEditItemLink(false, true, $this->_userSide);
                }
                if ((!is_array($this->_actions)) || in_array('delete', $this->_actions)) {
                    $actions[] = $object->getDeleteItemLink(false, true, $this->_userSide);
                }
                $aObject['actions'] = $actions;

                $this->_tpl->assign('icms_actions_column_width', count($actions) * 30);

                $doWeHaveActions = $doWeHaveActions ? true : count($actions) > 0;

                $this->_aObjects[] = $aObject;
            }
            $this->_tpl->assign('icms_persistable_objects', $this->_aObjects);
        } else {
            $colspan = count($this->_columns) + 1;
            $this->_tpl->assign('icms_colspan', $colspan);
        }
        $this->_hasActions = $doWeHaveActions;
    }

    /**
     *
     * @param unknown_type $debug
     */
    public function fetchObjects($debug = false) {
        return $this->_objectHandler->getObjects($this->_criteria, true, true, false, $debug);
    }

    /**
     *
     * @todo change to dependency injection methods
     */
    public function getDefaultFilter() {
        return $this->getCookie($this->_id . '_filtersel', $this->_filtersel ?: 'default');
    }

    /**
     */
    public function getFiltersArray() {
        $ret = array();
        $field = array();
        $field['caption'] = _CO_ICMS_NONE;
        $field['selected'] = '';
        $ret['default'] = $field;
        unset($field);

        if ($this->_filterseloptions) {
            foreach ($this->_filterseloptions as $key => $value) {
                $field = array();
                if (is_array($value)) {
                    $field['caption'] = $key;
                    $field['selected'] = $this->_filtersel == $key ? "selected='selected'" : '';
                } else {
                    $field['caption'] = $this->_tempObject->vars[$key]['form_caption'];
                    $field['selected'] = $this->_filtersel == $key ? "selected='selected'" : '';
                }
                $ret[$key] = $field;
                unset($field);
            }
        } else {
            $ret = false;
        }
        return $ret;
    }

    /**
     *
     * @param unknown_type $default_filter2
     */
    public function setDefaultFilter2($default_filter2) {
        $this->_filtersel2 = $default_filter2;
    }

    /**
     *
     * @todo change to dependency injection methods
     */
    public function getDefaultFilter2() {
        return $this->getCookie('filtersel2', $this->_filtersel2 ?: 'default');
    }

    /**
     */
    public function getFilters2Array() {
        $ret = array();

        foreach ($this->_filtersel2options as $key => $value) {
            $field = array();
            $field['caption'] = $value;
            $field['selected'] = $this->_filtersel2 == $key ? "selected='selected'" : '';
            $ret[$key] = $field;
            unset($field);
        }
        return $ret;
    }

    /**
     *
     * @param $limitsArray
     * @param $params_of_the_options_sel
     */
    public function renderOptionSelection($limitsArray, $params_of_the_options_sel) {
        // Rendering the form to select options on the table
        $current_url = icms::$urls['full'];

        /**
         * What was $params_of_the_options_sel doing again ?
         */
        // $this->_tpl->assign('icms_optionssel_action', $_SERVER['SCRIPT_NAME'] . "?" . implode('&', $params_of_the_options_sel));
        $this->_tpl->assign('icms_optionssel_action', $current_url);
        $this->_tpl->assign('icms_optionssel_limitsArray', $limitsArray);
    }

    /**
     */
    public function getLimitsArray() {
        $ret = array();
        $ret['all']['caption'] = _CO_ICMS_LIMIT_ALL;
        $ret['all']['selected'] = ('all' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['5']['caption'] = icms_conv_nr2local('5');
        $ret['5']['selected'] = ('5' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['10']['caption'] = icms_conv_nr2local('10');
        $ret['10']['selected'] = ('10' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['15']['caption'] = icms_conv_nr2local('15');
        $ret['15']['selected'] = ('15' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['20']['caption'] = icms_conv_nr2local('20');
        $ret['20']['selected'] = ('20' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['25']['caption'] = icms_conv_nr2local('25');
        $ret['25']['selected'] = ('25' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['30']['caption'] = icms_conv_nr2local('30');
        $ret['30']['selected'] = ('30' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['35']['caption'] = icms_conv_nr2local('35');
        $ret['35']['selected'] = ('35' == $this->_limitsel) ? "selected='selected'" : "";

        $ret['40']['caption'] = icms_conv_nr2local('40');
        $ret['40']['selected'] = ('40' == $this->_limitsel) ? "selected='selected'" : "";
        return $ret;
    }

    /**
     */
    public function getObjects() {
        return $this->_objects;
    }

    /**
     */
    public function hideActionColumnTitle() {
        $this->_showActionsColumnTitle = false;
    }

    /**
     */
    public function hideFilterAndLimit() {
        $this->_showFilterAndLimit = false;
    }

    /**
     */
    public function getOrdersArray() {
        $ret = array();
        $ret['ASC']['caption'] = _CO_ICMS_SORT_ASC;
        $ret['ASC']['selected'] = ('ASC' == $this->_ordersel) ? "selected='selected'" : "";

        $ret['DESC']['caption'] = _CO_ICMS_SORT_DESC;
        $ret['DESC']['selected'] = ('DESC' == $this->_ordersel) ? "selected='selected'" : "";

        return $ret;
    }

    /**
     */
    public function renderD() {
        return $this->render(false, true);
    }

    /**
     */
    public function renderForPrint() {}

    /**
     * Gets from cookie
     *
     * @param string $fieldName Field name read from cookie
     * @param string|null $defaultValue Default value
     *
     * @return string
     */
    protected function getCookie($fieldName, $defaultValue = null) {
        $name = 'tbl_' . str_replace('.', '_', $fieldName);

        return isset($_COOKIE[$name]) ? $_COOKIE[$name] : $defaultValue;
    }

    /**
     * Sets cookie
     *
     * @param string $fieldName
     * @param string $value
     */
    protected function setCookie($fieldName, $value) {
        setcookie('tbl_' . $fieldName, $value, time() + 3600 * 24 * 365, parse_url(ICMS_URL, PHP_URL_PATH), parse_url(ICMS_URL, PHP_URL_HOST), substr(ICMS_URL, 0, 5) == 'https' ? 1 : 0, true);
    }

    /**
     * Render the table of records for an IPF object
     *
     * @todo change to dependency injection methods
     * @todo remove the rest of the HTML and move it to the templates
     *
     * @param $fetchOnly
     * @param $debug
     */
    public function render($fetchOnly = false, $debug = false) {

        /* Filters. First, some variable variables */
        $start = 'start' . $this->_objectHandler->keyName;
        $sortsel = $this->_objectHandler->_itemname . '_' . 'sortsel';
        $ordersel = $this->_objectHandler->_itemname . '_' . 'ordersel';
        $quicksearch = 'quicksearch_' . $this->_id;

        $filter_get = array($start => 'int', 'limitsel' => 'int', 'filtersel' => 'str', 'filtersel2' => 'str', $sortsel => 'str', $ordersel => 'str', $quicksearch => 'special', 'fct' => 'str');

        $filter_post = array('limitsel' => 'int', 'filtersel' => 'str', 'filtersel2' => 'str', $quicksearch => 'special', 'fct' => 'str');

        $filter_server = array('SCRIPT_NAME' => 'str');
        /* default values */
        $$start = 0;
        $limitsel = 15;
        $filtersel = $this->getDefaultFilter();
        $filtersel2 = $this->getDefaultFilter2();
        $$sortsel = $$ordersel = '';
        $$quicksearch = '';

        /* filter the user input - only allow specified variables */
        if (!empty($_GET)) {
            $clean_GET = icms_core_DataFilter::checkVarArray($_GET, $filter_get, true);
            extract($clean_GET);
        }
        if (!empty($_POST)) {
            $clean_POST = icms_core_DataFilter::checkVarArray($_POST, $filter_post, true);
            extract($clean_POST);
        }

        $server_vars = icms_core_DataFilter::checkVarArray($_SERVER, $filter_server, true);
        $script_name = $server_vars['SCRIPT_NAME'];

        $this->_tpl = new icms_view_Tpl();

        /**
         * We need access to the protected vars of the icms_ipf_Object for a few things in the table creation.
         * Since we may not have an icms_ipf_Object to look into now, let's create one for this purpose
         * and we will free it after
         */
        $this->_tempObject = &$this->_objectHandler->create();

        $this->_criteria->setStart($$start);

        $this->setSortOrder();

        $this->_limitsel = !empty($limitsel) ? $limitsel : $this->getCookie('limitsel', '15');

        if ($this->_isTree) {
            $this->_limitsel = 'all';
        }

        $this->setCookie('limitsel', $this->_limitsel);

        $limitsArray = $this->getLimitsArray();
        $this->_criteria->setLimit($this->_limitsel);

        $this->_filtersel = $filtersel;

        $this->setCookie($this->_id . '_filtersel', $this->_filtersel);
        $filtersArray = $this->getFiltersArray();

        if ($filtersArray) {
            $this->_tpl->assign('icms_optionssel_filtersArray', $filtersArray);
        }

        // Check if the selected filter is defined and if so, create the selfilter2
        if (!empty($this->_filterseloptions[$this->_filtersel])) {
            // check if method associate with this filter exists in the handler
            if (is_array($this->_filterseloptions[$this->_filtersel])) {
                $filter = $this->_filterseloptions[$this->_filtersel];
                $this->_criteria->add($filter['criteria']);
            } else {
                if (method_exists($this->_objectHandler, $this->_filterseloptions[$this->_filtersel])) {

                    // then we will create the selfilter2 options by calling this method
                    $method = $this->_filterseloptions[$this->_filtersel];
                    $this->_filtersel2options = $this->_objectHandler->$method();

                    $this->_filtersel2 = $filtersel2;

                    $filters2Array = $this->getFilters2Array();
                    $this->_tpl->assign('icms_optionssel_filters2Array', $filters2Array);

                    $this->setCookie('filtersel2', $this->_filtersel2);
                    if ($this->_filtersel2 !== 'default') {
                        $this->_criteria->add(new icms_db_criteria_Item($this->_filtersel, $this->_filtersel2));
                    }
                }
            }
        }
        // Check if we have a quicksearch

        if (!empty($$quicksearch)) {
            $quicksearch_criteria = new icms_db_criteria_Compo();
            if (is_array($this->_quickSearch['fields'])) {
                foreach ($this->_quickSearch['fields'] as $v) {
                    $quicksearch_criteria->add(new icms_db_criteria_Item($v, '%' . $$quicksearch . '%', 'LIKE'), 'OR');
                }
            } else {
                $quicksearch_criteria->add(new icms_db_criteria_Item($this->_quickSearch['fields'], '%' . $$quicksearch . '%', 'LIKE'));
            }
            $this->_criteria->add($quicksearch_criteria);
        }

        $this->_objects = $this->fetchObjects($debug);

        /**
         * $params_of_the_options_sel is an array with all the parameters of the page
         * but without the pagenave parameters.
         * This array will be used in the
         * OptionsSelection
         */
        $params_of_the_options_sel = array();
        if ($this->_criteria->getLimit() > 0) {

            /**
             * Geeting rid of the old params
             * $new_get_array is an array containing the new GET parameters
             */
            $new_get_array = array();

            $not_needed_params = array('sortsel', 'limitsel', 'ordersel', 'start' . $this->_objectHandler->keyName);
            foreach ($clean_GET as $k => $v) {
                if (!in_array($k, $not_needed_params)) {
                    $new_get_array[] = "$k=$v";
                    $params_of_the_options_sel[] = "$k=$v";
                }
            }

            /**
             * Adding the new params of the pagenav
             */
            $new_get_array[] = "sortsel=" . $this->_sortsel;
            $new_get_array[] = "ordersel=" . $this->_ordersel;
            $new_get_array[] = "limitsel=" . $this->_limitsel;
            $otherParams = implode('&', $new_get_array);

            $pagenav = new icms_view_PageNav($this->_objectHandler->getCount($this->_criteria), $this->_criteria->getLimit(), $this->_criteria->getStart(), 'start' . $this->_objectHandler->keyName, $otherParams);
            $this->_tpl->assign('icms_pagenav', $pagenav->renderNav());
        }
        $this->renderOptionSelection($limitsArray, $params_of_the_options_sel);

        // retreive the current url and the query string
        $current_url = icms::$urls['full_phpself'];
        $query_string = icms::$urls['querystring'];
        if ($query_string) {
            $query_string = str_replace('?', '', $query_string);
        }
        $query_stringArray = explode('&', $query_string);
        $new_query_stringArray = array();
        foreach ($query_stringArray as $query_string) {
            if (strpos($query_string, 'sortsel') == FALSE && strpos($query_string, 'ordersel') == FALSE) {
                $new_query_stringArray[] = $query_string;
            }
        }
        $new_query_string = implode('&', $new_query_stringArray);

        $orderArray = array();
        $orderArray['ASC']['image'] = 'desc.png';
        $orderArray['ASC']['neworder'] = 'DESC';
        $orderArray['DESC']['image'] = 'asc.png';
        $orderArray['DESC']['neworder'] = 'ASC';

        $aColumns = array();

        foreach ($this->_columns as $column) {
            $aColumn = array();
            $aColumn['width'] = $column->getWidth();
            $aColumn['align'] = $column->getAlign();
            $aColumn['key'] = $column->getKeyName();

            if ($column->_keyname == 'checked') {
                $aColumn['caption'] = '<input type ="checkbox" id="checkall_icmspersistableobjects" name="checkall_icmspersistableobjects"' . ' value="checkall_icmspersistableobjects" onclick="icms_checkall(window.document.form_' . $this->_id . ', \'selected_icmspersistableobjects\');" />';
            } elseif ($column->getCustomCaption()) {
                $aColumn['caption'] = $column->getCustomCaption();
            } else {
                $aColumn['caption'] = $this->_tempObject->getVarInfo($column->getKeyName(), 'form_caption') ? $this->_tempObject->getVarInfo($column->getKeyName(), 'form_caption') : $column->getKeyName();
            }
            // Are we doing a GET sort on this column ?
            $getSort = (!empty($$sortsel) && $$sortsel == $column->getKeyName()) || ($this->_sortsel == $column->getKeyName());
            $order = !empty($$ordersel) ? $$ordersel : 'DESC';

            if (!empty($$quicksearch)) {
                $filter = !empty($$quicksearch) ? INPUT_POST : INPUT_GET;
                $qs_param = "&amp;quicksearch_" . $this->_id . "=" . filter_input($filter, 'quicksearch_' . $this->_id, FILTER_SANITIZE_SPECIAL_CHARS);
            } else {
                $qs_param = '';
            }
            if (!$this->_enableColumnsSorting || $column->_keyname == 'checked' || !$column->_sortable) {
                $aColumn['caption'] = $aColumn['caption'];
            } elseif ($getSort) {
                $aColumn['caption'] = '<a href="' . $current_url . '?' . $this->_objectHandler->_itemname . '_' . 'sortsel=' . $column->getKeyName() . '&amp;' . $this->_objectHandler->_itemname . '_' . 'ordersel=' . $orderArray[$order]['neworder'] . $qs_param . '&amp;' . $new_query_string . '">' . $aColumn['caption'] . ' <img src="' . ICMS_IMAGES_SET_URL . '/actions/' . $orderArray[$order]['image'] . '" alt="ASC" /></a>';
            } else {
                $aColumn['caption'] = '<a href="' . $current_url . '?' . $this->_objectHandler->_itemname . '_' . 'sortsel=' . $column->getKeyName() . '&amp;' . $this->_objectHandler->_itemname . '_' . 'ordersel=ASC' . $qs_param . '&amp;' . $new_query_string . '">' . $aColumn['caption'] . '</a>';
            }
            $aColumns[] = $aColumn;
        }
        $this->_tpl->assign('icms_columns', $aColumns);

        if ($this->_quickSearch) {
            $this->_tpl->assign('icms_quicksearch', $this->_quickSearch['caption']);
        }

        $this->createTableRows();

        $this->_tpl->assign('icms_showFilterAndLimit', $this->_showFilterAndLimit);
        $this->_tpl->assign('icms_isTree', $this->_isTree);
        $this->_tpl->assign('icms_show_action_column_title', $this->_showActionsColumnTitle);
        $this->_tpl->assign('icms_table_header', $this->_tableHeader);
        $this->_tpl->assign('icms_table_footer', $this->_tableFooter);
        $this->_tpl->assign('icms_printer_friendly_page', $this->_printerFriendlyPage);
        $this->_tpl->assign('icms_user_side', $this->_userSide);
        $this->_tpl->assign('icms_has_actions', $this->_hasActions);
        $this->_tpl->assign('icms_head_css_class', $this->_head_css_class);
        $this->_tpl->assign('icms_actionButtons', $this->_actionButtons);
        $this->_tpl->assign('icms_introButtons', $this->_introButtons);
        $this->_tpl->assign('icms_id', $this->_id);
        if (!empty($this->_withSelectedActions)) {
            $this->_tpl->assign('icms_withSelectedActions', $this->_withSelectedActions);
        }

        $icms_table_template = $this->_customTemplate ? $this->_customTemplate : 'system_persistabletable_display.html';
        if ($fetchOnly) {
            return $this->_tpl->fetch('db:' . $icms_table_template);
        } else {
            $this->_tpl->display('db:' . $icms_table_template);
        }
    }

    /**
     */
    public function disableColumnsSorting() {
        $this->_enableColumnsSorting = false;
    }

    /**
     *
     * @param $debug
     */
    public function fetch($debug = false) {
        return $this->render(true, $debug);
    }
}