public function add()
{
//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 = new event();
$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')->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());
}
}
