public function new_crop(Request $request) { //คำนวนพื้นที่ เพื่อเอาไปหาจำนวนที่ปลูกสูงสุด //โดยแปลงทัั้งหมดเป็นไร่ $date = $request->input('start_date_plan'); $dateformat = explode('-', $date); $date_start_crop = $dateformat[2] . '-' . $dateformat[1] . '-' . $dateformat[0]; $r = $request->input('rai'); $n = $request->input('ngarn'); $w = $request->input('wah'); $r += $n / 4; $r += $w / 400; $Crops = new Crops(); $Crops->crop_name = $request->input('namerai'); $Crops->crop_latitude = $request->input('latitude'); $Crops->crop_longitude = $request->input('longitude'); $Crops->crop_product = $r * 800; $Crops->crop_rai = $request->input('rai'); $Crops->crop_ngarn = $request->input('ngarn'); $Crops->crop_wah = $request->input('wah'); $Crops->crop_breed_id = $request->input('breed'); $Crops->crop_cp_id = $request->input('plan_crops_cp'); $Crops->crop_start_date = $date_start_crop; $Crops->crop_begin_date = '0000-00-00'; $Crops->crop_crop_date = '0000-00-00'; $Crops->crop_end_date = '0000-00-00'; $Crops->crop_status = '1'; $Crops->save(); $user_id_group = new GroupCropUser(); $user_id_group->user_id = Auth::user()->id; $user_id_group->crop_id = $Crops->crop_id; $user_id_group->save(); return Redirect::to('/home'); }
public function index() { $marker = array(); # show map google $config = array(); $config['center'] = 'auto'; $gmaps = new Gmaps(); $gmaps->initialize($config); // set up the marker ready for positioning // once we know the users location if (Auth::guest()) { $maps_crops = Crops::all(); } else { if (Auth::user()->typeuser_id == '2') { $maps_crops = Crops::all(); } else { $maps_crops = DB::table('group_crop_users')->join('crops', 'group_crop_users.crop_id', '=', 'crops.crop_id')->where('group_crop_users.user_id', '=', Auth::user()->id)->get(); } } foreach ($maps_crops as $map) { // Loop Create Map $marker['map_id'] = $map->crop_id; $marker['position'] = $map->crop_latitude . ',' . $map->crop_longitude; $marker['title'] = 'mapid_' . $map->crop_id; $marker['icon'] = 'assets/img/crops/rice/rice_running.png'; $gmaps->add_marker($marker); } $map = $gmaps->create_map(); return view('home', compact('map')); }