/**
*
*/
public function execute()
{
$data = $this->entity->tabelizeRecord($this->record);
/**
* We need to get entity table extensions.
* Lets hardcode them for now.
*/
$extensions = ['i18n', 'p17n', ''];
$table = $this->entity->getTable();
$primaryKeys = $this->entity->getRepository()->getCache()->getTablePrimaryKeys($table);
if (!$primaryKeys) {
throw new Exception('Will NOT delete from table without primary keys ...');
}
foreach ($extensions as $ext) {
if ($ext) {
$ext = '_' . $ext;
}
if ($this->entity->getRepository()->getCache()->hasTable($table . $ext)) {
/**
* We will delete record from $table ...
*/
$query = (new Delete())->setTable($table . $ext);
/**
* ... add primary key condition ...
*/
foreach ($primaryKeys as $key) {
$query->where($key, $data[$table][$key]);
}
/**
* ... prepare query ...
*/
$prepare = $this->repository->prepareQuery($query);
/**
* ... and execute it.
*/
$this->repository->executePrepared($prepare);
}
}
$this->record->setSaved(false);
$this->record->setDeleted(true);
return true;
}
public function execute()
{
$entity = new Entity();
$entity->setRepository(context()->get($this->migration->getRepository()));
$cache = $entity->getRepository()->getCache();
foreach ($this->migration->getTables() as $table) {
$this->sql = [];
if ($cache->hasTable($table->getName())) {
$this->updateTable($cache, $table);
} else {
$this->installTable($cache, $table);
}
}
if ($this->sqls) {
$this->applyMigration();
}
}
protected function applyGuessedSorts(Entity $entity)
{
if (!$entity->getQuery()->getOrderBy()) {
$cache = $entity->getRepository()->getCache();
if ($cache->tableHasField($entity->getTable(), 'order')) {
$entity->orderBy('`' . $entity->getTable() . '`.`order` ASC');
} else {
if ($cache->tableHasField($entity->getTable(), 'ord')) {
$entity->orderBy('`' . $entity->getTable() . '`.`ord` ASC');
} else {
if ($cache->tableHasField($entity->getTable(), 'position')) {
$entity->orderBy('`' . $entity->getTable() . '`.`position` ASC');
} else {
if ($cache->tableHasField($entity->getTable(), 'dt_published')) {
$entity->orderBy('IF(`' . $entity->getTable() . '`.`dt_published` BETWEEN \'0000-00-00 00:00:01\' AND NOW() , 1, 0) DESC, id ASC');
} else {
$entity->orderBy('`' . $entity->getTable() . '`.`id` DESC');
}
}
}
}
}
}
/**
* @param Entity $entity
* @param Repository $repository
*/
public function __construct(Entity $entity, Repository $repository = null)
{
$this->entity = $entity;
$this->repository = $repository ?: $this->entity->getRepository();
}
public function primaryWhere(Entity $entity, $data, $table)
{
$primaryKeys = $entity->getRepository()->getCache()->getTablePrimaryKeys($table);
if (!$primaryKeys) {
throw new Exception('Primary key must be set on deletion!');
}
foreach ($primaryKeys as $primaryKey) {
$this->where('`' . $primaryKey . '`', $data[$primaryKey]);
}
}
public function applyOnEntity(Entity $entity)
{
$filters = $this->getAppliedFilters();
$signMapper = ['equals' => '=', 'greater' => '>', 'greaterOrEquals' => '>=', 'lower' => '<', 'lowerOrEquals' => '<=', 'not' => '!=', 'in' => 'IN', 'notIn' => 'NOT IN', 'like' => 'LIKE'];
foreach ($filters as $filter) {
if (!is_array($filter['value']) && in_array($filter['options']['method'], ['in', 'notIn'])) {
$filter['value'] = explode(',', $filter['value']);
}
$entity->where($filter['field'], $filter['value'], $signMapper[$filter['options']['method']]);
}
$signMapper = ['equals' => '=', 'in' => 'IN', 'notIn' => 'NOT IN', 'not' => '!='];
$relationFilters = $this->getAppliedRelationFilters();
foreach ($relationFilters as $relationFilter) {
$relation = (new Relations())->where('id', $relationFilter['id'])->one();
if ($relation->dynamic_relation_type_id == 1) {
$entity->where($relation->onField->field, $relationFilter['value'], $signMapper[$relationFilter['options']['method']]);
} else {
if ($relation->dynamic_relation_type_id == 2) {
$entity->join('INNER JOIN ' . $relation->showTable->table, $relation->onTable->table . '.id = ' . $relation->showTable->table . '.' . $relation->onField->field, $relation->showTable->table . '.' . $relationFilter['field'] . ' ' . $signMapper[$relationFilter['options']['method']] . ' ' . $entity->getRepository()->getConnection()->quote($relationFilter['value']));
}
}
}
}
