PHP Order::getHistory方法代码示例

function invoice_number_set()
{
    Configuration::loadConfiguration();
    $number = 1;
    // Update each order with a number
    $result = Db::getInstance()->ExecuteS('
	SELECT id_order
	FROM ' . _DB_PREFIX_ . 'orders
	ORDER BY id_order');
    foreach ($result as $row) {
        $order = new Order((int) $row['id_order']);
        $history = $order->getHistory(false);
        foreach ($history as $row2) {
            $oS = new OrderState((int) $row2['id_order_state'], (int) Configuration::get('PS_LANG_DEFAULT'));
            if ($oS->invoice) {
                Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'orders SET invoice_number = ' . (int) $number++ . ', `invoice_date` = `date_add` WHERE id_order = ' . (int) $order->id);
                break;
            }
        }
    }
    // Add configuration var
    Configuration::updateValue('PS_INVOICE_NUMBER', (int) $number);
}

function delivery_number_set()
{
    Configuration::loadConfiguration();
    $number = 1;
    // Update each order with a number
    $result = Db::getInstance()->ExecuteS('
	SELECT id_order
	FROM ' . _DB_PREFIX_ . 'orders
	ORDER BY id_order');
    foreach ($result as $row) {
        $order = new Order(intval($row['id_order']));
        $history = $order->getHistory(false);
        foreach ($history as $row2) {
            $oS = new OrderState(intval($row2['id_order_state']));
            if ($oS->delivery) {
                Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'orders SET delivery_number = ' . intval($number++) . ', `delivery_date` = `date_add` WHERE id_order = ' . intval($order->id));
                break;
            }
        }
    }
    // Add configuration var
    Configuration::updateValue('PS_DELIVERY_NUMBER', intval($number));
}

 public function execNotification()
 {
     $veritrans = new Veritrans_Config();
     Veritrans_Config::$isProduction = Configuration::get('VT_ENVIRONMENT') == 'production' ? true : false;
     Veritrans_Config::$serverKey = Configuration::get('VT_SERVER_KEY');
     $veritrans_notification = new Veritrans_Notification();
     $history = new OrderHistory();
     $history->id_order = (int) $veritrans_notification->order_id;
     error_log('message notif');
     error_log(print_r($veritrans_notification, TRUE));
     error_log('==============================================');
     // check if order history already been updated to payment success, then save to array $order_history.
     $order_id_notif = (int) $veritrans_notification->order_id;
     $order = new Order($order_id_notif);
     $order_histories = $order->getHistory($this->context->language->id, Configuration::get('VT_PAYMENT_SUCCESS_STATUS_MAP'));
     // if (empty($order_histories))
     // 	error_log("not found in DB");
     // error_log(print_r($order_histories,true));
     // print_r($order_histories,true);
     //Validating order
     //if ($veritrans_notification->isVerified())
     //{
     //$history->id_order = (int)$veritrans_notification->order_id;
     //error_log('notif verified');
     //error_log('message notif: '.(int)$veritrans_notification->order_id);
     if ($veritrans_notification->transaction_status == 'capture') {
         if ($veritrans_notification->fraud_status == 'accept') {
             // if order history !contains payment accepted, then update DB. Else, don't update DB
             if (empty($order_histories)) {
                 $history->changeIdOrderState(Configuration::get('VT_PAYMENT_SUCCESS_STATUS_MAP'), $order_id_notif);
                 echo 'Valid success notification accepted.';
             } else {
                 error_log("########## Transaction has already been updated to success status once, no need to update again");
             }
         } else {
             if ($veritrans_notification->fraud_status == 'challenge') {
                 $history->changeIdOrderState(Configuration::get('VT_PAYMENT_CHALLENGE_STATUS_MAP'), $order_id_notif);
                 echo 'Valid challenge notification accepted.';
             }
         }
     } else {
         if ($veritrans_notification->transaction_status == 'settlement') {
             if ($veritrans_notification->payment_type != 'credit_card') {
                 // if order history !contains payment accepted, then update DB. Else, don't update DB
                 if (empty($order_histories)) {
                     $history->changeIdOrderState(Configuration::get('VT_PAYMENT_SUCCESS_STATUS_MAP'), $order_id_notif);
                     echo 'Valid success notification accepted.';
                 } else {
                     error_log("########## Transaction has already been updated to success status once, no need to update again");
                 }
             } else {
                 echo 'Credit card settlement notification accepted.';
             }
         } else {
             if ($veritrans_notification->transaction_status == 'pending') {
                 $history->changeIdOrderState(Configuration::get('VT_PAYMENT_CHALLENGE_STATUS_MAP'), $order_id_notif);
                 echo 'Pending notification accepted.';
             } else {
                 if ($veritrans_notification->transaction_status == 'cancel') {
                     $history->changeIdOrderState(Configuration::get('VT_PAYMENT_FAILURE_STATUS_MAP'), $order_id_notif);
                     echo 'Pending notification accepted.';
                 } else {
                     if ($veritrans_notification->transaction_status == 'expire') {
                         $history->changeIdOrderState(Configuration::get('VT_PAYMENT_FAILURE_STATUS_MAP'), $order_id_notif);
                         echo 'Expire notification accepted.';
                     } else {
                         $history->changeIdOrderState(Configuration::get('VT_PAYMENT_FAILURE_STATUS_MAP'), $order_id_notif);
                         echo 'Valid failure notification accepted';
                     }
                 }
             }
         }
     }
     try {
         $history->add(true);
     } catch (Exception $e) {
         echo 'Order history not added: ' . $e->getMessage();
         exit;
     }
     //}
     exit;
 }

 public function hookOrderConfirmation($params)
 {
     if (!$this->active) {
         return;
     }
     if (!$this->checkCurrency($params['cart'])) {
         return;
     }
     $order = new Order(Tools::getValue('id_order'));
     $history = $order->getHistory($this->context->cookie->id_lang);
     $history = $history[0];
     $this->context->smarty->assign(array('transaction_status' => $history['id_order_state'], 'cart' => $this->context->cart, 'this_path' => $this->_path, 'this_path_ssl' => Tools::getShopDomainSsl(true, true) . __PS_BASE_URI__ . 'modules/' . $this->name . '/'));
     if (version_compare(Configuration::get('PS_VERSION_DB'), '1.5') == -1) {
         return $this->display(__FILE__, 'views/templates/hook/order_confirmation.tpl');
     } else {
         return $this->display(__FILE__, 'order_confirmation.tpl');
     }
 }

function hipayResetOrderStatus($cart = null)
{
    echo '-fnROS';
    if ($_POST['status'] == '117' || $_POST['status'] == '118') {
        $cart = new Cart((int) $_POST['order']->id);
        if ($cart->orderExists()) {
            $orderState = _PS_OS_PAYMENT_;
            if ($_POST['captured_amount'] < $_POST['authorized_amount']) {
                $orderState = Configuration::get('HIPAY_PARTIALLY_CAPTURED') ? Configuration::get('HIPAY_PARTIALLY_CAPTURED') : HipayClass::getConfiguration('HIPAY_PARTIALLY_CAPTURED');
            }
            // FORCE INVOICE CREATION IF OrderState = _PS_OS_PAYMENT_
            if ($orderState == _PS_OS_PAYMENT_) {
                $order_id = retrieveOrderId($cart->id);
                // Retrieve order id
                $order = new Order((int) $order_id);
                // Recreate order
                $newOS = new OrderState((int) $orderState, $order->id_lang);
                // Emulate the order state _PS_OS_PAYMENT_
                // Uf the order state allows invoice and there is no invoice number, then generate the invoice
                if ($newOS->invoice and !$order->invoice_number) {
                    $order->setInvoice();
                }
            }
        }
    }
    // New modification for status challenged
    // Second check for status 112 -> 117 -> 118
    if ($_POST['status'] == '117') {
        if ((bool) $order->getHistory($context->language->id, Configuration::get('HIPAY_CHALLENGED'))) {
            $cart = new Cart((int) $_POST['order']->id);
            if ($cart->orderExists()) {
                $orderState = _PS_OS_PAYMENT_;
            }
            if ($_POST['captured_amount'] < $_POST['authorized_amount']) {
                $orderState = Configuration::get('HIPAY_PARTIALLY_CAPTURED') ? Configuration::get('HIPAY_PARTIALLY_CAPTURED') : HipayClass::getConfiguration('HIPAY_PARTIALLY_CAPTURED');
            }
            // FORCE INVOICE CREATION IF OrderState = _PS_OS_PAYMENT_
            if ($orderState == _PS_OS_PAYMENT_) {
                $order_id = retrieveOrderId($cart->id);
                // Retrieve order id
                $order = new Order((int) $order_id);
                // Recreate order
                $newOS = new OrderState((int) $orderState, $order->id_lang);
                // Emulate the order state _PS_OS_PAYMENT_
                // Uf the order state allows invoice and there is no invoice number, then generate the invoice
                if ($newOS->invoice and !$order->invoice_number) {
                    $order->setInvoice();
                }
            }
        }
    }
    // Update to minimize risk of simultaneous calls for status 116 and 117
    if ($_POST['status'] == '116') {
        usleep(500000);
        // 0.5sec
        echo '/116';
        // If order exists for cart
        $cart = new Cart((int) $_POST['order']->id);
        if ($cart->orderExists()) {
            echo '/C_OK' . $GLOBALS['_HIPAY_CALLBACK_ORDER_ID_'];
            $context = Context::getContext();
            // Retrieve Order ID
            $order_id = retrieveOrderId($cart->id);
            $order = new Order((int) $order_id);
            echo '/' . (int) $order_id;
            // If current state is paiement accepted or capture partielle
            // then skip the process
            if ((bool) $order->getHistory($context->language->id, _PS_OS_PAYMENT_)) {
                echo '/' . (int) _PS_OS_PAYMENT_ . '_U';
                // Update orders
                $sql_update = "UPDATE `" . _DB_PREFIX_ . "orders`\r\n                    SET `current_state` = '" . _PS_OS_PAYMENT_ . "'\r\n                    WHERE `id_order`='" . (int) $order_id . "'";
                Db::getInstance()->execute($sql_update);
                // Insert into order_history
                $sql_insert = "INSERT INTO `" . _DB_PREFIX_ . "order_history` (`id_employee`, `id_order`, `id_order_state`, `date_add`)\r\n                    VALUES ('0', '" . (int) $order_id . "', '" . _PS_OS_PAYMENT_ . "', now());";
                Db::getInstance()->execute($sql_insert);
            }
            if ((bool) $order->getHistory($context->language->id, Configuration::get('HIPAY_PARTIALLY_CAPTURED'))) {
                echo '/' . (int) Configuration::get('HIPAY_PARTIALLY_CAPTURED') . '_U';
                // Update orders
                $sql_update = "UPDATE `" . _DB_PREFIX_ . "orders`\r\n                    SET `current_state` = '" . Configuration::get('HIPAY_PARTIALLY_CAPTURED') . "'\r\n                    WHERE `id_order`='" . (int) $order_id . "'";
                Db::getInstance()->execute($sql_update);
                // Insert into order_history
                $sql_insert = "INSERT INTO `" . _DB_PREFIX_ . "order_history` (`id_employee`, `id_order`, `id_order_state`, `date_add`)\r\n                    VALUES ('0', '" . (int) $order_id . "', '" . Configuration::get('HIPAY_PARTIALLY_CAPTURED') . "', now());";
                Db::getInstance()->execute($sql_insert);
            }
            HipayLogger::addLog($hipay->l('Callback process', 'hipay'), HipayLogger::NOTICE, 'hipayResetOrderStatus status 116 cart already ok - cid : ' . (int) $_POST['order']->id);
            die;
        } else {
            echo '/C_KO' . $GLOBALS['_HIPAY_CALLBACK_ORDER_ID_'];
        }
    }
    HipayLogger::addLog($hipay->l('Callback process', 'hipay'), HipayLogger::NOTICE, 'hipayResetOrderStatus ended - cid : ' . (int) $_POST['order']->id);
    die;
}

 public static function setOrderStatusDeclined($order_ref, $check = true)
 {
     $oid = self::getOrdersIdFromOrderRef($order_ref);
     if ($oid) {
         $amz_payments = new AmzPayments();
         $new_status = $amz_payments->decline_status_id;
         if ($check) {
             $order = new Order((int) $oid);
             $history = $order->getHistory(Context::getContext()->language->id, $amz_payments->decline_status_id);
             if (sizeof($history) > 0) {
                 return false;
             }
         }
         self::setOrderStatus($oid, $new_status);
     }
 }

    public function sendReminders()
    {
        $id_order_state_for_reminder = (int) Configuration::get('PS_OS_MF_REMINDER');
        $id_order_state_for_lastreminder = (int) Configuration::get('PS_OS_MF_LASTREMINDER');
        if ($id_order_state_for_reminder == 0 && !Validate::isObjectLoaded(new OrderState((int) $id_order_state_for_reminder))) {
            self::logToFile('cron has been stopped - "Reminder" order state has not been defined. Please check configuration.', 'cron');
        } elseif ($id_order_state_for_lastreminder == 0 && !Validate::isObjectLoaded(new OrderState((int) $id_order_state_for_lastreminder))) {
            self::logToFile('cron has been stopped - "Last Reminder" order state has not been defined. Please check configuration.', 'cron');
        } else {
            $reminder_init_os = array();
            $reminder_days = array();
            $active_euro_shops = array();
            $orders = Db::getInstance()->executeS('SELECT a.`id_order`, a.`id_shop`, a.`current_state`, a.`id_lang`, a.`id_customer`, a.`id_currency`
			FROM ' . _DB_PREFIX_ . 'orders a LEFT JOIN ' . _DB_PREFIX_ . 'mf_claims c ON a.`id_order`=c.`id_order` WHERE c.`id_order` IS NULL');
            foreach ($orders as $order) {
                //check currency
                if (!isset($active_euro_shops[$order['id_shop']])) {
                    $active_euro_shops[$order['id_shop']] = $this->getActiveEuroCurrencyID($order['id_shop']);
                    $active_euro = $active_euro_shops[$order['id_shop']];
                } else {
                    $active_euro = $active_euro_shops[$order['id_shop']];
                }
                //$active_euro = 1; // for testing
                if ((int) $active_euro == 0) {
                    self::logToFile('Order ' . $order['id_order'] . ' - euro is not active for shop', 'cron');
                } elseif ($active_euro != $order['id_currency']) {
                    self::logToFile('Order ' . $order['id_order'] . ' - euro is not currency of order', 'cron');
                } else {
                    //get customer group
                    $id_customer_group = Customer::getDefaultGroupId($order['id_customer']);
                    // *send reminder*
                    //check current order state
                    if (!isset($reminder_init_os[$order['id_shop']])) {
                        $reminder_init_os[$order['id_shop']] = Tools::jsonDecode(Configuration::get('MEDIAFINANZ_REMINDER_INIT_OS', null, null, $order['id_shop']), true);
                        $init_os = $reminder_init_os[$order['id_shop']];
                    } else {
                        $init_os = $reminder_init_os[$order['id_shop']];
                    }
                    if (in_array($order['current_state'], $init_os)) {
                        // get days
                        if (!isset($reminder_days[$order['id_shop']])) {
                            $reminder_days[$order['id_shop']] = Tools::jsonDecode(Configuration::get('MEDIAFINANZ_GROUP_REM', null, null, $order['id_shop']), true);
                            $days = $reminder_days[$order['id_shop']];
                        } else {
                            $days = $reminder_days[$order['id_shop']];
                        }
                        $days_x = (int) $days[(string) $id_customer_group];
                        $order_obj = new Order($order['id_order']);
                        $history_entities = $order_obj->getHistory($order['id_lang'], $order['current_state']);
                        $last_history_entity = end($history_entities);
                        $date_reminder = $last_history_entity['date_add'];
                        $days_between = ceil(abs(strtotime(date('Y-m-d H:i:s')) - strtotime($date_reminder)) / 86400);
                        if ($days_between >= $days_x) {
                            try {
                                if ($this->changeOrderState($order['id_order'], $id_order_state_for_reminder)) {
                                    self::logToFile('Order ' . $order['id_order'] . ' - send reminder - successful - mail has been sent', 'cron');
                                } else {
                                    self::logToFile('Order ' . $order['id_order'] . ' - send reminder - successful - mail has not been sent ', 'cron');
                                }
                            } catch (Exception $e) {
                                self::logToFile('Order ' . $order['id_order'] . ' - send reminder - failed - ' . $e->getMessage(), 'cron');
                            }
                        }
                    }
                    //*send last reminder*
                    if ($order['current_state'] == $id_order_state_for_reminder) {
                        // get days
                        if (!isset($reminder_days[$order['id_shop']])) {
                            $reminder_days[$order['id_shop']] = Tools::jsonDecode(Configuration::get('MEDIAFINANZ_GROUP_LASTREM', null, null, $order['id_shop']), true);
                            $days = $reminder_days[$order['id_shop']];
                        } else {
                            $days = $reminder_days[$order['id_shop']];
                        }
                        $days_y = (int) $days[(string) $id_customer_group];
                        $order_obj = new Order($order['id_order']);
                        $history_entities = $order_obj->getHistory($order['id_lang'], $order['current_state']);
                        $last_history_entity = end($history_entities);
                        $date_reminder = $last_history_entity['date_add'];
                        $days_between = ceil(abs(strtotime(date('Y-m-d H:i:s')) - strtotime($date_reminder)) / 86400);
                        if ($days_between >= $days_y) {
                            try {
                                if ($this->changeOrderState($order['id_order'], $id_order_state_for_lastreminder)) {
                                    self::logToFile('Order ' . $order['id_order'] . ' - send lastreminder - successful - mail has been sent', 'cron');
                                } else {
                                    self::logToFile('Order ' . $order['id_order'] . ' - send lastreminder - successful - mail has not been sent ', 'cron');
                                }
                            } catch (Exception $e) {
                                self::logToFile('Order ' . $order['id_order'] . ' - send lastreminder - failed - ' . $e->getMessage(), 'cron');
                            }
                        }
                    }
                }
            }
        }
    }

    public function renderCreateClaimsList()
    {
        $order_ids = Tools::getValue('order_list');
        if (count($order_ids) > 0) {
            $list = Db::getInstance()->executeS('SELECT a.`id_shop`, a.`id_order`, a.`id_address_invoice`, a.`date_add`, a.`id_customer`,
												a.`total_paid_tax_incl`, a.`id_currency` FROM `' . _DB_PREFIX_ . 'orders` a LEFT JOIN `' . _DB_PREFIX_ . 'orders` o ON (o.`id_order` = a.`id_order` AND o.`id_shop` = a.`id_shop`) LEFT JOIN `' . _DB_PREFIX_ . 'customer` c ON (c.`id_customer` = a.`id_customer`) WHERE a.`id_order` IN (' . implode(', ', array_map('intval', $order_ids)) . ') ' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'a', 'shop'));
            $claim = Tools::getValue('claim');
            foreach ($list as &$row) {
                $row['accepted_for_claiming'] = true;
                $row['claim']['file_number'] = 0;
                if ($claim_object = MediafinanzClaim::getMediafinanzClaimByOrderId($row['id_order'])) {
                    $row['claim']['file_number'] = (int) $claim_object->file_number;
                    $row['claim']['id'] = (int) $claim_object->id;
                    $row['accepted_for_claiming'] = false;
                }
                $order = new Order($row['id_order']);
                // get Reminder date
                $row['date_reminder'] = '';
                $state_reminder = Configuration::get('PS_OS_MF_REMINDER');
                if ($state_reminder > 0) {
                    $history_entities = $order->getHistory($this->context->language->id, $state_reminder);
                    $last_history_entity = end($history_entities);
                    if ($last_history_entity) {
                        $row['date_reminder'] = $last_history_entity['date_add'];
                    }
                }
                // get Last Reminder date
                $row['date_lastreminder'] = '';
                $state_reminder = Configuration::get('PS_OS_MF_LASTREMINDER');
                if ($state_reminder > 0) {
                    $history_entities = $order->getHistory($this->context->language->id, $state_reminder);
                    $last_history_entity = end($history_entities);
                    if ($last_history_entity) {
                        $row['date_lastreminder'] = $last_history_entity['date_add'];
                    }
                }
                $euro_currency_id = $this->module->getActiveEuroCurrencyID($row['id_shop']);
                // check currency
                if ($euro_currency_id == 0) {
                    $row['accepted_for_claiming'] = false;
                    $row['supported_currency_by_shop'] = false;
                } else {
                    $row['supported_currency_by_shop'] = true;
                    if ($row['id_currency'] == $euro_currency_id) {
                        $row['supported_currency'] = true;
                    } else {
                        $row['accepted_for_claiming'] = false;
                        $row['supported_currency'] = false;
                    }
                }
                $row['claim']['invoice'] = $row['id_order'];
                $row['claim']['type'] = !isset($claim[$row['id_order']]['type']) ? Configuration::get('MEDIAFINANZ_CLAIM_TYPE') : $claim[$row['id_order']]['type'];
                $row['claim']['reason'] = $this->module->getOrderReason($row['id_order']);
                $currency = new Currency($row['id_currency']);
                $row['claim']['display_originalvalue'] = Tools::displayPrice($row['total_paid_tax_incl'], $currency);
                $row['claim']['originalvalue'] = Tools::ps_round($row['total_paid_tax_incl'], 2);
                $row['claim']['overduefees'] = !isset($claim[$row['id_order']]['overduefees']) ? Configuration::get('MEDIAFINANZ_OVERDUEFEES') : $claim[$row['id_order']]['overduefees'];
                $row['claim']['dateoforigin'] = date('Y-m-d', strtotime($row['date_add']));
                //'2015-5-16';
                $row['claim']['dateoflastreminder'] = date('Y-m-d', strtotime($row['date_lastreminder']));
                $row['claim']['note'] = !isset($claim[$row['id_order']]['note']) ? Configuration::get('MEDIAFINANZ_NOTE') : $claim[$row['id_order']]['note'];
                $customer = new Customer($row['id_customer']);
                $address = new Address($row['id_address_invoice']);
                $row['debtor']['id'] = $customer->id;
                if ($address->company != '') {
                    $row['debtor']['address'] = 'c';
                } elseif ($customer->id_gender == 1) {
                    $row['debtor']['address'] = 'm';
                } elseif ($customer->id_gender == 2) {
                    $row['debtor']['address'] = 'f';
                } else {
                    $row['debtor']['address'] = '@';
                }
                $row['debtor']['firstname'] = $address->firstname;
                $row['debtor']['lastname'] = $address->lastname;
                $row['debtor']['company'] = $address->company;
                $row['debtor']['street'] = $address->address1 . ($address->address2 != '' ? ' ' . $address->address2 : '');
                $row['debtor']['postcode'] = $address->postcode;
                $row['debtor']['city'] = $address->city;
                $country = new Country($address->id_country);
                $row['debtor']['country'] = $country->iso_code;
                //$row['debtor']['addressstatus'] = $row['id_customer'];
                $row['debtor']['telephone1'] = $address->phone;
                $row['debtor']['telephone2'] = $address->phone_mobile;
                //$row['debtor']['fax'] = $row['id_customer'];
                $row['debtor']['email'] = $customer->email;
                //$row['debtor']['dateofbirth'] = $row['id_customer'];
                //$row['debtor']['deliveryaddress'] = $row['id_customer'];
                $row['configuration_completed'] = (int) $this->module->isModuleConfigurationCompleted($order->id_shop);
                $row['id_shop'] = (int) $order->id_shop;
                $row['mode_for_shop'] = $this->module->getCurrentModeTitle($order->id_shop);
            }
        }
        $this->context->smarty->assign('currency', new Currency($this->module->getActiveEuroCurrencyID(Context::getContext()->shop->id)));
        $this->context->smarty->assign('claim_types', $this->module->getClaimTypes());
        $this->context->smarty->assign('createclaims_data', $list);
        $this->setTemplate('createclaims-list' . (_PS_VERSION_ < '1.6.0.0' ? '_15' : '') . '.tpl');
    }