Ghi chú phát triển 4.3.01 - nukeviet/module-wallet GitHub Wiki

Cho phép thanh toán bằng quy đổi

INSERT INTO `nv4_config` (`lang`, `module`, `config_name`, `config_value`) VALUES ('vi', 'wallet', 'allow_exchange_pay', '1');

Cập nhật phần tỷ giá

ALTER TABLE `nv4_wallet_exchange` CHANGE `exchange` `exchange_to` DOUBLE NOT NULL DEFAULT '1';
ALTER TABLE `nv4_wallet_exchange` ADD `exchange_from` DOUBLE NOT NULL DEFAULT '1' AFTER `than_unit`;

ALTER TABLE `nv4_wallet_exchange_log` CHANGE `exchange` `exchange_to` DOUBLE NOT NULL DEFAULT '1';
ALTER TABLE `nv4_wallet_exchange_log` ADD `exchange_from` DOUBLE NOT NULL DEFAULT '1' AFTER `than_unit`;

Lưu lại ID Transaction vào CSDL

ALTER TABLE `nv4_wallet_orders` ADD `paid_id` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'ID giao dịch' AFTER `paid_status`;

Chạy tool

<?php

/**
 * @Project NUKEVIET 4.x
 * @Author VINADES.,JSC <[email protected]>
 * @Copyright (C) 2014 VINADES.,JSC. All rights reserved
 * @License GNU/GPL version 2 or any later version
 * @Createdate 31/05/2010, 00:36
 */

if (isset($_GET['response_headers_detect'])) {
    exit(0);
}

define('NV_SYSTEM', true);

// Xac dinh thu muc goc cua site
define('NV_ROOTDIR', pathinfo(str_replace(DIRECTORY_SEPARATOR, '/', __file__), PATHINFO_DIRNAME));

require NV_ROOTDIR . '/includes/mainfile.php';

$sql = "SELECT * FROM " . $db_config['prefix'] . "_wallet_orders WHERE paid_time>0";
$result1 = $db->query($sql);

while ($order = $result1->fetch()) {
    $sql = "SELECT id FROM " . $db_config['prefix'] . "_wallet_transaction WHERE transaction_status=" . $order['paid_status'] . " AND order_id=" . $order['id'] . " AND transaction_time=" . $order['paid_time'];
    $transaction = $db->query($sql)->fetch();
    if (!empty($transaction)) {
        $db->query("UPDATE " . $db_config['prefix'] . "_wallet_orders SET paid_id=" . $db->quote(vsprintf('WP%010s', $transaction['id'])) . "
        WHERE id=" . $order['id']);
    }
}

echo('Cập nhật hoàn tất!');