Subversion Repositories cheapmusic

<?php
/**
 * Copyright(C) 2009-2019 www.seopanel.in. All rights reserved.
 * @author Geo Varghese 
 * 
 */
class SD_Manager extends SeoDiary {
        
        var $cronJob = false;
        var $statusList;

        function __construct() {
                parent::__construct();
                parent::initPlugin(true);
                $this->statusList = array(
                        'new' => $this->pluginText['New'],
                        'closed' => $this->pluginText['Closed'],
                        'cancelled' => $this->pluginText['Cancelled'],
                        'inprogress' => $this->pluginText['Inprogress'],
                        'blocked' => $this->pluginText['Blocked'],
                        'feedback' => $this->pluginText['Feedback'],
                );
        }
        
        function showSDList($info = "") {
                $userId = isLoggedIn ();
                $this->set ( 'post', $info );
                $cond = "";
                
                $projectCtrler = $this->createHelper ( 'Project' );
                $projectList = $projectCtrler->__getAllProjects ( $userId, true );
                $this->set ( 'projectList', $projectList );
                
                if (!isAdmin ()) {
                    if (SD_ALLOW_USER_PROJECTS) {
                        $prjIdList = [0];
                        foreach ($projectList as $projectInfo) $prjIdList[] = $projectInfo['id'];
                        $cond .= " and d.project_id in (".implode(',', $prjIdList).")";
                    } else {
                        $cond .= " and d.assigned_user_id=$userId";
                    }
                }
                
                $cond .= !empty( $info ['project_id'] ) ? " and d.project_id=" . intval ( $info ['project_id'] ) : "";
                $cond .= !empty( $info ['category_id'] ) ? " and d.category_id=" . intval ( $info ['category_id'] ) : "";
                $cond .= !empty( $info ['assigned_user_id'] ) ? " and d.assigned_user_id=" . intval ( $info ['assigned_user_id'] ) : "";
                $cond .= !empty( $info ['keyword'] ) ? " and (title LIKE '%" . addslashes ( $info ['keyword'] ) . "%' OR d.description LIKE '%" . addslashes ( $info ['keyword'] ) . "%')" : "";
                $cond .= !empty( $info ['status'] ) ? " and d.status='" . addslashes( $info ['status'] ) ."'" : "";
                $cond .= !empty( $info ['sort_col'] ) ? " order by " . addslashes ( $info ['sort_col'] ) : "";
                $cond .= !empty( $info ['sort_val'] ) ? " " . addslashes ( $info ['sort_val'] ) : "";
                
                $info ['user_id'] = intval ( $info ['assigned_user_id'] );
                $pgScriptPath = PLUGIN_SCRIPT_URL . "&action=diaryManager";
                $sql = "select d.*,p.name project_name, c.label category_label from sd_seo_diary d, sd_category c, sd_projects p 
                        where d.project_id=p.id and d.category_id=c.id $cond ";
                
                $userCtrler = new UserController ();
                $userList = $userCtrler->__getAllUsers ();
                $this->set( 'userList', $userList );
                $userIdList = [];
                
                foreach ( $userList as $userInfo ) {
                        $userIdList [$userInfo ['id']] = $userInfo;
                }
                
                $this->set ( 'userIdList', $userIdList );
                $categoryList = $this->selectDiaryCategory ();
                $this->set ( 'categoryList', $categoryList );
                $this->set( 'statusList', $this->statusList);
                
                // pagination setup
                $this->db->query ( $sql, true );
                $this->paging->setDivClass ( 'pagingdiv' );
                $this->paging->loadPaging ( $this->db->noRows, SP_PAGINGNO );
                $pagingDiv = $this->paging->printPages ( $pgScriptPath, 'searchform', 'scriptDoLoadPost', 'content', '');
                $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->pluginRender ( 'diary_manager' );
        }
        
        /*
         * func to create new project
         */
        function newDiary($info = '') {
                $userId = isLoggedIn ();
                $userCtrler = new UserController ();
                $userList = $userCtrler->__getAllUsers ();
                $this->set ( 'userList', $userList );
                
                $projectCtrler = $this->createHelper ( 'Project' );
                $projectList = $projectCtrler->__getAllProjects ( $userId, true );
                $this->set ( 'projectList', $projectList );
                
                $categoryList = $this->selectDiaryCategory ();
                $this->set ( 'categoryList', $categoryList );
                $this->set( 'statusList', $this->statusList);
                $this->set ( 'spTextReport', $this->getLanguageTexts('report', $_SESSION['lang_code']));
                $this->pluginRender ( 'new_diary' );
        }
        
        /*
         * func to create diary
         */
        function createDiary($listInfo) {
            $this->set ( 'post', $listInfo );
            $now = date('Y-m-d H:i:s');
                $errMsg ['project_id'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['project_id'] ) );
                $errMsg ['category_id'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['category_id'] ) );
                $errMsg ['title'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['title'] ) );
                $errMsg ['description'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['description'] ) );
                $errMsg ['status'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['status'] ) );
                
                if (! $this->validate->flagErr) {
                    
                    if ($this->__checkTitle ($listInfo ['title'], $listInfo ['project_id'] )) {
                        $errMsg ['title'] = formatErrorMsg ($this->pluginText['Diary already exist']);
                        $this->validate->flagErr = true;
                    }
                    
                    if (!$this->validate->flagErr) {
                    $listInfo['created_user_id'] = isLoggedIn();
                    $listInfo['update_time'] = $now;
                    $listInfo['creation_time'] = $now;
                        $this->insertDiary($listInfo);
                        $this->showSDList(['keyword' => $listInfo ['title']]);
                        exit();
                    }
                }
                
                $this->set('errMsg', $errMsg );
                $this->newDiary( $listInfo );
        }       
        
        function insertDiary($listInfo) {
            $sql = "INSERT INTO `sd_seo_diary`(`project_id`, `assigned_user_id`, `category_id`, `title`, `description`, `due_date`, `status`, 
                    `email_notification`, `creation_time`, `update_time`, `created_user_id`)
                                        VALUES('" . intval ( $listInfo ['project_id'] ) . "', '" . intval ( $listInfo ['assigned_user_id'] ) . "',
                                        '" . intval ( $listInfo ['category_id'] ) . "',  '" . addslashes ( $listInfo ['title'] ) . "',
                                        '" . addslashes ( $listInfo ['description'] ) . "', '" . addslashes ( $listInfo ['due_date'] ) . "',
                                        '" . addslashes ( $listInfo ['status'] ) . "', ".intval($listInfo['email_notification']).", 
                    '" . addslashes ( $listInfo ['creation_time'] ) . "', '" . addslashes ( $listInfo ['creation_time'] ) . "', ".intval($listInfo['created_user_id']).")";
            $this->db->query( $sql );
            
            // email notification enabled, send mail
            if (!empty($listInfo['email_notification']) && !empty($listInfo ['assigned_user_id'])) {
            $this->sendNotificationMail($listInfo);        
            }
            
        }
        
        function sendNotificationMail($listInfo) {
            $userId = $listInfo ['assigned_user_id'];
            $subject = $this->pluginText['Assigned to You'] . ": " . $listInfo['title'];
            $userController = new UserController ();
            $userInfo = $userController->__getUserInfo ( $userId );
            $userName = $userInfo ['first_name'] . "-" . $userInfo ['last_name'];
            $adminInfo = $userController->__getAdminInfo();
            $adminName = $adminInfo['first_name']."-".$adminInfo['last_name'];
            $this->set ( 'userName', $userName );
            $this->set ( 'listInfo', $listInfo);
            $content = $this->getPluginViewContent('notification_mail');
            
            if (sendMail( $adminInfo ['email'], $adminName, $userInfo['email'], $subject, $content )) {
                showSuccessMsg("Notifiaction Mail send successfully to " . $userInfo ['email'], FALSE);
            } else {
                showErrorMsg('An internal error occured while sending mail!', FALSE);
            }
        }
        
        /*
         * func to edit diary
         */
        function editDiary($diaryId, $listInfo = '') {
                
                if (!empty( $diaryId )) {
                        
                        if (empty($listInfo )) {
                                $listInfo = $this->__getDiaryInfo ( $diaryId );
                        }
                        
                        $this->set ( 'post', $listInfo );
                        $userCtrler = new UserController ();
                        $userList = $userCtrler->__getAllUsers ();
                        $this->set ( 'userList', $userList );
                        
                        $userId = isLoggedIn ();
                        $projectCtrler = $this->createHelper ( 'Project' );
                        $projectList = $projectCtrler->__getAllProjects ( $userId, true );
                        $this->set ( 'projectList', $projectList );
                        
                        $categoryList = $this->selectDiaryCategory ();
                        $this->set ( 'categoryList', $categoryList );
                        $this->set( 'statusList', $this->statusList);
                        $this->set ( 'spTextReport', $this->getLanguageTexts('report', $_SESSION['lang_code']));
                        $this->pluginRender ( 'edit_diary' );
                }
        }
        
        /*
         * func to update project
         */
        function updateDiary($listInfo) {               
                $this->set ( 'post', $listInfo );
                $errMsg = [];
                $errMsg ['project_id'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['project_id'] ) );
                $errMsg ['category_id'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['category_id'] ) );
                $errMsg ['title'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['title'] ) );
                $errMsg ['description'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['description'] ) );
                $errMsg ['status'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['status'] ) );
                
                if (! $this->validate->flagErr) {
                        
                    if ($this->__checkTitle ( $listInfo ['title'], $listInfo ['project_id'], $listInfo ['id'] )) {
                        $errMsg ['title'] = formatErrorMsg ($this->pluginText['Diary already exist']);
                                $this->validate->flagErr = true;
                        }
                        
                        if (! $this->validate->flagErr) {
                            $oldDiaryInfo = $this->__getDiaryInfo($listInfo ['id']);
                                $sql = "update sd_seo_diary set project_id = " . intval ( $listInfo ['project_id'] ) . ", category_id = " . intval ( $listInfo ['category_id'] ) . 
                                    ", title = '" . addslashes ( $listInfo ['title'] ) . "', description = '" . addslashes ( $listInfo ['description'] ) . 
                                    "', assigned_user_id = '" . intval ( $listInfo ['assigned_user_id'] ) . "', due_date = '" . addslashes ( $listInfo ['due_date'] ) . 
                                    "', update_time = '" . date ( "Y-m-d H:i:s" ) . "', status = '" . addslashes ( $listInfo ['status'] ) . "' where id=" . intval ( $listInfo ['id'] );
                                $this->db->query ( $sql );
                                
                                // email notification enabled, send mail
                                if (!empty($listInfo['email_notification']) && !empty($listInfo ['assigned_user_id'])) {
                                    if ($oldDiaryInfo['assigned_user_id'] != $listInfo ['assigned_user_id']) {
                                        $this->sendNotificationMail($listInfo);
                                    }
                                }
                                
                                $this->showSDList(['keyword' => $listInfo ['title']]);
                                exit();
                        }
                        
                }
                
                $this->set ( 'errMsg', $errMsg );
                $this->editDiary( $listInfo ['id'], $listInfo );
        }
        
        /*
         * func to delete project
         */
        function deleteDiary($diaryId) {
                $diaryId = intval ( $diaryId );
                $sql = "delete from sd_seo_diary where id=" . intval ( $diaryId );
                $this->db->query ( $sql );
                $this->showSDList ();
        }
        
        function getUserDiaryList($userId) {
            $cond = "";
            $userId = intval($userId);
            
            if (!isAdmin()) {
                if (SD_ALLOW_USER_PROJECTS) {
                    $projectCtrler = $this->createHelper ( 'Project' );
                    $projectList = $projectCtrler->__getAllProjects ( $userId, true );
                    $prjIdList = [0];
                    foreach ($projectList as $projectInfo) $prjIdList[] = $projectInfo['id'];
                    $cond .= " project_id in (".implode(',', $prjIdList).")";
                } else {
                    $cond .= " assigned_user_id=$userId";
                }
            }
            
            $diaryList = $this->dbHelper->getAllRows('sd_seo_diary', $cond);
            return $diaryList;
        }       
        
        /*
         * func to create new comments
         */
        function newDiaryComments($info = '') {
                $this->set ( 'post', $info );
                $userId = isLoggedIn();
                
                $diaryList = $this->getUserDiaryList($userId);
                $this->set ( 'diaryList', $diaryList );
                
                if (empty($info['diary_id'] )) {
                    $diaryId = $diaryList[0]['id'];
                } else {
                        $diaryId = intval($info['diary_id']);
                }
                
                if (empty($diaryId)) {
                    showErrorMsg($_SESSION['text']['common']['No Records Found']);
                }

                $diaryInfo = $this->__getDiaryInfo($diaryId);
                $this->set ('diaryInfo', $diaryInfo );
                $this->set ('diaryId', $diaryId );
                
                $userCtrler = new UserController ();
                $userList = $userCtrler->__getAllUsers();
                $userIdList = [];
                foreach ( $userList as $userInfo ) $userIdList [$userInfo ['id']] = $userInfo;
                $this->set ( 'userIdList', $userIdList );
                
                $diaryCommentList = $this->getDiaryComments( " and diary_id=" . intval($diaryId));
                $this->set ( 'diaryCommentList', $diaryCommentList );   
                $this->pluginRender ( 'diary_comments' );
        }
        
        /*
         * func to create project
         */
        function createDiaryComment($listInfo) {
            $userId = isLoggedIn ();
            $this->set ( 'post', $listInfo );
            $errMsg ['diary_id'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['diary_id'] ) );
            $errMsg ['comments'] = formatErrorMsg ( $this->validate->checkBlank ( $listInfo ['comments'] ) );
            
            if (! $this->validate->flagErr) {
                $sql = "INSERT INTO `sd_diary_comments`( `diary_id`, `user_id`, `comments`,  `updated_time`) 
                    VALUES ('" . intval ( $listInfo ['diary_id'] ) . "','" . intval ( $userId ) . "',
                                        '" . addslashes ( $listInfo ['comments'] ) . "','". date("Y-m-d H:i:s")."')";
                $this->db->query ( $sql );
                $this->newDiaryComments(['diary_id' =>  $listInfo ['diary_id']]);
                exit ();
            }
            
            $this->set ('errMsg', $errMsg );
            $this->newDiaryComments ( $listInfo );
        }
        
        /*
         * func to project shummary
         */
        function showProjectSummery($info = '') {
                $this->set ( 'post', $info );
                $userId = isLoggedIn ();
                $projectCtrler = $this->createHelper ( 'Project' );
                $projectList = $projectCtrler->__getAllProjects ( $userId, true );
                $this->set ( 'projectList', $projectList );
                
                if (empty($info['project_id'] )) {
                        $projectId = $projectList[0]['id'];
                } else {
                        $projectId = intval($info['project_id']);
                }
                
                if (empty($projectId)) {
                    showErrorMsg($_SESSION['text']['common']['No Records Found']);
                }
                
                $projectInfo = $projectCtrler->__getProjectInfo($projectId);
                $this->set('projectInfo', $projectInfo);
                
                $diaryList = $this->__getDiaryList(" project_id = " . intval($projectId));
                foreach ( $diaryList as $i => $listInfo ) {
                        $diaryList[$i]['comment_count'] = $this->getDiarytCommentCount($listInfo['id']);
                }
                
                $this->set ( 'diaryList', $diaryList );
                $this->set ( 'spTextSA', $this->getLanguageTexts('siteauditor', $_SESSION['lang_code']));               
                $this->pluginRender ( 'project_summery' );
        }
        
        /*
         * show tasks assigned users
         */
        function showTaskList($info = "") {
                $this->set ( 'post', $info );
                $userId = isLoggedIn ();
                $cond .= " and d.assigned_user_id=$userId";
                
                $cond .= !empty( $info ['project_id'] ) ? " and d.project_id=" . intval ( $info ['project_id'] ) : "";
                $cond .= !empty( $info ['keyword'] ) ? " and (title LIKE '%" . addslashes ( $info ['keyword'] ) . "%' OR d.description LIKE '%" . addslashes ( $info ['keyword'] ) . "%')" : "";
                $cond .= !empty( $info ['status'] ) ? " and d.status='" . addslashes( $info ['status'] ) ."'" : "";
                $cond .= !empty( $info ['sort_col'] ) ? " order by " . addslashes ( $info ['sort_col'] ) : "";
                $cond .= !empty( $info ['sort_val'] ) ? " " . addslashes ( $info ['sort_val'] ) : "";
                
                $info ['user_id'] = intval ( $info ['assigned_user_id'] );
                $pgScriptPath = PLUGIN_SCRIPT_URL . "&action=myTasks";
                $sql = "select d.*,p.name project_name, c.label category_label from sd_seo_diary d, sd_category c, sd_projects p 
                        where d.project_id=p.id and d.category_id=c.id $cond ";
                
                $userCtrler = new UserController ();
                $userList = $userCtrler->__getAllUsers ();
                $this->set ( 'userList', $userList );
                $userIdList = [ ];
                
                foreach ( $userList as $userInfo ) {
                        $userIdList [$userInfo ['id']] = $userInfo;
                }
                
                $this->set ( 'userIdList', $userIdList );
                
                $projectCtrler = $this->createHelper ( 'Project' );
                $projectList = $projectCtrler->__getAllProjects ( $userId, true );
                $this->set ( 'projectList', $projectList );
                
                $categoryList = $this->selectDiaryCategory ();
                $this->set ( 'categoryList', $categoryList );
                $this->set ( 'statusList', $this->statusList );
                
                // pagination setup
                $this->db->query ( $sql, true );
                $this->paging->setDivClass ( 'pagingdiv' );
                $this->paging->loadPaging ( $this->db->noRows, SP_PAGINGNO );
                $pagingDiv = $this->paging->printPages ( $pgScriptPath, 'searchform', 'scriptDoLoadPost', 'content', '');
                $this->set ( 'pagingDiv', $pagingDiv );
                $sql .= " limit " . $this->paging->start . "," . $this->paging->per_page;
                
                $taskList = $this->db->select ( $sql );
                $this->set ( 'list', $taskList );
                $this->set ( 'pageNo', $_GET ['pageno'] );
                $this->pluginRender ( 'my_task' );
        }
        
        /*
         * func to get all category type
         */
        function getDiaryComments($condtions = '') {
                $sql = "select * from sd_diary_comments where 1=1";
                $sql .= empty( $condtions ) ? "" : $condtions;
                $diaryCommentList = $this->db->select( $sql );
                return $diaryCommentList;
        }
        
        /*
         * func to get all category type
         */
        function selectDiaryCategory($condtions = '') {
                $sql = "select id, label from sd_category";
                $sql .= empty ( $condtions ) ? "" : $condtions;
                $categoryList = $this->db->select ( $sql );
                return $categoryList;
        }
        
        /*
         * func to get all category type
         */
        function getDiarytCommentCount($diaryId) {
            $diaryCountInfo = $this->dbHelper->getRow('sd_diary_comments', "diary_id=".intval($diaryId), "count(*) count");
            return !empty($diaryCountInfo['count']) ? $diaryCountInfo['count'] : 0;
        }
        
        /*
         * function to check name of project already existing
         */
        function __checkTitle($title, $projectId, $diaryId = 0) {
                $diaryId = intval ( $diaryId );
                $sql = "select id from sd_seo_diary where title='" . addslashes ( $title ) . "' and project_id=".intval($projectId);
                $sql .= !empty( $diaryId ) ? " and id!=$diaryId" : "";
                $listInfo = $this->db->select ( $sql, true );
                return empty ( $listInfo ['id'] ) ? false : $listInfo ['id'];
        }
        
        /*
         * func to get project info
         */
        function __getDiaryInfo($diaryId) {
                $sql = "select d.*,p.name project_name from sd_seo_diary d,sd_projects p where d.project_id=p.id and d.id=" . intval ( $diaryId );
                $info = $this->db->select ( $sql, true );
                return $info;
        }
        
        function __getDiaryList($cond = '') {
            $diaryList = $this->dbHelper->getAllRows('sd_seo_diary', $cond);
            return $diaryList;
        }

        /*function startCronJob() {
                $this->cronJob = true;
                $sql = "SELECT `id`,`assigned_user_id`, `due_date`, `status` FROM `sd_seo_diary` WHERE `status`= 'new' or `sd_seo_diary`.`status`='inprogress'";
                $diaryList = $this->db->select($sql);

                if (count($diaryList) > 0) {
                        foreach ($diaryList as $diaryListInfo) {
                                $diaryId =$diaryListInfo['id'];
                                $this->generateDairyList($diaryId);
                                
                        }
                } else {
                        echo "Diary List generated for all the projects!";
                }

        }

        function generateDairyList($diaryId) {  

                $datetime = new DateTime(date('Y-m-d'));
                $datetime->modify('+1 day');
                $datetime->format('Y-m-d');
                $diaryInfo = $this->__getDiaryInfo($diaryId);


            if (($diaryInfo['status'] == "new" || "inprogress") || ($diaryInfo['due_date'] > $datetime)) {
                        $userId = $diaryInfo ['assigned_user_id'];
                    $subject = "your assingned diary was changed";
                    $content = $this->getViewContent('mailview', 'ajax', false);
                    $userController = new UserController ();
                    $userInfo = $userController->__getUserInfo ( $userId );
                    $adminInfo = $userController->__getAdminInfo ();
                    $userName = $userInfo ['first_name'] . "-" . $userInfo ['last_name'];
                    $this->set ( 'userName', $userName );
                    
                if (! sendMail ( $adminInfo ['email'], $userName, $userInfo ['email'], $subject, $content )) {
                echo "Reports send successfully to " . $userInfo ['email'] . "\n";
                } else {
                        echo 'An internal error occured while sending mail!';
                       }
             ?><br><?php print $adminInfo ['email']; 
                                     print  $userName;
                                     print  $userInfo ['email'];
                                     print  $subject;
                                     print  $content;
         }
                }*/
                
}