Exemplo n.º 1
0
function _xt_report_yiqifa_page($start, $end, $page = 1, $action_id = '', $order_no = '', $status = '')
{
    $app = xt_get_app_yiqifa();
    if (empty($app) || empty($app['account']) || empty($app['sid']) || empty($app['syncSecret'])) {
        wp_die('尚未配置亿起发账号,网站主ID,密钥!');
    }
    //$url = 'http://o.yiqifa.com/servlet/queryCpsMultiRow?sid=' . urlencode($app['sid']) . '&username='******'account']) . '&privatekey=' . urlencode($app['syncSecret']) . '&st=' . urlencode($start) . '&ed=' . urlencode($end);
    $url = 'http://o.yiqifa.com/servlet/queryCpsMultiRow?sid=' . $app['sid'] . '&username='******'account']) . '&privatekey=' . urlencode($app['syncSecret']) . '&ed=' . urlencode($end) . '&st=' . urlencode($start) . '&action_id=' . urlencode($action_id) . '&order_no=' . urlencode($order_no) . '&status=' . urlencode($status);
    $body = file_get_contents($url);
    if (!empty($body)) {
        $body = xt_iconv($body, 'GBK', 'UTF-8');
        $lines = explode("\n", $body);
        if (!empty($lines)) {
            foreach ($lines as $line) {
                $line = trim($line);
                if (!empty($line)) {
                    $params = explode("||", $line);
                    if (!empty($params) && count($params) > 17) {
                        $yiqifaId = $params[0];
                        // 亿起发唯一编号
                        $actionId = $params[1];
                        // 联盟活动编号
                        $sid = $params[2];
                        // 网营商ID(商城)
                        $wid = $params[3];
                        // 网站编号
                        $orderTime = $params[4];
                        // 下单时间
                        $orderNo = $params[5];
                        // 订单编号
                        $commissionType = $params[6];
                        //佣金分类
                        $itemId = $params[7];
                        //商品编号
                        $itemNums = $params[8];
                        //订单商品件数
                        $itemPrice = $params[9];
                        //订单商品价格
                        $outerCode = $params[10];
                        //反馈标签(返利标识)
                        $orderStatus = $params[11];
                        //订单状态
                        $commission = $params[12];
                        //网站主佣金
                        $cid = $params[13];
                        //商品分类
                        //14 未知
                        $itemTitle = $params[15];
                        //商品标题
                        $actionName = $params[16];
                        //商城活动标题
                        //17 ?时间
                        //18无
                        //19无
                        //20 ?价格
                        //21无
                        //22无
                        global $xt_report_total;
                        $xt_report_total++;
                        global $wpdb;
                        $count = $wpdb->get_var("SELECT COUNT(*) FROM " . XT_TABLE_YIQIFA_REPORT . " WHERE yiqifaId={$yiqifaId}");
                        $_user_id = '';
                        $_user_name = '';
                        $users = xt_report_fanxian_member('yiqifa', $outerCode);
                        $buyer = $users['buyer'];
                        $sharer = $users['sharer'];
                        $adser = $users['adser'];
                        if ($buyer->exists()) {
                            $_user_id = $buyer->ID;
                            $_user_name = $buyer->user_login;
                        }
                        if ($count == 0) {
                            $wpdb->insert(XT_TABLE_YIQIFA_REPORT, array('yiqifaId' => $yiqifaId, 'actionId' => $actionId, 'actionName' => $actionName, 'cid' => $cid, 'cname' => $cid, 'commission' => $commission, 'commissionType' => $commissionType, 'itemId' => $itemId, 'itemNums' => $itemNums, 'itemPrice' => $itemPrice, 'itemTitle' => $itemTitle, 'orderNo' => $orderNo, 'orderStatus' => $orderStatus, 'orderTime' => $orderTime, 'outerCode' => $outerCode, 'sid' => $sid, 'wid' => $wid, 'user_id' => $_user_id, 'user_name' => $_user_name));
                            global $xt_report_insert;
                            $xt_report_insert++;
                        } else {
                            $wpdb->update(XT_TABLE_YIQIFA_REPORT, array('actionId' => $actionId, 'actionName' => $actionName, 'cid' => $cid, 'cname' => $cid, 'commission' => $commission, 'commissionType' => $commissionType, 'itemId' => $itemId, 'itemNums' => $itemNums, 'itemPrice' => $itemPrice, 'itemTitle' => $itemTitle, 'orderNo' => $orderNo, 'orderStatus' => $orderStatus, 'orderTime' => $orderTime, 'outerCode' => $outerCode, 'sid' => $sid, 'wid' => $wid), array('yiqifaId' => $yiqifaId));
                        }
                        if ($orderStatus == 'A' && xt_is_fanxian()) {
                            //订单状态已确认
                            xt_report_fanxian_save('yiqifa', $buyer, $sharer, $adser, $yiqifaId, $commission, $orderTime);
                        }
                    }
                }
            }
        }
    }
}
Exemplo n.º 2
0
function xt_ajax_unorder()
{
    $result = array('code' => 0, 'msg' => '', 'result' => array());
    if (!isset($_POST['id']) || empty($_POST['id'])) {
        $result['code'] = 500;
        $result['msg'] = '未指定要找回的订单';
        exit(json_encode($result));
    }
    if (!isset($_POST['platform']) || empty($_POST['platform'])) {
        $result['code'] = 500;
        $result['msg'] = '未指定要找回的订单的类型';
        exit(json_encode($result));
    }
    if (!isset($_POST['tradeId']) || empty($_POST['tradeId'])) {
        $result['code'] = 500;
        $result['msg'] = '未指定要找回的订单的订单号';
        exit(json_encode($result));
    }
    $table = '';
    $field_tradeId = '';
    $field_commission = '';
    $field_payTime = '';
    $field_outer = 'outInfo';
    switch ($_POST['platform']) {
        case 'taobao':
            $table = XT_TABLE_TAOBAO_REPORT;
            $field_tradeId = 'trade_id';
            $field_commission = 'commission';
            $field_payTime = 'pay_time';
            $field_outer = 'outer_code';
            break;
        case 'paipai':
            $table = XT_TABLE_PAIPAI_REPORT;
            $field_tradeId = 'dealId';
            $field_commission = 'brokeragePrice';
            $field_payTime = 'chargeTime';
            $field_outer = 'outInfo';
            break;
        case 'yiqifa':
            $table = XT_TABLE_YIQIFA_REPORT;
            $field_tradeId = 'orderNo';
            $field_commission = 'commission';
            $field_payTime = 'orderTime';
            $field_outer = 'outerCode';
            break;
    }
    if (empty($table)) {
        $result['code'] = 500;
        $result['msg'] = '订单类型不正确';
        exit(json_encode($result));
    }
    $user = wp_get_current_user();
    if ($user->exists()) {
        global $wpdb;
        $order = $wpdb->get_row('SELECT * FROM ' . $table . ' WHERE id=' . intval($_POST['id']));
        if (empty($order)) {
            $result['code'] = 500;
            $result['msg'] = '未找到指定的订单';
            exit(json_encode($result));
        }
        if ($order->user_id > 0) {
            $result['code'] = 500;
            $result['msg'] = '该订单已被[' . $order->user_name . ']找回';
            exit(json_encode($result));
        }
        if ($order->{$field_tradeId} == $_POST['tradeId']) {
            if ($wpdb->update($table, array('user_id' => $user->ID, 'user_name' => $user->user_login), array('id' => intval($_POST['id'])))) {
                $needFanxian = false;
                $commission = $order->{$field_commission};
                if ($_POST['platform'] == 'paipai') {
                    $commission = round($commission / 100, 2);
                    $needFanxian = $order->bargainState == 0 && xt_is_fanxian();
                } elseif ($_POST['platform'] == 'yiqifa') {
                    $needFanxian = $order->orderStatus == 'A' && xt_is_fanxian();
                } elseif ($_POST['platform'] == 'taobao') {
                    $needFanxian = true;
                }
                if ($needFanxian) {
                    if (!empty($order->{$field_outer}) && preg_match("/^([a-zA-Z]{4})8\$/", str_replace(XT_FANXIAN_PRE, '', $order->{$field_outer}), $guids)) {
                        $users = xt_report_fanxian_member($_POST['platform'], $order->{$field_outer} . xt_user_guid($user->ID));
                        $buyer = $users['buyer'];
                        $sharer = $users['sharer'];
                        $adser = $users['adser'];
                        xt_report_fanxian_save($_POST['platform'], $buyer, $sharer, $adser, $_POST['tradeId'], $commission, $order->{$field_payTime});
                    } else {
                        $users = xt_report_fanxian_member($_POST['platform'], XT_FANXIAN_PRE . $user->ID);
                        $buyer = $users['buyer'];
                        $sharer = $users['sharer'];
                        $adser = $users['adser'];
                        xt_report_fanxian_save($_POST['platform'], $buyer, $sharer, $adser, $_POST['tradeId'], $commission, $order->{$field_payTime});
                    }
                }
            }
        } else {
            $result['code'] = 500;
            $result['msg'] = '订单号不正确';
        }
    } else {
        $result['code'] = 500;
        $result['msg'] = '未登录';
    }
    exit(json_encode($result));
}