Ntest.php
7.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
<?php
namespace app\test\controller;
use phpDocumentor\Reflection\DocBlock\Tag\VarTagTest;
use qcloudcos\Conf;
use qcloudcos\Myqcloudcos;
use Pinyin\Pinyin;
use think\Controller;
use think\db\Query;
use Think\Exception;
use think\Url;
use think\Config;
use think\Page;
use think\Validate;
use think\Verify;
use think\Db;
use think\model\Merge;
use think\Cache;
class Ntest extends Controller
{
public $weixin_config;
public function _initialize() {
$stoid=getMobileStoId();
if(empty($stoid)) $stoid=1;
$this->weixin_config = M('wx_user')->where('store_id='.$stoid)->find(); //获取微信配置
}
public function add_card(){
$data='{"token":"59a23b4f68f99138d2fe6844dfa75fe96b274db4167d7ab1d5bcb4a0de5c60e9f1df542d77ea8c5c466aee8d3a1c1ca244a57bc953b77ff742b7e344c8273d74f23513cc75ff996fb490d28c573b4c2d2f1568ddfa25342ef4550cda0d1b009b22a88d1a21f94a7ee9151c436e86af68b9c250fd9c899d0c7fdba3159e7d66813f16e60222eabf566cabef5ba355d22411eca15ce94f9958221045e9149680b08dd58ee155a2e2ba7f2d753af7820a14335893c01cf0e705a2d6222a9b6ae7ca751cff834d2753864ee9cbb0e19d52a98c1ceee2754794df1bebf65c7d13d985287d2f17167421d9dfec34f0a36e97dd7a9f4f61ec35f71d8f70f219f3532a46","VIPId":"5054c0f8-171e-8d59-ad47-19f63472aec2","CardId":"D7F47EBB-D94F-4D21-A786-FDAB7F9D8DEB","CardFee":"99","PayTypeId":"\u5fae\u652f\u4ed8","PayNo":"XSJHZP_vlc201909292001072385","Recommon":"18879153313","ServiceMan":"18879153313","page":1,"pageSize":10}';
$data=json_decode($data,true);
$data['RegisterDate']="2019-09-29 20:01:16";
$api = "/api/erp/vip/mem/card/register";
$mrs = getApiData_java_p($api, "XSJHZP", $data, 1, 10, null, "POST");
dump($mrs);
}
//--重新分配--
public function re_discount_order2(){
$sql='select a.account*a.goods_num,b.order_amount+b.user_money from wxd_order_goods a
LEFT JOIN wxd_order b ON a.order_id=b.order_id where
a.account*a.goods_num>b.order_amount+b.user_money-b.shipping_price and
b.store_id=99 and a.account_yu>0 and a.account>0 ';
$data_arr=Db::query($sql);
$this->assign("data_arr", json_encode($data_arr));
return $this->fetch("","",0);
}
public function re_discount_handle(){
$order_sn=I("order_sn");
//是否启用平摊
$dissum = 0;
$order=M("order")->where("order_sn",$order_sn)->find();
$ordergoods_list = M('order_goods')->where(array('order_sn' => $order_sn, 'goods_price' => array('neq', 0)))
->order('goods_price desc')->select(); //订单详情
if(count($ordergoods_list)>1){
return json(['code'=>-1,'msg'=>'买多件不平摊']);
}
$orderlist = $order;
$dissum = $orderlist['discount_amount'] + $orderlist['order_prom_amount']; //促销优惠金额 + 订单优惠
//优惠金额
if ($dissum) {
$val=$ordergoods_list[0];
$fect_price= $val['goods_price'] * $val['goods_num']-$dissum;
$per= floor($fect_price*100/ $val['goods_num'])/100;
$yu=$fect_price-$val['goods_num']*$per;
$data['account']=$per;
$data['account_yu']=$yu;
M("order_goods")->where('order_sn',$order_sn)->save($data);
return json(['code'=>0,'msg'=>'suc:'.$order_sn]);
}
}
public function clear_zhuce_sanjia_cache()
{
$store=M("store")->select();
foreach ($store as $k=>$v){
$name='weshop:PROD:erp:newToken:'.$store['ERPId'];
Cache::rm($name);
}
echo 'ok';
}
//判断是否有线下会员
public function check_is_downLine_member($erpvipid,$accdb)
{
}
public function my_test_user(){
$this->check_is_downLine_member("{84949140-16bf-bd0d-f21a-d1864ca21c26}","ppt");
}
public function text_php(){
$var = 122.0004;
$float_value_of_var = floatval ($var);
echo $float_value_of_var;
}
//-- 测试人数 --
public function test_gu_php(){
$store_m=M('store_module_endtime')->where('store_id',1)->where('type',3)->find();
$datap['EndDate']= date("Y-m-d", $store_m['end_time']);
$rs=getApiData_java_p("/api/erp/vip/mem/card/count",'ppt',$datap);
echo $rs;
if($rs){
$rs=json_decode($rs,true);
$count=$rs['data']['SumTotal'];
return $count;
}
}
public function notify_post(){
return $this->fetch();
}
public function notify_dj(){
$order_sn="PPT_vlc201911201107435937";
$rs = M('recharge')->where(array('order_sn' => $order_sn, 'recharge_type' => array("in",'3,4'), 'pay_status' => 0))->find();//积分充值
if (empty($rs)) {
return true;
}
$getstoid = $rs['store_id'];
$store_erpid = tpCache('shop_info.ERPId', $rs['store_id']);
mlog('等级卡,会员id::' . $rs['user_id'], 'recharge/' . $rs['store_id']);
$user = M("users")->where("user_id", $rs['user_id'])->field("erpvipid")->find();
$vipid = $user['erpvipid'];
$tk = tpCache('shop_info', $rs['store_id']);
$sto_erpid = $tk['ERPId'];
$data1 = array(
'VIPId' => urlencode($vipid),//会员ID
'CardId' => $rs['cardid'],//等级卡ID
'CardFee' => $rs['account'],//等级卡金额
'PayTypeId' => '微支付',
'PayNo' => $rs["order_sn"],//
);
$updateuser = null;
if ($rs['recharge_type'] == 3) {
$data1['Recommon'] = $rs["recommon"];//邀请码
$data1['ServiceMan'] = $rs["serviceman"];//营业员
$api = "/api/erp/vip/mem/card/register";
//$mrs = getApiData_java_p($api, $sto_erpid, $data1, 1, 10, null, "POST");
//mlog('购买:' . json_encode($data1, true) . ' 返回值:' . $mrs, 'recharge_1/' . $rs['store_id']);
//$mrs = json_decode($mrs, true);
$mrs=more_pos_api($api,$data1,$sto_erpid,3);
//计算有效期
//$yxq = strtotime("+" . $rs['days'] . " day");
//$updateuser['card_expiredate'] = date('Y-m-d H:i:s', $yxq);
mlog('开卡:' . json_encode($data1) . ' 返回值:' . json_encode($mrs), 'recharge_1/' . $rs['store_id']);
//$mrs = json_decode($mrs, true);
$updateuser['card_expiredate'] = $mrs['data'][0]['ExpiryDate'];
} else {
$api = "/api/erp/vip/mem/card/renew";
//$mrs = getApiData_java_p($api, $sto_erpid, $data1, 1, 10, null, "POST");
$mrs=more_pos_api($api,$data1,$sto_erpid,3);
mlog('续费:' . json_encode($data1) . ' 返回值:' . json_encode($mrs), 'recharge_1/' . $rs['store_id']);
//$mrs = json_decode($mrs, true);
$updateuser['card_expiredate'] = $mrs['data'][0]['ExpiryDate'];
}
if ($mrs['code'] == 0) {
$updateuser['card_field'] = $rs['integral_remark'];
M('users')->where('user_id', $rs['user_id'])->save($updateuser);//更新会员信息表
}
$data['pay_status'] = 1;
$data['payno'] = $data["transaction_id"];
$rs = M('recharge')->where('order_id', $rs['order_id'])->save($data);
if ($rs) {
mlog($order_sn . "处理成功", "recharge/" . $getstoid);
} else {
mlog($order_sn . "处理失败", "recharge/" . $getstoid);
}
return "ok";
}
}