Autocomplete у опции

nash · 13 серпня 2020

Добрый день! Делаю autocomplete для опций. Для одной опции работает, делаю для других - выдает пустые значения (второй скрин). Поля patina и dekor - сделаны, работают правильно.

controller/product

public function autocomplete() {
		$json = array();

		if (isset($this->request->get['filter_name']) || isset($this->request->get['filter_model']) || isset($this->request->get['filter_patina']) || isset($this->request->get['filter_dekor'])) {
			$this->load->model('catalog/product');

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

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

			if (isset($this->request->get['limit'])) {
				$limit = $this->request->get['limit'];
			} else {
				$limit = 10;
			}

			$filter_data = array(
				'filter_model' => $filter_model,
				'filter_patina' => $filter_patina,
				'filter_dekor' => $filter_dekor,
				'start'        => 0,
				'limit'        => $limit
			);

			$results = $this->model_catalog_product->getProducts($filter_data);

			foreach ($results as $result) {

				$json[] = array(
					'product_id' => $result['product_id'],
					'name'       => strip_tags(html_entity_decode($result['model'], ENT_QUOTES, 'UTF-8')),
					'patina'	 => strip_tags(html_entity_decode($result['patina'], ENT_QUOTES, 'UTF-8')),
					'dekor'	 => strip_tags(html_entity_decode($result['dekor'], ENT_QUOTES, 'UTF-8')),
					'price'      => $result['price']
				);
			}
		}

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

model/product

getProducts()

public function getProducts($data = array()) {
		$sql = "SELECT p.product_id, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special";

		if (!empty($data['filter_category_id'])) {
			if (!empty($data['filter_sub_category'])) {
				$sql .= " FROM " . DB_PREFIX . "category_path cp LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (cp.category_id = p2c.category_id)";
			} else {
				$sql .= " FROM " . DB_PREFIX . "product_to_category p2c";
			}

			if (!empty($data['filter_filter'])) {
				$sql .= " LEFT JOIN " . DB_PREFIX . "product_filter pf ON (p2c.product_id = pf.product_id) LEFT JOIN " . DB_PREFIX . "product p ON (pf.product_id = p.product_id)";
			} else {
				$sql .= " LEFT JOIN " . DB_PREFIX . "product p ON (p2c.product_id = p.product_id)";
			}
		} else {
			$sql .= " FROM " . DB_PREFIX . "product p";
		}

		$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'";

		if (!empty($data['filter_category_id'])) {
			if (!empty($data['filter_sub_category'])) {
				$sql .= " AND cp.path_id = '" . (int)$data['filter_category_id'] . "'";
			} else {
				$sql .= " AND p2c.category_id = '" . (int)$data['filter_category_id'] . "'";
			}

			if (!empty($data['filter_filter'])) {
				$implode = array();

				$filters = explode(',', $data['filter_filter']);

				foreach ($filters as $filter_id) {
					$implode[] = (int)$filter_id;
				}

				$sql .= " AND pf.filter_id IN (" . implode(',', $implode) . ")";
			}
		}
		
		if (!empty($data['filter_model'])) {
			$sql .= " AND p.model LIKE '%" . $this->db->escape($data['filter_model']) . "%'";
		}		
		
		if (!empty($data['filter_patina'])) {
			$sql .= " AND p.model LIKE '%" . $this->db->escape($data['filter_patina']) . "%'";
		}	
		
		if (!empty($data['filter_dekor'])) {
			$sql .= " AND p.model LIKE '%" . $this->db->escape($data['filter_dekor']) . "%'";
		}

		if (!empty($data['filter_name']) || !empty($data['filter_tag'])) {
			$sql .= " AND (";

			if (!empty($data['filter_name'])) {
				$implode = array();

				$words = explode(' ', trim(preg_replace('/\s+/', ' ', $data['filter_name'])));

				foreach ($words as $word) {
					$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";
				}

				if ($implode) {
					$sql .= " " . implode(" AND ", $implode) . "";
				}

				if (!empty($data['filter_description'])) {
					$sql .= " OR pd.description LIKE '%" . $this->db->escape($data['filter_name']) . "%'";
				}
			}

			if (!empty($data['filter_name']) && !empty($data['filter_tag'])) {
				$sql .= " OR ";
			}

			if (!empty($data['filter_tag'])) {
				$implode = array();

				$words = explode(' ', trim(preg_replace('/\s+/', ' ', $data['filter_tag'])));

				foreach ($words as $word) {
					$implode[] = "pd.tag LIKE '%" . $this->db->escape($word) . "%'";
				}

				if ($implode) {
					$sql .= " " . implode(" AND ", $implode) . "";
				}
			}

			if (!empty($data['filter_name'])) {
				$sql .= " OR LCASE(p.model) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
				$sql .= " OR LCASE(p.sku) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
				$sql .= " OR LCASE(p.upc) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
				$sql .= " OR LCASE(p.ean) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
				$sql .= " OR LCASE(p.jan) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
				$sql .= " OR LCASE(p.isbn) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
				$sql .= " OR LCASE(p.mpn) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
			}

			$sql .= ")";
		}

		if (!empty($data['filter_manufacturer_id'])) {
			$sql .= " AND p.manufacturer_id = '" . (int)$data['filter_manufacturer_id'] . "'";
		}

		$sql .= " GROUP BY p.product_id";

		$sort_data = array(
			'pd.name',
			'p.model',
			'p.quantity',
			'p.price',
			'rating',
			'p.sort_order',
			'p.date_added'
		);

		if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			if ($data['sort'] == 'pd.name' || $data['sort'] == 'p.model') {
				$sql .= " ORDER BY LCASE(" . $data['sort'] . ")";
			} elseif ($data['sort'] == 'p.price') {
				$sql .= " ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END)";
			} else {
				$sql .= " ORDER BY " . $data['sort'];
			}
		} else {
			$sql .= " ORDER BY p.sort_order";
		}

		if (isset($data['order']) && ($data['order'] == 'DESC')) {
			$sql .= " DESC, LCASE(pd.name) DESC";
		} else {
			$sql .= " ASC, LCASE(pd.name) ASC";
		}

		if (isset($data['start']) || isset($data['limit'])) {
			if ($data['start'] < 0) {
				$data['start'] = 0;
			}

			if ($data['limit'] < 1) {
				$data['limit'] = 20;
			}

			$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
		}

		$product_data = array();

		$query = $this->db->query($sql);

		foreach ($query->rows as $result) {
			$product_data[$result['product_id']] = $this->getProduct($result['product_id']);
		}

		return $product_data;
	}

template

<?php if ($option['type'] == 'text') { ?>
                <div class="form-group<?php echo ($option['required'] ? ' required' : ''); ?>" <?php if ($option['option_id']=='17' ) { ?>id="plenka"
                  <?php } ?>>
                  <label class="control-label" for="<?php echo $module_name; ?>input-option<?php echo $option['product_option_id']; ?>">
                    <?php echo $option['name']; ?></label>
                  <input type="text" name="option[<?php echo $option['product_option_id']; ?>]" value="<?php echo $option['value']; ?>" placeholder="<?php echo $option['name']; ?>" id="<?php echo $module_name; ?>input-option<?php echo $option['product_option_id']; ?>" class="form-control" />
                </div>
                <?php if ($option['option_id'] == '17') { ?>
                <script type="text/javascript">
                <!--
                $('input[name=\'option[<?php echo $option["product_option_id"]; ?>]\']').autocomplete({
                  'source': function(request, response) {
                    $.ajax({
                      url: 'index.php?route=product/product/autocomplete&filter_name=' + encodeURIComponent(request),
                      dataType: 'json',
                      success: function(json) {
                        response($.map(json, function(item) {
                          return {
                            label: item['name'],
                            value: item['product_id']
                          }
                        }));
                      }
                    });
                  },
                  'select': function(item) {
                    $('input[name=\'option[<?php echo $option["product_option_id"]; ?>]\']').val(item['label']);
                  }
                });
                //-->
                </script>
                <?php } ?>
				<?php if ($option['option_id'] == '18') { ?>
                <script type="text/javascript">
                <!--
                $('input[name=\'option[<?php echo $option["product_option_id"]; ?>]\']').autocomplete({
                  'source': function(request, response) {
                    $.ajax({
                      url: 'index.php?route=product/product/autocomplete&filter_patina=' + encodeURIComponent(request),
                      dataType: 'json',
                      success: function(json) {
                        response($.map(json, function(item) {
                          return {
                            label: item['patina'],
                            value: item['product_id']
                          }
                        }));
                      }
                    });
                  },
                  'select': function(item) {
                    $('input[name=\'option[<?php echo $option["product_option_id"]; ?>]\']').val(item['label']);
                  }
                });
                //-->
                </script>
                <?php } ?>
				
				<?php if ($option['option_id'] == '19') { ?>
                <script type="text/javascript">
                <!--
                $('input[name=\'option[<?php echo $option["product_option_id"]; ?>]\']').autocomplete({
                  'source': function(request, response) {
                    $.ajax({
                      url: 'index.php?route=product/product/autocomplete&filter_dekor=' + encodeURIComponent(request),
                      dataType: 'json',
                      success: function(json) {
                        response($.map(json, function(item) {
                          return {
                            label: item['dekor'],
                            value: item['product_id']
                          }
                        }));
                      }
                    });
                  },
                  'select': function(item) {
                    $('input[name=\'option[<?php echo $option["product_option_id"]; ?>]\']').val(item['label']);
                  }
                });
                //-->
                </script>
                <?php } ?>
                <?php } ?>

Вхід

Autocomplete у опции

Recommended Posts

nash

Надіслати

Поділитися на інших сайтах

Створіть аккаунт або увійдіть для коментування

Створити обліковий запис

Вхід

Зараз на сторінці 0 користувачів

Покупцям

Розробникам

Корисна інформація

Останні розширення

Ваші замовлення

ocStore

Шаблони

OpenCart.Pro

Important Information