Current path: home/webdevt/www/schtroumpf.fr/modules/ps_eventbus/src/Repository/
?? Go up: /home/webdevt/www/schtroumpf.fr/modules/ps_eventbus/src
<?php
namespace PrestaShop\Module\PsEventbus\Repository;
class OrderCartRuleRepository
{
public const TABLE_NAME = 'order_cart_rule';
/**
* @var \Db
*/
private $db;
public function __construct(\Db $db)
{
$this->db = $db;
}
/**
* @return \DbQuery
*/
public function getBaseQuery()
{
$query = new \DbQuery();
$query->from(self::TABLE_NAME, 'ocr');
return $query;
}
/**
* @param array $orderIds
*
* @return array|bool|\mysqli_result|\PDOStatement|resource|null
*
* @throws \PrestaShopDatabaseException
*/
public function getOrderCartRules(array $orderIds)
{
if (!$orderIds) {
return [];
}
$query = $this->getBaseQuery();
$query->select('ocr.id_order_cart_rule,ocr.id_order,ocr.id_cart_rule,ocr.id_order_invoice,ocr.name,ocr.value,ocr.value_tax_excl,
ocr.free_shipping');
if (\Tools::version_compare(_PS_VERSION_, '1.7.7.0', '>=')) {
$query->select('ocr.deleted');
}
$query->where('ocr.id_order IN (' . implode(',', array_map('intval', $orderIds)) . ')');
return $this->db->executeS($query);
}
}