/**
* Promotions post processing
*
* @param string $status_to new order status
* @param string $status_from original order status
* @param array $order_info order information
* @param array $force_notification Array with notification rules
* @return boolean always true
*/
function fn_promotion_post_processing($status_to, $status_from, $order_info, $force_notification = array())
{
$order_statuses = fn_get_statuses(STATUSES_ORDER, array(), true);
$notify_user = isset($force_notification['C']) ? $force_notification['C'] : (!empty($order_statuses[$status_to]['params']['notify']) && $order_statuses[$status_to]['params']['notify'] == 'Y' ? true : false);
$status_from_is_positive = fn_status_is_positive($order_statuses[$status_from]);
$status_to_is_positive = fn_status_is_positive($order_statuses[$status_to]);
if (empty($order_info['promotions'])) {
return false;
}
// Process numbers of usage for Open statuses
if ($status_to != $status_from && fn_status_is_positive($order_statuses[$status_from], true) != fn_status_is_positive($order_statuses[$status_to], true)) {
// Post processing
if (fn_status_is_positive($order_statuses[$status_to], true)) {
db_query("UPDATE ?:promotions SET number_of_usages = number_of_usages + 1 WHERE promotion_id IN (?n)", array_keys($order_info['promotions']));
} else {
db_query("UPDATE ?:promotions SET number_of_usages = number_of_usages - 1 WHERE promotion_id IN (?n)", array_keys($order_info['promotions']));
}
}
if ($status_to != $status_from && $status_from_is_positive != $status_to_is_positive) {
// Apply pending actions
foreach ($order_info['promotions'] as $k => $v) {
if (!empty($v['bonuses'])) {
foreach ($v['bonuses'] as $bonus) {
// Assign usergroup
if ($bonus['bonus'] == 'give_usergroup') {
$is_ug_already_assigned = false;
if (empty($order_info['user_id'])) {
continue;
}
// Don't assing a disabled usergroup
$system_usergroups = fn_get_usergroups(array('type' => 'C', 'status' => array('A', 'H')), CART_LANGUAGE);
if (!empty($system_usergroups[$bonus['value']]['status']) && in_array($system_usergroups[$bonus['value']]['status'], array('A', 'H'))) {
if ($order_statuses[$status_to]['params']['inventory'] == 'D') {
// Don't assing the usergroup to the user if it's already assigned
$current_user_usergroups = fn_get_user_usergroups($order_info['user_id']);
foreach ($current_user_usergroups as $ug) {
if (isset($ug['usergroup_id']) && $bonus['value'] == $ug['usergroup_id'] && in_array($ug['status'], array('A', 'H'))) {
$is_ug_already_assigned = true;
break;
}
}
if (!$is_ug_already_assigned) {
db_query("REPLACE INTO ?:usergroup_links SET user_id = ?i, usergroup_id = ?i, status = 'A'", $order_info['user_id'], $bonus['value']);
$activated = true;
}
} else {
db_query("UPDATE ?:usergroup_links SET status = 'F' WHERE user_id = ?i AND usergroup_id = ?i", $order_info['user_id'], $bonus['value']);
$activated = false;
}
if ($notify_user == true && !$is_ug_already_assigned) {
$prefix = $activated == true ? 'activation' : 'disactivation';
Mailer::sendMail(array('to' => $order_info['email'], 'from' => 'company_users_department', 'data' => array('user_data' => fn_get_user_info($order_info['user_id']), 'usergroups' => fn_get_usergroups(array('status' => array('A', 'H')), $order_info['lang_code']), 'usergroup_ids' => (array) $bonus['value']), 'tpl' => 'profiles/usergroup_' . $prefix . '.tpl', 'company_id' => $order_info['company_id']), 'C', $order_info['lang_code']);
}
} else {
if (AREA == 'C') {
fn_set_notification('E', __('error'), __('unable_to_assign_usergroup'));
}
}
} elseif ($bonus['bonus'] == 'give_coupon') {
$promotion_data = fn_get_promotion_data($bonus['value']);
if (empty($promotion_data)) {
continue;
}
if ($status_to_is_positive) {
fn_promotion_update_condition($promotion_data['conditions']['conditions'], 'add', 'auto_coupons', $bonus['coupon_code']);
if ($notify_user == true) {
Mailer::sendMail(array('to' => $order_info['email'], 'from' => 'company_users_department', 'data' => array('promotion_data' => $promotion_data, 'bonus_data' => $bonus, 'order_info' => $order_info), 'tpl' => 'promotions/give_coupon.tpl', 'company_id' => $order_info['company_id']), 'C', $order_info['lang_code']);
}
} else {
fn_promotion_update_condition($promotion_data['conditions']['conditions'], 'remove', 'auto_coupons', $bonus['coupon_code']);
}
db_query("UPDATE ?:promotions SET conditions = ?s, conditions_hash = ?s, users_conditions_hash = ?s WHERE promotion_id = ?i", serialize($promotion_data['conditions']), fn_promotion_serialize($promotion_data['conditions']['conditions']), fn_promotion_serialize_users_conditions($promotion_data['conditions']['conditions']), $bonus['value']);
}
}
}
}
}
return true;
}
function fn_update_promotion($data, $promotion_id, $lang_code = DESCR_SL)
{
if (!empty($data['conditions']['conditions'])) {
$data['conditions_hash'] = fn_promotion_serialize($data['conditions']['conditions']);
$data['users_conditions_hash'] = fn_promotion_serialize_users_conditions($data['conditions']['conditions']);
} else {
$data['conditions_hash'] = $data['users_conditions_hash'] = '';
}
$data['conditions'] = empty($data['conditions']) ? array() : $data['conditions'];
$data['bonuses'] = empty($data['bonuses']) ? array() : $data['bonuses'];
fn_promotions_check_group_conditions($data['conditions']);
if ($data['bonuses']) {
foreach ($data['bonuses'] as $k => $v) {
if (empty($v['bonus'])) {
unset($data['bonuses'][$k]);
}
}
}
$data['conditions'] = serialize($data['conditions']);
$data['bonuses'] = serialize($data['bonuses']);
$from_date = $data['from_date'];
$to_date = $data['to_date'];
$data['from_date'] = !empty($from_date) ? fn_parse_date($from_date) : 0;
$data['to_date'] = !empty($to_date) ? fn_parse_date($to_date, true) : 0;
if (!empty($data['to_date']) && $data['to_date'] < $data['from_date']) {
// protection from incorrect date range (special for isergi :))
$data['from_date'] = fn_parse_date($to_date);
$data['to_date'] = fn_parse_date($from_date, true);
}
if (!empty($promotion_id)) {
db_query("UPDATE ?:promotions SET ?u WHERE promotion_id = ?i", $data, $promotion_id);
db_query('UPDATE ?:promotion_descriptions SET ?u WHERE promotion_id = ?i AND lang_code = ?s', $data, $promotion_id, $lang_code);
} else {
$promotion_id = $data['promotion_id'] = db_query("REPLACE INTO ?:promotions ?e", $data);
foreach (fn_get_translation_languages() as $data['lang_code'] => $_v) {
db_query("REPLACE INTO ?:promotion_descriptions ?e", $data);
}
}
return $promotion_id;
}
