function searchProviders(Request $request)
 {
     $search = $request->input('search');
     $users = User::where('role_id', 2) > where(function ($query) use($search) {
         $query->Where('name', 'like', '%' . $search . '%')->orWhere('last_name', 'like', '%' . $search . '%')->orWhere('email', $search)->orWhere('second_name', 'like', '%' . $search . '%')->orWhere('second_last_name', 'like', '%' . $search . '%')->orWhere('identification', 'like', '%' . $search . '%');
     })->paginate(50);
     $roleName = $this->roleName;
     $routeSearch = 'searchProvider';
     return view('back.users', compact('users', 'roleName', 'routeSearch', 'search'));
 }
Beispiel #2
0
 public function insertPayResult($inputs)
 {
     $data = [];
     /*foreach (Session::get('cart') as $item) {
     
                 if(!$item->offers)
                     $value = $item->price;
                 else
                     $value = (Carbon::now()->between(new Carbon($item->offers->offer_on), new Carbon($item->offers->offer_off)))
                         ? $item->offers->offer_price
                         : $item->price;
     
                 $data[$item->id] = ['quantity' => $item->quantity, 'state_order_id' => 2, 'value' => $value];
             }*/
     $user = User::where('identification', $inputs['id_cliente'])->first();
     $order = Order::create(['identification_client' => $inputs['id_cliente'], 'user_id' => $user->id, 'address_client' => $inputs['campo1'], 'zp_buy_id' => $inputs['id_pago'], 'zp_buy_token' => $inputs['ticketID'], 'zp_state' => $inputs['estado_pago']]);
     $user->orders()->save($order);
     $order->products()->attach($data);
     if ($inputs['estado_pago']) {
         Session::forget('cart');
         Session::forget('valueTotal');
     }
 }
 function showClients()
 {
     $users = User::where('role_id', '=', 4)->with('client')->paginate(10);
     return view('back.clients', compact('users'));
 }