/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// SET UP NEW CARBON DATES
$_old = '2016/san-antonio';
$_new = (object) ['slug' => '2017/san-antonio', 'published' => Carbon::create(2016, 01, 18, 16, 30, 00), 'start' => Carbon::create(2017, 01, 18, 07, 00, 00), 'end' => Carbon::create(2017, 01, 18, 16, 30, 00)];
// DELETE DUPLICATES
$conference = Conference::where('slug', '=', $_new->slug)->delete();
$forceDel = Conference::onlyTrashed()->forceDelete();
$agenda = Agenda::where('conference_slug', '=', $_new->slug)->delete();
$forceDel = Agenda::onlyTrashed()->forceDelete();
$option = Option::where('slug', '=', $_new->slug)->delete();
$forceDel = Option::onlyTrashed()->forceDelete();
unset($conference, $agenda, $option, $forceDel);
// RESCHEDULE CONFERENCE
$conference = Conference::where('slug', '=', $_old)->update(['slug' => $_new->slug, 'start_date' => $_new->start, 'end_date' => $_new->end, 'published' => $_new->published]);
// UPDATE OPTIONS
$option = Option::where('slug', '=', $_old)->update(['slug' => $_new->slug]);
// UPDATE AGENDA
$agendas = Agenda::where('conference_slug', '=', $_old)->get();
foreach ($agendas as $agenda) {
$agenda->conference_slug = $_new->slug;
$agenda->timeslot = $_new->start->format('Y-m-d') . ' ' . $agenda->timeslot->format('H:i:s');
$agenda->save();
}
// UPDATE SPEAKERS
$speakers = Speaker::where('conference_slug', '=', $_old)->update(['conference_slug' => $_new->slug]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// Variables for later use
$slug = '2016/austin';
$date = Carbon::parse('2016-09-21 00:00:00');
$published = Carbon::parse('2016-07-22 13:53:12');
// Turn off the topics since we have a fleshed out agenda
Option::where('slug', '=', $slug)->where('option', '=', 'show_topics')->where('value', '=', 1)->update(['value' => 0]);
// Update remaining agenda items
// 9:00 Keynote
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->addHours(9)->format('Y-m-d H:i:s'))->update(['slug' => 'staffing-training-and-talent-retention', 'session_type' => 'keynote', 'title' => 'Staffing, Training & Talent Retention', 'title_short' => 'Staffing, Training & Talent Retention', 'desc' => 'Join our opening panel of CIOs as we discuss challenges around staffing, training and how to keep our good talent from leaving. With new technological advances coming out all the time, we often need people with new types of advanced knowledge and skillsets. Do we hire and retrain people from within the organization or do we look to the pool of people coming from the universities or other areas? Join our panel as they discuss what they are doing to recruit and retrain technical staff, where they are finding their IT Talent and some of the things that they are doing to retain their good talent from leaving to find new opportunities.']);
// 10:30 Keynote
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->addHour()->addMinutes(30)->format('Y-m-d H:i:s'))->orderBy('priority', 'asc')->take(1)->update(['slug' => 'cyber-security', 'session_type' => 'keynote', 'title' => 'Cyber Security', 'title_short' => 'Cyber Security', 'desc' => 'With cyber threats evolving, IT Leaders are challenged to find more innovative ways to secure and protect information while increasing access to authorized users. Join our discussion as we talk about some of the security challenges and risks that comes with each. Discussion points will include: Personal vs. Corporate mobile devices and how to protect them, Multi factor authentication, the paradigm of web based applications, access to cloud networks and interactive real time infrastructures.']);
// Disable the second 10:30 breakout
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->format('Y-m-d H:i:s'))->orderBy('priority', 'desc')->take(1)->update(['published' => null]);
// 11:45 Breakouts
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->addHour()->addMinutes(15)->format('Y-m-d H:i:s'))->orderBy('priority', 'asc')->take(1)->update(['slug' => 'business-continuity-disaster-recovery', 'session_type' => 'breakout', 'title' => 'Business Continuity Disaster Recovery', 'title_short' => 'Business Continuity Disaster Recovery', 'desc' => '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 group of experts as they discuss some of the strategies and protocols which have been implemented to help protect their companies in the event that an emergency strikes.']);
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->format('Y-m-d H:i:s'))->orderBy('priority', 'desc')->take(1)->update(['slug' => 'new-technology-trends', 'session_type' => 'session', 'title' => 'New Technology Trends', 'title_short' => 'New Technology Trends', 'desc' => 'What is on the Horizon?']);
// 12:45 Keynote
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->addHour()->format('Y-m-d H:i:s'))->update(['slug' => 'the-internet-of-things', 'session_type' => 'keynote', 'title' => 'The Internet of Things', 'title_short' => 'The Internet of Things', 'desc' => 'As Technology advances, so has the capability to simultaneously connect devices, buildings, vehicles, networks, electronics, power grids, software, sensors and much more, giving us the ability to share, collect and use data in real time. Where the Internet of Things can provide convenience and benefits to the organization, it can also cause an IT organization many challenges. Join our panel of experts as they discuss how they are using IOT along with some of the significant challenges and benefits in moving to this type of technology.']);
// 2:30 Breakouts
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->addHour()->addMinutes(45)->format('Y-m-d H:i:s'))->orderBy('priority', 'asc')->take(1)->update(['slug' => 'it-alignment-keeping-ahead-of-change', 'session_type' => 'breakout', 'title' => 'IT Alignment - Keeping ahead of change', 'title_short' => 'IT Alignment', 'desc' => 'One of the most challenging tasks of the CIO is to ensure that the IT department is supporting and embracing the needs of the business. With technology advancing rapidly, companies are being forced to change and adapt quickly in order to stay competitive within the industry. How we handle these changes can have a deep impact on the bottom line for the organization. Join our panel of experts as they discuss some of the things that they are doing to keep up with the demand for new technologies while embracing and supporting the needs of the business.']);
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->format('Y-m-d H:i:s'))->orderBy('priority', 'desc')->take(1)->update(['slug' => 'information-security', 'session_type' => 'session', 'title' => 'Information Security', 'title_short' => 'Information Security', 'desc' => 'Companies are collecting enormous amounts of real time information and data from customers, devices and employees. There are many things that we can do to ensure that the information collected is protected and secure. Join our panel as we discuss some of the challenges around:<ul><li>Adaptive Security Architectures – How they are used to identify and counter evolving threats</li><li>Email Security - protocol and enforcement of personal email through corporate mail systems</li><li>System ownership - ways to get end users and operators to take ownership of applications</li><li>End user security awareness training</li></ul>']);
// 3:45 Keynote
Agenda::where('conference_slug', '=', $slug)->where('timeslot', '=', $date->addHour()->addMinutes(15)->format('Y-m-d H:i:s'))->update(['slug' => 'the-value-of-it-solutions', 'session_type' => 'keynote', 'title' => 'The Value of IT Solutions', 'title_short' => 'The Value of IT Solutions', 'desc' => 'CIOs are continually asked to spend less and do more while supporting the needs of the organization. In this session we will have an open dialogue on value of many IT solutions that companies use. With newer and better technologies, software and upgrades always around the corner, looking at all of our options can save us a lot of time and money. Join our panel of experts as they address pros and cons of subscription based vs. fully licensed products such as Office 365, flash storage vs. traditional storage and Cloud vs. private cloud or on premise solutions and the value of doing a short and long term cost benefit analysis before making a final decision.']);
}
public static function lookup_agendas($params, $flags)
{
$agendas = Agenda::where('conference_id', '=', $params->conference)->orderBy('timeslot')->orderBy('priority');
if (self::flags($flags, 'published')) {
$agendas->published();
}
return self::collectionToArray($agendas->get());
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// SET UP NEW CARBON DATES
$_old = '2017/tampa';
$_new = (object) ['slug' => '2017/tampa', 'published' => Carbon::create(2016, 03, 02, 16, 30, 00), 'start' => Carbon::create(2017, 03, 02, 07, 00, 00), 'end' => Carbon::create(2017, 03, 02, 16, 30, 00)];
// RESCHEDULE CONFERENCE
$conference = Conference::where('slug', '=', $_old)->update(['slug' => $_new->slug, 'start_date' => $_new->start, 'end_date' => $_new->end, 'published' => $_new->published]);
// UPDATE OPTIONS
$options = Option::insert(['slug' => '2017/tampa', 'option' => 'show_upcoming', 'value' => 0, 'published' => Carbon::now()]);
// UPDATE AGENDA
$agendas = Agenda::where('conference_slug', '=', $_old)->get();
foreach ($agendas as $agenda) {
$agenda->conference_slug = $_new->slug;
$agenda->timeslot = $_new->start->format('Y-m-d') . ' ' . $agenda->timeslot->format('H:i:s');
$agenda->save();
}
// UPDATE SPEAKERS
$speakers = Speaker::where('conference_slug', '=', $_old)->update(['conference_slug' => $_new->slug]);
}
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'));
}
public function agenda($id)
{
$this->data['title'] = 'Agenda';
$this->data['agendalist'] = Models\Agenda::find($id);
return view('front.agenda', $this->data);
}
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'));
}
public function showAgenda()
{
$model = new Slot();
$exist = Agenda::find()->where(['agendaID' => $this->agendaID])->one();
$permAgendaID = Agenda::find()->where(['owner' => $exist['owner'], 'type' => 'perm'])->one();
$tempSlotIDs = array();
if ($exist['type'] == 'temp') {
$tempSlotIDs = $model->getIDs($this->agendaID);
}
$permSlotIDs = $model->getIDs($permAgendaID['agendaID']);
$permindex = 0;
$tempindex = 0;
$agendforShow = array();
$index = 0;
while ($permindex < sizeof($permSlotIDs) && $tempindex < sizeof($tempSlotIDs)) {
if ($tempSlotIDs[$tempindex]['slotnum'] == $permSlotIDs[$permindex]['slotnum']) {
$agendforShow[$index]['slotID'] = $tempSlotIDs[$tempindex]['slotID'];
$agendforShow[$index]['maxBookers'] = $tempSlotIDs[$tempindex]['numberOfBookers'];
$agendforShow[$index]['content'] = $tempSlotIDs[$tempindex]['content'];
$count = Book::find()->where(['slotID' => $agendforShow[$index]['slotID'], 'date' => $exist['lastUpdate']])->count();
$agendforShow[$index]['bookCount'] = $count;
$tempindex++;
$index++;
} else {
$agendforShow[$index]['slotID'] = $permSlotIDs[$permindex]['slotID'];
$agendforShow[$index]['maxBookers'] = $permSlotIDs[$permindex]['numberOfBookers'];
$agendforShow[$index]['content'] = $permSlotIDs[$permindex]['content'];
$count = Book::find()->where(['slotID' => $agendforShow[$index]['slotID'], 'date' => $exist['lastUpdate']])->count();
$agendforShow[$index]['bookCount'] = $count;
$index++;
}
$permindex++;
}
while ($tempindex < sizeof($tempSlotIDs)) {
$agendforShow[$index]['slotID'] = $tempSlotIDs[$tempindex]['slotID'];
$agendforShow[$index]['maxBookers'] = $tempSlotIDs[$tempindex]['numberOfBookers'];
$agendforShow[$index]['content'] = $tempSlotIDs[$tempindex]['content'];
$count = Book::find()->where(['slotID' => $agendforShow[$index]['slotID'], 'date' => $exist['lastUpdate']])->count();
$agendforShow[$index]['bookCount'] = $count;
$tempindex++;
$index++;
}
while ($permindex < sizeof($permSlotIDs)) {
$agendforShow[$index]['slotID'] = $permSlotIDs[$permindex]['slotID'];
$agendforShow[$index]['maxBookers'] = $permSlotIDs[$permindex]['numberOfBookers'];
$agendforShow[$index]['content'] = $permSlotIDs[$permindex]['content'];
$count = Book::find()->where(['slotID' => $agendforShow[$index]['slotID'], 'date' => $exist['lastUpdate']])->count();
$agendforShow[$index]['bookCount'] = $count;
$permindex++;
$index++;
}
return $agendforShow;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$agenda = Agenda::find($id);
if ($agenda->delete()) {
return response()->json(array('success' => TRUE));
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAgendas()
{
return $this->hasMany(Agenda::className(), ['owner' => 'formalemail']);
}
public function actionIsException()
{
$owner = $_POST['owner'];
$lastUpdate = $_POST['date'];
$exist = Agenda::find()->select('lastUpdate')->where(['owner' => $owner, 'type' => 'temp', 'lastUpdate' => $lastUpdate])->asArray()->all();
echo json_encode($exist);
}
public function agenda($slug)
{
$agenda_detail = Models\Agenda::where('slug_agenda', $slug)->first();
$this->data['title'] = $agenda_detail->tema_agenda;
$this->data['agendalist'] = $agenda_detail;
return view('web.agenda_detail', $this->data);
}
/**
* 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)]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//
Speaker::where('conference_slug', '=', '2017/san-antonio')->update(['agenda_slug' => null, 'published' => null]);
Agenda::where('conference_slug', '=', '2017/san-antonio')->update(['speakers' => null]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAgenda()
{
return $this->hasOne(Agenda::className(), ['agendaID' => 'agendaID']);
}
