/**
* Get the detailed payment of an order
* @param int $order_reference
* @return array
* @since 1.5.0.13
*/
public static function getByOrderReference($order_reference)
{
return ObjectModel::hydrateCollection('OrderPayment', Db::getInstance()->executeS('
SELECT *
FROM `' . _DB_PREFIX_ . 'order_payment`
WHERE `order_reference` = \'' . pSQL($order_reference) . '\''));
}
public static function findAll()
{
$sql = 'select * from ' . _DB_PREFIX_ . 'prestaebooks where ebook_active = 1 order by id_prestaebooks ASC';
if ($rows = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql)) {
return ObjectModel::hydrateCollection(__CLASS__, $rows);
}
return array();
}
public static function getByOrder($id_order)
{
$order_invoice_list = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT oi.*
FROM `' . _DB_PREFIX_ . 'order_invoice` oi
LEFT JOIN `' . _DB_PREFIX_ . 'orders` o ON (o.`id_order` = oi.`id_order`)
WHERE o.id_order = ' . intval($id_order) . '
');
return ObjectModel::hydrateCollection('OrderInvoice', $order_invoice_list);
}
/**
* Retrieve my comments
* @param array $params filters (column)
* @return array
* @throws Exception
*/
public function comments($params = array())
{
$query = new DbQuery();
$query->select('*')->from('comment')->where('id_user = '******'date_add DESC');
if (isset($params['username'])) {
$query->where('username = "******"');
}
$results = Db::getInstance()->ExecuteS($query);
if (!Validate::isNonEmptyArray($results)) {
return array();
}
return ObjectModel::hydrateCollection('Comment', $results);
}
public static function getResponseByQuestion($id_question)
{
$query = new DbQuery();
$query->from('lgconsultas_respuestas');
$query->where('id_consulta = ' . (int) $id_question);
$row = DB::getInstance()->executeS($query);
if ($row) {
$rows = ObjectModel::hydrateCollection('LGRespuesta', $row);
$object = array_pop($rows);
} else {
$object = new LGRespuesta();
$object->id_consulta = (int) $id_question;
$object->id_employee = (int) 0;
$object->respuesta = '';
$object->date_add = '';
}
return $object;
}
/**
* @since 1.5.0.3
* @param $date_from
* @param $date_to
* @return array collection of invoice
*/
public static function getByDeliveryDateInterval($date_from, $date_to)
{
$order_invoice_list = Db::getInstance()->executeS('
SELECT oi.*
FROM `' . _DB_PREFIX_ . 'order_invoice` oi
LEFT JOIN `' . _DB_PREFIX_ . 'orders` o ON (o.`id_order` = oi.`id_order`)
WHERE DATE_ADD(oi.delivery_date, INTERVAL -1 DAY) <= \'' . pSQL($date_to) . '\'
AND oi.delivery_date >= \'' . pSQL($date_from) . '\'
' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o') . '
ORDER BY oi.delivery_date ASC
');
return ObjectModel::hydrateCollection('OrderInvoice', $order_invoice_list);
}
/**
* @static
* @param Context|null $context
* @return mixed
*/
public static function autoAddToCart(Context $context = null)
{
if ($context === null) {
$context = Context::getContext();
}
if (!CartRule::isFeatureActive() || !Validate::isLoadedObject($context->cart)) {
return;
}
$sql = '
SELECT cr.*
FROM ' . _DB_PREFIX_ . 'cart_rule cr
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
' . ($context->cart->id_carrier ? 'LEFT JOIN ' . _DB_PREFIX_ . 'carrier c ON (c.id_reference = crca.id_carrier AND c.deleted = 0)' : '') . '
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND cr.date_from < "' . date('Y-m-d H:i:s') . '"
AND cr.date_to > "' . date('Y-m-d H:i:s') . '"
AND (
cr.id_customer = 0
' . ($context->customer->id ? 'OR cr.id_customer = ' . (int) $context->cart->id_customer : '') . '
)
AND (
cr.`carrier_restriction` = 0
' . ($context->cart->id_carrier ? 'OR c.id_carrier = ' . (int) $context->cart->id_carrier : '') . '
)
AND (
cr.`shop_restriction` = 0
' . (Shop::isFeatureActive() && $context->shop->id ? 'OR crs.id_shop = ' . (int) $context->shop->id : '') . '
)
AND (
cr.`group_restriction` = 0
' . ($context->customer->id ? 'OR 0 < (
SELECT cg.`id_group`
FROM `' . _DB_PREFIX_ . 'customer_group` cg
INNER JOIN `' . _DB_PREFIX_ . 'cart_rule_group` crg ON cg.id_group = crg.id_group
WHERE cr.`id_cart_rule` = crg.`id_cart_rule`
AND cg.`id_customer` = ' . (int) $context->customer->id . '
LIMIT 1
)' : '') . '
)
AND (
cr.`reduction_product` <= 0
OR cr.`reduction_product` IN (
SELECT `id_product`
FROM `' . _DB_PREFIX_ . 'cart_product`
WHERE `id_cart` = ' . (int) $context->cart->id . '
)
)
AND cr.id_cart_rule NOT IN (SELECT id_cart_rule FROM ' . _DB_PREFIX_ . 'cart_cart_rule WHERE id_cart = ' . (int) $context->cart->id . ')
ORDER BY priority';
$result = Db::getInstance()->executeS($sql);
if ($result) {
$cart_rules = ObjectModel::hydrateCollection('CartRule', $result);
if ($cart_rules) {
foreach ($cart_rules as $cart_rule) {
if ($cart_rule->checkValidity($context, false, false)) {
$context->cart->addCartRule($cart_rule->id);
}
}
}
}
}
/**
* Launch sql query to create collection of objects
*
* @param bool $display_query If true, query will be displayed (for debug purpose)
* @return Collection
*/
public function getAll($display_query = false)
{
if ($this->is_hydrated) {
return $this;
}
$this->is_hydrated = true;
$alias = $this->generateAlias();
//$this->query->select($alias.'.*');
$this->query->from($this->definition['table'], $alias);
// If multilang, create association to lang table
if (!empty($this->definition['multilang'])) {
$this->join(self::LANG_ALIAS);
if ($this->id_lang) {
$this->where(self::LANG_ALIAS . '.id_lang', '=', $this->id_lang);
}
}
// Add join clause
foreach ($this->join_list as $data) {
$on = '(' . implode(') AND (', $data['on']) . ')';
switch ($data['type']) {
case self::LEFT_JOIN:
$this->query->leftJoin($data['table'], $data['alias'], $on);
break;
case self::INNER_JOIN:
$this->query->innerJoin($data['table'], $data['alias'], $on);
break;
case self::LEFT_OUTER_JOIN:
$this->query->leftOuterJoin($data['table'], $data['alias'], $on);
break;
}
}
// Shall we display query for debug ?
if ($display_query) {
echo $this->query . '<br />';
}
$this->results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($this->query);
$this->results = ObjectModel::hydrateCollection($this->classname, $this->results, $this->id_lang);
return $this;
}
/**
* @static
* @param JeproshopContext|null $context
* @return mixed
*/
public static function autoAddToCart(JeproshopContext $context = null)
{
if ($context === null) {
$context = JeproshopContext::getContext();
}
if (!JeproshopCartRuleModelCartRule::isFeaturePublished() || !JeproshopValidator::isLoadedObject($context->cart, 'cart_id')) {
return;
}
$db = JFactory::getDBO();
$query = "SELECT cart_rule.* FROM " . $db->quoteName('#__jeproshop_cart_rule') . " AS cart_rule LEFT JOIN " . $db->quoteName('#__jeproshop_cart_rule_shop');
$query .= " AS cart_rule_shop ON cart_rule.cart_rule_id = cart_rule_shop.cart_rule_id ";
$group_query = " LEFT JOIN " . $db->quoteName('#__jeproshop_cart_rule_group') . " AS cart_rule_group ON cart_rule.cart_rule_id = cart_rule_group.cart_rule_id ";
$query .= (!$context->customer->customer_id && JeproshopGroupModelGroup::isFeaturePublished() ? $group_query : "") . " LEFT JOIN ";
$query .= $db->quoteName('#__jeproshop_cart_rule_carrier') . " AS cart_rule_carrier ON cart_rule.cart_rule_id = cart_rule_carrier.cart_rule_id ";
$query .= $context->cart->carrier_id ? " LEFT JOIN " . $db->quoteName('#__jeproshop_carrier') . " AS carrier ON (carrier.reference_id = cart_rule_carrier.carrier_id AND carrier.deleted = 0)" : "";
$query .= " LEFT JOIN " . $db->quoteName('#__jeproshop_cart_rule_country') . " AS cart_rule_country ON cart_rule.cart_rule_id = cart_rule_country.";
$query .= "cart_rule_id WHERE cart_rule.published = 1 AND cart_rule.code = '' AND cart_rule.quantity > 0 AND cart_rule.date_from < '" . date('Y-m-d H:i:s') . "'\tAND cart_rule.date_to > '";
$query .= date('Y-m-d H:i:s') . "' AND ( cart_rule.customer_id = 0 " . ($context->customer->customer_id ? " OR cart_rule.customer_id = " . (int) $context->cart->customer_id : "");
$query .= ") AND ( cart_rule." . $db->quoteName('carrier_restriction') . " = 0 " . ($context->cart->carrier_id ? " OR carrier.carrier_id = " . (int) $context->cart->carrier_id : "");
$query .= " ) AND ( cart_rule." . $db->quoteName('shop_restriction') . " = 0 " . (JeproshopShopModelShop::isFeaturePublished() && $context->shop->shop_id ? " OR cart_rule_shop.shop_id = " . (int) $context->shop->shop_id : "");
$query .= " ) AND ( cart_rule." . $db->quoteName('group_restriction') . " = 0 ";
if ($context->customer->customer_id) {
$query = " OR 0 < ( SELECT customer_group." . $db->quoteName('group_id') . " FROM " . $db->quoteName('#__jeproshop_customer_group') . " AS customer_group INNER JOIN " . $db->quoteName('#__jeproshop_cart_rule_group');
$query .= " AS cart_rule_group ON customer_group.group_id = cart_rule_group.group_id WHERE cart_rule." . $db->quoteName('cart_rule_id') . " = cart_rule_group." . $db->quoteName('cart_rule_id') . " AND customer_group.";
$query .= $db->quoteName('customer_id') . " = " . (int) $context->customer->customer_id . " LIMIT 1\t)";
} else {
if (JeproshopGroupModelGroup::isFeaturePublished()) {
$query .= " OR cart_rule_group." . $db->quoteName('group_id') . " = " . (int) JeproshopSettingModelSetting::getValue('unidentified_group');
}
}
$query .= " ) AND ( cart_rule." . $db->quoteName('`reduction_product') . " <= 0 OR cart_rule." . $db->quoteName('reduction_product') . " IN ( SELECT " . $db->quoteName('product_id') . " FROM ";
$query .= $db->quoteName('#__jeproshop_cart_product') . " WHERE " . $db->quoteName('cart_id') . " = " . (int) $context->cart->cart_id . " ) ) AND cart_rule.cart_rule_id NOT IN (SELECT cart_rule_id FROM ";
$query .= $db->quoteName('#__jeproshop_cart_cart_rule') . " WHERE car_id = " . (int) $context->cart->cart_id . ") ORDER BY priority";
$db->setQuery($query);
$result = $db->loadObjectList();
if ($result) {
$cart_rules = ObjectModel::hydrateCollection('CartRule', $result);
if ($cart_rules) {
foreach ($cart_rules as $cart_rule) {
if ($cart_rule->checkValidity($context, false, false)) {
$context->cart->addCartRule($cart_rule->cart_rule_id);
}
}
}
}
}
private function getByNumberInterval($number_from, $number_to)
{
//this function is not there in OrderInvoice class, so I implemented by my own
$order_invoice_list = Db::getInstance()->executeS('
SELECT oi.*
FROM `' . _DB_PREFIX_ . 'order_invoice` oi
LEFT JOIN `' . _DB_PREFIX_ . 'orders` o ON (o.`id_order` = oi.`id_order`)
WHERE oi.id_order <= \'' . pSQL($number_to) . '\'
AND oi.id_order >= \'' . pSQL($number_from) . '\'
' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o') . '
ORDER BY oi.date_add ASC
');
return ObjectModel::hydrateCollection('OrderInvoice', $order_invoice_list);
}
/**
* @static
* @param $id_supply_order array
* @return array collection of OrderInvoice
*/
public static function getSupplyOrderCollection($id_supply_order)
{
if (!empty($id_supply_order)) {
$supply_order_list = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT so.*
FROM `' . _DB_PREFIX_ . 'supply_order` so
WHERE so.id_supply_order = ' . (int) $id_supply_order . '
ORDER BY so.`id_supply_order` DESC');
return ObjectModel::hydrateCollection('SupplyOrder', $supply_order_list);
}
}
/**
* @static
* @param Context|null $context
* @return mixed
*/
public static function autoAddToCart(Context $context = null)
{
if ($context === null) {
$context = Context::getContext();
}
if (!CartRule::isFeatureActive() || !Validate::isLoadedObject($context->cart)) {
return;
}
$result = Db::getInstance()->executeS('
SELECT cr.*
FROM ' . _DB_PREFIX_ . 'cart_rule cr
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND cr.date_from < "' . date('Y-m-d H:i:s') . '"
AND cr.date_to > "' . date('Y-m-d H:i:s') . '"
AND (
cr.id_customer = 0
' . ($context->customer->id ? 'OR cr.id_customer = ' . (int) $context->cart->id_customer : '') . '
)
AND (
cr.carrier_restriction = 0
' . ($context->cart->id_carrier ? 'OR crca.id_carrier = ' . (int) $context->cart->id_carrier : '') . '
)
AND (
cr.shop_restriction = 0
' . (Shop::isFeatureActive() && $context->shop->id ? 'OR crs.id_shop = ' . (int) $context->shop->id : '') . '
)
AND (
cr.group_restriction = 0
' . ($context->customer->id ? 'OR 0 < (
SELECT cg.id_group
FROM ' . _DB_PREFIX_ . 'customer_group cg
LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_group crg ON cg.id_group = crg.id_group
WHERE cr.id_cart_rule = crg.id_cart_rule
AND cg.id_customer = ' . (int) $context->customer->id . '
)' : '') . '
)
AND (
cr.reduction_product <= 0
OR cr.reduction_product IN (
SELECT id_product
FROM ' . _DB_PREFIX_ . 'cart_product
WHERE id_cart = ' . (int) $context->cart->id . '
)
)
AND cr.id_cart_rule NOT IN (SELECT id_cart_rule FROM ' . _DB_PREFIX_ . 'cart_cart_rule WHERE id_cart = ' . (int) $context->cart->id . ')
ORDER BY priority');
$cartRules = ObjectModel::hydrateCollection('CartRule', $result);
foreach ($cartRules as $cartRule) {
if ($cartRule->checkValidity($context, false, false)) {
$context->cart->addCartRule($cartRule->id);
}
}
}
