magento订单列表查询

Question

我想选择Magento中所有订单的列表。

这是我需要在另一个PHP应用程序中显示magento所有订单的列表。

也可以使用Magento的版本1.4.2有人写信给我使用的Magento约定的代码，如Mage::

林。

谢谢，
马克

Answer 1

该代码使用“Magento的方式”，并访问通过隔离您从表结构变化的模型层中的数据的主（例如平坦vs EAV）。在Magento安装的根目录下创建一个包含此框架代码的新PHP文件（如果其他地方更新了第一个require语句的路径）。

这给你一些如何添加属性到集合的例子，你应该能够按照例子添加更多的需要。它向您显示如何按属性过滤和按属性排序。用于回显您需要的字段的示例。

HTH，
JD

require_once 'app/Mage.php'; 
umask(0); 
Mage::app('default'); 
    $orders = Mage::getResourceModel('sales/order_collection') 
     ->addAttributeToSelect('*') 
     ->joinAttribute('billing_firstname', 'order_address/firstname', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_lastname', 'order_address/lastname', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_street', 'order_address/street', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_company', 'order_address/company', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_city', 'order_address/city', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_region', 'order_address/region', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_country', 'order_address/country_id', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_postcode', 'order_address/postcode', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_telephone', 'order_address/telephone', 'billing_address_id', null, 'left') 
     ->joinAttribute('billing_fax', 'order_address/fax', 'billing_address_id', null, 'left') 
     ->joinAttribute('shipping_firstname', 'order_address/firstname', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_lastname', 'order_address/lastname', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_street', 'order_address/street', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_company', 'order_address/company', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_city', 'order_address/city', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_region', 'order_address/region', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_country', 'order_address/country_id', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_postcode', 'order_address/postcode', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_telephone', 'order_address/telephone', 'shipping_address_id', null, 'left') 
     ->joinAttribute('shipping_fax', 'order_address/fax', 'shipping_address_id', null, 'left') 

     ->addFieldToFilter('status', array("in" => array(
      'complete', 
      'closed') 
      )) 

     ->addAttributeToFilter('store_id', Mage::app()->getStore()->getId()) 
     ->addAttributeToSort('created_at', 'asc') 
     ->load(); 
    foreach($orders as $order): 
    echo $order->getIncrementId().'<br/>'; 
    echo $order->getShippingTelephone().'<br/>'; 
    endforeach; 

Answer 2

试试这个：

select * from sales_flat_order; 

这头级别的信息。如果您需要线项目信息/更深层次的信息，您可以使用类似下面的连接：

select e.*,sfoi.* from sales_flat_order e 
left join sales_flat_order_item sfoi on (e.entity_id=sfoi.order_id) 

现在，这是要复制（笛卡尔积）所有的头信息与线项目信息一起。如果进一步要求的东西，让我知道，我在Magento的EAV SQL :)

Answer 3

晚了一点，但是这可能是有用的（在Magento CE 1.7.0.2测试）。该代码在指导方面受到严重评论。

<?php 
// include the core code we are going to use 
require_once('app/Mage.php'); 
umask (0); 
Mage::app('default'); 

// resources 
$resource = Mage::getSingleton('core/resource'); 

// db access 
$db_read = $resource->getConnection('core_read'); 
$db_write = $resource->getConnection('core_write'); 

// support table prefix if one is being used 
$table_prefix = Mage::getConfig()->getTablePrefix(); 

// count the orders 
$order_num = $db_read->fetchOne("SELECT COUNT(*) AS num FROM {$table_prefix}sales_flat_order WHERE status = 'pending'"); 

// get an array of the orders 
$orders = $db_read->fetchAll("SELECT sales.* FROM {$table_prefix}sales_flat_order AS sales WHERE sales.status = 'pending'"); 

// start iterating through the orders 
for($i=0; $i < intval($order_num); $i++) { 

    // order id 
    $orderid = $orders[$i]['entity_id']; 

    // shipping address 
    $order_details = Mage::getModel('sales/order')->load($orderid); 
    $shippingAddress = $order_details->getShippingAddress(); 

    // use like so 
    $shippingAddress->getPrefix()); 
    $shippingAddress->getFirstname(); 
    $shippingAddress->getLastname(); 
    $shippingAddress->getCompany(); 
    $shippingAddress->getEmail(); 
    $shippingAddress->getTelephone(); 
    $shippingAddress->getStreetFull(); 

    // billing address 
    $order_details = Mage::getModel('sales/order')->load($orderid); 
    $billingAddress = $order_details->getBillingAddress(); 

    // use like so 
    $billingAddress->getPrefix()); 
    $billingAddress->getFirstname(); 
    $billingAddress->getLastname(); 
    $billingAddress->getCompany(); 
    $billingAddress->getEmail(); 
    $billingAddress->getTelephone(); 
    $billingAddress->getStreetFull(); 

    // and if you want order items, do the following 
    $items = $db_read->fetchAll("SELECT 
     items.order_id AS orderid, 
     items.item_id AS itemid, 
     orders.total_item_count AS total_items_in_order, 
     items.quote_item_id AS quoteid, 
     items.created_at AS orderdate, 
     items.product_type, 
     items.sku AS itemcode, 
     items.name AS itemname, 
     items.price_incl_tax AS itemprice, 
     items.tax_amount AS itemtax, 
     items.discount_amount AS discount, 
     items.qty_ordered AS qty_ordered, 
     items.qty_shipped AS qty_shipped, 
     address.email AS email, 
     address.prefix AS title, 
     address.firstname AS firstname, 
     address.lastname AS lastname, 
     address.street AS address, 
     address.city AS city, 
     address.region AS region, 
     address.country_id AS country, 
     address.postcode AS postcode, 
     address.telephone AS telephone 
     FROM {$table_prefix}sales_flat_order AS orders 
     JOIN {$table_prefix}sales_flat_order_item AS items 
      ON items.order_id = orders.entity_id 
     LEFT JOIN {$table_prefix}sales_flat_order_address AS address 
      ON orders.entity_id = address.parent_id 
     WHERE 
     items.order_id = $orderid 
     AND address.address_type = 'shipping' 
     AND orders.status = 'pending' 
    "); 

    foreach ($items AS $item) { 
     echo $item['itemid']; 
     // blah blah blah 
    } 
} 
?> 

希望能帮助别人！