00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034 class Mage_CatalogInventory_Model_Mysql4_Stock_Item_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract
00035 {
00036 protected function _construct()
00037 {
00038 $this->_init('cataloginventory/stock_item');
00039 }
00040
00041
00042
00043
00044
00045
00046
00047 public function addStockFilter($stock)
00048 {
00049 if ($stock instanceof Mage_CatalogInventory_Model_Stock) {
00050 $this->addFieldToFilter('main_table.stock_id', $stock->getId());
00051 }
00052 else {
00053 $this->addFieldToFilter('main_table.stock_id', $stock);
00054 }
00055 return $this;
00056 }
00057
00058
00059
00060
00061
00062
00063
00064 public function addProductsFilter($products)
00065 {
00066 $productIds = array();
00067 foreach ($products as $product) {
00068 if ($product instanceof Mage_Catalog_Model_Product) {
00069 $productIds[] = $product->getId();
00070 }
00071 else {
00072 $productIds[] = $product;
00073 }
00074 }
00075 if (empty($productIds)) {
00076 $productIds[] = false;
00077 $this->_setIsLoaded(true);
00078 }
00079 $this->addFieldToFilter('main_table.product_id', array('in'=>$productIds));
00080 return $this;
00081 }
00082
00083
00084
00085
00086
00087
00088
00089 public function joinStockStatus($storeId = null)
00090 {
00091 $websiteId = Mage::app()->getStore($storeId)->getWebsiteId();
00092 $this->getSelect()->joinLeft(
00093 array('status_table' => $this->getTable('cataloginventory/stock_status')),
00094 '`main_table`.`product_id`=`status_table`.`product_id`'
00095 . ' AND `main_table`.`stock_id`=`status_table`.`stock_id`'
00096 . $this->getConnection()->quoteInto(' AND `status_table`.`website_id`=?', $websiteId),
00097 array('stock_status')
00098 );
00099
00100 return $this;
00101 }
00102
00103 public function addManagedFilter($isStockManagedInConfig)
00104 {
00105 if ($isStockManagedInConfig) {
00106 $this->getSelect()->where('(manage_stock = 1 OR use_config_manage_stock = 1)');
00107 } else {
00108 $this->addFieldToFilter('manage_stock', 1);
00109 }
00110
00111 return $this;
00112 }
00113
00114 public function addQtyFilter($comparsionMethod, $qty)
00115 {
00116 $allowedMethods = array('<', '>', '=', '<=', '>=', '<>');
00117 if (!in_array($comparsionMethod, $allowedMethods)) {
00118 Mage::throwException(Mage::helper('cataloginventory')->__('%s is not correct comparsion method.', $comparsionMethod));
00119 }
00120 $this->getSelect()->where("main_table.qty {$comparsionMethod} ?", $qty);
00121 return $this;
00122 }
00123
00124
00125
00126
00127
00128
00129 public function load($printQuery = false, $logQuery = false)
00130 {
00131 if (!$this->isLoaded()) {
00132 $this->getSelect()->joinInner(array('_products_table' => $this->getTable('catalog/product')),
00133 'main_table.product_id=_products_table.entity_id', 'type_id'
00134 );
00135 }
00136 return parent::load($printQuery, $logQuery);
00137 }
00138 }