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'));
}
