Rev 103 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<?php
/***************************************************************************
* Copyright (C) 2009-2011 by Geo Varghese(www.seopanel.in) *
* sendtogeo@gmail.com *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
* This program is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
* GNU General Public License for more details. *
* *
* You should have received a copy of the GNU General Public License *
* along with this program; if not, write to the *
* Free Software Foundation, Inc., *
* 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. *
***************************************************************************/
/* class defines all overview controller functions */
class OverviewController extends Controller {
var $baseUrl = "overview.php";
function showOverView($searchInfo = '') {
$userId = isLoggedIn();
$websiteCtrler = New WebsiteController();
$websiteList = $websiteCtrler->__getAllWebsites($userId, true);
if (empty($websiteList)) {
showErrorMsg($_SESSION['text']['common']['nowebsites']);
}
$this->set('siteList', $websiteList);
$websiteId = isset($searchInfo['website_id']) ? intval($searchInfo['website_id']) : $websiteList[0]['id'];
$this->set('websiteId', $websiteId);
$fromTime = !empty($searchInfo['from_time']) ? addslashes($searchInfo['from_time']) : date('Y-m-d', strtotime('-14 days'));
$toTime = !empty($searchInfo['to_time']) ? addslashes($searchInfo['to_time']) : date('Y-m-d');
$this->set('fromTime', $fromTime);
$this->set('toTime', $toTime);
$this->set("custSubMenu", "overview");
$this->render('user/userhome');
}
function showPageOverview($websiteId, $fromDate, $toDate) {
$keywordController = new KeywordController();
$seLIst = $keywordController->getUserKeywordSearchEngineList("", $websiteId);
if (empty($seLIst)) {
showErrorMsg($_SESSION['text']['common']['No Records Found']);
}
$this->set("seList", $seLIst);
$pageOVUrl = SP_WEBPATH . "/$this->baseUrl?sec=page-overview-data&website_id=$websiteId&from_time=$fromDate&to_time=$toDate";
$this->set("pageOVUrl", $pageOVUrl);
$this->render('report/page_overview');
}
function showPageOverviewData($seachInfo) {
$websiteId = intval($seachInfo['website_id']);
$seId = intval($seachInfo['se_id']);
$conditions = !empty($seachInfo['from_time']) ? " and sr.result_date>='".addslashes($seachInfo['from_time'])."'" : "";
$conditions .= !empty($seachInfo['to_time']) ? " and sr.result_date<='".addslashes($seachInfo['to_time'])."'" : "";
$sql = "select distinct srd.url, sr.`rank`,sr.result_date, sr.keyword_id, k.name as keyword
from searchresults sr, searchresultdetails srd, keywords k
where sr.id=srd.searchresult_id and sr.keyword_id=k.id and k.website_id=$websiteId and sr.searchengine_id=$seId $conditions
order by `rank` asc, result_date DESC limit 0, 1000";
$rList = $this->db->select($sql);
$pageResultList = [];
foreach ($rList as $rInfo) {
if (!isset($pageResultList[$rInfo['url']])) {
$pageResultList[$rInfo['url']] = $rInfo;
if(count($pageResultList) > SP_PAGINGNO) {
break;
}
}
}
$this->set("pageResultList", $pageResultList);
$this->render('report/page_overview_data');
}
function showKeywordOverview($websiteId, $fromDate, $toDate) {
$keywordController = new KeywordController();
$seLIst = $keywordController->getUserKeywordSearchEngineList("", $websiteId);
if (empty($seLIst)) {
showErrorMsg($_SESSION['text']['common']['No Records Found']);
}
$this->set("seList", $seLIst);
$keywordOVUrl = SP_WEBPATH . "/$this->baseUrl?sec=keyword-overview-data&website_id=$websiteId&from_time=$fromDate&to_time=$toDate";
$this->set("keywordOVUrl", $keywordOVUrl);
$this->render('report/keyword_overview');
}
function showKeywordOverviewData($seachInfo) {
$websiteId = intval($seachInfo['website_id']);
$seId = intval($seachInfo['se_id']);
$conditions = !empty($seachInfo['from_time']) ? " and sr.result_date>='".addslashes($seachInfo['from_time'])."'" : "";
$conditions .= !empty($seachInfo['to_time']) ? " and sr.result_date<='".addslashes($seachInfo['to_time'])."'" : "";
$sql = "select distinct sr.keyword_id, srd.url, sr.`rank`,sr.result_date, k.name as keyword
from searchresults sr, searchresultdetails srd, keywords k
where sr.id=srd.searchresult_id and sr.keyword_id=k.id and k.website_id=$websiteId and sr.searchengine_id=$seId $conditions
order by `rank` asc, result_date DESC limit 0, 1000";
$rList = $this->db->select($sql);
$keywordResultList = [];
foreach ($rList as $rInfo) {
if (!isset($keywordResultList[$rInfo['keyword']])) {
$keywordResultList[$rInfo['keyword']] = $rInfo;
if(count($keywordResultList) > SP_PAGINGNO) {
break;
}
}
}
$this->set("keywordResultList", $keywordResultList);
$this->render('report/keyword_overview_data');
}
}
?>