Output of 2 repeater field blocks to a date list

• taro09

• July 6, 2016 at 11:36 pm

Hello,

due to some reasons I would like to add a 2nd repeater field block to the following jquery, which works fine so far.
the 2nd repeater field block is called ” termineneu” with fields like termineneu_beginn , termineneu_ende ect.

Is it possible ???

<?php
// get all rows from the postmeta table where the sub_field (type) equals 'june, or "06"'
// - http://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results
// $date = date('Ymd');    
  
	$rows = $wpdb->get_results($wpdb->prepare( 
            "
            SELECT * 
            FROM $wpdb->postmeta  pm
            Join wp_posts p ON pm.post_id=p.ID
            WHERE p.post_status = 'publish' AND pm.meta_key LIKE %s
            AND pm.meta_value LIKE %s
            AND pm.meta_value > CURDATE()
           ORDER BY pm.meta_value ASC;
			",     
              't_block_%_beginn', // meta_name: $ParentName_$RowNumber_$ChildName
           "201705__"  // meta_value:
          
		 ));
	
	// loop through the results
	if( $rows )
	{
		foreach( $rows as $row )
		{
// for each result, find the 'repeater row number' and use it to load the info!                            
	preg_match('_([0-9]+)_', $row->meta_key, $matches);
			
 $meta_key_beginn = 't_block_' . $matches[0] . '_beginn'; // $matches[0] contains the row number!
         $beginn_id = get_post_meta( $row->post_id, $meta_key_beginn, true );
         $timestamp_beginn = DateTime::createFromFormat('Ymd', $beginn_id);

         $meta_key_ende = 't_block_' . $matches[0] . '_ende';
         $ende_id = get_post_meta( $row->post_id, $meta_key_ende, true );
         $timestamp_ende = DateTime::createFromFormat('Ymd', $ende_id);
         
         $meta_key_preis = 't_block_' . $matches[0] . '_preis'; // $matches[0] contains the row number!
         $preis = get_post_meta( $row->post_id, $meta_key_preis, true );
         
          $meta_key_buchbar = 't_block_' . $matches[0] . '_buchbar';
          $buchbar = get_post_meta( $row->post_id, $meta_key_buchbar, true );
          
          $meta_key_sprache = 't_block_' . $matches[0] . '_sprache';
          $sprache = get_post_meta( $row->post_id, $meta_key_sprache, true );
     
      echo '<li>' ;
     	echo '<h5>' . $timestamp_beginn->format('d.m.Y') . '  -  ';   
      echo '' .   $timestamp_ende->format('d.m.Y') . ' :';  
      echo '  ' ."<a href='" . get_permalink($row->post_id) . "'>";
      echo get_the_title( $row->post_id ).'   '; 
      echo "</a>"; 
      echo '  ' . $preis . ' € ';
      echo ' ' . $sprache . ' ';
      echo '  ' . $buchbar . '</li></h5>' ;
   
           
             ?>    

                          
			
<?php
 
	}
}
 
?>

• James

• July 7, 2016 at 1:32 pm

Hi @taro09

I’m afraid I don’t understand your request. Could you please explain it in more details? Also, could you please share some screenshots of it?

If you need to query a repeater, please check this article (under the Sub custom field values section): https://www.advancedcustomfields.com/resources/query-posts-custom-fields/.

Thanks 🙂

• taro09

• July 7, 2016 at 7:16 pm

Hello James,

sorry for this confusion.
I try to explain with my bad english .

I have website with lots of travels. Each post is one travel with several traveldates. The above code gives me a list of all dates sorted by the beginning of a travel like:

3.2.16 – 24.2.16 Brasil Price bookable ect.
4.2.16 – 16.2.16 Thailand price
ect.

All dates / informations are repeater fields:
named
t_block_beginn ; t_block_ende ; t_block_price ect.

Now I have to create a 2nd “block” of repeater fields with the same informations and named like
newdates_beginn ; newdates_ende ; newdates_price ect.

This 2nd “newdates – block” of repeater field shloud also be integrated in my query / sorted list …

Hope now its quite understandable 🙂

• James

• July 8, 2016 at 1:43 pm

Hi @taro09

Could you please share the JSON export of the field group? Also, could you please tell me how do you want the data to show up? Do you need to join it or just show it separated? Could you please share some screenshots of the current result and add a note to let me know how you want it to be?

Thanks 🙂

• taro09

• July 12, 2016 at 10:35 pm

This reply has been marked as private.

• James

• July 13, 2016 at 2:02 pm

Hi @taro09

I’m afraid the XML export is not working. Did you modify it? For further investigation, could you please open a new ticket and provide temporary admin credentials to your site? You can open a new ticket here: https://support.advancedcustomfields.com/new-ticket. Also, please don’t forget to explain the issue again and provide the link to this thread.

Thanks 🙂