sd_manager.ctrl.php

<?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();
		$this->setPluginTextsForRender ( $this->textCategory, $this->textTable );
		$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 or d.created_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;
         }
		}*/
		
}