Subversion Repositories cheapmusic

<?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('-2 days'));
            $toTime = !empty($searchInfo['to_time']) ? addslashes($searchInfo['to_time']) : date('Y-m-d', strtotime('-1 days'));
            $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 * from (
                    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
                ) as p group by p.url limit " . SP_PAGINGNO;
                
                $pageResultList = $this->db->select($sql);
                $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 * from (
                    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
                ) as p group by p.keyword_id limit " . SP_PAGINGNO;
            
            $keywordResultList = $this->db->select($sql);
            $this->set("keywordResultList", $keywordResultList);
            $this->render('report/keyword_overview_data');
        }
        
}
?>