/** * @return mixed */ public function prepareQueryBeforeCount(xPDOQuery $c) { $c->select($this->modx->getSelectColumns('modManagerLog', 'modManagerLog', '', array('action'), true)); // $c->select($this->modx->getSelectColumns('modManagerLog','modManagerLog')); $c->select(array('User.username', 'Template.templatename', 'Chunk.name as chunkname', 'Snippet.name as snippetname', 'Plugin.name as pluginname', 'TV.name as tvname')); $c->innerJoin('modUser', 'User'); $c->leftJoin('modTemplate', 'Template', '`modManagerLog`.item = `Template`.`id` AND `modManagerLog`.`classKey` = "modTemplate"'); $c->leftJoin('modChunk', 'Chunk', '`modManagerLog`.item = `Chunk`.`id` AND `modManagerLog`.`classKey` = "modChunk"'); $c->leftJoin('modSnippet', 'Snippet', '`modManagerLog`.item = `Snippet`.`id` AND `modManagerLog`.`classKey` = "modSnippet"'); $c->leftJoin('modPlugin', 'Plugin', '`modManagerLog`.item = `Plugin`.`id` AND `modManagerLog`.`classKey` = "modPlugin"'); $c->leftJoin('modTemplateVar', 'TV', '`modManagerLog`.item = `TV`.`id` AND `modManagerLog`.`classKey` = "modTemplateVar"'); $query = trim($this->getProperty('query')); if ($query) { $c->where('(Template.templatename LIKE "%' . $query . '%" OR Chunk.name LIKE "%' . $query . '%" OR Snippet.name LIKE "%' . $query . '%" OR Plugin.name LIKE "%' . $query . '%" OR TV.name LIKE "%' . $query . '%")'); } else { $c->where('(modManagerLog.action LIKE "template_%" OR modManagerLog.action LIKE "chunk_%" OR modManagerLog.action LIKE "snippet_%" OR modManagerLog.action LIKE "plugin_%" OR modManagerLog.action LIKE "tv_%")'); } $user = intval($this->getProperty('user')); if ($user) { $c->andCondition(array('modManagerLog.user' => $user)); } $dateStart = trim($this->getProperty('datestart')); if ($dateStart) { $dateStart = date('Y-m-d', strtotime($dateStart)); $c->andCondition(array('modManagerLog.occurred:>=' => $dateStart)); } $dateEnd = trim($this->getProperty('dateend')); if ($dateEnd) { $dateEnd = date('Y-m-d 23:59:59', strtotime($dateEnd)); $c->andCondition(array('modManagerLog.occurred:<=' => $dateEnd)); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $contextKey = $this->getProperty('cntx'); if (!empty($contextKey)) { $c->andCondition(array('context_key' => $contextKey)); } $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('id' => $query, 'OR:pagetitle:LIKE' => '%' . $query . '%')); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('pattern:LIKE' => '%' . $query . '%', 'OR:target:LIKE' => '%' . $query . '%')); } $context = $this->getProperty('context'); if (!empty($context)) { $c->andCondition(array('context_key:LIKE' => '%' . $context . '%')); } return $c; }
/** * @return mixed */ public function prepareQueryBeforeCount(xPDOQuery $c) { $c->leftJoin('modUser', 'UserCreate'); $c->select('adminNotes.*, UserCreate.username'); $where = '(adminNotes.private = 0 OR adminNotes.private = 1 AND adminNotes.createdby = ' . $this->modx->user->get('id') . ')'; $query = trim($this->getProperty('searchQuery')); $wheresearch = trim($this->getProperty('wheresearch')); if ($query) { switch ($wheresearch) { case 1: case '': $where .= ' AND (adminNotes.title LIKE "%' . $query . '%" OR adminNotes.text LIKE "%' . $query . '%" OR FIND_IN_SET(\'' . $query . '\', `tags`))'; break; case 2: $where .= ' AND adminNotes.title LIKE "%' . $query . '%"'; break; case 3: $where .= ' AND adminNotes.text LIKE "%' . $query . '%"'; break; case 4: $where .= " AND FIND_IN_SET('{$query}', `tags`)"; break; } } $c->where($where); $private = $this->getProperty('private'); if ($private) { $c->andCondition(array('adminNotes.createdby' => $this->modx->user->id)); } return $c; }
/** * Filter on status and add task data * * @param xPDOQuery $c * @return xPDOQuery */ public function prepareQueryBeforeCount(xPDOQuery $c) { $c->innerJoin('sTask', 'Task'); $c->select($this->modx->getSelectColumns($this->classKey, $this->classKey)); $c->select($this->modx->getSelectColumns('sTask', 'Task', 'task_')); $c->where($this->additionalWhere); $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('Task.reference:LIKE' => '%' . $query . '%')); } $namespace = $this->getProperty('namespace'); if (!empty($namespace)) { $c->andCondition(array('Task.namespace' => $namespace)); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $query = trim($this->getProperty('query')); if ($query !== '') { $c->andCondition(array('conversation:LIKE' => "%{$query}%")); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $form = $this->getProperty('formId'); $startDate = $this->getProperty('startDate'); $endDate = $this->getProperty('endDate'); if (!empty($form)) { $c->where(array('form_id' => $form)); } if (!empty($startDate)) { $c->andCondition(array('senton:>' => date('Y-m-d', strtotime($startDate)) . ' 00:00:00')); } if (!empty($endDate)) { $c->andCondition(array('senton:<' => date('Y-m-d', strtotime($endDate)) . ' 23:59:59')); } // var_dump($form, date('Y-m-d H:i:s', strtotime($startDate)), date('Y-m-d H:i:s', strtotime($endDate))); die; return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('id' => $query, 'OR:name:LIKE' => '%' . $query . '%')); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $c->where(array('key:!=' => 'mgr')); $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('key:LIKE' => '%' . $query . '%')); } return $c; }
/** * Can be used to adjust the query prior to the COUNT statement * * @param xPDOQuery $c * @return xPDOQuery */ public function prepareQueryBeforeCount(xPDOQuery $c) { $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('modResource.pagetitle:LIKE' => '%' . $query . '%', 'OR:modResource.longtitle:LIKE' => '%' . $query . '%', 'OR:modResource.menutitle:LIKE' => '%' . $query . '%', 'OR:modResource.description:LIKE' => '%' . $query . '%')); } $c->where(array('class_key:=' => 'GridContainer', 'OR:class_key:=' => 'StaticGridContainer')); return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $c->innerJoin('modUser', 'Sender'); $c->where(array('recipient' => $this->modx->user->get('id'))); $search = $this->getProperty('search', ''); if (!empty($search)) { $c->andCondition(array('subject:LIKE' => '%' . $search . '%', 'OR:message:LIKE' => '%' . $search . '%'), null, 2); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $c->select(array('qsbButton.*', 'Icon.class AS iconcls', 'Icon.path as iconpath')); $c->leftJoin('qsbIcon', 'Icon'); $c->where(array('set' => $this->getProperty('id'))); $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('id' => $query, 'OR:text:LIKE' => '%' . $query . '%')); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $form = $this->getProperty('form'); if (!empty($form)) { $c->where(array('form' => $form)); } $context_key = $this->getProperty('context_key'); if (!empty($context_key)) { $c->where(array('context_key' => $context_key)); } $startDate = $this->getProperty('startDate'); if ($startDate != '') { $c->andCondition(array('date:>' => strtotime($startDate . ' 00:00:00'))); } $endDate = $this->getProperty('endDate'); if ($endDate != '') { $c->andCondition(array('date:<' => strtotime($endDate . ' 23:59:59'))); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $selected = $this->getProperty('selected'); if (!empty($selected)) { $newSort = 'FIELD(id, ' . $selected . ') DESC, ' . $this->defaultSortField; $this->setProperty('sort', $newSort); } $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('name:LIKE' => '%' . $query . '%', 'OR:class:LIKE' => '%' . $query . '%')); } return $c; }
/** * Only load variations for current test. * * @param xPDOQuery $c * @return xPDOQuery */ public function prepareQueryBeforeCount(xPDOQuery $c) { $c->select($this->modx->getSelectColumns($this->classKey, $this->classKey)); // search $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('reference:LIKE' => '%' . $query . '%', 'OR:description:LIKE' => '%' . $query . '%', 'OR:namespace:LIKE' => '%' . $query . '%')); } // filter on class key $classKey = $this->getProperty('class_key'); if (!empty($classKey)) { $c->andCondition(array('class_key' => $classKey)); } // implement runs $subc = $this->modx->newQuery('sTaskRun'); $subc->select($this->modx->getSelectColumns('sTaskRun', 'sTaskRun', '', array('timing'))); $subc->where(array('status' => sTaskRun::STATUS_SCHEDULED, '`sTaskRun`.`task` = `sTask`.`id`')); $subc->sortby('timing', 'asc'); $subc->limit(1); $subc->prepare(); $c->select('(' . $subc->toSQL() . ') AS next_run'); return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $where = array(); if ($res = $this->getProperty('res')) { $where['res'] = $res; } $where['Language.active'] = 1; if ($ctx = $this->getProperty('context')) { $c->leftJoin('XlexiconLanguage', 'Language', "Language.iso_code = {$this->classKey}.language"); $c->andCondition(array('Language.context:REGEXP' => "(^|.+,){$ctx}(,.+|\$)")); } $c->where($where); return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $cronid = $this->getProperty('cronid'); if (!empty($cronid)) { $c->where(array('cronjob' => $cronid)); } $error = $this->getProperty('error', 'all'); if ($error != 'all') { $c->where(array('error' => $error)); } $query = $this->getProperty('query'); if (!empty($query)) { $c->andCondition(array('message:LIKE' => '%' . $query . '%')); } return $c; }
public function prepareQueryBeforeCount(xPDOQuery $c) { $ugns = $this->modx->user->getUserGroupNames(); $userGroupNames = ''; foreach ($ugns as $ugn) { $userGroupNames .= '"' . $ugn . '",'; } $userGroupNames = rtrim($userGroupNames, ','); $c->leftJoin('modUser', 'Author'); $c->leftJoin('modResource', 'Resource'); $c->innerJoin('quipThread', 'Thread'); $c->where(array('quipComment.deleted' => $this->getProperty('deleted', false), 'quipComment.approved' => false)); /* handle moderator permissions */ $c->andCondition(array('( Thread.moderated = 0 OR Thread.moderator_group IN (' . $userGroupNames . ') OR "' . $this->modx->user->get('username') . '" IN (Thread.moderators) )')); $thread = $this->getProperty('thread'); if (!empty($thread)) { $c->where(array('quipComment.thread' => $thread)); } return $c; }