79 lines
1.8 KiB
PHP
79 lines
1.8 KiB
PHP
<?php
|
|
/**
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This file is licenced under the Software License Agreement.
|
|
* With the purchase or the installation of the software in your application
|
|
* you accept the licence agreement.
|
|
*
|
|
* You must not modify, adapt or create derivative works of this source code
|
|
*
|
|
* @author imoje
|
|
* @copyright 2022-now imoje
|
|
* @license GNU General Public License
|
|
**/
|
|
|
|
class ImojeSql
|
|
{
|
|
|
|
/**
|
|
* @var string
|
|
*/
|
|
const TABLE_NAME = _DB_PREFIX_ . 'imoje_transaction_list';
|
|
|
|
/**
|
|
* @return bool
|
|
*/
|
|
public static function install()
|
|
{
|
|
$sql = [];
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'
|
|
. _DB_PREFIX_
|
|
. 'imoje_transaction_list` ( `id` int(11) NOT NULL AUTO_INCREMENT, `id_order` '
|
|
. 'int(10) UNSIGNED NOT NULL, `id_transaction` varchar(255) NOT NULL, PRIMARY KEY (`id`)) ENGINE='
|
|
. _MYSQL_ENGINE_
|
|
. ' DEFAULT CHARSET=utf8;';
|
|
|
|
$valid = true;
|
|
|
|
foreach ($sql as $query) {
|
|
if (Db::getInstance()->execute($query) == false) {
|
|
$valid = false;
|
|
}
|
|
}
|
|
|
|
return $valid;
|
|
}
|
|
|
|
/**
|
|
* @return bool
|
|
*/
|
|
public static function uninstall()
|
|
{
|
|
|
|
$sql = array();
|
|
|
|
$valid = true;
|
|
|
|
foreach ($sql as $query) {
|
|
if (Db::getInstance()->execute($query) == false) {
|
|
$valid = false;
|
|
}
|
|
}
|
|
|
|
return $valid;
|
|
}
|
|
|
|
/**
|
|
* @param string $orderId
|
|
*
|
|
* @return string|void
|
|
*/
|
|
public static function getTransactionId($orderId)
|
|
{
|
|
|
|
return Db::getInstance()->getValue("SELECT `" . self::TABLE_NAME . "`.`id_transaction` FROM `" . self::TABLE_NAME . "` WHERE `" . self::TABLE_NAME . "`.`id_order` = '" . pSQL($orderId) . "';");
|
|
}
|
|
}
|