class Mypage1Controller < ApplicationController
  def index
    sql = <<-"EOS"
    select
      1 as sec,
      considerations.iine,
      considerations.consideration as comment,
      post_time
     from considerations
     where account = '#{session[:account]}'
    union
     select
      2 as sec,
      impressions.iine,
      impressions.impression,
      post_time as comment
     from impressions
    where account = '#{session[:account]}' order by post_time desc;
    EOS



    @conimp = ActiveRecord::Base.connection.select_all(sql).to_hash
    @post=User.find_by(account:session[:account])
    @noti=Notification.where(account:session[:account]).limit(10).order("post_date desc")
    @imp=Impression.where(account:session[:account]).order("post_time desc")
    @con=Consideration.where(account:session[:account]).order("post_time desc")
  end

  def create
    @mypage1=User.find_by(account:session[:account])
    @img=params[:myimg]
    if @img !=nil
      File.open("Public/img/"+session[:account]+"_"+@img.original_filename,"wb"){|f|
        f.write(@img.read)
      }
      @mypage1.img=session[:account]+"_"+@img.original_filename
    else
      @mypage1.img=""
    end
    @mypage1.save!
    redirect_to :action=>:index

end



end