Code Context $storms = $this->Storm->query($sql);
$this->set('stateName', $this->Constants->states_lookup[$state]);
$state = 'ok'
$county = '503'
$loc = (int) 78837
$location = array(
'Location' => array(
'id' => '78837',
'country' => 'USA',
'zipcode' => '74735',
'state' => 'OK',
'city' => 'Fort Towson',
'county' => 'Choctaw',
'county_id' => '503',
'premium' => false,
'active' => true,
'perm' => false,
'is_airport' => false,
'activated' => '2016-10-31 15:57:39',
'timezone' => 'America/Chicago',
'notes' => null,
'archived' => false,
'type' => 'shape'
),
'County' => array(
'id' => '503',
'state' => 'OK',
'name' => 'Choctaw',
'county_group_id' => '37',
'core' => false
)
)
$defs = array(
(int) 6 => 'Rain',
(int) 7 => 'Snow',
(int) 8 => 'Sleet',
(int) 9 => 'Freezing Rain',
(int) 10 => 'Wintry Mix',
(int) 11 => 'Ice',
(int) 12 => 'None',
(int) 13 => 'Snow / Sleet'
)
$seasons = '2025,2024,2023'
$sql = '
select *
from storms
join storm_locations on storm_locations.storm_id = storms.id
join narratives on narratives.id = storm_locations.narrative_id
where storms.season_id in (2025,2024,2023)
and storm_locations.published = 1
and storm_locations.deleted = 0
and storms.published = 1
and storms.deleted = 0
and storm_locations.location_id = 78837
'
$storms = array(
(int) 0 => array(
'storms' => array(
'id' => '65618',
'county_group_id' => '37',
'season_id' => '2023',
'author' => '189',
'publisher' => '189',
'min_start' => '2024-01-14 08:00:00',
'max_end' => '2024-01-15 08:30:00',
'storm_obs_set_id' => '42695',
'minutes_worked' => '185',
'email_sent' => '0',
'published' => true,
'published_date' => '2024-01-17 00:03:01',
'scheduled_publish' => '2024-01-17 00:00:00',
'pending_review' => false,
'deleted' => false,
'created' => '2024-01-14 21:31:37',
'modified' => '2024-01-17 00:03:01'
),
'storm_locations' => array(
'id' => '12610225',
'storm_id' => '65618',
'location_id' => '78837',
'narrative_id' => '840554',
'note_id' => null,
'start' => '2024-01-14 16:30:00',
'start_high' => '2024-01-14 19:30:00',
'end_low' => '2024-01-15 05:30:00',
'end' => '2024-01-15 08:30:00',
'precip_type' => '7',
'snow_amount' => '0.0',
'snow_trace' => '1',
'ice_amount' => '0.00',
'ice_amount_low' => '0.00',
'ice_amount_high' => '0.00',
'ice_trace' => null,
'published' => true,
'deleted' => false
),
'narratives' => array(
'id' => '840554',
'storm_id' => '65618',
'is_notes' => false,
'label' => 'S OK',
'text' => '',
'title' => 'A period of Snow on January 14-15',
'body' => 'A period of snow started to affect the region around 4:30 - 7:30 PM January 14th. The rate during this period was light to occasionally moderate with temperatures between 9-14 degrees during the event. The period of snow ended before midnight. Scattered light to moderate snow showers lingered overnight as temperatures dropped to around 3-7 degrees. All snow showers ended by 5:30 - 8:30 AM January 15th.',
'footer' => '',
'title_template' => 'A period of Snow on #STORMDATE',
'body_template' => 'A period of snow started to affect the region around #START. The rate during this period was light to occasionally moderate with temperatures between 9-14 degrees during the event. The period of snow ended before midnight. Scattered light to moderate snow showers lingered overnight as temperatures dropped to around 3-7 degrees. All snow showers ended by #END.',
'footer_template' => '',
'start_low' => '2024-01-14 16:30:00',
'start_high' => '2024-01-14 19:30:00',
'end_low' => '2024-01-15 05:30:00',
'end_high' => '2024-01-15 08:30:00',
'time_mode' => 'startend'
)
),
(int) 1 => array(
'storms' => array(
'id' => '65878',
'county_group_id' => '37',
'season_id' => '2023',
'author' => '189',
'publisher' => '189',
'min_start' => '2024-01-21 14:00:00',
'max_end' => '2024-01-22 14:00:00',
'storm_obs_set_id' => '42928',
'minutes_worked' => '135',
'email_sent' => '0',
'published' => true,
'published_date' => '2024-01-24 10:03:01',
'scheduled_publish' => '2024-01-24 10:00:00',
'pending_review' => false,
'deleted' => false,
'created' => '2024-01-22 17:04:35',
'modified' => '2024-01-24 10:03:01'
),
'storm_locations' => array(
'id' => '12721869',
'storm_id' => '65878',
'location_id' => '78837',
'narrative_id' => '842025',
'note_id' => null,
'start' => '2024-01-21 20:00:00',
'start_high' => '2024-01-21 23:00:00',
'end_low' => '2024-01-22 07:00:00',
'end' => '2024-01-22 10:00:00',
'precip_type' => '9',
'snow_amount' => '0.0',
'snow_trace' => null,
'ice_amount' => '0.10',
'ice_amount_low' => '0.00',
'ice_amount_high' => '0.00',
'ice_trace' => null,
'published' => true,
'deleted' => false
),
'narratives' => array(
'id' => '842025',
'storm_id' => '65878',
'is_notes' => false,
'label' => 'SE OK',
'text' => '',
'title' => 'Periods of Freezing Rain on January 21-22',
'body' => 'Periods of freezing rain began to impact the area around 8 - 11 PM January 21st. The freezing rain was on and off throughout the event. Temperatures were between 28-32 degrees throughout the event. As temperatures rose to 32-26 degrees by the end of the end, the freezing rain transitioned over to plain rain by 7 - 10 AM January 22nd.',
'footer' => '',
'title_template' => 'Periods of Freezing Rain on #STORMDATE',
'body_template' => 'Periods of freezing rain began to impact the area around #START. The freezing rain was on and off throughout the event. Temperatures were between 28-32 degrees throughout the event. As temperatures rose to 32-26 degrees by the end of the end, the freezing rain transitioned over to plain rain by #END.',
'footer_template' => '',
'start_low' => '2024-01-21 20:00:00',
'start_high' => '2024-01-21 23:00:00',
'end_low' => '2024-01-22 07:00:00',
'end_high' => '2024-01-22 10:00:00',
'time_mode' => 'startend'
)
)
)
StormHistoryController::history() - APP/Controller/StormHistoryController.php, line 90
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 107
