Files
2024-10-25 14:16:28 +02:00

73 lines
2.2 KiB
PHP

<?php
/**
* We offer the best and most useful modules PrestaShop and modifications for your online store.
*
* We are experts and professionals in PrestaShop
*
* @author PresTeamShop.com <support@presteamshop.com>
* @copyright 2011-2017 PresTeamShop
* @license see file: LICENSE.txt
* @category PrestaShop
* @category Module
*/
class PaymentClass extends ObjectModel
{
public $id;
public $id_module;
public $name;
public $title;
public $description;
public $name_image;
public $force_display;
public static $definition = array(
'table' => 'opc_payment',
'primary' => 'id_payment',
'multilang' => true,
'multilang_shop' => true,
'fields' => array(
'id_module' => array('type' => self::TYPE_INT),
'name' => array('type' => self::TYPE_STRING),
'name_image' => array('type' => self::TYPE_STRING),
'force_display' => array('type' => self::TYPE_BOOL),
/* Lang fields */
'title' => array('type' => self::TYPE_STRING, 'lang' => true),
'description' => array('type' => self::TYPE_STRING, 'lang' => true)
)
);
public function __construct($id = null, $id_lang = null, $id_shop = null)
{
//create multishop assoc
Shop::addTableAssociation(self::$definition['table'], array('type' => 'shop'));
parent::__construct($id, $id_lang, $id_shop);
}
public static function getPaymentByName($name)
{
$query = new DbQuery();
$query->select(self::$definition['primary']);
$query->from(self::$definition['table']);
$query->where('name = \''.pSQL($name).'\'');
$id_payment = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
if (!empty($id_payment)) {
return $id_payment;
}
return null;
}
public static function getIdPaymentBy($field, $value)
{
$query = new DbQuery();
$query->select(bqSQL(self::$definition['primary']));
$query->from(bqSQL(self::$definition['table']));
$query->where($field.' = "'.pSQL($value).'"');
return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
}
}