private function _pay_order($sn, $data)
{
global $db, $log;
//产品订单
$get_order_info = 'select `amount`,`account`,`business_account`,`product_amount`,`mobile`,`delivery_fee` from ' . $db->table('order') . ' where `order_sn`=\'' . $sn . '\'';
$order = $db->fetchRow($get_order_info);
add_order_log($sn, $order['account'], 3, "在线支付");
if ($order && $order['amount'] * 100 == $data->total_fee && $data->sign == tenpay_sign($data, $this->mch_key)) {
//验证订单金额正确
//1. 设置订单为已付款
$order_data = array('status' => 3, 'pay_time' => time());
$flag = $db->autoUpdate('order', $order_data, '`order_sn`=\'' . $sn . '\' and `status`<>3');
if ($flag && $db->get_affect_rows()) {
$log->record($sn . '支付成功');
//2. 订单结算
$get_path = 'select `path` from ' . $db->table('member') . ' where `account`=\'' . $order['account'] . '\'';
$path = $db->fetchOne($get_path);
distribution_settle($order['reward_amount'], $path, $sn);
//3. 新增商家收入
$business_income = $order['product_amount'] + $order['delivery_fee'] - $order['reward_amount'];
if (add_business_exchange($order['business_account'], 0, $business_income, $order['account'], '用户在线支付')) {
add_business_trade($order['business_account'], $business_income, $sn);
} else {
//增加商家收入失败
}
$get_order_detail = 'select `product_sn`,`product_name`,`count`,`is_virtual`,`attributes` from ' . $db->table('order_detail') . ' where `order_sn`=\'' . $sn . '\'';
$order_detail = $db->fetchAll($get_order_detail);
foreach ($order_detail as $od) {
//扣减库存
consume_inventory($od['product_sn'], $od['attributes'], $od['count']);
//如果是虚拟产品，则生成预约券
if ($od['is_virtual']) {
$get_virtual_contents = 'select `content`,`count`,`total` from ' . $db->table('virtual_content') . ' where `product_sn`=\'' . $od['product_sn'] . '\'';
$virtual_contents = $db->fetchAll($get_virtual_contents);
$virtual_content = '';
if ($virtual_contents) {
$virtual_content = serialize($virtual_contents);
}
add_order_content($order['business_account'], $order['account'], $order['mobile'], $sn, $od['product_sn'], $od['product_name'], $virtual_content, 2);
}
}
//如果会员购买了activity=4的产品，则升级
$check_can_levelup = 'select am.`activity_id` from ' . $db->table('activity_mapper') . ' as am left join ' . $db->table('order_detail') . ' using (`product_sn`) where `order_sn`=\'' . $sn . '\' and `activity_id`=4';
if ($db->fetchOne($check_can_levelup)) {
$member_data = array('level_id' => 1);
$db->autoUpdate('member', $member_data, '`account`=\'' . $order['account'] . '\'');
}
}
} else {
//金额不正确
}
}
echo json_encode($response);
exit;
}
if ('receive' == $opera) {
$order_sn = getPOST('order_sn');
$response = array('error' => 1, 'msg' => '');
if ($order_sn == '') {
$response['msg'] = '订单编号为空';
} else {
$order_sn = $db->escape($order_sn);
$check_order_sn = 'select `order_sn` from ' . $db->table('order') . ' where `order_sn`=\'' . $order_sn . '\' and `account`=\'' . $_SESSION['account'] . '\'';
$order_sn = $db->fetchOne($check_order_sn);
if ($order_sn) {
$data = array('status' => 7);
if ($db->autoUpdate('order', $data, '`order_sn`=\'' . $order_sn . '\'')) {
add_order_log($order_sn, $_SESSION['account'], 7, '用户确认收货');
//将款项打到商家账户中
//读取担保交易记录，并将款项打入到商家的余额中
$get_trade = 'select `id`,`business_account`,`trade` from ' . $db->table('trade') . ' where `remark`=\'' . $order_sn . '\' and `status`=0';
$trade = $db->fetchRow($get_trade);
if (add_business_exchange($trade['business_account'], $trade['trade'], -1 * $trade['trade'], $_SESSION['account'], '用户确认收货')) {
$trade_status = array('status' => 1, 'solve_time' => time());
$db->autoUpdate('trade', $trade_status, '`id`=' . $trade['id']);
}
//读取佣金,将佣金发放到用户账户里
$get_member_rewards = 'select `id`,`remark`,`integral`,`account`,`reward` from ' . $db->table('member_reward') . ' where `status`=0 and `assoc`=\'' . $order_sn . '\'';
$member_rewards = $db->fetchAll($get_member_rewards);
if ($member_rewards) {
foreach ($member_rewards as $reward) {
if (add_memeber_exchange_log($reward['account'], 0, $reward['reward'], $reward['integral'], -1 * $reward['integral'], -1 * $reward['reward'], $_SESSION['account'], $order_sn . '奖金发放')) {
$reward_status = array('status' => 1, 'solve_time' => time());
break;
}
$db->begin();
$status = 1;
$response['order_status'] = 1;
if ($cart['total_amount'] == 0) {
$status = 4;
$response['order_status'] = 4;
}
$business_account = $cart['business_account'];
$order_sn = add_order($cart['total_integral'], $cart['total_product_amount'], $cart['total_delivery_fee'], $cart['delivery_id'], $business_account, $cart['total_integral_given'], $payment_id, $address_id, $cart['total_reward'], $_SESSION['account'], $cart['integral_paid'], $cart['reward_paid'], $cart['balance_paid'], $status, 0, $cart['remark']);
if ($order_sn) {
if ($status == 4) {
$order_data = array('pay_time' => time());
$db->autoUpdate('order', $order_data, '`order_sn`=\'' . $order_sn . '\'');
add_order_log($order_sn, $_SESSION['account'], 4, "使用余额/佣金/积分支付");
}
if ($cart['balance_paid'] || $cart['reward_paid'] || $cart['integral_paid']) {
add_memeber_exchange_log($_SESSION['account'], -1 * $cart['balance_paid'], -1 * $cart['reward_paid'], -1 * $cart['integral_paid'], 0, 0, $_SESSION['account'], "抵扣订单金额");
}
$flag = true;
foreach ($cart['products'] as $od) {
if (!add_order_detail($od['product_sn'], $od['product_name'], $od['product_attributes'], $od['attributes'], $od['product_price'], $od['integral'], $od['integral_given'], $od['reward'], $od['count'], $business_account, $order_sn, $od['is_virtual'])) {
$flag = false;
} else {
if ($status == 4) {
//扣减库存
consume_inventory($od['product_sn'], $od['attributes'], $od['count']);
if ($od['is_virtual']) {
//如果是虚拟产品，则生成预约券
$get_virtual_contents = 'select `content`,`count`,`total` from ' . $db->table('virtual_content') . ' where `product_sn`=\'' . $od['product_sn'] . '\'';
//赠送积分给合伙人
add_memeber_exchange_log($account, 0, 0, $config['level_integral'], 0, 0, $account, '成为合伙人赠送积分');
$get_path = 'select `path` from ' . $db->table('member') . ' where `account`=\'' . $account . '\'';
$path = $db->fetchOne($get_path);
distribution_settle($config['partner_fee'], $path, $account . '成为合伙人');
}
} else {
}
} else {
//支付成功
$sn = $out_trade_no;
$sn = $db->escape($sn);
//产品订单
$get_order_info = 'select * from ' . $db->table('order') . ' where `order_sn`=\'' . $sn . '\'';
$order = $db->fetchRow($get_order_info);
add_order_log($sn, $order['account'], 3, "在线支付");
if ($order && $order['amount'] == $total_fee) {
//验证订单金额正确
//1. 设置订单为已付款
$order_data = array('status' => 3, 'pay_time' => time());
$flag = $db->autoUpdate('order', $order_data, '`order_sn`=\'' . $sn . '\' and `status`<3');
if ($flag && $db->get_affect_rows()) {
$log->record($sn . '支付成功');
//2. 订单结算
$get_path = 'select `path` from ' . $db->table('member') . ' where `account`=\'' . $order['account'] . '\'';
$path = $db->fetchOne($get_path);
distribution_settle($order['reward_amount'], $path, $sn);
//3. 新增商家收入
$business_income = $order['product_amount'] + $order['delivery_fee'] - $order['reward_amount'];
if (add_business_exchange($order['business_account'], 0, $business_income, $order['account'], '用户在线支付')) {
add_business_trade($order['business_account'], $business_income, $sn);
