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'
        ));
    }
}