Version Notes
Fixed Minor bugs
Download this release
Release Info
Developer | Magento Core Team |
Extension | Yesha_DeleteOrder |
Version | 1.0.0 |
Comparing to | |
See all releases |
Version 1.0.0
app/code/community/Yesha/DeleteOrder/Block/Adminhtml/Sales/Order/Grid.php
ADDED
@@ -0,0 +1,218 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
/**
|
3 |
+
* Magento
|
4 |
+
*
|
5 |
+
* NOTICE OF LICENSE
|
6 |
+
*
|
7 |
+
* This source file is subject to the Open Software License (OSL 3.0)
|
8 |
+
* that is bundled with this package in the file LICENSE.txt.
|
9 |
+
* It is also available through the world-wide-web at this URL:
|
10 |
+
* http://opensource.org/licenses/osl-3.0.php
|
11 |
+
* If you did not receive a copy of the license and are unable to
|
12 |
+
* obtain it through the world-wide-web, please send an email
|
13 |
+
* to license@magentocommerce.com so we can send you a copy immediately.
|
14 |
+
*
|
15 |
+
* DISCLAIMER
|
16 |
+
*
|
17 |
+
* Do not edit or add to this file if you wish to upgrade Magento to newer
|
18 |
+
* versions in the future. If you wish to customize Magento for your
|
19 |
+
* needs please refer to http://www.magentocommerce.com for more information.
|
20 |
+
*
|
21 |
+
* @category Mage
|
22 |
+
* @package Mage_Adminhtml
|
23 |
+
* @copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
|
24 |
+
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
|
25 |
+
*/
|
26 |
+
|
27 |
+
/**
|
28 |
+
* Adminhtml sales orders grid
|
29 |
+
*
|
30 |
+
* @category Mage
|
31 |
+
* @package Mage_Adminhtml
|
32 |
+
* @author Magento Core Team <core@magentocommerce.com>
|
33 |
+
*/
|
34 |
+
class Yesha_DeleteOrder_Block_Adminhtml_Sales_Order_Grid extends Mage_Adminhtml_Block_Sales_Order_Grid
|
35 |
+
{
|
36 |
+
|
37 |
+
|
38 |
+
public function __construct()
|
39 |
+
{
|
40 |
+
parent::__construct();
|
41 |
+
$this->setId('sales_order_grid');
|
42 |
+
$this->setUseAjax(true);
|
43 |
+
$this->setDefaultSort('created_at');
|
44 |
+
$this->setDefaultDir('DESC');
|
45 |
+
$this->setSaveParametersInSession(true);
|
46 |
+
}
|
47 |
+
|
48 |
+
/**
|
49 |
+
* Retrieve collection class
|
50 |
+
*
|
51 |
+
* @return string
|
52 |
+
*/
|
53 |
+
/*protected function _getCollectionClass()
|
54 |
+
{
|
55 |
+
return 'sales/order_grid_collection';
|
56 |
+
}*/
|
57 |
+
|
58 |
+
protected function _prepareCollection()
|
59 |
+
{
|
60 |
+
$collection = Mage::getResourceModel($this->_getCollectionClass());
|
61 |
+
$this->setCollection($collection);
|
62 |
+
return parent::_prepareCollection();
|
63 |
+
}
|
64 |
+
|
65 |
+
protected function _prepareColumns()
|
66 |
+
{
|
67 |
+
|
68 |
+
$this->addColumn('real_order_id', array(
|
69 |
+
'header'=> Mage::helper('sales')->__('Order #'),
|
70 |
+
'width' => '80px',
|
71 |
+
'type' => 'text',
|
72 |
+
'index' => 'increment_id',
|
73 |
+
));
|
74 |
+
|
75 |
+
if (!Mage::app()->isSingleStoreMode()) {
|
76 |
+
$this->addColumn('store_id', array(
|
77 |
+
'header' => Mage::helper('sales')->__('Purchased From (Store)'),
|
78 |
+
'index' => 'store_id',
|
79 |
+
'type' => 'store',
|
80 |
+
'store_view'=> true,
|
81 |
+
'display_deleted' => true,
|
82 |
+
));
|
83 |
+
}
|
84 |
+
|
85 |
+
$this->addColumn('created_at', array(
|
86 |
+
'header' => Mage::helper('sales')->__('Purchased On'),
|
87 |
+
'index' => 'created_at',
|
88 |
+
'type' => 'datetime',
|
89 |
+
'width' => '100px',
|
90 |
+
));
|
91 |
+
|
92 |
+
$this->addColumn('billing_name', array(
|
93 |
+
'header' => Mage::helper('sales')->__('Bill to Name'),
|
94 |
+
'index' => 'billing_name',
|
95 |
+
));
|
96 |
+
|
97 |
+
$this->addColumn('shipping_name', array(
|
98 |
+
'header' => Mage::helper('sales')->__('Ship to Name'),
|
99 |
+
'index' => 'shipping_name',
|
100 |
+
));
|
101 |
+
|
102 |
+
$this->addColumn('base_grand_total', array(
|
103 |
+
'header' => Mage::helper('sales')->__('G.T. (Base)'),
|
104 |
+
'index' => 'base_grand_total',
|
105 |
+
'type' => 'currency',
|
106 |
+
'currency' => 'base_currency_code',
|
107 |
+
));
|
108 |
+
|
109 |
+
$this->addColumn('grand_total', array(
|
110 |
+
'header' => Mage::helper('sales')->__('G.T. (Purchased)'),
|
111 |
+
'index' => 'grand_total',
|
112 |
+
'type' => 'currency',
|
113 |
+
'currency' => 'order_currency_code',
|
114 |
+
));
|
115 |
+
|
116 |
+
$this->addColumn('status', array(
|
117 |
+
'header' => Mage::helper('sales')->__('Status'),
|
118 |
+
'index' => 'status',
|
119 |
+
'type' => 'options',
|
120 |
+
'width' => '70px',
|
121 |
+
'options' => Mage::getSingleton('sales/order_config')->getStatuses(),
|
122 |
+
));
|
123 |
+
|
124 |
+
if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/view')) {
|
125 |
+
$this->addColumn('action',
|
126 |
+
array(
|
127 |
+
'header' => Mage::helper('sales')->__('Action'),
|
128 |
+
'width' => '50px',
|
129 |
+
'type' => 'action',
|
130 |
+
'getter' => 'getId',
|
131 |
+
'actions' => array(
|
132 |
+
array(
|
133 |
+
'caption' => Mage::helper('sales')->__('View'),
|
134 |
+
'url' => array('base'=>'*/sales_order/view'),
|
135 |
+
'field' => 'order_id'
|
136 |
+
)
|
137 |
+
),
|
138 |
+
'filter' => false,
|
139 |
+
'sortable' => false,
|
140 |
+
'index' => 'stores',
|
141 |
+
'is_system' => true,
|
142 |
+
));
|
143 |
+
}
|
144 |
+
$this->addRssList('rss/order/new', Mage::helper('sales')->__('New Order RSS'));
|
145 |
+
|
146 |
+
$this->addExportType('*/*/exportCsv', Mage::helper('sales')->__('CSV'));
|
147 |
+
$this->addExportType('*/*/exportExcel', Mage::helper('sales')->__('Excel'));
|
148 |
+
|
149 |
+
return parent::_prepareColumns();
|
150 |
+
}
|
151 |
+
|
152 |
+
protected function _prepareMassaction()
|
153 |
+
{
|
154 |
+
$this->setMassactionIdField('entity_id');
|
155 |
+
$this->getMassactionBlock()->setFormFieldName('order_ids');
|
156 |
+
$this->getMassactionBlock()->setUseSelectAll(false);
|
157 |
+
|
158 |
+
if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/cancel')) {
|
159 |
+
$this->getMassactionBlock()->addItem('cancel_order', array(
|
160 |
+
'label'=> Mage::helper('sales')->__('Cancel'),
|
161 |
+
'url' => $this->getUrl('*/sales_order/massCancel'),
|
162 |
+
));
|
163 |
+
}
|
164 |
+
|
165 |
+
if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/hold')) {
|
166 |
+
$this->getMassactionBlock()->addItem('hold_order', array(
|
167 |
+
'label'=> Mage::helper('sales')->__('Hold'),
|
168 |
+
'url' => $this->getUrl('*/sales_order/massHold'),
|
169 |
+
));
|
170 |
+
}
|
171 |
+
|
172 |
+
if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/unhold')) {
|
173 |
+
$this->getMassactionBlock()->addItem('unhold_order', array(
|
174 |
+
'label'=> Mage::helper('sales')->__('Unhold'),
|
175 |
+
'url' => $this->getUrl('*/sales_order/massUnhold'),
|
176 |
+
));
|
177 |
+
}
|
178 |
+
|
179 |
+
$this->getMassactionBlock()->addItem('pdfinvoices_order', array(
|
180 |
+
'label'=> Mage::helper('sales')->__('Print Invoices'),
|
181 |
+
'url' => $this->getUrl('*/sales_order/pdfinvoices'),
|
182 |
+
));
|
183 |
+
|
184 |
+
$this->getMassactionBlock()->addItem('pdfshipments_order', array(
|
185 |
+
'label'=> Mage::helper('sales')->__('Print Packingslips'),
|
186 |
+
'url' => $this->getUrl('*/sales_order/pdfshipments'),
|
187 |
+
));
|
188 |
+
|
189 |
+
$this->getMassactionBlock()->addItem('pdfcreditmemos_order', array(
|
190 |
+
'label'=> Mage::helper('sales')->__('Print Credit Memos'),
|
191 |
+
'url' => $this->getUrl('*/sales_order/pdfcreditmemos'),
|
192 |
+
));
|
193 |
+
|
194 |
+
$this->getMassactionBlock()->addItem('pdfdocs_order', array(
|
195 |
+
'label'=> Mage::helper('sales')->__('Print All'),
|
196 |
+
'url' => $this->getUrl('*/sales_order/pdfdocs'),
|
197 |
+
));
|
198 |
+
$this->getMassactionBlock()->addItem('delete_order', array(
|
199 |
+
'label'=> Mage::helper('sales')->__('Delete order'),
|
200 |
+
'url' => $this->getUrl('*/sales_order/deleteorder'),
|
201 |
+
));
|
202 |
+
return $this;
|
203 |
+
}
|
204 |
+
|
205 |
+
public function getRowUrl($row)
|
206 |
+
{
|
207 |
+
if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/view')) {
|
208 |
+
return $this->getUrl('*/sales_order/view', array('order_id' => $row->getId()));
|
209 |
+
}
|
210 |
+
return false;
|
211 |
+
}
|
212 |
+
|
213 |
+
public function getGridUrl()
|
214 |
+
{
|
215 |
+
return $this->getUrl('*/*/grid', array('_current'=>true));
|
216 |
+
}
|
217 |
+
|
218 |
+
}
|
app/code/community/Yesha/DeleteOrder/controllers/Adminhtml/Sales/OrderController.php
ADDED
@@ -0,0 +1,202 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
require_once 'Mage/Adminhtml/controllers/Sales/OrderController.php';
|
3 |
+
class Yesha_DeleteOrder_Adminhtml_Sales_OrderController extends Mage_Adminhtml_Sales_OrderController
|
4 |
+
{
|
5 |
+
public function deleteorderAction()
|
6 |
+
{
|
7 |
+
|
8 |
+
$orderIds = $this->getRequest()->getPost('order_ids');
|
9 |
+
$flag = false;
|
10 |
+
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
|
11 |
+
$query="show tables";
|
12 |
+
$rsc_table=$write->fetchCol($query);
|
13 |
+
|
14 |
+
$table_sales_flat_order = Mage::getSingleton('core/resource')->getTableName('sales_flat_order');
|
15 |
+
$table_sales_flat_creditmemo_comment= Mage::getSingleton('core/resource')->getTableName('sales_flat_creditmemo_comment');
|
16 |
+
$table_sales_flat_creditmemo_item= Mage::getSingleton('core/resource')->getTableName('sales_flat_creditmemo_item');
|
17 |
+
$table_sales_flat_creditmemo= Mage::getSingleton('core/resource')->getTableName('sales_flat_creditmemo');
|
18 |
+
$table_sales_flat_creditmemo_grid= Mage::getSingleton('core/resource')->getTableName('sales_flat_creditmemo_grid');
|
19 |
+
$table_sales_flat_invoice_comment= Mage::getSingleton('core/resource')->getTableName('sales_flat_invoice_comment');
|
20 |
+
$table_sales_flat_invoice_item= Mage::getSingleton('core/resource')->getTableName('sales_flat_invoice_item');
|
21 |
+
$table_sales_flat_invoice= Mage::getSingleton('core/resource')->getTableName('sales_flat_invoice');
|
22 |
+
$table_sales_flat_invoice_grid= Mage::getSingleton('core/resource')->getTableName('sales_flat_invoice_grid');
|
23 |
+
$table_sales_flat_quote_address_item= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote_address_item');
|
24 |
+
$table_sales_flat_quote_item_option= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote_item_option');
|
25 |
+
$table_sales_flat_quote= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote');
|
26 |
+
$table_sales_flat_quote_address= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote_address');
|
27 |
+
$table_sales_flat_quote_item= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote_item');
|
28 |
+
$table_sales_flat_quote_payment= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote_payment');
|
29 |
+
$table_sales_flat_shipment_comment= Mage::getSingleton('core/resource')->getTableName('sales_flat_shipment_comment');
|
30 |
+
$table_sales_flat_shipment_item= Mage::getSingleton('core/resource')->getTableName('sales_flat_shipment_item');
|
31 |
+
$table_sales_flat_shipment_track= Mage::getSingleton('core/resource')->getTableName('sales_flat_shipment_track');
|
32 |
+
$table_sales_flat_shipment= Mage::getSingleton('core/resource')->getTableName('sales_flat_shipment');
|
33 |
+
$table_sales_flat_shipment_grid= Mage::getSingleton('core/resource')->getTableName('sales_flat_shipment_grid');
|
34 |
+
$table_sales_flat_order_address= Mage::getSingleton('core/resource')->getTableName('sales_flat_order_address');
|
35 |
+
$table_sales_flat_order_item= Mage::getSingleton('core/resource')->getTableName('sales_flat_order_item');
|
36 |
+
$table_sales_flat_order_payment= Mage::getSingleton('core/resource')->getTableName('sales_flat_order_payment');
|
37 |
+
$table_sales_flat_order_status_history= Mage::getSingleton('core/resource')->getTableName('sales_flat_order_status_history');
|
38 |
+
$table_sales_flat_order_grid= Mage::getSingleton('core/resource')->getTableName('sales_flat_order_grid');
|
39 |
+
$table_log_quote= Mage::getSingleton('core/resource')->getTableName('log_quote');
|
40 |
+
$quoteId='';
|
41 |
+
if (!empty($orderIds)) {
|
42 |
+
foreach ($orderIds as $orderId) {
|
43 |
+
$query=null;
|
44 |
+
$order = Mage::getModel('sales/order')->load($orderId);
|
45 |
+
if($order->increment_id){
|
46 |
+
/*$query="show tables like 'sales_flat_order'";
|
47 |
+
$rs=$write->fetchAll($query);*/
|
48 |
+
$incId=$order->increment_id;
|
49 |
+
if(in_array($table_sales_flat_order,$rsc_table)){
|
50 |
+
$query='SELECT entity_id FROM '.$table_sales_flat_order.' WHERE increment_id="'.mysql_escape_string($incId).'"';
|
51 |
+
|
52 |
+
$rs=$write->fetchAll($query);
|
53 |
+
|
54 |
+
$query='SELECT quote_id FROM '.$table_sales_flat_order.' WHERE entity_id="'.mysql_escape_string($orderId).'"';
|
55 |
+
$rs1=$write->fetchAll($query);
|
56 |
+
$quoteId=$rs1[0]['quote_id'];
|
57 |
+
}
|
58 |
+
|
59 |
+
$query='SET FOREIGN_KEY_CHECKS=1';
|
60 |
+
$rs3=$write->query($query);
|
61 |
+
//print_r($rsc_table);
|
62 |
+
//echo $table_sales_flat_creditmemo_comment;
|
63 |
+
if(in_array($table_sales_flat_creditmemo_comment,$rsc_table)){
|
64 |
+
//echo "DELETE FROM ".$table_sales_flat_creditmemo_comment." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_creditmemo." WHERE order_id=".$orderId.")";
|
65 |
+
//die;
|
66 |
+
$write->query("DELETE FROM ".$table_sales_flat_creditmemo_comment." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_creditmemo." WHERE order_id='".mysql_escape_string($orderId)."')");
|
67 |
+
}
|
68 |
+
//die;
|
69 |
+
|
70 |
+
|
71 |
+
if(in_array('sales_flat_creditmemo_item',$rsc_table)){
|
72 |
+
$write->query("DELETE FROM ".$table_sales_flat_creditmemo_item." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_creditmemo." WHERE order_id='".mysql_escape_string($orderId)."')");
|
73 |
+
}
|
74 |
+
|
75 |
+
|
76 |
+
if(in_array($table_sales_flat_creditmemo,$rsc_table)){
|
77 |
+
$write->query("DELETE FROM ".$table_sales_flat_creditmemo." WHERE order_id='".mysql_escape_string($orderId)."'");
|
78 |
+
}
|
79 |
+
|
80 |
+
|
81 |
+
|
82 |
+
if(in_array($table_sales_flat_creditmemo_grid,$rsc_table)){
|
83 |
+
$write->query("DELETE FROM ".$table_sales_flat_creditmemo_grid." WHERE order_id='".mysql_escape_string($orderId)."'");
|
84 |
+
}
|
85 |
+
|
86 |
+
|
87 |
+
if(in_array($table_sales_flat_invoice_comment,$rsc_table)){
|
88 |
+
|
89 |
+
$write->query("DELETE FROM ".$table_sales_flat_invoice_comment." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_invoice." WHERE order_id='".mysql_escape_string($orderId)."')");
|
90 |
+
}
|
91 |
+
|
92 |
+
if(in_array($table_sales_flat_invoice_item,$rsc_table)){
|
93 |
+
|
94 |
+
$write->query("DELETE FROM ".$table_sales_flat_invoice_item." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_invoice." WHERE order_id='".mysql_escape_string($orderId)."')");
|
95 |
+
}
|
96 |
+
|
97 |
+
|
98 |
+
if(in_array($table_sales_flat_invoice,$rsc_table)){
|
99 |
+
|
100 |
+
$write->query("DELETE FROM ".$table_sales_flat_invoice." WHERE order_id='".mysql_escape_string($orderId)."'");
|
101 |
+
}
|
102 |
+
|
103 |
+
if(in_array($table_sales_flat_invoice_grid,$rsc_table)){
|
104 |
+
|
105 |
+
$write->query("DELETE FROM ".$table_sales_flat_invoice_grid." WHERE order_id='".mysql_escape_string($orderId)."'");
|
106 |
+
}
|
107 |
+
|
108 |
+
if($quoteId){
|
109 |
+
if(in_array($table_sales_flat_quote_address_item,$rsc_table)){
|
110 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote_address_item." WHERE parent_item_id IN (SELECT address_id FROM ".$table_sales_flat_quote_address." WHERE quote_id=".$quoteId.")");
|
111 |
+
}
|
112 |
+
|
113 |
+
$table_sales_flat_quote_shipping_rate= Mage::getSingleton('core/resource')->getTableName('sales_flat_quote_shipping_rate');
|
114 |
+
if(in_array($table_sales_flat_quote_shipping_rate,$rsc_table)){
|
115 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote_shipping_rate." WHERE address_id IN (SELECT address_id FROM ".$table_sales_flat_quote_address." WHERE quote_id=".$quoteId.")");
|
116 |
+
}
|
117 |
+
|
118 |
+
if(in_array($table_sales_flat_quote_item_option,$rsc_table)){
|
119 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote_item_option." WHERE item_id IN (SELECT item_id FROM ".$table_sales_flat_quote_item." WHERE quote_id=".$quoteId.")");
|
120 |
+
}
|
121 |
+
|
122 |
+
|
123 |
+
if(in_array($table_sales_flat_quote,$rsc_table)){
|
124 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote." WHERE entity_id=".$quoteId);
|
125 |
+
}
|
126 |
+
|
127 |
+
if(in_array($table_sales_flat_quote_address,$rsc_table)){
|
128 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote_address." WHERE quote_id=".$quoteId);
|
129 |
+
}
|
130 |
+
|
131 |
+
if(in_array($table_sales_flat_quote_item,$rsc_table)){
|
132 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote_item." WHERE quote_id=".$quoteId);
|
133 |
+
}
|
134 |
+
|
135 |
+
if(in_array('sales_flat_quote_payment',$rsc_table)){
|
136 |
+
$write->query("DELETE FROM ".$table_sales_flat_quote_payment." WHERE quote_id=".$quoteId);
|
137 |
+
}
|
138 |
+
|
139 |
+
}
|
140 |
+
|
141 |
+
|
142 |
+
if(in_array($table_sales_flat_shipment_comment,$rsc_table)){
|
143 |
+
$write->query("DELETE FROM ".$table_sales_flat_shipment_comment." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_shipment." WHERE order_id='".mysql_escape_string($orderId)."')");
|
144 |
+
}
|
145 |
+
|
146 |
+
if(in_array($table_sales_flat_shipment_item,$rsc_table)){
|
147 |
+
$write->query("DELETE FROM ".$table_sales_flat_shipment_item." WHERE parent_id IN (SELECT entity_id FROM ".$table_sales_flat_shipment." WHERE order_id='".mysql_escape_string($orderId)."')");
|
148 |
+
}
|
149 |
+
|
150 |
+
|
151 |
+
if(in_array($table_sales_flat_shipment_track,$rsc_table)){
|
152 |
+
$write->query("DELETE FROM ".$table_sales_flat_shipment_track." WHERE order_id IN (SELECT entity_id FROM ".$table_sales_flat_shipment." WHERE order_id='".mysql_escape_string($orderId)."')");
|
153 |
+
}
|
154 |
+
|
155 |
+
|
156 |
+
if(in_array($table_sales_flat_shipment,$rsc_table)){
|
157 |
+
|
158 |
+
$write->query("DELETE FROM ".$table_sales_flat_shipment." WHERE order_id='".mysql_escape_string($orderId)."'");
|
159 |
+
}
|
160 |
+
|
161 |
+
|
162 |
+
if(in_array($table_sales_flat_shipment_grid,$rsc_table)){
|
163 |
+
$write->query("DELETE FROM ".$table_sales_flat_shipment_grid." WHERE order_id='".mysql_escape_string($orderId)."'");
|
164 |
+
}
|
165 |
+
|
166 |
+
if(in_array($table_sales_flat_order,$rsc_table)){
|
167 |
+
$write->query("DELETE FROM ".$table_sales_flat_order." WHERE entity_id='".mysql_escape_string($orderId)."'");
|
168 |
+
}
|
169 |
+
|
170 |
+
if(in_array($table_sales_flat_order_address,$rsc_table)){
|
171 |
+
$write->query("DELETE FROM ".$table_sales_flat_order_address." WHERE parent_id='".mysql_escape_string($orderId)."'");
|
172 |
+
}
|
173 |
+
|
174 |
+
if(in_array($table_sales_flat_order_item,$rsc_table)){
|
175 |
+
$write->query("DELETE FROM ".$table_sales_flat_order_item." WHERE order_id='".mysql_escape_string($orderId)."'");
|
176 |
+
}
|
177 |
+
if(in_array($table_sales_flat_order_payment,$rsc_table)){
|
178 |
+
$write->query("DELETE FROM ".$table_sales_flat_order_payment." WHERE parent_id='".mysql_escape_string($orderId)."'");
|
179 |
+
}
|
180 |
+
if(in_array($table_sales_flat_order_status_history,$rsc_table)){
|
181 |
+
$write->query("DELETE FROM ".$table_sales_flat_order_status_history." WHERE parent_id='".mysql_escape_string($orderId)."'");
|
182 |
+
}
|
183 |
+
if($incId&&in_array($table_sales_flat_order_grid,$rsc_table)){
|
184 |
+
$write->query("DELETE FROM ".$table_sales_flat_order_grid." WHERE increment_id='".mysql_escape_string($incId)."'");
|
185 |
+
|
186 |
+
}
|
187 |
+
|
188 |
+
$query="show tables like '%".$table_log_quote."'";
|
189 |
+
$rsc_table_l=$write->fetchCol($query);
|
190 |
+
if($quoteId&&$rsc_table_l){
|
191 |
+
$write->query("DELETE FROM ".$table_log_quote." WHERE quote_id=".$quoteId);
|
192 |
+
}
|
193 |
+
$write->query("SET FOREIGN_KEY_CHECKS=1");
|
194 |
+
}
|
195 |
+
}
|
196 |
+
$this->_getSession()->addSuccess($this->__('Order(s) deleted.'));
|
197 |
+
}else{
|
198 |
+
$this->_getSession()->addError($this->__('Order(s) error.'));
|
199 |
+
}
|
200 |
+
$this->_redirect('*/*/');
|
201 |
+
}
|
202 |
+
}
|
app/code/community/Yesha/DeleteOrder/etc/config.xml
ADDED
@@ -0,0 +1,42 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<config>
|
3 |
+
<modules>
|
4 |
+
<Yesha_DeleteOrder>
|
5 |
+
<version>1.0.0</version>
|
6 |
+
</Yesha_DeleteOrder>
|
7 |
+
</modules>
|
8 |
+
<global>
|
9 |
+
<rewrite>
|
10 |
+
<em_emadmin_adminhtml_sales_order>
|
11 |
+
<from><![CDATA[#/admin/sales_order/#]]></from>
|
12 |
+
<to>/emadmin/adminhtml_sales_order/</to>
|
13 |
+
</em_emadmin_adminhtml_sales_order>
|
14 |
+
</rewrite>
|
15 |
+
|
16 |
+
<blocks>
|
17 |
+
<adminhtml>
|
18 |
+
<rewrite>
|
19 |
+
<sales_order_grid>Yesha_DeleteOrder_Block_Adminhtml_Sales_Order_Grid</sales_order_grid>
|
20 |
+
</rewrite>
|
21 |
+
</adminhtml>
|
22 |
+
</blocks>
|
23 |
+
</global>
|
24 |
+
<admin>
|
25 |
+
<routers>
|
26 |
+
<em_deleteorder>
|
27 |
+
<use>admin</use>
|
28 |
+
<args>
|
29 |
+
<module>Yesha_DeleteOrder</module>
|
30 |
+
<frontName>emadmin</frontName>
|
31 |
+
</args>
|
32 |
+
</em_deleteorder>
|
33 |
+
<adminhtml>
|
34 |
+
<args>
|
35 |
+
<modules>
|
36 |
+
<Yesha_DeleteOrder_Adminhtml before="Mage_Adminhtml">Yesha_DeleteOrder_Adminhtml</Yesha_DeleteOrder_Adminhtml>
|
37 |
+
</modules>
|
38 |
+
</args>
|
39 |
+
</adminhtml>
|
40 |
+
</routers>
|
41 |
+
</admin>
|
42 |
+
</config>
|
app/etc/modules/Yesha_DeleteOrder.xml
ADDED
@@ -0,0 +1,9 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<config>
|
3 |
+
<modules>
|
4 |
+
<Yesha_DeleteOrder>
|
5 |
+
<active>true</active>
|
6 |
+
<codePool>community</codePool>
|
7 |
+
</Yesha_DeleteOrder>
|
8 |
+
</modules>
|
9 |
+
</config>
|
package.xml
ADDED
@@ -0,0 +1,36 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<package>
|
3 |
+
<name>Yesha_DeleteOrder</name>
|
4 |
+
<version>1.0.0</version>
|
5 |
+
<stability>stable</stability>
|
6 |
+
<license uri="http://www.opensource.org/licenses/osl-3.0.php">OSL v3.0</license>
|
7 |
+
<channel>community</channel>
|
8 |
+
<extends/>
|
9 |
+
<summary>Easy to delete order in backend through the Action dropdown box on the native Order Manager.</summary>
|
10 |
+
<description>Yesha Delete Order
|
11 |
+

|
12 |
+
Easy to delete order in backend seamlessly through the Action dropdown box on the native Order Manager.
|
13 |
+

|
14 |
+
Installation:
|
15 |
+

|
16 |
+
1. Install the extension through Magento Connect.
|
17 |
+

|
18 |
+
2. Go to System > Cache Management > Click button Flush Magento Cache.
|
19 |
+

|
20 |
+
3. Logout out and re-login.
|
21 |
+

|
22 |
+
4. If it still not works, delete the file downloader/pearlib/pear.ini and do following step 1 to 3 again.
|
23 |
+

|
24 |
+
Usage:
|
25 |
+

|
26 |
+
In the backend, Sales menu > Orders, tick on orders you want to delete, select Action Delete at the top right corner.
|
27 |
+

|
28 |
+
PLEASE REMEMBER TO BACKUP YOUR DATABASE BEFORE USING THIS EXTENSION</description>
|
29 |
+
<notes>Fixed Minor bugs</notes>
|
30 |
+
<authors><author><name>Yesha Patel</name><user>auto-converted</user><email>yesha3012@hotmail.com</email></author></authors>
|
31 |
+
<date>2011-11-21</date>
|
32 |
+
<time>06:14:16</time>
|
33 |
+
<contents><target name="magecommunity"><dir name="Yesha"><dir name="DeleteOrder"><dir name="Block"><dir name="Adminhtml"><dir name="Sales"><dir name="Order"><file name="Grid.php" hash="22db99be88fbe30ad6f5f762b2fd8c2f"/></dir></dir></dir></dir><dir name="controllers"><dir name="Adminhtml"><dir name="Sales"><file name="OrderController.php" hash="b5ccca753db96d60fbcc10e1b4558f0c"/></dir></dir></dir><dir name="etc"><file name="config.xml" hash="3f17d1df3227b22384c2e98291a393de"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Yesha_DeleteOrder.xml" hash="70af7ef462fb8b865afd765a85d2d4e7"/></dir></target></contents>
|
34 |
+
<compatible/>
|
35 |
+
<dependencies/>
|
36 |
+
</package>
|