public static function add_contact() { //check input form $validate = validatecontact::validatecontact(Request::all()); if ($validate->passes()) { $contact_person = new contact_person(); $contact_person->name = Request::input('name'); $contact_person->position = Request::input('position'); $contact_person->email = Request::input('email'); $contact_person->phone = Request::input('phone'); $contact_person->mobile = Request::input('mobile'); $contact_person->remark = Request::input('remark'); $contact_person->customer_id = Request::input('customer_id'); if ($contact_person->save()) { return redirect::to('customer_detail/' . Request::input('customer_id'))->with('status', "เพิ่มผู้ประสานงานชื่อ " . Request::input('name') . " สำเร็จ"); } else { return redirect::to('add_contact/' . Request::input('customer_id'))->withInput(Request::except('password'))->withErrors("เกิดข้อผิดพลาด - ไม่สามารถเพิ่มผู้ประสานงานได้"); } } else { return redirect::to('add_contact/' . Request::input('customer_id'))->withInput(Request::all())->withErrors($validate->messages()); } }
public function edit() { //check input form $validate = validateevent::validateevent(Request::all()); if ($validate->passes()) { $custumer_contact_id = Request::input('customer_contact_select'); if ($custumer_contact_id == 0) { $customer_id = Request::input('customer_id'); $contact_name = Request::input('custumer_contact_name'); $contact_phone = Request::input('custumer_contact_phone'); $contact_person = new contact_person(); $contact_person->name = $contact_name; $contact_person->phone = $contact_phone; $contact_person->customer_id = $customer_id; $contact_person->save(); $contact_person_result = contact_person::where("name", "=", $contact_name)->where("customer_id", "=", $customer_id)->first(); $custumer_contact_id = $contact_person_result->id; } $input_event_date = explode("/", Request::input('event_date')); $event_date = $input_event_date[2] . "-" . $input_event_date[1] . "-" . $input_event_date[0]; $input_stert_time = explode(" ", Request::input('stert_time')); $stert_time = $input_stert_time[0] . ":" . $input_stert_time[2] . ":00"; $input_register_time = explode(" ", Request::input('register_time')); $register_time = $input_register_time[0] . ":" . $input_register_time[2] . ":00"; $input_staff_appointment_time = explode(" ", Request::input('staff_appointment_time')); $staff_appointment_time = $input_staff_appointment_time[0] . ":" . $input_staff_appointment_time[2] . ":00"; $input_setup_date = explode("/", Request::input('setup_date')); $setup_date = $input_setup_date[2] . "-" . $input_setup_date[1] . "-" . $input_setup_date[0]; $input_setup_time = explode(" ", Request::input('setup_time')); $setup_time = $input_setup_time[0] . ":" . $input_setup_time[2] . ":00"; $input_supplier_date = explode("/", Request::input('supplier_date')); $supplier_date = $input_supplier_date[2] . "-" . $input_supplier_date[1] . "-" . $input_supplier_date[0]; $input_supplier_time = explode(" ", Request::input('supplier_time')); $supplier_time = $input_supplier_time[0] . ":" . $input_supplier_time[2] . ":00"; $input_venue = explode("]", Request::input('venue_id')); $splite_venue = explode("[", $input_venue[0]); $venue_id = $splite_venue[1]; /*$input_setup_time = explode(" ", Request::input('setup_time')); $time_setup_time = $input_setup_time[1].":".$input_setup_time[3].":00"; $split_date_setup_time = explode("/", $input_setup_time[0]); $date_setup_time = $split_date_setup_time[2]."-".$split_date_setup_time[1]."-".$split_date_setup_time[0]; $setup_time = $date_setup_time." ".$time_setup_time; $input_supplier_time = explode(" ", Request::input('supplier_time')); $time_supplier_time = $input_supplier_time[1].":".$input_supplier_time[3].":00"; $split_supplier_time = explode("/", $input_supplier_time[0]); $date_supplier_time = $split_supplier_time[2]."-".$split_supplier_time[1]."-".$split_supplier_time[0]; $supplier_time = $date_supplier_time." ".$time_supplier_time;*/ $event = event::where("id", "=", Request::input('id'))->first(); $event->event_name = Request::input('event_name'); $event->customer_id = Request::input('customer_id'); $event->event_type = Request::input('event_type'); $event->event_date = $event_date; $event->venue_id = $venue_id; $event->register_point = Request::input('register_point'); $event->summary_point = Request::input('summary_point'); $event->stert_time = $stert_time; $event->register_time = $register_time; $event->setup_date = $setup_date; $event->setup_time = $setup_time; $event->staff_appointment_time = $staff_appointment_time; $event->supplier_date = $supplier_date; $event->supplier_time = $supplier_time; $event->custumer_contact_id = $custumer_contact_id; $event->hotel_contact_name = Request::input('hotel_contact_name'); $event->hotel_contact_phone = Request::input('hotel_contact_phone'); $event->supplier_contact_name = Request::input('supplier_contact_name'); $event->supplier_contact_phone = Request::input('supplier_contact_phone'); $event->staff_contact_id = Request::input('staff_contact_id'); $event->meeting_period = Request::input('meeting_period'); $event->event_status = Request::input('event_status'); if ($event->save()) { return redirect::to('event_detail/' . Request::input('id'))->with('status', "แก้ไขข้อมูลงานที่กำลังเปิดรับชื่อ " . Request::input('event_name') . " สำเร็จ"); } else { return redirect::to('add_event')->withInput(Request::except('password'))->withErrors("เกิดข้อผิดพลาด - ไม่สามารถแก้ไขข้อมูลงานที่กำลังเปิดรับได้"); } } else { return redirect::to('add_event')->withInput(Request::all())->withErrors($validate->messages()); } }