/**
* 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');
}
