      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:

    <?php

    namespace WPGMZA;

    class AdminMarkerDataTable extends MarkerDataTable
    {
        const ID_PLACEHOLDER = '__5d5621cf7b6bb90bfb7bda85a0df7293';

        public function __construct($ajax_parameters=null)
        {
            MarkerDataTable::__construct($ajax_parameters, array(
                'order' => array(
                    1,
                    'desc'
                )
            ));

            $this->element->setAttribute('data-wpgmza-admin-marker-datatable', null);

            $this->element->import('<div>
                &#x21b3;
                <button class="wpgmza button select_all_markers" type="button">' . __('Select All', 'wp-google-maps') . '</button>
                <button class="wpgmza button bulk_delete" type="button">' . __('Bulk Delete', 'wp-google-maps') . '</button>
            </div>');
        }

        protected function getColumns()
        {
            return array(
                'mark'          => __('Mark',           'wp-google-maps'),
                'id'            => __('ID',             'wp-google-maps'),
                'icon'          => __('Icon',           'wp-google-maps'),
                'title'         => __('Title',          'wp-google-maps'),
                'category'      => __('Category',       'wp-google-maps'),
                'address'       => __('Address',        'wp-google-maps'),
                'description'   => __('Description',    'wp-google-maps'),
                'pic'           => __('Image',          'wp-google-maps'),
                'link'          => __('Link',           'wp-google-maps'),
                'action'        => __('Action',         'wp-google-maps')
            );
        }

        protected function getActionButtons()
        {
            $id_placeholder = AdminMarkerDataTable::ID_PLACEHOLDER;

            return 'REPLACE(\'

                <a title="Edit this marker" class="wpgmza_edit_btn button" id="' . $id_placeholder . '" data-edit-marker-id="' . $id_placeholder . '">
                    <i class="fa fa-edit"> </i>
                </a>
                <a href="?page=wp-google-maps-menu&amp;action=edit_marker&amp;id=' . $id_placeholder . '" title="'
                    . esc_attr( __('Edit this marker location', 'wp-google-maps') )  .
                    '" class="wpgmza_edit_btn button" id="' . $id_placeholder . '">
                    <i class="fa fa-map-marker"> </i>
                </a>
                <a href="javascript: ;" title="'
                    . esc_attr( __('Delete this marker', 'wp-google-maps') ) .
                    '" class="wpgmza_del_btn button" id="' . $id_placeholder . '">
                    <i class="fa fa-times"> </i>
                </a>

                \',
                "' . $id_placeholder . '",
                id
            ) AS `action`
            ';
        }

        protected function filterColumns(&$columns, $input_params)
        {
            MarkerDataTable::filterColumns($columns, $input_params);

            foreach($columns as $key => $value)
            {
                $name = $this->getColumnNameByIndex($key);

                switch($name)
                {
                    case 'category':
                    case 'description':
                    case 'pic':
                        $columns[$key] = '"" AS ' . $name;
                        break;

                    case 'action':
                        $columns[$key] = $this->getActionButtons();
                        break;

                    case 'icon':
                        $columns[$key] = '\'<img src="' . Marker::DEFAULT_ICON . '"/>\' AS icon';
                        break;
                }
            }

            return $columns;
        }

        protected function getSearchClause($input_params, &$query_params, $exclude_columns=null)
        {
            return MarkerDataTable::getSearchClause($input_params, $query_params, array(
                'mark',
                'action'
            ));
        }
    }