select * from cotisations_commande where id = "22540" 
select * from cms_frontusers where identifiant = "c.hubler13" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22540" 
 select * from cotisations where identifiant = "c.hubler13" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "c.hubler13" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181725
payment_means : MASTERCARD
transmission_date : 20170411161725
payment_time : 182003
payment_date : 20170411
response_code : 00
payment_certificate : 6ae72647b1ea
authorisation_id : 636442
currency_code : 978
card_number : 5132.94
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.hubler13
order_id : 22540
customer_email : c.hubler13@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183639
payment_means : MASTERCARD
transmission_date : 20170411163639
payment_time : 183854
payment_date : 20170411
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5137.39
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 59
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.camus25
order_id : 22541
customer_email : f.camus25@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201711
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22541" 
select * from cms_frontusers where identifiant = "f.camus25" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22541" 
 select * from cotisations where identifiant = "t.colineaux14" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183912
payment_means : VISA
transmission_date : 20170411163912
payment_time : 184308
payment_date : 20170411
response_code : 00
payment_certificate : cfe41e080e33
authorisation_id : 568373
currency_code : 978
card_number : 4059.75
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.camus25
order_id : 22541
customer_email : f.camus25@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201707
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22542" 
select * from cms_frontusers where identifiant = "g.menuet18" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22542" 
 select * from cotisations where identifiant = "p.placais20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 184933
payment_means : VISA
transmission_date : 20170411164933
payment_time : 185322
payment_date : 20170411
response_code : 00
payment_certificate : fab7dc11b10e
authorisation_id : 734129
currency_code : 978
card_number : 4979.81
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : g.menuet18
order_id : 22542
customer_email : g.menuet18@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22543" 
select * from cms_frontusers where identifiant = "g.menuet18" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22543" 
 select * from cotisations where identifiant = "p.placais20" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 185443
payment_means : VISA
transmission_date : 20170411165443
payment_time : 185932
payment_date : 20170411
response_code : 00
payment_certificate : c25e48f71a9c
authorisation_id : 420600
currency_code : 978
card_number : 4979.81
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : g.menuet18
order_id : 22543
customer_email : g.menuet18@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22544" 
select * from cms_frontusers where identifiant = "w.bourges11" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22544" 
 select * from cotisations where identifiant = "g.portanier27" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "g.portanier27" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 194221
payment_means : MASTERCARD
transmission_date : 20170411174221
payment_time : 194521
payment_date : 20170411
response_code : 00
payment_certificate : cbbe2ec381f9
authorisation_id : 627849
currency_code : 978
card_number : 5131.29
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : w.bourges11
order_id : 22544
customer_email : w.bourges11@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201904
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 202324
payment_means : VISA
transmission_date : 20170411182324
payment_time : 202638
payment_date : 20170411
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4533.76
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : b.beaubreuil05
order_id : 22545
customer_email : b.beaubreuil05@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_FAILURE
statement_reference : 
card_validity : 202003
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22546" 
select * from cms_frontusers where identifiant = "m.vanderhaegen05" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22546" 
 select * from cotisations where identifiant = "m.vanderhaegen05" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "m.vanderhaegen05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 202746
payment_means : MASTERCARD
transmission_date : 20170411182746
payment_time : 202945
payment_date : 20170411
response_code : 00
payment_certificate : f8f80e306c2b
authorisation_id : 645915
currency_code : 978
card_number : 5136.11
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : m.vanderhaegen05
order_id : 22546
customer_email : m.vanderhaegen05@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22547" 
select * from cms_frontusers where identifiant = "k.cadu18" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "22547" 
 select * from cotisations where identifiant = "k.cadu18" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 214548
payment_means : MASTERCARD
transmission_date : 20170411194548
payment_time : 214814
payment_date : 20170411
response_code : 00
payment_certificate : ce5dcd602fde
authorisation_id : 427172
currency_code : 978
card_number : 5133.58
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : k.cadu18
order_id : 22547
customer_email : k.cadu18@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------