質問編集履歴

コードの追加

2020/08/04 08:15

投稿

ORyohei

スコア18

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -210,80 +210,444 @@
 at TransformsRequest->handle()
-in Pipeline.php line 163
-at Pipeline->Illuminate\Pipeline\{closure}()
-in Pipeline.php line 53
-at Pipeline->Illuminate\Routing\{closure}()
-in TransformsRequest.php line 21
-at TransformsRequest->handle()
-in Pipeline.php line 163
-at Pipeline->Illuminate\Pipeline\{closure}()
-in Pipeline.php line 53
-at Pipeline->Illuminate\Routing\{closure}()
-in ValidatePostSize.php line 27
-at ValidatePostSize->handle()
-in Pipeline.php line 163
-at Pipeline->Illuminate\Pipeline\{closure}()
-in Pipeline.php line 53
-at Pipeline->Illuminate\Routing\{closure}()
-in CheckForMaintenanceMode.php line 62
-at CheckForMaintenanceMode->handle()
-in Pipeline.php line 163
-at Pipeline->Illuminate\Pipeline\{closure}()
-in Pipeline.php line 53
-at Pipeline->Illuminate\Routing\{closure}()
-in TrustProxies.php line 57
-at TrustProxies->handle()
-in Pipeline.php line 163
-at Pipeline->Illuminate\Pipeline\{closure}()
-in Pipeline.php line 53
-at Pipeline->Illuminate\Routing\{closure}()
-in Pipeline.php line 104
-at Pipeline->then()
-in Kernel.php line 151
-at Kernel->sendRequestThroughRouter()
-in Kernel.php line 116
-at Kernel->handle()
-in index.php line 55
 ```
+UserController.php
+```ここに言語を入力
+<?php
+namespace App\Http\Controllers;
+use Illuminate\Support\Facades\Mail;
+use Illuminate\Validation\Rule;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Storage;
+use Illuminate\Support\Facades\Log;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Support\Str;
+use Illuminate\Support\Facades\Hash;
+use phpDocumentor\Reflection\Types\Boolean;
+use Carbon\Carbon;
+use App\User;
+use App\Buyer;
+use App\Product;
+use App\Order;
+use App\EmailReset;
+use App\Rules\Hankaku;
+use App\Mail\ChangeEmail;
+use App\Http\Requests\UserProfileRequest;
+use App\Http\Requests\ProductRequest;
+use Request as PostRequest;
+class UserController extends Controller {
+//-----------------------------------------------------------
+//ユーザが投稿した最近の記事5件
+//-----------------------------------------------------------
+    public function index(int $id){
+        $user = User::where('id', $id)->first();
+        $is_img = $this->isImg();
+        $products = $user->products->take(5);
+        //ユーザーと商品のリレーションから、最新の5件の商品を取得
+        $soldOutProducts = $user->soldProduct;
+        //hasmanythroughでusers->products->ordersテーブルをまたいでアクセス。売れた商品を取得
+        if (!empty($soldOutProducts)) {
+            foreach ($soldOutProducts as $soldOutProduct) {
+                $product_id[] = $soldOutProduct->product_id;
+            }//ordersテーブルのproduct_idカラムを全て取得
+            if (!empty($product_id)) {
+                $soldOutProducts = Product::whereIn('id', $product_id)->get()->take(5);
+                //productsテーブルのからproduct_id[]の値を元に取得
+            }
+        }
+        return view('users.index', [
+            'products' => $products,
+            'user' => $user,
+            'soldOutProducts' => $soldOutProducts,
+]);
+    }
+    //----------------------------------------
+    //出品中の商品
+    //----------------------------------------
+    public function onSellProduct(int $id){
+        $user = User::where('id', $id)->first();
+        //$idをもとにuser情報取得
+        $products = $user->products()->paginate(10);
+      //user情報をもとに商品を取得
+        return view('users.onSellProducts', [
+        'user' => $user,
+        'products' => $products,
+      ]);
+    }
+    //----------------------------------------
+    //売れた商品
+    //----------------------------------------
+    public function soldProduct($id) {
+        $user = User::where('id', $id)->first();
+        //ユーザー情報
+        $soldOutProducts = $user->soldProduct;
+        //hasmanythroughでusers->products->ordersテーブルにアクセス。
+        //ユーザーが出品した商品で売れたものをとる
+        if (!empty($soldOutProducts)) {
+            foreach ($soldOutProducts as $soldOutProduct) {
+                $product_id[] = $soldOutProduct->product_id;
+                Log::debug(print_r( $product_id, true));
+                     }
+            if (!empty($product_id)) {
+                //ordersテーブルから売れた商品のproduct_idを取得
+                $soldOutProducts = Product::whereIn('id',$product_id)->paginate(10);
+            }
+        }
+        return view('users.soldProducts', [
+         'soldOutProducts' => $soldOutProducts,
+        'user' => $user
+        ]);
+    }
+    //----------------------------------------
+    //ユーザープロフィール編集
+    //----------------------------------------
+    public function profile(int $id){
+        $user = User::where('id', $id)->first();
+        $prefs = config('prefectures');
+        $is_img = $this->isImg();
+        Log::debug(print_r($is_img, true));
+        return view('users.profile', [
+            'user' => $user,
+            'prefs' => $prefs,
+        ]);
+    }
+    //----------------------------------------
+    //ユーザープロフィール編集
+    //----------------------------------------
+    // GETパラメータが数字かどうかをチェックする
+    public function update(UserProfileRequest $request, int $id) {
+        $user = User::where('id', $id)->first();
+            $user->shop_name = $request->shop_name;
+            $user->branch_name = $request->branch_name;
+            $user->prefecture = $request->prefecture ;
+            $user->address = $request->address;
+            if (!empty($request->img)) {
+                Storage::delete('public/userProfile_images', Auth::id() . '.jpg');
+                Log::debug(print_r($request->img, true));
+                $user->img = $request->file('img')->storeAs('public/userProfile_images', Auth::id() . '.jpg');
+            }
+        $user->save();
+        return back()->with('flash_message', '変更が完了しました');
+    }
+```
+Product.php
+```ここに言語を入力
+<?php
+namespace App;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Support\Facades\Log;
+use Illuminate\Database\Eloquent\Relations\HasMany;
+use Illuminate\Database\Eloquent\Relations\HasOne;
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\Relations\BelongsTo;
+use Illuminate\Database\Eloquent\Relations\BelongsToMany;
+class Product extends Model
+{
+    protected $fillable = ['product_name','expiration_date','price','img',];
+    //----------------------------
+    //userとのリレーション(１対多)
+    //----------------------------
+    public function user(): BelongsTo//このメソッドの戻り値の「型」を宣言
+    {
+    return $this->belongsTo('App\User');
+    }
+    //----------------------------
+    //buyerとのリレーション(多対多)
+    //product->ordersで自分を買ったバイヤーの情報取得
+    //product->orders()->attachで中間テーブル更新
+    //----------------------------
+    public function orderBuyer(): BelongsToMany
+    {
+    return $this->belongsToMany('App\Buyer', 'orders','product_id', 'buyer_id')->withTimestamps();
+    }//第二引数には中間テーブルのテーブル名
+    //----------------------------
+    //ログインしているバイヤーがその商品を購入済みかの確認
+    //----------------------------
+    public function isOrderedBy(buyer $buyer): bool {
+    //viewから受け取った情報がbuyerモデルであることを確認
+    //返り値がboolであることを確認
+      // $a =  $this->orders;
+        return $buyer
+             ?(bool)$this->orderBuyer->where('id', $buyer->id)->count()
+             :false;
+            //buyerモデルを参照して中間テーブルにアクセス。
+            //ログインしているバイヤーのidをもとにordersテーブルから
+            //product->buyer->orders->>where('id', $buyer->id)->count()
+            //buyerモデルのコレクションが返る。
+            //thisはviewから送られてきたproduct
+          // $order = $buyer->buyers()->where('product_id',  $id)->count();
+            //$buyer->buyers()でbuyerモデルからordersテーブル経由で紐付いているproductモデルのコレクションが返る
+    }
+    public function hasOrders(): HasOne//OK
+{
+    return $this->hasOne('App\Order');
+}
+}
+```
+```
 ### 環境
 mysql5.5