magento按日期过滤order_invoice_item

Question

嗨，我想按日期过滤magento order_invoice_item集合

作为参数，我有一个时间戳字符串"20130701T00:00:00“。

我试着把它过滤成那样

$invoiceitems = Mage::getModel('sales/order_invoice_item')->getCollection()
->addAttributeToFilter('sku', array('in' => $skuList))
->addAttributeToFilter('created_at', array('lt' => strtotime("20130701T00:00:00")));

但这是行不通的，因为"created_at“在发票上。

我如何加入发票，按日期过滤它？

Answer 1

我的解决办法是

$invoiceitems = Mage::getModel('sales/order_invoice_item')->getCollection()
    ->addAttributeToFilter('sku', array('in' => $skuList));
    $invoiceitems->getSelect()->where("created_at >= CONVERT_TZ(FROM_UNIXTIME(".strtotime($from)."), @@session.time_zone,'UTC')");
    $invoiceitems->getSelect()->where("created_at <= CONVERT_TZ(FROM_UNIXTIME(".strtotime($to)."), @@session.time_zone,'UTC')");
    $invoiceitems->getSelect()->joinInner("sales_flat_invoice", "parent_id=sales_flat_invoice.entity_id", 'created_at');