Guest User

Untitled

a guest
Nov 23rd, 2017
650
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.38 KB | None | 0 0
  1. Schema::create('alunos', function (Blueprint $table) {
  2. $table->integer('id_academia')->unsigned();
  3. $table->increments('id_aluno');
  4. $table->string('id_aluno_academia', 3);
  5. $table->string('foto')->nullable();
  6. $table->string('nome');
  7. $table->string('email', 70);
  8. $table->string('celular', 16);
  9. $table->string('telefone', 16)->nullable();
  10. $table->date('data_nasc');
  11. $table->string('idade', 2);
  12. $table->string('cpf', 14);
  13. $table->string('rg', 12)->nullable();
  14. $table->boolean('sexo');
  15. $table->string('cep')->nullable();
  16. $table->string('endereco');
  17. $table->string('num_end');
  18. $table->string('bairro');
  19. $table->string('cidade', 50);
  20. $table->string('uf', 2);
  21. $table->string('plano', 1)->nullable();
  22. $table->string('tipo_pagamento', 1)->nullable();
  23. $table->string('turma', 3)->nullable();
  24. $table->string('professor', 3)->nullable();
  25. $table->string('senha')->nullable();
  26. $table->string('status', 1)->default(0);
  27. $table->date('expira')->nullable();
  28. $table->boolean('acesso')->default(0);
  29. $table->string('tipo_visita', 1)->nullable();
  30. $table->string('indicado_por', 1)->nullable();
  31. $table->string('modalidades_interesse')->nullable();
  32. $table->string('nivel_interesse')->nullable();
  33. $table->string('objetivo')->nullable();
  34. $table->text('observacoes')->nullable();
  35. $table->timestamps();
  36. $table->foreign('id_academia')->references('id_academia')->on('academias')->onDelete('cascade');
  37. });
  38.  
  39. public function run()
  40. {
  41. $nomes =
  42. [
  43. 'Felipe', 'João', 'Gabriela', 'Miguel', 'Renata', 'Juliana', 'Sintia', 'Marcos',
  44. 'Débora', 'Diego', 'Carlos', 'Fabiano', 'Maria', 'Jurema', 'Joaquim', 'Artur',
  45. 'Eduarda', 'Antonella', 'Julieta', 'Ema'
  46. ];
  47.  
  48. $sobrenomes =
  49. [
  50. 'Silva', 'Santos', 'Paz', 'Guedes', 'Silveira', 'Ribeiro', 'Magalhães', 'Garcia',
  51. 'Agostini', 'Goldmann', 'Schulz', 'Schmidt', 'Bellini'
  52. ];
  53.  
  54. $ufs =
  55. [
  56. 'AC','AL','AM','AP','BA','CE','DF','ES','GO','MA','MG','MS','MT',
  57. 'PA','PB','PE','PI','PR','RJ','RN','RO','RR','RS','SC','SE','SP','TO'
  58. ];
  59.  
  60. $emails =
  61. [
  62. '@gmail.com', '@outlook.com', '@yahoo.com', '@uol.com.br', '@msn.com', '@bol.com.br'
  63. ];
  64.  
  65. $alunos = [];
  66.  
  67. for ($i=1; $i < 2; $i++) {
  68.  
  69. for ($c=0; $c < 14; $c++) {
  70. $cpf[$c] = rand(0,9);
  71. }
  72.  
  73. for ($r=0; $r < 10; $r++) {
  74. $rg[$r] = rand(0,9);
  75. }
  76.  
  77. for ($n=0; $n < 3; $n++) {
  78. $num[$n] = rand(0,9);
  79. }
  80.  
  81. $dia = rand(1, 26);
  82. $mes = rand(1, 12);
  83. $ano = rand(2012, 2017);
  84.  
  85. $nome = $nomes[array_rand($nomes)];
  86. $sobrenome = $sobrenomes[array_rand($sobrenomes)];
  87. $email = strtolower($nome . '.' . $sobrenome).$emails[array_rand($emails)];
  88.  
  89. $expira = $ano . '-' . $mes . '-' . $dia;
  90. $sexo = rand(0,1);
  91.  
  92. $alunos =
  93. [
  94. 'id_academia' => rand(1, 10),
  95. 'id_aluno_academia' => $i,
  96. 'nome' => $nome.' '.$sobrenome,
  97. 'email' => $email,
  98. 'celular' => '(54) 9 9945-2428',
  99. 'data_nasc' => '1989-09-01',
  100. 'idade' => rand(18, 45),
  101. 'cpf' => implode('',$cpf),
  102. 'rg' => implode('', $rg),
  103. 'sexo' => $sexo,
  104. 'endereco' => 'Rua Maratona',
  105. 'num_end' => implode('', $num),
  106. 'bairro' => 'Vila Isabel',
  107. 'cidade' => 'Passo Fundo',
  108. 'uf' => $ufs[array_rand($ufs)],
  109. 'plano' => rand(1,4),
  110. 'senha' => md5(time())
  111. ];
  112.  
  113. DB::table('alunos')->insert($alunos);
  114. }
  115. // $alunos->save();
  116. }
Add Comment
Please, Sign In to add comment