LeuchtfeuerPrintmailingBundle.php
<?php
namespace MauticPlugin\LeuchtfeuerPrintmailingBundle;
use Doctrine\DBAL\Schema\Schema;
use Mautic\CoreBundle\Factory\MauticFactory;
use Mautic\PluginBundle\Bundle\PluginBundleBase;
use Mautic\PluginBundle\Entity\Plugin;
class LeuchtfeuerPrintmailingBundle extends PluginBundleBase
{
public static function onPluginUpdate(Plugin $plugin, MauticFactory $factory, $metadata = null, Schema $installedSchema = null)
{
$database = $factory->getDatabase();
$platform = $database->getDatabasePlatform()->getName();
$queries = [];
$fromVersion = $plugin->getVersion();
switch ($fromVersion) {
case '1.0.0':
switch ($platform) {
case 'mysql':
$queries[] = sprintf(
'ALTER TABLE %strigger_campaigns CHANGE end_date end_date datetime DEFAULT NULL COMMENT \'(DC2Type:datetime)\'',
MAUTIC_TABLE_PREFIX
);
break;
}
break;
}
if (!empty($queries)) {
$database->beginTransaction();
try {
foreach ($queries as $query) {
$database->query($query);
}
$database->commit();
} catch (\Exception $exception) {
$database->rollBack();
throw $exception;
}
}
parent::updatePluginSchema($metadata, $installedSchema, $factory);
}
}