124 lines
5.8 KiB
PHP
124 lines
5.8 KiB
PHP
<?php
|
|
/*
|
|
* 人人商城
|
|
*
|
|
* 青岛易联互动网络科技有限公司
|
|
* http://www.we7shop.cn
|
|
* TEL: 4000097827/18661772381/15865546761
|
|
*/
|
|
error_reporting(0);
|
|
require "../../../../../framework/bootstrap.inc.php";
|
|
require dirname(__DIR__) . "/../../defines.php";
|
|
require "../../../../../addons/" . EWEI_SHOP_V2_MODULE_NAME . "/core/inc/functions.php";
|
|
global $_W, $_GPC;
|
|
|
|
$data = intval($_GPC['uniacid']);
|
|
|
|
if ($data) {
|
|
$where = ' uniacid = ' . $data;
|
|
}
|
|
else {
|
|
$where = 1;
|
|
}
|
|
ignore_user_abort(); //忽略关闭浏览器
|
|
set_time_limit(0); //永远执行
|
|
$sets = pdo_fetchall('select uniacid,refund from ' . tablename('ewei_shop_groups_set') . ' where ' . $where);
|
|
foreach ($sets as $key => $value) {
|
|
global $_W, $_GPC,$_S;
|
|
$_W['uniacid'] = $value['uniacid'];
|
|
$shopset = $_S['shop'];
|
|
if (empty($_W['uniacid'])) {
|
|
continue;
|
|
}
|
|
|
|
$hours = intval($value['refund']); //拼团失败X小时
|
|
if ($hours <= 0) {
|
|
//不自动退款
|
|
continue;
|
|
}
|
|
$times = $hours * 60 * 60;
|
|
$orders = pdo_fetchall("select id,orderno,refundid,openid,credit,creditmoney,price,freight,status,pay_type,teamid,apppay,isborrow,borrowopenid,more_spec from " . tablename('ewei_shop_groups_order') . "
|
|
where uniacid={$_W['uniacid']} and status = 1 and pay_type !='other' and success = -1 and refundtime = 0 and canceltime + {$times} <= ".time()." order by id desc ");
|
|
foreach ($orders as $k => $val) {
|
|
//退款金额
|
|
$realprice = $val['price'] - $val['creditmoney'] + $val['freight'];
|
|
//购物积分
|
|
$credits = $val['credit'];
|
|
if ($val['pay_type'] == 'credit') {
|
|
|
|
//余额支付，直接返回余额
|
|
$result = m('member')->setCredit($val['openid'], 'credit2', $realprice, array(0, $shopset['name'] . "退款: {$realprice}元 订单号: " . $val['orderno']));
|
|
} else if ($val['pay_type'] == 'wechat') {
|
|
//微信支付，走退款 接口
|
|
//直接退还扣除减掉余额抵扣
|
|
$realprice = round($realprice, 2);
|
|
if (empty($val['isborrow'])){
|
|
$result = m('finance')->refund($val['openid'], $val['orderno'], $val['orderno'], $realprice * 100, $realprice * 100, !empty($val['apppay']) ? true : false);
|
|
}else{
|
|
$result = m('finance')->refundBorrow($val['borrowopenid'], $val['orderno'], $val['orderno'], $realprice * 100, $realprice * 100, !empty($val['apppay']) ? true : false);
|
|
}
|
|
//$result = m('finance')->refund($val['openid'], $val['orderno'], $val['orderno'], floatval($realprice) * 100, $realprice * 100, !empty($val['apppay']) ? true : false);
|
|
$refundtype = 2;
|
|
} elseif( $val['pay_type'] == 'wxapp' ) {
|
|
//微信小程序支付，走小程序退款 接口
|
|
//直接退还扣除减掉余额抵扣
|
|
$realprice = round($realprice, 2);
|
|
$result = m('finance')->wxapp_refund($val['openid'], $val['orderno'], $val['orderno'], $realprice * 100, $realprice * 100);
|
|
|
|
}else{
|
|
//其他支付方式，走微信企业付款
|
|
if ($realprice < 0.3) {
|
|
show_json(0, '退款金额必须大于0.3元，才能使用微信企业付款退款!');
|
|
}
|
|
|
|
$result = m('finance')->pay($val['openid'], 1, $realprice * 100, $val['orderno'], $shopset['name'] . "退款: {$realprice}元 订单号: " . $val['orderno']);
|
|
$refundtype = 1;
|
|
}
|
|
if(is_error($result) && $result['message'] != 'OK | 订单已全额退款' && $result['message'] != 'Refund exists|退款已存在'){
|
|
continue;
|
|
}
|
|
//返还抵扣积分
|
|
if ($credits > 0) {
|
|
m('member')->setCredit($val['openid'], 'credit1', $credits, array('0', $shopset['name'] . "购物返还抵扣积分 积分: {$val['credit']} 抵扣金额: {$val['creditmoney']} 订单号: {$val['orderno']}"));
|
|
}
|
|
//模板消息
|
|
/*p('groups')->sendTeamMessage($val['id'], true);*/
|
|
//修复拼团失败的订单，自动退款的时候，已经发起退款申请的订单提示订单无法申请问题
|
|
$refund = pdo_fetch('select * from ' . tablename('ewei_shop_groups_order_refund') . ' where id=:id limit 1', array(':id' => $val['refundid']));
|
|
if(empty($refund)!=true){
|
|
if($refund['refundstatus']==0){
|
|
|
|
$change_refund['refundstatus'] = 1;
|
|
$change_refund['refundtype'] = $refundtype;
|
|
$change_refund['refundtime'] = time();
|
|
|
|
if (empty($refund['operatetime'])) {
|
|
$change_refund['operatetime'] = time();
|
|
}
|
|
|
|
//同意
|
|
pdo_update('ewei_shop_groups_order_refund', $change_refund, array('id' => $val['refundid']));
|
|
}
|
|
}
|
|
//更新订单退款状态
|
|
pdo_update('ewei_shop_groups_order', array('refundstate' => 0, 'status' => -1, 'refundtime' => time()), array('id' => $val['id'], 'uniacid' => $_W['uniacid']));
|
|
|
|
//更新实际销量
|
|
$sales = pdo_fetch("select id,sales,stock from ".tablename('ewei_shop_groups_goods')." where id = :id and uniacid = :uniacid ",array(':id'=>$val['goodid'], ':uniacid' => $uniacid));
|
|
|
|
pdo_update('ewei_shop_groups_goods', array('sales' => $sales['sales'] - 1,'stock'=>$sales['stock'] + 1), array('id' => $sales['id'], 'uniacid' => $uniacid));
|
|
//如果是多规格
|
|
if( $val['more_spec'] == 1 ){
|
|
$option = pdo_get( 'ewei_shop_groups_order_goods' , array( 'uniacid' => $_W['uniacid'] , 'groups_order_id' => $val['id'] ) );
|
|
//更新多规格库存
|
|
pdo_update( 'ewei_shop_groups_goods_option' , array( 'stock' => 'stock+1' ),array( 'id' => $option['groups_goods_option_id'] ) );
|
|
}
|
|
|
|
plog('groups.task.refund', "订单退款 ID: {$val['id']} 订单号: {$val['orderno']}");
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|