public function getOrCreateByName($name)
{
$spot = Spot::where('name', $name)->first();
if (!$spot) {
$spot = new Spot();
$spot->name = $name;
$spot->save();
}
return $spot;
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$this->findDateSpecificDistance = Spot::whereImei($_GET['item_id'])->where('created_at', ">=", $_GET['date'])->get();
$this->lngArray = array();
$this->latArray = array();
$this->carInfo = null;
if (is_object($this->findDateSpecificDistance)) {
foreach ($this->findDateSpecificDistance as $key => $dist) {
if ($dist->lng) {
$this->lngArray[] = $dist->lng;
} else {
$this->lngArray[] = 0;
}
if ($dist->lat) {
$this->latArray[] = $dist->lat;
} else {
$this->latArray[] = 0;
}
}
for ($i = 1; $i < sizeof($this->latArray); $i++) {
$this->totalDistance += $this->distance($this->latArray[$i - 1], $this->lngArray[$i - 1], $this->latArray[$i], $this->lngArray[$i], "K");
}
}
$cars = Cars::whereImei($_GET['item_id'])->get();
foreach ($cars as $key => $car) {
$this->carInfo = $car->manufacturer . ' ' . $car->num_plate;
}
return view('Spot/Create')->with('distance', $this->totalDistance)->with('carInfo', $this->carInfo)->with('date', $_GET['date']);
}
public function run()
{
DB::table('spots')->delete();
$faker = Faker\Factory::create();
for ($i = 0; $i < 5; $i++) {
$spot = new Spot();
$spot->place_name = $faker->streetName;
$spot->pos = $faker->latitude . "," . $faker->longitude;
$spot->price = $faker->randomNumber(2);
$spot->tips = $faker->text(20);
$spot->save();
// DB::table('ratings')->insert([
// 'user_id' => $i,
// 'value' => $i,
// 'ratingable_id' => $faker->randomDigit,
// 'ratingable_type' => $faker->word
// ]);
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$spotId = Request::get('id');
//echo $spotId; exit();
Spot::where('id', $spotId)->delete();
return redirect("spots");
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
//
$room = Room::find($id);
$spots = Spot::all();
$events = Event::all();
return view('rooms.edit', compact('room', 'spots', 'events'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$data = Spot::all();
return response()->json(json_encode($data));
}
public function bookBooth($id)
{
if (!$this->adminAuth() && !$this->checkCompanyType()) {
return view('errors.404');
}
$exhibitioneventId = $id;
$checExEv = ExhibitionEvent::find($exhibitioneventId);
if (date("Y-m-d H:i:s") > $checExEv->start_time) {
return view('errors.404');
}
$exhibitors = Exhibitor::all();
$exhibitionevents = ExhibitionEvent::all();
$types = Type::all();
$models = Modeldesign::all();
$spots = Spot::all();
return view('CompanyCP.booths.create', compact('types', 'models', 'exhibitors', 'exhibitionevents', 'exhibitioneventId', 'spots'));
}
/**
* @param $token
* @param $food_data
* @param transpo
* @return reponse json
*/
public static function addSpot($token, $food_data, $transpo)
{
//todo
$response = self::resolveNewSegmentFromActivity($token, $transpo, $food_data);
if ($response['err code'] == '403') {
return $response;
}
$current_iterinary = self::getUserCurrentIterinary($token);
if ($current_iterinary['err'] == 'err') {
return response()->json($current_iterinary, 403);
}
$day = self::getDiffInDays($token, $current_iterinary->id);
$activity = new Activity();
$activity->start_time = Carbon::now()->toTimeString();
$activity->iterinary_id = $current_iterinary->id;
$activity->day = $day;
$eat = new Spot();
$eat->place_name = $food_data['place_name'];
$eat->lng = $food_data['lng'];
$eat->lat = $food_data['lat'];
$eat->tips = $food_data['review'];
$eat->price = $food_data['price'];
$eat->foursquare_id = !$food_data['foursquare_id'] == "" ? null : $food_data['foursquare_id'];
$spotcategory = FoursquareHelper::resolveSpotCategory($food_data['category']['cat_id']);
// return $foodcategory;
// return response()->json($foodcategory['main_cat']);
$eat->main_category_id = $spotcategory['main_cat'];
$eat->sub_category_id = $spotcategory['sub_cat'];
$pic = $food_data['category'];
$eat->pic_url = $pic['prefix'] . 'bg_64' . $pic['suffix'];
// return response()->json($eat);
$eat->save();
$eat->activity()->save($activity);
self::updateIterinary($token);
$iterinary = Iterinary::findOrFail($current_iterinary->id)->with('activities.typable')->first();
return response()->json($eat, 200);
// $current_iterinary = self::getUserCurrentIterinary($token);
// $day = self::getDiffInDays($token, $current_iterinary->id);
// $activity = new Activity();
// $activity->start_time = Carbon::now()->toTimeString();
// $activity->iterinary_id = $current_iterinary->id;
// $activity->day = $day;
// $eat = new Spot();
// $eat->place_name = $spot_data['place_name'];
//
// $eat->lng = $spot_data['lng'];
// $eat->lat = $spot_data['lat'];
// $eat->tips = $spot_data['review'];
// $eat->price = $spot_data['price'];
//
// $spot_category = FoursquareHelper::resolveSpotCategory($spot_data['category']['cat_id']);
//
//// return response()->json($foodcategory['main_cat']);
// $eat->main_category_id = $spot_category['main_cat'];
// $eat->sub_category_id = $spot_category['sub_cat'];
// $pic = $spot_data['category'];
// $eat->pic_url = $pic['prefix'] . '64' . $pic['suffix'];
//
//// return response()->json($spot_category, 200);
// self::resolveSegmentFromActivity($token);
//
//// return response()->json($eat);
// $eat->save();
// $eat->activity()->save($activity);
//
//
// $iterinary = Iterinary::findOrFail($current_iterinary->id)
// ->with('activities.typable')
// ->first();
// return response()->json($iterinary, 200);
// return response()->json($eat);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
Spot::create($request::all());
return response()->json(array('success' => true));
}
public function addSpotTest(Request $request)
{
$request = $request->all();
$food_data = $request['spot'];
$token = $request['token'];
$transpo = $request['transpo'];
$response = UserSessionHandler::resolveNewSegmentFromActivity($token, $transpo, $food_data);
// return response()->json($response);
$current_iterinary = UserSessionHandler::getUserCurrentIterinary($token);
$day = UserSessionHandler::getDiffInDays($token, $current_iterinary->id);
$activity = new Activity();
$activity->start_time = Carbon::now()->toTimeString();
$activity->iterinary_id = $current_iterinary->id;
$activity->day = $day;
$eat = new Spot();
$eat->place_name = $food_data['place_name'];
$eat->lng = $food_data['lng'];
$eat->lat = $food_data['lat'];
$eat->tips = $food_data['review'];
$eat->price = $food_data['price'];
$foodcategory = Foursquare::resolveSpotCategory($food_data['category']['cat_id']);
// return response()->json($foodcategory['main_cat']);
$eat->main_category_id = $foodcategory['main_cat'];
$eat->sub_category_id = $foodcategory['sub_cat'];
$pic = $food_data['category'];
$eat->pic_url = $pic['prefix'] . '64' . $pic['suffix'];
// return response()->json($eat);
$eat->save();
$eat->activity()->save($activity);
$iterinary = Iterinary::findOrFail($current_iterinary->id)->with('activities.typable')->first();
return response()->json($iterinary, 200);
// return response()->json($eat);
}
//var_dump($key, $value);
//});
/// -- test helpers -- //
Route::get('test/helpers', function () {
App\Classes\FoursquareHelper::testHelper();
App\Classes\Rome2rioHelper::testHelper();
App\Classes\GeolocationHelper::testHelper();
});
Route::get('test/distance', function () {
$lnglat1 = App\Classes\GeolocationHelper::parseLongLat(Input::get('lnglat1'));
//$lnglat2 = Input::get('lnglat2');
$segment = new App\Segment();
$segment->origin_pos = $lnglat1;
//$segment->destination_pos = $lnglat2;
//dd($lnglat1);
$spots = App\Spot::haversine($lnglat1[0], $lnglat1[1])->get();
//return response()->json(App\Classes\GeolocationHelper::calculateDistance($segment),200);
dd($spots);
});
Event::listen('cache.hit', function ($query) {
var_dump('cache accessed ' . $query);
});
Route::get('api/img/{img_url}', 'ApiController@imageHandler');
Route::get('api/image/{img}', function ($img) {
return response()->make(file_get_contents(public_path() . '/images/' . $img))->header('Content-Type', 'png');
});
// -- end test helpers -- //
Route::get('test/collection', function () {
//if(Session::forget('56bdc5c7a38ab')) return response()->json('forgottten',200);
//Session::flush();
// $category = Input::get('category');
