# Copyright (C) 2012-2016 Zammad Foundation, http://zammad-foundation.org/ class Stats::TicketReopen def self.generate(user) # get my closed tickets total = Ticket.select('id').where( 'owner_id = ? AND close_at > ?', user.id, Time.zone.now - 7.days ).count # get count of reopens count = StatsStore.count_by_search( object: 'User', o_id: user.id, key: 'ticket:reopen', start: Time.zone.now - 7.days, end: Time.zone.now, ) if count > total total = count end reopen_in_precent = 0 if total.nonzero? reopen_in_precent = ( count.to_f / (total.to_f / 100) ).round(1) end { used_for_average: reopen_in_precent, percent: reopen_in_precent, average_per_agent: '-', state: 'good', count: count, total: total, } end def self.average_state(result, _user_id) return result if !result.key?(:used_for_average) if result[:total] < 1 || result[:average_per_agent] == 0.0 result[:state] = 'supergood' return result end #in_percent = ( result[:used_for_average].to_f / (result[:average_per_agent].to_f / 100) ).round(1) #result[:average_per_agent_in_percent] = in_percent in_percent = ( result[:count].to_f / (result[:total].to_f / 100) ).round(1) result[:state] = if in_percent >= 90 'superbad' elsif in_percent >= 65 'bad' elsif in_percent >= 40 'ok' elsif in_percent >= 20 'good' else 'supergood' end result end def self.log(object, o_id, changes, updated_by_id) return if object != 'Ticket' ticket = Ticket.lookup(id: o_id) return if !ticket # check if close_at is already set / if not, ticket is not reopened return if !ticket.close_at # only if state id has changed return if !changes['state_id'] # only if ticket is not created in closed state return if !changes['state_id'][0] # only if current owner is not 1 return if ticket.owner_id == 1 state_before = Ticket::State.lookup(id: changes['state_id'][0]) state_type_before = Ticket::StateType.lookup(id: state_before.state_type_id) return if state_type_before.name != 'closed' state_now = Ticket::State.lookup(id: changes['state_id'][1]) state_type_now = Ticket::StateType.lookup(id: state_now.state_type_id) return if state_type_now.name == 'closed' StatsStore.add( object: 'User', o_id: ticket.owner_id, key: 'ticket:reopen', data: { ticket_id: ticket.id }, created_at: Time.zone.now, created_by_id: updated_by_id, updated_by_id: updated_by_id, ) end end