Magento 2.1 – Save Cart Price Rule Custom Fields in Database

adminhtmlmagento-2.1shopping-cart-price-rules

I need to save values of two custom fields which I have added using xml.
Below is the xml in which I have added that fields also they reflect in cart price rule form.

 <fieldset name="custom details">
    <argument name="data" xsi:type="array">
        <item name="config" xsi:type="array">
            <item name="label" xsi:type="string" translate="true"> Detail1</item>
            <item name="collapsible" xsi:type="boolean">true</item>
            <item name="sortOrder" xsi:type="string">40</item>
        </item>
    </argument>
    <field name="field1">
        <argument name="data" xsi:type="array">
            <item name="config" xsi:type="array">
                <item name="label" xsi:type="string" translate="true">i</item>
                <item name="dataType" xsi:type="string">text</item>
                <item name="formElement" xsi:type="string">input</item>
                <item name="source" xsi:type="string">sales_rule</item>
                <item name="dataScope" xsi:type="string">field1</item>
                <item name="validation" xsi:type="array">
                    <item name="required-entry" xsi:type="boolean">true</item>
                </item>
            </item>
        </argument>
    </field>
    <field name="field2">
        <argument name="data" xsi:type="array">
            <item name="config" xsi:type="array">
                <item name="dataType" xsi:type="string">text</item>
                <item name="formElement" xsi:type="string">wysiwyg</item>
                <item name="source" xsi:type="string">sales_rule</item>
                <item name="label" xsi:type="string">Field2</item>

                <item name="template" xsi:type="string">ui/form/field</item>
                <item name="wysiwyg" xsi:type="boolean">true</item>
                <item name="dataScope" xsi:type="string">terms_conditions</item>
                <item name="sortOrder" xsi:type="number">50</item>
                <!--<item name="rows" xsi:type="number">8</item>-->
                <item name="validation" xsi:type="array">
                    <item name="required-entry" xsi:type="boolean">true</item>
                </item>

            </item>
        </argument>
    </field>
</fieldset>

I am struggling as on how shall I save the values of two fields in the database against their database field columns.I tried to go through save.php in Namespace/Modulename/Controller/Adminhtml/Promo/Quote/Save.But could find any success in that.
Can someone please help.

Best Answer

You don't need to write custom Model for that, If you add custom field using ui_component than it will save automatically to the DB.

You need to create relative field to salesrule table.

Create setup file at below path.

Vendor/Module/Setup/InstallData.php

public function install(
    ModuleDataSetupInterface $setup,
    ModuleContextInterface $context
) {
    $setup->startSetup();

     $setup->getConnection()->addColumn(
        $setup->getTable('salesrule'),
        'group_members',
        [
            'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
            'length' => 32,
            'nullable' => false,
            'default' => '',
            'comment' => 'Group Members'
        ]
    );

Than Run below commands from Magento root.

php bin/magento setup:upgrade
php bin/magento setup:static-content:deploy
php bin/magento cache:clean

Note: If you modifying existing Module setup file than you must need to remove your module entry from setup table.

Hope it will help you !!

Related Solutions

Magento – Shopping Cart Price rule – tiered

You will have create three rules for that and have to include the categories in which you want to apply discount in each of them. Please review the screenshot below and you will get it.

enter image description here

Please follow the steps as shown in screenshot and it will work for you.

[EDIT]

Please make stop further rules processing to YES

Custom Shopping Cart Price Rule for Most Expensive Product

This is actually not that difficult.

Have a look at Mage_SalesRule_Model_Rule_Condition_Combine::getNewChildSelectOptions

You will see it builds an array of conditions as such:

$conditions = array_merge_recursive($conditions, array(
            array('value'=>'salesrule/rule_condition_product_found', 'label'=>Mage::helper('salesrule')->__('Product attribute combination')),
            array('value'=>'salesrule/rule_condition_product_subselect', 'label'=>Mage::helper('salesrule')->__('Products subselection')),
            array('value'=>'salesrule/rule_condition_combine', 'label'=>Mage::helper('salesrule')->__('Conditions combination')),
            array('label'=>Mage::helper('salesrule')->__('Cart Attribute'), 'value'=>$attributes),
        ));

and then fires an event, passing along an object called as 'additional'

Mage::dispatchEvent('salesrule_rule_condition_combine', array('additional' => $additional));

it expects back $additional->getConditions()

so, if you observer that event, you can populate the additional object with your own array of conditions.

In your observer some code like this will do:

$conditions = array(
            array('value'=>'YOURMODULE_NAMESPACE/rule_condition_Mostexpensive', 'label'=>Mage::helper('YOURMODULE_NAMESPACE')->__('Most Expensive Product')),
        );

Now your rule option is cleanly injected into the list of available rules.

The next step is to go create the model it will use. As can be seen from the code above, you will need to create the class

YOURMODULE_NAMESPACE_Model_Rule_Condition_Mostexpensive

What that would extend is really up to the functionality you intend to use. If for example you intend to use product attributes in the validation, you would extend Mage_SalesRule_Model_Rule_Condition_Product so you can inherit all the functionality surrounding product validation.

In your class, these methods are the important ones. Try not to extend methods if you don't need to, it is best to try re-use core code, which results in a lot more stability of your module.

asHtml() : This holds the options that will be displayed when your rule is selected.

validate : This is where you'd place your logic to determine if the rule is valid. In the end it would simply result in bool.

If you'd like to build a rule that has sub-rules, you'd extend the _combined salesrule classes, as for example: Mage_SalesRule_Model_Rule_Condition_Product_Found

Look at the core code in sales rules. It has all the examples you need. To really understand what is going on, I highly suggest you used a debugger (I use xdebug) with an ide/editor that supports line-breaks. (I use netbeans) This way you can put breakpoints in the salsrule classes and follow the code flow as the rules are built. Make sit a lot easier.

Hope this helps.

Best Answer

Related Solutions

Magento – Shopping Cart Price rule – tiered

Custom Shopping Cart Price Rule for Most Expensive Product

Related Topic