Class: EsrRecord

Inherits:
ActiveRecord::Base
  • Object
show all
Includes:
AASM
Defined in:
app/models/esr_record.rb

Constant Summary collapse

SUPPORTED_RECORD_TYPES = 
[
  :lsv_credit,
  :esr_e_banking_credit
]

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.supported_line?(line) ⇒ Boolean

Returns:

  • (Boolean) 


48
49
50
51
52
 
# File 'app/models/esr_record.rb', line 48

def self.supported_line?(line)
  record_type_code = line[0..2]
  record_type = EsrRecordTypes.lookup_code record_type_code
  SUPPORTED_RECORD_TYPES.include?(record_type)
end

.update_unsolved_states ⇒ Object 



171
172
173
174
175
176
 
# File 'app/models/esr_record.rb', line 171

def self.update_unsolved_states
  self.unsolved.find_each do |e|
    e.update_state
    e.save
  end
end

Instance Method Details

#client_id ⇒ Object 



84
85
86
 
# File 'app/models/esr_record.rb', line 84

def client_id
  reference[0..7]
end

#create_extra_earning_booking(comments = nil) ⇒ Object 



246
247
248
249
250
251
252
253
254
255
256
257
 
# File 'app/models/esr_record.rb', line 246

def create_extra_earning_booking(comments = nil)
  if invoice
    invoice.book_extra_earning("Korrektur nach VESR Zahlung").save
  else
    Booking.create(:title => "Ausserordentlicher Ertrag",
                 :comments => comments || "Zahlung kann keiner Rechnung zugewiesen werden",
                 :amount => self.amount,
                 :debit_account  => ,
                 :credit_account => Account.find_by_tag('vesr:extra-earnings'),
                 :value_date => Date.today)
  end
end

#create_write_off_booking ⇒ Object 



242
243
244
 
# File 'app/models/esr_record.rb', line 242

def create_write_off_booking
  invoice.write_off("Korrektur nach VESR Zahlung").save
end

#customer_id ⇒ Object 



92
93
94
 
# File 'app/models/esr_record.rb', line 92

def customer_id
  reference[8..18].to_i
end

#invoice_id ⇒ Object 



88
89
90
 
# File 'app/models/esr_record.rb', line 88

def invoice_id
  reference[19..-1].to_i
end

#parse(line) ⇒ Object 



96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
 
# File 'app/models/esr_record.rb', line 96

def parse(line)
#    self.recipe_type       = line[0, 1]
  self.bank_pc_id        = line[3..11]
  self.reference         = line[12..38]
  self.amount            = BigDecimal.new(line[39..48]) / 100
  self.payment_reference = line[49..58]
  self.payment_date      = line[59..64]
  self.transaction_date  = line[65..70]
  self.value_date        = line[71..76]
  self.microfilm_nr      = line[77..85]
  self.reject_code       = line[86, 1]
  self.reserved          = line[87,95]
  self.payment_tax       = line[96..99]

  self
end

#to_s ⇒ Object 



80
81
82
 
# File 'app/models/esr_record.rb', line 80

def to_s
  "CHF #{amount} for client #{client_id} on #{value_date}, reference #{reference}"
end

#update_remarks ⇒ Object 



113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
 
# File 'app/models/esr_record.rb', line 113

def update_remarks
  # Duplicate
  if self.state == 'duplicate'
    return
  end

  # Invoice not found
  if self.state == 'missing'
    self.remarks += ", Rechnung ##{invoice_id} nicht gefunden"
    return
  end

  # Remark if invoice should not get payment according to state
  if !(invoice.active)
    self.remarks += ", wurde bereits #{invoice.state_adverb}"
    return
  end

  # Perfect payment
  return if invoice.balance == 0

  # Paid more than once
  if (self.state == 'overpaid') && (invoice.amount == self.amount)
    self.remarks += ", mehrfach bezahlt"
    return
  end

  # Not fully paid
  if (self.state == 'underpaid')
    self.remarks += ", Teilzahlung"
    return
  end

  # Simply mark bad amount otherwise
  self.remarks += ", falscher Betrag"
end

#update_state ⇒ Object 



150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
 
# File 'app/models/esr_record.rb', line 150

def update_state
  if duplicate_of.present?
    self.state = 'duplicate'
    return
  end

  if self.invoice.nil?
    self.state = 'missing'
    return
  end

  balance = self.invoice.balance
  if balance == 0
    self.state = 'paid'
  elsif balance > 0
    self.state = 'underpaid'
  elsif balance < 0
    self.state = 'overpaid'
  end
end