Source: my-calendar-location-manager.php

  1. <?php
  2. /**
  3.  * Manage Locations
  4.  *
  5.  * @category Locations
  6.  * @package  My Calendar
  7.  * @author   Joe Dolson
  8.  * @license  GPLv2 or later
  9.  * @link     https://www.joedolson.com/my-calendar/
  10.  */
  12. if ( ! defined( 'ABSPATH' ) ) {
  13. 	exit;
  14. }
  16. /**
  17.  * List of locations to edit.
  18.  */
  19. function my_calendar_manage_locations() {
  20. 	?>
  21. 	<div class="wrap my-calendar-admin my-calendar-locations">
  22. 	<?php
  23. 	my_calendar_check_db();
  24. 	// We do some checking to see what we're doing.
  25. 	mc_mass_delete_locations();
  26. 	mc_clean_duplicate_locations();
  27. 	if ( ! empty( $_POST ) && ( ! isset( $_POST['mc_locations'] ) && ! isset( $_POST['mass_delete'] ) ) ) {
  28. 		$nonce = $_REQUEST['_wpnonce'];
  29. 		if ( ! wp_verify_nonce( $nonce, 'my-calendar-nonce' ) ) {
  30. 			wp_die( 'My Calendar: Security check failed' );
  31. 		}
  32. 	}
  33. 	if ( isset( $_GET['location_id'] ) && 'delete' === $_GET['mode'] ) {
  34. 		$verify = isset( $_GET['nonce'] ) ? wp_verify_nonce( $_GET['nonce'], 'my-calendar-delete-location' ) : false;
  35. 		$loc    = absint( $_GET['location_id'] );
  36. 		if ( isset( $_GET['confirm'] ) && $verify ) {
  37. 			echo wp_kses_post( mc_delete_location( $loc ) );
  38. 		} else {
  39. 			$nonce = wp_create_nonce( 'my-calendar-delete-location' );
  40. 			$args  = array(
  41. 				'location_id' => $loc,
  42. 				'nonce'       => $nonce,
  43. 			);
  44. 			// Translators: Delete link.
  45. 			$notice = sprintf( __( 'Are you sure you want to delete this location? %s', 'my-calendar' ), '<a class="button delete" href="' . esc_url( add_query_arg( $args, admin_url( 'admin.php?page=my-calendar-location-manager&mode=delete&confirm=true' ) ) ) . '">' . __( 'Delete', 'my-calendar' ) . '</a>' );
  46. 			mc_show_notice( $notice, true, false, 'warning' );
  47. 		}
  48. 	}
  49. 	if ( isset( $_GET['default'] ) && is_numeric( $_GET['default'] ) ) {
  50. 		$mcnonce = wp_verify_nonce( $_GET['_mcnonce'], 'mcnonce' );
  51. 		if ( $mcnonce ) {
  52. 			mc_update_option( 'default_location', (int) $_GET['default'] );
  53. 			mc_show_notice( __( 'Default Location Changed', 'my-calendar' ), true, false, 'success' );
  54. 		} else {
  55. 			mc_show_error( __( 'Invalid security check; please try again!', 'my-calendar' ) );
  56. 		}
  57. 	}
  58. 	?>
  59. 		<h1 class="wp-heading-inline"><?php esc_html_e( 'Locations', 'my-calendar' ); ?></h1>
  60. 		<a href="<?php echo esc_url( admin_url( 'admin.php?page=my-calendar-locations' ) ); ?>" class="page-title-action"><?php esc_html_e( 'Add New', 'my-calendar' ); ?></a>
  61. 		<?php
  62. 		if ( '' === mc_get_option( 'location_cpt_base', '' ) ) {
  63. 			?>
  64. 			<a class="page-title-action" href="<?php echo esc_url( admin_url( 'options-permalink.php#mc_location_cpt_base' ) ); ?>"><?php esc_html_e( 'Update location permalinks', 'my-calendar' ); ?></a>
  65. 			<?php
  66. 		}
  67. 		?>
  68. 		<hr class="wp-header-end">
  69. 	<div class="postbox-container jcd-wide">
  70. 		<div class="metabox-holder">
  71. 			<div class="ui-sortable meta-box-sortables">
  72. 				<div class="postbox">
  73. 					<h2><?php esc_html_e( 'Manage Locations', 'my-calendar' ); ?></h2>
  75. 					<div class="inside">
  76. 						<?php mc_manage_locations(); ?>
  77. 					</div>
  78. 				</div>
  79. 			</div>
  80. 		</div>
  81. 	</div>
  82. 		<?php mc_show_sidebar(); ?>
  83. 	</div>
  84. 	<?php
  85. }
  87. /**
  88.  * Fetch default location data.
  89.  *
  90.  * @return string
  91.  */
  92. function mc_default_location() {
  93. 	$default = mc_get_option( 'default_location' );
  94. 	$output  = '';
  95. 	if ( $default ) {
  96. 		$location = mc_get_location( $default );
  97. 		if ( ! $location ) {
  98. 			return '';
  99. 		}
  100. 		$output  = mc_hcard( $location, 'true', false, 'location' );
  101. 		$output .= '<p><a href="' . admin_url( "admin.php?page=my-calendar-locations&amp;mode=edit&amp;location_id=$default" ) . '">' . __( 'Edit Default Location', 'my-calendar' ) . '</a></p>';
  102. 	}
  103. 	if ( ! $output ) {
  104. 		$output = '<p>' . __( 'No default location selected.', 'my-calendar' ) . '</p>';
  105. 	}
  107. 	return $output;
  108. }
  111. /**
  112.  * Mass replace locations.
  113.  *
  114.  * @return mixed boolean/int query result.
  115.  */
  116. function mc_clean_duplicate_locations() {
  117. 	global $wpdb;
  118. 	// Mass delete locations.
  119. 	if ( ! empty( $_POST['mass_edit'] ) && isset( $_POST['mass_replace'] ) ) {
  120. 		$nonce = $_REQUEST['_wpnonce'];
  121. 		$post  = map_deep( $_POST, 'sanitize_text_field' );
  122. 		if ( ! wp_verify_nonce( $nonce, 'my-calendar-nonce' ) ) {
  123. 			wp_die( 'My Calendar: Security check failed' );
  124. 		}
  125. 		$locations = $post['mass_edit'];
  126. 		$replace   = absint( $post['mass_replace_id'] );
  127. 		$location  = mc_get_location( $replace );
  128. 		if ( ! $location ) {
  129. 			// If this isn't a valid location, don't continue.
  130. 			mc_show_error( esc_html__( 'An invalid ID was provided for the replacement location.', 'my-calendar' ) );
  131. 			return;
  132. 		}
  133. 		$i       = 0;
  134. 		$total   = 0;
  135. 		$deleted = array();
  136. 		foreach ( $locations as $value ) {
  137. 			// If the replacement location is checked, ignore it.
  138. 			if ( (int) $replace === (int) $value ) {
  139. 				continue;
  140. 			}
  141. 			$total  = count( $locations );
  142. 			$result = mc_delete_location( $value, 'bool' );
  143. 			if ( ! $result ) {
  144. 				$failed[] = absint( $value );
  145. 			} else {
  146. 				$deleted[] = absint( $value );
  147. 			}
  148. 			$wpdb->update(
  149. 				my_calendar_table(),
  150. 				array(
  151. 					'event_location' => $replace,
  152. 				),
  153. 				array(
  154. 					'event_location' => $value,
  155. 				),
  156. 				'%d',
  157. 				'%d'
  158. 			);
  159. 			++$i;
  160. 		}
  161. 		if ( ! empty( $deleted ) ) {
  162. 			/**
  163. 			 * Run when action to clean up duplicate locations is run.
  164. 			 *
  165. 			 * @hook mc_clean_duplicate_locations
  166. 			 *
  167. 			 * @param {array} $deleted Array of location IDs successfully deleted.
  168. 			 * @param {array} $failed Array of location IDs that were not successfully deleted.
  169. 			 */
  170. 			do_action( 'mc_clean_duplicate_locations', $deleted, $failed );
  171. 			// Translators: Number of locations deleted, number selected.
  172. 			$message = mc_show_notice( sprintf( __( '%1$d locations deleted successfully out of %2$d selected', 'my-calendar' ), count( $deleted ), $total ), false, false, 'success' );
  173. 		} else {
  174. 			$message = mc_show_error( __( 'Your locations have not been deleted. Please investigate.', 'my-calendar' ), false );
  175. 		}
  176. 		echo wp_kses_post( $message );
  177. 	}
  178. }
  180. /**
  181.  * Mass delete locations.
  182.  *
  183.  * @return mixed boolean/int query result.
  184.  */
  185. function mc_mass_delete_locations() {
  186. 	global $wpdb;
  187. 	// Mass delete locations.
  188. 	if ( ! empty( $_POST['mass_edit'] ) && isset( $_POST['mass_delete'] ) ) {
  189. 		$post  = map_deep( $_POST, 'sanitize_text_field' );
  190. 		$nonce = $_REQUEST['_wpnonce'];
  191. 		if ( ! wp_verify_nonce( $nonce, 'my-calendar-nonce' ) ) {
  192. 			wp_die( 'My Calendar: Security check failed' );
  193. 		}
  194. 		$locations = $post['mass_edit'];
  195. 		$i         = 0;
  196. 		$total     = 0;
  197. 		$deleted   = array();
  198. 		$failed    = array();
  199. 		foreach ( $locations as $value ) {
  200. 			$total  = count( $locations );
  201. 			$result = mc_delete_location( $value, 'bool' );
  202. 			if ( ! $result ) {
  203. 				$failed[] = absint( $value );
  204. 			} else {
  205. 				$deleted[] = absint( $value );
  206. 			}
  207. 			++$i;
  208. 		}
  209. 		if ( ! empty( $deleted ) ) {
  210. 			/**
  211. 			 * Run when multiple locations are deleted.
  212. 			 *
  213. 			 * @hook mc_mass_delete_locations
  214. 			 *
  215. 			 * @param {array} $deleted Array of location IDs successfully deleted.
  216. 			 * @param {array} $failed Array of location IDs that were not successfully deleted.
  217. 			 */
  218. 			do_action( 'mc_mass_delete_locations', $deleted, $failed );
  219. 			// Translators: Number of locations deleted, number selected.
  220. 			$message = mc_show_notice( sprintf( __( '%1$d locations deleted successfully out of %2$d selected', 'my-calendar' ), count( $deleted ), $total ), false );
  221. 		} else {
  222. 			$message = mc_show_error( __( 'Your locations have not been deleted. Please investigate.', 'my-calendar' ), false );
  223. 		}
  224. 		echo wp_kses_post( $message );
  225. 	}
  226. }
  228. /**
  229.  * Generate list of locations.
  230.  */
  231. function mc_manage_locations() {
  232. 	global $wpdb;
  233. 	$orderby = 'location_label';
  234. 	$sortby  = 'location';
  236. 	if ( isset( $_GET['orderby'] ) ) {
  237. 		$sortby = $_GET['orderby'];
  238. 		switch ( $sortby ) {
  239. 			case 'city':
  240. 				$orderby = 'location_city';
  241. 				break;
  242. 			case 'state':
  243. 				$orderby = 'location_state';
  244. 				break;
  245. 			case 'id':
  246. 				$orderby = 'location_id';
  247. 				break;
  248. 			default:
  249. 				$orderby = 'location_label';
  250. 		}
  251. 	}
  252. 	$order       = 'ASC';
  253. 	$query_order = 'DESC';
  254. 	if ( isset( $_GET['order'] ) ) {
  255. 		switch ( $_GET['order'] ) {
  256. 			case 'asc':
  257. 				$order       = 'DESC';
  258. 				$query_order = 'ASC';
  259. 				break;
  260. 			case 'desc':
  261. 				$order       = 'ASC';
  262. 				$query_order = 'DESC';
  263. 				break;
  264. 			default:
  265. 				$order       = 'ASC';
  266. 				$query_order = 'DESC';
  267. 		}
  268. 	}
  269. 	// Pull the locations from the database.
  270. 	$items_per_page = 50;
  271. 	$search         = '';
  272. 	$current        = empty( $_GET['paged'] ) ? 1 : intval( $_GET['paged'] );
  273. 	if ( isset( $_POST['mcl'] ) ) {
  274. 		$query   = esc_sql( $_POST['mcl'] );
  275. 		$length  = strlen( $query );
  276. 		$db_type = mc_get_db_type();
  277. 		if ( '' !== $query ) {
  278. 			if ( 'MyISAM' === $db_type && $length > 3 ) {
  279. 				/**
  280. 				 * Customize admin search MATCH columns when db is MyISAM.
  281. 				 *
  282. 				 * @hook mc_search_fields
  283. 				 *
  284. 				 * @param {string} $fields Comma-separated list of column names.
  285. 				 *
  286. 				 * @return {string}
  287. 				 */
  288. 				$search = ' WHERE MATCH(' . apply_filters( 'mc_search_fields', 'location_label,location_city,location_state,location_region,location_country,location_street,location_street2,location_phone' ) . ") AGAINST ( '$query' IN BOOLEAN MODE ) ";
  289. 			} else {
  290. 				$search = " WHERE location_label LIKE '%$query%' OR location_city LIKE '%$query%' OR location_state LIKE '%$query%' OR location_region LIKE '%$query%' OR location_country LIKE '%$query%' OR location_street LIKE '%$query%' OR location_street2 LIKE '%$query%' OR location_phone LIKE '%$query%' ";
  291. 			}
  292. 		} else {
  293. 			$search = '';
  294. 		}
  295. 	}
  297. 	$query_limit = ( ( $current - 1 ) * $items_per_page );
  298. 	$locations   = $wpdb->get_results( $wpdb->prepare( 'SELECT location_id FROM ' . my_calendar_locations_table() . " $search ORDER BY $orderby $query_order LIMIT %d, %d", $query_limit, $items_per_page ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQL.NotPrepared
  299. 	$found_rows  = $wpdb->get_col( 'SELECT COUNT(*) FROM  ' . my_calendar_locations_table() . " $search ORDER BY $orderby $query_order" ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.PreparedSQL.NotPrepared
  300. 	$items       = $found_rows[0];
  301. 	$pagination  = '';
  303. 	$num_pages = ceil( $items / $items_per_page );
  304. 	if ( $num_pages > 1 ) {
  305. 		$page_links = paginate_links(
  306. 			array(
  307. 				'base'      => add_query_arg( 'paged', '%#%' ),
  308. 				'format'    => '',
  309. 				'prev_text' => __( '&laquo; Previous<span class="screen-reader-text"> Locations</span>', 'my-calendar' ),
  310. 				'next_text' => __( 'Next<span class="screen-reader-text"> Locations</span> &raquo;', 'my-calendar' ),
  311. 				'total'     => $num_pages,
  312. 				'current'   => $current,
  313. 				'mid_size'  => 1,
  314. 			)
  315. 		);
  316. 		$nav_label  = esc_attr( __( 'Locations Pagination', 'my-calendar' ) );
  317. 		$pagination = sprintf( "<nav class='tablenav' aria-label='$nav_label'><div class='tablenav-pages'>%s</div></nav>", $page_links );
  318. 	}
  320. 	if ( ! empty( $locations ) ) {
  321. 		echo wp_kses_post( $pagination );
  322. 		?>
  323. 	<div class="mc-admin-header locations">
  324. 		<div class='mc-search'>
  325. 			<form action="<?php echo esc_url( admin_url( 'admin.php?page=my-calendar-location-manager' ) ); ?>" method="post" role='search'>
  326. 				<div>
  327. 					<input type="hidden" name="_wpnonce" value="<?php echo esc_attr( wp_create_nonce( 'my-calendar-nonce' ) ); ?>"/>
  328. 				</div>
  329. 				<div>
  330. 					<label for="mc_search" class='screen-reader-text'><?php esc_html_e( 'Search Locations', 'my-calendar' ); ?></label>
  331. 					<input type='text' name='mcl' id='mc_search' value='<?php echo ( isset( $_POST['mcl'] ) ) ? esc_attr( $_POST['mcl'] ) : ''; ?>'/>
  332. 					<input type='submit' value='<?php esc_attr_e( 'Search', 'my-calendar' ); ?>' class='button-secondary' />
  333. 				</div>
  334. 			</form>
  335. 		</div>
  336. 	</div>
  337. 	<form action="<?php echo esc_url( add_query_arg( $_GET, admin_url( 'admin.php' ) ) ); ?>" method="post">
  338. 		<div><input type="hidden" name="_wpnonce" value="<?php echo esc_attr( wp_create_nonce( 'my-calendar-nonce' ) ); ?>"/></div>
  339. 		<div class='mc-actions'>
  340. 			<input type="submit" class="button-secondary delete" name="mass_delete" value="<?php esc_attr_e( 'Delete locations', 'my-calendar' ); ?>" />
  341. 			<div class="mass-replace-wrap">
  342. 				<input type="checkbox" name="mass_replace_on" disabled id="mass_replace_on" value="true"><label for="mass_replace_on"><?php esc_attr_e( 'Merge duplicates', 'my-calendar' ); ?></label>
  343. 				<div class="mass-replace-container">
  344. 					<label for="mass-replace"><?php esc_html_e( 'Replacement ID', 'my-calendar' ); ?></label><input type="text" size="4" id="mass-replace" name="mass_replace_id" class="mass-replace" value="" />
  345. 					<input type="submit" class="button-secondary delete" name="mass_replace" value="<?php esc_html_e( 'Replace', 'my-calendar' ); ?>" />
  346. 				</div>
  347. 			</div>
  348. 			<div><input type='checkbox' class='selectall' id='mass_edit' data-action="mass_edit" /> <label for='mass_edit'><?php esc_html_e( 'Check all', 'my-calendar' ); ?></label></div>
  349. 		</div>
  350. 		<table class="widefat striped page mc-responsive-table mc-locations-table" id="my-calendar-admin-table">
  351. 			<caption class="screen-reader-text"><?php esc_html_e( 'Location list. Use column headers to sort.', 'my-calendar' ); ?></caption>
  352. 			<thead>
  353. 			<tr>
  354. 				<?php
  355. 				$admin_url = admin_url( "admin.php?page=my-calendar-location-manager&paged=$current&order=" . strtolower( $order ) );
  356. 				$url       = add_query_arg( 'orderby', 'id', $admin_url );
  357. 				$col_head  = mc_table_header( __( 'ID', 'my-calendar' ), $order, $sortby, 'id', $url );
  358. 				$url       = add_query_arg( 'orderby', 'location', $admin_url );
  359. 				$col_head .= mc_table_header( __( 'Location', 'my-calendar' ), $order, $sortby, 'location', $url );
  360. 				$url       = add_query_arg( 'orderby', 'city', $admin_url );
  361. 				$col_head .= mc_table_header( __( 'City', 'my-calendar' ), $order, $sortby, 'city', $url );
  362. 				$url       = add_query_arg( 'orderby', 'state', $admin_url );
  363. 				$col_head .= mc_table_header( __( 'State/Province', 'my-calendar' ), $order, $sortby, 'state', $url );
  364. 				$col_head .= mc_table_header( __( 'Events', 'my-calendar' ), $order, $sortby, 'count', '' );
  365. 				echo wp_kses( $col_head, mc_kses_elements() );
  366. 				/**
  367. 				 * Add custom column table headers to Location Manager.
  368. 				 *
  369. 				 * @hook mc_location_manager_headers
  370. 				 *
  371. 				 * @param {string} $headers HTML output. Appends HTML in the end column of the location manager table row.
  372. 				 *
  373. 				 * @return {string}
  374. 				 */
  375. 				$headers = apply_filters( 'mc_location_manager_headers', '' );
  376. 				echo wp_kses( $headers, mc_kses_elements() );
  377. 				?>
  378. 			</tr>
  379. 			</thead>
  380. 			<tbody>
  381. 			<?php
  382. 			$default_location = mc_get_option( 'default_location', '' );
  383. 			if ( $default_location ) {
  384. 				$default = mc_get_location( $default_location );
  385. 				echo wp_kses( mc_location_manager_row( $default ), mc_kses_elements() );
  386. 			}
  387. 			foreach ( $locations as $loc ) {
  388. 				if ( (int) $default_location === (int) $loc->location_id ) {
  389. 					continue;
  390. 				}
  391. 				$location = mc_get_location( $loc->location_id );
  392. 				echo wp_kses( mc_location_manager_row( $location ), mc_kses_elements() );
  393. 			}
  394. 			?>
  395. 			</tbody>
  396. 		</table>
  397. 		<div class="mc-actions">
  398. 		<p>
  399. 			<input type="submit" class="button-secondary delete" name="mass_delete" value="<?php esc_html_e( 'Delete locations', 'my-calendar' ); ?>" />
  400. 		</p>
  401. 		</div>
  402. 		</form>
  403. 		<?php
  404. 	} else {
  405. 		if ( isset( $_POST['mcl'] ) ) {
  406. 			echo '<p>' . esc_html__( 'No results found for your search query.', 'my-calendar' ) . '</p>';
  407. 		}
  408. 		echo '<p><a class="button" href="' . esc_url( admin_url( 'admin.php?page=my-calendar-locations' ) ) . '">' . esc_html__( 'Create a new location', 'my-calendar' ) . '</a></p>';
  409. 	}
  410. }
  412. /**
  413.  * Verify that a location has valid fields. If a location has no valid data, delete it.
  414.  *
  415.  * @param object $location Location object.
  416.  *
  417.  * @return bool
  418.  */
  419. function mc_verify_location( $location ) {
  420. 	if ( ! is_object( $location ) ) {
  421. 		return true;
  422. 	}
  423. 	$location_id = $location->location_id;
  424. 	$copy        = clone $location;
  425. 	// Unset location ID and location Post, which will always exist.
  426. 	$copy->location_id   = '';
  427. 	$copy->location_post = '';
  428. 	$json                = wp_json_encode( $copy );
  429. 	if ( '{"location_id":"","location_label":"","location_street":"","location_street2":"","location_city":"","location_state":"","location_postcode":"","location_region":"","location_url":"","location_country":"","location_longitude":"0.000000","location_latitude":"0.000000","location_zoom":"16","location_phone":"","location_phone2":"","location_access":"","location_post":""}' === $json ) {
  430. 		if ( $location_id ) {
  431. 			mc_delete_location( $location_id );
  432. 			mc_location_delete_post( true, $location_id );
  433. 		}
  435. 		return false;
  436. 	}
  438. 	return true;
  439. }
  441. /**
  442.  * Generate the location manager row for a location.
  443.  *
  444.  * @param object $location Location object.
  445.  *
  446.  * @return string
  447.  */
  448. function mc_location_manager_row( $location ) {
  449. 	$card            = mc_hcard( $location, 'true', 'false', 'location' );
  450. 	$verify          = mc_verify_location( $location );
  451. 	$count           = mc_count_location_events( $location->location_id );
  452. 	$filters         = array(
  453. 		'filter'   => $location->location_id,
  454. 		'restrict' => 'where',
  455. 	);
  456. 	$location_filter = add_query_arg( $filters, admin_url( 'admin.php?page=my-calendar-manage' ) );
  457. 	if ( $count ) {
  458. 		$count = '<a href="' . esc_url( $location_filter ) . '">' . $count . '</a>';
  459. 	}
  460. 	if ( ! $verify ) {
  461. 		return '';
  462. 	}
  464. 	if ( (int) mc_get_option( 'default_location' ) === (int) $location->location_id ) {
  465. 		$card    = str_replace( '</strong>', ' ' . __( '(Default)', 'my-calendar' ) . '</strong>', $card );
  466. 		$default = '<span class="mc_default">' . __( 'Default Location', 'my-calendar' ) . '</span>';
  467. 	} else {
  468. 		$mcnonce = wp_create_nonce( 'mcnonce' );
  469. 		$url     = add_query_arg( '_mcnonce', $mcnonce, admin_url( "admin.php?page=my-calendar-location-manager&amp;default=$location->location_id" ) );
  470. 		$default = '<a href="' . esc_url( $url ) . '">' . __( 'Set as Default', 'my-calendar' ) . '</a>';
  471. 	}
  472. 	$delete_url = admin_url( "admin.php?page=my-calendar-location-manager&amp;mode=delete&amp;location_id=$location->location_id" );
  473. 	$view_url   = get_the_permalink( mc_get_location_post( $location->location_id, false ) );
  474. 	$edit_url   = admin_url( "admin.php?page=my-calendar-locations&amp;mode=edit&amp;location_id=$location->location_id" );
  475. 	$view_link  = '';
  476. 	if ( $view_url && esc_url( $view_url ) ) {
  477. 		$view_link = "<a href='" . esc_url( $view_url ) . "' class='view' aria-describedby='location" . absint( $location->location_id ) . "'>" . esc_html__( 'View', 'my-calendar' ) . '</a> | ';
  478. 	}
  480. 	/**
  481. 	 * Add custom column table cells to Location Manager.
  482. 	 *
  483. 	 * @hook mc_location_manager_cells
  484. 	 *
  485. 	 * @param {string} $custom_location_cells HTML output. Appends HTML in the end column of the location manager table row.
  486. 	 * @param {object} $location Locatino object.
  487. 	 * @return {string}
  488. 	 */
  489. 	$custom_location_cells = apply_filters( 'mc_location_manager_cells', '', $location );
  491. 	$row  = '';
  492. 	$row .= '
  493. 	<tr>
  494. 		<th scope="row">
  495. 			<input type="checkbox" value="' . absint( $location->location_id ) . '" name="mass_edit[]" id="mc' . absint( $location->location_id ) . '"/>
  496. 			<label for="mc' . absint( $location->location_id ) . '">' . $location->location_id . '</label>
  497. 		</th>
  498. 		<td>' . $card . '
  499. 			<div class="row-actions">' . $view_link . '
  500. 				<a href="' . esc_url( $edit_url ) . '" class="edit" aria-describedby="location' . absint( $location->location_id ) . '">' . esc_html__( 'Edit', 'my-calendar' ) . '</a> | ' . $default . ' | 
  501. 				<a href="' . esc_url( $delete_url ) . '" class="delete" aria-describedby="location' . absint( $location->location_id ) . '">' . esc_html__( 'Delete', 'my-calendar' ) . '</a>
  502. 			</div>
  503. 		</td>
  504. 		<td>' . esc_html( $location->location_city ) . '</td>
  505. 		<td>' . esc_html( $location->location_state ) . '</td>' . $custom_location_cells . '
  506. 		<td>' . $count . '</td>
  507. 	</tr>';
  509. 	return $row;
  510. }