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