get_resources_nodes_by_rtf()

Description

Get all resource nodes associated for a specific resource type field.

Parameters

ColumnTypeDefaultDescription
$ref integer Resource type field ID

Return

Generator

Location

include/node_functions.php lines 1373 to 1398

Definition

 
function get_resources_nodes_by_rtf(int $ref)
{
    $offset = null;
    do {
        $rows = 1000;
        $sql_limit = sql_limit($offset, $rows);
        $offset += $rows;

        $parameters = [];
        $sql = columns_in("node", "n");
        add_sql_node_language($sql, $parameters, "n");

        $parameters = array_merge($parameters, ['i', $ref]);
        $data = ps_query(
            "SELECT " . $sql . "
                  FROM resource_node AS rn
            INNER JOIN node AS n ON rn.node = n.ref AND n.resource_type_field = ?
            INNER JOIN resource AS r ON rn.resource = r.ref
            $sql_limit",
            $parameters
        );
        foreach ($data as $page_data) {
            yield $page_data;
        }
    } while (!empty($data) && count($data) === $rows);
}

This article was last updated 14th March 2025 20:35 Europe/London time based on the source file dated 3rd February 2025 20:05 Europe/London time.