예제 #1
0
 public static function getZoneByProducts()
 {
     $query = new DbQuery();
     $query->select('id_product, id_product_attribute, wpl.id_warehouse_product_location, 
             id_wharehouse, location, id_erpip_warehouse_product_location, id_zone, id_zone_parent');
     $query->from('warehouse_product_location', 'wpl');
     $query->inner('erp_warehouse_product_location', 'ewpl', 'wpl.id_warehouse_product_location = ewpl.id_warehouse_product_location');
     return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($query);
 }