Version Notes
Beta version
Download this release
Release Info
Developer | Marcelo Linhares |
Extension | Lema21_CustomExport |
Version | 0.9.0 |
Comparing to | |
See all releases |
Version 0.9.0
- app/code/local/Lema21/CustomExport/Helper/Data.php +25 -0
- app/code/local/Lema21/CustomExport/Model/Observer.php +26 -0
- app/code/local/Lema21/CustomExport/Service/GenerateCSV.php +91 -0
- app/code/local/Lema21/CustomExport/Template/template.csv +1 -0
- app/code/local/Lema21/CustomExport/controllers/IndexController.php +23 -0
- app/code/local/Lema21/CustomExport/etc/config.xml +53 -0
- app/etc/modules/Lema21_CustomExport.xml +27 -0
- app/locale/pt_BR/Lema21_CustomExport.csv +1 -0
- package.xml +25 -0
app/code/local/Lema21/CustomExport/Helper/Data.php
ADDED
@@ -0,0 +1,25 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Lema21_CustomExport_Helper_Data extends Mage_Core_Helper_Abstract
|
4 |
+
{
|
5 |
+
|
6 |
+
/**
|
7 |
+
* Get array of itens in template line
|
8 |
+
*
|
9 |
+
* @return array
|
10 |
+
*/
|
11 |
+
public static function loadTemplate()
|
12 |
+
{
|
13 |
+
$io = new Varien_Io_File();
|
14 |
+
|
15 |
+
$pathToTile = Mage::getBaseDir('app') . DS .
|
16 |
+
'code/local/Lema21/CustomExport/Template/template.csv';
|
17 |
+
|
18 |
+
// load csv
|
19 |
+
$contentTemplate = file_get_contents($pathToTile);
|
20 |
+
|
21 |
+
$templateLine = explode("|", $contentTemplate);
|
22 |
+
|
23 |
+
return $templateLine;
|
24 |
+
}
|
25 |
+
}
|
app/code/local/Lema21/CustomExport/Model/Observer.php
ADDED
@@ -0,0 +1,26 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Lema21_CustomExport_Model_Observer {
|
4 |
+
|
5 |
+
public function includeOption($observer)
|
6 |
+
{
|
7 |
+
// Get code of grid
|
8 |
+
$idBlockObserver = $observer->getEvent()->getBlock()->getId();
|
9 |
+
|
10 |
+
if ($idBlockObserver=="sales_order_grid" ) {
|
11 |
+
|
12 |
+
// copy+paste by "delete orders" module, thanks Stefan Wieczorek
|
13 |
+
$block = $observer->getEvent()
|
14 |
+
->getBlock()
|
15 |
+
->getMassactionBlock();
|
16 |
+
|
17 |
+
if ($block) {
|
18 |
+
$block->addItem('custom_export', array(
|
19 |
+
'label'=> Mage::helper('custom_export')->__('Custom Export Data to CSV'),
|
20 |
+
'url' => Mage::getUrl('lema21_custom_export', array('_secure'=>true)),
|
21 |
+
));
|
22 |
+
}
|
23 |
+
}
|
24 |
+
}
|
25 |
+
|
26 |
+
}
|
app/code/local/Lema21/CustomExport/Service/GenerateCSV.php
ADDED
@@ -0,0 +1,91 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
class Lema21_CustomExport_Service_GenerateCSV {
|
4 |
+
|
5 |
+
private $_orderIds;
|
6 |
+
private $_collectionOrders;
|
7 |
+
private $_contentCSV;
|
8 |
+
|
9 |
+
public function __construct($ordersId) {
|
10 |
+
$this->_orderIds = $ordersId;
|
11 |
+
}
|
12 |
+
|
13 |
+
private function _loadOrderObjects()
|
14 |
+
{
|
15 |
+
$this->_collectionOrders = array();
|
16 |
+
|
17 |
+
foreach($this->_orderIds as $id) {
|
18 |
+
$instance = Mage::getModel("sales/order")->load($id);
|
19 |
+
array_push($this->_collectionOrders, $instance);
|
20 |
+
}
|
21 |
+
}
|
22 |
+
|
23 |
+
private function _prepareData($templateLine)
|
24 |
+
{
|
25 |
+
$this->_contentCSV = "";
|
26 |
+
|
27 |
+
//iterate on the orders selected
|
28 |
+
foreach($this->_collectionOrders as $order) {
|
29 |
+
|
30 |
+
$lineItem = "";
|
31 |
+
|
32 |
+
// iterate on the itens in template
|
33 |
+
foreach($templateLine as $t) {
|
34 |
+
|
35 |
+
// order.increment_id => $order->getData("increment_id");
|
36 |
+
// getAttributeByCode($attribute, $order)
|
37 |
+
$item = "";
|
38 |
+
list($object, $attribute) = explode(".", $t);
|
39 |
+
|
40 |
+
switch($object) {
|
41 |
+
|
42 |
+
case "order":
|
43 |
+
|
44 |
+
$item = $order->getData($attribute);
|
45 |
+
break;
|
46 |
+
|
47 |
+
case "customer":
|
48 |
+
|
49 |
+
if ($attribute=="name") {
|
50 |
+
$item = $order->getData("customer_firstname") . " " .
|
51 |
+
$order->getData("customer_lastname");
|
52 |
+
} else {
|
53 |
+
$item = $order->getData("customer_{$attribute}");
|
54 |
+
}
|
55 |
+
|
56 |
+
break;
|
57 |
+
|
58 |
+
case "address":
|
59 |
+
|
60 |
+
$address = $order->getShippingAddress();
|
61 |
+
|
62 |
+
if (strpos($attribute, "street_")!==false) {
|
63 |
+
$street = explode("_", $attribute);
|
64 |
+
$item = $address->getStreet($street[1]);
|
65 |
+
} else {
|
66 |
+
$item = $address->getData($attribute);
|
67 |
+
}
|
68 |
+
|
69 |
+
break;
|
70 |
+
}
|
71 |
+
|
72 |
+
$lineItem.="{$item},";
|
73 |
+
}
|
74 |
+
|
75 |
+
// endline
|
76 |
+
$this->_contentCSV .=$lineItem ."\n";
|
77 |
+
}
|
78 |
+
}
|
79 |
+
|
80 |
+
public function call()
|
81 |
+
{
|
82 |
+
$this->_loadOrderObjects();
|
83 |
+
|
84 |
+
$templateLine = Mage::helper("custom_export")->loadTemplate();
|
85 |
+
|
86 |
+
$this->_prepareData($templateLine);
|
87 |
+
|
88 |
+
return $this->_contentCSV;
|
89 |
+
}
|
90 |
+
|
91 |
+
}
|
app/code/local/Lema21/CustomExport/Template/template.csv
ADDED
@@ -0,0 +1 @@
|
|
|
1 |
+
order.increment_id|order.status|order.created_at|customer.name|customer.email|customer.taxvat|address.street_1|address.street_2|address.street_3|address.street_4|address.city|address.region|address.postcode|address.telephone|order.shipping_description
|
app/code/local/Lema21/CustomExport/controllers/IndexController.php
ADDED
@@ -0,0 +1,23 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
|
4 |
+
require_once 'Mage/Adminhtml/controllers/Sales/OrderController.php';
|
5 |
+
|
6 |
+
class Lema21_CustomExport_IndexController
|
7 |
+
extends Mage_Adminhtml_Sales_OrderController {
|
8 |
+
|
9 |
+
const FILENAME = 'custom_orders.csv';
|
10 |
+
|
11 |
+
public function indexAction()
|
12 |
+
{
|
13 |
+
|
14 |
+
$post = $this->getRequest()->getPost();
|
15 |
+
|
16 |
+
$orderIdsList = $post['order_ids'];
|
17 |
+
|
18 |
+
$serviceGenerateCSV = new Lema21_CustomExport_Service_GenerateCSV($orderIdsList);
|
19 |
+
$contentCSV = $serviceGenerateCSV->call();
|
20 |
+
|
21 |
+
$this->_prepareDownloadResponse(self::FILENAME, $contentCSV);
|
22 |
+
}
|
23 |
+
}
|
app/code/local/Lema21/CustomExport/etc/config.xml
ADDED
@@ -0,0 +1,53 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<config>
|
3 |
+
<modules>
|
4 |
+
<Lema21_CustomExport>
|
5 |
+
<version>0.9</version>
|
6 |
+
</Lema21_CustomExport>
|
7 |
+
</modules>
|
8 |
+
<global>
|
9 |
+
<models>
|
10 |
+
<custom_export>
|
11 |
+
<class>Lema21_CustomExport_Model</class>
|
12 |
+
</custom_export>
|
13 |
+
</models>
|
14 |
+
<helpers>
|
15 |
+
<custom_export>
|
16 |
+
<class>Lema21_CustomExport_Helper</class>
|
17 |
+
</custom_export>
|
18 |
+
</helpers>
|
19 |
+
</global>
|
20 |
+
<admin>
|
21 |
+
<routers>
|
22 |
+
<Lema21_CustomExport>
|
23 |
+
<use>admin</use>
|
24 |
+
<args>
|
25 |
+
<module>Lema21_CustomExport</module>
|
26 |
+
<frontName>lema21_custom_export</frontName>
|
27 |
+
</args>
|
28 |
+
</Lema21_CustomExport>
|
29 |
+
</routers>
|
30 |
+
</admin>
|
31 |
+
<adminhtml>
|
32 |
+
<events>
|
33 |
+
<adminhtml_block_html_before>
|
34 |
+
<observers>
|
35 |
+
<option_in_custom_export>
|
36 |
+
<class>custom_export/Observer</class>
|
37 |
+
<method>includeOption</method>
|
38 |
+
</option_in_custom_export>
|
39 |
+
</observers>
|
40 |
+
</adminhtml_block_html_before>
|
41 |
+
</events>
|
42 |
+
|
43 |
+
<translate>
|
44 |
+
<modules>
|
45 |
+
<qualquer_id_unico_aqui>
|
46 |
+
<files>
|
47 |
+
<default>Lema21_CustomExport.csv</default>
|
48 |
+
</files>
|
49 |
+
</qualquer_id_unico_aqui>
|
50 |
+
</modules>
|
51 |
+
</translate>
|
52 |
+
</adminhtml>
|
53 |
+
</config>
|
app/etc/modules/Lema21_CustomExport.xml
ADDED
@@ -0,0 +1,27 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<!--
|
3 |
+
/**
|
4 |
+
* Lema21
|
5 |
+
* @category Lema21
|
6 |
+
* @package Lema21_CustomExport
|
7 |
+
* @copyright Copyright (c) 2010-2011 Unicode Systems. (http://www.unicodesystems.in)
|
8 |
+
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
|
9 |
+
|
10 |
+
Module to export orders to custom CSV
|
11 |
+
|
12 |
+
CSV template file available in Lema21/CustomExport/Template/template.csv
|
13 |
+
|
14 |
+
Possible Entities: order|customer|address
|
15 |
+
|
16 |
+
Example:
|
17 |
+
order.increment_id | order.status | order.grand_total | customer.email
|
18 |
+
|
19 |
+
*/-->
|
20 |
+
<config>
|
21 |
+
<modules>
|
22 |
+
<Lema21_CustomExport>
|
23 |
+
<active>true</active>
|
24 |
+
<codePool>local</codePool>
|
25 |
+
</Lema21_CustomExport>
|
26 |
+
</modules>
|
27 |
+
</config>
|
app/locale/pt_BR/Lema21_CustomExport.csv
ADDED
@@ -0,0 +1 @@
|
|
|
1 |
+
"Custom Export Data to CSV","Exportar pedidos para Controle"
|
package.xml
ADDED
@@ -0,0 +1,25 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<package>
|
3 |
+
<name>Lema21_CustomExport</name>
|
4 |
+
<version>0.9.0</version>
|
5 |
+
<stability>stable</stability>
|
6 |
+
<license uri="https://github.com/lema21/magent_custom_export">GNU General Public License (GPL)</license>
|
7 |
+
<channel>community</channel>
|
8 |
+
<extends/>
|
9 |
+
<summary>Module to export sales in Magento to custom CSV</summary>
|
10 |
+
<description>With this module is possible to export sales in custom CSV!
|
11 |
+

|
12 |
+

|
13 |
+
Possible Entities to export: order|customer|address
|
14 |
+

|
15 |
+
Example (file Template/template.csv):
|
16 |
+

|
17 |
+
order.increment_id | order.status | order.grand_total | customer.email</description>
|
18 |
+
<notes>Beta version</notes>
|
19 |
+
<authors><author><name>Marcelo Linhares</name><user>marcelolinhares</user><email>marcelolinhares@gmail.com</email></author></authors>
|
20 |
+
<date>2013-05-30</date>
|
21 |
+
<time>02:44:01</time>
|
22 |
+
<contents><target name="magelocal"><dir name="Lema21"><dir name="CustomExport"><dir name="Helper"><file name="Data.php" hash="1747c5c9e93a060724c8164c6e0ba322"/></dir><dir name="Model"><file name="Observer.php" hash="108f09a1ab28ea5d0b1e60685284a0b3"/></dir><dir name="Service"><file name="GenerateCSV.php" hash="d468e43d84bb9718b35688efeec70518"/></dir><dir name="Template"><file name="template.csv" hash="9b009f1f2aff39761d6e39f5ce670d70"/></dir><dir name="controllers"><file name="IndexController.php" hash="e93200cbf72dc408e5c08cf026b1a950"/></dir><dir name="etc"><file name="config.xml" hash="effcb99ff4b2f9af9a4e3fc9d48b4c85"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Lema21_CustomExport.xml" hash="e1dd042ae15ca61db6eeaa766c2db125"/></dir></target><target name="magelocale"><dir name="pt_BR"><file name="Lema21_CustomExport.csv" hash="3fd135fcccb6beedcb8462c2898c6ab3"/></dir></target></contents>
|
23 |
+
<compatible/>
|
24 |
+
<dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
|
25 |
+
</package>
|