public function execute($request) { $projectId = $request->getParameter("projectId"); $timesheetDao = new TimesheetDao(); $this->noProjectActivity = "no"; if ($projectId == -1) { $this->activityList = "All"; } else { $this->activityList = $timesheetDao->getProjectActivitiesByPorjectId($projectId); $this->allActivityList = $timesheetDao->getProjectActivitiesByPorjectId($projectId, true); if ($this->allActivityList == null) { $this->noProjectActivity = "yes"; } } }
public function executeGetRelatedActiviesForAutoCompleteAjax(sfWebRequest $request) { $this->backAction = $this->getContext()->getUser()->getFlash('actionName'); $this->getContext()->getUser()->setFlash('actionName', $this->backAction); $customerName = $request->getParameter('customerName'); $projectName = $request->getParameter('projectName'); // $projectName = htmlspecialchars($projectName, ENT_QUOTES); // $customerName = htmlspecialchars($customerName, ENT_QUOTES); $timesheetDao = new TimesheetDao(); $customer = $timesheetDao->getCustomerByName($customerName); $customerId = $customer->getCustomerId(); $project = $timesheetDao->getProjectByProjectNameAndCustomerId($projectName, $customerId); $projectId = $project->getProjectId(); $this->activityList = $timesheetDao->getProjectActivitiesByPorjectId($projectId); }
/** * Gets all the names of available projects, including deleted projects. * @return array() $projectNameList */ private function _getDataList() { $activityNameList = array(); $projectService = new ProjectService(); $projectList = $projectService->getActiveProjectList(); $projectId = -1; foreach ($projectList as $project) { $projectId = $project->getProjectId(); break; } $timesheetDao = new TimesheetDao(); $activityList = $timesheetDao->getProjectActivitiesByPorjectId($projectId); if ($activityList != null) { $activityNameList[-1] = __("All"); } else { $activityNameList[null] = "--" . __("No Project Activities") . "--"; } return $activityNameList; }