Xuan Trung Le · @trunglx · Ba Toi Dang · Xuan Trung Le · Ba Toi Dang · Xuan Trung Le
--- a/app/models/city.rb
+++ b/app/models/city.rb
+
+  scope :top_cities, -> { select('cities.id, cities.name AS name, COUNT(jobs.id) AS jobs_count').
+    joins(:jobs).
+    group('cities.id').
+    order('jobs_count DESC, name').
+    limit(9) }
+
+  scope :city_list, -> { select('cities.id, cities.name AS name, countries.name AS country_name,
+                                 COUNT(jobs.id) AS jobs_count').
+    joins(:jobs).
+    joins(:country).
+    # where('jobs_count >= 1').
+    group('cities.id').
+    order('jobs_count DESC, name') }
+
+  scope :get_job, -> id { find(id) }
--- a/app/models/city.rb
+++ b/app/models/city.rb
  belongs_to :country, optional: true
  has_and_belongs_to_many :companies
  has_and_belongs_to_many :jobs
+
+  scope :top_cities, -> { select('cities.id, cities.name AS name, COUNT(jobs.id) AS jobs_count').
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+class JobsController < ApplicationController
+  before_action :set_job, only: [:show]
+  def index
+    @jobs = Job.all.order(updated_date: 'DESC').limit(5)
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+    @industries = Industry.top_industries
+  end
+
+  def show
+    #code
+  end
+
+  def job_lists
+    #code
+  end
+
+  def city
+    city = City.find(params[:id])
+    @jobs = city.jobs.page(params[:page]).per(20)
+    @result = "jobs/City/#{city.name}"
+    render :action => :job_lists
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+  def index
+    @jobs = Job.all.order(updated_date: 'DESC').limit(5)
+    @cities = City.top_cities
+    @industries = Industry.top_industries
+  end
+
+  def show
+    #code
+  end
+
+  def job_lists
+    #code
+  end
+
+  def city
+    city = City.find(params[:id])
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+class JobsController < ApplicationController
+  before_action :set_job, only: [:show]
+  def index
+    @jobs = Job.all.order(updated_date: 'DESC').limit(5)
+    @cities = City.top_cities
+    @industries = Industry.top_industries
+  end
+
+  def show
+    #code
+  end
+
+  def job_lists
--- a/config/routes.rb
+++ b/config/routes.rb
 Rails.application.routes.draw do
  devise_for :users
+  get 'jobs/index'
+  resources :cities, :industries, :jobs do
+    get 'cities' => 'cities#index'
+    get 'industries' => "industries#index"
+    collection do
+      get 'city/:id' => "jobs#city"