Subversion Repositories cheapmusic

<?php
/**
 * Copyright(C) 2009-2019 www.seopanel.in. All rights reserved.
 * @author Geo Varghese 
 * 
 */
class Project extends SeoDiary {
        
        var $spTextSA;
        var $spTextPanel;
        
        function __construct() {
                parent::__construct();
                $this->spTextSA = $this->getLanguageTexts('siteauditor', $_SESSION['lang_code']);
        }
        
        /*
         * show projects list to manage
         */
        function showProjectsManager($info = '') {
                $userId = isLoggedIn();
                $info ['user_id'] = intval( $info ['user_id'] );
                $pgScriptPath = PLUGIN_SCRIPT_URL;
                $sql = "select sdp.*, w.name as website_name from sd_projects sdp, websites w where sdp.website_id=w.id";
                
                if(isAdmin()) {
                        $userCtrler = new UserController();
                        $userList = $userCtrler->__getAllUsers();
                        $this->set( 'userList', $userList );
                        
                        $webSiteCtrler = new WebsiteController();
                        $websiteList = $webSiteCtrler->__getAllWebsites();
                        $this->set( 'websiteList', $websiteList );
                        
                        if(!empty( $info ['user_id'] )) {
                                $pgScriptPath .= "&user_id=" . $info ['user_id'];
                                $sql .= " and w.user_id=" . $info ['user_id'];
                                $this->set( 'userId', $info ['user_id'] );
                        }
                        
                        $this->set( 'isAdmin', 1 );
                } else {
                        $sql .= " and w.user_id=$userId";
                        $this->set( 'isAdmin', 0 );
                }
                
                // pagination setup
                $this->db->query( $sql, true );
                $this->paging->setDivClass( 'pagingdiv' );
                $this->paging->loadPaging( $this->db->noRows, SP_PAGINGNO );
                $pagingDiv = $this->paging->printPages( $pgScriptPath, '', 'scriptDoLoad', 'content', 'layout=ajax' );
                $this->set( 'pagingDiv', $pagingDiv );
                $sql .= " limit " . $this->paging->start . "," . $this->paging->per_page;
                
                $projectList = $this->db->select( $sql );
                $this->set( 'list', $projectList );
                $this->set( 'pageNo', $_GET ['pageno'] );
                $this->set('spTextSA', $this->spTextSA);
                $this->pluginRender( 'show_projects_manager' );
        }
        
        /*
         * func to create new project
         */
        function newProject($info = '') {
                $userId = isLoggedIn();
                $webSiteCtrler = new WebsiteController();
                $websiteList = $webSiteCtrler->__getAllWebsites( $userId, true );
                $this->set( 'websiteList', $websiteList );
                $this->pluginRender( 'new_project' );
        }
        
        /*
         * func to create project
         */
        function createProject($listInfo) {

                $this->set( 'post', $listInfo );
                $errMsg ['website_id'] = formatErrorMsg( $this->validate->checkBlank( $listInfo ['website_id'] ) );
                $errMsg ['name'] = formatErrorMsg( $this->validate->checkBlank( $listInfo ['name'] ) );
                $errMsg ['description'] = formatErrorMsg( $this->validate->checkBlank( $listInfo ['description'] ) );
                
                if(! $this->validate->flagErr) {                        
                        if(!$this->__checkProjectExists( $listInfo ['website_id'])) {
                                $sql = "insert into sd_projects(website_id, name,description,status)
                                        values(" . intval( $listInfo ['website_id'] ) . ", '" . addslashes( $listInfo ['name'] ) . "','" 
                                        . addslashes( $listInfo ['description'] ) . "',1)";
                                $this->db->query( $sql );
                                $this->showProjectsManager();
                                exit();
                        } else {
                                $errMsg ['name'] = formatErrorMsg( $this->spTextSA['projectalreadyexist'] );
                        }
                }
                
                $this->set( 'errMsg', $errMsg );
                $this->newProject( $listInfo );
        }
        
        /*
         * func to edit project
         */
        function editProject($projectId, $listInfo = '') {
                $userId = isLoggedIn();
                
                if(!empty( $projectId )) {
                        
                        if(empty( $listInfo )) {
                                $listInfo = $this->__getProjectInfo( $projectId );
                        }
                        
                        $this->set( 'post', $listInfo );
                        $webSiteCtrler = new WebsiteController();
                        $websiteList = $webSiteCtrler->__getAllWebsites( $userId, true );
                        $this->set( 'websiteList', $websiteList );
                        $this->pluginRender( 'edit_project' );
                }
        }
        
        /*
         * func to update project
         */
        function updateProject($listInfo) {

                $this->set( 'post', $listInfo );
                $errMsg ['website_id'] = formatErrorMsg( $this->validate->checkBlank( $listInfo ['website_id'] ) );
                $errMsg ['name'] = formatErrorMsg( $this->validate->checkBlank( $listInfo ['name'] ) );
                $errMsg ['description'] = formatErrorMsg( $this->validate->checkBlank( $listInfo ['description'] ) );
                
                if(! $this->validate->flagErr) {                        
                        
                        if($this->__checkProjectExists($listInfo['website_id'], $listInfo ['id'] )) {
                                $this->validate->flagErr = true;
                                $errMsg ['name'] = formatErrorMsg( $this->spTextSA['projectalreadyexist'] );
                        }
                        
                        if(! $this->validate->flagErr) {                                
                                $sql = "update sd_projects set
                                                                website_id = " . intval( $listInfo ['website_id'] ) . ",
                                                                name = '" . addslashes( $listInfo ['name'] ) . "',
                                                                description = '" . addslashes( $listInfo ['description'] ) . "'
                                                                where id=" . intval( $listInfo ['id'] );
                                $this->db->query( $sql );
                                $this->showProjectsManager();
                                exit();
                        }
                }
                
                $this->set( 'errMsg', $errMsg );
                $this->editProject( $listInfo ['id'], $listInfo );
        }
        
        /*
         * func to delete project
         */
        function deleteProject($projectId) {
                $projectId = intval( $projectId );
                $sql = "delete from sd_projects where id=" . intval( $projectId );
                $this->db->query( $sql );
                $this->showProjectsManager();
        }
        
        /*
         * func to change status
         */
        function __changeStatus($projectId, $status) {
                $projectId = intval( $projectId );
                $status = intval( $status );
                $sql = "update sd_projects set status=$status where id=$projectId";
                $this->db->query( $sql );
        }

        /*
         * function to check name of project already existing
         */
        function __checkProjectExists($websiteId, $projectId = 0) {
                $websiteId = intval( $websiteId );
                $projectId = intval($projectId);
                $sql = "select id from sd_projects where website_id=$websiteId";
                $sql .= !empty( $projectId ) ? " and id!=$projectId" : "";
                $listInfo = $this->db->select( $sql, true );
                return !empty( $listInfo ['id'] ) ? $listInfo ['id'] : false;
        }

        function __getAllProjects($userId = '', $isAdminCheck = false, $searchName = '') {
                $sql = "select p.*,w.name as website_name from sd_projects p,websites w where p.website_id=w.id ";
                if(!$isAdminCheck || !isAdmin() ){
                        if(!empty($userId)) $sql .= " and user_id=" . intval($userId);
                } 
                
                // if search string is not empty
                if (!empty($searchName)) {
                        $sql .= " and (name like '%".addslashes($searchName)."%' or url like '%".addslashes($searchName)."%')";
                }
                
                $sql .= " order by name";
                $websiteList = $this->db->select($sql);
                return $websiteList;
        }
        
        /*
         * func to get project info
         */
        function __getProjectInfo($projectId) {
                $sql = "select p.*,w.name as website_name from sd_projects p,websites w where p.website_id=w.id and p.id=" . intval( $projectId );
                $info = $this->db->select( $sql, true );
                return $info;
        }
}