class ManifestationCheckoutStatsController < ApplicationController load_and_authorize_resource after_filter :convert_charset, only: :show # GET /manifestation_checkout_stats # GET /manifestation_checkout_stats.json def index @manifestation_checkout_stats = ManifestationCheckoutStat.page(params[:page]) respond_to do |format| format.html # index.html.erb format.json { render json: @manifestation_checkout_stats } end end # GET /manifestation_checkout_stats/1 # GET /manifestation_checkout_stats/1.json def show if params[:format] == 'txt' per_page = 65534 else per_page = CheckoutStatHasManifestation.default_per_page end @carrier_type_results = Checkout.where( Checkout.arel_table[:created_at].gteq @manifestation_checkout_stat.start_date ).where( Checkout.arel_table[:created_at].lt @manifestation_checkout_stat.end_date ).joins(item: :manifestation).group( 'checkouts.shelf_id', :carrier_type_id ).merge( Manifestation.where(carrier_type_id: CarrierType.pluck(:id)) ).count(:id) @checkout_type_results = Checkout.where( Checkout.arel_table[:created_at].gteq @manifestation_checkout_stat.start_date ).where( Checkout.arel_table[:created_at].lt @manifestation_checkout_stat.end_date ).joins(item: :manifestation).group( 'checkouts.shelf_id', :checkout_type_id ).count(:id) @stats = Checkout.where( Checkout.arel_table[:created_at].gteq @manifestation_checkout_stat.start_date ).where( Checkout.arel_table[:created_at].lt @manifestation_checkout_stat.end_date ).joins(item: :manifestation).group(:manifestation_id).merge( Manifestation.where(carrier_type_id: CarrierType.pluck(:id)) ).order('count_id DESC').page(params[:page]).per(per_page) respond_to do |format| format.html # show.html.erb format.json { render json: @manifestation_checkout_stat } format.txt format.js end end # GET /manifestation_checkout_stats/new # GET /manifestation_checkout_stats/new.json def new @manifestation_checkout_stat = ManifestationCheckoutStat.new respond_to do |format| format.html # new.html.erb format.json { render json: @manifestation_checkout_stat } end end # GET /manifestation_checkout_stats/1/edit def edit end # POST /manifestation_checkout_stats # POST /manifestation_checkout_stats.json def create @manifestation_checkout_stat = ManifestationCheckoutStat.new(params[:manifestation_checkout_stat]) @manifestation_checkout_stat.user = current_user respond_to do |format| if @manifestation_checkout_stat.save @manifestation_checkout_stat.transition_to(:started) @manifestation_checkout_stat.transition_to!(:completed) #Resque.enqueue(ManifestationCheckoutStatQueue, @manifestation_checkout_stat.id) format.html { redirect_to @manifestation_checkout_stat, notice: t('controller.successfully_created', model: t('activerecord.models.manifestation_checkout_stat')) } format.json { render json: @manifestation_checkout_stat, status: :created, location: @manifestation_checkout_stat } else format.html { render action: "new" } format.json { render json: @manifestation_checkout_stat.errors, status: :unprocessable_entity } end end end # PUT /manifestation_checkout_stats/1 # PUT /manifestation_checkout_stats/1.json def update respond_to do |format| if @manifestation_checkout_stat.update_attributes(params[:manifestation_checkout_stat]) if @manifestation_checkout_stat.mode == 'import' Resque.enqueue(ManifestationCheckoutStatQueue, @manifestation_checkout_stat.id) end format.html { redirect_to @manifestation_checkout_stat, notice: t('controller.successfully_updated', model: t('activerecord.models.manifestation_checkout_stat')) } format.json { head :no_content } else format.html { render action: "edit" } format.json { render json: @manifestation_checkout_stat.errors, status: :unprocessable_entity } end end end # DELETE /manifestation_checkout_stats/1 # DELETE /manifestation_checkout_stats/1.json def destroy @manifestation_checkout_stat.destroy respond_to do |format| format.html { redirect_to manifestation_checkout_stats_url } format.json { head :no_content } end end end