/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
foreach (Team::get() as $te) {
RelationTeUs::create(['team_id' => $te->id, 'user_coach_id' => $faker->numberBetween(1, count(User::get())), 'user_coach_aux_id' => $faker->numberBetween(1, count(User::get())), 'user_coordinador_id' => $faker->numberBetween(1, count(User::get())), 'user_cap_id' => $faker->numberBetween(1, count(User::get())), 'user_int2_id' => $faker->numberBetween(1, count(User::get())), 'user_int3_id' => $faker->numberBetween(1, count(User::get())), 'user_int4_id' => $faker->numberBetween(1, count(User::get()))]);
}
}
public function checkThree(Request $request)
{
$data = $request->all();
$dataOne = Tool::removeSpace($data['datosOne']);
$dataTwo = Tool::removeSpace($data['datosTwo']);
$dataThree = Tool::removeSpace($data['datosThree']);
$validatorOne = Validator::make($dataOne, ["Institución" => "required", "Nombre_del_equipo" => "required|name_team", "Nombre_del_robot" => "required|alpha_space", "Tipo" => "required", "Reto" => "required", "Grado" => "required"]);
$validatorTwo = Validator::make($dataTwo, ["Nombre" => "required|alpha_space", "Apellido_Paterno" => "required|alpha", "Apellido_Materno" => "required|alpha", "Correo" => "required|email|unique:rb_users,email", "Correo_confirmación" => "required|email|same:Correo", "Correo_alterno" => "required|email", "Nombre_Coach_auxiliar" => "required|alpha_space", "Apellido_Paterno_Coach_auxiliar" => "required|alpha", "Apellido_Materno_Coach_auxiliar" => "required|alpha", "Nombre_coordinador" => "required|alpha_space", "Apellido_paterno_coordinador" => "required|alpha", "Apellido_materno_coordinador" => "required|alpha"]);
$validatorThree = Validator::make($dataThree, ["Nombre_capitan" => "required|alpha_space", "Apellido_paterno_capitan" => "required|alpha", "Apellido_materno_capitan" => "required|alpha", "Nombre_2_integrante" => "required|alpha_space", "Apellido_paterno_2_integrante" => "required|alpha", "Apellido_materno_2_integrante" => "required|alpha", "Nombre_3_integrante" => "required|alpha_space", "Apellido_paterno_3_integrante" => "required|alpha", "Apellido_materno_3_integrante" => "required|alpha", "Nombre_4_integrante" => "required|alpha_space", "Apellido_paterno_4_integrante" => "required|alpha", "Apellido_materno_4_integrante" => "required|alpha"]);
$toArrayOne = $validatorOne->errors()->toArray();
$toArrayTwo = $validatorTwo->errors()->toArray();
$toArrayThree = $validatorThree->errors()->toArray();
if ($validatorOne->fails() || $validatorTwo->fails() || $validatorThree->fails()) {
return response()->json(['success' => false, 'errors' => ['uno' => $toArrayOne, 'dos' => $toArrayTwo, 'tres' => $toArrayThree]]);
}
$pas = Tool::generateKey(['MI' => true, 'NU' => true, 'CA' => true, 'MA' => true, 'LEN' => 10]);
DB::beginTransaction();
try {
Mail::send('mails.mail', ['user' => 'Ricardio'], function ($msj) {
$msj->to('*****@*****.**')->subject('Este es un correo de prueba de la liga de robotica');
});
$team = Team::create(['institution_id' => $dataOne['Institución'], 'name' => $dataOne['Nombre_del_equipo'], 'name_altered' => Tool::getName($dataOne['Nombre_del_equipo']), 'robot_name' => $dataOne['Nombre_del_robot'], 'gender' => $dataOne['Tipo'], 'challenge_id' => $dataOne['Reto'], 'degree_id' => $dataOne['Grado']]);
$team_id = $team->id;
$userOne = User::create(['name' => $dataTwo['Nombre'], 'last_name' => $dataTwo['Apellido_Paterno'], 'last_name_m' => $dataTwo['Apellido_Materno'], 'email' => $dataTwo['Correo'], 'email_alter' => $dataTwo['Correo_alterno'], 'password' => bcrypt($pas), 'password_two' => base64_encode($pas), 'role_id' => 2]);
$coach_id = $userOne->id;
$userTwo = User::create(['name' => $dataTwo['Nombre_Coach_auxiliar'], 'last_name' => $dataTwo['Apellido_Paterno_Coach_auxiliar'], 'last_name_m' => $dataTwo['Apellido_Materno_Coach_auxiliar'], 'role_id' => 3]);
$coach_aux_id = $userTwo->id;
if ($dataTwo['Coordinado'] != 'S') {
$userThree = User::create(['name' => $dataTwo['Nombre_coordinador'], 'last_name' => $dataTwo['Apellido_paterno_coordinador'], 'last_name_m' => $dataTwo['Apellido_materno_coordinador'], 'role_id' => 4]);
$coordinador_id = $userThree->id;
} else {
$coordinador_id = $coach_aux_id;
}
$cap = User::create(['name' => $dataThree['Nombre_capitan'], 'last_name' => $dataThree['Apellido_paterno_capitan'], 'last_name_m' => $dataThree['Apellido_materno_capitan'], 'role_id' => 5]);
$cap_id = $cap->id;
$userdos = User::create(['name' => $dataThree['Nombre_2_integrante'], 'last_name' => $dataThree['Apellido_paterno_2_integrante'], 'last_name_m' => $dataThree['Apellido_materno_2_integrante'], 'role_id' => 6]);
$userdos_id = $userdos->id;
$userthre = User::create(['name' => $dataThree['Nombre_3_integrante'], 'last_name' => $dataThree['Apellido_paterno_3_integrante'], 'last_name_m' => $dataThree['Apellido_materno_3_integrante'], 'role_id' => 7]);
$userthre_id = $userthre->id;
$userfour = User::create(['name' => $dataThree['Nombre_3_integrante'], 'last_name' => $dataThree['Apellido_paterno_3_integrante'], 'last_name_m' => $dataThree['Apellido_materno_3_integrante'], 'role_id' => 8]);
$userfour_id = $userfour->id;
RelationTeUs::create(['team_id' => $team_id, 'user_coach_id' => $coach_id, 'user_coach_aux_id' => $coach_aux_id, 'user_coordinador_id' => $coordinador_id, 'user_cap_id' => $cap_id, 'user_int2_id' => $userdos_id, 'user_int3_id' => $userthre_id, 'user_int4_id' => $userfour_id]);
} catch (\Exception $e) {
DB::rollback();
}
DB::commit();
return response()->json(['success' => true]);
}
public function evalFirmsTeam($id, $firm)
{
$relation = RelationTeUs::where('team_id', '=', $id)->first()->toArray();
switch ($firm) {
case $relation['user_cap_id']:
return true;
break;
case $relation['user_int2_id']:
return true;
break;
case $relation['user_int3_id']:
return true;
break;
case $relation['user_int4_id']:
return true;
break;
default:
return $this->EvalFirmAdmin($firm);
break;
}
}
