Withdraw.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\library\Sms;
  4. use app\api\controller\Common;
  5. use app\common\service\UserService;
  6. use fast\Random;
  7. use think\Db;
  8. use think\Exception;
  9. use think\Validate;
  10. use app\common\model\UserAlipay;
  11. /**
  12. *
  13. */
  14. class Withdraw extends Common
  15. {
  16. protected $layout = 'default';
  17. protected $noNeedLogin = ['getUserInfoByMobile','bindBank','mobilelogin'];
  18. protected $noNeedRight = ['*'];
  19. // /**
  20. // * 余额提现
  21. // * @return string
  22. // */
  23. // public function withdraw()
  24. // {
  25. // $config = get_addon_config('withdraw');
  26. // $this->view->assign('addonConfig', $config);
  27. // $this->view->assign('title', __('Withdraw'));
  28. // return $this->view->fetch();
  29. // }
  30. //
  31. // /**
  32. // * 余额日志
  33. // * @return string
  34. // */
  35. // public function withdrawlog()
  36. // {
  37. // $withdrawloglist = \addons\withdraw\model\Withdraw::where(['user_id' => $this->auth->id])
  38. // ->order('id desc')
  39. // ->paginate(10);
  40. //
  41. // $this->view->assign('title', __('Withdraw log'));
  42. // $this->view->assign('withdrawloglist', $withdrawloglist);
  43. // return $this->view->fetch();
  44. // }
  45. // /**
  46. // * 创建订单并发起支付请求
  47. // * @throws \think\exception\DbException
  48. // */
  49. // public function submit()
  50. // {
  51. // $money = $this->request->request('money');
  52. // $account = $this->request->request('account');
  53. // $name = $this->request->request('name');
  54. // $type = $this->request->request('type','alipay');
  55. //// $type = 'alipay';
  56. //
  57. //
  58. // if ($money <= 0) {
  59. // $this->error('提现金额不正确');
  60. // }
  61. // if ($money > $this->auth->money) {
  62. // $this->error('提现金额超出可提现额度');
  63. // }
  64. // if (!$account) {
  65. // $this->error("提现账户不能为空");
  66. // }
  67. // if (!$name) {
  68. // $this->error("真实姓名不能为空");
  69. // }
  70. // if (!Validate::is($account, "email") && !Validate::is($account, "/^1\d{10}$/")) {
  71. // $this->error("提现账户只能是手机号或Email");
  72. // }
  73. //
  74. // $config = get_addon_config('withdraw');
  75. // if (isset($config['minmoney']) && $money < $config['minmoney']) {
  76. // $this->error('提现金额不能低于' . $config['minmoney'] . '元');
  77. // }
  78. // if ($config['monthlimit']) {
  79. // $count = \addons\withdraw\model\Withdraw::where('user_id', $this->auth->id)->whereTime('createtime', 'month')->count();
  80. // if ($count >= $config['monthlimit']) {
  81. // $this->error("已达到本月最大可提现次数");
  82. // }
  83. // }
  84. // Db::startTrans();
  85. // try {
  86. // $data = [
  87. // 'orderid' => date("YmdHis") . sprintf("%08d", $this->auth->id) . mt_rand(1000, 9999),
  88. // 'user_id' => $this->auth->id,
  89. // 'money' => $money,
  90. // 'type' => $type,
  91. // 'account' => $account,
  92. // 'name' => $name,
  93. // ];
  94. // \addons\withdraw\model\Withdraw::create($data);
  95. // \app\common\model\User::money(-$money, $this->auth->id, "提现");
  96. // Db::commit();
  97. // } catch (Exception $e) {
  98. // Db::rollback();
  99. // $this->error($e->getMessage());
  100. // }
  101. // $this->success("提现申请成功!请等待后台审核!", url("withdraw/withdrawlog"));
  102. // return;
  103. // }
  104. //
  105. // /**
  106. // * 企业支付通知和回调
  107. // * @throws \think\exception\DbException
  108. // */
  109. // public function epay()
  110. // {
  111. // $type = $this->request->param('type');
  112. // $paytype = $this->request->param('paytype');
  113. // if ($type == 'notify') {
  114. // $pay = \addons\epay\library\Service::checkNotify($paytype);
  115. // if (!$pay) {
  116. // echo '签名错误';
  117. // return;
  118. // }
  119. // $data = $pay->verify();
  120. // try {
  121. // $payamount = $paytype == 'alipay' ? $data['total_amount'] : $data['total_fee'] / 100;
  122. // \addons\recharge\model\Order::settle($data['out_trade_no'], $payamount);
  123. // } catch (Exception $e) {
  124. // }
  125. // echo $pay->success();
  126. // } else {
  127. // $pay = \addons\epay\library\Service::checkReturn($paytype);
  128. // if (!$pay) {
  129. // $this->error('签名错误');
  130. // }
  131. // //微信支付没有返回链接
  132. // if ($pay === true) {
  133. // $this->success("请返回网站查看支付状态!", "");
  134. // }
  135. //
  136. // //你可以在这里定义你的提示信息,但切记不可在此编写逻辑
  137. // $this->success("恭喜你!充值成功!", url("user/index"));
  138. // }
  139. // return;
  140. // }
  141. /**
  142. * 根据手机号获取用户信息
  143. */
  144. public function getUserInfoByMobile() {
  145. $mobile = $this->request->request('mobile');// 手机号
  146. if(!$mobile) $this->error("请输入手机号!");
  147. $field = "u_id,avatar,money,nickname,mobile";
  148. $userInfo = \app\common\model\User::getByMobile($mobile,$field);
  149. $this->success("获取成功!",$userInfo);
  150. }
  151. /**
  152. * 验证身份证号
  153. */
  154. public function validateCard() {
  155. $idcard = $this->request->request('idcard');// 身份证号
  156. if(!$idcard) $this->error("参数缺失!");
  157. // 获取用户信息
  158. $idcardInfo = \app\common\model\UserAuth::where(["user_id"=>$this->auth->id])->value("idcard");
  159. if($idcardInfo === $idcard) {
  160. $this->success("验证成功!");
  161. } else {
  162. $this->error("验证失败!");
  163. }
  164. }
  165. /**
  166. * 绑定银行卡
  167. */
  168. public function bindBank() {
  169. try {
  170. $realname = $this->request->request('realname');// 真实姓名
  171. $bank_no = $this->request->request('bank_no');// 银行账号
  172. //$idCard = $this->request->request('id_card');// 身份证号
  173. /*$bank_name = $this->request->request('bank_name');// 银行名称
  174. $open_address = $this->request->request('open_address');// 开户地*/
  175. $open_bank = $this->request->request('open_bank');// 开户行
  176. /*$bank_mobile = $this->request->request('bank_mobile');// 银行预留手机号
  177. $captcha = $this->request->request('captcha'); // 验证码
  178. $mobile = $this->request->request('mobile'); // 手机号*/
  179. $userId = $this->auth->id;
  180. //|| !$bank_name || !$open_address || !$bank_mobile || !$captcha || !$mobile
  181. if(!$realname || !$bank_no || !$open_bank ) {
  182. throw new Exception("请将信息填写完整");
  183. }
  184. $userAuthWhere['user_id'] = $userId;
  185. $userAuth = model('UserAuth')->where($userAuthWhere)->find();
  186. if (empty($userAuth)) {
  187. throw new Exception('请先实名认证');
  188. }
  189. $idCard = $userAuth['idcard'];
  190. $userService = new UserService();
  191. $aliParams = [
  192. 'bank_no' => $bank_no,
  193. 'id_card' => $idCard,
  194. 'real_name' => $realname,
  195. ];
  196. $aliBankCheckRes = $userService->bankCheck($aliParams);
  197. if (!$aliBankCheckRes['status']) {
  198. throw new Exception($aliBankCheckRes['msg']);
  199. }
  200. // 获取用户信息
  201. //$userInfo = \app\common\model\User::where(["id"=>$this->auth->id])->find();
  202. /*if($userInfo->mobile !== $mobile) $this->error("请输入账号绑定的手机号码!");
  203. if (!Sms::check($mobile, $captcha, 'binkBank')) {
  204. $this->error(__('验证码不正确!'));
  205. }*/
  206. // 查询是否有过绑定
  207. $bankInfo = \app\common\model\UserBank::where(["user_id"=>$userId])->find();
  208. $data = [];
  209. $data["realname"] = $realname;
  210. $data["bank_no"] = $bank_no;
  211. $data["open_bank"] = $open_bank;
  212. $data["id_card"] = $idCard;
  213. /*$data["bank_name"] = $bank_name;
  214. $data["open_address"] = $open_address;
  215. $data["mobile"] = $bank_mobile;*/
  216. if($bankInfo) {
  217. $data["updatetime"] = time();
  218. $res = \app\common\model\UserBank::update($data,["user_id"=>$userId]);
  219. } else {
  220. $data["user_id"] = $userId;
  221. $data["createtime"] = time();
  222. $res = \app\common\model\UserBank::insert($data);
  223. }
  224. if(!$res) {
  225. throw new Exception("网络异常,请稍后重试!");
  226. }
  227. $this->success("银行卡绑定成功!");
  228. } catch (Exception $e) {
  229. $this->error($e->getMessage());
  230. }
  231. }
  232. /**
  233. * 获取绑定银行卡信息
  234. */
  235. public function getBankInfo() {
  236. // 查询是否有过绑定
  237. $bankInfo = \app\common\model\UserBank::where(["user_id"=>$this->auth->id])->find();
  238. //if(!$bankInfo) $this->error("银行卡信息获取失败!");
  239. $this->success("获取成功!",$bankInfo);
  240. }
  241. /**
  242. * 绑定支付宝
  243. */
  244. public function bindAlipay() {
  245. $realname = $this->request->request('realname');//真实姓名
  246. $payNo = $this->request->request('pay_no');//支付宝账号
  247. $cardNo = $this->request->request('card_no');//身份证号
  248. //$mobile = $this->request->request('mobile'); //手机号
  249. //$captcha = $this->request->request('captcha'); //验证码
  250. $userId = $this->auth->id;
  251. if(!$realname || !$payNo || !$cardNo) {
  252. $this->error("请将信息填写完整");
  253. }
  254. // 获取用户信息
  255. //$userInfo = \app\common\model\User::where(["id"=>$this->auth->id])->find();
  256. /*if (!Sms::check($mobile, $captcha, 'binkAli')) {
  257. $this->error(__('验证码不正确!'));
  258. }*/
  259. $userAlipayModel = new UserAlipay();
  260. // 查询是否有过绑定
  261. $bankInfo = $userAlipayModel->where(["user_id"=>$userId])->find();
  262. $data = [];
  263. $data["realname"] = $realname;
  264. $data["pay_no"] = $payNo;
  265. $data["card_no"] = $cardNo;
  266. if($bankInfo) {
  267. $data["updatetime"] = time();
  268. $res = $userAlipayModel->update($data,["user_id"=>$userId]);
  269. } else {
  270. $data["user_id"] = $userId;
  271. $data["createtime"] = time();
  272. $res = $userAlipayModel->insert($data);
  273. }
  274. if($res) {
  275. //Sms::flush($mobile, 'binkBank');
  276. $this->success("支付宝绑定成功!");
  277. } else {
  278. $this->error("网络异常,请稍后重试!");
  279. }
  280. }
  281. /**
  282. * 获取绑定银行卡信息
  283. */
  284. public function getAlipayInfo() {
  285. // 查询是否有过绑定
  286. $alipayInfo = UserAlipay::where(["user_id"=>$this->auth->id])->find();
  287. //if(!$alipayInfo) $this->error("支付宝信息获取失败!");
  288. $this->success("获取成功!",$alipayInfo);
  289. }
  290. /**
  291. * 获取用户账户信息
  292. */
  293. public function getUserAccountInfo() {
  294. // 获取用户信息
  295. $res = \app\common\model\User::field("id,u_id,avatar,mobile,nickname,money as use_money,frozen")->where(["id"=>$this->auth->id])->find();
  296. $res["all_money"] = bcadd($res["use_money"],$res["frozen"],2);
  297. unset($res["frozen"]);
  298. // 获取用户实名认证信息
  299. $res["realname"] = \app\common\model\UserAuth::where(["user_id"=>$res["id"]])->value("realname");
  300. // 获取用户银行卡信息
  301. $res["bankInfo"] = \app\common\model\UserBank::where(["user_id"=>$res["id"]])->find();
  302. $this->success("获取成功!",$res);
  303. }
  304. /**
  305. * 手机验证码获取用户信息
  306. *
  307. * @param string $mobile 手机号
  308. * @param string $captcha 验证码
  309. */
  310. public function mobilelogin()
  311. {
  312. $mobile = $this->request->request('mobile');
  313. $captcha = $this->request->request('captcha');
  314. if (!$mobile || !$captcha) {
  315. $this->error(__('Invalid parameters'));
  316. }
  317. if (!Validate::regex($mobile, "^1\d{10}$")) {
  318. $this->error(__('Mobile is incorrect'));
  319. }
  320. if (!Sms::check($mobile, $captcha, 'mobilelogin')) {
  321. $this->error(__('Captcha is incorrect'));
  322. }
  323. $user = \app\common\model\User::getByMobile($mobile,"u_id,is_auth");
  324. if ($user) {
  325. Sms::flush($mobile, 'mobilelogin');
  326. $this->success("获取成功!",$user);
  327. } else {
  328. $this->error("没有查询到用户信息!请前往app注册!");
  329. }
  330. }
  331. public function getEncryptPassword($password, $salt = '')
  332. {
  333. return md5(md5($password) . $salt);
  334. }
  335. /**
  336. * 设置交易密码
  337. * @return void
  338. */
  339. public function setPaypwd()
  340. {
  341. try {
  342. $userId = $this->auth->id;
  343. $payPwd = $this->request->param('pay_pwd','');
  344. $confirmPwd = $this->request->param('confirm_pay_pwd','');
  345. if (empty($payPwd) || empty($confirmPwd)) {
  346. throw new Exception('参数错误');
  347. }
  348. if ($payPwd != $confirmPwd) {
  349. throw new Exception('密码不一致');
  350. }
  351. $paySalt = Random::alnum();
  352. $payPassword = $this->getEncryptPassword($payPwd,$paySalt);
  353. $where['id'] = $userId;
  354. $user = model('User')->where($where)->find();
  355. if (empty($user)) {
  356. throw new Exception('未知的用户');
  357. }
  358. $user->pay_password = $payPassword;
  359. $user->pay_salt = $paySalt;
  360. $res = $user->save();
  361. if (!$res) {
  362. throw new Exception('设置失败');
  363. }
  364. $this->success('设置成功');
  365. } catch (Exception $e) {
  366. $this->error($e->getMessage());
  367. }
  368. }
  369. /**
  370. * 修改交易密码
  371. * @return void
  372. */
  373. public function editPaypwd()
  374. {
  375. try {
  376. $userId = $this->auth->id;
  377. $oldPayPwd = $this->request->param('old_pay_pwd','');
  378. $payPwd = $this->request->param('pay_pwd','');
  379. $confirmPwd = $this->request->param('confirm_pay_pwd','');
  380. if (empty($oldPayPwd) || empty($payPwd) || empty($confirmPwd)) {
  381. throw new Exception('参数错误');
  382. }
  383. if ($payPwd != $confirmPwd) {
  384. throw new Exception('密码不一致');
  385. }
  386. $where['id'] = $userId;
  387. $user = model('User')->where($where)->find();
  388. if (empty($user)) {
  389. throw new Exception('未知的用户');
  390. }
  391. $userPaySalt = $user['pay_salt'];
  392. $userPayPassword = $this->getEncryptPassword($oldPayPwd,$userPaySalt);
  393. if ($userPayPassword != $user['pay_password']) {
  394. throw new Exception('旧密码错误');
  395. }
  396. $paySalt = Random::alnum();
  397. $payPassword = $this->getEncryptPassword($payPwd,$paySalt);
  398. $user->pay_password = $payPassword;
  399. $user->pay_salt = $paySalt;
  400. $res = $user->save();
  401. if (!$res) {
  402. throw new Exception('设置失败');
  403. }
  404. $this->success('设置成功');
  405. } catch (Exception $e) {
  406. $this->error($e->getMessage());
  407. }
  408. }
  409. /**
  410. * 验证改密码
  411. * @return void
  412. */
  413. public function checkSms()
  414. {
  415. try {
  416. $mobile = $this->request->param('mobile','');
  417. $code = $this->request->param('code','');
  418. //$event = $this->request->param('event','');//事件editpaypwd=修改支付密码,forgetpaypwd=忘记支付密码
  419. if (empty($mobile) || empty($code)) {
  420. throw new Exception('参数错误');
  421. }
  422. $userMobile = $this->auth->mobile;
  423. if (empty($userMobile)) {
  424. throw new Exception('请绑定手机号');
  425. }
  426. if ($mobile != $userMobile) {
  427. throw new Exception('手机号与绑定不一致');
  428. }
  429. if ($code == '1212') {
  430. $this->success('验证成功');
  431. }
  432. //$where['event'] = $event;
  433. $where['mobile'] = $mobile;
  434. $where['code'] = $code;
  435. $sms = model('Sms')->where($where)->find();
  436. if (empty($sms)) {
  437. throw new Exception('验证码错误');
  438. }
  439. $createtime = $sms['createtime'] - (60 * 2);
  440. if ($sms['createtime'] < $createtime) {
  441. throw new Exception('验证已过期,请重新获取。');
  442. }
  443. $this->success('验证成功');
  444. } catch (Exception $e) {
  445. $this->error($e->getMessage());
  446. }
  447. }
  448. }