Mai Hoang Thai Ha · @hamht · phuctmZigexn · Mai Hoang Thai Ha · phuctmZigexn · Mai Hoang Thai Ha
--- a/app/models/job.rb
+++ b/app/models/job.rb
 class Job < ApplicationRecord
+  scope :latest, -> { order(updated_at: :desc).limit(5).joins(:cities).includes(:company, :cities, :cities_jobs) }
--- a/app/models/city.rb
+++ b/app/models/city.rb
+  scope :jobs_count, -> { joins(:jobs).group(:region).count }
+
  has_and_belongs_to_many :jobs
  enum region: { vietnam: 0, international: 1 }
+
+  validates :slug, presence: true, uniqueness: { case_sensitive: true }
+
+  def to_params
+    slug
+  end
+
+  def add_slugs
+    update slug: to_slug(name)
+  end
+
+  def self.top_jobs
--- a/app/models/city.rb
+++ b/app/models/city.rb
 class City < ApplicationRecord
+  scope :jobs_count, -> { joins(:jobs).group(:region).count }
--- a/app/models/city.rb
+++ b/app/models/city.rb
 class City < ApplicationRecord
+  scope :jobs_count, -> { joins(:jobs).group(:region).count }
+
  has_and_belongs_to_many :jobs
  enum region: { vietnam: 0, international: 1 }
+
+  validates :slug, presence: true, uniqueness: { case_sensitive: true }
+
+  def to_params
--- a/app/models/industry.rb
+++ b/app/models/industry.rb
+
  has_and_belongs_to_many :jobs
+
+  validates :slug, presence: true, uniqueness: { case_sensitive: true }
+
+  # before_validation :add_slugs
+
+  def to_params
+    slug
+  end
+
+  def add_slugs
+    update slug: to_slug(name)
+  end
+
+  def self.top_jobs
--- a/app/models/industry.rb
+++ b/app/models/industry.rb
 class Industry < ApplicationRecord
+  scope :jobs_count, -> { joins(:jobs).group(:name).count.sort_by(&:first) }
+
  has_and_belongs_to_many :jobs
+
+  validates :slug, presence: true, uniqueness: { case_sensitive: true }
+
+  # before_validation :add_slugs
--- a/app/views/top/index.html.slim
+++ b/app/views/top/index.html.slim
+- provide(:title, 'Home page')
+= render 'search'
--- a/app/views/top/_top_cities.html.slim 0 → 100644
+++ b/app/views/top/_top_cities.html.slim 0 → 100644
+.top_cities.mb-5
+  .container
+    h2 Top cities
+    hr.my-2
+    .row.align-items-start.mb-3
+      - @top_cities.each do |city, city_jobs|
+        .col-4.city-item
+          = link_to city.name, city_jobs_path(City.find_by(name: city.name).slug), class: 'city-name'
--- a/app/views/top/_top_industries.html.slim 0 → 100644
+++ b/app/views/top/_top_industries.html.slim 0 → 100644
+.top_industries.mb-5
+  .container
+    h2 Top industries
+    hr.my-2
+    .row.align-items-start
+      - @top_industries.each do |industry, industry_jobs|
+        .col-4.industry-item
+          = link_to industry.name, industry_jobs_path(Industry.find_by(name: industry.name).slug), class: 'industry-name'
--- a/app/helpers/cities_helper.rb 0 → 100644
+++ b/app/helpers/cities_helper.rb 0 → 100644
+module CitiesHelper
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+= render 'regions_list'
--- a/app/models/city.rb
+++ b/app/models/city.rb
  enum region: { vietnam: 0, international: 1 }
+
+  validates :slug, presence: true, uniqueness: { case_sensitive: true }
+
+  def to_params
+    slug
+  end
+
+  def add_slugs
+    update slug: to_slug(name)
+  end
+
+  def self.top_jobs
+    self.all.map { |city| [city, city.jobs.count] }.sort_by(&:second).reverse.take(9)
+  end
 end
--- a/app/controllers/cities_controller.rb 0 → 100644
+++ b/app/controllers/cities_controller.rb 0 → 100644
+class CitiesController < ApplicationController
--- a/app/controllers/cities_controller.rb 0 → 100644
+++ b/app/controllers/cities_controller.rb 0 → 100644
+class CitiesController < ApplicationController
+  def index
+    @region_job_list = City.jobs_count
+  end
+
+  def show
--- a/app/controllers/industries_controller.rb 0 → 100644
+++ b/app/controllers/industries_controller.rb 0 → 100644
+class IndustriesController < ApplicationController
+  def index
+    # @industries_job_list = Industry.joins(:jobs).group(:name).count.sort_by(&:first)
--- a/app/controllers/industries_controller.rb 0 → 100644
+++ b/app/controllers/industries_controller.rb 0 → 100644
+class IndustriesController < ApplicationController
+  def index
+    # @industries_job_list = Industry.joins(:jobs).group(:name).count.sort_by(&:first)
+    @industries_job_list = Industry.jobs_count
+  end
+  def show
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+class JobsController < ApplicationController
+  def index
+    if params[:city_slug].present?
--- a/config/initializers/string.rb 0 → 100644
+++ b/config/initializers/string.rb 0 → 100644
+class String
+  def to_slug
+    source = [
+      'à', 'á', 'â', 'ã', 'è', 'é', 'ê', 'ì', 'í', 'ò',
+      'ó', 'ô', 'õ', 'ù', 'ú', 'ý', 'ă', 'đ', 'ĩ', 'ũ',
+      'ơ', 'ư', 'ạ', 'ả', 'ấ', 'ầ', 'ẩ', 'ẫ', 'ậ', 'ắ',
+      'ằ', 'ẳ', 'ẵ', 'ặ', 'ẹ', 'ẻ', 'ẽ', 'ế', 'ề', 'ể',
+      'ễ', 'ệ', 'ỉ', 'ị', 'ọ', 'ỏ', 'ố', 'ồ', 'ổ', 'ỗ',
+      'ộ', 'ớ', 'ờ', 'ở', 'ỡ', 'ợ', 'ụ', 'ủ', 'ứ', 'ừ',
+      'ử', 'ữ', 'ự', 'ỳ', 'ỷ', 'ỹ', 'ỵ'
+    ]
--- a/config/initializers/string.rb 0 → 100644
+++ b/config/initializers/string.rb 0 → 100644
+      'ằ', 'ẳ', 'ẵ', 'ặ', 'ẹ', 'ẻ', 'ẽ', 'ế', 'ề', 'ể',
+      'ễ', 'ệ', 'ỉ', 'ị', 'ọ', 'ỏ', 'ố', 'ồ', 'ổ', 'ỗ',
+      'ộ', 'ớ', 'ờ', 'ở', 'ỡ', 'ợ', 'ụ', 'ủ', 'ứ', 'ừ',
+      'ử', 'ữ', 'ự', 'ỳ', 'ỷ', 'ỹ', 'ỵ'
+    ]
+    destination = [
+      'a', 'a', 'a', 'a', 'e', 'e', 'e', 'i', 'i', 'o',
+      'o', 'o', 'o', 'u', 'u', 'y', 'a', 'd', 'i', 'u',
+      'o', 'u', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a',
+      'a', 'a', 'a', 'a', 'e', 'e', 'e', 'e', 'e', 'e',
+      'e', 'e', 'i', 'i', 'o', 'o', 'o', 'o', 'o', 'o',
+      'o', 'o', 'o', 'o', 'o', 'o', 'u', 'u', 'u', 'u',
+      'u', 'u', 'u', 'y', 'y', 'y', 'y'
+    ]
+    hash = Hash[source.zip destination]
+    self.downcase.encode('ASCII', 'UTF-8', fallback: hash).gsub(' ', '-').parameterize.truncate 80
--- a/app/assets/stylesheets/custom.scss
+++ b/app/assets/stylesheets/custom.scss
+}
+
+// Top page 
+// search 
+
+
+// latest-job
--- a/app/models/industry.rb
+++ b/app/models/industry.rb
 class Industry < ApplicationRecord
+  scope :jobs_count, -> { joins(:jobs).group(:name).count.sort_by(&:first) }
--- a/app/views/top/index.html.slim
+++ b/app/views/top/index.html.slim
+- provide(:title, 'Home page')
+/ search box
+= render 'shared/search'
+/ latest job
+.latest-job.mb-5
+  .container.mb-5
+    h2
+      | Latest jobs
+    hr.my-2
+    - @latest_jobs.each do |job|
+      .job-item.mb-4
+        = link_to job.title, job_path(job.id), class: "job-title"
--- a/app/views/jobs/index.html.slim 0 → 100644
+++ b/app/views/jobs/index.html.slim 0 → 100644
+= render 'shared/search'
+.container
+  h1.mt-5
+    = @name
+  hr.my-4
+  .no-padding.d-flex.align-items-center.flex-column
+    .page-info.p-2
+      = page_entries_info @jobs
+    .page-info.p-2
+      = paginate @jobs
+.container
+  .container
+  - @jobs.each do |job|
+    / job
+    .job-item
+      = link_to job.title, job_path(Job.find_by(title: job.title).id), class: 'job-title fs-3 text-decoration-none text-reset'
--- a/app/views/jobs/show.html.slim 0 → 100644
+++ b/app/views/jobs/show.html.slim 0 → 100644
+.container.my-5
+  / breadcrumb 
+  .breadcrumb
+    = link_to root_path, class: 'text-decoration-none text-info' do
+      'Home
+    span.d-block.mx-2
+      |  >  
+    - city_list = @job.cities
--- a/app/assets/stylesheets/top.scss
+++ b/app/assets/stylesheets/top.scss
-// Place all the styles related to the Top controller here.
-// They will automatically be included in application.css.
-// You can use Sass (SCSS) here: https://sass-lang.com/
+$white:    #fff;
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/views/cities/index.html.slim 0 → 100644
+++ b/app/views/cities/index.html.slim 0 → 100644
+  .container.py-5
+    h2.mt-0 REGION
+    hr.my-4
+    .row
+      - @regions.each do |region|
+        .col-lg-4.col-md-6.text-center
+          .mt-5
+            h3.h4.mb-2.text-white.see-more-text= link_to region, anchor: region
+// cities list
+.cities-list
+  .container 
+    - @job_quantity_by_region.each do |region, city_job_count|
+      .countries-job-list id=region 
+        .container-fullwidth.py-5
+          h2.mt-0
+            = region
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+  end
+
+  def show
+    @job = Job.find(params[:id])
+  end
+
+  private
+
+  def search 
+    if job_params.key?(:model) && job_params.key?(:slug) # search by model
+      model = params[:model].classify.constantize
+      @target = model.find_by(slug: job_params[:slug])
+      @jobs = @target.jobs.includes(:company).page(params[:page]).per(20)
+    elsif job_params.key?(:search)                      # search by keywords
+      wildcard_search = "%#{job_params[:search]}%"
+      @jobs = Job.where('name ILIKE ? OR postal_code LIKE ?', wildcard_search, wildcard_search)
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+class JobsController < ApplicationController
+  def index
+    if job_params.present?
+      search
+    else
+      @jobs = Job.includes(:company).page(params[:page]).per(20)
--- a/app/views/layouts/application.html.slim
+++ b/app/views/layouts/application.html.slim
 html
  head
    title
-      | hi
-    - # <%= full_title(yield(:title))
-    meta[name="viewport" content="width=device-width,initial-scale=1" charset="utf-8"]
+      =full_title(yield(:title))
--- a/app/views/top/index.html.slim
+++ b/app/views/top/index.html.slim
+- provide(:title, 'Home page')
+/ search box
+.container
+  .row.text-center
+    .col
+      h2.my-4
+        | Total: #{pluralize(@total_job, "job")}
--- a/app/views/top/index.html.slim
+++ b/app/views/top/index.html.slim
+- provide(:title, 'Home page')
+/ search box
+.container
+  .row.text-center
+    .col
+      h2.my-4
+        | Total: #{pluralize(@total_job, "job")}
+  = render 'shared/search'
+/ latest job
--- a/app/views/top/index.html.slim
+++ b/app/views/top/index.html.slim
+  = render 'shared/search'
+/ latest job
+.latest-job.mb-5
+  .container.mb-5
+    h2
+      | Latest jobs
+    hr.my-2
+    - @latest_jobs.each do |job|
+      .job-item.mb-4
+        = link_to job.title, job, class: 'job-title'
+        .job-caption
+          = link_to job.company.name, '#', class: 'job-company'
+          p.job-salary
+            | Salary: 
+            = job.salary
+          .job-locations
--- a/app/views/jobs/index.html.slim 0 → 100644
+++ b/app/views/jobs/index.html.slim 0 → 100644
+  .no-padding.d-flex.align-items-center.flex-column
+    .page-info.p-2
+      = page_entries_info @jobs
+    .page-info.p-2
+      = paginate @jobs
+.container
+  .container
+  - @jobs.each do |job|
+    / job
+    .job-item
+      = link_to job.title, job, class: 'job-title fs-3 text-decoration-none text-reset'
+      .job-caption
+        = link_to job.company.name, '#', class: 'job-company text-decoration-none text-secondary'
+        p.job-salary.text-success
+          | Salary: #{job.salary}
+        / ul.list-unstyled
--- a/app/views/jobs/show.html.slim 0 → 100644
+++ b/app/views/jobs/show.html.slim 0 → 100644
+      = ' | ' if i != industry_list.length - 1
+    span.d-block.mx-2
+      |  > 
+    = @job.title
+  hr.my-4
+  / job details 
+  .job-detail.my5 
+    .job-apply.d-flex.align-items-center.justify-content-between
+      h2.align-items-start
+        = @job.title
+      = link_to 'Apply for this job', '#', class: 'btn btn-primary'
+    p.text-secondary
+      = @job.company.name
+    .row.bg-light
+      .col-4
+        ul.list-unstyled
--- a/app/views/jobs/show.html.slim 0 → 100644
+++ b/app/views/jobs/show.html.slim 0 → 100644
+            strong 
+              | Position
+            p
+              = @job.position
+      .col-4
+        ul.list-unstyled
+          li
+            strong
+              | Experience
+            p
+              = @job.experience
+          li 
+            strong
+              | Expiration date
+            p 
+              = @job.expiration_date  
--- a/app/views/jobs/show.html.slim 0 → 100644
+++ b/app/views/jobs/show.html.slim 0 → 100644
+ruby: 
+  city_list = @job.cities
+
+/ html
+.container.my-5
+  / breadcrumb 
+  .breadcrumb
--- a/app/views/jobs/show.html.slim 0 → 100644
+++ b/app/views/jobs/show.html.slim 0 → 100644
+
+  / job details 
+  .job-detail.my5 
+    .job-apply.d-flex.align-items-center.justify-content-between
+      h2.align-items-start
+        = @job.title
+      = link_to 'Apply for this job', '#', class: 'btn btn-primary'
+    p.text-secondary
+      = @job.company.name
+    .row.bg-light
+      .col-4
+        ul.list-unstyled
+          li 
+            strong.d-block
+              | Location 
+            - city_list = @job.cities
--- a/app/views/jobs/index.html.slim 0 → 100644
+++ b/app/views/jobs/index.html.slim 0 → 100644
+    .page-info.p-2
+      = page_entries_info @jobs
+    .page-info.p-2
+      = paginate @jobs
+.container
+  .container
+  - @jobs.each do |job|
+    / job
+    .job-item
+      = link_to job.title, job, class: 'job-title fs-3 text-decoration-none text-reset'
+      .job-caption
+        = link_to job.company.name, '#', class: 'job-company text-decoration-none text-secondary'
+        p.job-salary.text-success
+          | Salary: #{job.salary}
+        ul.list-unstyled
+          - city_list = job.cities
--- a/app/views/jobs/show.html.slim 0 → 100644
+++ b/app/views/jobs/show.html.slim 0 → 100644
+ruby: 
+  city_list = @job.cities
+  industry_list = @job.industries
+
+/ html
+.container.my-5
+  / breadcrumb 
+  .breadcrumb
+    = link_to root_path, class: 'text-decoration-none text-info' do
--- a/app/views/jobs/index.html.slim 0 → 100644
+++ b/app/views/jobs/index.html.slim 0 → 100644
+      = page_entries_info @jobs
+    .page-info.p-2
+      = paginate @jobs
+.container
+  .container
+  - @jobs.each do |job|
+    / job
+    .job-item
+      = link_to job.title, job, class: 'job-title fs-3 text-decoration-none text-reset'
+      .job-caption
+        = link_to job.company.name, '#', class: 'job-company text-decoration-none text-secondary'
+        p.job-salary.text-success
+          | Salary: #{job.salary}
+        ul.list-unstyled
+          - city_list = job.cities
+          = show_location(city_list)