Create array with Set Extract in Cakephp with conditions

Question

I have the following array:

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
        )

And I want to use CakePHP's Set:extract tools to filter this array on the 'maxweight', so all elements that have a 'maxweight' more than X and get an array made up of the 'rate' and 'svcdescription' fields ie:

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

Is this at all possible?

stevelove · Accepted Answer · 2010-11-20 08:06:36Z

2

In my opinion, to get the most value out of Set::extract, it would be better to start with an array with a structure more like the following (otherwise I believe you'd have to run Set::extract inside a loop):

$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
        )
    )
);

Now you can use the path syntax for Set::extract() to extract elements that have a maxweight greater than $x.

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

With this data, you can build the array you're looking for using the rates as keys and svcdescription as values using Set::combine().

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

edited Nov 20, 2010 at 8:06

answered Nov 12, 2010 at 1:38

stevelove

3,2121 gold badge25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

deceze Over a year ago

Set::extract doesn't care about "preferred formats", it simply works on arrays.

Aditya P Bhatt Over a year ago

its helpful though.. tnx a lot !

Leo · Accepted Answer · 2010-06-21 13:26:29Z

0

I've never used this before, but thanks for encouraging me to read up on it. Have you tried using Set::combine() ?

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

answered Jun 21, 2010 at 13:26

Leo

6,5712 gold badges33 silver badges49 bronze badges

Comments

mikegreenberg · Accepted Answer · 2010-08-04 15:36:59Z

0

Why can't you just use a foreach loop to process through the array.

$returnArray = array();

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

answered Aug 4, 2010 at 15:36

mikegreenberg

1,4212 gold badges12 silver badges19 bronze badges

2 Comments

designvoid Over a year ago

Obviously I could, I was just thinking it could be done a different way.

mikegreenberg Over a year ago

There are probably a lot of ways to do it. If I could offer advice, don't get caught trying to overoptimize or spend too much time trying to find the perfect tool when a good-enough tool will do....well.... good enough. :)

Collectives™ on Stack Overflow

Create array with Set Extract in Cakephp with conditions

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related