<?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);
    }
}