Exemplo n.º 1
0
    private static function getProductByIdParcel($id_parcel)
    {
        return Db::getInstance()->executeS('
			SELECT `id_product`, `id_product_attribute`
			FROM `' . _DB_PREFIX_ . bqSQL(self::$definition['table']) . '`
			WHERE `id_parcel`=' . (int) $id_parcel);
    }
Exemplo n.º 2
0
function homeslider_stripslashes_field($field)
{
    $quotes = array('"\\\'"', '"\'"');
    $dquotes = array('\'\\\\"\'', '\'"\'');
    $backslashes = array('"\\\\\\\\"', '"\\\\"');
    return '`' . bqSQL($field) . '` = replace(replace(replace(`' . bqSQL($field) . '`, ' . $quotes[0] . ', ' . $quotes[1] . '), ' . $dquotes[0] . ', ' . $dquotes[1] . '), ' . $backslashes[0] . ', ' . $backslashes[1] . ')';
}
Exemplo n.º 3
0
 public function __construct($name = null)
 {
     if ($this->name == null) {
         $this->name = $this->id;
     }
     if ($this->name != null) {
         if (self::$modulesCache === null) {
             self::$modulesCache = array();
             $db = Db::getInstance();
             $result = $db->ExecuteS('SELECT * FROM `' . bqSQL(_DB_PREFIX_ . $this->table) . '`', false);
             while ($row = $db->nextRow($result)) {
                 self::$modulesCache[$row['name']] = $row;
             }
         }
         if (isset(self::$modulesCache[$this->name])) {
             $this->active = true;
             $this->id = self::$modulesCache[$this->name]['id_module'];
             foreach (self::$modulesCache[$this->name] as $key => $value) {
                 if (property_exists($this, $key)) {
                     $this->{$key} = $value;
                 }
             }
             $this->_path = __PS_BASE_URI__ . 'modules/' . $this->name . '/';
         }
     }
 }
Exemplo n.º 4
0
    public function getData()
    {
        $currency = new Currency(Configuration::get('PS_CURRENCY_DEFAULT'));
        $this->query = 'SELECT SQL_CALC_FOUND_ROWS cr.code, ocr.name, COUNT(ocr.id_cart_rule) as total, ROUND(SUM(o.total_paid_real) / o.conversion_rate,2) as ca
				FROM ' . _DB_PREFIX_ . 'order_cart_rule ocr
				LEFT JOIN ' . _DB_PREFIX_ . 'orders o ON o.id_order = ocr.id_order
				LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule cr ON cr.id_cart_rule = ocr.id_cart_rule
				WHERE o.valid = 1
					' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o') . '
					AND o.invoice_date BETWEEN ' . $this->getDate() . '
				GROUP BY ocr.id_cart_rule';
        if (Validate::IsName($this->_sort)) {
            $this->query .= ' ORDER BY `' . bqSQL($this->_sort) . '`';
            if (isset($this->_direction) && (Tools::strtoupper($this->_direction) == 'ASC' || Tools::strtoupper($this->_direction) == 'DESC')) {
                $this->query .= ' ' . pSQL($this->_direction);
            }
        }
        if (($this->_start === 0 || Validate::IsUnsignedInt($this->_start)) && Validate::IsUnsignedInt($this->_limit)) {
            $this->query .= ' LIMIT ' . (int) $this->_start . ', ' . (int) $this->_limit;
        }
        $values = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($this->query);
        foreach ($values as &$value) {
            $value['ca'] = Tools::displayPrice($value['ca'], $currency);
        }
        $this->_values = $values;
        $this->_totalCount = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('SELECT FOUND_ROWS()');
    }
Exemplo n.º 5
0
 protected function getFilterQuery($keys_array = array(), $table)
 {
     $sql = '';
     foreach ($keys_array as $key) {
         if ($this->context->cookie->__isset($table . 'Filter_' . $key)) {
             $value = $this->context->cookie->{$table . 'Filter_' . $key};
             if (Validate::isSerializedArray($value)) {
                 $date = $this->module_instance->unSerialize($value);
                 if (!empty($date[0])) {
                     $sql .= '`' . bqSQL($key) . '` > "' . pSQL($date[0]) . '" AND ';
                 }
                 if (!empty($date[1])) {
                     $sql .= '`' . bqSQL($key) . '` < "' . pSQL($date[1]) . '" AND ';
                 }
             } else {
                 if ($value != '') {
                     $sql .= '`' . bqSQL($key) . '` LIKE "%' . pSQL($value) . '%" AND ';
                 }
             }
         }
     }
     if ($sql) {
         $sql = ' HAVING ' . Tools::substr($sql, 0, -4);
     }
     // remove 'AND ' from the end of query
     return $sql;
 }
Exemplo n.º 6
0
    public function getData()
    {
        $this->_totalCount = $this->getTotalCount();
        $this->query = 'SELECT m.name, SUM(od.product_quantity) as quantity, ROUND(SUM(od.product_quantity * od.product_price) / c.conversion_rate, 2) as sales
				FROM ' . _DB_PREFIX_ . 'order_detail od
				LEFT JOIN ' . _DB_PREFIX_ . 'product p ON (p.id_product = od.product_id)
				LEFT JOIN ' . _DB_PREFIX_ . 'orders o ON (o.id_order = od.id_order)
				LEFT JOIN ' . _DB_PREFIX_ . 'currency c ON (c.id_currency = o.id_currency)
				LEFT JOIN ' . _DB_PREFIX_ . 'manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
				WHERE o.invoice_date BETWEEN ' . $this->getDate() . '
					' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o') . '
					AND o.valid = 1
					AND m.id_manufacturer IS NOT NULL
				GROUP BY p.id_manufacturer';
        if (Validate::IsName($this->_sort)) {
            $this->query .= ' ORDER BY `' . bqSQL($this->_sort) . '`';
            if (isset($this->_direction) && Validate::isSortDirection($this->_direction)) {
                $this->query .= ' ' . $this->_direction;
            }
        }
        if (($this->_start === 0 || Validate::IsUnsignedInt($this->_start)) && Validate::IsUnsignedInt($this->_limit)) {
            $this->query .= ' LIMIT ' . (int) $this->_start . ', ' . (int) $this->_limit;
        }
        $this->_values = Db::getInstance()->executeS($this->query);
    }
Exemplo n.º 7
0
 protected function getFilterQuery($keys_array = array(), $table)
 {
     $sql = '';
     foreach ($keys_array as $key) {
         if ($this->context->cookie->{$table . 'Filter_' . $key} !== '' && $this->context->cookie->{$table . 'Filter_' . $key} !== false) {
             $value = $this->context->cookie->{$table . 'Filter_' . $key};
             if ($key == 'id_manifest') {
                 $sql .= '`id_manifest` ' . ($value ? '!=' : '=') . ' "0" AND ';
             } elseif (is_array(Tools::jsonDecode($value))) {
                 $date = Tools::jsonDecode($value);
                 $date = array_filter($date);
                 if (!$date) {
                     continue;
                 }
                 if (!empty($date[0])) {
                     $sql .= '`' . bqSQL($key) . '` > "' . pSQL($date[0]) . '" AND ';
                 }
                 if (!empty($date[1])) {
                     $sql .= '`' . bqSQL($key) . '` < "' . pSQL($date[1]) . '" AND ';
                 }
             } else {
                 $sql .= '`' . bqSQL($key) . '` LIKE "%' . pSQL($value) . '%" AND ';
             }
         }
     }
     if ($sql) {
         $sql = ' HAVING ' . Tools::substr($sql, 0, -4);
     }
     // remove 'AND ' from the end of query
     return $sql;
 }
Exemplo n.º 8
0
    /**
     * Load ObjectModel
     * @param $id
     * @param $id_lang
     * @param $entity ObjectModel
     * @param $entity_defs
     * @param $id_shop
     * @param $should_cache_objects
     * @throws PrestaShopDatabaseException
     */
    public function load($id, $id_lang, $entity, $entity_defs, $id_shop, $should_cache_objects)
    {
        // Load object from database if object id is present
        $cache_id = 'objectmodel_' . $entity_defs['classname'] . '_' . (int) $id . '_' . (int) $id_shop . '_' . (int) $id_lang;
        if (!$should_cache_objects || !Cache::isStored($cache_id)) {
            $sql = new DbQuery();
            $sql->from($entity_defs['table'], 'a');
            $sql->where('a.`' . bqSQL($entity_defs['primary']) . '` = ' . (int) $id);
            // Get lang informations
            if ($id_lang && isset($entity_defs['multilang']) && $entity_defs['multilang']) {
                $sql->leftJoin($entity_defs['table'] . '_lang', 'b', 'a.`' . bqSQL($entity_defs['primary']) . '` = b.`' . bqSQL($entity_defs['primary']) . '` AND b.`id_lang` = ' . (int) $id_lang);
                if ($id_shop && !empty($entity_defs['multilang_shop'])) {
                    $sql->where('b.`id_shop` = ' . (int) $id_shop);
                }
            }
            // Get shop informations
            if (Shop::isTableAssociated($entity_defs['table'])) {
                $sql->leftJoin($entity_defs['table'] . '_shop', 'c', 'a.`' . bqSQL($entity_defs['primary']) . '` = c.`' . bqSQL($entity_defs['primary']) . '` AND c.`id_shop` = ' . (int) $id_shop);
            }
            if ($object_datas = Db::getInstance()->getRow($sql)) {
                if (!$id_lang && isset($entity_defs['multilang']) && $entity_defs['multilang']) {
                    $sql = 'SELECT *
							FROM `' . bqSQL(_DB_PREFIX_ . $entity_defs['table']) . '_lang`
							WHERE `' . bqSQL($entity_defs['primary']) . '` = ' . (int) $id . ($id_shop && $entity->isLangMultishop() ? ' AND `id_shop` = ' . (int) $id_shop : '');
                    if ($object_datas_lang = Db::getInstance()->executeS($sql)) {
                        foreach ($object_datas_lang as $row) {
                            foreach ($row as $key => $value) {
                                if ($key != $entity_defs['primary'] && array_key_exists($key, $entity)) {
                                    if (!isset($object_datas[$key]) || !is_array($object_datas[$key])) {
                                        $object_datas[$key] = array();
                                    }
                                    $object_datas[$key][$row['id_lang']] = $value;
                                }
                            }
                        }
                    }
                }
                $entity->id = (int) $id;
                foreach ($object_datas as $key => $value) {
                    if (array_key_exists($key, $entity)) {
                        $entity->{$key} = $value;
                    } else {
                        unset($object_datas[$key]);
                    }
                }
                if ($should_cache_objects) {
                    Cache::store($cache_id, $object_datas);
                }
            }
        } else {
            $object_datas = Cache::retrieve($cache_id);
            if ($object_datas) {
                $entity->id = (int) $id;
                foreach ($object_datas as $key => $value) {
                    $entity->{$key} = $value;
                }
            }
        }
    }
Exemplo n.º 9
0
 public function delete($table, $where = false, $limit = false)
 {
     if ($this->_link) {
         $query = 'DELETE FROM `' . bqSQL($table) . '`' . ($where ? ' WHERE ' . $where : '') . ($limit ? ' LIMIT ' . (int) $limit : '');
         $res = mysql_query($query);
         return $res;
     }
     return false;
 }
Exemplo n.º 10
0
 protected static function _getScoreQuery($id_product, $id_shop, $id_currency, $id_country, $id_group)
 {
     $select = '(IF (NOW() >= `from` AND NOW() <= `to`, 1, 0) + ';
     foreach (array_reverse(SpecificPrice::getPriority((int) $id_product)) as $k => $field) {
         if ($field != 'id_shop') {
             $select .= ' IF (`' . bqSQL($field) . '` = ' . (int) ${$field} . ', ' . pow(2, $k + 1) . ', 0) + ';
         }
     }
     return rtrim($select, ' +') . ') `score`';
 }
 public static function insert($all_data)
 {
     $to_insert = array();
     if (is_array($all_data) && count($all_data)) {
         foreach ($all_data as $key => $data) {
             $to_insert[bqSQL($key)] = pSQL($data);
         }
     }
     Db::getInstance()->autoExecute(_DB_PREFIX_ . 'ebay_delivery_time_options', $to_insert, 'INSERT');
 }
Exemplo n.º 12
0
 public function postProcess()
 {
     global $currentIndex;
     if (isset($_POST['submitDatabase' . $this->table])) {
         if ($this->tabAccess['edit'] === '1') {
             foreach ($this->_fieldsDatabase as $field => $values) {
                 if (isset($values['required']) and $values['required']) {
                     if (($value = Tools::getValue($field)) == false and (string) $value != '0') {
                         $this->_errors[] = Tools::displayError('field') . ' <b>' . $values['title'] . '</b> ' . Tools::displayError('is required.');
                     }
                 }
             }
             if (!sizeof($this->_errors)) {
                 /* Datas are not saved in database but in config/settings.inc.php */
                 $settings = array();
                 foreach ($_POST as $k => $value) {
                     if ($value) {
                         $settings['_' . Tools::strtoupper($k) . '_'] = $value;
                     }
                 }
                 rewriteSettingsFile(NULL, NULL, $settings);
                 Tools::redirectAdmin($currentIndex . '&conf=6' . '&token=' . $this->token);
             }
         } else {
             $this->_errors[] = Tools::displayError('You do not have permission to edit here.');
         }
     }
     if (Tools::isSubmit('submitEngine')) {
         if (!isset($_POST['tablesBox']) or !sizeof($_POST['tablesBox'])) {
             $this->_errors[] = Tools::displayError('You did not select any tables');
         } else {
             $available_engines = $this->_getEngines();
             $tables_status = $this->_getTablesStatus();
             $tables_engine = array();
             foreach ($tables_status as $table) {
                 $tables_engine[$table['Name']] = $table['Engine'];
             }
             $engineType = pSQL(Tools::getValue('engineType'));
             /* Datas are not saved in database but in config/settings.inc.php */
             $settings = array('_MYSQL_ENGINE_' => $engineType);
             rewriteSettingsFile(NULL, NULL, $settings);
             foreach ($_POST['tablesBox'] as $table) {
                 if ($engineType == $tables_engine[$table]) {
                     $this->_errors[] = $table . ' ' . $this->l('is already in') . ' ' . $engineType;
                 } else {
                     if (!Db::getInstance()->Execute('ALTER TABLE `' . bqSQL($table) . '` ENGINE=`' . bqSQL($engineType) . '`')) {
                         $this->_errors[] = $this->l('Can\'t change engine for') . ' ' . $table;
                     } else {
                         echo '<div class="conf confirm"><img src="../img/admin/ok.gif" alt="' . $this->l('Confirmation') . '" />' . $this->l('Engine change of') . ' ' . $table . ' ' . $this->l('to') . ' ' . $engineType . '</div>';
                     }
                 }
             }
         }
     }
 }
Exemplo n.º 13
0
function update_order_canada()
{
    $sql = 'SHOW TABLES LIKE \'' . _DB_PREFIX_ . 'order_tax\'';
    $table = Db::getInstance()->ExecuteS($sql);
    if (!count($table)) {
        Db::getInstance()->Execute('
		CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'order_tax` (
		  `id_order` int(11) NOT NULL,
		  `tax_name` varchar(40) NOT NULL,
		  `tax_rate` decimal(6,3) NOT NULL,
		  `amount` decimal(20,6) NOT NULL
		) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8');
        $address_field = Configuration::get('PS_TAX_ADDRESS_TYPE');
        $sql = 'SELECT `id_order`
					FROM `' . _DB_PREFIX_ . 'orders` o
					LEFT JOIN `' . _DB_PREFIX_ . 'address` a ON (a.`id_address` = o.`' . bqSQL($address_field) . '`)
					LEFT JOIN `' . _DB_PREFIX_ . 'country` c ON (c.`id_country` = a.`id_country`)
					WHERE c.`iso_code` = "CA"';
        $id_order_list = Db::getInstance()->ExecuteS($sql);
        $values = '';
        foreach ($id_order_list as $id_order) {
            $amount = array();
            $id_order = $id_order['id_order'];
            $order = new Order((int) $id_order);
            if (!Validate::isLoadedObject($order)) {
                continue;
            }
            $products = $order->getProducts();
            foreach ($products as $product) {
                if (!array_key_exists($product['tax_name'], $amount)) {
                    $amount[$product['tax_name']] = array('amount' => 0, 'rate' => $product['tax_rate']);
                }
                if ($order->getTaxCalculationMethod() == PS_TAX_EXC) {
                    $total_product = $product['product_price'] * $product['product_quantity'];
                    $amount_tmp = Tools::ps_round($total_product * ($product['tax_rate'] / 100), 2);
                    $amount[$product['tax_name']]['amount'] += Tools::ps_round($total_product * ($product['tax_rate'] / 100), 2);
                } else {
                    $total_product = $product['product_price'] * $product['product_quantity'];
                    $amount_tmp = Tools::ps_round($total_product - $total_product / (1 + $product['tax_rate'] / 100), 2);
                    $amount[$product['tax_name']]['amount'] += Tools::ps_round($total_product - $total_product / (1 + $product['tax_rate'] / 100), 2);
                }
            }
            foreach ($amount as $tax_name => $tax_infos) {
                $values .= '(' . (int) $order->id . ', \'' . pSQL($tax_name) . '\', \'' . pSQL($tax_infos['rate']) . '\', ' . (double) $tax_infos['amount'] . '),';
            }
            unset($order);
        }
        if (!empty($values)) {
            $values = rtrim($values, ",");
            Db::getInstance()->Execute('
			INSERT INTO `' . _DB_PREFIX_ . 'order_tax` (id_order, tax_name, tax_rate, amount)
			VALUES ' . $values);
        }
    }
}
Exemplo n.º 14
0
 protected static function _getScoreQuery($id_product, $id_shop, $id_currency, $id_country, $id_group)
 {
     $select = '(';
     $now = date('Y-m-d H:i:s');
     $select .= ' IF (\'' . $now . '\' >= `from` AND \'' . $now . '\' <= `to`, ' . pow(2, 0) . ', 0) + ';
     $priority = SpecificPrice::getPriority($id_product);
     foreach (array_reverse($priority) as $k => $field) {
         $select .= ' IF (`' . bqSQL($field) . '` = ' . (int) ${$field} . ', ' . pow(2, $k + 1) . ', 0) + ';
     }
     return rtrim($select, ' +') . ') AS `score`';
 }
Exemplo n.º 15
0
 /**
  * Returns image type definitions
  *
  * @param string|null Image type
  * @return array Image type definitions
  */
 public static function getImagesTypes($type = null)
 {
     if (!isset(self::$images_types_cache[$type])) {
         $where = 'WHERE 1';
         if (!empty($type)) {
             $where .= ' AND `' . bqSQL($type) . '` = 1 ';
         }
         $query = 'SELECT * FROM `' . _DB_PREFIX_ . 'image_type` ' . $where . ' ORDER BY `name` ASC';
         self::$images_types_cache[$type] = Db::getInstance()->executeS($query);
     }
     return self::$images_types_cache[$type];
 }
 public static function replace($data)
 {
     $to_insert = array();
     foreach ($data as $key => $value) {
         $to_insert[bqSQL($key)] = pSQL($value);
     }
     if (version_compare(_PS_VERSION_, '1.5', '>')) {
         Db::getInstance()->insert('ebay_category_condition_configuration', $to_insert, false, false, Db::REPLACE);
     } else {
         Db::getInstance()->execute('REPLACE INTO `' . _DB_PREFIX_ . 'ebay_category_condition_configuration` (`' . implode('` , `', array_keys($to_insert)) . '`) VALUES (\'' . implode('\', \'', $to_insert) . '\')');
     }
 }
Exemplo n.º 17
0
    public static function getAllData($filter = '', $limit = '', $order_by = '', $order_way = '')
    {
        if (!in_array($order_by, self::$available_order_by)) {
            $order_by = self::DEFAULT_ORDER_BY;
        }
        if (!in_array($order_way, self::$available_order_way)) {
            $order_way = self::DEFAULT_ORDER_WAY;
        }
        return DB::getInstance()->executeS('
			SELECT `id_postcode`, `postcode`, `region`, `city`, `address`
			FROM `' . _DB_PREFIX_ . _DPDGROUP_POSTCODE_DB_ . '`
			' . $filter . 'ORDER BY `' . bqSQL($order_by) . '` ' . pSQL($order_way) . $limit);
    }
Exemplo n.º 18
0
    public function getList($order_by, $order_way, $filter, $start, $pagination)
    {
        $order_way = Validate::isOrderWay($order_way) ? $order_way : 'ASC';
        return Db::getInstance()->executeS('
			SELECT m.`id_manifest_ws` 				AS `id_manifest_ws`,
				COUNT(p.`id_parcel`) 				AS `count_parcels`,
				COUNT(DISTINCT m.`id_package_ws`)	AS `count_orders`,
				m.`date_add` 						AS `date_add`
			FROM `' . _DB_PREFIX_ . _DPDPOLAND_MANIFEST_DB_ . '` m
			LEFT JOIN `' . _DB_PREFIX_ . _DPDPOLAND_PARCEL_DB_ . '` p ON (p.`id_package_ws` = m.`id_package_ws`)
			GROUP BY `id_manifest_ws`
			' . $filter . '
			ORDER BY `' . bqSQL($order_by) . '` ' . pSQL($order_way) . ($start !== null && $pagination !== null ? ' LIMIT ' . (int) $start . ', ' . (int) $pagination : ''));
    }
Exemplo n.º 19
0
    public function getData()
    {
        $currency = new Currency(Configuration::get('PS_CURRENCY_DEFAULT'));
        $date_between = $this->getDate();
        $array_date_between = explode(' AND ', $date_between);
        $this->query = 'SELECT SQL_CALC_FOUND_ROWS p.reference, p.id_product, pl.name,
				ROUND(AVG(od.product_price / o.conversion_rate), 2) as avgPriceSold,
				IFNULL(stock.quantity, 0) as quantity,
				IFNULL(SUM(od.product_quantity), 0) AS totalQuantitySold,
				ROUND(IFNULL(IFNULL(SUM(od.product_quantity), 0) / (1 + LEAST(TO_DAYS(' . $array_date_between[1] . '), TO_DAYS(NOW())) - GREATEST(TO_DAYS(' . $array_date_between[0] . '), TO_DAYS(product_shop.date_add))), 0), 2) as averageQuantitySold,
				ROUND(IFNULL(SUM((od.product_price * od.product_quantity) / o.conversion_rate), 0), 2) AS totalPriceSold,
				(
					SELECT IFNULL(SUM(pv.counter), 0)
					FROM ' . _DB_PREFIX_ . 'page pa
					LEFT JOIN ' . _DB_PREFIX_ . 'page_viewed pv ON pa.id_page = pv.id_page
					LEFT JOIN ' . _DB_PREFIX_ . 'date_range dr ON pv.id_date_range = dr.id_date_range
					WHERE pa.id_object = p.id_product AND pa.id_page_type = ' . (int) Page::getPageTypeByName('product') . '
					AND dr.time_start BETWEEN ' . $date_between . '
					AND dr.time_end BETWEEN ' . $date_between . '
				) AS totalPageViewed,
				product_shop.active
				FROM ' . _DB_PREFIX_ . 'product p
				' . Shop::addSqlAssociation('product', 'p') . '
				LEFT JOIN ' . _DB_PREFIX_ . 'product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = ' . (int) $this->getLang() . ' ' . Shop::addSqlRestrictionOnLang('pl') . ')
				LEFT JOIN ' . _DB_PREFIX_ . 'order_detail od ON od.product_id = p.id_product
				LEFT JOIN ' . _DB_PREFIX_ . 'orders o ON od.id_order = o.id_order
				' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o') . '
				' . Product::sqlStock('p', 0) . '
				WHERE o.valid = 1
				AND o.invoice_date BETWEEN ' . $date_between . '
				GROUP BY od.product_id';
        if (Validate::IsName($this->_sort)) {
            $this->query .= ' ORDER BY `' . bqSQL($this->_sort) . '`';
            if (isset($this->_direction) && Validate::isSortDirection($this->_direction)) {
                $this->query .= ' ' . $this->_direction;
            }
        }
        if (($this->_start === 0 || Validate::IsUnsignedInt($this->_start)) && Validate::IsUnsignedInt($this->_limit)) {
            $this->query .= ' LIMIT ' . (int) $this->_start . ', ' . (int) $this->_limit;
        }
        $values = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($this->query);
        foreach ($values as &$value) {
            $value['avgPriceSold'] = Tools::displayPrice($value['avgPriceSold'], $currency);
            $value['totalPriceSold'] = Tools::displayPrice($value['totalPriceSold'], $currency);
        }
        unset($value);
        $this->_values = $values;
        $this->_totalCount = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('SELECT FOUND_ROWS()');
    }
Exemplo n.º 20
0
 /**
  * Returns image type definitions
  *
  * @param string|null Image type
  * @param bool        $order_by_size
  * @return array Image type definitions
  * @throws PrestaShopDatabaseException
  */
 public static function getImagesTypes($type = null, $order_by_size = false)
 {
     if (!isset(self::$images_types_cache[$type])) {
         $where = 'WHERE 1';
         if (!empty($type)) {
             $where .= ' AND `' . bqSQL($type) . '` = 1 ';
         }
         if ($order_by_size) {
             $query = 'SELECT * FROM `' . _DB_PREFIX_ . 'image_type` ' . $where . ' ORDER BY `width` DESC, `height` DESC, `name`ASC';
         } else {
             $query = 'SELECT * FROM `' . _DB_PREFIX_ . 'image_type` ' . $where . ' ORDER BY `name` ASC';
         }
         self::$images_types_cache[$type] = Db::getInstance()->executeS($query);
     }
     return self::$images_types_cache[$type];
 }
Exemplo n.º 21
0
    public function __construct($id = NULL, $id_lang = NULL)
    {
        $this->def = ObjectModel::getDefinition($this);
        // Check if the id configuration is set in the configuration_lang table.
        // Otherwise configuration is not set as translated configuration.
        if ($id !== null) {
            $id_translated = Db::getInstance()->executeS('				SELECT `' . bqSQL($this->def['primary']) . '`
				FROM `' . bqSQL(_DB_PREFIX_ . $this->def['table']) . '_lang`
				WHERE `' . bqSQL($this->def['primary']) . '`=' . (int) $id . ' LIMIT 0,1
			');
            if (empty($id_translated)) {
                $id = null;
            }
        }
        parent::__construct($id, $id_lang);
    }
    public static function insertOrUpdate($product_id, $data)
    {
        if (!count($data)) {
            return;
        }
        $to_insert = array();
        $fields_strs = array();
        foreach ($data as $key => $value) {
            $to_insert[bqSQL($key)] = pSQL($value);
            $fields_strs[] = '`' . bqSQL($key) . '` = ' . pSQL($value);
        }
        $sql = 'INSERT INTO `' . _DB_PREFIX_ . 'ebay_product_configuration` (`id_product`, `' . implode('`,`', array_keys($to_insert)) . '`)
			VALUES (' . (int) $product_id . ', ' . implode(',', $to_insert) . ')
			ON DUPLICATE KEY UPDATE ';
        $sql .= implode(',', $fields_strs);
        return Db::getInstance()->execute($sql);
    }
Exemplo n.º 23
0
 public function postProcess()
 {
     /* PrestaShop demo mode */
     if (_PS_MODE_DEMO_) {
         $this->_errors[] = Tools::displayError('This functionnality has been disabled.');
         return;
     }
     /* PrestaShop demo mode*/
     if (Tools::isSubmit('submitAddaccess') and $action = Tools::getValue('action') and $id_tab = (int) Tools::getValue('id_tab') and $id_profile = (int) Tools::getValue('id_profile') and $this->tabAccess['edit'] == 1) {
         if ($id_tab == -1 and $action == 'all' and (int) Tools::getValue('perm') == 0) {
             Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'access` SET `view` = ' . (int) Tools::getValue('perm') . ', `add` = ' . (int) Tools::getValue('perm') . ', `edit` = ' . (int) Tools::getValue('perm') . ', `delete` = ' . (int) Tools::getValue('perm') . ' WHERE `id_profile` = ' . (int) $id_profile . ' AND `id_tab` != 31');
         } elseif ($id_tab == -1 and $action == 'all') {
             Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'access` SET `view` = ' . (int) Tools::getValue('perm') . ', `add` = ' . (int) Tools::getValue('perm') . ', `edit` = ' . (int) Tools::getValue('perm') . ', `delete` = ' . (int) Tools::getValue('perm') . ' WHERE `id_profile` = ' . (int) $id_profile);
         } elseif ($id_tab == -1) {
             Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'access` SET `' . bqSQL($action) . '` = ' . (int) Tools::getValue('perm') . ' WHERE `id_profile` = ' . (int) $id_profile);
         } elseif ($action == 'all') {
             Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'access` SET `view` = ' . (int) Tools::getValue('perm') . ', `add` = ' . (int) Tools::getValue('perm') . ', `edit` = ' . (int) Tools::getValue('perm') . ', `delete` = ' . (int) Tools::getValue('perm') . ' WHERE `id_tab` = ' . (int) $id_tab . ' AND `id_profile` = ' . (int) $id_profile);
         } else {
             Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'access` SET `' . bqSQL($action) . '` = ' . (int) Tools::getValue('perm') . ' WHERE `id_tab` = ' . (int) $id_tab . ' AND `id_profile` = ' . (int) $id_profile);
         }
     }
 }
Exemplo n.º 24
0
 /**
  * @see DbCore::set_db()
  */
 public function set_db($db_name)
 {
     return $this->link->query('USE `' . bqSQL($db_name) . '`');
 }
Exemplo n.º 25
0
    public function getLastElementsForNotify($element)
    {
        $element = bqSQL($element);
        $max = Db::getInstance()->getValue('
			SELECT MAX(`id_' . $element . '`) as `id_' . $element . '`
			FROM `' . _DB_PREFIX_ . $element . ($element == 'order' ? 's' : '') . '`');
        // if no rows in table, set max to 0
        if ((int) $max < 1) {
            $max = 0;
        }
        return (int) $max;
    }
Exemplo n.º 26
0
 /**
  * Execute a DELETE query
  *
  * @param string $table Name of the table to delete
  * @param string $where WHERE clause on query
  * @param int $limit Number max of rows to delete
  * @param bool $use_cache Use cache or not
  * @return bool
  */
 public function delete($table, $where = '', $limit = 0, $use_cache = true)
 {
     $this->result = false;
     $sql = 'DELETE FROM `' . bqSQL($table) . '`' . ($where ? ' WHERE ' . $where : '') . ($limit ? ' LIMIT ' . (int) $limit : '');
     $res = $this->query($sql);
     if ($use_cache && $this->is_cache_enabled) {
         Cache::getInstance()->deleteQuery($sql);
     }
     return (bool) $res;
 }
Exemplo n.º 27
0
    /**
     * Return the list of shop by id
     *
     * @param int $id
     * @param string $identifier
     * @param string $table
     * @return array
     */
    public static function getShopById($id, $identifier, $table)
    {
        return Db::getInstance()->executeS('
			SELECT `id_shop`, `' . bqSQL($identifier) . '`
			FROM `' . _DB_PREFIX_ . bqSQL($table) . '_shop`
			WHERE `' . bqSQL($identifier) . '` = ' . (int) $id);
    }
Exemplo n.º 28
0
    /**
     * This tricky method generates a SQL clause to check if ranged data are overloaded by multishop
     *
     * @since 1.5.0
     *
     * @param string $range_table Range table
     *
     * @return string SQL quoer to get the delivery range table in this Shop(Group)
     */
    public static function sqlDeliveryRangeShop($range_table, $alias = 'd')
    {
        if (Shop::getContext() == Shop::CONTEXT_ALL) {
            $where = 'AND d2.id_shop IS NULL AND d2.id_shop_group IS NULL';
        } elseif (Shop::getContext() == Shop::CONTEXT_GROUP) {
            $where = 'AND ((d2.id_shop_group IS NULL OR d2.id_shop_group = ' . Shop::getContextShopGroupID() . ') AND d2.id_shop IS NULL)';
        } else {
            $where = 'AND (d2.id_shop = ' . Shop::getContextShopID() . ' OR (d2.id_shop_group = ' . Shop::getContextShopGroupID() . '
					AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))';
        }
        $sql = 'AND ' . $alias . '.id_delivery = (
					SELECT d2.id_delivery
					FROM ' . _DB_PREFIX_ . 'delivery d2
					WHERE d2.id_carrier = `' . bqSQL($alias) . '`.id_carrier
						AND d2.id_zone = `' . bqSQL($alias) . '`.id_zone
						AND d2.`id_' . bqSQL($range_table) . '` = `' . bqSQL($alias) . '`.`id_' . bqSQL($range_table) . '`
						' . $where . '
					ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
					LIMIT 1
				)';
        return $sql;
    }
Exemplo n.º 29
0
 public function truncateTable($table)
 {
     switch ($table) {
         case 'customer':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'customer');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'customer_group');
             break;
         case 'address':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'address');
             break;
         case 'country':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'state');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'country');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'country_lang');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'country');
         case 'group':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'customer_group');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'group_lang');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'group');
             break;
         case 'combination':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_attribute');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_attribute_shop');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_attribute_combination');
             break;
         case 'category':
             Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'category` WHERE id_category != 1');
             Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'category_lang` WHERE id_category != 1');
             Db::getInstance()->execute('ALTER TABLE `' . _DB_PREFIX_ . 'category` AUTO_INCREMENT = 2 ');
             foreach (scandir(_PS_CAT_IMG_DIR_) as $d) {
                 if (preg_match('/^[0-9]+(\\-(.*))?\\.jpg$/', $d)) {
                     unlink(_PS_CAT_IMG_DIR_ . $d);
                 }
             }
             Image::clearTmpDir();
             break;
         case 'product':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_shop');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'feature_product');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_lang');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'category_product');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_tag');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'image');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'image_lang');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_attribute');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_attribute_shop');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'product_attribute_combination');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'specific_price');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'specific_price_priority');
             Image::deleteAllImages(_PS_PROD_IMG_DIR_);
             Image::clearTmpDir();
             @mkdir(_PS_PROD_IMG_DIR_);
             break;
         case 'manufacturer':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'manufacturer');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'manufacturer_lang');
             foreach (scandir(_PS_MANU_IMG_DIR_) as $d) {
                 if (preg_match('/^[0-9]+(\\-(.*))?\\.jpg$/', $d)) {
                     unlink(_PS_MANU_IMG_DIR_ . $d);
                 }
             }
             Image::clearTmpDir();
             break;
         case 'Suppliers':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'supplier');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'supplier_lang');
             foreach (scandir(_PS_SUPP_IMG_DIR_) as $d) {
                 if (preg_match('/^[0-9]+(\\-(.*))?\\.jpg$/', $d)) {
                     unlink(_PS_SUPP_IMG_DIR_ . $d);
                 }
             }
             Image::clearTmpDir();
             break;
         case 'attribute':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'attribute');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'attribute_lang');
             break;
         case 'attributegroup':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'attribute_group');
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . 'attribute_group_lang');
             break;
         case 'currency':
         case 'customer':
         case 'zone':
         case 'state':
             Db::getInstance()->execute('TRUNCATE TABLE `' . _DB_PREFIX_ . bqSQL($table) . '`');
             break;
     }
     return true;
 }
Exemplo n.º 30
-1
    public function getList($order_by, $order_way, $filter, $start, $pagination)
    {
        $order_way = Validate::isOrderWay($order_way) ? $order_way : 'ASC';
        $id_shop = (int) Context::getContext()->shop->id;
        $id_lang = (int) Context::getContext()->language->id;
        if (version_compare(_PS_VERSION_, '1.5', '<')) {
            $countries = DB::getInstance()->executeS('
				SELECT
					c.`id_country` AS `id_country`,
					cl.`name` AS `name`,
					c.`iso_code` AS `iso_code`,
					IF(dpdc.`enabled` IS NULL, 1, dpdc.`enabled`) AS `enabled`
				FROM `' . _DB_PREFIX_ . 'country` c
				LEFT JOIN `' . _DB_PREFIX_ . _DPDPOLAND_COUNTRY_DB_ . '` dpdc ON (dpdc.`id_country` = c.`id_country` AND dpdc.`id_shop` = "' . (int) $id_shop . '")
				LEFT JOIN `' . _DB_PREFIX_ . 'country_lang` cl ON (cl.`id_country` = c.`id_country` AND cl.`id_lang` = "' . (int) $id_lang . '")' . $filter . ($order_by && $order_way ? ' ORDER BY `' . bqSQL($order_by) . '` ' . pSQL($order_way) : '') . ($start !== null && $pagination !== null ? ' LIMIT ' . (int) $start . ', ' . (int) $pagination : ''));
        } else {
            $countries = DB::getInstance()->executeS('
				SELECT
					c.`id_country` AS `id_country`,
					cl.`name` AS `name`,
					c.`iso_code` AS `iso_code`,
					IF(dpdc.`enabled` IS NULL, 1, dpdc.`enabled`) AS `enabled`
				FROM `' . _DB_PREFIX_ . 'country` c
				LEFT JOIN `' . _DB_PREFIX_ . _DPDPOLAND_COUNTRY_DB_ . '` dpdc ON (dpdc.`id_country` = c.`id_country` AND dpdc.`id_shop` = "' . (int) $id_shop . '")
				LEFT JOIN `' . _DB_PREFIX_ . 'country_shop` cs ON (cs.`id_country` = c.`id_country`)
				LEFT JOIN `' . _DB_PREFIX_ . 'country_lang` cl ON (cl.`id_country` = c.`id_country` AND cl.`id_lang` = "' . (int) $id_lang . '")
				WHERE cs.`id_shop` = "' . (int) $id_shop . '" ' . $filter . ($order_by && $order_way ? ' ORDER BY `' . bqSQL($order_by) . '` ' . pSQL($order_way) : '') . ($start !== null && $pagination !== null ? ' LIMIT ' . (int) $start . ', ' . (int) $pagination : ''));
        }
        if (!$countries) {
            $countries = array();
        }
        return $countries;
    }