2020_06_30_111337_change_auth_hr_verifies.php 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <?php
  2. use App\Authority;
  3. use App\Unit;
  4. use Illuminate\Support\Facades\Schema;
  5. use Illuminate\Database\Schema\Blueprint;
  6. use Illuminate\Database\Migrations\Migration;
  7. class ChangeAuthHrVerifies extends Migration
  8. {
  9. protected $addNames=[
  10. '人事管理-组长审核',
  11. ];
  12. protected $changeNames=[
  13. ['人事管理-审核','人事管理-门卫审核'],
  14. ];
  15. /**
  16. * Run the migrations.
  17. *
  18. * @return void
  19. */
  20. public function up()
  21. {
  22. Authority::where('name','人事管理-门卫审核')->first();
  23. foreach ($this->addNames as $namePack){
  24. if(!Authority::where('name',$namePack)->first())(new Authority(['name'=>$namePack]))->save();
  25. }
  26. //修改或没有则添加
  27. foreach ($this->changeNames as $namePack){
  28. $authority=Authority::where('name',$namePack[0])->orWhere('name',$namePack[1])->first();
  29. if(!$authority){
  30. (new Authority(['name'=>$namePack[1],'alias_name'=>$namePack[1]]))->save();
  31. }elseif($authority['name']==$namePack[0]){
  32. $authority['name']=$namePack[1];
  33. $authority->save();
  34. }
  35. }
  36. }
  37. /**
  38. * Reverse the migrations.
  39. *
  40. * @return void
  41. */
  42. public function down()
  43. {
  44. foreach ($this->addNames as $name){
  45. Authority::where('name',$name)->delete();
  46. }
  47. //改回旧的
  48. foreach ($this->changeNames as $namePack){
  49. $authority=Authority::where('name',$namePack[1])->first();
  50. $authority['name']=$namePack[0];
  51. $authority->save();
  52. }
  53. }
  54. }