amazon_product.php (22729B)
1 <?php 2 class ControllerExtensionOpenbayAmazonProduct extends Controller { 3 public function index() { 4 $data = $this->load->language('catalog/product'); 5 $data = $this->load->language('extension/openbay/amazon_listing', $data); 6 7 $this->load->model('extension/openbay/amazon'); 8 $this->load->model('catalog/product'); 9 $this->load->model('tool/image'); 10 11 $this->document->addScript('view/javascript/openbay/js/openbay.js'); 12 $this->document->setTitle($this->language->get('heading_title')); 13 14 $data['breadcrumbs'] = array(); 15 16 $data['breadcrumbs'][] = array( 17 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true), 18 'text' => $this->language->get('text_home'), 19 ); 20 21 $data['breadcrumbs'][] = array( 22 'href' => $this->url->link('marketplace/openbay', 'user_token=' . $this->session->data['user_token'], true), 23 'text' => $this->language->get('text_openbay'), 24 ); 25 26 $data['breadcrumbs'][] = array( 27 'href' => $this->url->link('extension/openbay/amazon', 'user_token=' . $this->session->data['user_token'], true), 28 'text' => $this->language->get('text_amazon'), 29 ); 30 31 $data['breadcrumbs'][] = array( 32 'href' => $this->url->link('extension/openbay/amazon_listing/create', 'user_token=' . $this->session->data['user_token'], true), 33 'text' => $this->language->get('heading_title'), 34 ); 35 36 $data['breadcrumbs'][] = array( 37 'href' => $this->url->link('extension/openbay/amazon_product', 'user_token=' . $this->session->data['user_token'], true), 38 'text' => $this->language->get('text_title_advanced'), 39 ); 40 41 $url = ''; 42 43 if (isset($this->request->get['filter_name'])) { 44 $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8')); 45 } 46 47 if (isset($this->request->get['filter_model'])) { 48 $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8')); 49 } 50 51 if (isset($this->request->get['filter_price'])) { 52 $url .= '&filter_price=' . $this->request->get['filter_price']; 53 } 54 55 if (isset($this->request->get['filter_price_to'])) { 56 $url .= '&filter_price_to=' . $this->request->get['filter_price_to']; 57 } 58 59 if (isset($this->request->get['filter_quantity'])) { 60 $url .= '&filter_quantity=' . $this->request->get['filter_quantity']; 61 } 62 63 if (isset($this->request->get['filter_quantity_to'])) { 64 $url .= '&filter_quantity_to=' . $this->request->get['filter_quantity_to']; 65 } 66 67 if (isset($this->request->get['filter_status'])) { 68 $url .= '&filter_status=' . $this->request->get['filter_status']; 69 } 70 71 if (isset($this->request->get['filter_sku'])) { 72 $url .= '&filter_sku=' . $this->request->get['filter_sku']; 73 } 74 75 if (isset($this->request->get['filter_desc'])) { 76 $url .= '&filter_desc=' . $this->request->get['filter_desc']; 77 } 78 79 if (isset($this->request->get['filter_category'])) { 80 $url .= '&filter_category=' . $this->request->get['filter_category']; 81 } 82 83 if (isset($this->request->get['filter_manufacturer'])) { 84 $url .= '&filter_manufacturer=' . $this->request->get['filter_manufacturer']; 85 } 86 87 if (isset($this->request->get['sort'])) { 88 $url .= '&sort=' . $this->request->get['sort']; 89 } 90 91 if (isset($this->request->get['order'])) { 92 $url .= '&order=' . $this->request->get['order']; 93 } 94 95 if (isset($this->request->get['page'])) { 96 $url .= '&page=' . $this->request->get['page']; 97 } 98 99 if (isset($this->request->get['product_id'])) { 100 $product_id = $this->request->get['product_id']; 101 } else { 102 die('No product id'); 103 } 104 105 if (isset($this->request->get['sku'])) { 106 $variation = $this->request->get['sku']; 107 } else { 108 $variation = ''; 109 } 110 $data['variation'] = $variation; 111 $data['errors'] = array(); 112 113 if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validateForm()) { 114 $data_array = $this->request->post; 115 116 $this->model_extension_openbay_amazon->saveProduct($product_id, $data_array); 117 118 if ($data_array['upload_after'] === 'true') { 119 $upload_result = $this->uploadItems(); 120 if ($upload_result['status'] == 'ok') { 121 $this->session->data['success'] = $this->language->get('text_uploaded'); 122 $this->response->redirect($this->url->link('marketplace/openbay/items', 'user_token=' . $this->session->data['user_token'] . $url, true)); 123 } else { 124 $data['errors'][] = Array('message' => $upload_result['error_message']); 125 } 126 } else { 127 $this->session->data['success'] = $this->language->get('text_saved_local'); 128 $this->response->redirect($this->url->link('extension/openbay/amazon_product', 'user_token=' . $this->session->data['user_token'] . '&product_id=' . $product_id . $url, true)); 129 } 130 } 131 132 if (isset($this->session->data['success'])) { 133 $data['success'] = $this->session->data['success']; 134 unset($this->session->data['success']); 135 } else { 136 $data['success'] = ''; 137 } 138 139 $saved_listing_data = $this->model_extension_openbay_amazon->getProduct($product_id, $variation); 140 if (empty($saved_listing_data)) { 141 $listing_saved = false; 142 } else { 143 $listing_saved = true; 144 } 145 146 $errors = $this->model_extension_openbay_amazon->getProductErrors($product_id); 147 foreach($errors as $error) { 148 $error['message'] = 'Error for SKU: "' . $error['sku'] . '" - ' . $this->formatUrlsInText($error['message']); 149 $data['errors'][] = $error; 150 } 151 if (!empty($errors)) { 152 $data['has_listing_errors'] = true; 153 } else { 154 $data['has_listing_errors'] = false; 155 } 156 157 $product_info = $this->model_catalog_product->getProduct($product_id); 158 $data['listing_name'] = $product_info['name'] . " : " . $product_info['model']; 159 $data['listing_sku'] = $product_info['sku']; 160 $data['listing_url'] = $this->url->link('catalog/product/edit', 'user_token=' . $this->session->data['user_token'] . '&product_id=' . $product_id . $url, true); 161 162 if ($listing_saved) { 163 $data['edit_product_category'] = $saved_listing_data['category']; 164 } else { 165 $data['edit_product_category'] = ''; 166 } 167 168 $data['amazon_categories'] = array(); 169 170 $amazon_templates = $this->openbay->amazon->getCategoryTemplates(); 171 172 foreach($amazon_templates as $template) { 173 $template = (array)$template; 174 $category_data = array( 175 'friendly_name' => $template['friendly_name'], 176 'name' => $template['name'], 177 'template' => $template['xml'] 178 ); 179 $data['amazon_categories'][] = $category_data; 180 } 181 182 if ($listing_saved) { 183 $data['template_parser_url'] = $this->url->link('extension/openbay/amazon_product/parseTemplateAjax&edit_id=' . $product_id, 'user_token=' . $this->session->data['user_token'], true); 184 } else { 185 $data['template_parser_url'] = $this->url->link('extension/openbay/amazon_product/parseTemplateAjax&product_id=' . $product_id, 'user_token=' . $this->session->data['user_token'], true); 186 } 187 188 $data['url_remove_errors'] = $this->url->link('extension/openbay/amazon_product/removeErrors', 'user_token=' . $this->session->data['user_token'] . '&product_id=' . $product_id . $url, true); 189 $data['cancel_url'] = $this->url->link('marketplace/openbay/items', 'user_token=' . $this->session->data['user_token'] . $url, true); 190 $data['saved_listings_url'] = $this->url->link('extension/openbay/amazon/savedListings', 'user_token=' . $this->session->data['user_token'], true); 191 $data['main_url'] = $this->url->link('extension/openbay/amazon_product', 'user_token=' . $this->session->data['user_token'] . $url, true); 192 $data['user_token'] = $this->session->data['user_token']; 193 $data['no_image'] = $this->model_tool_image->resize('no_image.png', 100, 100); 194 195 if ($this->openbay->addonLoad('openstock')) { 196 $this->load->model('extension/module/openstock'); 197 $data['options'] = $this->model_setting_module_openstock->getVariants($product_id); 198 } else { 199 $data['options'] = array(); 200 } 201 202 $data['marketplaces'] = array( 203 array('name' => $this->language->get('text_germany'), 'id' => 'A1PA6795UKMFR9', 'code' => 'de'), 204 array('name' => $this->language->get('text_france'), 'id' => 'A13V1IB3VIYZZH', 'code' => 'fr'), 205 array('name' => $this->language->get('text_italy'), 'id' => 'APJ6JRA9NG5V4', 'code' => 'it'), 206 array('name' => $this->language->get('text_spain'), 'id' => 'A1RKKUPIHCS9HS', 'code' => 'es'), 207 array('name' => $this->language->get('text_united_kingdom'), 'id' => 'A1F83G8C2ARO7P', 'code' => 'uk'), 208 ); 209 210 $marketplace_mapping = array( 211 'uk' => 'A1F83G8C2ARO7P', 212 'de' => 'A1PA6795UKMFR9', 213 'fr' => 'A13V1IB3VIYZZH', 214 'it' => 'APJ6JRA9NG5V4', 215 'es' => 'A1RKKUPIHCS9HS', 216 ); 217 218 if ($this->config->get('openbay_amazon_default_listing_marketplace')) { 219 $data['default_marketplaces'] = array($marketplace_mapping[$this->config->get('openbay_amazon_default_listing_marketplace')]); 220 } else { 221 $data['default_marketplaces'] = array(); 222 } 223 224 $data['saved_marketplaces'] = isset($saved_listing_data['marketplaces']) ? (array)unserialize($saved_listing_data['marketplaces']) : false; 225 226 $data['header'] = $this->load->controller('common/header'); 227 $data['column_left'] = $this->load->controller('common/column_left'); 228 $data['footer'] = $this->load->controller('common/footer'); 229 230 $this->response->setOutput($this->load->view('extension/openbay/amazon_listing_advanced', $data)); 231 } 232 233 public function removeErrors() { 234 $url = ''; 235 236 if (isset($this->request->get['filter_name'])) { 237 $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8')); 238 } 239 240 if (isset($this->request->get['filter_model'])) { 241 $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8')); 242 } 243 244 if (isset($this->request->get['filter_price'])) { 245 $url .= '&filter_price=' . $this->request->get['filter_price']; 246 } 247 248 if (isset($this->request->get['filter_price_to'])) { 249 $url .= '&filter_price_to=' . $this->request->get['filter_price_to']; 250 } 251 252 if (isset($this->request->get['filter_quantity'])) { 253 $url .= '&filter_quantity=' . $this->request->get['filter_quantity']; 254 } 255 256 if (isset($this->request->get['filter_quantity_to'])) { 257 $url .= '&filter_quantity_to=' . $this->request->get['filter_quantity_to']; 258 } 259 260 if (isset($this->request->get['filter_status'])) { 261 $url .= '&filter_status=' . $this->request->get['filter_status']; 262 } 263 264 if (isset($this->request->get['filter_sku'])) { 265 $url .= '&filter_sku=' . $this->request->get['filter_sku']; 266 } 267 268 if (isset($this->request->get['filter_desc'])) { 269 $url .= '&filter_desc=' . $this->request->get['filter_desc']; 270 } 271 272 if (isset($this->request->get['filter_category'])) { 273 $url .= '&filter_category=' . $this->request->get['filter_category']; 274 } 275 276 if (isset($this->request->get['filter_manufacturer'])) { 277 $url .= '&filter_manufacturer=' . $this->request->get['filter_manufacturer']; 278 } 279 280 if (isset($this->request->get['sort'])) { 281 $url .= '&sort=' . $this->request->get['sort']; 282 } 283 284 if (isset($this->request->get['order'])) { 285 $url .= '&order=' . $this->request->get['order']; 286 } 287 288 if (isset($this->request->get['page'])) { 289 $url .= '&page=' . $this->request->get['page']; 290 } 291 292 if (isset($this->request->get['product_id'])) { 293 $product_id = $this->request->get['product_id']; 294 } else { 295 $this->response->redirect($this->url->link('marketplace/openbay/items', 'user_token=' . $this->session->data['user_token'] . $url, true)); 296 } 297 $this->load->model('extension/openbay/amazon'); 298 $this->model_extension_openbay_amazon->removeAdvancedErrors($product_id); 299 $this->session->data['success'] = 'Errors removed'; 300 $this->response->redirect($this->url->link('extension/openbay/amazon_product', 'user_token=' . $this->session->data['user_token'] . '&product_id=' . $product_id . $url, true)); 301 } 302 303 public function deleteSaved() { 304 if (!isset($this->request->get['product_id']) || !isset($this->request->get['var'])) { 305 return; 306 } 307 308 $this->load->model('extension/openbay/amazon'); 309 $this->model_extension_openbay_amazon->deleteSaved($this->request->get['product_id'], $this->request->get['var']); 310 } 311 312 public function uploadSaved() { 313 ob_start(); 314 $json = json_encode($this->uploadItems()); 315 ob_clean(); 316 317 $this->response->addHeader('Content-Type: application/json'); 318 $this->response->setOutput($json); 319 } 320 321 private function uploadItems() { 322 $this->load->language('extension/openbay/amazon_listing'); 323 $this->load->model('extension/openbay/amazon'); 324 $logger = new Log('amazon_product.log'); 325 326 $logger->write('Uploading process started . '); 327 328 $saved_products = $this->model_extension_openbay_amazon->getSavedProductsData(); 329 330 if (empty($saved_products)) { 331 $logger->write('No saved listings found. Uploading canceled . '); 332 $result['status'] = 'error'; 333 $result['error_message'] = 'No saved listings. Nothing to upload. Aborting . '; 334 return $result; 335 } 336 337 foreach($saved_products as $saved_product) { 338 $product_data_decoded = (array)json_decode($saved_product['data']); 339 340 $catalog = defined(HTTPS_CATALOG) ? HTTPS_CATALOG : HTTP_CATALOG; 341 $response_data = array("response_url" => $catalog . 'index.php?route=extension/openbay/amazon/product'); 342 $category_data = array('category' => (string)$saved_product['category']); 343 $fields_data = array('fields' => (array)$product_data_decoded['fields']); 344 345 $mp_array = !empty($saved_product['marketplaces']) ? (array)unserialize($saved_product['marketplaces']) : array(); 346 $marketplaces_data = array('marketplaces' => $mp_array); 347 348 $product_data = array_merge($category_data, $fields_data, $response_data, $marketplaces_data); 349 $insertion_response = $this->openbay->amazon->insertProduct($product_data); 350 351 $logger->write("Uploading product with data:" . print_r($product_data, true) . " 352 Got response:" . print_r($insertion_response, true)); 353 354 if (!isset($insertion_response['status']) || $insertion_response['status'] == 'error') { 355 $details = isset($insertion_response['info']) ? $insertion_response['info'] : 'Unknown'; 356 $result['error_message'] = sprintf($this->language->get('error_upload_failed'), $saved_product['product_sku'], $details); 357 $result['status'] = 'error'; 358 break; 359 } 360 $logger->write('Product upload success'); 361 $this->model_extension_openbay_amazon->setProductUploaded($saved_product['product_id'], $insertion_response['insertion_id'], $saved_product['sku']); 362 } 363 364 if (!isset($result['status'])) { 365 $result['status'] = 'ok'; 366 $logger->write('Uploading process completed successfully . '); 367 } else { 368 $logger->write('Uploading process failed with message: ' . $result['error_message']); 369 } 370 return $result; 371 } 372 373 public function parseTemplateAjax() { 374 $this->load->model('tool/image'); 375 376 $log = new Log('amazon_product.log'); 377 378 $json = array(); 379 380 if (isset($this->request->get['xml'])) { 381 $request = array('template' => $this->request->get['xml'], 'version' => 2); 382 $response = $this->openbay->amazon->call("productv2/GetTemplateXml", $request); 383 if ($response) { 384 $template = $this->openbay->amazon->parseCategoryTemplate($response); 385 if ($template) { 386 $variation = isset($this->request->get['sku']) ? $this->request->get['sku'] : ''; 387 388 if (isset($this->request->get['product_id'])) { 389 $template['fields'] = $this->fillDefaultValues($this->request->get['product_id'], $template['fields'], $variation); 390 } elseif (isset($this->request->get['edit_id'])) { 391 $template['fields'] = $this->fillSavedValues($this->request->get['edit_id'], $template['fields'], $variation); 392 } 393 394 foreach($template['fields'] as $key => $field) { 395 if ($field['accepted']['type'] == 'image') { 396 if (empty($field['value'])) { 397 $template['fields'][$key]['thumb'] = ''; 398 } else { 399 $template['fields'][$key]['thumb'] = $this->model_tool_image->resize(str_replace(HTTPS_CATALOG . 'image/', '', $field['value']), 100, 100); 400 } 401 } 402 } 403 404 $result = array( 405 "category" => $template['category'], 406 "fields" => $template['fields'], 407 "tabs" => $template['tabs'] 408 ); 409 } else { 410 $json_decoded = json_decode($response); 411 if ($json_decoded) { 412 $result = $json_decoded; 413 } else { 414 $result = array('status' => 'error'); 415 $log->write("admin/openbay/amazon_product/parseTemplateAjax failed to parse template response: " . $response); 416 } 417 } 418 } else { 419 $log->write("admin/openbay/amazon_product/parseTemplateAjax failed calling productv2/GetTemplateXml with params: " . print_r($request, true)); 420 } 421 } 422 423 $this->response->addHeader('Content-Type: application/json'); 424 $this->response->setOutput(json_encode($result)); 425 } 426 427 private function fillDefaultValues($product_id, $fields_array, $var = '') { 428 $this->load->model('catalog/product'); 429 $this->load->model('setting/setting'); 430 $this->load->model('extension/openbay/amazon'); 431 432 $openbay_settings = $this->model_setting_setting->getSetting('openbay_amazon'); 433 434 $product_info = $this->model_catalog_product->getProduct($product_id); 435 $product_info['description'] = trim(utf8_encode(strip_tags(html_entity_decode($product_info['description']), "<br>"))); 436 $product_info['image'] = HTTPS_CATALOG . 'image/' . $product_info['image']; 437 438 $tax_added = isset($openbay_settings['openbay_amazon_listing_tax_added']) ? $openbay_settings['openbay_amazon_listing_tax_added'] : 0; 439 $default_condition = isset($openbay_settings['openbay_amazon_listing_default_condition']) ? $openbay_settings['openbay_amazon_listing_default_condition'] : ''; 440 $product_info['price'] = number_format($product_info['price'] + $tax_added / 100 * $product_info['price'], 2, '.', ''); 441 442 $defaults = array( 443 'sku' => $product_info['sku'], 444 'title' => $product_info['name'], 445 'quantity' => $product_info['quantity'], 446 'standardprice' => $product_info['price'], 447 'description' => $product_info['description'], 448 'mainimage' => $product_info['image'], 449 'currency' => $this->config->get('config_currency'), 450 'shippingweight' => number_format($product_info['weight'], 2, '.', ''), 451 'conditiontype' => $default_condition, 452 ); 453 454 $this->load->model('localisation/weight_class'); 455 $weight_class = $this->model_localisation_weight_class->getWeightClass($product_info['weight_class_id']); 456 if (!empty($weight_class)) { 457 $defaults['shippingweightunitofmeasure'] = $weight_class['unit']; 458 } 459 460 $this->load->model('catalog/manufacturer'); 461 $manufacturer = $this->model_catalog_manufacturer->getManufacturer($product_info['manufacturer_id']); 462 if (!empty($manufacturer)) { 463 $defaults['manufacturer'] = $manufacturer['name']; 464 $defaults['brand'] = $manufacturer['name']; 465 } 466 467 $product_images = $this->model_catalog_product->getProductImages($product_id); 468 $image_index = 1; 469 foreach($product_images as $product_image) { 470 $defaults['pt' . $image_index] = HTTPS_CATALOG . 'image/' . $product_image['image']; 471 $image_index ++; 472 } 473 474 if (!empty($product_info['upc'])) { 475 $defaults['type'] = 'UPC'; 476 $defaults['value'] = $product_info['upc']; 477 } else if (!empty($product_info['ean'])) { 478 $defaults['type'] = 'EAN'; 479 $defaults['value'] = $product_info['ean']; 480 } 481 482 $meta_keywords = explode(',', $product_info['meta_keyword']); 483 foreach ($meta_keywords as $index => $meta_keyword) { 484 $defaults['searchterms' . $index] = trim($meta_keyword); 485 } 486 487 if ($var !== '' && $this->openbay->addonLoad('openstock')) { 488 $this->load->model('tool/image'); 489 $this->load->model('extension/module/openstock'); 490 $option_stocks = $this->model_setting_module_openstock->getVariants($product_id); 491 492 $option = ''; 493 494 foreach ($option_stocks as $option_iterator) { 495 if ($option_iterator['sku'] === $var) { 496 $option = $option_iterator; 497 break; 498 } 499 } 500 501 if ($option != '') { 502 $defaults['sku'] = $option['sku']; 503 $defaults['quantity'] = $option['stock']; 504 $defaults['standardprice'] = number_format($option['price'] + $tax_added / 100 * $option['price'], 2, '.', ''); 505 $defaults['shippingweight'] = number_format($option['weight'], 2, '.', ''); 506 507 if (!empty($option['image'])) { 508 $defaults['mainimage'] = HTTPS_CATALOG . 'image/' . $option['image']; 509 } 510 } 511 } 512 513 if ($defaults['shippingweight'] <= 0) { 514 unset($defaults['shippingweight']); 515 unset($defaults['shippingweightunitofmeasure']); 516 } 517 518 $filled_array = array(); 519 520 foreach($fields_array as $field) { 521 522 $value_array = array('value' => ''); 523 524 if (isset($defaults[strtolower($field['name'])])) { 525 $value_array = array('value' => $defaults[strtolower($field['name'])]); 526 } 527 528 $filled_item = array_merge($field, $value_array); 529 530 $filled_array[] = $filled_item; 531 } 532 return $filled_array; 533 } 534 535 private function fillSavedValues($product_id, $fields_array, $var = '') { 536 537 $this->load->model('extension/openbay/amazon'); 538 $saved_listing = $this->model_extension_openbay_amazon->getProduct($product_id, $var); 539 540 $decoded_data = (array)json_decode($saved_listing['data']); 541 $saved_fields = (array)$decoded_data['fields']; 542 543 //Show current quantity instead of last uploaded 544 $saved_fields['Quantity'] = $this->model_extension_openbay_amazon->getProductQuantity($product_id, $var); 545 546 $filled_array = array(); 547 548 foreach($fields_array as $field) { 549 $value_array = array('value' => ''); 550 551 if (isset($saved_fields[$field['name']])) { 552 $value_array = array('value' => $saved_fields[$field['name']]); 553 } 554 555 $filled_item = array_merge($field, $value_array); 556 557 $filled_array[] = $filled_item; 558 } 559 560 return $filled_array; 561 } 562 563 public function resetPending() { 564 $this->db->query("UPDATE `" . DB_PREFIX . "amazon_product` SET `status` = 'saved' WHERE `status` = 'uploaded'"); 565 } 566 567 private function validateForm() { 568 return true; 569 } 570 571 private function formatUrlsInText($text) { 572 $regex_url = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/"; 573 preg_match_all($regex_url, $text, $matches); 574 $used_patterns = array(); 575 foreach($matches[0] as $pattern) { 576 if (!array_key_exists($pattern, $used_patterns)) { 577 $used_patterns[$pattern]=true; 578 $text = str_replace($pattern, "<a target='_blank' href=" . $pattern . ">" . $pattern . "</a>", $text); 579 } 580 } 581 return $text; 582 } 583 }