updateTextToJson.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Models\ReferralApply;
  4. use App\Models\RuleGroup;
  5. use App\Models\UserGroup;
  6. use Illuminate\Console\Command;
  7. use Log;
  8. class updateTextToJson extends Command {
  9. protected $signature = 'updateTextToJson';
  10. protected $description = '转换原有数列至新数列';
  11. public function handle(): void {
  12. Log::info('----------------------------【数据转换】开始----------------------------');
  13. foreach(ReferralApply::all() as $referralApply){
  14. $referralApply->link_logs = $this->convertToJson($referralApply->getRawOriginal ('link_logs'));
  15. $referralApply->save();
  16. }
  17. Log::info('转换返利表完成');
  18. foreach(UserGroup::all() as $userGroup){
  19. $userGroup->nodes = $this->convertToJson($userGroup->getRawOriginal ('nodes'));
  20. $userGroup->save();
  21. }
  22. Log::info('转换用户分组表完成');
  23. foreach(RuleGroup::all() as $ruleGroup){
  24. $ruleGroup->rules = $this->convertToJson($ruleGroup->getRawOriginal ('rules'));
  25. $ruleGroup->nodes = $this->convertToJson($ruleGroup->getRawOriginal ('nodes'));
  26. $ruleGroup->save();
  27. }
  28. Log::info('转换审核规则表完成');
  29. Log::info('----------------------------【数据转换】结束----------------------------');
  30. }
  31. private function convertToJson($string): array {
  32. return explode(',', $string);
  33. }
  34. }