<?php
$order_model = new shopOrderModel();
$sql = "SELECT * FROM shop_order WHERE state_id = 'deleted' AND paid_date IS NOT NULL";
foreach ($order_model->query($sql) as $order) {
$order_id = $order['id'];
shopCustomers::recalculateTotalSpent($order['contact_id']);
$order_model->updateById($order_id, array('paid_date' => null, 'paid_year' => null, 'paid_month' => null, 'paid_quarter' => null));
$order_model->returnProductsToStocks($order_id);
shopAffiliate::cancelBonus($order_id);
$order_model->recalculateProductsTotalSales($order_id);
}
