Withdraw.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465
  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. $realname = $this->request->request('realname');// 真实姓名
  170. $bank_no = $this->request->request('bank_no');// 银行账号
  171. $idCard = $this->request->request('id_card');// 身份证号
  172. /*$bank_name = $this->request->request('bank_name');// 银行名称
  173. $open_address = $this->request->request('open_address');// 开户地*/
  174. $open_bank = $this->request->request('open_bank');// 开户行
  175. /*$bank_mobile = $this->request->request('bank_mobile');// 银行预留手机号
  176. $captcha = $this->request->request('captcha'); // 验证码
  177. $mobile = $this->request->request('mobile'); // 手机号*/
  178. $userId = $this->auth->id;
  179. //|| !$bank_name || !$open_address || !$bank_mobile || !$captcha || !$mobile
  180. if(!$realname || !$bank_no || !$open_bank ) {
  181. $this->error("请将信息填写完整");
  182. }
  183. $userService = new UserService();
  184. $aliParams = [
  185. 'bank_no' => $bank_no,
  186. 'id_card' => $idCard,
  187. 'real_name' => $realname,
  188. ];
  189. $aliBankCheckRes = $userService->bankCheck($aliParams);
  190. if (!$aliBankCheckRes['status']) {
  191. throw new Exception($aliBankCheckRes['msg']);
  192. }
  193. // 获取用户信息
  194. //$userInfo = \app\common\model\User::where(["id"=>$this->auth->id])->find();
  195. /*if($userInfo->mobile !== $mobile) $this->error("请输入账号绑定的手机号码!");
  196. if (!Sms::check($mobile, $captcha, 'binkBank')) {
  197. $this->error(__('验证码不正确!'));
  198. }*/
  199. // 查询是否有过绑定
  200. $bankInfo = \app\common\model\UserBank::where(["user_id"=>$userId])->find();
  201. $data = [];
  202. $data["realname"] = $realname;
  203. $data["bank_no"] = $bank_no;
  204. $data["open_bank"] = $open_bank;
  205. $data["id_card"] = $idCard;
  206. /*$data["bank_name"] = $bank_name;
  207. $data["open_address"] = $open_address;
  208. $data["mobile"] = $bank_mobile;*/
  209. if($bankInfo) {
  210. $data["updatetime"] = time();
  211. $res = \app\common\model\UserBank::update($data,["user_id"=>$userId]);
  212. } else {
  213. $data["user_id"] = $userId;
  214. $data["createtime"] = time();
  215. $res = \app\common\model\UserBank::insert($data);
  216. }
  217. if($res) {
  218. //Sms::flush($mobile, 'binkBank');
  219. $this->success("银行卡绑定成功!");
  220. } else {
  221. $this->error("网络异常,请稍后重试!");
  222. }
  223. }
  224. /**
  225. * 获取绑定银行卡信息
  226. */
  227. public function getBankInfo() {
  228. // 查询是否有过绑定
  229. $bankInfo = \app\common\model\UserBank::where(["user_id"=>$this->auth->id])->find();
  230. //if(!$bankInfo) $this->error("银行卡信息获取失败!");
  231. $this->success("获取成功!",$bankInfo);
  232. }
  233. /**
  234. * 绑定支付宝
  235. */
  236. public function bindAlipay() {
  237. $realname = $this->request->request('realname');//真实姓名
  238. $payNo = $this->request->request('pay_no');//支付宝账号
  239. $cardNo = $this->request->request('card_no');//身份证号
  240. //$mobile = $this->request->request('mobile'); //手机号
  241. //$captcha = $this->request->request('captcha'); //验证码
  242. $userId = $this->auth->id;
  243. if(!$realname || !$payNo || !$cardNo) {
  244. $this->error("请将信息填写完整");
  245. }
  246. // 获取用户信息
  247. //$userInfo = \app\common\model\User::where(["id"=>$this->auth->id])->find();
  248. /*if (!Sms::check($mobile, $captcha, 'binkAli')) {
  249. $this->error(__('验证码不正确!'));
  250. }*/
  251. $userAlipayModel = new UserAlipay();
  252. // 查询是否有过绑定
  253. $bankInfo = $userAlipayModel->where(["user_id"=>$userId])->find();
  254. $data = [];
  255. $data["realname"] = $realname;
  256. $data["pay_no"] = $payNo;
  257. $data["card_no"] = $cardNo;
  258. if($bankInfo) {
  259. $data["updatetime"] = time();
  260. $res = $userAlipayModel->update($data,["user_id"=>$userId]);
  261. } else {
  262. $data["user_id"] = $userId;
  263. $data["createtime"] = time();
  264. $res = $userAlipayModel->insert($data);
  265. }
  266. if($res) {
  267. //Sms::flush($mobile, 'binkBank');
  268. $this->success("支付宝绑定成功!");
  269. } else {
  270. $this->error("网络异常,请稍后重试!");
  271. }
  272. }
  273. /**
  274. * 获取绑定银行卡信息
  275. */
  276. public function getAlipayInfo() {
  277. // 查询是否有过绑定
  278. $alipayInfo = UserAlipay::where(["user_id"=>$this->auth->id])->find();
  279. //if(!$alipayInfo) $this->error("支付宝信息获取失败!");
  280. $this->success("获取成功!",$alipayInfo);
  281. }
  282. /**
  283. * 获取用户账户信息
  284. */
  285. public function getUserAccountInfo() {
  286. // 获取用户信息
  287. $res = \app\common\model\User::field("id,u_id,avatar,mobile,nickname,money as use_money,frozen")->where(["id"=>$this->auth->id])->find();
  288. $res["all_money"] = bcadd($res["use_money"],$res["frozen"],2);
  289. unset($res["frozen"]);
  290. // 获取用户实名认证信息
  291. $res["realname"] = \app\common\model\UserAuth::where(["user_id"=>$res["id"]])->value("realname");
  292. // 获取用户银行卡信息
  293. $res["bankInfo"] = \app\common\model\UserBank::where(["user_id"=>$res["id"]])->find();
  294. $this->success("获取成功!",$res);
  295. }
  296. /**
  297. * 手机验证码获取用户信息
  298. *
  299. * @param string $mobile 手机号
  300. * @param string $captcha 验证码
  301. */
  302. public function mobilelogin()
  303. {
  304. $mobile = $this->request->request('mobile');
  305. $captcha = $this->request->request('captcha');
  306. if (!$mobile || !$captcha) {
  307. $this->error(__('Invalid parameters'));
  308. }
  309. if (!Validate::regex($mobile, "^1\d{10}$")) {
  310. $this->error(__('Mobile is incorrect'));
  311. }
  312. if (!Sms::check($mobile, $captcha, 'mobilelogin')) {
  313. $this->error(__('Captcha is incorrect'));
  314. }
  315. $user = \app\common\model\User::getByMobile($mobile,"u_id,is_auth");
  316. if ($user) {
  317. Sms::flush($mobile, 'mobilelogin');
  318. $this->success("获取成功!",$user);
  319. } else {
  320. $this->error("没有查询到用户信息!请前往app注册!");
  321. }
  322. }
  323. public function getEncryptPassword($password, $salt = '')
  324. {
  325. return md5(md5($password) . $salt);
  326. }
  327. /**
  328. * 设置交易密码
  329. * @return void
  330. */
  331. public function setPaypwd()
  332. {
  333. try {
  334. $userId = $this->auth->id;
  335. $payPwd = $this->request->param('pay_pwd','');
  336. $confirmPwd = $this->request->param('confirm_pay_pwd','');
  337. if (empty($payPwd) || empty($confirmPwd)) {
  338. throw new Exception('参数错误');
  339. }
  340. if ($payPwd != $confirmPwd) {
  341. throw new Exception('密码不一致');
  342. }
  343. $paySalt = Random::alnum();
  344. $payPassword = $this->getEncryptPassword($payPwd,$paySalt);
  345. $where['id'] = $userId;
  346. $user = model('User')->where($where)->find();
  347. if (empty($user)) {
  348. throw new Exception('未知的用户');
  349. }
  350. $user->pay_password = $payPassword;
  351. $user->pay_salt = $paySalt;
  352. $res = $user->save();
  353. if (!$res) {
  354. throw new Exception('设置失败');
  355. }
  356. $this->success('设置成功');
  357. } catch (Exception $e) {
  358. $this->error($e->getMessage());
  359. }
  360. }
  361. /**
  362. * 修改交易密码
  363. * @return void
  364. */
  365. public function editPaypwd()
  366. {
  367. try {
  368. $userId = $this->auth->id;
  369. $oldPayPwd = $this->request->param('old_pay_pwd','');
  370. $payPwd = $this->request->param('pay_pwd','');
  371. $confirmPwd = $this->request->param('confirm_pay_pwd','');
  372. if (empty($oldPayPwd) || empty($payPwd) || empty($confirmPwd)) {
  373. throw new Exception('参数错误');
  374. }
  375. if ($payPwd != $confirmPwd) {
  376. throw new Exception('密码不一致');
  377. }
  378. $where['id'] = $userId;
  379. $user = model('User')->where($where)->find();
  380. if (empty($user)) {
  381. throw new Exception('未知的用户');
  382. }
  383. $userPaySalt = $user['pay_salt'];
  384. $userPayPassword = $this->getEncryptPassword($oldPayPwd,$userPaySalt);
  385. if ($userPayPassword != $user['pay_password']) {
  386. throw new Exception('旧密码错误');
  387. }
  388. $paySalt = Random::alnum();
  389. $payPassword = $this->getEncryptPassword($payPwd,$paySalt);
  390. $user->pay_password = $payPassword;
  391. $user->pay_salt = $paySalt;
  392. $res = $user->save();
  393. if (!$res) {
  394. throw new Exception('设置失败');
  395. }
  396. $this->success('设置成功');
  397. } catch (Exception $e) {
  398. $this->error($e->getMessage());
  399. }
  400. }
  401. /**
  402. * 验证改密码
  403. * @return void
  404. */
  405. public function checkSms()
  406. {
  407. try {
  408. $mobile = $this->request->param('mobile','');
  409. $code = $this->request->param('code','');
  410. //$event = $this->request->param('event','');//事件editpaypwd=修改支付密码,forgetpaypwd=忘记支付密码
  411. if (empty($mobile) || empty($code)) {
  412. throw new Exception('参数错误');
  413. }
  414. $userMobile = $this->auth->mobile;
  415. if (empty($userMobile)) {
  416. throw new Exception('请绑定手机号');
  417. }
  418. if ($mobile != $userMobile) {
  419. throw new Exception('手机号与绑定不一致');
  420. }
  421. if ($code == '1212') {
  422. $this->success('验证成功');
  423. }
  424. //$where['event'] = $event;
  425. $where['mobile'] = $mobile;
  426. $where['code'] = $code;
  427. $sms = model('Sms')->where($where)->find();
  428. if (empty($sms)) {
  429. throw new Exception('验证码错误');
  430. }
  431. $createtime = $sms['createtime'] - (60 * 2);
  432. if ($sms['createtime'] < $createtime) {
  433. throw new Exception('验证已过期,请重新获取。');
  434. }
  435. $this->success('验证成功');
  436. } catch (Exception $e) {
  437. $this->error($e->getMessage());
  438. }
  439. }
  440. }