Advertisement
Guest User

Untitled

a guest
May 23rd, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. $rep_metas = array(
  2.     'cidade',
  3.     'estado',
  4.     'endereco',
  5.     'telefone_1',
  6.     'telefone_2',
  7.     'website',
  8.     'email',
  9.     'marca'
  10. );
  11.  
  12. $sql = "SELECT $wpdb->posts.ID, $wpdb->posts.post_title, $wpdb->posts.post_name, ";
  13.  
  14. foreach ($rep_metas as $key => $post_meta) {
  15.     $sql .= "pm".$key.".meta_value AS ".$post_meta.", ";
  16. }
  17.  
  18. $sql = substr($sql, 0, -2)." ";
  19. $sql .= "FROM $wpdb->posts ";
  20.  
  21. foreach ($rep_metas as $key => $post_meta) {
  22.     $sql .= "
  23.         LEFT OUTER JOIN $wpdb->postmeta pm".$key."
  24.         ON $wpdb->posts.ID = pm".$key.".post_id && pm".$key.".meta_key = '".$post_meta."'
  25.     ";
  26. }
  27.  
  28. $sql .= "WHERE $wpdb->posts.post_status = 'publish' ";
  29. $sql .= "AND $wpdb->posts.post_type = 'distribuidor' ";
  30.  
  31. $sql .= "AND pm1.meta_value = '".$param['estado']."' ";
  32.  
  33. if($param['cidade'] != '0'){
  34.     $sql .= "AND pm0.meta_value = '".$param['cidade']."' ";
  35. }  
  36.  
  37. $sql .= "ORDER BY $wpdb->posts.post_title DESC ";
  38.  
  39.  
  40. $response = $wpdb->get_results($sql, OBJECT );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement