function getlocations_search_load_all_locations in Get Locations 7
Same name and namespace in other branches
- 7.2 modules/getlocations_search/getlocations_search.module \getlocations_search_load_all_locations()
1 call to getlocations_search_load_all_locations()
- getlocations_search_getmap in modules/getlocations_search/getlocations_search.module
- Set up the map and use getlocations to spit it out
File
- modules/getlocations_search/getlocations_search.module, line 448
- getlocations_search.module
@author Bob Hutchinson http://drupal.org/user/52366
@copyright GNU GPL
Code
function getlocations_search_load_all_locations($search_type = 'all') {
if (!user_access('access getlocations')) {
return;
}
$getlocations_defaults = getlocations_defaults();
$permitted_entity_types = array();
if (user_access('access content') && user_access('access getlocations') && ($search_type == 'all' || $search_type == 'node')) {
$permitted_entity_types[] = 'node';
}
if (getlocations_access_user_location() && ($search_type == 'all' || $search_type == 'user')) {
$permitted_entity_types[] = 'user';
}
if (user_access('access getlocations') && ($search_type == 'all' || $search_type == 'term')) {
$permitted_entity_types[] = 'term';
}
if (user_access('access comments') && user_access('access getlocations') && ($search_type == 'all' || $search_type == 'comment')) {
$permitted_entity_types[] = 'comment';
}
$locations = array();
$module = getlocations_get_current_supported_module();
if ($module == 'getlocations_fields') {
$query = db_select('getlocations_fields', 'f');
$query
->fields('f', array(
'glid',
));
$rows = $query
->execute();
$glids = array();
foreach ($rows as $row) {
$glids[$row->glid] = $row->glid;
}
$ct = 0;
foreach ($glids as $glid) {
$locations[$ct] = getlocations_load_location($glid);
$ct++;
}
}
elseif ($module == 'location_cck') {
$query = db_select('location', 'f');
$query
->fields('f', array(
'lid',
));
$rows = $query
->execute();
$lids = array();
foreach ($rows as $row) {
$lids[$row->lid] = $row->lid;
}
$ct = 0;
foreach ($lids as $lid) {
$locations[$ct] = getlocations_load_location($lid);
$sql = "SELECT nid, uid FROM {location_instance} WHERE lid = :lid";
$sqlarr = array(
':lid' => $lid,
);
$result = db_query($sql, $sqlarr);
foreach ($result as $row) {
$locations[$ct]['nid'] = $row->nid;
$locations[$ct]['uid'] = $row->uid;
if ($row->nid > 0) {
$entity_type = 'node';
$locations[$ct]['marker'] = $getlocations_defaults['node_map_marker'];
}
elseif ($row->uid > 0) {
$entity_type = 'user';
$locations[$ct]['marker'] = $getlocations_defaults['user_map_marker'];
}
$locations[$ct]['type'] = $entity_type;
}
$ct++;
}
}
elseif ($module == 'geofield') {
$gtype = 'geofield';
$entity_type = '';
$fieldnames = getlocations_other_get_fieldname($gtype, $module, $entity_type);
if (!empty($fieldnames)) {
$tabledata = array();
$ct = 0;
foreach ($fieldnames as $fieldname) {
$tabledata[$ct]['table'] = 'field_data_' . $fieldname;
$tabledata[$ct]['fieldname_latitude'] = $fieldname . '_lat';
$tabledata[$ct]['fieldname_longitude'] = $fieldname . '_lon';
$ct++;
}
}
}
elseif ($module == 'geolocation') {
$gtype = 'geolocation_latlng';
$entity_type = '';
$fieldnames = getlocations_other_get_fieldname($gtype, $module, $entity_type);
if (!empty($fieldnames)) {
$tabledata = array();
$ct = 0;
foreach ($fieldnames as $fieldname) {
$tabledata[$ct]['table'] = 'field_data_' . $fieldname;
$tabledata[$ct]['fieldname_latitude'] = $fieldname . '_lat';
$tabledata[$ct]['fieldname_longitude'] = $fieldname . '_lng';
$ct++;
}
}
}
if (($module == 'geolocation' || $module == 'geofield') && !empty($fieldnames)) {
$location_ct = 0;
foreach ($tabledata as $data) {
$table = $data['table'];
$latfield = 'g.' . $data['fieldname_latitude'];
$lonfield = 'g.' . $data['fieldname_longitude'];
$fields = array();
$fields[] = "{$latfield} AS latitude";
$fields[] = "{$lonfield} AS longitude";
$fields[] = "g.entity_type AS entity_type";
$fields[] = "g.entity_id AS entity_id";
$selects = implode(",", $fields);
$sql = "SELECT {$selects} FROM {$table} g";
$sql .= " WHERE {$latfield} != '0' AND {$lonfield} != '0'";
$result = db_query($sql);
foreach ($result as $row) {
$locations[$location_ct]['latitude'] = $row->latitude;
$locations[$location_ct]['longitude'] = $row->longitude;
if ($row->entity_type == 'node') {
$locations[$location_ct]['nid'] = $row->entity_id;
$locations[$location_ct]['type'] = $row->entity_type;
$locations[$location_ct]['marker'] = $getlocations_defaults['node_map_marker'];
$t = getlocations_get_nodetype($locations[$location_ct]['nid']);
if ($t) {
$typemarkers = getlocations_get_markertypes('node');
if (isset($typemarkers[$t]) && $typemarkers[$t]) {
$locations[$location_ct]['marker'] = $typemarkers[$t];
}
}
$locations[$location_ct]['marker'] = getlocations_get_term_marker($row->entity_id, $locations[$location_ct]['marker']);
$n = node_load($locations[$location_ct]['nid']);
$locations[$location_ct]['title'] = $n->title;
if ($n->status == 0 || !in_array('node', $permitted_entity_types)) {
unset($locations[$location_ct]);
}
}
elseif ($row->entity_type == 'user') {
$locations[$location_ct]['uid'] = $row->entity_id;
$locations[$location_ct]['type'] = $row->entity_type;
$locations[$location_ct]['marker'] = $getlocations_defaults['user_map_marker'];
$u = user_load($locations[$location_ct]['uid']);
$locations[$location_ct]['title'] = $u->name;
if ($u->status == 0 || !in_array('user', $permitted_entity_types)) {
unset($locations[$location_ct]);
}
}
elseif ($row->entity_type == 'term') {
$locations[$location_ct]['tid'] = $row->entity_id;
$locations[$location_ct]['type'] = $row->entity_type;
$locations[$location_ct]['marker'] = $getlocations_defaults['vocabulary_map_marker'];
}
elseif ($row->entity_type == 'comment') {
$locations[$location_ct]['cid'] = $row->entity_id;
$locations[$location_ct]['type'] = $row->entity_type;
$locations[$location_ct]['marker'] = $getlocations_defaults['comment_map_marker'];
$comment = comment_load($locations[$location_ct]['cid']);
if ($comment->status == 0 || !in_array('comment', $permitted_entity_types)) {
unset($locations[$location_ct]);
}
}
if (isset($locations[$location_ct]) && empty($locations[$location_ct]['marker'])) {
$locations[$location_ct]['marker'] = $getlocations_defaults['node_map_marker'];
}
$location_ct++;
}
}
}
if (($module == 'getlocations_fields' || $module == 'location_cck') && !empty($locations)) {
foreach ($locations as $ct => $val) {
if ($locations[$ct]['type'] == 'node') {
$n = node_load($locations[$ct]['nid']);
$locations[$ct]['title'] = htmlspecialchars_decode($locations[$ct]['name'] ? strip_tags($locations[$ct]['name']) : strip_tags($n->title), ENT_QUOTES);
if ($n->status == 0 || !in_array('node', $permitted_entity_types)) {
unset($locations[$ct]);
}
}
elseif ($locations[$ct]['type'] == 'user') {
$u = user_load($locations[$ct]['uid']);
$locations[$ct]['title'] = htmlspecialchars_decode($locations[$ct]['name'] ? strip_tags($locations[$ct]['name']) : strip_tags($u->name), ENT_QUOTES);
if ($u->status == 0 || !in_array('user', $permitted_entity_types)) {
unset($locations[$ct]);
}
}
elseif ($locations[$ct]['type'] == 'term') {
if (!in_array('term', $permitted_entity_types)) {
unset($locations[$ct]);
}
}
elseif ($locations[$ct]['type'] == 'comment') {
$c = comment_load($locations[$ct]['cid']);
$locations[$ct]['title'] = htmlspecialchars_decode($locations[$ct]['name'] ? strip_tags($locations[$ct]['name']) : strip_tags($c->subject), ENT_QUOTES);
if ($c->status == 0 || !in_array('comment', $permitted_entity_types)) {
unset($locations[$ct]);
}
}
}
}
return $locations;
}
