diff options
Diffstat (limited to 'public/admin/controller/extension/advertise')
| -rw-r--r-- | public/admin/controller/extension/advertise/google.php | 2089 |
1 files changed, 2089 insertions, 0 deletions
diff --git a/public/admin/controller/extension/advertise/google.php b/public/admin/controller/extension/advertise/google.php new file mode 100644 index 0000000..fa24904 --- /dev/null +++ b/public/admin/controller/extension/advertise/google.php @@ -0,0 +1,2089 @@ +<?php + +use \googleshopping\exception\Connection as ConnectionException; +use \googleshopping\Googleshopping; +use \googleshopping\traits\LibraryLoader; +use \googleshopping\traits\StoreLoader; + +class ControllerExtensionAdvertiseGoogle extends Controller { + use StoreLoader; + use LibraryLoader; + + private $error = array(); + private $store_id = 0; + + public function __construct($registry) { + parent::__construct($registry); + + $this->store_id = isset($this->request->get['store_id']) ? (int)$this->request->get['store_id'] : 0; + + $this->loadStore($this->store_id); + + $this->loadLibrary($this->store_id); + } + + public function index() { + $this->load->language('extension/advertise/google'); + + $this->load->model('extension/advertise/google'); + + $this->load->config('googleshopping/googleshopping'); + + // Fix clashes with third-party extension table names + $this->model_extension_advertise_google->renameTables(); + + // Even though this should be ran during install, there are known cases of webstores which do not trigger the install method. This is why we run createTables here explicitly. + $this->model_extension_advertise_google->createTables(); + + // Fix a missing AUTO_INCREMENT + $this->model_extension_advertise_google->fixColumns(); + + // Redirect to the preliminary check-list + if (!$this->setting->get('advertise_google_checklist_confirmed')) { + $this->response->redirect($this->url->link('extension/advertise/google/checklist', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + + try { + // If we have not connected, navigate to connect screen + if (!$this->setting->has('advertise_google_access_token')) { + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } else if (!$this->setting->has('advertise_google_gmc_account_selected')) { + // In case the merchant has made no decision about which GMC account to use, redirect to the form for connection + $this->response->redirect($this->url->link('extension/advertise/google/merchant', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } else if (!$this->googleshopping->isStoreUrlClaimed()) { + if (empty($this->session->data['error'])) { + $this->session->data['error'] = $this->language->get('error_store_url_claim'); + } + + // In case the merchant has made no decision about which GMC account to use, redirect to the form for connection + $this->response->redirect($this->url->link('extension/advertise/google/merchant', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } else if (count($this->googleshopping->getTargets($this->store_id)) == 0) { + $this->response->redirect($this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } else if (!$this->setting->has('advertise_google_gmc_shipping_taxes_configured')) { + // In case the merchant has not set up shipping and taxes, redirect them to the form for shipping and taxes + $this->response->redirect($this->url->link('extension/advertise/google/shipping_taxes', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } else if (count($this->model_extension_advertise_google->getMapping($this->store_id)) == 0) { + // In case the merchant has not set up mapping, redirect them to the form for mapping + $this->response->redirect($this->url->link('extension/advertise/google/mapping', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + + // Pull the campaign reports + $this->googleshopping->getCampaignReports(); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->error['warning'] = $e->getMessage(); + } + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateSettings()) { + $this->applyNewSettings($this->request->post); + + try { + // Profilactic target push, as sometimes targets are not initialized properly + $this->googleshopping->pushTargets(); + $this->googleshopping->pushCampaignStatus(); + + $this->session->data['success'] = $this->language->get('success_index'); + + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->error['warning'] = $e->getMessage(); + } + } + + $this->document->setTitle($this->language->get('heading_title')); + + $data = array(); + + $data['text_connected'] = sprintf($this->language->get('text_connected'), $this->setting->get('advertise_google_gmc_account_id')); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + $data['error'] = $this->session->data['error']; + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + $data['error_cron_email'] = $this->getValidationError('cron_email'); + $data['error_cron_acknowledge'] = $this->getValidationError('cron_acknowledge'); + + $data['success'] = ''; + + if (isset($this->session->data['success'])) { + $data['success'] = $this->session->data['success']; + unset($this->session->data['success']); + } + + $advertised_count = $this->model_extension_advertise_google->getAdvertisedCount($this->store_id); + $last_cron_executed = (int)$this->setting->get('advertise_google_cron_last_executed'); + + $data['warning'] = ''; + + if (!$this->setting->get('advertise_google_status') && $this->model_extension_advertise_google->hasActiveTarget($this->store_id)) { + $data['warning'] = $this->language->get('warning_disabled'); + } else if (!$this->model_extension_advertise_google->hasActiveTarget($this->store_id)) { + $data['warning'] = sprintf($this->language->get('warning_no_active_campaigns'), $this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true)); + } else if ($advertised_count == 0) { + $data['warning'] = sprintf($this->language->get("warning_no_advertised_products"), $this->language->get("text_video_tutorial_url_advertise")); + } else if ($last_cron_executed + 24 * 60 * 60 <= time()) { + $data['warning'] = sprintf($this->language->get("warning_last_cron_executed"), $this->language->get("text_tutorial_cron")); + } + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + $reporting_intervals = $this->config->get('advertise_google_reporting_intervals'); + + $data['user_token'] = $this->session->data['user_token']; + + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + $data['action'] = $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + $data['shipping_taxes'] = $this->url->link('extension/advertise/google/shipping_taxes', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true); + $data['campaign'] = $this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true); + $data['mapping'] = $this->url->link('extension/advertise/google/mapping', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true); + $data['disconnect'] = $this->url->link('extension/advertise/google/disconnect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + $data['list_ads'] = html_entity_decode($this->url->link('extension/advertise/google/list_ads', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['advertise'] = html_entity_decode($this->url->link('extension/advertise/google/advertise', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['url_popup'] = html_entity_decode($this->url->link('extension/advertise/google/popup_product', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['url_category_autocomplete'] = html_entity_decode($this->url->link('extension/advertise/google/category_autocomplete', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['url_debug_log_download'] = html_entity_decode($this->url->link('extension/advertise/google/debug_log_download', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + + $data['advertise_google_status'] = $this->getSettingValue('advertise_google_status', 0); + $data['advertise_google_debug_log'] = $this->getSettingValue('advertise_google_debug_log', 0); + $data['advertise_google_cron_email_status'] = $this->getSettingValue('advertise_google_cron_email_status'); + $data['advertise_google_cron_email'] = $this->getSettingValue('advertise_google_cron_email', $this->config->get('config_email')); + $data['advertise_google_cron_token'] = $this->getSettingValue('advertise_google_cron_token'); + $data['advertise_google_cron_acknowledge'] = $this->getSettingValue('advertise_google_cron_acknowledge', null, true); + + if (isset($this->request->post['advertise_google_reporting_interval'])) { + $data['advertise_google_reporting_interval'] = $this->request->post['advertise_google_reporting_interval']; + } else if ($this->setting->has('advertise_google_reporting_interval') && in_array($this->setting->get('advertise_google_reporting_interval'), $reporting_intervals)) { + $data['advertise_google_reporting_interval'] = $this->setting->get('advertise_google_reporting_interval'); + } else { + $data['advertise_google_reporting_interval'] = $this->config->get('advertise_google_reporting_intervals_default'); + } + + $server = $this->googleshopping->getStoreUrl(); + + $data['advertise_google_cron_command'] = 'export CUSTOM_SERVER_NAME=' . parse_url($server, PHP_URL_HOST) . '; export CUSTOM_SERVER_PORT=443; export ADVERTISE_GOOGLE_CRON=1; export ADVERTISE_GOOGLE_STORE_ID=' . $this->store_id . '; ' . PHP_BINDIR . '/php -d session.save_path=' . session_save_path() . ' -d memory_limit=256M ' . DIR_SYSTEM . 'library/googleshopping/cron.php > /dev/null 2> /dev/null'; + + if (!$this->setting->get('advertise_google_cron_token')) { + $data['advertise_google_cron_token'] = md5(mt_rand()); + } + + $host_and_uri = parse_url($server, PHP_URL_HOST) . parse_url($server, PHP_URL_PATH); + + $data['advertise_google_cron_url'] = 'https://' . rtrim($host_and_uri, '/') . '/index.php?route=extension/advertise/google/cron&cron_token={CRON_TOKEN}'; + + $data['reporting_intervals'] = array(); + + foreach ($reporting_intervals as $interval) { + $data['reporting_intervals'][$interval] = $this->language->get('text_reporting_interval_' . $interval); + } + + $campaign_reports = $this->setting->get('advertise_google_report_campaigns'); + + $data['campaigns'] = $this->googleshopping->getTargets($this->store_id); + + $data['text_report_date_range'] = sprintf($this->language->get('text_report_date_range'), $campaign_reports['date_range']); + $data['text_ads_intro'] = sprintf($this->language->get('text_ads_intro'), $data['shipping_taxes']); + $data['advertise_google_report_campaigns'] = $campaign_reports['reports']; + $data['text_panel_heading'] = sprintf($this->language->get('text_panel_heading'), $this->googleshopping->getStoreName()); + + $data['text_selection_all'] = str_replace("'", "\\'", $this->language->get('text_selection_all')); + $data['text_selection_page'] = str_replace("'", "\\'", $this->language->get('text_selection_page')); + + $data['tab_settings'] = $this->load->view('extension/advertise/google_settings', $data); + $data['tab_ads'] = $this->load->view('extension/advertise/google_ads', $data); + $data['tab_reports'] = $this->load->view('extension/advertise/google_reports', $data); + + $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/advertise/google', $data)); + } + + public function debug_log_download() { + $filename = sprintf(Googleshopping::DEBUG_LOG_FILENAME, $this->store_id); + + header('Pragma: no-cache'); + header('Expires: 0'); + header('Content-Description: File Transfer'); + header('Content-Type: plain/text'); + header('Content-Disposition: attachment; filename="' . $filename . '"'); + header('Content-Transfer-Encoding: binary'); + + $file = DIR_LOGS . $filename; + + if (file_exists($file)) { + readfile($file); + } + + exit; + } + + public function advertise() { + $this->load->language('extension/advertise/google'); + + $json = array( + 'success' => null, + 'redirect' => null, + 'error' => null, + 'warning' => null + ); + + if ($this->validatePermission()) { + $this->load->model('extension/advertise/google'); + + $select = array(); + $filter_data = array(); + + if (!empty($this->request->post['all_pages'])) { + $filter_data = $this->getFilter($this->request->post['filter']); + } else if (isset($this->request->post['select']) && is_array($this->request->post['select'])) { + $select = $this->request->post['select']; + } + + if (!empty($select) || !empty($filter_data)) { + $target_ids = !empty($this->request->post['target_ids']) ? $this->request->post['target_ids'] : array(); + + if (!empty($select)) { + $this->model_extension_advertise_google->setAdvertisingBySelect($select, $target_ids, $this->store_id); + } else if (!empty($filter_data)) { + $this->model_extension_advertise_google->setAdvertisingByFilter($filter_data, $target_ids, $this->store_id); + } + + if (!empty($target_ids)) { + $json['success'] = $this->language->get('success_advertise_listed'); + } else { + $json['success'] = $this->language->get('success_advertise_unlisted'); + } + } + } else { + $json['error'] = $this->error['warning']; + } + + // Refresh warnings + $advertised_count = $this->model_extension_advertise_google->getAdvertisedCount($this->store_id); + $last_cron_executed = (int)$this->setting->get('advertise_google_cron_last_executed'); + + if (!$this->setting->get('advertise_google_status') && $this->model_extension_advertise_google->hasActiveTarget($this->store_id)) { + $json['warning'] = $this->language->get('warning_disabled'); + } else if (!$this->model_extension_advertise_google->hasActiveTarget($this->store_id)) { + $json['warning'] = sprintf($this->language->get('warning_no_active_campaigns'), $this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true)); + } else if ($advertised_count == 0) { + $json['warning'] = sprintf($this->language->get("warning_no_advertised_products"), $this->language->get("text_video_tutorial_url_advertise")); + } else if ($last_cron_executed + 24 * 60 * 60 <= time()) { + $json['warning'] = sprintf($this->language->get("warning_last_cron_executed"), $this->language->get("text_tutorial_cron")); + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function list_ads() { + $json = array(); + + $this->load->model('extension/advertise/google'); + + $this->model_extension_advertise_google->insertNewProducts(array(), $this->store_id); + + $this->load->language('extension/advertise/google'); + + $page = (int)$this->request->post['page']; + + $filter_data = array( + 'sort' => $this->request->post['sort'], + 'order' => $this->request->post['order'], + 'start' => ($page - 1) * $this->config->get('config_limit_admin'), + 'limit' => $this->config->get('config_limit_admin') + ); + + $filter_data = array_merge($filter_data, $this->getFilter($this->request->post['filter'])); + + $products = $this->googleshopping->getProducts($filter_data, $this->store_id); + + $json['products'] = array_map(array($this, 'product'), $products); + + $product_total = $this->googleshopping->getTotalProducts($filter_data, $this->store_id); + + $pagination = new Pagination(); + $pagination->total = $product_total; + $pagination->page = $this->request->post['page']; + $pagination->limit = $this->config->get('config_limit_admin'); + $pagination->url = '{page}'; + + $pages = ceil($product_total / $this->config->get('config_limit_admin')); + + $json['showing'] = sprintf($this->language->get('text_pagination'), ($product_total) ? (($page - 1) * $this->config->get('config_limit_admin')) + 1 : 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_total, $pages); + + $json['pagination'] = $pagination->render(); + $json['total'] = (int)$product_total; + $json['pages'] = (int)$pages; + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function merchant() { + $this->load->language('extension/advertise/google'); + + $this->document->setTitle($this->language->get('heading_merchant')); + + $this->document->addStyle('view/stylesheet/googleshopping/stepper.css'); + + $this->load->model('extension/advertise/google'); + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validatePermission()) { + try { + $redirect_uri = html_entity_decode($this->url->link('extension/advertise/google/callback_merchant', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $state = md5(microtime(true) . $redirect_uri . microtime(true)); + + $auth_url_data = array( + 'account_type' => $this->request->post['advertise_google_gmc_account_type'], + 'redirect_uri' => $redirect_uri . '&state=' . $state + ); + + $this->session->data['advertise_google'] = $auth_url_data; + $this->session->data['advertise_google']['state'] = $state; + + $this->response->redirect($this->googleshopping->getMerchantAuthUrl($auth_url_data)); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->error['warning'] = $e->getMessage(); + } + } + + $data = array(); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + $data['error'] = $this->session->data['error']; + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + $data['success'] = ''; + + if (isset($this->session->data['success'])) { + $data['success'] = $this->session->data['success']; + unset($this->session->data['success']); + } + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google/merchant', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + $data['action'] = $this->url->link('extension/advertise/google/merchant', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + + if (isset($this->request->post['advertise_google_gmc_account_type'])) { + $data['advertise_google_gmc_account_type'] = $this->request->post['advertise_google_gmc_account_type']; + } else { + $data['advertise_google_gmc_account_type'] = 'api'; + } + + $data['header'] = $this->load->controller('common/header'); + $data['column_left'] = $this->load->controller('common/column_left'); + $data['footer'] = $this->load->controller('common/footer'); + + $data['current_step'] = 2; + $data['steps'] = $this->load->view('extension/advertise/google_steps', $data); + + $this->response->setOutput($this->load->view('extension/advertise/google_merchant', $data)); + } + + public function shipping_taxes() { + $this->load->language('extension/advertise/google'); + + $this->document->setTitle($this->language->get('heading_shipping_taxes')); + + $this->document->addStyle('view/stylesheet/googleshopping/stepper.css'); + + $this->load->model('extension/advertise/google'); + + $this->load->config('googleshopping/googleshopping'); + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateShippingAndTaxes()) { + try { + $this->applyNewSettings($this->request->post); + + $this->googleshopping->pushShippingAndTaxes(); + + $this->applyNewSettings(array( + 'advertise_google_gmc_shipping_taxes_configured' => '1' + )); + + $this->session->data['success'] = $this->language->get('success_shipping_taxes'); + + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->error['warning'] = $e->getMessage(); + } + } + + $available_carriers = array(); + + try { + $available_carriers = $this->googleshopping->getAvailableCarriers(); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->error['warning'] = $e->getMessage(); + } + + $data = array(); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + $data['error'] = $this->session->data['error']; + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + if (isset($this->error['min_transit_time'])) { + $data['error_min_transit_time'] = $this->error['min_transit_time']; + } else { + $data['error_min_transit_time'] = ''; + } + + if (isset($this->error['max_transit_time'])) { + $data['error_max_transit_time'] = $this->error['max_transit_time']; + } else { + $data['error_max_transit_time'] = ''; + } + + if (isset($this->error['flat_rate'])) { + $data['error_flat_rate'] = $this->error['flat_rate']; + } else { + $data['error_flat_rate'] = ''; + } + + if (isset($this->error['carrier_postcode'])) { + $data['error_carrier_postcode'] = $this->error['carrier_postcode']; + } else { + $data['error_carrier_postcode'] = ''; + } + + if (isset($this->error['carrier_price_percentage'])) { + $data['error_carrier_price_percentage'] = $this->error['carrier_price_percentage']; + } else { + $data['error_carrier_price_percentage'] = ''; + } + + if (isset($this->error['carrier'])) { + $data['error_carrier'] = $this->error['carrier']; + } else { + $data['error_carrier'] = ''; + } + + $data['success'] = ''; + + if (isset($this->session->data['success'])) { + $data['success'] = $this->session->data['success']; + unset($this->session->data['success']); + } + + $data['from_dashboard'] = isset($this->request->get['from_dashboard']); + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + if ($data['from_dashboard']) { + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_shipping_taxes'), + 'href' => $this->url->link('extension/advertise/google/shipping_taxes', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true), + ); + } + + if ($data['from_dashboard']) { + $data['cancel'] = $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + } else { + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + } + + $data['action'] = $this->url->link('extension/advertise/google/shipping_taxes', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + + if (isset($this->request->post['advertise_google_shipping_taxes'])) { + $data['advertise_google_shipping_taxes'] = $this->request->post['advertise_google_shipping_taxes']; + } else if ($this->setting->has('advertise_google_shipping_taxes')) { + $data['advertise_google_shipping_taxes'] = $this->setting->get('advertise_google_shipping_taxes'); + } else { + $data['advertise_google_shipping_taxes'] = array( + 'shipping_type' => 'flat', + 'flat_rate' => $this->config->get('shipping_flat_cost'), + 'min_transit_time' => 1, + 'max_transit_time' => 14, + 'carrier_price_percentage' => 5, + 'tax_type' => $this->config->get('config_country_id') == 223 ? 'usa' : 'not_usa' + ); + } + + $data['available_carriers'] = $available_carriers; + + $data['states'] = $this->config->get('advertise_google_tax_usa_states'); + + $data['header'] = $this->load->controller('common/header'); + $data['column_left'] = $this->load->controller('common/column_left'); + $data['footer'] = $this->load->controller('common/footer'); + + $data['current_step'] = 4; + $data['steps'] = $this->load->view('extension/advertise/google_steps', $data); + + $this->response->setOutput($this->load->view('extension/advertise/google_shipping_taxes', $data)); + } + + public function mapping() { + $this->load->language('extension/advertise/google'); + + $this->document->setTitle($this->language->get('heading_mapping')); + + $this->document->addStyle('view/stylesheet/googleshopping/stepper.css'); + + $this->load->model('extension/advertise/google'); + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateMapping()) { + try { + foreach ($this->request->post['advertise_google_mapping'] as $google_product_category => $category_id) { + $this->model_extension_advertise_google->setCategoryMapping($google_product_category, $this->store_id, $category_id); + } + + if (!empty($this->request->post['advertise_google_modify_existing'])) { + $this->model_extension_advertise_google->updateGoogleProductCategoryMapping($this->store_id); + } + + $this->session->data['success'] = $this->language->get('success_mapping'); + + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->error['warning'] = $e->getMessage(); + } + } + + $data = array(); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + $data['error'] = $this->session->data['error']; + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + $data['success'] = ''; + + if (isset($this->session->data['success'])) { + $data['success'] = $this->session->data['success']; + unset($this->session->data['success']); + } + + $data['from_dashboard'] = isset($this->request->get['from_dashboard']); + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + if ($data['from_dashboard']) { + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_shipping_taxes'), + 'href' => $this->url->link('extension/advertise/google/mapping', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true), + ); + } + + $this->load->config('googleshopping/googleshopping'); + + $data['mapping'] = array(); + + foreach ($this->config->get('advertise_google_google_product_categories') as $google_product_category_id => $google_product_category_name) { + if ($google_product_category_id == 0) continue; + + $category_id = ''; + $name = ''; + + if (null !== $category = $this->model_extension_advertise_google->getMappedCategory($google_product_category_id, $this->store_id)) { + $category_id = $category['category_id']; + $name = $category['name']; + } + + $map = array( + 'google_product_category' => array( + 'id' => $google_product_category_id, + 'name' => $google_product_category_name + ), + 'oc_category' => array( + 'category_id' => $category_id, + 'name' => $name + ) + ); + + $data['mapping'][] = $map; + } + + $data['mapping_json'] = json_encode($data['mapping']); + + if ($data['from_dashboard']) { + $data['cancel'] = $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + } else { + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + } + + $data['action'] = $this->url->link('extension/advertise/google/mapping', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + + $data['user_token'] = $this->session->data['user_token']; + + $data['url_mapping_verify'] = html_entity_decode($this->url->link('extension/advertise/google/mapping_verify', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['url_category_autocomplete'] = html_entity_decode($this->url->link('extension/advertise/google/category_autocomplete', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + + $data['header'] = $this->load->controller('common/header'); + $data['column_left'] = $this->load->controller('common/column_left'); + $data['footer'] = $this->load->controller('common/footer'); + + $data['current_step'] = 5; + $data['steps'] = $this->load->view('extension/advertise/google_steps', $data); + + $this->response->setOutput($this->load->view('extension/advertise/google_mapping', $data)); + } + + public function mapping_verify() { + $this->load->language('extension/advertise/google'); + + $this->load->model('extension/advertise/google'); + + $data = array(); + + $json = array( + 'submit_directly' => !$this->model_extension_advertise_google->isAnyProductCategoryModified($this->store_id), + 'modal_confirmation' => $this->load->view('extension/advertise/google_mapping_verify', $data) + ); + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function campaign_test() { + $json = array( + 'status' => false, + 'redirect' => null, + 'error' => null + ); + + if ($this->validatePermission()) { + try { + $json['status'] = $this->googleshopping->testCampaigns(); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $json['redirect'] = html_entity_decode($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + } catch (\RuntimeException $e) { + $json['status'] = false; + $json['error'] = $e->getMessage(); + } + + $this->applyNewSettings(array( + 'advertise_google_can_edit_campaigns' => (int)$json['status'] + )); + } else { + $json['error'] = $this->error['warning']; + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function campaign() { + $this->load->language('extension/advertise/google'); + + $this->document->setTitle($this->language->get('heading_campaign')); + + $this->document->addStyle('view/stylesheet/googleshopping/stepper.css'); + + $this->load->model('extension/advertise/google'); + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateCampaign()) { + $this->applyNewSettings($this->request->post); + + // If there is no redirect from the push of targets, go back to the extension dashboard + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + + $data = array(); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + $data['error'] = $this->session->data['error']; + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + $data['success'] = ''; + + if (isset($this->session->data['success'])) { + $data['success'] = $this->session->data['success']; + unset($this->session->data['success']); + } + + $data['warning'] = ''; + + if (!$this->setting->get('advertise_google_status') && $this->model_extension_advertise_google->hasActiveTarget($this->store_id)) { + $data['warning'] = $this->language->get('warning_paused_targets'); + } + + $data['from_dashboard'] = isset($this->request->get['from_dashboard']); + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + if ($data['from_dashboard']) { + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_campaign'), + 'href' => $this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&from_dashboard=true', true), + ); + } + + if (isset($this->request->post['advertise_google_auto_advertise'])) { + $data['advertise_google_auto_advertise'] = $this->request->post['advertise_google_auto_advertise']; + } else if ($this->setting->has('advertise_google_auto_advertise')) { + $data['advertise_google_auto_advertise'] = $this->setting->get('advertise_google_auto_advertise'); + } else { + $data['advertise_google_auto_advertise'] = '0'; + } + + if ($data['from_dashboard']) { + $data['cancel'] = $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + } else { + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + } + + $data['action'] = $this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + $data['target_add'] = html_entity_decode($this->url->link('extension/advertise/google/target_add', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['target_edit'] = html_entity_decode($this->url->link('extension/advertise/google/target_edit', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&advertise_google_target_id={target_id}', true), ENT_QUOTES, 'UTF-8'); + $data['target_delete'] = html_entity_decode($this->url->link('extension/advertise/google/target_delete', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&advertise_google_target_id={target_id}', true), ENT_QUOTES, 'UTF-8'); + $data['target_list'] = html_entity_decode($this->url->link('extension/advertise/google/target_list', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['url_campaign_test'] = html_entity_decode($this->url->link('extension/advertise/google/campaign_test', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $data['can_edit_campaigns'] = (bool)$this->setting->get('advertise_google_can_edit_campaigns'); + $data['text_roas_warning'] = sprintf($this->language->get('warning_roas'), date($this->language->get('date_format_long'), time() + Googleshopping::ROAS_WAIT_INTERVAL)); + + $data['json_allowed_targets'] = json_encode($this->model_extension_advertise_google->getAllowedTargets()); + + $targets = $this->googleshopping->getTargets($this->store_id); + + foreach ($targets as &$target) { + if (!$target['roas_status']) { + $target['roas_warning'] = sprintf($this->language->get('warning_roas'), date($this->language->get('date_format_long'), $target['roas_available_on'])); + } else { + $target['roas_warning'] = null; + } + } + + $data['targets'] = $targets; + $data['json_targets'] = json_encode($targets); + + $data['header'] = $this->load->controller('common/header'); + $data['column_left'] = $this->load->controller('common/column_left'); + $data['footer'] = $this->load->controller('common/footer'); + + $data['current_step'] = 3; + $data['steps'] = $this->load->view('extension/advertise/google_steps', $data); + + $this->response->setOutput($this->load->view('extension/advertise/google_campaign', $data)); + } + + public function target_add() { + $this->load->language('extension/advertise/google'); + + $json = array( + 'success' => null, + 'redirect' => null, + 'error' => null + ); + + if ($this->validatePermission()) { + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateTarget()) { + $this->load->model('extension/advertise/google'); + + $target = array( + 'store_id' => $this->store_id, + 'campaign_name' => str_replace(',', ',', trim($this->request->post['campaign_name'])), + 'country' => $this->request->post['country'], + 'status' => $this->request->post['status'] == 'active' ? 'active' : 'paused', + 'budget' => (float)preg_replace('~[^0-9\.]~i', '', $this->request->post['budget']), + 'roas' => isset($this->request->post['roas']) ? (int)$this->request->post['roas'] : 0, + 'feeds' => array_values($this->request->post['feed']) + ); + + $this->model_extension_advertise_google->addTarget($target, $this->store_id); + + try { + $this->googleshopping->pushTargets(); + + $json['success'] = $this->language->get('success_target_add'); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $json['redirect'] = html_entity_decode($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + } catch (\RuntimeException $e) { + $json['error'] = $e->getMessage(); + } + } else { + $json['error'] = $this->error['warning']; + + if (isset($this->error['campaign_name'])) { + $json['error_campaign_name'] = $this->error['campaign_name']; + } + + if (isset($this->error['country'])) { + $json['error_country'] = $this->error['country']; + } + + if (isset($this->error['budget'])) { + $json['error_budget'] = $this->error['budget']; + } + + if (isset($this->error['feed'])) { + $json['error_feed'] = $this->error['feed']; + } + } + } else { + $json['error'] = $this->error['warning']; + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function target_edit() { + $this->load->language('extension/advertise/google'); + + $json = array( + 'success' => null, + 'redirect' => null, + 'error' => null + ); + + if ($this->validatePermission()) { + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateTarget()) { + $this->load->model('extension/advertise/google'); + + $target = array( + 'campaign_name' => str_replace(',', ',', trim($this->request->post['campaign_name'])), + 'country' => $this->request->post['country'], + 'status' => $this->request->post['status'] == 'active' ? 'active' : 'paused', + 'budget' => (float)preg_replace('~[^0-9\.]~i', '', $this->request->post['budget']), + 'roas' => isset($this->request->post['roas']) ? (int)$this->request->post['roas'] : 0, + 'feeds' => array_values($this->request->post['feed']) + ); + + $this->googleshopping->editTarget((int)$this->request->get['advertise_google_target_id'], $target); + + try { + $this->googleshopping->pushTargets(); + + $json['success'] = $this->language->get('success_target_edit'); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $json['redirect'] = html_entity_decode($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + } catch (\RuntimeException $e) { + $json['error'] = $e->getMessage(); + } + } else { + $json['error'] = $this->error['warning']; + + if (isset($this->error['campaign_name'])) { + $json['error_campaign_name'] = $this->error['campaign_name']; + } + + if (isset($this->error['country'])) { + $json['error_country'] = $this->error['country']; + } + + if (isset($this->error['budget'])) { + $json['error_budget'] = $this->error['budget']; + } + + if (isset($this->error['feed'])) { + $json['error_feed'] = $this->error['feed']; + } + } + } else { + $json['error'] = $this->error['warning']; + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function target_delete() { + $this->load->language('extension/advertise/google'); + + $json = array( + 'success' => null, + 'redirect' => null, + 'error' => null + ); + + if ($this->validatePermission()) { + $this->load->model('extension/advertise/google'); + + $advertise_google_target_id = (int)$this->request->get['advertise_google_target_id']; + + $target_info = $this->googleshopping->getTarget($advertise_google_target_id); + + if (!empty($target_info)) { + try { + $this->googleshopping->deleteCampaign($target_info['campaign_name']); + + $this->googleshopping->deleteTarget($advertise_google_target_id); + + $json['success'] = $this->language->get('success_target_delete'); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $json['redirect'] = html_entity_decode($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + } catch (\RuntimeException $e) { + $json['error'] = $e->getMessage(); + } + } + } else { + $json['error'] = $this->error['warning']; + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function target_list() { + $this->load->language('extension/advertise/google'); + + $json = array( + 'targets' => null, + 'error' => null + ); + + $this->load->model('extension/advertise/google'); + + $targets = $this->googleshopping->getTargets($this->store_id); + + foreach ($targets as &$target) { + if (!$target['roas_status']) { + $target['roas_warning'] = sprintf($this->language->get('warning_roas'), date($this->language->get('date_format_long'), $target['roas_available_on'])); + } else { + $target['roas_warning'] = null; + } + } + + $json['targets'] = $targets; + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function callback_merchant() { + $state_verified = + !empty($this->session->data['advertise_google']['state']) && + !empty($this->request->get['state']) && + $this->request->get['state'] == $this->session->data['advertise_google']['state']; + + $error = isset($this->request->get['error']) ? $this->request->get['error'] : null; + $merchant_id = isset($this->request->get['merchant_id']) ? $this->request->get['merchant_id'] : null; + + if ($state_verified && is_null($error)) { + $this->load->language('extension/advertise/google'); + + try { + $this->googleshopping->verifySite(); + + $this->load->model('user/user'); + $user_info = $this->model_user_user->getUser($this->user->getId()); + + $this->applyNewSettings(array( + 'advertise_google_gmc_account_selected' => true, + 'advertise_google_gmc_account_id' => $merchant_id, + 'advertise_google_gmc_account_accepted_by' => array( + 'user_id' => $user_info['user_id'], + 'user_group_id' => $user_info['user_group_id'], + 'user_group' => $user_info['user_group'], + 'username' => $user_info['username'], + 'firstname' => $user_info['firstname'], + 'lastname' => $user_info['lastname'], + 'email' => $user_info['email'], + 'ip' => $user_info['ip'] + ), + 'advertise_google_gmc_account_accepted_at' => time(), + 'advertise_google_conversion_tracker' => $this->googleshopping->getConversionTracker(), + 'advertise_google_can_edit_campaigns' => '0' + )); + + if ($this->session->data['advertise_google']['account_type'] == 'api') { + $this->session->data['success'] = sprintf($this->language->get('success_merchant_access'), $merchant_id); + } else { + $this->session->data['success'] = $this->language->get('success_merchant'); + } + + if (count($this->googleshopping->getTargets($this->store_id)) > 0) { + $this->response->redirect($this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + unset($this->session->data['advertise_google']); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->session->data['error'] = $e->getMessage(); + } + } else if (!is_null($error)) { + $this->session->data['error'] = $error; + + $setting = $this->model_setting_setting->getSetting('advertise_google', $this->store_id); + + unset($setting['advertise_google_status']); + unset($setting['advertise_google_work']); + unset($setting['advertise_google_gmc_account_selected']); + unset($setting['advertise_google_gmc_shipping_taxes_configured']); + unset($setting['advertise_google_can_edit_campaigns']); + + $this->model_setting_setting->editSetting('advertise_google', $setting, $this->store_id); + } + + unset($this->session->data['advertise_google']); + + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + + public function callback_connect() { + $state_verified = + !empty($this->session->data['advertise_google']['state']) && + !empty($this->request->get['state']) && + $this->request->get['state'] == $this->session->data['advertise_google']['state']; + + if ($state_verified) { + $this->load->language('extension/advertise/google'); + + $this->load->model('extension/advertise/google'); + + try { + $access = $this->googleshopping->access($this->session->data['advertise_google'], urldecode($this->request->get['code'])); + + $this->applyNewSettings(array( + 'advertise_google_app_id' => $this->session->data['advertise_google']['app_id'], + 'advertise_google_app_secret' => $this->session->data['advertise_google']['app_secret'], + 'advertise_google_status' => $this->session->data['advertise_google']['status'], + 'advertise_google_cron_token' => $this->session->data['advertise_google']['cron_token'], + 'advertise_google_cron_acknowledge' => $this->session->data['advertise_google']['cron_acknowledge'], + 'advertise_google_cron_email' => $this->session->data['advertise_google']['cron_email'], + 'advertise_google_cron_email_status' => $this->session->data['advertise_google']['cron_email_status'], + 'advertise_google_access_token' => $access['access_token'], + 'advertise_google_refresh_token' => $access['refresh_token'] + )); + + $this->session->data['success'] = $this->language->get('success_connect'); + + if (count($this->googleshopping->getTargets($this->store_id)) > 0 && $this->setting->get('advertise_google_gmc_account_selected')) { + $this->response->redirect($this->url->link('extension/advertise/google/campaign', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->session->data['error'] = $e->getMessage(); + } + } else if (isset($this->request->get['error'])) { + $this->session->data['error'] = $this->request->get['error']; + } + + unset($this->session->data['advertise_google']); + + if ($this->setting->get('advertise_google_gmc_account_selected')) { + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } else { + $this->response->redirect($this->url->link('extension/advertise/google/merchant', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + } + + public function connect() { + $this->load->language('extension/advertise/google'); + + $this->document->setTitle($this->language->get('heading_title')); + + $this->document->addStyle('view/stylesheet/googleshopping/stepper.css'); + + $this->load->model('extension/advertise/google'); + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validateSettings() && $this->validateConnect()) { + unset($this->session->data['advertise_google']); + + $this->session->data['advertise_google']['app_id'] = $this->request->post['advertise_google_app_id']; + $this->session->data['advertise_google']['app_secret'] = $this->request->post['advertise_google_app_secret']; + $this->session->data['advertise_google']['status'] = $this->request->post['advertise_google_status']; + $this->session->data['advertise_google']['cron_email_status'] = $this->request->post['advertise_google_cron_email_status']; + $this->session->data['advertise_google']['cron_email'] = $this->request->post['advertise_google_cron_email']; + $this->session->data['advertise_google']['cron_token'] = $this->request->post['advertise_google_cron_token']; + $this->session->data['advertise_google']['cron_acknowledge'] = isset($this->request->post['advertise_google_cron_acknowledge']); + $this->session->data['advertise_google']['redirect_uri'] = html_entity_decode($this->url->link('extension/advertise/google/callback_connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), ENT_QUOTES, 'UTF-8'); + $this->session->data['advertise_google']['state'] = md5(microtime(true) . json_encode($this->session->data['advertise_google']) . microtime(true)); + + $url = $this->googleshopping->authorize($this->session->data['advertise_google']); + + $this->response->redirect($url); + } + + $data = array(); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + if (empty($this->session->data['success']) && $this->getSettingValue('advertise_google_app_id', false) && $this->getSettingValue('advertise_google_app_secret', false)) { + $data['error'] = $this->session->data['error']; + } + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + $data['error_cron_email'] = $this->getValidationError('cron_email'); + $data['error_cron_acknowledge'] = $this->getValidationError('cron_acknowledge'); + + if (isset($this->error['app_id'])) { + $data['error_app_id'] = $this->error['app_id']; + } else { + $data['error_app_id'] = ''; + } + + if (isset($this->error['app_secret'])) { + $data['error_app_secret'] = $this->error['app_secret']; + } else { + $data['error_app_secret'] = ''; + } + + $data['success'] = ''; + + if (isset($this->session->data['success'])) { + $data['success'] = $this->session->data['success']; + unset($this->session->data['success']); + } + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + $data['advertise_google_status'] = $this->getSettingValue('advertise_google_status', 1); + $data['advertise_google_app_id'] = $this->getSettingValue('advertise_google_app_id', ''); + $data['advertise_google_app_secret'] = $this->getSettingValue('advertise_google_app_secret', ''); + $data['advertise_google_cron_email_status'] = $this->getSettingValue('advertise_google_cron_email_status'); + $data['advertise_google_cron_email'] = $this->getSettingValue('advertise_google_cron_email', $this->config->get('config_email')); + $data['advertise_google_cron_token'] = $this->getSettingValue('advertise_google_cron_token'); + $data['advertise_google_cron_acknowledge'] = $this->getSettingValue('advertise_google_cron_acknowledge', null, true); + + $server = $this->googleshopping->getStoreUrl(); + + $data['advertise_google_cron_command'] = 'export CUSTOM_SERVER_NAME=' . parse_url($server, PHP_URL_HOST) . '; export CUSTOM_SERVER_PORT=443; export ADVERTISE_GOOGLE_CRON=1; export ADVERTISE_GOOGLE_STORE_ID=' . $this->store_id . '; ' . PHP_BINDIR . '/php -d session.save_path=' . session_save_path() . ' -d memory_limit=256M ' . DIR_SYSTEM . 'library/googleshopping/cron.php > /dev/null 2> /dev/null'; + + if (!$this->setting->get('advertise_google_cron_token')) { + $data['advertise_google_cron_token'] = md5(mt_rand()); + } + + $host_and_uri = parse_url($server, PHP_URL_HOST) . dirname(parse_url($server, PHP_URL_PATH)); + + $data['advertise_google_cron_url'] = 'https://' . rtrim($host_and_uri, '/') . '/index.php?route=extension/advertise/google/cron&cron_token={CRON_TOKEN}'; + + $data['header'] = $this->load->controller('common/header'); + $data['column_left'] = $this->load->controller('common/column_left'); + $data['footer'] = $this->load->controller('common/footer'); + + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + $data['action'] = $this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + + $data['text_connect_intro'] = sprintf($this->language->get('text_connect_intro'), Googleshopping::API_URL); + + $data['current_step'] = 1; + $data['steps'] = $this->load->view('extension/advertise/google_steps', $data); + + $this->response->setOutput($this->load->view('extension/advertise/google_connect', $data)); + } + + public function disconnect() { + $this->load->language('extension/advertise/google'); + + if ($this->validatePermission()) { + try { + $this->load->model('setting/setting'); + + $this->googleshopping->disconnect(); + + foreach ($this->googleshopping->getTargets($this->store_id) as $target) { + $this->googleshopping->deleteTarget($target['target_id']); + } + + $setting = $this->model_setting_setting->getSetting('advertise_google', $this->store_id); + + unset($setting['advertise_google_status']); + unset($setting['advertise_google_work']); + unset($setting['advertise_google_access_token']); + unset($setting['advertise_google_refresh_token']); + unset($setting['advertise_google_gmc_account_selected']); + unset($setting['advertise_google_gmc_shipping_taxes_configured']); + unset($setting['advertise_google_can_edit_campaigns']); + + $this->model_setting_setting->editSetting('advertise_google', $setting, $this->store_id); + + $this->session->data['success'] = $this->language->get('success_disconnect'); + } catch (ConnectionException $e) { + $this->session->data['error'] = $e->getMessage(); + + $this->response->redirect($this->url->link('extension/advertise/google/connect', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } catch (\RuntimeException $e) { + $this->session->data['error'] = $e->getMessage(); + } + } else { + $this->session->data['error'] = $this->error['warning']; + } + + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + + public function checklist() { + $this->load->language('extension/advertise/google'); + + $this->document->setTitle($this->language->get('heading_title')); + + if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validatePermission()) { + $this->load->model('setting/setting'); + + $this->model_setting_setting->editSetting('advertise_google', $this->request->post, $this->store_id); + + $this->response->redirect($this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true)); + } + + $data = array(); + + $data['error'] = ''; + + if (isset($this->session->data['error'])) { + $data['error'] = $this->session->data['error']; + unset($this->session->data['error']); + } else if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + $data['breadcrumbs'] = array(); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_home'), + 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('text_extensions'), + 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true), + ); + $data['breadcrumbs'][] = array( + 'text' => $this->language->get('heading_title'), + 'href' => $this->url->link('extension/advertise/google', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true), + ); + + $data['text_panel_heading'] = sprintf($this->language->get('text_panel_heading'), $this->googleshopping->getStoreName()); + + $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=advertise', true); + $data['action'] = $this->url->link('extension/advertise/google/checklist', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'], true); + + $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/advertise/google_checklist', $data)); + } + + public function popup_product() { + $json = array( + 'body' => '', + 'title' => '', + 'success' => false, + 'required_fields' => [], + 'success_message' => '' + ); + + $this->language->load('extension/advertise/google'); + + $this->load->model('extension/advertise/google'); + + $operand_info = NULL; + $form_data = NULL; + $filter_data = NULL; + $product_ids = array(); + + if ($this->request->post['operand']['type'] == 'single') { + $product_advertise_google_id = $this->request->post['operand']['data']; + + $product_info = $this->model_extension_advertise_google->getProductByProductAdvertiseGoogleId($product_advertise_google_id); + + if ($product_info !== NULL) { + $json['product_id'] = $product_info['product_id']; + + // Required variables: + $operand_info = array( + 'title' => sprintf($this->language->get('text_popup_title_single'), $product_info['name'], $product_info['model']) + ); + + $required_fields = $this->model_extension_advertise_google->getRequiredFieldsByProductIds(array($product_info['product_id']), $this->store_id); + + if ($this->request->post['action'] == 'submit') { + $form_data = array_merge($this->request->post['form'], array( + 'product_id' => $product_info['product_id'] + )); + } + + $options = $this->model_extension_advertise_google->getProductOptionsByProductIds(array($product_info['product_id'])); + + $default_form_data = $this->model_extension_advertise_google->getProductAdvertiseGoogle($product_advertise_google_id); + } + } else if ($this->request->post['operand']['type'] == 'multiple') { + if (!empty($this->request->post['operand']['data']['all_pages'])) { + $filter_data = $this->getFilter($this->request->post['operand']['data']['filter']); + + $total_products = $this->googleshopping->getTotalProducts($filter_data, $this->store_id); + + // Required variables: + $operand_info = array( + 'title' => sprintf($this->language->get('text_popup_title_multiple'), $total_products) + ); + + $required_fields = $this->model_extension_advertise_google->getRequiredFieldsByFilter($filter_data, $this->store_id); + + if ($this->request->post['action'] == 'submit') { + $form_data = $this->request->post['form']; + } + + $options = $this->model_extension_advertise_google->getProductOptionsByFilter($filter_data); + } else { + $product_ids = $this->request->post['operand']['data']['select']; + + $total_products = count($product_ids); + + // Required variables: + $operand_info = array( + 'title' => sprintf($this->language->get('text_popup_title_multiple'), $total_products) + ); + + $required_fields = $this->model_extension_advertise_google->getRequiredFieldsByProductIds($product_ids, $this->store_id); + + if ($this->request->post['action'] == 'submit') { + $form_data = $this->request->post['form']; + } + + $options = $this->model_extension_advertise_google->getProductOptionsByProductIds($product_ids); + } + + $default_form_data = array( + 'google_product_category' => '', + 'condition' => '', + 'adult' => '', + 'multipack' => '', + 'is_bundle' => '', + 'age_group' => '', + 'color' => '', + 'gender' => '', + 'size_type' => '', + 'size_system' => '', + 'size' => '' + ); + } + + if ($operand_info !== NULL) { + $json['title'] = $operand_info['title']; + $json['success_message'] = $this->language->get('success_product'); + + $this->load->config('googleshopping/googleshopping'); + + $json['required_fields'] = $required_fields; + + if ($this->request->post['action'] == 'submit' && $this->validateProduct($required_fields)) { + $form_data['store_id'] = (int)$this->store_id; + + if ($this->request->post['operand']['type'] == 'single') { + $this->model_extension_advertise_google->updateSingleProductFields($form_data); + } else if ($this->request->post['operand']['type'] == 'multiple') { + if (!empty($this->request->post['operand']['data']['all_pages'])) { + $this->model_extension_advertise_google->updateMultipleProductFields($filter_data, $form_data); + } else { + foreach ($product_ids as $product_id) { + $form_data['product_id'] = (int)$product_id; + $this->model_extension_advertise_google->updateSingleProductFields($form_data); + } + } + } + + $json['success'] = true; + } + + $data['error'] = ''; + + if (!empty($this->error['warning'])) { + $data['error'] = $this->error['warning']; + } + + if (isset($this->error['color'])) { + $data['error_color'] = $this->error['color']; + } else { + $data['error_color'] = ''; + } + + if (isset($this->error['size_system'])) { + $data['error_size_system'] = $this->error['size_system']; + } else { + $data['error_size_system'] = ''; + } + + if (isset($this->error['size_type'])) { + $data['error_size_type'] = $this->error['size_type']; + } else { + $data['error_size_type'] = ''; + } + + if (isset($this->error['size'])) { + $data['error_size'] = $this->error['size']; + } else { + $data['error_size'] = ''; + } + + if (isset($this->error['product_category'])) { + $data['error_product_category'] = $this->error['product_category']; + } else { + $data['error_product_category'] = ''; + } + + if (isset($this->error['condition'])) { + $data['error_condition'] = $this->error['condition']; + } else { + $data['error_condition'] = ''; + } + + if (isset($this->error['age_group'])) { + $data['error_age_group'] = $this->error['age_group']; + } else { + $data['error_age_group'] = ''; + } + + if (isset($this->error['gender'])) { + $data['error_gender'] = $this->error['gender']; + } else { + $data['error_gender'] = ''; + } + + if (isset($this->error['adult'])) { + $data['error_adult'] = $this->error['adult']; + } else { + $data['error_adult'] = ''; + } + + if (isset($this->error['multipack'])) { + $data['error_multipack'] = $this->error['multipack']; + } else { + $data['error_multipack'] = ''; + } + + if (isset($this->error['is_bundle'])) { + $data['error_is_bundle'] = $this->error['is_bundle']; + } else { + $data['error_is_bundle'] = ''; + } + + $data['google_product_categories'] = $this->config->get('advertise_google_google_product_categories'); + $data['conditions'] = array( + 'new' => $this->language->get('text_condition_new'), + 'refurbished' => $this->language->get('text_condition_refurbished'), + 'used' => $this->language->get('text_condition_used') + ); + $data['age_groups'] = array( + '' => $this->language->get('text_does_not_apply'), + 'newborn' => $this->language->get('text_age_group_newborn'), + 'infant' => $this->language->get('text_age_group_infant'), + 'toddler' => $this->language->get('text_age_group_toddler'), + 'kids' => $this->language->get('text_age_group_kids'), + 'adult' => $this->language->get('text_age_group_adult') + ); + $data['genders'] = array( + 'unisex' => $this->language->get('text_gender_unisex'), + 'female' => $this->language->get('text_gender_female'), + 'male' => $this->language->get('text_gender_male') + ); + $data['size_systems'] = array( + '' => $this->language->get('text_does_not_apply') + ); + foreach ($this->config->get('advertise_google_size_systems') as $system) { + $data['size_systems'][$system] = $system; + } + + $data['size_types'] = array( + '' => $this->language->get('text_does_not_apply'), + 'regular' => $this->language->get('text_size_type_regular'), + 'petite' => $this->language->get('text_size_type_petite'), + 'plus' => $this->language->get('text_size_type_plus'), + 'big and tall' => $this->language->get('text_size_type_big_and_tall'), + 'maternity' => $this->language->get('text_size_type_maternity') + ); + + $data['options'] = array( + '' => $this->language->get('text_does_not_apply') + ); + + foreach ($options as $option) { + $data['options'][$option['option_id']] = $option['name']; + } + + $data['required_fields'] = json_encode($required_fields); + + if ($this->request->post['action'] == 'submit') { + $form_data = $this->request->post['form']; + } else { + $form_data = $default_form_data; + } + + $data['google_product_category'] = $form_data['google_product_category']; + $data['condition'] = $form_data['condition']; + $data['adult'] = $form_data['adult']; + $data['multipack'] = $form_data['multipack']; + $data['is_bundle'] = $form_data['is_bundle']; + $data['age_group'] = $form_data['age_group']; + $data['color'] = $form_data['color']; + $data['gender'] = $form_data['gender']; + $data['size_type'] = $form_data['size_type']; + $data['size_system'] = $form_data['size_system']; + $data['size'] = $form_data['size']; + + $json['body'] = $this->load->view('extension/advertise/google_popup_product', $data); + } else { + $json['title'] = $this->language->get('error_popup_not_found_title'); + $json['body'] = $this->language->get('error_popup_not_found_body'); + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function popup_issues() { + $json = array( + 'body' => '', + 'title' => '' + ); + + $this->language->load('extension/advertise/google'); + + $this->load->model('catalog/product'); + $this->load->model('extension/advertise/google'); + + $product_id = isset($this->request->get['product_id']) ? (int)$this->request->get['product_id'] : 0; + + $product_issues = $this->model_extension_advertise_google->getProductIssues($product_id, $this->store_id); + + if ($product_issues !== NULL) { + $json['title'] = sprintf($this->language->get('text_popup_title_single'), $product_issues['name'], $product_issues['model']); + + $data['product_issues'] = $product_issues['entries']; + + $json['body'] = $this->load->view('extension/advertise/google_popup_issues', $data); + } else { + $json['title'] = $this->language->get('error_popup_not_found_title'); + $json['body'] = $this->language->get('error_popup_not_found_body'); + } + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + public function admin_link(&$route, &$data, &$template) { + if (!$this->user->hasPermission('access', 'extension/advertise/google')) { + return; + } + + foreach ($data['menus'] as &$menu) { + if ($menu['id'] == 'menu-marketing') { + $children = array(); + + $this->load->model('setting/store'); + + $children[] = array( + 'name' => $this->config->get('config_name'), + 'children' => array(), + 'href' => $this->url->link('extension/advertise/google', 'store_id=0&user_token=' . $this->session->data['user_token'], true) + ); + + foreach ($this->model_setting_store->getStores() as $store) { + $children[] = array( + 'name' => $store['name'], + 'children' => array(), + 'href' => $this->url->link('extension/advertise/google', 'store_id=' . $store['store_id'] . '&user_token=' . $this->session->data['user_token'], true) + ); + } + + array_push($menu['children'], array( + 'name' => 'Google Shopping', + 'children' => $children, + 'href' => '' + )); + + return; + } + } + } + + public function addProduct(&$route, &$args, &$output) { + $this->load->model('extension/advertise/google'); + $this->load->model('catalog/product'); + + foreach ($this->model_catalog_product->getProductStores($output) as $store_id) { + $this->model_extension_advertise_google->insertNewProducts(array($output), $store_id); + } + } + + public function copyProduct(&$route, &$args, &$output) { + $this->load->model('extension/advertise/google'); + $this->load->model('catalog/product'); + + $final_product_id = $this->model_extension_advertise_google->getFinalProductId(); + + if (!empty($final_product_id)) { + foreach ($this->model_catalog_product->getProductStores($final_product_id) as $store_id) { + $this->model_extension_advertise_google->insertNewProducts(array($final_product_id), $store_id); + } + } + } + + public function deleteProduct(&$route, &$args, &$output) { + $this->load->model('extension/advertise/google'); + + $this->model_extension_advertise_google->deleteProducts(array((int)$args[0])); + } + + public function install() { + $this->load->model('extension/advertise/google'); + + $this->model_extension_advertise_google->createTables(); + $this->model_extension_advertise_google->createEvents(); + } + + public function uninstall() { + $this->load->model('extension/advertise/google'); + + $this->model_extension_advertise_google->dropTables(); + $this->model_extension_advertise_google->deleteEvents(); + } + + public function category_autocomplete() { + $json = array(); + + if (isset($this->request->get['filter_name'])) { + $this->load->model('extension/advertise/google'); + + $filter_data = array( + 'filter_name' => $this->request->get['filter_name'], + 'sort' => 'name', + 'order' => 'ASC', + 'start' => 0, + 'limit' => 5 + ); + + $results = $this->model_extension_advertise_google->getCategories($filter_data, $this->store_id); + + foreach ($results as $result) { + $json[] = array( + 'category_id' => $result['category_id'], + 'name' => strip_tags(html_entity_decode($result['name'], ENT_QUOTES, 'UTF-8')) + ); + } + } + + $sort_order = array(); + + foreach ($json as $key => $value) { + $sort_order[$key] = $value['name']; + } + + array_multisort($sort_order, SORT_ASC, $json); + + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($json)); + } + + protected function getFilter($array) { + if (!empty($array)) { + return array( + 'filter_product_name' => $array['product_name'], + 'filter_product_model' => $array['product_model'], + 'filter_category_id' => $array['category_id'], + 'filter_is_modified' => $array['is_modified'], + 'filter_store_id' => $this->store_id + ); + } + + return array( + 'filter_store_id' => $this->store_id + ); + } + + protected function applyNewSettings($new_settings) { + $this->load->model('setting/setting'); + + $old_settings = $this->model_setting_setting->getSetting('advertise_google', $this->store_id); + + $new_settings = array_merge($old_settings, $new_settings); + + $this->model_setting_setting->editSetting('advertise_google', $new_settings, $this->store_id); + + foreach ($new_settings as $key => $value) { + $this->setting->set($key, $value); + } + } + + protected function product(&$row) { + $this->load->config('googleshopping/googleshopping'); + + $this->load->model('tool/image'); + + if (!empty($row['image']) && file_exists(DIR_IMAGE . $row['image'])) { + $image = $this->model_tool_image->resize($row['image'], 50, 50); + } else { + $image = $this->model_tool_image->resize('no_image.png', 50, 50); + } + + return array( + 'product_advertise_google_id' => (int)$row['product_advertise_google_id'], + 'product_id' => (int)$row['product_id'], + 'image' => $image, + 'name' => htmlentities(html_entity_decode($row['name'], ENT_QUOTES, 'UTF-8'), ENT_QUOTES, 'UTF-8'), + 'model' => $row['model'], + 'impressions' => (int)$row['impressions'], + 'clicks' => (int)$row['clicks'], + 'conversions' => (int)$row['conversions'], + 'cost' => $this->googleshopping->currencyFormat($row['cost']), + 'conversion_value' => $this->googleshopping->currencyFormat($row['conversion_value']), + 'destination_status' => $row['destination_status'], + 'is_modified' => (bool)$row['is_modified'], + 'has_issues' => (bool)$row['has_issues'], + 'url_issues' => html_entity_decode($this->url->link('extension/advertise/google/popup_issues', 'store_id=' . $this->store_id . '&user_token=' . $this->session->data['user_token'] . '&product_id=' . $row['product_id'], true), ENT_QUOTES, 'UTF-8'), + 'campaigns' => $this->model_extension_advertise_google->getProductCampaigns((int)$row['product_id'], $this->store_id) + ); + } + + protected function getSettingValue($key, $default = null, $checkbox = false) { + if ($checkbox) { + if ($this->request->server['REQUEST_METHOD'] == 'POST' && !isset($this->request->post[$key])) { + return $default; + } else { + return $this->setting->get($key); + } + } + + if (isset($this->request->post[$key])) { + return $this->request->post[$key]; + } else if ($this->setting->has($key)) { + return $this->setting->get($key); + } else { + return $default; + } + } + + protected function getValidationError($key) { + if (isset($this->error[$key])) { + return $this->error[$key]; + } else { + return ''; + } + } + + protected function validateSettings() { + $this->validatePermission(); + + if (empty($this->request->post['advertise_google_status'])) { + return true; + } + + if (!empty($this->request->post['advertise_google_cron_email_status'])) { + if (!filter_var($this->request->post['advertise_google_cron_email'], FILTER_VALIDATE_EMAIL)) { + $this->error['cron_email'] = $this->language->get('error_invalid_email'); + } + } + + if (empty($this->request->post['advertise_google_cron_acknowledge'])) { + $this->error['cron_acknowledge'] = $this->language->get('error_cron_acknowledge'); + } + + if ($this->error && empty($this->error['warning'])) { + $this->error['warning'] = $this->language->get('error_form'); + } + + return !$this->error; + } + + protected function validateShippingAndTaxes() { + $this->validatePermission(); + + if (empty($this->request->post['advertise_google_shipping_taxes']['min_transit_time']) || !is_numeric($this->request->post['advertise_google_shipping_taxes']['min_transit_time']) || (int)$this->request->post['advertise_google_shipping_taxes']['min_transit_time'] < 0) { + $this->error['min_transit_time'] = $this->language->get('error_min_transit_time'); + } else if (empty($this->request->post['advertise_google_shipping_taxes']['max_transit_time']) || !is_numeric($this->request->post['advertise_google_shipping_taxes']['max_transit_time']) || (int)$this->request->post['advertise_google_shipping_taxes']['max_transit_time'] < (int)$this->request->post['advertise_google_shipping_taxes']['min_transit_time']) { + $this->error['max_transit_time'] = $this->language->get('error_max_transit_time'); + } + + switch ($this->request->post['advertise_google_shipping_taxes']['shipping_type']) { + case 'flat' : + if (!isset($this->request->post['advertise_google_shipping_taxes']['flat_rate']) || !is_numeric($this->request->post['advertise_google_shipping_taxes']['flat_rate']) || (float)$this->request->post['advertise_google_shipping_taxes']['flat_rate'] <= 0) { + $this->error['flat_rate'] = $this->language->get('error_flat_rate'); + } + break; + case 'carrier' : + if (empty($this->request->post['advertise_google_shipping_taxes']['carrier'])) { + $this->error['warning'] = $this->language->get('error_carrier'); + } + + if (empty($this->request->post['advertise_google_shipping_taxes']['carrier_postcode'])) { + $this->error['carrier_postcode'] = $this->language->get('error_carrier_postcode'); + } + + if (!isset($this->request->post['advertise_google_shipping_taxes']['carrier_price_percentage']) || !is_numeric($this->request->post['advertise_google_shipping_taxes']['carrier_price_percentage']) || (float)$this->request->post['advertise_google_shipping_taxes']['carrier_price_percentage'] < 0 || (float)$this->request->post['advertise_google_shipping_taxes']['carrier_price_percentage'] > 100) { + $this->error['carrier_price_percentage'] = $this->language->get('error_carrier_price_percentage'); + } + break; + } + + switch ($this->request->post['advertise_google_shipping_taxes']['tax_type']) { + case 'usa' : + if (empty($this->request->post['advertise_google_shipping_taxes']['tax'])) { + $this->error['warning'] = $this->language->get('error_tax'); + } + break; + } + + if (!isset($this->error['warning']) && $this->error) { + $this->error['warning'] = $this->language->get('error_warning'); + } + + return !$this->error; + } + + protected function validateMapping() { + $this->validatePermission(); + + if (!isset($this->error['warning']) && $this->error) { + $this->error['warning'] = $this->language->get('error_warning'); + } + + return !$this->error; + } + + protected function validateProduct($required_fields) { + if (!$this->user->hasPermission('modify', 'extension/advertise/google')) { + $this->error['warning'] = $this->language->get('error_permission'); + } + + if (empty($this->error)) { + foreach ($required_fields as $key => $requirements) { + if (empty($requirements['selected_field']) && (!isset($this->request->post['form'][$key]) || $this->request->post['form'][$key] == '')) { + $this->error[$key] = $this->language->get('error_field_no_value'); + } else if (!empty($requirements['selected_field'])) { + foreach ($requirements['selected_field'] as $dependency => $values) { + if (in_array($this->request->post['form'][$dependency], $values) && (!isset($this->request->post['form'][$key]) || $this->request->post['form'][$key] == '')) { + $this->error[$key] = $this->language->get('error_field_no_value'); + } + } + } + } + } + + if (!isset($this->error['warning']) && $this->error) { + $this->error['warning'] = $this->language->get('error_warning'); + } + + return !$this->error; + } + + protected function validatePermission() { + if (!$this->user->hasPermission('modify', 'extension/advertise/google')) { + $this->error['warning'] = $this->language->get('error_permission'); + } + + return !$this->error; + } + + protected function validateCampaign() { + $this->validatePermission(); + + $this->load->model('extension/advertise/google'); + + $targets = $this->googleshopping->getTargets($this->store_id); + + if (empty($targets)) { + $this->error['warning'] = $this->language->get('error_no_targets'); + } + + if (!isset($this->error['warning']) && $this->error) { + $this->error['warning'] = $this->language->get('error_warning'); + } + + return !$this->error; + } + + protected function validateConnect() { + $this->validatePermission(); + + if (!isset($this->request->post['advertise_google_app_id']) || trim($this->request->post['advertise_google_app_id']) == '') { + $this->error['app_id'] = $this->language->get('error_empty_app_id'); + } else if ($this->model_extension_advertise_google->isAppIdUsed($this->request->post['advertise_google_app_id'], $this->store_id)) { + $this->error['app_id'] = $this->language->get('error_used_app_id'); + } + + if (!isset($this->request->post['advertise_google_app_secret']) || trim($this->request->post['advertise_google_app_secret']) == '') { + $this->error['app_secret'] = $this->language->get('error_empty_app_secret'); + } + + if (!isset($this->error['warning']) && $this->error) { + $this->error['warning'] = $this->language->get('error_warning'); + } + + return !$this->error; + } + + protected function validateTarget() { + $this->validatePermission(); + + if (!isset($this->request->post['budget']) || !is_numeric($this->request->post['budget']) || (float)$this->request->post['budget'] < 5) { + $this->error['budget'] = $this->language->get('error_budget'); + } + + if (empty($this->request->post['feed']) || !is_array($this->request->post['feed'])) { + $this->error['feed'] = $this->language->get('error_empty_feed'); + } else { + foreach ($this->request->post['feed'] as $feed) { + if (empty($feed['language']) || empty($feed['currency'])) { + $this->error['feed'] = $this->language->get('error_invalid_feed'); + break; + } + } + } + + if (empty($this->request->post['country'])) { + $this->error['country'] = $this->language->get('error_empty_country'); + } + + if (empty($this->request->post['campaign_name']) || trim($this->request->post['campaign_name']) == '') { + $this->error['campaign_name'] = $this->language->get('error_empty_campaign_name'); + } else { + $disallowed_names = []; + + $this->load->model('extension/advertise/google'); + + foreach ($this->googleshopping->getTargets($this->store_id) as $existing_target) { + if (isset($this->request->get['advertise_google_target_id']) && $existing_target['target_id'] == $this->request->get['advertise_google_target_id']) { + // Ignore this target as it is currntly being edited + continue; + } + + $disallowed_names[] = strtolower(str_replace(',', ',', trim($existing_target['campaign_name']))); + } + + if (in_array(trim(strtolower($this->request->post['campaign_name'])), $disallowed_names)) { + $this->error['campaign_name'] = $this->language->get('error_campaign_name_in_use'); + } + + if (strtolower(trim($this->request->post['campaign_name'])) == 'total') { + $this->error['campaign_name'] = $this->language->get('error_campaign_name_total'); + } + } + + if (!isset($this->error['warning']) && $this->error) { + $this->error['warning'] = $this->language->get('error_warning'); + } + + return !$this->error; + } +}
\ No newline at end of file |