示例#1
0
function fn_delete_affiliate_commissions($commission_ids, $plan_id)
{
    $plan_data = fn_get_affiliate_plan_data($plan_id, DESCR_SL);
    if (!empty($plan_data)) {
        foreach ($commission_ids as $com_id) {
            unset($plan_data['commissions'][$com_id]);
        }
        return fn_update_affiliate_plan($plan_data, $plan_id, DESCR_SL);
    }
    return $plan_id;
}
示例#2
0
function fn_add_partner_action($action, $banner_id, $partner_id, $customer_id = '', $additional_data = '', $amount = '0', $multi_tier_account = false)
{
    $auth =& $_SESSION['auth'];
    $payout_types =& Registry::get('payout_types');
    if (empty($action) || empty($partner_id)) {
        return false;
    }
    if (!$multi_tier_account && AREA != 'A') {
        fn_set_partner_cookie($partner_id);
    }
    $data = array();
    $data['banner_id'] = $banner_id;
    $data['partner_id'] = $partner_id;
    $data['customer_id'] = $customer_id;
    $data['date'] = TIME;
    $data['ip'] = $action == 'init_balance' ? '' : $_SERVER['REMOTE_ADDR'];
    $data['action'] = $action;
    $data['approved'] = Registry::get('addons.affiliate.automatic_approval_commissions') == 'Y' && $action != 'sale' ? 'Y' : 'N';
    $data['plan_id'] = db_get_field("SELECT plan_id FROM ?:aff_partner_profiles WHERE user_id = ?i", $partner_id);
    if (empty($data['plan_id'])) {
        return false;
    }
    if ($multi_tier_account) {
        $data['amount'] = round($amount, 2);
    } elseif (!empty($payout_types[$action])) {
        $plan_data = fn_get_affiliate_plan_data($data['plan_id']);
        $payout_values = $plan_data['payout_types'];
        $p_value = false;
        if ($action == 'sale' && !empty($additional_data['P'])) {
            $p_value = fn_get_payout_value($data['plan_id'], $additional_data['P'], 'product');
            if ($p_value === false) {
                $product_data = fn_get_product_data($additional_data['P'], $auth);
                if (!empty($product_data['main_category'])) {
                    $p_value = fn_get_payout_value($data['plan_id'], $product_data['main_category'], 'category');
                }
            }
        } elseif ($action == 'use_coupon' && !empty($additional_data['D'])) {
            $p_value = fn_get_payout_value($data['plan_id'], $additional_data['D'], 'promotion');
        }
        if ($p_value === false) {
            if (empty($payout_values[$action]) || $action != 'init_balance' && (empty($payout_types[$action]['default']) || $payout_types[$action]['default'] != 'Y')) {
                $p_value = array('value' => 0, 'value_type' => 'A');
            } else {
                $p_value = $payout_values[$action];
            }
        }
        $data['amount'] = @$p_value['value_type'] == 'A' ? @$p_value['value'] : $amount * $p_value['value'] / 100;
        $data['amount'] = round($data['amount'], 2);
    }
    $data = fn_check_table_fields($data, 'aff_partner_actions');
    $action_id = db_query("INSERT INTO ?:aff_partner_actions ?e", $data);
    if (!empty($action_id)) {
        if (Registry::get('addons.affiliate.automatic_approval_commissions') == 'Y' && $action != 'sale') {
            fn_update_partner_balance($data['partner_id'], $data['amount'], '+');
        }
        if (!empty($additional_data) && is_array($additional_data)) {
            foreach ($additional_data as $object_type => $object_data) {
                $object_type = substr($object_type, 0, 1);
                $object_type = strtoupper($object_type);
                $_data = array('action_id' => $action_id, 'object_data' => $object_data, 'object_type' => $object_type);
                $_data = fn_check_table_fields($_data, 'aff_action_links');
                db_query("INSERT INTO ?:aff_action_links ?e", $_data);
            }
        }
        if (!$multi_tier_account && $action != 'init_balance') {
            fn_add_commissions_to_multi_tier_affiliates($action, $data['partner_id'], array('commission' => $data['amount'], 'price' => round($amount, 2)), $action_id, $data['customer_id'], $data['banner_id'], $additional_data);
        }
    }
    return true;
}
示例#3
0
    // FIXME: page
    $payouts = db_get_hash_array("SELECT ?:affiliate_payouts.*, ?:users.user_login, ?:users.firstname, ?:users.lastname FROM ?:affiliate_payouts LEFT JOIN ?:users ON ?:affiliate_payouts.partner_id=?:users.user_id WHERE ?p AND ?:users.user_id = ?i ORDER BY {$sorting} {$limit}", 'payout_id', $payout_search_condition, $auth['user_id']);
    $view->assign('payouts', $payouts);
} elseif ($mode == 'update') {
    if (empty($_REQUEST['payout_id'])) {
        return array(CONTROLLER_STATUS_NO_PAGE);
    } else {
        $payout_data = db_get_row("SELECT * FROM ?:affiliate_payouts WHERE payout_id = ?i", $_REQUEST['payout_id']);
        if (empty($payout_data)) {
            return array(CONTROLLER_STATUS_NO_PAGE);
        } else {
            if (!empty($payout_data['partner_id'])) {
                $payout_data['partner'] = fn_get_partner_data($payout_data['partner_id']);
            }
            if (!empty($payout_data['partner']['plan_id'])) {
                $payout_data['plan'] = fn_get_affiliate_plan_data($payout_data['partner']['plan_id']);
            }
            $payout_data['actions'] = fn_get_affiliate_actions($_REQUEST);
            $payout_data['date_range']['min'] = db_get_field("SELECT MIN(date) FROM ?:aff_partner_actions WHERE payout_id = ?i", $_REQUEST['payout_id']);
            $payout_data['date_range']['max'] = db_get_field("SELECT MAX(date) FROM ?:aff_partner_actions WHERE payout_id = ?i", $_REQUEST['payout_id']);
            // [Breadcrumbs]
            fn_add_breadcrumb(fn_get_lang_var('payouts'), "payouts.manage");
            // [/Breadcrumbs]
            $view->assign('affiliate_plan', fn_get_affiliate_plan_data_by_partner_id($auth['user_id']));
            $view->assign('payouts', array($payout_data['partner_id'] => $payout_data));
        }
        $view->assign('sort_order', empty($sort_order) || $sort_order == 'asc' ? 'desc' : 'asc');
        $view->assign('sort_by', empty($sort_by) ? 'date' : $sort_by);
    }
}
/** /Body **/
示例#4
0
function fn_add_payouts($params, $lang_code = CART_LANGUAGE)
{
    // Init filter
    $params = fn_init_view('pay_affiliates', $params);
    // Set default values to input params
    $params['page'] = empty($params['page']) ? 1 : $params['page'];
    // default page is 1
    // Define sort fields
    $sortings = array('action' => "actions.action", 'date' => "actions.date", 'cost' => "actions.amount", 'banner' => "banner");
    $directions = array('asc' => 'asc', 'desc' => 'desc');
    if (empty($params['sort_order']) || empty($directions[$params['sort_order']])) {
        $params['sort_order'] = 'desc';
    }
    if (empty($params['sort_by']) || empty($sortings[$params['sort_by']])) {
        $params['sort_by'] = 'date';
    }
    $sorting = (is_array($sortings[$params['sort_by']]) ? implode(' ' . $directions[$params['sort_order']] . ', ', $sortings[$params['sort_by']]) : $sortings[$params['sort_by']]) . " " . $directions[$params['sort_order']];
    // Reverse sorting (for usage in view)
    $params['sort_order'] = $params['sort_order'] == 'asc' ? 'desc' : 'asc';
    $new_payouts = array();
    if (!empty($params['partner_ids'])) {
        $date_condition = "";
        if (!empty($params['last_payout']) && !empty($params['time_from'])) {
            $date_condition = db_quote(" AND date < ?i", $params['time_from']);
        }
        foreach ($params['partner_ids'] as $_partner_id) {
            $condition = "1 " . $date_condition . db_quote(" AND approved = 'Y' AND payout_id = 0 AND partner_id = ?i", $_partner_id);
            $new_payouts[$_partner_id]['amount'] = db_get_field("SELECT SUM(amount) FROM ?:aff_partner_actions WHERE {$condition}");
            if (empty($new_payouts[$_partner_id]['amount'])) {
                unset($new_payouts[$_partner_id]);
            } else {
                $new_payouts[$_partner_id]['partner'] = fn_get_partner_data($_partner_id);
                if (!empty($new_payouts[$_partner_id]['partner']['plan_id'])) {
                    $new_payouts[$_partner_id]['plan'] = fn_get_affiliate_plan_data($new_payouts[$_partner_id]['partner']['plan_id'], $lang_code);
                }
                $_params = array('sort_by' => $params['sort_by'], 'sort_order' => $params['sort_order'] == 'asc' ? 'desc' : 'asc');
                $new_payouts[$_partner_id]['actions'] = fn_get_affiliate_actions($condition, $_params, true, @$params['page']);
                $new_payouts[$_partner_id]['date_range']['min'] = db_get_field("SELECT MIN(date) FROM ?:aff_partner_actions WHERE {$condition}");
                $new_payouts[$_partner_id]['date_range']['max'] = db_get_field("SELECT MAX(date) FROM ?:aff_partner_actions WHERE {$condition}");
            }
        }
    }
    return array($new_payouts, $params);
}