pubmaster / dbal-table-manager Goto Github PK

List of methods to be changed:

• findOneByPk
• updateByPk
• softDeleteByPk

When BaseManager uses DeletedRowCondition, it inverts SQL where condition inside this piece of code:

if ($showNotDeleted && $showDeleted) {
	// show all
} else if ($showNotDeleted) {
	$query->andWhere($this->getEntity()->getDeletedAtField() . ' IS NULL');
} else if ($showDeleted) {
	$query->andWhere($this->getEntity()->getDeletedAtField() . ' IS NOT NULL');
}

Некорректно работает с Postgres. Нужно подружить.

SELECT static.*,
version.surname,
version.name,
version.patronymic,
version.agency_id,
version.department_1c_id,
version.department_en_id,
version.position_1c_id,
version.position_en_id,
version.position_ru_id,
version.head,
version.head_employee_id,
version.fired
FROM Company_employee static
INNER JOIN Company_employee_version version ON static.id = version.employee_id AND version.effective_since = (
SELECT MAX(v1.effective_since)
FROM Company_employee_version v1
WHERE static.id = v1.employee_id
AND v1.effective_since <= '2018-05-31 23:59:59'
) AND version.created_at = (
SELECT MAX(v2.created_at)
FROM Company_employee_version v2
WHERE v2.employee_id = version.employee_id
AND v2.effective_since = version.effective_since
AND v2.created_at <= '2018-05-31 23:59:59'
)