How to skip search results from an unpublished parent with SimpleSearch

[esger]

In a website with many pages, each built from blocks (resources, not folders) with child resources, I want to prevent SimpleSearch returning results from child resources of unpublished blocks and unpublished pages, so the editor does not have to unpublish the child resources as well.
How could this be achieved?

[halftrainedharry]

One possible way to do this, is to use the &exclude property of the SimpleSearch snippet and provide a comma-separated list of resource IDs you want to exclude.

[[!SimpleSearch? &exclude=`[[getChildrenIdsWithUnpublishedParent]]` ...]]

You could generate this list with a custom snippet.
Here is an (untested) snippet that might work:

Snippet getChildrenIdsWithUnpublishedParent

<?php
$q = $modx->newQuery('modResource');
$q->innerJoin('modResource','Parent');
$q->where(array(
    'Parent.published' => 0
));
$q->select($modx->getSelectColumns('modResource', 'modResource', '', array('id')));
$q->prepare();
$q->stmt->execute();
$ids = $q->stmt->fetchAll(PDO::FETCH_COLUMN, 0);
return implode(',',$ids);

[esger]

That’s smart thank you. Would this work for an unpublished parent multiple levels up as well?
I mean a resource could be in an unpublished block(resource) or in a published block that is a child of an unpublished page or even an unpublished folder with pages further up the tree.

[bruno17]

maybe publish/unpublish all child resources with a plugin at onDocFormSave?

[halftrainedharry]

@esger

Would this work for an unpublished parent multiple levels up as well?

This exact solution only works for direct children of an unpublished parent.

If you have deeper hierarchies, then it is probably easier to use the $ids property to restrict the search to a generated list of resource-ids and set the property $idType to documents.

[[!SimpleSearch? &ids=`[[getResourceIdsForSearch]]` &idType=`documents` ...]]

Then write a snippet getResourceIdsForSearch that traverses the resources tree and excludes every branch with an unpublished parent-node.