Đường Sỹ Hoàng · @hoangds · Van Hau Le · Đường Sỹ Hoàng · Van Hau Le · Đường Sỹ Hoàng
--- a/app/models/job.rb
+++ b/app/models/job.rb
 class Job < ApplicationRecord
  has_many :user_jobs
  has_many :city_jobs
+  scope :latest_job, -> {order(created_at: :desc).limit 5}
--- a/app/views/jobs/index.html.erb 0 → 100644
+++ b/app/views/jobs/index.html.erb 0 → 100644
+<div class="center jumbotron">
+  <head>
+    <title><%= yield(:title) %> Venjob</title>
+    <meta name="viewport" content="width=device-width, initial-scale=1">
+  </head>
+    <!--List of latest jobs-->
+    <div class="Job list">
+      <div class="Job-title-wrapper">
+          <h3>Latest</h3>
+      </div>
+      <div class="Job-content-wrapper">
+        <% @jobs.latest_job.each do |job| %>
--- a/lib/tasks/import_job_csv.rake
+++ b/lib/tasks/import_job_csv.rake
+                          address: row["company address"]
+                          }
+        company = Company.find_or_initialize_by(code: row["company id"])
+        company.update(company_params)
+
+        job_params = {
+                      description: row["description"],
+                      position: row["level"],
+                      salary: row["salary"],
+                      requirement: row["requirement"]
+                      }
+        job = Job.find_or_initialize_by(title: row["name"], company_id: company.id)
+        job.update(job_params)
+
+        city_params = {
+                        region: row["company province"]
--- a/lib/tasks/import_job_csv.rake
+++ b/lib/tasks/import_job_csv.rake
-                    position: row["level"],
-                    salary: row["salary"],
-                    requirement: row["requirement"]
-                    }
-      job = Job.find_or_initialize_by(title: row["name"], company_id: company.id)
-      job.update(job_params)
-      rescue
-        import_logger = ActiveSupport::Logger.new("log/import.log")
-        import_logger.error "Skip #{row}"
-        next
+  namespace :job do
+    desc "Import CSV file into database"
+    task import_csv: :environment do
+      csv_file = Settings.import_job.csv_file
+      CSV.foreach(csv_file, headers: true) do |row|
+        company_params = {
--- a/app/assets/stylesheets/custom.css 0 → 100644
+++ b/app/assets/stylesheets/custom.css 0 → 100644
+  color: #fff;
+  text-decoration: none;
+}
+
+#banner {
+  width: 100%;
+  padding: 0px;
+}
+
+.inverse {
+    overflow: hidden;
+    background-color: gray;
+  }
+
+ul {
+  float: right;
--- a/app/controllers/jobs_controller.rb 0 → 100644
+++ b/app/controllers/jobs_controller.rb 0 → 100644
+class JobsController < ApplicationController
+  def index
+    @latest_jobs = Job.latest_city.take(5)
--- a/app/models/city.rb
+++ b/app/models/city.rb
 class City < ApplicationRecord
  has_many :city_jobs
+  has_many :jobs, through: :city_jobs
+
+  def self.sort_top_cities
+    @cities||= all.sort_by(&:jobs_count).reverse
--- a/app/models/city.rb
+++ b/app/models/city.rb
 class City < ApplicationRecord
  has_many :city_jobs
+  has_many :jobs, through: :city_jobs
+
+  def self.sort_top_cities
+    @cities||= all.sort_by(&:jobs_count).reverse
+  end
+
+  def jobs_count
+    @jobs_count = jobs.count
--- a/config/environment.rb
+++ b/config/environment.rb

 # Initialize the Rails application.
 Rails.application.initialize!
-# # Rails.logger = Logger.new(STDOUT)
-# # config.logger = ActiveSupport::Logger.new("log/#{Rails.env}.log")
+# Rails.logger = Logger.new(STDOUT)
--- a/app/views/layouts/_header.html.erb 0 → 100644
+++ b/app/views/layouts/_header.html.erb 0 → 100644
+    <%= link_to image_tag("zigexn_logo.png", id: "logo", alt: "Venjob logo") %>
+    <nav>
+        <ul>
+            <li class="btn-navbar"><%=link_to "Login", '#' %></li>
+            <li class="btn-navbar"><%=link_to "Register", '#' %></li>
+        </ul>
+        <ul>
+        <ul>
+          <li class="btn-navbar"><%=link_to "Favorite", '#' %></li>
+          <li class="btn-navbar"><%=link_to "History", '#' %></li>
+      </ul>
+    </nav>
+    <%= link_to image_tag("banner.jpg", id: "banner", alt: "Venjob banner") %>
+  </div>
+  <div class="container">
+      <%= yield %>
--- a/app/views/layouts/application.html.erb
+++ b/app/views/layouts/application.html.erb
    <%= csrf_meta_tags %>
    <%= csp_meta_tag %>
-
    <%= stylesheet_link_tag 'application', media: 'all', 'data-turbolinks-track': 'reload' %>
    <%= javascript_pack_tag 'application', 'data-turbolinks-track': 'reload' %>
  </head>
-
-  <body>
-    <%= yield %>
-  </body>
+    <body>
+      <header>
+        <%= render partial: "layouts/header" %>
+      </header>
+      <footer>
+        <%= render partial: "layouts/footer" %>
--- a/config/routes.rb
+++ b/config/routes.rb
 Rails.application.routes.draw do
+  root "jobs#index"
+  resource :jobs
--- a/app/models/job.rb
+++ b/app/models/job.rb
 class Job < ApplicationRecord
  has_many :user_jobs
  has_many :city_jobs
+
+  def self.latest_city
+    @latest = Job.order(created_at: :desc)
--- a/lib/tasks/import_job_csv.rake
+++ b/lib/tasks/import_job_csv.rake
+        job_params = {
+          description: row["description"],
+          position: row["level"],
+          salary: row["salary"],
+          requirement: row["requirement"]
+        }
+        job = Job.find_or_initialize_by(title: row["name"], company_id: company.id)
+        job.update(job_params)
+
+        city_params = { region: row["company province"] }
+        city = City.find_or_initialize_by(name: row["work place"])
+        city.update(city_params)
+        city_job_params = { city_id: city.id }
+        city_job = CityJob.find_or_initialize_by(job_id: job.id)
+        city_job.update(city_job_params)
+        rescue
--- a/app/views/layouts/application.html.erb
+++ b/app/views/layouts/application.html.erb
 <html>
  <head>
-    <title>VenJob</title>
+    <title><%= yield(:title) %>Venjob</title>
    <%= csrf_meta_tags %>
    <%= csp_meta_tag %>
-
    <%= stylesheet_link_tag 'application', media: 'all', 'data-turbolinks-track': 'reload' %>
    <%= javascript_pack_tag 'application', 'data-turbolinks-track': 'reload' %>
  </head>
-
-  <body>
-    <%= yield %>
-  </body>
+    <body>
+      <header>
--- a/app/assets/stylesheets/custom.scss 0 → 100644
+++ b/app/assets/stylesheets/custom.scss 0 → 100644
+}
+
+.row {
+  padding: 5px;
+  margin: 5px;
+  background-color: $sub-color;
+}
+
+.col-sm {
+  margin: 5px;
+  padding: 5px;
+  background-color: $primary-color;
+}
+
+.form-inline-city {
+  margin-left: 1000px;
--- a/Gemfile.lock
+++ b/Gemfile.lock
 DEPENDENCIES
  activerecord-import
  bootsnap (>= 1.4.2)
+  bootstrap-sass (= 3.3.7)
  byebug
  capybara (>= 2.15)
  config
--- a/lib/tasks/import_job_csv.rake
+++ b/lib/tasks/import_job_csv.rake
-      job = Job.find_or_initialize_by(title: row["name"], company_id: company.id)
-      job.update(job_params)
+        job_params = {
+          description: row["description"],
+          position: row["level"],
+          salary: row["salary"],
+          requirement: row["requirement"]
+        }
+        job = Job.find_or_initialize_by(title: row["name"], company_id: company.id)
+        job.update(job_params)
+
+        city_params = { region: row["work place"] }
+        city = City.find_or_initialize_by(name: row["company province"])
+        city.update(city_params)
+        city_job_params = { city_id: city.id }
+        city_job = CityJob.find_or_initialize_by(job_id: job.id)
--- a/app/assets/javascripts/application.js 0 → 100644
+++ b/app/assets/javascripts/application.js 0 → 100644
+//= require bootstrap
--- a/app/models/industry.rb
+++ b/app/models/industry.rb
 class Industry < ApplicationRecord
  has_many :industry_jobs
+  has_many :jobs, through: :industry_jobs
+
+  def self.sort_top_industries
+    @cindustries ||= all.sort_by(&:jobs_count).reverse
--- a/app/models/job.rb
+++ b/app/models/job.rb
 class Job < ApplicationRecord
  has_many :user_jobs
  has_many :city_jobs
+
+  def self.latest_jobs
+    @latest ||= Job.order(created_at: :desc)
--- a/app/controllers/top_controller.rb 0 → 100644
+++ b/app/controllers/top_controller.rb 0 → 100644
+class TopController < ApplicationController
+  def index
+    @latest_jobs = Job.latest_jobs.take(Settings.top.job.limit)
+    @top_cities = City.sort_top_cities.take(Settings.top.city.limit)
+    @top_industries = Industry.sort_top_industries.take(Settings.top.industry.limit)
--- a/app/views/cities/_city.html.erb 0 → 100644
+++ b/app/views/cities/_city.html.erb 0 → 100644
+<div class="container">
+  <div class="row justify-content-md-center">
+    <div class="col-sm">
+      <%= city.name %>
+      (<%= city.jobs.count %>)
--- a/app/views/industries/_industry.html.erb 0 → 100644
+++ b/app/views/industries/_industry.html.erb 0 → 100644
+<div class="container">
+  <div class="row justify-content-md-center">
+    <div class="col-sm">
+      <%= industry.name %>
+      (<%= industry.jobs.count %>)