Nguyen Ngoc Nghia · @nghiann · Son Do Hong · Nguyen Ngoc Nghia · Van Hau Le · Nguyen Ngoc Nghia
--- a/db/migrate/20191202023440_add_index_to_company_code.rb 0 → 100644
+++ b/db/migrate/20191202023440_add_index_to_company_code.rb 0 → 100644
+class AddIndexToCompanyCode < ActiveRecord::Migration[6.0]
+  def change
+    add_index :companies, :company_code, unique: true
--- a/app/services/cities.rb 0 → 100644
+++ b/app/services/cities.rb 0 → 100644
+require "csv"
+require "activerecord-import"
+# require "activerecord -import/active_record/adapters/mysql_adapter"
--- a/app/services/companies.rb 0 → 100644
+++ b/app/services/companies.rb 0 → 100644
+require "csv"
+require "activerecord-import"
+# require "activerecord -import/active_record/adapters/mysql_adapter"
--- a/app/services/companies.rb 0 → 100644
+++ b/app/services/companies.rb 0 → 100644
+require "csv"
+require "activerecord-import"
+# require "activerecord -import/active_record/adapters/mysql_adapter"
+
+class CompanyImport
+  def companies
--- a/config/routes.rb
+++ b/config/routes.rb
 Rails.application.routes.draw do
+  get "companies/index"
+  get "industries/index"
+  get "cities/index"
--- a/app/services/import.rb 0 → 100644
+++ b/app/services/import.rb 0 → 100644
+
+    city_columns = [:name, :region]
+    company_columns = [:name, :email, :address, :code]
+    industry_columns = [:name]
+    job_columns = [:title, :level, :salary, :description, :short_des, :requirement,
+      :category, :company_id]
+
+    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
+      cities << {name: row["company province"], region: "Việt Nam"}
+      companies << {name: row["company name"], email: row["contact email"],
+        address: row["company address"], code: row["company id"]}
+      industries << {name: row["category"]}
+      jobs << {title: row["name"], level: row["level"], salary: row["salary"],
+        description: row["description"], short_des: row["benefit"],
+        requirement: row["requirement"], category: row["type"],
+        company_id: Company.find_by(code: row["company id"])&.id}
--- a/lib/tasks/task.rake 0 → 100644
+++ b/lib/tasks/task.rake 0 → 100644
+require "./app/services/import.rb"
--- a/app/services/import.rb 0 → 100644
+++ b/app/services/import.rb 0 → 100644
+require "csv"
+require "activerecord-import"
+# require "activerecord -import/active_record/adapters/mysql_adapter"
--- a/app/services/import.rb 0 → 100644
+++ b/app/services/import.rb 0 → 100644
+require "csv"
+require "activerecord-import"
--- a/app/services/import.rb 0 → 100644
+++ b/app/services/import.rb 0 → 100644
+    job_columns = [:title, :level, :salary, :description, :short_des, :requirement,
+      :category, :company_id]
+
+    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
+      cities << {name: row["company province"], region: "Việt Nam"}
+      companies << {name: row["company name"], email: row["contact email"],
+        address: row["company address"], code: row["company id"]}
+      industries << {name: row["category"]}
+      jobs << {title: row["name"], level: row["level"], salary: row["salary"],
+        description: row["description"], short_des: row["benefit"],
+        requirement: row["requirement"], category: row["type"],
+        company_id: Company.find_by(code: row["company id"])&.id}
+    end
+
+    City.import city_columns, cities, on_duplicate_key_ignore: true
+    Company.import company_columns, companies, on_duplicate_key_ignore: true
--- a/app/services/import.rb 0 → 100644
+++ b/app/services/import.rb 0 → 100644
+
+    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
+      cities << {name: row["company province"], region: "Việt Nam"}
+      companies << {name: row["company name"], email: row["contact email"],
+        address: row["company address"], code: row["company id"]}
+      industries << {name: row["category"]}
+      jobs << {title: row["name"], level: row["level"], salary: row["salary"],
+        description: row["description"], short_des: row["benefit"],
+        requirement: row["requirement"], category: row["type"],
+        company_id: Company.find_by(code: row["company id"])&.id}
+    end
+
+    City.import city_columns, cities, on_duplicate_key_ignore: true
+    Company.import company_columns, companies, on_duplicate_key_ignore: true
+    Industry.import industry_columns, industries, on_duplicate_key_ignore: true
+    Job.import job_columns, jobs
--- a/config/routes.rb
+++ b/config/routes.rb
 Rails.application.routes.draw do
+  resources :companies
--- a/lib/tasks/task.rake 0 → 100644
+++ b/lib/tasks/task.rake 0 → 100644
+# require "./app/services/import.rb"
--- a/app/views/jobs/index.html.erb 0 → 100644
+++ b/app/views/jobs/index.html.erb 0 → 100644
+<table class="table">
+  <thead>
+    <tr>
+      <th scope="col">title</th>
+      <th scope="col">short description</th>
+      <th scope="col">salary</th>
+    </tr>
+  </thead>
+  <tbody>
+    <% @jobs.each do |job| %>
--- a/app/views/cities/index.html.erb 0 → 100644
+++ b/app/views/cities/index.html.erb 0 → 100644
+<table class="table">
+  <thead>
+    <tr>
+      <th scope="col">name</th>
+      <th scope="col">region</th>
+    </tr>
+  </thead>
+  <tbody>
+    <% @cities.each do |city| %>
--- a/app/services/job_csv.rb 0 → 100644
+++ b/app/services/job_csv.rb 0 → 100644
+  end
+
+  def requirement
+    @requirement ||= @row["requirement"]
+  end
+
+  def category
+    @category ||= @row["type"]
+  end
+
+  def company_id
+    @company_id ||= company.id
+  end
+
+  def company
+    @company ||= Company.find_or_create_by(code: @row["company id"])
--- a/app/services/jobs_import.rb 0 → 100644
+++ b/app/services/jobs_import.rb 0 → 100644
+require "csv"
+
+class JobsImport
+  def import_job
+    jobs = []
+    job_columns = [:title, :level, :salary, :description, :short_des,
+                   :requirement, :category, :company_id]
+
+    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
+      jobcsv = JobCsv.new(row)
+      jobs << jobcsv.csv_attributes
--- a/app/services/job_csv.rb 0 → 100644
+++ b/app/services/job_csv.rb 0 → 100644
+  end
+
+  def category
+    @category ||= @row["type"]
+  end
+
+  def company_id
+    @company_id ||= company.id
+  end
+
+  def company
+    @company ||= Company.find_or_create_by(code: @row["company id"])
+  end
+
+  def csv_attributes
+    {title: self.title, level: self.level, salary: self.salary, description: self.description,
--- a/app/controllers/static_pages_controller.rb
+++ b/app/controllers/static_pages_controller.rb
 class StaticPagesController < ApplicationController
  def index
+    @cities = City.all
+    @industries  = Industry.all
+    @jobs = Job.page(params[:page]).per(5)
--- a/app/views/companies/index.html.erb 0 → 100644
+++ b/app/views/companies/index.html.erb 0 → 100644
+<table class="table">
+  <thead>
+    <tr>
+      <th scope="col">company name</th>
+      <th scope="col">contact email</th>
+      <th scope="col">company address</th>
+      <th scope="col">company code</th>
+    </tr>
+  </thead>
+  <tbody>
+    <% @companies.each do |company| %>
--- a/app/models/job.rb
+++ b/app/models/job.rb
+# In database
+#   t.string :title
+#   t.string :level
+#   t.string :salary
+#   t.string :other_salary
+#   t.text :description
+#   t.text :short_des