1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
namespace App\Http\Controllers;
use App\Area;
use App\GrandeArea;
use App\SubArea;
use App\AreaModalidade;
use App\Pertence;
use App\Revisor;
use App\Trabalho;
use Illuminate\Http\Request;
class AreaController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$areas = Area::orderBy('nome')->get();
return view('naturezas.area.index')->with(['areas' => $areas]);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create($grandeAreaid)
{
return view('naturezas.area.nova_area')->with(['grandeAreaId' => $grandeAreaid]);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request, $id)
{
$validatedData = $request->validate([
'nome' => 'required',
]);
$area = new Area();
$area->nome = $request->nome;
$area->grande_area_id = $id;
$area->save();
return redirect( route('grandearea.show', ['id' => $id]) )->with(['mensagem' => 'Nova área cadastrada com sucesso']);
}
/**
* Display the specified resource.
*
* @param \App\Area $area
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$area = Area::find($id);
$subAreas = SubArea::where('area_id', '=', $id)->orderBy('nome')->get();
return view('naturezas.area.detalhes')->with(['area' => $area, 'subAreas' => $subAreas]);
}
/**
* Show the form for editing the specified resource.
*
* @param \App\Area $area
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$area = Area::find($id);
return view('naturezas.area.editar_area')->with(['area' => $area]);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\Area $area
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$validated = $request->validate([
'nome' => 'required',
]);
$area = Area::find($id);
$grandeArea = GrandeArea::find($area->grande_area_id);
$area->nome = $request->nome;
$area->update();
return redirect( route('grandearea.show', ['id' => $area->grande_area_id]) )->with(['grandeArea' => $grandeArea,'mensagem' => 'Área atualizada com sucesso']);
}
/**
* Remove the specified resource from storage.
*
* @param \App\Area $area
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$area = Area::find($id);
$id = $area->grande_area_id;
$area->delete();
//ver a questão de chave estrangeira para a tabela sub-áreas
$grandeArea = GrandeArea::find($id);
return redirect( route('grandearea.show', ['id' => $id]) )->with(['grandeArea' => $grandeArea,'mensagem' => 'Área deletada com sucesso']);
}
public function consulta(Request $request) {
$id = json_decode($request->id) ;
$areas = Area::where('grande_area_id', $id)->orderBy('nome')->get();
return response()->json($areas);
return $areas->toJson();
}
}