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); }