Пример #1
0
 public function getCostumers()
 {
     //if( Request::ajax() ){
     $query = Input::get('query');
     $clientes = Cliente::where('nome', 'like', '%' . $query . '%')->orWhere('empresa', 'like', '%' . $query . '%')->get();
     $fornecedores = Fornecedor::where('nome', 'like', '%' . $query . '%')->orWhere('empresa', 'like', '%' . $query . '%')->get();
     $vendedores = Vendedor::where('nome', 'like', '%' . $query . '%')->orWhere('empresa', 'like', '%' . $query . '%')->get();
     foreach ($clientes as $cliente) {
         $suggestions[] = array("value" => $cliente->nome . " [" . $cliente->empresa . "]", "data" => array('type' => 'Clientes (' . count($clientes) . ')', 'obj' => json_encode($cliente)));
     }
     foreach ($fornecedores as $fornecedor) {
         $suggestions[] = array("value" => $fornecedor->nome . " [" . $fornecedor->empresa . "]", "data" => array('type' => 'Fornecedores (' . count($fornecedores) . ')'));
     }
     foreach ($vendedores as $vendedor) {
         $suggestions[] = array("value" => $vendedor->nome . " [" . $vendedor->empresa . "]", "data" => array('type' => 'Vendedores (' . count($vendedores) . ')'));
     }
     $costumers = array('suggestions' => $suggestions);
     //$costumers = Cliente::all();
     return Response::json($costumers);
     //}
 }
Пример #2
0
 public function getContacts()
 {
     //if( Request::ajax() ){
     $query = Input::get('query');
     $clientes = Cliente::where('email', 'like', '%' . $query . '%')->get();
     $fornecedores = Fornecedor::where('email', 'like', '%' . $query . '%')->get();
     $vendedores = Vendedor::where('email', 'like', '%' . $query . '%')->get();
     foreach ($clientes as $cliente) {
         $suggestions[] = array("value" => $cliente->email, "data" => array('type' => 'Clientes (' . count($clientes) . ')'));
     }
     foreach ($fornecedores as $fornecedor) {
         $suggestions[] = array("value" => $fornecedor->email, "data" => array('type' => 'Fornecedores (' . count($fornecedores) . ')'));
     }
     foreach ($vendedores as $vendedor) {
         $suggestions[] = array("value" => $vendedor->email, "data" => array('type' => 'Vendedores (' . count($vendedores) . ')'));
     }
     $contacts = array('suggestions' => $suggestions);
     //$contacts = Cliente::all();
     return Response::json($contacts);
     //}
 }