DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]rideearthtom[/eluser]
I've done a temporary fix by filling an array with the offending sub-query's results and adding where_not_in if count() > 0.

But it seems strange that other subquery types work OK.

Here's the full code, with the working subqueries, and with the broken one replaced with the fix above. The above post was a simplification of the problematic subquery. Maybe this is a DMZ problem, I don't know.

Code:

private function has_documents_to_accept()
    {
        $accepted_documents = new Document();
        $accepted_documents->where_related('sme_profile', 'id', $this->sme_profile->id)
            ->get();
        $ids_1 = array();
        foreach ($accepted_documents as $item)
        {
            $ids_1[] = $item->id;
        }
        $products_purchased = new Product();
        $products_purchased->select('id')
            ->where_related('purchase', 'sme_profile_id', $this->sme_profile->id);
        $join_projects_purchased = new Join_documents_locations_project();
        $join_projects_purchased->select('id')
            ->where_related('project/purchase', 'sme_profile_id', $this->sme_profile->id)
            ->where('location_id', $this->sme_profile->location_id);
        $documents = new Document();
        $documents->where_related_subquery('product', 'id', $products_purchased)
            ->or_where_related_subquery('join_documents_locations_project', 'project_id', $join_projects_purchased);
        if (count($ids_1) > 0)
        {
            $documents->where_not_in('id', $ids_1);
        }
        return $documents->count() > 0 ? TRUE : FALSE;
    }