public function search_eventsAction() { if ($this->request->isPost()) { $eventName = $this->request->getPost('name'); $eventAddress = $this->request->getPost('address'); $country = Countries::findFirst(array('columns' => '*', 'conditions' => 'country LIKE :country:', 'bind' => array('country' => $eventAddress))); $countryId = ''; if ($country) { $countryId = $country->id; } if (!empty($eventName) && !empty($eventAddress) && !empty($countryId)) { $event = Events::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city: OR country_id = :country_id:', 'bind' => array('name' => '%' . $eventName . '%', 'street' => '%' . $eventAddress . '%', 'city' => '%' . $eventAddress . '%', 'country_id' => $countryId))); } if (!empty($eventName) && empty($eventAddress)) { $event = Events::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city:', 'bind' => array('name' => '%' . $eventName . '%', 'street' => '%' . $eventName . '%', 'city' => '%' . $eventName . '%'))); } if (empty($eventName) && !empty($eventAddress) && !empty($countryId)) { $event = Events::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city: OR country_id = :country_id:', 'bind' => array('name' => '%' . $eventAddress . '%', 'street' => '%' . $eventAddress . '%', 'city' => '%' . $eventAddress . '%', 'country_id' => $countryId))); } if (empty($eventName) && !empty($eventAddress) && empty($countryId)) { $event = Events::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city:', 'bind' => array('name' => '%' . $eventAddress . '%', 'street' => '%' . $eventAddress . '%', 'city' => '%' . $eventAddress . '%'))); } if (empty($eventName) && empty($eventAddress) && empty($countryId)) { $event = Events::find(); } $this->view->setVar('event', $event); } else { $event = Events::find(); } $this->view->setVar('events', $event); }
public function getEvent($id) { if (Session::has('in') && !strcmp(Session::get('in'), 'gautepJ9')) { return View::make('events.eventDisplay')->with('entries', Events::find($id)); } return Redirect::to('admin/login')->with('isErr', true)->with('msg', 'You need to login first.'); }
protected function saveModel($company = false) { if (Input::get('id')) { $company = Company::find(Input::get('id')); } if (!$company) { $company = new Company(); } $company->name = Input::get('name'); $company->type = Input::get('type'); $company->references = Input::get('references'); $company->bank_details = Input::get('bank_details'); $company->tax_number = Input::get('tax_number'); $company->notes = Input::get('notes'); $address = $company->address()->first() ?: new Address(); $country = Country::where('id', Input::get('country'))->first(); $address->country()->associate($country); $address->address = Input::get('address_address'); $address->postal_code = Input::get('address_postal_code'); $address->city = Input::get('address_city'); $address->state_province = Input::get('address_state_province'); $address->phone = Input::get('address_phone'); $address->fax = Input::get('address_fax'); $address->email = Input::get('address_email'); $address->website = Input::get('address_website'); $address->save(); $company->address()->associate($address); $company->save(); if (Input::get('venue_id')) { $company->venues()->detach(Venue::find(Input::get('venue_id'))); $company->venues()->attach(Venue::find(Input::get('venue_id'))); } if (Input::get('contact_id')) { $company->contacts()->detach(Contact::find(Input::get('contact_id'))); $company->contacts()->attach(Contact::find(Input::get('contact_id'))); } if (Input::get('event_id')) { $company->events()->detach(Events::find(Input::get('event_id'))); $company->events()->attach(Events::find(Input::get('event_id'))); } return $company; }
$dataset_budget['highlightFill'] = "rgba(220,220,220,0.75)"; $dataset_budget['highlightStroke'] = "rgba(220,220,220,1)"; $dataset_budget['data'] = $data_budget; $dataset[] = $dataset_budget; foreach ($periods as $dt) { $dt_end = clone $dt; $start = $dt->modify('first day of this month'); $end = $dt_end->modify('last day of this month'); $d = '{' . $start->format('d') . '...' . $end->format('d') . '}'; $m = $start->format('m'); $y = $start->format('Y'); $events = new Events(); $search = array('date' => "{$m}/{$d}/{$y}", 'client_id' => $client_id, 'service_id' => $service_id); $parameter = Events::getAsParameter($search, Events::getFields()); $parameter = json_encode($parameter); $foundEvents = $events->find($parameter, $inclusionFirst); error_log("{$m}/{$d}/{$y}"); if (!FileMaker::isError($foundEvents)) { $data_scheduled[] = FM_Table::summarize($foundEvents, 'duration_unix') / 60 / 60; } else { $data_scheduled[] = 0; } } $dataset_scheduled['fillColor'] = "rgba(151,187,205,0.5)"; $dataset_scheduled['strokeColor'] = "rgba(151,187,205,0.8)"; $dataset_scheduled['highlightFill'] = "rgba(151,187,205,0.75)"; $dataset_scheduled['highlightStroke'] = "rgba(151,187,205,1)"; $dataset_scheduled['data'] = $data_scheduled; $dataset[] = $dataset_scheduled; $data['datasets'] = $dataset; echo json_encode($data);
public static function createEvent($input) { $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'], 'creator_fname' => $input['creator_fname'], 'creator_lname' => $input['creator_fname'], 'creator_email' => $input['creator_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'], 'started_at' => $started_at == 'no' ? '' : mktime((int) $started_at[3], (int) $started_at[4], 0, (int) $started_at[0], (int) $started_at[1], (int) $started_at[2]), 'ended_at' => $ended_at == 'no' ? '' : mktime((int) $ended_at[3], (int) $ended_at[4], 0, (int) $ended_at[0], (int) $ended_at[1], (int) $ended_at[2])); $rules = array('event_category_id' => 'required', 'city_id' => 'required', 'creator_fname' => 'required', 'creator_lname' => 'required', 'creator_email' => 'required|email', 'email' => 'required|email', '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 { try { // Mencatat pembuat target sosial if (Auth::check()) { $input['user_id'] = Auth::user()->id; } else { // Check apakah user ada di database $check_user = User::where('email', $input['creator_email']); if ($check_user->count() > 0) { $input['user_id'] = $check_user->pluck('id'); } else { // Membuat user baru dengan status draft (status:2) $post = new User(); $post->firstname = $input['creator_fname']; $post->lastname = $input['creator_lname']; $post->email = $input['creator_email']; $post->status = 2; $post->save(); $input['user_id'] = $post->id; } } unset($input['creator_fname']); unset($input['creator_lname']); unset($input['creator_email']); $event = new Events(); $event->fill($input); $event->save(); // digunakan untuk mengambil id user yang belum login if (!Auth::check()) { Session::put('update_id', $event->id); } // update $update = Events::find($event->id); $update->fill(array('slug' => Events::checkSlugName(Str::slug($input['name'])) > 0 ? strtolower(Str::slug($input['name'])) . $event->id : strtolower(Str::slug($input['name'])))); $update->save(); return "ok"; } catch (Exception $e) { return "no"; } } }
protected function saveModel($event = false) { if (Input::get('id')) { $event = Events::find(Input::get('id')); } if (!$event) { $event = new Events(); } $event->name = Input::get('name'); $event->proposed_opening_time = Input::get('proposed_opening_time'); $event->proposed_closing_time = Input::get('proposed_closing_time'); $event->proposed_local_sponsors = Input::get('proposed_local_sponsors'); $event->promotional_activities = Input::get('promotional_activities'); $event->eval_financial_score = Input::get('eval_financial_score'); $event->eval_financial_text = Input::get('eval_financial_text'); $event->eval_marketing_score = Input::get('eval_marketing_score'); $event->eval_marketing_text = Input::get('eval_marketing_text'); $event->eval_travel_score = Input::get('eval_travel_score'); $event->eval_travel_text = Input::get('eval_travel_text'); $event->eval_production_score = Input::get('eval_production_score'); $event->eval_production_text = Input::get('eval_production_text'); $event->eval_extra_text = Input::get('eval_extra_text'); // new stuff 1 $event->curfew = Input::get('curfew'); $event->minimal_age_limit = Input::get('minimal_age_limit'); $event->alcohol_license = Input::get('alcohol_license'); $event->restrictions_on_merchandise_sales = Input::get('restrictions_on_merchandise_sales'); $event->sound_restrictions = Input::get('sound_restrictions'); $event->booked_for_setup_from = Input::get('booked_for_setup_from'); $event->booked_for_break_until = Input::get('booked_for_break_until'); // new stuff 2 $event->hotel1_name = Input::get('hotel1_name'); $event->hotel2_name = Input::get('hotel2_name'); $event->hotel1_website = Input::get('hotel1_website'); $event->hotel2_website = Input::get('hotel2_website'); $event->hotel1_travel_time_from_airport = Input::get('hotel1_travel_time_from_airport'); $event->hotel2_travel_time_from_airport = Input::get('hotel2_travel_time_from_airport'); $event->hotel1_travel_time_from_venue = Input::get('hotel1_travel_time_from_venue'); $event->hotel2_travel_time_from_venue = Input::get('hotel2_travel_time_from_venue'); $event->ticketsystem_enabled = Input::get('ticketsystem_enabled'); $event->currency_id = Input::get('currency_id'); $event->ticketsystem_recording_startdate = Input::get('ticketsystem_recording_startdate'); $event->ticketsystem_locked_for_promoter = Input::get('ticketsystem_locked_for_promoter'); $event->ticketsystem_autoremind_user_id = Input::get('ticketsystem_autoremind_user_id'); $event->ticketsystem_autoremind = Input::get('ticketsystem_autoremind'); $event->save(); if (Input::get('event_date')) { //error_log('Event date '.json_encode(Input::get('event_date'))); $input_date = strtotime(Input::get('event_date')); $date = $event->date()->first(); if ($date) { // update current date $date->datetime_start = date("Y-m-d H:i:s", $input_date); $date->datetime_end = date("Y-m-d H:i:s", $input_date); $date->update(); } else { // create new date $event_date = new Dates(['datetime_start' => date("Y-m-d H:i:s", $input_date), 'datetime_end' => date("Y-m-d H:i:s", $input_date)]); $event_date->save(); $event->date()->attach($event_date); } $response = Event::fire('event.datechanged', array($event)); } if (Input::get('contact_id')) { $event->contacts()->detach(Contact::find(Input::get('contact_id'))); $event->contacts()->attach(Contact::find(Input::get('contact_id'))); } if (Input::get('venue_id')) { $event->venues()->detach(Venue::find(Input::get('venue_id'))); $event->venues()->attach(Venue::find(Input::get('venue_id'))); } if (Input::get('company_id')) { $event->companies()->detach(Company::find(Input::get('company_id'))); $event->companies()->attach(Company::find(Input::get('company_id'))); } if (Input::get('promoter_id')) { $event->users()->detach(User::find(Input::get('promoter_id'))); $event->users()->attach(User::find(Input::get('promoter_id'))); } return $event; }
public function newAction() { if ($this->request->isPost()) { $messages = $this->formValidate(); if (count($messages)) { $this->view->disable(); $errorMsg = ''; foreach ($messages as $msg) { $errorMsg .= $msg . "<br>"; } $this->flash->error('<button type="button" class="close" data-dismiss="alert">×</button>' . $errorMsg); return $this->response->redirect('event/new/'); } else { $this->view->disable(); echo "validation is either failed or passed"; } $userSession = $this->session->get("userSession"); $eventName = $this->request->getPost("name"); $website = $this->request->getPost("website"); $telephone = $this->request->getPost("telephone"); $street = $this->request->getPost("street"); $city = $this->request->getPost("city"); $info = $this->request->getPost("event_info"); $category = $this->request->getPost("category"); $country = $this->request->getPost("country"); $raw_address = $this->request->getPost("address"); $latitude = $this->request->getPost("lat"); $longitude = $this->request->getPost("lng"); $dates = $this->request->getPost("date"); $fromTimes = $this->request->getPost("fromTime"); $toTimes = $this->request->getPost("toTime"); $event = new Events(); $event->created = date('Y-m-d H:i:s'); $event->modified = date('Y-m-d H:i:s'); $event->member_id = $userSession['id']; $event->name = $eventName; $event->event_date = $this->request->getPost("date"); $event->website = $website; $event->telephone = $telephone; $event->street = $street; $event->city = $city; $event->country_id = $country; $event->event_category_id = $category; $event->lng = $longitude; $event->lat = $latitude; $event->eventinfo = $info; if ($event->create()) { $id = $event->id; $i = 0; foreach ($dates as $date) { $eventDatetime = new EventDatetimes(); $eventDatetime->event_id = $id; $eventDatetime->date = $date; $eventDatetime->from_time = $fromTimes[$i]; $eventDatetime->to_time = $toTimes[$i]; $i++; if (!$eventDatetime->create()) { $this->view->disable(); echo "failed to insert event date and time in event_datetimes table. :("; } } $this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New event has been posted'); if ($this->request->hasFiles() == true) { $uploads = $this->request->getUploadedFiles(); $isUploaded = false; $ctr = 1; foreach ($uploads as $upload) { # define a "unique" name and a path to where our file must go $fileName = $upload->getname(); $fileInfo = new SplFileInfo($fileName); $fileExt = $fileInfo->getExtension(); $fileExt = strtolower($fileExt); $newFileName = substr(md5(uniqid(rand(), true)), 0, 10) . date('ymdhis') . '.' . $fileExt; $fileImageExt = array('jpeg', 'jpg', 'png'); $fileType = ''; $filePath = ''; $path = ''; if (in_array($fileExt, $fileImageExt)) { $path = 'img/event/' . $newFileName; $filePath = 'img/event/'; //$fileType = 'Image'; } # move the file and simultaneously check if everything was ok $upload->moveTo($path) ? $isUploaded = true : ($isUploaded = false); if ($isUploaded) { $eventPhotos = new EventPhotos(); $eventPhotos->created = date('Y-m-d H:i:s'); $eventPhotos->modified = date('Y-m-d H:i:s'); $eventPhotos->member_id = $userSession['id']; $eventPhotos->event_id = $id; $eventPhotos->file_path = $filePath; $eventPhotos->filename = $newFileName; $eventPhotos->caption = $this->request->getPost('caption'); //$ctr++; if ($eventPhotos->create()) { echo "success"; } else { $this->view->disable(); print_r($eventPhotos->getMessages()); } } } } } else { $this->view->disable(); print_r($event->getMessages()); } return $this->response->redirect('event/view/' . $id); } $events = Events::find(); $categories = EventsCategories::find(); $countries = Countries::find(); $this->view->setVar('events', $events); $this->view->setVars(['events' => $events, 'categories' => $categories, 'countries' => $countries]); }
public function view($id) { $events = Events::find($id); $events->views += 1; $events->save(); if (Auth::guest()) { $events->ismember = false; } else { $events->ismember = $this->checkmembers($id); } return View::make('events.view')->with('events', $events); }
public function getDelete($id = '') { if ($id == '') { return Redirect::to($this->route)->with('msg_error', Lang::get('messages.events_display_err')); } else { $event = Events::find($id); $delete = Events::destroy($id); if (!$delete) { return Redirect::to($this->route . '/trash')->with('msg_error', Lang::get('messages.events_delete_err', array('title' => $event->title))); } else { return Redirect::to($this->route . '/trash')->with('msg_success', Lang::get('messages.events_delete', array('title' => $event->title))); } } }
public function getEvent($id) { $event = Events::find($id); 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"; } $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} {$strYear} เวลา {$strHour}:{$strMinute} น."; //$event['stat'] = 'newenw'; } $this->breadcrumbs->push('กิจกรรม', URL::to('/events')); $this->breadcrumbs->push($event->name, URL::to('/events/' . $id . '/show')); $this->breadcrumbs->generate(); return View::make('home.showEvent')->with('event', $event); }
public static function createEvent($input) { $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'], 'started_at' => $started_at == 'no' ? '' : mktime((int) $started_at[3], (int) $started_at[4], 0, (int) $started_at[0], (int) $started_at[1], (int) $started_at[2]), 'ended_at' => $ended_at == 'no' ? '' : mktime((int) $ended_at[3], (int) $ended_at[4], 0, (int) $ended_at[0], (int) $ended_at[1], (int) $ended_at[2])); $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 { try { $event = new Events(); $event->fill($input); $event->save(); // digunakan untuk mengambil id user yang belum login if (!Auth::check()) { Session::put('update_id', $event->id); } // update $update = Events::find($event->id); $update->fill(array('slug' => Events::checkSlugName(Str::slug($input['name'])) > 0 ? strtolower(Str::slug($input['name'])) . $event->id : strtolower(Str::slug($input['name'])))); $update->save(); return "ok"; } catch (Exception $e) { return "no"; } } }
/** * Show the form for editing the specified event. * * @param int $id * @return Response */ public function edit($id) { $event = Events::find($id); return View::make('events.edit', compact('event')); }
public function getShowEvent($id) { $event = Events::find($id); $columns = Schema::getColumnListing('events'); return View::make('admin.show_event')->with('event', $event)->with('columns', $columns); }
public function saveEvent() { $inputs = Input::all(); /* ["_token"]=> string(40) "ZUiNHvF83pNBXJMeBNTFVTLTiyDSYC75y6dMiNeN" ["eventIdEdit"]=> string(1) "1" ["eventNameEdit"]=> string(9) "Baratheon" ["eventDateEdit"]=> string(10) "2015-11-10" ["eventDescriptionEdit"]=> string(5) "afsad" ["eventLocationEdit"]=> string(4) "asdf" ["eventTypeEdit"]=> string(1) "1" ["stateEdit"]=> string(2) "17" ["cityEdit"]=> string(6) "175345" */ $event = Events::find($inputs['eventIdEdit']); $event->name = $inputs['eventNameEdit']; $event->event_description = $inputs['eventDescriptionEdit']; $event->type = $inputs['eventTypeEdit']; $event->area = $inputs['eventLocationEdit']; $event->state = $inputs['stateEdit']; $event->city = $inputs['cityEdit']; $event->event_date = $inputs['eventDateEdit']; $event->save(); if ($event) { return Response::json(array("status" => "success")); } else { return Response::json(array("status" => "failed")); } }