Xuan Trung Le · @trunglx · Ba Toi Dang · Xuan Trung Le · Ba Toi Dang · Xuan Trung Le
--- a/app/views/admins/applies/_application.html.erb 0 → 100644
+++ b/app/views/admins/applies/_application.html.erb 0 → 100644
+<% @applications.each do |application| %>
+  <div class="job-intro well mr0 mrBot20">
+    <h4 class="mr0"><%= link_to application.job.name, job_path(application.job) %></h4>
+    <p><%= "Candidate Name: #{application.user.name}" %></p>
--- a/app/views/admins/applies/_application.html.erb 0 → 100644
+++ b/app/views/admins/applies/_application.html.erb 0 → 100644
+<% @applications.each do |application| %>
+  <div class="job-intro well mr0 mrBot20">
+    <h4 class="mr0"><%= link_to application.job.name, job_path(application.job) %></h4>
+    <p><%= "Candidate Name: #{application.user.name}" %></p>
+    <p><%= "Candidate CV: #{application.user.cv}" %></p>
+    <p>
+      <span><%= "Candidate Email: #{application.user.email}" %></span>
+      <span class="navbar-right"><%= "Applied at: #{application.created_at.strftime('%m/%d/%y')}" %></span>
--- a/app/views/admins/applies/_application.html.erb 0 → 100644
+++ b/app/views/admins/applies/_application.html.erb 0 → 100644
+<% @applications.each do |application| %>
+  <div class="job-intro well mr0 mrBot20">
+    <h4 class="mr0"><%= link_to application.job.name, job_path(application.job) %></h4>
+    <p><%= "Candidate Name: #{application.user.name}" %></p>
+    <p><%= "Candidate CV: #{application.user.cv}" %></p>
--- a/app/assets/javascripts/application.js
+++ b/app/assets/javascripts/application.js
 //= require_tree .
 //= require javascripts/jquery-3.2.1.min.js
 //= require javascripts/bootstrap.min.js
+//= require javascripts/bootstrap.min.js
+//= require bootstrap-datetimepicker.min.js

 $(document).ready(function(){
  $('.message').delay(5000).fadeOut('slow');
+
+  $('.form_date').datetimepicker({
+    language:  'fr',
--- a/app/assets/javascripts/application.js
+++ b/app/assets/javascripts/application.js
 //= require_tree .
 //= require javascripts/jquery-3.2.1.min.js
--- a/app/assets/javascripts/application.js
+++ b/app/assets/javascripts/application.js
 //= require_tree .
 //= require javascripts/jquery-3.2.1.min.js
--- a/app/assets/stylesheets/application.scss
+++ b/app/assets/stylesheets/application.scss
 @import "stylesheets/bootstrap-theme.min.css";
--- a/app/views/admins/applies/index.html.erb
+++ b/app/views/admins/applies/index.html.erb
+            <input class="form-control" size="16" type="text" value="" readonly>
+            <span class="input-group-addon"><span class="glyphicon glyphicon-remove fa fa-trash-o"></span></span>
+            <span class="input-group-addon"><span class="glyphicon glyphicon-calendar fa fa-calendar"></span></span>
+          </div>
+          <%= hidden_field_tag('dtp_input2', params[:date_to], value: '') %>
+        </div>
+        <div class="field form-group form-inline text-center">
+          <%= submit_tag "search", class: "btn btn-default" %>
+          <%= submit_tag "Down csv", class: "btn btn-default" %>
+        </div>
+      <% end %>
+    </div>
+
+    <div class="col-md-12 jobs">
+      <div class="panel border_bot clearfix">
+        <%= render "admins/applies/application", applications: @application %>
--- a/app/assets/javascripts/application.js
+++ b/app/assets/javascripts/application.js
 //
 //= require rails-ujs
 //= require_tree .
-//= require javascripts/jquery-3.2.1.min.js
-//= require javascripts/bootstrap.min.js
+//= require jquery-3.2.1.min.js
--- a/app/assets/javascripts/application.js
+++ b/app/assets/javascripts/application.js
 //
 //= require rails-ujs
 //= require_tree .
--- a/app/assets/stylesheets/application.scss
+++ b/app/assets/stylesheets/application.scss
-@import "stylesheets/bootstrap-theme.min.css";
-@import "stylesheets/bootstrap.min.css";
+@import "bootstrap-theme.min.css";
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+require 'rsolr'
+require "csv"
+
 class Admins::AppliesController < ApplicationController
  def index
+    @cities = City.pluck(:id, :name)
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+require "csv"
+
 class Admins::AppliesController < ApplicationController
  def index
+    @cities = City.pluck(:id, :name)
+    if params[:commit]
+      # get condition here
+      condition = get_condition
+      # get applications from query
+      response = query(condition)
+      job_id = response["response"]["docs"].pluck("id")
+
+      @applications = ApplyJob.where(job_id: job_id).includes(:job, :user)
+      if params[:commit].eql? 'Down csv'
+        flash[:notice] = 'Down csv'
+        down_csv(@applications)
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+  def down_csv(applications)
+
+    # handle data
+    data_csv = []
+    applications.each do |application|
+      candidate = {}
+      candidate[:job] = application.job.name
+      candidate[:name] = application.name
+      candidate[:email] = application.email
+      candidate[:cv] = application.cv
+      candidate[:applied_at] = application.created_at
+      data_csv << candidate
+    end
+
+    # create new csv file
+    CSV.open("file.csv", "wb") do |csv|
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+    # Direct connection
+    connect
+    # use get method to query
+    response = @solr.get 'select', :params => condition
+    response
+  end
+
+  def get_condition
+    condition = {}
+    filter_query = []
+    date_from = '*'
+    date_to = 'NOW'
+
+    # get condition
+    condition[:q] = "email:[* TO *]"
+    filter_query << "email:\"#{params[:email]}\"" if params[:email]
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+
+  private
+  def connect
+    url = 'http://localhost:8983/solr/my_solr_collection'
+    @solr = RSolr.connect url: url
+  end
+
+  def query(condition)
+    # Direct connection
+    connect
+    # use get method to query
+    response = @solr.get 'select', :params => condition
+    response
+  end
+
+  def get_condition
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+
+    # down file.csv into local
+    send_file "#{Rails.root}/file.csv", type: 'application/csv'
+  end
+
+  private
+  def connect
+    url = 'http://localhost:8983/solr/my_solr_collection'
+    @solr = RSolr.connect url: url
+  end
+
+  def query(condition)
+    # Direct connection
+    connect
+    # use get method to query
+    response = @solr.get 'select', :params => condition
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+    CSV.open("file.csv", "wb") do |csv|
+      # write header
+      csv << data_csv.first.keys
+      # write values
+      data_csv.each_with_index do |data, i|
+        csv << data.values
+      end
+    end
+
+    # down file.csv into local
+    send_file "#{Rails.root}/file.csv", type: 'application/csv'
+  end
+
+  private
+  def connect
+    url = 'http://localhost:8983/solr/my_solr_collection'
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+      # get condition here
+      condition = get_condition
+      # get applications from query
+      response = query(condition)
+      job_id = response["response"]["docs"].pluck("id")
+
+      @applications = ApplyJob.where(job_id: job_id).includes(:job, :user)
+      if params[:commit].eql? 'Down csv'
+        flash[:notice] = 'Down csv'
+        down_csv(@applications)
+      end
+    else
+      # get applications
+      @applications = ApplyJob.includes(:job, :user)
+    end
+    puts params[:commit]
--- a/app/controllers/application_controller.rb
+++ b/app/controllers/application_controller.rb
 class ApplicationController < ActionController::Base
  protect_from_forgery with: :exception
-  helper_method :clear_session_candidate
+  helper_method :clear_session_candidate, :admin_can_not_do_this
--- a/app/controllers/applies_controller.rb
+++ b/app/controllers/applies_controller.rb
  def application_params
    params.require(:apply_job).permit(:name, :email, :cv)
  end
+
+  def check_deadline
--- a/app/views/admins/applies/_application.html.erb 0 → 100644
+++ b/app/views/admins/applies/_application.html.erb 0 → 100644
+<% @applications.each do |application| %>
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+require 'rsolr'
+require "csv"
+require 'uri'
+require './app/models/settings.rb'
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+require 'rsolr'
+require "csv"
+require 'uri'
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+      if params[:commit].eql? 'Down csv'
+        down_csv(@applications)
+        return
+      end
+    else
+      # get applications
+      @applications = ApplyJob.includes(:job, :user)
+    end
+  end
+
+  def down_csv(applications)
+    send_data ApplyJob.to_csv(applications), filename: "applications-#{Date.today}.csv"
+  end
+
+  def down_cv_candidate
+      user = User.find(params[:user_id])
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+    send_data ApplyJob.to_csv(applications), filename: "applications-#{Date.today}.csv"
+  end
+
+  def down_cv_candidate
+      user = User.find(params[:user_id])
+      if user.cv.file.exists?
+        send_file user.cv.path
+      else
+        flash[:notice] = 'File not exist!'
+        redirect_back(fallback_location: root_path)
+      end
+  end
+
+  private
+  def connect
+    RSolr.connect url: Settings.rsolr.url
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+require 'rsolr'
+require "csv"
+require 'uri'
+require './app/models/settings.rb'
+
 class Admins::AppliesController < ApplicationController
+  before_action :authenticate_admin!
+
  def index
+    if params[:commit]
+      # get condition here
+      condition = get_condition
+      # get applications from query
+      response = query(condition)
+      job_id = response["response"]["docs"].pluck("id")
--- a/app/controllers/admins/applies_controller.rb
+++ b/app/controllers/admins/applies_controller.rb
+
+  private
+  def connect
+    RSolr.connect url: Settings.rsolr.url
+  end
+
+  def query(condition)
+    # Direct connection
+    @solr ||= connect
+    # use get method to query
+    response = @solr.get 'select', params: condition
+    response
+  end
+
+  def get_condition
+    condition = {}
--- a/app/models/job.rb
+++ b/app/models/job.rb
  has_many :view_jobs
  has_many :users_has_viewed, through: :view_jobs, class_name: 'User', source: :user

-  scope :top_list, -> { order(updated_date: :desc).limit(Settings.top.job_per_page) }
+  scope :top_list, -> { order(updated_date: :desc).check_expiration_date.limit(Settings.top.job_per_page) }
+  scope :check_expiration_date, -> { where('NOW() >= expiry_date')   }