function getPopupUIMenu($layer_tablename, $row_id, $layer_name, $feature_title) { $menu=array(); $base_path=$GLOBALS['base_path']; if((isset($_SESSION['popup_layer_tablename']) && $_SESSION['popup_layer_tablename'] != $layer_tablename) || ((isset($_SESSION['popup_row_id']) && $_SESSION['popup_row_id'] != $row_id))) { if(isset($_SESSION['popup_menu'])) { unset($_SESSION['popup_menu']); } unset($_SESSION['popup_layer_tablename']); unset($_SESSION['popup_row_id']); } $_SESSION['popup_layer_tablename']=$layer_tablename; $_SESSION['popup_row_id']=$row_id; if(!isset($_SESSION['popup_menu']) || $_SESSION['popup_menu'] != "") { $user=$GLOBALS['user']; $menu['divId']="divPopupPane"; $menu['ulId']="ulPopupUIMenu"; /* details tab */ $details_lnk="{$base_path}ml_orchestrator.php?action=getLayerDataDetails&row_id={$row_id}&layer_tablename={$layer_tablename}&hasmenu=1"; $menu['details_id']='layerDetails'; $menu['details_lnk']=$details_lnk; $menu['details_title']='Details'; /* end details tab */ /* edit details */ if(userHasEditLayerDataPerm($layer_tablename, $row_id)) { $liID="editFeatureDetails"; $lnk="{$base_path}ml_orchestrator.php?action=getLayerTableSchema&layer_tablename={$layer_tablename}&id={$row_id}"; $title="Edit Details"; $menu['editDetails_id']=$liID; $menu['editDetails_lnk']=$lnk; $menu['editDetails_title']=$title; } /* end edit details */ /* drupal node */ $query='SELECT ' . AUTO_DBCOL_PREFIX . 'nid FROM "%s" where ' . AUTO_DBCOL_PREFIX . 'id = %d'; $result=db_query($query, $layer_tablename, $row_id); if(!$result) { } else { $obj=db_fetch_object($result); $nid=$obj-> { AUTO_DBCOL_PREFIX . 'nid' }; if($nid) { /* if drupal node is assigned, show it and comments. */ $liID="drupalNode"; $lnk="{$base_path}node/" . $nid . "/popup"; $title="More Details"; $menu['moreDetails_id']=$liID; $menu['moreDetails_lnk']=$lnk; $menu['moreDetails_title']=$title; if(node_access('update', node_load($nid))) { $liID="drupalEditDetails"; $lnk="{$base_path}node/{$nid}/edit/popup"; $title="Edit More Details"; $menu['editMoreDetails_id']=$liID; $menu['editMoreDetails_lnk']=$lnk; $menu['editMoreDetails_title']=$title; } if($user->uid) { $liID="drupalAddComments"; $lnk="{$base_path}comment/reply/$nid#comment-form"; $title="Add Comments"; $menu['addComments_id']=$liID; $menu['addComments_lnk']=$lnk; $menu['addComments_title']=$title; } } else { if($user->uid && user_access("create node_mlocate_feature")) { $liID="drupalAddMoreDetails"; $lnk="{$base_path}node/add/node-mlocate-feature/popup?layer_tablename={$layer_tablename}&point_id={$row_id}"; $title="Add More Details"; $menu['addMoreDetails_id']=$liID; $menu['addMoreDetails_lnk']=$lnk; $menu['addMoreDetails_title']=$title; } } } /* end drupal node */ /* charts */ $liID="featureCharts"; $menu['charts_id']=$liID; /* end charts */ /* media */ $columns_arr=array(); $columns_arr[]="media_columns"; $metainfo=get_values_metatable($layer_tablename, $row_id, TABLE_TYPE_LAYER, $columns_arr); $media_columns=$metainfo['media_columns']; if($media_columns != "") { $cols=explode(",", $media_columns); foreach($cols as $col) { $col=str_replace("'", "", $col); $col=trim($col); $title=strtoupper(substr($col, 0, 1)) . substr($col, 1); $lnk="{$base_path}ml_orchestrator.php?action=getMedia&id={$row_id}&layer_tablename={$layer_tablename}&media_column={$col}"; $liID='media_' . $col; $menu[$col . '_media_id']=$liID; $menu[$col . '_media_lnk']=$lnk; $menu[$col . '_media_title']=$title; } } /* end media */ /* link tables info */ $link_tablenames=getLinkTableNames($layer_tablename); $i=1; foreach($link_tablenames as $link) { $tablename=$link['tablename']; $liID="linkedData_{$i}"; $title=$link['name']; if($title == "") { $title="Linked Data {$i}"; } $lnk="{$base_path}ml_orchestrator.php?action=getLinkTableEntries&layerdata_id={$row_id}&layer_tablename={$layer_tablename}&link_tablename={$tablename}"; $arr_linktable[$title . '_liId']=$liID; $arr_linktable[$title . '_lnk']=$lnk; $arr_linktable[$title . '_title']=$title; $i++; } if(sizeof($link_tablenames) != 0) { $menu['linktable']=$link_tablenames; } else { $menu['linktable']=""; } /* end link tables info */ $_SESSION['popup_menu']=$menu; } else { $menu=$_SESSION['popup_menu']; } return $menu; }
function getFeatureInfo($xmlDoc, &$rootNode, $paramsNode) { $layer_tablename = $paramsNode->getElementsByTagName('layer_tablename')->item(0)->nodeValue; $row_id = $paramsNode->getElementsByTagName('row_id')->item(0)->nodeValue; if(($layer_tablename == null || $layer_tablename == '') || ($row_id == null || $row_id == '')) { setError($xmlDoc, $rootNode, "Required parameters not set."); return; } else { $col_db_info = getDBColDesc($layer_tablename); $columns_arr = array(); $columns_arr[] = 'layer_name'; $columns_arr[] = 'layer_type'; $columns_arr[] = 'title_column'; $columns_arr[] = 'license'; $columns_arr[] = 'attribution'; $columns_arr[] = 'summary_columns'; $columns_arr[] = 'media_columns'; $columns_arr[] = 'video_columns'; $columns_arr[] = 'nid'; $metainfo = get_values_metatable($layer_tablename, $layer_id, TABLE_TYPE_LAYER, $columns_arr); $layer_name = $metainfo['layer_name']; $layer_title_column = str_replace("'", "", $metainfo['title_column']); $layer_license = $metainfo['license']; $layer_attribution = $metainfo['attribution']; $summary_columns_arr = explode(",", str_replace("'", "", $metainfo['summary_columns'])); $media_columns = $metainfo['media_columns']; $media_columns_arr = array(); if($media_columns != NULL && $media_columns != '') { $media_columns_arr = explode(",", str_replace("'", "", $metainfo['media_columns'])); } $video_columns_arr = array(); $video_columns = $metainfo['video_columns']; if($video_columns != NULL && $video_columns != '') { $video_columns_arr = explode(",", str_replace("'", "", $metainfo['video_columns'])); } $lyr_nid = $metainfo['nid']; $attribs_res = array(); $images = array(); $videos = array(); $title = ""; $created_by = ""; $created_date = ""; $modified_by = ""; $modified_date = ""; $validated_by = ""; $validated_date = ""; $validated = ""; $attribution = ""; $nid = 0; $teaser = ""; $query = 'select * from "%s" where '.AUTO_DBCOL_PREFIX.'id = %d;'; $result = db_query($query, array($layer_tablename, $row_id)); if (!$result) { setError($xmlDoc, $rootNode, "Error fetching information."); } else { if ($arr = db_fetch_array($result)) { $base_path = base_path(); foreach ($arr as $key => $val) { if($key == $layer_title_column) { $title = $val; } if(in_array($key, $media_columns_arr)) { if($val != NULL) { $arr = explode(",", $val); $label = $col_db_info[$key] == '' ? $key : $col_db_info[$key]; foreach($arr as $v) { $images[] = array('value' => $base_path.'sites/default/files/images/'.$layer_tablename.'/'.$v, 'label' => $label . ': ' . $v); } } } if(in_array($key, $video_columns_arr)) { if($val != NULL) { $arr = explode(",", $val); $label = $col_db_info[$key] == '' ? $key : $col_db_info[$key]; foreach($arr as $v) { $videos[] = array('value' => $base_path.'sites/default/files/videos/'.$layer_tablename.'/'.$v, 'label' => $label . ': ' . $v); } } } switch($key) { case AUTO_DBCOL_PREFIX.'created_by': if($val) { $created_by = getUserName($val); } break; case AUTO_DBCOL_PREFIX.'created_date': $created_date = $val; break; case AUTO_DBCOL_PREFIX.'modified_by': if($val) { $modified_by = getUserName($val); } break; case AUTO_DBCOL_PREFIX.'modified_date': $modified_date = $val; break; case AUTO_DBCOL_PREFIX.'validated_by': if($val) { $validated_by = getUserName($val); } break; case AUTO_DBCOL_PREFIX.'validated_date': $validated_date = $val; break; case AUTO_DBCOL_PREFIX.'status': $validated = $val; break; case AUTO_DBCOL_PREFIX.'attribution': $attribution = $val; break; case AUTO_DBCOL_PREFIX.'nid': $nid = $val; break; case AUTO_DBCOL_PREFIX.'id': case AUTO_DBCOL_PREFIX.'layer_id': case AUTO_DBCOL_PREFIX.'topology': break; default: if(count($summary_columns_arr) > 0) { if(!in_array($key, $media_columns_arr) && !in_array($key, $video_columns_arr)) { $attribs_res[$key] = array('key' => $key, 'value' => $val, 'label' => ($col_db_info[$key] == '' ? $key : $col_db_info[$key]), 'summary_column' => (in_array($key, $summary_columns_arr) == true) ? '1' : '0'); } } else { if(!in_array($key, $media_columns_arr) && !in_array($key, $video_columns_arr)) { $attribs_res[$key] = array('key' => $key, 'value' => $val, 'label' => ($col_db_info[$key] == '' ? $key : $col_db_info[$key])); } } break; } } } } setNoError($xmlDoc, $rootNode); $lyrNode = addXMLChildNode($xmlDoc, $rootNode, "layer", null, array('name' => $layer_name, 'tablename' => $layer_tablename, 'row_id' => $row_id, 'nid' => $lyr_nid)); $infoNode = addXMLChildNode($xmlDoc, $lyrNode, "info"); addXMLChildNode($xmlDoc, $infoNode, "title", $title); if($nid) { $node = node_load($nid); $ntitle = $node->title; $nbody = $node->body; $nbody .= ' <font color="#0000FF"><i><a href="'.base_path().'node/'.$nid.'" target="_blank">(more...)</a></i></font>'; addXMLChildNode($xmlDoc, $infoNode, "narrative", $nbody, array('nid' => $nid, 'title' => $ntitle)); } else { addXMLChildNode($xmlDoc, $infoNode, "narrative", null, array('nid' => $nid)); } addXMLChildNode($xmlDoc, $infoNode, "created", null, array('by' => $created_by, 'date' => $created_date)); addXMLChildNode($xmlDoc, $infoNode, "modified", null, array('by' => $modified_by, 'date' => $modified_date)); if($validated) { addXMLChildNode($xmlDoc, $infoNode, "validated", null, array('by' => $validated_by, 'date' => $validated_date)); } addXMLChildNode($xmlDoc, $infoNode, "attribution", $attribution); $license = getCCLicenseHTMLForSummary($layer_license); if($license != $layer_license){ $url = 'http://i.creativecommons.org/l/' . $license[0] . '/3.0/'; addXMLChildNode($xmlDoc, $infoNode, "license", $license[0], array('url' => $url, 'img' => $url . $license[1] . '.png')); } else { addXMLChildNode($xmlDoc, $infoNode, "license", $license); } if(userHasEditLayerDataPerm($layer_tablename, $row_id)) { addXMLChildNode($xmlDoc, $infoNode, "userHasEditLayerDataPerm", "1"); } else { addXMLChildNode($xmlDoc, $infoNode, "userHasEditLayerDataPerm", "0"); } $user = $GLOBALS['user']; if($user->uid && user_access("create node_mlocate_feature")) { addXMLChildNode($xmlDoc, $infoNode, "userHasEditDrupalNodePerm", "1"); } else { addXMLChildNode($xmlDoc, $infoNode, "userHasEditDrupalNodePerm", "0"); } $base_path = base_path(); $mediaNode = addXMLChildNode($xmlDoc, $lyrNode, "media"); if(count($media_columns_arr) > 0) { $imagesNode = addXMLChildNode($xmlDoc, $mediaNode, "images"); foreach ($images as $im) { addXMLChildNode($xmlDoc, $imagesNode, "image", null, $im); } } if(count($video_columns_arr) > 0) { $videosNode = addXMLChildNode($xmlDoc, $mediaNode, "videos"); foreach ($videos as $vd) { addXMLChildNode($xmlDoc, $videosNode, "video", null, $vd); } } $attribsNode = addXMLChildNode($xmlDoc, $lyrNode, "attribs"); foreach ($attribs_res as $attrib) { addXMLChildNode($xmlDoc, $attribsNode, "attrib", null, $attrib); } } }