public function post_ajaxsearch()
{
$data = Input::get('data');
parse_str($data, $post);
$query = $post['searchInput'];
$like = '%' . $query . '%';
if (is_Numeric($query)) {
//Since it is numeric we are probably sorting by a CID. Let's try to find VAs by CID with this number
$vas = User::where('cid', 'like', $like)->orderBy('cid', 'ASC')->get();
} else {
//Hmm maybe they are trying to find a VA by name or by the name of the owner or URL
$vas = User::where('name', 'like', $like)->orWhere('url', 'like', $like)->orWhere('email', 'like', $like)->orWhere('vaname', 'like', $like)->orWhere('url', 'like', $like)->orderBy('vaname', 'ASC')->get();
}
if (count($vas) > 0) {
//Format our output
$send = '';
foreach ($vas as $va) {
$status = User::formatUserStatus($va->status);
$flags = "";
if ($va->awaiting_response == 1) {
$flags = '<span class="label label-warning"><i class="fa fa-info fa-fw"></i> Awaiting Response</span>';
}
$send .= "<tr><td>{$va->vaname}</td><td>{$status}</td><td>{$flags}</td><td>{$va->url}</td><td>{$va->cid}</td><td>{$va->name}</td><td>{$va->created_at}</td><td><a class=\"searchEditVABtn\" href=\"" . URL::route('console') . "/va/" . $va->cid . "\"><i class=\"fa fa-edit fa-fw\"</a></td></tr>";
}
} else {
$send = '0';
}
echo $send;
}
