$message .= 'Order Price: ' . $result[0]['total_price'] . "<br />\n"; $message .= 'Payment Processing Gross Price: ' . $total . "<br />\n"; write_log($message); break; } $sql = 'UPDATE ' . TABLE_ORDERS . ' SET status = 2, transaction_number = \'' . $transaction_number . '\', payment_date = \'' . date('Y-m-d H:i:s') . '\', status_changed = \'' . date('Y-m-d H:i:s') . '\', payment_type = 1, payment_method = ' . $payment_method . ' WHERE order_number = \'' . $order_number . '\''; if (database_void_query($sql)) { // update customer orders/listings amount Customers::SetOrdersForCustomer($result[0]['customer_id'], '+'); Customers::SetListingsForCustomer($result[0]['customer_id'], $result[0]['advertise_plan_id'], $result[0]['listings_amount'], '+'); // send email to customer if (Orders::SendOrderEmail($order_number, 'completed', $result[0]['customer_id'])) { write_log($sql, _ORDER_PLACED_MSG); } else { write_log($sql, _ORDER_ERROR); } } else { write_log($sql, mysql_error()); } } else { write_log($sql, 'Error: no records found. ' . mysql_error()); } break; case 'Updated':
/** * After-Delete record */ public function AfterDeleteRecord() { // $this->curRecordId - currently deleted record if ($this->order_status == 2 || $this->order_status == 3 || $this->order_status == 4) { // update customer orders/listings amount Customers::SetOrdersForCustomer($this->order_customer_id, '-'); if ($this->order_status == 2 || $this->order_status == 3) { Customers::SetListingsForCustomer($this->order_customer_id, $this->order_advertise_plan_id, $this->order_listings, '-'); } } }