diff options
Diffstat (limited to 'admin/survey/modules/mod_geoIP/class.SurveyGeoIP.php')
| -rw-r--r-- | admin/survey/modules/mod_geoIP/class.SurveyGeoIP.php | 276 |
1 files changed, 276 insertions, 0 deletions
diff --git a/admin/survey/modules/mod_geoIP/class.SurveyGeoIP.php b/admin/survey/modules/mod_geoIP/class.SurveyGeoIP.php new file mode 100644 index 0000000..a8942f7 --- /dev/null +++ b/admin/survey/modules/mod_geoIP/class.SurveyGeoIP.php @@ -0,0 +1,276 @@ +<?php
+
+/*
+ * Modul za dolocanje lokacije na podlagi IP-ja
+ *
+ * Po novem se uporablja GeoIP2 z GeoLiteCity knjiznico
+ *
+ */
+
+
+use GeoIp2\Database\Reader;
+
+class SurveyGeoIP{
+
+ var $anketa; # id ankete
+ var $data = array(); # tabela z ip analizo lokacij
+
+ var $countryDB = false;
+ var $countriesLocationsData = array();
+
+
+ function __construct($anketa){
+ global $site_url;
+
+ // Ce imamo anketo
+ if ((int)$anketa > 0){
+ $this->anketa = $anketa;
+ }
+
+ // Check if we have data for countries
+ $sql = sisplet_query("SELECT COUNT(*) AS cnt FROM countries_locations", 'obj');
+ if($sql->cnt > 0){
+ $this->countryDB = true;
+ }
+ }
+
+
+ public function displayData(){
+ global $lang;
+
+ // Zakesiramo podatke o lokacijah
+ $this->calculateLocations();
+ //var_dump($this->data);
+
+
+ // Opozorilo o nenatancnosti
+ echo '<p class="bold">'.$lang['srv_geoip_warning'].'</p>';
+
+
+ echo '<div>';
+ echo '<div class="floatLeft">';
+
+ // Izpis tabele frekvenc
+ echo '<table class="geoip_table">';
+
+ // Prva vrstica
+ echo '<tr>';
+ echo '<th>'.$lang['srv_geoip_country'].'</th>';
+ echo '<th>'.$lang['srv_geoip_city'].'</th>';
+ echo '<th>'.$lang['srv_geoip_freq'].'</th>';
+ echo '<th>%</th>';
+ echo '</tr>';
+
+ // Vrstice s podatki
+ if(isset($this->data['all'])){
+
+ foreach($this->data['all'] as $country => $country_freq){
+
+ if($country !== 'all'){
+
+ // Frekvenca po drzavi
+ $country_percent = ($this->data['freq'] > 0) ? round($country_freq['freq'] / $this->data['freq'], 3) * 100 : 0;
+
+ echo '<tr class="country">';
+ echo '<td>'.($country == '' ? '<i>'.$lang['srv_geoip_unknown'].'<i>' : mb_convert_encoding($country, "UTF-8", "ISO-8859-1")).'</td>';
+ $cities = mb_convert_encoding($this->data['all'][$country]['cities'], "UTF-8", "ISO-8859-1");
+ echo '<td>'.(isset($country_freq['showMap']) ? '<a class="fMap rawData" title="'.$lang['srv_view_data_on_map'].'" href="javascript:void(0);" onclick=\'passMapDataRaw('.json_encode($cities).');\'><img src="img_0/Google_Maps_Icon.png" height="24" width="24" /></a></td>' : '');
+ echo '<td>'.$country_freq['freq'].'</td>';
+ echo '<td>'.$country_percent.' %</td>';
+ echo '</tr>';
+
+ // Se frekvence po mestih
+ foreach($this->data['all'][$country]['cities'] as $city => $city_data){
+
+ $city_percent = ($this->data['freq'] > 0) ? round($city_data['cnt'] / $this->data['freq'], 3) * 100 : 0;
+
+ echo '<tr class="city">';
+ echo '<td></td>';
+ echo '<td>'.($city == '' ? '<i>'.$lang['srv_geoip_unknown'].'<i>' : mb_convert_encoding($city, "UTF-8", "ISO-8859-1")).'</td>';
+ echo '<td>'.$city_data['cnt'].'</td>';
+ echo '<td>'.$city_percent.' %</td>';
+ echo '</tr>';
+ }
+ }
+ }
+ }
+
+ // Zadnja vrstica
+ echo '<tr class="country">';
+ echo '<td>'.$lang['hour_total'].'</td>';
+ echo '<td></td>';
+ echo '<td>'.$this->data['freq'].'</td>';
+ echo '<td>100%</td>';
+ echo '</tr>';
+ echo '</table>';
+
+ echo '</div>';
+
+ // Google maps on right of table
+ if(count($this->countriesLocationsData)>0){
+
+ echo '<div class="floatLeft" style="margin: 15px 0px 0px 50px;">';
+
+ if(count($this->countriesLocationsData) > 1)
+ $this->displayNavigationMaps();
+
+ echo '<div id="map_ip" style="width: 800px; height:500px;border-style: solid;border-width: 1px;border-color: #b4b3b3;"></div>';
+
+ echo '</div>';
+
+ $cities = mb_convert_encoding($this->data['all']['all']['cities'], "UTF-8", "ISO-8859-1");
+
+ echo '<script type="text/javascript">passMapDataRaw('.json_encode($cities).');googleMapsAPIProcedura(initializeMapGeneralForIPs);</script>';
+ }
+ echo '</div>';
+ }
+
+
+ // Loop cez response in zackesiramo ip-je in lokacije
+ private function calculateLocations(){
+ global $site_path;
+ global $lang;
+
+ // Inicializiramo reader s knjiznico ip lokacij
+ $reader = new Reader($site_path.'admin/survey/modules/mod_geoIP/db/GeoLite2-City.mmdb');
+ //$reader = new Reader($site_path.'admin/survey/modules/mod_geoIP/db/GeoLite2-Country.mmdb');
+
+
+ $sql = sisplet_query("SELECT ip, preview, testdata, last_status, lurker
+ FROM srv_user
+ WHERE ank_id='".$this->anketa."' AND testdata='0' AND preview='0' AND deleted='0'
+ ");
+ while($row = mysqli_fetch_array($sql)){
+
+ // Ce locimo glede na status
+ //$index = $row['last_status'].'_'.$row['lurker'];
+ $index = 'all';
+
+ // Poskusimo ustvariti objekt z lokacijo za IP
+ $unknown_location = false;
+ try {
+ $location_object = $reader->city($row['ip']);
+ }
+ catch (Exception $e) {
+ //echo 'Error: ', $e->getMessage();
+ $unknown_location = true;
+ }
+
+ // Ce ni ip-ja v bazi gre za neznano lokacijo
+ if($unknown_location){
+ $location_data['country_name'] = $lang['srv_unknown'];
+ $location_data['country_code'] = '';
+ $location_data['city'] = $lang['srv_unknown'];
+ $location_data['longitude'] = '';
+ $location_data['latitude'] = '';
+ }
+ // Drugace preberemo iz knjiznice podatke o lokaciji
+ else{
+ $location_data['country_name'] = $location_object->country->name;
+ $location_data['country_code'] = $location_object->country->isoCode;
+ $location_data['city'] = $location_object->city->name;
+ $location_data['longitude'] = $location_object->location->longitude;
+ $location_data['latitude'] = $location_object->location->latitude;
+ }
+
+ // Frekvence po drzavah
+ if(isset($this->data[$index][$location_data['country_name']]['freq'])){
+
+ $this->data[$index][$location_data['country_name']]['freq']++;
+
+ if($location_data['country_name']!='')
+ $this->countriesLocationsData[$location_data['country_name']]['cnt']++;
+ }
+ else{
+ $this->data[$index][$location_data['country_name']]['freq'] = 1;
+
+ //store coordinates for country
+ if($this->countryDB && $location_data['country_name'] != '' && $location_data['country_name'] != $lang['srv_unknown']){
+
+ $sqlc = sisplet_query("SELECT latitude, longitude FROM countries_locations WHERE country_code='".$location_data['country_code']."'", 'obj');
+
+ $this->countriesLocationsData[$location_data['country_name']]['cnt'] = 1;
+ $this->countriesLocationsData[$location_data['country_name']]['lat'] = $sqlc->latitude;
+ $this->countriesLocationsData[$location_data['country_name']]['lng'] = $sqlc->longitude;
+ }
+ }
+
+ // Frekvence po mestih
+ if(isset($this->data[$index][$location_data['country_name']]['cities'][$location_data['city']])){
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']]['cnt']++;
+ $this->data[$index]['all']['cities'][$location_data['city']]['cnt']++;
+ }
+ else{
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']]['cnt'] = 1;
+ $this->data[$index]['all']['cities'][$location_data['city']]['cnt'] = 1;
+
+ if($location_data['city'] != '' && $location_data['city'] != $lang['srv_unknown']){
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']]['lat'] = floatval($location_data['latitude']);
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']]['lng'] = floatval($location_data['longitude']);
+ $this->data[$index]['all']['cities'][$location_data['city']]['lat'] = floatval($location_data['latitude']);
+ $this->data[$index]['all']['cities'][$location_data['city']]['lng'] = floatval($location_data['longitude']);
+ }
+ }
+
+ // Mesto ni znano, imamo pa koordinate
+ if($location_data['city'] == '' && isset($location_data['longitude']) && $location_data['longitude'] != '' && isset($location_data['latitude']) && $location_data['latitude'] != ''){
+
+ if(isset($this->data[$index][$location_data['country_name']]['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])])){
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['cnt']++;
+ $this->data[$index]['all']['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['cnt']++;
+ }
+ else{
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['cnt'] = 1;
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['lat'] = floatval($location_data['latitude']);
+ $this->data[$index][$location_data['country_name']]['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['lng'] = floatval($location_data['longitude']);
+ $this->data[$index]['all']['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['cnt'] = 1;
+ $this->data[$index]['all']['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['lat'] = floatval($location_data['latitude']);
+ $this->data[$index]['all']['cities'][$location_data['city']][''.floatval($location_data['latitude']).floatval($location_data['longitude'])]['lng'] = floatval($location_data['longitude']);
+ }
+ }
+
+ if(isset($location_data['latitude']) && $location_data['latitude'] != ''){
+ $this->data[$index][$location_data['country_name']]['showMap'] = 1;
+ $this->data[$index]['all']['showMap'] = 1;
+ }
+
+ // Frekvenca vseh
+ if(isset($this->data['freq']))
+ $this->data['freq']++;
+ else
+ $this->data['freq'] = 1;
+ }
+ }
+
+ function displayNavigationMaps() {
+ global $lang;
+
+ $countries = mb_convert_encoding($this->countriesLocationsData, "UTF-8", "ISO-8859-1");
+ $cities = mb_convert_encoding($this->data['all']['all']['cities'], "UTF-8", "ISO-8859-1");
+
+ echo '<div class="secondNavigation">';
+ echo '<ul class="secondNavigation">';
+
+ echo'<li>';
+ echo '<a class="no-img active" id="geoip_cities" onclick=\'geoip_map_navigation_toggle(this, '.json_encode($cities).');\'>';
+ echo '<span class="label">' . $lang['srv_geoip_map_cities'] . '</span>';
+ echo '</a>';
+ echo'</li>';
+
+ #space
+ echo'<li class="space">';
+ echo'</li>';
+
+ echo'<li>';
+ echo '<a class="no-img" id="geoip_countries" onclick=\'geoip_map_navigation_toggle(this, '.json_encode($countries).');\'>';
+ echo '<span class="label">' . $lang['srv_geoip_map_countries'] . '</span>';
+ echo '</a>';
+ echo'</li>';
+
+ echo'</ul>';
+ echo '</div>';
+
+ echo '<br class="clr" />';
+ echo '<br class="clr" />';
+ }
+}
\ No newline at end of file |