require_dependency "educode_sales/application_controller" module EducodeSales class IdeasController < ApplicationController before_action :find_idea, only: [:edit, :destroy, :detail, :history, :update] def index respond_to do |format| format.html do staff_ids = EducodeSales::Idea.all.pluck(:staff_id) creator_ids = EducodeSales::Idea.all.pluck(:creator_id) @creator_arr = EducodeSales::Staff.joins(:user).where(id: creator_ids).pluck("concat(users.lastname,users.firstname)", :id) @staff_arr = EducodeSales::Staff.joins(:user).where(id: staff_ids).pluck("concat(users.lastname,users.firstname)", :id) end format.json do @ideas = Idea.not_deleted if params[:q] && params[:q][:created_at].present? date = params[:q][:created_at].split(" - ") @ideas = @ideas.where("educode_sales_ideas.created_at >= ? AND educode_sales_ideas.created_at <= ?", date[0] + " 00:00:00", date[1] + " 23:59:59") end if params[:q].present? && params[:q][:name].present? @ideas = @ideas.where("educode_sales_ideas.name like ?", "%#{params[:q][:name]}%") end if params[:q].present? && params[:q][:school].present? @ideas = @ideas.left_joins(:school).where("schools.name like ?", "%#{params[:q][:school]}%") end if params[:q].present? && params[:q][:creator_id].present? @ideas = @ideas.where("educode_sales_ideas.creator_id = ?", params[:q][:creator_id].to_i) end if params[:q].present? && params[:q][:staff_id].present? @ideas = @ideas.where("educode_sales_ideas.staff_id = ?", params[:q][:staff_id].to_i) end if params[:q].present? && params[:q][:status].present? @ideas = @ideas.where(status: params[:q][:status]) end if params[:q].present? && params[:q][:types].present? @ideas = @ideas.where(types: params[:q][:types]) end if params[:q].present? && params[:q][:model].present? @ideas = @ideas.where(model: params[:q][:model]) end if params[:q].present? && params[:q][:history_type].present? if params[:q][:history_type].to_i == 0 @ideas = @ideas.where("educode_sales_ideas.history_type=#{params[:q][:history_type]} or educode_sales_ideas.history_type is null ") else @ideas = @ideas.where(history_type: params[:q][:history_type]) end end if params[:q].present? && params[:q][:level].present? @ideas = @ideas.where(level: params[:q][:level]) end @ideas = @ideas.page(params[:page]).per(params[:limit]) end end end def new staffs = Staff.where.not(role_id: 11).includes(:user) gon.staffs = staffs.map { |d| { name: d.user.real_name, value: d.id } } gon.department = { value: '', name: '' } gon.value = '' gon.attachments = [] render layout: false end def create idea = Idea.new(idea_params) # idea.school_id = Department.find_by_id(idea.department_id)&.school_id idea.creator = current_user assist_staff_ids = Array(params[:assist_staff_ids].to_s.split(",")) attachment_ids = Array(params[:attachment_ids].to_s.split(",")) idea.attachment_ids = attachment_ids idea.assist_staff_ids = assist_staff_ids idea.save render_success end def detail render layout: false end def history render layout: false end def update @idea.assign_attributes(idea_params) # @idea.school_id = Department.find_by_id(@idea.department_id)&.school_id assist_staff_ids = Array(params[:assist_staff_ids].to_s.split(",")) @idea.assist_staff_ids = assist_staff_ids attachment_ids = Array(params[:attachment_ids].to_s.split(",")) @idea.attachment_ids = attachment_ids check_changes @idea.save render_success end def destroy @idea.soft_destroy(current_user.id) render_success end def edit staffs = Staff.where.not(role_id: 11).includes(:user) gon.staffs = staffs.map { |d| { name: d.user.real_name, value: d.id } } gon.staff_value = [{ name: @idea.staff&.user&.real_name, value: @idea.staff_id }] gon.sale_staff_value = [{ name: @idea.sale_staff&.user&.real_name, value: @idea.sale_staff_id }] gon.assist_staff_value = @idea.assist_staffs.map { |d| { name: d&.user&.real_name, value: d.id } } gon.attachment_list = @idea.attachments.map { |d| { name: d.filename, value: d.id } } gon.department = { value: @idea&.department_id, name: "#{@idea&.department&.school&.name}-#{@idea&.department&.name}" } gon.value = @idea.department_id gon.department_list = @idea.department.present? ? [{ name: @idea.department.name, value: @idea.department_id }] : [] gon.school_list = @idea.school.present? ? [{ name: @idea.school.name, value: @idea.school_id }] : [] render layout: false end private def idea_params params.permit(:name, :level, :staff_id, :status, :types, :model, :hardware, :project, :money, :end_time, :content, :department_id, :school_id, :manager_name, :manager_phone, :school_name, :department_name, :sale_staff_id, :attachment_id) end def find_idea @idea = Idea.find(params[:id]) end def check_changes unless @idea.new_record? history = [] arr = @idea.attributes.except(:creator_id, :id, :history_type, :deleter_id, :is_deleted, :deleted_at, :history_record, :created_at, :updated_at).keys arr.each do |attr| if @idea.send("#{attr}_changed?") old_value, new_value = @idea.send("#{attr}_was"), @idea.send(attr) res = @idea.save_history(attr, old_value, new_value) history << res if res end end @idea.idea_histories.create(content: history, staff: current_user) if history.present? end end # def upload_file(file) # folder = File.join(Rails.root, "public", "files", 'educode_sales') # upload_file = file # raise "未上传文件" unless upload_file # save_path = File.join(folder) # ext = file_ext(upload_file.original_filename) # local_path, digest = file_save_to_local(save_path, upload_file.tempfile, ext) # content_type = upload_file.content_type.presence || 'application/octet-stream' # disk_filename = local_path[save_path.size + 1, local_path.size] # @attachment = Attachment.where(disk_filename: disk_filename, # author_id: current_user.id).first # if @attachment.blank? # @attachment = Attachment.new # @attachment.filename = upload_file.original_filename # @attachment.description = "popup_windows" # @attachment.disk_filename = local_path[save_path.size + 1, local_path.size] # @attachment.filesize = upload_file.tempfile.size # @attachment.content_type = content_type # @attachment.digest = digest # @attachment.author_id = current_user.id # @attachment.container_id = current_user.id # @attachment.save! # else # logger.info "文件已存在，id = #{@attachment.id}, filename = #{@attachment.filename}" # end # @attachment.id # # render_ok # end # def edu_setting name # EduSetting.get(name) # end # # # def file_ext(file_name) # ext = '' # exts = file_name.split(".") # if exts.size > 1 # ext = ".#{exts.last}" # end # ext # end # # def file_save_to_local(save_path, temp_file, ext) # unless Dir.exists?(save_path) # FileUtils.mkdir_p(save_path) ##不成功这里会抛异常 # end # # digest = md5_file(temp_file) # digest = "#{digest}_#{(Time.now.to_f * 1000).to_i}" # local_file_path = File.join(save_path, digest) + ext # save_temp_file(temp_file, local_file_path) # # [local_file_path, digest] # end # # # def md5_file(temp_file) # md5 = Digest::MD5.new # temp_file.rewind # while (buffer = temp_file.read(8192)) # md5.update(buffer) # end # md5.hexdigest # end # # def save_temp_file(temp_file, save_file_path) # File.open(save_file_path, 'wb') do |f| # temp_file.rewind # while (buffer = temp_file.read(8192)) # f.write(buffer) # end # end # end end end