public static function New_Assign($assign_id) { $root_url = dirname($_SERVER['PHP_SELF']); $root_url = "http://ojconsultinggroup.com" . $root_url; $assingment = Assignment::where("id", "=", $assign_id)->first(); $user = Member::where("id", "=", $assingment->user_id)->first(); $event = event::where("id", "=", $assingment->event_id)->first(); $customer_id = $event->customer_id; $venue_id = $event->venue_id; $venue_room = venue::where("id", "=", $venue_id)->first(); $customer = customer::where("id", "=", $customer_id)->first(); $userid = $user->id; $idcard = $user->id_card; $name = $user->name . " " . $user->surname; $email = $user->email; $event_name = $event->event_name; $event_type = $event->event_type; $split_event_date = explode("-", $event->event_date); $event_date = $split_event_date[2] . " " . AssignCalendar::get_month_thai($split_event_date[1]) . " " . AssignCalendar::get_BE_year($split_event_date[0]); $staff_appointment_time = $event->staff_appointment_time; $customer_name = $customer->symbol . " - " . $customer->name; $venue_name = $venue_room->venue->name . " : " . $venue_room->room_name; $venue_address = $venue_room->venue->address; $subject = "OJ - คุณได้รับมอบหมายงานในวันที่ " . $event_date; $data = array('root_url' => $root_url, 'userid' => $userid, 'idcard' => $idcard, 'id' => $assign_id, 'name' => $name, 'event_name' => $event_name, 'event_type' => $event_type, 'event_date' => $event_date, 'staff_appointment_time' => $staff_appointment_time, 'customer_name' => $customer_name, 'venue_name' => $venue_name, 'venue_address' => $venue_address, 'subject' => $subject, 'email' => $email); Mail::queue('Assign.New_assign_mail', $data, function ($message) use($data) { $message->to($data['email'])->subject($data['subject']); }); }
public static function get_room($event_id) { $event = event::where("id", "=", $event_id)->first(); $room_id = $event->venue_id; $venue_room = venue_room::where('id', '=', $room_id)->first(); $venue_name = $venue_room->venue->name; $room_name = $venue_room->room_name; $full_name = $venue_name . " - " . $room_name; $room_id = $venue_room->id; $rooom_list = "[" . $room_id . "] " . $full_name; return $rooom_list; }
public static function main() { $venue_room = venue_room::orderBy('room_name')->get(); $user_list = array(); foreach ($venue_room as $query) { $venue_name = $query->venue->name; $room_name = $query->room_name; $full_name = $venue_name . " - " . $room_name; $room_id = $query->id; $rooom_list[] = "[" . $room_id . "] " . $full_name; } echo json_encode($rooom_list); }
public static function get_edit_room_form($room_id) { $venue_room = venue_room::where('id', '=', $room_id)->first(); $plan_url = $venue_room->room_plan; $room_name = $venue_room->room_name; $form_room_name = '<input type="text" class="form-control" name="name" id="room_name" value="' . $room_name . '"> <input type="hidden" class="form-control" name="room_url" id="room_url" value="' . $plan_url . '">'; $form_plan_room = '<form action="../uploadplan" method="post" enctype="multipart/form-data" class="Edit_plan_form" id="Edit_plan_id_' . $room_id . '"> <div id="result" class="hidden"></div> <input type="hidden" name="method" value="edit_image"> <input type="hidden" name="room_id" value="' . $room_id . '"> <input name="image_file" id="imageInput" type="file" /> <div class="progress upload_progress hidden" > <div class="bar upload_bar"></div> <div class="percent upload_percent">0%</div> </div> <div id="output"></div> <button room_id="' . $room_id . '" class="edit_plan" value="Upload" >upload</button> </form>'; return json_encode(array("form_plan_room" => $form_plan_room, "form_room_name" => $form_room_name)); }