<?php
if (!defined('ABSPATH'))
{
	exit;
}

//job_listing_table_shortcode_pro
//10.1.9
function job_listing_table_shortcode_free($atts)
{
	global $table_prefix,$wpdb,$post;

	$args = array( 'post_type' => 'job_listing', 'post_status' => 'publish' );

	$job_listingarray = array();
	$m_single = array();
	$searchFormEnable = '';

	$enableGlossarySearchForm = get_option("enableGlossarySearchForm"); //!!! 14.3.2
	
	$return_content = '';
	$return_content .= '<div class="tooltips_directory">';

	//14.2.4
	$limit_sql = '';

	if (isset($atts['searchform']))
	{
		$searchFormEnable = $atts['searchform'];
	}

	$post_type = 'job_listing';
	$sql = $wpdb->prepare( "SELECT ID, post_title, post_content, post_excerpt FROM $wpdb->posts WHERE post_type=%s AND post_status='publish' order by post_title ASC $limit_sql",$post_type);

	$results = $wpdb->get_results( $sql );


	$show_glossary_page_current_result = $results;

	//16.2.8
	$enableGlossaryCatNameUnderTerm = get_option("enableGlossaryCatNameUnderTerm");
	
	//!!! old works well if ((!(empty($results))) && (is_array($results)) && (count($results) >0))
	
	//!!! 12.7.6 start
	$return_content .= '<div class="tooltips_list_start">';
	
	
	if ((!(empty($show_glossary_page_current_result))) && (is_array($show_glossary_page_current_result)) && (count($show_glossary_page_current_result) >0))
	{
		$m_single = array();
		//!!! old works well foreach ($results as $single)
		
		foreach ($show_glossary_page_current_result as $single)
		{
			//!!! 15.0.8
			if (empty($single->post_title))
			{
				continue ;
			}
			//!!! end 15.0.8
			
			$return_content .= '<div class="tooltips_list">';
			$return_content .= '<span class="tooltips_table_items">';
			$return_content .= '<div class="tooltips_table">';
			$return_content .= '<div class="tooltips_table_title">';
			$enabGlossaryIndexPage =  get_option("enabGlossaryIndexPage");
			if (empty($enabGlossaryIndexPage))
			{
				$enabGlossaryIndexPage = 'YES';
			}
				
			if ($enabGlossaryIndexPage == 'YES')
			{
			    //7.9.3
			    // before 9.5.9 $return_content .=	'<a href="'.esc_url(get_permalink($single->ID)).'">'.$single->post_title.'</a>';
				$return_content .=	'<a href="'.esc_url(get_permalink($single->ID)).'">'.esc_html($single->post_title).'</a>';
				//$return_content .=	'<a href="'.get_permalink($single->ID).'">'.$single->post_title.'</a>';
			}
			else
			{
				// before 9.5.9 $return_content .=	$single->post_title;
				//9.5.9
				$return_content .=	esc_html($single->post_title);
			}
			//16.2.8 end
			$return_content .='</div>';
			$return_content .= '<div class="tooltips_table_content">';

			$glossaryExcerptOrContentSelect = get_option("glossaryExcerptOrContentSelect");
			
			if ($glossaryExcerptOrContentSelect == 'glossaryexcerpt')
			{
			    
				// old $m_content= get_the_excerpt($single->ID);
				// $m_content = wp_trim_excerpt($single->post_content); //!!! 14.0.4
				// before 25.0.8 $m_content =  wp_trim_excerpt('',$single->ID);  //!!! 14.2.8
			    $m_content =  ''; //25.0.8
				//14.5.2
				if (empty($single->post_excerpt))
				{
				    
					//$m_content =  wp_trim_excerpt('',$single->ID);
				    
					//before 27.0.8 $excerpt_more = apply_filters('excerpt_more', ' ' . '[&hellip;]');
                    //27.0.8
                    $excerpt_more = tt_excerpt_more_free($single->ID,'Read More');

				    $excerpt_length = 20;
				    $m_content = tt_wp_trim_words_free( $single->post_content, $excerpt_length, $excerpt_more );
				    
				}
				else 
				{
				    
					$m_content =  $single->post_excerpt;
				}
				//end 14.5.2
			}
				
			if ($glossaryExcerptOrContentSelect == 'glossarycontent')
			{
			    
				$m_content = $single->post_content;
			}

			//14.1.0
			if (empty($glossaryExcerptOrContentSelect))
			{
			    
				$m_content = $single->post_content;
			}

			$m_content = do_shortcode($m_content);

			$return_content .=	$m_content;
			$return_content .='</div>';
			$return_content .='</div>';
			$return_content .='</span>';
			$return_content .='</div>';
			
		}
	}
	$return_content .='</div>'; // job_listing_list_start  12.7.6
	//!!! 12.7.4 start

	
	$return_content .= '</div>';

	return $return_content;
}


//add_shortcode( 'joblistingtable', 'job_listing_table_shortcode_pro',10 );
//add_shortcode( 'jobmanagerdirectory', 'job_listing_table_shortcode_pr',10 );
//10.1.9
add_shortcode( 'joblistingtable', 'job_listing_table_shortcode_free',10 );
add_shortcode( 'jobmanagerdirectory', 'job_listing_table_shortcode_free',10 );

//!!! 14.0.4
//function disabletooltipforjob_listingdirectory()
//10.1.9
function disabletooltipforjob_listingdirectory_free()
{
	$tooltipforleftcolumnglossarytable = get_option("tooltipforleftcolumnglossarytable");
	$tooltipforrightcolumnglossarytable = get_option("tooltipforrightcolumnglossarytable");
	
	if ((empty($tooltipforleftcolumnglossarytable)) || ($tooltipforleftcolumnglossarytable == 'NO'))
	{
		{
			echo '<script type="text/javascript">';
			// $disabletooltipforclassandidsSingle = trim($disabletooltipforclassandidsSingle);
			//!!! 15.3.4 disabletooltipforclassandidSinglei = jQuery(this).html(); 
			?>
			jQuery(document).ready(function () {
				jQuery('.tooltips_table_items .tooltips_table_title .tooltipsall').each
				(function()
				{
				disabletooltipforclassandidSinglei = jQuery(this).text();
				jQuery(this).replaceWith(disabletooltipforclassandidSinglei);
				})
			})
			<?php 
			echo '</script>';
		}
	}
	
	//14.0.8
	if ((empty($tooltipforrightcolumnglossarytable)) || ($tooltipforrightcolumnglossarytable == 'NO'))
	{
		{
			echo '<script type="text/javascript">';
			// $disabletooltipforclassandidsSingle = trim($disabletooltipforclassandidsSingle);
			?>
				jQuery(document).ready(function () {
					jQuery('.tooltips_table_items .tooltips_table_content .tooltipsall').each
					(function()
					{
					disabletooltipforclassandidSinglei = jQuery(this).html();
					jQuery(this).replaceWith(disabletooltipforclassandidSinglei);
					})
				})
				<?php 
				echo '</script>';
			}
	}
		

}
//add_action('wp_footer','disabletooltipforjob_listingdirectory');
//10.1.9
add_action('wp_footer','disabletooltipforjob_listingdirectory_free');