PHP Cliente::where方法代码示例

 public function getFiltro()
 {
     $input = Input::all();
     $filtro = $input['filtro'];
     $buscar = $input['buscar'];
     $clientes = array();
     if ($filtro == 'nit') {
         $clientes = Cliente::where('nit', 'like', '%' . $buscar . '%')->paginate(10);
     } elseif ($filtro == 'nombre') {
         $clientes = Cliente::where('nombre', 'like', '%' . $buscar . '%')->paginate(10);
     }
     $mensaje = 'Clientes que contienen <strong>' . $buscar . '</strong> en el ' . strtoupper($filtro);
     Session::flash('mensajeOk', $mensaje);
     return View::make('clientes.listado')->with(compact('clientes', 'input'));
 }

 function putIdPushByCliente(Request $request, Response $response)
 {
     $response = $response->withHeader('Content-type', 'application/json');
     $email = $request->getAttribute('email');
     $data = json_decode($request->getBody(), true);
     try {
         $cliente = Cliente::where('email', '=', $email)->first();
         $cliente->idPush = $data['idPush'];
         $cliente->save();
         $respuesta = json_encode(array('msg' => "Modificado correctamente", "std" => 1, "obj" => $cliente));
         $response = $response->withStatus(200);
     } catch (Exception $err) {
         $respuesta = json_encode(array('msg' => "Error al modificar", "std" => 0, "err" => $err->getMessage()));
         $response = $response->withStatus(404);
     }
     $response->getBody()->write($respuesta);
     return $response;
 }

 public function changePass($id = null)
 {
     if (is_null($id) or !is_numeric($id)) {
         return Redirect::to('404.html');
     } else {
         $cliente = Cliente::where('id', '=', $id)->firstOrFail();
         if (is_object($cliente)) {
             $cliente->pasword = Input::get('password');
             return View::make('cliente.change_pass', array('cliente' => $cliente));
         } else {
             return Redirect::to('404.html');
         }
     }
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $clientes = Cliente::where('farmacia_id', 1)->orderBy('created_at', 'dsc')->get();
     // dd($clientes);
     return Response::json($clientes, 200);
 }

 private function verificarCliente($identificacion)
 {
     return $cliente = Cliente::where('identificacion', $identificacion)->first();
 }

@foreach(@$cuadrilla as $data)
<?php 
$verificar = Cliente::where('saldo', '>', '0')->where('cuadrilla_id', '=', $data->id)->get();
?>
@if(count($verificar) > 0)
<?php 
$total = 0;
?>
<div align="center">
	<h3> {{ $data->cuadrilla }} {{ $data->caporal }} </h3>
</div>
<table class="table">
	<thead>
		<tr>
			<th width="14%" style="text-align: center;">DPI</th>
			<th width="23%" style="text-align: center;">Nombre</th>
			<th width="23%" style="text-align: center;">Direccion Actual</th>
			<th width="9%" style="text-align: center;">Telefono</th>
			<th width="10%" style="text-align: center;">Saldo</th>
			<th width="5%" style="text-align: center;">D.P</th>
			<th width="4%" style="text-align: center;">D.V</th>
			<th width="12%" style="text-align: center;">Pago</th>
		</tr>
	</thead>
	<tbody>
		@foreach(@$data->clientes as $cliente)
		@if($cliente->saldo > 0 )
		<?php 
$dias = DB::table('pagos')->select(DB::raw("DATEDIFF(current_date,max(created_at)) as dias"))->where('cliente_id', '=', $cliente->id)->first();
$diasV = DB::table('ventas')->select(DB::raw("DATEDIFF(current_date,max(created_at)) as dias"))->where('cliente_id', '=', $cliente->id)->first();

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

 public function search()
 {
     $modalidad = Modalidad::lists('id', 'monto');
     $pago = Pagos::max('id');
     $id = Input::get('id_cliente');
     if (is_null($id) or !is_numeric($id)) {
         return Redirect::to('404.html');
     } else {
         $cliente = Cliente::where('id', '=', $id)->firstOrFail();
         if (is_object($cliente)) {
             return View::make('pagos.showCliente', array('cliente' => $cliente, 'modalidad' => $modalidad, 'pago' => $pago));
             //return Redirect::to('pagos/create')->withErrors($respuesta['mensaje'] )->withInput();
             //return Redirect::to('pagos/create/',array('cliente'=>$cliente,'modalidad'=>$modalidad));
         } else {
             return Redirect::to('404.html');
         }
     }
 }

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