$gift_cert_data = $_REQUEST['gift_cert_data'];
fn_correct_gift_certificate($gift_cert_data);
if (!isset($gift_cert_data['products'])) {
$gift_cert_data['products'] = array();
}
// Change certfificate status
fn_change_gift_certificate_status($_REQUEST['gift_cert_id'], $gift_cert_data['status'], $_REQUEST['certificate_status'], fn_get_notification_rules(array(), false));
//if difference then add line in log
$debit_info = db_get_row("SELECT debit AS amount, debit_products AS products FROM ?:gift_certificates_log WHERE gift_cert_id = ?i ORDER BY timestamp DESC", $_REQUEST['gift_cert_id']);
if (empty($debit_info)) {
$debit_info = db_get_row("SELECT amount, products FROM ?:gift_certificates WHERE gift_cert_id = ?i", $_REQUEST['gift_cert_id']);
}
$is_diff = $gift_cert_data['amount'] - $debit_info['amount'] != 0 || md5(serialize($gift_cert_data['products'])) != md5($debit_info['products']) ? 'Y' : 'N';
if ($is_diff == 'Y') {
$_info = array('amount' => $gift_cert_data['amount'], 'products' => serialize($gift_cert_data['products']));
fn_add_gift_certificate_log_record($_REQUEST['gift_cert_id'], $debit_info, $_info);
}
//Update certificate data
$_data = $gift_cert_data;
$_data['products'] = !empty($_data['products']) ? serialize($_data['products']) : '';
db_query("UPDATE ?:gift_certificates SET ?u WHERE gift_cert_id = ?i", $_data, $_REQUEST['gift_cert_id']);
$gift_cert_data['gift_cert_id'] = $_REQUEST['gift_cert_id'];
fn_gift_certificate_notification($gift_cert_data, fn_get_notification_rules($_REQUEST));
$suffix = ".update?gift_cert_id={$_REQUEST['gift_cert_id']}";
}
}
if ($mode == 'preview') {
if (!empty($_REQUEST['gift_cert_data'])) {
fn_show_postal_card($_REQUEST['gift_cert_data']);
exit;
}
function fn_update_gift_certificate($gift_cert_data, $gift_cert_id = 0, $params = array())
{
fn_correct_gift_certificate($gift_cert_data);
$gift_cert_data['products'] = !empty($gift_cert_data['products']) ? serialize($gift_cert_data['products']) : '';
if (empty($gift_cert_id)) {
do {
$code = fn_generate_gift_certificate_code();
} while (true == fn_check_gift_certificate_code($code));
$gift_cert_data = fn_array_merge($gift_cert_data, array('gift_cert_code' => $code, 'timestamp' => TIME));
if (fn_allowed_for('ULTIMATE') && Registry::get('runtime.company_id')) {
$gift_cert_data['company_id'] = Registry::get('runtime.company_id');
}
$gift_cert_id = db_query("INSERT INTO ?:gift_certificates ?e", $gift_cert_data);
} else {
// Change certfificate status
fn_change_gift_certificate_status($gift_cert_id, $gift_cert_data['status'], '', fn_get_notification_rules(array(), false));
//if difference then add line in log
$debit_info = db_get_row("SELECT debit AS amount, debit_products AS products FROM ?:gift_certificates_log WHERE gift_cert_id = ?i ORDER BY timestamp DESC", $gift_cert_id);
if (empty($debit_info)) {
$debit_info = db_get_row("SELECT amount, products FROM ?:gift_certificates WHERE gift_cert_id = ?i", $gift_cert_id);
}
$is_diff = $gift_cert_data['amount'] - $debit_info['amount'] != 0 || md5($gift_cert_data['products']) != md5($debit_info['products']);
if ($is_diff == true) {
$_info = array('amount' => $gift_cert_data['amount'], 'products' => $gift_cert_data['products']);
fn_add_gift_certificate_log_record($gift_cert_id, $debit_info, $_info);
}
//Update certificate data
$_data = $gift_cert_data;
db_query("UPDATE ?:gift_certificates SET ?u WHERE gift_cert_id = ?i", $gift_cert_data, $gift_cert_id);
}
$gc_data = fn_get_gift_certificate_info($gift_cert_id);
fn_gift_certificate_notification($gc_data, fn_get_notification_rules($params));
return $gift_cert_id;
}
function fn_gift_certificates_place_order(&$order_id, &$action, &$order_status, &$cart)
{
if (!empty($order_id)) {
$is_parent_order = db_get_field("SELECT is_parent_order FROM ?:orders WHERE order_id = ?i", $order_id);
if ($is_parent_order == 'Y') {
return false;
}
if (defined('ORDER_MANAGEMENT')) {
// If the purchased certificate was deleted when editing, then it should be updated in the database
if (!empty($cart['gift_certificates_previous_state'])) {
$flip_gcps = array_flip(array_keys($cart['gift_certificates_previous_state']));
$flip_gc = array_flip(array_keys(!empty($cart['gift_certificates']) ? $cart['gift_certificates'] : array()));
$diff = array_diff_key($flip_gcps, $flip_gc);
if (!empty($diff)) {
foreach ($diff as $gift_cert_cart_id => $v) {
db_query("UPDATE ?:gift_certificates SET order_ids = ?p WHERE gift_cert_id = ?i", fn_remove_from_set('order_ids', $order_id), $cart['gift_certificates_previous_state'][$gift_cert_cart_id]['gift_cert_id']);
}
db_query("DELETE FROM ?:order_data WHERE order_id = ?i AND type = ?s", $order_id, ORDER_DATA_PURCHASED_GIFT_CERTIFICATES);
}
}
}
if (isset($cart['reset_use_gift_certificates'])) {
foreach ($cart['reset_use_gift_certificates'] as $v) {
db_query("UPDATE ?:gift_certificates SET order_ids = ?p WHERE gift_cert_id = ?i", fn_remove_from_set('order_ids', $order_id), $v);
}
unset($cart['reset_use_gift_certificates']);
}
if (isset($cart['gift_certificates'])) {
static $certificates = array();
foreach ($cart['gift_certificates'] as $k => $v) {
if (defined('ORDER_MANAGEMENT') && !empty($v['gift_cert_code'])) {
$code = $v['gift_cert_code'];
} else {
do {
$code = fn_generate_gift_certificate_code();
} while (true == fn_check_gift_certificate_code($code));
}
if (empty($cart['parent_order_id']) || empty($certificates[$cart['parent_order_id']])) {
$_data = $v;
$_data['gift_cert_code'] = $code;
$_data['timestamp'] = TIME;
$_data['status'] = 'P';
$_data['products'] = !empty($v['products']) ? serialize($v['products']) : '';
$company_id = Registry::get('runtime.company_id');
if (!empty($company_id)) {
$_data['company_id'] = $company_id;
}
$gift_cert_id = db_query('REPLACE INTO ?:gift_certificates ?e', $_data);
$_data['gift_cert_id'] = $gift_cert_id;
if (!empty($cart['parent_order_id'])) {
$certificates[$cart['parent_order_id']] = $_data;
}
} else {
$_data = $certificates[$cart['parent_order_id']];
$gift_cert_id = $_data['gift_cert_id'];
}
$cart['gift_certificates'][$k] = fn_array_merge($v, array('gift_cert_id' => $gift_cert_id, 'gift_cert_code' => $_data['gift_cert_code']));
db_query("UPDATE ?:gift_certificates SET order_ids = ?p WHERE gift_cert_id = ?i", fn_add_to_set('order_ids', $order_id), $gift_cert_id);
if (defined('ORDER_MANAGEMENT')) {
//If the certificate was not removed from the order, it is necessary to check whether the products and amount have been changed and modify the log.
$debit_info = db_get_row("SELECT debit AS amount, debit_products AS products FROM ?:gift_certificates_log WHERE gift_cert_id = ?i ORDER BY timestamp DESC", $gift_cert_id);
if (empty($debit_info)) {
$debit_info = db_get_row("SELECT amount, products FROM ?:gift_certificates WHERE gift_cert_id = ?i", $gift_cert_id);
}
if ($_data['amount'] - $debit_info['amount'] != 0 || md5($_data['products']) != md5($debit_info['products'])) {
$_info = array('amount' => $_data['amount'], 'products' => $_data['products']);
fn_add_gift_certificate_log_record($gift_cert_id, $debit_info, $_info);
}
}
}
$order_data = array('order_id' => $order_id, 'type' => ORDER_DATA_PURCHASED_GIFT_CERTIFICATES, 'data' => serialize($cart['gift_certificates']));
db_query("REPLACE INTO ?:order_data ?e", $order_data);
}
//--> FIXME: optimize this code:
if (!empty($cart['use_gift_certificates_previous_state'])) {
$flip_ugcps = array_flip(array_keys($cart['use_gift_certificates_previous_state']));
$flip_ugc = array_flip(array_keys(!empty($cart['use_gift_certificates']) ? $cart['use_gift_certificates'] : array()));
$diff = array_diff_key($flip_ugcps, $flip_ugc);
if (!empty($diff)) {
foreach ($diff as $gift_cert_code => $v) {
$gc_data = $cart['use_gift_certificates_previous_state'][$gift_cert_code]['previous_state'];
$log_records = db_get_array("SELECT log_id, amount, debit, products, debit_products FROM ?:gift_certificates_log WHERE log_id >= ?i AND gift_cert_id = ?i ORDER BY timestamp ASC", $gc_data['log_id'], $gc_data['gift_cert_id']);
foreach ($log_records as $record) {
if (!empty($gc_data['products'])) {
if ($record['log_id'] != $gc_data['log_id']) {
$record['products'] = unserialize($record['products']);
foreach ($gc_data['products'] as $po_product_id => $po_quantity) {
if (!isset($record['products'][$po_product_id])) {
$record['products'][$po_product_id] = $po_quantity;
} else {
$record['products'][$po_product_id] += $po_quantity;
}
if (empty($record['products'][$po_product_id])) {
unset($record['products'][$po_product_id]);
}
}
$record['products'] = serialize($record['products']);
}
$record['debit_products'] = unserialize($record['debit_products']);
foreach ($gc_data['products'] as $po_product_id => $po_quantity) {
if (!isset($record['debit_products'][$po_product_id])) {
$record['debit_products'][$po_product_id] = $po_quantity;
} else {
$record['debit_products'][$po_product_id] += $po_quantity;
}
if (empty($record['debit_products'][$po_product_id])) {
unset($record['debit_products'][$po_product_id]);
}
}
$record['debit_products'] = serialize($record['debit_products']);
}
if ($record['log_id'] != $gc_data['log_id']) {
$record['amount'] += $gc_data['cost'];
}
$record['debit'] += $gc_data['cost'];
db_query("UPDATE ?:gift_certificates_log SET ?u WHERE log_id = ?i", $record, $record['log_id']);
if (floatval($record['debit']) > 0 || unserialize($record['debit_products']) != array() && db_get_field("SELECT status FROM ?:gift_certificates WHERE gift_cert_id = ?", $gc_data['gift_cert_id']) == 'U') {
fn_change_gift_certificate_status($gc_data['gift_cert_id'], 'A');
}
}
}
}
}
if (isset($cart['use_gift_certificates'])) {
$debit_products = array();
$use_gift_certificates = array();
if (!empty($cart['deleted_exclude_products'][GIFT_CERTIFICATE_EXCLUDE_PRODUCTS])) {
foreach ($cart['deleted_exclude_products'][GIFT_CERTIFICATE_EXCLUDE_PRODUCTS] as $cart_id => $v) {
foreach ($v['in_use_certificate'] as $gift_cert_code => $amount) {
$debit_products[$gift_cert_code]['products'][$v['product_id']] = $amount;
}
}
}
$use_gift_certificate_products = array();
if (!empty($cart['products'])) {
foreach ($cart['products'] as $product) {
if (!empty($product['extra']['exclude_from_calculate']) && $product['extra']['exclude_from_calculate'] == GIFT_CERTIFICATE_EXCLUDE_PRODUCTS) {
foreach ($product['extra']['in_use_certificate'] as $gift_cert_code => $quantity) {
$use_gift_certificate_products[$gift_cert_code][$product['product_id']] = $quantity;
}
}
}
}
foreach ($cart['use_gift_certificates'] as $k => $v) {
if (!empty($v['log_id'])) {
$product_odds = array();
$amount_odds = $v['previous_state']['cost'] - $v['cost'];
$current_state_products = !empty($use_gift_certificate_products[$k]) ? $use_gift_certificate_products[$k] : array();
if (sizeof($v['previous_state']['products']) != sizeof($current_state_products) || serialize($v['previous_state']['products']) != serialize($current_state_products)) {
if (!empty($v['previous_state']['products'])) {
foreach ($v['previous_state']['products'] as $product_id => $quantity) {
if (!isset($current_state_products[$product_id])) {
$product_odds[$product_id] = $quantity;
} else {
$product_odds[$product_id] = $quantity - $current_state_products[$product_id];
}
if (empty($product_odds[$product_id])) {
unset($product_odds[$product_id]);
}
}
} elseif (!empty($current_state_products)) {
foreach ($current_state_products as $product_id => $quantity) {
$product_odds[$product_id] = -$quantity;
}
}
}
if ($amount_odds != 0 || !empty($product_odds)) {
$log_records = db_get_array("SELECT log_id, amount, debit, products, debit_products FROM ?:gift_certificates_log WHERE log_id >= ?i AND gift_cert_id = ?i ORDER BY timestamp ASC", $v['log_id'], $v['gift_cert_id']);
foreach ($log_records as $record) {
if (!empty($product_odds)) {
if ($record['log_id'] != $v['log_id']) {
$record['products'] = unserialize($record['products']);
foreach ($product_odds as $po_product_id => $po_quantity) {
if (!isset($record['products'][$po_product_id])) {
$record['products'][$po_product_id] = $po_quantity;
} else {
$record['products'][$po_product_id] += $po_quantity;
}
if (empty($record['products'][$po_product_id])) {
unset($record['products'][$po_product_id]);
}
}
$record['products'] = serialize($record['products']);
}
$record['debit_products'] = unserialize($record['debit_products']);
foreach ($product_odds as $po_product_id => $po_quantity) {
if (!isset($record['debit_products'][$po_product_id])) {
$record['debit_products'][$po_product_id] = $po_quantity;
} else {
$record['debit_products'][$po_product_id] += $po_quantity;
}
if (empty($record['debit_products'][$po_product_id])) {
unset($record['debit_products'][$po_product_id]);
}
}
$record['debit_products'] = serialize($record['debit_products']);
} else {
if ($record['log_id'] != $v['log_id']) {
$record['amount'] += $amount_odds;
}
$record['debit'] += $amount_odds;
}
db_query("UPDATE ?:gift_certificates_log SET ?u WHERE log_id = ?i", $record, $record['log_id']);
$use_gift_certificates[$k] = array('gift_cert_id' => $v['gift_cert_id'], 'amount' => $v['previous_state']['amount'], 'cost' => $v['cost'], 'log_id' => $v['log_id']);
if (floatval($record['debit']) <= 0 && unserialize($record['debit_products']) == array()) {
fn_change_gift_certificate_status($v['gift_cert_id'], 'U');
} elseif (floatval($record['debit']) > 0 || unserialize($record['debit_products']) != array() && db_get_field("SELECT status FROM ?:gift_certificates WHERE gift_cert_id = ?i", $v['gift_cert_id']) == 'U') {
fn_change_gift_certificate_status($v['gift_cert_id'], 'A');
}
}
}
//<-- FIXME: optimize this code
} else {
$before_info = array('amount' => $v['amount'], 'products' => serialize(!empty($v['products']) ? $v['products'] : array()));
$after_info = array('amount' => fn_format_price($v['amount'] - $v['cost']), 'products' => serialize(!empty($debit_products[$k]['products']) ? $debit_products[$k]['products'] : array()));
$log_id = fn_add_gift_certificate_log_record($v['gift_cert_id'], $before_info, $after_info, $order_id);
$use_gift_certificates[$k] = array('gift_cert_id' => $v['gift_cert_id'], 'amount' => $v['amount'], 'cost' => $v['cost'], 'log_id' => $log_id);
if (floatval($v['amount'] - $v['cost']) <= 0 && !isset($debit_products[$k]['products'])) {
fn_change_gift_certificate_status($v['gift_cert_id'], 'U');
}
}
db_query("UPDATE ?:gift_certificates SET order_ids = ?p WHERE gift_cert_id = ?i", fn_add_to_set('order_ids', $order_id), $v['gift_cert_id']);
}
$order_data = array('order_id' => $order_id, 'type' => 'U', 'data' => serialize($use_gift_certificates));
db_query("REPLACE INTO ?:order_data ?e", $order_data);
}
}
}
