/**
* This will fetch all the default task details based on the search paramerters passed with pagination.
*
* @param string $sort
* @param string $by
* @param number $perPage
* @param number $pageNo
* @param JSON $searchData
* @param string $call
* @param string $dashboardcall
* @param string $a
* @param string $b
* @param string $c
* @param string $d
*
* @return array
*/
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $a = '', $loginUserId = '', $tm_role = '', $d = '')
{
$searchQuery = $having = '';
$searchArray = array();
$data = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'tm_role') {
$having = " tm_role ='" . $val . "' ";
} else {
if ($key == 'empname') {
$searchQuery .= " e.userfullname like'%" . $val . "%' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
$objName = 'projectresources';
$projectModel = new Timemanagement_Model_Projects();
$projectData = $projectModel->getSingleProjectData($a);
$tableFields = array('empname' => 'Name', 'tm_role' => 'Role', 'viewtasks' => '');
$tablecontent = $this->getProjectResourcesGridData($sort, $by, $pageNo, $perPage, $searchQuery, $a, $loginUserId, $having);
$dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'menuName' => 'Resources', 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'call' => $call, 'dashboardcall' => $dashboardcall, 'search_filters' => array('tm_role' => array('type' => 'select', 'filter_data' => array('' => 'All', 'Manager' => 'Manager', 'Employee' => 'Employee'))));
return $dataTmp;
}
/**
* This will fetch all the default task details based on the search paramerters passed with pagination.
*
* @param string $sort
* @param string $by
* @param number $perPage
* @param number $pageNo
* @param JSON $searchData
* @param string $call
* @param string $dashboardcall
* @param string $a
* @param string $b
* @param string $c
* @param string $d
*
* @return array
*/
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $a = '', $b = '', $c = '', $d = '')
{
$searchQuery = '';
$searchArray = array();
$data = array();
$having = '';
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'actual_hrs') {
$having = " " . $key . " like '%" . $val . "%' ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
$objName = 'projecttasks';
$projectModel = new Timemanagement_Model_Projects();
$projectData = $projectModel->getSingleProjectData($a);
$tableFields = array('task' => 'Name', 'actual_hrs' => 'Actual Hours', 'viewresources' => '');
$tablecontent = $this->getProjectTaskData($sort, $by, $pageNo, $perPage, $searchQuery, $a, $having);
$dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'menuName' => 'Tasks', 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'call' => $call, 'dashboardcall' => $dashboardcall);
return $dataTmp;
}
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');
}
$dataTmp = $projectTaskModel->getEmpTaskGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $id, $loginUserId);
$dataTmp['emptyRoles'] = '';
$dataTmp['objectname'] = 'employeeprojects';
$dataTmp['dataemptyFlag'] = '';
$dataTmp['menuName'] = 'Tasks';
$dataTmp['dashboardcall'] = 'Yes';
$dataTmp['projectId'] = $id;
array_push($data_arr, $dataTmp);
$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';
}
}
public function addresourcesAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$projectResourcesModel = new Timemanagement_Model_Projectresources();
if ($this->getRequest()->getPost()) {
$type = $this->_getParam('type');
$projectId = $this->_getParam('projectId');
$projRes = $this->_getParam('projRes');
$projRes_arr = array();
if (isset($projRes) && $projRes != '') {
$projRes = trim($projRes, ",");
$projRes_arr = explode(",", $projRes);
}
foreach ($projRes_arr as $newres) {
$projectResourceData = array('project_id' => trim($projectId), 'emp_id' => trim($newres), 'created_by' => $loginUserId, 'created' => gmdate("Y-m-d H:i:s"), 'is_active' => 1, 'modified_by' => $loginUserId, 'modified' => gmdate("Y-m-d H:i:s"));
$result = $projectResourcesModel->SaveorUpdateProjectResourceData($projectResourceData, '');
}
$projectResourcesData = $projectData = array();
try {
if (is_numeric($projectId) && $projectId > 0) {
$projectModel = new Timemanagement_Model_Projects();
$projectData = $projectModel->getSingleProjectData($projectId);
$projectResourcesData = $projectResourcesModel->getProjectResourcesData($projectId);
if ($projectResourcesData == 'norows') {
$this->view->rowexist = "norows";
} else {
if (!empty($projectResourcesData)) {
$this->view->rowexist = "rows";
}
}
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
$this->view->projectData = $projectData;
$this->view->projectResourcesData = $projectResourcesData;
}
}
}
public function addtasksAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$taskModel = new Timemanagement_Model_Tasks();
$projectTasksModel = new Timemanagement_Model_Projecttasks();
$projectModel = new Timemanagement_Model_Projects();
if ($this->getRequest()->getPost()) {
$type = $this->_getParam('type');
if ($type == 'new') {
$projectId = $this->_getParam('projectId');
$task_name = $this->_getParam('task_name');
$def_check = $this->_getParam('def_check');
$projectData = $projectModel->getSingleProjectData($projectId);
$newTaskData = array('task' => trim($task_name), 'is_default' => $def_check == 'true' ? '1' : '0', 'created_by' => $loginUserId, 'created' => gmdate("Y-m-d H:i:s"), 'is_active' => 1, 'modified_by' => $loginUserId, 'modified' => gmdate("Y-m-d H:i:s"));
$insertedTaskId = $taskModel->SaveorUpdateTaskData($newTaskData, '');
if (is_numeric($insertedTaskId) && $insertedTaskId > 0) {
$projectTaskData = array('project_id' => trim($projectId), 'task_id' => trim($insertedTaskId), 'created_by' => $loginUserId, 'created' => gmdate("Y-m-d H:i:s"), 'is_active' => 1, 'modified_by' => $loginUserId, 'modified' => gmdate("Y-m-d H:i:s"));
$result = $projectTasksModel->SaveorUpdateProjectTaskData($projectTaskData, '');
}
} else {
if ($type == 'default') {
$projectId = $this->_getParam('projectId');
$taskids = $this->_getParam('taskids');
$defaultTaskIds = json_decode($taskids);
$projectData = $projectModel->getSingleProjectData($projectId);
if (count($defaultTaskIds) > 0) {
$projectTaskData = array();
foreach ($defaultTaskIds as $defTaskId) {
$projectTaskData = array('project_id' => trim($projectId), 'task_id' => trim($defTaskId), 'created_by' => $loginUserId, 'created' => gmdate("Y-m-d H:i:s"), 'is_active' => 1, 'modified_by' => $loginUserId, 'modified' => gmdate("Y-m-d H:i:s"));
$result = $projectTasksModel->SaveorUpdateProjectTaskData($projectTaskData, '');
}
}
} else {
if ($type == 'most') {
$projectId = $this->_getParam('projectId');
$taskids = $this->_getParam('taskids');
$mostTaskIds = json_decode($taskids);
$projectData = $projectModel->getSingleProjectData($projectId);
if (count($mostTaskIds) > 0) {
$projectTaskData = array();
foreach ($mostTaskIds as $mostTaskId) {
$projectTaskData = array('project_id' => trim($projectId), 'task_id' => trim($mostTaskId), 'created_by' => $loginUserId, 'created' => gmdate("Y-m-d H:i:s"), 'is_active' => 1, 'modified_by' => $loginUserId, 'modified' => gmdate("Y-m-d H:i:s"));
$result = $projectTasksModel->SaveorUpdateProjectTaskData($projectTaskData, '');
}
}
}
}
}
$projectTasksData = array();
$projectTasksData = $projectTasksModel->getProjectTasksData($projectId);
if ($projectTasksData == 'norows') {
$this->view->rowexist = "norows";
} else {
if (!empty($projectTasksData)) {
$this->view->rowexist = "rows";
}
}
$this->view->projectTasksData = $projectTasksData;
$this->view->projectId = $projectId;
}
}
}
