PHP-按最接近from_Date的日期筛选价格规则 - PHP - Filter Price Rule By Date Closest To from_date

PHP - Filter Price Rule By Date Closest To from_date

我正试图直接从价格规则在标题上显示横幅，而不必每次都对其进行编码。

我创建了一个php文件，看起来像：

<?php
/* Gets all the Magento store rules */
require 'app/Mage.php';
umask(0);
Mage::app('default');
//echo "test1<br>";
$todayDate = date("Y-m-d");
//echo $todayDate;
$limit = 1;
/* Get all the active Catalog Rules */
$catalogrules = Mage::getModel('catalogrule/rule')->getCollection()
        ->addFieldToFilter('is_active', 1)
    //    ->addFieldToFilter('sort_order', 1)       
        ->addFieldToFilter('from_date', array('lteq' => $todayDate))
        ->addFieldToFilter('to_date', array('gteq' => $todayDate))
        ->addFieldToSelect('description');
foreach ($catalogrules as $rule)
{
    //echo "catalog rule:<br>";
    echo $rule->getData('description');
    echo "<br>";
}
/* Get all active Shopping Cart Rules */
$cartrules = Mage::getModel('salesrule/rule')->getCollection()
        ->addFieldToFilter('is_active', 1)
    //  ->addFieldToFilter('sort_order', 1)
        ->addFieldToFilter('from_date', array('lteq' => $todayDate))
        ->addFieldToFilter('to_date', array('gteq' => $todayDate))
        ->addFieldToSelect('description');
foreach ($cartrules as $rule)
{
    //echo "cart rule:<br>";
    echo $rule->getData('description');
    echo "<br>";
}
?>

我需要过滤代码，它只接受目录规则和购物车规则中最近启动的（from_date）规则。

请建议！！

THanks！

<?php
/* Gets all the Magento store rules */
require 'app/Mage.php';
umask(0);
Mage::app('default');
//echo "test1<br>";
$todayDate = date("Y-m-d");
//echo $todayDate;
$limit = 1;
/* Get all the active Catalog Rules */
$catalogrules = Mage::getModel('catalogrule/rule')->getCollection()
        ->addFieldToFilter('is_active', 1)
    //    ->addFieldToFilter('sort_order', 1)       
        ->addFieldToFilter('from_date', array(array('gteq' => $todayDate), array('null' => true)))//Make these changes
        ->addFieldToFilter('to_date', array(array('lteq' => $todayDate), array('null' => true)))//Make these changes
        ->addFieldToSelect('description');
foreach ($catalogrules as $rule)
{
    //echo "catalog rule:<br>";
    echo $rule->getData('description');
    echo "<br>";
}
/* Get all active Shopping Cart Rules */
$cartrules = Mage::getModel('salesrule/rule')->getCollection()
        ->addFieldToFilter('is_active', 1)
    //  ->addFieldToFilter('sort_order', 1)
        ->addFieldToFilter('from_date', array(array('gteq' => $todayDate), array('null' => true)))//Make these changes
        ->addFieldToFilter('to_date', array(array('lteq' => $todayDate), array('null' => true)))//Make these changes
        ->addFieldToSelect('description');
foreach ($cartrules as $rule)
{
    //echo "cart rule:<br>";
    echo $rule->getData('description');
    echo "<br>";
}
?>