foodsoft/app/controllers/articles_controller.rb

248 lines
9 KiB
Ruby
Raw Permalink Normal View History

2009-01-06 11:49:19 +01:00
class ArticlesController < ApplicationController
before_action :authenticate_article_meta, :find_supplier
2009-01-06 11:49:19 +01:00
def index
sort = if params['sort']
case params['sort']
when 'name' then 'articles.name'
when 'unit' then 'articles.unit'
when 'article_category' then 'article_categories.name'
when 'note' then 'articles.note'
when 'availability' then 'articles.availability'
when 'name_reverse' then 'articles.name DESC'
when 'unit_reverse' then 'articles.unit DESC'
when 'article_category_reverse' then 'article_categories.name DESC'
when 'note_reverse' then 'articles.note DESC'
when 'availability_reverse' then 'articles.availability DESC'
end
else
'article_categories.name, articles.name'
end
@articles = Article.undeleted.where(supplier_id: @supplier, type: nil).includes(:article_category).order(sort)
2020-06-22 16:03:32 +02:00
if request.format.csv?
send_data ArticlesCsv.new(@articles, encoding: 'utf-8').to_csv, filename: 'articles.csv', type: 'text/csv'
return
end
2012-10-19 01:12:47 +02:00
@articles = @articles.where('articles.name LIKE ?', "%#{params[:query]}%") unless params[:query].nil?
2012-10-19 01:12:47 +02:00
@articles = @articles.page(params[:page]).per(@per_page)
respond_to do |format|
format.html
format.js { render layout: false }
end
2009-01-06 11:49:19 +01:00
end
def new
@article = @supplier.articles.build(tax: FoodsoftConfig[:tax_default])
render layout: false
2009-01-06 11:49:19 +01:00
end
2019-10-14 09:25:34 +02:00
def copy
@article = @supplier.articles.find(params[:article_id]).dup
render layout: false
end
def edit
@article = Article.find(params[:id])
render action: 'new', layout: false
2019-10-14 09:25:34 +02:00
end
def create
2009-01-06 11:49:19 +01:00
@article = Article.new(params[:article])
if @article.valid? && @article.save
render layout: false
2009-01-06 11:49:19 +01:00
else
render action: 'new', layout: false
end
2009-01-06 11:49:19 +01:00
end
2009-01-06 11:49:19 +01:00
# Updates one Article and highlights the line if succeded
def update
@article = Article.find(params[:id])
if @article.update(params[:article])
render layout: false
2009-01-06 11:49:19 +01:00
else
render action: 'new', layout: false
2009-01-06 11:49:19 +01:00
end
end
# Deletes article from database. send error msg, if article is used in a current order
def destroy
2009-01-06 11:49:19 +01:00
@article = Article.find(params[:id])
@article.mark_as_deleted unless @order = @article.in_open_order # If article is in an active Order, the Order will be returned
render layout: false
end
2009-01-06 11:49:19 +01:00
# Renders a form for editing all articles from a supplier
def edit_all
@articles = @supplier.articles.undeleted
2009-01-06 11:49:19 +01:00
end
2009-01-06 11:49:19 +01:00
# Updates all article of specific supplier
def update_all
invalid_articles = false
Article.transaction do
if params[:articles].present?
# Update other article attributes...
@articles = Article.find(params[:articles].keys)
@articles.each do |article|
unless article.update(params[:articles][article.id.to_s])
invalid_articles ||= true # Remember that there are validation errors
2009-01-06 11:49:19 +01:00
end
end
raise ActiveRecord::Rollback if invalid_articles # Rollback all changes
end
end
if invalid_articles
2009-01-06 11:49:19 +01:00
# An error has occurred, transaction has been rolled back.
flash.now.alert = I18n.t('articles.controller.error_invalid')
render :edit_all
else
# Successfully done.
redirect_to supplier_articles_path(@supplier), notice: I18n.t('articles.controller.update_all.notice')
2009-01-06 11:49:19 +01:00
end
end
2009-01-06 11:49:19 +01:00
# makes different actions on selected articles
def update_selected
raise I18n.t('articles.controller.error_nosel') if params[:selected_articles].nil?
articles = Article.find(params[:selected_articles])
Article.transaction do
case params[:selected_action]
when 'destroy'
articles.each(&:mark_as_deleted)
flash[:notice] = I18n.t('articles.controller.update_sel.notice_destroy')
when 'setNotAvailable'
articles.each { |a| a.update_attribute(:availability, false) }
flash[:notice] = I18n.t('articles.controller.update_sel.notice_unavail')
when 'setAvailable'
articles.each { |a| a.update_attribute(:availability, true) }
flash[:notice] = I18n.t('articles.controller.update_sel.notice_avail')
else
flash[:alert] = I18n.t('articles.controller.update_sel.notice_noaction')
end
2009-01-06 11:49:19 +01:00
end
# action succeded
redirect_to supplier_articles_url(@supplier, per_page: params[:per_page])
rescue StandardError => e
redirect_to supplier_articles_url(@supplier, per_page: params[:per_page]),
alert: I18n.t('errors.general_msg', msg: e)
2009-01-06 11:49:19 +01:00
end
2009-01-06 11:49:19 +01:00
# lets start with parsing articles from uploaded file, yeah
# Renders the upload form
def upload; end
2012-10-28 18:03:50 +01:00
# Update articles from a spreadsheet
def parse_upload
2015-04-17 18:44:38 +02:00
uploaded_file = params[:articles]['file'] or raise I18n.t('articles.controller.parse_upload.no_file')
options = { filename: uploaded_file.original_filename }
options[:outlist_absent] = (params[:articles]['outlist_absent'] == '1')
options[:convert_units] = (params[:articles]['convert_units'] == '1')
@updated_article_pairs, @outlisted_articles, @new_articles = @supplier.sync_from_file uploaded_file.tempfile,
options
2015-03-27 19:03:21 +01:00
if @updated_article_pairs.empty? && @outlisted_articles.empty? && @new_articles.empty?
redirect_to supplier_articles_path(@supplier),
notice: I18n.t('articles.controller.parse_upload.notice')
2014-02-24 14:07:03 +01:00
end
@ignored_article_count = 0
rescue StandardError => e
redirect_to upload_supplier_articles_path(@supplier), alert: I18n.t('errors.general_msg', msg: e.message)
2009-01-06 11:49:19 +01:00
end
2009-01-06 11:49:19 +01:00
# sync all articles with the external database
# renders a form with articles, which should be updated
def sync
2009-01-06 11:49:19 +01:00
# check if there is an shared_supplier
unless @supplier.shared_supplier
redirect_to supplier_articles_url(@supplier),
alert: I18n.t('articles.controller.sync.shared_alert', supplier: @supplier.name)
2009-01-06 11:49:19 +01:00
end
# sync articles against external database
@updated_article_pairs, @outlisted_articles, @new_articles = @supplier.sync_all
return unless @updated_article_pairs.empty? && @outlisted_articles.empty? && @new_articles.empty?
redirect_to supplier_articles_path(@supplier), notice: I18n.t('articles.controller.sync.notice')
2009-01-06 11:49:19 +01:00
end
# Updates, deletes articles when upload or sync form is submitted
def update_synchronized
@outlisted_articles = Article.find(params[:outlisted_articles].try(:keys) || [])
@updated_articles = Article.find(params[:articles].try(:keys) || [])
@updated_articles.map { |a| a.assign_attributes(params[:articles][a.id.to_s]) }
@new_articles = (params[:new_articles] || []).map { |a| @supplier.articles.build(a) }
2015-04-03 15:53:08 +02:00
has_error = false
Article.transaction do
# delete articles
2015-04-17 18:44:38 +02:00
begin
@outlisted_articles.each(&:mark_as_deleted)
rescue StandardError
2015-04-17 18:44:38 +02:00
# raises an exception when used in current order
has_error = true
end
2015-04-03 15:53:08 +02:00
# Update articles
@updated_articles.each { |a| a.save or has_error = true }
2015-04-03 15:53:08 +02:00
# Add new articles
@new_articles.each { |a| a.save or has_error = true }
2015-04-03 15:53:08 +02:00
raise ActiveRecord::Rollback if has_error
end
if has_error
2015-04-03 15:53:08 +02:00
@updated_article_pairs = @updated_articles.map do |article|
orig_article = Article.find(article.id)
[article, orig_article.unequal_attributes(article)]
end
flash.now.alert = I18n.t('articles.controller.error_invalid')
render params[:from_action] == 'sync' ? :sync : :parse_upload
else
redirect_to supplier_articles_path(@supplier), notice: I18n.t('articles.controller.update_sync.notice')
end
end
# renders a view to import articles in local database
#
def shared
# build array of keywords, required for ransack _all suffix
q = params.fetch(:q, {})
q[:name_cont_all] = params.fetch(:name_cont_all_joined, '').split(' ')
search = @supplier.shared_supplier.shared_articles.ransack(q)
@articles = search.result.page(params[:page]).per(10)
render layout: false
end
# fills a form whith values of the selected shared_article
# when the direct parameter is set and the article is valid, it is imported directly
def import
@article = SharedArticle.find(params[:shared_article_id]).build_new_article(@supplier)
@article.article_category_id = params[:article_category_id] if params[:article_category_id].present?
if params[:direct] && params[:article_category_id].present? && @article.valid? && @article.save
render action: 'create', layout: false
else
render action: 'new', layout: false
end
end
2015-04-03 15:53:08 +02:00
private
# @return [Number] Number of articles not taken into account when syncing (having no number)
def ignored_article_count
if action_name == 'sync' || params[:from_action] == 'sync'
2016-04-16 21:15:53 +02:00
@ignored_article_count ||= @supplier.articles.undeleted.where(order_number: [nil, '']).count
2015-04-03 15:53:08 +02:00
else
0
end
end
2015-06-05 15:34:22 +02:00
helper_method :ignored_article_count
end