News投稿機能の作成 about musubu HOT 4 CLOSED

■routes
・index
・form
・confirm
・completed
・show
・edit
・update

rails g controller admins::news index form confirm completed show edit

from musubu.

■Newsモデル
・news_image_id:string
・title:string
・content:text
・start_date:date
・end_date:date
・open_status:boolean
・登録日
・更新日

rails g model News news_image_id:string title:string content:text start_date:date end_date:date open_status:boolean

from musubu.

有効記事の取得

@news = News.where(open_status: true).where( 'start_date <= ? ', date ).where('end_date >= ? ', date)

・SQL
SELECT COUNT(*) FROM "news" WHERE "news"."open_status" = ? AND (start_date <= '2020-11-12' ) AND (end_date >= '2020-11-12' )

from musubu.

■一般用routes
■routes
・index
・show

rails g controller news index show

from musubu.