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