//$result = $gate->findById(3);
//echo $result->id . " - " . $result->ip_address;
//
//echo '<h3>Test filterByBrowser(2)</h3>';
//$gate = new VisitsTableGateway($dbAdapter);
//$result = $gate->filterByBrowser(2);
//foreach ($result as $row) {
// echo $row->id . " - " . $row->browser_id .' - '. $row->ip_address . "<br/>";
//}
//echo '<h3>Test filterByOS(4)</h3>';
//$gate = new VisitsTableGateway($dbAdapter);
//$result = $gate->filterByReferrer(5);
//foreach ($result as $row) {
// echo $row->id . " - " . $row->referrer_id . ' - ' . $row->ip_address . "<br/>";
//}
$gate = new VisitsTableGateway($dbAdapter);
echo '<h3>Test countryLike</h3>';
$gate = new CountriesTableGateway($dbAdapter);
$result = $gate->countryLike('ja');
foreach ($result as $row) {
echo $row->CountryName . ' - ' . $row->ISO . "<br/>";
}
$gate = new CountriesTableGateway($dbAdapter);
echo '<h3>Test countryLike</h3>';
$gate = new BrowserTableGateway($dbAdapter);
$result = $gate->visitsByCountryFromContinent();
foreach ($result as $row) {
echo $row->Name . $row->Visits . "<br/>";
}
// all done close connection
$dbAdapter->closeConnection();
function actionData($userData, $actionType, $param, $param2)
{
require_once 'lib/helpers/visits-setup.inc.php';
$BrowsersToPull = new BrowserTableGateway($dbAdapter);
$CountriesToPull = new CountriesTableGateway($dbAdapter);
$VisitsToPull = new VisitsTableGateway($dbAdapter);
$dataSets = array("Browsers", "Continents", "Countries", "DeviceBrand", "DeviceType", "OperatingSystems", "Referrers", "Visits");
if (in_array($userData, $dataSets)) {
switch ($userData) {
case "Visits":
if ($actionType == "countmonth") {
$dataOutput = $VisitsToPull->countByMonth($param);
} elseif ($actionType == "countmonthbyday") {
$dataOutput = $VisitsToPull->visitsByDayForMonth($param);
} elseif ($actionType == "countbycountrycode") {
$dataOutput = $VisitsToPull->countByCountryCode($param);
} elseif ($actionType == "countbydevicetype") {
$dataOutput = $VisitsToPull->countByDeviceType($param);
} elseif ($actionType == "countbydevicebrand") {
$dataOutput = $VisitsToPull->countByDeviceBrand($param);
} elseif ($actionType == "countbybrowser") {
$dataOutput = $VisitsToPull->countByBrowser($param);
} elseif ($actionType == "countbyreferrer") {
$dataOutput = $VisitsToPull->countByReferrer($param);
} elseif ($actionType == "countbyos") {
$dataOutput = $VisitsToPull->countByOS($param);
} elseif ($actionType == "filtervisitsdata") {
$dataOutput = $VisitsToPull->filterVisitsData($param, $param2);
} elseif ($actionType == "visitsforbarchart") {
$dataOutput = $VisitsToPull->visitsForBarChart($param);
} else {
$dataOutput = null;
}
echo json_encode($dataOutput);
break;
case "Countries":
if ($actionType == "filterbycontinentcode") {
$dataOutput = $CountriesToPull->filterByContinentCode($param);
} elseif ($actionType == "countrieslike") {
$dataOutput = $CountriesToPull->countryLike($param);
} elseif ($actionType == "visitsbycountry") {
$dataOutput = $CountriesToPull->visitsByCountry($param);
} elseif ($actionType == "fetchcountrynames") {
$dataOutput = $CountriesToPull->fetchCountryNames();
} elseif ($actionType == "fetchcountrynamestop10visits") {
$dataOutput = $CountriesToPull->fetchCountryNamesTop10Visits();
} elseif ($actionType == "visitsbycountryfromcontinent") {
$dataOutput = $CountriesToPull->visitsByCountryFromContinent($param);
} else {
$dataOutput = "Invalid Input";
}
echo json_encode($dataOutput);
break;
case "Browsers":
if ($actionType == "visitsbybrowser") {
$dataOutput = $BrowsersToPull->visitsByBrowser();
} else {
$dataOutput = "Invalid Input";
}
echo json_encode($dataOutput);
break;
}
}
}
