public function getIndex($route = '', $content = '', $idContent = '')
{
if ($route == '') {
$event = Events::where('title', '=', 'CURSO')->take(1)->get();
$courses = isset($event[0]) ? $event[0]->getPublishCourses() : null;
foreach ($courses as $course) {
$course->start = date("d-m-Y", strtotime($course->start));
$course->end = date("d-m-Y", strtotime($course->end));
}
return View::make('frontend.courses.index')->with(array('courses' => $courses));
} elseif ($route != '') {
$course = Courses::findRoute($route);
if ($course) {
$course->start = date("d-m-Y", strtotime($course->start));
$course->end = date("d-m-Y", strtotime($course->end));
switch ($content) {
case '':
return self::getCourseContent($route, $course, $idContent);
break;
case 'conteudo':
return self::getCourseContent($route, $course, $idContent);
break;
/*
case 'inscricoes':
return self::getCourseInscription( $route, $course, $idContent );
break;
case 'trabalhos':
return self::getCourseWorks( $route, $course, $idContent );
break;
*/
/*
case 'inscricoes':
return self::getCourseInscription( $route, $course, $idContent );
break;
case 'trabalhos':
return self::getCourseWorks( $route, $course, $idContent );
break;
*/
case 'acesso':
return self::getCourseSignin($route, $course, $idContent);
break;
case 'arquivos':
return self::getCourseFiles($route, $course, $idContent);
break;
case 'trabalhosactualizacao':
return self::getCourseFilesUploaded($route, $course, $idContent);
break;
case 'pagamento':
return self::getCoursePayment($route, $course, $idContent);
break;
default:
return self::getCourseContent($route, $course, $idContent);
break;
}
} else {
return View::make('specialpages.404');
}
}
}
/**
* undocumented function
*
* @return void
* @author
**/
public static function isExist($id)
{
$count = Events::where('event_category_id', $id)->count();
if ($count > 0) {
return true;
}
return false;
}
public function get_index()
{
$event = Events::where('status', '=', 3)->get();
if (is_null($event)) {
return json_encode('Event not found', 404);
} else {
return json_encode($event);
}
}
public function getIndex()
{
$event = Events::where('title', '=', 'EVENTOS')->take(1)->get();
$courses = isset($event[0]) ? $event[0]->getPublishCourses() : null;
foreach ($courses as $course) {
$course->start = date("d-m-Y", strtotime($course->start));
$course->end = date("d-m-Y", strtotime($course->end));
}
return View::make('frontend.events.index')->with(array('courses' => $courses));
}
public function getEvents()
{
$inputs = Input::all();
$term = $inputs['term'];
$result = Events::where('name', 'LIKE', '%' . $term . '%')->select('name as label', 'id')->get();
if (isset($result)) {
return Response::json($result);
}
return Response::json(array("status" => "clear"));
}
public function postGetEvent()
{
$school_id = $this->getSchoolId();
$all_events = Events::where('school_id', '=', $school_id)->get();
$i = 0;
foreach ($all_events as $all_event) {
$event_type_name = EventTypes::where('id', '=', $all_event->category)->get()->first();
$all_events[$i++]['category'] = $event_type_name->event_type_name;
}
return Response::json($all_events);
}
public function getIndex()
{
$event = Events::where('title', '=', 'EVENTOS')->take(1)->get();
$courses = isset($event[0]) ? $event[0]->getPublishCourses(3) : null;
$banner = SFNews::where('sticky', '=', '0')->where('category', '=', '0')->where('status', '=', '1')->where('home', '=', '1')->orderBy('date', 'DESC')->take(3)->get();
$principal = SFNews::where('sticky', '=', '0')->where('category', '=', '1')->where('status', '=', '1')->where('home', '=', '1')->orderBy('date', 'DESC')->take(1)->get();
$news = SFNews::where('status', '=', '1')->where('home', '=', '1')->orderBy('date', 'DESC')->take(3)->get();
$video = SFVideos::where('position', '=', '1')->take(1)->get();
$video = isset($video[0]) ? $video[0] : null;
$args = array('news' => $news, 'courses' => $courses, 'principal' => $principal, 'banner' => $banner, 'video' => $video);
return View::make('frontend.home.index')->with($args);
}
/**
* undocumented function
*
* @return void
* @author
**/
public static function isExist($id)
{
$count1 = SocialTarget::where('city_id', $id)->count();
$count2 = SocialAction::where('city_id', $id)->count();
$count3 = Events::where('city_id', $id)->count();
$count4 = User::where('city_id', $id)->count();
$count = $count1 + $count2 + $count3 + $count4;
if ($count > 0) {
return true;
}
return false;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$this->info("searching for event candidates...");
// get all relevant events
$all_events = Events::where('ticketsystem_enabled', 1)->where('ticketsystem_autoremind', 1)->whereNotNull('ticketsystem_autoremind_user_id')->whereNotNull('ticketsystem_recording_startdate')->get();
error_log('All Events ' . json_encode($all_events));
$curr_year = date("Y", strtotime('now'));
$curr_week = date("W", strtotime('now'));
// iterate to get at the event ticket types without sales
foreach ($all_events as $key => $curr_event) {
$this->info("event with ticketsystem enabled found...");
// event ticket types
$ticket_types = $curr_event->ticket_types()->get();
$event_has_incomplete_sales = false;
foreach ($ticket_types as $key => $tt) {
// No point sending multiple notifications for same event and different ticket types
if ($event_has_incomplete_sales) {
break;
}
$this->info("searching event ticket types...");
for ($days_added = 0;; $days_added += 7) {
$cmp_ts = strtotime($curr_event->ticketsystem_recording_startdate . " +" . $days_added . " days");
if ($cmp_ts > strtotime('now')) {
break;
}
// get the week and year
$cmp_year = date("Y", $cmp_ts);
$cmp_week = date("W", $cmp_ts);
// get the ones without sales entries at some week between ticketsystem startdate and now
$tt_weekly_sales = TicketSold::where('event_ticket_types_id', $tt->id)->where('week', $cmp_week)->where('year', $cmp_year)->first();
if (!$tt_weekly_sales) {
$this->comment("notifying promoter...");
// get the user to be notified
$promoter = User::find($curr_event->ticketsystem_autoremind_user_id);
// create autologin entry
$confirmation_code = str_random(30);
$autologin_entry = TicketSalesAutologin::create(['users_id' => $promoter->id, 'events_id' => $curr_event->id, 'token' => $confirmation_code]);
if ($autologin_entry) {
// send notification
Mail::send('emails.promoters.incomplete_sales', array('promoter' => $promoter, 'curr_event' => $curr_event, 'autologin' => $autologin_entry), function ($message) use($promoter) {
$message->to($promoter->email, $promoter->username)->subject("Alda: Incomplete ticket sales");
});
}
$event_has_incomplete_sales = true;
break;
}
}
}
}
}
public function getSession($id)
{
// init
$data = array();
$event = Events::where('id', $id)->first();
if ($event == false) {
return App::abort('404');
}
$data['view'] = $event;
// // get photos
$data['photos'] = Photo::where('type_name', '=', 'events')->where('type_id', '=', $event->id)->where('status', '=', 1)->get();
$data['social_actions'] = SocialAction::with(array('city', 'category'))->join('social_action_events', 'social_action_events.social_action_id', '=', 'social_actions.id')->where('event_id', '=', $event->id)->where('social_actions.status', '=', 1)->orderBy('social_actions.id', 'desc')->get();
$data['social_target_id'] = SocialTarget::getAll();
$data['social_action_category_id'] = SocialActionCategory::getAll();
$data['city_id'] = City::getAll();
Session::put('type_name', 'Events');
Session::forget('type_id');
Session::put('event_id', $event['id']);
return Redirect::route('buat-aksi-sosial');
}
public function eventModify()
{
$evId = Input::get('evId');
Events::where('evId', $evId)->update(array('evName' => Input::get('evName'), 'evIntro' => Input::get('evIntro'), 'evRules' => Input::get('evRules'), 'evCat' => Input::get('evCat')));
$phone = Input::get('phone');
$k = Organizer::where('evId', $evId);
if ($k) {
$k->delete();
}
foreach (Input::get('name') as $key => $name) {
if (strlen($name) > 0) {
$organizer = new Organizer();
$organizer->name = $name;
if (strlen($phone[$key]) > 0) {
$organizer->phone = $phone[$key];
}
$organizer->evId = $evId;
$organizer->save();
}
}
return Redirect::to('admin/event/' . $evId)->with('isErr', false)->with('msg', 'Successfully updated event.');
}
public function delete_event_image_1()
{
try {
$sequence = 0;
$id = Input::get('id');
$_arrayImages = explode(";", Input::get('images'));
$images = $_arrayImages;
$image = Input::get('image');
$new_image = '';
foreach ($images as $_image) {
if ($_image != $image) {
if ($sequence == count($images) - 1) {
$new_image .= $_image;
} else {
$new_image .= $_image . ';';
}
}
$sequence++;
}
if (ends_with($new_image, ';')) {
$_arrayImages = '';
$_arrayImages = explode(";", $new_image);
$new_image = '';
$sequence = 0;
foreach ($_arrayImages as $_image) {
$sequence++;
if ($sequence < count($images) - 1) {
$new_image .= $_image . ';';
} else {
if ($sequence == count($images) - 1) {
$new_image .= $_image;
}
}
}
}
$isUpdate = Events::where('eventId', $id)->update(array('eventPicturesContent' => $new_image));
return Response::json(['status' => 'success', 'msg' => 'Đăng nhập thành công!']);
} catch (Exception $_ex) {
Log::error('Error: ' . $_ex);
return Response::json(['status' => 'error', 'msg' => 'Đăng nhập thành công!']);
}
}
public function getEvents()
{
/*
Get all events asociated with logged in promoter
*/
//check if user is authenticated
$auser = Auth::user();
if (!$auser) {
eerror_log('user not authenticated');
return Response::json((object) null);
}
// storage
$all_user_events = [];
////////////////////////////////
// associated through company //
////////////////////////////////
$user = User::find($auser->id);
if (!$user) {
eerror_log('could not find user');
return Response::json((object) null);
}
// non fatal - no company associated
if (!$user->company()->first()) {
eerror_log('no company associated with user');
}
if ($user && $user->company()->first()) {
eerror_log('company found');
// get them all
$user_companies = $user->company()->get();
foreach ($user_companies as $company_ndx => $company_val) {
// get associated events
$tmp_company_events = $company_val->events()->get();
eerror_log('>>> company ' . json_encode($company_val));
eerror_log('>>> company events ' . json_encode($tmp_company_events));
foreach ($tmp_company_events as $cevents_ndx => $cevents_val) {
// dump them
$all_user_events[] = $cevents_val;
}
}
}
/////////////////////
// associated with //
/////////////////////
$user_events = $user->events()->get();
foreach ($user_events as $user_eventsr_key => $user_event) {
$all_user_events[] = $user_event;
Debugbar::info('added event user', $user_event);
}
////////////////
// created by //
////////////////
$events_created_by_user = Events::where('created_by', $user->id)->get();
foreach ($events_created_by_user as $events_created_by_user_key => $events_created_by_user_value) {
$all_user_events[] = $events_created_by_user_value;
}
$resp = [];
$company_events = null;
if (count($all_user_events) > 0) {
foreach ($all_user_events as $event_ndx => $curr_event) {
$event_details = $this->getDetails($curr_event);
if (strtotime($event_details['date']) < strtotime('now')) {
eerror_log('>>>>>>>>>>>> Event Date is in the past ' . json_encode($event_details['date']));
continue;
}
$cats = $this->getTaskCategories();
$company_events[] = $curr_event;
$event_tasks = $this->getTasks($curr_event);
$categorized_event_tasks = $this->getCategorizedTasks($curr_event);
// Le tickets
list($ticket_types, $ticket_aggregate, $yearly_tickettype_aggregate, $global_aggregate) = $this->getTickets($curr_event);
// calc cumulative task updates for current event
$event_updates_files = 0;
$event_updates_comments = 0;
foreach ($event_tasks as $task_ndx => $curr_task) {
if ($curr_task['info']['status'] === "incomplete") {
$event_updates_files += (int) $curr_task['info']['cnt_updated_files'];
$event_updates_comments += (int) $curr_task['info']['cnt_updated_comments'];
}
}
$resp[] = ['cats' => $cats, 'currencies' => $this->getCurrencies(), 'cat_tasks' => $categorized_event_tasks, 'details' => $event_details, 'due_date' => strtotime($event_details['deadline']), 'event' => $curr_event, 'logged_in_id' => $user->id, 'tasks' => $event_tasks, 'ticket_types' => $ticket_types, 'tickets' => $ticket_aggregate, 'tickets_yearly' => $yearly_tickettype_aggregate, 'global_sales' => $global_aggregate, 'updated_files' => $event_updates_files, 'updated_comments' => $event_updates_comments];
}
}
return Response::json($resp);
}
public function createPost()
{
if (Request::isMethod('post')) {
$input = Input::all();
$postEvent = SocialTarget::StoreSocialTarget($input);
if (array_key_exists('msg', $postEvent) && $postEvent['msg'] == 'ok') {
// check if any mutliple upload photo
$CountPhoto = Photo::where('tmp', Session::get('time'))->count();
if ($CountPhoto > 0) {
Photo::updatePhotos('social_targets', $postEvent['id']);
Photo::roolback();
// set default photo
$setPhoto = Photo::where('user_id', Auth::user()->id)->where('type_name', 'social_targets')->where('type_id', $postEvent['id'])->first();
$setPhotoRow = array('default_photo_id' => $setPhoto->id);
Events::where('id', $postEvent['id'])->update($setPhotoRow);
}
Session::flash('sukses', 'Target Sosial Berhasil di Rekap');
return Redirect::route('admin.social-target')->withInput();
} else {
// get session validation
Session::put('validasi', 'social_targets');
Session::flash('validasi', $postEvent);
return Redirect::route('admin.social-target.create')->withInput(Input::except('social_target_category_id', 'user_id', 'city_id'));
}
}
}
public static function UpdateEvent($input)
{
$id = $input['id'];
$rules = array('event_category_id' => 'required', 'city_id' => 'required', 'name' => 'required', 'stewardship' => 'required|min:5', 'description' => 'required|min:5', 'location' => 'required', 'started_at' => 'required', 'ended_at' => 'required');
$validator = Validator::make($input, $rules);
if ($validator->fails()) {
return $validator->errors()->all();
} else {
$started_at = empty($input['started_at']) ? 'no' : preg_split("/([\\/: ])/", $input['started_at']);
$ended_at = empty($input['ended_at']) ? 'no' : preg_split("/([\\/: ])/", $input['ended_at']);
$input = array('event_category_id' => $input['event_category_id'], 'city_id' => $input['city_id'], 'email' => $input['email'], 'name' => $input['name'], 'user_id' => Auth::check() ? Auth::user()->id : '', 'stewardship' => $input['stewardship'], 'description' => $input['description'], 'location' => $input['location'], 'website_url' => $input['website_url'], 'social_media_urls' => $input['social_media_urls'], 'status' => $input['status'], 'started_at' => mktime((int) $started_at[3], (int) $started_at[4], 0, (int) $started_at[0], (int) $started_at[1], (int) $started_at[2]), 'ended_at' => mktime((int) $ended_at[3], (int) $ended_at[4], 0, (int) $ended_at[0], (int) $ended_at[1], (int) $ended_at[2]), 'created_at' => time(), 'updated_at' => time());
$getSlug = Events::where('id', $id)->first();
$slug = Str::slug($input['name']);
// jika input tidak sama dengan slug di database
if (strcmp($input['name'], $getSlug['name']) != 0) {
$checkSlug = Events::where('slug', $slug)->where('id', '!=', $id)->count();
if ($checkSlug > 0) {
$input['slug'] = $slug . "-" . $id;
} else {
$input['slug'] = $slug;
}
}
$photo = Photo::updateAvatar($getSlug['cover_photo_id'], 'events', $getSlug->id);
$input['cover_photo_id'] = $photo['cover_photo_id'];
$event = Events::find($id);
$event->fill($input);
$event->save();
return "ok";
}
}
public function renderDefault()
{
$this->template->subjects = $this->places->order('name')->where('subject.id != 1')->group('subject.id')->having('COUNT(:event.id) > 0');
$this->template->approvedPlacesCount = $this->approvedPlacesCount;
$this->template->subject_id = $this->subject_id;
if ($this->subject_id != 'all') {
$this->events->where('subject_id', $this->subject_id)->group('event.id')->having('COUNT(:event_time.id) = 0');
}
// vyhledavani
if ($this->q) {
$this->events->where("event.name LIKE ? OR subject.name LIKE ? OR user.email LIKE ?", "%" . $this->q . "%", "%" . $this->q . "%", "%" . $this->q . "%");
$this->places->where("subject.name LIKE ?", "%" . $this->q . "%");
$this['search']['q']->setDefaultValue($this->q);
$this->template->search = TRUE;
} else {
$this->template->search = FALSE;
}
if ($this->order == '' && $this->user->isInRole('administrator')) {
$this->order = 'updated DESC';
}
switch ($this->what) {
case self::ANONYMOUS:
$this->events->where('subject_id', '1');
$this->template->what = self::ANONYMOUS;
break;
case self::NOTERM:
$this->events->group('event.id')->having('COUNT(:event_time.id) = 0');
$this->template->what = self::NOTERM;
break;
case self::UPDATED:
$this->events->group('event.id')->having('DATEDIFF(NOW(), event.changed) < ' . self::TIME_UPDATED);
$this->template->what = self::UPDATED;
break;
case self::RECENT:
$this->events->group('event.id')->having('DATEDIFF(NOW(), event.created) < ' . self::TIME_RECENT);
$this->template->what = self::UPDATED;
break;
case self::TOREVIEW:
$this->events->group('event.id')->having('event.reviewed = 0');
$this->template->what = self::TOREVIEW;
break;
case self::NOTAPPROVED:
$this->events->group('event.id')->having('event.approved = 0');
$this->template->what = self::NOTAPPROVED;
break;
case self::PREFERED:
$this->events->group('event.id')->having('event.prefered = 1');
$this->template->what = self::PREFERED;
break;
default:
$this->template->what = self::ALL;
}
if ($this->orderBy == '' && $this->user->isInRole('administrator')) {
$this->orderBy = self::MODIFICATION;
}
switch ($this->orderBy) {
case self::MODIFICATION:
$this->events->order('changed DESC, created DESC');
$this->template->orderBy = self::MODIFICATION;
break;
case self::ALPHABET:
default:
$this->events->order('name');
$this->template->orderBy = self::ALPHABET;
break;
}
$this->pagerEvents->itemCount = $this->events->count();
$this->template->events = $this->events->limit($this->pagerEvents->getLimit(), $this->pagerEvents->getOffset());
if ($this->user->isInRole('administrator')) {
$this->template->nonaproved = $this->context->createServiceEvents()->where('approved', '0');
}
}
<option value="none">None</option>
@foreach($all_hot_stuffs as $all_hot_stuff)
<option value="{{$all_hot_stuff->eventId}}">{{$all_hot_stuff->eventName}}</option>
@endforeach
</select>
</div>
</div>
</div>
<!-- what's cool Part -->
<div class="panel panel-primary">
<div class="panel-heading">Cool Stuff</div>
<div class="panel-body">
<div class="form-group">
<label>Event</label>
<?php
$all_cool_stuffs = Events::where('eventType', 'cool-stuff')->where('nsl_id', 'none')->where('eventVisible', '1')->get();
?>
<select class="form-control" name="cool_stuff_id">
<option value="none">None</option>
@foreach($all_cool_stuffs as $all_cool_stuff)
<option value="{{$all_cool_stuff->eventId}}">{{$all_cool_stuff->eventName}}</option>
@endforeach
</select>
</div>
</div>
</div>
<button type="button" onclick="javascript:window.history.back();" class="btn btn-default">Back</button>
<button type="submit" class="btn btn-default btn-primary">Save data</button>
<button type="reset" onclick="javascript:location.reload();" class="btn btn-default btn-danger">Cancel</button>
</form>
</div>
public function delete($id)
{
$Event = Events::where('id', $id);
$Event->delete();
Session::flash('sukses', 'Data berhasil dihapus');
return Redirect::route('admin.event');
}
public function update_event()
{
try {
$_arData = array();
$total_files = null;
$eventType = Input::get("eventType");
$eventName = Input::get("eventName");
$eventShortTitle = Input::get("eventShortTitle");
$eventContent = Input::get("eventContent");
$eventVisible = Input::get("eventVisible");
if ($eventVisible == '1') {
$eventVisible = '1';
} else {
$eventVisible = '0';
}
$_userData = Session::get('login');
$destinationPath_Events = 'asserts/images/Events';
$_countFiles = count(Input::file("fileTextImage"));
$_number = 1;
if (Input::hasfile('fileTextImage')) {
foreach (Input::file("fileTextImage") as $file) {
$filename = $file->getClientOriginalName();
if ($_number == $_countFiles) {
$total_files .= $filename;
} else {
$total_files .= $filename . ';';
}
$upload_success = $file->move($destinationPath_Events, $filename);
$_number++;
}
}
$filename_Banner = null;
if (Input::hasfile('file')) {
$file_Banner = Input::file("file");
$filename_Banner = $file_Banner->getClientOriginalName();
$upload_success_banner = $file_Banner->move($destinationPath_Events, $filename_Banner);
}
if ($filename_Banner == null && $total_files == null) {
$_arData = array('eventName' => $eventName, 'eventShortTitle' => $eventShortTitle, 'eventContent' => $eventContent, 'eventType' => $eventType, 'eventVisible' => $eventVisible, 'eventEditor' => $_userData["username"], 'eventCreatedDate' => date("Y-m-d"));
} else {
if ($filename_Banner == null && $total_files != null) {
$_arData = array('eventName' => $eventName, 'eventShortTitle' => $eventShortTitle, 'eventContent' => $eventContent, 'eventType' => $eventType, 'eventPicturesContent' => $total_files, 'eventVisible' => $eventVisible, 'eventEditor' => $_userData["username"], 'eventCreatedDate' => date("Y-m-d"));
} else {
if ($filename_Banner != null && $total_files == null) {
$_arData = array('eventName' => $eventName, 'eventShortTitle' => $eventShortTitle, 'eventContent' => $eventContent, 'eventType' => $eventType, 'eventPictures' => $filename_Banner, 'eventVisible' => $eventVisible, 'eventEditor' => $_userData["username"], 'eventCreatedDate' => date("Y-m-d"));
} else {
if ($filename_Banner != null && $total_files != null) {
$_arData = array('eventName' => $eventName, 'eventShortTitle' => $eventShortTitle, 'eventContent' => $eventContent, 'eventType' => $eventType, 'eventPictures' => $filename_Banner, 'eventPicturesContent' => $total_files, 'eventVisible' => $eventVisible, 'eventEditor' => $_userData["username"], 'eventCreatedDate' => date("Y-m-d"));
}
}
}
}
$_page_update = Events::where('eventId', Input::get("eventId"))->update($_arData);
} catch (Exception $_ex) {
Session::flash('error', '$$$ --- Error (' . $_ex->getMessage() . ') --- $$$');
}
Session::flash('success', '$$$ --- Update Event Successfully --- $$$');
return Redirect::to('qlm-admin/newsletters/' . Input::get("eventId"));
}
/**
* undocumented function
*
* @return void
* @author
**/
public function deleteDo()
{
$id = Input::get('id');
$photo = Photo::remove($id);
// Mengupdate semua fitur yang menggunakan foto menjadi 0
Events::where('default_photo_id', $id)->update(['default_photo_id' => 0]);
Events::where('cover_photo_id', $id)->update(['cover_photo_id' => 0]);
SocialAction::where('default_photo_id', $id)->update(['default_photo_id' => 0]);
SocialAction::where('cover_photo_id', $id)->update(['cover_photo_id' => 0]);
SocialTarget::where('default_photo_id', $id)->update(['default_photo_id' => 0]);
SocialTarget::where('cover_photo_id', $id)->update(['cover_photo_id' => 0]);
if ($photo) {
$lokasi = public_path() . '/photos/';
if (unlink($lokasi . $id . '.jpg') && unlink($lokasi . 'thumb_' . $id . '.jpg')) {
return Redirect::route('admin.photo')->withStatuses(['delete' => 'Hapus Sukses']);
}
return Redirect::route('admin.photo')->withErrors(['delete' => 'Delete File Gagal']);
}
return Redirect::route('admin.photo')->withErrors(['delete' => 'Delete File Gagal']);
}
<?php
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the Closure to execute when that URI is requested.
|
*/
Route::get('/', function () {
return View::make('index');
});
Route::get('/mobile', function () {
return View::make('mobile');
});
Route::resource('Areas', 'AreasController');
Route::resource('Events', 'EventsController');
Route::resource('Users', 'UsersController');
Route::resource('Occupencies', 'OccupenciesController');
Route::get('Steps/{id}', function ($id) {
$events = Events::where('user_id', '=', $id)->where('steps', '>', 1)->get();
$steps = 0;
foreach ($events as $event) {
$steps += $event->steps;
}
return Response::json(['error' => false, 'data' => ['steps' => $steps]]);
});
public function filterEvents()
{
$location = Input::get('location');
if ($location == "ทั้งหมด") {
$events = Events::orderBy('start', 'ASC')->get();
} else {
$events = Events::where('location', $location)->orderBy('start', 'ASC')->get();
}
foreach ($events as $event) {
date_default_timezone_set('Asia/Bangkok');
$date11 = $event->start;
$date21 = $event->finish;
if (date("Y-m-d H:i:s") < $date11) {
$date1 = new DateTime($date11);
$date2 = new DateTime(date("Y-m-d H:i:s"));
$interval = $date2->diff($date1);
if ($interval->days == 0) {
$event['status'] = "-3";
$event['hr'] = $interval->h;
} else {
//$event['status'] = $interval->days;
$event['status'] = "-3";
}
//$event['status'] = $interval->days;
} elseif (date("Y-m-d H:i:s") >= $date11 && date("Y-m-d H:i:s") <= $date21) {
$event['status'] = "-1";
} elseif (date("Y-m-d H:i:s") >= $date21) {
$event['status'] = "-2";
} else {
$event['status'] = "9999";
}
$start = new DateTime($date11);
$finish = new DateTime($date21);
$interval1 = $start->diff($finish);
//dd($event->start);
if ($interval1->days < 1) {
$strDate = $event->start;
$strYear = date("Y", strtotime($strDate)) + 543;
$strMonth = date("n", strtotime($strDate));
$strDay = date("j", strtotime($strDate));
$strHour = date("H", strtotime($strDate));
$strMinute = date("i", strtotime($strDate));
$strSeconds = date("s", strtotime($strDate));
$strMonthCut = array("", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม ", "พฤศจิกายน", "ธันวาคม");
$strMonthThai = $strMonthCut[$strMonth];
$event['format'] = "{$strDay} {$strMonthThai} {$strYear}";
} elseif ($interval1->days > 0) {
if ($strMonth = date("n", strtotime($event->start)) == ($strMonth = date("n", strtotime($event->finish)))) {
$strDate = $event->start;
$strYear = date("Y", strtotime($strDate)) + 543;
$strMonth = date("n", strtotime($strDate));
$strDay = date("j", strtotime($strDate));
$strHour = date("H", strtotime($strDate));
$strMinute = date("i", strtotime($strDate));
$strSeconds = date("s", strtotime($strDate));
$strMonthCut = array("", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม ", "พฤศจิกายน", "ธันวาคม");
$strMonthThai = $strMonthCut[$strMonth];
$strDayFinish = date("j", strtotime($event->finish));
$event['format'] = "{$strDay} - {$strDayFinish} {$strMonthThai} {$strYear}";
} else {
$strDate = $event->start;
$strYear = date("Y", strtotime($strDate)) + 543;
$strMonth = date("n", strtotime($strDate));
$strDay = date("j", strtotime($strDate));
$strHour = date("H", strtotime($strDate));
$strMinute = date("i", strtotime($strDate));
$strSeconds = date("s", strtotime($strDate));
$strMonthCut = array("", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม ", "พฤศจิกายน", "ธันวาคม");
$strMonthThai = $strMonthCut[$strMonth];
$strDayFinish = date("j", strtotime($event->finish));
$strMonthFinish = date("n", strtotime($event->finish));
$event['format'] = "{$strDay} {$strMonthThai} - {$strDayFinish} {$strMonthCut[$strMonthFinish]} {$strYear}";
}
}
$times = array("start", "finish");
for ($i = 0; $i < sizeof($times); $i++) {
$strDate = $event->{$times}[$i];
$strYear = date("Y", strtotime($strDate)) + 543;
$strMonth = date("n", strtotime($strDate));
$strDay = date("j", strtotime($strDate));
$strHour = date("H", strtotime($strDate));
$strMinute = date("i", strtotime($strDate));
$strSeconds = date("s", strtotime($strDate));
$strMonthCut = array("", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม ", "พฤศจิกายน", "ธันวาคม");
$strMonthThai = $strMonthCut[$strMonth];
$event->{$times}[$i] = "{$strDay} {$strMonthThai} - {$strDayFinish} {$strMonthCut[$strMonthFinish]} {$strYear} เวลา {$strHour}:{$strMinute} น.";
//$event['stat'] = 'newenw';
}
}
foreach ($events as $event) {
if ($event->status != -2 && $event->status == -1) {
echo "<div class=\"col-xs-12 col-sx-6 col-sm-6 col-md-6 col-lg-4\">\n <div class=\"feature\">\n <a href=\"/events/{$event->id}/show\">\n <div class=\"event-title\">\n {$event->name}\n </div>\n <div class=\"event-img\">\n <img class=\"lazy img-responsive\" data-original=\"/uploads/events/{$event->img}\" alt=\"BMW M1 Hood\" src=\"/uploads/events/{$event->img}\" style=\"display: block;\">\n\n </div>\n <div class=\"event-desc\">";
if (!$event->repeat) {
echo "<p>{$event->format}</p>\n <p>@ {$event->where}, {$event->location}</p>";
} else {
echo "<p>ทุก{$event->day} เริ่ม {$event->start}</p>\n <p>@ {$event->where}, {$event->location}</p>";
}
echo "</div>\n </a>\n </div>\n </div>";
}
}
}
