[[getResources? &parents=`51` &tpl=`company_deal_maker` &sortby=`pagetitle` &sortdir=`ASC` &includeTVs=`1` &processTVs=`1` &tvPrefix=`` &showHidden=`1` &tvFilters=`membership_status>=100,deal_name!=''` &limit=`` ]]
$c = $modx->newQuery('modResource'); $c->innerJoin('modTemplateVarResource','TemplateVarResources'); $c->innerJoin('modTemplateVar','TemplateVar','`TemplateVar`.`id` = `TemplateVarResources`.`tmplvarid`'); $c->where(array( array( 'parent' => 51, 'published' => true, 'deleted' => false, ), array( array( 'TemplateVar.name' => 'membership_status', 'TemplateVarResources.value:>=' => 100, ), array( 'TemplateVar.name' => 'deal_name', 'TemplateVarResources.value:!=' => '' ) ) )); $c->sortby('pagetitle'); $collection = $modx->getCollection('modResource',$c); foreach ($collection as $o) { $output .= '<br />' . $o->get('pagetitle') . ' (' . $o->get('id') . ')'; } return $output;
<?php $c = $modx->newQuery('modResource'); $c->innerJoin('modTemplateVarResource','TemplateVarResources'); $c->innerJoin('modTemplateVar','TemplateVar','`TemplateVar`.`id` = `TemplateVarResources`.`tmplvarid`'); $c->where(array( 'parent' => 51, 'published' => true, 'deleted' => false, array( array( 'TemplateVar.name' => 'membership_status', 'TemplateVarResources.value:>=' => 100 ), array( 'TemplateVar.name' => 'deal_name', 'TemplateVarResources.value:!=' => '' ), ) )); $c->sortby('pagetitle'); $collection = $modx->getIterator('modResource',$c); foreach ($collection as $o) { $output .= ',' . $o->get('pagetitle') . ' (' . $o->get('id') . ')'; } return $output;
$c = $modx->newQuery('modResource'); $c->innerJoin('modTemplateVarResource', 'tv_member', array('tv_member.name' => 'membership_status')); $c->innerJoin('modTemplateVar', 'tv_member_val', array('tv_member_val.tmplvarid = tv_member.id', 'tv_member_val.content_id = modResource.id')); $c->innerJoin('modTemplateVarResource', 'tv_deal', array('tv_deal.name' => 'deal_name')); $c->innerJoin('modTemplateVar', 'tv_deal_val', array('tv_deal_val.tmplvarid = tv_deal.id', 'tv_deal_val.content_id = modResource.id')); $c->where(array( 'parent' => 51, 'published' => 1, 'deleted' => 0, 'tv_member_val.value:>=' => 100, 'tv_deal_val:!=' => '' )); $c->sortby('pagetitle'); $collection = $modx->getCollection('modResource',$c); foreach ($collection as $o) { $output .= '' . $o->get('pagetitle') . ' (' . $o->get('id') . ')'; } return $output;
$c->prepare(); echo $c->toSQL(); exit();