public function delete($cod = null) { if (is_null($cod)) { Redirect::to('404.html'); } else { $agencia = Tour::where('codAgencia', '=', $cod)->firstOrFail(); if (is_object($agencia)) { $agencia->estado = '0'; $agencia->save(); return Redirect::to('agencias'); } } }
public function thankyou($payment_reference = null, $charge = null) { $charge = Session::get('charge'); $payment_reference = Session::get('payment_reference'); if ($payment_reference) { $booking = Booking::find($payment_reference); $booking->receipt = array('stripe_id' => $charge->id, 'payment_reference' => Session::get('payment_reference'), 'amount' => $charge->amount); $booking->save(); Tour::where('dates.id', (int) $booking->tour_date)->decrement('dates.$.spaces'); $tour = Tour::find($booking->id); Mail::send('emails.stripebooking', compact('booking', 'tour'), function ($message) { $message->to('*****@*****.**', 'Not Normal Tours')->subject('New Booking at Not Normal Tours'); }); return View::make('pages.thankyou'); } return View::make('pages.thankyou'); }
/** * @param $compet * @return bool */ private function saveTour($compet) { // Delete Tour qui sont supérieur au compet->nbtour Tour::where('compet_id', '=', $compet->id)->where('num', '>', $compet->nbtours)->delete(); for ($t = 1; $t <= $compet->nbtours; $t++) { $tour = Tour::where('compet_id', '=', $compet->id)->where('num', '=', $t)->first(); if ($tour) { $tour->datetour = $compet->date->addDays($t - 1); $tour->save(); } else { $tour = new Tour(); $tour->compet_id = $compet->id; $tour->num = $t; $tour->datetour = $compet->date->addDays($t - 1); $tour->save(); } } return true; }
/** * Display the specified resource. * * @param int $id * @return Response */ public function tourDetail($country = '', $tour = '', $tour_type = '') { if (Session::has('st_date')) { $st_date = Session::get('st_date'); } else { $st_date = date("Y/m/d"); } //Session::flush(); if (Session::has('ed_date')) { $ed_date = Session::get('ed_date'); } else { $ed_date = date("Y/m/d", strtotime($st_date . ' + 2 days')); } $filter_tours = Tour::where('val', 1)->get(); $filter_cities = City::where('val', 1)->get(); if (!empty($country)) { $country = str_replace('-', ' ', $country); $get_country_id = DB::table('countries')->where('country', 'LIKE', $country)->first(); $country_id = $get_country_id->id; } if (!empty($tour)) { $tour = str_replace('-', ' ', $tour); $get_tour_id = DB::table('tours')->where('tour_title', 'LIKE', $tour)->first(); $tour_id = $get_tour_id->id; } if (!empty($tour_type)) { $tour_type = str_replace('-', ' ', $tour_type); $get_tour_type_id = DB::table('tour_types')->where('tour_type_title', 'LIKE', $tour_type)->first(); $tour_type_id = $get_tour_type_id->id; } $path = array(); $tour = Tour::where('id', $tour_id)->where('val', 1)->get(); $tour_type = TourType::where('id', $tour_type_id)->where('val', 1)->first(); // dd(DB::getQueryLog()); if (!$tour_type->count()) { return Redirect::to('/403'); } return View::make('tour.tour_details')->with(array('tour' => $tour, 'tour_id' => $tour_id, 'tour_type_id' => $tour_type_id, 'path' => $path, 'tour_type' => $tour_type, 'st_date' => $st_date, 'ed_date' => $ed_date, 'filter_tours' => $filter_tours, 'filter_cities' => $filter_cities)); }
<?php $param = $dsp->var['param']; $tours = Tour::where('compet_id', '=', $param['compet_id'])->get(); ?> {{ openContent($param['titre']) }} <?php // Open Form Xform::form('route', 'tour.formule'); // Hidden Xform::startRow('hidden'); Xform::addText('_token', 'x', Session::getToken(), 2); Xform::addText('backUrl', '', $param['backUrl']); Xform::addText('compet_id', 'COMPET_ID', $param['compet_id'], 1); Xform::endRow(); ?> @foreach($tours as $tour) <?php $t = $tour->num; // Hidden Xform::startRow('hidden'); Xform::addText('id[' . $t . ']', 'ID', $tour->id, 2); Xform::endRow(); // Get Fields Xform::startRow(); Xform::addDate('datetour[' . $t . ']', 'Date', $tour->datetour, 2); Xform::addSelect('formulecompet_id[' . $t . ']', $tour->compet->typecompet->listFormules(), 'Formule de jeu', $tour->formulecompet_id, 3);
function viewTours($idAdvice) { $adviceDetails = AdviceDetail::where('id_advice', $idAdvice)->get(); //============= $questionAnswerLoc = AdviceDetail::where('id_advice', $idAdvice)->where('id_question', 1)->first(); $location = Location::join(Answer::getTableName(), Answer::getTableName() . '.name', '=', Location::getTableName() . '.code')->where(Answer::getTableName() . '.id', $questionAnswerLoc->id_answer)->select(Location::getTableName() . '.*')->first(); $tours = Tour::where('start_loc', $location->id)->get(); $listAnsOfNotFactor = $adviceDetails->filter(function ($row) { return !in_array($row->id_question, Question::$_rootQuestionID); }); if ($listAnsOfNotFactor->count() > 0) { $arrAnsPoint = $this->scoreAnswer($listAnsOfNotFactor->lists('id_answer')); $arrAnsPoint = $this->interaction($arrAnsPoint); $lisIDAvailable = []; foreach ($arrAnsPoint as $idAns => $item) { if ($item['point']) { $lisIDAvailable[] = TourScore::where('id_answer', $idAns)->where('score', '>=', $item['point'])->whereIn('id_tour', $tours->lists('id'))->select('id_tour')->lists('id_tour'); } } $fileInput = public_path('z1.txt'); $fileOutput = public_path('z2.txt'); if (file_exists($fileInput)) { unlink($fileInput); } foreach ($lisIDAvailable as $list) { if ($list) { file_put_contents($fileInput, implode(' ', $list) . "\n", FILE_APPEND); } } $cmd = 'java -jar spmf.jar run FPGrowth_itemsets ' . $fileInput . ' ' . $fileOutput . ' 50%'; exec($cmd); $file = fopen($fileOutput, 'r'); $arrID = []; while (!feof($file)) { $line = fgets($file); if ($line) { preg_match('/(.*)#SUP(.*)/', $line, $matches); $strID = trim($matches[1]); $arrID = array_merge($arrID, explode(' ', $strID)); $arrID = array_unique($arrID); } } $tableLocation = Location::getTableName(); $tours = Tour::whereIn(Tour::getTableName() . '.id', $arrID)->join($tableLocation, "{$tableLocation}.id", '=', 'start_loc')->get([Tour::getTableName() . '.*', $tableLocation . '.name as locationName']); return View::make('advice.tour', compact('tours')); } }