PHP Mage_Customer_Model_Entity_Setup::startSetup Exemples

Exemple #1

Fichier : install-0.1.0.php Projet : vpietri/adm_abandonedcart

<?php

// $installer = $this; //Mage_Core_Model_Resource_Setup
$installer = new Mage_Customer_Model_Entity_Setup('core_setup');
$installer->startSetup();
/**
 * Create table 'adm_abandonedcart/followup'
 */
$table = $installer->getConnection()->newTable($installer->getTable('adm_abandonedcart/followup'))->addColumn('followup_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true), 'Followup Id')->addColumn('quote_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true, 'nullable' => false, 'default' => '0'), 'Quote Id')->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array('unsigned' => true, 'nullable' => false, 'default' => '0'), 'Store Id')->addColumn('abandonned_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array('nullable' => false), 'Cart Abandoned At')->addColumn('customer_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true, 'default' => '0'), 'Customer Id')->addColumn('customer_email', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Customer Email')->addColumn('base_grand_total', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array('default' => '0.0000'), 'Base Grand Total')->addColumn('coupon_code', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Coupon Code')->addColumn('secret_code', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Secret code')->addColumn('is_closed', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array('unsigned' => true, 'default' => '0'), 'Is restored')->addColumn('offset', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array('unsigned' => true, 'default' => '0'), 'Offset')->addColumn('mail_scheduled_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array('nullable' => false), 'Mail1 Scheduled At')->addIndex($installer->getIdxName('adm_abandonedcart/followup', array('customer_id', 'store_id')), array('customer_id', 'store_id'))->addIndex($installer->getIdxName('adm_abandonedcart/followup', array('store_id')), array('store_id'))->addForeignKey($installer->getFkName('adm_abandonedcart/followup', 'store_id', 'core/store', 'store_id'), 'store_id', $installer->getTable('core/store'), 'store_id', Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)->addIndex($installer->getIdxName('adm_abandonedcart/followup', array('quote_id')), array('quote_id'))->addForeignKey($installer->getFkName('adm_abandonedcart/followup', 'quote_id', 'sales/quote', 'entity_id'), 'quote_id', $installer->getTable('sales/quote'), 'entity_id', Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)->setComment('ADM Cart Abandoned to follow');
$installer->getConnection()->createTable($table);
$table = $installer->getConnection()->newTable($installer->getTable('adm_abandonedcart/tracker'))->addColumn('tracker_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true), 'Tracker Id')->addColumn('followup_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true, 'nullable' => false, 'default' => '0'), 'Followup Id')->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array('unsigned' => true, 'nullable' => false, 'default' => '0'), 'Store Id')->addColumn('restored', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array('unsigned' => true, 'default' => '0'), 'Restored')->addColumn('offset', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array('unsigned' => true, 'default' => '0'), 'Offset')->addColumn('track_code', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Message')->addColumn('track_message', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Message')->addColumn('remote_ip', Varien_Db_Ddl_Table::TYPE_TEXT, 16, array('nullable' => false), 'Customer IP')->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array('nullable' => false), 'Created At')->addForeignKey($installer->getFkName('adm_abandonedcart/tracker', 'followup_id', 'adm_abandonedcart/tracker', 'followup_id'), 'followup_id', $installer->getTable('adm_abandonedcart/followup'), 'followup_id', Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)->setComment('ADM Cart Abandoned tracker');
$installer->getConnection()->createTable($table);
$installer->endSetup();

Exemple #2

Fichier : mysql4-upgrade-0.1.0-0.1.1.php Projet : hipay/hipay-fullservice-sdk-magento1

<?php

$installerCustomer = new Mage_Customer_Model_Entity_Setup('allopass_hipay_setup');
/* @var $installerCustomer Mage_Customer_Model_Entity_Setup */
$installerCustomer->startSetup();
$entityId = $installerCustomer->getEntityTypeId('customer');
$attribute = $installerCustomer->getAttribute($entityId, 'hipay_alias_oneclick');
if (!$attribute) {
    $installerCustomer->addAttribute('customer', 'hipay_alias_oneclick', array('type' => 'varchar', 'label' => 'Alias Oneclick Hipay', 'visible' => true, 'required' => false, 'unique' => false, 'sort_order' => 700, 'default' => 0, 'input' => 'text'));
    $usedInForms = array('adminhtml_customer');
    $attribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'hipay_alias_oneclick');
    $attribute->setData('used_in_forms', $usedInForms);
    $attribute->setData('sort_order', 700);
    $attribute->save();
}
$entityId = $installerCustomer->getEntityTypeId('customer');
$attribute = $installerCustomer->getAttribute($entityId, 'hipay_alias_recurring');
if (!$attribute) {
    $installerCustomer->addAttribute('customer', 'hipay_alias_recurring', array('type' => 'varchar', 'label' => 'Alias Recurring Hipay', 'visible' => true, 'required' => false, 'unique' => false, 'sort_order' => 710, 'default' => 0, 'input' => 'text'));
    $usedInForms = array('adminhtml_customer');
    $attribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'hipay_alias_recurring');
    $attribute->setData('used_in_forms', $usedInForms);
    $attribute->setData('sort_order', 700);
    $attribute->save();
}
$attribute = $installerCustomer->getAttribute($entityId, 'hipay_cc_number_enc');
if (!$attribute) {
    $installerCustomer->addAttribute('customer', 'hipay_cc_number_enc', array('type' => 'varchar', 'label' => 'Card number encrypted hipay', 'visible' => true, 'required' => false, 'unique' => false, 'sort_order' => 750, 'default' => 0, 'input' => 'text'));
    $usedInForms = array('adminhtml_customer');
    $attribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'hipay_cc_number_enc');
    $attribute->setData('used_in_forms', $usedInForms);