How to use getColumn method of Location class

...74		if(1 == $row->getRowIndex ()) continue;//skip first row75		$rowIndex = $row->getRowIndex();76		$array_data[$rowIndex] = array('A'=>'','B'=>'','C'=>'','D'=>'','E'=>'','F'=>'','G'=>'','H'=>'','I'=>'','J'=>'','K'=>'','L'=>'','N'=>'','O'=>'','P'=>'');77		foreach ($cellIterator as $cell) {78			if('A' == $cell->getColumn()){79				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();80			} else if('B' == $cell->getColumn()){81				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();82			} else if('C' == $cell->getColumn()){83				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();84			}else if('D' == $cell->getColumn()){85				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();86			}else if('E' == $cell->getColumn()){87				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();88			}else if('F' == $cell->getColumn()){89				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();90			}else if('G' == $cell->getColumn()){91				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();92			}else if('H' == $cell->getColumn()){93				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();94			}else if('I' == $cell->getColumn()){95				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();96			}else if('J' == $cell->getColumn()){97				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();98			}else if('K' == $cell->getColumn()){99				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();100			}else if('L' == $cell->getColumn()){101				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();102			}else if('M' == $cell->getColumn()){103				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();104			}else if('N' == $cell->getColumn()){105				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();106			}else if('O' == $cell->getColumn()){107				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();108			}else if('P' == $cell->getColumn()){109				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();110			}111			112		}113	}114	$user = $array_data;115	$def=2;116	$entrysaved=0;117	$query = "update file_info set name='".clean($filename)."',date='$xdate' where id='".$fileid."'";118	if($result = mysql_query($query))119	{120		$entryid = $fileid;121		$totalentries = sizeof($user)-$def;122		for($i=$def;$i<(sizeof($user)+$def);$i++)123		{124			$skip =false;125			$mysqldate ="";126			$coords="";127			$saddress="";128			$eaddress="";129			if(!empty($user[$i]['E']) && !empty($user[$i]['F']) && !empty($user[$i]['G']) && !empty($user[$i]['H']))130			{131				$saddress=$user[$i]['E'].", ".$user[$i]['F']." ".$user[$i]['G']." ".$user[$i]['H'];132				$cord =getGEO($saddress);133				$lat = $cord['lat'];134				$lng = $cord['lng'];135				$coords .= $lng.",".$lat.",100 ";136			}137			if(!empty($user[$i]['I']) && !empty($user[$i]['J']) && !empty($user[$i]['K']) && !empty($user[$i]['L']))138			{139				$eaddress=$user[$i]['I'].", ".$user[$i]['J']." ".$user[$i]['K']." ".$user[$i]['L'];140				$cord =getGEO($eaddress);141				$lat = $cord['lat'];142				$lng = $cord['lng'];143				$coords .= $lng.",".$lat.",100 ";144			}145			//$mysqldate = date('Y-m-d', $user[$i]["G"]);146			//$phpdate = strtotime($mysqldate);147			@$phpdate = PHPExcel_Style_NumberFormat::toFormattedString($user[$i]["A"], "YYYY-M-D");148			$found=false;149			if($user[$i]["N"]=="Column14" || $user[$i]["N"]=="" || empty($user[$i]["N"]))150				$totalg="0";151			else152				$totalg=$user[$i]["N"];153			if($user[$i]["O"]=="Column15" || $user[$i]["O"]=="" || empty($user[$i]["O"]))154				$totalp="0";155			else156				$totalp=$user[$i]["O"];157			if($user[$i]["M"]=="Column13" || $user[$i]["M"]=="" || empty($user[$i]["M"]))158				$totalgross="0";159			else160				$totalgross=$user[$i]["M"];161			if(!empty($saddress) && !empty($eaddress) && !empty($entryid) && !empty($coords) && !empty($user[$i]["B"]) && !empty($user[$i]["C"]) && !empty($phpdate) && !empty($user[$i]["D"]))162			{163				if($saddress =="Column5, Column6 Column7 Column8'" ||  $eaddress=="Column9, Column10 Column11 Column12" || $coords==",,100 ,,100"  || $user[$i]["B"]=="Column2" || $user[$i]["C"]=="COLUMN3" || $user[$i]["A"]=="Column1" || $user[$i]["D"]=="Column4")164					$skip = true;165				if(!$skip)166				{167					//if the entry is valid168					if(!empty($user[$i]["P"]))169						$query = "insert ignore into file_entries(fileid,address1,address2,coords,totalg,totalp,totalgross,agent,agent_code,date,manager,office)values('".$entryid."','".clean(ucwords(strtolower($saddress)))."','".clean(ucwords(strtolower($eaddress)))."','".$coords."','".$totalg."','".$totalp."','".$totalgross."','".ucwords(strtolower(clean($user[$i]["B"])))."','".strtoupper(clean($user[$i]["C"]))."','".$phpdate."','".clean(ucwords(strtolower($user[$i]["D"])))."','".clean($user[$i]["P"])."')";170					else171						$query = "insert ignore into file_entries(fileid,address1,address2,coords,totalg,totalp,totalgross,agent,agent_code,date,manager)values('".$entryid."','".clean(ucwords(strtolower($saddress)))."','".clean(ucwords(strtolower($eaddress)))."','".$coords."','".$totalg."','".$totalp."','".$totalgross."','".ucwords(strtolower(clean($user[$i]["B"])))."','".strtoupper(clean($user[$i]["C"]))."','".$phpdate."','".clean(ucwords(strtolower($user[$i]["D"])))."')";172					@mysql_query($query);173					$entrysaved++;174				}175			}176		}177		//echo "<br/>Total Entries: <u>$totalentries</u> Entryies Saved: <u>$entrysaved</u><br/>";178		if($entrysaved==0)179		{180			$queryx = "delete from file_info where id='".$entryid."'";181			@mysql_query($queryx);182			$_SESSION["mapresult"]="ERROR: Corrupted File, ALL Entries Deleted";183			header("location:showmap.php");184			exit;185		}186		else187		{188			if($totalentries != $entrysaved)189				$_SESSION["mapresult"]= "$entrysaved out of $totalentries Entries Saved. Invalid rows found and ignored";190			else191				$_SESSION["mapresult"]= "All Entries Saved";192		}193	}194	unset($_SESSION["fmap"]);195	unset($_SESSION["titlesearch"]);196	unset($_SESSION["prevlink"]);197	header("location:showmap.php");198	exit;199	}200}201else if($reimport =="fover")202{203	$ext = explode(".",$_FILES['fileov']['name']);204	//if import is required205	if($ext[1] != "xlsx")206	{207		$_SESSION["fmapresult"]="Invalid File Type";208		header("location:editimport.php?id=".base64_encode($fileid));209		exit;210	}211	else212	{213	//read 2003 format214	//$objPHPExcel = new PHPExcel();215	//$objReader = new PHPExcel_Reader_Excel5();216	//$objReader->setReadDataOnly(true);217	//end of read 2003 format218	//read 2007 format219	$objReader = PHPExcel_IOFactory::createReader('Excel2007');220	$objReader->setReadDataOnly(true);221	//end of read 2007 forma222	if(empty($filename))223	{224		$_SESSION["fmapresult"]="Provide A Name For File";225		header("location:editimport.php?id=".base64_encode($fileid));226		exit;227	}228	$objPHPExcel = $objReader->load($_FILES['fileov']['tmp_name']);229	//second try230	$rowIterator = $objPHPExcel->getActiveSheet()->getRowIterator();231	$array_data = array();232	foreach($rowIterator as $row){233		$cellIterator = $row->getCellIterator();234		$cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set235		if(1 == $row->getRowIndex ()) continue;//skip first row236		$rowIndex = $row->getRowIndex();237		$array_data[$rowIndex] = array('A'=>'','B'=>'','C'=>'','D'=>'','E'=>'','F'=>'','G'=>'','H'=>'','I'=>'','J'=>'','K'=>'','L'=>'','N'=>'','O'=>'','P'=>'');238		foreach ($cellIterator as $cell) {239			if('A' == $cell->getColumn()){240				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();241			} else if('B' == $cell->getColumn()){242				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();243			} else if('C' == $cell->getColumn()){244				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();245			}else if('D' == $cell->getColumn()){246				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();247			}else if('E' == $cell->getColumn()){248				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();249			}else if('F' == $cell->getColumn()){250				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();251			}else if('G' == $cell->getColumn()){252				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();253			}else if('H' == $cell->getColumn()){254				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();255			}else if('I' == $cell->getColumn()){256				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();257			}else if('J' == $cell->getColumn()){258				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();259			}else if('K' == $cell->getColumn()){260				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();261			}else if('L' == $cell->getColumn()){262				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();263			}else if('M' == $cell->getColumn()){264				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();265			}else if('N' == $cell->getColumn()){266				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();267			}else if('O' == $cell->getColumn()){268				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();269			}else if('P' == $cell->getColumn()){270				$array_data[$rowIndex][$cell->getColumn()] = $cell->getValue();271			}272			273		}274	}275	$user = $array_data;276	$def=2;277	$entrysaved=0;278	$query = "update file_info set name='".clean($filename)."',date='$xdate' where id='".$fileid."'";279	if($result = mysql_query($query))280	{281		$entryid = $fileid;282		$totalentries = sizeof($user)-$def;283		for($i=$def;$i<(sizeof($user)+$def);$i++)284		{...

...41        $this->initVisitorProfile();42        /** @var DataTable\Row $visit */43        foreach ($visits->getRows() as $visit) {44            ++$this->profile['totalVisits'];45            $this->profile['totalVisitDuration'] += $visit->getColumn('visitDuration');46            $this->profile['totalActions'] += $visit->getColumn('actions');47            $this->profile['totalGoalConversions'] += $visit->getColumn('goalConversions');48            // individual goal conversions are stored in action details49            foreach ($visit->getColumn('actionDetails') as $action) {50                $this->handleIfGoalAction($action);51                $this->handleIfEventAction($action);52                $this->handleIfDownloadAction($action);53                $this->handleIfOutlinkAction($action);54                $this->handleIfEcommerceAction($action);55                $this->handleIfSiteSearchAction($action);56                $this->handleIfPageViewAction($action);57                $this->handleIfPageGenerationTime($action);58            }59            $this->handleGeoLocation($visit);60        }61        $this->handleGeoLocationCountries();62        $this->handleGeoLocationContinents();63        $this->handleSiteSearches();64        $this->handleAveragePageGenerationTime();65        $formatter = new Formatter();66        $this->profile['totalVisitDurationPretty'] = $formatter->getPrettyTimeFromSeconds($this->profile['totalVisitDuration'], true);67        $this->handleVisitsSummary($visits);68        $this->handleAdjacentVisitorIds($visits, $visitorId, $segment);69        // use N most recent visits for last_visits70        $visits->deleteRowsOffset($numLastVisits);71        $this->profile['lastVisits'] = $visits;72        $this->profile['userId'] = $visit->getColumn('userId');73        return $this->profile;74    }75    /**76     * Returns a summary for an important visit. Used to describe the first & last visits of a visitor.77     *78     * @param DataTable\Row $visit79     * @return array80     */81    private function getVisitorProfileVisitSummary($visit)82    {83        $today = Date::today();84        $serverDate = $visit->getColumn('firstActionTimestamp');85        return array(86            'date'            => $serverDate,87            'prettyDate'      => Date::factory($serverDate)->getLocalized(Date::DATE_FORMAT_LONG),88            'daysAgo'         => (int)Date::secondsToDays($today->getTimestamp() - Date::factory($serverDate)->getTimestamp()),89            'referrerType'    => $visit->getColumn('referrerType'),90            'referralSummary' => self::getReferrerSummaryForVisit($visit),91        );92    }93    /**94     * Returns a summary for a visit's referral.95     *96     * @param DataTable\Row $visit97     * @return bool|mixed|string98     */99    public static function getReferrerSummaryForVisit($visit)100    {101        $referrerType = $visit->getColumn('referrerType');102        if ($referrerType === false103            || $referrerType == 'direct'104        ) {105            return Piwik::translate('Referrers_DirectEntry');106        }107        if ($referrerType == 'search') {108            $referrerName = $visit->getColumn('referrerName');109            $keyword = $visit->getColumn('referrerKeyword');110            if ($keyword !== false111                && $keyword != APIReferrers::getKeywordNotDefinedString()112            ) {113                $referrerName .= ' (' . $keyword . ')';114            }115            return $referrerName;116        }117        if ($referrerType == 'campaign') {118            $summary = Piwik::translate('Referrers_ColumnCampaign') . ': ' . $visit->getColumn('referrerName');119            $keyword = $visit->getColumn('referrerKeyword');120            if (!empty($keyword)) {121                $summary .= ' - ' . $keyword;122            }123            return $summary;124        }125        return $visit->getColumn('referrerName');126    }127    private function isEcommerceEnabled()128    {129        return $this->isEcommerceEnabled;130    }131    /**132     * @param $action133     */134    private function handleIfEventAction($action)135    {136        if ($action['type'] != 'event') {137            return;138        }139        $this->profile['totalEvents']++;140    }141    /**142     * @param $action143     */144    private function handleIfDownloadAction($action)145    {146        if ($action['type'] != 'download') {147            return;148        }149        $this->profile['totalDownloads']++;150    }151    /**152     * @param $action153     */154    private function handleIfOutlinkAction($action)155    {156        if ($action['type'] != 'outlink') {157            return;158        }159        $this->profile['totalOutlinks']++;160    }161    /**162     * @param $action163     */164    private function handleIfPageViewAction($action)165    {166        if ($action['type'] != 'action') {167            return;168        }169        $this->profile['totalPageViews']++;170    }171    /**172     * @param $action173     */174    private function handleIfEcommerceAction($action)175    {176        if (!$this->isEcommerceEnabled()) {177            return;178        }179        if ($action['type'] == Piwik::LABEL_ID_GOAL_IS_ECOMMERCE_ORDER) {180            ++$this->profile['totalEcommerceConversions'];181            $this->profile['totalEcommerceRevenue'] += $action['revenue'];182            $this->profile['totalEcommerceItems'] += $action['items'];183        } else if ($action['type'] == Piwik::LABEL_ID_GOAL_IS_ECOMMERCE_CART) {184            ++$this->profile['totalAbandonedCarts'];185            $this->profile['totalAbandonedCartsRevenue'] += $action['revenue'];186            $this->profile['totalAbandonedCartsItems'] += $action['items'];187        }188    }189    private function handleIfGoalAction($action)190    {191        if ($action['type'] != 'goal') {192            return;193        }194        $idGoal = $action['goalId'];195        $idGoalKey = 'idgoal=' . $idGoal;196        if (!isset($this->profile['totalConversionsByGoal'][$idGoalKey])) {197            $this->profile['totalConversionsByGoal'][$idGoalKey] = 0;198        }199        ++$this->profile['totalConversionsByGoal'][$idGoalKey];200        if (!empty($action['revenue'])) {201            if (!isset($this->profile['totalRevenueByGoal'][$idGoalKey])) {202                $this->profile['totalRevenueByGoal'][$idGoalKey] = 0;203            }204            $this->profile['totalRevenueByGoal'][$idGoalKey] += $action['revenue'];205        }206    }207    private function handleIfSiteSearchAction($action)208    {209        if (!isset($action['siteSearchKeyword'])) {210            return;211        }212        $keyword = $action['siteSearchKeyword'];213        if (!isset($this->siteSearchKeywords[$keyword])) {214            $this->siteSearchKeywords[$keyword] = 0;215            ++$this->profile['totalSearches'];216        }217        ++$this->siteSearchKeywords[$keyword];218    }219    private function handleGeoLocation(DataTable\Row $visit)220    {221        // realtime map only checks for latitude222        $hasLatitude = $visit->getColumn('latitude') !== false;223        if ($hasLatitude) {224            $this->profile['hasLatLong'] = true;225        }226        $countryCode = $visit->getColumn('countryCode');227        if (!isset($this->countries[$countryCode])) {228            $this->countries[$countryCode] = 0;229        }230        ++$this->countries[$countryCode];231        $continentCode = $visit->getColumn('continentCode');232        if (!isset($this->continents[$continentCode])) {233            $this->continents[$continentCode] = 0;234        }235        ++$this->continents[$continentCode];236        if ($countryCode && !array_key_exists($countryCode, $this->cities)) {237            $this->cities[$countryCode] = array();238        }239        $city = $visit->getColumn('city');240        if (!empty($city)) {241            $this->cities[$countryCode][] = $city;242        }243    }244    private function handleSiteSearches()245    {246        // sort by visit/action247        arsort($this->siteSearchKeywords);248        foreach ($this->siteSearchKeywords as $keyword => $searchCount) {249            $this->profile['searches'][] = array('keyword' => $keyword,250                'searches' => $searchCount);251        }252    }253    private function handleGeoLocationContinents()254    {255        // sort by visit/action256        asort($this->continents);257        foreach ($this->continents as $continentCode => $nbVisits) {258            $this->profile['continents'][] = array('continent' => $continentCode,259                'nb_visits' => $nbVisits,260                'prettyName' => \Piwik\Plugins\UserCountry\continentTranslate($continentCode));261        }262    }263    private function handleGeoLocationCountries()264    {265        // sort by visit/action266        asort($this->countries);267        // transform country/continents/search keywords into something that will look good in XML268        $this->profile['countries'] = $this->profile['continents'] = $this->profile['searches'] = array();269        foreach ($this->countries as $countryCode => $nbVisits) {270            $countryInfo = array('country' => $countryCode,271                'nb_visits' => $nbVisits,272                'flag' => \Piwik\Plugins\UserCountry\getFlagFromCode($countryCode),273                'prettyName' => \Piwik\Plugins\UserCountry\countryTranslate($countryCode));274            if (!empty($this->cities[$countryCode])) {275                $countryInfo['cities'] = array_unique($this->cities[$countryCode]);276            }277            $this->profile['countries'][] = $countryInfo;278        }279    }280    private function initVisitorProfile()281    {282        $this->profile['totalVisits'] = 0;283        $this->profile['totalVisitDuration'] = 0;284        $this->profile['totalActions'] = 0;285        $this->profile['totalEvents'] = 0;286        $this->profile['totalOutlinks'] = 0;287        $this->profile['totalDownloads'] = 0;288        $this->profile['totalSearches'] = 0;289        $this->profile['totalPageViews'] = 0;290        $this->profile['totalPageViewsWithTiming'] = 0;291        $this->profile['totalGoalConversions'] = 0;292        $this->profile['totalConversionsByGoal'] = array();293        $this->profile['hasLatLong'] = false;294        if ($this->isEcommerceEnabled()) {295            $this->profile['totalEcommerceConversions'] = 0;296            $this->profile['totalEcommerceRevenue'] = 0;297            $this->profile['totalEcommerceItems'] = 0;298            $this->profile['totalAbandonedCarts'] = 0;299            $this->profile['totalAbandonedCartsRevenue'] = 0;300            $this->profile['totalAbandonedCartsItems'] = 0;301        }302    }303    private function handleAveragePageGenerationTime()304    {305        if ($this->profile['totalPageViewsWithTiming']) {306            $this->profile['averagePageGenerationTime'] =307                round($this->pageGenerationTimeTotal / $this->profile['totalPageViewsWithTiming'], $precision = 2);308        }309    }310    private function handleIfPageGenerationTime($action)311    {312        if (isset($action['generationTime'])) {313            $this->pageGenerationTimeTotal += $action['generationTime'];314            ++$this->profile['totalPageViewsWithTiming'];315        }316    }317    /**318     * @param DataTable $visits319     * @param $visitorId320     * @param $segment321     */322    private function handleAdjacentVisitorIds(DataTable $visits, $visitorId, $segment)323    {324        // get visitor IDs that are adjacent to this one in log_visit325        // TODO: make sure order of visitor ids is not changed if a returning visitor visits while the user is326        //       looking at the popup.327        $rows = $visits->getRows();328        $latestVisitTime = reset($rows)->getColumn('lastActionDateTime');329        $model = new Model();330        $this->profile['nextVisitorId'] = $model->queryAdjacentVisitorId($this->idSite, $visitorId, $latestVisitTime, $segment, $getNext = true);331        $this->profile['previousVisitorId'] = $model->queryAdjacentVisitorId($this->idSite, $visitorId, $latestVisitTime, $segment, $getNext = false);332    }333    /**334     * @param DataTable $visits335     */336    private function handleVisitsSummary(DataTable $visits)337    {338        $rows = $visits->getRows();339        $this->profile['firstVisit'] = $this->getVisitorProfileVisitSummary(end($rows));340        $this->profile['lastVisit'] = $this->getVisitorProfileVisitSummary(reset($rows));341        $this->profile['visitsAggregated'] = count($rows);342    }...

...22    protected function doDisplay(array $context, array $blocks = [])23    {24        // line 125        echo "<strong class=\"visitor-log-datetime visitorLogTooltip\" title=\"";26        if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "visitorType"], "method") == "new")) {27            echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), ["General_NewVisitor"]), "html", null, true);28        } else {29            echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), ["Live_VisitorsLastVisit", $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "daysSinceLastVisit"], "method")]), "html", null, true);30        }31        echo "\">32    ";33        // line 234        echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "serverDatePrettyFirstAction"], "method"), "html", null, true);35        echo "36    ";37        // line 338        if (($context["isWidget"] ?? $this->getContext($context, "isWidget"))) {39            echo "<br/>";40        } else {41            echo "-";42        }43        echo " ";44        echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "serverTimePrettyFirstAction"], "method"), "html", null, true);45        echo "</strong>46";47        // line 448        if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "visitIp"], "method"))) {49            // line 550            echo "<span class=\"visitor-log-ip-location visitorLogTooltip\" title=\"";51            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "userId"], "method"))) {52                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), ["General_UserId"]), "html", null, true);53                echo ": ";54                echo call_user_func_array($this->env->getFilter('rawSafeDecoded')->getCallable(), [$this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "userId"], "method")]);55                echo "56";57            }58            // line 659            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "visitorId"], "method"))) {60                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), ["General_VisitorID"]), "html", null, true);61                echo ": ";62                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "visitorId"], "method"), "html", null, true);63                echo "64";65            }66            // line 767            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "idVisit"], "method"))) {68                // line 869                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), ["General_Visit"]), "html", null, true);70                echo " ID: ";71                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "idVisit"], "method"), "html", null, true);72                echo "73";74            }75            // line 976            if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "latitude"], "method") || $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "longitude"], "method"))) {77                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "location"], "method"), "html", null, true);78                echo "79GPS (lat/long): ";80                // line 1081                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "latitude"], "method"), "html", null, true);82                echo ",";83                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "longitude"], "method"), "html", null, true);84                echo "85";86            }87            // line 1188            if ($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "providerName"], "method")) {89                // line 1290                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), ["Provider_ColumnProvider"]), "html", null, true);91                echo ": ";92                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "providerName"], "method"), "html", null, true);93            }94            echo "\">95    IP: ";96            // line 1397            echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "visitIp"], "method"), "html", null, true);98            echo "99    <br />100    ";101            // line 15102            if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "location"], "method") != call_user_func_array($this->env->getFilter('translate')->getCallable(), ["General_Unknown"]))) {103                echo "<span><img width=\"16\" class=\"flag\" src=\"";104                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "countryFlag"], "method"), "html", null, true);105                echo "\"/>&nbsp;106    ";107                // line 16108                if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "city"], "method"))) {109                    echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "city"], "method"), "html", null, true);110                } else {111                    echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "country"], "method"), "html", null, true);112                }113                echo "</span>";114            }115            // line 17116            echo "117    ";118            // line 18119            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "userId"], "method"))) {120                echo "<br/><br/>";121                echo call_user_func_array($this->env->getFilter('rawSafeDecoded')->getCallable(), [$this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", [0 => "userId"], "method")]);122            }123            // line 19124            echo "</span>";125        }126        // line 20127        if (($context["isWidget"] ?? $this->getContext($context, "isWidget"))) {128            // line 21129            echo "    <br />130    ";131            // line 22132            echo call_user_func_array($this->env->getFunction('postEvent')->getCallable(), ["Live.renderVisitorIcons", ($context["visitInfo"] ?? $this->getContext($context, "visitInfo"))]);133            echo "134";135        }136    }137    public function getTemplateName()138    {139        return "@Live/_visitorDetails.twig";140    }141    public function isTraitable()142    {143        return false;144    }145    public function getDebugInfo()146    {147        return array (  137 => 22,  134 => 21,  132 => 20,  129 => 19,  124 => 18,  121 => 17,  113 => 16,  107 => 15,  102 => 13,  95 => 12,  93 => 11,  86 => 10,  81 => 9,  74 => 8,  72 => 7,  64 => 6,  55 => 5,  53 => 4,  43 => 3,  39 => 2,  30 => 1,);148    }149    /** @deprecated since 1.27 (to be removed in 2.0). Use getSourceContext() instead */150    public function getSource()151    {152        @trigger_error('The '.__METHOD__.' method is deprecated since version 1.27 and will be removed in 2.0. Use getSourceContext() instead.', E_USER_DEPRECATED);153        return $this->getSourceContext()->getCode();154    }155    public function getSourceContext()156    {157        return new Source("<strong class=\"visitor-log-datetime visitorLogTooltip\" title=\"{% if visitInfo.getColumn('visitorType')=='new' %}{{ 'General_NewVisitor'|translate }}{% else %}{{ 'Live_VisitorsLastVisit'|translate(visitInfo.getColumn('daysSinceLastVisit')) }}{% endif %}\">158    {{ visitInfo.getColumn('serverDatePrettyFirstAction') }}159    {% if isWidget %}<br/>{% else %}-{% endif %} {{ visitInfo.getColumn('serverTimePrettyFirstAction') }}</strong>160{% if visitInfo.getColumn('visitIp') is not empty %}161<span class=\"visitor-log-ip-location visitorLogTooltip\" title=\"{% if visitInfo.getColumn('userId') is not empty %}{{ 'General_UserId'|translate }}: {{ visitInfo.getColumn('userId')|rawSafeDecoded }}162{% endif %}{% if visitInfo.getColumn('visitorId') is not empty %}{{ 'General_VisitorID'|translate }}: {{ visitInfo.getColumn('visitorId') }}163{% endif %}{% if visitInfo.getColumn('idVisit') is not empty %}164{{ 'General_Visit'|translate }} ID: {{ visitInfo.getColumn('idVisit') }}165{% endif %}{% if visitInfo.getColumn('latitude') or visitInfo.getColumn('longitude') %}{{ visitInfo.getColumn('location') }}166GPS (lat/long): {{ visitInfo.getColumn('latitude') }},{{ visitInfo.getColumn('longitude') }}167{% endif %}{% if visitInfo.getColumn('providerName') %}168{{ 'Provider_ColumnProvider'|translate }}: {{ visitInfo.getColumn('providerName') }}{% endif %}\">169    IP: {{ visitInfo.getColumn('visitIp') }}170    <br />171    {% if visitInfo.getColumn('location') != 'General_Unknown'|translate %}<span><img width=\"16\" class=\"flag\" src=\"{{ visitInfo.getColumn('countryFlag') }}\"/>&nbsp;172    {% if visitInfo.getColumn('city') is not empty %}{{ visitInfo.getColumn('city') }}{% else %}{{ visitInfo.getColumn('country') }}{% endif %}</span>{% endif %}173    {% if visitInfo.getColumn('userId') is not empty %}<br/><br/>{{ visitInfo.getColumn('userId')|rawSafeDecoded }}{% endif %}174</span>{% endif %}175{% if isWidget %}176    <br />177    {{ postEvent('Live.renderVisitorIcons', visitInfo) }}178{% endif %}179", "@Live/_visitorDetails.twig", "/home/www/wordpress/wp-content/plugins/matomo/app/plugins/Live/templates/_visitorDetails.twig");180    }181}...

...12    protected function doDisplay(array $context, array $blocks = array())13    {14        // line 115        echo "<strong class=\"visitor-log-datetime visitorLogTooltip\" title=\"";16        if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitorType"), "method") == "new")) {17            echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_NewVisitor")), "html", null, true);18        } else {19            echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("Live_VisitorsLastVisit", $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "daysSinceLastVisit"), "method"))), "html", null, true);20        }21        echo "\">22    ";23        // line 224        echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "serverDatePrettyFirstAction"), "method"), "html", null, true);25        echo "26    ";27        // line 328        if (($context["isWidget"] ?? $this->getContext($context, "isWidget"))) {29            echo "<br/>";30        } else {31            echo "-";32        }33        echo " ";34        echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "serverTimePrettyFirstAction"), "method"), "html", null, true);35        echo "</strong>36";37        // line 438        if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitIp"), "method"))) {39            // line 540            echo "<span class=\"visitor-log-ip-location visitorLogTooltip\" title=\"";41            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method"))) {42                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_UserId")), "html", null, true);43                echo ": ";44                echo call_user_func_array($this->env->getFilter('rawSafeDecoded')->getCallable(), array($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method")));45                echo "46";47            }48            // line 649            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitorId"), "method"))) {50                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_VisitorID")), "html", null, true);51                echo ": ";52                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitorId"), "method"), "html", null, true);53                echo "54";55            }56            // line 757            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "idVisit"), "method"))) {58                // line 859                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_Visit")), "html", null, true);60                echo " ID: ";61                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "idVisit"), "method"), "html", null, true);62                echo "63";64            }65            // line 966            if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "latitude"), "method") || $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "longitude"), "method"))) {67                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "location"), "method"), "html", null, true);68                echo "69GPS (lat/long): ";70                // line 1071                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "latitude"), "method"), "html", null, true);72                echo ",";73                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "longitude"), "method"), "html", null, true);74                echo "75";76            }77            // line 1178            if ($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "providerName"), "method")) {79                // line 1280                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("Provider_ColumnProvider")), "html", null, true);81                echo ": ";82                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "providerName"), "method"), "html", null, true);83            }84            echo "\">85    IP: ";86            // line 1387            echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitIp"), "method"), "html", null, true);88            echo "89    <br />90    ";91            // line 1592            if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "location"), "method") != call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_Unknown")))) {93                echo "<span><img width=\"16\" class=\"flag\" src=\"";94                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "countryFlag"), "method"), "html", null, true);95                echo "\"/>&nbsp;96    ";97                // line 1698                if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "city"), "method"))) {99                    echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "city"), "method"), "html", null, true);100                } else {101                    echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "country"), "method"), "html", null, true);102                }103                echo "</span>";104            }105            // line 17106            echo "107    ";108            // line 18109            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method"))) {110                echo "<br/><br/>";111                echo call_user_func_array($this->env->getFilter('rawSafeDecoded')->getCallable(), array($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method")));112            }113            // line 19114            echo "</span>";115        }116        // line 20117        if (($context["isWidget"] ?? $this->getContext($context, "isWidget"))) {118            // line 21119            echo "    <br />120    ";121            // line 22122            echo call_user_func_array($this->env->getFunction('postEvent')->getCallable(), array("Live.renderVisitorIcons", ($context["visitInfo"] ?? $this->getContext($context, "visitInfo"))));123            echo "124";125        }126    }127    public function getTemplateName()128    {129        return "@Live/_visitorDetails.twig";130    }131    public function isTraitable()132    {133        return false;134    }135    public function getDebugInfo()136    {137        return array (  126 => 22,  123 => 21,  121 => 20,  118 => 19,  113 => 18,  110 => 17,  102 => 16,  96 => 15,  91 => 13,  84 => 12,  82 => 11,  75 => 10,  70 => 9,  63 => 8,  61 => 7,  53 => 6,  44 => 5,  42 => 4,  32 => 3,  28 => 2,  19 => 1,);138    }139    /** @deprecated since 1.27 (to be removed in 2.0). Use getSourceContext() instead */140    public function getSource()141    {142        @trigger_error('The '.__METHOD__.' method is deprecated since version 1.27 and will be removed in 2.0. Use getSourceContext() instead.', E_USER_DEPRECATED);143        return $this->getSourceContext()->getCode();144    }145    public function getSourceContext()146    {147        return new Twig_Source("<strong class=\"visitor-log-datetime visitorLogTooltip\" title=\"{% if visitInfo.getColumn('visitorType')=='new' %}{{ 'General_NewVisitor'|translate }}{% else %}{{ 'Live_VisitorsLastVisit'|translate(visitInfo.getColumn('daysSinceLastVisit')) }}{% endif %}\">148    {{ visitInfo.getColumn('serverDatePrettyFirstAction') }}149    {% if isWidget %}<br/>{% else %}-{% endif %} {{ visitInfo.getColumn('serverTimePrettyFirstAction') }}</strong>150{% if visitInfo.getColumn('visitIp') is not empty %}151<span class=\"visitor-log-ip-location visitorLogTooltip\" title=\"{% if visitInfo.getColumn('userId') is not empty %}{{ 'General_UserId'|translate }}: {{ visitInfo.getColumn('userId')|rawSafeDecoded }}152{% endif %}{% if visitInfo.getColumn('visitorId') is not empty %}{{ 'General_VisitorID'|translate }}: {{ visitInfo.getColumn('visitorId') }}153{% endif %}{% if visitInfo.getColumn('idVisit') is not empty %}154{{ 'General_Visit'|translate }} ID: {{ visitInfo.getColumn('idVisit') }}155{% endif %}{% if visitInfo.getColumn('latitude') or visitInfo.getColumn('longitude') %}{{ visitInfo.getColumn('location') }}156GPS (lat/long): {{ visitInfo.getColumn('latitude') }},{{ visitInfo.getColumn('longitude') }}157{% endif %}{% if visitInfo.getColumn('providerName') %}158{{ 'Provider_ColumnProvider'|translate }}: {{ visitInfo.getColumn('providerName') }}{% endif %}\">159    IP: {{ visitInfo.getColumn('visitIp') }}160    <br />161    {% if visitInfo.getColumn('location') != 'General_Unknown'|translate %}<span><img width=\"16\" class=\"flag\" src=\"{{ visitInfo.getColumn('countryFlag') }}\"/>&nbsp;162    {% if visitInfo.getColumn('city') is not empty %}{{ visitInfo.getColumn('city') }}{% else %}{{ visitInfo.getColumn('country') }}{% endif %}</span>{% endif %}163    {% if visitInfo.getColumn('userId') is not empty %}<br/><br/>{{ visitInfo.getColumn('userId')|rawSafeDecoded }}{% endif %}164</span>{% endif %}165{% if isWidget %}166    <br />167    {{ postEvent('Live.renderVisitorIcons', visitInfo) }}168{% endif %}169", "@Live/_visitorDetails.twig", "C:\\wamp\\www\\piwik\\plugins\\Live\\templates\\_visitorDetails.twig");170    }171}...

...12    protected function doDisplay(array $context, array $blocks = array())13    {14        // line 115        echo "<strong class=\"visitor-log-datetime visitorLogTooltip\" title=\"";16        if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitorType"), "method") == "new")) {17            echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_NewVisitor")), "html", null, true);18        } else {19            echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("Live_VisitorsLastVisit", $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "daysSinceLastVisit"), "method"))), "html", null, true);20        }21        echo "\">22    ";23        // line 224        echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "serverDatePrettyFirstAction"), "method"), "html", null, true);25        echo "26    ";27        // line 328        if (($context["isWidget"] ?? $this->getContext($context, "isWidget"))) {29            echo "<br/>";30        } else {31            echo "-";32        }33        echo " ";34        echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "serverTimePrettyFirstAction"), "method"), "html", null, true);35        echo "</strong>36";37        // line 438        if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitIp"), "method"))) {39            // line 540            echo "<span class=\"visitor-log-ip-location visitorLogTooltip\" title=\"";41            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method"))) {42                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_UserId")), "html", null, true);43                echo ": ";44                echo call_user_func_array($this->env->getFilter('rawSafeDecoded')->getCallable(), array($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method")));45                echo "46";47            }48            // line 649            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitorId"), "method"))) {50                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_VisitorID")), "html", null, true);51                echo ": ";52                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitorId"), "method"), "html", null, true);53                echo "54";55            }56            // line 757            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "idVisit"), "method"))) {58                // line 859                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_Visit")), "html", null, true);60                echo " ID: ";61                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "idVisit"), "method"), "html", null, true);62                echo "63";64            }65            // line 966            if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "latitude"), "method") || $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "longitude"), "method"))) {67                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "location"), "method"), "html", null, true);68                echo "69GPS (lat/long): ";70                // line 1071                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "latitude"), "method"), "html", null, true);72                echo ",";73                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "longitude"), "method"), "html", null, true);74                echo "75";76            }77            // line 1178            if ($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "providerName"), "method")) {79                // line 1280                echo \Piwik\piwik_escape_filter($this->env, call_user_func_array($this->env->getFilter('translate')->getCallable(), array("Provider_ColumnProvider")), "html", null, true);81                echo ": ";82                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "providerName"), "method"), "html", null, true);83            }84            echo "\">85    IP: ";86            // line 1387            echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "visitIp"), "method"), "html", null, true);88            echo "89    <br />90    ";91            // line 1592            if (($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "location"), "method") != call_user_func_array($this->env->getFilter('translate')->getCallable(), array("General_Unknown")))) {93                echo "<span><img width=\"16\" class=\"flag\" src=\"";94                echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "countryFlag"), "method"), "html", null, true);95                echo "\"/>&nbsp;96    ";97                // line 1698                if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "city"), "method"))) {99                    echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "city"), "method"), "html", null, true);100                } else {101                    echo \Piwik\piwik_escape_filter($this->env, $this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "country"), "method"), "html", null, true);102                }103                echo "</span>";104            }105            // line 17106            echo "107    ";108            // line 18109            if ( !twig_test_empty($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method"))) {110                echo "<br/><br/>";111                echo call_user_func_array($this->env->getFilter('rawSafeDecoded')->getCallable(), array($this->getAttribute(($context["visitInfo"] ?? $this->getContext($context, "visitInfo")), "getColumn", array(0 => "userId"), "method")));112            }113            // line 19114            echo "</span>";115        }116        // line 20117        if (($context["isWidget"] ?? $this->getContext($context, "isWidget"))) {118            // line 21119            echo "    <br />120    ";121            // line 22122            echo call_user_func_array($this->env->getFunction('postEvent')->getCallable(), array("Live.renderVisitorIcons", ($context["visitInfo"] ?? $this->getContext($context, "visitInfo"))));123            echo "124";125        }126    }127    public function getTemplateName()128    {129        return "@Live/_visitorDetails.twig";130    }131    public function isTraitable()132    {133        return false;134    }135    public function getDebugInfo()136    {137        return array (  126 => 22,  123 => 21,  121 => 20,  118 => 19,  113 => 18,  110 => 17,  102 => 16,  96 => 15,  91 => 13,  84 => 12,  82 => 11,  75 => 10,  70 => 9,  63 => 8,  61 => 7,  53 => 6,  44 => 5,  42 => 4,  32 => 3,  28 => 2,  19 => 1,);138    }139    /** @deprecated since 1.27 (to be removed in 2.0). Use getSourceContext() instead */140    public function getSource()141    {142        @trigger_error('The '.__METHOD__.' method is deprecated since version 1.27 and will be removed in 2.0. Use getSourceContext() instead.', E_USER_DEPRECATED);143        return $this->getSourceContext()->getCode();144    }145    public function getSourceContext()146    {147        return new Twig_Source("<strong class=\"visitor-log-datetime visitorLogTooltip\" title=\"{% if visitInfo.getColumn('visitorType')=='new' %}{{ 'General_NewVisitor'|translate }}{% else %}{{ 'Live_VisitorsLastVisit'|translate(visitInfo.getColumn('daysSinceLastVisit')) }}{% endif %}\">148    {{ visitInfo.getColumn('serverDatePrettyFirstAction') }}149    {% if isWidget %}<br/>{% else %}-{% endif %} {{ visitInfo.getColumn('serverTimePrettyFirstAction') }}</strong>150{% if visitInfo.getColumn('visitIp') is not empty %}151<span class=\"visitor-log-ip-location visitorLogTooltip\" title=\"{% if visitInfo.getColumn('userId') is not empty %}{{ 'General_UserId'|translate }}: {{ visitInfo.getColumn('userId')|rawSafeDecoded }}152{% endif %}{% if visitInfo.getColumn('visitorId') is not empty %}{{ 'General_VisitorID'|translate }}: {{ visitInfo.getColumn('visitorId') }}153{% endif %}{% if visitInfo.getColumn('idVisit') is not empty %}154{{ 'General_Visit'|translate }} ID: {{ visitInfo.getColumn('idVisit') }}155{% endif %}{% if visitInfo.getColumn('latitude') or visitInfo.getColumn('longitude') %}{{ visitInfo.getColumn('location') }}156GPS (lat/long): {{ visitInfo.getColumn('latitude') }},{{ visitInfo.getColumn('longitude') }}157{% endif %}{% if visitInfo.getColumn('providerName') %}158{{ 'Provider_ColumnProvider'|translate }}: {{ visitInfo.getColumn('providerName') }}{% endif %}\">159    IP: {{ visitInfo.getColumn('visitIp') }}160    <br />161    {% if visitInfo.getColumn('location') != 'General_Unknown'|translate %}<span><img width=\"16\" class=\"flag\" src=\"{{ visitInfo.getColumn('countryFlag') }}\"/>&nbsp;162    {% if visitInfo.getColumn('city') is not empty %}{{ visitInfo.getColumn('city') }}{% else %}{{ visitInfo.getColumn('country') }}{% endif %}</span>{% endif %}163    {% if visitInfo.getColumn('userId') is not empty %}<br/><br/>{{ visitInfo.getColumn('userId')|rawSafeDecoded }}{% endif %}164</span>{% endif %}165{% if isWidget %}166    <br />167    {{ postEvent('Live.renderVisitorIcons', visitInfo) }}168{% endif %}169", "@Live/_visitorDetails.twig", "/html/analytics/plugins/Live/templates/_visitorDetails.twig");170    }171}...

...55            set_time_limit(5);565758            foreach ($cellIterator as $cell) {59                if('A' == $cell->getColumn()){60                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();61                } else if('B' == $cell->getColumn()){62                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();63                } else if('C' == $cell->getColumn()){64                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();65                } else if('D' == $cell->getColumn()){66                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();67                } else if('E' == $cell->getColumn()){68                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();69                } else if('F' == $cell->getColumn()){70                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();71                } else if('G' == $cell->getColumn()){72                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();73                } else if('H' == $cell->getColumn()){74                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();75                } else if('I' == $cell->getColumn()){76                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();77                } else if('J' == $cell->getColumn()){78                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();79                } else if('K' == $cell->getColumn()){80                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();81                } else if('L' == $cell->getColumn()){82                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();83                }8485            }86            87            88            $i++;89        }90        91        92        $i=0;93        foreach($array_data as $row) {94            $c=0;95            foreach($row as $cell):96                $result[$c][]=$cell;
...

...54            set_time_limit(5);555657            foreach ($cellIterator as $cell) {58                if('A' == $cell->getColumn()){59                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();60                } else if('B' == $cell->getColumn()){61                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();62                } else if('C' == $cell->getColumn()){63                    $array_data[$rowIndex][$cell->getColumn()] = PHPExcel_Style_NumberFormat::toFormattedString($cell->getCalculatedValue(), 'YYYY-MM-DD');64                } else if('D' == $cell->getColumn()){65                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();66                } else if('E' == $cell->getColumn()){67                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();68                } else if('F' == $cell->getColumn()){69                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();70                } else if('G' == $cell->getColumn()){71                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();72                } else if('H' == $cell->getColumn()){73                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();74                } else if('I' == $cell->getColumn()){75                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();76                } else if('J' == $cell->getColumn()){77                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();78                } else if('K' == $cell->getColumn()){79                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();80                } else if('L' == $cell->getColumn()){81                    $array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();82                }8384            }85            86            87            $i++;88        }89        90        91        92        foreach($array_data as $row) {93            $c=0;94            foreach($row as $cell):95                $result[$c][]=$cell;
...

...33            $cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set34                foreach ($cellIterator as $cell) {35                    if ($cell->getValue() != '') {36                        $cellValue = trim($cell->getValue());37                        if ($cell->getColumn() == 'A') {38                            $location->setAdministrativeAreaLevel3($cellValue);39                        }40                        if ($cell->getColumn() == 'B') {41                            $service->setDisplayName($cellValue);42                        }43                        if ($cell->getColumn() == 'C') {44                            $location->setAddress($cellValue);45                        }46                        if ($cell->getColumn() == 'D') {47                            $service->setWebsite($cellValue);48                        }49                        if ($cell->getColumn() == 'E') {50                            $service->setEmail($cellValue);51                        }52                        if ($cell->getColumn() == 'F') {53                            $service->setPhone($cellValue);54                        }55                        if ($cell->getColumn() == 'G') {56                            $location->setLat($cellValue);57                        }58                        if ($cell->getColumn() == 'H') {59                            $location->setLng($cellValue);60                        }61                    }62                }63            $service->setLocation($location);64            if ($service->getDisplayName() != '') {65                $manager->persist($service);66            }67        }68        $manager->flush();69    }70}...

1$location = new Location();2$location->getColumn('id');3$location->getColumn('name');4$location->getColumn('address');5$location->getColumn('city');6$location->getColumn('state');7$location->getColumn('zip');8$location->getColumn('country');9$location = new Location();10$columns = $location->getColumns();11foreach($columns as $column){12    echo $column . '<BR>';13}14$location = new Location();15$columns = $location->getColumns();16echo implode($columns, ', ');17$location = new Location();18$columns = $location->getColumns();19echo implode($columns, ', ');20echo '<BR>';21echo implode($columns, ', ');22$location = new Location();23$columns = $location->getColumns();24echo implode($columns, ', ');25echo '<BR>';26echo implode($columns, ', ');27echo '<BR>';28echo implode($columns, ', ');29$location = new Location();30$columns = $location->getColumns();31echo implode($columns, ', ');32echo '<BR>';33echo implode($columns, ', ');34echo '<BR>';35echo implode($columns, ', ');36echo '<BR>';37echo implode($columns, ', ');38$location = new Location();39$columns = $location->getColumns();40echo implode($c

1$location = new Location();2echo $location->getColumn('city');3$location = new Location();4echo $location->getColumn('state');5require_once 'Location.php';6$location = new Location();7echo $location->getColumn('city');8$location = new Location();9echo $location->getColumn('state');10require_once 'Location.php';11require_once 'Location.php';12require_once 'Location.php';13require_once 'Location.php';14require_once 'Location.php';15require_once 'Location.php';16require 'Location.php';17$location = new Location();18echo $location->getColumn('city');19$location = new Location();20echo $location->getColumn('state');21include 'Location.php';22$location = new Location();23echo $location->getColumn('city');24$location = new Location();25echo $location->getColumn('state');

1$location = new Location();2$location->getColumn('id');3$location->getColumn('name');4$location = new Location();5$location->getColumn('id');6$location->getColumn('name');7include_once('Location.php');8$location = new Location();9$location->getColumn('id');10$location->getColumn('name');11include_once('Location.php');12$location = new Location();13$location->getColumn('id');14$location->getColumn('name');

1$location = new Location();2$location->getColumn('location_name');3$location = new Location();4$location->getColumn('location_name');5require_once("1.php");6$location = new Location();7$location->getColumn('location_name');

1require_once "Location.php";2$loc = new Location();3echo $loc->getColumn("id");4require_once "Location.php";5$loc = new Location();6echo $loc->getColumn("name");7require_once "Location.php";8$loc = new Location();9echo $loc->getColumn("address");10require_once "Location.php";11$loc = new Location();12echo $loc->getColumn("city");13require_once "Location.php";14$loc = new Location();15echo $loc->getColumn("state");16require_once "Location.php";17$loc = new Location();18echo $loc->getColumn("zip");19require_once "Location.php";20$loc = new Location();21echo $loc->getColumn("phone");22require_once "Location.php";23$loc = new Location();24echo $loc->getColumn("email");25require_once "Location.php";26$loc = new Location();27echo $loc->getColumn("url");28require_once "Location.php";29$loc = new Location();30echo $loc->getColumn("latitude");31require_once "Location.php";32$loc = new Location();33echo $loc->getColumn("longitude");34require_once "Location.php";35$loc = new Location();36echo $loc->getColumn("hours");37require_once "Location.php";38$loc = new Location();39echo $loc->getColumn("description");40require_once "Location.php";41$loc = new Location();

1$location = new Location();2$location->setColumn(1);3$location->setRow(1);4$location->getColumn();5$location->getRow();6echo $location->toString();

1$locationObj = new Location();2$locationObj->getColumn('name');3$locationObj = new Location();4$locationObj->getRow('name');5$locationObj = new Location();6$locationObj->getAll('name');7$locationObj = new Location();8$locationObj->getAll('name');9$locationObj = new Location();10$locationObj->getAll('name');11$locationObj = new Location();12$locationObj->getAll('name');