public function show($referen)
{
$empresa = Session::get('empresa');
Checklist::where('chk_referen', $referen)->delete();
$documentos = \DB::connection('master')->table('mdb_tipodocum')->select('doc_clave', 'doc_nombre')->get();
foreach ($documentos as $doc) {
$result = Result::where('res_referen', $referen)->first();
if (!empty($result)) {
$validacion = Validation::where('attribute_id', 9)->where('id', $result->validations_id)->whereRaw('SUBSTRING_INDEX(val_data, "|", 1) = ' . $doc->doc_clave)->count();
if ($validacion > 0) {
$imagen = \DB::connection('users')->table('opauimg')->where('pk_referencia', $referen)->where('imgtipodoc', $doc->doc_clave)->count();
if ($imagen > 0) {
$check = 1;
} else {
$check = 0;
}
} else {
$check = 2;
}
} else {
$check = 0;
}
$data = ["chk_referen" => $referen, "chk_document" => $doc->doc_nombre, "chk_status" => $check, "chk_company" => $empresa];
Checklist::create($data);
}
$result = Checklist::where('chk_company', $empresa)->get();
return view('list_document')->with(['document' => $result, 'referen' => $referen]);
}
public function iresponse($project, Request $request)
{
$iresponseCol = Question::where('project_id', $project->id)->where('qnum', config('aio.iresponse'))->first();
$dbraw = DB::select(DB::raw("SELECT pcode.state,answers.*,q.* \n FROM pcode INNER JOIN results ON results.resultable_id = pcode.primaryid \n INNER JOIN answers ON answers.status_id = results.id \n INNER JOIN ( SELECT id,qnum FROM questions where id = '{$iresponseCol->id}') q ON q.id = answers.qid"));
$dbGroupBy = DB::select(DB::raw("SELECT pcode.state,answers.*,q.* \n FROM pcode INNER JOIN results ON results.resultable_id = pcode.primaryid \n INNER JOIN answers ON answers.status_id = results.id \n INNER JOIN ( SELECT id,qnum FROM questions where id = '{$iresponseCol->id}') q ON q.id = answers.qid GROUP BY results.id"));
$incidents = Result::where('project_id', $project->id);
$locations = PLocation::where('org_id', $project->org_id)->groupBy('state');
return view('frontend.result.response-incident')->withProject($project)->withRequest($request)->withQuestion($iresponseCol)->withIncidents($incidents)->withLocations($locations)->withDbraw(collect($dbraw))->withDbGroup(collect($dbGroupBy));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$quiz = Quiz::findOrFail($id);
$result = Result::where('quiz_id', $quiz->id)->first();
if (!$result) {
$quiz->status = 'rejected';
$quiz->save();
$result = new Result();
$result->quiz_id = $quiz->id;
$result->user_id = $quiz->user_id;
$result->save();
}
return view('teacher.results.show')->with('result', $result)->with('title', trans('titles.results'));
}
public function checkPedimento($referen, $valorOrigen)
{
if ($valorOrigen['entrada'] == 1) {
$pk_referencia = $referen->pk_referencia;
$tabla = 'optr02';
$camposel1 = 'pk_factura';
$camposel2 = 'pk_cove';
$campow = 'pk_referencia';
} else {
$pk_referencia = $referen->folio_ds;
$tabla = 'ds505';
$camposel1 = 'NumeroFactura';
$camposel2 = 'NumeroFactura';
$campow = 'folio_ds';
}
//Recorrer campos del Anexo 22
$anexo = Anexo22::all();
foreach ($anexo as $anx) {
//Checar validaciones por campo
foreach ($anx->validations as $val) {
$valid = $val->id;
$camposbd = $anx->relationships->where('origin_id', $valorOrigen['entrada'])->first();
$data = ["tabla" => $camposbd->table, "campos" => $camposbd->field, "attr_id" => $val->attribute_id, "data_val" => $val->val_data, "anx_id" => $anx->id, "entrada" => $valorOrigen['entrada'], "referencia" => $pk_referencia];
$validacion = new Validation();
$valor = $validacion->isValid($data);
if ($valor == 0) {
if ($val->attribute_id == 9) {
$docum = 1;
} else {
$docum = 0;
}
$datos = ["res_referen" => $pk_referencia, "validations_id" => $valid, "res_document" => $docum, "res_company" => Session::get('empresa'), "res_user" => Session::get('usuario')];
$totalres = Result::where('res_referen', $pk_referencia)->where('validations_id', $valid)->count();
if ($totalres == 0) {
Result::create($datos);
}
}
}
}
$factura = \DB::connection('users')->table($tabla)->where($campow, $pk_referencia)->first();
$cove = $this->checkCove($factura, $camposel1, $camposel2, $pk_referencia);
echo $cove;
}
public function index($id)
{
echo $id;
$results = Result::where("tournament_id", $id)->get();
$a = "";
$results_json = array();
$i = 0;
foreach ($results as $result) {
// $game["user1"] = $result->user1()->get();
// $game["user2"] = $result->user2()->get();
$game["user1_result"] = array($result->user1()->get()[0]->name, $result->result_user1);
$game["user2_result"] = array($result->user2()->get()[0]->name, $result->result_user2);
// echo $result->user1()->get()[0]->name;
$results_json[$i] = $game;
$i++;
}
$tournament = Tournament::find($id);
$data = array('name' => "test", 'age' => "sdfds");
return view('results.results', array('tournament' => $tournament, 'results' => $results_json));
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
$series = Series::all();
// get lottery to display
$time = date("Hi");
$next_draw_lottery = Lottery::where("draw_time", '>', $time)->orderBy("draw_time")->first();
if ($next_draw_lottery) {
$next_draw_time = date_create_from_format("Hi", $next_draw_lottery->draw_time);
$next_draw_time = $next_draw_time->format("h:i A");
} else {
$next_draw_time = "--:--";
}
$lottery = Lottery::where("draw_time", '<=', $time)->orderBy("draw_time", "desc")->first();
if ($lottery) {
$date = date('Y-m-d');
$results = Result::where(array("date" => $date, 'lottery_id' => $lottery->id))->with('series')->get();
}
// dd($results->first()->series->code);
return view('home', compact('results', 'lottery', 'series', 'next_draw_time'));
}
/**
* Check that losers score is not higher than the winners score.
*/
public function moreValidation($validator)
{
$match = Result::where('match_id', '=', $this->input('match_id'))->first();
$booking = Booking::find($this->input('match_id'));
$validator->after(function ($validator) use($match, $booking) {
if ($this->input('win')) {
if ($this->input('user_score') < $this->input('opponent_score')) {
$validator->errors()->add('user_score', ' Your score must be higher than your opponent');
}
} elseif (!$this->input('result_by_default')) {
if ($this->input('user_score') > $this->input('opponent_score')) {
$validator->errors()->add('user_score', ' Your score must be lower than your opponent');
}
}
if ($match->created_at != $match->created_at) {
$validator->errors()->add('match_id', 'Match score already entered by opponent');
}
if ($booking->booking_date > date('Y-m-d')) {
$validator->errors()->add('match_id', 'Match has not been played yet');
}
});
}
public function show($testId)
{
$results = Result::where('test_id', $testId)->get();
return $results->toArray();
}
public function store_winning(Request $request)
{
//save winning numbers for $lottery_id for current date
$input = Input::all();
$date = date('Y-m-d');
$lottery_id = (int) $input['lottery_id'];
// dd(count($results));
$series = $input['series'];
// dd($series);
$ctr = 0;
foreach ($series as $series_id => $win_no) {
$series_id = (int) $series_id;
//check if entry already created for this date and lottery id
$result = Result::where(array('series_id' => $series_id, 'lottery_id' => $lottery_id, 'date' => $date))->get();
// dd(count($result));
if (count($result)) {
$result = $result[0];
$result->winning_number = $win_no;
} else {
$result = new Result(array('date' => $date, 'lottery_id' => $lottery_id, 'series_id' => $series_id, 'winning_number' => $win_no));
}
$rsp = $result->save();
// $rsp ? ($ctr++) : '';
}
return Redirect::to('/admin/lotteries/winning');
}
/**
* Status check function
* To Do: need to rewrite whole function
* @param type $project
* @param type $section
* @param type $answers
* @return string
* @throws GeneralException
*/
private function updateStatus($project, $section, $answers, $form_id)
{
if ($project->type == 'incident') {
return 'incident';
}
$section = (int) $section;
/**
* Get total questions count in a section
*/
$section_qcount = $project->questions->where('section', $section)->count();
$anscount = count(array_filter(array_keys($answers), 'strlen'));
// total answers count from form submit
// initialize error status
$error = false;
// flat multi dimentional questions and answers array to single array
$flat_answers = call_user_func_array('array_merge', $answers);
/**
* Loop through form submitted answers
* $qnum string (question number)
* $answer array
*/
foreach ($answers as $qslug => $answer) {
// get question using qnum slug
$lftq = $this->questions->getQuestionByQnum($qslug, $section, $project->id);
/**
* Loop answer
* $akey string (radio or answer key)
* $aval mixed (string or integer submitted by form input)
*/
foreach ($answer as $akey => $aval) {
if ($akey == 'radio') {
$qanswer = $lftq->qanswers->where('slug', $aval)->first();
} else {
$qanswer = $lftq->qanswers->where('slug', $akey)->first();
}
if (!is_null($qanswer)) {
if (!empty($qanswer->logic)) {
if (!empty($qanswer->logic['lftval'])) {
$lftval = $qanswer->logic['lftval'];
} else {
$lftval = '';
switch ($qanswer->type) {
case 'radio':
$lftval = $qanswer->value;
break;
case 'checkbox':
$lftval = $qanswer->value;
break;
default:
if (array_key_exists($qanswer->logic['lftans'], $flat_answers)) {
/** get actual answer if exist in input
* Ofcourse it will exist because it is left side answer
*/
$lftval = $flat_answers[$qanswer->logic['lftans']];
}
break;
}
}
if (!empty($qanswer->logic['rftval'])) {
$rftval = $qanswer->logic['rftval'];
} else {
// initialize right side value
$rftval = '';
// get right side question
if (isset($qanswer->logic['rftquess'])) {
$rftq = $this->questions->getQuestionByQnum($qanswer->logic['rftquess'], $section, $project->id);
if (!is_null($rftq)) {
if (isset($qanswer->logic['rftans'])) {
$rftanswer = $rftq->qanswers->where('slug', $qanswer->logic['rftans'])->first();
switch ($rftanswer->type) {
case 'radio':
$rftval = $rftanswer->value;
break;
case 'checkbox':
$rftval = $rftanswer->value;
break;
default:
if (array_key_exists($qanswer->logic['rftans'], $flat_answers)) {
/** get actual answer if exist in input
*/
$rftval = $flat_answers[$qanswer->logic['rftans']];
} else {
// get answer from database
$results = Result::where('project_id', $project->id)->where('incident_id', $form_id)->where('resultable_id', $resultable->id)->where('resultable_type', $resultable_type)->all();
dd($results);
}
break;
}
}
}
}
}
switch ($qanswer->logic['operator']) {
case '=':
if ($lftval != $rftval) {
$error = true;
}
break;
case '>':
if ($lftval < $rftval) {
$error = true;
}
break;
case '<':
if ($lftval > $rftval) {
$error = true;
}
break;
case 'between':
if ($lftval > $qanswer->logic['minval'] || $lftval < $qanswer->logic['maxval']) {
$error = true;
}
break;
default:
$error = false;
break;
}
}
}
}
}
//dd($ac);
if ($error === true) {
return 'error';
} elseif ($anscount === 0) {
return 'missing';
} elseif ($anscount >= $section_qcount) {
return 'complete';
} elseif ($anscount < $section_qcount) {
return 'incomplete';
} else {
return 'unknown';
}
throw new GeneralException('Something wrong with status checking!');
}
public function show($testId, RegressionCalculator $regressionCalculator)
{
$results = Result::where('test_id', $testId)->latest()->get();
$regressionLine = $regressionCalculator->calculate($results);
return view('results.show', compact('results', 'testId', 'regressionLine'));
}
protected function insertProjectResult(Request $request, $id)
{
$array = Input::all();
$validator = Validator::make($array, ['content' => 'required']);
if ($validator->fails()) {
return Response::json('', 400);
} else {
$result = Result::where('Project_FK', '=', $id)->first();
if (!empty($result)) {
$result->content = $request->input('content');
$result->save();
} else {
$result = new Result();
$result->Project_FK = $id;
$result->content = $request->input('content');
$result->save();
}
}
}
public function competitor_statistics(Request $request)
{
$competitors = Competitor::all();
//Nevezett versenyzők
$competitor_in = [];
foreach ($competitors as $comp) {
$competitor_in[$comp->id] = $comp->full_name_birthday;
}
natsort($competitor_in);
reset($competitor_in);
$act_competitor = key($competitor_in);
//Kiválasztott versenyző
if ($request->competitor) {
$act_competitor = $request->competitor;
}
$all_result = Result::where('competitor_id', '=', $act_competitor)->orderBy('total_points', 'desc')->get();
//Úszás és kombinált távok mentése
$swim_200 = ['Ifi B', 'Ifi A', 'Junior', 'Felnőtt', 'Senior'];
$swim_100 = ['Ifi C', 'Ifi D'];
$swim_50 = ['Ifi E', 'Ifi F'];
$ce_3200 = ['Ifi A', 'Junior', 'Felnőtt', 'Senior'];
$ce_2400 = ['Ifi B'];
$ce_1600 = ['Ifi C'];
$ce_800 = ['Ifi D'];
$ce_400 = ['Ifi E', 'Ifi F'];
//Lovaglás legjobb
$best_riding = Result::where('competitor_id', '=', $act_competitor)->where('riding_points', '!=', 0)->orderBy('riding_points', 'desc')->first();
//Vívás legjobb
$best_fencing = Result::where('competitor_id', '=', $act_competitor)->where('fencing_points', '!=', 0)->orderBy('fencing_points', 'desc')->first();
//Totál legjobb
$best_total = Result::where('competitor_id', '=', $act_competitor)->where('total_points', '!=', 0)->orderBy('total_points', 'desc')->first();
//Úszás legjobbak
$best_swimming_200 = Result::whereIn('age_group', $swim_200)->where('competitor_id', '=', $act_competitor)->where('swimming_time', '!=', '')->orderBy('swimming_time', 'asc')->first();
$best_swimming_100 = Result::whereIn('age_group', $swim_100)->where('competitor_id', '=', $act_competitor)->where('swimming_time', '!=', '')->orderBy('swimming_time', 'asc')->first();
$best_swimming_50 = Result::whereIn('age_group', $swim_50)->where('competitor_id', '=', $act_competitor)->where('swimming_time', '!=', '')->orderBy('swimming_time', 'asc')->first();
//Kombinált legjobbak
$best_ce_3200 = Result::whereIn('age_group', $ce_3200)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first();
$best_ce_2400 = Result::whereIn('age_group', $ce_2400)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first();
$best_ce_1600 = Result::whereIn('age_group', $ce_1600)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first();
$best_ce_800 = Result::whereIn('age_group', $ce_800)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first();
$best_ce_400 = Result::whereIn('age_group', $ce_400)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first();
return view('competitor_statistics', compact('all_result', 'competitors', 'competitor_in', 'act_competitor', 'best_riding', 'best_fencing', 'best_total', 'best_swimming_200', 'best_swimming_100', 'best_swimming_50', 'best_ce_3200', 'best_ce_2400', 'best_ce_1600', 'best_ce_800', 'best_ce_400'));
}
protected function getRequirementSpecificationPercent($id)
{
$counter = 0;
$introduction = ProjectIntroduction::where('Project_FK', '=', $id)->first();
if (count($introduction) > 0) {
$counter++;
}
$non = NonFunctionalRequirement::where('Project_FK', '=', $id)->first();
if (count($non) > 0) {
$counter++;
}
$quality = ProjectQuality::where('Project_FK', '=', $id)->first();
if (count($quality) > 0) {
$counter++;
}
$need = NeedToHave::where('Project_FK', '=', $id)->first();
if (count($need) > 0) {
$counter++;
}
$nice = NiceToHave::where('Project_FK', '=', $id)->first();
if (count($nice) > 0) {
$counter++;
}
$result = Result::where('Project_FK', '=', $id)->first();
if (count($result) > 0) {
$counter++;
}
$use = ProjectUse::where('Project_FK', '=', $id)->first();
if (count($use) > 0) {
$counter++;
}
$actual = ActualState::where('Project_FK', '=', $id)->first();
if (count($actual) > 0) {
$counter++;
}
$target = TargetState::where('Project_FK', '=', $id)->first();
if (count($target) > 0) {
$counter++;
}
$data = ProductData::where('Project_FK', '=', $id)->first();
if (count($data) > 0) {
$counter++;
}
return $counter;
}
/** Главный метод: гененрирует полотно вопросов на странице тестов */
public function showViews($id_test)
{
$test = new Test();
$result = new Result();
$user = new User();
$widgets = [];
$saved_test = [];
$current_date = date('U');
$query = $test->whereId_test($id_test)->select('amount', 'test_name', 'test_time', 'start', 'end', 'test_type')->first();
if ($current_date < strtotime($query->start) || $current_date > strtotime($query->end)) {
//проверка открыт ли тест
return view('no_access');
}
$amount = $query->amount;
//кол-во вопрососв в тесте
$result->test_name = $query->test_name;
$test_time = $query->test_time;
$test_type = $query->test_type;
if (!Session::has('test')) {
//если в тест зайдено первый раз
$test = new Test();
$test_controller = new TestController($test);
$ser_array = $this->prepareTest($id_test);
for ($i = 0; $i < $amount; $i++) {
$id = $this->chooseQuestion($ser_array);
if (!$test_controller->rybaTest($id)) {
//проверка на вопрос по рыбе
return view('no_access');
}
$data = $this->showTest($id, $i + 1);
//должны получать название view и необходимые параметры
$saved_test[] = $data;
$widgets[] = View::make($data['view'], $data['arguments']);
}
$start_time = date_create();
//время начала
$int_end_time = date_format($start_time, 'U') + 60 * $test_time;
//время конца
Session::put('end_time', $int_end_time);
$query = Result::max('id_result');
//пример использования агрегатных функций!!!
$current_result = $query + 1;
//создаем строку в таблице пройденных тестов
$query2 = $user->whereEmail(Auth::user()['email'])->select('id')->first();
$result->id_result = $current_result;
$result->id_user = $query2->id;
$result->id_test = $id_test;
$result->amount = $amount;
$result->save();
$saved_test = serialize($saved_test);
Result::where('id_result', '=', $current_result)->update(['saved_test' => $saved_test]);
Session::put('test', $current_result);
} else {
//если была перезагружена страница теста или тест был покинут
$current_test = Session::get('test');
$query = $result->whereId_result($current_test)->first();
$int_end_time = Session::get('end_time');
//время окончания теста
$saved_test = $query->saved_test;
$saved_test = unserialize($saved_test);
for ($i = 0; $i < $amount; $i++) {
$widgets[] = View::make($saved_test[$i]['view'], $saved_test[$i]['arguments']);
}
}
$current_time = date_create();
//текущее время
$int_left_time = $int_end_time - date_format($current_time, 'U');
//оставшееся время
$left_min = floor($int_left_time / 60);
//осталось минут
$left_sec = $int_left_time % 60;
//осталось секунд
$widgetListView = View::make('questions.student.widget_list', compact('amount', 'id_test', 'left_min', 'left_sec', 'test_type'))->with('widgets', $widgets);
$response = new Response($widgetListView);
return $response;
}
public function dsq_save($id, Request $request)
{
$competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
$act_competitor = $request->act_comp;
$result = Result::where('competitiongroup_id', '=', $id)->where('competitor_id', '=', $act_competitor)->first();
$result->dsq_status = 1;
$result->fencing_win = null;
$result->fencing_lose = null;
$result->fencing_points = 0;
$result->penalty_points_fencing = null;
$result->fencing_order = 0;
$result->swimming_time = "";
$result->swimming_points = 0;
$result->penalty_points_swimming = null;
$result->swimming_order = 0;
$result->riding_point = "";
$result->riding_time = "";
$result->riding_points = 0;
$result->horse_id = null;
$result->riding_order = 0;
$result->ce_time = "";
$result->ce_points = 0;
$result->penalty_points_ce = null;
$result->ce_order = 0;
$result->total_points = 0;
$result->total_penalty_points = null;
$result->save();
if ($competitiongroup->fencing_bouts != 0) {
$competitiongroup->fencing_bouts = $competitiongroup->fencing_bouts - $competitiongroup->bouts_per_match;
$competitiongroup->save();
}
$fencing_results1 = Fencing_result::where('competitiongroup_id', '=', $id)->where('competitor1_id', '=', $act_competitor)->get();
$fencing_results2 = Fencing_result::where('competitiongroup_id', '=', $id)->where('competitor2_id', '=', $act_competitor)->get();
foreach ($fencing_results1 as $fence) {
$fence->delete();
}
foreach ($fencing_results2 as $fence) {
$fence->delete();
}
//Sorrendek
$this->riding_order($id);
$this->swimming_order($id);
$this->ce_order($id);
$this->total_fencing_points($id);
$this->total_points($id);
$this->team_points_order($id);
return redirect('admin/competitiongroups/' . $id . '/dsq')->with('status', 'Versenyző kizárva.');
}
public function getStatusCount($project, Request $request)
{
//$section = $request->get('section');
$location = $request->get('location');
$loctype = $request->get('loctype');
foreach ($project->sections as $section => $section_value) {
if ($loctype && $location) {
$total_forms = PLocation::where('org_id', $project->org_id)->where($loctype, $location)->count();
//dd($total_forms);
$total_results = Result::where('project_id', $project->id)->where('section_id', $section)->OfWithPcode($loctype, $location)->count();
$result['complete'][$section]['y'] = Result::where('project_id', $project->id)->where('section_id', $section)->where('information', 'complete')->OfWithPcode($loctype, $location)->count();
$result['incomplete'][$section]['y'] = Result::where('project_id', $project->id)->where('section_id', $section)->where('information', 'incomplete')->OfWithPcode($loctype, $location)->count();
$result['error'][$section]['y'] = Result::where('project_id', $project->id)->where('section_id', $section)->where('information', 'error')->OfWithPcode($loctype, $location)->count();
$result['missing'][$section]['y'] = $total_forms - $total_results;
$result['complete'][$section]['label'] = $section_value->text;
$result['incomplete'][$section]['label'] = $section_value->text;
$result['error'][$section]['label'] = $section_value->text;
$result['missing'][$section]['label'] = $section_value->text;
} else {
$total_forms = PLocation::where('org_id', $project->org_id)->count();
$total_results = Result::where('project_id', $project->id)->where('section_id', $section)->count();
$result['complete'][$section]['y'] = Result::where('project_id', $project->id)->where('section_id', $section)->where('information', 'complete')->count();
$result['incomplete'][$section]['y'] = Result::where('project_id', $project->id)->where('section_id', $section)->where('information', 'incomplete')->count();
$result['error'][$section]['y'] = Result::where('project_id', $project->id)->where('section_id', $section)->where('information', 'error')->count();
$result['missing'][$section]['y'] = $total_forms - $total_results;
$result['complete'][$section]['label'] = _t($section_value->text);
$result['incomplete'][$section]['label'] = _t($section_value->text);
$result['error'][$section]['label'] = _t($section_value->text);
$result['missing'][$section]['label'] = _t($section_value->text);
//$result['complete'][$section]['indexLabel'] = _t($section_value->text);
//$result['incomplete'][$section]['indexLabel'] = _t($section_value->text);
//$result['error'][$section]['indexLabel'] = _t($section_value->text);
//$result['missing'][$section]['indexLabel'] = _t($section_value->text);
//$result['complete'][$section]['indexLabelPlacement'] = 'inside';
//$result['incomplete'][$section]['indexLabelPlacement'] = 'inside';
//$result['error'][$section]['indexLabelPlacement'] = 'inside';
//$result['missing'][$section]['indexLabelPlacement'] = 'inside';
}
}
//$result = Result::where('section_id', $section)->where('information', $status)->OfWithPcode('state','Yangon')->count();
return response()->json($result);
}
/**
* @param $input
* @param $result
* @throws GeneralException
*/
private function checkResultByEmail($input, $result)
{
//Figure out if email is not the same
if ($result->email != $input['email']) {
//Check to see if email exists
if (Result::where('email', '=', $input['email'])->first()) {
throw new GeneralException('That email address belongs to a different result.');
}
}
}
private function calculate_result($u_input)
{
$opponent_result = Result::where('match_id', '=', $u_input->input('match_id'))->where('player_id', '!=', \Auth::user()->id);
$user_result = Result::where('match_id', '=', $u_input->input('match_id'))->where('player_id', '=', \Auth::user()->id);
if ($u_input->input('win')) {
$winner_points = $this->winners_result($u_input->input('result_by_default'), $u_input->input('user_score'), $u_input->input('opponent_score'));
$loser_points = $this->losers_result($u_input->input('result_by_default'), $u_input->input('opponent_score'));
$user_result->update(['points' => $winner_points, 'winner' => '1']);
$opponent_result->update(['points' => $loser_points, 'winner' => '0']);
return;
}
$winner_points = $this->winners_result($u_input->input('result_by_default'), $u_input->input('opponent_score'), $u_input->input('user_score'));
$loser_points = $this->losers_result($u_input->input('result_by_default'), $u_input->input('user_score'));
$user_result->update(['points' => $loser_points, 'winner' => '0']);
$opponent_result->update(['points' => $winner_points, 'winner' => '1']);
return;
}
public function teams_entry($id)
{
$competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
//Versenyzők a listába
$result_list = Result::where('competitiongroup_id', '=', $id)->get()->lists('competitor_id', 'competitor_id');
$already_in1 = Results_team::select('competitor1_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor1_id', 'competitor1_id');
$already_in2 = Results_team::select('competitor2_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor2_id', 'competitor2_id');
$already_in3 = Results_team::select('competitor3_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor3_id', 'competitor3_id');
foreach ($already_in1 as $remove) {
$result_list->forget($remove);
}
foreach ($already_in2 as $remove) {
$result_list->forget($remove);
}
foreach ($already_in3 as $remove) {
$result_list->forget($remove);
}
$competitors = [];
foreach ($result_list as $comp) {
$temp_comp = Competitor::whereId($comp)->first();
$competitors[$comp] = $temp_comp->full_name_birthday;
}
natsort($competitors);
//Benevezett versenyzők
$competitor_list = Result::select('results.*')->where('competitiongroup_id', '=', $id)->join('competitors', 'results.competitor_id', '=', 'competitors.id')->orderBy('full_name', 'asc')->get();
$competitor_in = [];
foreach ($competitor_list as $comp) {
$competitor_in[$comp->id] = $comp->competitor->full_name;
}
natsort($competitor_in);
$comp_count = count($competitor_in);
//Benevezett csapatok
$team_list = Results_team::where('competitiongroup_id', '=', $id)->orderBy('name')->get();
$team_in = [];
foreach ($team_list as $team) {
$team_in[$team->id] = $team->name;
}
natsort($team_in);
$team_count = count($team_in);
return view('backend.competitiongroups.teams_entry', compact('competitiongroup', 'competitors', 'team_in', 'team_list', 'team_count', 'competitor_in', 'competitor_list', 'comp_count'));
}
