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 alert controller functions
class AlertController extends Controller {
    
    var $alertCategory;
    var $alertType;
    var $tableName = "alerts";
    var $pgScriptPath = "alerts.php";
    var $installAlertSubject = "Seo Panel New Version is Available Now!";
    
    function __construct() {
        parent::__construct();
        $this->alertCategory = array(
            'general' => $_SESSION['text']['common']["General"],
            'reports' => $_SESSION['text']['common']["Reports"],
        );
        
        $this->alertType = array(
            'success',
            'info',
            'warning',
            'danger',
            'primary',
            'secondary',
            'light',
            'dark',
        );
    }
        
        // func to get all Alerts
        function __getAllAlerts($cond = '') {
                $sql = "select * from $this->tableName where 1=1 $cond";
                $langList = $this->db->select($sql);
                return $langList;
        }
        
        // func to get alert info
        function __getAlertInfo($value, $col='id') {
                $sql = "select * from $this->tableName where $col = '". addslashes($value) ."'";
                $langInfo = $this->db->select($sql, true);
                return $langInfo;
        }
        
        /**
         * Function to display alert details
         * @param Array $info   Contains all search details
         */
        function listAlerts($info = '') {
            $userId = isLoggedIn();
            $fromTime = !empty($info['from_time']) ? $info['from_time'] : date('Y-m-d', strtotime('-30 days'));
            $toTime = !empty($info['to_time']) ? $info['to_time'] : date('Y-m-d');
            $this->set('fromTime', $fromTime);
            $this->set('toTime', $toTime);
            
            $sql = "select * from $this->tableName t where t.user_id=$userId and t.alert_time>='".addslashes("$fromTime 00:00:00")."'
                        and t.alert_time<='" . addslashes("$toTime 23:59:59") . "'";
            $sql .= !empty($info['keyword']) ? " and (alert_subject like '%".addslashes($info['keyword'])."%' or alert_message like '%".addslashes($info['keyword'])."%')" : "";
            $sql .= " order by alert_time DESC";
            
            // pagination setup
            $this->db->query($sql, true);
            $this->paging->setDivClass('pagingdiv');
            $this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
            $pagingDiv = $this->paging->printPages($this->pgScriptPath, 'listform', 'scriptDoLoadPost', 'content', '' );
            $this->set('pagingDiv', $pagingDiv);
            $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;
            
            $alertList = $this->db->select($sql);
            $this->set('pageNo', $info['pageno']);
            $this->set('pgScriptPath', $this->pgScriptPath);
            $this->set('post', $info);
            $this->set('list', $alertList);
            $this->set('alertCategory', $this->alertCategory);
            $this->render('alerts/alert_list');
        }
        
        /**
         * function to delete alert
         */
        function deleteAlert($alertId) {
            $sql = "delete from $this->tableName where id=".intval($alertId);
            $this->db->query($sql);
        }
        
        function showAlertInfo($alertId) {
            $alertInfo = $this->__getAlertInfo($alertId);
            $this->set('listInfo', $alertInfo);
            $this->set('alertCategory', $this->alertCategory);
            $this->render('alerts/alert_info');
        }
        
        function fetchAlerts($info) {
            $userId = isLoggedIn();
            if(isset($info['view'])) {
                
                if(!empty($info["view"])) {
                    $sql = "UPDATE $this->tableName SET visited=1 WHERE visited=0 and user_id=$userId";
                    $this->db->query($sql);
                }
                
                $alertList = $this->__getAllAlerts("and user_id=$userId order by visited ASC, alert_time DESC limit " . SP_PAGINGNO);
                $this->set('alertList', $alertList);
                $output = $this->getViewContent('alerts/alert_box');
                
                $sql = "SELECT count(*) count FROM $this->tableName WHERE visited=0 and user_id=$userId";
                $countInfo = $this->db->select($sql, true);
                $data = array(
                    'notification' => $output,
                    'unseen_notification'  => $countInfo['count'],
                );
                
                echo json_encode($data);
            }
            
        }
        
        /*
         * alert_type => [success|danger]
         * alert_category => [general|reports]
         */
        function createAlert($alertInfo, $userId = false, $adminAlert = false) {
                
                if (!$userId && $adminAlert) {
                        $userCtler = new UserController();
                        $adminInfo = $userCtler->__getAdminInfo();
                        $userId = $adminInfo['id'];
                }
                
                $dataList = array(
                        'user_id|int' => $userId,
                        'alert_subject' => $alertInfo['alert_subject'],
                        'alert_message' => $alertInfo['alert_message'],
                        'alert_url' => !empty($alertInfo['alert_url']) ? $alertInfo['alert_url'] : "",
                        'alert_time' => date("Y-m-d H:i:s"),
                );
                
                if (!empty($alertInfo['alert_category'])) {
                        $dataList['alert_category'] = $alertInfo['alert_category'];
                }
                
                if (!empty($alertInfo['alert_type'])) {
                        $dataList['alert_type'] = $alertInfo['alert_type'];
                }
                
                // check whether alert already exists
                $cond = "user_id=" . intval($userId) . " and alert_subject='".addslashes($dataList['alert_subject'])."'";
                $cond .= " and alert_message='".addslashes($dataList['alert_message'])."'";
                $cond .= " and date(alert_time)='".date('Y-m-d')."'";
                $existInfo = $this->dbHelper->getRow($this->tableName, $cond, "id");
                
                // if alert not exists
                if (empty($existInfo['id'])) {          
                        $this->dbHelper->insertRow($this->tableName, $dataList);
                }
        }       
        
        /**
         * function to update system alerts, eg: installation uptodate etc
         */
        function updateSystemAlerts() {
            
            // installation version check
            if (in_array(date('d'), [1, 7, 14])) {
                
                $informationCtrler = new InformationController();
                $check_info = $informationCtrler->__getTodayInformation('install_check');
                if (empty($check_info)) {
                $cond = "and alert_subject='" .addslashes($this->installAlertSubject). "' and date(alert_time)='". date("Y-m-d"). "'";
                $alertList = $this->__getAllAlerts($cond);
    
                // check the installation version
                if (empty($alertList)) {
                    $settingCtrler = new SettingsController();
                    $settingCtrler->spTextSettings = $this->getLanguageTexts('settings', $_SESSION['lang_code']);
                    list($oldVersion, $message) = $settingCtrler->checkVersion(true);
    
                    // if current version is old
                    if ($oldVersion) {
                        $alertInfo = array(
                            'alert_subject' => $this->installAlertSubject,
                            'alert_message' => $message,
                            'alert_type' => "danger",
                        );
                        $this->createAlert($alertInfo, false, true);
                        $informationCtrler->updateTodayInformation($message, "install_check");
                        return ['status' => true, 'result' => "Installation version is old."];
                    } else {
                        $informationCtrler->updateTodayInformation($message, "install_check");
                        return ['status' => false, 'result' => "Installation version is uptodate."];    
                    }
                }
                }
                
                return ['status' => false, 'result' => "Installation version check is already done."];
            } else {
                return ['status' => false, 'result' => "Skip installation version check due to date."];
            }
        }
}
?>