<?php
/**
 * TaggerGetResourcesWhere
 *
 * DESCRIPTION
 *
 * This snippet generate SQL Query that can be used in WHERE condition in getResources snippet
 *
 * PROPERTIES:
 *
 * &tags            string  optional    Comma separated list of Tags for which will be generated a Resource query. By default Tags from GET param will be loaded
 * &groups          string  optional    Comma separated list of Tagger Groups. Only from those groups will Tags be allowed
 * &where           string  optional    Original getResources where property. If you used where property in your current getResources call, move it here
 * &likeComparison  int     optional    If set to 1, tags will compare using LIKE
 * &tagField        string  optional    Field that will be used to compare with given tags. Default: alias
 * &matchAll        int     optional    If set to 1, resource must have all specified tags. Default: 0
 * &field           string  optional    modResource field that will be used to compare with assigned resource ID
 *
 * USAGE:
 *
 * [[!getResources? &where=`[[!TaggerGetResourcesWhere? &tags=`Books,Vehicles` &where=`{"isfolder": 0}`]]`]]
 *
 */

$tagger = $modx->getService('tagger','Tagger',$modx->getOption('tagger.core_path',null,$modx->getOption('core_path').'components/tagger/').'model/tagger/',$scriptProperties);
if (!($tagger instanceof Tagger)) return '';

$tags = $modx->getOption('tags', $scriptProperties, '');
$where = $modx->getOption('where', $scriptProperties, '');
$tagField = $modx->getOption('tagField', $scriptProperties, 'alias');
$likeComparison = (int) $modx->getOption('likeComparison', $scriptProperties, 0);
$matchAll = (int) $modx->getOption('matchAll', $scriptProperties, 0);
$field = $modx->getOption('field', $scriptProperties, 'id');
$where = $modx->fromJSON($where);
if ($where == false) {
    $where = array();
}

$tagsCount = 0;

if ($tags == '') {
    $gc = $modx->newQuery('TaggerGroup');
    $gc->select($modx->getSelectColumns('TaggerGroup', '', '', array('alias')));

    $groups = $modx->getOption('groups', $scriptProperties, '');
    $groups = $tagger->explodeAndClean($groups);
    if (!empty($groups)) {
        $gc->where(array(
            'name:IN' => $groups,
            'OR:alias:IN' => $groups,
            'OR:id:IN' => $groups,
        ));
    }

    $gc->prepare();
    $gc->stmt->execute();
    $groups = $gc->stmt->fetchAll(PDO::FETCH_COLUMN, 0);

    $conditions = array();
    foreach ($groups as $group) {
        if (isset($_GET[$group])) {
            $groupTags = $tagger->explodeAndClean($_GET[$group]);
            if (!empty($groupTags)) {
                $like = array('AND:alias:IN' => $groupTags);

                if ($likeComparison == 1) {
                    foreach ($groupTags as $tag) {
                        $like[] = array('OR:alias:LIKE' => '%' . $tag . '%');
                    }
                }

                $conditions[] = array(
                    'OR:Group.alias:=' => $group,
                    $like
                );
                $tagsCount += count($groupTags);
            }
        }
    }

    if (count($conditions) == 0) {
        return $modx->toJSON($where);
    }

    $c = $modx->newQuery('TaggerTag');
    $c->leftJoin('TaggerGroup', 'Group');

    $c->where($conditions);
} else {
    $tags = $tagger->explodeAndClean($tags);

    if (empty($tags)) {
        return $modx->toJSON($where);
    }

    $tagsCount = count($tags);

    $groups = $modx->getOption('groups', $scriptProperties, '');

    $groups = $tagger->explodeAndClean($groups);

    $c = $modx->newQuery('TaggerTag');
    $c->select($modx->getSelectColumns('TaggerTag', 'TaggerTag', '', array('id')));

    $compare = array(
        $tagField . ':IN' => $tags
    );

    if ($likeComparison == 1) {
        foreach ($tags as $tag) {
            $compare[] = array('OR:' . $tagField . ':LIKE' => '%' . $tag . '%');
        }
    }

    $c->where($compare);

    if (!empty($groups)) {
        $c->leftJoin('TaggerGroup', 'Group');
        $c->where(array(
            'Group.id:IN' => $groups,
            'OR:Group.name:IN' => $groups,
            'OR:Group.alias:IN' => $groups,
        ));
    }
}

$c->prepare();
$c->stmt->execute();
$tagIDs = $c->stmt->fetchAll(PDO::FETCH_COLUMN, 0);

if (count($tagIDs) == 0) {
    $tagIDs[] = 0;
}

if ($matchAll == 0) {
    $where[] = "EXISTS (SELECT 1 FROM {$modx->getTableName('TaggerTagResource')} r WHERE r.tag IN (" . implode(',', $tagIDs) . ") AND r.resource = modResource." . $field . ")";
} else {
    $where[] = "EXISTS (SELECT 1 as found FROM {$modx->getTableName('TaggerTagResource')} r WHERE r.tag IN (" . implode(',', $tagIDs) . ") AND r.resource = modResource." . $field . " GROUP BY found HAVING count(found) = " . $tagsCount . ")";
}

return $modx->toJSON($where);
return;