php获取产品订单列表,php – magento订单列表查询

此代码使用“Magento方式”并通过Model层访问数据,这使您可以隔离表结构的变化(例如,平坦与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().'
';

echo $order->getShippingTelephone().'
';

endforeach;