$sth = $dbh->prepare("select * from OrderState o where updated=(select min(updated) from OrderState where order_id=o.order_id and state & " . $GLOBALS['STATE_DELIVERED'] . ") and updated between '$from' and '$to'");
$sth->execute();
$order_states = OrderStatePeer::populateObjects($sth);
+ $dups = array();
foreach ($order_states as $order_state) {
- $order_ids[] = $order_state->getOrderId();
- $order_state_ids[] = $order_state->getId();
+ $order_id = $order_state->getOrderId();
+ $order_ids[] = $order_id;
+ if (! $dups[$order_id]) $order_state_ids[] = $order_state->getId();
+ $dups[$order_id] = true;
}
$q = new OrderQuery;
$q->filterById($order_ids);