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
]

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.supported_line?(line) ⇒ Boolean

Returns:

  • (Boolean) 


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

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 



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

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

Instance Method Details

#client_id ⇒ Object 



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

def client_id
  reference[0..7]
end

#create_extra_earning_booking(comments = nil) ⇒ Object 



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

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 



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

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

#customer_id ⇒ Object 



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

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

#invoice_id ⇒ Object 



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

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

#parse(line) ⇒ Object 



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

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 



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

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

#update_remarks ⇒ Object 



112
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
 
# File 'app/models/esr_record.rb', line 112

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 



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

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