where( array('order_id' => $order_id) )->find(); $member_info = M('lionfish_comshop_member')->where( array('member_id' => $order_info['member_id'] ) )->find(); $openId = $member_info['openid']; $we_openid = $member_info['we_openid']; if( $order_info['from_type'] == 'wepro' ) { $openId = $we_openid; } //we_openid //money $transaction_id = $order_info["transaction_id"]; if( $order_info['type'] == 'integral' ) { $total_fee = ( $order_info["shipping_fare"] )*100; }else{ $total_fee = ($order_info["total"] + $order_info["shipping_fare"]-$order_info['voucher_credit']-$order_info['fullreduction_money'] - $order_info['score_for_money']-$order_info['fare_shipping_free'] )*100; } //预售begin $presale_result = D('Home/PresaleGoods')->getOrderPresaleInfo( $order_id ); if( $presale_result['code'] ==0 ) { $total_fee = $total_fee - $presale_result['data']['presale_ding_money'] * 100; } //end $refund_fee = $total_fee; //order_goods_id if( !empty($order_goods_id) ) { $order_goods_info = M('lionfish_comshop_order_goods')->where( array('order_goods_id' =>$order_goods_id ) )->find(); $refund_fee = ($order_goods_info["total"] + $order_goods_info["shipping_fare"]-$order_goods_info['voucher_credit']-$order_goods_info['fullreduction_money'] - $order_goods_info['score_for_money']-$order_goods_info['fare_shipping_free'])*100; if( $order_info['type'] == 'integral' ) { $refund_fee = ( $order_goods_info["shipping_fare"] )*100; } } if($money > 0 && $order_info['type'] != 'integral' ) { $refund_fee = $money * 100; }else if( $money > 0 && $order_info['type'] == 'integral' && !empty($order_goods_info) ) { if(!empty($_GPC['refund_money'])){ $refund_money = isset($_GPC['refund_money']) && $_GPC['refund_money'] >0 ? floatval($_GPC['refund_money']) : 0; //商品多个运费和 $refund_fee = ( $money - $refund_money )*100; //商品多个商品单价和 $order_info['total'] = $refund_money; }else{ $order_refund_history_image = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_id) )->order('addtime asc')->find(); $ref_shipping_fare = M('lionfish_comshop_order_refund')->field('ref_id,ref_money,real_refund_quantity,ref_shipping_fare')->where( array('order_id' => $order_id ))->order('ref_id desc')->find(); $refund_fee = ( $ref_shipping_fare['ref_shipping_fare'] )*100; $order_info['total'] = $money ; } } // else if( isset($is_open_yinpay) && $is_open_yinpay == 3 ) $is_open_yinpay = D('Home/Front')->get_config_by_name('is_open_yinpay'); if($order_info['payment_code'] == 'yuer') { //余额支付的,退款到余额 //退款到余额 //增加会员余额 $refund_fee = $refund_fee / 100; if( $refund_fee > 0 ) { //判断是否积分类型的 M('lionfish_comshop_member')->where( array('member_id' => $order_info['member_id']) )->setInc('account_money',$refund_fee); $account_money_info = M('lionfish_comshop_member')->field('account_money')->where( array('member_id' =>$order_info['member_id'] ) )->find(); $account_money = $account_money_info['account_money']; $member_charge_flow_data = array(); $member_charge_flow_data['member_id'] = $order_info['member_id']; $member_charge_flow_data['money'] = $refund_fee; $member_charge_flow_data['operate_end_yuer'] = $account_money; $member_charge_flow_data['state'] = 4; $member_charge_flow_data['trans_id'] = $order_id; $member_charge_flow_data['order_goods_id'] = $order_goods_id; $member_charge_flow_data['charge_time'] = time(); $member_charge_flow_data['add_time'] = time(); M('lionfish_comshop_member_charge_flow')->add($member_charge_flow_data); } if($order_info['order_status_id'] == 12) { $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count(); if( $ref_count <= 1 ) { M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); } } $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id'] ) )->select(); $goods_model = D('Home/Pingoods'); foreach($order_goods_list as $order_goods) { //$goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity'],2); if( !empty($order_goods_id) && $order_goods_id > 0 ) { if($order_goods_id == $order_goods['order_goods_id'] ) { if($is_back_sellcount == 1) { if( $is_zi_order_refund == 1 && $refund_quantity > 0 ) { $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2); }else{ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_goods_id' => $order_goods['order_goods_id'],'order_id' =>$order_info['order_id'],'type' => 'orderbuy' ) )->find(); if( !empty($score_refund_info) && $is_zi_order_refund == 1 ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } }else if( empty($order_goods_id) || $order_goods_id <=0 ){ if($is_back_sellcount == 1){ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_goods_id' => $order_goods['order_goods_id'],'order_id' => $order_info['order_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } if( $order_info['type'] == 'integral' ) { D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_info['total'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } //分佣也要退回去 if($is_zi_order_refund == 0) D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id); return array('code' => 1); //$this->refundOrder_success($order_info,$openId); //检测是否有需要退回积分的订单 //货到付款订单 }else if($order_info['payment_code'] == 'cashon_delivery') { //货到付款订单退款金额不到账,但有退款记录 if($order_info['order_status_id'] == 12) { $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count(); if( $ref_count <= 1 ) { M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); } } $order_info['total'] = $refund_fee / 100; $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id'] ) )->select(); $goods_model = D('Home/Pingoods'); foreach($order_goods_list as $order_goods) { //$goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity'],2); if( !empty($order_goods_id) && $order_goods_id > 0 ) { if($order_goods_id == $order_goods['order_goods_id'] ) { if($is_back_sellcount == 1) { if( $is_zi_order_refund == 1 && $refund_quantity > 0 ) { $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2); }else{ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_goods_id' => $order_goods['order_goods_id'],'order_id' =>$order_info['order_id'],'type' => 'orderbuy' ) )->find(); if( !empty($score_refund_info) && $is_zi_order_refund == 1 ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } }else if( empty($order_goods_id) || $order_goods_id <=0 ){ if($is_back_sellcount == 1){ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_goods_id' => $order_goods['order_goods_id'],'order_id' => $order_info['order_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } /*if( $order_info['type'] == 'integral' ) { D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_info['total'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); }*/ } //分佣也要退回去 if($is_zi_order_refund == 0) D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id); return array('code' => 1); //$this->refundOrder_success($order_info,$openId); //检测是否有需要退回积分的订单 } else if($order_info['payment_code'] == 'admin'){ if($order_info['order_status_id'] == 12) { $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count(); if( $ref_count <= 1 ) { M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); } } $order_info['total'] = $refund_fee / 100; $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id'] ) )->select(); $goods_model = D('Home/Pingoods'); foreach($order_goods_list as $order_goods) { //$goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity'],2); if( !empty($order_goods_id) && $order_goods_id > 0 ) { if($order_goods_id == $order_goods['order_goods_id'] ) { if($is_back_sellcount == 1) { if( $is_zi_order_refund == 1 && $refund_quantity > 0 ) { $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2); }else{ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_goods_id' => $order_goods['order_goods_id'],'order_id' =>$order_info['order_id'],'type' => 'orderbuy' ) )->find(); if( !empty($score_refund_info) && $is_zi_order_refund == 1 ) { //D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } }else if( empty($order_goods_id) || $order_goods_id <=0 ){ if($is_back_sellcount == 1){ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_goods_id' => $order_goods['order_goods_id'],'order_id' => $order_info['order_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } if( $order_info['type'] == 'integral' ) { //D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_goods['total'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } //分佣也要退回去 if($is_zi_order_refund == 0) D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id); return array('code' => 1); } else if($refund_fee == 0) { if($order_info['order_status_id'] == 12) { $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count(); if( $ref_count <= 1 ) { M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); } } //ims_ lionfish_comshop_order_goods $order_goods = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id']) )->select(); $order_goods_name = ''; $order_goods_name_arr = array(); $goods_model = D('Home/Pingoods'); //get_config_by_name($name) foreach ($order_goods as $key => $value) { //($order_id,$option,$goods_id,$quantity,$type='1') if($is_back_sellcount == 1) { if( $is_zi_order_refund == 1 && $refund_quantity > 0 ) { $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$refund_quantity,2); }else{ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity']-$has_refund_quantity,2); } } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_id' =>$order_info['order_id'] ,'order_goods_id' =>$value['order_goods_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$value['order_goods_id'] ); } //销量回退 $order_goods_name_arr[] = $value['name']; } $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n"; $msg = '订单退款: 您的订单'.$order_info['order_num_alias'].'参团未成功,现退款:'.round($order_info["total"],2).'元,商品名称:'.$order_goods_name; $url = D('Home/Front')->get_config_by_name('shop_domain'); //weixin_template_refund_order //send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order')); /** {{first.DATA}} 订单编号:{{keyword1.DATA}} 退款金额:{{keyword2.DATA}} {{remark.DATA}} --------------------------- 校白君提醒您,您有一笔退款成功,请留意。 订单编号:20088115853 退款金额:¥19.00 更多学生价好货,在底部菜单栏哦~猛戳“校园专区”,享更多优惠! **/ $wx_template_data = array(); $wx_template_data['first'] = array('value' => '退款通知', 'color' => '#030303'); $wx_template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303'); $wx_template_data['keyword2'] = array('value' => round($order_info["total"],2), 'color' => '#030303'); $wx_template_data['remark'] = array('value' => '拼团失败已按原路退款', 'color' => '#030303'); if( $order_info['from_type'] == 'wepro' ) { $template_data = array(); $template_data['keyword1'] = array('value' => $order_info['order_num_alias'], 'color' => '#030303'); $template_data['keyword2'] = array('value' => '商户名称', 'color' => '#030303'); $template_data['keyword2'] = array('value' => $order_goods_name, 'color' => '#030303'); $template_data['keyword3'] = array('value' => $order_info['total'].'元', 'color' => '#030303'); $template_data['keyword4'] = array('value' => '已按原路退款', 'color' => '#030303'); $template_data['keyword5'] = array('value' => $member_info['uname'], 'color' => '#030303'); $template_id = D('Home/Front')->get_config_by_name('weprogram_template_refund_order'); $pagepath = 'lionfish_comshop/pages/order/order?id='.$order_info['order_id']; $member_formid_info = M('lionfish_comshop_member_formid')->where("member_id=".$order_info['member_id']." and formid != '' and state =0")->order('id desc')->find(); if(!empty( $member_formid_info )) { D('Seller/User')->send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid'] ); M('lionfish_comshop_member_formid')->where( array('id' => $member_formid_info['id']) )->save(array('state' => 1)); } if( $openid != '1') { //send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order')); } }else{ //send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order')); } //检测是否有需要退回积分的订单 } else if( isset($is_open_yinpay) && $is_open_yinpay == 3 ) { $order_relate_info = M('lionfish_comshop_order_relate')->where( array('order_id' => $order_id ) )->order('id desc')->find(); if( !empty($order_relate_info) && $order_relate_info['order_all_id'] > 0 ) { $order_all_info = M('lionfish_comshop_order_all')->where( array('id' => $order_relate_info['order_all_id'] ) )->find(); if( !empty($order_all_info) && !empty($order_all_info['out_trade_no']) ) { $out_trade_no = $order_all_info['out_trade_no']; $appid = D('Home/Front')->get_config_by_name('wepro_fuwu_appid'); $mch_id = D('Home/Front')->get_config_by_name('wepro_fuwu_partnerid'); $nonce_str = nonce_str(); $pay_key = D('Home/Front')->get_config_by_name('wepro_key'); $sub_appid = D('Home/Front')->get_config_by_name('wepro_appid'); $sub_mch_id = D('Home/Front')->get_config_by_name('wepro_sub_mch_id'); $post = array(); $post['appid'] = $appid; $post['mch_id'] = $mch_id; $post['nonce_str'] = $nonce_str; $post['out_trade_no'] = $out_trade_no; $post['sub_appid'] = $sub_appid; $post['sub_mch_id'] = $sub_mch_id; $sign = sign($post,$pay_key); $post_xml = ' '.$appid.' '.$mch_id.' '.$nonce_str.' '.$out_trade_no.' '.$post['sub_appid'].' '.$post['sub_mch_id'].' '.$sign.' '; $url = "https://api.mch.weixin.qq.com/pay/orderquery"; $result = http_request($url,$post_xml); $array = xml($result); if( $array['RETURN_CODE'] == 'SUCCESS' && $array['RETURN_MSG'] == 'OK' ) { if( $array['TRADE_STATE'] == 'SUCCESS' || $array['TRADE_STATE'] == 'REFUND' ) { $total_fee = $array['TOTAL_FEE']; } } } } // $input = new \WxPayRefund(); $input->SetTransaction_id($transaction_id); $input->SetTotal_fee($total_fee); $input->SetRefund_fee($refund_fee); $mchid = D('Home/Front')->get_config_by_name('wepro_partnerid'); $refund_no = $mchid.date("YmdHis").$order_info['order_id']; $input->SetOut_refund_no($refund_no); $input->SetOp_user_id($mchid); $res = \WxPayApi::refund($input,6,'teweixin'); if($res["return_code"] == 'FAIL'){ return array('code' => 0, 'msg' => $res['return_msg']); } if( $res['err_code_des'] == '订单已全额退款' ) { $res['result_code'] = 'SUCCESS'; } if($res['result_code'] == 'SUCCESS') { if($order_info['order_status_id'] == 12) { $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count(); if( $ref_count <= 1 ) { M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); } } $order_info['total'] = $refund_fee / 100; $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id']) )->select(); $order_goods_name_arr = array(); $order_goods_name = ''; foreach($order_goods_list as $order_goods) { $order_goods_name_arr[] = $order_goods['name']; //... if( !empty($order_goods_id) && $order_goods_id > 0 ) { if($order_goods_id == $order_goods['order_goods_id'] ) { if($is_back_sellcount == 1) { if( $is_zi_order_refund == 1 && $refund_quantity > 0 ) { D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2); }else{ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_id' => $order_info['order_id'],'order_goods_id'=>$order_goods['order_goods_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) && $is_zi_order_refund == 1 ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } }else if( empty($order_goods_id) || $order_goods_id <=0 ){ if($is_back_sellcount == 1){ $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_id' => $order_info['order_id'],'order_goods_id' =>$order_goods['order_goods_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } if( $order_info['type'] == 'integral' ) { D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_goods['total'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n"; //分佣也要退回去 if($is_zi_order_refund == 0) D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id); return array('code' => 1); } else { $order_refund_history = array(); $order_refund_history['order_id'] = $order_info['order_id']; $order_refund_history['order_goods_id'] = $order_goods_id; $order_refund_history['message'] = $res['err_code_des']; $order_refund_history['type'] = 2; $order_refund_history['addtime'] = time(); M('lionfish_comshop_order_refund_history')->add($order_refund_history); /** M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 10, 'remarksaler' => $res[err_code_des]) ); **/ return array('code' => 0, 'msg' => $res['err_code_des']); } } else { $order_relate_info = M('lionfish_comshop_order_relate')->where( array('order_id' => $order_id ) )->order('id desc')->find(); if( !empty($order_relate_info) && $order_relate_info['order_all_id'] > 0 ) { $order_all_info = M('lionfish_comshop_order_all')->where( array('id' => $order_relate_info['order_all_id'] ) )->find(); if( !empty($order_all_info) && !empty($order_all_info['out_trade_no']) ) { $out_trade_no = $order_all_info['out_trade_no']; $appid = D('Home/Front')->get_config_by_name('wepro_appid'); $mch_id = D('Home/Front')->get_config_by_name('wepro_partnerid'); $nonce_str = nonce_str(); $pay_key = D('Home/Front')->get_config_by_name('wepro_key'); $post = array(); $post['appid'] = $appid; $post['mch_id'] = $mch_id; $post['nonce_str'] = $nonce_str; $post['out_trade_no'] = $out_trade_no; $sign = sign($post,$pay_key); $post_xml = ' '.$appid.' '.$mch_id.' '.$nonce_str.' '.$out_trade_no.' '.$sign.' '; $url = "https://api.mch.weixin.qq.com/pay/orderquery"; $result = http_request($url,$post_xml); $array = xml($result); if( $array['RETURN_CODE'] == 'SUCCESS' && $array['RETURN_MSG'] == 'OK' ) { if( $array['TRADE_STATE'] == 'SUCCESS' || $array['TRADE_STATE'] == 'REFUND' ) { $total_fee = $array['TOTAL_FEE']; } } } } // $input = new \WxPayRefund(); $input->SetTransaction_id($transaction_id); $input->SetTotal_fee($total_fee); $input->SetRefund_fee($refund_fee); $mchid = D('Home/Front')->get_config_by_name('wepro_partnerid'); $refund_no = $mchid.date("YmdHis").$order_info['order_id']; $input->SetOut_refund_no($refund_no); $input->SetOp_user_id($mchid); $res = \WxPayApi::refund($input,6,$order_info['from_type']); if($res["return_code"] == 'FAIL'){ return array('code' => 0, 'msg' => $res['return_msg']); } if( $res['err_code_des'] == '订单已全额退款' ) { $res['result_code'] = 'SUCCESS'; } if($res['result_code'] == 'SUCCESS') { if($order_info['order_status_id'] == 12) { $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count(); if( $ref_count <= 1 ) { M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); } } $order_info['total'] = $refund_fee / 100; $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id']) )->select(); $order_goods_name_arr = array(); $order_goods_name = ''; foreach($order_goods_list as $order_goods) { $order_goods_name_arr[] = $order_goods['name']; //... if( !empty($order_goods_id) && $order_goods_id > 0 ) { if($order_goods_id == $order_goods['order_goods_id'] ) { if($is_back_sellcount == 1) { if( $is_zi_order_refund == 1 && $refund_quantity > 0 ) { D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2); }else{ //获取已退款数量 $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_id' => $order_info['order_id'],'order_goods_id'=>$order_goods['order_goods_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) && $is_zi_order_refund == 1 ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } }else if( empty($order_goods_id) || $order_goods_id <=0 ){ if($is_back_sellcount == 1){ $has_refund_quantity = M('lionfish_comshop_order_goods_refund')->where( array('order_id' => $order_info['order_id'], 'order_goods_id' =>$order_goods['order_goods_id']) )->sum('quantity'); if(!$has_refund_quantity){ $has_refund_quantity = 0; } D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity']-$has_refund_quantity,2); } $score_refund_info = M('lionfish_comshop_member_integral_flow')->where( array('order_id' => $order_info['order_id'],'order_goods_id' =>$order_goods['order_goods_id'] ,'type' => 'orderbuy') )->find(); if( !empty($score_refund_info) ) { // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } if( $order_info['type'] == 'integral' ) { D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_goods['total'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] ); } } $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n"; //分佣也要退回去 if($is_zi_order_refund == 0) D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id); return array('code' => 1); } else { $order_refund_history = array(); $order_refund_history['order_id'] = $order_info['order_id']; $order_refund_history['order_goods_id'] = $order_goods_id; $order_refund_history['message'] = $res['err_code_des']; $order_refund_history['type'] = 2; $order_refund_history['addtime'] = time(); M('lionfish_comshop_order_refund_history')->add($order_refund_history); /** M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 10, 'remarksaler' => $res[err_code_des]) ); **/ return array('code' => 0, 'msg' => $res['err_code_des']); } } } public function refundOrder2($order_id,$money =0) { $lib_path = dirname(dirname( dirname(__FILE__) )).'/Lib/'; $data_path = dirname( dirname(dirname( dirname(__FILE__) )) ).'/Data/wxpaylogs/'.date('Y-m-d')."/"; RecursiveMkdir($data_path); set_time_limit(0); require_once $lib_path."/Weixin/lib/WxPay.Api.php"; require_once $lib_path."/Weixin/log.php"; //初始化日志 $logHandler= new \CLogFileHandler( $data_path .date('Y-m-d').'.log'); \Log::Init($logHandler, 15); \Log::DEBUG("进行中,订单ID :".$order_id ); //pin $order_info = M('order')->where( array('order_id' => $order_id) )->find(); $member_info = M('member')->where( array('member_id' => $order_info['member_id']) )->find(); $openId = $member_info['openid']; $we_openid = $member_info['we_openid']; if( $order_info['from_type'] == 'wepro' ) { $openId = $we_openid; } //we_openid //money $transaction_id = $order_info["transaction_id"]; $total_fee = ($order_info["total"])*100; $refund_fee = $total_fee; if($money > 0) { $refund_fee = $money * 100; } if($order_info['payment_code'] == 'yuer') { //余额支付的,退款到余额 //退款到余额 $member_charge_flow_data = array(); $member_charge_flow_data['member_id'] = $order_info['member_id']; $member_charge_flow_data['money'] = $order_info["total"]; $member_charge_flow_data['state'] = 4; $member_charge_flow_data['trans_id'] = $order_id; $member_charge_flow_data['charge_time'] = time(); $member_charge_flow_data['add_time'] = time(); M('member_charge_flow')->add($member_charge_flow_data); //增加会员余额 M('member')->where( array('member_id'=> $order_info['member_id'] ) )->setInc('account_money',$order_info["total"] ); $order_info['total'] = $refund_fee / 100; $this->refundOrder_success($order_info,$openId); //检测是否有需要退回积分的订单 } else if($refund_fee == 0) { M('order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); $config_info = M('config')->where( array('name' => 'SITE_URL') )->find(); $order_goods = M('order_goods')->where( array('order_id' => $order_info['order_id']) )->select(); $order_goods_name = ''; $order_goods_name_arr = array(); foreach ($order_goods as $key => $value) { $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity'],2); //销量回退 //$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET seller_count = (seller_count - " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' "); $order_goods_name_arr[] = $value['name']; } $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n"; $msg = '订单退款: 您的订单'.$order_info['order_num_alias'].'参团未成功,现退款:'.round($order_info["total"],2).'元,商品名称:'.$order_goods_name; $url = $config_info['value']; //weixin_template_refund_order //send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order')); $url = $url."/index.php?s=/Order/info/id/{$order_info['order_id']}.html"; /** {{first.DATA}} 订单编号:{{keyword1.DATA}} 退款金额:{{keyword2.DATA}} {{remark.DATA}} --------------------------- 校白君提醒您,您有一笔退款成功,请留意。 订单编号:20088115853 退款金额:¥19.00 更多学生价好货,在底部菜单栏哦~猛戳“校园专区”,享更多优惠! **/ $wx_template_data = array(); $wx_template_data['first'] = array('value' => '退款通知', 'color' => '#030303'); $wx_template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303'); $wx_template_data['keyword2'] = array('value' => round($order_info["total"],2), 'color' => '#030303'); $wx_template_data['remark'] = array('value' => '拼团失败已按原路退款', 'color' => '#030303'); if( $order_info['from_type'] == 'wepro' ) { $template_data = array(); $template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303'); $template_data['keyword2'] = array('value' => '参团未成功', 'color' => '#030303'); $template_data['keyword3'] = array('value' => '拼团失败已按原路退款', 'color' => '#030303'); $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_fail_pin') )->find(); $template_id = $pay_order_msg_info['value']; $pagepath = 'pages/order/order?id='.$order_info['order_id']; /** $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'], 'state' => 0) )->find(); send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid']); //更新 M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) ); $order_info['member_id'] **/ $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'], 'formid' =>array('neq',''), 'state' => 0) )->order('id desc')->find(); if(!empty( $member_formid_info )) { send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid'] ); M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) ); } if( $openid != '1') { //notify_weixin_msg($member_info['openid'],$msg,'退款通知',$url); send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order')); } }else{ //notify_weixin_msg($member_info['openid'],$msg,'退款通知',$url); send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order')); } //检测是否有需要退回积分的订单 \Log::DEBUG("退款成功。。。退款日志:退款订单号:" . $order_info['order_id'].',ten:'.$transaction_id.' 退款金额: ' .$order_info["total"].',退款给:openid='.$openId); } else { $input = new \WxPayRefund(); $input->SetTransaction_id($transaction_id); $input->SetTotal_fee($total_fee); $input->SetRefund_fee($refund_fee); $refund_no = \WxPayConfig::MCHID.date("YmdHis").$order_info['order_id']; $input->SetOut_refund_no($refund_no); $input->SetOp_user_id(\WxPayConfig::MCHID); $res = (\WxPayApi::refund($input,6,$order_info['from_type'])); //var_dump($res);die(); wx80131aa7dfc4ff71 if($res['result_code'] == 'SUCCESS') { $order_info['total'] = $refund_fee / 100; $this->refundOrder_success($order_info,$openId); \Log::DEBUG("退款成功。。。退款日志:退款订单号:" . $order_info['order_id'].',ten:'.$transaction_id.' 退款金额: '.$order_info["total"].',退款给:openid='.$openid); //检测是否有需要退回积分的订单 } else { M('order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 10, 'comment' => $res[err_code_des]) ); \Log::DEBUG("退款失败。原因:{$res[err_code_des]}。。退款日志:退款订单号:" . $order_info['order_id'].',退款金额: '.$order_info["total"].',退款给:openid='.$openId); } } return true; } /** 取消已经付款的 待发货订单 5、处理订单, 6、处理退款, **/ public function del_cancle_order($order_id) { $order_info = M('lionfish_comshop_order')->where( array('order_id' => $order_id ) )->find(); //判断订单状态是否已付款,避免多次退款,不合理 if( $order_info['order_status_id'] == 1 ) { //del_cancle_order $total_money = D('Seller/Commonorder')->get_order_paymoney( $order_id ); $has_refun_money = D('Seller/Commonorder')->order_refund_totalmoney( $order_id ); //是否预售订单begin $presale_result = D('Home/PresaleGoods')->getOrderPresaleInfo( $order_id ); $presale_info = []; if( $presale_result['code'] == 0 ) { $presale_info = $presale_result['data']; $total_money = $total_money - $presale_info['presale_ding_money']; } //end $refund_money = round($total_money - $has_refun_money,2); $result = $this->refundOrder($order_id, $refund_money); if( $result['code'] == 1 ) { $order_history = array(); $order_history['order_id'] = $order_id; $order_history['order_status_id'] = 5; $order_history['notify'] = 0; $order_history['comment'] = '会员前台申请取消订单,取消成功,并退款。'; $order_history['date_added'] = time(); M('lionfish_comshop_order_history')->add( $order_history ); M('lionfish_comshop_order')->where( array('order_id' => $order_id) )->save( array('order_status_id' => 5) ); //整笔 D('Seller/Commonorder')->refund_one_order( $order_id ,1); return array('code' => 0); }else{ $order_history = array(); $order_history['order_id'] = $order_id; $order_history['order_status_id'] = 10; $order_history['notify'] = 0; $order_history['comment'] = '申请取消订单,但是退款失败。'; $order_history['date_added'] = time(); M('lionfish_comshop_order_history')->add( $order_history ); M('lionfish_comshop_order')->where( array('order_id' => $order_id ) )->save( array('order_status_id' => 10, 'remarksaler' => $result['msg']) ); return array('code' => 1, 'msg' => $result['msg'] ,'s' => $result['code'] ); } } //如果退款成功了。那么就进行 } public function test_form_msg() { $member_info = M('member')->where( array('member_id' => 26) )->find(); $form_id_arr = M('member_formid')->where( array('member_id' => 26,'state' =>0) )->find(); M('member_formid')->where( array('id' => $form_id_arr['id'] ) )->save( array('state' =>1) ); $form_id = $form_id_arr['formid']; $template_data = array(); $template_data['keyword1'] = array('value' => '338866', 'color' => '#030303'); $template_data['keyword2'] = array('value' => '商品名称', 'color' => '#030303'); $template_data['keyword3'] = array('value' => '18元', 'color' => '#030303'); $template_data['keyword4'] = array('value' => '已按原路退款', 'color' => '#030303'); $template_data['keyword5'] = array('value' => '小鱼', 'color' => '#030303'); $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_refund_order') )->find(); $template_id = $pay_order_msg_info['value']; $pagepath = 'pages/order/order?id='.$order_info['order_id']; $rs = send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$form_id); var_dump($rs);die(); } public function refundOrder_success($order_info,$openid) { M('order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) ); $member_info = M('member')->where( array('member_id' => $order_info['member_id']) )->find(); $config_info = M('config')->where( array('name' => 'SITE_URL') )->find(); $order_goods = M('order_goods')->where( array('order_id' => $order_info['order_id']) )->select(); $goods_model = D('Home/Goods'); $order_goods_name = ''; $order_goods_name_arr = array(); foreach ($order_goods as $key => $value) { //$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET quantity = (quantity + " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' "); $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity'],2); //销量回退 //$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET seller_count = (seller_count - " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' "); $order_goods_name_arr[] = $value['name']; } $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n"; $msg = '订单退款: 您的订单'.$order_info['order_num_alias'].'参团未成功,现退款:'.round($order_info["total"],2).'元,商品名称:'.$order_goods_name; $url = $config_info['value']; $wx_template_data = array(); $wx_template_data['first'] = array('value' => '退款通知', 'color' => '#030303'); $wx_template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303'); $wx_template_data['keyword2'] = array('value' => $order_info['total'].'元', 'color' => '#030303'); $wx_template_data['remark'] = array('value' => '已按原路退款', 'color' => '#030303'); $url = $url."/index.php?s=/Order/info/id/{$order_info['order_id']}.html"; if( $order_info['from_type'] == 'wepro' ) { /** 退款成功通知 关键词 订单号 {{keyword1.DATA}} 商品名称 {{keyword2.DATA}} 退款金额 {{keyword3.DATA}} 温馨提示 {{keyword4.DATA}} 备注 {{keyword5.DATA}} **/ //$total_money = ($order_info["total"],2); $template_data = array(); $template_data['keyword1'] = array('value' => $order_info['order_num_alias'], 'color' => '#030303'); $template_data['keyword2'] = array('value' => $order_goods_name, 'color' => '#030303'); $template_data['keyword3'] = array('value' => $order_info['total'].'元', 'color' => '#030303'); $template_data['keyword4'] = array('value' => '已按原路退款', 'color' => '#030303'); $template_data['keyword5'] = array('value' => $member_info['uname'], 'color' => '#030303'); $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_refund_order') )->find(); $template_id = $pay_order_msg_info['value']; $pagepath = 'pages/order/order?id='.$order_info['order_id']; /** $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'], 'state' => 0) )->find(); send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid']); //更新 M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) ); **/ $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'],'formid' =>array('neq',''), 'state' => 0) )->order('id desc')->find(); //$order_info['member_id'] if( !empty($member_formid_info) ) { $rs = send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid']); M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) ); } if( $openid != '1') { //notify_weixin_msg($openid,$msg,'退款通知',$url); send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order')); } }else{ //notify_weixin_msg($openid,$msg,'退款通知',$url); send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order')); } } } ?>