Sha256: 49b942401e599ff3e937ba5d5ddeb3acf648880ef21f8c4d2888b67cc9e56f63
Contents?: true
Size: 1.73 KB
Versions: 8
Compression:
Stored size: 1.73 KB
Contents
require_dependency "educode_sales/application_controller"
module EducodeSales
class HomeController < ApplicationController
def index
end
def statistics
end
def no_permission
end
def search_users
@users = User.where("concat(lastname, firstname) like :q OR login like :q OR phone like :q or mail like :q", q: "%#{params[:q]}%").limit(50)
end
def search
if params[:type] == 'department'
@data = Department.joins(:school).where("schools.name like :q", q: "%#{params[:q]}%").limit(50)
unless @data.present?
@data = Department.where("name like ?", "%#{params[:q]}%").limit(50)
end
elsif params[:type] == "school"
data = School.where("name like ? ", "%#{params[:q]}%").limit(50)
end
end
def search_teacher
@data = Teacher.where("name like ? and is_key = false", "%#{params[:q]}%").limit(20)
user_ids = @data.pluck(:user_id).compact.uniq
@data += User.joins(:user_extension).where.not(id: user_ids).where("identity='teacher'", user_ids).where("lastname like ?", "%#{params[:q]}%").limit(50)
end
def search_edu_teacher
@data = User.joins(:user_extension).where("identity='teacher'").where("concat(lastname, firstname) like :q OR phone like :q OR mail like :q", q: "%#{params[:q]}%").limit(50)
end
def sales_staff
common = Common.find_by(clazz: 'staff_type', name: '销售')
@staffs = Staff
if params[:q].present?
@staffs = @staffs.joins(user: :user_extension).where("concat(lastname, firstname) like :q", q: "%#{params[:q]}%")
end
@staffs = @staffs.where(is_admin: false).where.not(id: @current_admin.id).where(job_type: common.id).page(params[:page]).per(10)
end
end
end
Version data entries
8 entries across 8 versions & 1 rubygems