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