/**
* @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();
}