Nguyen Ngoc Nghia · @nghiann · Van Hau Le · Nguyen Ngoc Nghia · Van Hau Le · Nguyen Ngoc Nghia
--- a/app/services/jobs_import.rb
+++ b/app/services/jobs_import.rb
    jobs = []
    job_columns = [:title, :level, :salary, :description, :short_des,
                   :requirement, :category, :company_id]
+    city_jobs = []
+    industry_jobs = []

    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
-      jobs << JobCsv.new(row).csv_attributes
+      job_csv = JobCsv.new(row)
+      jobs << job_csv.csv_attributes
+      city_jobs << [row["company province"], job_csv.title, job_csv.company_id]
+      industry_jobs << [row["category"], job_csv.title, job_csv.company_id]
    end

    Job.import job_columns, jobs
    puts "Jobs imported"
--- a/app/views/cities/_city.html.erb
+++ b/app/views/cities/_city.html.erb
 <div class="col-md-3">
  <div class="col-show">
-    <%= city.name %>
+    <%= city.name %> (<%= (city.jobs.count) %>)
--- a/config/routes.rb
+++ b/config/routes.rb
  resources :cities, only: :index
  resources :jobs, only: :index
  devise_for :users
-  root "static_pages#index"
-  get "static_pages/index"
+  root "tops#index"
+  get "tops/index"
--- a/app/models/city.rb
+++ b/app/models/city.rb
 #

 class City < ApplicationRecord
+  has_many :city_jobs
+  has_many :jobs, through: :city_jobs
+
  scope :vn_cities, -> {where region: "Việt Nam"}
  scope :inter_cities, -> {where region: "#"}
+
+  def job_count
+    jobs.count
--- a/app/services/jobs_import.rb
+++ b/app/services/jobs_import.rb
    jobs = []
    job_columns = [:title, :level, :salary, :description, :short_des,
                   :requirement, :category, :company_id]
+    join_jobs = []

    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
-      jobs << JobCsv.new(row).csv_attributes
+      job_csv = JobCsv.new(row)
+      jobs << job_csv.csv_attributes
+      join_jobs << [row["company province"], row["category"], job_csv.title, job_csv.company_id]
    end

    Job.import job_columns, jobs
-    puts "Jobs imported"
+
+    join_jobs.each do |city_name,industry_name, job_title, company_id|
--- a/lib/tasks/task.rake
+++ b/lib/tasks/task.rake
  task import: :environment do
    Import.new.import
    JobsImport.new.import_job
+
+    import = ActiveSupport::Logger.new("log/import.log")
+    import.debug "Cities, industries, companies, jobs imported: #{Time.current}"
--- a/app/services/jobs_import.rb
+++ b/app/services/jobs_import.rb
+      jobs << job_csv.csv_attributes
+      join_jobs << [row["company province"], row["category"], job_csv.title, job_csv.company_id]
    end

    Job.import job_columns, jobs
-    puts "Jobs imported"
+
+    join_jobs.each do |city_name,industry_name, job_title, company_id|
+      job = Job.find_by(title: job_title, company_id: company_id)
+      city = City.find_by(name: city_name)
+      job.city_jobs.create(city_id: city.id)
+      industry = Industry.find_by(name: industry_name)
+      job.industry_jobs.create(industry_id: industry.id)
+    end
+
+    puts "See import.log for more details."
--- a/lib/tasks/task.rake
+++ b/lib/tasks/task.rake
  task import: :environment do
    Import.new.import
    JobsImport.new.import_job