get_posts hijos únicos de ciertos padres
3 respuestas
- votos
-
- 2011-11-22
Tiene dos opciones:
-
Llame aget_posts varias veces: unapara laspáginasprincipalesmediante
post__in => array(2,4)
y dospara laspáginas secundarias de cadapadre conpost_parent => 2
ypost_parent => 4
yfinalmentefusionartodos los resultadosen una solamatriz. -
Escriba directamente su consulta SQL y use
$wpdb->get_results
.Consulte este artículo porejemplo.En su caso,sería algo similar al siguiente código (noprobado):$query_sql = " SELECT * FROM $wpdb->posts WHERE post_type = 'products' AND (ID IN (2,4) OR post_parent IN (2,4)) ORDER BY post_date DESC "; $query_result = $wpdb->get_results($query_sql, OBJECT);
You have two options:
Call get_posts multiple times: one for the parent pages using
post__in => array(2,4)
, and two for the child pages of each parent withpost_parent => 2
andpost_parent => 4
and finally merge all the results into a single array.Write directly your SQL query and use
$wpdb->get_results
. See this article for an example. In your case it would be something similar to the following (not tested) code:$query_sql = " SELECT * FROM $wpdb->posts WHERE post_type = 'products' AND (ID IN (2,4) OR post_parent IN (2,4)) ORDER BY post_date DESC "; $query_result = $wpdb->get_results($query_sql, OBJECT);
-
elprimeroesmalo,porqueno séel recuentoexacto de ID quepodría haber.El segundome parecebien.Lointentaré.the first on is bad, becouse I dont know exact count of Ids there might be. The second on seem good to me. Ill try.
- 0
- 2011-11-22
- jam
-
- 2011-11-22
$args = array('orderby' => 'date','order' => 'DESC','post_type' => 'products', 'include' => '2, 4'); // get the 2 and 4 posts $children = get_posts($args); // get the children of 2, and merge arrays $children = array_merge($children,get_posts(array('orderby' => 'date','order' => 'DESC','post_type' => 'products','post_parent'=>2))); // get the children of 4, and merge arrays $children = array_merge($children,get_posts(array('orderby' => 'date','order' => 'DESC','post_type' => 'products','post_parent'=>4))); foreach($children as $child){ // etc }
Aunque seríamuchomásfácil/rápido sipudieraetiquetarlosen unataxonomíapersonalizada oidentificarlos de alguna otramanerapara que solonecesitarabuscar una cosa,en lugar de 3 cosas.
p.ej. situviéramos unataxonomíapersonalizada 'productos destacados',podríamos hacer:
$children = get_posts('post_type' => 'products', 'orderby' => 'date','order' => 'DESC','highlighted_products' => 'example_page'); foreach($children as $child){ // etc }
Lo que seríamuchomásflexible,menospropenso aerrores (¡los ID 2 y 4podrían cambiar! No codifique),yesmuchomás rápido de hacer,sin SQL sinprocesar o consultasmúltiples. Sinmencionar que ahoratiene unainterfaz de usuario agradable yfácil de usaren elbackend donde simplementeetiqueta unapublicación deproductos y apareceen el lugar correcto
$args = array('orderby' => 'date','order' => 'DESC','post_type' => 'products', 'include' => '2, 4'); // get the 2 and 4 posts $children = get_posts($args); // get the children of 2, and merge arrays $children = array_merge($children,get_posts(array('orderby' => 'date','order' => 'DESC','post_type' => 'products','post_parent'=>2))); // get the children of 4, and merge arrays $children = array_merge($children,get_posts(array('orderby' => 'date','order' => 'DESC','post_type' => 'products','post_parent'=>4))); foreach($children as $child){ // etc }
Although it would be much much easier/faster if you could tag them in a custom taxonomy or identify them some other way so that you were only needing to look for one thing, rather than 3 things.
e.g. if we had a custom taxonomy 'highlighted_products' we might do:
$children = get_posts('post_type' => 'products', 'orderby' => 'date','order' => 'DESC','highlighted_products' => 'example_page'); foreach($children as $child){ // etc }
Which would be far more flexible, less prone to errors ( ID 2 and 4 might change! Don't hardcode ), and it's a lot faster to do, no raw SQL or multiple queries. Not to mention that you now have a nice user friendly UI in the backend where you just tag a products post and it appears in the right place
-
- 2013-11-13
$children = get_posts('post_parent=SLUG_OF_PARENT_POST&post_status=publish'); foreach($children as $child) { echo '<br/>ID:'.$child->ID; }
puede utilizar otros atributos (es decir,
$child->post_content
) ... sinecesita definirpost_type,agregueeste argumentotambién:&post_type=POST_TYPE_NAME
$children = get_posts('post_parent=SLUG_OF_PARENT_POST&post_status=publish'); foreach($children as $child) { echo '<br/>ID:'.$child->ID; }
you can use other attributes (i.e.
$child->post_content
)... if you need to define post_type, then add this argument too :&post_type=POST_TYPE_NAME
Tengopublicacionesparapadres (tipo depublicaciónpersonalizadajerarquía=verdadero) con ID 1,2,3,4.
Laspublicacionesprincipales con ID 2 y 4tienen páginas secundarias.
Necesito recuperar solo laspublicaciones 2 y 4 ytodas suspáginas secundarias.
Algo comoesto
¿Cómopuedoeditarestopara devolverpáginas secundarias de los IDincluidos?