public function getUpdate(Request $r)
 {
     foreach ($r->id_kec as $key => $id_kec) {
         $cek = Kecamatan::where('id', $r->kec[$key])->where('id', '<>', $id_kec)->count();
         if ($cek > 0) {
             \Session::flash('gagal', 'Gagal!! Pastikan ID KECAMATAN tidak ada yang sama');
             return redirect()->back();
         }
     }
     DB::transaction(function () use($r) {
         $table = ['app_air_tawar', 'app_tambak', 'app_jumlah_penduduk', 'app_mangrove_jenis', 'app_mangrove_milik', 'app_mangrove_rehabilitasi', 'app_pemasar', 'app_rumput_laut', 'app_terumbu_jenis_ikan', 'app_terumbu_milik', 'app_terumbu_rehabilitasi'];
         foreach ($r->id_kec as $key => $id_kec) {
             DB::table('kecamatan')->where('id', $id_kec)->update(['id' => $r->kec[$key]]);
             DB::table('desa')->where('id_kecamatan', $id_kec)->update(['id_kecamatan' => $r->kec[$key]]);
             foreach ($table as $val) {
                 DB::table($val)->where('kecamatan', $id_kec)->update(['kecamatan' => $r->kec[$key]]);
             }
         }
     });
     \Session::flash('success', 'Berhasil mengubah data');
     return redirect()->back();
 }
Example #2
0
 public function listkec()
 {
     $kab = Input::get('option');
     $kec = ['0' => 'Select kabupaten first'] + Kecamatan::where('kabupaten_id', '=', $kab)->lists('nama', 'id')->toArray();
     return Response::make($kec);
 }
Example #3
0
    }]);
    Route::resources(['instansi' => 'InstansiController', 'bantuan' => 'BantuanController', 'kriteria' => 'KriteriaController', 'indikator' => 'IndikatorController']);
    Route::group(['prefix' => 'region', 'namespace' => 'Region'], function () {
        Route::get('/', function () {
            return redirect()->url('admin/kabupaten');
        });
        Route::resources(['provinsi' => 'ProvinsiController', 'kabupaten' => 'KabupatenController', 'kecamatan' => 'KecamatanController', 'desa' => 'DesaController']);
        Route::get('get/{region}/{id}', ['as' => 'getRegion', 'uses' => function ($r, $id) {
            $data = [];
            if ($r == 'kabupaten') {
                foreach (\App\Kabupaten::where('provinsi_id', $id)->get() as $list) {
                    $data = array_merge_recursive($data, [['id' => $list->id, 'text' => $list->label]]);
                }
            }
            if ($r == 'kecamatan') {
                foreach (\App\Kecamatan::where('kabupaten_id', $id)->get() as $list) {
                    $data = array_merge_recursive($data, [['id' => $list->id, 'text' => $list->label]]);
                }
            }
            if ($r == 'desa') {
                foreach (\App\Desa::where('kecamatan_id', $id)->get() as $list) {
                    $data = array_merge_recursive($data, [['id' => $list->id, 'text' => $list->label]]);
                }
            }
            return $data;
        }]);
    });
});
Route::group(['prefix' => 'admin/kecamatan', 'middleware' => 'UAC:kecamatan', 'namespace' => 'Admin\\Kecamatan'], function () {
    Route::get('/', ['as' => 'admin.kecamatan.landing', 'uses' => function () {
        return view('admin_template');