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