/** * @param \T4\Dbal\Query $query * @return \T4\Dbal\Query */ public function modifyQuery(Query $query) : Query { if (empty($this->value)) { return $query; } $query->order($this->getColumnName() . ' ' . $this->getValue()); return $query; }
public function modifyQuery(Query $query) : Query { if ('' === $this->value || null === $this->value) { return $query; } if (empty($query->where)) { $query->where('TRUE'); } $query->where($query->where . ' AND CAST(' . $this->name . ' AS DATE) = :' . $this->name)->param(':' . $this->name, $this->value); return $query; }
public function modifyQuery(Query $query) : Query { if ('' === $this->value || null === $this->value) { return $query; } if (empty($query->where)) { $query->where('TRUE'); } $query->where($query->where . ' AND ' . $this->name . ' LIKE ' . $this->getConnection()->quote('%' . $this->value . '%')); return $query; }
/** * @param string $key * @param array $options * @return mixed * @throws Exception */ public function getRelationLazy($key, $options = []) { /** @var \T4\Orm\Model $class */ $class = get_class($this); $relations = $class::getRelations(); if (empty($relations[$key])) { throw new Exception('No such column or relation: ' . $key . ' in model of ' . $class . ' class'); } $relation = $relations[$key]; switch ($relation['type']) { case $class::BELONGS_TO: /** @var \T4\Orm\Model $relationClass */ $relationClass = $relation['model']; $thisColumnName = $class::getRelationLinkName($relation); $thatColumnName = $class::getBelongsToThatLinkColumnName($relation); $subModel = $relationClass::findByColumn($thatColumnName, $this->{$thisColumnName}, $options); if (empty($subModel)) { return null; } else { return $subModel; } break; case $class::HAS_ONE: /** @var \T4\Orm\Model $relationClass */ $relationClass = $relation['model']; $thisColumnName = $class::getHasOneThisLinkColumnName($relation); $thatColumnName = $class::getRelationLinkName($relation); $subModel = $relationClass::findByColumn($thatColumnName, $this->{$thisColumnName}, $options); if (empty($subModel)) { return null; } else { return $subModel; } break; case $class::HAS_MANY: /** @var \T4\Orm\Model $relationClass */ $relationClass = $relation['model']; $thisColumnName = $class::getHasManyThisLinkColumnName($relation); $thatColumnName = $class::getRelationLinkName($relation); return $relationClass::findAllByColumn($thatColumnName, $this->{$thisColumnName}, $options); break; case $class::MANY_TO_MANY: /** @var \T4\Orm\Model $relationClass */ $relationClass = $relation['model']; $linkTable = $class::getRelationLinkName($relation); $pivots = $relationClass::getPivots($class, $key); if (!empty($pivots)) { $pivotColumnsSql = ', ' . implode(', ', array_map(function ($x) { return 'j1.' . $x; }, array_keys($pivots))); } else { $pivotColumnsSql = ''; } $query = new Query(); $query->select('t1.*' . $pivotColumnsSql)->from($relationClass::getTableName())->join($linkTable, 't1.' . $relationClass::PK . '=j1.' . static::getManyToManyThatLinkColumnName($relation), 'left')->where('(j1.' . static::getManyToManyThisLinkColumnName($relation) . '=:id)' . (isset($options['where']) ? ' AND (' . $options['where'] . ')' : '')); if (isset($options['order'])) { $query->order($options['order']); } $query->params([':id' => $this->getPk()]); /** @var \T4\Orm\Model $relationClass */ $result = $relationClass::getDbConnection()->query($query)->fetchAllObjects($relationClass); if (!empty($result)) { $ret = new Collection($result); $ret->setNew(false); return $ret; } else { return new Collection(); } } }
protected function delete(Migration $migration) { $query = new Query(); if ($this->app->db->default->getDriverName() == 'mysql') { $column = '`time`'; } else { $column = '"time"'; } $query->delete()->table(self::TABLE_NAME)->where($column . '=:time')->params([':time' => $migration->getTimestamp()]); $this->app->db->default->execute($query); }
public function __call($method, $argv) { /** @var \T4\Orm\Model $model */ $model = $argv[0]; array_shift($argv); /* @var \T4\Orm\Model $class */ $class = get_class($model); $tableName = $class::getTableName(); /** @var \T4\Dbal\Connection $connection */ $connection = $class::getDbConnection(); switch ($method) { case 'refreshTreeColumns': $sql = (new Query())->select(['__lft', '__rgt', '__lvl', '__prt'])->from($tableName)->where($class::PK . '=:id')->params([':id' => $model->getPk()]); $columns = $connection->query($sql)->fetch(\PDO::FETCH_ASSOC); $model->merge($columns); return $model; case 'getTreeWidth': if ($model->isNew()) { return 1; } else { return $model->__rgt - $model->__lft; } case 'findAllParents': $query = new Query(); $query->select('*')->from($class::getTableName())->where('__lft<:lft AND __rgt>:rgt')->order('__lft')->params([':lft' => $model->__lft, ':rgt' => $model->__rgt]); return $class::findAllByQuery($query); case 'findAllChildren': $query = new Query(); $query->select('*')->from($class::getTableName())->where('__lft>:lft AND __rgt<:rgt')->order('__lft')->params([':lft' => $model->__lft, ':rgt' => $model->__rgt]); return $class::findAllByQuery($query); case 'hasChildren': $query = new Query(); $query->select('COUNT(*)')->from($class::getTableName())->where('__lft>:lft AND __rgt<:rgt')->order('__lft')->params([':lft' => $model->__lft, ':rgt' => $model->__rgt]); return 0 != $connection->query($query)->fetchScalar(); case 'findSubTree': $query = new Query(); $query->select('*')->from($class::getTableName())->where('__lft>=:lft AND __rgt<=:rgt')->order('__lft')->params([':lft' => $model->__lft, ':rgt' => $model->__rgt]); return $class::findAllByQuery($query); case 'hasPrevSibling': $query = new Query(); $query->select('COUNT(*)')->from($class::getTableName())->where('__rgt<:lft AND __prt=:prt')->params([':lft' => $model->__lft, ':prt' => $model->__prt]); return 0 != $connection->query($query)->fetchScalar(); case 'getPrevSibling': $query = new Query(); $query->select('*')->from($class::getTableName())->where('__rgt<:lft AND __prt=:prt')->order('__lft DESC')->limit(1)->params([':lft' => $model->__lft, ':prt' => $model->__prt]); return $class::findByQuery($query); case 'hasNextSibling': $query = new Query(); $query->select('COUNT(*)')->from($class::getTableName())->where('__lft>:rgt AND __prt=:prt')->params([':rgt' => $model->__rgt, ':prt' => $model->__prt]); return 0 != $connection->query($query)->fetchScalar(); case 'getNextSibling': $query = new Query(); $query->select('*')->from($class::getTableName())->where('__lft>:rgt AND __prt=:prt')->order('__lft')->limit(1)->params([':rgt' => $model->__rgt, ':prt' => $model->__prt]); return $class::findByQuery($query); case 'insertBefore': $element = $argv[0]; $this->insertModelBeforeElement($model, $element); return $model; break; case 'insertAfter': $element = $argv[0]; $this->insertModelAfterElement($model, $element); return $model; break; case 'moveToFirstPosition': $parent = $model->parent; if (empty($parent)) { $this->insertModelAsFirstRoot($model); } else { $this->insertModelAsFirstChildOf($model, $parent); } return $model; case 'moveToLastPosition': $parent = $model->parent; if (empty($parent)) { $this->insertModelAsLastRoot($model); } else { $this->insertModelAsLastChildOf($model, $parent); } return $model; } }
/** * TODO: много лишних isset, которые всегда true по определению * Сохранение полей модели без учета связей, требующих ID модели * @param Model $model * @return Model */ protected function saveColumns(Model $model) { /** @var \T4\Orm\Model $class */ $class = get_class($model); $columns = $class::getColumns(); $relations = $class::getRelations(); $cols = []; $sets = []; $data = []; foreach ($columns as $column => $def) { if (isset($model->{$column}) && null === $model->{$column} && isset($def['default'])) { $sets[$column] = ':' . $column; $data[':' . $column] = $def['default']; } else { $cols[] = $column; $sets[$column] = ':' . $column; $data[':' . $column] = $model->{$column}; } } foreach ($relations as $rel => $def) { switch ($def['type']) { case $class::BELONGS_TO: $column = $class::getRelationLinkName($def); if (!in_array($column, $cols)) { // todo: test this! //if (isset($model->{$column}) && !is_null($model->{$column})) { if (isset($model->{$column})) { $sets[$column] = ':' . $column; $data[':' . $column] = $model->{$column}; } elseif (isset($model->{$rel}) && $model->{$rel} instanceof Model) { $sets[$column] = ':' . $column; $data[':' . $column] = $model->{$rel}->getPk(); } } break; } } $connection = $class::getDbConnection(); if ($model->isNew()) { $query = new Query(); $query->insert($class::getTableName())->values($sets)->params($data); $connection->execute($query); $model->{$class::PK} = $connection->lastInsertId(); } else { $query = new Query(); $query->update($class::getTableName())->values($sets)->where($this->quoteName($class::PK) . '=' . $model->getPk())->params($data); $connection->execute($query); } return $model; }
/** * @param string|\T4\Dbal\QueryBuilder|\T4\Dbal\Query $query * @param array $params * @return \T4\Dbal\Statement */ public function query($query, array $params = []) { if ($query instanceof QueryBuilder) { $params = array_merge($params, $query->getParams()); $query = $query->getQuery($this->getDriver()); } if ($query instanceof Query) { $params = array_merge($params, $query->params); $query = $this->getDriver()->makeQueryString($query); } $statement = $this->pdo->prepare($query); $statement->execute($params); return $statement; }
/** * @param string $class * @param string $column * @param mixed $value * @param array|\T4\Dbal\Query $options * @return int * @throws \T4\Dbal\Exception */ public function countAllByColumn($class, $column, $value, $options = []) { /** @var \T4\Orm\Model $class */ if ('pgsql' != $class::getDbConnection()->getDriverName()) { throw new Exception('DB drivers mismatch'); } $query = new Query($options); $query->select('COUNT(*)')->from($this->quoteName($class::getTableName()))->where($this->quoteName($column) . '=:columnvalue' . (!empty($query->where) ? ' AND (' . $query->where . ')' : ''))->param(':columnvalue', $value); return (int) $class::getDbConnection()->query($query)->fetchScalar(); }