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.             *
 ***************************************************************************/

include_once(SP_CTRLPATH."/components/review_base.ctrl.php");

# class defines all review manager controller functions
class ReviewManagerController extends ReviewBase{
    
    var $linkTable = "review_links";
    var $linkReportTable = "review_link_results";
    var $layout = "ajax";
    var $pageScriptPath = 'review.php';
    var $serviceList;
    var $colList;
    var $spTextRM;
        
    function __construct() {
        parent::__construct();
        
        $this->set('pageScriptPath', $this->pageScriptPath);
        $this->set( 'serviceList', $this->serviceList );
        $this->set( 'pageNo', $_REQUEST['pageno']);
                
                $this->colList = array(
                        'url' => $_SESSION['text']['common']['Url'],
                        'reviews' => $_SESSION['text']['label']['Reviews'],
                        'rating' => $_SESSION['text']['label']['Rating'],
                );
    }
    
    function showReviewLinks($searchInfo = '') {
        $userId = isLoggedIn();
        $this->set('searchInfo', $searchInfo);
        $sql = "select l.*, w.name as website_name from $this->linkTable l, websites w where l.website_id=w.id";
        
        if (!isAdmin()) {
            $sql .= " and w.user_id=$userId";
        }
        
        // search conditions
        $sql .= !empty($searchInfo['name']) ? " and l.name like '%".addslashes($searchInfo['name'])."%'" : "";
        $sql .= !empty($searchInfo['website_id']) ? " and l.website_id=".intval($searchInfo['website_id']) : "";
        $sql .= !empty($searchInfo['type']) ? " and `type`='".addslashes($searchInfo['type'])."'" : "";
        
        if (!empty($searchInfo['status'])) {
            $sql .= ($searchInfo['status'] == 'active') ? " and l.status=1" : " and l.status=0"; 
        }
        
        $webSiteCtrler = new WebsiteController();
        $websiteList = $webSiteCtrler->__getAllWebsites($userId, true);
        $this->set( 'websiteList', $websiteList );
         
        // pagination setup
        $this->db->query( $sql, true );
        $this->paging->setDivClass( 'pagingdiv' );
        $this->paging->loadPaging( $this->db->noRows, SP_PAGINGNO );
        $pagingDiv = $this->paging->printPages( $this->pageScriptPath, 'searchForm', 'scriptDoLoadPost', 'content', '' );
        $this->set( 'pagingDiv', $pagingDiv );
        $sql .= " limit " . $this->paging->start . "," . $this->paging->per_page;
        
        $linkList = $this->db->select( $sql );
        $this->set( 'list', $linkList );
        $this->render( 'review/show_review_links');
    }
    
    function __checkName($name, $websiteId, $linkId = false){
        $whereCond = "name='".addslashes($name)."'";
        $whereCond .= " and website_id='".intval($websiteId)."'";
        $whereCond .= !empty($linkId) ? " and id!=".intval($linkId) : "";
        $listInfo = $this->dbHelper->getRow($this->linkTable, $whereCond);
        return empty($listInfo['id']) ? false :  $listInfo['id'];
    }
    
    function __checkUrl($url, $websiteId, $linkId = false){
        $whereCond = "url='".addslashes($url)."'";
        $whereCond .= " and website_id=".intval($websiteId);
        $whereCond .= !empty($linkId) ? " and id!=".intval($linkId) : "";
        $listInfo = $this->dbHelper->getRow($this->linkTable, $whereCond);
        return empty($listInfo['id']) ? false :  $listInfo['id'];
    }
    
    function validateReviewLink($listInfo) {        
        $errMsg = [];
        $errMsg['name'] = formatErrorMsg($this->validate->checkBlank($listInfo['name']));
        $errMsg['url'] = formatErrorMsg($this->validate->checkBlank($listInfo['url']));
        $errMsg['website_id'] = formatErrorMsg($this->validate->checkBlank($listInfo['website_id']));
        $errMsg['type'] = formatErrorMsg($this->validate->checkBlank($listInfo['type']));
        
        if(!$this->validate->flagErr){            
            if ($this->__checkName($listInfo['name'], $listInfo['website_id'], $listInfo['id'])) {
                $errMsg['name'] = formatErrorMsg($_SESSION['text']['label']['already exist']);
                $this->validate->flagErr = true;
            }
        }
        
        if(!$this->validate->flagErr){
            if ($this->__checkUrl($listInfo['url'], $listInfo['website_id'], $listInfo['id'])) {
                $errMsg['url'] = formatErrorMsg($_SESSION['text']['label']['already exist']);
                $this->validate->flagErr = true;
            }
        }
        
        if(!$this->validate->flagErr){
            if (!stristr($listInfo['url'], $listInfo['type'])) {
                $errMsg['url'] = formatErrorMsg($_SESSION['text']['common']["Invalid value"]);
                $this->validate->flagErr = true;
            }
        }
        
        // Validate link count
        if(!$this->validate->flagErr){
            $websiteCtrl = new WebsiteController();
            $websiteInfo = $websiteCtrl->__getWebsiteInfo($listInfo['website_id']);
            $newCount = !empty($listInfo['id']) ? 0 : 1;
            if (! $this->validateReviewLinkCount($websiteInfo['user_id'], $newCount)) {
                $this->set('validationMsg', $this->spTextSMC['Your review link count already reached the limit']);
                $this->validate->flagErr = true;
            }
        }
        
        return $errMsg;        
    }
    
    // Function to check / validate the user type review count
    function validateReviewLinkCount($userId, $newCount = 1) {
        $userCtrler = new UserController();
        
        // if admin user id return true
        if ($userCtrler->isAdminUserId($userId)) {
            return true;
        }
        
        $userTypeCtrlr = new UserTypeController();
        $userTypeDetails = $userTypeCtrlr->getUserTypeSpecByUser($userId);
        
        $whereCond = "l.website_id=w.id and w.user_id=".intval($userId);
        $existingInfo = $this->dbHelper->getRow("$this->linkTable l, websites w", $whereCond, "count(*) count");
        $userSMLinkCount = $existingInfo['count'];
        $userSMLinkCount += $newCount;
        
        // if limit is set and not -1
        if (isset($userTypeDetails['review_link_count']) && $userTypeDetails['review_link_count'] >= 0) {
            
            // check whether count greater than limit
            if ($userSMLinkCount <= $userTypeDetails['review_link_count']) {
                return true;
            } else {
                return false;
            }
            
        } else {
            return true;
        }
        
    }
    
    function newReviewLink($info = '') {
        $userId = isLoggedIn();
        $this->set('post', $info);
        $webSiteCtrler = new WebsiteController();
        $websiteList = $webSiteCtrler->__getAllWebsites($userId, true);
        $this->set( 'websiteList', $websiteList );                
        $this->set('editAction', 'createReviewLink');
        $this->render( 'review/edit_review_link');   
    }
    
    function createReviewLink($listInfo = '') {
        
        $errMsg = $this->validateReviewLink($listInfo);
        
        // if no error occured
        if (!$this->validate->flagErr) {
            $dataList = [
                'name' => $listInfo['name'],
                'url' => addHttpToUrl($listInfo['url']),
                'type' => $listInfo['type'],
                'website_id|int' => $listInfo['website_id'],
            ];
            $this->dbHelper->insertRow($this->linkTable, $dataList);
            $this->showReviewLinks(['name' => $listInfo['name']]);
            exit;
        }
        
        $this->set('errMsg', $errMsg);
        $this->newReviewLink($listInfo);
        
    }
    
    function editReviewLink($linkId, $listInfo = '') {
        
        if (!empty($linkId)) {
            $userId = isLoggedIn();
            $webSiteCtrler = new WebsiteController();
            $websiteList = $webSiteCtrler->__getAllWebsites($userId, true);
            $this->set( 'websiteList', $websiteList );
            
            if(empty($listInfo)){
                $listInfo = $this->__getReviewLinkInfo($linkId);
            }
            
            $this->set('post', $listInfo);           
            $this->set('editAction', 'updateReviewLink');
            $this->render( 'review/edit_review_link');
        }
        
    }
    
    function updateReviewLink($listInfo) {
        $this->set('post', $listInfo);
        $errMsg = $this->validateReviewLink($listInfo);
        
        if (!$this->validate->flagErr) {
            $dataList = [
                'name' => $listInfo['name'],
                'url' => addHttpToUrl($listInfo['url']),
                'type' => $listInfo['type'],
                'website_id|int' => $listInfo['website_id'],
            ];
            $this->dbHelper->updateRow($this->linkTable, $dataList, "id=".intval($listInfo['id']));
            $this->showReviewLinks(['name' => $listInfo['name']]);
            exit;
        }
        
        $this->set('errMsg', $errMsg);
        $this->editReviewLink($listInfo['id'], $listInfo);
    }
    
    function deleteReviewLink($linkId) {
        $this->dbHelper->deleteRows($this->linkTable, "id=" . intval($linkId));
        $this->showReviewLinks();
    }
    
    function __changeStatus($linkId, $status){
        $linkId = intval($linkId);
        $this->dbHelper->updateRow($this->linkTable, ['status|int' => $status], "id=$linkId");
    }
    
    function __getReviewLinkInfo($linkId) {
        $whereCond = "id=".intval($linkId);
        $info = $this->dbHelper->getRow($this->linkTable, $whereCond);
        return $info;
    }
    
    function verifyActionAllowed($linkId) {
        $allowed = true;
        
        // if not admin, check the permissions
        if (!isAdmin()) {
            $userId = isLoggedIn();
            $linkInfo = $this->__getReviewLinkInfo($linkId);
            $webSiteCtrler = new WebsiteController();
            $webSiteInfo = $webSiteCtrler->__getWebsiteInfo($linkInfo['website_id']);
            $allowed = ($userId == $webSiteInfo['user_id']) ? true : false;
        }
        
        if (!$allowed) {
            showErrorMsg($_SESSION['text']['label']['Access denied']); 
        }
                
    }

        function viewQuickChecker($info='') {
                $this->render('review/quick_checker');
        }

        function doQuickChecker($listInfo = '') {
                
                if (!stristr($listInfo['url'], $listInfo['type'])) {
                        $errorMsg = formatErrorMsg($_SESSION['text']['common']["Invalid value"]);
                        $this->validate->flagErr = true;
                }
                
                // if no error occured find review details
                if (!$this->validate->flagErr) {
                        $smLink = addHttpToUrl($listInfo['url']);
                        $result = $this->getReviewDetails($listInfo['type'], $smLink);
                        
                        // if call is success
                        if ($result['status']) {
                                $this->set('smType', $listInfo['type']);
                                $this->set('smLink', $smLink);
                                $this->set('statInfo', $result);
                                $this->render('review/quick_checker_results');
                                exit;
                        } else {
                                $errorMsg = $result['msg'];
                        }
                        
                }
                
                $errorMsg = !empty($errorMsg) ? $errorMsg : $_SESSION['text']['common']['Internal error occured'];
                showErrorMsg($errorMsg);
                
        }       
        
        function getReviewDetails($smType, $smLink) {
                $result = ['status' => 0, 'reviews' => 0, 'rating' => 0, 'msg' => $_SESSION['text']['common']['Internal error occured']];
                $smInfo = $this->serviceList[$smType];
                
                if (!empty($smInfo) && !empty($smLink)) {
                        
                        // if params needs to be added with url
                        if (!empty($smInfo['url_part'])) {
                                $smLink .= stristr($smLink, '?') ? str_replace("?", "&", $smInfo['url_part']) : $smInfo['url_part'];
                        }
                        
                        $smContentInfo = $this->spider->getContent($smLink);
                        
                        // testing val
                        /*$myfile = fopen(SP_TMPPATH . "/gbusiness.html", "w") or die("Unable to open file!");
                        fwrite($myfile, $smContentInfo['page']);
                        fclose($myfile);
                        exit;

                        $smContentInfo = [];
                        $myfile = fopen(SP_TMPPATH . "/gbusiness.html", "r") or die("Unable to open file!");
                        $smContentInfo['page'] = fread($myfile,filesize(SP_TMPPATH . "/gbusiness.html"));
                        fclose($myfile);*/
                        
                        if (!empty($smContentInfo['page'])) {
                            $matches = [];

                                // find reviews
                                if (!empty($smInfo['regex']['reviews'])) {
                                    preg_match($smInfo['regex']['reviews'], $smContentInfo['page'], $matches);
                                        
                                        if (!empty($matches[1])) {
                                                $result['status'] = 1;
                                                $result['reviews'] = formatNumber($matches[1]);
                                        }
                                }
                                
                                // find rating
                                if (!empty($smInfo['regex']['rating'])) {
                                        preg_match($smInfo['regex']['rating'], $smContentInfo['page'], $matches);
                                                
                                        if (!empty($matches[1])) {
                                                $result['status'] = 1;
                                                $result['rating'] = formatNumber($matches[1]);
                                        }       
                                }
                                
                        } else {
                                $result['msg'] = $smContentInfo['errmsg'];
                        }
                        
                }
                
                return $result;
                
        }
        
        /*
         * function to get all links with out reports for a day
         */
        function getAllLinksWithOutReports($websiteId, $date) {
                $websiteId = intval($websiteId);
                $date = addslashes($date);
                $sql = "select link.*, lr.id result_id from review_links link left join 
                        review_link_results lr on (link.id=lr.review_link_id and lr.report_date='$date') 
                        where link.status=1 and link.website_id=$websiteId and lr.id is NULL";
                
                $linkList = $this->db->select($sql);
                return $linkList;
                
        }
        
        function saveReviewLinkResults($linkId, $linkInfo) {            
                $dataList = [
                        'review_link_id|int' => $linkId,
                        'reviews|int' => $linkInfo['reviews'],
                        'rating|float' => $linkInfo['rating'],
                        'report_date' => date('Y-m-d'),
                ];
                
                $this->dbHelper->insertRow($this->linkReportTable, $dataList);          
        }
        
        /*
         * func to show report summary
         */ 
        function viewReportSummary($searchInfo = '', $summaryPage = false, $cronUserId=false) {
        
                $userId = !empty($cronUserId) ? $cronUserId : isLoggedIn();
                $this->set('summaryPage', $summaryPage);
                $this->set('searchInfo', $searchInfo);
                $this->set('cronUserId', $cronUserId);
        
                $exportVersion = false;
                switch($searchInfo['doc_type']){
        
                        case "export":
                                $exportVersion = true;
                                $exportContent = "";
                                break;
                                        
                        case "pdf":
                                $this->set('pdfVersion', true);
                                break;
                                        
                        case "print":
                                $this->set('printVersion', true);
                                break;
                }
        
                $fromTime = !empty($searchInfo['from_time']) ? addslashes($searchInfo['from_time']) : date('Y-m-d', strtotime('-1 days'));
                $toTime = !empty($searchInfo['to_time']) ? addslashes($searchInfo['to_time']) : date('Y-m-d');
                $this->set('fromTime', $fromTime);
                $this->set('toTime', $toTime);
        
                $websiteController = New WebsiteController();
                $wList = $websiteController->__getAllWebsites($userId, true);
                $websiteList = [];
                foreach ($wList as $wInfo) $websiteList[$wInfo['id']] = $wInfo;
                $websiteList = count($websiteList) ? $websiteList : array(0);
                $this->set('websiteList', $websiteList);
                $websiteId = intval($searchInfo['website_id']);
                $this->set('websiteId', $websiteId);
        
                // to find order col
                if (!empty($searchInfo['order_col'])) {
                        $orderCol = $searchInfo['order_col'];
                        $orderVal = getOrderByVal($searchInfo['order_val']);
                } else {
                        $orderCol = "rating";
                        $orderVal = 'DESC';
                }
        
                $this->set('orderCol', $orderCol);
                $this->set('orderVal', $orderVal);
                $scriptName = $summaryPage ? "archive.php" : $this->pageScriptPath;
                $scriptPath = SP_WEBPATH . "/$scriptName?sec=reportSummary&website_id=$websiteId";
                $scriptPath .= "&from_time=$fromTime&to_time=$toTime&search_name=" . $searchInfo['search_name'] . "&type=" . $searchInfo['type'];
                $scriptPath .= "&order_col=$orderCol&order_val=$orderVal&report_type=social-media-reports";
        
                // set website id to get exact keywords of a user
                if (!empty($websiteId)) {
                        $conditions = " and sml.website_id=$websiteId";
                } else {
                        $conditions = " and sml.website_id in (".implode(',', array_keys($websiteList)).")";
                }
        
                $conditions .= !empty($searchInfo['search_name']) ? " and sml.url like '%".addslashes($searchInfo['search_name'])."%'" : "";
                $conditions .= !empty($searchInfo['type']) ? " and sml.type='".addslashes($searchInfo['type'])."'" : "";
        
                $subSql = "select [cols] from $this->linkTable sml, $this->linkReportTable r where sml.id=r.review_link_id
                and sml.status=1 $conditions and r.report_date='$toTime'";
        
                $sql = "
                (" . str_replace("[cols]", "sml.id,sml.url,sml.website_id,sml.type,r.reviews,r.rating", $subSql) . ")
                        UNION
                        (select sml.id,sml.url,sml.website_id,sml.type,0,0 from $this->linkTable sml where sml.status=1 $conditions
                        and sml.id not in (". str_replace("[cols]", "distinct(sml.id)", $subSql) ."))
                order by " . addslashes($orderCol) . " " . addslashes($orderVal);
        
                if ($orderCol != 'url') $sql .= ", url";
        
                // pagination setup, if not from cron job email send function, pdf and export action
                if (!in_array($searchInfo['doc_type'], array("pdf", "export"))) {
                        $this->db->query($sql, true);
                        $this->paging->setDivClass('pagingdiv');
                        $this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
                        $pagingDiv = $this->paging->printPages($scriptPath, '', 'scriptDoLoad', 'content', "");
                        $this->set('pagingDiv', $pagingDiv);
                        $this->set('pageNo', $searchInfo['pageno']);
                        $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;
                }
        
                # set report list
                $baseReportList = $this->db->select($sql);
                $this->set('baseReportList', $baseReportList);
                $this->set('colList', $this->colList);
        
                // if keywords existing
                if (!empty($baseReportList)) {
                                
                        $keywordIdList = array();
                        foreach ($baseReportList as $info) {
                                $keywordIdList[] = $info['id'];
                        }
        
                        $sql = "select sml.id,sml.url,sml.website_id,sml.type,r.rating,r.reviews
                        from $this->linkTable sml, $this->linkReportTable r where sml.id=r.review_link_id
                        and sml.status=1 $conditions and r.report_date='$fromTime'";
                        $sql .= " and sml.id in(" . implode(",", $keywordIdList) . ")";
                        $reportList = $this->db->select($sql);
                        $compareReportList = array();
                                
                        foreach ($reportList as $info) {
                                $compareReportList[$info['id']] = $info;
                        }
                                
                        $this->set('compareReportList', $compareReportList);
                                
                }
        
                if ($exportVersion) {
                        $spText = $_SESSION['text'];
                        $reportHeading =  $this->spTextTools['Review Report Summary']."($fromTime - $toTime)";
                        $exportContent .= createExportContent( array('', $reportHeading, ''));
                        $exportContent .= createExportContent( array());
                        $headList = array($spText['common']['Website'], $spText['common']['Url']);
        
                        $pTxt = str_replace("-", "/", substr($fromTime, -5));
                        $cTxt = str_replace("-", "/", substr($toTime, -5));
                        foreach ($this->colList as $colKey => $colLabel) {
                                if ($colKey == 'url') continue;
                                $headList[] = $colLabel . "($pTxt)";
                                $headList[] = $colLabel . "($cTxt)";
                                $headList[] = $colLabel . "(+/-)";
                        }
        
                        $exportContent .= createExportContent($headList);
                        foreach($baseReportList as $listInfo){
        
                                $valueList = array($websiteList[$listInfo['website_id']]['url'], $listInfo['url']);
                                foreach ($this->colList as $colName => $colVal) {
                                        if ($colName == 'url') continue;
                                                
                                        $currRank = isset($listInfo[$colName]) ? $listInfo[$colName] : 0;
                                        $prevRank = isset($compareReportList[$listInfo['id']][$colName]) ? $compareReportList[$listInfo['id']][$colName] : 0;
                                        $rankDiff = "";
        
                                        // if both ranks are existing
                                        if ($prevRank != '' && $currRank != '') {
                                                $rankDiff = $currRank - $prevRank;
                                        }
        
                                        $valueList[] = $prevRank;
                                        $valueList[] = $currRank;
                                        $valueList[] = $rankDiff;
                                }
        
                                $exportContent .= createExportContent( $valueList);
                        }
                                
                        if ($summaryPage) {
                                return $exportContent;
                        } else {
                                exportToCsv('review_report_summary', $exportContent);
                        }
                                
                } else {
                                
                        // if pdf export
                        if ($summaryPage) {
                                return $this->getViewContent('review/review_report_summary');
                        } else {
                                // if pdf export
                                if ($searchInfo['doc_type'] == "pdf") {
                                        exportToPdf($this->getViewContent('review/review_report_summary'), "review_report_summary_$fromTime-$toTime.pdf");
                                } else {
                                        $this->set('searchInfo', $searchInfo);
                                        $this->render('review/review_report_summary');
                                }
                        }
                                
                }
        }
        
        function __getReviewLinks($whereCond = false) {
            $linkList = $this->dbHelper->getAllRows($this->linkTable, $whereCond);
            return !empty($linkList) ? $linkList : false;
        }
        
        // func to show detailed reports
        function viewDetailedReports($searchInfo = '') {
        
                $userId = isLoggedIn();

                if (!empty ($searchInfo['from_time'])) {
                        $fromTimeDate = addslashes($searchInfo['from_time']);
                } else {
                        $fromTimeDate = date('Y-m-d', strtotime('-15 days'));
                }
                
                if (!empty ($searchInfo['to_time'])) {
                        $toTimeDate = addslashes($searchInfo['to_time']);
                } else {
                        $toTimeDate = date('Y-m-d');
                }
                
                $this->set('fromTime', $fromTimeDate);
                $this->set('toTime', $toTimeDate);
        
            if(!empty($searchInfo['link_id']) && !empty($searchInfo['rep'])){                           
                        $searchInfo['link_id'] = intval($searchInfo['link_id']);
                        $linkInfo = $this->__getReviewLinkInfo($searchInfo['link_id']);
                        $searchInfo['website_id'] = $linkInfo['website_id'];
                }
        
                $websiteController = New WebsiteController();
                $websiteList = $websiteController->__getAllWebsites($userId, true);
                $this->set('websiteList', $websiteList);
                $websiteId = empty ($searchInfo['website_id']) ? $websiteList[0]['id'] : intval($searchInfo['website_id']);
                $this->set('websiteId', $websiteId);
        
                $linkList = $this->__getReviewLinks("website_id=$websiteId and status=1 order by name");
                $this->set('linkList', $linkList);
                $linkId = empty($searchInfo['link_id']) ? $linkList[0]['id'] : intval($searchInfo['link_id']);
                $this->set('linkId', $linkId);
        
                $list = [];
                if (!empty($linkId)) {
                
                $sql = "select s.* from $this->linkReportTable s
                where report_date>='$fromTimeDate' and report_date<='$toTimeDate' and s.review_link_id=$linkId
                order by s.report_date";
                $reportList = $this->db->select($sql);
                
                $colList = array_keys($this->colList);
                array_shift($colList);
                foreach ($colList as $col) $prevRank[$col] = 0;
                
                # loop through rank
                foreach ($reportList as $key => $repInfo) {
                        
                        // if not the first row, find differences in rank
                        if ($key)  {
                                
                                foreach ($colList as $col) $rankDiff[$col] = '';
                                        
                                foreach ($colList as $col) {
                                        $rankDiff[$col] = round($repInfo[$col] - $prevRank[$col], 2);
                                        if (empty($rankDiff[$col])) continue;
                                        
                                        if ($col == "average_position" ) $rankDiff[$col] = $rankDiff[$col] * -1;
                                        $rankClass = ($rankDiff[$col] > 0) ? 'green' : 'red';
                                        
                                        $rankDiff[$col] = "<font class='$rankClass'>($rankDiff[$col])</font>";
                                        $reportList[$key]['rank_diff_'.$col] = empty($rankDiff[$col]) ? '' : $rankDiff[$col];                   
                                }
                                
                        }
                                
                        foreach ($colList as $col) $prevRank[$col] = $repInfo[$col];
                
                }
                
                $list = array_reverse($reportList, true);
                }
                
                $this->set('list', $list);                              
                $this->render('review/review_reports');
                
        }
        
        // func to show review link select box
        function showReviewLinkSelectBox($websiteId, $linkId = ""){
            $websiteId = intval($websiteId);
            $this->set('linkList', $this->__getReviewLinks("website_id=$websiteId and status=1 order by name"));
            $this->set('linkId', $linkId);
            $this->render('review/review_link_select_box');
        }
        
        // func to show link search reports in graph
        function viewGraphReports($searchInfo = '') {
            
            $userId = isLoggedIn();
            
            if (!empty ($searchInfo['from_time'])) {
                $fromTimeDate = addslashes($searchInfo['from_time']);
            } else {
                $fromTimeDate = date('Y-m-d', strtotime('-15 days'));
            }
            
            if (!empty ($searchInfo['to_time'])) {
                $toTimeDate = addslashes($searchInfo['to_time']);
            } else {
                $toTimeDate = date('Y-m-d');
            }
            
            $this->set('fromTime', $fromTimeDate);
            $this->set('toTime', $toTimeDate);
            
            if(!empty($searchInfo['link_id']) && !empty($searchInfo['rep'])){
                $searchInfo['link_id'] = intval($searchInfo['link_id']);
                $linkInfo = $this->__getReviewLinkInfo($searchInfo['link_id']);
                $searchInfo['website_id'] = $linkInfo['website_id'];
            }
            
            $websiteController = New WebsiteController();
            $websiteList = $websiteController->__getAllWebsites($userId, true);
            $this->set('websiteList', $websiteList);
            $websiteId = empty ($searchInfo['website_id']) ? $websiteList[0]['id'] : intval($searchInfo['website_id']);
            $this->set('websiteId', $websiteId);
            
            $linkList = $this->__getReviewLinks("website_id=$websiteId and status=1 order by name");
            $this->set('linkList', $linkList);
            $linkId = empty($searchInfo['link_id']) ? $linkList[0]['id'] : intval($searchInfo['link_id']);
            $this->set('linkId', $linkId);
            
            // if reports not empty
            $colList = $this->colList;
            array_shift($colList);
            $this->set('colList', $colList);
            $this->set('searchInfo', $searchInfo);
        
            $graphContent = showErrorMsg($_SESSION['text']['common']['No Records Found'], false, true);
            if (!empty($linkId)) {
                
                $sql = "select s.* from $this->linkReportTable s
                where report_date>='$fromTimeDate' and report_date<='$toTimeDate'  and s.review_link_id=$linkId
                order by s.report_date";
                $reportList = $this->db->select($sql);
                
                $graphColList = array();
                if (!empty($searchInfo['attr_type'])) {
                        $graphColList[$searchInfo['attr_type']] = $colList[$searchInfo['attr_type']];
                } else {
                        //array_pop($colList);
                        $graphColList = $colList;
                }
                
                if (!empty($reportList)) {
                                
                        $dataArr = "['Date', '" . implode("', '", array_values($graphColList)) . "']";
                         
                        // loop through data list
                        foreach ($reportList as $dataInfo) {
        
                                $valStr = "";
                                foreach ($graphColList as $seId => $seVal) {
                                        $valStr .= ", ";
                                        $valStr .= !empty($dataInfo[$seId]) ? $dataInfo[$seId] : 0;
                                }
        
                                $dataArr .= ", ['{$dataInfo['report_date']}' $valStr]";
                        }
                         
                        $this->set('dataArr', $dataArr);
                        $this->set('graphTitle', $this->spTextTools['Graphical Reports']);
                        $graphContent = $this->getViewContent('report/graph');
                } else {
                        $graphContent = showErrorMsg($_SESSION['text']['common']['No Records Found'], false, true);
                }
                
            }
                
                // get graph content
                $this->set('graphContent', $graphContent);
                $this->render('review/graphicalreport');
                
        }
        
}
?>