在 Cakephp 中使用 Set Extract 和条件创建数组

Question

我有以下数组：

Array
(
    [0] => Array
        (
            [id] => 4
            [rate] => 82.50
            [pounds] => 2
            [ounces] => 3
            [mailtype] => Package
            [country] => UNITED KINGDOM (GREAT BRITAIN)
            [svccommitments] => 1 - 3 business days
            [svcdescription] => Global Express Guaranteed (GXG)
            [maxdimensions] => Max. length 46", width 35", height 46" and max. length plus girth combined 108"
            [maxweight] =>30
        )

    [1] => Array
        (
            [id] => 6
            [rate] => 82.50
            [pounds] => 2
            [ounces] => 3
            [mailtype] => Package
            [country] => UNITED KINGDOM (GREAT BRITAIN)
            [svccommitments] => 1 - 3 business days
            [svcdescription] => Global Express Guaranteed Non-Document Rectangular
            [maxdimensions] => Max. length 46", width 35", height 46" and max. length plus girth combined 108"
            [maxweight] => 70
        )

我想使用 CakePHP 的 Set:extract 工具在“maxweight”上过滤该数组，因此所有“maxweight”大于 X 的元素都会得到一个由“rate”和“svcdescription”字段即：

Array (
 [82.50] => Global Express Guaranteed Non-Document Rectangular
 ...
 etc
)

这可能吗？

Answer 1

在我看来，为了从 Set::extract 中获得最大价值，最好从一个结构类似于以下的数组开始（否则我相信你必须运行 < code>Set::extract 在循环内）：

$array = array(
    'Shipping' => array(
        array (
            "id" => 4,
            "rate" => 82.50,
            "pounds" => 2,
            "ounces" => 3,
            "mailtype" => "Package",
            "country" => "UNITED KINGDOM (GREAT BRITAIN)",
            "svccommitments" => "1 - 3 business days",
            "svcdescription" => "Global Express Guaranteed (GXG)",
            "maxdimensions" => 'Max. length 46", width 35", height 46" and max. length plus girth combined 108"',
            "maxweight" => 30
        ),
        array (
            "id" => 6,
            "rate" => 82.50,
            "pounds" => 2,
            "ounces" => 3,
            "mailtype" => "Package",
            "country" => "UNITED KINGDOM (GREAT BRITAIN)",
            "svccommitments" => "1 - 3 business days",
            "svcdescription" => "Global Express Guaranteed Non-Document Rectangular",
            "maxdimensions" => 'Max. length 46", width 35", height 46" and max. length plus girth combined 108"',
            "maxweight" => 70
        )
    )
);

现在您可以使用 Set::extract() 的路径语法来提取 maxweight 大于 $x 的元素。

$extracted = Set::extract($array, '/Shipping[maxweight>'.$x.']');

有了这些数据，您就可以使用 Set::combine() 将费率作为键、将 svcdescription 作为值来构建您要查找的数组。

$combined = Set::combine($extracted, '{n}.Shipping.rate', '{n}.Shipping.svcdescription');

Answer 2

我以前从未使用过这个，但感谢您鼓励我阅读它。
您是否尝试过使用 Set::combine() ？

http://book.cakephp.org/view/662/combine

Answer 3

为什么不能只使用 foreach 循环来处理数组。

$returnArray = array();

// Where $x is weight amount you're testing against
foreach ($yourData as $eachData) {
    if ($eachData['maxweight'] > $x) {
        $returnArray[$eachData['rate']] = $eachData['svcdescription'];
    }
}