PaymentChannelOptionsTest.php 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779
  1. <?php
  2. namespace Tests\Integration;
  3. use App\Http\Controllers\admin\PaymentConfiguration;
  4. use App\Http\Controllers\admin\RechargeChannel;
  5. use App\Http\Controllers\admin\PaymentCompany;
  6. use App\Services\PaymentChannelLinkService;
  7. use App\Services\Payment\RechargeChannelConfigurationService;
  8. use App\Models\PaymentGateway;
  9. use App\Models\RechargeChannel as ChannelModel;
  10. use App\Services\Payment\PaymentProviderService;
  11. use App\Services\PaymentOrderService;
  12. use Illuminate\Config\Repository;
  13. use Illuminate\Database\Capsule\Manager;
  14. use Illuminate\Database\Schema\Blueprint;
  15. use Illuminate\Foundation\Application;
  16. use Illuminate\Http\JsonResponse;
  17. use Illuminate\Http\Request;
  18. use Illuminate\Support\Facades\DB;
  19. use Illuminate\Support\Facades\Facade;
  20. use Illuminate\Translation\ArrayLoader;
  21. use Illuminate\Translation\Translator;
  22. use Illuminate\Validation\Factory;
  23. use PHPUnit\Framework\TestCase;
  24. class PaymentChannelOptionsTest extends TestCase
  25. {
  26. private Application $app;
  27. protected function setUp(): void
  28. {
  29. Facade::clearResolvedInstances();
  30. $this->app = new Application(dirname(__DIR__, 2));
  31. $this->app->instance('config', new Repository(['app' => ['locale' => 'zh']]));
  32. Facade::setFacadeApplication($this->app);
  33. $db = new Manager($this->app);
  34. $db->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'prefix' => 'bot_']);
  35. $db->setAsGlobal();
  36. $db->bootEloquent();
  37. $this->app->instance('db', $db->getDatabaseManager());
  38. $this->app->bind('db.schema', fn () => $db->schema());
  39. $translator = new Translator(new ArrayLoader(), 'zh');
  40. $this->app->instance('translator', $translator);
  41. $this->app->instance('validator', new Factory($translator, $this->app));
  42. $this->app->instance(\Illuminate\Contracts\Routing\ResponseFactory::class, new \Tests\Support\JsonResponseFactory());
  43. Request::macro('validate', function (array $rules) {
  44. return app('validator')->make($this->all(), $rules)->validate();
  45. });
  46. $db->schema()->create('recharge_channel', function (Blueprint $t) {
  47. $t->id(); $t->integer('from'); $t->integer('data_type'); $t->string('key');
  48. $t->string('name'); $t->string('type'); $t->decimal('rate', 8, 4);
  49. $t->decimal('min')->nullable(); $t->decimal('max')->nullable(); $t->string('fixed')->nullable();
  50. $t->integer('status'); $t->integer('sort'); $t->timestamps();
  51. });
  52. $db->schema()->create('recharge_channel_group', function (Blueprint $t) {
  53. $t->id(); $t->string('name'); $t->text('recharge_type')->nullable();
  54. $t->text('withdraw_type')->nullable(); $t->text('activity_type')->nullable(); $t->timestamps();
  55. });
  56. $fixture = require dirname(__DIR__) . '/fixtures/payment_provider_channels.php';
  57. DB::table('recharge_channel')->insert($fixture['channels']);
  58. DB::table('recharge_channel_group')->insert($fixture['groups']);
  59. (require dirname(__DIR__, 2) . '/database/migrations/2026_09_08_160000_add_payment_provider_status_and_channel_soft_deletes.php')->up();
  60. (require dirname(__DIR__, 2) . '/database/migrations/2026_09_08_170000_add_soft_deletes_to_recharge_channel_groups.php')->up();
  61. (require dirname(__DIR__, 2) . '/database/migrations/2026_10_28_150000_add_recharge_channel_logo.php')->up();
  62. (require dirname(__DIR__, 2) . '/database/migrations/2026_10_28_160000_create_recharge_method_logos.php')->up();
  63. $db->schema()->create('operation_audits', function (Blueprint $t) {
  64. $t->id(); $t->string('resource_type'); $t->unsignedBigInteger('resource_id')->nullable();
  65. $t->string('action'); $t->json('changes'); $t->unsignedBigInteger('operator_id')->nullable();
  66. $t->string('operator_name'); $t->timestamp('created_at')->useCurrent();
  67. });
  68. }
  69. protected function tearDown(): void
  70. {
  71. DB::disconnect();
  72. Facade::clearResolvedInstances();
  73. parent::tearDown();
  74. }
  75. private function request(string $path, array $params): void
  76. {
  77. $this->app->instance('request', Request::create($path, 'GET', $params));
  78. }
  79. private function channelList(array $params): array
  80. {
  81. $this->request('/admin/rechargeChannel/list', $params);
  82. $response = (new RechargeChannel())->list()->getData(true);
  83. $this->assertSame(0, $response['code']);
  84. return $response['data'];
  85. }
  86. public function test_sanjin_fixed_amounts_accept_list_roundtrip_without_any_minimum_or_maximum(): void
  87. {
  88. $params = ['id' => 10, 'data_type' => 1, 'payment_company' => 'sanjin', 'type' => 'zfbge', 'rate' => '0.027'];
  89. $result = $this->saveChannel($params + ['fixed' => [945, '988.00000000', 990, 945], 'min' => 'not applicable', 'max' => ['unused']]);
  90. $this->assertSame(0, $result['code'], $result['msg']);
  91. $row = ChannelModel::find(10);
  92. $this->assertSame(['945', '988', '990'], $row->fixed);
  93. $this->assertNull($row->min); $this->assertNull($row->max);
  94. $result = $this->saveChannel($params + ['fixed' => $row->fixed]);
  95. $this->assertSame(0, $result['code'], $result['msg']);
  96. $this->assertSame(0, $this->saveChannel($params + ['fixed' => '100, 200.50'])['code']);
  97. $this->assertSame(['100', '200.50'], ChannelModel::find(10)->fixed);
  98. $this->assertSame(0, $this->saveChannel($params)['code']);
  99. $this->assertSame(['100', '200.50'], ChannelModel::find(10)->fixed);
  100. $created = $this->saveChannel($this->newChannel(['payment_company' => 'sanjin', 'type' => 'zfbge', 'key' => 'fixed-test', 'fixed' => ['300', '500']]));
  101. $this->assertSame(0, $created['code'], $created['msg']);
  102. $new = ChannelModel::where('key', 'fixed-test')->first();
  103. $this->assertNull($new->min); $this->assertNull($new->max);
  104. $this->assertSame(['300', '500'], $new->fixed);
  105. }
  106. public function test_fixed_amount_validation_and_other_channel_range_validation_remain_independent(): void
  107. {
  108. $params = ['id' => 10, 'data_type' => 1, 'payment_company' => 'sanjin', 'type' => 'zfbge', 'rate' => '0.027'];
  109. $before = DB::table('recharge_channel')->where('id', 10)->first();
  110. foreach ([null, [], '', [0], [-1], ['1.234'], [['invalid']], ['key' => 100], 'abc'] as $fixed) {
  111. $this->assertSame(-3, $this->saveChannel($params + ['fixed' => $fixed])['code']);
  112. $this->assertEquals($before, DB::table('recharge_channel')->where('id', 10)->first());
  113. }
  114. $badRange = $this->saveChannel(['id' => 2, 'data_type' => 1, 'payment_company' => 'sanjin', 'type' => 'wxsm', 'rate' => '0.01', 'min' => 100, 'max' => 50]);
  115. $this->assertSame(-3, $badRange['code']);
  116. try {
  117. (new RechargeChannelConfigurationService())->save($params + ['fixed' => [], 'min' => 1, 'max' => 2]);
  118. $this->fail('Invalid direct-service fixed amounts accepted');
  119. } catch (\Illuminate\Validation\ValidationException $e) { $this->assertArrayHasKey('fixed', $e->errors()); }
  120. }
  121. public function test_logo_options_include_every_payment_method_even_without_enabled_or_existing_channels(): void
  122. {
  123. $this->request('/admin/rechargeChannel/saveLogo', []);
  124. $service = new \App\Services\Payment\RechargeChannelLogoService();
  125. DB::table('recharge_channel')->where('data_type', 1)->update(['status' => 0]);
  126. DB::table('payment_providers')->update(['status' => 0]);
  127. $options = $service->options();
  128. $this->assertSame(13, $options['total']);
  129. $rows = array_column($options['data'], null, 'channel_type');
  130. foreach (['wxsm','ylsm','szrmb','zfbsm','zfbge','zfbzk','sdjt','JDpay','NOpay12','NOpay13','ZIMUpay','usdt','rgcz'] as $type) {
  131. $this->assertArrayHasKey($type, $rows);
  132. }
  133. $this->assertSame('三斤支付 / 微信扫码', $rows['wxsm']['channel_name']);
  134. DB::table('recharge_channel')->delete(); DB::table('recharge_channel_group')->delete();
  135. $this->assertSame(13, $service->options()['total']);
  136. $result = $service->save(['channel_type' => 'wxsm', 'logo' => 'https://cdn.example.test/wx.png']);
  137. $this->assertSame('https://cdn.example.test/wx.png', $result['logo']);
  138. $this->assertSame(0, DB::table('recharge_channel')->count());
  139. $this->assertSame('https://cdn.example.test/wx.png', array_column($service->options()['data'], null, 'channel_type')['wxsm']['logo']);
  140. $this->assertSame('', $service->save(['channel_type' => 'wxsm', 'logo' => null])['logo']);
  141. $this->request('/admin/rechargeChannel/logoOptions', []);
  142. $this->assertSame(13, (new RechargeChannel())->logoOptions($service)->getData(true)['data']['total']);
  143. $router = new \Illuminate\Routing\Router(new \Illuminate\Events\Dispatcher($this->app), $this->app);
  144. $this->app->instance('router', $router);
  145. $router->group(['prefix' => 'admin'], function () { require dirname(__DIR__, 2) . '/routes/admin.php'; });
  146. foreach (['logoOptions' => ['GET', 'admin/rechargeChannel/list'], 'saveLogo' => ['POST', 'admin/rechargeChannel/update']] as $path => [$method, $permission]) {
  147. $route = $router->getRoutes()->match(Request::create('/admin/rechargeChannel/' . $path, $method));
  148. $this->assertSame($permission, $route->defaults['permission_uri']);
  149. $this->assertContains('admin.jwt', $route->middleware()); $this->assertContains('check.button.uri', $route->middleware());
  150. }
  151. try { $service->save(['channel_type' => 'DF001', 'logo' => '/a.png']); $this->fail('Withdrawal-only method accepted'); }
  152. catch (\Illuminate\Validation\ValidationException $e) { $this->assertArrayHasKey('channel_type', $e->errors()); }
  153. }
  154. public function test_logo_preconfiguration_is_inherited_by_later_channels_and_migration_retains_old_uploads(): void
  155. {
  156. $this->request('/admin/rechargeChannel/saveLogo', []);
  157. $migration = require dirname(__DIR__, 2) . '/database/migrations/2026_10_28_160000_create_recharge_method_logos.php';
  158. $migration->down();
  159. DB::table('recharge_channel')->where('id', 2)->update(['logo' => '/storage/wx.png']);
  160. $migration->up();
  161. $this->assertSame('/storage/wx.png', DB::table('recharge_method_logos')->where('channel_type', 'wxsm')->value('logo'));
  162. DB::table('recharge_channel')->where('type', 'JDpay')->where('data_type', 1)->delete();
  163. $service = new \App\Services\Payment\RechargeChannelLogoService();
  164. $service->save(['channel_type' => 'JDpay', 'logo' => 'https://cdn.example.test/jd.png']);
  165. $body = $this->saveChannel($this->newChannel(['payment_company' => 'jd', 'type' => 'JDpay']));
  166. $this->assertSame(0, $body['code'], $body['msg']);
  167. $this->assertSame('https://cdn.example.test/jd.png', \App\Models\RechargeChannel::where('data_type', 1)->where('type', 'JDpay')->first()->logo);
  168. }
  169. public function test_deposit_logos_upload_save_share_by_method_and_can_be_cleared(): void
  170. {
  171. $this->app['config']->set('app.url', 'https://admin.example.test');
  172. $before = DB::table('recharge_channel')->where('id', 24)->first();
  173. $this->assertSame(0, $this->saveChannel(['id' => 24, 'data_type' => 1, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.01', 'logo' => '/storage/images/jd.png'])['code']);
  174. $row = \App\Models\RechargeChannel::find(24);
  175. $this->assertSame('https://admin.example.test/storage/images/jd.png', $row->logo);
  176. $this->assertSame((string)$before->type, $row->type);
  177. $this->assertSame(0, $this->saveChannel($this->newChannel(['data_type' => 1, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.02']))['code']);
  178. $peers = \App\Models\RechargeChannel::where('data_type', 1)->where('type', 'JDpay')->get();
  179. $this->assertCount(2, $peers);
  180. foreach ($peers as $peer) $this->assertSame($row->logo, $peer->logo);
  181. $this->assertSame(0, $this->saveChannel(['id' => 24, 'data_type' => 1, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.01', 'logo' => 'https://cdn.example.test/jd.webp'])['code']);
  182. foreach (\App\Models\RechargeChannel::where('data_type', 1)->where('type', 'JDpay')->get() as $peer) $this->assertSame('https://cdn.example.test/jd.webp', $peer->logo);
  183. $this->assertSame(0, $this->saveChannel(['id' => 24, 'data_type' => 1, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.01', 'logo' => null])['code']);
  184. foreach (\App\Models\RechargeChannel::where('data_type', 1)->where('type', 'JDpay')->get() as $peer) $this->assertSame('', $peer->logo);
  185. foreach (['javascript:alert(1)', '//evil.test/a.png', ['bad']] as $logo) {
  186. $this->assertSame(-3, $this->saveChannel(['id' => 24, 'data_type' => 1, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.01', 'logo' => $logo])['code']);
  187. }
  188. }
  189. public function test_withdraw_logos_upload_save_share_by_method_and_list_returns_logo(): void
  190. {
  191. $this->app['config']->set('app.url', 'https://admin.example.test');
  192. $this->assertSame(0, $this->saveChannel(['id' => 25, 'data_type' => 2, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.01', 'logo' => '/storage/images/jd-withdraw.png'])['code']);
  193. $row = \App\Models\RechargeChannel::find(25);
  194. $this->assertSame('https://admin.example.test/storage/images/jd-withdraw.png', $row->logo);
  195. $deposit = \App\Models\RechargeChannel::find(24);
  196. $this->assertSame('', $deposit->logo);
  197. $this->assertSame(0, $this->saveChannel($this->newChannel(['data_type' => 2, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.02', 'key' => 'withdraw-peer']))['code']);
  198. foreach (\App\Models\RechargeChannel::where('data_type', 2)->where('type', 'JDpay')->get() as $peer) {
  199. $this->assertSame($row->logo, $peer->logo);
  200. }
  201. $listRow = $this->channelList(['data_type' => '2', 'payment_company' => 'jd'])['data'][0];
  202. $this->assertArrayHasKey('logo', $listRow);
  203. $this->assertSame('https://admin.example.test/storage/images/jd-withdraw.png', $listRow['logo']);
  204. $formatted = array_column(\App\Models\RechargeChannel::getFormatChannel(2, 1), null, 'value');
  205. $this->assertSame('https://admin.example.test/storage/images/jd-withdraw.png', $formatted['JDpay']['logo'] ?? '');
  206. $this->assertSame('', array_column(\App\Models\RechargeChannel::getFormatChannel(1, 1), null, 'value')['JDpay']['logo'] ?? 'x');
  207. $this->assertSame(0, $this->saveChannel(['id' => 25, 'data_type' => 2, 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.01', 'logo' => null])['code']);
  208. foreach (\App\Models\RechargeChannel::where('data_type', 2)->where('type', 'JDpay')->get() as $peer) {
  209. $this->assertSame('', $peer->logo);
  210. }
  211. }
  212. public function test_company_options_use_all_rows_not_first_page(): void
  213. {
  214. $page1 = $this->channelList(['data_type' => '1']);
  215. $this->assertSame(19, $page1['total']);
  216. $this->assertCount(15, $page1['data']);
  217. $this->assertNotContains('jd', array_column($page1['data'], 'payment_company'));
  218. $page2 = $this->channelList(['data_type' => '1', 'page' => 2]);
  219. $this->assertSame(['zimu', 'no', 'no', 'jd'], array_column($page2['data'], 'payment_company'));
  220. $this->request('/admin/paymentConfig/options', ['kind' => 'deposit']);
  221. $data = (new PaymentConfiguration(new PaymentChannelLinkService()))->options()->getData(true);
  222. $this->assertSame(0, $data['code']);
  223. $this->assertSame([false, false, false, false], array_column($data['data']['payment_companies'], 'disabled'));
  224. }
  225. public function test_channel_list_displays_provider_separately_from_channel_name(): void
  226. {
  227. $data = $this->channelList(['data_type' => '1', 'payment_company' => 'jd']);
  228. $this->assertSame(1, $data['total']);
  229. $this->assertSame('JD钱包', $data['data'][0]['name']);
  230. $this->assertSame('JD支付', $data['data'][0]['payment_company_label']);
  231. $this->assertSame(1, $data['data'][0]['from']);
  232. $this->assertSame(24, $data['data'][0]['id']);
  233. $withdraw = $this->channelList(['data_type' => '2', 'payment_company' => 'jd']);
  234. $this->assertSame(25, $withdraw['data'][0]['id']);
  235. $this->assertSame(0, $this->channelList(['data_type' => '2', 'payment_company' => 'sanjin'])['total']);
  236. }
  237. public function test_missing_group_returns_reason_without_enabling_or_rewriting_config(): void
  238. {
  239. DB::table('recharge_channel_group')->update(['recharge_type' => 'wxsm,zfbsm']);
  240. $this->request('/admin/paymentConfig/options', ['kind' => 'deposit']);
  241. $data = (new PaymentConfiguration(new PaymentChannelLinkService()))->options()->getData(true)['data'];
  242. $this->assertSame([false, true, true, true], array_column($data['payment_companies'], 'disabled'));
  243. $this->assertSame(['', 'group_missing', 'group_missing', 'group_missing'], array_column($data['payment_companies'], 'disabled_reason_code'));
  244. $this->assertSame('wxsm,zfbsm', DB::table('recharge_channel_group')->value('recharge_type'));
  245. $this->assertSame(0, DB::table('recharge_channel')->where('id', 31)->value('status'));
  246. }
  247. public function test_group_editor_options_include_new_types_even_before_any_group_uses_them(): void
  248. {
  249. DB::table('recharge_channel_group')->update(['recharge_type' => 'wxsm', 'withdraw_type' => 'DF001']);
  250. $this->request('/admin/rechargeChannel/getChannel', ['data_type' => 1]);
  251. $response = (new RechargeChannel())->getChannel()->getData(true);
  252. $this->assertSame(0, $response['code']);
  253. $names = array_column($response['data']['data'], 'name', 'type');
  254. $this->assertSame('JD钱包', $names['JDpay']);
  255. $this->assertSame('NO快捷充值-扫码支付', $names['NOpay12']);
  256. $this->assertSame('NO快捷充值-余额支付', $names['NOpay13']);
  257. $this->assertSame('808充值', $names['ZIMUpay']);
  258. $this->assertSame(13, $response['data']['total']);
  259. $this->request('/admin/rechargeChannel/getChannel', ['data_type' => 2]);
  260. $names = array_column((new RechargeChannel())->getChannel()->getData(true)['data']['data'], 'name', 'type');
  261. $this->assertSame('JD钱包', $names['JDpay']);
  262. $this->assertSame('NO快捷提现', $names['NOwithdraw']);
  263. $this->assertSame('808账户提现', $names['ZIMUwithdraw']);
  264. $this->assertArrayNotHasKey('ZIMUcash', $names);
  265. $this->assertSame('wxsm', DB::table('recharge_channel_group')->value('recharge_type'));
  266. }
  267. private function formOptions(int $dataType = 1, ?int $id = null): array
  268. {
  269. $this->request('/admin/rechargeChannel/options', ['data_type' => $dataType] + ($id ? ['id' => $id] : []));
  270. $response = (new RechargeChannel())->options(new RechargeChannelConfigurationService())->getData(true);
  271. $this->assertSame(0, $response['code']);
  272. return $response['data'];
  273. }
  274. private function saveChannel(array $params): array
  275. {
  276. $this->app->instance('request', Request::create('/admin/rechargeChannel/update', 'POST', $params));
  277. return (new RechargeChannel())->update(new RechargeChannelConfigurationService())->getData(true);
  278. }
  279. private function newChannel(array $overrides = []): array
  280. {
  281. return $overrides + ['data_type' => 1, 'payment_company' => 'no', 'type' => 'NOpay12',
  282. 'rate' => '0.0300', 'name' => '测试通道', 'key' => 'test-key', 'min' => 1, 'max' => 100];
  283. }
  284. public function test_creation_catalog_works_without_any_database_channels_or_groups(): void
  285. {
  286. DB::table('recharge_channel')->delete();
  287. DB::table('recharge_channel_group')->delete();
  288. $data = $this->formOptions();
  289. $this->assertSame(['sanjin', 'jd', 'no', 'zimu'], array_column($data['payment_companies'], 'value'));
  290. $this->assertTrue($data['identity_editable']);
  291. $this->assertSame('', $data['identity_edit_reason']);
  292. $this->assertContains('NOpay12', array_column($data['types'], 'value'));
  293. $this->assertSame(['qianbao', 'jd', 'no', 'zimu'], array_column($this->formOptions(2)['payment_companies'], 'value'));
  294. $this->assertSame([], $this->formOptions(3)['payment_companies']);
  295. }
  296. public function test_create_selected_company_then_switch_company_and_type_on_same_record(): void
  297. {
  298. $result = $this->saveChannel($this->newChannel());
  299. $this->assertSame(0, $result['code']);
  300. $this->assertSame([], $result['data']);
  301. $row = DB::table('recharge_channel')->where('key', 'test-key')->first();
  302. $this->assertSame(1, $row->from);
  303. $this->assertSame(1, $row->status);
  304. $this->assertSame(0, $row->sort);
  305. $result = $this->saveChannel(['id' => $row->id, 'data_type' => 1,
  306. 'payment_company' => 'jd', 'type' => 'JDpay', 'rate' => '0.02']);
  307. $this->assertSame(0, $result['code']);
  308. $data = $this->channelList(['data_type' => '1', 'key' => 'test-key'])['data'][0];
  309. $this->assertSame($row->id, $data['id']);
  310. $this->assertSame('jd', $data['payment_company']);
  311. $this->assertSame('JD支付 / 测试通道', $data['display_name']);
  312. }
  313. public function test_invalid_company_type_or_source_is_rejected_without_writing(): void
  314. {
  315. $before = DB::table('recharge_channel')->count();
  316. foreach ([
  317. ['payment_company' => 'jd', 'type' => 'NOpay12'],
  318. ['payment_company' => 'no', 'type' => '12'],
  319. ['payment_company' => 'no', 'type' => 'usdt'],
  320. ['payment_company' => 'no', 'from' => 2],
  321. ['payment_company' => 'sanjin', 'type' => 'DF001', 'data_type' => 2],
  322. ] as $override) {
  323. $this->assertSame(-3, $this->saveChannel($this->newChannel($override))['code']);
  324. }
  325. $this->assertSame($before, DB::table('recharge_channel')->count());
  326. }
  327. public function test_native_and_activity_channels_do_not_require_or_fabricate_company(): void
  328. {
  329. foreach ([[1, 'usdt', 2], [1, 'rgcz', 3], [2, 'rgtx', 3], [3, 'recharge', 1]] as [$direction, $type, $from]) {
  330. $result = $this->saveChannel($this->newChannel(['payment_company' => null, 'data_type' => $direction,
  331. 'type' => $type, 'key' => 'local-' . $type]));
  332. $this->assertSame(0, $result['code']);
  333. $row = $this->channelList(['key' => 'local-' . $type])['data'][0];
  334. $this->assertSame($from, $row['from']);
  335. $this->assertNull($row['payment_company']);
  336. $this->assertSame('测试通道', $row['display_name']);
  337. }
  338. }
  339. public function test_existing_valid_clients_can_omit_derived_company_and_from(): void
  340. {
  341. $params = $this->newChannel();
  342. unset($params['payment_company']);
  343. $this->assertSame(0, $this->saveChannel($params)['code']);
  344. $row = $this->channelList(['key' => 'test-key'])['data'][0];
  345. $this->assertSame('no', $row['payment_company']);
  346. $this->assertSame(1, $row['from']);
  347. }
  348. public function test_linked_channel_locks_identity_but_keeps_regular_edit_available(): void
  349. {
  350. DB::connection()->getSchemaBuilder()->create('payment_gateways', function (Blueprint $t) {
  351. $t->id(); $t->unsignedBigInteger('recharge_channel_id'); $t->softDeletes();
  352. });
  353. DB::table('payment_gateways')->insert(['recharge_channel_id' => 24]);
  354. $options = $this->formOptions(1, 24);
  355. $this->assertFalse($options['identity_editable']);
  356. $this->assertNotSame('', $options['identity_edit_reason']);
  357. $result = $this->saveChannel(['id' => 24, 'data_type' => 1, 'payment_company' => 'no',
  358. 'type' => 'NOpay12', 'rate' => '0.01']);
  359. $this->assertSame(-3, $result['code']);
  360. $this->assertSame('JDpay', DB::table('recharge_channel')->where('id', 24)->value('type'));
  361. $result = $this->saveChannel(['id' => 24, 'data_type' => 1, 'payment_company' => 'jd',
  362. 'type' => 'JDpay', 'rate' => '0.01', 'name' => 'JD新名称']);
  363. $this->assertSame(0, $result['code']);
  364. DB::table('payment_gateways')->update(['deleted_at' => now()]);
  365. $this->assertTrue($this->formOptions(1, 24)['identity_editable']);
  366. $this->assertSame(0, $this->saveChannel(['id' => 24, 'data_type' => 1,
  367. 'payment_company' => 'no', 'type' => 'NOpay12', 'rate' => '0.01'])['code']);
  368. }
  369. public function test_switching_company_does_not_rewrite_group_permissions(): void
  370. {
  371. $groups = DB::table('recharge_channel_group')->orderBy('id')->get()->toJson();
  372. $this->assertSame(0, $this->saveChannel(['id' => 24, 'data_type' => 1,
  373. 'payment_company' => 'no', 'type' => 'NOpay12', 'rate' => '0.01'])['code']);
  374. $this->assertSame($groups, DB::table('recharge_channel_group')->orderBy('id')->get()->toJson());
  375. $this->assertSame(-3, $this->saveChannel(['id' => 24, 'data_type' => 2,
  376. 'payment_company' => 'no', 'type' => 'NOwithdraw', 'rate' => '0.01'])['code']);
  377. }
  378. public function test_group_option_names_include_company_without_changing_values(): void
  379. {
  380. $this->request('/admin/rechargeChannel/getChannel', ['data_type' => 1]);
  381. $rows = array_column((new RechargeChannel())->getChannel()->getData(true)['data']['data'], null, 'type');
  382. $this->assertSame('JD钱包', $rows['JDpay']['name']);
  383. $this->assertSame('jd', $rows['JDpay']['payment_company']);
  384. $this->assertSame('JD支付 / JD钱包', $rows['JDpay']['display_name']);
  385. $this->assertSame('USDT充值', $rows['usdt']['display_name']);
  386. }
  387. public function test_merchant_save_rechecks_channel_identity_inside_transaction(): void
  388. {
  389. DB::table('recharge_channel')->where('id', 26)->update(['type' => 'JDpay']);
  390. $this->request('/admin/paymentConfig/gateways/save', []);
  391. $controller = new PaymentConfiguration(new PaymentChannelLinkService());
  392. $method = new \ReflectionMethod($controller, 'saveModel');
  393. $method->setAccessible(true);
  394. $this->expectException(\InvalidArgumentException::class);
  395. $this->expectExceptionMessage('支付公司与所选通道不匹配');
  396. $method->invoke($controller, PaymentGateway::class, ['kind' => 'deposit', 'recharge_channel_id' => 26,
  397. 'recharge_channel_group_ids' => [1], 'payment_company' => 'no', 'payment_method' => 'NOpay12'], 'payment_gateway');
  398. }
  399. private function setCompanyStatus(string $code, int $status): array
  400. {
  401. $this->app->instance('request', Request::create('/admin/paymentCompany/status', 'POST', ['payment_company' => $code, 'status' => $status]));
  402. return (new PaymentCompany())->status(new PaymentProviderService())->getData(true);
  403. }
  404. private function deleteChannel(int $id): array
  405. {
  406. $this->app->instance('request', Request::create('/admin/rechargeChannel/delete', 'POST', ['id' => $id]));
  407. return (new RechargeChannel())->delete(new RechargeChannelConfigurationService())->getData(true);
  408. }
  409. public function test_company_management_lists_registered_providers_and_filters_status(): void
  410. {
  411. $this->request('/admin/paymentCompany/list', []);
  412. $result = (new PaymentCompany())->list(new PaymentProviderService())->getData(true);
  413. $this->assertSame(0, $result['code']);
  414. $this->assertSame(5, $result['data']['total']);
  415. $rows = array_column($result['data']['data'], null, 'payment_company');
  416. $this->assertSame('SHA256', $rows['no']['signature_algorithm']);
  417. $this->assertSame([1, 2], $rows['no']['data_types']);
  418. $this->assertSame(3, $rows['no']['channel_count']);
  419. $this->assertSame(0, $this->setCompanyStatus('no', 0)['code']);
  420. $this->assertSame(0, $this->setCompanyStatus('no', 0)['code']);
  421. $this->assertSame(1, DB::table('operation_audits')->where('resource_type', 'payment_company')->count());
  422. $this->request('/admin/paymentCompany/list', ['status' => 0]);
  423. $this->assertSame(1, (new PaymentCompany())->list(new PaymentProviderService())->getData(true)['data']['total']);
  424. $this->assertSame(-3, $this->setCompanyStatus('unknown', 0)['code']);
  425. $this->assertSame(-3, $this->setCompanyStatus('no', 9)['code']);
  426. }
  427. public function test_company_switch_disables_options_and_runtime_without_rewriting_channels(): void
  428. {
  429. $groups = DB::table('recharge_channel_group')->get()->toJson();
  430. $this->assertSame(0, $this->setCompanyStatus('no', 0)['code']);
  431. $this->assertFalse(ChannelModel::checkRechargeChannel('NOpay12', 1));
  432. $this->assertFalse(ChannelModel::checkWithdrawChannel('NOwithdraw', 1));
  433. $this->assertNotFalse(ChannelModel::checkRechargeChannel('JDpay', 1));
  434. $this->assertNotFalse(ChannelModel::checkRechargeChannel('usdt', 1));
  435. $this->assertArrayNotHasKey('NOpay12', ChannelModel::product(1));
  436. $this->assertSame(1, DB::table('recharge_channel')->where('id', 26)->value('status'));
  437. $this->assertSame($groups, DB::table('recharge_channel_group')->get()->toJson());
  438. $this->request('/admin/paymentConfig/options', ['kind' => 'deposit']);
  439. $options = (new PaymentConfiguration(new PaymentChannelLinkService()))->options()->getData(true)['data'];
  440. $companies = array_column($options['payment_companies'], null, 'value');
  441. $this->assertSame('provider_disabled', $companies['no']['disabled_reason_code']);
  442. $this->assertFalse(array_column($options['recharge_channels'], null, 'id')[26]['selectable']);
  443. $form = $this->formOptions();
  444. $this->assertTrue(array_column($form['payment_companies'], null, 'value')['no']['disabled']);
  445. $row = $this->channelList(['data_type' => '1', 'type' => 'NOpay12'])['data'][0];
  446. $this->assertSame(1, $row['status']);
  447. $this->assertSame(0, $row['company_status']);
  448. $this->assertSame(0, $row['effective_status']);
  449. $this->assertSame(-3, $this->saveChannel($this->newChannel())['code']);
  450. $this->assertSame(0, $this->setCompanyStatus('no', 1)['code']);
  451. $this->assertNotFalse(ChannelModel::checkRechargeChannel('NOpay12', 1));
  452. }
  453. public function test_reenable_company_does_not_enable_individually_disabled_channels(): void
  454. {
  455. $this->setCompanyStatus('zimu', 0);
  456. $this->setCompanyStatus('zimu', 1);
  457. $this->assertSame(0, DB::table('recharge_channel')->where('id', 31)->value('status'));
  458. $this->assertFalse(ChannelModel::checkWithdrawChannel('ZIMUcash', 1));
  459. $this->assertNotFalse(ChannelModel::checkWithdrawChannel('ZIMUwithdraw', 1));
  460. }
  461. public function test_disabled_company_blocks_new_external_requests_before_any_wallet_or_network_work(): void
  462. {
  463. $this->setCompanyStatus('no', 0);
  464. $this->assertSame('支付公司已禁用', PaymentOrderService::createPay('test-user', 100, 'NOpay12')['text']);
  465. $this->assertSame('支付公司已禁用', PaymentOrderService::autoCreatePayout('test-user', 100, 'NOwithdraw', '', '', '')['text']);
  466. $this->assertFalse(PaymentProviderService::requestEnabled('nopay12', 1));
  467. $this->assertTrue(PaymentProviderService::requestEnabled('JDpay', 1));
  468. }
  469. public function test_delete_last_deposit_type_soft_deletes_and_cleans_only_its_group_membership(): void
  470. {
  471. $beforeWithdraw = DB::table('recharge_channel_group')->where('id', 1)->value('withdraw_type');
  472. $this->assertSame(0, $this->deleteChannel(24)['code']);
  473. $this->assertNull(ChannelModel::query()->find(24));
  474. $deleted = ChannelModel::withTrashed()->findOrFail(24);
  475. $this->assertTrue($deleted->trashed());
  476. $this->assertSame(0, (int)$deleted->status);
  477. $this->assertSame('JD钱包', $deleted->name);
  478. $types = explode(',', DB::table('recharge_channel_group')->where('id', 1)->value('recharge_type'));
  479. $this->assertNotContains('JDpay', $types);
  480. $this->assertContains('NOpay12', $types);
  481. $this->assertSame($beforeWithdraw, DB::table('recharge_channel_group')->where('id', 1)->value('withdraw_type'));
  482. $this->assertNotFalse(ChannelModel::checkWithdrawChannel('JDpay', 1));
  483. $this->assertFalse(ChannelModel::checkRechargeChannel('JDpay', 1));
  484. $this->assertSame(0, $this->deleteChannel(24)['code']);
  485. $this->assertSame(1, DB::table('operation_audits')->where('resource_type', 'recharge_channel')->count());
  486. $this->setCompanyStatus('jd', 0); $this->setCompanyStatus('jd', 1);
  487. $this->assertNull(ChannelModel::query()->find(24));
  488. }
  489. public function test_delete_one_of_several_same_type_channels_preserves_groups_until_last_removed(): void
  490. {
  491. $this->assertSame(0, $this->deleteChannel(6)['code']);
  492. $this->assertStringContainsString('zfbsm', DB::table('recharge_channel_group')->where('id', 1)->value('recharge_type'));
  493. $this->assertSame(3, ChannelModel::query()->where('data_type', 1)->where('type', 'zfbsm')->count());
  494. foreach ([7, 8, 9] as $id) $this->assertSame(0, $this->deleteChannel($id)['code']);
  495. $this->assertStringNotContainsString('zfbsm', DB::table('recharge_channel_group')->where('id', 1)->value('recharge_type'));
  496. }
  497. public function test_delete_is_blocked_by_payment_config_reference_and_does_not_touch_activity(): void
  498. {
  499. DB::connection()->getSchemaBuilder()->create('payment_gateways', function (Blueprint $t) {
  500. $t->id(); $t->unsignedBigInteger('recharge_channel_id'); $t->softDeletes();
  501. });
  502. DB::table('payment_gateways')->insert(['recharge_channel_id' => 24]);
  503. $this->assertSame(-3, $this->deleteChannel(24)['code']);
  504. $this->assertNotNull(ChannelModel::query()->find(24));
  505. $this->assertSame(-3, $this->deleteChannel(21)['code']);
  506. $this->assertNotNull(ChannelModel::query()->find(21));
  507. DB::table('payment_gateways')->update(['deleted_at' => now()]);
  508. $this->assertSame(0, $this->deleteChannel(24)['code']);
  509. }
  510. public function test_migration_retry_keeps_disabled_company_and_deleted_channel(): void
  511. {
  512. $this->setCompanyStatus('no', 0);
  513. $this->deleteChannel(24);
  514. (require dirname(__DIR__, 2) . '/database/migrations/2026_09_08_160000_add_payment_provider_status_and_channel_soft_deletes.php')->up();
  515. $this->assertSame(0, PaymentProviderService::statuses()['no']);
  516. $this->assertTrue(ChannelModel::withTrashed()->findOrFail(24)->trashed());
  517. $this->assertSame(5, DB::table('payment_providers')->count());
  518. }
  519. private function paymentOrderFixture(int $type, string $channel, int $status): \App\Models\PaymentOrder
  520. {
  521. DB::connection()->getSchemaBuilder()->create('payment_orders', function (Blueprint $t) {
  522. $t->id(); $t->integer('type'); $t->string('channel'); $t->integer('status');
  523. $t->string('order_no'); $t->string('member_id'); $t->decimal('amount', 18, 4);
  524. $t->string('state')->nullable(); $t->text('callback_data')->nullable(); $t->timestamps();
  525. });
  526. $this->app->instance('log', new class {
  527. public function channel($channel) { return $this; }
  528. public function error($message, array $context = []) {}
  529. });
  530. return \App\Models\PaymentOrder::query()->create(['type' => $type, 'channel' => $channel,
  531. 'status' => $status, 'order_no' => 'test-order', 'member_id' => 'test-user', 'amount' => 10]);
  532. }
  533. public function test_pending_payout_cannot_be_sent_after_company_disabled(): void
  534. {
  535. $order = $this->paymentOrderFixture(2, 'NOwithdraw', PaymentOrderService::STATUS_STAY);
  536. $this->setCompanyStatus('no', 0);
  537. $result = PaymentOrderService::createPayout($order->id);
  538. $this->assertSame(-3, $result['code']);
  539. $this->assertSame('支付公司已禁用', $result['msg']);
  540. $this->assertSame(PaymentOrderService::STATUS_STAY, $order->fresh()->status);
  541. }
  542. public function test_pending_payout_cannot_be_sent_after_last_channel_deleted(): void
  543. {
  544. $order = $this->paymentOrderFixture(2, 'JDpay', PaymentOrderService::STATUS_STAY);
  545. $this->assertSame(0, $this->deleteChannel(25)['code']);
  546. $result = PaymentOrderService::createPayout($order->id);
  547. $this->assertSame(-3, $result['code']);
  548. $this->assertSame('提现通道已停用或删除', $result['msg']);
  549. $this->assertSame(PaymentOrderService::STATUS_STAY, $order->fresh()->status);
  550. }
  551. public function test_existing_pay_callback_is_not_blocked_by_company_switch(): void
  552. {
  553. $order = $this->paymentOrderFixture(1, 'NOpay12', PaymentOrderService::STATUS_PROCESS);
  554. $this->setCompanyStatus('no', 0);
  555. $method = new \ReflectionMethod(PaymentOrderService::class, 'applyPayCallback');
  556. $method->setAccessible(true);
  557. $this->assertTrue($method->invoke(null, $order, '10', 'failed', 'success', 'failed', ['status' => 'failed']));
  558. $this->assertSame(PaymentOrderService::STATUS_FAIL, $order->fresh()->status);
  559. $this->assertNotNull($order->fresh()->callback_data);
  560. }
  561. public function test_company_disabled_updates_saved_gateway_effective_status(): void
  562. {
  563. $channel = ChannelModel::query()->findOrFail(26);
  564. $gateway = new PaymentGateway(['payment_company' => 'no', 'payment_method' => 'NOpay12',
  565. 'status' => 1, 'recharge_channel_group_ids' => [1]]);
  566. $gateway->setRelation('rechargeChannel', $channel);
  567. $this->setCompanyStatus('no', 0);
  568. $data = (new PaymentChannelLinkService())->formatOne($gateway);
  569. $this->assertSame(1, $data['config_status']);
  570. $this->assertSame(1, $data['channel_status']);
  571. $this->assertSame(0, $data['company_status']);
  572. $this->assertSame(0, $data['effective_status']);
  573. $this->expectException(\RuntimeException::class);
  574. $this->expectExceptionMessage('NO支付已禁用');
  575. (new PaymentChannelLinkService())->validate(26, [1], 1);
  576. }
  577. public function test_empty_group_types_can_be_saved_after_last_channel_removed(): void
  578. {
  579. $this->app->instance('request', Request::create('/admin/rechargeChannel/updateGroup', 'POST',
  580. ['id' => 1, 'name' => '全部充值', 'recharge_type' => [], 'withdraw_type' => []]));
  581. $this->assertSame(0, (new RechargeChannel())->updateGroup()->getData(true)['code']);
  582. $this->assertSame('', DB::table('recharge_channel_group')->where('id', 1)->value('recharge_type'));
  583. $this->assertSame('yuebao,old_user,recharge', DB::table('recharge_channel_group')->where('id', 1)->value('activity_type'));
  584. }
  585. private function saveGroup(array $params): array
  586. {
  587. $this->app->instance('request', Request::create('/admin/rechargeChannel/updateGroup', 'POST', $params));
  588. return (new RechargeChannel())->updateGroup()->getData(true);
  589. }
  590. private function groupPayload(int $id = 1): array
  591. {
  592. $group = DB::table('recharge_channel_group')->where('id', $id)->first();
  593. return ['id' => $id, 'name' => $group->name, 'recharge_type' => explode(',', $group->recharge_type),
  594. 'withdraw_type' => explode(',', $group->withdraw_type)];
  595. }
  596. public function test_legacy_group_can_be_saved_and_only_invalid_existing_types_are_cleaned(): void
  597. {
  598. $payload = $this->groupPayload();
  599. $result = $this->saveGroup($payload);
  600. $this->assertSame(0, $result['code']);
  601. $this->assertSame([], $result['data']);
  602. $this->assertStringContainsString('已清理', $result['msg']);
  603. $saved = $this->groupPayload();
  604. $this->assertSame(array_values(array_diff($payload['recharge_type'], ['1', '2', '3'])), $saved['recharge_type']);
  605. $this->assertSame(array_values(array_diff($payload['withdraw_type'], ['ylk', 'zfb', 'szrmb'])), $saved['withdraw_type']);
  606. $this->assertSame('yuebao,old_user,recharge', DB::table('recharge_channel_group')->where('id', 1)->value('activity_type'));
  607. $audit = DB::table('operation_audits')->where('resource_type', 'recharge_channel_group')->first();
  608. $this->assertNotNull($audit);
  609. $this->assertSame(['1', '2', '3'], json_decode($audit->changes, true)['after']['removed_types']['recharge_type']);
  610. }
  611. public function test_new_unknown_type_in_existing_group_is_rejected_atomically(): void
  612. {
  613. $payload = $this->groupPayload();
  614. $payload['recharge_type'][] = 'not_a_type';
  615. $before = DB::table('recharge_channel_group')->where('id', 1)->first();
  616. $result = $this->saveGroup($payload);
  617. $this->assertSame(-3, $result['code']);
  618. $this->assertStringContainsString('not_a_type', $result['msg']);
  619. $this->assertSame($before->recharge_type, DB::table('recharge_channel_group')->where('id', 1)->value('recharge_type'));
  620. $this->assertSame(0, DB::table('operation_audits')->count());
  621. }
  622. public function test_new_group_cannot_reuse_invalid_values_from_another_group(): void
  623. {
  624. $payload = $this->groupPayload();
  625. unset($payload['id']);
  626. $result = $this->saveGroup($payload);
  627. $this->assertSame(-3, $result['code']);
  628. $this->assertStringContainsString('1,2,3', $result['msg']);
  629. $this->assertSame(2, DB::table('recharge_channel_group')->count());
  630. }
  631. public function test_group_types_trim_deduplicate_and_keep_disabled_company_membership(): void
  632. {
  633. $this->setCompanyStatus('no', 0);
  634. $result = $this->saveGroup(['id' => 1, 'name' => '组合',
  635. 'recharge_type' => [' JDpay ', 'JDpay', ' NOpay12 '], 'withdraw_type' => [' DF001 ']]);
  636. $this->assertSame(0, $result['code']);
  637. $this->assertSame('JDpay,NOpay12', DB::table('recharge_channel_group')->where('id', 1)->value('recharge_type'));
  638. $this->assertSame('DF001', DB::table('recharge_channel_group')->where('id', 1)->value('withdraw_type'));
  639. }
  640. public function test_nested_option_objects_are_rejected_without_writing(): void
  641. {
  642. $result = $this->saveGroup(['id' => 1, 'name' => '组合',
  643. 'recharge_type' => [['type' => 'JDpay', 'name' => 'JD钱包']], 'withdraw_type' => ['DF001']]);
  644. $this->assertSame(-3, $result['code']);
  645. $this->assertStringContainsString('type', $result['msg']);
  646. $this->assertSame(0, DB::table('operation_audits')->count());
  647. }
  648. public function test_existing_deleted_type_is_removed_and_not_restored(): void
  649. {
  650. DB::table('recharge_channel')->where('id', 24)->update(['deleted_at' => now(), 'status' => 0]);
  651. $this->assertSame(0, $this->saveGroup($this->groupPayload())['code']);
  652. $saved = $this->groupPayload();
  653. $this->assertNotContains('JDpay', $saved['recharge_type']);
  654. $this->assertContains('JDpay', $saved['withdraw_type']);
  655. $this->assertTrue(ChannelModel::withTrashed()->findOrFail(24)->trashed());
  656. }
  657. private function deleteGroup(int $id): array
  658. {
  659. $this->app->instance('request', Request::create('/admin/rechargeChannel/deleteGroup', 'POST', ['id' => $id]));
  660. return (new RechargeChannel())->deleteGroup(new RechargeChannelConfigurationService())->getData(true);
  661. }
  662. public function test_unreferenced_group_can_be_soft_deleted_without_deleting_channels(): void
  663. {
  664. $count = ChannelModel::query()->count();
  665. $this->assertSame(0, $this->deleteGroup(2)['code']);
  666. $this->assertNull(\App\Models\RechargeChannelGroup::query()->find(2));
  667. $this->assertTrue(\App\Models\RechargeChannelGroup::withTrashed()->findOrFail(2)->trashed());
  668. $this->assertSame($count, ChannelModel::query()->count());
  669. $this->assertSame(0, $this->deleteGroup(2)['code']);
  670. $this->assertSame(1, DB::table('operation_audits')->where('action', 'delete')->count());
  671. $this->request('/admin/rechargeChannel/groupList', []);
  672. $this->assertSame(1, (new RechargeChannel())->groupList()->getData(true)['data']['total']);
  673. $this->assertSame(-3, $this->saveGroup(['id' => 2, 'name' => '已删除', 'recharge_type' => [], 'withdraw_type' => []])['code']);
  674. }
  675. public function test_default_group_and_member_assigned_group_cannot_be_deleted(): void
  676. {
  677. $this->assertSame(-3, $this->deleteGroup(1)['code']);
  678. $this->assertSame(-3, $this->deleteGroup(999)['code']);
  679. DB::connection()->getSchemaBuilder()->create('users', function (Blueprint $t) {
  680. $t->id(); $t->string('member_id'); $t->unsignedBigInteger('recharge_channel_group_id')->nullable(); $t->timestamps();
  681. });
  682. DB::table('users')->insert(['member_id' => 'test', 'recharge_channel_group_id' => 2]);
  683. $result = $this->deleteGroup(2);
  684. $this->assertSame(-3, $result['code']);
  685. $this->assertStringContainsString('会员', $result['msg']);
  686. $this->assertNotNull(\App\Models\RechargeChannelGroup::query()->find(2));
  687. $this->assertSame(0, DB::table('operation_audits')->count());
  688. }
  689. public function test_numeric_and_string_payment_config_group_references_block_delete(): void
  690. {
  691. DB::connection()->getSchemaBuilder()->create('payment_collection_channels', function (Blueprint $t) {
  692. $t->id(); $t->json('recharge_channel_group_ids'); $t->softDeletes();
  693. });
  694. foreach (['[2]', '["2"]', '["02"]'] as $json) {
  695. DB::table('payment_collection_channels')->delete();
  696. DB::table('payment_collection_channels')->insert(['recharge_channel_group_ids' => $json]);
  697. $result = $this->deleteGroup(2);
  698. $this->assertSame(-3, $result['code']);
  699. $this->assertStringContainsString('被支付配置引用', $result['msg']);
  700. $this->assertNotNull(\App\Models\RechargeChannelGroup::query()->find(2));
  701. }
  702. DB::table('payment_collection_channels')->update(['deleted_at' => now()]);
  703. $this->assertSame(0, $this->deleteGroup(2)['code']);
  704. }
  705. public function test_deleted_group_cannot_be_assigned_to_members_or_new_payment_config(): void
  706. {
  707. DB::connection()->getSchemaBuilder()->create('users', function (Blueprint $t) {
  708. $t->id(); $t->string('member_id'); $t->unsignedBigInteger('recharge_channel_group_id')->nullable(); $t->timestamps();
  709. });
  710. DB::table('users')->insert(['member_id' => 'test', 'recharge_channel_group_id' => 1]);
  711. $this->assertSame(0, $this->deleteGroup(2)['code']);
  712. $this->app->instance('request', Request::create('/admin/user/setRechargeChannelGroup', 'POST',
  713. ['member_id' => ['test'], 'recharge_channel_group_id' => 2]));
  714. $this->assertSame(-3, (new \App\Http\Controllers\admin\User())->setRechargeChannelGroup()->getData(true)['code']);
  715. $this->assertSame(1, DB::table('users')->where('member_id', 'test')->value('recharge_channel_group_id'));
  716. $this->expectException(\RuntimeException::class);
  717. $this->expectExceptionMessage('部分通道组合不存在');
  718. (new PaymentChannelLinkService())->validate(24, [2], 1, true);
  719. }
  720. }