<?php

namespace WPGMZA;

if(!defined('ABSPATH'))
	return;

class AdminMarkerDataTable extends MarkerDataTable
{
	const ID_PLACEHOLDER = '__5d5621cf7b6bb90bfb7bda85a0df7293';
	
	public function __construct($ajax_parameters=null)
	{	
		global $wpgmza;

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

		$buttonClass = $wpgmza->internalEngine->getButtonClass('button');

		@$this->element->setAttribute('data-wpgmza-admin-marker-datatable', '');
		
		$this->element->import('<div class="wpgmza-marker-listing__actions">
			<span>&#x21b3;</span>
			<button class="wpgmza ' . $buttonClass . ' select_all_markers select_all_features" type="button">' . __('Select All', 'wp-google-maps') . '</button>
			<button class="wpgmza ' . $buttonClass . ' bulk_edit" type="button">' . __('Bulk Edit', 'wp-google-maps') . '</button>
			<button class="wpgmza ' . $buttonClass . ' 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'),
			'sticky'		=> __('Sticky',			'wp-google-maps'),
			'action'		=> __('Action', 		'wp-google-maps')
		);
	}
	
	protected function getActionButtons()
	{
		global $wpgmza;

		$id_placeholder = AdminMarkerDataTable::ID_PLACEHOLDER;

		$buttonClass = $wpgmza->internalEngine->getButtonClass('button');

		$actionsHtml = "<div class=\'wpgmza-action-buttons wpgmza-flex\'>
					<a title=\'" . esc_attr( __('Edit this marker', 'wp-google-maps') ) . "\' class=\'wpgmza_edit_btn {$buttonClass}\' data-edit-marker-id=\'{$id_placeholder}\'>
						<i class=\'fa fa-edit\'> </i>
					</a>
					<a title=\'" . esc_attr( __('Edit this marker location', 'wp-google-maps') ) . "\' data-adjust-marker-id=\'{$id_placeholder}\' class=\'wpgmza_edit_btn {$buttonClass}\'>
						<i class=\'fa fa-map-marker\'> </i>
					</a>
					<a title=\'" . esc_attr( __('Center on marker', 'wp-google-maps') ) . "\' class=\'wpgmza_center_btn {$buttonClass}\' data-center-marker-id=\'{$id_placeholder}\'>
						<i class=\'fa fa-eye\'> </i>
					</a>
					<a href=\'javascript: ;\' title=\'"
						. esc_attr( __('Delete this marker', 'wp-google-maps') ) .
						"\' class=\'wpgmza_del_btn {$buttonClass}\' data-delete-marker-id=\'{$id_placeholder}\'>
						<i class=\'fa fa-times\'> </i>
					</a>
				</div>";


		if(!$wpgmza->internalEngine->isLegacy()){
			$actionsHtml = "<div class=\'wpgmza-action-buttons wpgmza-toolbar\'>
					<input type=\'checkbox\' id=\'wpgmza-toolbar-conditional-marker-{$id_placeholder}\'>
					<label class=\'wpgmza-button\' for=\'wpgmza-toolbar-conditional-marker-{$id_placeholder}\'><i class=\'fa fa-ellipsis-h\'></i></label>
					<div class=\'wpgmza-toolbar-list\'>
						<a title=\'" . esc_attr( __('Edit this marker', 'wp-google-maps') ) . "\' class=\'wpgmza_edit_btn\' data-edit-marker-id=\'{$id_placeholder}\'>
							" . esc_attr( __('Edit', 'wp-google-maps') ) . "
						</a>
						<a title=\'" . esc_attr( __('Edit this marker location', 'wp-google-maps') ) . "\' data-adjust-marker-id=\'{$id_placeholder}\' class=\'wpgmza_edit_btn\'>
							" . esc_attr( __('Adjust', 'wp-google-maps') ) . "
						</a>
						<a title=\'" . esc_attr( __('Center on marker', 'wp-google-maps') ) . "\' class=\'wpgmza_center_btn\' data-center-marker-id=\'{$id_placeholder}\'>
							" . esc_attr( __('Center', 'wp-google-maps') ) . "
						</a>
						<a title=\'" . esc_attr( __('Duplicate this marker', 'wp-google-maps') ) . "\' class=\'wpgmza_duplicate_btn\' data-duplicate-feature-id=\'{$id_placeholder}\' data-pro-action>
							" . esc_attr( __('Duplicate', 'wp-google-maps') ) . "
						</a>
						<a title=\'" . esc_attr( __('Move this marker to another map', 'wp-google-maps') ) . "\' class=\'wpgmza_move_map_btn\' data-move-map-feature-id=\'{$id_placeholder}\' data-pro-action>
							" . esc_attr( __('Move Map', 'wp-google-maps') ) . "
						</a>
						<a href=\'javascript: ;\' title=\'"
							. esc_attr( __('Delete this marker', 'wp-google-maps') ) . 
							"\' class=\'wpgmza_del_btn\' data-delete-marker-id=\'{$id_placeholder}\'>
							" . esc_attr( __('Delete', 'wp-google-maps') ) . "
						</a>
					</div>
				</div>";
		}
		
		/* Developer Hook (Filter) - Modify datatable action button SQL, before it is sent to DB */
		return apply_filters('wpgmza_admin_marker_datatable_action_buttons_sql', "REPLACE('{$actionsHtml}',
				'{$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;
				
				case 'sticky':
					$columns[$key] = '(CASE WHEN sticky = 1 THEN \'&#x2714;\' ELSE \'\' END) AS sticky';
					break;
			}
		}
		
		return $columns;
	}
	
	protected function getSearchClause($input_params, &$query_params, $exclude_columns=null)
	{
		return MarkerDataTable::getSearchClause($input_params, $query_params, array(
			'mark',
			'action'
		));
	}
}