public function editAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $sess_vals = $auth->getStorage()->read(); $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $messages['message'] = ''; $id = $this->getRequest()->getParam('id', null); $projectsModel = new Default_Model_Createprojects(); $requi_model = new Default_Model_Requisition(); $usersModel = new Default_Model_Users(); $where = ""; $actionflag = 1; $form = new Default_Form_createprojects(); $form->setAttrib('action', DOMAIN . 'createprojects/edit/id/' . $id); $this->view->business_units_list = $requi_model->getBusinessUnits(); try { if ($id > 0 && is_numeric($id)) { //update code $where = ""; $actionflag = 2; $id = abs($id); $projectdata = $projectsModel->getProjectDataByID($id); $form->submit->setLabel('Update Project'); $this->view->loginuserGroup = $loginuserGroup; $this->view->form = $form; $this->view->isEdit = "1"; $this->view->data = $projectdata; $this->view->BUUsers = $usersModel->getAllActiveUsersByBU($projectdata['businessunit']); $this->view->TrackingCodes = $projectsModel->getTrackingCodesByCategory($projectdata['category']); if ($this->getRequest()->getPost()) { $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //$tprojectCategory = $this->_getParam('projectCategory', null); $tprojectCategory = PROJECTCATEGORYID; $tProjectName = $this->_getParam('ProjectName', null); $tProjectDescription = $this->_getParam('ProjectDescription', null); $tprojectStatus = $this->_getParam('projectStatus', null); $tprojectBU = $this->_getParam('projectBU', null); $tprojectPrimaryLead = $this->_getParam('projectPrimaryLead', null); $tprojectSecondaryLead = $this->_getParam('projectSecondaryLead', null); $tprojectEffort = $this->_getParam('ProjectEffort', null); $tprojectStartDate = $this->_getParam('projectStartDate', null); $tprojectEndDate = $this->_getParam('projectEndDate', null); $tprojectStartDate1 = sapp_Global::change_date(trim($tprojectStartDate), 'database'); $tprojectEndDate1 = sapp_Global::change_date(trim($tprojectEndDate), 'database'); $tprojectStartDate2 = sapp_Global::change_date(trim($projectdata['startdate']), 'database'); $tprojectEndDate2 = sapp_Global::change_date(trim($projectdata['enddate']), 'database'); //get tracking codes for edits $ttrackingcodestartdate = $this->_getParam('trackingcodestartdate', null); $ttrackingcodeenddate = $this->_getParam('trackingcodeenddate', null); $ttrackingcodeeffort = $this->_getParam('trackingcodeeffort', null); if ($tprojectStartDate2 != $tprojectStartDate1 && ($ttrackingcodestartdate <= 0 || $ttrackingcodestartdate == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Start Date.")); $validationMsg['message'] = 'Tracking code due to change in Project Planned Start Date.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectEndDate2 != $tprojectEndDate1 && ($ttrackingcodeenddate <= 0 || $ttrackingcodeenddate == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned End Date.")); $validationMsg['message'] = 'Tracking code due to change in Project Planned End Date.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($projectdata['effort'] != $tprojectEffort && ($ttrackingcodeeffort <= 0 || $ttrackingcodeeffort == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Effort.")); $validationMsg['message'] = 'Tracking code due to change in Project Planned Effort.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tProjectName)) <= 0) { $validationMsg['message'] = 'Project name cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tProjectDescription)) <= 0) { $validationMsg['message'] = 'Project description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tprojectStartDate)) <= 0) { $validationMsg['message'] = 'Project planned start date cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tprojectEndDate)) <= 0) { $validationMsg['message'] = 'Project planned end date cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectBU <= 0) { $validationMsg['message'] = 'Please select project business unit.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectPrimaryLead <= 0) { $validationMsg['message'] = 'Project primary lead cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectSecondaryLead <= 0) { $validationMsg['message'] = 'Project secondary lead cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tprojectEffort)) <= 0) { $validationMsg['message'] = 'Project planned effort cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } } } } if ($bFlag) { $mpolicydata = array('category' => trim($tprojectCategory), 'projectname' => trim($tProjectName), 'description' => trim($tProjectDescription), 'status' => trim($tprojectStatus), 'effort' => trim($tprojectEffort), 'startdate' => $tprojectStartDate1, 'enddate' => $tprojectEndDate1, 'businessunit' => trim($tprojectBU), 'primarylead' => trim($tprojectPrimaryLead), 'secondarylead' => trim($tprojectSecondaryLead), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id = ?' => $id); $Id = $projectsModel->SaveorUpdatePolicyData($mpolicydata, $where); if ($projectdata['startdate'] != $tprojectStartDate1 || $projectdata['enddate'] != $tprojectEndDate1 || $projectdata['effort'] != $tprojectEffort) { $projectslogModel = new Default_Model_Createprojectslog(); $mprojectlogdata = array('projectid' => trim($projectdata['id']), 'startdatetrackingcodeid' => trim($ttrackingcodestartdate), 'enddatetrackingcodeid' => trim($ttrackingcodeenddate), 'efforttrackingcodeid' => trim($ttrackingcodeeffort), 'effortold' => trim($projectdata['effort']), 'startdateold' => $tprojectStartDate2, 'enddateold' => $projectdata['enddate'], 'effortnew' => $tprojectEndDate2, 'startdatenew' => $tprojectStartDate1, 'enddatenew' => $tprojectEndDate1, 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s")); $where = ""; $Id = $projectslogModel->SaveorUpdateData($mprojectlogdata, $where); } //if ($Id == 'update') { $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully updated.")); /* } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while updating project details.")); } */ $trDb->commit(); $this->_redirect('/createprojects'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/createprojects'); } } } else { //Insert code $actionflag = 1; if ($this->getRequest()->getPost()) { #$result = $this->save($form, $policydata); $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; $tprojectCategory = PROJECTCATEGORYID; $tProjectName = $this->_getParam('ProjectName', null); $tProjectDescription = $this->_getParam('ProjectDescription', null); $tprojectStartDate = $this->_getParam('projectStartDate', null); $tprojectEndDate = $this->_getParam('projectEndDate', null); $tprojectStatus = $this->_getParam('projectStatus', null); $tprojectBU = $this->_getParam('projectBU', null); $tprojectPrimaryLead = $this->_getParam('projectPrimaryLead', null); $tprojectSecondaryLead = $this->_getParam('projectSecondaryLead', null); $tprojectEffort = $this->_getParam('ProjectEffort', null); $tprojectStartDate1 = sapp_Global::change_date(trim($tprojectStartDate), 'database'); $tprojectEndDate1 = sapp_Global::change_date(trim($tprojectEndDate), 'database'); if (strlen(trim($tProjectName)) <= 0) { $validationMsg['message'] = 'Project name cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tProjectDescription)) <= 0) { $validationMsg['message'] = 'Project description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tprojectStartDate)) <= 0) { $validationMsg['message'] = 'Project planned start date cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tprojectEndDate)) <= 0) { $validationMsg['message'] = 'Project planned end date cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectBU <= 0) { $validationMsg['message'] = 'Please select project business unit.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectPrimaryLead <= 0) { $validationMsg['message'] = 'Project primary lead cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectSecondaryLead <= 0) { $validationMsg['message'] = 'Project secondary lead cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($tprojectEffort)) <= 0) { $validationMsg['message'] = 'Project planned effort cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } if ($bFlag) { $mpolicydata = array('category' => trim($tprojectCategory), 'projectname' => trim($tProjectName), 'description' => trim($tProjectDescription), 'status' => trim($tprojectStatus), 'effort' => trim($tprojectEffort), 'startdate' => sapp_Global::change_date(trim($tprojectStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($tprojectEndDate), 'database'), 'businessunit' => trim($tprojectBU), 'primarylead' => trim($tprojectPrimaryLead), 'secondarylead' => trim($tprojectSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $Id = $projectsModel->SaveorUpdatePolicyData($mpolicydata, $where); if ($Id > 0 && is_numeric($Id)) { $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully added.")); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding project details.")); } $trDb->commit(); $this->_redirect('/createprojects'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/createprojects'); } } $mdata = array('category' => PROJECTCATEGORYID, 'projectname' => trim($tProjectName), 'description' => trim($tProjectDescription), 'status' => trim($tprojectStatus), 'effort' => trim($tprojectEffort), 'startdate' => $tprojectStartDate1, 'enddate' => $tprojectEndDate1, 'businessunit' => trim($tprojectBU), 'primarylead' => trim($tprojectPrimaryLead), 'secondarylead' => trim($tprojectSecondaryLead)); $buUsers = array(); if ($tprojectBU > 0) { $buUsers = $usersModel->getAllActiveUsersByBU($tprojectBU); } $this->view->BUUsers = $buUsers; $form->submit->setLabel('Add Project'); $this->view->loginuserGroup = $loginuserGroup; $this->view->form = $form; $this->view->data = $mdata; $this->view->isEdit = "0"; } } catch (Exception $e) { $this->view->nodata = 'nodata'; } $this->view->messages = $this->_helper->flashMessenger->getMessages(); }
public function editAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $sess_vals = $auth->getStorage()->read(); $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $messages['message'] = ''; $id = $this->getRequest()->getParam('id', null); $taskModel = new Default_Model_Createtasks(); $currprojectsModel = new Default_Model_Createprojects(); $activityModel = new Default_Model_Createactivities(); $requi_model = new Default_Model_Requisition(); $usersModel = new Default_Model_Users(); $currentUserSummary = $usersModel->getEmployeeSummaryByID($loginUserId); $taskAllocationModel = new Default_Model_Tasksallocation(); $where = ""; $actionflag = 1; $form = new Default_Form_createprojects(); $form->setAttrib('action', DOMAIN . 'createtasks/edit/id/' . $id); //$this->view->activeprojects = $taskModel->getActiveProjects(); $this->view->activeprojects = $taskAllocationModel->getActiveProjectsForTasksForUser($currentUserSummary['businessunit_id'], $loginUserId, $loginuserGroup); $this->view->projectCategories = $taskModel->getProjectCategories(); $this->view->business_units_list = $requi_model->getBusinessUnits(); $this->view->allusers = array(); //$this->view->allusers = $usersModel->getAllActiveUsers(); try { if ($id > 0 && is_numeric($id)) { //update code $where = ""; $actionflag = 2; $id = abs($id); $taskdata = $taskModel->getTaskDataByID($id); $Currprojectdata = $currprojectsModel->getProjectDataByID($taskdata['projectid']); $form->submit->setLabel('Update Task'); $this->view->taskpagerefresh = '0'; $this->view->TaskID = $id; $this->view->loginuserGroup = $loginuserGroup; $this->view->form = $form; $this->view->isEdit = "1"; $this->view->data = $taskdata; $this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']); $this->view->TrackingCodes = $currprojectsModel->getTrackingCodesByCategory($Currprojectdata['category']); if ($this->getRequest()->getPost()) { $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //Task Details $tprojectSelected = $this->_getParam('projectSelected', null); $ttaskName = $this->_getParam('taskName', null); $ttaskDescription = $this->_getParam('taskDescription', null); $ttaskStartDate = $this->_getParam('taskStartDate', null); $ttaskEndDate = $this->_getParam('taskEndDate', null); $ttaskStatus = $this->_getParam('taskStatus', null); $ttaskPrimaryLead = $this->_getParam('taskPrimaryLead', null); $ttaskSecondaryLead = $this->_getParam('taskSecondaryLead', null); $ttaskEffort = $this->_getParam('taskEffort', null); //Task Activity Details $tprjactivitytaskid = $this->_getParam('prjactivitytaskid', null); $tprjactivityid = $this->_getParam('prjactivityid', null); $tprjactivitysdate = $this->_getParam('prjactivitysdate', null); $tprjactivityedate = $this->_getParam('prjactivityedate', null); $tprjactivityeffort = $this->_getParam('prjactivityeffort', null); $tprojectStartDate1 = sapp_Global::change_date(trim($ttaskStartDate), 'database'); $tprojectEndDate1 = sapp_Global::change_date(trim($ttaskEndDate), 'database'); $tprojectStartDate2 = sapp_Global::change_date(trim($taskdata['startdate']), 'database'); $tprojectEndDate2 = sapp_Global::change_date(trim($taskdata['enddate']), 'database'); //get tracking codes for edits $ttrackingcodestartdate = $this->_getParam('trackingcodestartdate', null); $ttrackingcodeenddate = $this->_getParam('trackingcodeenddate', null); $ttrackingcodeeffort = $this->_getParam('trackingcodeenddate', null); $mtaskactivitytrackingdata = array('startdate' => implode(',', $ttrackingcodestartdate), 'enddate' => implode(',', $ttrackingcodeenddate), 'effort' => implode(',', $ttrackingcodeeffort)); $this->view->taskactivitytrackingdata = $mtaskactivitytrackingdata; $this->view->taskpagerefresh = '1'; if ($tprojectStartDate2 != $tprojectStartDate1 && ($ttrackingcodestartdate <= 0 || $ttrackingcodestartdate == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Start Date.")); $validationMsg['message'] = 'Tracking code due to change in Task Planned Start Date.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectEndDate2 != $tprojectEndDate1 && ($ttrackingcodeenddate <= 0 || $ttrackingcodeenddate == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned End Date.")); $validationMsg['message'] = 'Tracking code due to change in Task Planned End Date.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($taskdata['effort'] != $ttaskEffort && ($ttrackingcodeeffort <= 0 || $ttrackingcodeeffort == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Effort.")); $validationMsg['message'] = 'Tracking code due to change in Task Planned Effort.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectSelected <= 0) { $validationMsg['message'] = 'Please select project.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskName)) <= 0) { $validationMsg['message'] = 'Task name cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskDescription)) <= 0) { $validationMsg['message'] = 'Task description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskStartDate)) <= 0) { $validationMsg['message'] = 'Task startdate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEndDate)) <= 0) { $validationMsg['message'] = 'Task enddate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEffort)) <= 0) { $validationMsg['message'] = 'Task effort cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskPrimaryLead <= 0) { $validationMsg['message'] = 'Please select primary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskSecondaryLead <= 0) { $validationMsg['message'] = 'Please select secondary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } } } } if ($bFlag) { $mpolicydata = array('projectid' => trim($tprojectSelected), 'taskname' => trim($ttaskName), 'description' => trim($ttaskDescription), 'status' => trim($ttaskStatus), 'effort' => trim($ttaskEffort), 'startdate' => sapp_Global::change_date(trim($ttaskStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($ttaskEndDate), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $taskModel->SaveorUpdateData($mpolicydata, $where); if ($tprojectStartDate2 != $tprojectStartDate1 || $tprojectEndDate2 != $tprojectEndDate1 || $taskdata['effort'] != $ttaskEffort) { $taskslogModel = new Default_Model_Createtaskslog(); $mprojectlogdata = array('taskid' => trim($taskdata['id']), 'startdatetrackingcodeid' => trim($ttrackingcodestartdate), 'enddatetrackingcodeid' => trim($ttrackingcodeenddate), 'efforttrackingcodeid' => trim($ttrackingcodeeffort), 'effortold' => trim($taskdata['effort']), 'startdateold' => $tprojectStartDate2, 'enddateold' => $tprojectEndDate2, 'effortnew' => $ttaskEffort, 'startdatenew' => $tprojectStartDate1, 'enddatenew' => $tprojectEndDate1, 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s")); $where = ""; $Id = $taskslogModel->SaveorUpdateData($mprojectlogdata, $where); } //update Task Activities $currRow = 0; foreach ($tprjactivityid as $tprjactid) { $mactivitydata = array('effort' => trim($tprjactivityeffort[$currRow]), 'startdate' => sapp_Global::change_date(trim($tprjactivitysdate[$currRow]), 'database'), 'enddate' => sapp_Global::change_date(trim($tprjactivityedate[$currRow]), 'database'), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $tprjactivitytaskid[$currRow]); $Id1 = $activityModel->SaveorUpdateData($mactivitydata, $where); $currRow = $currRow + 1; } $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Task details successfully modified.")); $trDb->commit(); $this->_redirect('/createtasks'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/createtasks'); } } } else { //Insert code $actionflag = 1; if ($this->getRequest()->getPost()) { #$result = $this->save($form, $policydata); $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //Task Details $tprojectSelected = $this->_getParam('projectSelected', null); $ttaskName = $this->_getParam('taskName', null); $ttaskDescription = $this->_getParam('taskDescription', null); $ttaskStartDate = $this->_getParam('taskStartDate', null); $ttaskEndDate = $this->_getParam('taskEndDate', null); $ttaskStatus = $this->_getParam('taskStatus', null); $ttaskPrimaryLead = $this->_getParam('taskPrimaryLead', null); $ttaskSecondaryLead = $this->_getParam('taskSecondaryLead', null); $ttaskEffort = $this->_getParam('taskEffort', null); //Task Activity Details $tprjactivityid = $this->_getParam('prjactivityid', null); $tprjactivitysdate = $this->_getParam('prjactivitysdate', null); $tprjactivityedate = $this->_getParam('prjactivityedate', null); $tprjactivityeffort = $this->_getParam('prjactivityeffort', null); $tprjactivitysdate1 = implode(',', $tprjactivitysdate); $mtaskactivitytrackingdata = array('startdate' => implode(',', $tprjactivitysdate), 'enddate' => implode(',', $tprjactivityedate), 'effort' => implode(',', $tprjactivityeffort)); $this->view->taskactivitytrackingdata = $mtaskactivitytrackingdata; $this->view->taskpagerefresh = '1'; if ($tprojectSelected <= 0) { $validationMsg['message'] = 'Please select project.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskName)) <= 0) { $validationMsg['message'] = 'Task name cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskDescription)) <= 0) { $validationMsg['message'] = 'Task description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskStartDate)) <= 0) { $validationMsg['message'] = 'Task startdate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEndDate)) <= 0) { $validationMsg['message'] = 'Task enddate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEffort)) <= 0) { $validationMsg['message'] = 'Task effort cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskPrimaryLead <= 0) { $validationMsg['message'] = 'Please select primary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskSecondaryLead <= 0) { $validationMsg['message'] = 'Please select secondary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } $mpolicydata = array('projectid' => trim($tprojectSelected), 'taskname' => trim($ttaskName), 'description' => trim($ttaskDescription), 'status' => trim($ttaskStatus), 'effort' => trim($ttaskEffort), 'startdate' => sapp_Global::change_date(trim($ttaskStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($ttaskEndDate), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($bFlag) { $Id = $taskModel->SaveorUpdateData($mpolicydata, $where); if ($Id > 0 && is_numeric($Id)) { //Insert Task Activities $currRow = 0; foreach ($tprjactivityid as $tprjactid) { $mactivitydata = array('taskid' => trim($Id), 'activityid' => trim($tprjactid), 'status' => trim($ttaskStatus), 'effort' => trim($tprjactivityeffort[$currRow]), 'startdate' => sapp_Global::change_date(trim($tprjactivitysdate[$currRow]), 'database'), 'enddate' => sapp_Global::change_date(trim($tprjactivityedate[$currRow]), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $currRow = $currRow + 1; $Id1 = $activityModel->SaveorUpdateData($mactivitydata, $where); } $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully added.")); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding project details.")); } $trDb->commit(); $this->_redirect('/createtasks'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/createtasks'); } } if ($tprojectSelected > 0) { $Currprojectdata = $currprojectsModel->getProjectDataByID($tprojectSelected); $this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']); } $form->submit->setLabel('Add Task'); $this->view->loginuserGroup = $loginuserGroup; $this->view->TaskID = "0"; $this->view->form = $form; $this->view->isEdit = "0"; $this->view->data = $mpolicydata; } } catch (Exception $e) { $this->view->nodata = 'nodata'; } }
public function editAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $sess_vals = $auth->getStorage()->read(); $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $messages['message'] = ''; $id = $this->getRequest()->getParam('id', null); $meetingRoom = new Default_Model_Meetingroom(); $taskModel = new Default_Model_Createtasks(); $currprojectsModel = new Default_Model_Createprojects(); $activityModel = new Default_Model_Createactivities(); $requi_model = new Default_Model_Requisition(); $usersModel = new Default_Model_Users(); $currentUserSummary = $usersModel->getEmployeeSummaryByID($loginUserId); $taskAllocationModel = new Default_Model_Tasksallocation(); $where = ""; $actionflag = 1; $form = new Default_Form_createprojects(); //$form = new Default_Form_createprojects(); $form->setAttrib('action', DOMAIN . 'meetingroomblock/edit/id/' . $id); $this->view->activeprojects = $taskModel->getActiveProjects(); $this->view->activeprojects = $taskAllocationModel->getActiveProjectsForTasksForUser($currentUserSummary['businessunit_id'], $loginUserId, $loginuserGroup); $this->view->projectCategories = $taskModel->getProjectCategories(); $this->view->business_units_list = $meetingRoom->getBusinessUnits(); $this->view->meetingrooms = $meetingRoom->getActiveMeetingRooms(); $this->view->allusers = array(); //$this->view->allusers = $usersModel->getAllActiveUsers(); try { if ($id > 0 && is_numeric($id)) { //update code $where = ""; $actionflag = 2; $id = abs($id); $meetingdata = $meetingRoom->getMeetingRoomDataByID($id); // $Currprojectdata = $currprojectsModel->getProjectDataByID($taskdata['projectid']); $form->submit->setLabel('Update Meeting'); $this->view->taskpagerefresh = '0'; $this->view->MeetingRoomID = $id; $this->view->loginuserGroup = $loginuserGroup; $this->view->form = $form; $this->view->isEdit = "1"; $this->view->data = $meetingdata; $this->view->delta_recipents_list = $meetingRoom->getRecipentsByBU($meetingdata['businessunit']); if ($this->getRequest()->getPost()) { $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //Meeting Room Details $deltameetingrooms = $this->_getParam('deltameetingrooms', null); $meetingDate = $this->_getParam('meetingDate', null); $meetingStartTime = $this->_getParam('meetingStartTime', null); $meetingEndTime = $this->_getParam('meetingEndTime', null); $projectBU = $this->_getParam('projectBU', null); $buResources = $this->_getParam('buResources', null); $clientrecipients = $this->_getParam('clientrecipients', null); $meetingtitle = $this->_getParam('meetingtitle', null); $meetingnotes = $this->_getParam('meetingnotes', null); $deltaOwnerResource = $this->_getParam('deltaOwnerResource', null); $clientOwnerResource = $this->_getParam('clientOwnerResource', null); if ($deltameetingrooms <= 0) { $validationMsg['message'] = 'Please select meetingroom.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingDate)) <= 0) { $validationMsg['message'] = 'Meeting Date cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingStartTime)) <= 0) { $validationMsg['message'] = 'Meeting Start Time cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingEndTime)) <= 0) { $validationMsg['message'] = 'Meeting End Time cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (count($projectBU) <= 0) { $validationMsg['message'] = 'Please select Business Unit.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (count($buResources) <= 0) { $validationMsg['message'] = 'Please select Recipients.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingtitle)) <= 0) { $validationMsg['message'] = 'Title cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingnotes)) <= 0) { $validationMsg['message'] = 'Description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($deltaOwnerResource <= 0) { $validationMsg['message'] = 'Please select Delta Owner.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } } if ($bFlag) { $mpolicydata = array('roomid' => trim($deltameetingrooms), 'blockmeetingdate' => trim($meetingDate), 'blockmeetingstarttime' => sapp_Global::change_time(trim($meetingStartTime) . 'database'), 'blockmeetingendtime' => sapp_Global::change_time(trim($meetingEndTime), 'database'), 'businessunit' => implode(',', $projectBU), 'createdby' => trim($loginUserId), 'title' => trim($meetingtitle), 'clientrecipients' => trim($clientrecipients), 'deltarecipients' => implode(',', $buResources), 'createddate' => gmdate("Y-m-d H:i:s"), 'description' => trim($meetingnotes), 'deltaowner' => trim($deltaOwnerResource), 'clientowner' => trim($clientOwnerResource), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id = ?' => $id); $Id = $meetingRoom->SaveorUpdateData($mpolicydata, $where); $this->sendInvite(implode(',', $buResources), $loginUserId, trim($meetingDate), trim($meetingStartTime), trim($meetingEndTime), $id, $meetingnotes, $meetingtitle); $menuID = 99; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully updated.")); /* } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while updating project details.")); } */ $trDb->commit(); $this->_redirect('/meetingroomblock'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/meetingroomblock'); } } } else { //Insert code $actionflag = 1; if ($this->getRequest()->getPost()) { #$result = $this->save($form, $policydata); $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //Meeting Room Details $deltameetingrooms = $this->_getParam('deltameetingrooms', null); $meetingDate = $this->_getParam('meetingDate', null); $meetingStartTime = $this->_getParam('meetingStartTime', null); $meetingEndTime = $this->_getParam('meetingEndTime', null); $projectBU = $this->_getParam('projectBU', null); $buResources = $this->_getParam('buResources', null); $clientrecipients = $this->_getParam('clientrecipients', null); $meetingtitle = $this->_getParam('meetingtitle', null); $meetingnotes = $this->_getParam('meetingnotes', null); $deltaOwnerResource = $this->_getParam('deltaOwnerResource', null); $clientOwnerResource = $this->_getParam('clientOwnerResource', null); if ($deltameetingrooms <= 0) { $validationMsg['message'] = 'Please select meetingroom.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingDate)) <= 0) { $validationMsg['message'] = 'Meeting Date cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingStartTime)) <= 0) { $validationMsg['message'] = 'Meeting Start Time cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingEndTime)) <= 0) { $validationMsg['message'] = 'Meeting End Time cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (count($projectBU) <= 0) { $validationMsg['message'] = 'Please select Business Unit.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (count($buResources) <= 0) { $validationMsg['message'] = 'Please select Recipients.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingtitle)) <= 0) { $validationMsg['message'] = 'Title cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($meetingnotes)) <= 0) { $validationMsg['message'] = 'Description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($deltaOwnerResource <= 0) { $validationMsg['message'] = 'Please select Delta Owner.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } } $mpolicydata = array('roomid' => trim($deltameetingrooms), 'blockmeetingdate' => trim($meetingDate), 'blockmeetingstarttime' => sapp_Global::change_time(trim($meetingStartTime), 'database'), 'blockmeetingendtime' => sapp_Global::change_time(trim($meetingEndTime), 'database'), 'businessunit' => implode(',', $projectBU), 'createdby' => trim($loginUserId), 'title' => trim($meetingtitle), 'clientrecipients' => trim($clientrecipients), 'deltarecipients' => implode(',', $buResources), 'createddate' => gmdate("Y-m-d H:i:s"), 'description' => trim($meetingnotes), 'deltaowner' => trim($deltaOwnerResource), 'clientowner' => trim($clientOwnerResource), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($bFlag) { $Id = $meetingRoom->SaveorUpdateData($mpolicydata, $where); $this->sendInvite(implode(',', $buResources), $loginUserId, trim($meetingDate), trim($meetingStartTime), trim($meetingEndTime), $Id, $meetingnotes, $meetingtitle); $menuID = 99; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully added.")); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding project details.")); } $trDb->commit(); $this->_redirect('/meetingroomblock'); } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/meetingroomblock'); } } if ($tprojectSelected > 0) { $Currprojectdata = $currprojectsModel->getProjectDataByID($tprojectSelected); $this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']); } $form->submit->setLabel('Add Task'); $this->view->loginuserGroup = $loginuserGroup; $this->view->TaskID = "0"; $this->view->form = $form; $this->view->isEdit = "0"; $this->view->data = $mpolicydata; } } catch (Exception $e) { $this->view->nodata = 'nodata'; } }