function addEventToZip($eid, $mid, $zip)
{
$query = "SELECT Id, MonitorId, StartTime, Frames FROM Events WHERE Id={$eid}";
$results = dbFetchAll($query);
$scale = max(reScale(SCALE_BASE, '100', ZM_WEB_DEFAULT_SCALE), SCALE_BASE);
foreach ($results as $result) {
for ($counter = 1; $counter <= $result['Frames']; $counter++) {
$event['Id'] = $result['Id'];
$event['StartTime'] = $result['StartTime'];
$event['MonitorId'] = $result['MonitorId'];
$imageData = getImageSrc($event, $counter, $scale, isset($_REQUEST['show']) && $_REQUEST['show'] == "capt");
$imagePath = $imageData['thumbPath'];
$eventPath = $imageData['eventPath'];
$dImagePath = sprintf("%s/%0" . ZM_EVENT_IMAGE_DIGITS . "d-diag-d.jpg", $eventPath, $counter);
$rImagePath = sprintf("%s/%0" . ZM_EVENT_IMAGE_DIGITS . "d-diag-r.jpg", $eventPath, $counter);
$frames[] = viewImagePath($imagePath);
}
$zip->addDirectory("events/" . $event['MonitorId']);
$zip->addDirectory("events/" . $event['MonitorId'] . "/" . $event['Id']);
}
$i = 0;
$filesString = "";
foreach ($frames as $frame) {
$i++;
$filesName = sprintf("%0" . ZM_EVENT_IMAGE_DIGITS . "d-capture.jpg", $i);
$filesString .= "\nframes.push(\"events/" . $mid . "/" . $eid . "/" . $filesName . "\");";
$zip->addLargeFile($frame, "events/" . $mid . "/" . $eid . "/" . $filesName);
}
return $filesString;
}
public function getSearch()
{
$categoryId = Input::get('categoryid');
$search = Input::get('query');
$objects = null;
if ($categoryId) {
// Category Image
if ($featuredImageId = ObjectMeta::getValue($categoryId, '_featured_image')) {
$featuredImageUrl = getImageSrc($featuredImageId, 'thumbnail');
}
// Get objects where in category
$objects = Object::Where('type', 'object_type')->whereExists(function ($query) use($categoryId) {
$query->select(DB::raw(1))->from('object_meta')->whereRaw(DB::getTablePrefix() . 'object_meta.object_id = ' . DB::getTablePrefix() . 'objects.id')->where('meta_key', '_category_id')->where('meta_value', $categoryId);
})->select(DB::raw('substr(name, 14) as field_name'))->get()->toArray();
$types = array_map(function ($v) {
return $v['field_name'];
}, $objects);
if (!empty($types)) {
$objects = Object::whereIn('type', $types);
}
}
if ($objects) {
$objects = $objects->select(array('objects.id', DB::raw('"/uploads/' . $featuredImageUrl . '"' . ' as featured_image'), 'objects.name', 'objects.title', 'objects.excerpt'))->get();
}
return $objects;
}
public function getCategories($id = null)
{
//Config::set('laravel-debugbar::config.enabled', false);
$categories = Object::where('objects.type', 'category')->where('parent_id', $id)->select(array('objects.id', 'objects.title', 'objects.name'))->get();
$response = $categories;
foreach ($categories as $category) {
if ($contentImageId = ObjectMeta::getValue($category->id, '_content_image')) {
if ($contentImageUrl = getImageSrc($contentImageId, 'medium')) {
$category['contentImageUrl'] = '/uploads/' . $contentImageUrl;
}
}
if ($featuredImageId = ObjectMeta::getValue($category->id, '_featured_image')) {
if ($featuredImageUrl = getImageSrc($featuredImageId, 'thumbnail')) {
$category['featuredImageUrl'] = '/uploads/' . $featuredImageUrl;
}
}
$category['childrenCount'] = Object::where('objects.type', 'category')->where('parent_id', $category['id'])->count();
$category['itemsCount'] = ObjectMeta::join('objects', 'object_meta.object_id', '=', 'objects.id')->where('meta_key', '_category_id')->where('meta_value', $category['id'])->where('objects.type', '<>', 'category')->groupBy('object_id')->count();
}
// $categories = Object::leftJoin('objects as t1', function($join) {
// $join->on('objects.id', '=', 't1.parent_id');
// })
// ->where('objects.type', 'category')
// //->whereNull('objects.parent_id')
// ->where('t1.parent_id', $id)
// ->select(DB::raw('jini_t1.*'))
// ->get();
//print_r($categories);
//
// $response = array(
// 'categories' => $categories
// //'contentImage' =>
// );
return response()->json($categories);
}
public function default()
{
$default = "assets/images/default.jpg";
if (FileSystem::exists($default) && FileSystem::isImage($default)) {
return getImageSrc($default, $this->width, $this->height);
}
return null;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function getEdit($id)
{
$object = Object::find($id);
$parent_id = $object->parent_id;
$categories = Object::where('type', 'category')->where('id', '!=', $id)->get();
if ($imageObjectId = $object->getValue('_featured_image')) {
$featuredImage = getImageSrc($imageObjectId, 'thumbnail');
}
if ($imageObjectId = $object->getValue('_content_image')) {
$contentImage = getImageSrc($imageObjectId, 'thumbnail');
}
$toolTip = $object->getValue('_tooltip');
return view('admin.category.create_edit', compact('object', 'parent_id', 'categories', 'featuredImage', 'contentImage', 'toolTip'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function getEdit($id)
{
$object = Object::find($id);
$parent_id = $object->parent_id;
$categories = Object::where('type', 'category')->where('id', '!=', $id)->get();
if ($imageObjectId = $object->getValue('_featured_image')) {
// $featuredImage = getImageSrc($imageObjectId, 'thumbnail');
$featuredImage = 'cropped/' . getTheImageSize(getImageSrc($imageObjectId), '_featured_image');
}
if ($imageObjectId = $object->getValue('_content_image')) {
// $contentImage = getImageSrc($imageObjectId, 'thumbnail');
$contentImage = 'cropped/' . getTheImageSize(getImageSrc($imageObjectId), '_content_image');
}
$toolTip = $object->getValue('_tooltip');
$keywords = $object->keywords->implode('content', ', ');
return view('admin.category.create_edit', compact('object', 'parent_id', 'categories', 'featuredImage', 'contentImage', 'toolTip', 'keywords'));
}
private function processCategory(&$category)
{
if ($contentImageId = ObjectMeta::getValue($category->id, '_content_image')) {
if ($contentImageUrl = getImageSrc($contentImageId, 'medium')) {
$category['contentImageUrl'] = '/uploads/' . $contentImageUrl;
}
}
if ($featuredImageId = ObjectMeta::getValue($category->id, '_featured_image')) {
if ($featuredImageUrl = getImageSrc($featuredImageId, 'small')) {
$category['featuredImageUrl'] = '/uploads/' . $featuredImageUrl;
// $path = __DIR__ . '/../../../public/uploads/' . $featuredImageUrl;
// echo $path . '<br />' . file_exists($path) . '<br />';
// if (file_exists($path)) {
// $type = pathinfo($path, PATHINFO_EXTENSION);
// $data = file_get_contents($path);
// $category['featuredImageUrl'] = base64_encode($data);
// }
}
}
$category['childrenCount'] = Object::where('objects.type', 'category')->where('parent_id', $category['id'])->count();
$category['itemsCount'] = ObjectMeta::join('objects', 'object_meta.object_id', '=', 'objects.id')->where('meta_key', '_category_id')->where('meta_value', $category['id'])->where('objects.type', '<>', 'category')->groupBy('object_id')->count();
return $category;
}
}
} else {
$frame = dbFetchOne('SELECT * FROM Frames WHERE EventId = ? AND Score = ?', NULL, array($eid, $event['MaxScore']));
}
$maxFid = $event['Frames'];
$firstFid = 1;
$prevFid = $frame['FrameId'] - 1;
$nextFid = $frame['FrameId'] + 1;
$lastFid = $maxFid;
$alarmFrame = $frame['Type'] == 'Alarm';
if (isset($_REQUEST['scale'])) {
$scale = validInt($_REQUEST['scale']);
} else {
$scale = max(reScale(SCALE_BASE, $event['DefaultScale'], ZM_WEB_DEFAULT_SCALE), SCALE_BASE);
}
$imageData = getImageSrc($event, $frame, $scale, isset($_REQUEST['show']) && $_REQUEST['show'] == "capt");
$imagePath = $imageData['thumbPath'];
$eventPath = $imageData['eventPath'];
$dImagePath = sprintf("%s/%0" . ZM_EVENT_IMAGE_DIGITS . "d-diag-d.jpg", $eventPath, $frame['FrameId']);
$rImagePath = sprintf("%s/%0" . ZM_EVENT_IMAGE_DIGITS . "d-diag-r.jpg", $eventPath, $frame['FrameId']);
$focusWindow = true;
xhtmlHeaders(__FILE__, translate('Frame') . " - " . $event['Id'] . " - " . $frame['FrameId']);
?>
<body>
<div id="page">
<div id="header">
<div id="headerButtons">
<?php
if (ZM_RECORD_EVENT_STATS && $alarmFrame) {
echo makePopupLink('?view=stats&eid=' . $event['Id'] . '&fid=' . $frame['FrameId'], 'zmStats', 'stats', translate('Stats'));
}
function getImage($device)
{
global $config;
return '<img src="' . getImageSrc($device) . '" />';
}
$map_init = "[" . $config['leaflet']['default_lat'] . ", " . $config['leaflet']['default_lng'] . "], " . sprintf("%01.0f", $config['leaflet']['default_zoom']);
$temp_output .= 'var map = L.map(\'leaflet-map\').setView(' . $map_init . ');
L.tileLayer(\'//{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\', {
attribution: \'© <a href="http://osm.org/copyright">OpenStreetMap</a> contributors\'
}).addTo(map);
var markers = L.markerClusterGroup();
var redMarker = L.AwesomeMarkers.icon({
icon: \'server\',
markerColor: \'red\', prefix: \'fa\', iconColor: \'white\'
});
var greenMarker = L.AwesomeMarkers.icon({
icon: \'server\',
markerColor: \'green\', prefix: \'fa\', iconColor: \'white\'
});
';
foreach (dbFetchRows("SELECT `device_id`,`hostname`,`os`,`status`,`lat`,`lng` FROM `devices` LEFT JOIN `locations` ON `devices`.`location`=`locations`.`location` WHERE `disabled`=0 AND `ignore`=0 AND `lat` != '' AND `lng` != '' ORDER BY `status` ASC, `hostname`") as $map_devices) {
$icon = 'greenMarker';
if ($map_devices['status'] == 0) {
$icon = 'redMarker';
}
$temp_output .= "var title = '<a href=\"" . generate_device_url($map_devices) . "\"><img src=\"" . getImageSrc($map_devices) . "\" width=\"32\" height=\"32\" alt=\"\">" . $map_devices['hostname'] . "</a>';\n var marker = L.marker(new L.LatLng(" . $map_devices['lat'] . ", " . $map_devices['lng'] . "), {title: title, icon: {$icon}});\n marker.bindPopup(title);\n markers.addLayer(marker);\n";
}
$temp_output .= 'map.addLayer(markers);
</script>';
} else {
$temp_output = 'Mapael engine not supported here';
}
unset($common_output);
$common_output[] = $temp_output;
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
//
if (!canView('Events')) {
$_REQUEST['view'] = "error";
return;
}
$event = dbFetchOne('select E.*,M.Name as MonitorName from Events as E, Monitors as M where E.Id = ? and E.MonitorId = M.Id', NULL, array($_REQUEST['eid']));
$frame = dbFetchOne('select * from Frames where EventID = ? and Score = ?', NULL, array($_REQUEST['eid'], $event['MaxScore']));
$scale = getDeviceScale($event['Width'], $event['Height'], 2.2);
$image1 = getImageSrc($event, 1, $scale);
if ($frame['Type'] == 'Alarm') {
$image2 = getImageSrc($event, $frame['FrameId'], $scale);
} else {
$image2 = getImageSrc($event, intval($event['Frames'] / 2), $scale);
}
xhtmlHeaders(__FILE__, translate('Event') . ' - ' . $_REQUEST['eid']);
?>
<body>
<div id="page">
<div id="content">
<table id="contentTable" class="major">
<tr>
<th scope="row"><?php
echo translate('Name');
?>
</th>
<td><?php
echo htmlentities($event['Name']);
echo $event['Archived'] ? "(" . translate('Archived') . ")" : "";
function getFrameImage()
{
$eventId = $_REQUEST['id'][0];
$frameId = $_REQUEST['id'][1];
$sql = 'select * from Frames where EventId = ? and FrameId = ?';
if (!($frame = dbFetchOne($sql, NULL, array($eventId, $frameId)))) {
$frame = array();
$frame['EventId'] = $eventId;
$frame['FrameId'] = $frameId;
$frame['Type'] = "Virtual";
}
$event = dbFetchOne('select * from Events where Id = ?', NULL, array($frame['EventId']));
$frame['Image'] = getImageSrc($event, $frame, SCALE_BASE);
return $frame;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function getEdit($id)
{
$data = Object::get();
$object = Object::find($id);
if ($typeName = $object->type) {
if ($type = Object::getType($typeName)->first()) {
$fieldsRows = Object::getFields($type->id)->get();
$fields = array();
$fieldControls = array();
// Promoted
$field = array();
$field['id'] = '_field_promoted';
$field['name'] = 'promoted';
$field['label'] = 'Promoted';
$field['type'] = 'boolean';
$field['instructions'] = '';
$field['required'] = 0;
$values = $this->getFieldValues($id, $field);
foreach ($values as $key => $value) {
if ($values[$key] == '1') {
$values[$key] = 'on';
}
}
$fieldControls[] = view('admin.partials.form.boolean', compact('field', 'values'));
// Occupation
$field = array();
$field['id'] = '_field_occupation';
$field['name'] = 'occupation';
$field['label'] = 'Occupation';
$field['type'] = 'text';
$field['instructions'] = '';
$field['required'] = 0;
$values = $this->getFieldValues($id, $field);
$fieldControls[] = view('admin.partials.form.text', compact('field', 'values'));
// Address
$uniqueId = Hash::getUniqueId();
$field = array();
$field['id'] = '_field_address';
$field['name'] = 'address';
$field['label'] = 'Address';
$field['type'] = 'map';
$field['instructions'] = '';
$field['required'] = 0;
$values = $this->getFieldValues($id, $field);
$fieldControls[] = view('admin.partials.form.map', compact('field', 'values', 'uniqueId'));
// French
$field = array();
$field['id'] = '_field_french_speakers';
$field['name'] = 'french_speakers';
$field['label'] = 'French Speakers';
$field['type'] = 'boolean';
$field['instructions'] = '';
$field['required'] = 0;
$values = $this->getFieldValues($id, $field);
$fieldControls[] = view('admin.partials.form.boolean', compact('field', 'values'));
// Address
$field = array();
$field['id'] = '_field_phone';
$field['name'] = 'phone';
$field['label'] = 'Phone';
$field['type'] = 'tel';
$field['instructions'] = '';
$field['required'] = 0;
$values = $this->getFieldValues($id, $field);
$fieldControls[] = view('admin.partials.form.tel', compact('field', 'values'));
// Email
$field = array();
$field['id'] = '_field_email';
$field['name'] = 'email';
$field['label'] = 'Email';
$field['type'] = 'email';
$field['instructions'] = '';
$field['required'] = 0;
$values = $this->getFieldValues($id, $field);
$fieldControls[] = view('admin.partials.form.email', compact('field', 'values'));
foreach ($fieldsRows as $fieldRow) {
$field = unserialize($fieldRow['meta_value']);
$fields[] = $field;
//$field['value'] = $object->getValue($field['id']);
$values = array();
$valuesMeta = ObjectMeta::where('object_id', $id)->where('meta_key', 'LIKE', $field['id'] . '%')->get();
foreach ($valuesMeta as $valueMeta) {
$valueMetaKey = str_replace($field['id'], '', $valueMeta['meta_key']);
if (substr($valueMetaKey, 0, 1) == '-') {
$valueMetaKey = substr($valueMetaKey, 1);
}
$value = $valueMeta['meta_value'];
if ($value == '1') {
$value = 'on';
}
if ($valueMetaKey) {
$values[$valueMetaKey] = $value;
} else {
$values[] = $value;
}
}
$uniqueId = Hash::getUniqueId();
switch ($field['type']) {
case 'text':
$fieldControls[] = view('admin.partials.form.text', compact('field', 'values', 'uniqueId'));
break;
case 'wysiwyg':
$fieldControls[] = view('admin.partials.form.wysiwyg', compact('field', 'values', 'uniqueId'));
break;
case 'map':
$fieldControls[] = view('admin.partials.form.map', compact('field', 'values', 'uniqueId'));
break;
case 'tel':
$fieldControls[] = view('admin.partials.form.tel', compact('field', 'values', 'uniqueId'));
break;
case 'boolean':
$fieldControls[] = view('admin.partials.form.boolean', compact('field', 'values', 'uniqueId'));
break;
}
}
}
}
if (isset($object)) {
if ($imageObjectId = $object->getValue('_featured_image')) {
$featuredImage = getImageSrc($imageObjectId, 'thumbnail');
}
if ($imageObjectId = $object->getValue('_content_image')) {
$contentImage = getImageSrc($imageObjectId, 'thumbnail');
}
//d
}
return view('admin.object.create_edit', compact('object', 'fields', 'values', 'fieldControls', 'featuredImage', 'contentImage'));
}
function getImage($device)
{
return '<img src="' . getImageSrc($device) . '" />';
}
if ($result['disabled'] == 1) {
$highlight_colour = '#808080';
} else {
if ($result['ignored'] == 1 && $result['disabled'] == 0) {
$highlight_colour = '#000000';
} else {
if ($result['status'] == 0 && $result['ignore'] == 0 && $result['disabled'] == 0) {
$highlight_colour = '#ff0000';
} else {
if ($result['status'] == 1 && $result['ignore'] == 0 && $result['disabled'] == 0) {
$highlight_colour = '#008000';
}
}
}
}
$device[] = array('name' => $name, 'hostname' => $result['hostname'], 'device_id' => $result['device_id'], 'colours' => $highlight_colour, 'device_image' => getImageSrc($result), 'device_hardware' => $result['hardware'], 'device_os' => $config['os'][$result['os']]['text'], 'version' => $result['version'], 'location' => $result['location'], 'plugin' => $result['mplug_type']);
}
//end foreach
}
//end if
$json = json_encode($device);
die($json);
} else {
if ($_REQUEST['type'] == 'iftype') {
// Device search
if (is_admin() === true || is_read() === true) {
$results = dbFetchRows("SELECT `ports`.ifType FROM `ports` WHERE `ifType` LIKE '%" . $search . "%' GROUP BY ifType ORDER BY ifType LIMIT " . $limit);
} else {
$results = dbFetchRows("SELECT `I`.ifType FROM `ports` AS `I`, `devices` AS `D`, `devices_perms` AS `P`, `ports_perms` AS `PP` WHERE ((`P`.`user_id` = ? AND `P`.`device_id` = `D`.`device_id`) OR (`PP`.`user_id` = ? AND `PP`.`port_id` = `I`.`port_id` AND `I`.`device_id` = `D`.`device_id`)) AND `D`.`device_id` = `I`.`device_id` AND (`ifType` LIKE '%" . $search . "%') GROUP BY ifType ORDER BY ifType LIMIT " . $limit, array($_SESSION['user_id'], $_SESSION['user_id']));
}
if (count($results)) {
// APP ----------
// TODO: Auto colors
var font_white = new Font('<?php
echo getImageSrc('font_1.png');
?>
', 8, glyphsData);
var font_yellow = new Font('<?php
echo getImageSrc('font_1_yellow.png');
?>
', 8, glyphsData);
var font_black = new Font('<?php
echo getImageSrc('font_1_black.png');
?>
', 8, glyphsData);
var out = document.getElementById('out');
var canvas = document.getElementById('panel');
canvas.style.width = canvas.width * <?php
echo CANVAS_SCALE;
?>
+ 'px';
canvas.style.height = canvas.height * <?php
echo CANVAS_SCALE;
?>
+ 'px';
var ctx = canvas.getContext('2d');
function createListThumbnail( $event, $overwrite=false )
{
$sql = "select * from Frames where EventId = '".$event['Id']."' and Score = '".$event['MaxScore']."' order by FrameId limit 1";
if ( !($frame = dbFetchOne( $sql )) )
return( false );
$frameId = $frame['FrameId'];
if ( ZM_WEB_LIST_THUMB_WIDTH )
{
$thumbWidth = ZM_WEB_LIST_THUMB_WIDTH;
$scale = (SCALE_BASE*ZM_WEB_LIST_THUMB_WIDTH)/$event['Width'];
$thumbHeight = reScale( $event['Height'], $scale );
}
elseif ( ZM_WEB_LIST_THUMB_HEIGHT )
{
$thumbHeight = ZM_WEB_LIST_THUMB_HEIGHT;
$scale = (SCALE_BASE*ZM_WEB_LIST_THUMB_HEIGHT)/$event['Height'];
$thumbWidth = reScale( $event['Width'], $scale );
}
else
{
Fatal( "No thumbnail width or height specified, please check in Options->Web" );
}
$imageData = getImageSrc( $event, $frame, $scale, false, $overwrite );
$thumbData = $frame;
$thumbData['Path'] = $imageData['thumbPath'];
$thumbData['Width'] = (int)$thumbWidth;
$thumbData['Height'] = (int)$thumbHeight;
return( $thumbData );
}
$name = $result['hostname'];
if ($result['disabled'] == 1) {
$highlight_colour = '#808080';
} elseif ($result['ignored'] == 1 && $result['disabled'] == 0) {
$highlight_colour = '#000000';
} elseif ($result['status'] == 0 && $result['ignore'] == 0 && $result['disabled'] == 0) {
$highlight_colour = '#ff0000';
} elseif ($result['status'] == 1 && $result['ignore'] == 0 && $result['disabled'] == 0) {
$highlight_colour = '#008000';
}
if (is_admin() === TRUE || is_read() === TRUE) {
$num_ports = dbFetchCell("SELECT COUNT(*) FROM `ports` WHERE device_id = ?", array($result['device_id']));
} else {
$num_ports = dbFetchCell("SELECT COUNT(*) FROM `ports` AS `I`, `devices` AS `D`, `devices_perms` AS `P` WHERE `P`.`user_id` = ? AND `P`.`device_id` = `D`.`device_id` AND `I`.`device_id` = `D`.`device_id` AND device_id = ?", array($_SESSION['user_id'], $result['device_id']));
}
$device[] = array('name' => $name, 'device_id' => $result['device_id'], 'url' => generate_device_url($result), 'colours' => $highlight_colour, 'device_ports' => $num_ports, 'device_image' => getImageSrc($result), 'device_hardware' => $result['hardware'], 'device_os' => $config['os'][$result['os']]['text'], 'version' => $result['version'], 'location' => $result['location']);
}
}
$json = json_encode($device);
print_r($json);
exit;
} elseif ($_REQUEST['type'] == 'ports') {
// Search ports
if (is_admin() === TRUE || is_read() === TRUE) {
$results = dbFetchRows("SELECT `ports`.*,`devices`.* FROM `ports` LEFT JOIN `devices` ON `ports`.`device_id` = `devices`.`device_id` WHERE `ifAlias` LIKE '%" . $search . "%' OR `ifDescr` LIKE '%" . $search . "%' ORDER BY ifDescr LIMIT 8");
} else {
$results = dbFetchRows("SELECT DISTINCT(`I`.`port_id`), `I`.*, `D`.`hostname` FROM `ports` AS `I`, `devices` AS `D`, `devices_perms` AS `P`, `ports_perms` AS `PP` WHERE ((`P`.`user_id` = ? AND `P`.`device_id` = `D`.`device_id`) OR (`PP`.`user_id` = ? AND `PP`.`port_id` = `I`.`port_id` AND `I`.`device_id` = `D`.`device_id`)) AND `D`.`device_id` = `I`.`device_id` AND (`ifAlias` LIKE '%" . $search . "%' OR `ifDescr` LIKE '%" . $search . "%') ORDER BY ifDescr LIMIT 8", array($_SESSION['user_id'], $_SESSION['user_id']));
}
if (count($results)) {
$found = 1;
foreach ($results as $result) {
function getFrameImage()
{
$eventId = dbEscape($_REQUEST['id'][0]);
$frameId = dbEscape($_REQUEST['id'][1]);
$sql = "select * from Frames where EventId = '" . $eventId . "' and FrameId = '" . $frameId . "'";
if (!($frame = dbFetchOne($sql))) {
$frame = array();
$frame['EventId'] = $eventId;
$frame['FrameId'] = $frameId;
$frame['Type'] = "Virtual";
}
$event = dbFetchOne("select * from Events where Id = '" . $frame['EventId'] . "'");
$frame['Image'] = getImageSrc($event, $frame, SCALE_BASE);
return $frame;
}
public function getLocations()
{
$results = $this->getSearchPage(true);
$results = $results['items'];
// dd($results->toArray());
$data = array();
$locations = array('type' => 1, 'userMsg' => false);
if (!empty($results)) {
foreach ($results as $result) {
if ($lat = ObjectMeta::getValue($result->id, '_field_address-location-g')) {
if ($long = ObjectMeta::getValue($result->id, '_field_address-location-k')) {
$location = array('id' => $result->id, 'geo_latitude' => $lat, 'geo_longitude' => $long, 'location' => '', 'title' => $result->title, 'name' => $result->name, 'excerpt' => $result->excerpt, 'score' => $result->score);
if ($contentImageId = ObjectMeta::getValue($result->id, '_content_image')) {
$location['content_image'] = Url('/uploads/' . getImageSrc($contentImageId, 'medium'));
} else {
$location['content_image'] = '';
}
$location['address_street'] = ObjectMeta::getValue($result->id, '_field_address-address');
$location['address_city'] = ObjectMeta::getValue($result->id, '_field_address-city');
$location['address_country'] = ObjectMeta::getValue($result->id, '_field_address-country');
$location['promoted'] = ObjectMeta::getValue($result->id, '_field_promoted');
$data[] = $location;
}
}
}
}
$options = array();
foreach ($data as &$item) {
if (isset($options[$item['geo_latitude'] . '_' . $item['geo_longitude']])) {
$options[$item['geo_latitude'] . '_' . $item['geo_longitude']] += 1;
$current = $options[$item['geo_latitude'] . '_' . $item['geo_longitude']] - 1;
$lat = substr($item['geo_latitude'], -3);
if ($lat + $current * 10 < 1000) {
$lat = $lat + $current * 10;
$subLat = substr($item['geo_latitude'], 0, strlen($item['geo_latitude']) - 3);
$item['geo_latitude'] = $subLat . $lat;
} else {
$lat = substr($item['geo_latitude'], -4);
$lat = $lat + $current * 10;
$subLat = substr($item['geo_latitude'], 0, strlen($item['geo_latitude']) - 4);
$item['geo_latitude'] = $subLat . $lat;
}
} else {
$options[$item['geo_latitude'] . '_' . $item['geo_longitude']] = 1;
}
}
$locations['data'] = $data;
return $locations;
//return view('partials.map', compact( 'locations' ));
}
public function getCategories($id = null)
{
//Config::set('laravel-debugbar::config.enabled', false);
$this->fetchCategories();
foreach ($this->items as $category) {
if ($contentImageId = ObjectMeta::getValue($category->id, '_content_image')) {
if ($contentImageUrl = getImageSrc($contentImageId)) {
// if ($contentImageUrl = getImageSrc($contentImageId, 'medium') ) {
$category['contentImageUrl'] = 'cropped/' . getTheImageSize($contentImageUrl, '_content_image');
// $category['contentImageUrl'] = $contentImageUrl;
}
}
if ($featuredImageId = ObjectMeta::getValue($category->id, '_featured_image')) {
if ($featuredImageUrl = getImageSrc($featuredImageId)) {
// if ($featuredImageUrl = getImageSrc($featuredImageId, 'small')) {
$category['featuredImageUrl'] = 'cropped/' . getTheImageSize($featuredImageUrl, '_featured_image');
// $category['featuredImageUrl'] = $featuredImageUrl;
}
}
}
$this->itemsParents[0] = [];
$categories = $this->itemArray();
$this->items2 = $this->items->getDictionary();
/*
$time11 = microtime(true);
foreach($this->items2 as $k => &$v)
{
if($v->items_count)
continue;
$objects = Object::whereNotIn('objects.type', ['object_type', 'image','category'])
->join('objects as obj', function ($join){
$join->on('obj.name', '=', DB::raw("concat( '_object_type_', objects.type )"));
})
->join('object_meta', function ($join){
$join->on('object_meta.object_id', '=', 'obj.id')
->where('object_meta.meta_key', '=', '_category_id');
})
->join('objects as cat', function ($join){
$join->on('cat.id', '=', 'object_meta.meta_value');
})
->where('object_meta.meta_value', $k)
->select('objects.id', 'objects.name')
->limit(2)
;
if($objects->count() != 1)
continue;
$v->url = $objects->first()->toArray();
}
$time22 = microtime(true);
*/
$categories2 = $this->itemArray2();
$this->itemsParents2[0] = [];
$breadCrumbs = [];
$breadCrumbs[0] = [];
foreach ($this->itemsParents as $itemID => $arr) {
foreach ($arr as $subK) {
$subItem = $this->items->getDictionary()[$subK];
$breadCrumbs[$itemID][] = ['id' => $subK, 'title' => $subItem->title, 'url' => $subItem->name, 'hasItems' => (bool) $subItem->items_count];
}
}
$currentItem = !$id ? false : ['id' => $id, 'title' => $this->items->getDictionary()[$id]['title'], 'contentImageUrl' => $this->items->getDictionary()[$id]['contentImageUrl'], 'featuredImageUrl' => $this->items->getDictionary()[$id]['featuredImageUrl']];
// echo "script execution time: ".($time22-$time11); //value in seconds
return response()->json(['categories' => $categories2, 'parents' => $this->itemsParents, 'breadcrumbs' => $breadCrumbs, 'currentItem' => $currentItem]);
}
</div>
<div id="content">
<?php
if ($pagination) {
?>
<h3 class="pagination"><?php
echo $pagination;
?>
</h3>
<?php
}
?>
<div id="eventFrames">
<?php
foreach ($frames as $frame) {
$imageData = getImageSrc($event, $frame, $scale);
?>
<a href="?view=frame&eid=<?php
echo $_REQUEST['eid'];
?>
&fid=<?php
echo $frame['FrameId'];
?>
"><img src="<?php
echo viewImagePath($imageData['thumbPath']);
?>
" class="<?php
echo $imageData['imageClass'];
?>
" alt="<?php
echo $frame['Type'];
function createListThumbnail($event, $overwrite = false)
{
if (!($frame = dbFetchOne("SELECT * FROM Frames WHERE EventId=? AND Score=? ORDER BY FrameId LIMIT 1", NULL, array($event['Id'], $event['MaxScore'])))) {
return false;
}
$frameId = $frame['FrameId'];
if (ZM_WEB_LIST_THUMB_WIDTH) {
$thumbWidth = ZM_WEB_LIST_THUMB_WIDTH;
$scale = SCALE_BASE * ZM_WEB_LIST_THUMB_WIDTH / $event['Width'];
$thumbHeight = reScale($event['Height'], $scale);
} elseif (ZM_WEB_LIST_THUMB_HEIGHT) {
$thumbHeight = ZM_WEB_LIST_THUMB_HEIGHT;
$scale = SCALE_BASE * ZM_WEB_LIST_THUMB_HEIGHT / $event['Height'];
$thumbWidth = reScale($event['Width'], $scale);
} else {
Fatal("No thumbnail width or height specified, please check in Options->Web");
}
$imageData = getImageSrc($event, $frame, $scale, false, $overwrite);
$thumbData = $frame;
$thumbData['Path'] = $imageData['thumbPath'];
$thumbData['Width'] = (int) $thumbWidth;
$thumbData['Height'] = (int) $thumbHeight;
return $thumbData;
}
function getImageTag($imageId, $size)
{
if ($imageSrc = getImageSrc($imageId, $size)) {
return sprintf('<img src="%s" alt="" title="" />', URL::to('/public/' . $imageSrc));
}
}
public function getLocations()
{
$results = $this->getSearch();
$data = array();
$locations = array('type' => 1, 'userMsg' => false);
if (!empty($results)) {
foreach ($results as $result) {
if ($lat = ObjectMeta::getValue($result->id, '_field_address-location-g')) {
if ($long = ObjectMeta::getValue($result->id, '_field_address-location-k')) {
$location = array('geo_latitude' => $lat, 'geo_longitude' => $long, 'location' => '', 'title' => $result->title, 'excerpt' => $result->excerpt);
if ($contentImageId = ObjectMeta::getValue($result->id, '_content_image')) {
$location['content_image'] = Url('/uploads/' . getImageSrc($contentImageId, 'medium'));
} else {
$location['content_image'] = '';
}
$location['address_street'] = ObjectMeta::getValue($result->id, '_field_address-address');
$location['address_city'] = ObjectMeta::getValue($result->id, '_field_address-city');
$location['address_country'] = ObjectMeta::getValue($result->id, '_field_address-country');
$location['promoted'] = ObjectMeta::getValue($result->id, '_field_promoted');
$data[] = $location;
}
}
}
}
$locations['data'] = $data;
return $locations;
//return view('partials.map', compact( 'locations' ));
}
