public function prepareQueryBeforeCount(xPDOQuery $c)
{
$c = parent::prepareQueryBeforeCount($c);
$alias = $c->getAlias();
$c->select(array("{$alias}.*", "{$alias}.pathRelative as relativeUrl"));
$where = array("source" => $this->source->id);
// Скрытие файлов
if ($this->getProperty('hideFiles')) {
$where['type!:='] = 'file';
}
// Фильтр файлов по названию
if ($query = trim($this->getProperty('query'))) {
$c->where(array('name:like' => "%{$query}%", 'OR:tags:like' => "%{$query}%"));
}
/*
Только свои
*/
if ($this->getProperty('own_only')) {
$c->where(array('createdby' => $this->modx->user->id, 'OR:modifiedby:=' => $this->modx->user->id));
}
$c->where($where);
# $c->prepare();
# print $c->toSQL();
# exit;
# if($where = $this->getProperty('where')){
# $c->where($where);
# }
return $c;
}
public function prepareQueryBeforeCount(xPDOQuery $c)
{
$c = parent::prepareQueryBeforeCount($c);
$c->select(array("`{$this->classKey}`.*"));
return $c;
}
