update_status( 'completed' );
}
add_filter( 'job_manager_enable_job_archive_page', '__return_false' );
add_filter( 'get_job_listings_cache_results', '__return_false' );
// Intercept the shortcode’s WP_Query args and replace the normal "s" search
add_filter( 'get_job_listings_query_args', function( $query_args, $args ) {
if ( ! empty( $args['search_keywords'] ) ) {
$raw = trim( $args['search_keywords'] );
// split on commas if present, otherwise on whitespace
if ( strpos( $raw, ',' ) !== false ) {
$pieces = preg_split( '/\s*,\s*/', $raw, -1, PREG_SPLIT_NO_EMPTY );
} else {
$pieces = preg_split( '/\s+/', $raw, -1, PREG_SPLIT_NO_EMPTY );
}
// sanitize + dedupe
$terms = array_unique( array_map( 'sanitize_text_field', $pieces ) );
if ( $terms ) {
// stash for our later WHERE-clause and turn off the normal "s" keyword search
$query_args['wpjm_title_search'] = $terms;
unset( $query_args['s'] );
}
}
return $query_args;
}, 20, 2 );
// 2) When WP_Query runs, inject a WHERE clause so post_title LIKE term1 OR term2 …
add_filter( 'posts_where', function( $where, $wp_query ) {
if ( is_admin() ) {
return $where;
}
// only target the [jobs] queries
if ( $wp_query->get( 'post_type' ) !== 'job_listing' ) {
return $where;
}
$terms = $wp_query->get( 'wpjm_title_search' );
if ( empty( $terms ) ) {
return $where;
}
global $wpdb;
$likes = [];
foreach ( (array) $terms as $term ) {
$likes[] = $wpdb->prepare( "{$wpdb->posts}.post_title LIKE %s", '%' . $wpdb->esc_like( $term ) . '%' );
}
if ( $likes ) {
// require at least one of them
$where .= ' AND ( ' . implode( ' OR ', $likes ) . ' ) ';
}
return $where;
}, 10, 2 );
// 1. Trigger the import
function wpai_cron_trigger_import() {
wp_remote_get(
'https://redsealrecruiting.com/wp-load.php?import_key=bm4-iJbCAs&import_id=1&action=trigger'
);
}
add_action( 'wpai_cron_trigger_import', 'wpai_cron_trigger_import' );
// 2. Process the import in batches
function wpai_cron_process_import() {
wp_remote_get(
'https://redsealrecruiting.com/wp-load.php?import_key=bm4-iJbCAs&import_id=1&action=processing'
);
}
add_action( 'wpai_cron_process_import', 'wpai_cron_process_import' );
add_filter('the_content', function ($content) {
if (get_post_type() !== 'job_listing') return $content;
// Remove style="" from any HTML tag
return preg_replace('/(<[a-z0-9:-]+\b[^>]*?)\sstyle\s*=\s*(?:"[^"]*"|\'[^\']*\')/i', '$1', $content);
}, 20);
/**
* WooCommerce Email: Show Job Posting/Closing dates before Order Summary
*/
add_action('woocommerce_email_before_order_table', function ( $order, $sent_to_admin, $plain_text, $email ) {
// Only for the "Completed order" email sent to the customer
if ( ! $email || ! isset( $email->id ) || $email->id !== 'customer_completed_order' ) {
return;
}
if ( ! $order instanceof WC_Order ) {
return;
}
$date_format = get_option('date_format');
$tz = wp_timezone();
$jobs_found = [];
// Helper: normalize date strings (e.g., '2025-07-24', timestamps) to localized display
$fmt = function( $raw ) use ( $date_format, $tz ) {
if ( empty( $raw ) ) return '';
// If looks like a timestamp
if ( is_numeric( $raw ) ) {
$dt = (new DateTime())->setTimestamp( (int) $raw )->setTimezone( $tz );
return wp_date( $date_format, $dt->getTimestamp(), $tz );
}
// If looks like YYYY-MM-DD (WPJM commonly stores like this)
if ( preg_match('/^\d{4}-\d{2}-\d{2}$/', $raw) ) {
try {
$dt = new DateTime( $raw, $tz );
return wp_date( $date_format, $dt->getTimestamp(), $tz );
} catch ( Exception $e ) { /* fall through */ }
}
// Fallback: let WordPress try
$ts = strtotime( $raw );
return $ts ? wp_date( $date_format, $ts, $tz ) : esc_html( $raw );
};
// Collect job listings referenced by order items
foreach ( $order->get_items() as $item ) {
if ( ! $item instanceof WC_Order_Item_Product ) continue;
$meta = $item->get_meta_data();
$meta_map = [];
foreach ( $meta as $m ) {
$meta_map[ $m->key ] = $m->value;
}
// Common meta keys used by WC Paid Listings / WP Job Manager checkout
$possible_keys = ['_job_id','_job_listing_id','job_id','job_listing_id'];
$job_id = null;
foreach ( $possible_keys as $key ) {
if ( ! empty( $meta_map[ $key ] ) && absint( $meta_map[ $key ] ) ) {
$job_id = absint( $meta_map[ $key ] );
break;
}
}
if ( ! $job_id ) continue;
if ( get_post_type( $job_id ) !== 'job_listing' ) continue;
$post = get_post( $job_id );
$posting_date_disp = $fmt( $post->post_date );
// Closing date priority: job expiry, then application deadline (if you use it)
$expiry_raw = get_post_meta( $job_id, '_job_expires', true );
$deadline_raw = get_post_meta( $job_id, '_application_deadline', true );
$closing_label = '';
$closing_disp = '';
if ( ! empty( $expiry_raw ) ) {
$closing_label = __( 'Job Closing Date', 'your-textdomain' );
$closing_disp = $fmt( $expiry_raw );
} elseif ( ! empty( $deadline_raw ) ) {
$closing_label = __( 'Application Deadline', 'your-textdomain' );
$closing_disp = $fmt( $deadline_raw );
}
$jobs_found[] = [
'id' => $job_id,
'title' => get_the_title( $job_id ),
'posting_date' => $posting_date_disp,
'closing_label' => $closing_label,
'closing_date' => $closing_disp,
'permalink' => get_permalink( $job_id ),
];
}
if ( empty( $jobs_found ) ) return;
// ===== Output =====
if ( $plain_text ) {
echo "\n";
echo "—— Job Details ——\n";
foreach ( $jobs_found as $j ) {
echo sprintf( "%s (ID #%d)\n", $j['title'], $j['id'] );
echo sprintf( "Posting Date: %s\n", $j['posting_date'] ?: '-' );
if ( $j['closing_label'] ) {
echo sprintf( "%s: %s\n", $j['closing_label'], $j['closing_date'] ?: '-' );
}
echo "\n";
}
echo "——————————————\n\n";
return;
}
// HTML block styled to match Woo emails
?>
'',
'mode' => 'both',
),
$atts
);
if(empty($atts['sheet'])){
return 'Salary data not available.
'; } wp_enqueue_script('chartjs'); wp_enqueue_script('rsr-salary-chart'); /* ----------------------------- CACHE CSV ----------------------------- */ $cache_key = 'rsr_salary_csv_' . md5($atts['sheet']); $csv = get_transient($cache_key); if(false === $csv){ $response = wp_remote_get( esc_url_raw($atts['sheet']), array('timeout'=>15) ); if(is_wp_error($response)){ return 'Unable to load salary data.
'; } $csv = wp_remote_retrieve_body($response); if(!$csv){ return 'No salary data found.
'; } set_transient($cache_key,$csv,HOUR_IN_SECONDS); } $rows = array_map('str_getcsv', explode("\n", trim($csv))); if(empty($rows)){ return 'No salary data found.
'; } /* ----------------------------- TITLE ROW ----------------------------- */ $title=''; $first_row = reset($rows); if($first_row && count(array_filter($first_row)) === 1){ $title = trim($first_row[0]); array_shift($rows); } $header = array_shift($rows); /* ----------------------------- DETECT COLUMNS ----------------------------- */ $province_idx = null; $city_idx = null; $wage_idx = null; $comp_idx = null; $date_idx = null; $skip_cols = array(); foreach($header as $i=>$name_raw){ $name = trim($name_raw); if(null === $province_idx && strcasecmp($name,'Province')===0){ $province_idx = $i; } elseif(strcasecmp($name,'Province')===0){ $skip_cols[] = $i; } if(null === $city_idx && stripos($name,'City') !== false){ $city_idx = $i; } if(null === $wage_idx && stripos($name,'Wage (number only') !== false){ $wage_idx = $i; $skip_cols[] = $i; } if(null === $comp_idx && stripos($name,'Compensation') !== false){ $comp_idx = $i; } if(null === $date_idx && stripos($name,'Date Collected') !== false){ $date_idx = $i; } if(strcasecmp($name,'Next Raise')===0) $skip_cols[]=$i; if(strcasecmp($name,'Contact Person/Number')===0) $skip_cols[]=$i; if(strcasecmp($name,'Date Collected')===0) $skip_cols[]=$i; if(stripos($name,'City Wage')!==false){ $skip_cols[]=$i; } } /* ----------------------------- LARGE CITY LIST ----------------------------- */ $allowed_cities = array( 'Toronto','Montreal','Calgary','Ottawa','Edmonton','Winnipeg','Mississauga','Vancouver','Brampton','Hamilton', 'Surrey','Quebec City','Halifax','Laval','London','Markham','Vaughan','Gatineau','Saskatoon','Kitchener', 'Longueuil','Burnaby','Windsor','Regina','Oakville','Richmond','Richmond Hill','Burlington','Oshawa','Sherbrooke', 'Greater Sudbury','Abbotsford','Lévis','Coquitlam','Barrie','Saguenay','Kelowna','Guelph','Trois-Rivières','Whitby', 'Cambridge','St. Catharines','Milton','Langley','Kingston','Ajax','Waterloo','Terrebonne','Saanich','St. John\'s', 'Thunder Bay','Delta','Brantford','Chatham-Kent','Clarington','Red Deer','Nanaimo','Strathcona County','Pickering', 'Lethbridge','Kamloops','Saint-Jean-sur-Richelieu','Niagara Falls','Cape Breton','Chilliwack','Victoria','Brossard', 'Maple Ridge','North Vancouver','Newmarket','Repentigny','Peterborough','Saint-Jérôme','Moncton','Drummondville', 'Kawartha Lakes','New Westminster','Prince George','Caledon','Airdrie','Wood Buffalo','Sault Ste. Marie','Sarnia', 'Saint John','Granby','St. Albert','Norfolk County','Grande Prairie','Medicine Hat','Fredericton','Halton Hills', 'Aurora','Port Coquitlam','Mirabel','Blainville','Saint-Hyacinthe','Welland','Belleville','North Bay' ); /* ----------------------------- BUILD DATA ----------------------------- */ $city_values=array(); $prov_values=array(); foreach($rows as $cols){ if(empty(array_filter($cols))){ continue; } $city = (null!==$city_idx && isset($cols[$city_idx])) ? trim($cols[$city_idx]) : ''; $province = (null!==$province_idx && isset($cols[$province_idx])) ? trim($cols[$province_idx]) : ''; /* ----------------------------- DATE FILTER (last 2 years) ----------------------------- */ if(null!==$date_idx && isset($cols[$date_idx])){ $date_raw = trim($cols[$date_idx]); if($date_raw){ $timestamp = strtotime($date_raw); if($timestamp && $timestamp < strtotime('-2 years')){ continue; } } } /* ----------------------------- CITY FILTER (chart only) ----------------------------- */ $city_for_chart = $city; if($city_for_chart && !in_array($city_for_chart,$allowed_cities,true)){ $city_for_chart=''; } $wage=null; if(null!==$wage_idx && isset($cols[$wage_idx])){ $wage_str = trim($cols[$wage_idx]); if(''!==$wage_str){ $wage_str = str_replace(array(',',' '),'',$wage_str); if(is_numeric($wage_str)){ $wage = (float)$wage_str; } } } if(null===$wage && null!==$comp_idx && isset($cols[$comp_idx])){ $wage = rsr_parse_compensation_to_number($cols[$comp_idx]); } if(null!==$wage && ($wage<=0 || $wage>200)){ $wage=null; } if(null===$wage){ continue; } if($city_for_chart){ $city_values[$city_for_chart][]=$wage; } if($province){ $prov_values[$province][]=$wage; } } /* ----------------------------- CITY AVERAGE + MEDIAN ----------------------------- */ $city_labels=array(); $city_avg=array(); $city_median=array(); foreach($city_values as $city_name=>$values){ sort($values); $count=count($values); if(!$count) continue; $avg=array_sum($values)/$count; $middle=floor(($count-1)/2); $median = ($count%2) ? $values[$middle] : ($values[$middle]+$values[$middle+1])/2; $city_labels[]=$city_name; $city_avg[]=$avg; $city_median[]=$median; } /* ----------------------------- PROVINCE AVERAGE + MEDIAN ----------------------------- */ $prov_labels=array(); $prov_avg=array(); $prov_median=array(); foreach($prov_values as $prov_name=>$values){ sort($values); $count=count($values); if(!$count) continue; $avg=array_sum($values)/$count; $middle=floor(($count-1)/2); $median = ($count%2) ? $values[$middle] : ($values[$middle]+$values[$middle+1])/2; $prov_labels[]=$prov_name; $prov_avg[]=$avg; $prov_median[]=$median; } /* ----------------------------- LIMIT CITY COUNT ----------------------------- */ $max_cities=12; $city_combined=array(); foreach($city_labels as $i=>$label){ $city_combined[]=array( 'label'=>$label, 'avg'=>$city_avg[$i], 'median'=>$city_median[$i], ); } usort($city_combined,function($a,$b){ return $b['avg'] <=> $a['avg']; }); $city_combined=array_slice($city_combined,0,$max_cities); $city_labels=array(); $city_avg=array(); $city_median=array(); foreach($city_combined as $row){ $city_labels[]=$row['label']; $city_avg[]=$row['avg']; $city_median[]=$row['median']; } /* ----------------------------- FINAL PAYLOAD ----------------------------- */ $chart_payload=array( 'city'=>array( 'labels'=>$city_labels, 'avg'=>$city_avg, 'median'=>$city_median, ), 'province'=>array( 'labels'=>$prov_labels, 'avg'=>$prov_avg, 'median'=>$prov_median, ), ); /* ----------------------------- OUTPUT ----------------------------- */ ob_start(); echo '| '; echo esc_html($title); echo ' |
|---|
| '.esc_html($heading).' | '; } echo '
| '.esc_html($c).' | '; } echo '