143 lines
4.7 KiB
Plaintext
143 lines
4.7 KiB
Plaintext
.qi_header
|
|
.right= link_to 'Ajouter un paiement', new_admin_p_payment_path(), :class => "btn btn-primary", :remote => true
|
|
%h1
|
|
Paiements
|
|
%span
|
|
Relances
|
|
|
|
-if params[:age]
|
|
.qi_row
|
|
.qi_pannel.qi_plain.padding
|
|
:scss
|
|
.with_border{
|
|
tr,thead,tbody,td,th{
|
|
border:1px solid black !important;
|
|
|
|
}
|
|
th{
|
|
vertical-align:middle;
|
|
text-align:center;
|
|
}
|
|
}
|
|
-p_customers = PCustomer.where("cache_encours > 0.0").joins(:particular).order("particulars.organisation ASC, particulars.name ASC, particulars.firstname ASC").uniq.limit(500)
|
|
%p
|
|
=p_customers.count
|
|
clients
|
|
|
|
%table.table.with_border
|
|
%thead
|
|
%tr
|
|
%th{:rowspan => 1, :colspan => 2} Tiers
|
|
%th{:rowspan => 2} Solde du compte
|
|
%th{:rowspan => 1, :colspan => 4, :style => "border-right:3px black solid !important;"} Echus
|
|
%th{:rowspan => 1, :colspan => 2} Non echus
|
|
%th{:style => "border:0 !important;"}
|
|
%tr
|
|
|
|
%th Client
|
|
%th Cpt.client
|
|
-headers = ["de plus de 90 j","de 61 à 90 j","de 31 à 60 j", "de 0 à 30 j", "de 1 à 30 j","de plus de 30 j"]
|
|
-headers.each do |h|
|
|
%th{:style => ("border-right:3px black solid !important;" if h == "de 0 à 30 j")}= h
|
|
|
|
%th{:style => "border:0 !important;"}
|
|
|
|
-problemes = 0
|
|
-p_customers.all.each do |p_customer|
|
|
%tr
|
|
%td=link_to p_customer.show_name, [:admin, p_customer]
|
|
%td=link_to p_customer.code, [:admin, p_customer]
|
|
%td.numeraire
|
|
-encours = p_customer.cache_encours
|
|
=link_to number_to_currency(encours), admin_p_customer_path(:anchor => "tabs", :id => p_customer.id, :tab => "etat")
|
|
|
|
-tot = 0.0
|
|
-i = 0
|
|
-[[nil,91], [90, 61], [60,31], [30,0], [-1,-30], [-30, nil]].each do |val|
|
|
|
|
%td.numeraire{:style => ("border-right:3px black solid !important;" if i == 3)}
|
|
-docs = p_customer.p_documents.where(:p_document_type_id => [4,7], :paid => false, :i_archive => false)
|
|
-docs = docs.where("echeance_date >= ?", (Time.now - val[0].days).end_of_day) if val[0]
|
|
-docs = docs.where("echeance_date <= ?", (Time.now - val[1].days).end_of_day) if val[1]
|
|
|
|
|
|
-t = docs.sum(:cache_to_paid)
|
|
-tot += t
|
|
-if t != 00
|
|
-if !val[0] or val[0] > 0
|
|
- h = "échus "
|
|
-else
|
|
- h = "non échus "
|
|
|
|
-h += headers[i]
|
|
=link_to number_to_currency(t), admin_p_customer_path(:doc_label => h, :anchor => "tabs", :id => p_customer.id, :tab => "bills", :p_document_ids => docs.ids)
|
|
|
|
-i += 1
|
|
%td{:style => "border:0 !important;"}
|
|
-if encours.to_f != tot.to_f
|
|
%span{:style => "color:red;"}
|
|
-problemes += 1
|
|
=ic :warning
|
|
|
|
%p{:style => "color:red;"}
|
|
=problemes
|
|
clients avec un encours différent du solde des factures à payer
|
|
|
|
-else
|
|
.qi_row
|
|
.qi_pannel.qi_plain.padding
|
|
.right=link_to "Balance agée", "?age=true"
|
|
|
|
=form_tag "", :method => "get", :onsubmit => "" do
|
|
|
|
|
|
|
|
%table
|
|
%tr
|
|
%td Jours de retard :
|
|
%td
|
|
=select_tag :day, options_for_select(["0","30","60"], params[:day]),:class => "form-control", include_blank: true
|
|
|
|
%tr
|
|
%td Inclure les importés ?
|
|
%td
|
|
=select_tag :importeds, options_for_select([["Oui", "1"], ["Non", "0"]], params[:importeds]),:class => "form-control", include_blank: true
|
|
|
|
|
|
=submit_tag "Recherche", :class => "btn btn-default", :style => "margin-bottom: 10px;"
|
|
|
|
|
|
%p
|
|
="(#{@p_documents.total_count}) résultat(s) (#{@p_document_bruts.where(:imported => false).count})"
|
|
|
|
%table.table
|
|
%tr
|
|
|
|
%th Date
|
|
%th N° offre
|
|
%th Client
|
|
|
|
%th Type
|
|
%th Numéro
|
|
%th Total HT
|
|
%th Total TTC
|
|
-if params[:p_document_type_id].to_i == 4
|
|
%th
|
|
Th. Payée
|
|
%th
|
|
Payée
|
|
%th
|
|
Echeance
|
|
%th Jours de retard
|
|
%th Etat
|
|
|
|
|
|
|
|
|
|
%tbody#p_customer_sheets_rows
|
|
=render @p_documents
|
|
|
|
|
|
.qi_pagination
|
|
= paginate @p_documents
|
|
|