BankCardBusiness.php 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. namespace app\business;
  3. use Illuminate\Support\Arr;
  4. use support\Db;
  5. use support\Redis;
  6. class BankCardBusiness
  7. {
  8. /** 用户卡号信息
  9. * @param array $param
  10. * @return void
  11. */
  12. static public function data(array $param)
  13. {
  14. $data=Db::table('wa_bank_card')->where(function ($query)use ($param){
  15. if(Arr::get($param,'uid')){
  16. $query->where('uid',$param['uid']);
  17. }
  18. })->first();
  19. return $data;
  20. }
  21. /**绑定和修改实名信息
  22. * @param array $param
  23. * @return void
  24. */
  25. static public function UpData(array $param)
  26. {
  27. try {
  28. $data=Db::table('wa_bank_card')->where('uid',$param['user_data']['id'])->first();
  29. $user_identity_name=Db::table('wa_user_identity')->where('uid',$param['user_data']['id'])->value('name');
  30. if(empty($user_identity_name)){
  31. throw new \Exception('请先实名!');
  32. }
  33. if($user_identity_name != $param['account_holder']){
  34. throw new \Exception('实名人和开户人不一致,请绑定实名人的银行卡!');
  35. }
  36. if(empty($data)){
  37. /** 绑定 */
  38. Db::table('wa_bank_card')->insert([
  39. 'affiliated_bank' =>$param['affiliated_bank'],
  40. 'account_holder' =>$param['account_holder'],
  41. 'card_number' =>$param['card_number'],
  42. 'uid' =>$param['user_data']['id'],
  43. 'created_at' =>date('Y-m-d H:i:s'),
  44. 'updated_at' =>date('Y-m-d H:i:s'),
  45. ]);
  46. }else{
  47. throw new \Exception('请联系客服进行修改!');
  48. if($user_identity_name != $param['account_holder']){
  49. throw new \Exception('实名人和开户人不一致,请绑定实名人的银行卡!');
  50. }
  51. /** 修改 */
  52. Db::table('wa_bank_card')->where('uid',$param['user_data']['id'])->update([
  53. 'affiliated_bank' =>$param['affiliated_bank'],
  54. 'account_holder' =>$param['account_holder'],
  55. 'card_number' =>$param['card_number'],
  56. 'o_affiliated_bank' =>$data->affiliated_bank,
  57. 'o_account_holder' =>$data->account_holder,
  58. 'o_card_number' =>$data->o_card_number,
  59. 'created_at' =>date('Y-m-d H:i:s'),
  60. 'updated_at' =>date('Y-m-d H:i:s'),
  61. ]);
  62. }
  63. }catch (\Throwable $exception){
  64. throw new \Exception($exception->getMessage());
  65. }
  66. return true;
  67. }
  68. }