public function executeWaitlist(sfWebRequest $request) { $this->form = new ReportWaitlistForm(); if ($request->isMethod('post')) { $this->form->bind($request->getParameter($this->form->getName()), $request->getFiles($this->form->getName())); if ($this->form->isValid()) { $date = $this->form->getValue('date'); $date = mktime(0, 0, 0, $date['month'], $date['day'], $date['year']); $clientservices = ClientServicePeer::getWaiting($date); $this->wait_lists = array(); foreach ($clientservices as $client_service) { $this->wait_lists[$client_service->getOfficeId()]['location'] = $client_service->getOffice() ? $client_service->getOffice()->getName() : 'n/a'; $this->wait_lists[$client_service->getOfficeId()]['clientservices'][] = $client_service; } $this->setTemplate('waitlistReport'); } } }