Help with code

[acerby12]

pls help with code, its for latest post jobs , i modified it with random , but i need to show just featured jobs, what is needed to change?

now it shows all jobs

 

 

 

 

 

<?php

global $wp_query;
$query_vars = $wp_query->query_vars;


$job_category  = $query_vars['job_category'];
$page  = $query_vars['page'];
$my_page = $page;
$job_sort  = $query_vars['job_sort'];
$job_tax  = $query_vars['job_tax'];
$term_search = $query_vars['term_search'];


if(empty($term_search)) $term_search = $_GET['term_search'];


//---------- 


if(empty($job_category))  $job_category  = "all";
if(empty($page))  $page  = "1";
if(empty($job_sort))  $job_sort  = "";
if(empty($job_tax))  $job_tax  = "category";


if($job_tax == "category") 
$job_tax2 = "job_cat";
else 
$job_tax2 = "job_location";


//---------- 


if($job_category != "all" and $job_tax == "category")
{
$term_ct = get_term_by('slug', $job_category, 'job_cat');  
$posted_jobs = sprintf(__('All %s Jobs','PricerrTheme'), $term_ct->name); 
}


elseif($job_category != "all" and $job_tax == "location")
{


$term_ct = get_term_by('slug', $job_category, 'job_location');  
$posted_jobs = sprintf(__('All Jobs in %s','PricerrTheme'), $term_ct->name); 
}


else
{
$posted_jobs = __('All Posted Jobs','PricerrTheme'); 
}


if(1) //!sitemile_check_if_home())
{
echo '<h3 class="widget-title">'.$posted_jobs.'</h3>';
}


?>


        
        
         <?php


$view = pricerrtheme_get_current_view_grid_list();
echo '<div class="switchers">';
echo '<div class="switch_view_link">'.__('Switch View:','PricerrTheme').'</div>';


if($view != "grid")
{
echo '<a href="'.pricerrtheme_switch_link_from_home_page('grid').'" class="grid"></a>';
echo '<a href="'.pricerrtheme_switch_link_from_home_page('list').'" class="list-selected"></a>';
}
else
{
echo '<a href="'.pricerrtheme_switch_link_from_home_page('grid').'" class="grid-selected"></a>';
echo '<a href="'.pricerrtheme_switch_link_from_home_page('list').'" class="list"></a>';
}
echo '</div>';


?>
        


<?php


function jobTheme_posts_where( $where ) {


global $wpdb, $term; 
$where .= " AND ({$wpdb->posts}.post_title LIKE '%$term%' OR {$wpdb->posts}.post_content LIKE '%$term%')";


return $where;
}


global $term, $wpdb;
$term = $term_search;


if(!empty($term_search))
{
$term  = $term_search;
$where_term  = " AND ("; // AND (posts.post_title LIKE '%$term%' OR posts.post_content LIKE '%$term%')";


$split_stemmed = split ( " ", $term );




while ( list ( $key,$val ) = each ( $split_stemmed ) )
{
 if( $val!='' && strlen ( $val ) > 0 )
 {
$where_term .= "( posts.post_title LIKE '%".$val."%' OR  posts.post_content LIKE '%".$val."%') OR ";
 }
}


$where_term .= " 0!=0 )";


}




global $wpdb; 
$prefix  = $wpdb->prefix;
$nrpostsPage  = 10;


$PricerrTheme_show_limit_job_cnt = get_option('PricerrTheme_show_limit_job_cnt');
if(!empty($PricerrTheme_show_limit_job_cnt)) $nrpostsPage = $PricerrTheme_show_limit_job_cnt;






if($job_category != "all") 
{
$tmp = "select term_id from ".$prefix."terms where slug='$job_category'";
$res = $wpdb->get_results($tmp);
$term_id = $res[0]->term_id;


$ors = ' OR 0=1 ';


$childs = get_term_children( $term_id, $job_tax2 );    
foreach($childs as $child)
{
$term_id_ms = $child; 
$tmp1 = "select term_taxonomy_id from ".$prefix."term_taxonomy where term_id='$term_id_ms' AND taxonomy='$job_tax2'";
$res1 = $wpdb->get_results($tmp1);
$term_id1 = $res1[0]->term_taxonomy_id; 


$ors .= " OR tax.term_taxonomy_id='$term_id1' "; 
}


//echo $ors;


$tmp = "select term_taxonomy_id from ".$prefix."term_taxonomy where term_id='$term_id' AND taxonomy='$job_tax2'";
$res = $wpdb->get_results($tmp);
$term_id = $res[0]->term_taxonomy_id;


$cate_inner = " INNER JOIN ".$prefix."term_relationships tax ON (posts.ID = tax.object_id) "; 
$cate_where = " AND (tax.term_taxonomy_id='$term_id' ".$ors. " )  ";


//$cate = " posts.ID=tax.object_id AND tax.term_taxonomy_id='$term_id' AND ";


}




if($job_sort == 'popularity')
{ 
$likes_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) "; 
$likes_where = " AND (meta7.meta_key = 'likes' )  ";
$likes_sort  = " meta7.meta_value+0 DESC ,  ";
}


if($job_sort == 'views')
{ 
$views_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) "; 
$views_where = " AND (meta7.meta_key = 'views' )  ";
$views_sort  = " meta7.meta_value+0 DESC ,  ";
}


if($job_sort == 'express')
{ 
$views_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) "; 
$views_where = " AND (meta7.meta_key = 'max_days' ) AND (meta7.meta_value = '1' )  ";
$views_sort  = " meta7.meta_value+0 DESC ,  ";
}


if($job_sort == 'instant')
{ 
$views_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) "; 
$views_where = " AND (meta7.meta_key = 'instant' ) AND (meta7.meta_value = '1' )  ";
$views_sort  = " meta7.meta_value+0 DESC ,  ";
}


if($job_sort == 'rating')  
{
$rating_inner = " INNER JOIN ".$prefix."postmeta meta5 ON (posts.ID = meta5.post_id) "; 
$rating_where = " AND (meta5.meta_key = 'rating' )  ";
$rating_sort  = " meta5.meta_value+0 DESC ,  ";
}


if($job_sort == 'videos')  
{ 
$hasvideo_inner = " INNER JOIN ".$prefix."postmeta AS meta9 ON (posts.ID = meta9.post_id) "; 
$hasvideo_where = " AND (meta9.meta_key = 'has_video' ) AND (meta9.meta_value = '1' ) ";
} 




if($job_sort == 'pictures')  
{ 
$haspictures_where = " AND EXISTS (select ID from ".$prefix."posts second_posts where 
second_posts.post_parent=posts.ID AND post_type='attachment' AND post_mime_type like '%image%' LIMIT 1) ";
} 


//----------------------------------------------


$closed_inner = " INNER JOIN ".$prefix."postmeta AS meta89 ON (posts.ID = meta89.post_id) "; 
$closed_where = " AND (meta89.meta_key = 'closed' ) AND (meta89.meta_value = '0' ) ";


$active_inner = " INNER JOIN ".$prefix."postmeta AS meta88 ON (posts.ID = meta88.post_id) "; 
$active_where = " AND (meta88.meta_key = 'active' ) AND (meta88.meta_value = '1' ) ";


//----------------------------------------------






$featured_sort = "";
if($job_sort == "auto") $featured_sort = "meta1.meta_value+0 ASC, ";


//---------------------------------------------------------------


$sql = "SELECT SQL_CALC_FOUND_ROWS posts.* FROM ".$prefix."posts posts 
INNER JOIN ".$prefix."postmeta meta1 ON (posts.ID = meta1.post_id)  
INNER JOIN ".$prefix."postmeta AS meta3 ON (posts.ID = meta3.post_id) ". $closed_inner ." ". $active_inner. " ".$cate_inner."
".$hasvideo_inner." ".$rating_inner." ".$views_inner." ".$likes_inner." ".$cate_where."
WHERE ".$cate." posts.post_type = 'job' AND (posts.post_status = 'publish') 
AND meta1.meta_key = 'featured' ".$where_term." AND meta3.meta_key = 'closed' AND meta3.meta_value = '0'  
".$hasvideo_where." ".$closed_where." ".$active_where." ".$rating_where." ".$likes_where." ".$views_where." ".$haspictures_where."
GROUP BY posts.ID  ORDER BY ".$featured_sort." ".$rating_sort." ".$views_sort." ".$likes_sort." posts.post_modified  desc ";




//----------------------------------------------------------------


$sql_temp = "SELECT SQL_CALC_FOUND_ROWS posts.ID FROM ".$prefix."posts posts 
INNER JOIN ".$prefix."postmeta meta1 ON (posts.ID = meta1.post_id)  
INNER JOIN ".$prefix."postmeta AS meta3 ON (posts.ID = meta3.post_id) ". $closed_inner ." ". $active_inner. " ".$cate_inner."
".$hasvideo_inner." ".$rating_inner." ".$views_inner." ".$likes_inner." ".$cate_where."
WHERE ".$cate." posts.post_type = 'job' AND (posts.post_status = 'publish') 
AND meta1.meta_key = 'featured' ".$where_term." AND meta3.meta_key = 'closed' AND meta3.meta_value = '0'  
".$hasvideo_where." ".$closed_where." ".$active_where." ".$rating_where." ".$likes_where." ".$views_where." ".$haspictures_where."
GROUP BY posts.ID  ORDER BY ".$featured_sort." ".$rating_sort." ".$views_sort." ".$likes_sort." posts.post_modified  desc ";


//---------------------------------------------------------------
//echo $sql;
$limit = " LIMIT ".($nrpostsPage * ($page - 1) ).", $nrpostsPage ";
//mysql_query($sql) or die(mysql_error());


//echo $sql;


//$totalposts = $wpdb->get_results($sql_temp, OBJECT); 




//$nrposts = count($totalposts);
//$totalPages = ceil($nrposts / $nrpostsPage);
//$pagess = $totalPages;




//====================================================


// The Loop


//$pageposts = $wpdb->get_results($sql.$limit, OBJECT);
//$posts_per = 5;


$nrpostsPage = 20;
$nrpostsPage_home_page = get_option('PricerrTheme_nrpostsPage_home_page');
if(!empty($nrpostsPage_home_page)) $nrpostsPage = $nrpostsPage_home_page;


//-------------------------------------




$pj = get_query_var('paged');


$meta_querya = array(array(
'key' => 'active',
'value' => "1",
'compare' => '='
) );


$args = array('posts_per_page' => $nrpostsPage, 'paged' => $pj, 'post_type' => 'job', 'order' => "DESC" , 'meta_query' => $meta_querya ,'meta_key' => 'featured', 'orderby'=> 'rand' );
$the_query = new WP_Query( $args );




if($the_query->have_posts()):
while ( $the_query->have_posts() ) : $the_query->the_post();


?>
                     
                     
                     <?php 
                     
if($view != "grid")
PricerrTheme_get_post();
else
PricerrTheme_get_post_thumbs();
                     
                     ?>
                     
                     
                     <?php endwhile; ?>
         <?php


$pricerrtheme_show_pagination_homepage = get_option('pricerrtheme_show_pagination_homepage');
if($pricerrtheme_show_pagination_homepage != "yes"):


?>
         <div class="show_all_jobs">
             <a href="<?php echo get_post_type_archive_link('job') ?>"><?php _e('Show All Jobs','PricerrTheme'); ?></a>            
            </div>
     
        
         <?php else:
if(function_exists('wp_pagenavi')):
echo '<div class="my_pagination">';
wp_pagenavi( array( 'query' => $the_query ) );
echo '</div>'; endif;
endif;
?>
        
        
                     <?php else : ?> <?php $no_p = 1; ?>
                       <div class="padd100"><p class="center"><?php _e("Sorry, there are no posted jobs yet",'PricerrTheme'); ?>.</p></div>
                        
                     <?php  endif; ?>

Edited August 1, 2016 by Barand

[ginerjm]

#1 - please post code in the proper code tags

#2 - Don't understand much about your question other than "it shows all jobs"

#3 - Why do you think we need to see ALL THIS CODE? Can't you pinpoint where you think your problem is?

#4 - If I took a guess I would have to say that you need to filter what your query is calling for. Change your where clause to only select what you want to display.

[cyberRobot]

Did you write the code? If not, where does the code come from?

[ginerjm]

And maybe you could do what Good Programmers do and add some COMMENTS to the code so we can follow it. And perhaps you could restructure it so that the php is segregated from the html to make it easier to decipher and follow and maintain. And since the only query execution statement is commented out, maybe you could show us how you are retrieving this data? And when you have solved this problem maybe you could make the transition to a new db interface such as mysqlI or PDO since you are only doctoring up outdated code that is soon going to break and not be useable.

 

So much work to do.