PHP DbQuery::where方法代码示例

 /**
  * Gets reference, ean13 and upc of the current product
  * Stores it in stock for stock_mvt integrity and history purposes
  */
 protected function getProductInformations()
 {
     // if combinations
     if ((int) $this->id_product_attribute > 0) {
         $query = new DbQuery();
         $query->select('reference, ean13, upc');
         $query->from('product_attribute');
         $query->where('id_product = ' . (int) $this->id_product);
         $query->where('id_product_attribute = ' . (int) $this->id_product_attribute);
         $rows = Db::getInstance()->executeS($query);
         if (!is_array($rows)) {
             return;
         }
         foreach ($rows as $row) {
             $this->reference = $row['reference'];
             $this->ean13 = $row['ean13'];
             $this->upc = $row['upc'];
         }
     } else {
         // else, simple product
         $product = new Product((int) $this->id_product);
         if (Validate::isLoadedObject($product)) {
             $this->reference = $product->reference;
             $this->ean13 = $product->ean13;
             $this->upc = $product->upc;
         }
     }
 }

    /**
     * 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;
                }
            }
        }
    }

 private static function getCombinationIdByIdCombination($id_product, $id_combination)
 {
     $datas = explode('-', $id_combination);
     if (empty($datas[1])) {
         return 0;
     }
     $query = new DbQuery();
     $query->select('pa.id_product_attribute');
     $query->from('product_attribute', 'pa');
     $query->where('pa.id_product_attribute = \'' . pSQL($datas[1]) . '\'');
     $query->where('pa.id_product = ' . (int) $id_product);
     return Db::getInstance()->getValue($query);
 }

    public function renderView()
    {
        $badges_feature = new Collection('badge', $this->context->language->id);
        $badges_feature->where('type', '=', 'feature');
        $badges_feature->orderBy('id_group');
        $badges_feature->orderBy('group_position');
        $badges_achievement = new Collection('badge', $this->context->language->id);
        $badges_achievement->where('type', '=', 'achievement');
        $badges_achievement->orderBy('id_group');
        $badges_achievement->orderBy('group_position');
        $badges_international = new Collection('badge', $this->context->language->id);
        $badges_international->where('type', '=', 'international');
        $badges_international->orderBy('id_group');
        $badges_international->orderBy('group_position');
        $groups = array();
        $query = new DbQuery();
        $query->select('DISTINCT(b.`id_group`), bl.group_name, b.type');
        $query->from('badge', 'b');
        $query->join('
			LEFT JOIN `' . _DB_PREFIX_ . 'badge_lang` bl ON bl.`id_badge` = b.`id_badge`');
        $query->where('bl.id_lang = ' . (int) $this->context->language->id);
        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);
        foreach ($result as $res) {
            $groups['badges_' . $res['type']][$res['id_group']] = $res['group_name'];
        }
        $badges_type = array('badges_feature' => array('name' => $this->l('Features'), 'badges' => $badges_feature), 'badges_achievement' => array('name' => $this->l('Achievements'), 'badges' => $badges_achievement), 'badges_international' => array('name' => $this->l('International'), 'badges' => $badges_international));
        $levels = array(1 => $this->l('1. Beginner'), 2 => $this->l('2. Pro'), 3 => $this->l('3. Expert'), 4 => $this->l('4. Wizard'), 5 => $this->l('5. Guru'), 6 => $this->l('6. Legend'));
        $this->tpl_view_vars = array('badges_type' => $badges_type, 'current_level_percent' => (int) Configuration::get('GF_CURRENT_LEVEL_PERCENT'), 'current_level' => (int) Configuration::get('GF_CURRENT_LEVEL'), 'groups' => $groups, 'levels' => $levels);
        if (version_compare(_PS_VERSION_, '1.5.6.0', '>')) {
            $this->base_tpl_view = 'view_bt.tpl';
        }
        return parent::renderView();
    }

 protected function getQuantitySold($id_product, $id_product_attribute, $coverage)
 {
     $query = new DbQuery();
     $query->select('SUM(' . PP::sqlQty('product_quantity', 'od') . ')');
     $query->from('order_detail', 'od');
     $query->leftJoin('orders', 'o', 'od.id_order = o.id_order');
     $query->leftJoin('order_history', 'oh', 'o.date_upd = oh.date_add');
     $query->leftJoin('order_state', 'os', 'os.id_order_state = oh.id_order_state');
     $query->where('od.product_id = ' . (int) $id_product);
     $query->where('od.product_attribute_id = ' . (int) $id_product_attribute);
     $query->where('TO_DAYS(NOW()) - TO_DAYS(oh.date_add) <= ' . (int) $coverage);
     $query->where('o.valid = 1');
     $query->where('os.logable = 1 AND os.delivery = 1 AND os.shipped = 1');
     $quantity = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
     return $quantity;
 }

 /**
  * Returns id_erpip_supply_order_receipt_history for a given id_supply_order_receipt_history
  * @param int $id_supply_order_receipt_history
  * @return int $id_erpip_supply_order_receipt_history
  */
 public static function getErpAssociation($id_supply_order_receipt_history)
 {
     $query = new DbQuery();
     $query->select('id_erpip_supply_order_receipt_history');
     $query->from('erpip_supply_order_receipt_history');
     $query->where('id_supply_order_receipt_history = ' . (int) $id_supply_order_receipt_history);
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
 }

 /**
  * Returns id_erpip_supplier for a given id_supplier
  * @param int $id_supplier
  * @return int $id_erpip_supplier
  */
 public static function getErpSupplierIdBySupplierId($id_supplier)
 {
     $query = new DbQuery();
     $query->select('id_erpip_supplier');
     $query->from('erpip_supplier');
     $query->where('id_supplier = ' . (int) $id_supplier);
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
 }

 public function getStockValue()
 {
     $query = new DbQuery();
     $query->select('SUM(s.`price_te` * (s.`physical_quantity`+s.`physical_quantity_remainder`)');
     $query->from('stock', 's');
     $query->where('s.`id_warehouse` = ' . (int) $this->id);
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
 }

 public function getNextBadgeId()
 {
     $query = new DbQuery();
     $query->select('b.`id_badge`');
     $query->from('badge', 'b');
     $query->where('b.id_group = \'' . pSQL($this->id_group) . '\' AND b.validated = 0');
     $query->orderBy('b.group_position');
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
 }

 /**
  * For a given id_stock_mvt_reason, tells if it exists
  *
  * @since 1.5.0
  * @param int $id_stock_mvt_reason
  * @return bool
  */
 public static function exists($id_stock_mvt_reason)
 {
     $query = new DbQuery();
     $query->select('smr.id_stock_mvt_reason');
     $query->from('stock_mvt_reason', 'smr');
     $query->where('smr.id_stock_mvt_reason = ' . (int) $id_stock_mvt_reason);
     $query->where('smr.deleted = 0');
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
 }

 private function getFieldsValues()
 {
     $sql = new DbQuery();
     $sql->select('*');
     $sql->from('expressmailing_fax');
     $sql->where('campaign_id = ' . $this->campaign_id);
     $result = Db::getInstance()->getRow($sql);
     $this->campaign_api_message_id = $result['campaign_api_message_id'];
     return true;
 }

 public static function getImageContentIdsByIdImage($id_image)
 {
     // build query
     $query = new DbQuery();
     $query->select('id_stock_image_content');
     $query->from('stock_image_content', 'sic');
     $query->where('id_stock_image=' . (int) $id_image);
     $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);
     return $result;
 }

 public static function getByProductId($id_product)
 {
     if (!Validate::isUnsignedInt($id_product)) {
         die(Tools::displayError());
     }
     $sql = new DbQuery();
     $sql->select('id_simpleblog_post, id_product');
     $sql->from('simpleblog_related_post');
     $sql->where('id_product = ' . $id_product);
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
 }

 public static function getIdBySlug($slug)
 {
     if (!Validate::isLinkRewrite($slug)) {
         return Tools::displayError('getIdBySlug - invalid slug');
     }
     $sql = new DbQuery();
     $sql->select('id_simpleblog_post_type');
     $sql->from('simpleblog_post_type', 'sbpt');
     $sql->where('slug = \'' . $slug . '\'');
     return Db::getInstance()->getValue($sql);
 }

    /**
     * For a given product and warehouse, gets the WarehouseProductLocation corresponding ID
     *
     * @param int $id_product
     * @param int $id_product_attribute
     * @param int $id_supplier
     * @return int $id_warehouse_product_location ID of the WarehouseProductLocation
     */
    public static function getIdByProductAndWarehouse($id_product, $id_product_attribute, $id_warehouse)
    {
        // build query
        $query = new DbQuery();
        $query->select('wpl.id_warehouse_product_location');
        $query->from('warehouse_product_location', 'wpl');
        $query->where('wpl.id_product = ' . (int) $id_product . '
			AND wpl.id_product_attribute = ' . (int) $id_product_attribute . '
			AND wpl.id_warehouse = ' . (int) $id_warehouse);
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
    }