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 get_event_date($event_id)
{
$event = event::where('id', '=', $event_id)->first();
return $event->event_date;
}
public static function main($method, $value)
{
if ($method == "Get_request_event") {
$Udata = AS_Requestjob::get_request_event($value);
$return_html = Assign::generate_html($Udata, "");
echo $return_html;
} else {
if ($method == "Get_request_date") {
$Udata = AS_Requestjob::get_request_day($value);
$return_html = Assign::generate_html($Udata, "");
echo $return_html;
} else {
if ($method == "Get_all_user") {
$Udata = AS_Requestjob::get_all_user($value);
$return_html = Assign::generate_html($Udata, "");
echo $return_html;
} else {
if ($method == "Get_assign_user") {
$Udata = AS_Requestjob::Get_assign_user($value);
$return_html = Assign::generate_html($Udata, "assignment_user");
echo $return_html;
} else {
if ($method == "remove_from_assign") {
$remove_type = $value["type"];
$event_id = $value["event_id"];
$user_id = $value["user_id"];
$not_include = $value["not_include"];
$include = $value["include"];
if ($remove_type == "assignment_user") {
if (!empty($user_id)) {
$Moveto = AS_Requestjob::find_user_request_type($event_id, $user_id);
if ($Moveto == "request_event_user") {
$Udata = AS_Requestjob::get_request_event($event_id);
} else {
if ($Moveto == "request_job_user") {
$Udata = AS_Requestjob::get_request_day($event_id);
} else {
$Udata = AS_Requestjob::get_all_user($event_id);
}
}
$event = event::where("id", "=", $event_id)->first();
$event_date = $event->event_date;
$usernameall = AS_Member::get_user_data($user_id, 'fullname');
$usergrade = AS_Member::get_user_detail($user_id, 'grade');
$sortgrade = AS_Member::get_user_detail($user_id, 'sortgrade');
$userstatus = Check_busy::main($user_id, $event_date);
$assign_id = "";
$category = "assignment_user";
$Udata[] = ["user_id" => $user_id, "usernameall" => $usernameall, "usergrade" => $usergrade, "sortgrade" => $sortgrade, "userstatus" => $userstatus, "assign_id" => $assign_id, "category" => $category];
}
} else {
if ($remove_type == "request_event_user") {
$Udata = AS_Requestjob::get_request_event($event_id);
$Moveto = "request_event_user";
} else {
if ($remove_type == "request_job_user") {
$Udata = AS_Requestjob::get_request_day($event_id);
$Moveto = "request_job_user";
} else {
$Udata = AS_Requestjob::get_all_user($event_id);
$Moveto = "all_user";
}
}
}
if (!empty($not_include)) {
for ($i = 0; $i < count($not_include); $i++) {
foreach ($Udata as $key => $value) {
if ($value["user_id"] == $not_include[$i]) {
unset($Udata[$key]);
}
}
}
}
usort($Udata, function ($a, $b) {
return $b["sortgrade"] - $a["sortgrade"];
});
$return_html = Assign::generate_html($Udata, "");
$arr = array("code_return" => $return_html, "moveto" => $Moveto);
echo json_encode($arr);
}
}
}
}
}
}
public static function request_event()
{
$count_job_request = request_job::where('event_id', '=', Request::input('event_id'))->where('user_id', '=', Auth::user()->id)->count();
if ($count_job_request > 0) {
return redirect::to("event")->with('status', "คุณได้ยื่นขอทำงานนี้แล้ว");
} else {
$event = event::where("id", "=", Request::input('event_id'))->first();
$request_name = $event->event_name;
$start_date = $event->event_date;
$end_date = $event->event_date;
$duration = $event->meeting_period;
//=====================================================================================
$request = new request_job();
$request->request_name = $request_name;
$request->user_id = Auth::user()->id;
$request->start_date = $start_date;
$request->end_date = $end_date;
$request->duration = $duration;
$request->event_id = Request::input('event_id');
$request->multiple_day = 0;
$url = "event";
if ($request->save()) {
return redirect::to($url)->with('status', "ยื่นขอทำงานสำเร็จ");
} else {
return redirect::to($url)->withInput(Request::except('password'))->withErrors("เกิดข้อผิดพลาด - ไม่สามารถยื่นขอทำงานนี้ได้ กรุณาติดต่อผู้ดูแลระบบ");
}
}
}
public static function get_assign_event($date, $user_id)
{
$event_data = "<td valign='top'>";
$event = event::where('event_date', '=', $date)->get();
foreach ($event as $data) {
//เช็คช่วงเวลา request
if ($data->meeting_period == 2) {
$event_color_class = "event_color_morning";
} else {
if ($data->meeting_period == 3) {
$event_color_class = "event_color_afternoon";
} else {
$event_color_class = "event_color_allday";
}
}
$count = Assignment::where('event_id', '=', $data->id)->where('user_id', '=', $user_id)->count();
if ($count > 0) {
$assignment = Assignment::where('event_id', '=', $data->id)->where('user_id', '=', $user_id)->get();
foreach ($assignment as $data_assign) {
//$event_data .= "<div id='". $date ."' class='st-c st-s'>".$data_assign->id."</div>";
$event_data .= "<div id='" . $data->id . "' class='st-c-pos goto_assign'>\n <div class='rb-n " . $event_color_class . "' >\n <div class='rb-ni'>" . $data->event_name . "</div>\n </div>\n </div>";
}
}
}
$event_data .= "</td>";
return $event_data;
}
public static function getuserform($id, $type)
{
$user = Member::orderBy('name')->get();
if ($type == 'edit') {
$event = event::where("id", "=", $id)->first();
$id = $event->staff_contact_id;
}
echo "<select name='staff_contact_id' id='staff_contact_id' class='form-control'>";
foreach ($user as $recode) {
echo "<option value='" . $recode->id . "'";
if ($id == $recode->id) {
echo " selected='selected'";
}
echo ">" . $recode->nickname . " - " . $recode->name . " " . $recode->surname . "</option>";
}
echo "</select>";
}
public static function get_customer_contact($id, $value)
{
$event = event::where("id", "=", $id)->first();
$cus_contact_id = $event->custumer_contact_id;
$contact = contact_person::where("id", "=", $cus_contact_id)->first();
$datareturn = $contact->{$value};
return $datareturn;
}