public class MyViewModel {
public List<table1> TheFirstTable {get;set;}
public List<table2> TheSecondTable {get;set;}
}
MyViewModel viewModel = new MyViewModel();
viewModel.TheFirstTable = //first table content
viewModel.TheSecondTable = //second table content
return View(viewmodel);
//多筆資料
@foreach(var row in Model.TheFirstTable) {
//do something with the row
}
//單筆資料
@Model.TheSecondTable
@RenderSection("JavaScript", required: false)
@section JavaScript
{
<script type="text/javascript" src="@Url.Content("~/Scripts/SomeScript.js")"></script>
<script type="text/javascript" src="@Url.Content("~/Scripts/AnotherScript.js")"></script>
}
# validation
gem 'jquery-validation-rails'
$ bundle
//= require jquery.validate
//= require jquery.validate.additional-methods
.error {
color: #FF0000;
}
<%= form_for @rcalendar, :url => rcalendars_path do |f| %>
<%= f.hidden_field :v_calendar_id, :value => params[:vid] %>
<div>
<%= f.label :fb_nickname, "Facebook姓名" %><span style="color:#FF0000">(必填)</span>
<%= f.text_field :fb_nickname, :class => "required" %>
</div>
<div>
<%= f.label :fb_urls, "Facebook網址" %><span style="color:#FF0000">(必填)</span>
<%= f.text_field :fb_urls, size: "57", :class => "required" %>
</div>
<div>
<%= f.label :content, "內容" %>
<%= f.text_area :content, size: "50x10" %>
</div>
<div>
<%= f.label :password, "取消預約密碼" %><span style="color:#FF0000">(必填)</span>
<%= f.password_field :password, :class => "required", autocomplete: "off" %>
</div>
<div>
<%= f.label :password_confirmation, "確認取消密碼" %><span style="color:#FF0000">(必填)</span>
<%= f.password_field :password_confirmation, :class => "required", autocomplete: "off" %>
</div>
<%= f.submit "確定" %>
<% end %>
<script type="text/javascript">
$('#new_rcalendar').validate({
//debug: true,
rules: {
'rcalendar[fb_nickname]': {
required: true
},
'rcalendar[fb_urls]': {
required: true,
url: true
},
'rcalendar[password]': {
required: true,
minlength: 5
},
'rcalendar[password_confirmation]': {
required: true,
minlength: 5,
equalTo: "#rcalendar_password"
}
},
messages: {
'rcalendar[fb_nickname]': {
required: '必須填寫'
},
'rcalendar[fb_urls]': {
required: '必須填寫',
url: '請輸入有效的網址'
},
'rcalendar[password]': {
required: '必須填寫',
minlength: '長度不得小於5位數'
},
'rcalendar[password_confirmation]': {
required: '必須填寫',
minlength: '長度不得小於5位數',
equalTo: '密碼不符'
}
}
});
</script>
# jquery-ui
gem 'jquery-ui-rails'
//= require jquery-ui
*= require jquery-ui
$ bundle install
before_action :set_calendar, :only => [ :destroy]
def index
@calendars = Calendar.
select("calendars.id", "IF(calendars.user_id = '#{current_user.id}', 1, 0) AS isedit",
"IF(rcalendars.fb_nickname IS NULL, 1, 0) AS reserved",
"CONCAT(calendars.vdate , ' ', calendars.vtime, ':00:00') AS dt",
"CONCAT(users.username, ' ', IFNULL(rcalendars.fb_nickname, '')) AS title",
"CONCAT(calendars.vdate , ' ', calendars.vtime, '點<br/>', IFNULL(rcalendars.content, '')) AS description").
joins("LEFT JOIN users ON users.id = calendars.user_id LEFT JOIN rcalendars ON rcalendars.calendar_id = calendars.id")
#if json file(index.json.jbuilder) like to link use json.url calendar_path(calendar)
end
def new
@calendar = []
15.times do
@calendar << Calendar.new
end
render :layout => false
end
def create
if params.has_key?("calendar")
@calendar = Calendar.create(calendar_params(params["calendar"]))
else
params["calendars"].each do |calendar|
if calendar["issave"] && calendar["vdate"] != ""
@calendar = Calendar.create(calendar_params(calendar))
end
end
end
#json
respond_to do |format|
if @calendar.save
format.html { redirect_to calendars_url, notice: 'calendar was successfully created.' }
format.json { render action: 'index', status: :created, location: @calendar }
else
format.html { render action: 'new' }
format.json { render json: @calendar.errors, status: :unprocessable_entity }
end
end
#json
end
def destroy
@calendar.destroy
redirect_to calendars_url
flash[:alert] = "calendar was successfully deleted"
end
private
# Use callbacks to share common setup or constraints between actions.
def set_calendar
@calendar = Calendar.find(params[:id])
end
# Never trust parameters from the scary internet, only allow the white list through.
def calendar_params(my_params)
my_params.permit(:user_id, :vdate, :vtime)
end
$(document).ready ->
# page is now ready, initialize the calendar...
$('#new_event').click (event) ->
$.get '/calendars/new', (data) ->
#初始將a.html include div#iframe
$('#create_event').html data
return
$('#create_event_dialog').dialog
title: '新增'
modal: true
width: 500
close: (event, ui) ->
$('#create_event_dialog').dialog 'destroy'
return
return
$('#create_event_dialog, #desc_dialog').on 'submit', '#event_form', (event) ->
$spinner = $('.spinner')
show_spinner = ->
$spinner.show()
return
hide_spinner = ->
$spinner.hide()
return
handle_error = (xhr) ->
alert xhr.responseText
return
event.preventDefault()
$.ajax
type: 'POST'
data: $(this).serialize()
url: $(this).attr('action')
beforeSend: show_spinner
complete: hide_spinner
success: refetch_events_and_close_dialog
error: handle_error
return
$('#calendar').fullCalendar
header:
left: 'prev,next today'
center: 'title'
right: 'month'
defaultView: 'month'
loading: (bool) ->
if bool
$('#loading').show()
else
$('#loading').hide()
return
events: '/calendars.json'
timeFormat: 'Ahh點'
eventClick: (event, jsEvent, view) ->
showEventDetails event
return
return
showEventDetails = (event) ->
$('#event_desc').html event.description
title = event.title
if event.isedit and event.reserved
$('#delete_event').html '<form class="button_to" method="post" action="/calendars/' + event.id + '"><input type="hidden" name="_method" value="delete" /><input type="hidden" name="authenticity_token" value="' + $('meta[name="csrf-token"]').attr('content') + '" /><input data-confirm="Are you sure?" type="submit" value="Delete" /></form>'
else
$('#delete_event').html ''
$('#desc_dialog').dialog
title: title
modal: true
width: 500
close: (event, ui) ->
$('#desc_dialog').dialog 'destroy'
return
return
refetch_events_and_close_dialog = ->
$('#calendar').fullCalendar 'refetchEvents'
$('.dialog:visible').dialog 'destroy'
return
.fc-h-event {
cursor: pointer;
}
<div><%=link_to '新增', new_calendar_path, :id => 'new_event' %></div>
<div id="calendar"></div>
<!--隱藏表單 //-->
<div id = "desc_dialog" class="dialog" style ="display:none;">
<div id = "event_desc">
</div>
<br/>
<br/>
<div id = "event_actions">
<span id = "edit_event"></span>
<span id = "delete_event"></span>
</div>
</div>
<div id = "create_event_dialog" class="dialog" style ="display:none;">
<div id = "create_event">
</div>
</div>
json.array!(@calendars) do |calendar|
json.extract! calendar, :id, :title
json.start calendar.dt
end
def index
@calendars = calendar.select("calendars.id, CONCAT(calendars.vdate , ' ', calendars.vtime, ':00:00') AS dt , users.username AS title").joins(:user)
end
$(document).ready ->
$('#calendar').fullCalendar
header:
left: 'prev,next today'
center: 'title'
right: 'month'
defaultView: 'month'
slotMinutes: 15
loading: (bool) ->
if bool
$('#loading').show()
else
$('#loading').hide()
return
events: '/calendars.json'
timeFormat: 'Ahh點'
return
has_many :calendars, :dependent => :delete_all
belongs_to :user
def new
@calendar = []
20.times do
@calendar << calendar.new
end
end
def create
if params.has_key?("calendar")
@calendar = calendar.create(calendar_params(params["calendar"]))
else
params["calendars"].each do |calendar|
if calendar["issave"] && calendar["vdate"] != ""
@calendar = calendar.create(calendar_params(calendar))
end
end
end
if @calendar.save
redirect_to calendars_url
else
render :action => :new
end
flash[:notice] = "calendar was successfully created"
end
<%= form_tag calendars_path do %>
<% i=0 %>
<table border="0">
<tr>
<td>儲存</td>
<td>日期</td>
<td>時間</td>
</tr>
<% @calendar.each do |calendar| %>
<%= fields_for 'calendars[]', calendar do |f| %>
<tr>
<td>
<div>
<% if i < 1 %>
<%= hidden_field_tag('calendars[][issave]', true) %>
<% else %>
<%= check_box_tag('calendars[][issave]', true) %>
<% end %>
<%= f.hidden_field :user_id, :value => current_user.id %>
</div>
</td>
<td>
<div>
<%= f.date_field :vdate %>
</div>
</td>
<td>
<div>
<%= f.select(:vtime) do %>
<% (0..23).each do |t| -%>
<%= content_tag(:option, t.to_s.rjust(2, '0'), value: t) %>
<% end %>
<% end %>
</div>
</td>
<% i=i+1 %>
<% end %>
</tr>
<% end %>
</table>
<div class="actions">
<%= submit_tag %>
</div>
<% end %>
$ gem list底下會列出主機上所有安裝的gem套件，已經安裝的人可以跳過安裝步驟哦。
$ gem install momentjs-rails $ bundle install
# momentjs gem 'momentjs-rails'
//= require moment
test "truth" do
assert_kind_of Module, Momentjs::Rails
end
$ gem install fullcalendar-rails $ bundle install
# full calendar
gem 'fullcalendar-rails'
*= require fullcalendar
//= require fullcalendar
//= require fullcalendar/lang/zh-tw
$(document).ready ->
$("#calendar").fullCalendar(
lang: 'zh-tw' #轉換語系
editable: true
header:
left: 'prev,next today'
center: 'title'
right: 'month,agendaWeek,agendaDay,listWeek'
defaultView: 'month'
height: 500
slotMinutes: 15
)
<div id="calendar"></div>
就會顯示月曆了。<scrip>
$(document).ready(function(){
$('#calendar').fullCalendar({
lang: 'zh-tw', //轉換語系
editable: true,
header: {
left: 'prev,next today',
center: 'title',
right: 'month,agendaWeek,agendaDay,listWeek'
},
defaultView: 'month',
height: 500,
slotMinutes: 15
});
});
</scrip>
<div id="calendar"></div>
config.assets.precompile += ['application-print.css']
<%= stylesheet_link_tag "application-print", :media => "print" %>
----------------------------------------------------------------------------------
文章路徑 實際路徑 修改內容 app/config/app.php config/app.php 'timezone' => 'Asia/Taipei'
'debug' => env('APP_DEBUG', true), app/config/database.php config/database.php
暫不修改 app/routes.php routes/web.php Route::get('/index.html', function() {
return View::make('welcome');
});
<%= link_to "連結", products_path(:param1 => "value1", :param2 => "value2"), class: "color1" %>
<%= link_to(product) do %>
<img src="images/<%= product.image_url %>" class="img-responsive" alt=""/>
<h3><%= product.title %></h3>
<h4>$<%= product.price %></h4>
<% end %>
validates :cname, presence: true
validates :phone1, numericality: true, length: { in: 9..12 }
validates :zipcode, numericality: { only_integer: true }, length: { in: 3..5 }
validates :address, presence: true
# 語系檔
gem "rails-i18n"
$ gem install rails-i18n
zh-TW:
activerecord:
models:
user: "會員資料"
attributes:
user:
cname: "姓名"
email: "信箱"
phone1: "電話1"
zipcode: "郵遞區號"
address: "地址"
password: "密碼"
password_confirmation: "確認密碼"
# The default locale is :en and all translations from config/locales/*.rb,yml are auto loaded. config.i18n.load_path += Dir[Rails.root.join('rails', 'locale', '*.{rb,yml}').to_s] config.i18n.default_locale = "zh-TW" #devise_error config.action_view.field_error_proc = Proc.new { |html_tag, instance| "<font style=\"color: #CC0000;\">#{html_tag}</font>".html_safe }
errors: format: "%{attribute} %{message}" messages: not_saved: one: 有 1 個錯誤發生使得「%{resource}」無法被儲存。 other: 有 %{count} 個錯誤發生使得「%{resource}」無法被儲存。
$ rails g controller registrations
#class RegistrationsController < ApplicationController
class RegistrationsController < Devise::RegistrationsController
private
def sign_up_params
params.require(:user).permit(:cname, :phone1, :phone2, :address, :zipcode, :email, :password, :password_confirmation)
end
def account_update_params
params.require(:user).permit(:cname, :phone1, :phone2, :address, :zipcode, :email, :password, :password_confirmation, :current_password)
end
end
#devise_for :users
devise_for :users, :controllers => { registrations: 'registrations' }
$ rails g migration add_fields_to_users_products
class AddFieldsToUsersProducts < ActiveRecord::Migration
def change
add_column :users, :cname, :string
add_column :users, :phone1, :string
add_column :users, :phone2, :string
add_column :users, :address, :string
add_column :users, :zipcode, :string
add_column :products, :startdate, :datetime
add_column :products, :enddate, :datetime
add_column :products, :stock, :integer
add_column :products, :disstartdate, :datetime
add_column :products, :disenddate, :datetime
add_column :products, :disprice, :integer
add_column :products, :discontext, :text
add_column :products, :predictdate, :datetime
end
end
$ rails g model style product_id:integer title:string image_url:string
create db/migrate/20160629071919_create_styles.rb
create app/models/style.rb
invoke test_unit
create test/models/style_test.rb
create test/fixtures/styles.yml
$ bin/rake db:migrate
@using (Html.BeginForm("update1", "form1"))
{
if (Request.Form.AllKeys.Contains("btn1"))
{
@Html.ValidationSummary()
}
@Html.LabelFor(m => m.PointA1)
@Html.TextBoxFor(m => m.PointA1)
@Html.LabelFor(m => m.PointB1)
@Html.TextBoxFor(m => m.PointB1)
<br />
<input type="submit" name="btn1" value="確定" />
}
@using (Html.BeginForm("update2", "form2"))
{
if (Request.Form.AllKeys.Contains("btn2"))
{
@Html.ValidationSummary()
}
@Html.LabelFor(m => m.PointA2)
@Html.TextBoxFor(m => m.PointA2)
@Html.LabelFor(m => m.PointB2)
@Html.TextBoxFor(m => m.PointB2)
<br />
<input type="submit" name="btn2" value="確定" />
}
利用submit的name就好嘍！
//原：
var dataList = new CsvReader(new StreamReader(path)).GetRecords<FunUpload>().ToList();
//修改後：
var dataList = new CsvReader(new StreamReader(path, Encoding.Default)).GetRecords<FunUpload>().ToList();
...
<td><%= link_to 'Edit', edit_product_path(product) %></td>
<td><%= link_to 'Destroy', product, method: :delete, data: { confirm: 'Are you sure?' } %></td>
<td><a href="/cart/<%= product.id %>">加入購物車</a></td>
</tr>
<% end %>
...
<h1>你的購物車</h1>
<% if @cart.empty? %>
<p>購物車中沒有任何商品</p>
<% else %>
<%= link_to '清空購物車', cart_clear_path %>
<% end %>
<br/><br/><br/>
<% total = 0 %>
<ul>
<% @cart.each do | id, quantity | %>
<% product = Product.find_by_id(id) %>
<li>
<%= link_to product.title, product %>
<p><%= product.description %></p>
<p><%= number_to_currency(product.price, :unit => '$') %></p>
<p>Quantity: <%= quantity %></p>
</li>
<% total += quantity * product.price %>
<% end %>
<p><strong><%= number_to_currency(total, :unit => '$') %></strong></p>
</ul>
class CartController < ApplicationController
before_action :authenticate_user!, except: [:index]
def add
id = params[:id]
...
end
class PageController < ApplicationController
before_action :authenticate_user!, only: [:contact]
def home
end
...
end
root 'page#home'
devise_for :users
get '/cart' => 'cart#index'
get '/cart/clear' => 'cart#clearCart'
get '/cart/:id' => 'cart#add'
#get 'cart#index'
resources :products
get 'page/about'
get 'page/faqs'
get 'page/contact'
這是我routes.rb的內容，routes.rb裡的內容順序是有意義的哦，我將原本放在中間的root 'page#home'移到最前面後再存檔就能work了，很神奇唄！連我都不大清楚why…會不會是我一開始就沒存檔…<!DOCTYPE html> <html> <head> <title>Workspace</title> <%= stylesheet_link_tag 'application', media: 'all', 'data-turbolinks-track' => true %> <%= javascript_include_tag 'application', 'data-turbolinks-track' => true %> <%= csrf_meta_tags %> </head> <body> <nav id="nav"> <div id="page_nav"> <%= link_to('首頁', root_path) %> <%= link_to('產品', products_path) %> <%= link_to('關於我們', page_about_path) %> <%= link_to('問與答', page_faqs_path) %> <%= link_to('聯絡我們', page_contact_path) %> </div> <div id="sign_in"> <% if user_signed_in? %> Signed in as <%= current_user.email %>. Not you? <%= link_to('登出', destroy_user_session_path, :method => :delete) %> | <%= link_to('修改密碼', edit_registration_path(:user)) %> <% else %> <%= link_to('註冊', new_registration_path(:user)) %> | <%= link_to('登入', new_session_path(:user)) %> <% end %> </div> </nav> <div id="main_wrap"> <% if notice %> <p class="alert alert-success"><%= notice %></p> <% end %> <% if alert %> <p class="alert alert-danger"><%= alert %></p> <% end %> <%= yield %> </div> </body> </html>
/*
* This is a manifest file that'll be compiled into application.css, which will include all the files
* listed below.
*
* Any CSS and SCSS file within this directory, lib/assets/stylesheets, vendor/assets/stylesheets,
* or any plugin's vendor/assets/stylesheets directory can be referenced here using a relative path.
*
* You're free to add application-wide styles to this file and they'll appear at the bottom of the
* compiled file so the styles you add here take precedence over styles defined in any styles
* defined in the other CSS/SCSS files in this directory. It is generally better to create a new
* file per style scope.
*
*= require_tree .
*= require_self
*/
*{
margin: 0;
padding: 0;
}
#nav{
width: 100%;
height:40px;
background: #000;
float: left;
}
#page_nav a, #sign_in a {
line-height: 40px;
color: #FFF;
padding: 0 20px 0 20px;
text-decoration: none;
}
#page_nav {
margin: 0 0 0 5%;
float: left;
}
#sign_in{
float: right;
margin: 0 5% 0 0;
}
#main_wrap {
width: 90%;
float: left;
margin: 20px 5% 0 5%;
}
get '/cart' => 'cart#index' get '/cart/clear' => 'cart#clearCart' get '/cart/:id' => 'cart#add'*get '{網址}' => '{controller}#{action}'
class CartController < ApplicationController
def add
id = params[:id]
#if the cart has already been created, use the existing cart else create a new cart
if session[:cart] then
cart = session[:cart]
else
session[:cart] = {}
cart = session[:cart]
end
#if the product has already been added to the cart, increment the value else set the value to 1
if cart[id] then
cart[id] = cart[id] + 1
else
cart[id] = 1
end
redirect_to :action => :index
end
def clearCart
session[:cart] = nil
redirect_to :action => :index
end
def index
#if there is a cart , pass it to the page for display else pass an empty value
if session[:cart] then
@cart = session[:cart]
else
@cart = {}
end
end
end
$ rails s -b $IP -p $PORT
$ mysql-ctl restart
$ rails g controller controller_file_name
$ rails g migration migration_file_name
$ bin/rake db:migrate
$ rake routes