Помогите настроить модуль Shipment Tracking System

lanbar · 6 мар 2013

В общем устанавливаю модуль, после этого в админке все слова отображаются как кракозябры и вверху выскакивает ошибка

$this->data['shippers'] = $this->url->link('sale/shipper', 'token=' . $this->session->data['token'], 'SSL'); $this->data['text_shippers'] = $this->language->get('text_shippers');
Нажмите, чтобы раскрыть...

Я так понял что это в базе нужно ковыряться, только что и как ковырять?

Если поставить язык админа английский, то кракозябры пропадают.

Как исправить, очень нужен этот модуль

Спойлер

Сылка на модуль http://scriptmafia.org/modules/95745-150x-shipment-tracking-system-opencart-extension.html

Spartak · 6 мар 2013

Добрый день.
Попробуйте пересохранить файлы модуля, например через Notepad++, в кодировке UTF-8 без BOM

Matras · 6 мар 2013

Нужно папке admin в файлах модуля во первых скопировать папку english и переименовать ее в russian. затем все файлы языковые в папке russian сохранить в UTF-8 без BOM

lanbar · 7 мар 2013

Не помогло, все так и осталось, ошибку и кракозябры вызывает файл vqmod 15X-Tracking-System.xml
После его удаления ошибка проподает.
Посмотрите пожалуйста, может кто подскажет как исправить?

Спойлер

<modification>

<id>1.5.X - Shipment Tracking System</id>
<version>1.0.0</version>
<vqmver>1.0.4</vqmver>
<author>SpotOnSolutions.net</author>

<file name="catalog/controller/account/order.php">

<operation>
<search position="replace" index="2" trim="true"><![CDATA[
if (!$this->customer->isLogged()) {
]]></search>
<add trim="true"><![CDATA[
if(!$this->customer->isLogged() && !isset($this->session->data['tracking_customer_id'])) {
]]></add>
</operation>

<operation>
<search position="after"><![CDATA[
$this->data['column_status'] = $this->language->get('column_status');
]]></search>
<add><![CDATA[
///////////// 1.5.X Shippment Tracking /////////////
$this->data['column_ship_track'] = $this->language->get('column_ship_track');
///////////// 1.5.X Shippment Tracking ////////////
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
$this->data['histories'][] = array(
]]></search>
<add><![CDATA[
$url = $this->model_account_order->getShipURL($result['shipper_id']);
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
'comment' => nl2br($result['comment'])
]]></search>
<add><![CDATA[
'ship_track' => $result['trackcode'],
'trackcode' => sprintf($url, $result['trackcode']),
]]></add>
</operation>

</file>

<file name="catalog/model/account/order.php">
<operation>
<search position="replace" trim="true" index="1"><![CDATA[
$order_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order` WHERE order_id = '" . (int)$order_id . "' AND customer_id = '" . (int)$this->customer->getId() . "' AND order_status_id > '0'");
]]></search>
<add trim="true"><![CDATA[
$filter = "";
if(isset($this->session->data['tracking_customer_id']) && ($this->session->data['tracking_customer_id'])) {
$filter = "AND customer_id = '" . (int)$this->session->data['tracking_customer_id'] . "'";
unset($this->session->data['tracking_customer_id']);
}else{
$filter = "AND customer_id = '" . (int)$this->customer->getId() . "'";
}
$order_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order` WHERE order_id = '" . (int)$order_id . "' $filter AND order_status_id > '0'");
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
public function getTotalOrderProductsByOrderId($order_id) {
]]></search>
<add><![CDATA[
// start function for order tracking...................

public function trackingOrder($order_id, $email) {
$query = $this->db->query("SELECT customer_id FROM `" . DB_PREFIX . "order` WHERE order_id = '" . (int)$order_id . "' AND email = '" . $this->db->escape($email) . "' AND order_status_id > '0'");

return ($query->num_rows > 0)?$query->row['customer_id']:false;
}
// end function for order tracking...................
]]></add>
</operation>

<operation>
<search position="replace"><![CDATA[
$query = $this->db->query("SELECT date_added, os.name AS status, oh.comment, oh.notify FROM " . DB_PREFIX . "order_history oh LEFT JOIN " . DB_PREFIX . "order_status os ON oh.order_status_id = os.order_status_id WHERE oh.order_id = '" . (int)$order_id . "' AND oh.notify = '1' AND os.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY oh.date_added");
]]></search>
<add><![CDATA[
///////////// 1.5.X Shippment Tracking /////////////
$query = $this->db->query("SELECT date_added, os.name AS status, oh.comment, oh.trackcode, oh.shipper_id, oh.notify FROM " . DB_PREFIX . "order_history oh LEFT JOIN " . DB_PREFIX . "order_status os ON oh.order_status_id = os.order_status_id WHERE oh.order_id = '" . (int)$order_id . "' AND oh.notify = '1' AND os.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY oh.date_added");
///////////// 1.5.X Shippment Tracking /////////////
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
public function getOrderHistories($order_id) {
]]></search>
<add><![CDATA[
public function getShipURL($shipper_id){
$query = $this->db->query("SELECT url FROM `" . DB_PREFIX . "shippers` WHERE shipper_id = '" . (int)$shipper_id . "'");
if($query->num_rows){
return $query->row['url'];
} else {
return false;
}
}
]]></add>
</operation>

</file>

<file name="catalog/language/english/account/order.php">
<operation>
<search position="after"><![CDATA[
$_['column_status'] = 'Status';
]]></search>
<add><![CDATA[
///////////// 1.5.X Shippment Tracking /////////////
$_['column_ship_track'] = 'Tracking No.';
///////////// 1.5.X Shippment Tracking /////////////
]]></add>
</operation>
</file>

<file name="catalog/view/theme/default/template/account/order_info.tpl">
<operation>
<search position="before"><![CDATA[
<td class="left"><?php echo $column_comment; ?></td>
]]></search>
<add><![CDATA[
<td class="left"><?php echo $column_ship_track; ?></td>
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
<td class="left"><?php echo $history['comment']; ?></td>
]]></search>
<add><![CDATA[
<td class="left"><?php if($history['ship_track']){ echo '<a href="' . $history['trackcode'] . '" target="_blank">' . $history['ship_track'] . '</a>'; } ?></td>
]]></add>
</operation>

</file>

<file name="admin/controller/common/header.php">
<operation>
<search position="after"><![CDATA[
$this->data['text_order'] = $this->language->get('text_order');
]]></search>
<add><![CDATA[
$this->data['text_shippers'] = $this->language->get('text_shippers');
]]></add>
</operation>
<operation>
<search position="after"><![CDATA[
$this->data['order'] = $this->url->link('sale/order', 'token=' . $this->session->data['token'], 'SSL');
]]></search>
<add><![CDATA[
$this->data['shippers'] = $this->url->link('sale/shipper', 'token=' . $this->session->data['token'], 'SSL');
]]></add>
</operation>
</file>

<file name="admin/language/english/common/header.php">
<operation>
<search position="after"><![CDATA[
$_['text_order']
]]></search>
<add><![CDATA[
$_['text_shippers'] = 'Shippers';
]]></add>
</operation>
</file>

<file name="admin/view/template/common/header.tpl">
<operation>
<search position="after"><![CDATA[
<li><a href="<?php echo $order; ?>"><?php echo $text_order; ?></a></li>
]]></search>
<add><![CDATA[
<li><a href="<?php echo $shippers; ?>"><?php echo $text_shippers; ?></a></li>
]]></add>
</operation>
</file>

<file name="admin/controller/sale/order.php">

<operation>
<search position="after"><![CDATA[
$this->data['column_remaining'] = $this->language->get('column_remaining');
]]></search>
<add><![CDATA[
$this->data['column_ship_track'] = $this->language->get('column_ship_track');
]]></add>
</operation>

<operation>
<search position="after"><![CDATA[
$this->data['column_comment'] = $this->language->get('column_comment');
]]></search>
<add><![CDATA[
$this->data['column_ship_track'] = $this->language->get('column_ship_track');
]]></add>
</operation>

<operation>
<search position="after"><![CDATA[
$this->data['entry_comment'] = $this->language->get('entry_comment');
]]></search>
<add><![CDATA[
$this->data['entry_shipper'] = $this->language->get('entry_shipper');
$this->data['entry_trackcode'] = $this->language->get('entry_trackcode');
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
$this->data['date_added'] = date($this->language->get('date_format_short'), strtotime($order_info['date_added']));
]]></search>
<add><![CDATA[
$this->data['shippers'] = $this->model_sale_order->getShippers();
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
$this->data['histories'][] = array(
]]></search>
<add><![CDATA[
$url = $this->model_sale_order->getShipURL($result['shipper_id']);
]]></add>
</operation>

<operation>
<search position="after"><![CDATA[
'status' => $result['status'],
]]></search>
<add><![CDATA[
'ship_track' => $result['trackcode'],
'trackcode' => sprintf($url, $result['trackcode']),
]]></add>
</operation>

</file>

<file name="admin/model/sale/order.php">

<operation>
<search position="replace"><![CDATA[
$this->db->query("INSERT INTO " . DB_PREFIX . "order_history SET order_id = '" . (int)$order_id . "', order_status_id = '" . (int)$data['order_status_id'] . "', notify = '" . (isset($data['notify']) ? (int)$data['notify'] : 0) . "', comment = '" . $this->db->escape(strip_tags($data['comment'])) . "', date_added = NOW()");
]]></search>
<add><![CDATA[
$this->db->query("INSERT INTO " . DB_PREFIX . "order_history SET order_id = '" . (int)$order_id . "', order_status_id = '" . (int)$data['order_status_id'] . "', notify = '" . (isset($data['notify']) ? (int)$data['notify'] : 0) . "', trackcode = '" . $this->db->escape($data['trackcode']) . "', shipper_id = '" . (int)$data['shipper_id'] . "', comment = '" . $this->db->escape(strip_tags($data['comment'])) . "', date_added = NOW()");
]]></add>
</operation>

<operation>
<search position="replace"><![CDATA[
$query = $this->db->query("SELECT oh.date_added, os.name AS status, oh.comment, oh.notify FROM " . DB_PREFIX . "order_history oh LEFT JOIN " . DB_PREFIX . "order_status os ON oh.order_status_id = os.order_status_id WHERE oh.order_id = '" . (int)$order_id . "' AND os.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY oh.date_added ASC LIMIT " . (int)$start . "," . (int)$limit);
]]></search>
<add><![CDATA[
$query = $this->db->query("SELECT oh.date_added, os.name AS status, oh.comment, oh.notify, oh.trackcode, oh.shipper_id FROM " . DB_PREFIX . "order_history oh LEFT JOIN " . DB_PREFIX . "order_status os ON oh.order_status_id = os.order_status_id WHERE oh.order_id = '" . (int)$order_id . "' AND os.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY oh.date_added ASC LIMIT " . (int)$start . "," . (int)$limit);
]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
public function getTotalOrderHistoriesByOrderStatusId($order_status_id) {
]]></search>
<add><![CDATA[
public function getShippers() {
$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "shippers`");
return $query->rows;
}

public function getShipURL($shipper_id){
$query = $this->db->query("SELECT url FROM `" . DB_PREFIX . "shippers` WHERE shipper_id = '" . (int)$shipper_id . "'");
if($query->num_rows){
return $query->row['url'];
} else {
return false;
}
}

]]></add>
</operation>

<operation>
<search position="before"><![CDATA[
$message .= $language->get('text_footer');
]]></search>
<add><![CDATA[
if ($data['trackcode']) {
$url = $this->getShipUrl($data['shipper_id']);
$message .= $language->get('text_tracking') . "\n\n";
$message .= $data['trackcode'] . "\n\n";
$message .= $language->get('text_url') . "\n\n";
$message .= sprintf($url, $data['trackcode']) . "\n\n";
}
]]></add>
</operation>

</file>

<file name="admin/view/template/sale/order_history.tpl">

<operation>
<search position="after"><![CDATA[
<td class="left"><b><?php echo $column_status; ?></b></td>
]]></search>
<add><![CDATA[
<td class="left"><b><?php echo $column_ship_track; ?></b></td>
]]></add>
</operation>

<operation>
<search position="after"><![CDATA[
<td class="left"><?php echo $history['status']; ?></td>
]]></search>
<add><![CDATA[
<td class="left"><?php if($history['ship_track']){ echo '<a href="' . $history['trackcode'] . '" target="_blank">' . $history['ship_track'] . '</a>'; } ?></td>
]]></add>
</operation>

</file>

<file name="admin/view/template/sale/order_info.tpl">

<operation>
<search position="before"><![CDATA[
<td><?php echo $entry_comment; ?></td>
]]></search>
<add><![CDATA[
<td><?php echo $entry_shipper; ?></td>
<td><select name="shipper_id">
<option value="">N/A</option>
<?php foreach ($shippers as $shipper){ ?>
<option value="<?php echo $shipper['shipper_id']; ?>"><?php echo $shipper['name']; ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td><?php echo $entry_trackcode; ?></td>
<td><input type="text" name="trackcode" size="30" /></td>
</tr>
<tr>
]]></add>
</operation>

<operation>
<search position="replace"><![CDATA[
data: 'order_status_id=' + encodeURIComponent($('select[name=\'order_status_id\']').val()) + '&notify=' + encodeURIComponent($('input[name=\'notify\']').attr('checked') ? 1 : 0) + '&append=' + encodeURIComponent($('input[name=\'append\']').attr('checked') ? 1 : 0) + '&comment=' + encodeURIComponent($('textarea[name=\'comment\']').val()),
]]></search>
<add><![CDATA[
data: 'order_status_id=' + encodeURIComponent($('select[name=\'order_status_id\']').val()) + '&notify=' + encodeURIComponent($('input[name=\'notify\']').attr('checked') ? 1 : 0) + '&append=' + encodeURIComponent($('input[name=\'append\']').attr('checked') ? 1 : 0) + '&comment=' + encodeURIComponent($('textarea[name=\'comment\']').val()) + '&trackcode=' + encodeURIComponent($('input[name=\'trackcode\']').val()) + '&shipper_id=' + encodeURIComponent($('select[name=\'shipper_id\']').val()),
]]></add>
</operation>

</file>

<file name="admin/language/english/sale/order.php">

<operation>
<search position="after"><![CDATA[
$_['column_action']
]]></search>
<add><![CDATA[
$_['column_ship_track'] = 'Tracking Number';
]]></add>
</operation>

<operation>
<search position="after"><![CDATA[
$_['entry_payment']
]]></search>
<add><![CDATA[
$_['entry_shipper'] = 'Shipper:';
$_['entry_trackcode'] = 'Tracking Number:';
]]></add>
</operation>

</file>

<file name="admin/language/english/mail/order.php">

<operation>
<search position="after"><![CDATA[
$_['text_comment'] = 'The comments for your order are:';
]]></search>
<add><![CDATA[
$_['text_tracking'] = 'Your Tracking number is:';
$_['text_url'] = 'You can Track your package at the following url:';
]]></add>
</operation>

</file>

</modification>

Nasario2 · 22 мар 2013

кидайте модуль и Ваш файл header.tpl - гляну.

AlexV · 24 мар 2013

Исправить просто. Настройте SSL для вашего сайта и заработает. Тут проверка идет, если есть SSL, выводит инфу.

Войти или зарегистрироваться

Помогите настроить модуль Shipment Tracking System

lanbar

Spartak

Matras Guest

lanbar

Nasario2

AlexV