select * from cotisations_commande where id = "23579" 
select * from cms_frontusers where identifiant = "e.rudolf19" 
 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 = "23579" 
 select * from cotisations where identifiant = "a.bourgbroc11" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 101014
payment_means : VISA
transmission_date : 20170510081014
payment_time : 101125
payment_date : 20170510
response_code : 00
payment_certificate : 00c54c525fc5
authorisation_id : 649571
currency_code : 978
card_number : 4976.12
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 : e.rudolf19
order_id : 23579
customer_email : e.rudolf19@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 : 201905
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "23578" 
select * from cms_frontusers where identifiant = "g.dezest23" 
 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 = "23578" 
 select * from cotisations where identifiant = "r.housset06" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "r.housset06" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 100920
payment_means : VISA
transmission_date : 20170510080920
payment_time : 101205
payment_date : 20170510
response_code : 00
payment_certificate : 6cca907ca32f
authorisation_id : 499445
currency_code : 978
card_number : 4975.00
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.dezest23
order_id : 23578
customer_email : g.dezest23@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 : 202002
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "23580" 
select * from cms_frontusers where identifiant = "b.visse10" 
 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 = "23580" 
 select * from cotisations where identifiant = "e.hebert05" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 104927
payment_means : MASTERCARD
transmission_date : 20170510084927
payment_time : 105107
payment_date : 20170510
response_code : 00
payment_certificate : 851a616124dc
authorisation_id : 101345
currency_code : 978
card_number : 5131.34
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 : b.visse10
order_id : 23580
customer_email : b.visse10@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 : 201706
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "23582" 
select * from cms_frontusers where identifiant = "a.laot06" 
 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 = "23582" 
 select * from cotisations where identifiant = "w.vanwaesberghe10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 110650
payment_means : VISA
transmission_date : 20170510090650
payment_time : 110855
payment_date : 20170510
response_code : 00
payment_certificate : 2537889d190b
authorisation_id : 233563
currency_code : 978
card_number : 4977.38
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 : a.laot06
order_id : 23582
customer_email : a.laot06@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "23583" 
select * from cms_frontusers where identifiant = "a.laot06" 
 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 = "23583" 
 select * from cotisations where identifiant = "w.vanwaesberghe10" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 110935
payment_means : VISA
transmission_date : 20170510090935
payment_time : 111110
payment_date : 20170510
response_code : 00
payment_certificate : 88a138b117c3
authorisation_id : 340353
currency_code : 978
card_number : 4977.38
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 : a.laot06
order_id : 23583
customer_email : a.laot06@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "23584" 
select * from cms_frontusers where identifiant = "l.goehry08" 
 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 = "23584" 
 select * from cotisations where identifiant = "l.goehry08" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 125751
payment_means : MASTERCARD
transmission_date : 20170510105751
payment_time : 125901
payment_date : 20170510
response_code : 00
payment_certificate : b22b908d3521
authorisation_id : 627972
currency_code : 978
card_number : 5131.87
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 : l.goehry08
order_id : 23584
customer_email : l.goehry08@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "23585" 
select * from cms_frontusers where identifiant = "a.emonet28" 
 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 = "23585" 
 select * from cotisations where identifiant = "a.emonet28" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 152822
payment_means : VISA
transmission_date : 20170510132822
payment_time : 152948
payment_date : 20170510
response_code : 00
payment_certificate : 72f92598bf33
authorisation_id : 354945
currency_code : 978
card_number : 4978.12
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 : a.emonet28
order_id : 23585
customer_email : a.emonet28@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 : 201706
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "23586" 
select * from cms_frontusers where identifiant = "x.leroux15" 
 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 = "23586" 
 select * from cotisations where identifiant = "x.leroux15" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201850
payment_means : MASTERCARD
transmission_date : 20170510181850
payment_time : 202221
payment_date : 20170510
response_code : 00
payment_certificate : 7e51556b40e3
authorisation_id : 234114
currency_code : 978
card_number : 5136.87
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 : x.leroux15
order_id : 23586
customer_email : x.leroux15@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 : 201804
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 : 204900
payment_means : VISA
transmission_date : 20170510184900
payment_time : 205035
payment_date : 20170510
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4978.21
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 05
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.parel07
order_id : 23587
customer_email : c.parel07@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_NOTENROLLED
statement_reference : 
card_validity : 201902
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "23587" 
select * from cms_frontusers where identifiant = "c.parel07" 
 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 = "23587" 
 select * from cotisations where identifiant = "c.parel07" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 205109
payment_means : VISA
transmission_date : 20170510185109
payment_time : 205506
payment_date : 20170510
response_code : 00
payment_certificate : 4df67cb0bf98
authorisation_id : 022811
currency_code : 978
card_number : 4978.21
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.parel07
order_id : 23587
customer_email : c.parel07@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 : 201902
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------