<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20220201134046 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql("UPDATE customer
LEFT JOIN (
SELECT customer_id, COUNT(status) AS finishedCount
FROM customer_quotations
WHERE status = 'quotation.status.finished'
GROUP BY customer_id
) as q ON
q.customer_id = customer.id
SET customer.order_count = ifnull(q.finishedCount,0)
");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
}
}