2020_06_30_111337_change_auth_hr_verifies.php 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  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,'alias_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['alias_name']=$namePack[1];
  34. $authority->save();
  35. }
  36. }
  37. }
  38. /**
  39. * Reverse the migrations.
  40. *
  41. * @return void
  42. */
  43. public function down()
  44. {
  45. foreach ($this->addNames as $name){
  46. Authority::where('name',$name)->delete();
  47. }
  48. //改回旧的
  49. foreach ($this->changeNames as $namePack){
  50. $authority=Authority::where('name',$namePack[1])->first();
  51. $authority['name']=$namePack[0];
  52. $authority->save();
  53. }
  54. }
  55. }