'; $order = 'ASC'; } else { return NULL; } $dateRange = NULL; if (!empty($from_date) && !empty($to_date)) { $dateRange = "(field_data_field_event_date.field_event_date_value BETWEEN '" . $from_date . "' AND '" . $to_date . "') AND "; } /*echo "SELECT node.title AS node_title, node.nid AS nid, field_data_field_event_date.field_event_date_value AS field_data_field_event_date_field_event_date_value, node.created AS node_created, 'node' AS field_data_field_event_date_node_entity_type, 'node' AS field_data_field_event_title_image_node_entity_type FROM node node LEFT JOIN field_data_field_event_date field_data_field_event_date ON node.nid = field_data_field_event_date.entity_id AND (field_data_field_event_date.entity_type = 'node' AND field_data_field_event_date.deleted = '0') WHERE node.status = '1' AND " . $dateRange . " (UNIX_TIMESTAMP(field_data_field_event_date.field_event_date_value) " . $sql_op . " UNIX_TIMESTAMP('" . $event_released_date . "')) " . "AND node.type IN ('events_and_highlights') " . "ORDER BY field_data_field_event_date_field_event_date_value " . $order . ", node_created " . $order . " LIMIT 1 OFFSET 0";*/ $result = db_query("SELECT node.title AS node_title, node.nid AS nid, field_data_field_event_date.field_event_date_value AS field_data_field_event_date_field_event_date_value, node.created AS node_created, 'node' AS field_data_field_event_date_node_entity_type, 'node' AS field_data_field_event_title_image_node_entity_type FROM node node LEFT JOIN field_data_field_event_date field_data_field_event_date ON node.nid = field_data_field_event_date.entity_id AND (field_data_field_event_date.entity_type = 'node' AND field_data_field_event_date.deleted = '0') WHERE node.status = '1' AND " . $dateRange . " (UNIX_TIMESTAMP(field_data_field_event_date.field_event_date_value) " . $sql_op . " UNIX_TIMESTAMP('" . $event_released_date . "') OR node.nid " . $sql_op . " $current_node) " . "AND node.type IN ('events_and_highlights') " . "ORDER BY field_data_field_event_date_field_event_date_value " . $order . ", node_created " . $order . " LIMIT 1 OFFSET 0")->fetchAll(); if (!isset($result[0]->nid) || !$result[0]->nid) { return NULL; } else { return $result[0]->nid; } } } $nid = isset($_GET['eid']) && !empty($_GET['eid']) ? $_GET['eid'] : ''; $from_date = isset($_GET['from_date']) && !empty($_GET['from_date']) ? $_GET['from_date'] : ''; if(!empty($from_date)){ $from_date = date("Y-m-d", strtotime($from_date)); } $to_date = isset($_GET['to_date']) && !empty($_GET['to_date']) ? $_GET['to_date'] : ''; if(!empty($to_date)){ $to_date = date("Y-m-d", strtotime($to_date)); } if (!empty($nid)) { $node = node_load($nid); $event_released_date = $node->field_event_date['und'][0]['value']; //debugArr($node); //exit; } if (!empty($node)) { $prev_id = drbatra_prev_next($nid, 'p', $event_released_date, $from_date, $to_date); $next_id = drbatra_prev_next($nid, 'n', $event_released_date, $from_date, $to_date); $photoGalleryHTML = ''; $bodycontent = $node->body['und'][0]['value']; $photoGallery = $node->field_event_gallery["und"]; if(count($photoGallery) > 0) { $photoGalleryHTML = '

'; $bodycontent = str_replace("##PHOTO_GALLERY##",$photoGalleryHTML,$bodycontent); } ?>

field_event_date['und'][0]['value'])); ?>

title; ?>


img").prop("src", "'.$base_url.'/themes/drbatra/images/prev.png"); jQuery(".owl-next > img").prop("src", "'.$base_url.'/themes/drbatra/images/next.png"); });'; drupal_add_js($js, array('type' => 'inline', 'scope' => 'footer', 'weight' => 5));

Speak To Us
TALK TO AN EXPERT
x

1st time in india

bio-engineered hair

Visible results guarantee

in 10 sessions