public static function getall($filter_group, $filter_value, $sort)
{
if ($filter_group == 1) {
$input_date = explode("/", $filter_value);
$date = $input_date[2] . "-" . $input_date[1] . "-" . $input_date[0];
$event = event::where('event_date', '=', $date)->orderBy('event_date')->get();
} else {
if ($filter_group == 2 && $filter_value != "all") {
$event = event::where('event_status', '=', $filter_value)->orderBy('event_date')->get();
} else {
if ($filter_group == 2 && $filter_value == "all") {
$event = event::orderBy('event_status')->get();
} else {
$now = date("Y-m-d");
$event = event::where('event_date', '>=', $now)->orderBy('event_date')->get();
}
}
}
$returnhtml = "<table class='table table-bordered table-hover table-striped'>\n <thead>\n <tr>\n <th class='text-center'>ยื่นขอทำงานนี้</th>\n <th class='text-center'>จัดการคน</th>\n <th class='text-center'>วันที่</th>\n <th class='text-center'>ช่วงเวลางาน</th>\n <th class='text-center'>ชื่องาน</th>\n <th class='text-center'>ชื่อลูกค้า</th>\n <th class='text-center'>สถานที่จัดประชุม</th>\n <th class='text-center'>สถานะของงาน</th>\n </tr>\n </thead>\n <tbody>";
foreach ($event as $record) {
$customerid = $record->customer_id;
$customer = customer::where('id', '=', $customerid)->first();
$customername = $customer->symbol . " - " . $customer->name;
$event_status = Getdataform::event_status($record->event_status, 'getvalue');
//get venue
//$venueid = $record->venue_id;
$venuename = venue_room_control::venue_detail($record->id, "link");
//end get venue id
$split_event_date = explode("-", $record->event_date);
$event_date = $split_event_date[2] . "/" . $split_event_date[1] . "/" . $split_event_date[0];
if ($record->meeting_period == 2) {
$meeting_period = "ช่วงเช้า";
} else {
if ($record->meeting_period == 3) {
$meeting_period = "ช่วงบ่าย";
} else {
$meeting_period = "ทั้งวัน";
}
}
if (LoginController::checkverifyuser()) {
$request_botton = "<form style='display:inline;' role='form' method='POST' action='request_event' >\n <input type='hidden' name='_token' value='" . csrf_token() . "'>\n <input type='hidden' name='event_id' value='" . $record->id . "'>\n <a class='btn btn-success btn-circle request_this_event' id='" . $record->id . "'>\n <i class='fa fa-sign-in fa-lg request_this_event' style='cursor:pointer;' id='" . $record->id . "'></i>\n </a>\n <button type='submit' class='btn btn-success btn-circle hidden' id='submit_" . $record->id . "'>\n <i class='fa fa-sign-in fa-lg request_this_event' style='cursor:pointer;'></i>\n </button>\n </form>";
} else {
$request_botton = "";
}
if (LoginController::checkpermission(2)) {
$assign_botton = "<a href='assigment/" . $record->id . "' class='btn btn-outline btn-info btn-circle' target='_blank'>\n <i class='fa fa-user fa-lg' style='cursor:pointer;'></i>\n </a>";
} else {
$assign_botton = "";
}
$returnhtml .= "<tr><td class='text-center'>" . $request_botton . "</td><td class='text-center'>" . $assign_botton . "</td></td><td class='text-center'>" . $event_date . "</td></td><td class='text-center'>" . $meeting_period . "</td><td class='text-center'><a href='event_detail/" . $record->id . "'>" . $record->event_name . "</a><td class='text-center'><a href='customer_detail/" . $customerid . "'>" . $customername . "</a><td class='text-center'>" . $venuename . "</td><td class='text-center'>" . $event_status . "</td><tr>";
}
$returnhtml .= "</tbody>\n </table>";
echo $returnhtml;
}
