public function store(ContactFormRequest $request)
 {
     $route = Helpers::routeinfo();
     $from = [$request->get('email'), ucwords($request->get('name'))];
     $to = ['*****@*****.**', 'Acclaim Events'];
     $subj = 'Contact Form Submission';
     if (count($route->params) === 1) {
         $member = TeamMember::where('first_name', '=', ucwords($route->params['contact']))->take(1)->get();
         if (isset($member[0])) {
             $member = (object) $member[0]->toArray();
             $to = [$member->email, $member->first_name . ' ' . $member->last_name];
             $subj = 'Personal Contact request for ' . $member->first_name . ' ' . $member->last_name;
         }
     }
     $contact = ['from' => $from, 'to' => $to, 'subj' => $subj];
     \Mail::send('emails/contact', ['name' => $request->get('name'), 'email' => $request->get('email'), 'phone' => $request->get('phone'), 'msg' => $request->get('message')], function ($message) use($contact) {
         $fromEmail = $contact['from'][0];
         $fromName = $contact['from'][1];
         $toEmail = $contact['to'][0];
         $toName = $contact['to'][1];
         $subject = $contact['subj'];
         $message->from($fromEmail, $fromName);
         $message->to($toEmail, $toName)->subject($subject);
     });
     return back()->with('message', 'Thanks for contacting us!');
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     //
     Schema::create('conferences', function (Blueprint $table) {
         $table->increments('id');
         $table->string('slug');
         $table->string('conference');
         $table->string('city');
         $table->string('state');
         $table->datetime('start_date');
         $table->timestamp('end_date');
         $table->string('timezone', 3)->nullable();
         $table->tinyInteger('coming')->default(0);
         $table->text('about')->nullable();
         $table->text('partners')->nullable();
         $table->string('venue_slug')->nullable();
         $table->text('sponsors')->nullable();
         $table->text('tags')->nullable();
         $table->text('options')->nullable();
         $table->string('hero')->nullable();
         $table->string('photo')->nullable();
         $table->timestamps();
         $table->timestamp('published')->nullable();
         $table->softDeletes();
     });
     Conference::create(['slug' => 'austin', 'conference' => 'Austin IT Strategies Conference', 'city' => 'Austin', 'state' => 'TX', 'start_date' => Carbon::create(2015, 9, 15, 7, 30, 0), 'end_date' => Carbon::create(2015, 9, 15, 16, 30, 0), 'timezone' => 'CDT', 'coming' => 'September 2015', 'about' => '<p>Our Austin IT Strategies Conference will bring together CIOs, CTOs SVPs &#038; VPs of IT, IT Directors and Sr. Level IT Leaders of fortune 100-5000 companies and equivalent healthcare, government and educational entities in the greater Austin Region.  Our attendee’s will have the opportunity to hear from Industry experts, network with their peers and discuss critical challenges and issues that they face within their organizations.  We encourage our attendee’s to share and discuss their lessons learned, knowledge and insight as we dive into some of today’s biggest IT challenges.</p><p>We strive to produce content-rich presentations that will provide answers to many of today’s business challenges and hope that you will be able to gain practical knowledge and insights that you can then use within your own organization.</p>', 'partners' => Helpers::serialize(['partners' => ['tagitm'], 'text' => '<p><strong>We are proud to be able to partner with TAGITM for the 2015 Austin IT Strategies Conference.</strong></p>']), 'venue_slug' => 'texas-austin-crown-plaza-austin', 'sponsors' => Helpers::serialize(['emerald' => ['cylance', 'dynatrace', 'forsythe', 'hitachi', 'workday', 'mcci', 'good', '2fa', 'nimble-storage', 'secure-nation', 'windstream', 'arbor-networks']]), 'tags' => 'austin-it-strategies-2015,austin,texas,it-strategies,information-technology,it-solutions', 'options' => Helpers::serialize(['link' => '0', 'hero' => true, 'title' => 'event:conference', 'jumbotron' => 'event:hero', 'countdown' => true, 'about' => true, 'partners' => true, 'agenda' => true, 'speakers' => true, 'sponsors' => true, 'sponsorlevels' => false, 'venue' => true]), 'hero' => '/images/conferences/austin.jpg', 'photo' => '/images/conferences/austin-portfolio.jpg', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Conference::create(['slug' => 'san-antonio', 'conference' => 'San Antonio IT Strategies Conference', 'city' => 'San Antonio', 'state' => 'TX', 'start_date' => Carbon::create(2016, 5, 31, 0, 0, 0), 'end_date' => Carbon::create(2016, 5, 31, 23, 59, 59), 'timezone' => 'CDT', 'coming' => 1, 'about' => '<p>Our San Antonio IT Strategies Conference will bring together CIOs, CTOs SVPs &#038; VPs of IT, IT Directors and Sr. Level IT Leaders of fortune 100-5000 companies and equivalent healthcare, government and educational entities in the greater San Antonio Region.  Our attendee’s will have the opportunity to hear from Industry experts, network with their peers and discuss critical challenges and issues that they face within their organizations.  We encourage our attendee’s to share and discuss their lessons learned, knowledge and insight as we dive into some of today’s biggest IT challenges.</p><p>We strive to produce content-rich presentations that will provide answers to many of today’s business challenges and hope that you will be able to gain practical knowledge and insights that you can then use within your own organization.</p>', 'sponsors' => Helpers::serialize(['acclaim-events']), 'tags' => 'san-antonio,texas,it-strategies,information-technology,it-solutions', 'options' => Helpers::serialize(['link' => '0', 'title' => 'event:conference', 'jumbotron' => 'event:hero', 'countdown' => true, 'about' => true, 'partners' => false, 'agenda' => true, 'speakers' => false, 'sponsors' => false, 'sponsorlevels' => false, 'venue' => true]), 'hero' => '/images/conferences/san-antonio.jpg', 'photo' => '/images/conferences/san-antonio-portfolio.jpg', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Conference::create(['slug' => 'tampa', 'conference' => 'Tampa IT Strategies Conference', 'city' => 'Tampa', 'state' => 'FL', 'start_date' => Carbon::create(2017, 2, 28, 0, 0, 0), 'end_date' => Carbon::create(2017, 2, 28, 12, 59, 59), 'timezone' => 'EST', 'coming' => 1, 'about' => '<p>Our Tampa IT Strategies Conference will bring together CIOs, CTOs SVPs &#038; VPs of IT, IT Directors and Sr. Level IT Leaders of fortune 100-5000 companies and equivalent healthcare, government and educational entities in the greater Tampa Region.  Our attendee’s will have the opportunity to hear from Industry experts, network with their peers and discuss critical challenges and issues that they face within their organizations.  We encourage our attendee’s to share and discuss their lessons learned, knowledge and insight as we dive into some of today’s biggest IT challenges.</p><p>We strive to produce content-rich presentations that will provide answers to many of today’s business challenges and hope that you will be able to gain practical knowledge and insights that you can then use within your own organization.</p>', 'sponsors' => Helpers::serialize(['acclaim-events']), 'tags' => 'tampa,florida,it-strategies,information-technology,it-solutions', 'options' => Helpers::serialize(['link' => '0', 'title' => 'event:conference', 'jumbotron' => 'event:hero', 'countdown' => true, 'about' => true, 'partners' => false, 'agenda' => true, 'speakers' => false, 'sponsors' => false, 'sponsorlevels' => false, 'venue' => true]), 'hero' => '/images/conferences/tampa.jpg', 'photo' => '/images/conferences/tampa-portfolio.jpg', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
 }
Пример #3
0
 public function get_UeUserList_csv($id)
 {
     if (!(Helpers::isProf() || Helpers::isSecr())) {
         return redirect('/');
     }
     $ue = Ue::FindOrFail($id);
     $parcours_ue = $ue->parcours_ues->first();
     $output = fopen('php://memory', 'w');
     $filename = $ue->intitule . '.csv';
     // output the column headings
     fputcsv($output, array($ue->intitule), ';');
     fputcsv($output, array('Nom', 'Prénom', '@mail', 'actif'), ';');
     // loop over the rows, outputting them
     foreach ($parcours_ue->choixes as $choix) {
         $user = $choix->user;
         fputcsv($output, array($user->nom, $user->prenom, $user->mail, $user->actif), ';');
     }
     // reset the file pointer to the start of the file
     fseek($output, 0);
     // tell the browser it's going to be a csv file
     header('Content-Type: application/csv');
     // tell the browser we want to save it instead of displaying it
     header('Content-Disposition: attachment; filename="' . $filename . '";');
     // make php send the generated csv lines to the browser
     fpassthru($output);
     return null;
 }
Пример #4
0
 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     /**
      * validation rules, number must be:
      * an integer
      * >= 1
      * <= 100
      */
     $this->validate($request, ['number' => 'required|integer|min:1|max:100']);
     $number = $request->get("number");
     $rangeArray = Helpers::createArrayRange($number);
     $missingNumber = Helpers::findMissingNumber($rangeArray);
     return view("test.create", compact("missingNumber", "rangeArray", $missingNumber, $rangeArray));
 }
Пример #5
0
 public function testIntegration()
 {
     $valid = 0;
     for ($i = 1; $i <= 100; $i++) {
         $rangeArray = Helpers::createArrayRange($i);
         $missingNumber = Helpers::findMissingNumber($rangeArray);
         if ($i === $missingNumber) {
             $valid++;
             continue;
         }
         $valid--;
     }
     $this->assertTrue($valid === 100);
 }
 protected function getEvents()
 {
     $events = ['' => 'Select one...'];
     $conferences = Conference::where('start_date', '>', Carbon::now())->get();
     $conferences = Helpers::keysByField($conferences, 'slug');
     foreach ($conferences as $slug => $event) {
         $events[$slug] = $event->city . ', ' . $event->state . ' | ';
         $time = $event->start_date . (!empty($event->timezone) ? $event->timezone : '');
         if (!empty($event->coming)) {
             $events[$slug] .= date('F Y', strtotime($time));
         } else {
             $events[$slug] .= date('F j, Y', strtotime($time));
         }
     }
     return $events;
 }
 protected function getEvents()
 {
     $events = ['' => 'Select one...'];
     $conferences = Conference::current()->get();
     $conferences = Helpers::keysByField($conferences, 'slug');
     $conferences = Lookup::addOptions($conferences);
     foreach ($conferences as $slug => $event) {
         $events[$slug] = $event->city . ', ' . $event->state . ' | ';
         $time = $event->start_date . (!empty($event->timezone) ? $event->timezone : '');
         if (!empty($event->options->show_upcoming)) {
             $events[$slug] .= date('F Y', strtotime($time));
         } else {
             $events[$slug] .= date('F j, Y', strtotime($time));
         }
     }
     return $events;
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('pages', function (Blueprint $table) {
         $table->increments('id');
         $table->string('slug');
         $table->text('about')->nullable();
         $table->text('options')->nullable();
         $table->timestamps();
         $table->timestamp('published')->nullable();
         $table->softDeletes();
     });
     Page::create(['slug' => 'home', 'options' => Helpers::serialize(['active' => 'home', 'hero' => '1', 'jumbotron' => '/images/networking.jpg', 'upcoming' => '1', 'benefits' => '1', 'testimonials' => '1']), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Page::create(['slug' => 'about', 'about' => '<p>Established in 2012, Acclaim Events was created to help Business Technology Executives find solutions to many of today’s critical business challenges. We were built on the premise that networking and the sharing of ideas among technology leaders will help broaden and expand IT knowledge within the local community. With over 20 years of combined experience, our Acclaim Events team knows what it takes to facilitate high quality, interactive and educational technology networking conferences.</p><p>IT Professionals are tasked with keeping corporate and private information secure, while embracing new ways of supporting and doing business. With technology advancing at an alarming rate, it can be challenging to keep up with many of the technological advances, trends and best practices that help to keep our organizations competitive and secure.</p><p>Our IT Strategies Conferences foster an exclusive environment for CIOs &amp; Sr. level IT Executives that is conducive to learning, networking and sharing ideas with their peers; giving them valuable insight and knowledge that they can use within their organizations.</p>', 'options' => Helpers::serialize(['active' => 'about', 'hero' => '0', 'title' => 'About Acclaim Events', 'about' => '1', 'team' => '1', 'advisors' => '1']), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Page::create(['slug' => 'conferences', 'options' => Helpers::serialize(['active' => 'conferences', 'title' => 'Conferences', 'conferences' => '1']), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Page::create(['slug' => 'conference', 'options' => Helpers::serialize(['active' => 'conferences', 'title' => 'event:conference', 'hero' => '1', 'jumbotron' => 'event:hero', 'countdown' => '0', 'about' => '0', 'agenda' => '0', 'speakers' => '0', 'sponsors' => '0', 'sponsorlevels' => '0', 'map' => '0', 'address' => '0', 'coords' => '0', 'venue' => '0']), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Page::create(['slug' => 'contact', 'options' => Helpers::serialize(['active' => 'contact', 'title' => 'Contact Us', 'hero' => '0', 'jumbotron' => '/images/contact.jpg', 'contact' => '1']), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
     Page::create(['slug' => 'register', 'options' => Helpers::serialize(['active' => 'register', 'title' => 'Conference Registration', 'hero' => '0', 'jumbotron' => '/images/registration.jpg', 'contact' => 'register']), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
 }
 protected function conference($route, $event)
 {
     $venue = Venue::where('slug', '=', $event->venue_slug)->published()->get();
     $venue = !empty($venue[0]) ? (object) $venue[0]->toArray() : null;
     $options = Helpers::options($route, $event->slug, $event);
     //		dd($options);
     $navs = Helpers::navigation($route, $options);
     $sub = Helpers::navigation($route, $options, true);
     $partners = (object) ['companies' => null, 'text' => null];
     if (!empty($event->partners)) {
         $undo = Helpers::unserialize($event->partners);
         $companies = Partner::where(function ($query) use($undo) {
             foreach ($undo['partners'] as $i => $slug) {
                 if ($i === 0) {
                     $query->where('slug', '=', $slug);
                 } else {
                     $query->orWhere('slug', '=', $slug);
                 }
             }
         })->published()->orderBy('company')->get();
         if (!empty($undo['text'])) {
             $partners->text = $undo['text'];
         }
         if (is_object($companies)) {
             $partners->companies = [];
             foreach ($companies as $i => $company) {
                 $partners->companies[] = (object) $company->toArray();
             }
         }
     }
     $unfilteredTopics = Topic::where('conference_slug', '=', $event->slug)->published()->get();
     $topics = [];
     foreach ($unfilteredTopics as $topic) {
         $topics[] = [$topic->title => $topic->text];
     }
     if ((bool) $options->topics_by_alpha === true) {
         sort($topics);
     }
     //dd($topics);
     $agendasRaw = Agenda::where('conference_slug', '=', $event->slug)->published()->orderBy('timeslot')->orderBy('priority')->get();
     $speakerList = [];
     $agendas = [];
     if (is_object($agendasRaw)) {
         foreach ($agendasRaw as $i => $agenda) {
             $agenda = (object) $agenda->toArray();
             list($date, $time) = explode(' ', $agenda->timeslot);
             if (!empty($agenda->speakers)) {
                 //					$agenda->speakers = Helpers::unserialize($agenda->speakers);
                 //					dd($agenda->speakers);
                 $agendaSpeakers = explode(',', $agenda->speakers);
                 $agenda->speakers = [];
                 if (is_array($agendaSpeakers)) {
                     foreach ($agendaSpeakers as $s) {
                         @(list($speakerType, $speakerSlug) = @explode('|', $s));
                         $agenda->speakers[$speakerType][] = $speakerSlug;
                     }
                     //							dd($agenda->speakers);
                 }
             }
             $agendas[$date][$time][] = $agenda;
             if (!empty($agenda->speakers)) {
                 $speakersTypes = $agenda->speakers;
                 if (is_array($speakersTypes)) {
                     ksort($speakersTypes);
                     //						dd($speakersTypes);
                     foreach ($speakersTypes as $speakers) {
                         $speakerList = array_merge($speakerList, $speakers);
                     }
                 }
             }
         }
     }
     //		dd($agendas);
     if (count($speakerList) > 0) {
         $speakers = Speaker::where(function ($query) use($speakerList) {
             $query->where('slug', '=', array_pop($speakerList));
             while (count($speakerList) > 0) {
                 $query->orWhere('slug', '=', array_pop($speakerList));
             }
         })->published()->orderBy('last_name')->get();
         $speakers = Helpers::keysByField($speakers, 'slug', function ($value, $key, $field, $array, $toObj) {
             $value->sessions = [];
             return $value;
         }, true);
     }
     if ((bool) $options->sponsor_levels === true) {
         $sponsors = Lookup::lookup('sponsors', ['conference_slug' => $event->slug], ['published' => true, 'sponsorlevels' => true]);
     } else {
         $sponsors = Lookup::lookup('sponsors', ['conference_slug' => $event->slug], ['published' => true]);
     }
     //		dd($options);
     return view('pages/conference', compact('event', 'venue', 'partners', 'topics', 'agendas', 'speakers', 'sponsors', 'options', 'navs', 'sub'));
 }
 protected function conference($route, $event)
 {
     $venue = Venue::where('slug', '=', $event->venue_slug)->published()->get();
     $venue = !empty($venue[0]) ? (object) $venue[0]->toArray() : null;
     $event->options = !empty($event->options) ? Helpers::unserialize($event->options) : [];
     $options = Helpers::options($route, 'conference', $event->options);
     $options = (array) $options;
     foreach ($options as $key => $option) {
         if (is_string($option) && preg_match("/^([a-z]+):([a-z]+)\$/i", $option)) {
             list($foo, $bar) = explode(':', $option);
             $options[$key] = ${$foo}->{$bar};
         }
     }
     $options = (object) $options;
     //		dd($options);
     $navs = Helpers::navigation($route, $options);
     $sub = Helpers::navigation($route, $options, true);
     $partners = (object) ['companies' => null, 'text' => null];
     if (!empty($event->partners)) {
         $undo = Helpers::unserialize($event->partners);
         $companies = Partner::where(function ($query) use($undo) {
             foreach ($undo['partners'] as $i => $slug) {
                 if ($i === 0) {
                     $query->where('slug', '=', $slug);
                 } else {
                     $query->orWhere('slug', '=', $slug);
                 }
             }
         })->published()->orderBy('company')->get();
         if (!empty($undo['text'])) {
             $partners->text = $undo['text'];
         }
         if (is_object($companies)) {
             $partners->companies = [];
             foreach ($companies as $i => $company) {
                 $partners->companies[] = (object) $company->toArray();
             }
         }
     }
     $agendasRaw = Agenda::where('conference_id', '=', $event->id)->published()->orderBy('timeslot')->orderBy('priority')->get();
     $speakerList = [];
     $agendas = [];
     if (is_object($agendasRaw)) {
         foreach ($agendasRaw as $i => $agenda) {
             $agenda = (object) $agenda->toArray();
             list($date, $time) = explode(' ', $agenda->timeslot);
             if (!empty($agenda->speakers)) {
                 $agenda->speakers = Helpers::unserialize($agenda->speakers);
             }
             $agendas[$date][$time][] = $agenda;
             if (!empty($agenda->speakers)) {
                 $speakersTypes = $agenda->speakers;
                 if (is_array($speakersTypes)) {
                     ksort($speakersTypes);
                     foreach ($speakersTypes as $speakers) {
                         $speakerList = array_merge($speakerList, $speakers);
                     }
                 }
             }
         }
     }
     if (count($speakerList) > 0) {
         $speakers = Speaker::where(function ($query) use($speakerList) {
             $query->where('slug', '=', array_pop($speakerList));
             while (count($speakerList) > 0) {
                 $query->orWhere('slug', '=', array_pop($speakerList));
             }
         })->published()->orderBy('last_name')->get();
         $speakers = Helpers::keysByField($speakers, 'slug', function ($value, $key, $field, $array, $toObj) {
             $value->sessions = [];
             return $value;
         }, true);
     }
     if ((bool) $options->sponsorlevels === true) {
         $sponsors = Lookup::lookup('sponsors', ['conference' => $event->id], ['published' => true, 'sponsorlevels' => true]);
     } else {
         $sponsors = Lookup::lookup('sponsors', ['conference' => $event->id], ['published' => true]);
     }
     //		dd($sponsors);
     return view('pages/conference', compact('event', 'venue', 'partners', 'agendas', 'speakers', 'sponsors', 'options', 'navs', 'sub'));
 }
Пример #11
0
 public function post_DeleteCancel()
 {
     if (!Helpers::isAdmin()) {
         return redirect('/');
     }
     $text = "Supression annulée";
     return view("confirmation", ['text' => $text]);
 }
Пример #12
0
 /**
  * Register the user and start a session
  */
 public function register()
 {
     $fullName = Input::get('fullName');
     $email = Input::get('email');
     $password = Input::get('password');
     // lets validate the users input
     $validator = Validator::make(array('fullName' => $fullName, 'email' => $email, 'password' => $password), array('fullName' => 'required', 'email' => 'required|email|unique:users', 'password' => 'required|min:8'));
     // Commented out for open beta and beyond
     /************* Make sure the email being used has been invited to beta
              *
     		if ( !DB::table('beta')->whereEmail($email)->whereStatus(1)->get() ) {
     			$validator->getMessageBag()->add('used', 'The email used has not been invited.');
     			return Redirect::back()->withErrors($validator)->withInput();
     		}
              *
              ******************/
     if ($validator->fails()) {
         return Redirect::back()->withErrors($validator)->withInput();
     }
     $user = new User();
     $user->full_name = $fullName;
     $user->email = $email;
     $user->password = Hash::make($password);
     $user->save();
     if (Auth::attempt(array('email' => $email, 'password' => $password))) {
         Helpers::sendWelcomeMail();
         return Redirect::to('hud');
     }
     return Redirect::back()->withErrors($validator);
 }
 function register()
 {
     /*
     		$show = [
     			'hero'			=> false,
     			'active'		=> false,
     			'title'			=> 'Register',
     		];
     		$show = $this->get_show_preferences($show);
     
     		$event = [
     			'slug'			=> 'austin',
     			'title'			=> 'Austin IT Strategies Conference',
     			'start'			=> '2015-09-15 07:30:00 CDT',
     			'end'			=> '2015-09-15 17:00:00 CDT',
     			'venue'			=> 'Crown Plaza Austin',
     			'location'		=> '6121 North Ih 35, Austin, TX 78752',
     			'place'			=> 'ChIJVzSZghjKRIYREyXBujdzq6w',
     			'directions'	=> 'http://www.ihg.com/crowneplaza/hotels/us/en/austin/ausgz/hoteldetail?cm_mmc=GoogleMaps-_-cp-_-USEN-_-ausgz#map-directions',
     		];
     		$event['date'] = date('F j, Y', strtotime($event['start']));
     
     		$events = [
     			[
     				'slug'			=> 'austin',
     				'title'			=> 'Austin IT Strategies Conference',
     				'city'			=> 'Austin, TX',
     				'start'			=> '2015-09-15 07:30:00 CDT',''
     			],
     			[
     				'slug'			=> 'san-antonio',
     				'title'			=> 'San Antonio IT Strategies Conference',
     				'city'			=> 'San Antonio, TX',
     				'start'			=> '2016-04-21 07:30:00 CST',
     			],
     		];
     
     		foreach ($events as $i => $event) {
     			$events[$i]['date'] = date('F j, Y', strtotime($event['start']));
     		}
     
     		$data = [
     			'show'		=> $show,
     			'event'		=> $event,
     			'events'	=> $events,
     			'nav-sub'	=> [],
     		];
     
     		return view('pages/register')->withData($data);
     */
     $route = Helpers::routeinfo();
     $options = Helpers::options($route);
     $navs = Helpers::navigation($route, $options);
     $sub = Helpers::navigation($route, $options, true);
     $events = DB::table('conferences')->where('start_date', '>', Carbon\Carbon::now())->where('published', '>', '0000-00-00 00:00:00')->orderBy('start_date')->get();
 }
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
        Schema::create('agendas', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('conference_id');
            $table->timestamp('timeslot');
            $table->integer('priority')->default(1);
            $table->enum('type', ['keynote', 'session', 'breakout', 'break']);
            $table->string('title');
            $table->string('title_short')->nullable();
            $table->string('subtitle')->nullable();
            $table->text('desc')->nullable();
            $table->text('tags')->nullable();
            $table->text('speakers')->nullable();
            $table->text('options')->nullable();
            $table->timestamps();
            $table->timestamp('published')->nullable();
            $table->softDeletes();
        });
        /*****  AUSTIN IT STRATEGIES CONFERENCE 2015-09-15 *****/
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 07:30:00', 'priority' => 1, 'type' => 'break', 'title' => 'Networking Breakfast', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 09:00:00', 'priority' => 2, 'type' => 'keynote', 'title' => 'Analyzing Big Data – Using the Massive Volume of Information Collected', 'title_short' => 'Analyzing Big Data', 'desc' => '<p>Many organizations now have the ability to collect a massive amounts of structured and unstructured data every day. If companies are able to analyze and extract value from the information it can provide great insights and information about business trends. Join our experts as they discuss Big Data, some of its uses and some of the challenges around analysis, capture, curation, storage and privacy/security of the information collected.</p>', 'speakers' => Helpers::serialize(['moderator' => ['sturm-mike'], 'panelist' => ['bhattacharjee-dave', 'ketchum-debra', 'talbert-neera']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 10:00:00', 'priority' => 3, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 10:30:00', 'priority' => 4, 'type' => 'session', 'title' => 'Enterprise Mobility – Embracing BYOD While Keeping your Information Secure', 'title_short' => 'Enterprise Mobility', 'desc' => '<p>Today’s workforce has an expectation that they will be able to access information through a multitude of various devices, applications and infrastructures. We as IT Leaders need to be able to have policies in place that will accommodate the mobile workforce while maintaining information security. Join our experts as they discuss various strategies, policies and best practices that they have implemented to deal with the ever increasing number of mobile users within their organization.</p>', 'speakers' => Helpers::serialize(['speaker' => ['brewer-bob']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 10:30:00', 'priority' => 5, 'type' => 'breakout', 'title' => 'Application Modernization', 'title_short' => 'Application Modernization', 'desc' => '<p>As technology advances, we are forced to upgrade our old legacy systems to more modern and efficient systems.  Many of the businesses critical operations are often housed within older legacy systems and are completely developed with custom code.  Application Modernization allows the business to extend the life of their current system by incrementally updating applications and systems, allowing them to work together while avoiding costly downtime that would affect business operations.  Join our panel as they discuss some of the challenges strategies and lessons learned as a result of updating to newer more modern systems.</p>', 'speakers' => Helpers::serialize(['moderator' => ['selissen-anh'], 'panelist' => ['cook-dana', 'waldo-jay', 'rios-george']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 11:30:00', 'priority' => 6, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 11:45:00', 'priority' => 7, 'type' => 'session', 'title' => 'U.S. Secret Service vs. Cyber Criminals', 'title_short' => 'U.S. Secret Service', 'desc' => '<p>The U.S. Secret Service was established in 1865 to protect our nation\'s currency from counterfeiters. Today, the agency\'s investigative mission has evolved to combat cyber crime targeting U.S. banking infrastructure - specifically financial institutions and payment systems.  This briefing will provide an overview of the capabilities and efforts of the public/private/academic partnerships forged at the U.S. Secret Service Electronic Crimes Task Forces throughout the world.   As well as, current trends in cyber crime, related intelligence sharing, and examples of previous cyber case work by the agency.</p>', 'speakers' => Helpers::serialize(['speaker' => ['edwards-tom']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 11:45:00', 'priority' => 8, 'type' => 'breakout', 'title' => 'Business Continuity Disaster Recovery', 'title_short' => 'Business Continuity Disaster Recovery', 'desc' => '<p>Having an established business continuity and disaster recovery plan can help an organization to continue business and mitigate losses during catastrophic failures, cyber-attacks and malware infections, natural disasters and other critical emergencies. Join our panel of experts as they discuss some of the strategies and protocols that they have implemented within their organizations to help protect their companies in the event that an emergency strikes.</p>', 'speakers' => Helpers::serialize(['moderator' => ['harris-richard'], 'panelist' => ['fernandes-andrew', 'felps-robert', 'theis-brandon']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 12:45:00', 'priority' => 9, 'type' => 'keynote', 'title' => 'Innovative Strategic Planning – Aligning IT Strategy to the Needs of the Business', 'title_short' => 'Innovative Strategic Planning', 'desc' => '<p>Integrating IT initiatives with the business strategy can often be challenging and complex. The speed of business and access to countless software applications and more connected networks make keeping company information secure a major challenge. IT continues to be under pressure to drive productivity and enable innovation, in many cases with fewer dollars.</p>
					<p>Join our experts as they discuss some innovative ways to help integrate your IT strategy to meet the needs of the business while maintaining a high level of security.</p>', 'speakers' => Helpers::serialize(['moderator' => ['martin-jeff'], 'panelist' => ['smedley-jeff', 'flay-gregory', 'johnson-rani', 'parnell-lawanda']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 14:15:00', 'priority' => 10, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 14:30:00', 'priority' => 11, 'type' => 'breakout', 'title' => 'Conquering your “Cloud” Fears - Visibility, Performance and End User Experience', 'title_short' => 'Conquering your “Cloud” Fears', 'desc' => '<p>Are you prepared to move your critical applications to the cloud?  With application complexity, visibility concerns and user demand growing at an astounding rate over the past few years,  IT organizations have a lot of times struggled to keep pace.  The cloud can provide many positives, but it also keeps a lot of executives up at night wondering what new complexities and challenges the cloud might be hiding.  Organizations that are the most successful with moving applications to the cloud understand the importance of maintaining application visibility, increase performance and keeping their end user’s happy.  This session will discuss the importance of these key areas and how to put them into affect.</p>', 'speakers' => Helpers::serialize(['speaker' => ['jackson-kevin']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 14:30:00', 'priority' => 12, 'type' => 'breakout', 'title' => 'Information Security – Is your Business Under Attack?', 'title_short' => 'Information Security', 'desc' => '<p>Information Security is one of the biggest things that can keep a CIO up at night. We are always looking for ways to better protect company information and assets while trying to prevent data breaches, hacks and insider threats. Our experts will address risk assessment, governance, and other best practice strategies that can be used to minimize putting your organizations information at risk.</p>', 'speakers' => Helpers::serialize(['moderator' => ['moore-larry'], 'panelist' => ['botts-michael', 'nather-wendy', 'yoder-marc']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 15:30:00', 'priority' => 13, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 1, 'timeslot' => '2015-09-15 15:45:00', 'priority' => 14, 'type' => 'keynote', 'title' => 'The CIO Perspective – A High Level Discussion with Local CIOs', 'title_short' => 'The CIO Perspective', 'desc' => '<p>Join our closing keynote panel of local CIOs as they discuss challenges that they have faced within their organizations and some of the solutions, policies and strategies that have been put in place to help embrace organizational growth and efficiency.</p>', 'speakers' => Helpers::serialize(['moderator' => ['dominguez-jake'], 'panelist' => ['brandt-scott', 'neill-robert', 'bowers-evan', 'bynum-andy']]), 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        /*****  SAN ANTONIO IT STRATEGIES CONFERENCE (DATE TBD) *****/
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 07:30:00', 'priority' => 1, 'type' => 'break', 'title' => 'Networking Breakfast', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 09:00:00', 'priority' => 2, 'type' => 'keynote', 'title' => 'Keynote', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 10:00:00', 'priority' => 3, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 10:30:00', 'priority' => 4, 'type' => 'session', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 10:30:00', 'priority' => 5, 'type' => 'breakout', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 11:30:00', 'priority' => 6, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 11:45:00', 'priority' => 7, 'type' => 'session', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 11:45:00', 'priority' => 8, 'type' => 'breakout', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 12:45:00', 'priority' => 9, 'type' => 'keynote', 'title' => 'Keynote', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 14:15:00', 'priority' => 10, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 14:30:00', 'priority' => 11, 'type' => 'session', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 14:30:00', 'priority' => 12, 'type' => 'breakout', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 15:30:00', 'priority' => 13, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 2, 'timeslot' => '2015-09-15 15:45:00', 'priority' => 14, 'type' => 'keynote', 'title' => 'Keynote', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        /*****  TAMPA IT STRATEGIES CONFERENCE (DATE TBD) *****/
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 07:30:00', 'priority' => 1, 'type' => 'break', 'title' => 'Networking Breakfast', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 09:00:00', 'priority' => 2, 'type' => 'keynote', 'title' => 'Keynote', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 10:00:00', 'priority' => 3, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 10:30:00', 'priority' => 4, 'type' => 'session', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 10:30:00', 'priority' => 5, 'type' => 'breakout', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 11:30:00', 'priority' => 6, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 11:45:00', 'priority' => 7, 'type' => 'session', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 11:45:00', 'priority' => 8, 'type' => 'breakout', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 12:45:00', 'priority' => 9, 'type' => 'keynote', 'title' => 'Keynote', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 14:15:00', 'priority' => 10, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 14:30:00', 'priority' => 11, 'type' => 'session', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 14:30:00', 'priority' => 12, 'type' => 'breakout', 'title' => 'Breakout', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 15:30:00', 'priority' => 13, 'type' => 'break', 'title' => 'Networking Break', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
        Agenda::create(['conference_id' => 3, 'timeslot' => '2015-09-15 15:45:00', 'priority' => 14, 'type' => 'keynote', 'title' => 'Keynote', 'published' => Carbon::create(2015, 00, 28, 15, 05, 29)]);
    }