public static function query_data($venue_id)
{
if (!empty($venue_id)) {
$area_select = venue::where('id', '=', $venue_id)->first();
}
$area_all = venue_area::orderBy('area_name')->get();
if (isset($area_select) && $area_select->venue_area) {
$data['select'] = ['id' => $area_select->venue_area->id, 'name' => $area_select->venue_area->area_name];
}
if (!empty($area_all)) {
foreach ($area_all as $record) {
$data['all_area'][] = ['id' => $record->id, 'name' => $record->area_name];
}
}
if (!empty($data) && isset($data)) {
return $data;
}
}
public function edit()
{
//check input form
$validate = validatevenue::validateeditvenue(Request::all());
if ($validate->passes()) {
$venue = venue::where("id", "=", Request::input('id'))->first();
$venue->name = Request::input('name');
$venue->address = Request::input('address');
$venue->phone = Request::input('phone');
$venue->venue_area_id = Request::input('venue_area');
if ($venue->save()) {
return redirect::to('venue_detail/' . Request::input('id'))->with('status', "แก้ไขข้อมูลสถานที่จัดงาน " . Request::input('name') . " สำเร็จ");
} else {
return redirect::to('edit_venue/' . Request::input('id'))->withInput(Request::except('password'))->withErrors("เกิดข้อผิดพลาด - ไม่สามารถแก้ไขข้อมูลลูกค้าได้");
}
} else {
return redirect::to('edit_venue/' . Request::input('id'))->withInput(Request::all())->withErrors($validate->messages());
}
}
