PHP mage::getResourceModel方法代码示例

 public function getGroup()
 {
     if ($this->_group == null) {
         $this->_group = mage::getResourceModel('BackgroundTask/Taskgroup')->loadByGroupCode($this->_groupCode);
     }
     return $this->_group;
 }

 /**
  * Retourne le dernier prix d'achat sans frais d'approche pour un produit
  *
  * @param unknown_type $ProductId
  */
 public function GetLastPriceWithoutFees($ProductId)
 {
     $sql = 'select pop_price_ht_base from ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'purchase_order_product, ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'purchase_order where pop_order_num = po_num and po_status = \'' . MDN_Purchase_Model_Order::STATUS_COMPLETE . '\' and pop_price_ht_base > 0 and pop_product_id = ' . $ProductId . ' order by po_num DESC LIMIT 1';
     $retour = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchOne($sql);
     $retour = number_format($retour, 2);
     return $retour;
 }

    /**
     * Calcul le stock pour un produit
     *
     */
    public function ComputeProductStock($ProductId)
    {
        $sql = '
				select sum(sm_coef  * sm_qty) stock
				from ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'stock_movement 
				where sm_product_id = ' . $ProductId . '
				';
        $data = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchAll($sql);
        if (count($data) > 0) {
            if ($data[0]['stock'] == '') {
                return 0;
            } else {
                return $data[0]['stock'];
            }
        }
        return 0;
    }

 /**
  * Met a jour la qté réservée
  *
  * @param unknown_type $qty
  */
 public function UpdateReservedQty($product)
 {
     //recupere la qté
     $reservedQty = $this->GetReservedQty($product->getId());
     //check if record exists
     $sql = 'select count(*) from ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity_int where entity_id = ' . $product->getId() . ' and attribute_id = ' . mage::getModel('Purchase/Constant')->GetProductReservedQtyAttributeId();
     $res = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchOne($sql);
     if ($res == 0) {
         //insert record
         $sql = 'insert into ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity_int (value, entity_id, attribute_id) values (' . $reservedQty . ', ' . $product->getId() . ', ' . mage::getModel('Purchase/Constant')->GetProductReservedQtyAttributeId() . ')';
         $res = mage::getResourceModel('sales/order_item_collection')->getConnection()->query($sql);
     } else {
         //met a jour pour le produit
         $sql = 'update ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity_int set value = ' . $reservedQty . ' where entity_id = ' . $product->getId() . ' and attribute_id = ' . mage::getModel('Purchase/Constant')->GetProductReservedQtyAttributeId();
         mage::getResourceModel('sales/order_item_collection')->getConnection()->query($sql);
     }
     return;
 }

 /**
  * Clear all tasks
  *
  */
 public function ClearGroupTasksAction()
 {
     mage::getResourceModel('BackgroundTask/Task')->deleteAllGroupTasks();
     mage::getResourceModel('BackgroundTask/Taskgroup')->deleteAllGroups();
     //confirm & redirect
     Mage::getSingleton('adminhtml/session')->addSuccess($this->__('Group Tasks successfully deleted'));
     $this->_redirect('BackgroundTask/Admin/Grid');
 }

 /**
  * Return ids for product that must be in supply needs
  *
  */
 public function getCandidateProductIds()
 {
     //recupere les valeurs par défaut pour le store
     $DefaultManageStock = Mage::getStoreConfig('cataloginventory/item_options/manage_stock');
     if ($DefaultManageStock == '') {
         $DefaultManageStock = 1;
     }
     $DefaultNotifyStockQty = Mage::getStoreConfig('cataloginventory/item_options/notify_stock_qty');
     if ($DefaultNotifyStockQty == '') {
         $DefaultNotifyStockQty = 0;
     }
     //retrieve concerned products
     $sql = "\n\t\t\t\t\tselect \n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity.entity_id product_id,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.qty qty,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.notify_stock_qty notify_stock_qty,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.use_config_notify_stock_qty use_config_notify_stock_qty,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.manage_stock manage_stock,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.use_config_manage_stock use_config_manage_stock,\n\t\t\t\t\t\t\ttbl_ordered_qty.value ordered_qty\n\t\t\t\t\t\t\t\n\t\t\t\t\tfrom \t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity_int tbl_status,\n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity_int tbl_ordered_qty\n\t\t\t\t\twhere \n\t\t\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity.entity_id = " . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.product_id\n\t\t\t\t\t\t\tand " . mage::getModel('Purchase/Constant')->getTablePrefix() . "cataloginventory_stock_item.stock_id = 1\n\t\t\t\t\t\t\tand tbl_status.entity_id = " . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity.entity_id\n\t\t\t\t\t\t\tand tbl_status.attribute_id = " . mage::getModel('Purchase/Constant')->GetProductStatusAttributeId() . "\n\t\t\t\t\t\t\tand tbl_status.value = 1\n\t\t\t\t\t\t\tand tbl_status.store_id = 0\n\t\t\t\t\t\t\tand tbl_ordered_qty.entity_id = " . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity.entity_id\n\t\t\t\t\t\t\tand tbl_ordered_qty.attribute_id = " . mage::getModel('Purchase/Constant')->GetProductOrderedQtyAttributeId() . "\n\t\t\t\t\t\t\tand tbl_ordered_qty.store_id = 0\n\t\t\t\t\t\t\tand " . mage::getModel('Purchase/Constant')->getTablePrefix() . "catalog_product_entity.exclude_from_supply_needs = 0\n\t\t\t\t";
     $data = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchAll($sql);
     return $data;
 }

 /**
  * Enregistre les modifs faite sur le manufacturer
  *
  */
 public function SaveAction()
 {
     //Charge le manufacturer
     $Manufacturer = Mage::getModel('Purchase/Manufacturer')->load($this->getRequest()->getParam('man_id'));
     //Enregistre les modifs
     $Manufacturer->setman_name($this->getRequest()->getParam('man_name'));
     $Manufacturer->setman_contact($this->getRequest()->getParam('man_contact'));
     $Manufacturer->setman_address1($this->getRequest()->getParam('man_address1'));
     $Manufacturer->setman_address2($this->getRequest()->getParam('man_address2'));
     $Manufacturer->setman_zipcode($this->getRequest()->getParam('man_zipcode'));
     $Manufacturer->setman_city($this->getRequest()->getParam('man_city'));
     $Manufacturer->setman_country($this->getRequest()->getParam('man_country'));
     $Manufacturer->setman_tel($this->getRequest()->getParam('man_tel'));
     $Manufacturer->setman_fax($this->getRequest()->getParam('man_fax'));
     $Manufacturer->setman_email($this->getRequest()->getParam('man_email'));
     $Manufacturer->setman_website($this->getRequest()->getParam('man_website'));
     $Manufacturer->setman_comments($this->getRequest()->getParam('man_comments'));
     $Manufacturer->setman_attribute_option_id($this->getRequest()->getParam('man_attribute_option_id'));
     //Si on doit créer le manufacturer magento
     if ($this->getRequest()->getParam('create_magento_manufacturer') == '1') {
         //cree l'option
         $option['attribute_id'] = mage::getModel('Purchase/Constant')->GetProductManufacturerAttributeId();
         $option['value'][0][0] = $Manufacturer->getman_name();
         $setup = new Mage_Eav_Model_Entity_Setup('core_setup');
         $setup->addAttributeOption($option);
         //recupere son id
         $OptionId = null;
         $sql = "\n\t\t\t\tSELECT \n\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option_value.option_id id, " . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option_value.value name\n\t\t\t\tfrom \n\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option,\n\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option_value\n\t\t\t\twhere \n\t\t\t\t\t" . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option.attribute_id = " . mage::getModel('Purchase/Constant')->GetProductManufacturerAttributeId() . "\n\t\t\t\t\tand " . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option.option_id = " . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option_value.option_id \n\t\t\t\t\torder by " . mage::getModel('Purchase/Constant')->getTablePrefix() . "eav_attribute_option_value.value\n\t\t\t\t";
         //execute la requete
         $data = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchAll($sql);
         for ($i = 0; $i < count($data); $i++) {
             if ($data[$i]['name'] == $Manufacturer->getman_name()) {
                 $OptionId = $data[$i]['id'];
             }
         }
         //l'associe
         $Manufacturer->setman_attribute_option_id($OptionId);
     }
     $Manufacturer->save();
     //confirme
     Mage::getSingleton('adminhtml/session')->addSuccess($this->__('Manufacturer Saved'));
     //Redirige vers la fiche créée
     $this->_redirect('Purchase/Manufacturers/Edit/man_id/' . $Manufacturer->getId());
 }

 public function getIngoingMovement($from, $to, $productId)
 {
     $tablePrefix = Mage::getConfig()->getTablePrefix();
     $sql = "select sum(sm_qty * sm_coef) from " . $tablePrefix . "stock_movement where sm_coef > 0 and sm_product_id=" . $productId . " and sm_date >= '" . date('Y-m-d', $from) . "' and sm_date <= '" . date('Y-m-d', $to) . "'";
     $retour = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchOne($sql);
     return abs((int) $retour);
 }

 /**
  * Méthode appelée par le cron pour mettre a jour les qte commandés des produits
  *
  */
 public function UpdateStocksForOrders()
 {
     //Parcourt les commandes dont les stocks n'ont pas été mis a jour (stocks_updated = 0)
     echo '<h2>UpdateStocksForOrders</h2>';
     $sql = 'select entity_id from ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'sales_order where stocks_updated = 0';
     $data = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchAll($sql);
     for ($i = 0; $i < count($data); $i++) {
         //Charge la commande
         $order = mage::getModel('sales/order')->load($data[$i]['entity_id']);
         echo '<p><b>Processing order #' . $order->getId() . '</b>';
         //Si la commande remplit les conditions
         if ($order->IsValidForPurchaseProcess()) {
             try {
                 //Pour chaque produit de la commande
                 foreach ($order->getAllItems() as $item) {
                     if ($item->getproduct_id()) {
                         //charge le produit
                         $product = mage::getModel('catalog/product')->load($item->getproduct_id());
                         if ($product->getId() != '') {
                             echo '<br>Updating product ordered qty for product #' . $product->getId();
                             //reserve le produit si possible
                             $model = mage::getModel('Purchase/Productstock');
                             mage::helper('purchase/ProductReservation')->reserveProductForOrder($order->getId(), $product->getId());
                             //met a jour les qte (reservée et ordered)
                             echo '<br>Update ordered and reserved qty';
                             $model->UpdateOrderedQty($product);
                         }
                     }
                 }
             } catch (Exception $ex) {
                 echo 'Error while browsing products : ' . $ex->getMessage() . ' <br> ' . $ex->getTraceAsString();
             }
             //Specifie que le stock a été mis a jour
             $sql = 'update ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'sales_order set stocks_updated = 1 where entity_id = ' . $data[$i]['entity_id'];
             echo '<br>' . $sql;
             mage::getResourceModel('sales/order_item_collection')->getConnection()->query($sql);
             //dispatch order in order preparation tabs
             mage::helper('BackgroundTask')->AddTask('Dispatch order #' . $order->getId(), 'Orderpreparation', 'dispatchOrder', $order->getId());
             //Store planning
             try {
                 echo '<br>Store planning';
                 $planning = mage::helper('purchase/Planning')->createPlanning($order);
                 $planning->setpsop_anounced_date($planning->getpsop_delivery_date());
                 $planning->setpsop_anounced_date_max($planning->getpsop_delivery_date_max());
                 $planning->save();
             } catch (Exception $ex) {
                 echo '<font color="red">Error creating order planning: ' . $ex->getMessage() . '</font>';
             }
             //update supply needs for products
             /*
             foreach($order->getAllItems() as $item)
             {
             	$productId = $item->getproduct_id();
             	Mage::dispatchEvent('purchase_update_supply_needs_for_product', array('product_id'=>$productId, 'from' => 'order #'.$order->getId().' placed'));
             }
             */
         } else {
             echo '<p>Order doesnt fullfill supplyneeds and reservation requiresites. Stocks not updated';
         }
     }
 }

 /**
  * Delete group's tasks
  *
  */
 protected function _afterDelete()
 {
     mage::getResourceModel('BackgroundTask/Task')->deleteGroupTasks($this->getbtg_code());
 }

 /**
  * Collect next task to execute
  *
  */
 public function getNextTaskToExecute()
 {
     $collection = mage::getResourceModel('BackgroundTask/Task_Collection')->getNextTaskToExecute();
     foreach ($collection as $item) {
         return $item;
     }
 }

    /**
     * Retourne la liste des erreurs
     *
     */
    public function getList()
    {
        $retour = array();
        $ProductStockModel = mage::getModel('Purchase/Productstock');
        //Recupere la liste des produits
        $sql = '
				select 
					product_id,
					qty,
					tbl_ordered.value ordered_qty,
					tbl_reserved.value reserved_qty,
					tbl_name.value name
				from 
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity,
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'cataloginventory_stock_item,
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity_int tbl_ordered,
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity_int tbl_reserved,
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity_varchar tbl_name
				where
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity.entity_id = ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'cataloginventory_stock_item.product_id
					and ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity.entity_id = tbl_ordered.entity_id
					and ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity.entity_id = tbl_reserved.entity_id
					and tbl_reserved.attribute_id = ' . mage::getModel('Purchase/Constant')->GetProductReservedQtyAttributeId() . '
					and tbl_ordered.attribute_id = ' . mage::getModel('Purchase/Constant')->GetProductOrderedQtyAttributeId() . '
					and tbl_name.entity_id = tbl_ordered.entity_id
					and tbl_name.attribute_id = ' . mage::getModel('Purchase/Constant')->GetProductNameAttributeId() . '
					and ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity.type_id = \'simple\'
				order by 
					' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'catalog_product_entity.entity_id
				';
        $data = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchAll($sql);
        for ($i = 0; $i < count($data); $i++) {
            $AddProduct = false;
            $StockProblem = false;
            $OrderedProblem = false;
            $ReservedProblem = false;
            $productId = $data[$i]['product_id'];
            //Recupere le stock calcué via les mouvements de stock
            $CalculatedStock = (int) $ProductStockModel->ComputeProductStock($productId);
            if ($CalculatedStock != $data[$i]['qty']) {
                $AddProduct = true;
                $StockProblem = true;
            }
            //Recupere le stock calcué via les mouvements de stock
            $OrderedQty = (int) $ProductStockModel->GetOrderedQty($productId);
            if ($OrderedQty != $data[$i]['ordered_qty']) {
                $AddProduct = true;
                $OrderedProblem = true;
            }
            //Recupere le stock calcué via les mouvements de stock
            $ReservedQty = (int) mage::helper('purchase/ProductReservation')->GetReservedQty($productId);
            if ($ReservedQty != $data[$i]['reserved_qty']) {
                $AddProduct = true;
                $ReservedProblem = true;
            }
            if ($ReservedQty > $CalculatedStock) {
                $AddProduct = true;
            }
            if ($ReservedQty > $OrderedQty) {
                $AddProduct = true;
            }
            //Si le produit a un pb
            if ($AddProduct) {
                $item = array();
                $item['product_name'] = '<a href="' . $this->getUrl('Purchase/Products/Edit', array('product_id' => $productId)) . '">' . $data[$i]['name'] . ' (' . $productId . ')</a>';
                $item['ordered_qty'] = '';
                $item['reserved_qty'] = '';
                $item['product_id'] = $productId;
                $item['other'] = '';
                $item['stock'] = '';
                if ($StockProblem) {
                    $item['stock'] = '<font color="red">Error (' . (int) $data[$i]['qty'] . ' / ' . $CalculatedStock . ')</font>';
                } else {
                    $item['stock'] = $CalculatedStock;
                }
                if ($OrderedProblem) {
                    $item['ordered_qty'] = '<font color="red">Error (' . (int) $data[$i]['ordered_qty'] . ' / ' . $OrderedQty . ')</font>';
                } else {
                    $item['ordered_qty'] = $OrderedQty;
                }
                if ($ReservedProblem) {
                    $item['reserved_qty'] = '<font color="red">Error (' . (int) $data[$i]['reserved_qty'] . ' / ' . $ReservedQty . ')</font>';
                } else {
                    $item['reserved_qty'] = $ReservedQty;
                }
                if ($ReservedQty > $CalculatedStock) {
                    $item['other'] .= '<font color="red">Reserved qty > stock</font>';
                }
                if ($ReservedQty > $OrderedQty) {
                    $item['other'] .= '<font color="red">Reserved qty > ordered qty</font>';
                }
                $retour[] = $item;
            }
        }
        //retourne
        return $retour;
//.........这里部分代码省略.........