正在筛选Magento中的Sales_flat_quote - Filtering Sales_flat_quote in Magento

Filtering Sales_flat_quote in Magento

我想要sales_flat_quote表中reserved_order_id为Null的数据。我写了。

<?php
require_once 'abstract.php';
require_once 'cache.php';
class Mage_Migrate_Carts extends Mage_Shell_Abstract
{
    public function run(){
        $quotes = Mage::getModel('sales/quote');
        $readConnection = $quotes->getConnection('core_read');
        $query = "Select * from sales_flat_quote where reserved_order_id is Null";   
        $results = $readConnection->fetchAll($query);
        print_r($results);
    }
}   
$shell = new Mage_Migrate_Carts();
$shell->run();

它正在运行它抛出的错误：Fatal error: Call to a member function fetchAll() on a non-object in file.php on line 11。如何在销售/报价模型中编写sqlquery。我今天第一次接触马根托。

您必须添加core/resource才能读取查询。

public function run(){
        $quotes = Mage::getModel('sales/quote');
        $connectionresource = Mage::getSingleton('core/resource');
        $readConnection = $connectionresource->getConnection('core_read');
        $query = "Select * from sales_flat_quote where reserved_order_id is Null";   
        $results = $readConnection->fetchAll($query);
        print_r($results);
    }