HomeController.php

<?php
namespace App\Http\Controllers;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\View;
use App\Model_items;
use App\Http\Requests;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Input;
use Validator;
use DB;
use PDF;
use Cornford\Googlmapper\Facades\MapperFacade as Mapper;

class HomeController extends Controller {

	public function index()
	{
		$data  = Model_items::paginate(10);

		$i=0;
		foreach ($data as $value) {
			if ($i!=0) {
					Mapper::marker($value->lintang,$value->bujur);
			}else
					Mapper::map($value->lintang,$value->bujur, [ 'marker' => false, 'cluster' => false, 'fullscreenControl' => false]);
		 					//Mapper::map($value->lintang,$value->bujur, ['zoom' => 10, 'markers' => ['title' => "INFO : <br> ".$value->keterangan, 'animation' => 'DROP'], 'cluster' => false]);

					Mapper::informationWindow($value->lintang,$value->bujur,"INFO : <br> ".$value->keterangan);
					$i++;
		}


     //return View::make('index')->with('dataList', $data);
		 return view('index' ,['dataList'=> $data]);

	}

	public function tambahData()
	{
		return view('importExport');
	}

	public function delete($id)
	{
		$data = Model_items::find($id);
		$data->delete();
		return redirect('/')->with('sukses_delete','yes');
	}

	public function edit($id)
	{
		$data = Model_items::find($id);
		return view('edit')->with('data',$data);
	}

	public function update($id, Request $request)
	{

		$validator = Validator::make($request->all(), [
            'no' => 'required',
            'tanggal' => 'required|date_format:Y-m-d',
            'waktu' => 'required',
            'lintang' => 'required',
            'bujur' => 'required',
            'kedalaman' => 'required',
            'mag' => 'required',
            'mlv' => 'required',
            'keterangan' => 'required',
        ]);

		if ($validator->fails()) {
            return redirect('edit')
				->withErrors($validator)
				->withInput();
        }

		$data = Model_items::find($id);

		// $data->nama_field_di_database = Input::get('nama_field_di_form');

		$data->no = Input::get('no');
		$data->tanggal = Input::get('tanggal');
		$data->waktu = Input::get('waktu');
		$data->lintang = Input::get('lintang');
		$data->bujur = Input::get('bujur');
		$data->kedalaman = Input::get('kedalaman');
		$data->mag = Input::get('mag');
		$data->mlv = Input::get('mlv');
		$data->x = Input::get('x');
		$data->y = Input::get('y');
		$data->z = Input::get('z');
		$data->keterangan = Input::get('keterangan');

		$data->save();

		return redirect('/')->with('sukses_update','yes');

	}

	public function search(Request $request){
        $cariBulan = $request->get('bulan');
        $cariKabu = $request->get('kabupaten');
        $cariProv = $request->get('provinsi');
        $cariMag = $request->get('mag');
        $cariKed = $request->get('kedalaman');
        // $dataList = Model_items::where('keterangan','LIKE','%'.$cariKabuProv.'%')->paginate(10);
        // ->Where('kedalaman','=',$cariKed)->Where('mag','=',$cariMag)->paginate(10);
        // $ket = Model_items::where('keterangan','LIKE','%'.$cariKabuProv.'%')->paginate(10);
        // $mag = Model_items::where('kedalaman','=',$cariKed)->paginate(10);
        // $ked = Model_items::where('mag','=',$cariMag)->paginate(10);
        // $dataList = $ket;
        // $dataList = DB::table('infogempas')
        //     ->select(DB::raw("*"))
        //     ->where('keterangan','LIKE','%'.$cariKabuProv.'%')
        //     ->where('kedalaman','=',$cariKed)
        //     ->where('mag','=',$cariMag)
        //     ->paginate(10);
        $query = Model_items::query();
			if(Input::has('kabupaten')) {
			    $query->where('keterangan', 'LIKE', '%'.$cariKabu.'%');
			}
			if(Input::has('provinsi')) {
			    $query->where('keterangan', 'LIKE', '%'.$cariProv.'%');
			}
			if(Input::has('kedalaman')) {
			    $query->where('kedalaman', Input::get('kedalaman'));
			}
			if(Input::has('mag')) {
			    $query->where('mag', Input::get('mag'));
			}
			$dataList = $query->paginate(10);
			// return View::make('dashboard')->with('reservations', $reservations);
        return view('index', compact('dataList'));
    }

  //   public function map(){
  //   	//Get the base-64 string from data
		// $filteredData=substr($_POST['img_val'], strpos($_POST['img_val'], ",")+1);

		// //Decode the string
		// $unencodedData=base64_decode($filteredData);

		// //Save the image
		// file_put_contents('img.png', $unencodedData);
  //   }
}