public function executeNameSearch($request) { $this->results = array(); if ($terms = $request->getParameter('name')) { $entities = array(); $page = $request->getParameter('page', 1); $num = $request->getParameter('num', 20); $result = EntityTable::getSphinxHits($terms, $page, $num); if ($result['total_found'] > 0 && isset($result['matches'])) { $ids = array_keys($result['matches']); $db = Doctrine_Manager::connection(); $sql = 'SELECT e.*, FIELD(e.id, ' . implode(',', $ids) . ') AS field ' . 'FROM entity e WHERE e.id IN (' . implode(',', $ids) . ') AND e.is_deleted = 0 ' . 'ORDER BY field'; $stmt = $db->execute($sql); $entities = $stmt->fetchAll(PDO::FETCH_ASSOC); } foreach ($entities as $entity) { $this->results[] = array('name' => $entity['name'], 'markup' => NoteTable::getRecordMarkup($entity, $entity['name'], 'entity')); } } }
} ?> <?php $initialValue = ''; if (isset($user)) { $initialValue = NoteTable::getUserMarkup($user); } elseif (isset($record)) { if (isset($analysts)) { $handles = array(); foreach ($analysts as $analyst) { $handles[] = NoteTable::getUserMarkup($analyst); } $initialValue = "To all " . NoteTable::getRecordMarkup($record, $record->getName()) . " analysts (" . implode(", ", $handles) . "): \n"; } else { $initialValue = NoteTable::getRecordMarkup($record, $record->getName()); } } ?> <?php if (isset($networks)) { ?> <?php foreach ($networks as $network) { ?> <?php $isChecked = isset($network_ids) ? in_array($network['id'], $network_ids) : $network['id'] == sfGuardUserTable::getHomeNetworkId(); ?> <?php echo checkbox_tag('network_ids[]', $network['id'], $isChecked);