Knowledge Base

copy_resource_nodes()

Description

Copy resource nodes from one resource to another. Only applies for active metadata fields.

Parameters

Column	Type	Default	Description
$resourcefrom	integer		Resource we are copying data from
void	$resourceto:
for	check
$resourceto	integer		Resource we are copying data to

Location

include/node_functions.php lines 1621 to 1686

Definition

 
function copy_resource_nodes($resourcefrom, $resourceto): void
    {
    $omit_fields_sql = '';
    $omit_fields_sql_params = array();
    $omitfields = array();

    // When copying normal resources from one to another, check for fields that should be excluded
    // NOTE: this does not apply to user template resources (negative ID resource)
    if($resourcefrom > 0)
        {
        $omitfields = ps_array("SELECT ref AS `value` FROM resource_type_field WHERE omit_when_copying = 1", array(), "schema");
        }

    // Exclude fields which user cannot edit "F?" or cannot see "f-?". With config, users permissions maybe overridden for different resource types.
    global $userpermissions;

    $no_permission_fields = array();
    foreach ($userpermissions as $permission_to_check)
        {
        if (substr($permission_to_check, 0, 2) == "f-")
            {
            $no_permission_fields[] = substr($permission_to_check, 2);
            }
        elseif (substr($permission_to_check, 0, 1) == "F")
            {
            $no_permission_fields[] = substr($permission_to_check, 1);
            }
        }
    
    $omitfields = array_merge($omitfields, array_unique($no_permission_fields));

    if (count($omitfields) > 0)
        {
        $omit_fields_sql = " AND n.resource_type_field NOT IN (" . ps_param_insert(count($omitfields)) . ") ";
        $omit_fields_sql_params = ps_param_fill($omitfields, "i");
        }
    else
        {
        $omit_fields_sql = "";
        }

    // This is for logging after the insert statement
    $nodes_to_add = ps_array("
    SELECT node value
        FROM resource_node AS rnold
    LEFT JOIN node AS n ON n.ref = rnold.node
    WHERE resource = ?
        AND n.`active` = 1
        {$omit_fields_sql};
    ", array_merge(array("i", (int) $resourcefrom), $omit_fields_sql_params));

    ps_query("
        INSERT INTO resource_node(resource, node, hit_count, new_hit_count)
             SELECT ?, node, 0, 0
               FROM resource_node AS rnold
          LEFT JOIN node AS n ON n.ref = rnold.node
          LEFT JOIN resource_type_field AS rtf ON n.resource_type_field = rtf.ref
              WHERE resource = ?
              AND rtf.active = 1
                AND n.`active` = 1
                {$omit_fields_sql}
                 ON DUPLICATE KEY UPDATE hit_count = rnold.new_hit_count;
    ", array_merge(array("i", $resourceto, "i", $resourcefrom), $omit_fields_sql_params));

    log_node_changes($resourceto,$nodes_to_add,array());
    }


This article was last updated 26th April 2024 07:05 Europe/London time based on the source file dated 15th April 2024 11:30 Europe/London time.