質問編集履歴

質問の意図を追記

2017/07/03 07:12

投稿

anvinon

スコア38

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -23,3 +23,517 @@
 他にデータベースへ保存する方法があればご教示ください。
 よろしくお願いします。
+**※以下追記**
+現在ECサイトを開発しております。各商品（product）のページに複数のレビュー（review）を投稿して、複数のコメント（comment）が出来るようにアソシエーションを組みました。そして、commentsテーブルにreview_idカラムを作成し、reviewsテーブルのidをreview_idに保存したいのですが、コントローラーやビューで試行錯誤しても、うまくいかないため、質問をさせて頂きました。下記にソースコードを掲載致しました。
+ビューは以下のとおりです。
+```Ruby
+# app/views/products/show.html.erb
+<h1>商品詳細</h1>
+  <%= @product.price %>
+  <%= @product.description %>
+  <%= image_tag @product.image.url %>
+  <%= form_tag(:controller => :products, :action => :add) do %>
+    <%= select_tag :item, options_for_select(["01","02","03","04","05"]) %>
+    <%= submit_tag "Add Cart" %>
+  <% end %>
+<%= link_to '編集', "/products/#{@product.id}/edit", method: :get %>
+<%= link_to '削除', "/products/#{@product.id}", method: :delete %>
+<% if session[:user_id] %>
+<h2>レビュー投稿</h2>
+  <%= form_for(@review_new, :url => {:controller => :reviews, :action => :create}) do |f| %>
+    <%= f.text_area :text %>
+    <%= f.hidden_field :user_id, :value => "#{session[:user_id]}" %>
+    <%= f.hidden_field :name, :value => "#{session[:name]}" %>
+    <%= f.hidden_field :product_id, :value => "#{@product.id}" %>
+    <%= f.submit %>
+  <% end %>
+<% end %>
+<h2>ユーザーレビュー</h2>
+<% if @reviews.nil? %>
+  まだユーザーレビューはありません。
+<% else %>
+<% @reviews.each do |r| %>
+  ユーザー名：<%= r.name %>
+  レビュー文：<%= r.text %>
+  <%= link_to 'コメントする', "/comments/new", method: :get %>
+  <% r.comments.each do |c| %>
+  コメント：<%= c.text %>
+  <% end %>
+<% end %>
+<% end %>
+```
+```Ruby
+# app/views/comments/new.html.erb
+<h1>コメント投稿</h1>
+<%= form_for(@comment_new, :url => {:controller => :comments, :action => :create}) do |f| %>
+  <%= f.text_area :text %>
+  <%= f.hidden_field :user_id, :value => session[:user_id] %>
+  <%= f.hidden_field :name, :value => session[:name] %>
+  <%= f.hidden_field :product_id, :value => session[:product_show_id] %>
+  <%= f.submit %>
+<% end %>
+```
+コントローラーは以下のとおりです。
+```Ruby
+# app/controllers/products_controller.rb
+class ProductsController < ApplicationController
+  def index
+    @product_all = Product.all
+  end
+  def new
+    @product_new = Product.new
+    @review =Review.new
+   end
+  def create
+    Product.create(product_params_create)
+    redirect_to :action => "index"
+  end
+  def show
+    @product = Product.find(params[:id])
+    session[:cart] ||= {}
+    session[:cart]["#{params[:id]}"] = Product.find(params[:id])
+    @review_new = Review.new
+    session[:product_show_id] = params[:id]
+    @comment_all = Comment.all
+    @reviews = @product.reviews
+  end
+  def add
+    if session[:item] == nil then
+      session[:item] ||= {}
+      session[:item]["#{params[:id]}"] = params[:item]
+    else
+      session[:item]["#{params[:id]}"] = params[:item].to_i + session[:item]["#{params[:id]}"].to_i
+    end
+  end
+  def content
+  end
+  def destroy
+    product = Product.find(params[:id])
+    product.destroy
+  end
+  def edit
+    @product_edit = Product.find(params[:id])
+  end
+  def update
+    @product_update = Product.find(params[:id])
+    @product_update.update(product_params_update)
+    redirect_to :action => "index"
+  end
+  def search
+    @products = Product.all
+    if params[:description].present?
+      @products = @products.get_by_description params[:description]
+    end
+  end
+private
+  def product_params_create
+    params.require(:product).permit(:price, :description, :image)
+  end
+  def product_params_update
+    params.permit(:price, :description, :image)
+  end
+end
+```
+```Ruby
+# app/controllers/reviews_controller.rb
+class ReviewsController < ApplicationController
+  def index
+    @reviews = Review.all
+  end
+  def new
+    @review_new = Review.new
+  end
+  def create
+    review  =  Review.create(review_params_create)
+    redirect_to controller: "products", action: "show", id: "#{session[:product_show_id]}"
+  end
+  def edit
+    @review_edit = Review.find(params[:id])
+  end
+  def update
+    @review_update = Review.find(params[:id])
+    @review_update.update(review_params_update)
+    redirect_to controller: "products", action: "show", id: "#{session[:product_show_id]}"
+  end
+  def destroy
+    Review.find(params[:id]).destroy
+    redirect_to controller: "products", action: "show", id: "#{session[:product_show_id]}"
+  end
+  private
+    def review_params_create
+      params.require(:review).permit(:text, :user_id, :name, :product_id)
+    end
+    def review_params_update
+      params.require(:review).permit(:text)
+    end
+end
+```
+```Ruby
+# app/controllers/comments_controller.rb
+class CommentsController < ApplicationController
+    def index
+      @comment_index = Comment.all
+    end
+    def new
+      @comment_new = Comment.new
+    end
+    def create
+      session[:comment] = Comment.create(comment_params_create)
+      email = User.find(session[:user_id]).email
+      name = session[:name]
+      url = ""
+      if  ENV["RAILS_ENV"] == "development"
+        url = "http://localhost:3000/products/#{session[:product_id]}"
+      else
+        url = "https://slup-app.herokuapp.com/products/#{session[:product_id]}"
+      end
+      NoticeNewComment.notice_new_comment(name, url, email).deliver_now
+      redirect_to controller: "products", action: "show", id: "#{session[:product_show_id]}"
+    end
+    private
+      def comment_params_create
+        params.require(:comment).permit(:text, :user_id, :review_id)
+      end
+end
+```
+モデルは以下のとおりです。
+```Ruby
+# app/models/comment.rb
+class Comment < ActiveRecord::Base
+  belongs_to :user
+  belongs_to :review
+end
+```
+```Ruby
+# app/models/product.rb
+class Product < ActiveRecord::Base
+  mount_uploader :image, ImageUploader
+  #ユーザー名による絞り込み
+  scope :get_by_description, ->(description) {where("description like ?", "%#{description}%")}
+  has_many :reviews
+end
+```
+```Ruby
+# app/models/review.rb
+class Review < ActiveRecord::Base
+  belongs_to :user
+  belongs_to :product
+  has_many :comments
+end
+```
+```Ruby
+# app/models/user.rb
+class User < ActiveRecord::Base
+  has_secure_password
+  validates :name, presence: true, :uniqueness => true
+  validates :email, presence: true, :uniqueness => true
+  has_many :reviews
+  has_many :comments
+end
+```