/** * All PaymentMethods without SR: Fill table sofort_orders_notification * @param int $sofortOrdersId - key from table sofort_orders * @return last insert_id * @see insertSofortOrdersNotification() */ function updateTimeline($sofortOrdersId, $orderStatus, $comment) { if (!$sofortOrdersId) { return false; } $sqlDataArray = array('sofort_orders_id' => $sofortOrdersId, 'items' => '', 'amount' => 0, 'customer_comment' => $comment, 'seller_comment' => $comment, 'status_id' => 0, 'status' => $orderStatus, 'status_reason' => '', 'invoice_status' => '', 'invoice_objection' => ''); xtc_db_query(HelperFunctions::getEscapedInsertInto('sofort_orders_notification', $sqlDataArray)); return xtc_db_insert_id(); // fetch and return the last insert id }
function insertNewTotalCommentToHistory($orderId, $status, $time, $newTotal) { if ($newTotal['newTotal'] > $newTotal['lastShopTotal']) { $comments = MODULE_PAYMENT_SOFORT_SR_TRANSLATE_CART_RESET . ' ' . MODULE_PAYMENT_SOFORT_SR_TRANSLATE_CURRENT_TOTAL . ' ' . $newTotal['newTotal'] . ' Euro ' . MODULE_PAYMENT_SOFORT_SR_TRANSLATE_TIME . ': ' . $time; } else { $comments = MODULE_PAYMENT_SOFORT_SR_TRANSLATE_CART_EDITED . ' ' . MODULE_PAYMENT_SOFORT_SR_TRANSLATE_CURRENT_TOTAL . ' ' . $newTotal['newTotal'] . ' Euro ' . MODULE_PAYMENT_SOFORT_SR_TRANSLATE_TIME . ': ' . $time; } $sqlDataArray = array('orders_id' => (int) $orderId, 'orders_status_id' => $status, 'date_added' => 'sqlcommand:now()', 'customer_notified' => 0, 'comments' => $comments); xtc_db_query(HelperFunctions::getEscapedInsertInto(TABLE_ORDERS_STATUS_HISTORY, $sqlDataArray)); echo MODULE_PAYMENT_SOFORT_SR_TRANSLATE_CART_EDITED . "\n"; return $comments; }
/** * save bankdata in users history and return link to sv-bankdata-page * @return string - link to sv-bankdata-page */ function _insertSvBankdataAndGetLinkToBankdataPage($orderId) { //save sofortvorkasse-bankdata in customer history and show bankdata-page $bankdata = MODULE_PAYMENT_SOFORT_SV_CHECKOUT_HOLDER_TEXT . ' ' . HelperFunctions::htmlMask($_GET['holder']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_ACCOUNT_NUMBER_TEXT . ' ' . HelperFunctions::htmlMask($_GET['account_number']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_IBAN_TEXT . ' ' . HelperFunctions::htmlMask($_GET['iban']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_BANK_CODE_TEXT . ' ' . HelperFunctions::htmlMask($_GET['bank_code']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_BIC_TEXT . ' ' . HelperFunctions::htmlMask($_GET['bic']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_AMOUNT_TEXT . ' ' . HelperFunctions::htmlMask($_GET['amount']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_REASON_1_TEXT . ' ' . HelperFunctions::htmlMask($_GET['reason_1']) . ' -- ' . MODULE_PAYMENT_SOFORT_SV_CHECKOUT_REASON_2_TEXT . ' ' . HelperFunctions::htmlMask($_GET['reason_2']); $sql_data_array = array('orders_id' => $orderId, 'orders_status_id' => DEFAULT_ORDERS_STATUS_ID, 'date_added' => 'sqlcommand:now()', 'customer_notified' => 0, 'comments' => $bankdata); xtc_db_query(HelperFunctions::getEscapedInsertInto(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array)); /* //create link to bankdata-page and return this link $server = (ENABLE_SSL == true) ? HTTPS_SERVER : HTTP_SERVER; $session = '&' . session_name() . '=' . session_id(); $get = 'holder='.HelperFunctions::htmlMask($_GET['holder']).'&account_number='.HelperFunctions::htmlMask($_GET['account_number']).'&iban='.HelperFunctions::htmlMask($_GET['iban']).'&bank_code='.HelperFunctions::htmlMask($_GET['bank_code']).'&bic='.HelperFunctions::htmlMask($_GET['bic']).'&amount='.HelperFunctions::htmlMask($_GET['amount']).'&reason_1='.HelperFunctions::htmlMask($_GET['reason_1']).'&reason_2='.HelperFunctions::htmlMask($_GET['reason_2']); return $server.DIR_WS_CATALOG.'callback/sofort/ressources/scripts/confirmVorkasse.php?'.$get.$session; */ $get = 'vorkasse=sofort&holder=' . HelperFunctions::htmlMask($_GET['holder']) . '&account_number=' . HelperFunctions::htmlMask($_GET['account_number']) . '&iban=' . HelperFunctions::htmlMask($_GET['iban']) . '&bank_code=' . HelperFunctions::htmlMask($_GET['bank_code']) . '&bic=' . HelperFunctions::htmlMask($_GET['bic']) . '&amount=' . HelperFunctions::htmlMask($_GET['amount']) . '&reason_1=' . HelperFunctions::htmlMask($_GET['reason_1']) . '&reason_2=' . HelperFunctions::htmlMask($_GET['reason_2']); //return xtc_href_link('callback/sofort/ressources/scripts/confirmVorkasse.php', $get, 'SSL'); return xtc_href_link(FILENAME_CHECKOUT_SUCCESS, $get, 'SSL'); }