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