/**
* Has an email been sent to the customer for this
* order step.
*"-10 days"
*
* @param Order $order
* @param Boolean $checkDateOfOrder
* @return Boolean
**/
public function hasBeenSent(Order $order, $checkDateOfOrder = true)
{
//if it has been more than a XXX days since the order was last edited (submitted) then we do not send emails as
//this would be embarrasing.
if ($checkDateOfOrder) {
if ($log = $order->SubmissionLog()) {
$lastEditedValue = $log->LastEdited;
} else {
$lastEditedValue = $order->LastEdited;
}
if (strtotime($lastEditedValue) < strtotime("-" . EcommerceConfig::get("OrderStep", "number_of_days_to_send_update_email") . " days")) {
return true;
}
}
$count = OrderEmailRecord::get()->Filter(array("OrderID" => $order->ID, "OrderStepID" => $this->ID, "Result" => 1))->count();
return $count ? true : false;
}
function read($request)
{
$id = intval($request->param("ID"));
$email = OrderEmailRecord::get()->byID($id);
return $email->Content;
}
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;
}
