[Request] Allow table data be sorted / filtered by column headings

[RIPcounties]

An option to allow site visitors to sort (filter?) table data by clicking on a column heading would be helpful for our project.

(Providing this feature for visitors is the only reason we are currently using Ninja Tables alongside M Chart).

https://ripcounties.ie/the-national-picture/

[methnen]

That's definitely out of the intended scope of the plugin.

However, I've purposely put many hooks into the existing code to allow for just these kinds of things.

I don't think I've documented this one in the wiki yet, but there's a hook right where the table template is called:

require apply_filters( 'm_chart_table_template', $template, $library, $post->ID );

You could use that hook to return the path of a different table template inside of your theme and then do whatever you want in there.

The default table template looks like this:

<table class="<?php echo esc_attr( $classes ); ?>">
	<?php
	$set_name = '';

	if ( $multiple ) {
		$set_name = ': ' . $post_meta['set_names'][ $set ];
	}

	if ( isset( m_chart()->parse()->value_labels['first_row'] ) ) {
		$first_row = m_chart()->parse()->value_labels['first_row'];
		$labels    = m_chart()->parse()->value_labels['first_column'];

		$row_column = false;

		if ( count( $first_row ) == count( m_chart()->parse()->set_data[0] ) ) {
			$row_column = true;
		}
		?>
		<tr><th colspan="<?php echo count( $first_row ) + 1; ?>"><?php echo get_the_title( $post_id ) . $set_name; ?></th></tr>
		<tr>
			<th></th>
			<?php
			foreach ( $first_row as $label ) {
				?>
				<th><?php echo esc_html( $label ); ?></th>
				<?php
			}
			?>
		</tr>
		<?php
		foreach ( $labels as $row => $label ) {
			?>
			<tr>
				<th><?php echo esc_html( $label ); ?></th>
				<?php
				foreach ( $first_row as $column => $label ) {
					if ( $row_column ) {
						$value = m_chart()->parse()->set_data[ $row ][ $column ];
					} else {
						$value = m_chart()->parse()->set_data[ $column ][ $row ];
					}

					if ( is_numeric( $value ) ) {
						$value = number_format_i18n( $value, strlen( substr( strrchr( $value, '.'), 1 ) ) );
						$value = '' != $value ? m_chart()->parse()->data_prefix . $value . m_chart()->parse()->data_suffix : '';
					}
					?>
					<td><?php echo esc_html( $value ); ?></td>
					<?php
				}
				?>
			</tr>
			<?php
		}
	} else {
		$first_row = m_chart()->parse()->value_labels;
		?>
		<tr><th colspan="<?php echo count( $first_row ); ?>"><?php echo get_the_title( $post_id ) . $set_name; ?></th></tr>
		<tr>
			<?php
			foreach ( $first_row as $label ) {
				?>
				<th><?php echo esc_html( $label ); ?></th>
				<?php
			}
			?>
		</tr>
		<tr>
			<?php
			$row_count = 1;
			$total_rows = count( m_chart()->parse()->set_data ) / count( $first_row );

			foreach ( m_chart()->parse()->set_data as $key => $value ) {
				if ( is_numeric( $value ) ) {
					$value = number_format_i18n( $value, strlen( substr( strrchr( $value, '.'), 1 ) ) );
					$value = '' != $value ? m_chart()->parse()->data_prefix . $value . m_chart()->parse()->data_suffix : '';
				}
				?>
				<td><?php echo esc_html( $value ); ?></td>
				<?php

				if ( ( $key + 1 ) / ( count( $first_row ) * $row_count ) == 1 ) {
					$row_count++;

					if ( $row_count <= $total_rows ) {
						?>
						</tr><tr>
						<?php
					}
				}
			}
			?>
		</tr>
	<?php
	}
	?>
</table>

You could use that as a starting point to build alternate versions of table output that include whatever features you like. And there are many javascript libraries out there for adding sorting features to HTML tables.

[RIPcounties]

Thanks. A bit beyond my basic skills. But I know a developer who might help out.

[methnen]

Happy to help them along/point them in the right direction when the time comes.