本文整理汇总了PHP中DbQuery::select方法的典型用法代码示例。如果您正苦于以下问题:PHP DbQuery::select方法的具体用法?PHP DbQuery::select怎么用?PHP DbQuery::select使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbQuery
的用法示例。
在下文中一共展示了DbQuery::select方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getProductInformations
/**
* 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 {
$product = new Product((int) $this->id_product);
if (Validate::isLoadedObject($product)) {
$this->reference = $product->reference;
$this->ean13 = $product->ean13;
$this->upc = $product->upc;
}
}
}
示例2: getDevices
function getDevices()
{
$devices_obj = new DbQuery();
$devices_obj->select('
mpn.`id`,
mpn.`new_order`,
mpn.`new_customer`,
mpn.`order_statuses`,
mpn.`id_shop`,
mpn.`app_connection_id`,
mpn.`status`,
mpn.`device_unique_id`,
md.`account_email`,
md.`device_name`,
md.`last_activity`,
c.`iso_code` AS currency_iso
');
$devices_obj->from('mobassistantconnector_push_notifications', 'mpn');
$devices_obj->leftJoin('mobassistantconnector_devices', 'md', 'md.`device_unique_id` = mpn.`device_unique_id`');
$devices_obj->leftJoin('currency', 'c', 'c.`id_currency` = mpn.`currency_code`');
$devices_sql = $devices_obj->build();
$devices = Db::getInstance()->executeS($devices_sql);
if (!$devices) {
$devices = array();
}
$devices = replaceNull($devices);
$statuses_db = OrderState::getOrderStates(Configuration::get('PS_LANG_DEFAULT'));
$count_statuses = count($statuses_db);
$statuses = array();
for ($i = 0; $i < $count_statuses; $i++) {
$statuses[$statuses_db[$i]['id_order_state']] = $statuses_db[$i]['name'];
}
$devices = formDevices($devices, $statuses);
return Tools::jsonEncode($devices);
}
示例3: renderView
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`');
$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);
return parent::renderView();
}
示例4: getStockValue
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);
}
示例5: getErpAssociation
/**
* 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);
}
示例6: getErpSupplierIdBySupplierId
/**
* 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);
}
示例7: getLastId
public function getLastId()
{
// build query
$query = new DbQuery();
$query->select('id_erpip_inventory');
$query->from('erpip_inventory', 'i');
$query->orderBy('id_erpip_inventory DESC');
return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
}
示例8: getNextBadgeId
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);
}
示例9: exists
/**
* 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);
}
示例10: getImageContentIdsByIdImage
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;
}
示例11: getFieldsValues
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;
}
示例12: getIdBySlug
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);
}
示例13: getIdByProductAndWarehouse
/**
* 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);
}
示例14: getByProductId
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);
}
示例15: getAllById
public static function getAllById($id_simpleblog_post)
{
if (!Validate::isUnsignedInt($id_simpleblog_post)) {
return Tools::displayError('getAllById - invalid ID');
}
$sql = new DbQuery();
$sql->select('*');
$sql->from('simpleblog_post_image', 'sbpi');
$sql->where('id_simpleblog_post = ' . (int) $id_simpleblog_post);
$sql->orderBy('position ASC');
return Db::getInstance()->executeS($sql);
}