public function tasksAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$projectTasksData = $projectData = array();
$projectId = $this->getRequest()->getParam('projectid', null);
if ($this->getRequest()->getPost()) {
$taskprojectIds = $this->getRequest()->getParam('hid_taskprojid');
$projectId = $this->getRequest()->getParam('project_id');
$taskIds = $this->getRequest()->getParam('hid_taskid');
$projectTaskData = array();
$projectTasksModel = new Timemanagement_Model_Projecttasks();
if (count($taskprojectIds) > 0) {
foreach ($taskprojectIds as $key => $taskProjectId) {
$projectTaskData = array('project_id' => trim($projectId), 'task_id' => trim($taskIds[$key]), 'is_active' => 1, 'modified_by' => $loginUserId, 'modified' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $taskProjectId);
$projectTasksModel->SaveorUpdateProjectTaskData($projectTaskData, $where);
}
}
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Task(s) updated successfully."));
$this->_redirect('timemanagement/projects/tasks/projectid/' . $projectId);
}
$projectResourcesModel = new Timemanagement_Model_Projectresources();
$checkResourceExistsforProject = $projectResourcesModel->checkProjectResource($projectId, $loginUserId);
if ($loginUserId == 1 || $checkResourceExistsforProject > 0) {
try {
if (is_numeric($projectId) && $projectId > 0) {
$projectTasksModel = new Timemanagement_Model_Projecttasks();
$projectTasksData = $projectTasksModel->getProjectTasksData($projectId);
$projectModel = new Timemanagement_Model_Projects();
$projectData = $projectModel->getSingleProjectData($projectId);
if ($projectTasksData == 'norows') {
$this->view->projectData = $projectData;
$this->view->rowexist = "norows";
$this->view->messages = $this->_helper->flashMessenger->getMessages();
} else {
if (!empty($projectTasksData)) {
$this->view->rowexist = "rows";
$this->view->projectData = $projectData;
$this->view->projectTasksData = $projectTasksData;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
}
} else {
$this->view->projectData = 'norows';
$this->view->projectTasksData = 'norows';
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
} else {
$this->view->projectData = 'norows';
$this->view->projectTasksData = 'norows';
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
}
public function resourcetaskassigndeleteAction()
{
$dresource_model = new Timemanagement_Model_Projectresources();
$task_resource_model = new Timemanagement_Model_Projecttaskresources();
$projectId = $this->_getParam('projectId');
$employeeId = $this->_getParam('employeeId');
$checkedTasks = $this->_getParam('chekedtaskids');
$uncheckedTasks = $this->_getParam('uncheckedtaskids');
$checkedTaskIds = json_decode($checkedTasks);
$uncheckedTasksIds = json_decode($uncheckedTasks);
$allTaskIdsArray = array();
$project_task_id = array();
$inserted_count = 0;
$updated_count = 0;
$getAllTasks = $dresource_model->getAllTasks($projectId);
//get all tasks for perticuler project
foreach ($getAllTasks as $task_id) {
$allTaskIdsArray[] = $task_id['task_id'];
$project_task_id[$task_id['task_id']] = $task_id['id'];
}
$assignedTasks = $dresource_model->getassignedTasks($projectId, $employeeId);
$assignedTaskIds = array();
$resourceProjectTaskPrimaryId = array();
if (count($assignedTasks) > 0) {
foreach ($assignedTasks as $id) {
$assignedTaskIds[] = $id['task_id'];
$resourceProjectTaskPrimaryId[$id['task_id']] = $id['id'];
}
}
$unAssignedTasks = array();
foreach ($allTaskIdsArray as $tId) {
if (!in_array($tId, $assignedTaskIds)) {
$unAssignedTasks[] = $tId;
}
}
//user selected to delete tasks from resources
//compare previoues assigned tasks and selected to delete tasks
if (count($uncheckedTasksIds) > 0) {
foreach ($uncheckedTasksIds as $ckedId) {
if (in_array($ckedId, $assignedTaskIds)) {
$is_updated = $task_resource_model->assignTasks($ckedId, $projectId, $employeeId, $resourceProjectTaskPrimaryId[$ckedId], $for_update = 1);
if ($is_updated == 'update') {
$updated_count++;
}
}
}
}
if (count($checkedTaskIds) > 0) {
foreach ($checkedTaskIds as $taskId) {
if (in_array($taskId, $unAssignedTasks)) {
//insert tasks in employee_tasks table
$isTaskAssigned = $task_resource_model->isTaskAssigned($projectId, $taskId, $employeeId);
if ($isTaskAssigned == 0) {
$is_inserted = $task_resource_model->assignTasks($taskId, $projectId, $employeeId, $project_task_id[$taskId]);
if ($is_inserted > 0) {
$inserted_count++;
}
}
}
}
}
//$this->_helper->json(array('message'=>'success','status'=>$updated_count.' Tasks deleted successfully,'.$inserted_count.' Tasks assigned successfully.'));
$this->_helper->json(array('message' => 'success', 'status' => 'Tasks list updated successfully.'));
}
public function viewAction()
{
$auth = Zend_Auth::getInstance();
$loginUserId = 0;
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->getRequest()->getParam('id');
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$objName = 'employeeprojects';
$projectModel = new Timemanagement_Model_Projects();
$projectTaskModel = new Timemanagement_Model_Projecttasks();
$projectResourcesModel = new Timemanagement_Model_Projectresources();
try {
if (is_numeric($id) && $id > 0) {
$data = $projectModel->getSingleProjectData($id);
if (!empty($data) && $data != "norows") {
$data_arr = array();
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$dashboardcall = $this->_getParam('dashboardcall');
//$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($refresh == 'refresh') {
$sort = 'DESC';
$by = 'modified';
$perPage = DASHBOARD_PERPAGE;
$pageNo = 1;
$searchData = '';
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'tpe.modified';
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
$pageNo = $this->_getParam('page', 1);
$searchData = $this->_getParam('searchData');
}
$role = Zend_Registry::get('tm_role');
$dataTmp = $projectTaskModel->getEmpTaskGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $id, $loginUserId, $role);
$dataTmp['emptyRoles'] = '';
$dataTmp['objectname'] = 'leadprojects';
$dataTmp['dataemptyFlag'] = '';
$dataTmp['menuName'] = 'Tasks';
$dataTmp['dashboardcall'] = 'Yes';
$dataTmp['projectId'] = $id;
array_push($data_arr, $dataTmp);
$by = 'modified';
$projectResourcesModel = new Timemanagement_Model_Projectresources();
$dataResourceTmp = $projectResourcesModel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $id, $loginUserId, $role);
$dataResourceTmp['emptyRoles'] = '';
$dataResourceTmp['objectname'] = 'projectresources';
$dataResourceTmp['dataemptyFlag'] = '';
$dataResourceTmp['menuName'] = 'Resources';
$dataResourceTmp['dashboardcall'] = 'Yes';
$dataResourceTmp['projectId'] = $id;
array_push($data_arr, $dataResourceTmp);
$this->view->data_arr = $data_arr;
$this->view->controllername = $objName;
$this->view->data = $data;
$this->view->id = $id;
$this->view->ermsg = '';
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'nodata';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
}