コード例 #1
0
ファイル: MapController.php プロジェクト: kyfr59/cg35
 public function browseAction()
 {
     $table = $this->_helper->db->getTable();
     $locationTable = $this->_helper->db->getTable('Location');
     $params = $this->getAllParams();
     $params['only_map_items'] = false;
     $limit = (int) get_option('geolocation_per_page');
     $currentPage = $this->getParam('page', 1);
     // Only get pagination data for the "normal" page, only get
     // item/location data for the KML output.
     if ($this->_helper->contextSwitch->getCurrentContext() == 'kml') {
         $allItems = $table->findBy($params);
         $items = $table->findBy($params, $limit, $currentPage);
         $this->view->items = $items;
         $this->view->locations = $locationTable->findLocationByItemPublishers($items);
         _logFile(count($this->view->locations));
     } else {
         $this->view->totalItems = $table->count($params);
         $this->view->params = $params;
         $pagination = array('page' => $currentPage, 'per_page' => $limit, 'total_results' => $this->view->totalItems);
         Zend_Registry::set('pagination', $pagination);
     }
 }
コード例 #2
0
ファイル: browse.kml.php プロジェクト: kyfr59/cg35
        <?php 
/* Here is the styling for the balloon that appears on the map */
?>
        <Style id="item-info-balloon">
            <BalloonStyle>
                <text><![CDATA[
                    <div class="geolocation_balloon">
                        <div class="geolocation_balloon_title">$[namewithlink]</div>
                        <p class="geolocation_balloon_description">$[Snippet]</p>
                    </div>
                ]]></text>
            </BalloonStyle>
        </Style>
        <?php 
foreach ($locations as $location) {
    _logFile($location['nb']);
    ?>
        <Placemark>
            <name><![CDATA[<?php 
    echo $location['text'];
    ?>
]]></name>
            <namewithlink><![CDATA[<?php 
    echo $location['nb'];
    ?>
]]></namewithlink>
            <items><![CDATA[<?php 
    echo $location['items'];
    ?>
]]></items>
            <Point>
コード例 #3
0
ファイル: Location.php プロジェクト: kyfr59/cg35
 /**
  * Returns a location (or array of locations) for an item (or array of items)
  * @param array|Item|int $item An item or item id, or an array of items or item ids
  * @param boolean $findOnlyOne Whether or not to return only one location if it exists for the item
  * @return array|Location A location or an array of locations
  **/
 public function findLocationByItemPublishers($item, $findOnlyOne = false)
 {
     $db = get_db();
     if ($item instanceof Item && !$item->exists()) {
         return array();
     } else {
         if (is_array($item) && !count($item)) {
             return array();
         }
     }
     $alias = $this->getTableAlias();
     // Create a SELECT statement for the Location table
     $select = $db->select()->from(array($alias => $db->Location), array("{$alias}.*", "GROUP_CONCAT({$alias}.item_id) as items", "COUNT({$alias}.address) AS nb"));
     // Create a WHERE condition that will pull down all the location info
     if (is_array($item)) {
         $itemIds = array();
         foreach ($item as $it) {
             $itemIds[] = (int) ($it instanceof Item ? $it->id : $it);
         }
         $select->where("{$alias}.item_id IN (?)", $itemIds);
     } else {
         $itemId = (int) ($item instanceof Item ? $item->id : $item);
         $select->where("{$alias}.item_id = ?", $itemId);
     }
     // If only a single location is request, return the first one found.
     if ($findOnlyOne) {
         $location = $this->fetchObject($select);
         return $location;
     }
     $select->joinLeft(array('element_texts' => 'omeka_element_texts'), "{$alias}.item_id = element_texts.record_id AND element_texts.element_id = 45", array('element_texts.text'));
     $select->group('address');
     // Get the locations.
     $locations = $this->fetchObjects($select);
     // Return an associative array of locations where the key is the item_id of the location
     // Note: Since each item can only have one location, this makes sense to associate a single location with a single item_id.
     // However, if in the future, an item can have multiple locations, then we cannot just associate a single location with a single item_id;
     // Instead, in the future, we would have to associate an array of locations with a single item_id.
     $indexedLocations = array();
     foreach ($locations as $k => $loc) {
         $indexedLocations[$loc['item_id']] = $loc;
     }
     _logFile($select);
     return $indexedLocations;
 }