Thank you for waiting and here is the link to the demo website:
hidden link
Note: I'll share the admin access details, in the next private reply.
Here are some important points/steps:
1. I've added the custom post type "Service Pages" and the custom taxonomies "Locations" and "Brands and Models", exactly as I described in my earlier message:
https://toolset.com/forums/topic/making-a-relationship-with-3-variables/#post-2447001
2. I then added 3 term field groups "Location Fields", "Brand Fields", and "Model Fields" to add associate some demo fields for taxonomies.
3. Next, I added some example terms in the custom taxonomies "Locations" and "Brands and Models" and you can see them at WP Admin -> Service Pages -> Locations and WP Admin -> Service Pages -> Brands and Models
4. After that, I registered a custom shortcode to programmatically generate "Service Pages" posts with all possible combinations from all the terms available in the "Locations" and "Brands and Models" taxonomies. You can see that code at WP Admin -> Toolset -> Settings -> Custom Code, in the snippet named "custom-shortcode-for-auto-service-page-creation":
(it is slightly different from the code that I shared earlier)
add_shortcode('custom_create_service_pages', 'custom_create_service_pages_func');
function custom_create_service_pages_func() {
$target_post_type = 'service-page';
$location_taxonomy = 'location';
$brand_model_taxonomy = 'brand-and-model';
$location_terms = get_terms( $location_taxonomy, array('hide_empty' => false) );
$brand_model_terms = get_terms( $brand_model_taxonomy, array('hide_empty' => false) );
ob_start();
foreach ($location_terms as $location_term) {
foreach ($brand_model_terms as $brand_model_term) {
if ($brand_model_term->parent > 0) {
$current_parent_term = get_term_by('id', $brand_model_term->parent, $brand_model_taxonomy);
$check_title = $location_term->name.' '.$current_parent_term->name.' '.$brand_model_term->name;
$find_args = array("post_type" => $target_post_type, "name" => $check_title);
$found_post = get_posts( $find_args );
if(empty($found_post)) {
$args = array(
'post_type' => $target_post_type,
'post_title' => $check_title,
'post_status' => 'publish',
'tax_input' => array(
$location_taxonomy => array($location_term->term_id),
$brand_model_taxonomy => array($current_parent_term->term_id, $brand_model_term->term_id),
),
);
$post_id = wp_insert_post($args);
if(!is_wp_error($post_id)){
echo 'Post '.$check_title.' with ID '.$post_id.' created!';
echo '<br>';
}else{
echo $post_id->get_error_message();
echo '<br>';
}
}
}
}
}
return ob_get_clean();
}
5. To use this custom shortcode, I created a new page "Page to auto create the service pages" and in its content added this shortcode:
[custom_create_service_pages]
When I visited the front end of this page, this shortcode created 27 posts in the "Service Pages" post type. When there are some new posts to be created using the terms in those custom taxonomies, you'll see the list of the created posts. But if posts of all possible combinations have already been created, it won't show anything.
When you've added more terms in those custom taxonomies, you can visit that page's front end again and it will add "Service Pages" posts for their possible combination too.
6. To show the content of the individual "Service Pages" posts, I create a new content template "CT for Service Pages" from WP Admin -> Toolset -> Content Templates and assigned it to be used for the Service Pages" posts.
7. I felt another custom shortcode was needed to get the current "Service Pages" post's attached location, brand, or model. For that, I registered another custom shortcode at WP Admin -> Toolset -> Settings -> Custom Code, in the snippet named "custom-shortcode-to-get-current-tax-term-id":
add_shortcode('get_terms_by_level', 'get_terms_by_level_func');
function get_terms_by_level_func($atts) {
$level = $atts['level'];
$return = $atts['return'];
$postid = do_shortcode('[wpv-post-id]');
$location_taxonomy = 'location';
$brand_model_taxonomy = 'brand-and-model';
$results = array();
if($level == 'location') {
$target_tax = $location_taxonomy;
} elseif ( ($level == 'brand') || ($level == 'model') ) {
$target_tax = $brand_model_taxonomy;
}
$terms = get_the_terms( $postid, $target_tax);
if ( $terms && ! is_wp_error( $terms ) ) {
foreach ($terms as $term) {
if( ($level == 'model') && ($term->parent != 0) ) {
$results[] = $term;
} elseif ( ($level != 'model') && ($term->parent == 0) ) {
$results[] = $term;
}
}
if(!empty($results)) {
ob_start();
foreach ($results as $result) {
if($return == 'id') {
echo $result->term_id;
} elseif($return == 'name') {
echo $result->name;
} elseif($return == 'link') {
echo '<a href="' . esc_url( get_term_link( $result->term_id, $target_tax) ) . '">' . $result->name . '</a>';
}
}
return ob_get_clean();
}
}
}
I also added "get_terms_by_level" shortcode name in the "Third-party shortcode arguments" section, at WP Admin -> Toolset -> Settings -> Front-end Content.
This single custom shortcode can be used to get either 'id', 'name', or 'term archive link' for the connected 'location', 'brand', or 'model'.
It accepts two attributes:
a). level: which can be 'location', 'brand', or 'model'
b). return: which can be 'id', 'name', or 'link'
Examples of usage:
// Get location term data:
Location ID:
[get_terms_by_level level='location' return='id']
Location Name:
[get_terms_by_level level='location' return='name']
Location Archive Link:
[get_terms_by_level level='location' return='link']
// Get brand term data:
Brand ID:
[get_terms_by_level level='brand' return='id']
Brand Name:
[get_terms_by_level level='brand' return='name']
Brand Archive Link:
[get_terms_by_level level='brand' return='link']
// Get model term data:
Model ID:
[get_terms_by_level level='model' return='id']
Model Name:
[get_terms_by_level level='model' return='name']
Model Archive Link:
[get_terms_by_level level='model' return='link']
You can see these shortcodes in use in the content template "CT for Service Pages" too. I've added them in different colored containers so that data from each type of term/object is easy to spot.
8. Once the ID of the connected taxonomy term is known, it can be used in the content template to get the term field data, using the Types Fields API:
https://toolset.com/documentation/customizing-sites-using-php/functions/
Examples of using term field data can also be seen in use in the content template "CT for Service Pages":
Location Field 1:
[types termmeta="location-field-1" term_id="[get_terms_by_level level='location' return='id']"][/types]
Location Field 2:
[types termmeta="location-field-2" term_id="[get_terms_by_level level='location' return='id']"][/types]
Brand Field 1:
[types termmeta="brand-field-1" term_id="[get_terms_by_level level='brand' return='id']"][/types]
Brand Field 2:
[types termmeta="brand-field-2" term_id="[get_terms_by_level level='brand' return='id']"][/types]
Model Field 1:
[types termmeta="model-field-1" term_id="[get_terms_by_level level='model' return='id']"][/types]
Model Field 2:
[types termmeta="model-field-2" term_id="[get_terms_by_level level='model' return='id']"][/types]
So, in summary, you can see how each of those 27 'service page' posts shows dynamic content on the front end, from the attached taxonomy terms, without having any actual content in the posts themself. You'll change the data in the taxonomy term fields and it will automatically reflect/update on the relevant 'service page' posts too and you won't have to edit each of them.
I hope this demo website and explanation will make it more clear.
