WithdrawBusiness.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349
  1. <?php
  2. namespace app\business;
  3. use Illuminate\Support\Arr;
  4. use Respect\Validation\Validator;
  5. use support\Db;
  6. use support\Log;
  7. use support\Redis;
  8. class WithdrawBusiness
  9. {
  10. /** 提现
  11. * @param array $param
  12. * @return void
  13. */
  14. static public function applyfor(array $param)
  15. {
  16. try {
  17. $system = Db::table('wa_system')->first();
  18. if ($param['mold'] == 1) {
  19. throw new \Exception('提现功能暂未开放!');
  20. if (empty($system->is_money)) {
  21. throw new \Exception('提现功能暂未开放!');
  22. }
  23. if ($system->min_money > $param['money']) {
  24. throw new \Exception('最小提现金额:' . $system->min_money . '元');
  25. }
  26. } elseif ($param['mold'] == 2) {
  27. if (empty($system->is_money_one)) {
  28. throw new \Exception('兑换功能暂未开放!');
  29. }
  30. if ($system->min_money_one > $param['money']) {
  31. throw new \Exception('最小兑换金额:' . $system->min_money_one . '元');
  32. }
  33. } elseif ($param['mold'] == 3) {
  34. } elseif ($param['mold'] == 5) {
  35. } elseif ($param['mold'] == 6) {
  36. // if (empty($system->is_money_one)) {
  37. // throw new \Exception('兑换功能暂未开放!');
  38. // }
  39. if (10 > $param['money']) {
  40. throw new \Exception('最小提现金额:10USD');
  41. }
  42. } elseif ($param['mold'] == 10) {
  43. } elseif ($param['mold'] == 7) {
  44. if (empty($system->is_money_seven)) {
  45. throw new \Exception('提现功能暂未开放!');
  46. }
  47. if ($system->min_money_seven > $param['money']) {
  48. throw new \Exception('最小提现金额:' . $system->min_money_seven . '元');
  49. }
  50. } elseif ($param['mold'] == 8) {
  51. if (empty($system->is_money_eight)) {
  52. throw new \Exception('提现功能暂未开放!');
  53. }
  54. if ($system->min_money_eight > $param['money']) {
  55. throw new \Exception('最小提现金额:' . $system->min_money_eight . '元');
  56. }
  57. } elseif ($param['mold'] == 9) {
  58. if (empty($system->is_money_nine)) {
  59. throw new \Exception('提现功能暂未开放!');
  60. }
  61. if ($system->min_money_nine > $param['money']) {
  62. throw new \Exception('最小提现金额:' . $system->min_money_nine . '元');
  63. }
  64. } elseif ($param['mold'] == 11) {
  65. if (10 > $param['money']) {
  66. throw new \Exception('最小提现金额:10元');
  67. }
  68. } elseif ($param['mold'] == 12) {
  69. if (10 > $param['money']) {
  70. throw new \Exception('最小提现金额:10元');
  71. }
  72. } elseif ($param['mold'] == 55) {
  73. } elseif ($param['mold'] == 15) {
  74. if (10 > $param['money']) {
  75. throw new \Exception('最小提现金额:10元');
  76. }
  77. } elseif ($param['mold'] == 16) {
  78. if (10 > $param['money']) {
  79. throw new \Exception('最小提现金额:10元');
  80. }
  81. } elseif ($param['mold'] == 17) {
  82. if (10 > $param['money']) {
  83. throw new \Exception('最小提现金额:10元');
  84. }
  85. } elseif ($param['mold'] == 19) {
  86. if (10 > $param['money']) {
  87. throw new \Exception('最小提现金额:10元');
  88. }
  89. } elseif ($param['mold'] == 20) {
  90. if (10 > $param['money']) {
  91. throw new \Exception('最小提现金额:10元');
  92. }
  93. } elseif ($param['mold'] == 21) {
  94. if (10 > $param['money']) {
  95. throw new \Exception('最小提现金额:10元');
  96. }
  97. }elseif ($param['mold'] == 22) {
  98. if (10 > $param['money']) {
  99. throw new \Exception('最小提现金额:10元');
  100. }
  101. }elseif ($param['mold'] == 23) {
  102. // if($param['user_data']['new_is_num']<3){
  103. // throw new \Exception('邀请三人即可提现');
  104. // }
  105. if (10 > $param['money']) {
  106. throw new \Exception('最小提现金额:10元');
  107. }
  108. } else {
  109. throw new \Exception('提现功能暂未开放!');
  110. }
  111. $remarks = '';
  112. if ($param['mold'] == 2) {
  113. $status = 3;
  114. $affiliated_bank = '';
  115. $account_holder = '';
  116. $card_number = '';
  117. } elseif ($param['mold'] == 5) {
  118. $status = 3;
  119. $affiliated_bank = '';
  120. $account_holder = '';
  121. $card_number = '';
  122. } elseif ($param['mold'] == 6) {
  123. $status = 1;
  124. $affiliated_bank = '';
  125. $account_holder = '';
  126. $card_number = '';
  127. } elseif ($param['mold'] == 10) {
  128. $status = 3;
  129. $affiliated_bank = '';
  130. $account_holder = '';
  131. $card_number = '';
  132. $remarks = '全球通金卡提现申请通过,已打款';
  133. }elseif ($param['mold'] == 17) {
  134. $status = 3;
  135. $affiliated_bank = '';
  136. $account_holder = '';
  137. $card_number = '';
  138. } elseif ($param['mold'] == 1) {
  139. $status = 3;
  140. $affiliated_bank = '';
  141. $account_holder = '';
  142. $card_number = '';
  143. $userdata = Db::table('wa_users')->where('id', $param['user_data']['id'])->first();
  144. if ($userdata->money_fourteen < $param['money']) {
  145. throw new \Exception('今日提现额度不足!');
  146. }
  147. if ($userdata->money_four < $param['money']) {
  148. throw new \Exception('银行卡基础额度不足!');
  149. }
  150. } elseif ($param['mold'] == 55) {
  151. $status = 3;
  152. $affiliated_bank = '';
  153. $account_holder = '';
  154. $card_number = '';
  155. $userdata = Db::table('wa_users')->where('id', $param['user_data']['id'])->first();
  156. $money_five_value = bcmul($param['money'], $system->coin_value, 2);
  157. if ($userdata->money_thirteen < $money_five_value) {
  158. throw new \Exception('今日提现额度不足!');
  159. }
  160. if ($userdata->money_four < $money_five_value) {
  161. throw new \Exception('银行卡基础额度不足!');
  162. }
  163. } elseif ($param['mold'] == 17) {
  164. $status = 3;
  165. $affiliated_bank = '';
  166. $account_holder = '';
  167. $card_number = '';
  168. $remarks = '提现成功';
  169. } else {
  170. /** @var $bankCard 银行卡 */
  171. $bankCard = Db::table('wa_bank_card')->where('uid', $param['user_data']['id'])->first();
  172. if (empty($bankCard)) {
  173. throw new \Exception('请绑定银行卡!');
  174. }
  175. /** @var $userIdentity 实名信息 */
  176. $userIdentity = Db::table('wa_user_identity')->where('uid', $param['user_data']['id'])->first();
  177. if (empty($userIdentity)) {
  178. throw new \Exception('请实名后,在提现!');
  179. }
  180. $hasWithdraw = Db::table('wa_withdraw')
  181. ->where('type', $param['mold'])
  182. ->where('user_id', $param['user_data']['id'])
  183. ->whereBetween('created_at', [date('Y-m-d') . ' 00:00:00', date('Y-m-d') . ' 23:59:59'])->exists();
  184. if ($hasWithdraw) {
  185. throw new \Exception('今日已提现,请次日在来提现!');
  186. }
  187. $status = 1;
  188. $affiliated_bank = $bankCard->affiliated_bank;
  189. $account_holder = $bankCard->account_holder;
  190. $card_number = $bankCard->card_number;
  191. }
  192. $withdrawId = Db::table('wa_withdraw')->insertGetId([
  193. 'order_no' => date('YmdHis') . mt_rand(10000, 99999),
  194. 'user_id' => $param['user_data']['id'],
  195. 'money' => $param['money'],
  196. 'type' => $param['mold'],
  197. 'affiliated_bank' => $affiliated_bank,
  198. 'account_holder' => $account_holder,
  199. 'card_number' => $card_number,
  200. 'name' => Arr::get($param, 'name', ''),
  201. 'identity' => Arr::get($param, 'identity', ''),
  202. 'img' => !empty(Arr::get($param, 'img', '')) ? implode(',', Arr::get($param, 'img', '')) : '',
  203. 'created_at' => date('Y-m-d H:i:s'),
  204. 'updated_at' => date('Y-m-d H:i:s'),
  205. 'status' => $status,
  206. 'remarks' => $remarks
  207. ]);
  208. if ($param['mold'] == 2) {
  209. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType14, $param['mold'], moldTypefild($param['mold']), $withdrawId);
  210. StreamBusiness::addStream($param['user_data']['id'], $param['money'], streamType14, moldType3, moldTypefild3, $withdrawId);
  211. } elseif ($param['mold'] == 5) {
  212. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType24, $param['mold'], moldTypefild($param['mold']), $withdrawId);
  213. StreamBusiness::delStream($param['user_data']['id'], 100, streamType22, moldType5, moldTypefild5, $withdrawId);
  214. StreamBusiness::addStream($param['user_data']['id'], bcmul($param['money'], $system->coin_value, 2), streamType24, moldType10, moldTypefild10, $withdrawId);
  215. } elseif ($param['mold'] == 10) {
  216. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, $param['mold'], moldTypefild($param['mold']), $withdrawId);
  217. // Db::table('wa_system')->where('id',1)->increment('completion_progress',10);
  218. Db::table('wa_users')->where('id', $param['user_data']['id'])->increment('bank_money', $param['money']);
  219. StreamBusiness::addStream($param['user_data']['id'],$param['money'], streamType4, moldType3, moldTypefild3,$withdrawId);
  220. } elseif ($param['mold'] == 17) {
  221. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, $param['mold'], moldTypefild($param['mold']), $withdrawId);
  222. StreamBusiness::addStream($param['user_data']['id'], $param['money'], streamType4, moldType3, moldTypefild3, $withdrawId);
  223. } elseif ($param['mold'] == 1) {
  224. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, $param['mold'], moldTypefild($param['mold']), $withdrawId);
  225. StreamBusiness::addStream($param['user_data']['id'], $param['money'], streamType4, moldType10, moldTypefild10, $withdrawId);
  226. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, moldType4, moldTypefild4, $withdrawId);
  227. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, moldType14, moldTypefild14, $withdrawId);
  228. } elseif ($param['mold'] == 55) {
  229. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, moldType5, moldTypefild5, $withdrawId);
  230. StreamBusiness::addStream($param['user_data']['id'], bcmul($param['money'], $system->coin_value, 2), streamType4, moldType10, moldTypefild10, $withdrawId);
  231. StreamBusiness::delStream($param['user_data']['id'], bcmul($param['money'], $system->coin_value, 2), streamType4, moldType4, moldTypefild4, $withdrawId);
  232. StreamBusiness::delStream($param['user_data']['id'], bcmul($param['money'], $system->coin_value, 2), streamType4, moldType13, moldTypefild13, $withdrawId);
  233. } else {
  234. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType4, $param['mold'], moldTypefild($param['mold']), $withdrawId);
  235. }
  236. } catch (\Throwable $exception) {
  237. throw new \Exception($exception->getMessage());
  238. }
  239. return true;
  240. }
  241. /** 提现流水
  242. * @param array $param
  243. * @return void
  244. */
  245. static public function stream(array $param)
  246. {
  247. try {
  248. $data = Db::table('wa_withdraw')
  249. ->where(function ($query) use ($param) {
  250. if (!empty(Arr::get($param, 'mold'))) {
  251. if($param['mold']==111){
  252. $query->whereIn('type', [10, 16, 17, 18]);
  253. }elseif ($param['mold']==222){
  254. $query->whereIn('type', [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 19, 55]);
  255. }else{
  256. $query->where('type', $param['mold']);
  257. }
  258. }
  259. })->where('money','>',0)
  260. ->where('user_id', $param['user_data']['id'])
  261. ->orderByDesc('id')
  262. ->paginate(Arr::get($param, 'limit', 10), ['*'], 'page', Arr::get($param, 'page'))
  263. ->toArray();
  264. foreach ($data['data'] as $k => $v) {
  265. $is_buy_tuikuianll = Db::table('wa_payorder')
  266. ->where('user_id', $param['user_data']['id'])
  267. ->where('is_pay', 2)
  268. ->where('goods_type', 15)
  269. ->exists();
  270. $jieshutime = strtotime(date('Y-m-23',time()));
  271. if(!$is_buy_tuikuianll && $jieshutime<time()){
  272. $data['data'][$k]->new_state = 3;
  273. }
  274. $data['data'][$k]->mold_name = moldType($v->type);
  275. }
  276. } catch (\Throwable $exception) {
  277. throw new \Exception($exception->getMessage());
  278. }
  279. return $data;
  280. }
  281. /** 转账至五行银行卡
  282. * @param array $param
  283. * @return void
  284. */
  285. static public function transfer_accounts(array $param)
  286. {
  287. try {
  288. $system = Db::table('wa_system')->first();
  289. if ($param['mold'] != 2) {
  290. throw new \Exception('转账至五行银行卡暂未开放!');
  291. }
  292. $param['mold'] = 5;
  293. /** @var $bankCard 银行卡 */
  294. $bankCard = Db::table('wa_user_social_cark')->where('user_id', $param['user_data']['id'])->first();
  295. if (empty($bankCard)) {
  296. throw new \Exception('请先领取五行银行卡!');
  297. }
  298. /** @var $userIdentity 实名信息 */
  299. $userIdentity = Db::table('wa_user_identity')->where('uid', $param['user_data']['id'])->first();
  300. if (empty($userIdentity)) {
  301. throw new \Exception('请实名后,在转入!');
  302. }
  303. if (empty($system->conversion_value_cost)) {
  304. throw new \Exception('暂时不能转入!');
  305. }
  306. //五行银行卡余额变更
  307. $money = bcmul($param['money'], $system->conversion_value_cost, 2);
  308. Db::table('wa_user_social_cark')->where('user_id', $param['user_data']['id'])->increment('money', $money);
  309. //转账到五行银行卡余额
  310. StreamBusiness::addStream($param['user_data']['id'], $money, streamType14, moldType4, moldTypefild4);
  311. //减少股票账户
  312. StreamBusiness::delStream($param['user_data']['id'], $param['money'], streamType14, $param['mold'], moldTypefild($param['mold']), $param['user_data']['id']);
  313. } catch (\Throwable $exception) {
  314. throw new \Exception($exception->getMessage());
  315. }
  316. return true;
  317. }
  318. }