PHP Customer::whereId方法代码示例

 public function update(Request $request, $id)
 {
     $customer = Customer::whereId($id)->first();
     $customer->fill($request->all());
     $customer->push();
     return redirect('/customer/' . $id . '/show')->with('status', Alert::get('success', 'Informationen är uppdaterad.'));
 }

 public function update(Request $request, $id)
 {
     $customer = Customer::whereId($id)->firstOrFail();
     $customer->customer = $request->get('customer');
     $customer->street = $request->get('street');
     $customer->city = $request->get('city');
     $customer->state = $request->get('state');
     $customer->zip = $request->get('zip');
     $customer->save();
     Toastr::success('Customer updated.');
     return redirect(action('CustomersController@index', $customer->{$customer}));
 }

 public function show($id)
 {
     $order = Order::whereId($id)->firstOrFail();
     $coffee1 = DB::table('coffees')->where('id', 2)->first();
     $coffee2 = DB::table('coffees')->where('id', 3)->first();
     $coffee3 = DB::table('coffees')->where('id', 4)->first();
     $coffee4 = DB::table('coffees')->where('id', 5)->first();
     $coffee5 = DB::table('coffees')->where('id', 6)->first();
     $pastry1 = DB::table('pastries')->where('id', 7)->first();
     $pastry2 = DB::table('pastries')->where('id', 10)->first();
     $pastry3 = DB::table('pastries')->where('id', 11)->first();
     $pastry4 = DB::table('pastries')->where('id', 12)->first();
     $pastry5 = DB::table('pastries')->where('id', 15)->first();
     $total = 0;
     for ($i = 1; $i < 6; $i++) {
         $total = ${'coffee' . $i}->price * $order->{'coffee' . $i} + ${'pastry' . $i}->price * $order->{'pastry' . $i} + $total;
     }
     $user = \Auth::user();
     $customer = Customer::whereId($order->customerid)->firstOrFail();
     return view('order.show', compact('order', 'coffee1', 'coffee2', 'coffee3', 'coffee4', 'coffee5', 'pastry1', 'pastry2', 'pastry3', 'pastry4', 'pastry5', 'total', 'user', 'customer'));
 }

 public function postCustomerEdit(NewCustomerRequest $request, Customer $customer, CustomerProfile $profile, Payment $payment)
 {
     $id = $request->input('customer_id');
     $this->customer = $customer->whereId((int) $id)->update(['firstname' => Str::title($request->input('firstname')), 'lastname' => Str::title($request->input('lastname')), 'email' => Str::lower($request->input('email')), 'phone' => $request->input('phone')]);
     $dob = explode('/', $request->input('dob'));
     $dob_piece = [$dob[2], $dob[1], $dob[0]];
     $this->profile = $profile->where('customer_id', (int) $id)->update(['dob' => implode('-', $dob_piece), 'gender_id' => $request->input('gender'), 'state_id' => $request->input('state_of_origin'), 'hostel_address' => $request->input('hostel_address'), 'guardian_name' => Str::words($request->input('guardian_name')), 'guardian_phone' => $request->input('guardian_phone'), 'guardian_address' => $request->input('guardian_address')]);
     $this->payment = $payment->where('customer_id', (int) $id)->update(['account_balance' => $request->input('account_balance')]);
     if (!$this->customer && !$this->profile) {
         flash()->error('An error occurred, try updating the Customer again!');
     } else {
         flash()->success('Customer Updated Successfully!');
     }
     return redirect()->route('customer.list');
 }

 public function getById($id)
 {
     $customer = Customer::whereId($id)->with(['source', 'producers', 'samples' => function ($query) {
         $query->orderBy('created_at', 'desc');
     }, 'samples.assay_result'])->first();
     return $customer;
 }

 public function remainPay($id, SaleOrder $saleOrders, Request $request)
 {
     $customer = Customer::whereId($id)->first();
     $saleOrder = SaleOrder::where('sales_orders.customer_id', $id)->where("sales_orders.balance", ">", 0)->get();
     return view('saleOrders/remainPay', compact('saleOrder', 'customer'));
 }

 public function processPasteBuyerId(Request $request)
 {
     $data = $request->get('buyerIdList');
     $fileContents = trim($data);
     if (empty($fileContents)) {
         return $this->json->error('Paste Box Must Not Be Empty ...');
     }
     $fileLines = explode("\r\n", $fileContents);
     $fileLines = explode("\r", $fileContents);
     $maxLineCount = count($fileLines);
     $user = Auth::user();
     for ($x = 0; $x < $maxLineCount; $x++) {
         //dd( $fileLines[ $x ] );
         $urlArray = parse_url($fileLines[$x]);
         if (!is_array($urlArray) or !isset($urlArray['query'])) {
             continue;
         }
         parse_str($urlArray['query'], $query);
         $buyerId = $query['buyerID'];
         $orderId = $query['orderID'];
         /*$transaction = Transaction::where( 'amazon_order_id', '=', $orderId )
           ->with( ['customer.user' => function( $query ) use( $user ) {
               $query->where( 'id', '=', $user->id );
           }])->first();*/
         $transaction = Transaction::where('amazon_order_id', '=', $orderId)->first();
         if (!$transaction) {
             continue;
         }
         $customer = Customer::whereId($transaction->customer_id)->first();
         if (!$customer) {
             continue;
         }
         if ($customer->user_id != $user->id) {
             continue;
         }
         $customer->buyer_id = $buyerId;
         $customer->save();
     }
     return $this->json->success('SUCCESS!!! Import data done ....');
 }

 });
 $individualIds = array_diff($idArray, $range);
 $customers = new Collection();
 //fetch users
 if (count($range)) {
     foreach ($range as $fromTo) {
         $rangeFromTo = array_map(function ($item) {
             return trim($item);
         }, preg_split('/-/', $fromTo));
         $customers = $customers->merge(Customer::where('id', ">=", $rangeFromTo[0])->where('id', "<=", $rangeFromTo[1])->get());
     }
 }
 if (count($individualIds)) {
     foreach ($individualIds as $id) {
         $id = trim($id);
         $customers = $customers->merge(Customer::whereId($id)->get());
     }
 }
 $variableMapping = ['/\\%CHI_NAME\\%/' => "chinese_name", '/\\%ENG_NAME\\%/' => "english_name", '/\\%TODAY\\%/' => "today", '/\\%LOGIN\\%/' => "loginname", '/\\%PASSWORD\\%/' => "password"];
 $template = \App\Template::firstOrFail()->template;
 $letters = [];
 foreach ($customers as $user) {
     $letter = $template;
     foreach ($variableMapping as $pattern => $variable) {
         if ($pattern == '/\\%TODAY\\%/') {
             $today = \Carbon\Carbon::create()->toDateString();
             $letter = preg_replace($pattern, $today, $letter);
         } else {
             $letter = preg_replace($pattern, $user->{$variable}, $letter);
         }
     }

 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(Request $request, Customer $cus)
 {
     //
     $data = $request->all();
     unset($data['_token']);
     unset($data['_method']);
     $data['created_by'] = \Auth::user()->id;
     $data['updated_by'] = \Auth::user()->id;
     $data['is_active'] = 1;
     $cus->whereId(Input::get('id'))->update($data);
     return Redirect::route('customers.index');
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     $customer = Customer::whereId($id)->firstOrFail();
     $customer->delete();
     return redirect('/customers')->with('status', 'The selected customer has been deleted');
 }