Gsyfuy

I have added one Custom attribute custom_attribute to quote & order table I am sending a response to my controller I want to save the response in my custom_attribute to sales_flat_quote & sales_flat_order table
can someone please help me how to achieve this

  $response = $this->getRequest()->getParam('data'); // i am getting response here in my controller 



      $quoteModelInstance = Mage::getSingleton('checkout/session')->getQuote();

        $customerModelInstance = Mage::getSingleton('customer/session');



        $order = Mage::getModel('sales/order');

        $order->setQuote($quoteModelInstance);

        $order->setCustomAttribute($response);

        try {

            $order->save();



        } catch (Exception $e) {



            Mage::logException($e);

        }

Here I am showing you how to save the values in the sales_flat_order table using checkout_submit_all_after event and observer concept.

Step-1: From your custom controller set the value into session as shown below

/app/code/local/Namespace/ModuleName/controllers/IndexController.php

public function customAction(){



  $productPayDetails=$this->getRequest()->getPost();//get post values

  //write your code here

  .

  .





    $myValue = 2;

    Mage::getSingleton("checkout/cart")->getQuote()->setCustomAttribute($myValue)->save();



    (or)    



  Mage::getSingleton("checkout/session")->getQuote()->setCustomAttribute($myValue)->save();

  .

  .

  $testValue = 10; //Ex: Your attribute value

  Mage::getSingleton('core/session')->setCustomerPaymentTotal($testValue);

  Mage::getSingleton('core/session')->setCustomerPendingTotal($testValue);

}

Screen shot: http://prntscr.com/fxz7eu

Step 2: Now Configure an event in config.xml from your custom module

/app/code/local/Namespace/ModuleName/et/config.xml

  <frontend>

      <events>

         <checkout_submit_all_after>

                <observers>

                    <checkout_submit_all_after>

                        <class>intermediatepage/observer</class>

                        <method>checkout_submit_all_after</method>

                    </checkout_submit_all_after>

                </observers>

         </checkout_submit_all_after>

      </events>

</frontend>

Note: Here i am taking an example with intermediatepage class name

Step 3: Now Create a column in the sales_flat_order for example as shown in the
screenshot http://prntscr.com/fxxqgt

Step 4: create an observer file

/app/code/local/Namespace/ModuleName/Model/Observer.php

<?php



class Namespace_ModuleName_Model_Observer {



    public function checkout_submit_all_after(Varien_Event_Observer $observer)

     {

    $order = $observer->getEvent()->getOrder();

    $pendingtotal=Mage::getSingleton('core/session')->getCustomerPendingTotal();

    $paymenttotal=Mage::getSingleton('core/session')->getCustomerPaymentTotal();

    $order->setOrderPendingPayment($pendingtotal);

    $order->setOrderPaymentNow($paymenttotal);

    $order->save();



 //unset the session values

 Mage::getSingleton('core/session')->getCustomerPendingTotal('');

 Mage::getSingleton('core/session')->getCustomerPendingTotal('');



 }



}

Step 5: after done the changes in xml please remove cache and session and please try this in default magento from your custom module in locally.

I found another very easy solution for this please follow the steps below:

Step 1:
in your controller action please save the custom attribute value as shown below

Note:- You should create a column for saving the value in sales_flat_quote table
Ex: custom_attribute is the name of the column i have created

public function customAction(){



  $productPayDetails=$this->getRequest()->getPost();//get post values



  $myValue = 2; 



  Mage::getSingleton("checkout/cart")->getQuote()->setCustomAttribute($myValue)->save();



   (or)



  Mage::getSingleton("checkout/session")->getQuote()->setCustomAttribute($myValue)->save();



}

Step 2: Create a column in the name of custom_attribute in sales_flat_order table

Step 3: now keep the below code in between global tag from config.xml from your custom module

<global> 

<fieldsets>

        <sales_convert_quote>

          <custom_attribute>

            <to_order>*</to_order>

           </custom_attribute>

        </sales_convert_quote>

        <sales_convert_order>

            <custom_attribute>

                <to_quote>*</to_quote>

            </custom_attribute>            

        </sales_convert_order>

    </fieldsets>

  </global>

clear cache and session and create an order and check the database.