编辑文件 - AxeptaConfigurationAccountPaygate.php

✏️ 正在编辑: AxeptaConfigurationAccountPaygate.php

路径: /home/bpioifn/www/pigmentse/modules/axepta/classes/AxeptaConfigurationAccountPaygate.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php
/**
 * 1997-2020 Quadra Informatique
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0) that is available
 * through the world-wide-web at this URL: http://www.opensource.org/licenses/OSL-3.0
 * If you are unable to obtain it through the world-wide-web, please send an email
 * to modules@quadra-informatique.fr so we can send you a copy immediately.
 *
 * @author    Quadra Informatique <modules@quadra-informatique.fr>
 * @copyright 1997-2020 Quadra Informatique
 * @license   http://www.opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 */

class AxeptaConfigurationAccountPaygate extends ObjectModel
{
    public $id_axepta_configuration_account_paygate;
    public $id_axepta_configuration_account;
    public $trigram;
    public $active;
    
    public static $definition = array(
        'table' => 'axepta_configuration_account_paygate',
        'primary' => 'id_axepta_configuration_account_paygate',
        'multilang' => false,
        'fields' => array(
            'id_axepta_configuration_account' => array(
                'type' => ObjectModel :: TYPE_INT,
                'required' => true,
            ),
            'trigram' => array(
                'type' => self::TYPE_STRING,
                'required' => true,
            ),
            'active' => array(
                'type' => self::TYPE_BOOL,
                'validate' => 'isBool',
            ),
        ),
    );

public static function resetPaygates($id_account = 0)
    {
        if ((int) $id_account) {
            Db::getInstance()->execute('DELETE FROM ' . _DB_PREFIX_ . 'axepta_configuration_account_paygate WHERE id_axepta_configuration_account = ' . (int) $id_account);
        }
        return false;
    }

public static function getPaygatesByIdAccount($id_account = 0)
    {
        if ((int) $id_account) {
            return Db::getInstance()->executeS('SELECT * FROM ' . _DB_PREFIX_ . 'axepta_configuration_account_paygate WHERE id_axepta_configuration_account = ' . (int) $id_account);
        }
        return false;
    }

public static function getActivePaygatesByIdAccountAndIdCountry($iso_code, $id_currency, $operation, $id_account = 0)
    {
        if ((int) $id_account && $iso_code) {
            $currency = new Currency($id_currency);
            $currency_code = $currency->iso_code;
            /*$result = Db::getInstance()->executeS("SELECT * FROM " . _DB_PREFIX_ . "axepta_xml_method a"
                    . " LEFT JOIN " . _DB_PREFIX_ . "axepta_xml_parameter_set ON " . _DB_PREFIX_ . "axepta_xml_parameter_set.method_id = a.id"
                    . " LEFT JOIN " . _DB_PREFIX_ . "axepta_xml_allow_countries ON " . _DB_PREFIX_ . "axepta_xml_allow_countries.method_id = a.id"
                    . " LEFT JOIN " . _DB_PREFIX_ . "axepta_configuration_account aca ON " . _DB_PREFIX_ . "axepta_xml_parameter_set.method_id = a.id"
                    . ' LEFT JOIN ' . _DB_PREFIX_ . 'axepta_configuration_account_paygate acap ON acap.trigram = a.trigram '
                    . " WHERE " . _DB_PREFIX_ . "axepta_xml_parameter_set.operation = '$operation'"
                    . " AND " . _DB_PREFIX_ . "axepta_xml_allow_countries.currency IN ('$currency_code', 'ALL')"
                    . " AND " . _DB_PREFIX_ . "axepta_xml_allow_countries.country IN ('$iso_code', 'ALL') group by a.id");*/
            
            $result = Db::getInstance()->executeS("SELECT * FROM " . _DB_PREFIX_ . "axepta_xml_method a"
                    . " LEFT JOIN " . _DB_PREFIX_ . "axepta_xml_parameter_set ON " . _DB_PREFIX_ . "axepta_xml_parameter_set.method_id = a.id"
                    . " LEFT JOIN " . _DB_PREFIX_ . "axepta_xml_allow_countries ON " . _DB_PREFIX_ . "axepta_xml_allow_countries.method_id = a.id"
                    . " LEFT JOIN " . _DB_PREFIX_ . "axepta_configuration_account aca ON " . _DB_PREFIX_ . "axepta_xml_parameter_set.method_id = a.id"
                    . ' LEFT JOIN ' . _DB_PREFIX_ . 'axepta_configuration_account_paygate acap ON acap.trigram = a.trigram AND acap.id_axepta_configuration_account = aca.id_axepta_configuration_account'
                    . " WHERE " . _DB_PREFIX_ . "axepta_xml_parameter_set.operation = '".pSQL($operation)."'"
                    . " AND " . _DB_PREFIX_ . "axepta_xml_allow_countries.currency IN ('".pSQL($currency_code)."', 'ALL')"
                    . " AND " . _DB_PREFIX_ . "axepta_xml_allow_countries.country IN ('".pSQL($iso_code)."', 'ALL') AND aca.id_axepta_configuration_account = ".(int)$id_account." group by a.id");
            foreach ($result as $index => $res) {
                if ($res['trigram'] == null) {
                    unset($result[$index]);
                }
            }
            return $result;
        }
        return false;
    }

public static function getActivePaygatesByIdAccountAndOperationOneClick($id_account)
    {
        if ((int) $id_account) {
            return Db::getInstance()->executeS('SELECT * FROM ' . _DB_PREFIX_ . 'axepta_configuration_account a '
                            . 'LEFT JOIN ' . _DB_PREFIX_ . 'axepta_configuration_account_paygate acap ON acap.id_axepta_configuration_account = a.id_axepta_configuration_account '
                            . 'LEFT JOIN ' . _DB_PREFIX_ . 'axepta_xml_method axm ON axm.trigram = acap.trigram '
                            . 'LEFT JOIN ' . _DB_PREFIX_ . 'axepta_xml_parameter_set axps ON axps.method_id = axm.id '
                            . 'WHERE acap.id_axepta_configuration_account = ' . (int) $id_account . ' AND operation = "oneclick" AND acap.active = 1');
        }
        return false;
    }

public static function getIfOneClickExist($id_account_paygate)
    {
        if ((int) $id_account_paygate) {
            $result = Db::getInstance()->getValue('SELECT id_axepta_configuration_account_paygate FROM ' . _DB_PREFIX_ . 'axepta_configuration_account_paygate acap '
                    . 'LEFT JOIN ' . _DB_PREFIX_ . 'axepta_configuration_account a ON acap.id_axepta_configuration_account = a.id_axepta_configuration_account '
                    . 'LEFT JOIN ' . _DB_PREFIX_ . 'axepta_xml_method axm ON axm.trigram = acap.trigram '
                    . 'LEFT JOIN ' . _DB_PREFIX_ . 'axepta_xml_parameter_set axps ON axps.method_id = axm.id '
                    . 'WHERE acap.id_axepta_configuration_account_paygate = ' . (int) $id_account_paygate . ' AND operation = "oneclick" AND acap.active = 1');
        }
        return $result;
    }
}

← 返回文件管理器