/**
* Get the amount saved on the given order with this discount.
*
* @param Order $order order to match against
* @return double savings amount
*/
public function getSavingsForOrder(Order $order)
{
$itemsavings = OrderAttribute::get()->innerJoin("Product_OrderItem_Discounts", "\"OrderAttribute\".\"ID\" = \"Product_OrderItem_Discounts\".\"Product_OrderItemID\"")->filter("Product_OrderItem_Discounts.DiscountID", $this->ID)->filter("OrderAttribute.OrderID", $order->ID)->sum("DiscountAmount");
$modifiersavings = OrderAttribute::get()->innerJoin("OrderDiscountModifier_Discounts", "\"OrderAttribute\".\"ID\" = \"OrderDiscountModifier_Discounts\".\"OrderDiscountModifierID\"")->filter("OrderDiscountModifier_Discounts.DiscountID", $this->ID)->filter("OrderAttribute.OrderID", $order->ID)->sum("DiscountAmount");
return $itemsavings + $modifiersavings;
}
function mergeUncompletedOrderForOneMember_170()
{
$explanation = "\r\n\t\t\t<h1>170. Merge uncompleted orders into one.</h1>\r\n\t\t\t<p>Merges uncompleted orders by the same user into one.</p>\r\n\t\t";
if ($this->retrieveInfoOnly) {
return $explanation;
} else {
echo $explanation;
}
$orders = Order::get()->filter(array("MemberID:GreaterThan" => 0))->sort(array("MemberID" => "ASC", "\"Order\".\"Created\"" => "DESC"))->innerJoin("Member", "\"Order\".\"MemberID\" = \"Member\".\"ID\"")->limit($this->limit, $this->start);
$count = 0;
$previousOrderMemberID = 0;
$lastOrderFromMember = null;
if ($orders->count()) {
foreach ($orders as $order) {
//crucial ONLY for non-submitted orders...
if ($order->IsSubmitted()) {
//do nothing!
$count++;
} else {
$memberID = $order->MemberID;
//recurring member
if ($previousOrderMemberID == $memberID && $lastOrderFromMember) {
$this->DBAlterationMessageNow("We have a duplicate order for a member: " . $order->Member()->Email, "created");
$orderAttributes = OrderAttribute::get()->filter(array("OrderID" => $order->ID));
if ($orderAttributes->count()) {
foreach ($orderAttributes as $orderAttribute) {
$this->DBAlterationMessageNow("Moving attribute #" . $orderAttribute->ID, "created");
DB::query("UPDATE \"OrderAttribute\" SET \"OrderID\" = " . $lastOrderFromMember->ID . " WHERE \"ID\" = " . $orderAttribute->ID);
}
} else {
$this->DBAlterationMessageNow("There are no attributes for this order");
}
$orderStatusLogs = OrderStatusLog::get()->filter(array("OrderID" => $order->ID));
if ($orderStatusLogs->count()) {
foreach ($orderStatusLogs as $orderStatusLog) {
$this->DBAlterationMessageNow("Moving order status log #" . $orderStatusLog->ID, "created");
DB::query("UPDATE \"OrderStatusLog\" SET \"OrderID\" = " . $lastOrderFromMember->ID . " WHERE \"ID\" = " . $orderStatusLog->ID);
}
} else {
$this->DBAlterationMessageNow("There are no order status logs for this order");
}
$orderEmailRecords = OrderEmailRecord::get()->filter(array("OrderID" => $order->ID));
if ($orderEmailRecords->count()) {
foreach ($orderEmailRecords as $orderEmailRecord) {
DB::query("UPDATE \"OrderEmailRecord\" SET \"OrderID\" = " . $lastOrderFromMember->ID . " WHERE \"ID\" = " . $orderEmailRecord->ID);
$this->DBAlterationMessageNow("Moving email #" . $orderEmailRecord->ID, "created");
}
} else {
$this->DBAlterationMessageNow("There are no emails for this order.");
}
} else {
$previousOrderMemberID = $order->MemberID;
$lastOrderFromMember = $order;
$this->DBAlterationMessageNow("Found last order from member.");
}
if ($order->BillingAddressID && !$lastOrderFromMember->BillingAddressID) {
$this->DBAlterationMessageNow("Moving Billing Address.");
DB::query("UPDATE \"Order\" SET \"BillingAddressID\" = " . $order->BillingAddressID . " WHERE \"ID\" = " . $lastOrderFromMember->ID);
DB::query("UPDATE \"BillingAddress\" SET \"OrderID\" = " . $lastOrderFromMember->ID . " WHERE \"ID\" = " . $order->BillingAddressID);
}
if ($order->ShippingAddressID && !$lastOrderFromMember->ShippingAddressID) {
$this->DBAlterationMessageNow("Moving Shipping Address.");
DB::query("UPDATE \"Order\" SET \"ShippingAddressID\" = " . $order->ShippingAddressID . " WHERE \"ID\" = " . $lastOrderFromMember->ID);
DB::query("UPDATE \"ShippingAddress\" SET \"OrderID\" = " . $lastOrderFromMember->ID . " WHERE \"ID\" = " . $order->ShippingAddressID);
}
$order->delete();
}
}
$this->DBAlterationMessageNow("Ignored {$count} Orders that have already been submitted.");
return $this->start + $this->limit;
} else {
$this->DBAlterationMessageNow("There were no orders at all to work through.");
}
return 0;
}
