/** * Run the database seeds. * * @return void */ public function run() { $faker = Faker::create(); //$faker->addProvider(new Faker\Provider\DateTime($faker)); $data = CombatRound::where('challenge_id', '=', 5)->get(); foreach ($data as $d) { $time1 = DateTime::time($format = 'H:i:s', $max = '00:02:00'); $time2 = DateTime::time($format = 'H:i:s', $max = '00:02:00'); $zonaRoja1 = $faker->numberBetween($min = 2, $max = 5); $nZonaRojo1 = $zonaRoja1 + 1; $zonaVerde1 = $faker->numberBetween($min = 1, $max = 5); $nZonaVerde1 = $zonaVerde1 + 1; $zonaAzul1 = $faker->numberBetween($min = 2, $max = 5); $nZonaAzul1 = $zonaAzul1 + 1; $zonaRoja2 = $faker->numberBetween($min = 2, $max = 5); $nZonaRojo2 = $zonaRoja2 + 1; $zonaVerde2 = $faker->numberBetween($min = 1, $max = 5); $nZonaVerde2 = $zonaVerde2 + 1; $zonaAzul2 = $faker->numberBetween($min = 2, $max = 5); $nZonaAzul2 = $zonaAzul2 + 1; BlockRise::create(['combat_id' => $d['id'], 'team_id_1' => $d['versus_one'], 'time_team_1' => $time1, 'zon_pun_roj_1' => $zonaRoja1, 'num_api_roj_1' => $nZonaRojo1, 'zon_pun_ver_1' => $zonaVerde1, 'num_api_ver_1' => $nZonaVerde1, 'zon_pun_azu_1' => $zonaAzul1, 'num_api_azu_1' => $nZonaAzul1, 'team_id_2' => $d['versus_two'], 'time_team_2' => $time2, 'zon_pun_roj_2' => $zonaRoja2, 'num_api_roj_2' => $nZonaRojo2, 'zon_pun_ver_2' => $zonaVerde2, 'num_api_ver_2' => $nZonaVerde2, 'zon_pun_azu_2' => $zonaAzul2, 'num_api_azu_2' => $nZonaAzul2]); } }
public function blockFirm(Request $request) { $data = $this->evalFirms($request->team_id, $request->firma_usuario); if ($data) { $dataFin = BlockRise::where('combat_id', '=', $request->combat_id)->first(); if ($dataFin) { if ($request->type == 1) { $iden = 2; $idPar = 2; $idPar2 = 1; } else { $iden = 1; $idPar = 1; $idPar2 = 2; } $d = false; $m = false; /* * if($request->identificador == 1){ $id=1; $idPar=2; }else{ $id=2; $idPar=1; }*/ $vI1 = 'team_id_' . $iden; $vI2 = 'time_team_' . $iden; $vI3 = 'zon_pun_roj_' . $iden; $vI4 = 'num_api_roj_' . $iden; $vI5 = 'zon_pun_ver_' . $iden; $vI6 = 'num_api_ver_' . $iden; $vI7 = 'zon_pun_azu_' . $iden; $vI8 = 'num_api_azu_' . $iden; $vI9 = 'scort_team_' . $iden; $vI10 = 'firm_team_' . $iden; $dataBlock = BlockRise::where('combat_id', '=', $request->combat_id)->select($vI1 . ' as team', $vI2 . ' as time', $vI3 . ' as zona_rojo', $vI4 . ' as apilado_rojo', $vI5 . ' as zona_verde', $vI6 . ' as apilado_verde', $vI7 . ' as zona_azul', $vI8 . ' as apilado_azul', $vI9 . ' as score', $vI10 . ' as firma')->first()->toArray(); $dataOneApil = $dataBlock['apilado_rojo'] + $dataBlock['apilado_verde'] + $dataBlock['apilado_azul']; $dataTwoApi = $request->numero_apilados_roja + $request->numero_apilados_verde + $request->numero_apilados_azules; if ($dataBlock['score'] > $request->scort_team) { //print_r('aca 1'); $id = $idPar; $d = true; $teamWin = $dataBlock['team']; } elseif ($request->scort_team > $dataBlock['score']) { //print_r('aca 2'); $id = $id = $idPar2; $d = true; $teamWin = $request->team_id; } else { if ($request->scort_team == $dataBlock['score']) { //dd('aca 3'); //print_r(strtotime($dataBlock['time']).' ----------- '.strtotime($request->time_final)); if (strtotime($request->time_final) < strtotime($dataBlock['time'])) { //print_r('aca 4'); $teamWin = $request->team_id; $d = true; $id = $idPar2; } else { if (strtotime($dataBlock['time']) < strtotime($request->time_final)) { $teamWin = $dataBlock['team']; //print_r('aca 5'); $d = true; $id = $idPar; } } if (strtotime($request->time_final) == strtotime($dataBlock['time'])) { if ($dataOneApil > $dataTwoApi) { //print_r('acas 1'); $teamWin = $dataBlock['team']; $id = $idPar; $d = true; } else { if ($dataTwoApi > $dataOneApil) { //print_r('acas 2'); $teamWin = $request->team_id; $id = $idPar; $d = true; } } } } } /*dd('team wind '.$teamWin.' el id '.$id); //dd('team wind '.$teamWin.' el id '); dd($dataBlock);*/ $v1 = "team_id_" . $request->type; $v2 = "time_team_" . $request->type; $v3 = "zon_pun_roj_" . $request->type; $v4 = "num_api_roj_" . $request->type; $v5 = "zon_pun_ver_" . $request->type; $v6 = "num_api_ver_" . $request->type; $v7 = "zon_pun_azu_" . $request->type; $v8 = "num_api_azu_" . $request->type; $v9 = "scort_team_" . $request->type; $v10 = "firm_team_" . $request->type; $dataFin->{$v1} = $request->team_id; $dataFin->{$v2} = $request->time_final; $dataFin->{$v3} = $request->zona_puntaje_roja; $dataFin->{$v4} = $request->numero_apilados_roja; $dataFin->{$v5} = $request->zona_puntaje_verde; $dataFin->{$v6} = $request->numero_apilados_verde; $dataFin->{$v7} = $request->zona_puntaje_azules; $dataFin->{$v8} = $request->numero_apilados_azules; $dataFin->{$v9} = $request->scort_team; $dataFin->{$v10} = $request->firma_usuario; $dataFin->team_id_win = $teamWin; $dataFin->save(); return ['flag' => $d, 'flag_win' => $id, 'muerte' => $m, 'error' => $data]; } else { BlockRise::create(['team_id_' . $request->type => $request->team_id, 'time_team_' . $request->type => $request->time_final, 'zon_pun_roj_' . $request->type => $request->zona_puntaje_roja, 'num_api_roj_' . $request->type => $request->numero_apilados_roja, 'zon_pun_ver_' . $request->type => $request->zona_puntaje_verde, 'num_api_ver_' . $request->type => $request->numero_apilados_verde, 'zon_pun_azu_' . $request->type => $request->zona_puntaje_azules, 'num_api_azu_' . $request->type => $request->numero_apilados_azules, 'scort_team_' . $request->type => $request->scort_team, 'firm_team_' . $request->type => $request->firma_usuario, 'combat_id' => $request->combat_id]); } /*$com = CombatRound::find($request->combat_id); $com->completed= 1; $com->save();*/ } return ['error' => $data]; }