[Deprecated] DMZ 1.6.2 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@BrianDHall

If all you want is the items - not the carts they are related to - you can do this:

Code:

$listings = new Listing();
$listings->where_related('cart_item/user', $user)->get();

This gets all listings related through a cart item to a user. This assumes that there is only one user per cart_item, and one cart_item per listing. If you have multiple in either case, then you need to add a distinct into your query.

If you also want the (singly-related) cart_item, you can do that in one query as well, like so:

Code:

$listings = new Listing();
$listings->include_related('cart_item', '*', TRUE, TRUE);
$listings->where_related('cart_item/user', $user)->get();

foreach($listings as $listing) {
    echo $listing->cart_item->id;
}

Both functions are detailed on Get (Advanced).