WeixinModel.class.php 52 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290
  1. <?php
  2. /**
  3. * lionfish 商城系统
  4. *
  5. * ==========================================================================
  6. * @link http://www.liofis.com/
  7. * @copyright Copyright (c) 2015 liofis.com.
  8. * @license http://www.liofis.com/license.html License
  9. * ==========================================================================
  10. *
  11. * @author fish
  12. *
  13. */
  14. namespace Home\Model;
  15. class WeixinModel{
  16. public function refundOrder($order_id, $money=0, $uniacid=0,$order_goods_id=0,$is_back_sellcount = 1,$refund_quantity = 0,$is_zi_order_refund =0)
  17. {
  18. $_GPC = I('request.');
  19. $lib_path = dirname(dirname( dirname(__FILE__) )).'/Lib/';
  20. set_time_limit(0);
  21. require_once $lib_path."/Weixin/lib/WxPay.Api.php";
  22. $order_info = M('lionfish_comshop_order')->where( array('order_id' => $order_id) )->find();
  23. $member_info = M('lionfish_comshop_member')->where( array('member_id' => $order_info['member_id'] ) )->find();
  24. $openId = $member_info['openid'];
  25. $we_openid = $member_info['we_openid'];
  26. if( $order_info['from_type'] == 'wepro' )
  27. {
  28. $openId = $we_openid;
  29. }
  30. //we_openid
  31. //money
  32. $transaction_id = $order_info["transaction_id"];
  33. if( $order_info['type'] == 'integral' )
  34. {
  35. $total_fee = ( $order_info["shipping_fare"] )*100;
  36. }else{
  37. $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;
  38. }
  39. //预售begin
  40. $presale_result = D('Home/PresaleGoods')->getOrderPresaleInfo( $order_id );
  41. if( $presale_result['code'] ==0 )
  42. {
  43. $total_fee = $total_fee - $presale_result['data']['presale_ding_money'] * 100;
  44. }
  45. //end
  46. $refund_fee = $total_fee;
  47. //order_goods_id
  48. if( !empty($order_goods_id) )
  49. {
  50. $order_goods_info = M('lionfish_comshop_order_goods')->where( array('order_goods_id' =>$order_goods_id ) )->find();
  51. $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;
  52. if( $order_info['type'] == 'integral' )
  53. {
  54. $refund_fee = ( $order_goods_info["shipping_fare"] )*100;
  55. }
  56. }
  57. if($money > 0 && $order_info['type'] != 'integral' )
  58. {
  59. $refund_fee = $money * 100;
  60. }else if( $money > 0 && $order_info['type'] == 'integral' && !empty($order_goods_info) )
  61. {
  62. if(!empty($_GPC['refund_money'])){
  63. $refund_money = isset($_GPC['refund_money']) && $_GPC['refund_money'] >0 ? floatval($_GPC['refund_money']) : 0;
  64. //商品多个运费和
  65. $refund_fee = ( $money - $refund_money )*100;
  66. //商品多个商品单价和
  67. $order_info['total'] = $refund_money;
  68. }else{
  69. $order_refund_history_image = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_id) )->order('addtime asc')->find();
  70. $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();
  71. $refund_fee = ( $ref_shipping_fare['ref_shipping_fare'] )*100;
  72. $order_info['total'] = $money ;
  73. }
  74. }
  75. // else if( isset($is_open_yinpay) && $is_open_yinpay == 3 )
  76. $is_open_yinpay = D('Home/Front')->get_config_by_name('is_open_yinpay');
  77. if($order_info['payment_code'] == 'yuer')
  78. {
  79. //余额支付的,退款到余额
  80. //退款到余额
  81. //增加会员余额
  82. $refund_fee = $refund_fee / 100;
  83. if( $refund_fee > 0 )
  84. {
  85. //判断是否积分类型的
  86. M('lionfish_comshop_member')->where( array('member_id' => $order_info['member_id']) )->setInc('account_money',$refund_fee);
  87. $account_money_info = M('lionfish_comshop_member')->field('account_money')->where( array('member_id' =>$order_info['member_id'] ) )->find();
  88. $account_money = $account_money_info['account_money'];
  89. $member_charge_flow_data = array();
  90. $member_charge_flow_data['member_id'] = $order_info['member_id'];
  91. $member_charge_flow_data['money'] = $refund_fee;
  92. $member_charge_flow_data['operate_end_yuer'] = $account_money;
  93. $member_charge_flow_data['state'] = 4;
  94. $member_charge_flow_data['trans_id'] = $order_id;
  95. $member_charge_flow_data['order_goods_id'] = $order_goods_id;
  96. $member_charge_flow_data['charge_time'] = time();
  97. $member_charge_flow_data['add_time'] = time();
  98. M('lionfish_comshop_member_charge_flow')->add($member_charge_flow_data);
  99. }
  100. if($order_info['order_status_id'] == 12)
  101. {
  102. $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count();
  103. if( $ref_count <= 1 )
  104. {
  105. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  106. }
  107. }
  108. $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id'] ) )->select();
  109. $goods_model = D('Home/Pingoods');
  110. foreach($order_goods_list as $order_goods)
  111. {
  112. //$goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity'],2);
  113. if( !empty($order_goods_id) && $order_goods_id > 0 )
  114. {
  115. if($order_goods_id == $order_goods['order_goods_id'] )
  116. {
  117. if($is_back_sellcount == 1)
  118. {
  119. if( $is_zi_order_refund == 1 && $refund_quantity > 0 )
  120. {
  121. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2);
  122. }else{
  123. //获取已退款数量
  124. $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');
  125. if(!$has_refund_quantity){
  126. $has_refund_quantity = 0;
  127. }
  128. $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);
  129. }
  130. }
  131. $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();
  132. if( !empty($score_refund_info) && $is_zi_order_refund == 1 )
  133. {
  134. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  135. }
  136. }
  137. }else if( empty($order_goods_id) || $order_goods_id <=0 ){
  138. if($is_back_sellcount == 1){
  139. //获取已退款数量
  140. $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');
  141. if(!$has_refund_quantity){
  142. $has_refund_quantity = 0;
  143. }
  144. $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);
  145. }
  146. $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();
  147. if( !empty($score_refund_info) )
  148. {
  149. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  150. }
  151. }
  152. if( $order_info['type'] == 'integral' )
  153. {
  154. D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_info['total'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  155. }
  156. }
  157. //分佣也要退回去
  158. if($is_zi_order_refund == 0)
  159. D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id);
  160. return array('code' => 1);
  161. //$this->refundOrder_success($order_info,$openId);
  162. //检测是否有需要退回积分的订单
  163. //货到付款订单
  164. }else if($order_info['payment_code'] == 'cashon_delivery')
  165. {
  166. //货到付款订单退款金额不到账,但有退款记录
  167. if($order_info['order_status_id'] == 12)
  168. {
  169. $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count();
  170. if( $ref_count <= 1 )
  171. {
  172. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  173. }
  174. }
  175. $order_info['total'] = $refund_fee / 100;
  176. $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id'] ) )->select();
  177. $goods_model = D('Home/Pingoods');
  178. foreach($order_goods_list as $order_goods)
  179. {
  180. //$goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity'],2);
  181. if( !empty($order_goods_id) && $order_goods_id > 0 )
  182. {
  183. if($order_goods_id == $order_goods['order_goods_id'] )
  184. {
  185. if($is_back_sellcount == 1)
  186. {
  187. if( $is_zi_order_refund == 1 && $refund_quantity > 0 )
  188. {
  189. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2);
  190. }else{
  191. //获取已退款数量
  192. $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');
  193. if(!$has_refund_quantity){
  194. $has_refund_quantity = 0;
  195. }
  196. $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);
  197. }
  198. }
  199. $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();
  200. if( !empty($score_refund_info) && $is_zi_order_refund == 1 )
  201. {
  202. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  203. }
  204. }
  205. }else if( empty($order_goods_id) || $order_goods_id <=0 ){
  206. if($is_back_sellcount == 1){
  207. //获取已退款数量
  208. $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');
  209. if(!$has_refund_quantity){
  210. $has_refund_quantity = 0;
  211. }
  212. $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);
  213. }
  214. $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();
  215. if( !empty($score_refund_info) )
  216. {
  217. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  218. }
  219. }
  220. /*if( $order_info['type'] == 'integral' )
  221. {
  222. D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_info['total'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  223. }*/
  224. }
  225. //分佣也要退回去
  226. if($is_zi_order_refund == 0)
  227. D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id);
  228. return array('code' => 1);
  229. //$this->refundOrder_success($order_info,$openId);
  230. //检测是否有需要退回积分的订单
  231. }
  232. else if($order_info['payment_code'] == 'admin'){
  233. if($order_info['order_status_id'] == 12)
  234. {
  235. $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count();
  236. if( $ref_count <= 1 )
  237. {
  238. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  239. }
  240. }
  241. $order_info['total'] = $refund_fee / 100;
  242. $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id'] ) )->select();
  243. $goods_model = D('Home/Pingoods');
  244. foreach($order_goods_list as $order_goods)
  245. {
  246. //$goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$order_goods['quantity'],2);
  247. if( !empty($order_goods_id) && $order_goods_id > 0 )
  248. {
  249. if($order_goods_id == $order_goods['order_goods_id'] )
  250. {
  251. if($is_back_sellcount == 1)
  252. {
  253. if( $is_zi_order_refund == 1 && $refund_quantity > 0 )
  254. {
  255. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2);
  256. }else{
  257. //获取已退款数量
  258. $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');
  259. if(!$has_refund_quantity){
  260. $has_refund_quantity = 0;
  261. }
  262. $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);
  263. }
  264. }
  265. $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();
  266. if( !empty($score_refund_info) && $is_zi_order_refund == 1 )
  267. {
  268. //D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  269. }
  270. }
  271. }else if( empty($order_goods_id) || $order_goods_id <=0 ){
  272. if($is_back_sellcount == 1){
  273. //获取已退款数量
  274. $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');
  275. if(!$has_refund_quantity){
  276. $has_refund_quantity = 0;
  277. }
  278. $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);
  279. }
  280. $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();
  281. if( !empty($score_refund_info) )
  282. {
  283. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  284. }
  285. }
  286. if( $order_info['type'] == 'integral' )
  287. {
  288. //D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_goods['total'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  289. }
  290. }
  291. //分佣也要退回去
  292. if($is_zi_order_refund == 0)
  293. D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id);
  294. return array('code' => 1);
  295. }
  296. else if($refund_fee == 0)
  297. {
  298. if($order_info['order_status_id'] == 12)
  299. {
  300. $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count();
  301. if( $ref_count <= 1 )
  302. {
  303. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  304. }
  305. }
  306. //ims_ lionfish_comshop_order_goods
  307. $order_goods = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id']) )->select();
  308. $order_goods_name = '';
  309. $order_goods_name_arr = array();
  310. $goods_model = D('Home/Pingoods');
  311. //get_config_by_name($name)
  312. foreach ($order_goods as $key => $value) {
  313. //($order_id,$option,$goods_id,$quantity,$type='1')
  314. if($is_back_sellcount == 1)
  315. {
  316. if( $is_zi_order_refund == 1 && $refund_quantity > 0 )
  317. {
  318. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$refund_quantity,2);
  319. }else{
  320. //获取已退款数量
  321. $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');
  322. if(!$has_refund_quantity){
  323. $has_refund_quantity = 0;
  324. }
  325. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity']-$has_refund_quantity,2);
  326. }
  327. }
  328. $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();
  329. if( !empty($score_refund_info) )
  330. {
  331. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$value['order_goods_id'] );
  332. }
  333. //销量回退
  334. $order_goods_name_arr[] = $value['name'];
  335. }
  336. $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n";
  337. $msg = '订单退款: 您的订单'.$order_info['order_num_alias'].'参团未成功,现退款:'.round($order_info["total"],2).'元,商品名称:'.$order_goods_name;
  338. $url = D('Home/Front')->get_config_by_name('shop_domain');
  339. //weixin_template_refund_order
  340. //send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order'));
  341. /**
  342. {{first.DATA}}
  343. 订单编号:{{keyword1.DATA}}
  344. 退款金额:{{keyword2.DATA}}
  345. {{remark.DATA}}
  346. ---------------------------
  347. 校白君提醒您,您有一笔退款成功,请留意。
  348. 订单编号:20088115853
  349. 退款金额:¥19.00
  350. 更多学生价好货,在底部菜单栏哦~猛戳“校园专区”,享更多优惠!
  351. **/
  352. $wx_template_data = array();
  353. $wx_template_data['first'] = array('value' => '退款通知', 'color' => '#030303');
  354. $wx_template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303');
  355. $wx_template_data['keyword2'] = array('value' => round($order_info["total"],2), 'color' => '#030303');
  356. $wx_template_data['remark'] = array('value' => '拼团失败已按原路退款', 'color' => '#030303');
  357. if( $order_info['from_type'] == 'wepro' )
  358. {
  359. $template_data = array();
  360. $template_data['keyword1'] = array('value' => $order_info['order_num_alias'], 'color' => '#030303');
  361. $template_data['keyword2'] = array('value' => '商户名称', 'color' => '#030303');
  362. $template_data['keyword2'] = array('value' => $order_goods_name, 'color' => '#030303');
  363. $template_data['keyword3'] = array('value' => $order_info['total'].'元', 'color' => '#030303');
  364. $template_data['keyword4'] = array('value' => '已按原路退款', 'color' => '#030303');
  365. $template_data['keyword5'] = array('value' => $member_info['uname'], 'color' => '#030303');
  366. $template_id = D('Home/Front')->get_config_by_name('weprogram_template_refund_order');
  367. $pagepath = 'lionfish_comshop/pages/order/order?id='.$order_info['order_id'];
  368. $member_formid_info = M('lionfish_comshop_member_formid')->where("member_id=".$order_info['member_id']." and formid != '' and state =0")->order('id desc')->find();
  369. if(!empty( $member_formid_info ))
  370. {
  371. D('Seller/User')->send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid'] );
  372. M('lionfish_comshop_member_formid')->where( array('id' => $member_formid_info['id']) )->save(array('state' => 1));
  373. }
  374. if( $openid != '1')
  375. {
  376. //send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order'));
  377. }
  378. }else{
  379. //send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order'));
  380. }
  381. //检测是否有需要退回积分的订单
  382. }
  383. else if( isset($is_open_yinpay) && $is_open_yinpay == 3 )
  384. {
  385. $order_relate_info = M('lionfish_comshop_order_relate')->where( array('order_id' => $order_id ) )->order('id desc')->find();
  386. if( !empty($order_relate_info) && $order_relate_info['order_all_id'] > 0 )
  387. {
  388. $order_all_info = M('lionfish_comshop_order_all')->where( array('id' => $order_relate_info['order_all_id'] ) )->find();
  389. if( !empty($order_all_info) && !empty($order_all_info['out_trade_no']) )
  390. {
  391. $out_trade_no = $order_all_info['out_trade_no'];
  392. $appid = D('Home/Front')->get_config_by_name('wepro_fuwu_appid');
  393. $mch_id = D('Home/Front')->get_config_by_name('wepro_fuwu_partnerid');
  394. $nonce_str = nonce_str();
  395. $pay_key = D('Home/Front')->get_config_by_name('wepro_key');
  396. $sub_appid = D('Home/Front')->get_config_by_name('wepro_appid');
  397. $sub_mch_id = D('Home/Front')->get_config_by_name('wepro_sub_mch_id');
  398. $post = array();
  399. $post['appid'] = $appid;
  400. $post['mch_id'] = $mch_id;
  401. $post['nonce_str'] = $nonce_str;
  402. $post['out_trade_no'] = $out_trade_no;
  403. $post['sub_appid'] = $sub_appid;
  404. $post['sub_mch_id'] = $sub_mch_id;
  405. $sign = sign($post,$pay_key);
  406. $post_xml = '<xml>
  407. <appid>'.$appid.'</appid>
  408. <mch_id>'.$mch_id.'</mch_id>
  409. <nonce_str>'.$nonce_str.'</nonce_str>
  410. <out_trade_no>'.$out_trade_no.'</out_trade_no>
  411. <sub_appid>'.$post['sub_appid'].'</sub_appid>
  412. <sub_mch_id>'.$post['sub_mch_id'].'</sub_mch_id>
  413. <sign>'.$sign.'</sign>
  414. </xml>';
  415. $url = "https://api.mch.weixin.qq.com/pay/orderquery";
  416. $result = http_request($url,$post_xml);
  417. $array = xml($result);
  418. if( $array['RETURN_CODE'] == 'SUCCESS' && $array['RETURN_MSG'] == 'OK' )
  419. {
  420. if( $array['TRADE_STATE'] == 'SUCCESS' || $array['TRADE_STATE'] == 'REFUND' )
  421. {
  422. $total_fee = $array['TOTAL_FEE'];
  423. }
  424. }
  425. }
  426. }
  427. //
  428. $input = new \WxPayRefund();
  429. $input->SetTransaction_id($transaction_id);
  430. $input->SetTotal_fee($total_fee);
  431. $input->SetRefund_fee($refund_fee);
  432. $mchid = D('Home/Front')->get_config_by_name('wepro_partnerid');
  433. $refund_no = $mchid.date("YmdHis").$order_info['order_id'];
  434. $input->SetOut_refund_no($refund_no);
  435. $input->SetOp_user_id($mchid);
  436. $res = \WxPayApi::refund($input,6,'teweixin');
  437. if($res["return_code"] == 'FAIL'){
  438. return array('code' => 0, 'msg' => $res['return_msg']);
  439. }
  440. if( $res['err_code_des'] == '订单已全额退款' )
  441. {
  442. $res['result_code'] = 'SUCCESS';
  443. }
  444. if($res['result_code'] == 'SUCCESS')
  445. {
  446. if($order_info['order_status_id'] == 12)
  447. {
  448. $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count();
  449. if( $ref_count <= 1 )
  450. {
  451. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  452. }
  453. }
  454. $order_info['total'] = $refund_fee / 100;
  455. $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id']) )->select();
  456. $order_goods_name_arr = array();
  457. $order_goods_name = '';
  458. foreach($order_goods_list as $order_goods)
  459. {
  460. $order_goods_name_arr[] = $order_goods['name'];
  461. //...
  462. if( !empty($order_goods_id) && $order_goods_id > 0 )
  463. {
  464. if($order_goods_id == $order_goods['order_goods_id'] )
  465. {
  466. if($is_back_sellcount == 1)
  467. {
  468. if( $is_zi_order_refund == 1 && $refund_quantity > 0 )
  469. {
  470. D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2);
  471. }else{
  472. //获取已退款数量
  473. $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');
  474. if(!$has_refund_quantity){
  475. $has_refund_quantity = 0;
  476. }
  477. 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);
  478. }
  479. }
  480. $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();
  481. if( !empty($score_refund_info) && $is_zi_order_refund == 1 )
  482. {
  483. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  484. }
  485. }
  486. }else if( empty($order_goods_id) || $order_goods_id <=0 ){
  487. if($is_back_sellcount == 1){
  488. $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');
  489. if(!$has_refund_quantity){
  490. $has_refund_quantity = 0;
  491. }
  492. 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);
  493. }
  494. $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();
  495. if( !empty($score_refund_info) )
  496. {
  497. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  498. }
  499. }
  500. if( $order_info['type'] == 'integral' )
  501. {
  502. D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_goods['total'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  503. }
  504. }
  505. $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n";
  506. //分佣也要退回去
  507. if($is_zi_order_refund == 0)
  508. D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id);
  509. return array('code' => 1);
  510. } else {
  511. $order_refund_history = array();
  512. $order_refund_history['order_id'] = $order_info['order_id'];
  513. $order_refund_history['order_goods_id'] = $order_goods_id;
  514. $order_refund_history['message'] = $res['err_code_des'];
  515. $order_refund_history['type'] = 2;
  516. $order_refund_history['addtime'] = time();
  517. M('lionfish_comshop_order_refund_history')->add($order_refund_history);
  518. /**
  519. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 10, 'remarksaler' => $res[err_code_des]) );
  520. **/
  521. return array('code' => 0, 'msg' => $res['err_code_des']);
  522. }
  523. }
  524. else {
  525. $order_relate_info = M('lionfish_comshop_order_relate')->where( array('order_id' => $order_id ) )->order('id desc')->find();
  526. if( !empty($order_relate_info) && $order_relate_info['order_all_id'] > 0 )
  527. {
  528. $order_all_info = M('lionfish_comshop_order_all')->where( array('id' => $order_relate_info['order_all_id'] ) )->find();
  529. if( !empty($order_all_info) && !empty($order_all_info['out_trade_no']) )
  530. {
  531. $out_trade_no = $order_all_info['out_trade_no'];
  532. $appid = D('Home/Front')->get_config_by_name('wepro_appid');
  533. $mch_id = D('Home/Front')->get_config_by_name('wepro_partnerid');
  534. $nonce_str = nonce_str();
  535. $pay_key = D('Home/Front')->get_config_by_name('wepro_key');
  536. $post = array();
  537. $post['appid'] = $appid;
  538. $post['mch_id'] = $mch_id;
  539. $post['nonce_str'] = $nonce_str;
  540. $post['out_trade_no'] = $out_trade_no;
  541. $sign = sign($post,$pay_key);
  542. $post_xml = '<xml>
  543. <appid>'.$appid.'</appid>
  544. <mch_id>'.$mch_id.'</mch_id>
  545. <nonce_str>'.$nonce_str.'</nonce_str>
  546. <out_trade_no>'.$out_trade_no.'</out_trade_no>
  547. <sign>'.$sign.'</sign>
  548. </xml>';
  549. $url = "https://api.mch.weixin.qq.com/pay/orderquery";
  550. $result = http_request($url,$post_xml);
  551. $array = xml($result);
  552. if( $array['RETURN_CODE'] == 'SUCCESS' && $array['RETURN_MSG'] == 'OK' )
  553. {
  554. if( $array['TRADE_STATE'] == 'SUCCESS' || $array['TRADE_STATE'] == 'REFUND' )
  555. {
  556. $total_fee = $array['TOTAL_FEE'];
  557. }
  558. }
  559. }
  560. }
  561. //
  562. $input = new \WxPayRefund();
  563. $input->SetTransaction_id($transaction_id);
  564. $input->SetTotal_fee($total_fee);
  565. $input->SetRefund_fee($refund_fee);
  566. $mchid = D('Home/Front')->get_config_by_name('wepro_partnerid');
  567. $refund_no = $mchid.date("YmdHis").$order_info['order_id'];
  568. $input->SetOut_refund_no($refund_no);
  569. $input->SetOp_user_id($mchid);
  570. $res = \WxPayApi::refund($input,6,$order_info['from_type']);
  571. if($res["return_code"] == 'FAIL'){
  572. return array('code' => 0, 'msg' => $res['return_msg']);
  573. }
  574. if( $res['err_code_des'] == '订单已全额退款' )
  575. {
  576. $res['result_code'] = 'SUCCESS';
  577. }
  578. if($res['result_code'] == 'SUCCESS')
  579. {
  580. if($order_info['order_status_id'] == 12)
  581. {
  582. $ref_count = M('lionfish_comshop_order_refund')->where( array('order_id' => $order_info['order_id'], 'state' => 0 ) )->count();
  583. if( $ref_count <= 1 )
  584. {
  585. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  586. }
  587. }
  588. $order_info['total'] = $refund_fee / 100;
  589. $order_goods_list = M('lionfish_comshop_order_goods')->where( array('order_id' => $order_info['order_id']) )->select();
  590. $order_goods_name_arr = array();
  591. $order_goods_name = '';
  592. foreach($order_goods_list as $order_goods)
  593. {
  594. $order_goods_name_arr[] = $order_goods['name'];
  595. //...
  596. if( !empty($order_goods_id) && $order_goods_id > 0 )
  597. {
  598. if($order_goods_id == $order_goods['order_goods_id'] )
  599. {
  600. if($is_back_sellcount == 1)
  601. {
  602. if( $is_zi_order_refund == 1 && $refund_quantity > 0 )
  603. {
  604. D('Home/Pingoods')->del_goods_mult_option_quantity($order_info['order_id'],$order_goods['rela_goodsoption_valueid'],$order_goods['goods_id'],$refund_quantity,2);
  605. }else{
  606. //获取已退款数量
  607. $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');
  608. if(!$has_refund_quantity){
  609. $has_refund_quantity = 0;
  610. }
  611. 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);
  612. }
  613. }
  614. $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();
  615. if( !empty($score_refund_info) && $is_zi_order_refund == 1 )
  616. {
  617. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  618. }
  619. }
  620. }else if( empty($order_goods_id) || $order_goods_id <=0 ){
  621. if($is_back_sellcount == 1){
  622. $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');
  623. if(!$has_refund_quantity){
  624. $has_refund_quantity = 0;
  625. }
  626. 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);
  627. }
  628. $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();
  629. if( !empty($score_refund_info) )
  630. {
  631. // D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$score_refund_info['score'], 0 ,'退款增加积分', 'refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  632. }
  633. }
  634. if( $order_info['type'] == 'integral' )
  635. {
  636. D('Admin/Member')->sendMemberPointChange($order_info['member_id'],$order_goods['total'], 0 ,'退款增加积分','refundorder', $order_info['order_id'] ,$order_goods['order_goods_id'] );
  637. }
  638. }
  639. $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n";
  640. //分佣也要退回去
  641. if($is_zi_order_refund == 0)
  642. D('Seller/Community')->back_order_commission($order_info['order_id'],$order_goods_id);
  643. return array('code' => 1);
  644. } else {
  645. $order_refund_history = array();
  646. $order_refund_history['order_id'] = $order_info['order_id'];
  647. $order_refund_history['order_goods_id'] = $order_goods_id;
  648. $order_refund_history['message'] = $res['err_code_des'];
  649. $order_refund_history['type'] = 2;
  650. $order_refund_history['addtime'] = time();
  651. M('lionfish_comshop_order_refund_history')->add($order_refund_history);
  652. /**
  653. M('lionfish_comshop_order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 10, 'remarksaler' => $res[err_code_des]) );
  654. **/
  655. return array('code' => 0, 'msg' => $res['err_code_des']);
  656. }
  657. }
  658. }
  659. public function refundOrder2($order_id,$money =0)
  660. {
  661. $lib_path = dirname(dirname( dirname(__FILE__) )).'/Lib/';
  662. $data_path = dirname( dirname(dirname( dirname(__FILE__) )) ).'/Data/wxpaylogs/'.date('Y-m-d')."/";
  663. RecursiveMkdir($data_path);
  664. set_time_limit(0);
  665. require_once $lib_path."/Weixin/lib/WxPay.Api.php";
  666. require_once $lib_path."/Weixin/log.php";
  667. //初始化日志
  668. $logHandler= new \CLogFileHandler( $data_path .date('Y-m-d').'.log');
  669. \Log::Init($logHandler, 15);
  670. \Log::DEBUG("进行中,订单ID :".$order_id );
  671. //pin
  672. $order_info = M('order')->where( array('order_id' => $order_id) )->find();
  673. $member_info = M('member')->where( array('member_id' => $order_info['member_id']) )->find();
  674. $openId = $member_info['openid'];
  675. $we_openid = $member_info['we_openid'];
  676. if( $order_info['from_type'] == 'wepro' )
  677. {
  678. $openId = $we_openid;
  679. }
  680. //we_openid
  681. //money
  682. $transaction_id = $order_info["transaction_id"];
  683. $total_fee = ($order_info["total"])*100;
  684. $refund_fee = $total_fee;
  685. if($money > 0)
  686. {
  687. $refund_fee = $money * 100;
  688. }
  689. if($order_info['payment_code'] == 'yuer')
  690. {
  691. //余额支付的,退款到余额
  692. //退款到余额
  693. $member_charge_flow_data = array();
  694. $member_charge_flow_data['member_id'] = $order_info['member_id'];
  695. $member_charge_flow_data['money'] = $order_info["total"];
  696. $member_charge_flow_data['state'] = 4;
  697. $member_charge_flow_data['trans_id'] = $order_id;
  698. $member_charge_flow_data['charge_time'] = time();
  699. $member_charge_flow_data['add_time'] = time();
  700. M('member_charge_flow')->add($member_charge_flow_data);
  701. //增加会员余额
  702. M('member')->where( array('member_id'=> $order_info['member_id'] ) )->setInc('account_money',$order_info["total"] );
  703. $order_info['total'] = $refund_fee / 100;
  704. $this->refundOrder_success($order_info,$openId);
  705. //检测是否有需要退回积分的订单
  706. }
  707. else if($refund_fee == 0)
  708. {
  709. M('order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  710. $config_info = M('config')->where( array('name' => 'SITE_URL') )->find();
  711. $order_goods = M('order_goods')->where( array('order_id' => $order_info['order_id']) )->select();
  712. $order_goods_name = '';
  713. $order_goods_name_arr = array();
  714. foreach ($order_goods as $key => $value) {
  715. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity'],2);
  716. //销量回退
  717. //$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET seller_count = (seller_count - " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' ");
  718. $order_goods_name_arr[] = $value['name'];
  719. }
  720. $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n";
  721. $msg = '订单退款: 您的订单'.$order_info['order_num_alias'].'参团未成功,现退款:'.round($order_info["total"],2).'元,商品名称:'.$order_goods_name;
  722. $url = $config_info['value'];
  723. //weixin_template_refund_order
  724. //send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order'));
  725. $url = $url."/index.php?s=/Order/info/id/{$order_info['order_id']}.html";
  726. /**
  727. {{first.DATA}}
  728. 订单编号:{{keyword1.DATA}}
  729. 退款金额:{{keyword2.DATA}}
  730. {{remark.DATA}}
  731. ---------------------------
  732. 校白君提醒您,您有一笔退款成功,请留意。
  733. 订单编号:20088115853
  734. 退款金额:¥19.00
  735. 更多学生价好货,在底部菜单栏哦~猛戳“校园专区”,享更多优惠!
  736. **/
  737. $wx_template_data = array();
  738. $wx_template_data['first'] = array('value' => '退款通知', 'color' => '#030303');
  739. $wx_template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303');
  740. $wx_template_data['keyword2'] = array('value' => round($order_info["total"],2), 'color' => '#030303');
  741. $wx_template_data['remark'] = array('value' => '拼团失败已按原路退款', 'color' => '#030303');
  742. if( $order_info['from_type'] == 'wepro' )
  743. {
  744. $template_data = array();
  745. $template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303');
  746. $template_data['keyword2'] = array('value' => '参团未成功', 'color' => '#030303');
  747. $template_data['keyword3'] = array('value' => '拼团失败已按原路退款', 'color' => '#030303');
  748. $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_fail_pin') )->find();
  749. $template_id = $pay_order_msg_info['value'];
  750. $pagepath = 'pages/order/order?id='.$order_info['order_id'];
  751. /**
  752. $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'], 'state' => 0) )->find();
  753. send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid']);
  754. //更新
  755. M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) );
  756. $order_info['member_id']
  757. **/
  758. $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'], 'formid' =>array('neq',''), 'state' => 0) )->order('id desc')->find();
  759. if(!empty( $member_formid_info ))
  760. {
  761. send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid'] );
  762. M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) );
  763. }
  764. if( $openid != '1')
  765. {
  766. //notify_weixin_msg($member_info['openid'],$msg,'退款通知',$url);
  767. send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order'));
  768. }
  769. }else{
  770. //notify_weixin_msg($member_info['openid'],$msg,'退款通知',$url);
  771. send_template_msg($wx_template_data,$url,$member_info['openid'],C('weixin_template_refund_order'));
  772. }
  773. //检测是否有需要退回积分的订单
  774. \Log::DEBUG("退款成功。。。退款日志:退款订单号:" . $order_info['order_id'].',ten:'.$transaction_id.' 退款金额: '
  775. .$order_info["total"].',退款给:openid='.$openId);
  776. } else {
  777. $input = new \WxPayRefund();
  778. $input->SetTransaction_id($transaction_id);
  779. $input->SetTotal_fee($total_fee);
  780. $input->SetRefund_fee($refund_fee);
  781. $refund_no = \WxPayConfig::MCHID.date("YmdHis").$order_info['order_id'];
  782. $input->SetOut_refund_no($refund_no);
  783. $input->SetOp_user_id(\WxPayConfig::MCHID);
  784. $res = (\WxPayApi::refund($input,6,$order_info['from_type']));
  785. //var_dump($res);die(); wx80131aa7dfc4ff71
  786. if($res['result_code'] == 'SUCCESS')
  787. {
  788. $order_info['total'] = $refund_fee / 100;
  789. $this->refundOrder_success($order_info,$openId);
  790. \Log::DEBUG("退款成功。。。退款日志:退款订单号:" . $order_info['order_id'].',ten:'.$transaction_id.' 退款金额: '.$order_info["total"].',退款给:openid='.$openid);
  791. //检测是否有需要退回积分的订单
  792. } else {
  793. M('order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 10, 'comment' => $res[err_code_des]) );
  794. \Log::DEBUG("退款失败。原因:{$res[err_code_des]}。。退款日志:退款订单号:" . $order_info['order_id'].',退款金额: '.$order_info["total"].',退款给:openid='.$openId);
  795. }
  796. }
  797. return true;
  798. }
  799. /**
  800. 取消已经付款的 待发货订单
  801. 5、处理订单,
  802. 6、处理退款,
  803. **/
  804. public function del_cancle_order($order_id)
  805. {
  806. $order_info = M('lionfish_comshop_order')->where( array('order_id' => $order_id ) )->find();
  807. //判断订单状态是否已付款,避免多次退款,不合理
  808. if( $order_info['order_status_id'] == 1 )
  809. {
  810. //del_cancle_order
  811. $total_money = D('Seller/Commonorder')->get_order_paymoney( $order_id );
  812. $has_refun_money = D('Seller/Commonorder')->order_refund_totalmoney( $order_id );
  813. //是否预售订单begin
  814. $presale_result = D('Home/PresaleGoods')->getOrderPresaleInfo( $order_id );
  815. $presale_info = [];
  816. if( $presale_result['code'] == 0 )
  817. {
  818. $presale_info = $presale_result['data'];
  819. $total_money = $total_money - $presale_info['presale_ding_money'];
  820. }
  821. //end
  822. $refund_money = round($total_money - $has_refun_money,2);
  823. $result = $this->refundOrder($order_id, $refund_money);
  824. if( $result['code'] == 1 )
  825. {
  826. $order_history = array();
  827. $order_history['order_id'] = $order_id;
  828. $order_history['order_status_id'] = 5;
  829. $order_history['notify'] = 0;
  830. $order_history['comment'] = '会员前台申请取消订单,取消成功,并退款。';
  831. $order_history['date_added'] = time();
  832. M('lionfish_comshop_order_history')->add( $order_history );
  833. M('lionfish_comshop_order')->where( array('order_id' => $order_id) )->save( array('order_status_id' => 5) );
  834. //整笔
  835. D('Seller/Commonorder')->refund_one_order( $order_id ,1);
  836. return array('code' => 0);
  837. }else{
  838. $order_history = array();
  839. $order_history['order_id'] = $order_id;
  840. $order_history['order_status_id'] = 10;
  841. $order_history['notify'] = 0;
  842. $order_history['comment'] = '申请取消订单,但是退款失败。';
  843. $order_history['date_added'] = time();
  844. M('lionfish_comshop_order_history')->add( $order_history );
  845. M('lionfish_comshop_order')->where( array('order_id' => $order_id ) )->save( array('order_status_id' => 10, 'remarksaler' => $result['msg']) );
  846. return array('code' => 1, 'msg' => $result['msg'] ,'s' => $result['code'] );
  847. }
  848. }
  849. //如果退款成功了。那么就进行
  850. }
  851. public function test_form_msg()
  852. {
  853. $member_info = M('member')->where( array('member_id' => 26) )->find();
  854. $form_id_arr = M('member_formid')->where( array('member_id' => 26,'state' =>0) )->find();
  855. M('member_formid')->where( array('id' => $form_id_arr['id'] ) )->save( array('state' =>1) );
  856. $form_id = $form_id_arr['formid'];
  857. $template_data = array();
  858. $template_data['keyword1'] = array('value' => '338866', 'color' => '#030303');
  859. $template_data['keyword2'] = array('value' => '商品名称', 'color' => '#030303');
  860. $template_data['keyword3'] = array('value' => '18元', 'color' => '#030303');
  861. $template_data['keyword4'] = array('value' => '已按原路退款', 'color' => '#030303');
  862. $template_data['keyword5'] = array('value' => '小鱼', 'color' => '#030303');
  863. $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_refund_order') )->find();
  864. $template_id = $pay_order_msg_info['value'];
  865. $pagepath = 'pages/order/order?id='.$order_info['order_id'];
  866. $rs = send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$form_id);
  867. var_dump($rs);die();
  868. }
  869. public function refundOrder_success($order_info,$openid)
  870. {
  871. M('order')->where( array('order_id' => $order_info['order_id']) )->save( array('order_status_id' => 7) );
  872. $member_info = M('member')->where( array('member_id' => $order_info['member_id']) )->find();
  873. $config_info = M('config')->where( array('name' => 'SITE_URL') )->find();
  874. $order_goods = M('order_goods')->where( array('order_id' => $order_info['order_id']) )->select();
  875. $goods_model = D('Home/Goods');
  876. $order_goods_name = '';
  877. $order_goods_name_arr = array();
  878. foreach ($order_goods as $key => $value) {
  879. //$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET quantity = (quantity + " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' ");
  880. $goods_model->del_goods_mult_option_quantity($order_info['order_id'],$value['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity'],2);
  881. //销量回退
  882. //$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET seller_count = (seller_count - " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' ");
  883. $order_goods_name_arr[] = $value['name'];
  884. }
  885. $order_goods_name = implode('\r\n', $order_goods_name_arr); //."\r\n";
  886. $msg = '订单退款: 您的订单'.$order_info['order_num_alias'].'参团未成功,现退款:'.round($order_info["total"],2).'元,商品名称:'.$order_goods_name;
  887. $url = $config_info['value'];
  888. $wx_template_data = array();
  889. $wx_template_data['first'] = array('value' => '退款通知', 'color' => '#030303');
  890. $wx_template_data['keyword1'] = array('value' => $order_goods_name, 'color' => '#030303');
  891. $wx_template_data['keyword2'] = array('value' => $order_info['total'].'元', 'color' => '#030303');
  892. $wx_template_data['remark'] = array('value' => '已按原路退款', 'color' => '#030303');
  893. $url = $url."/index.php?s=/Order/info/id/{$order_info['order_id']}.html";
  894. if( $order_info['from_type'] == 'wepro' )
  895. {
  896. /**
  897. 退款成功通知
  898. 关键词
  899. 订单号
  900. {{keyword1.DATA}}
  901. 商品名称
  902. {{keyword2.DATA}}
  903. 退款金额
  904. {{keyword3.DATA}}
  905. 温馨提示
  906. {{keyword4.DATA}}
  907. 备注
  908. {{keyword5.DATA}}
  909. **/
  910. //$total_money = ($order_info["total"],2);
  911. $template_data = array();
  912. $template_data['keyword1'] = array('value' => $order_info['order_num_alias'], 'color' => '#030303');
  913. $template_data['keyword2'] = array('value' => $order_goods_name, 'color' => '#030303');
  914. $template_data['keyword3'] = array('value' => $order_info['total'].'元', 'color' => '#030303');
  915. $template_data['keyword4'] = array('value' => '已按原路退款', 'color' => '#030303');
  916. $template_data['keyword5'] = array('value' => $member_info['uname'], 'color' => '#030303');
  917. $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_refund_order') )->find();
  918. $template_id = $pay_order_msg_info['value'];
  919. $pagepath = 'pages/order/order?id='.$order_info['order_id'];
  920. /**
  921. $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'], 'state' => 0) )->find();
  922. send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid']);
  923. //更新
  924. M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) );
  925. **/
  926. $member_formid_info = M('member_formid')->where( array('member_id' => $order_info['member_id'],'formid' =>array('neq',''), 'state' => 0) )->order('id desc')->find();
  927. //$order_info['member_id']
  928. if( !empty($member_formid_info) )
  929. {
  930. $rs = send_wxtemplate_msg($template_data,$url,$pagepath,$member_info['we_openid'],$template_id,$member_formid_info['formid']);
  931. M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) );
  932. }
  933. if( $openid != '1')
  934. {
  935. //notify_weixin_msg($openid,$msg,'退款通知',$url);
  936. send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order'));
  937. }
  938. }else{
  939. //notify_weixin_msg($openid,$msg,'退款通知',$url);
  940. send_template_msg($wx_template_data,$url,$openid,C('weixin_template_refund_order'));
  941. }
  942. }
  943. }
  944. ?>