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