Вход Регистрация
Файл: upload-2031-rs1/admin/controller/extension/openbay.php
Строк: 2320
<?php
class ControllerExtensionOpenbay extends Controller {
    private 
$error = array();

    public function 
install() {
        
$this->load->language('extension/openbay');

        
$this->load->model('extension/extension');

        if (!
$this->user->hasPermission('modify''extension/openbay')) {
            
$this->session->data['error'] = $this->language->get('error_permission');

            
$this->response->redirect($this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'));
        } else {
            
$this->model_extension_extension->install('openbay'$this->request->get['extension']);

            
$this->session->data['success'] = $this->language->get('text_install_success');

            
$this->load->model('user/user_group');

            
$this->model_user_user_group->addPermission($this->user->getGroupId(), 'access''openbay/' $this->request->get['extension']);
            
$this->model_user_user_group->addPermission($this->user->getGroupId(), 'modify''openbay/' $this->request->get['extension']);

            require_once(
DIR_APPLICATION 'controller/openbay/' $this->request->get['extension'] . '.php');

            
$class 'ControllerOpenbay' str_replace('_'''$this->request->get['extension']);
            
$class = new $class($this->registry);

            if (
method_exists($class'install')) {
                
$class->install();
            }

            
$this->response->redirect($this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'));
        }
    }

    public function 
uninstall() {
        
$this->load->language('extension/openbay');

        
$this->load->model('extension/extension');

        if (!
$this->user->hasPermission('modify''extension/openbay')) {
            
$this->session->data['error'] = $this->language->get('error_permission');

            
$this->response->redirect($this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'));
        } else {
            
$this->session->data['success'] = $this->language->get('text_uninstall_success');

            require_once(
DIR_APPLICATION 'controller/openbay/' $this->request->get['extension'] . '.php');

            
$this->load->model('extension/extension');
            
$this->load->model('setting/setting');

            
$this->model_extension_extension->uninstall('openbay'$this->request->get['extension']);
            
$this->model_setting_setting->deleteSetting($this->request->get['extension']);

            
$class 'ControllerOpenbay' str_replace('_'''$this->request->get['extension']);
            
$class = new $class($this->registry);

            if (
method_exists($class'uninstall')) {
                
$class->uninstall();
            }

            
$this->response->redirect($this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'));
        }
    }

    public function 
index() {
        
$this->load->model('openbay/openbay');
        
$this->load->model('extension/extension');
        
$this->load->model('setting/setting');
        
$this->load->model('openbay/version');

        
$data $this->load->language('extension/openbay');

        
$this->document->setTitle($this->language->get('heading_title'));
        
$this->document->addScript('view/javascript/openbay/js/faq.js');

        
$data['breadcrumbs'] = array();

        
$data['breadcrumbs'][] = array(
            
'text' => $this->language->get('text_home'),
            
'href' => $this->url->link('common/dashboard''token=' $this->session->data['token'], 'SSL'),
        );

        
$data['breadcrumbs'][] = array(
            
'text' => $this->language->get('heading_title'),
            
'href' => $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'),
        );

        
$data['manage_link'] = $this->url->link('extension/openbay/manage''token=' $this->session->data['token'], 'SSL');
        
$data['product_link'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'], 'SSL');
        
$data['order_link'] = $this->url->link('extension/openbay/orderlist''token=' $this->session->data['token'], 'SSL');

        
$data['success'] = '';
        if (isset(
$this->session->data['success'])) {
            
$data['success'] = $this->session->data['success'];
            unset(
$this->session->data['success']);
        }

        
$data['error'] = $this->model_openbay_openbay->requirementTest();

        if (isset(
$this->session->data['error'])) {
            
$data['error'][] = $this->session->data['error'];
            unset(
$this->session->data['error']);
        }

        
$extensions $this->model_extension_extension->getInstalled('openbay');

        foreach (
$extensions as $key => $value) {
            if (!
file_exists(DIR_APPLICATION 'controller/openbay/' $value '.php')) {
                
$this->model_extension_extension->uninstall('openbay'$value);
                unset(
$extensions[$key]);
            }
        }

        
$data['extensions'] = array();

        
$markets = array('ebay''etsy''amazon''amazonus');

        foreach (
$markets as $market) {
            
$extension basename($market'.php');

            
$this->load->language('openbay/' $extension);

            
$data['extensions'][] = array(
                
'name' => $this->language->get('heading_title'),
                
'edit' => $this->url->link('openbay/' $extension '''token=' $this->session->data['token'], 'SSL'),
                
'status' => ($this->config->get('openbay_' $extension '_status') || $this->config->get($extension '_status')) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
                
'install' => $this->url->link('extension/openbay/install''token=' $this->session->data['token'] . '&extension=' $extension'SSL'),
                
'uninstall' => $this->url->link('extension/openbay/uninstall''token=' $this->session->data['token'] . '&extension=' $extension'SSL'),
                
'installed' => in_array($extension$extensions),
                
'code' => $extension
            
);
        }

        
$settings $this->model_setting_setting->getSetting('openbay');

        if (isset(
$settings['openbay_version'])) {
            
$data['openbay_version'] = $settings['openbay_version'];
        } else {
            
$data['openbay_version'] = $this->model_openbay_version->version();
            
$settings['openbay_version'] = $this->model_openbay_version->version();
            
$this->model_setting_setting->editSetting('openbay'$settings);
        }

        
$data['token'] = $this->session->data['token'];

        
$data['header'] = $this->load->controller('common/header');
        
$data['column_left'] = $this->load->controller('common/column_left');
        
$data['footer'] = $this->load->controller('common/footer');

        
$this->response->setOutput($this->load->view('extension/openbay.tpl'$data));
    }

    public function 
manage() {
        
$this->load->model('setting/setting');

        
$data $this->load->language('extension/openbay');

        
$this->document->setTitle($this->language->get('text_manage'));
        
$this->document->addScript('view/javascript/openbay/js/faq.js');

        
$data['breadcrumbs'] = array();

        
$data['breadcrumbs'][] = array(
            
'href' => $this->url->link('common/dashboard''token=' $this->session->data['token'], 'SSL'),
            
'text' => $this->language->get('text_home'),
        );

        
$data['breadcrumbs'][] = array(
            
'href' => $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'),
            
'text' => $this->language->get('heading_title'),
        );

        
$data['breadcrumbs'][] = array(
            
'href' => $this->url->link('extension/openbay/manage''token=' $this->session->data['token'], 'SSL'),
            
'text' => $this->language->get('text_manage'),
        );

        if (
$this->request->server['REQUEST_METHOD'] == 'POST') {
            
$this->model_setting_setting->editSetting('openbay'$this->request->post);

            
$this->session->data['success'] = $this->language->get('text_success');

            
$this->response->redirect($this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'));
        }

        if (isset(
$this->request->post['openbay_version'])) {
            
$data['openbay_version'] = $this->request->post['openbay_version'];
        } else {
            
$settings $this->model_setting_setting->getSetting('openbay');

            if (isset(
$settings['openbay_version'])) {
                
$data['openbay_version'] = $settings['openbay_version'];
            } else {
                
$this->load->model('openbay/version');
                
$settings['openbay_version'] = $this->model_openbay_version->version();
                
$data['openbay_version'] = $this->model_openbay_version->version();
                
$this->model_setting_setting->editSetting('openbay'$settings);
            }
        }

        if (isset(
$this->request->post['openbay_ftp_username'])) {
            
$data['openbay_ftp_username'] = $this->request->post['openbay_ftp_username'];
        } else {
            
$data['openbay_ftp_username'] = $this->config->get('openbay_ftp_username');
        }

        if (isset(
$this->request->post['openbay_ftp_pw'])) {
            
$data['openbay_ftp_pw'] = $this->request->post['openbay_ftp_pw'];
        } else {
            
$data['openbay_ftp_pw'] = $this->config->get('openbay_ftp_pw');
        }

        if (isset(
$this->request->post['openbay_ftp_rootpath'])) {
            
$data['openbay_ftp_rootpath'] = $this->request->post['openbay_ftp_rootpath'];
        } else {
            
$data['openbay_ftp_rootpath'] = $this->config->get('openbay_ftp_rootpath');
        }

        if (isset(
$this->request->post['openbay_ftp_pasv'])) {
            
$data['openbay_ftp_pasv'] = $this->request->post['openbay_ftp_pasv'];
        } else {
            
$data['openbay_ftp_pasv'] = $this->config->get('openbay_ftp_pasv');
        }

        if (isset(
$this->request->post['openbay_ftp_beta'])) {
            
$data['openbay_ftp_beta'] = $this->request->post['openbay_ftp_beta'];
        } else {
            
$data['openbay_ftp_beta'] = $this->config->get('openbay_ftp_beta');
        }

        
$data['openbay_ftp_server'] = $_SERVER["SERVER_ADDR"];
        if (isset(
$this->request->post['openbay_ftp_server'])) {
            
$data['openbay_ftp_server'] = $this->request->post['openbay_ftp_server'];
        } else {
            
$data['openbay_ftp_server'] = $this->config->get('openbay_ftp_server');
        }

        if (isset(
$this->request->post['openbay_admin_directory'])) {
            
$data['openbay_admin_directory'] = $this->request->post['openbay_admin_directory'];
        } else {
            if (!
$this->config->get('openbay_admin_directory')) {
                
$data['openbay_admin_directory'] = 'admin';
            } else {
                
$data['openbay_admin_directory'] = $this->config->get('openbay_admin_directory');
            }
        }

        if (isset(
$this->request->post['openbay_language'])) {
            
$data['openbay_language'] = $this->request->post['openbay_language'];
        } else {
            
$data['openbay_language'] = $this->config->get('openbay_language');
        }

        
$data['languages'] = array(
            
'en_GB' => 'English',
            
'de_DE' => 'German',
            
'es_ES' => 'Spanish',
            
'fr_FR' => 'French',
            
'it_IT' => 'Italian',
            
'nl_NL' => 'Dutch',
            
'zh_HK' => 'Simplified Chinese'
        
);

        
$data['text_version'] = $this->config->get('openbay_version');
        
$data['openbay_menu'] = $this->config->get('openbay_menu');

        
$data['action'] = $this->url->link('extension/openbay/manage''token=' $this->session->data['token'], 'SSL');
        
$data['cancel'] = $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL');

        
$data['token'] = $this->session->data['token'];

        
$data['header'] = $this->load->controller('common/header');
        
$data['column_left'] = $this->load->controller('common/column_left');
        
$data['footer'] = $this->load->controller('common/footer');

        
$this->response->setOutput($this->load->view('openbay/openbay_manage.tpl'$data));
    }

    public function 
updateTest() {
        
$this->load->model('openbay/openbay');

        
$json $this->model_openbay_openbay->updateTest();

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
update() {
        
$this->load->model('openbay/openbay');

        
$json $this->model_openbay_openbay->update();

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
updateV2() {
        
$this->load->model('openbay/openbay');
        
$this->load->language('extension/openbay');

        
// set base var
        
$web_root preg_replace('/system/$/'''DIR_SYSTEM);

        if (!isset(
$this->request->get['stage'])) {
            
$stage 'check_server';
        } else {
            
$stage $this->request->get['stage'];
        }

        if (!isset(
$this->request->get['beta']) || $this->request->get['beta'] == 0) {
            
$beta 0;
        } else {
            
$beta 1;
        }

        switch (
$stage) {
            case 
'check_server'// step 1
                
$response $this->model_openbay_openbay->updateV2Test();

                
sleep(1);
                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            case 
'check_version'// step 2
                
$response $this->model_openbay_openbay->updateV2CheckVersion($beta);

                
sleep(1);
                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            case 
'download'// step 3
                
$response $this->model_openbay_openbay->updateV2Download($beta);

                
sleep(1);
                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            case 
'extract'// step 4
                
$response $this->model_openbay_openbay->updateV2Extract();

                
sleep(1);
                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            case 
'remove'// step 5 - remove any files no longer needed
                
$response $this->model_openbay_openbay->updateV2Remove();

                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            case 
'run_patch'// step 6 - run any db updates or other patch files
                
$this->model_openbay_openbay->patch();

                
$this->load->model('openbay/ebay');
                
$this->model_openbay_ebay->patch();

                
$this->load->model('openbay/amazon');
                
$this->model_openbay_amazon->patch();

                
$this->load->model('openbay/amazonus');
                
$this->model_openbay_amazonus->patch();

                
$this->load->model('openbay/etsy');
                
$this->model_openbay_etsy->patch();

                
$response = array('error' => 0'response' => '''percent_complete' => 90'status_message' => 'Running patch files');

                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            case 
'update_version'// step 7 - update the version number
                
$this->load->model('setting/setting');

                
$response $this->model_openbay_openbay->updateV2UpdateVersion($beta);

                
$this->response->addHeader('Content-Type: application/json');
                
$this->response->setOutput(json_encode($response));
                break;
            default;
        }
    }

    public function 
patch() {
        
$this->load->model('openbay/openbay');
        
$this->load->model('openbay/ebay');
        
$this->load->model('openbay/amazon');
        
$this->load->model('openbay/amazonus');
        
$this->load->model('openbay/etsy');
        
$this->load->model('extension/extension');
        
$this->load->model('setting/setting');
        
$this->load->model('user/user_group');
        
$this->load->model('openbay/version');

        
$this->model_openbay_openbay->patch();
        
$this->model_openbay_ebay->patch();
        
$this->model_openbay_amazon->patch();
        
$this->model_openbay_amazonus->patch();
        
$this->model_openbay_etsy->patch();

        
$openbay $this->model_setting_setting->getSetting('openbay');
        
$openbay['openbay_version'] = (int)$this->model_openbay_version->version();
        
$openbay['openbay_menu'] = 1;
        
$this->model_setting_setting->editSetting('openbay'$openbay);

        
$installed_modules $this->model_extension_extension->getInstalled('module');

        if (!
in_array('openbay'$installed_modules)) {
            
$this->model_extension_extension->install('feed''openbay');
            
$this->model_user_user_group->addPermission($this->user->getGroupId(), 'access''feed/openbay');
            
$this->model_user_user_group->addPermission($this->user->getGroupId(), 'modify''feed/openbay');
        }

        
sleep(1);

        
$json = array('msg' => 'ok');

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
notifications() {
        
$this->load->model('openbay/openbay');

        
$json $this->model_openbay_openbay->getNotifications();

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
version() {
        
$this->load->model('openbay/openbay');

        
$json $this->model_openbay_openbay->version();

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
faq() {
        
$this->load->model('openbay/openbay');

        
$this->load->language('extension/openbay');

        
$data $this->model_openbay_openbay->faqGet($this->request->get['qry_route']);
        
$data['button_faq'] = $this->language->get('button_faq');
        
$data['button_close'] = $this->language->get('button_close');

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($data));
    }

    public function 
faqDismiss() {
        
$this->load->model('openbay/openbay');

        
$json $this->model_openbay_openbay->faqDismiss($this->request->get['qry_route']);

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
faqClear() {
        
$this->load->model('openbay/openbay');
        
$this->model_openbay_openbay->faqClear();

        
$json = array('msg' => 'ok');

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }

    public function 
getOrderInfo() {
        
$data = array();

        
$data array_merge($data$this->load->language('extension/openbay'));

        if (
$this->config->get('ebay_status') == 1) {
            if (
$this->openbay->ebay->isEbayOrder($this->request->get['order_id']) !== false) {
                if (
$this->config->get('ebay_status_shipped_id') == $this->request->get['status_id']) {
                    
$data['carriers'] = $this->openbay->ebay->getCarriers();
                    
$data['order_info'] = $this->openbay->ebay->getOrder($this->request->get['order_id']);
                    
$this->response->setOutput($this->load->view('openbay/ebay_ajax_shippinginfo.tpl'$data));
                }
            }
        }

        if (
$this->config->get('openbay_amazon_status') == 1) {
            
$data['order_info'] = $this->openbay->amazon->getOrder($this->request->get['order_id']);

            if (
$data['order_info']) {
                if (
$this->request->get['status_id'] == $this->config->get('openbay_amazon_order_status_shipped')) {
                    
$data['couriers'] = $this->openbay->amazon->getCarriers();
                    
$data['courier_default'] = $this->config->get('openbay_amazon_default_carrier');
                    
$this->response->setOutput($this->load->view('openbay/amazon_ajax_shippinginfo.tpl'$data));
                }
            }
        }

        if (
$this->config->get('openbay_amazonus_status') == 1) {
            
$data['order_info'] = $this->openbay->amazonus->getOrder($this->request->get['order_id']);

            if (
$data['order_info']) {
                if (
$this->request->get['status_id'] == $this->config->get('openbay_amazonus_order_status_shipped')) {
                    
$data['couriers'] = $this->openbay->amazonus->getCarriers();
                    
$data['courier_default'] = $this->config->get('openbay_amazon_default_carrier');
                    
$this->response->setOutput($this->load->view('openbay/amazonus_ajax_shippinginfo.tpl'$data));
                }
            }
        }

        if (
$this->config->get('etsy_status') == 1) {
            
$data['order_info'] = $this->openbay->etsy->orderFind($this->request->get['order_id']);

            if (
$data['order_info']) {
                if (
$this->request->get['status_id'] == $this->config->get('etsy_order_status_shipped')) {

                }
            }
        }
    }

    public function 
addOrderInfo() {
        if (
$this->config->get('ebay_status') == && $this->openbay->ebay->isEbayOrder($this->request->get['order_id']) !== false) {
            if (
$this->config->get('ebay_status_shipped_id') == $this->request->get['status_id']) {
                
$this->openbay->ebay->orderStatusListen($this->request->get['order_id'], $this->request->get['status_id'], array('tracking_no' => $this->request->post['tracking_no'], 'carrier_id' => $this->request->post['carrier_id']));
            }else{
                
$this->openbay->ebay->orderStatusListen($this->request->get['order_id'], $this->request->get['status_id']);
            }
        }

        if (
$this->config->get('openbay_amazon_status') == && $this->openbay->amazon->getOrder($this->request->get['order_id']) !== false) {
            if (
$this->config->get('openbay_amazon_order_status_shipped') == $this->request->get['status_id']) {
                if (!empty(
$this->request->post['courier_other'])) {
                    
$this->openbay->amazon->updateOrder($this->request->get['order_id'], 'shipped'$this->request->post['courier_other'], false$this->request->post['tracking_no']);
                } else {
                    
$this->openbay->amazon->updateOrder($this->request->get['order_id'], 'shipped'$this->request->post['courier_id'], true$this->request->post['tracking_no']);
                }
            }

            if (
$this->config->get('openbay_amazon_order_status_canceled') == $this->request->get['status_id']) {
                
$this->openbay->amazon->updateOrder($this->request->get['order_id'], 'canceled');
            }
        }

        if (
$this->config->get('openbay_amazonus_status') == && $this->openbay->amazonus->getOrder($this->request->get['order_id']) !== false) {
            if (
$this->config->get('openbay_amazonus_order_status_shipped') == $this->request->get['status_id']) {
                if (!empty(
$this->request->post['courier_other'])) {
                    
$this->openbay->amazonus->updateOrder($this->request->get['order_id'], 'shipped'$this->request->post['courier_other'], false$this->request->post['tracking_no']);
                } else {
                    
$this->openbay->amazonus->updateOrder($this->request->get['order_id'], 'shipped'$this->request->post['courier_id'], true$this->request->post['tracking_no']);
                }
            }
            if (
$this->config->get('openbay_amazonus_order_status_canceled') == $this->request->get['status_id']) {
                
$this->openbay->amazonus->updateOrder($this->request->get['order_id'], 'canceled');
            }
        }

        if (
$this->config->get('etsy_status') == 1) {
            
$linked_order $this->openbay->etsy->orderFind($this->request->get['order_id']);

            if (
$linked_order != false) {
                if (
$this->config->get('etsy_order_status_paid') == $this->request->get['status_id']) {
                    
$response $this->openbay->etsy->orderUpdatePaid($linked_order['receipt_id'], "true");
                }

                if (
$this->config->get('etsy_order_status_shipped') == $this->request->get['status_id']) {
                    
$response $this->openbay->etsy->orderUpdateShipped($linked_order['receipt_id'], "true");
                }
            }
        }
    }

    public function 
orderList() {
        
$this->load->language('sale/order');
        
$this->load->model('openbay/order');

        
$data $this->load->language('openbay/openbay_order');
        
$this->document->setTitle($this->language->get('heading_title'));

        if (isset(
$this->request->get['filter_order_id'])) {
            
$filter_order_id $this->request->get['filter_order_id'];
        } else {
            
$filter_order_id null;
        }

        if (isset(
$this->request->get['filter_customer'])) {
            
$filter_customer $this->request->get['filter_customer'];
        } else {
            
$filter_customer null;
        }

        if (isset(
$this->request->get['filter_order_status_id'])) {
            
$filter_order_status_id $this->request->get['filter_order_status_id'];
        } else {
            
$filter_order_status_id null;
        }

        if (isset(
$this->request->get['filter_date_added'])) {
            
$filter_date_added $this->request->get['filter_date_added'];
        } else {
            
$filter_date_added null;
        }

        if (isset(
$this->request->get['filter_channel'])) {
            
$filter_channel $this->request->get['filter_channel'];
        } else {
            
$filter_channel null;
        }

        if (isset(
$this->request->get['sort'])) {
            
$sort $this->request->get['sort'];
        } else {
            
$sort 'o.order_id';
        }

        if (isset(
$this->request->get['order'])) {
            
$order $this->request->get['order'];
        } else {
            
$order 'DESC';
        }

        if (isset(
$this->request->get['page'])) {
            
$page $this->request->get['page'];
        } else {
            
$page 1;
        }

        
$url '';

        if (isset(
$this->request->get['filter_order_id'])) {
            
$url .= '&filter_order_id=' $this->request->get['filter_order_id'];
        }

        if (isset(
$this->request->get['filter_customer'])) {
            
$url .= '&filter_customer=' $this->request->get['filter_customer'];
        }

        if (isset(
$this->request->get['filter_order_status_id'])) {
            
$url .= '&filter_order_status_id=' $this->request->get['filter_order_status_id'];
        }

        if (isset(
$this->request->get['filter_date_added'])) {
            
$url .= '&filter_date_added=' $this->request->get['filter_date_added'];
        }

        if (isset(
$this->request->get['filter_channel'])) {
            
$url .= '&filter_channel=' $this->request->get['filter_channel'];
        }

        if (isset(
$this->request->get['sort'])) {
            
$url .= '&sort=' $this->request->get['sort'];
        }

        if (isset(
$this->request->get['order'])) {
            
$url .= '&order=' $this->request->get['order'];
        }

        if (isset(
$this->request->get['page'])) {
            
$url .= '&page=' $this->request->get['page'];
        }

        
$data['breadcrumbs'] = array();

        
$data['breadcrumbs'][] = array(
            
'href'      => $this->url->link('common/dashboard''token=' $this->session->data['token'], 'SSL'),
            
'text'      => $this->language->get('text_home'),
        );

        
$data['breadcrumbs'][] = array(
            
'href' => $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'),
            
'text' => $this->language->get('text_openbay'),
        );

        
$data['breadcrumbs'][] = array(
            
'href' => $this->url->link('extension/openbay/manage''token=' $this->session->data['token'], 'SSL'),
            
'text' => $data['heading_title'],
        );

        
$data['orders'] = array();

        
$filter = array(
            
'filter_order_id'        => $filter_order_id,
            
'filter_customer'         => $filter_customer,
            
'filter_order_status_id' => $filter_order_status_id,
            
'filter_date_added'      => $filter_date_added,
            
'filter_channel'         => $filter_channel,
            
'sort'                   => $sort,
            
'order'                  => $order,
            
'start'                  => ($page 1) * $this->config->get('config_limit_admin'),
            
'limit'                  => $this->config->get('config_limit_admin')
        );

        
$order_total $this->model_openbay_order->getTotalOrders($filter);
        
$results $this->model_openbay_order->getOrders($filter);

        foreach (
$results as $result) {
            
$channel $this->language->get('text_' $result['channel']);

            
$data['orders'][] = array(
                
'order_id'      => $result['order_id'],
                
'customer'      => $result['customer'],
                
'status'        => $result['status'],
                
'date_added'    => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
                
'selected'      => isset($this->request->post['selected']) && in_array($result['order_id'], $this->request->post['selected']),
                
'view'          => $this->url->link('sale/order/info''token=' $this->session->data['token'] . '&order_id=' $result['order_id'] . $url'SSL'),
                
'channel'       => $channel,
            );
        }

        
$data['channels'] = array();

        
$data['channels'][] = array(
            
'module' => 'web',
            
'title' => $this->language->get('text_web'),
        );

        if (
$this->config->get('ebay_status')) {
            
$data['channels'][] = array(
                
'module' => 'ebay',
                
'title' => $this->language->get('text_ebay'),
            );
        }

        if (
$this->config->get('openbay_amazon_status')) {
            
$data['channels'][] = array(
                
'module' => 'amazon',
                
'title' => $this->language->get('text_amazon'),
            );
        }

        if (
$this->config->get('openbay_amazonus_status')) {
            
$data['channels'][] = array(
                
'module' => 'amazonus',
                
'title' => $this->language->get('text_amazonus'),
            );
        }

        if (
$this->config->get('etsy_status')) {
            
$data['channels'][] = array(
                
'module' => 'etsy',
                
'title' => $this->language->get('text_etsy'),
            );
        }

        
$data['heading_title'] = $this->language->get('heading_title');
        
$data['text_no_results'] = $this->language->get('text_no_results');
        
$data['text_missing'] = $this->language->get('text_missing');
        
$data['column_order_id'] = $this->language->get('column_order_id');
        
$data['column_customer'] = $this->language->get('column_customer');
        
$data['column_status'] = $this->language->get('column_status');
        
$data['column_date_added'] = $this->language->get('column_date_added');
        
$data['column_action'] = $this->language->get('column_action');
        
$data['button_filter'] = $this->language->get('button_filter');

        
$data['token'] = $this->session->data['token'];

        if (isset(
$this->session->data['error'])) {
            
$data['error_warning'] = $this->session->data['error'];
            unset(
$this->session->data['error']);
        } else {
            
$data['error_warning'] = '';
        }

        if (isset(
$this->session->data['success'])) {
            
$data['success'] = $this->session->data['success'];

            unset(
$this->session->data['success']);
        } else {
            
$data['success'] = '';
        }

        
$url '';

        if (isset(
$this->request->get['filter_order_id'])) {
            
$url .= '&filter_order_id=' $this->request->get['filter_order_id'];
        }

        if (isset(
$this->request->get['filter_customer'])) {
            
$url .= '&filter_customer=' $this->request->get['filter_customer'];
        }

        if (isset(
$this->request->get['filter_order_status_id'])) {
            
$url .= '&filter_order_status_id=' $this->request->get['filter_order_status_id'];
        }

        if (isset(
$this->request->get['filter_date_added'])) {
            
$url .= '&filter_date_added=' $this->request->get['filter_date_added'];
        }

        if (isset(
$this->request->get['filter_channel'])) {
            
$url .= '&filter_channel=' $this->request->get['filter_channel'];
        }

        if (
$order == 'ASC') {
            
$url .= '&order=DESC';
        } else {
            
$url .= '&order=ASC';
        }

        if (isset(
$this->request->get['page'])) {
            
$url .= '&page=' $this->request->get['page'];
        }

        
$data['sort_order'] = $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . '&sort=o.order_id' $url'SSL');
        
$data['sort_customer'] = $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . '&sort=customer' $url'SSL');
        
$data['sort_status'] = $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . '&sort=status' $url'SSL');
        
$data['sort_date_added'] = $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . '&sort=o.date_added' $url'SSL');
        
$data['sort_channel'] = $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . '&sort=channel' $url'SSL');
        
$data['link_update'] = $this->url->link('extension/openbay/orderListUpdate''token=' $this->session->data['token'] . $url'SSL');
        
$data['cancel'] = $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL');

        
$url '';

        if (isset(
$this->request->get['filter_order_id'])) {
            
$url .= '&filter_order_id=' $this->request->get['filter_order_id'];
        }

        if (isset(
$this->request->get['filter_customer'])) {
            
$url .= '&filter_customer=' $this->request->get['filter_customer'];
        }

        if (isset(
$this->request->get['filter_order_status_id'])) {
            
$url .= '&filter_order_status_id=' $this->request->get['filter_order_status_id'];
        }

        if (isset(
$this->request->get['filter_date_added'])) {
            
$url .= '&filter_date_added=' $this->request->get['filter_date_added'];
        }

        if (isset(
$this->request->get['filter_channel'])) {
            
$url .= '&filter_channel=' $this->request->get['filter_channel'];
        }

        if (isset(
$this->request->get['sort'])) {
            
$url .= '&sort=' $this->request->get['sort'];
        }

        if (isset(
$this->request->get['order'])) {
            
$url .= '&order=' $this->request->get['order'];
        }

        
$pagination = new Pagination();
        
$pagination->total $order_total;
        
$pagination->page $page;
        
$pagination->limit $this->config->get('config_limit_admin');
        
$pagination->text $this->language->get('text_pagination');
        
$pagination->url $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . $url '&page={page}''SSL');

        
$data['pagination'] = $pagination->render();

        
$data['results'] = sprintf($this->language->get('text_pagination'), ($order_total) ? (($page 1) * $this->config->get('config_limit_admin')) + 0, ((($page 1) * $this->config->get('config_limit_admin')) > ($order_total $this->config->get('config_limit_admin'))) ? $order_total : ((($page 1) * $this->config->get('config_limit_admin')) + $this->config->get('config_limit_admin')), $order_totalceil($order_total $this->config->get('config_limit_admin')));

        
$data['filter_order_id'] = $filter_order_id;
        
$data['filter_customer'] = $filter_customer;
        
$data['filter_order_status_id'] = $filter_order_status_id;
        
$data['filter_date_added'] = $filter_date_added;
        
$data['filter_channel'] = $filter_channel;

        
$this->load->model('localisation/order_status');

        
$data['order_statuses'] = $this->model_localisation_order_status->getOrderStatuses();

        
$data['sort'] = $sort;
        
$data['order'] = $order;

        
$data['header'] = $this->load->controller('common/header');
        
$data['column_left'] = $this->load->controller('common/column_left');
        
$data['footer'] = $this->load->controller('common/footer');

        
$this->response->setOutput($this->load->view('openbay/openbay_orderlist.tpl'$data));
    }

    public function 
orderListUpdate() {
        
$data $this->load->language('openbay/openbay_order');
        
$this->document->setTitle($this->language->get('heading_title'));

        if (!isset(
$this->request->post['selected']) || empty($this->request->post['selected'])) {
            
$this->session->data['error'] = $data['text_no_orders'];
            
$this->response->redirect($this->url->link('extension/openbay/orderList''token=' $this->session->data['token'], 'SSL'));
        } else {
            
$this->load->model('openbay/order');
            
$this->load->language('sale/order');

            
$data['column_order_id'] = $this->language->get('column_order_id');
            
$data['column_customer'] = $this->language->get('column_customer');
            
$data['column_status'] = $this->language->get('column_status');
            
$data['column_date_added'] = $this->language->get('column_date_added');
            
$data['heading_title'] = $this->language->get('heading_title');

            
$data['link_complete'] = $this->url->link('extension/openbay/orderListComplete''token=' $this->session->data['token'], 'SSL');

            
$data['market_options'] = array();

            if (
$this->config->get('ebay_status') == 1) {
                
$data['market_options']['ebay']['carriers'] = $this->openbay->ebay->getCarriers();
            }

            if (
$this->config->get('openbay_amazon_status') == 1) {
                
$data['market_options']['amazon']['carriers'] = $this->openbay->amazon->getCarriers();
                
$data['market_options']['amazon']['default_carrier'] = $this->config->get('openbay_amazon_default_carrier');
            }

            if (
$this->config->get('openbay_amazonus_status') == 1) {
                
$data['market_options']['amazonus']['carriers'] = $this->openbay->amazonus->getCarriers();
            }

            
$this->load->model('localisation/order_status');
            
$data['order_statuses'] = $this->model_localisation_order_status->getOrderStatuses();
            
$data['status_mapped'] = array();

            foreach(
$data['order_statuses'] as $status) {
                
$data['status_mapped'][$status['order_status_id']] = $status['name'];
            }

            
$orders = array();

            foreach(
$this->request->post['selected'] as $order_id) {
                
$order $this->model_openbay_order->getOrder($order_id);

                if (
$order['order_status_id'] != $this->request->post['change_order_status_id']) {
                    
$order['channel'] = $this->language->get('text_' $order['channel']);
                    
$orders[] = $order;
                }
            }

            if (empty(
$orders)) {
                
$this->session->data['error'] = $data['text_no_orders'];
                
$this->response->redirect($this->url->link('extension/openbay/orderList''token=' $this->session->data['token'], 'SSL'));
            }else{
                
$data['orders'] = $orders;
            }

            
$data['breadcrumbs'] = array();

            
$data['breadcrumbs'][] = array(
                
'href'      => $this->url->link('common/dashboard''token=' $this->session->data['token'], 'SSL'),
                
'text'      => $this->language->get('text_home'),
            );

            
$data['breadcrumbs'][] = array(
                
'href' => $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'),
                
'text' => $this->language->get('text_openbay'),
            );

            
$data['breadcrumbs'][] = array(
                
'href' => $this->url->link('extension/openbay/manage''token=' $this->session->data['token'], 'SSL'),
                
'text' => $data['heading_title'],
            );

            
$data['change_order_status_id'] = $this->request->post['change_order_status_id'];
            
$data['ebay_status_shipped_id'] = $this->config->get('ebay_status_shipped_id');
            
$data['openbay_amazon_order_status_shipped'] = $this->config->get('openbay_amazon_order_status_shipped');
            
$data['openbay_amazonus_order_status_shipped'] = $this->config->get('openbay_amazonus_order_status_shipped');

            
$data['header'] = $this->load->controller('common/header');
            
$data['column_left'] = $this->load->controller('common/column_left');
            
$data['footer'] = $this->load->controller('common/footer');

            
$url '';

            if (isset(
$this->request->get['filter_order_id'])) {
                
$url .= '&filter_order_id=' $this->request->get['filter_order_id'];
            }

            if (isset(
$this->request->get['filter_customer'])) {
                
$url .= '&filter_customer=' urlencode(html_entity_decode($this->request->get['filter_customer'], ENT_QUOTES'UTF-8'));
            }

            if (isset(
$this->request->get['filter_order_status_id'])) {
                
$url .= '&filter_order_status_id=' $this->request->get['filter_order_status_id'];
            }

            if (isset(
$this->request->get['filter_channel'])) {
                
$url .= '&filter_channel=' $this->request->get['filter_channel'];
            }

            if (isset(
$this->request->get['filter_date_added'])) {
                
$url .= '&filter_date_added=' $this->request->get['filter_date_added'];
            }

            if (isset(
$this->request->get['sort'])) {
                
$url .= '&sort=' $this->request->get['sort'];
            }

            if (isset(
$this->request->get['order'])) {
                
$url .= '&order=' $this->request->get['order'];
            }

            if (isset(
$this->request->get['page'])) {
                
$url .= '&page=' $this->request->get['page'];
            }

            
$data['cancel'] = $this->url->link('extension/openbay/orderList''token=' $this->session->data['token'] . $url'SSL');
            
$data['button_cancel'] = $this->language->get('button_cancel');

            
$this->response->setOutput($this->load->view('openbay/openbay_orderlist_confirm.tpl'$data));
        }
    }

    public function 
orderListComplete() {
        
$this->load->model('sale/order');
        
$this->load->model('openbay/openbay');
        
$this->load->model('localisation/order_status');

        
$data $this->load->language('openbay/openbay_order');

        
$order_statuses $this->model_localisation_order_status->getOrderStatuses();
        
$status_mapped = array();

        foreach(
$order_statuses as $status) {
            
$status_mapped[$status['order_status_id']] = $status['name'];
        }

        
//Amazon EU
        
if ($this->config->get('openbay_amazon_status') == 1) {
            
$orders = array();

            foreach (
$this->request->post['order_id'] as $order_id) {
                if (
$this->request->post['channel'][$order_id] == 'Amazon EU') {

                    if (
$this->config->get('openbay_amazon_order_status_shipped') == $this->request->post['order_status_id']) {
                        
$carrier '';

                        if (isset(
$this->request->post['carrier_other'][$order_id]) && !empty($this->request->post['carrier_other'][$order_id])) {
                            
$carrier_from_list false;
                            
$carrier $this->request->post['carrier_other'][$order_id];
                        } else {
                            
$carrier_from_list true;
                            
$carrier $this->request->post['carrier'][$order_id];
                        }

                        
$orders[] = array(
                            
'order_id' => $order_id,
                            
'status' => 'shipped',
                            
'carrier' => $carrier,
                            
'carrier_from_list' => $carrier_from_list,
                            
'tracking' => $this->request->post['tracking'][$order_id],
                        );
                    }

                    if (
$this->config->get('openbay_amazon_order_status_canceled') == $this->request->post['order_status_id']) {
                        
$orders[] = array(
                            
'order_id' => $order_id,
                            
'status' => 'canceled',
                        );
                    }
                }
            }

            if (
$orders) {
                
$this->openbay->amazon->bulkUpdateOrders($orders);
            }
        }

        
//Amazon US
        
if ($this->config->get('openbay_amazonus_status') == 1) {
            
$orders = array();

            foreach (
$this->request->post['order_id'] as $order_id) {
                if (
$this->request->post['channel'][$order_id] == 'Amazon US') {

                    if (
$this->config->get('openbay_amazonus_order_status_shipped') == $this->request->post['order_status_id']) {
                        
$carrier '';

                        if (isset(
$this->request->post['carrier_other'][$order_id]) && !empty($this->request->post['carrier_other'][$order_id])) {
                            
$carrier_from_list false;
                            
$carrier $this->request->post['carrier_other'][$order_id];
                        } else {
                            
$carrier_from_list true;
                            
$carrier $this->request->post['carrier'][$order_id];
                        }

                        
$orders[] = array(
                            
'order_id' => $order_id,
                            
'status' => 'shipped',
                            
'carrier' => $carrier,
                            
'carrier_from_list' => $carrier_from_list,
                            
'tracking' => $this->request->post['tracking'][$order_id],
                        );
                    }

                    if (
$this->config->get('openbay_amazonus_order_status_canceled') == $this->request->post['order_status_id']) {
                        
$orders[] = array(
                            
'order_id' => $order_id,
                            
'status' => 'canceled',
                        );
                    }
                }
            }

            if (
$orders) {
                
$this->openbay->amazonus->bulkUpdateOrders($orders);
            }
        }

        
$i 0;
        foreach(
$this->request->post['order_id'] as $order_id) {
            if (
$this->config->get('ebay_status') == && $this->request->post['channel'][$order_id] == 'eBay') {
                if (
$this->config->get('ebay_status_shipped_id') == $this->request->post['order_status_id']) {
                    
$this->openbay->ebay->orderStatusListen($order_id$this->request->post['order_status_id'], array('tracking_no' => $this->request->post['tracking'][$order_id], 'carrier_id' => $this->request->post['carrier'][$order_id]));
                }else{
                    
$this->openbay->ebay->orderStatusListen($this->request->get['order_id'], $this->request->get['status_id']);
                }
            }

            if (
$this->config->get('etsy_status') == && $this->request->post['channel'][$order_id] == 'Etsy') {
                
$linked_order $this->openbay->etsy->orderFind($order_id);

                if (
$linked_order != false) {
                    if (
$this->config->get('etsy_order_status_paid') == $this->request->post['order_status_id']) {
                        
$response $this->openbay->etsy->orderUpdatePaid($linked_order['receipt_id'], "true");
                    }

                    if (
$this->config->get('etsy_order_status_shipped') == $this->request->post['order_status_id']) {
                        
$response $this->openbay->etsy->orderUpdateShipped($linked_order['receipt_id'], "true");
                    }
                }
            }

            
$data = array(
                
'append' => 0,
                
'notify' => $this->request->post['notify'][$order_id],
                
'order_status_id' => $this->request->post['order_status_id'],
                
'comment' => $this->request->post['comments'][$order_id],
            );

            
$this->model_openbay_openbay->addOrderHistory($order_id$data);
            
$i++;
        }

        
$this->session->data['success'] = sprintf($this->language->get('text_confirmed'), $i$status_mapped[$this->request->post['order_status_id']]);

        
$this->response->redirect($this->url->link('extension/openbay/orderList''token=' $this->session->data['token'], 'SSL'));
    }

    public function 
items() {
        
$this->document->addScript('view/javascript/openbay/js/openbay.js');
        
$this->document->addScript('view/javascript/openbay/js/faq.js');

        
$data = array();

        
$data array_merge($data$this->load->language('catalog/product'));
        
$data array_merge($data$this->load->language('openbay/openbay_itemlist'));

        
$this->document->setTitle($this->language->get('heading_title'));

        
$this->load->model('catalog/product');
        
$this->load->model('catalog/category');
        
$this->load->model('catalog/manufacturer');
        
$this->load->model('openbay/openbay');
        
$this->load->model('tool/image');

        if (
$this->openbay->addonLoad('openstock')) {
            
$this->load->model('module/openstock');
            
$openstock_installed true;
        } else {
            
$openstock_installed false;
        }

        
$data['category_list'] = $this->model_catalog_category->getCategories(array());
        
$data['manufacturer_list'] = $this->model_catalog_manufacturer->getManufacturers(array());

        if (isset(
$this->request->get['filter_name'])) {
            
$filter_name $this->request->get['filter_name'];
        } else {
            
$filter_name null;
        }

        if (isset(
$this->request->get['filter_model'])) {
            
$filter_model $this->request->get['filter_model'];
        } else {
            
$filter_model null;
        }

        if (isset(
$this->request->get['filter_price'])) {
            
$filter_price $this->request->get['filter_price'];
        } else {
            
$filter_price null;
        }

        if (isset(
$this->request->get['filter_price_to'])) {
            
$filter_price_to $this->request->get['filter_price_to'];
        } else {
            
$filter_price_to null;
        }

        if (isset(
$this->request->get['filter_quantity'])) {
            
$filter_quantity $this->request->get['filter_quantity'];
        } else {
            
$filter_quantity null;
        }

        if (isset(
$this->request->get['filter_quantity_to'])) {
            
$filter_quantity_to $this->request->get['filter_quantity_to'];
        } else {
            
$filter_quantity_to null;
        }

        if (isset(
$this->request->get['filter_status'])) {
            
$filter_status $this->request->get['filter_status'];
        } else {
            
$filter_status null;
        }

        if (isset(
$this->request->get['filter_sku'])) {
            
$filter_sku $this->request->get['filter_sku'];
        } else {
            
$filter_sku null;
        }

        if (isset(
$this->request->get['filter_desc'])) {
            
$filter_desc $this->request->get['filter_desc'];
        } else {
            
$filter_desc null;
        }

        if (isset(
$this->request->get['filter_category'])) {
            
$filter_category $this->request->get['filter_category'];
        } else {
            
$filter_category null;
        }

        if (isset(
$this->request->get['filter_manufacturer'])) {
            
$filter_manufacturer $this->request->get['filter_manufacturer'];
        } else {
            
$filter_manufacturer null;
        }

        if (isset(
$this->request->get['filter_marketplace'])) {
            
$filter_marketplace $this->request->get['filter_marketplace'];
        } else {
            
$filter_marketplace null;
        }

        if (isset(
$this->request->get['sort'])) {
            
$sort $this->request->get['sort'];
        } else {
            
$sort 'pd.name';
        }

        if (isset(
$this->request->get['order'])) {
            
$order $this->request->get['order'];
        } else {
            
$order 'ASC';
        }

        if (isset(
$this->request->get['page'])) {
            
$page $this->request->get['page'];
        } else {
            
$page 1;
        }

        
$url '';

        if (isset(
$this->request->get['filter_name'])) {
            
$url .= '&filter_name=' urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES'UTF-8'));
        }

        if (isset(
$this->request->get['filter_model'])) {
            
$url .= '&filter_model=' urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES'UTF-8'));
        }

        if (isset(
$this->request->get['filter_price'])) {
            
$url .= '&filter_price=' $this->request->get['filter_price'];
        }

        if (isset(
$this->request->get['filter_price_to'])) {
            
$url .= '&filter_price_to=' $this->request->get['filter_price_to'];
        }

        if (isset(
$this->request->get['filter_quantity'])) {
            
$url .= '&filter_quantity=' $this->request->get['filter_quantity'];
        }

        if (isset(
$this->request->get['filter_quantity_to'])) {
            
$url .= '&filter_quantity_to=' $this->request->get['filter_quantity_to'];
        }

        if (isset(
$this->request->get['filter_status'])) {
            
$url .= '&filter_status=' $this->request->get['filter_status'];
        }

        if (isset(
$this->request->get['filter_sku'])) {
            
$url .= '&filter_sku=' $this->request->get['filter_sku'];
        }

        if (isset(
$this->request->get['filter_desc'])) {
            
$url .= '&filter_desc=' $this->request->get['filter_desc'];
        }

        if (isset(
$this->request->get['filter_category'])) {
            
$url .= '&filter_category=' $this->request->get['filter_category'];
        }

        if (isset(
$this->request->get['filter_manufacturer'])) {
            
$url .= '&filter_manufacturer=' $this->request->get['filter_manufacturer'];
        }

        if (isset(
$this->request->get['filter_marketplace'])) {
            
$url .= '&filter_marketplace=' $this->request->get['filter_marketplace'];
        }

        if (isset(
$this->request->get['sort'])) {
            
$url .= '&sort=' $this->request->get['sort'];
        }

        if (isset(
$this->request->get['order'])) {
            
$url .= '&order=' $this->request->get['order'];
        }

        if (isset(
$this->request->get['page'])) {
            
$url .= '&page=' $this->request->get['page'];
        }

        
$data['breadcrumbs'] = array();

        
$data['breadcrumbs'][] = array(
            
'text'      => $this->language->get('text_home'),
            
'href'      => $this->url->link('common/dashboard''token=' $this->session->data['token'], 'SSL'),
        );

        
$data['breadcrumbs'][] = array(
            
'text'         => $this->language->get('text_openbay'),
            
'href'         => $this->url->link('extension/openbay''token=' $this->session->data['token'], 'SSL'),
        );

        
$data['breadcrumbs'][] = array(
            
'text'      => $this->language->get('heading_title'),
            
'href'      => $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . $url'SSL'),
        );

        if (
$this->config->get('openbay_amazon_status')) {
            
$data['link_amazon_eu_bulk'] = $this->url->link('openbay/amazon/bulkListProducts''token=' $this->session->data['token'] . $url'SSL');
        } else {
            
$data['link_amazon_eu_bulk'] = '';
        }

        if (
$this->config->get('openbay_amazonus_status')) {
            
$data['link_amazon_us_bulk'] = $this->url->link('openbay/amazonus/bulkListProducts''token=' $this->session->data['token'] . $url'SSL');
        } else {
            
$data['link_amazon_us_bulk'] = '';
        }

        if (
$this->config->get('ebay_status') == '1') {
            
$data['link_ebay_bulk'] = $this->url->link('openbay/openbay/createBulk''token=' $this->session->data['token'], 'SSL');
        } else {
            
$data['link_ebay_bulk'] = '';
        }

        
$data['products'] = array();

        
$filter_market_id '';
        
$filter_market_name '';

        
$ebay_status = array(
            
=> 'ebay_inactive',
            
=> 'ebay_active',
        );

        if (
in_array($filter_marketplace$ebay_status)) {
            
$filter_market_name 'ebay';
            
$filter_market_id array_search($filter_marketplace$ebay_status);
        }

        
$amazon_status = array(
            
=> 'amazon_unlisted',
            
=> 'amazon_saved',
            
=> 'amazon_uploaded',
            
=> 'amazon_ok',
            
=> 'amazon_error',
            
=> 'amazon_linked',
            
=> 'amazon_not_linked',
        );

        if (
in_array($filter_marketplace$amazon_status)) {
            
$filter_market_name 'amazon';
            
$filter_market_id array_search($filter_marketplace$amazon_status);
        }

        
$amazonus_status = array(
            
=> 'amazonus_unlisted',
            
=> 'amazonus_saved',
            
=> 'amazonus_uploaded',
            
=> 'amazonus_ok',
            
=> 'amazonus_error',
            
=> 'amazonus_linked',
            
=> 'amazonus_not_linked',
        );

        if (
in_array($filter_marketplace$amazonus_status)) {
            
$filter_market_name 'amazonus';
            
$filter_market_id array_search($filter_marketplace$amazonus_status);
        }

        
$filter = array(
            
'filter_name'            => $filter_name,
            
'filter_model'            => $filter_model,
            
'filter_price'            => $filter_price,
            
'filter_price_to'        => $filter_price_to,
            
'filter_quantity'       => $filter_quantity,
            
'filter_quantity_to'    => $filter_quantity_to,
            
'filter_status'         => $filter_status,
            
'filter_sku'            => $filter_sku,
            
'filter_desc'           => $filter_desc,
            
'filter_category'       => $filter_category,
            
'filter_manufacturer'   => $filter_manufacturer,
            
'filter_market_name'    => $filter_market_name,
            
'filter_market_id'      => $filter_market_id,
            
'sort'                  => $sort,
            
'order'                 => $order,
            
'start'                 => ($page 1) * $this->config->get('config_limit_admin'),
            
'limit'                 => $this->config->get('config_limit_admin')
        );

        if (
$this->config->get('ebay_status') != '1' && $filter['filter_market_name'] == 'ebay') {
            
$this->response->redirect($this->url->link('extension/openbay/items''token=' $this->session->data['token'], 'SSL'));
            return;
        }

        if (
$this->config->get('openbay_amazon_status') != '1' && $filter['filter_market_name'] == 'amazon') {
            
$this->response->redirect($this->url->link('extension/openbay/items''token=' $this->session->data['token'], 'SSL'));
            return;
        }

        if (
$this->config->get('openbay_amazonus_status') != '1' && $filter['filter_market_name'] == 'amazonus') {
            
$this->response->redirect($this->url->link('extension/openbay/items''token=' $this->session->data['token'], 'SSL'));
            return;
        }

        if (
$this->config->get('etsy_status') != '1' && $filter['filter_market_name'] == 'etsy') {
            
$this->response->redirect($this->url->link('extension/openbay/items''token=' $this->session->data['token'], 'SSL'));
            return;
        }

        
$data['marketplace_statuses'] = array(
            
'ebay' => $this->config->get('ebay_status'),
            
'amazon' => $this->config->get('openbay_amazon_status'),
            
'amazonus' => $this->config->get('openbay_amazonus_status'),
            
'etsy' => $this->config->get('etsy_status'),
        );

        
$product_total $this->model_openbay_openbay->getTotalProducts($filter);

        
$results $this->model_openbay_openbay->getProducts($filter);

        foreach (
$results as $result) {
            
$edit $this->url->link('catalog/product/edit''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL');

            if (
$result['image'] && file_exists(DIR_IMAGE $result['image'])) {
                
$image $this->model_tool_image->resize($result['image'], 4040);
            } else {
                
$image $this->model_tool_image->resize('no_image.png'4040);
            }

            
$special false;

            
$product_specials $this->model_catalog_product->getProductSpecials($result['product_id']);

            foreach (
$product_specials  as $product_special) {
                if ((
$product_special['date_start'] == '0000-00-00' || $product_special['date_start'] < date('Y-m-d')) && ($product_special['date_end'] == '0000-00-00' || $product_special['date_end'] > date('Y-m-d'))) {
                    
$special $product_special['price'];

                    break;
                }
            }

            
/**
             * Button status key:
             * 0 = Inactive / no link to market
             * 1 = Active
             * 2 = Error
             * 3 = Pending
             */

            
$markets = array();

            if (
$this->config->get('ebay_status') == '1') {
                
$this->load->model('openbay/ebay');

                
$active_list $this->model_openbay_ebay->getLiveListingArray();

                if (!
array_key_exists($result['product_id'], $active_list)) {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_ebay'),
                        
'text'      => $this->language->get('button_add'),
                        
'href'      => $this->url->link('openbay/ebay/create''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 0
                    
);
                } else {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_ebay'),
                        
'text'      => $this->language->get('button_edit'),
                        
'href'      => $this->url->link('openbay/ebay/edit''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 1
                    
);
                }
            }

            if (
$this->config->get('openbay_amazon_status') == '1') {
                
$this->load->model('openbay/amazon');
                
$amazon_status $this->model_openbay_amazon->getProductStatus($result['product_id']);

                if (
$amazon_status == 'processing') {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazon'),
                        
'text'      => $this->language->get('text_processing'),
                        
'href'      => '',
                        
'status'    => 3
                    
);
                } else if (
$amazon_status == 'linked' || $amazon_status == 'ok' || $amazon_status == 'saved') {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazon'),
                        
'text'      => $this->language->get('button_edit'),
                        
'href'      => $this->url->link('openbay/amazon_listing/edit''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 1
                    
);
                } else if (
$amazon_status == 'error_quick' || $amazon_status == 'error_advanced' || $amazon_status == 'error_few') {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazon'),
                        
'text'      => $this->language->get('button_error_fix'),
                        
'href'      => $this->url->link('openbay/amazon_listing/create''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 2
                    
);
                } else {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazon'),
                        
'text'      => $this->language->get('button_add'),
                        
'href'      => $this->url->link('openbay/amazon_listing/create''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 0
                    
);
                }
            }

            if (
$this->config->get('openbay_amazonus_status') == '1') {
                
$this->load->model('openbay/amazonus');
                
$amazonus_status $this->model_openbay_amazonus->getProductStatus($result['product_id']);

                if (
$amazonus_status == 'processing') {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazonus'),
                        
'text'      => $this->language->get('text_processing'),
                        
'href'      => '',
                        
'status'    => 3
                    
);
                } else if (
$amazonus_status == 'linked' || $amazonus_status == 'ok' || $amazonus_status == 'saved') {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazonus'),
                        
'text'      => $this->language->get('button_edit'),
                        
'href'      => $this->url->link('openbay/amazonus_listing/edit''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 1
                    
);
                } else if (
$amazonus_status == 'error_quick' || $amazonus_status == 'error_advanced' || $amazonus_status == 'error_few') {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazonus'),
                        
'text'      => $this->language->get('button_error_fix'),
                        
'href'      => $this->url->link('openbay/amazonus_listing/create''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 2
                    
);
                } else {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_amazonus'),
                        
'text'      => $this->language->get('button_add'),
                        
'href'      => $this->url->link('openbay/amazonus_listing/create''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 0
                    
);
                }
            }

            if (
$this->config->get('etsy_status') == '1') {
                
$this->load->model('openbay/etsy_product');

                
$status $this->model_openbay_etsy_product->getStatus($result['product_id']);

                if (
$status == 0) {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_etsy'),
                        
'text'      => $this->language->get('button_add'),
                        
'href'      => $this->url->link('openbay/etsy_product/create''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 0
                    
);
                } else {
                    
$markets[] = array(
                        
'name'      => $this->language->get('text_etsy'),
                        
'text'      => $this->language->get('button_edit'),
                        
'href'      => $this->url->link('openbay/etsy_product/edit''token=' $this->session->data['token'] . '&product_id=' $result['product_id'] . $url'SSL'),
                        
'status'    => 1
                    
);
                }
            }

            if (!isset(
$result['has_option'])) {
                
$result['has_option'] = 0;
            }

            
$data['products'][] = array(
                
'markets'   => $markets,
                
'product_id' => $result['product_id'],
                
'name'       => $result['name'],
                
'model'      => $result['model'],
                
'price'      => $result['price'],
                
'special'    => $special,
                
'image'      => $image,
                
'quantity'   => $result['quantity'],
                
'status'     => ($result['status'] ? $this->language->get('text_enabled') : $this->language->get('text_disabled')),
                
'selected'   => isset($this->request->post['selected']) && in_array($result['product_id'], $this->request->post['selected']),
                
'edit'       => $edit,
                
'has_option' => $openstock_installed $result['has_option'] : 0,
                
'vCount'     => $openstock_installed $this->model_module_openstock->countVariation($result['product_id']) : '',
                
'vsCount'    => $openstock_installed $this->model_module_openstock->countVariationStock($result['product_id']) : '',
            );
        }

        
$data['token'] = $this->session->data['token'];

        if (isset(
$this->error['warning'])) {
            
$data['error_warning'] = $this->error['warning'];
        } else {
            if (isset(
$this->session->data['warning'])) {
                
$data['error_warning'] = $this->session->data['warning'];
                unset(
$this->session->data['warning']);
            } else {
                
$data['error_warning'] = '';
            }
        }

        if (isset(
$this->session->data['success'])) {
            
$data['success'] = $this->session->data['success'];

            unset(
$this->session->data['success']);
        } else {
            
$data['success'] = '';
        }

        
$url '';

        if (isset(
$this->request->get['filter_name'])) {
            
$url .= '&filter_name=' urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES'UTF-8'));
        }

        if (isset(
$this->request->get['filter_model'])) {
            
$url .= '&filter_model=' urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES'UTF-8'));
        }

        if (isset(
$this->request->get['filter_price'])) {
            
$url .= '&filter_price=' $this->request->get['filter_price'];
        }

        if (isset(
$this->request->get['filter_price_to'])) {
            
$url .= '&filter_price_to=' $this->request->get['filter_price_to'];
        }

        if (isset(
$this->request->get['filter_quantity'])) {
            
$url .= '&filter_quantity=' $this->request->get['filter_quantity'];
        }

        if (isset(
$this->request->get['filter_quantity_to'])) {
            
$url .= '&filter_quantity_to=' $this->request->get['filter_quantity_to'];
        }

        if (isset(
$this->request->get['filter_status'])) {
            
$url .= '&filter_status=' $this->request->get['filter_status'];
        }

        if (isset(
$this->request->get['filter_sku'])) {
            
$url .= '&filter_sku=' $this->request->get['filter_sku'];
        }

        if (isset(
$this->request->get['filter_desc'])) {
            
$url .= '&filter_desc=' $this->request->get['filter_desc'];
        }

        if (isset(
$this->request->get['filter_category'])) {
            
$url .= '&filter_category=' $this->request->get['filter_category'];
        }

        if (isset(
$this->request->get['filter_manufacturer'])) {
            
$url .= '&filter_manufacturer=' $this->request->get['filter_manufacturer'];
        }

        if (isset(
$this->request->get['filter_marketplace'])) {
            
$url .= '&filter_marketplace=' $this->request->get['filter_marketplace'];
        }

        if (
$order == 'ASC') {
            
$url .= '&order=DESC';
        } else {
            
$url .= '&order=ASC';
        }

        if (isset(
$this->request->get['page'])) {
            
$url .= '&page=' $this->request->get['page'];
        }

        
$data['sort_name'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . '&sort=pd.name' $url'SSL');
        
$data['sort_model'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . '&sort=p.model' $url'SSL');
        
$data['sort_price'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . '&sort=p.price' $url'SSL');
        
$data['sort_quantity'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . '&sort=p.quantity' $url'SSL');
        
$data['sort_status'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . '&sort=p.status' $url'SSL');
        
$data['sort_order'] = $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . '&sort=p.sort_order' $url'SSL');

        
$url '';

        if (isset(
$this->request->get['filter_name'])) {
            
$url .= '&filter_name=' urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES'UTF-8'));
        }

        if (isset(
$this->request->get['filter_model'])) {
            
$url .= '&filter_model=' urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES'UTF-8'));
        }

        if (isset(
$this->request->get['filter_price'])) {
            
$url .= '&filter_price=' $this->request->get['filter_price'];
        }

        if (isset(
$this->request->get['filter_price_to'])) {
            
$url .= '&filter_price_to=' $this->request->get['filter_price_to'];
        }

        if (isset(
$this->request->get['filter_quantity'])) {
            
$url .= '&filter_quantity=' $this->request->get['filter_quantity'];
        }

        if (isset(
$this->request->get['filter_quantity_to'])) {
            
$url .= '&filter_quantity_to=' $this->request->get['filter_quantity_to'];
        }

        if (isset(
$this->request->get['filter_status'])) {
            
$url .= '&filter_status=' $this->request->get['filter_status'];
        }

        if (isset(
$this->request->get['filter_sku'])) {
            
$url .= '&filter_sku=' $this->request->get['filter_sku'];
        }

        if (isset(
$this->request->get['filter_desc'])) {
            
$url .= '&filter_desc=' $this->request->get['filter_desc'];
        }

        if (isset(
$this->request->get['filter_category'])) {
            
$url .= '&filter_category=' $this->request->get['filter_category'];
        }

        if (isset(
$this->request->get['filter_manufacturer'])) {
            
$url .= '&filter_manufacturer=' $this->request->get['filter_manufacturer'];
        }

        if (isset(
$this->request->get['filter_marketplace'])) {
            
$url .= '&filter_marketplace=' $this->request->get['filter_marketplace'];
        }

        if (isset(
$this->request->get['sort'])) {
            
$url .= '&sort=' $this->request->get['sort'];
        }

        if (isset(
$this->request->get['order'])) {
            
$url .= '&order=' $this->request->get['order'];
        }

        
$pagination = new Pagination();
        
$pagination->total $product_total;
        
$pagination->page $page;
        
$pagination->limit $this->config->get('config_limit_admin');
        
$pagination->text $this->language->get('text_pagination');
        
$pagination->url $this->url->link('extension/openbay/items''token=' $this->session->data['token'] . $url '&page={page}''SSL');

        
$data['pagination'] = $pagination->render();

        
$data['results'] = sprintf($this->language->get('text_pagination'), ($product_total) ? (($page 1) * $this->config->get('config_limit_admin')) + 0, ((($page 1) * $this->config->get('config_limit_admin')) > ($product_total $this->config->get('config_limit_admin'))) ? $product_total : ((($page 1) * $this->config->get('config_limit_admin')) + $this->config->get('config_limit_admin')), $product_totalceil($product_total $this->config->get('config_limit_admin')));

        
$data['filter_name'] = $filter_name;
        
$data['filter_model'] = $filter_model;
        
$data['filter_price'] = $filter_price;
        
$data['filter_price_to'] = $filter_price_to;
        
$data['filter_quantity'] = $filter_quantity;
        
$data['filter_quantity_to'] = $filter_quantity_to;
        
$data['filter_status'] = $filter_status;
        
$data['filter_sku'] = $filter_sku;
        
$data['filter_desc'] = $filter_desc;
        
$data['filter_category'] = $filter_category;
        
$data['filter_manufacturer'] = $filter_manufacturer;
        
$data['filter_marketplace'] = $filter_marketplace;

        
$data['sort'] = $sort;
        
$data['order'] = $order;

        
$data['ebay_status'] = $this->config->get('ebay_status');
        
$data['token'] = $this->request->get['token'];

        
$data['header'] = $this->load->controller('common/header');
        
$data['column_left'] = $this->load->controller('common/column_left');
        
$data['footer'] = $this->load->controller('common/footer');

        
$this->response->setOutput($this->load->view('openbay/openbay_itemlist.tpl'$data));
    }

    public function 
itemlist() {
        
$this->response->redirect($this->url->link('extension/openbay/items''token=' $this->session->data['token'], 'SSL'));
    }

    public function 
eventDeleteProduct($product_id) {
        foreach (
$this->openbay->installed_markets as $market) {
            if (
$market == 'amazon') {
                
$status $this->config->get('openbay_amazon_status');
            } elseif (
$market == 'amazonus') {
                
$status $this->config->get('openbay_amazon_status');
            } else {
                
$status $this->config->get($market '_status');
            }

            if (
$status == 1) {
                
$this->openbay->{$market}->deleteProduct($product_id);
            }
        }
    }

    public function 
eventEditProduct() {
        foreach (
$this->openbay->installed_markets as $market) {
            if (
$market == 'amazon') {
                
$status $this->config->get('openbay_amazon_status');
            } elseif (
$market == 'amazonus') {
                
$status $this->config->get('openbay_amazon_status');
            } else {
                
$status $this->config->get($market '_status');
            }

            if (
$status == 1) {
                
$this->openbay->{$market}->productUpdateListen($this->request->get['product_id'], $this->request->post);
            }
        }
    }

    public function 
purge() {
        
/**
         * This is a function that is very dangerous
         * Only developers should use this if you need to!!
         * You need this code: **135** (includes stars)
         *
         * ACTIONS HERE CANNOT BE UNDONE WITHOUT A BACKUP
         *
         * !! IMPORTANT !!
         * This section will by default comment out the database delete actions
         * If you want to use them, uncomment.
         * When you are finished, ensure you comment them back out!
         */

        
$this->log->write('User is trying to wipe system data');

        if (
$this->request->post['pass'] != '**135**') {
            
$this->log->write('User failed password validation');
            
$json = array('msg' => 'Password wrong, check the source code for the password! This is so you know what this feature does.');
        } else {
            
/**
            $this->log->write('User passed validation');
            $this->db->query("TRUNCATE `" . DB_PREFIX . "order`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "order_history`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "order_option`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "order_product`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "order_total`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "customer`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "customer_activity`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "customer_ban_ip`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "customer_transaction`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "address`");

            $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_order`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_order_lock`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_transaction`");

            if ($this->config->get('ebay_status') == 1) {
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_category`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_category_history`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_image_import`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_listing`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_listing_pending`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_stock_reserve`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_payment_method`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_profile`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_setting_option`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_shipping`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_shipping_location`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_shipping_location_exclude`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_template`");
            }

            if ($this->config->get('etsy_status') == 1) {
                $this->db->query("TRUNCATE `" . DB_PREFIX . "etsy_listing`");
                $this->db->query("TRUNCATE `" . DB_PREFIX . "etsy_setting_option`");
            }

            $this->db->query("TRUNCATE `" . DB_PREFIX . "etsy_order`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "etsy_order_lock`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "manufacturer`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "manufacturer_to_store`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "attribute`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "attribute_description`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "attribute_group`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "attribute_group_description`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "ebay_listing`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "category`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "category_description`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "category_to_store`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_to_store`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_description`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_attribute`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_option`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_option_value`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_image`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "product_to_category`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "option`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "option_description`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "option_value`");
            $this->db->query("TRUNCATE `" . DB_PREFIX . "option_value_description`");

            if ($this->openbay->addonLoad('openstock')) {
                $this->db->query("TRUNCATE `" . DB_PREFIX . "product_option_relation`");
            }
            */

            
$this->log->write('Data cleared');
            
$json = array('msg' => 'Data cleared');
        }

        
$this->response->addHeader('Content-Type: application/json');
        
$this->response->setOutput(json_encode($json));
    }
}
Онлайн: 1
Реклама