Export Particular order information

Question

I try to export particular order information in csv format but i can't able to download. What mistake i done here?

observer.php

public function adminhtmlWidgetContainerHtmlBefore($event)
    {
        $block = $event->getBlock();
        $message = Mage::helper('sales')->__('Are you want to Download...?');

        if ($block instanceof Mage_Adminhtml_Block_Sales_Order_View) {
            $block->addButton('download', array(
                'label'     => Mage::helper('Sales')->__('Download...'),
                'onclick'   => "confirmSetLocation('{$message}','{$block->getUrl('*/')}')", // < missed comma
                'class'     => 'go'
            ));
        }
    }

controller.php

public function downloadAction(){

      $orders = Mage::getModel("sales/order")->getCollection();
// prepare CSV header
$csv = '';
$_columns = array(
     "Order Id",
     "Product Name",
     "Sku",
     "Price"
);
$data = array();
// prepare CSV header...
foreach ($_columns as $column) {
       $data[] = '"'.$column.'"';
}
$csv .= implode(',', $data)."\n";
foreach ($orders as $order) {
         $items = $order->getAllItems();
         foreach ($items as $item) {
               $loadProduct = Mage::getModel('catalog/product')->load($item->getProductId());
               //prepare csv contents
                $data = array();
                $data[] = $order->getId();
                $data[] = $loadProduct['name'];
                $data[] = $loadProduct['sku'];
                $data[] = $loadProduct['price'];

                $csv .= implode(',', $data)."\n";
               //now $csv varaible has csv data as string
    }
}

$this->_redirect('*/*/');
$this->_prepareDownloadResponse('file.csv', $csv, 'text/csv');
    }

config.xml

 <?xml version="1.0"?>
<config>
    <modules>
        <Manoj_Csv>
            <version>0.1.0</version>
        </Manoj_Csv>
    </modules>
    <global>
    <blocks>

        <adminhtml>
            <rewrite>
                <sales_order_view>Manoj_Csv_Block_Adminhtml_Sales_Order_View</sales_order_view>
            </rewrite>
        </adminhtml>

    </blocks>

 </global>
    <adminhtml>
        <events>
            <adminhtml_widget_container_html_before>
                <observers>
                    <manoj_csv>
                        <class>Manoj_Csv_Model_Observer</class>
                        <method>adminhtmlWidgetContainerHtmlBefore</method>
                    </manoj_csv>
                </observers>
            </adminhtml_widget_container_html_before>
        </events>
    </adminhtml>
</config>

place this Mage::log('yes it is called', null, 'myfile.log'); inside the function and check if file name called myfile.log is in /var/log, if no file then function is not called. — Adarsh Khatri, Apr 04 '16 at 05:14
Where do you have your button to click? Can you post your config.xml too? — Adarsh Khatri, Apr 04 '16 at 05:25

Adarsh Khatri · Accepted Answer · 2016-04-04T13:39:14.297

1

It's most likely your controller function is not called.

To test: place this Mage::log('yes it is called', null, 'myfile.log'); inside the function and check if file name called myfile.log is in /var/log, if no file then function is not called.

See this line 'onclick' => "confirmSetLocation('{$message}','{$block->getUrl('*/')}'). You might want to check what $block->getUrl('*/') will return?

My approach:

You should rewrite your order view page to add your button there and then can link to your controller.

In config.xml

<?xml version="1.0"?>
<config>
 <global>
    <blocks>         
        <adminhtml>
            <rewrite>
                <sales_order_view>Manoj_Csv_Block_Adminhtml_Sales_Order_View</sales_order_view>
            </rewrite>
        </adminhtml>
    </blocks>
 </global>
 <admin>
    <routers>
        <adminhtml>
            <args>
                <modules>
                    <csv before="Mage_Adminhtml">Manoj_Csv_Adminhtml</csv>
                </modules>
            </args>
        </adminhtml>
    </routers>
</admin>
</config>

Then your Manoj/Csv/Block/Adminhtml/Sales/Order/View.php file

<?php

class Manoj_Csv_Block_Adminhtml_Sales_Order_View extends Mage_Adminhtml_Block_Sales_Order_View
{

    public function __construct()
    {

        parent::__construct();

        $order = $this->getOrder();
        $message = Mage::helper('sales')->__('Are you sure you want to download the file?');
                $this->addButton('download_csv', array(
                    'label'     => Mage::helper('sales')->__('Download Csv'),
                    'onclick'   => "confirmSetLocation('{$message}', '{$this->getDownloadCsv($order->getId())}')", 
                ));



    }

    public function getDownloadCsv($id)
    {
        return $this->getUrl('adminhtml/order/download', array('id' => $id));
    }

Now, your Manoj/Csv/controller/Adminhtml/OrderController.php

<?php

class Manoj_Csv_Adminhtml_OrderController extends Mage_Adminhtml_Controller_Action
{

public function downloadAction(){
  $orderId = $this->getRequest()->getParam('id');

  $order = Mage::getModel("sales/order")->load($orderId);
// prepare CSV header
$csv = '';
$_columns = array(
     "Order Id",
     "Product Name",
     "Sku",
     "Price"
);
$data = array();
// prepare CSV header...
foreach ($_columns as $column) {
       $data[] = '"'.$column.'"';
}
$csv .= implode(',', $data)."\n";
         $items = $order->getAllItems();
         foreach ($items as $item) {
               $loadProduct = Mage::getModel('catalog/product')->load($item->getProductId());
               //prepare csv contents
                $data[] = $order->getId();
                $data[] = $loadProduct->getName();
                $data[] = $loadProduct->getSku();
                $data[] = $loadProduct->getFinalPrice();

                $csv .= implode(',', $data)."\n";
               //now $csv varaible has csv data as string
    }

try {
        //download
        $this->_prepareDownloadResponse('file-'.$orderId.'.csv', $csv, 'text/csv');
        $this->_getSession()->addSuccess($this->__('File downloaded.'));
    } catch (Mage_Core_Exception $e) {
        $response = array(
            'error'     => true,
            'message'   => $e->getMessage(),
        );
    }catch (Exception $e) {
        $this->_getSession()->addError(Mage::helper('sales')->__('File cannot be donwloaded.'));
        $response = array(
            'error'     => true,
            'message'   => $this->__('File cannot be downloaded.')
        );
    }
}

I haven't tested but this should work. Good luck.

edited Apr 04 '16 at 13:39

answered Apr 04 '16 at 05:47

Adarsh Khatri

8,360
2
25
58

No luck No download – Magento 2 Apr 04 '16 at 11:06
I can confirm it worked on my side. – Adarsh Khatri Apr 04 '16 at 11:07
Can you please update the config.xml i think i made a mistake there – Magento 2 Apr 04 '16 at 11:08
Download Csv button not apper my code Download.. Button only show in that page – Magento 2 Apr 04 '16 at 11:13
On which page? Button should appear in order view page. – Adarsh Khatri Apr 04 '16 at 11:51
in sales order view page only – Magento 2 Apr 04 '16 at 11:52
Yes that's correct. Where do you want it to appear? – Adarsh Khatri Apr 04 '16 at 11:55
This button not apper ('Download Csv') – Magento 2 Apr 04 '16 at 11:56
Sometime class override doesn't come to effect due to multiple extension extending same class. Check if sales_order_view is extended by any other extension http://magento.stackexchange.com/questions/1594/how-do-i-get-a-list-of-all-class-rewrites#answer-1600 – Adarsh Khatri Apr 04 '16 at 11:58
Can you please update your working code so that i ill follow that – Magento 2 Apr 04 '16 at 12:00
Above code works, can you paste your full config.xml? – Adarsh Khatri Apr 04 '16 at 12:01
Please check my update question – Magento 2 Apr 04 '16 at 12:02
Remove <observer>....</observer> part and then check if you have conflict, http://magento.stackexchange.com/questions/1594/how-do-i-get-a-list-of-all-class-rewrites#answer-1600 – Adarsh Khatri Apr 04 '16 at 12:04
Also check my update config.xml – Adarsh Khatri Apr 04 '16 at 12:10
I can't see ('Download Csv') button – Magento 2 Apr 04 '16 at 12:16
did you check extension conflict? – Adarsh Khatri Apr 04 '16 at 12:16
I can't understand where i need to add that script – Magento 2 Apr 04 '16 at 12:17
create a file name.php and place in your root of the magento, where index.php is located, then call it in browser example.com/name.php – Adarsh Khatri Apr 04 '16 at 12:23
Let us continue this discussion in chat. – Adarsh Khatri Apr 04 '16 at 12:24

Export Particular order information

1 Answers1