Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/old/app/code/Chronopost/Chronorelais/Setup/ |
<?php
/**
* Chronopost
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade this extension to newer
* version in the future.
*
* @category Chronopost
* @package Chronopost_Chronorelais
* @copyright Copyright (c) 2021 Chronopost
*/
declare(strict_types=1);
namespace Chronopost\Chronorelais\Setup;
use Magento\Framework\DB\Adapter\AdapterInterface;
use Magento\Framework\DB\Ddl\Table;
use Magento\Framework\Setup\UpgradeSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Ui\Api\Data\BookmarkInterfaceFactory;
use Magento\Ui\Model\ResourceModel\BookmarkRepository;
/**
* Class UpgradeSchema
*
* @package Chronopost\Chronorelais\Setup
*/
class UpgradeSchema implements UpgradeSchemaInterface
{
/**
* @var BookmarkRepository
*/
private $bookmarkRepository;
/**
* @var BookmarkInterfaceFactory
*/
private $bookmarkFactory;
/**
* UpgradeSchema constructor.
*
* @param BookmarkInterfaceFactory $bookmarkFactory
* @param BookmarkRepository $bookmarkRepository
*/
public function __construct(
BookmarkInterfaceFactory $bookmarkFactory,
BookmarkRepository $bookmarkRepository
) {
$this->bookmarkFactory = $bookmarkFactory;
$this->bookmarkRepository = $bookmarkRepository;
}
/**
* Upgrade schema
*
* @param SchemaSetupInterface $setup
* @param ModuleContextInterface $context
*
* @throws \Zend_Db_Exception
*
* @SuppressWarnings(PHPMD.ExcessiveMethodLength)
* @SuppressWarnings(PHPMD.CyclomaticComplexity)
* @SuppressWarnings(PHPMD.NPathComplexity)
*/
public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
$installer = $setup;
$installer->startSetup();
if (version_compare($context->getVersion(), '1.0.1') < 0) {
if (!$installer->tableExists('chronopost_order_export_status')) {
$table = $installer->getConnection()->newTable(
$installer->getTable('chronopost_order_export_status')
)
->addColumn(
'entity_id',
Table::TYPE_INTEGER,
null,
[
'identity' => true,
'nullable' => false,
'primary' => true,
'unsigned' => true,
],
'Entity ID'
)
->addColumn(
'order_id',
Table::TYPE_INTEGER,
null,
[
'nullable' => false,
'unsigned' => true,
],
'Order ID'
)
->addColumn(
'livraison_le_samedi',
Table::TYPE_TEXT,
10,
[
'nullable' => false,
"default" => 'Yes'
],
'Livraison samedi'
)
->setComment('Chronopost export status');
$installer->getConnection()->createTable($table);
}
}
if (version_compare($context->getVersion(), '1.0.2') < 0) {
$tableName = $installer->getTable('sales_shipment_track');
$installer->getConnection()->modifyColumn($tableName, 'chrono_reservation_number', array(
'type' => Table::TYPE_TEXT,
'length' => 100000,
'nullable' => true,
'comment' => 'Reservation number'
));
}
if (version_compare($context->getVersion(), '1.0.3') < 0) {
$installer->getConnection()->addColumn(
$installer->getTable('quote'),
'relais_id',
[
'type' => Table::TYPE_TEXT,
'length' => 50,
'nullable' => true,
'comment' => 'Relais ID',
]
);
$installer->getConnection()->addColumn(
$installer->getTable('sales_order'),
'relais_id',
[
'type' => Table::TYPE_TEXT,
'length' => 50,
'nullable' => true,
'comment' => 'Relais ID',
]
);
}
if (version_compare($context->getVersion(), '1.0.4') < 0) {
$installer->getConnection()->addColumn(
$installer->getTable('quote'),
'chronopostsrdv_creneaux_info',
[
'type' => Table::TYPE_TEXT,
'length' => 100000,
'nullable' => true,
'comment' => 'Info RDV',
]
);
$installer->getConnection()->addColumn(
$installer->getTable('sales_order'),
'chronopostsrdv_creneaux_info',
[
'type' => Table::TYPE_TEXT,
'length' => 100000,
'nullable' => true,
'comment' => 'Info RDV',
]
);
}
if (version_compare($context->getVersion(), '1.0.6') < 0) {
if (!$installer->tableExists('chronopost_chronorelais_contracts_orders')) {
$table = $installer->getConnection()->newTable(
$installer->getTable('chronopost_chronorelais_contracts_orders')
)
->addColumn(
'entity_id',
Table::TYPE_INTEGER,
null,
[
'identity' => true,
'nullable' => false,
'primary' => true,
'unsigned' => true,
],
'Entity ID'
)
->addColumn(
'order_id',
Table::TYPE_INTEGER,
null,
[
'nullable' => false,
'unsigned' => true,
],
'Order ID'
)
->addColumn(
'contract_name',
Table::TYPE_TEXT,
255,
[
'nullable' => false,
"default" => null
],
'Contract Name'
)
->addColumn(
'contract_account_number',
Table::TYPE_TEXT,
50,
[
'nullable' => false,
"default" => null
],
'Contract account number'
)
->addColumn(
'contract_sub_account_number',
Table::TYPE_TEXT,
20,
[
'nullable' => false,
"default" => null
],
'Contract sub account number'
)
->addColumn(
'contract_account_password',
Table::TYPE_TEXT,
50,
[
'nullable' => false,
"default" => null
],
'Contract account password'
)
->setComment('Chronopost contract order');
$installer->getConnection()->createTable($table);
}
}
if (version_compare($context->getVersion(), '1.0.7') < 0) {
if (!$installer->tableExists('chronopost_chronorelais_lt_history')) {
$table = $installer->getConnection()->newTable(
$installer->getTable('chronopost_chronorelais_lt_history')
)
->addColumn(
'entity_id',
Table::TYPE_INTEGER,
null,
[
'identity' => true,
'nullable' => false,
'primary' => true,
'unsigned' => true,
],
'Entity ID'
)
->addColumn(
'shipment_id',
Table::TYPE_INTEGER,
null,
[
'nullable' => false,
'unsigned' => true,
],
'Shipment ID'
)
->addColumn(
'lt_number',
Table::TYPE_TEXT,
null,
[
'nullable' => false,
'default' => null
],
'LT Number'
)
->addColumn(
'weight',
Table::TYPE_INTEGER,
null,
[
'nullable' => false,
'default' => 0
],
'Weight of parcel'
);
$installer->getConnection()->createTable($table);
}
}
if (version_compare($context->getVersion(), '1.2.4') < 0) {
if ($installer->tableExists('chronopost_chronorelais_lt_history')) {
$installer->getConnection()->addColumn(
$installer->getTable('chronopost_chronorelais_lt_history'),
'type',
[
'type' => Table::TYPE_SMALLINT,
'length' => 2,
'nullable' => false,
'default' => 1,
'comment' => '1 : Shipment, 2 : Return',
]
);
$installer->getConnection()->addColumn(
$installer->getTable('chronopost_chronorelais_lt_history'),
'reservation',
[
'type' => Table::TYPE_INTEGER,
'nullable' => true,
'default' => null,
'comment' => 'Reservation number',
]
);
}
}
if (version_compare($context->getVersion(), '1.2.7') < 0) {
$installer->getConnection()->addColumn(
$installer->getTable('quote'),
'force_saturday_option',
[
'type' => Table::TYPE_BOOLEAN,
'nullable' => true,
'comment' => 'Saturday option'
]
);
$installer->getConnection()->addColumn(
$installer->getTable('sales_order'),
'force_saturday_option',
[
'type' => Table::TYPE_BOOLEAN,
'nullable' => true,
'comment' => 'Saturday option'
]
);
}
if (version_compare($context->getVersion(), '1.2.8') < 0) {
$installer->getConnection()->addColumn(
$installer->getTable('sales_order'),
'force_saturday_option_generated',
[
'type' => Table::TYPE_BOOLEAN,
'nullable' => true,
'comment' => 'Saturday generation option'
]
);
}
if (version_compare($context->getVersion(), '2.0.0') < 0) {
$installer->getConnection()->addColumn(
$installer->getTable('chronopost_chronorelais_lt_history'),
'expiration_date',
[
'type' => Table::TYPE_TEXT,
'nullable' => true,
'comment' => 'Expiration date',
'length' => 20
]
);
$collection = $this->bookmarkFactory->create()->getCollection();
$collection->addFieldToFilter('namespace', ['eq' => 'chronopost_sales_order_grid']);
foreach ($collection->getItems() as $bookmark) {
$this->bookmarkRepository->deleteById($bookmark->getBookmarkId());
}
$tableName = $installer->getTable('chronopost_chronorelais_lt_history');
$installer->getConnection()->modifyColumn($tableName, 'reservation', [
'type' => Table::TYPE_TEXT,
'length' => 255,
'nullable' => true,
'comment' => 'Reservation number'
]);
$tableName = $installer->getTable('sales_shipment_track');
$installer->getConnection()->modifyColumn($tableName, 'chrono_reservation_number', [
'type' => Table::TYPE_TEXT,
'length' => 255,
'nullable' => true,
'comment' => 'Reservation number'
]);
}
$installer->endSetup();
}
}